Diagrams


Table

Entry Summary

Fields

# Name Type
1 Entry No. (Entry No.) Integer
2 Table ID (Table ID) Integer
3 Summary Type (Summary Type) Text80
4 Total Quantity (Total Quantity) Decimal (0:5)
5 Total Reserved Quantity (Total Reserved Quantity) Decimal (0:5)
6 Total Available Quantity (Total Available Quantity) Decimal (0:5)
7 Current Reserved Quantity (Current Reserved Quantity) Decimal (0:5)
8 Source Subtype (Source Subtype) Integer
15 Qty. Alloc. in Warehouse (Qty. Alloc. in Warehouse) Decimal (0:5)
16 Res. Qty. on Picks & Shipmts. (Res. Qty. on Picks & Shipmts.) Decimal (0:5)
6500 Serial No. (Serial No.) Code20 Editable: No
6501 Lot No. (Lot No.) Code20 Editable: No
6502 Warranty Date (Warranty Date) Date Editable: No
6503 Expiration Date (Expiration Date) Date Editable: No
6504 Total Requested Quantity (Total Requested Quantity) Decimal (0:5)
6505 Selected Quantity (Selected Quantity) Decimal (0:5) BlankZero: Yes
6506 Current Pending Quantity (Current Pending Quantity) Decimal (0:5)
6507 Current Requested Quantity (Current Requested Quantity) Decimal
6508 Bin Content (Bin Content) Decimal (0:5) Editable: No
6509 Bin Active (Bin Active) Boolean Editable: No
6510 Non-specific Reserved Qty. (Non-specific Reserved Qty.) Decimal Editable: No
6511 Double-entry Adjustment (Double-entry Adjustment) Decimal Editable: No

Keys

# Fields
0 Entry No. (Entry No.) Clustered: Yes
1 Lot No.,Serial No. (Lot No.,Serial No.)
2 Expiration Date (Expiration Date)

Table Relations To Other Tables

Field Related Table Related Field

Table Relations From Other Tables

From Table From Field