Diagrams


Table

Whse. Item Entry Relation

Fields

# Name Type
1 Item Entry No. Integer
10 Source Type Integer
11 Source Subtype Option
12 Source ID Code20
13 Source Batch Name Code10
14 Source Prod. Order Line Integer
15 Source Ref. No. Integer
20 Serial No. Code20
21 Lot No. Code20
30 Order No. Code20
31 Order Line No. Integer

Keys

# Fields
0 Item Entry No. Clustered: Yes
1 Source ID,Source Type,Source Subtype,Source Ref. No.,Source Prod. Order Line,Source Batch Name
2 Order No.,Order Line No.

Table Relations To Other Tables

Field Related Table Related Field
Item Entry No. Item Ledger Entry Entry No. 1..1

Table Relations From Other Tables

From Table From Field