Diagrams

Table

Lot Numbers by Bin Buffer

DynamicsDocs.comLot Numbers by Bin Buffer«Table 7350»Lot Numbers by Bin BufferItem No. [PK]Variant Code [PK]Location Code [PK]Zone Code [PK]Bin Code [PK]Lot No. [PK]Qty. [Base]

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

Fields

# Name Type
1 Item No. (Item No.) Code20
2 Variant Code (Variant Code) Code10
3 Location Code (Location Code) Code10
4 Zone Code (Zone Code) Code10
5 Bin Code (Bin Code) Code20
6 Lot No. (Lot No.) Code20
7 Qty. (Base) (Qty. (Base)) Decimal (0:5)

Keys

# Fields
0 Item No.,Variant Code,Location Code,Zone Code,Bin Code,Lot No. (Item No.,Variant Code,Location Code,Zone Code,Bin Code,Lot No.) Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field