Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Document No. (Document No.) | Code20 | ||
| 2 | Line No. (Line No.) | Integer | ||
| 3 | Item No. (Item No.) | Code20 |
|
|
| 4 | Quantity (Quantity) | Decimal (0:5) | ||
| 5 | Unit of Measure (Unit of Measure) | Text10 | ||
| 6 | Qty. to Ship (Qty. to Ship) | Decimal (0:5) | ||
| 7 | Qty. to Receive (Qty. to Receive) | Decimal (0:5) | ||
| 8 | Quantity Shipped (Quantity Shipped) | Decimal (0:5) | Editable: No | |
| 9 | Quantity Received (Quantity Received) | Decimal (0:5) | Editable: No | |
| 10 | Status (Status) | Option | [Open,Released] | Editable: No |
| 11 | Shortcut Dimension 1 Code (Shortcut Dimension 1 Code) | Code20 | CaptionClass: '1,2,1'
|
|
| 12 | Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Code20 | CaptionClass: '1,2,2'
|
|
| 13 | Description (Description) | Text50 | ||
| 14 | Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Code10 |
|
|
| 15 | Inventory Posting Group (Inventory Posting Group) | Code10 |
|
|
| 16 | Quantity (Base) (Quantity (Base)) | Decimal (0:5) | ||
| 17 | Outstanding Qty. (Base) (Outstanding Qty. (Base)) | Decimal (0:5) | Editable: No | |
| 18 | Qty. to Ship (Base) (Qty. to Ship (Base)) | Decimal (0:5) | ||
| 19 | Qty. Shipped (Base) (Qty. Shipped (Base)) | Decimal (0:5) | Editable: No | |
| 20 | Qty. to Receive (Base) (Qty. to Receive (Base)) | Decimal (0:5) | ||
| 21 | Qty. Received (Base) (Qty. Received (Base)) | Decimal (0:5) | Editable: No | |
| 22 | Qty. per Unit of Measure (Qty. per Unit of Measure) | Decimal (0:5) | InitValue: 1 | Editable: No |
| 23 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
| 24 | Outstanding Quantity (Outstanding Quantity) | Decimal (0:5) | Editable: No | |
| 25 | Gross Weight (Gross Weight) | Decimal (0:5) | ||
| 26 | Net Weight (Net Weight) | Decimal (0:5) | ||
| 27 | Unit Volume (Unit Volume) | Decimal (0:5) | ||
| 30 | Variant Code (Variant Code) | Code10 |
|
|
| 31 | Units per Parcel (Units per Parcel) | Decimal (0:5) | ||
| 32 | Description 2 (Description 2) | Text50 | ||
| 33 | In-Transit Code (In-Transit Code) | Code10 |
|
Editable: No |
| 34 | Qty. in Transit (Qty. in Transit) | Decimal (0:5) | Editable: No | |
| 35 | Qty. in Transit (Base) (Qty. in Transit (Base)) | Decimal (0:5) | Editable: No | |
| 36 | Transfer-from Code (Transfer-from Code) | Code10 |
|
Editable: No |
| 37 | Transfer-to Code (Transfer-to Code) | Code10 |
|
Editable: No |
| 38 | Shipment Date (Shipment Date) | Date | ||
| 39 | Receipt Date (Receipt Date) | Date | ||
| 40 | Derived From Line No. (Derived From Line No.) | Integer |
|
|
| 41 | Shipping Agent Code (Shipping Agent Code) | Code10 | AccessByPermission: TableData 5790=R
|
|
| 42 | Shipping Agent Service Code (Shipping Agent Service Code) | Code10 |
|
|
| 43 | Appl.-to Item Entry (Appl.-to Item Entry) | Integer | AccessByPermission: TableData 27=R | |
| 50 | Reserved Quantity Inbnd. (Reserved Quantity Inbnd.) | Decimal (0:5) |
|
Editable: No FlowField |
| 51 | Reserved Quantity Outbnd. (Reserved Quantity Outbnd.) | Decimal (0:5) |
|
Editable: No FlowField |
| 52 | Reserved Qty. Inbnd. (Base) (Reserved Qty. Inbnd. (Base)) | Decimal (0:5) |
|
Editable: No FlowField |
| 53 | Reserved Qty. Outbnd. (Base) (Reserved Qty. Outbnd. (Base)) | Decimal (0:5) |
|
Editable: No FlowField |
| 54 | Shipping Time (Shipping Time) | DateFormula | AccessByPermission: TableData 5790=R | |
| 55 | Reserved Quantity Shipped (Reserved Quantity Shipped) | Decimal (0:5) |
|
Editable: No FlowField |
| 56 | Reserved Qty. Shipped (Base) (Reserved Qty. Shipped (Base)) | Decimal (0:5) |
|
Editable: No FlowField |
| 480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
| 5704 | Item Category Code (Item Category Code) | Code20 |
|
|
| 5707 | Product Group Code (Product Group Code) | Code10 |
|
|
| 5750 | Whse. Inbnd. Otsdg. Qty (Base) (Whse. Inbnd. Otsdg. Qty (Base)) | Decimal (0:5) |
|
BlankZero: Yes Editable: No FlowField |
| 5751 | Whse Outbnd. Otsdg. Qty (Base) (Whse Outbnd. Otsdg. Qty (Base)) | Decimal (0:5) |
|
BlankZero: Yes Editable: No FlowField |
| 5752 | Completely Shipped (Completely Shipped) | Boolean | Editable: No | |
| 5753 | Completely Received (Completely Received) | Boolean | Editable: No | |
| 5793 | Outbound Whse. Handling Time (Outbound Whse. Handling Time) | DateFormula | ||
| 5794 | Inbound Whse. Handling Time (Inbound Whse. Handling Time) | DateFormula | ||
| 7300 | Transfer-from Bin Code (Transfer-from Bin Code) | Code20 |
|
|
| 7301 | Transfer-To Bin Code (Transfer-To Bin Code) | Code20 |
|
|
| 99000755 | Planning Flexibility (Planning Flexibility) | Option | [Unlimited,None] |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Document No.,Line No. (Document No.,Line No.) | Clustered: Yes | |
| 1 | Transfer-to Code,Status,Derived From Line No.,Item No.,Variant Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Receipt Date,In-Transit Code (Transfer-to Code,Status,Derived From Line No.,Item No.,Variant Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Receipt Date,In-Transit Code) | SumIndexFields: Qty. in Transit (Base),Outstanding Qty. (Base) | MaintainSIFTIndex: No |
| 2 | Transfer-from Code,Status,Derived From Line No.,Item No.,Variant Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Shipment Date,In-Transit Code (Transfer-from Code,Status,Derived From Line No.,Item No.,Variant Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Shipment Date,In-Transit Code) | SumIndexFields: Outstanding Qty. (Base) | MaintainSIFTIndex: No |
| 3 | Item No.,Variant Code (Item No.,Variant Code) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Transfer-To Bin Code (Transfer-To Bin Code) | Bin | Code (Code) |
|
1..n |
| Transfer-from Bin Code (Transfer-from Bin Code) | Bin Content | Bin Code (Bin Code) |
|
1..n |
| Dimension Set ID (Dimension Set ID) | Dimension Set Entry | () |
|
1..n |
| Shortcut Dimension 2 Code (Shortcut Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
| Gen. Prod. Posting Group (Gen. Prod. Posting Group) | Gen. Product Posting Group | Code (Code) |
|
1..n |
| Inventory Posting Group (Inventory Posting Group) | Inventory Posting Group | Code (Code) |
|
1..n |
| Item No. (Item No.) | Item | () |
|
1..n |
| Item Category Code (Item Category Code) | Item Category | Code (Code) |
|
1..n |
| Unit of Measure Code (Unit of Measure Code) | Item Unit of Measure | Code (Code) |
|
1..n |
| Variant Code (Variant Code) | Item Variant | Code (Code) |
|
1..n |
| Transfer-to Code (Transfer-to Code) | Location | Code (Code) |
|
1..n |
| Shipping Agent Code (Shipping Agent Code) | Shipping Agent | Code (Code) |
|
1..n |
| Shipping Agent Service Code (Shipping Agent Service Code) | Shipping Agent Services | Code (Code) |
|
1..n |
| Derived From Line No. (Derived From Line No.) | Transfer Line | Line No. (Line No.) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Transfer Line | Derived From Line No. (Derived From Line No.) |
|
1..n |