Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Worksheet Template Name | Code10 |
|
|
| 2 | Journal Batch Name | Code10 |
|
|
| 3 | Line No. | Integer | ||
| 4 | Type | Option | [ ,G/L Account,Item] | |
| 5 | No. | Code20 |
|
|
| 6 | Description | Text50 | ||
| 7 | Description 2 | Text50 | ||
| 8 | Quantity | Decimal (0:5) | ||
| 9 | Vendor No. | Code20 |
|
|
| 10 | Direct Unit Cost | Decimal | AutoFormatType: 2 AutoFormatExpr: "Currency Code" |
|
| 12 | Due Date | Date | ||
| 13 | Requester ID | Code50 |
|
|
| 14 | Confirmed | Boolean | ||
| 15 | Shortcut Dimension 1 Code | Code20 | CaptionClass: '1,2,1'
|
|
| 16 | Shortcut Dimension 2 Code | Code20 | CaptionClass: '1,2,2'
|
|
| 17 | Location Code | Code10 |
|
|
| 18 | Recurring Method | Option | [,Fixed,Variable] | BlankZero: Yes |
| 19 | Expiration Date | Date | ||
| 20 | Recurring Frequency | DateFormula | ||
| 21 | Order Date | Date | ||
| 22 | Vendor Item No. | Text20 | ||
| 23 | Sales Order No. | Code20 |
|
Editable: No |
| 24 | Sales Order Line No. | Integer | Editable: No | |
| 25 | Sell-to Customer No. | Code20 |
|
Editable: No |
| 26 | Ship-to Code | Code10 |
|
Editable: No |
| 28 | Order Address Code | Code10 |
|
|
| 29 | Currency Code | Code10 |
|
|
| 30 | Currency Factor | Decimal (0:15) | ||
| 31 | Reserved Quantity | Decimal (0:5) |
|
Editable: No FlowField |
| 480 | Dimension Set ID | Integer |
|
Editable: No |
| 5401 | Prod. Order No. | Code20 |
|
Editable: No |
| 5402 | Variant Code | Code10 |
|
|
| 5403 | Bin Code | Code20 |
|
|
| 5404 | Qty. per Unit of Measure | Decimal (0:5) | InitValue: 1 | Editable: No |
| 5407 | Unit of Measure Code | Code10 |
|
|
| 5408 | Quantity (Base) | Decimal (0:5) | ||
| 5431 | Reserved Qty. (Base) | Decimal (0:5) |
|
Editable: No FlowField |
| 5520 | Demand Type | Integer |
|
Editable: No |
| 5521 | Demand Subtype | Option | [0,1,2,3,4,5,6,7,8,9] | Editable: No |
| 5522 | Demand Order No. | Code20 | Editable: No | |
| 5525 | Demand Line No. | Integer | Editable: No | |
| 5526 | Demand Ref. No. | Integer | Editable: No | |
| 5527 | Status | Option | [0,1,2,3,4,5,6,7,8,9,10] | Editable: No |
| 5530 | Demand Date | Date | Editable: No | |
| 5532 | Demand Quantity | Decimal (0:5) | Editable: No | |
| 5533 | Demand Quantity (Base) | Decimal (0:5) | Editable: No | |
| 5538 | Needed Quantity | Decimal (0:5) | BlankZero: Yes Editable: No |
|
| 5539 | Needed Quantity (Base) | Decimal (0:5) | BlankZero: Yes Editable: No |
|
| 5540 | Reserve | Boolean | ||
| 5541 | Qty. per UOM (Demand) | Decimal (0:5) | Editable: No | |
| 5542 | Unit Of Measure Code (Demand) | Code10 |
|
Editable: No |
| 5552 | Supply From | Code20 |
|
|
| 5553 | Original Item No. | Code20 |
|
Editable: No |
| 5554 | Original Variant Code | Code10 |
|
Editable: No |
| 5560 | Level | Integer | Editable: No | |
| 5563 | Demand Qty. Available | Decimal (0:5) | Editable: No | |
| 5590 | User ID | Code50 |
|
Editable: No |
| 5701 | Item Category Code | Code20 |
|
|
| 5702 | Nonstock | Boolean | ||
| 5703 | Purchasing Code | Code10 |
|
|
| 5705 | Product Group Code | Code10 |
|
|
| 5706 | Transfer-from Code | Code10 |
|
Editable: No |
| 5707 | Transfer Shipment Date | Date | AccessByPermission: TableData 5740=R | Editable: No |
| 7002 | Line Discount % | Decimal | MaxValue: 100 | |
| 7100 | Blanket Purch. Order Exists | Boolean |
|
Editable: No FlowField |
| 99000750 | Routing No. | Code20 |
|
|
| 99000751 | Operation No. | Code10 |
|
|
| 99000752 | Work Center No. | Code20 |
|
|
| 99000754 | Prod. Order Line No. | Integer |
|
Editable: No |
| 99000755 | MPS Order | Boolean | ||
| 99000756 | Planning Flexibility | Option | [Unlimited,None] | |
| 99000757 | Routing Reference No. | Integer | ||
| 99000882 | Gen. Prod. Posting Group | Code20 |
|
|
| 99000883 | Gen. Business Posting Group | Code20 |
|
|
| 99000884 | Low-Level Code | Integer | AccessByPermission: TableData 5405=R | Editable: No |
| 99000885 | Production BOM Version Code | Code20 |
|
|
| 99000886 | Routing Version Code | Code20 |
|
|
| 99000887 | Routing Type | Option | [Serial,Parallel] | |
| 99000888 | Original Quantity | Decimal (0:5) | BlankZero: Yes Editable: No |
|
| 99000889 | Finished Quantity | Decimal (0:5) | Editable: No | |
| 99000890 | Remaining Quantity | Decimal (0:5) | Editable: No | |
| 99000891 | Original Due Date | Date | Editable: No | |
| 99000892 | Scrap % | Decimal (0:5) | AccessByPermission: TableData 5405=R | |
| 99000894 | Starting Date | Date | ||
| 99000895 | Starting Time | Time | ||
| 99000896 | Ending Date | Date | ||
| 99000897 | Ending Time | Time | ||
| 99000898 | Production BOM No. | Code20 |
|
|
| 99000899 | Indirect Cost % | Decimal (0:5) | ||
| 99000900 | Overhead Rate | Decimal (0:5) | ||
| 99000901 | Unit Cost | Decimal | AutoFormatType: 2 | |
| 99000902 | Cost Amount | Decimal | AutoFormatType: 1 | Editable: No |
| 99000903 | Replenishment System | Option | [Purchase,Prod. Order,Transfer,Assembly, ] | |
| 99000904 | Ref. Order No. | Code20 |
|
Editable: No |
| 99000905 | Ref. Order Type | Option | [ ,Purchase,Prod. Order,Transfer,Assembly] | Editable: No |
| 99000906 | Ref. Order Status | Option | [,Planned,Firm Planned,Released] | BlankZero: Yes Editable: No |
| 99000907 | Ref. Line No. | Integer | BlankZero: Yes Editable: No |
|
| 99000908 | No. Series | Code20 |
|
Editable: No |
| 99000909 | Expected Operation Cost Amt. | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 99000910 | Expected Component Cost Amt. | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 99000911 | Finished Qty. (Base) | Decimal (0:5) | Editable: No | |
| 99000912 | Remaining Qty. (Base) | Decimal (0:5) | Editable: No | |
| 99000913 | Related to Planning Line | Integer | Editable: No | |
| 99000914 | Planning Level | Integer | Editable: No | |
| 99000915 | Planning Line Origin | Option | [ ,Action Message,Planning,Order Planning] | Editable: No |
| 99000916 | Action Message | Option | [ ,New,Change Qty.,Reschedule,Resched. & Chg. Qty.,Cancel] | |
| 99000917 | Accept Action Message | Boolean | ||
| 99000918 | Net Quantity (Base) | Decimal (0:5) | Editable: No | |
| 99000919 | Starting Date-Time | DateTime | ||
| 99000920 | Ending Date-Time | DateTime | ||
| 99000921 | Order Promising ID | Code20 | ||
| 99000922 | Order Promising Line No. | Integer | ||
| 99000923 | Order Promising Line ID | Integer |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Worksheet Template Name,Journal Batch Name,Line No. | Clustered: Yes | |
| 1 | Worksheet Template Name,Journal Batch Name,Vendor No.,Sell-to Customer No.,Ship-to Code,Order Address Code,Currency Code,Ref. Order Type,Ref. Order Status,Ref. Order No.,Location Code,Transfer-from Code | MaintainSQLIndex: No | |
| 2 | Type,No.,Variant Code,Location Code,Sales Order No.,Planning Line Origin,Due Date | SumIndexFields: Quantity (Base) | MaintainSIFTIndex: No |
| 3 | Type,No.,Variant Code,Location Code,Sales Order No.,Order Date | SumIndexFields: Quantity (Base) | MaintainSIFTIndex: No |
| 4 | Type,No.,Variant Code,Location Code,Starting Date | SumIndexFields: Quantity (Base) | MaintainSIFTIndex: No |
| 5 | Worksheet Template Name,Journal Batch Name,Type,No.,Due Date | MaintainSQLIndex: No | |
| 6 | Ref. Order Type,Ref. Order Status,Ref. Order No.,Ref. Line No. | ||
| 7 | Replenishment System,Type,No.,Variant Code,Transfer-from Code,Transfer Shipment Date | SumIndexFields: Quantity (Base) | MaintainSQLIndex: No |
| 8 | Order Promising ID,Order Promising Line ID,Order Promising Line No. | ||
| 9 | User ID,Demand Type,Worksheet Template Name,Journal Batch Name,Line No. | ||
| 10 | User ID,Demand Type,Demand Subtype,Demand Order No.,Demand Line No.,Demand Ref. No. | ||
| 11 | User ID,Worksheet Template Name,Journal Batch Name,Line No. | MaintainSQLIndex: No |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Demand Type | AllObjWithCaption | Object ID |
|
1..n |
| Bin Code | Bin | Code |
|
1..n |
| Currency Code | Currency | Code |
|
1..n |
| Sell-to Customer No. | Customer | No. |
|
1..n |
| Dimension Set ID | Dimension Set Entry |
|
1..n | |
| Shortcut Dimension 2 Code | Dimension Value | Code |
|
1..n |
| No. | G/L Account | No. |
|
1..n |
| Gen. Business Posting Group | Gen. Business Posting Group | Code |
|
1..n |
| Gen. Prod. Posting Group | Gen. Product Posting Group | Code |
|
1..n |
| Original Item No. | Item | No. |
|
1..n |
| Item Category Code | Item Category | Code |
|
1..n |
| Unit Of Measure Code (Demand) | Item Unit of Measure | Code |
|
1..n |
| Original Variant Code | Item Variant | Code |
|
1..n |
| Transfer-from Code | Location |
|
1..n | |
| No. Series | No. Series | Code |
|
1..n |
| Order Address Code | Order Address | Code |
|
1..n |
| Prod. Order Line No. | Prod. Order Line | Line No. |
|
1..n |
| Operation No. | Prod. Order Routing Line | Operation No. |
|
1..n |
| Production BOM No. | Production BOM Header | No. |
|
1..n |
| Production BOM Version Code | Production BOM Version | Version Code |
|
1..n |
| Purchasing Code | Purchasing | Code |
|
1..n |
| Worksheet Template Name | Req. Wksh. Template | Name |
|
1..n |
| Journal Batch Name | Requisition Wksh. Name | Name |
|
1..n |
| Routing No. | Routing Header | No. |
|
1..n |
| Routing Version Code | Routing Version | Version Code |
|
1..n |
| Sales Order No. | Sales Header | No. |
|
1..n |
| Ship-to Code | Ship-to Address | Code |
|
1..n |
| Unit of Measure Code | Unit of Measure | Code |
|
1..n |
| User ID | User | User Name |
|
1..n |
| Supply From | Vendor | No. |
|
1..n |
| Work Center No. | Work Center | No. |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Planning Component | Supplied-by Line No. |
|
1..n |
| Planning Routing Line | Worksheet Line No. |
|
1..n |
| Prod. Order Capacity Need | Worksheet Line No. |
|
1..n |
| Untracked Planning Element | Worksheet Line No. |
|
1..n |