Diagrams


Table

Order Tracking Entry

Fields

# Name Type
1 Entry No. Integer
2 Supplied by Text80
3 Demanded by Text80
8 Shipment Date Date
9 Expected Receipt Date Date
11 Item No. Code20
13 Quantity Decimal (0:5)
14 Level Integer
20 For Type Integer
21 For Subtype Integer
22 For ID Code20
23 For Batch Name Code10
24 For Prod. Order Line Integer
25 For Ref. No. Integer
26 From Type Integer
27 From Subtype Integer
28 From ID Code20
29 From Batch Name Code10
30 From Prod. Order Line Integer
31 From Ref. No. Integer
40 Starting Date Date
41 Ending Date Date
42 Name Text80
43 Warning Boolean

Keys

# Fields
0 Entry No. Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
Item No. Item No. 1..n

Table Relations From Other Tables

From Table From Field