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

Keys

# Fields
0 Code (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 (Item Tracking Code) 1..n