Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | Status | Option | [Simulated,Planned,Firm Planned,Released,Finished] | |
2 | Prod. Order No. | Code20 |
|
|
3 | Line No. | Integer | ||
11 | Item No. | Code20 |
|
|
12 | Variant Code | Code10 |
|
|
13 | Description | Text50 | ||
14 | Description 2 | Text50 | ||
20 | Location Code | Code10 |
|
|
21 | Shortcut Dimension 1 Code | Code20 | CaptionClass: '1,2,1'
|
|
22 | Shortcut Dimension 2 Code | Code20 | CaptionClass: '1,2,2'
|
|
23 | Bin Code | Code20 |
|
|
40 | Quantity | Decimal (0:5) | ||
41 | Finished Quantity | Decimal (0:5) | Editable: No | |
42 | Remaining Quantity | Decimal (0:5) | Editable: No | |
45 | Scrap % | Decimal (0:5) | ||
47 | Due Date | Date | Editable: No | |
48 | Starting Date | Date | ||
49 | Starting Time | Time | ||
50 | Ending Date | Date | ||
51 | Ending Time | Time | ||
52 | Planning Level Code | Integer | Editable: No | |
53 | Priority | Integer | ||
60 | Production BOM No. | Code20 |
|
|
61 | Routing No. | Code20 |
|
|
62 | Inventory Posting Group | Code20 |
|
|
63 | Routing Reference No. | Integer | Editable: No | |
65 | Unit Cost | Decimal | AutoFormatType: 2 | |
67 | Cost Amount | Decimal | AutoFormatType: 1 | Editable: No |
68 | Reserved Quantity | Decimal (0:5) |
|
Editable: No FlowField |
70 | Capacity Type Filter | Option | [Work Center,Machine Center] | FlowFilter |
71 | Capacity No. Filter | Code20 |
|
FlowFilter |
72 | Date Filter | Date | FlowFilter | |
80 | Unit of Measure Code | Code10 |
|
|
81 | Quantity (Base) | Decimal (0:5) | ||
82 | Finished Qty. (Base) | Decimal (0:5) | Editable: No | |
83 | Remaining Qty. (Base) | Decimal (0:5) | Editable: No | |
84 | Reserved Qty. (Base) | Decimal (0:5) |
|
Editable: No FlowField |
90 | Expected Operation Cost Amt. | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
91 | Total Exp. Oper. Output (Qty.) | Decimal (0:5) |
|
Editable: No FlowField |
94 | Expected Component Cost Amt. | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
198 | Starting Date-Time | DateTime | ||
199 | Ending Date-Time | DateTime | ||
480 | Dimension Set ID | Integer |
|
Editable: No |
5831 | Cost Amount (ACY) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
Editable: No |
5832 | Unit Cost (ACY) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
Editable: No |
99000750 | Production BOM Version Code | Code20 |
|
|
99000751 | Routing Version Code | Code20 |
|
|
99000752 | Routing Type | Option | [Serial,Parallel] | |
99000753 | Qty. per Unit of Measure | Decimal (0:5) | Editable: No | |
99000754 | MPS Order | Boolean | ||
99000755 | Planning Flexibility | Option | [Unlimited,None] | |
99000764 | Indirect Cost % | Decimal (0:5) | ||
99000765 | Overhead Rate | Decimal | AutoFormatType: 2 |
Keys
# | Fields | ||
---|---|---|---|
0 | Status,Prod. Order No.,Line No. | Clustered: Yes | |
1 | Prod. Order No.,Line No.,Status | ||
2 | Status,Item No.,Variant Code,Location Code,Ending Date | SumIndexFields: Remaining Qty. (Base),Cost Amount | |
3 | Status,Item No.,Variant Code,Location Code,Starting Date | SumIndexFields: Remaining Qty. (Base) | MaintainSIFTIndex: No |
4 | Status,Item No.,Variant Code,Location Code,Due Date | SumIndexFields: Remaining Qty. (Base) | MaintainSIFTIndex: No |
5 | Status,Item No.,Variant Code,Shortcut Dimension 1 Code,Shortcut Dimension 2 Code,Location Code,Due Date | SumIndexFields: Remaining Qty. (Base) | MaintainSIFTIndex: No |
6 | Status,Prod. Order No.,Item No. | ||
7 | Status,Prod. Order No.,Routing No.,Routing Reference No. | SumIndexFields: Quantity,Finished Quantity | MaintainSIFTIndex: No |
8 | Status,Prod. Order No.,Planning Level Code | ||
9 | Planning Level Code,Priority | ||
10 | Item No.,Variant Code,Location Code,Status,Ending Date | SumIndexFields: Remaining Qty. (Base) | MaintainSIFTIndex: No |
11 | Item No.,Variant Code,Location Code,Status,Due Date | SumIndexFields: Remaining Qty. (Base) | MaintainSIFTIndex: No |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
Bin Code | Bin | Code |
|
1..n |
Bin Code | Bin Content | Bin Code |
|
1..n |
Dimension Set ID | Dimension Set Entry |
|
1..n | |
Shortcut Dimension 2 Code | Dimension Value | Code |
|
1..n |
Inventory Posting Group | Inventory Posting Group | Code |
|
1..n |
Item No. | Item |
|
1..n | |
Unit of Measure Code | Item Unit of Measure | Code |
|
1..n |
Variant Code | Item Variant | Code |
|
1..n |
Location Code | Location |
|
1..n | |
Capacity No. Filter | Machine Center | No. |
|
1..n |
Production BOM No. | Production BOM Header | No. |
|
1..n |
Production BOM Version Code | Production BOM Version | Version Code |
|
1..n |
Prod. Order No. | Production Order | No. |
|
1..n |
Routing No. | Routing Header | No. |
|
1..n |
Routing Version Code | Routing Version | Version Code |
|
1..n |
Capacity No. Filter | Work Center | No. |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
Capacity Ledger Entry | Order Line No. |
|
1..n |
Item Journal Line | Order Line No. |
|
1..n |
Prod. Order Comp. Cmt Line | Prod. Order Line No. |
|
1..n |
Prod. Order Component | Supplied-by Line No. |
|
1..n |
Purch. Inv. Line | Prod. Order Line No. |
|
1..n |
Purch. Rcpt. Line | Prod. Order Line No. |
|
1..n |
Purchase Line | Prod. Order Line No. |
|
1..n |
Purchase Line Archive | Prod. Order Line No. |
|
1..n |
Registered Whse. Activity Line | Whse. Document Line No. |
|
1..n |
Requisition Line | Prod. Order Line No. |
|
1..n |
Warehouse Activity Line | Whse. Document Line No. |
|
1..n |
Whse. Worksheet Line | Whse. Document Line No. |
|
1..n |