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 |
|
NotBlank: Yes |
| 2 | Variant Code (Variant Code) | Code10 |
|
|
| 3 | Location Code (Location Code) | Code10 |
|
|
| 4 | Description (Description) | Text50 |
|
Editable: No FlowField |
| 5 | Description 2 (Description 2) | Text50 |
|
Editable: No FlowField |
| 6 | Assembly BOM (Assembly BOM) | Boolean |
|
Editable: No FlowField |
| 12 | Shelf No. (Shelf No.) | Code10 | ||
| 22 | Unit Cost (Unit Cost) | Decimal | AutoFormatType: 2 | |
| 24 | Standard Cost (Standard Cost) | Decimal | AutoFormatType: 2 | |
| 25 | Last Direct Cost (Last Direct Cost) | Decimal | AutoFormatType: 2 | |
| 31 | Vendor No. (Vendor No.) | Code20 |
|
|
| 32 | Vendor Item No. (Vendor Item No.) | Text20 | ||
| 33 | Lead Time Calculation (Lead Time Calculation) | DateFormula | ||
| 34 | Reorder Point (Reorder Point) | Decimal (0:5) | ||
| 35 | Maximum Inventory (Maximum Inventory) | Decimal (0:5) | AccessByPermission: TableData 244=R | |
| 36 | Reorder Quantity (Reorder Quantity) | Decimal (0:5) | ||
| 53 | Comment (Comment) | Boolean |
|
Editable: No FlowField |
| 62 | Last Date Modified (Last Date Modified) | Date | Editable: No | |
| 64 | Date Filter (Date Filter) | Date | FlowFilter | |
| 65 | Global Dimension 1 Filter (Global Dimension 1 Filter) | Code20 |
|
FlowFilter |
| 66 | Global Dimension 2 Filter (Global Dimension 2 Filter) | Code20 |
|
FlowFilter |
| 68 | Inventory (Inventory) | Decimal (0:5) |
|
Editable: No FlowField |
| 84 | Qty. on Purch. Order (Qty. on Purch. Order) | Decimal (0:5) | AccessByPermission: TableData 120=R
|
Editable: No FlowField |
| 85 | Qty. on Sales Order (Qty. on Sales Order) | Decimal (0:5) | AccessByPermission: TableData 110=R
|
Editable: No FlowField |
| 89 | Drop Shipment Filter (Drop Shipment Filter) | Boolean | FlowFilter | |
| 910 | Assembly Policy (Assembly Policy) | Option | [Assemble-to-Stock,Assemble-to-Order] AccessByPermission: TableData 90=R |
|
| 977 | Qty. on Assembly Order (Qty. on Assembly Order) | Decimal (0:5) |
|
Editable: No FlowField |
| 978 | Qty. on Asm. Component (Qty. on Asm. Component) | Decimal (0:5) |
|
Editable: No FlowField |
| 1001 | Qty. on Job Order (Qty. on Job Order) | Decimal (0:5) |
|
Editable: No FlowField |
| 5400 | Transfer-Level Code (Transfer-Level Code) | Integer | Editable: No | |
| 5401 | Lot Size (Lot Size) | Decimal (0:5) | AccessByPermission: TableData 5405=R | |
| 5410 | Discrete Order Quantity (Discrete Order Quantity) | Integer | ||
| 5411 | Minimum Order Quantity (Minimum Order Quantity) | Decimal (0:5) | ||
| 5412 | Maximum Order Quantity (Maximum Order Quantity) | Decimal (0:5) | AccessByPermission: TableData 244=R | |
| 5413 | Safety Stock Quantity (Safety Stock Quantity) | Decimal (0:5) | AccessByPermission: TableData 244=R | |
| 5414 | Order Multiple (Order Multiple) | Decimal (0:5) | AccessByPermission: TableData 244=R | |
| 5415 | Safety Lead Time (Safety Lead Time) | DateFormula | AccessByPermission: TableData 244=R | |
| 5416 | Components at Location (Components at Location) | Code10 |
|
|
| 5417 | Flushing Method (Flushing Method) | Option | [Manual,Forward,Backward,Pick + Forward,Pick + Backward] | |
| 5419 | Replenishment System (Replenishment System) | Option | [Purchase,Prod. Order,Transfer,Assembly] | |
| 5420 | Scheduled Receipt (Qty.) (Scheduled Receipt (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
| 5421 | Scheduled Need (Qty.) (Scheduled Need (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
| 5423 | Bin Filter (Bin Filter) | Code20 |
|
FlowFilter |
| 5428 | Time Bucket (Time Bucket) | DateFormula | ||
| 5440 | Reordering Policy (Reordering Policy) | Option | [ ,Fixed Reorder Qty.,Maximum Qty.,Order,Lot-for-Lot] | |
| 5441 | Include Inventory (Include Inventory) | Boolean | ||
| 5442 | Manufacturing Policy (Manufacturing Policy) | Option | [Make-to-Stock,Make-to-Order] | |
| 5443 | Rescheduling Period (Rescheduling Period) | DateFormula | ||
| 5444 | Lot Accumulation Period (Lot Accumulation Period) | DateFormula | ||
| 5445 | Dampener Period (Dampener Period) | DateFormula | ||
| 5446 | Dampener Quantity (Dampener Quantity) | Decimal (0:5) | ||
| 5447 | Overflow Level (Overflow Level) | Decimal (0:5) | ||
| 5700 | Transfer-from Code (Transfer-from Code) | Code10 |
|
|
| 5701 | Qty. in Transit (Qty. in Transit) | Decimal (0:5) |
|
Editable: No FlowField |
| 5702 | Trans. Ord. Receipt (Qty.) (Trans. Ord. Receipt (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
| 5703 | Trans. Ord. Shipment (Qty.) (Trans. Ord. Shipment (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
| 5901 | Qty. on Service Order (Qty. on Service Order) | Decimal (0:5) |
|
Editable: No FlowField |
| 7301 | Special Equipment Code (Special Equipment Code) | Code10 |
|
|
| 7302 | Put-away Template Code (Put-away Template Code) | Code10 |
|
|
| 7307 | Put-away Unit of Measure Code (Put-away Unit of Measure Code) | Code10 |
|
|
| 7380 | Phys Invt Counting Period Code (Phys Invt Counting Period Code) | Code10 |
|
|
| 7381 | Last Counting Period Update (Last Counting Period Update) | Date | Editable: No | |
| 7383 | Last Phys. Invt. Date (Last Phys. Invt. Date) | Date |
|
Editable: No FlowField |
| 7384 | Use Cross-Docking (Use Cross-Docking) | Boolean | InitValue: Yes AccessByPermission: TableData 7302=R |
|
| 7385 | Next Counting Start Date (Next Counting Start Date) | Date | ||
| 7386 | Next Counting End Date (Next Counting End Date) | Date | ||
| 99000765 | Planned Order Receipt (Qty.) (Planned Order Receipt (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
| 99000766 | FP Order Receipt (Qty.) (FP Order Receipt (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
| 99000767 | Rel. Order Receipt (Qty.) (Rel. Order Receipt (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
| 99000769 | Planned Order Release (Qty.) (Planned Order Release (Qty.)) | Decimal (0:5) |
|
Editable: No FlowField |
| 99000770 | Purch. Req. Receipt (Qty.) (Purch. Req. Receipt (Qty.)) | Decimal (0:5) |
|
FlowField |
| 99000771 | Purch. Req. Release (Qty.) (Purch. Req. Release (Qty.)) | Decimal (0:5) |
|
FlowField |
| 99000777 | Qty. on Prod. Order (Qty. on Prod. Order) | Decimal (0:5) |
|
Editable: No FlowField |
| 99000778 | Qty. on Component Lines (Qty. on Component Lines) | Decimal (0:5) |
|
Editable: No FlowField |
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Location Code,Item No.,Variant Code (Location Code,Item No.,Variant Code) | Clustered: Yes | |
| 1 | Replenishment System,Vendor No.,Transfer-from Code (Replenishment System,Vendor No.,Transfer-from Code) | ||
| 2 | Item No.,Location Code,Variant Code (Item No.,Location Code,Variant Code) | ||
| 3 | Item No.,Transfer-Level Code (Item No.,Transfer-Level Code) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Bin Filter (Bin Filter) | Bin | Code (Code) |
|
1..n |
| Global Dimension 2 Filter (Global Dimension 2 Filter) | Dimension Value | Code (Code) |
|
1..n |
| Item No. (Item No.) | Item | () |
|
1..n |
| Put-away Unit of Measure Code (Put-away Unit of Measure Code) | Item Unit of Measure | Code (Code) |
|
1..n |
| Variant Code (Variant Code) | Item Variant | Code (Code) |
|
1..n |
| Transfer-from Code (Transfer-from Code) | Location | () |
|
1..n |
| Phys Invt Counting Period Code (Phys Invt Counting Period Code) | Phys. Invt. Counting Period | Code (Code) |
|
1..n |
| Put-away Template Code (Put-away Template Code) | Put-away Template Header | Code (Code) |
|
1..n |
| Special Equipment Code (Special Equipment Code) | Special Equipment | Code (Code) |
|
1..n |
| Vendor No. (Vendor No.) | Vendor | No. (No.) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Bin | Variant Filter (Variant Filter) |
|
1..n |