Diagrams


Table

Stockkeeping Unit Comment Line

Fields

# Name Type
1 Item No. Code20 NotBlank: Yes
2 Variant Code Code10
3 Location Code Code10
4 Line No. Integer BlankZero: No
5 Date Date
6 Code Code10
7 Comment Text80

Keys

# Fields
0 Item No.,Variant Code,Location Code,Line No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Item No. Item No. 1..n
Variant Code Item Variant Code 1..n
Location Code Location 1..n

Table Relations From Other Tables

From Table From Field