Diagrams


Table

Item Tracking Code

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 Code Code10 NotBlank: Yes
2 Description Text50
3 Warranty Date Formula DateFormula
5 Man. Warranty Date Entry Reqd. Boolean
6 Man. Expir. Date Entry Reqd. Boolean
8 Strict Expiration Posting Boolean
11 SN Specific Tracking Boolean
13 SN Info. Inbound Must Exist Boolean
14 SN Info. Outbound Must Exist Boolean
15 SN Warehouse Tracking Boolean
21 SN Purchase Inbound Tracking Boolean
22 SN Purchase Outbound Tracking Boolean
23 SN Sales Inbound Tracking Boolean
24 SN Sales Outbound Tracking Boolean
25 SN Pos. Adjmt. Inb. Tracking Boolean
26 SN Pos. Adjmt. Outb. Tracking Boolean
27 SN Neg. Adjmt. Inb. Tracking Boolean
28 SN Neg. Adjmt. Outb. Tracking Boolean
29 SN Transfer Tracking Boolean
30 SN Manuf. Inbound Tracking Boolean
31 SN Manuf. Outbound Tracking Boolean
32 SN Assembly Inbound Tracking Boolean
33 SN Assembly Outbound Tracking Boolean
41 Lot Specific Tracking Boolean
43 Lot Info. Inbound Must Exist Boolean
44 Lot Info. Outbound Must Exist Boolean
45 Lot Warehouse Tracking Boolean
51 Lot Purchase Inbound Tracking Boolean
52 Lot Purchase Outbound Tracking Boolean
53 Lot Sales Inbound Tracking Boolean
54 Lot Sales Outbound Tracking Boolean
55 Lot Pos. Adjmt. Inb. Tracking Boolean
56 Lot Pos. Adjmt. Outb. Tracking Boolean
57 Lot Neg. Adjmt. Inb. Tracking Boolean
58 Lot Neg. Adjmt. Outb. Tracking Boolean
59 Lot Transfer Tracking Boolean
60 Lot Manuf. Inbound Tracking Boolean
61 Lot Manuf. Outbound Tracking Boolean
62 Lot Assembly Inbound Tracking Boolean
63 Lot Assembly Outbound Tracking Boolean

Keys

# Fields
0 Code Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field
Item Item Tracking Code 1..n