Order Tracking Entry

Diagrams

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

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

#	Fields
0	Entry No. (Entry No.)		Clustered: Yes

Field	Related Table	Related Field
Item No. (Item No.)	Item	No. (No.)	TableRelation: Item	1..n

From Table	From Field