Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
| # | Name | Type | ||
|---|---|---|---|---|
| 1 | Entry No. (Entry No.) | Integer | ||
| 2 | Item No. (Item No.) | Code20 |
|
|
| 3 | Posting Date (Posting Date) | Date | ||
| 4 | Entry Type (Entry Type) | Option | [Purchase,Sale,Positive Adjmt.,Negative Adjmt.,Transfer,Consumption,Output, ,Assembly Consumption,Assembly Output] | |
| 5 | Source No. (Source No.) | Code20 |
|
|
| 6 | Document No. (Document No.) | Code20 | ||
| 7 | Description (Description) | Text50 | ||
| 8 | Location Code (Location Code) | Code10 |
|
|
| 12 | Quantity (Quantity) | Decimal (0:5) | ||
| 13 | Remaining Quantity (Remaining Quantity) | Decimal (0:5) | ||
| 14 | Invoiced Quantity (Invoiced Quantity) | Decimal (0:5) | ||
| 28 | Applies-to Entry (Applies-to Entry) | Integer | ||
| 29 | Open (Open) | Boolean | ||
| 33 | Global Dimension 1 Code (Global Dimension 1 Code) | Code20 | CaptionClass: '1,1,1'
|
|
| 34 | Global Dimension 2 Code (Global Dimension 2 Code) | Code20 | CaptionClass: '1,1,2'
|
|
| 36 | Positive (Positive) | Boolean | ||
| 41 | Source Type (Source Type) | Option | [ ,Customer,Vendor,Item] | |
| 47 | Drop Shipment (Drop Shipment) | Boolean | AccessByPermission: TableData 223=R | |
| 50 | Transaction Type (Transaction Type) | Code10 |
|
|
| 51 | Transport Method (Transport Method) | Code10 |
|
|
| 52 | Country/Region Code (Country/Region Code) | Code10 |
|
|
| 59 | Entry/Exit Point (Entry/Exit Point) | Code10 |
|
|
| 60 | Document Date (Document Date) | Date | ||
| 61 | External Document No. (External Document No.) | Code35 | ||
| 62 | Area (Area) | Code10 |
|
|
| 63 | Transaction Specification (Transaction Specification) | Code10 |
|
|
| 64 | No. Series (No. Series) | Code10 |
|
|
| 70 | Reserved Quantity (Reserved Quantity) | Decimal (0:5) | AccessByPermission: TableData 120=R
|
Editable: No FlowField |
| 79 | Document Type (Document Type) | Option | [ ,Sales Shipment,Sales Invoice,Sales Return Receipt,Sales Credit Memo,Purchase Receipt,Purchase Invoice,Purchase Return Shipment,Purchase Credit Memo,Transfer Shipment,Transfer Receipt,Service Shipment,Service Invoice,Service Credit Memo,Posted Assembly] | |
| 80 | Document Line No. (Document Line No.) | Integer | ||
| 90 | Order Type (Order Type) | Option | [ ,Production,Transfer,Service,Assembly] | Editable: No |
| 91 | Order No. (Order No.) | Code20 | Editable: No | |
| 92 | Order Line No. (Order Line No.) | Integer | Editable: No | |
| 480 | Dimension Set ID (Dimension Set ID) | Integer |
|
Editable: No |
| 904 | Assemble to Order (Assemble to Order) | Boolean | AccessByPermission: TableData 90=R | |
| 1000 | Job No. (Job No.) | Code20 |
|
|
| 1001 | Job Task No. (Job Task No.) | Code20 |
|
|
| 1002 | Job Purchase (Job Purchase) | Boolean | ||
| 5402 | Variant Code (Variant Code) | Code10 |
|
|
| 5404 | Qty. per Unit of Measure (Qty. per Unit of Measure) | Decimal (0:5) | ||
| 5407 | Unit of Measure Code (Unit of Measure Code) | Code10 |
|
|
| 5408 | Derived from Blanket Order (Derived from Blanket Order) | Boolean | ||
| 5700 | Cross-Reference No. (Cross-Reference No.) | Code20 | ||
| 5701 | Originally Ordered No. (Originally Ordered No.) | Code20 | AccessByPermission: TableData 5715=R
|
|
| 5702 | Originally Ordered Var. Code (Originally Ordered Var. Code) | Code10 | AccessByPermission: TableData 5715=R
|
|
| 5703 | Out-of-Stock Substitution (Out-of-Stock Substitution) | Boolean | ||
| 5704 | Item Category Code (Item Category Code) | Code20 |
|
|
| 5705 | Nonstock (Nonstock) | Boolean | ||
| 5706 | Purchasing Code (Purchasing Code) | Code10 |
|
|
| 5707 | Product Group Code (Product Group Code) | Code10 |
|
|
| 5800 | Completely Invoiced (Completely Invoiced) | Boolean | ||
| 5801 | Last Invoice Date (Last Invoice Date) | Date | ||
| 5802 | Applied Entry to Adjust (Applied Entry to Adjust) | Boolean | ||
| 5803 | Cost Amount (Expected) (Cost Amount (Expected)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5804 | Cost Amount (Actual) (Cost Amount (Actual)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5805 | Cost Amount (Non-Invtbl.) (Cost Amount (Non-Invtbl.)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5806 | Cost Amount (Expected) (ACY) (Cost Amount (Expected) (ACY)) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode
|
Editable: No FlowField |
| 5807 | Cost Amount (Actual) (ACY) (Cost Amount (Actual) (ACY)) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode
|
Editable: No FlowField |
| 5808 | Cost Amount (Non-Invtbl.)(ACY) (Cost Amount (Non-Invtbl.)(ACY)) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode
|
Editable: No FlowField |
| 5813 | Purchase Amount (Expected) (Purchase Amount (Expected)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5814 | Purchase Amount (Actual) (Purchase Amount (Actual)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5815 | Sales Amount (Expected) (Sales Amount (Expected)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5816 | Sales Amount (Actual) (Sales Amount (Actual)) | Decimal | AutoFormatType: 1
|
Editable: No FlowField |
| 5817 | Correction (Correction) | Boolean | ||
| 5818 | Shipped Qty. Not Returned (Shipped Qty. Not Returned) | Decimal (0:5) | AccessByPermission: TableData 36=R | |
| 5833 | Prod. Order Comp. Line No. (Prod. Order Comp. Line No.) | Integer | AccessByPermission: TableData 5405=R | |
| 6500 | Serial No. (Serial No.) | Code20 | ||
| 6501 | Lot No. (Lot No.) | Code20 | ||
| 6502 | Warranty Date (Warranty Date) | Date | ||
| 6503 | Expiration Date (Expiration Date) | Date | ||
| 6510 | Item Tracking (Item Tracking) | Option | [None,Lot No.,Lot and Serial No.,Serial No.] | Editable: No |
| 6602 | Return Reason Code (Return Reason Code) | Code10 |
|
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Entry No. (Entry No.) | Clustered: Yes | |
| 1 | Item No. (Item No.) | SumIndexFields: Invoiced Quantity | |
| 2 | Item No.,Posting Date (Item No.,Posting Date) | ||
| 3 | Item No.,Entry Type,Variant Code,Drop Shipment,Location Code,Posting Date (Item No.,Entry Type,Variant Code,Drop Shipment,Location Code,Posting Date) | SumIndexFields: Quantity,Invoiced Quantity | |
| 4 | Source Type,Source No.,Item No.,Variant Code,Posting Date (Source Type,Source No.,Item No.,Variant Code,Posting Date) | SumIndexFields: Quantity | |
| 5 | Item No.,Open,Variant Code,Positive,Location Code,Posting Date (Item No.,Open,Variant Code,Positive,Location Code,Posting Date) | SumIndexFields: Quantity,Remaining Quantity | |
| 6 | Item No.,Open,Variant Code,Positive,Location Code,Posting Date,Expiration Date,Lot No.,Serial No. (Item No.,Open,Variant Code,Positive,Location Code,Posting Date,Expiration Date,Lot No.,Serial No.) | SumIndexFields: Quantity,Remaining Quantity | |
| 7 | Country/Region Code,Entry Type,Posting Date (Country/Region Code,Entry Type,Posting Date) | ||
| 8 | Document No.,Document Type,Document Line No. (Document No.,Document Type,Document Line No.) | ||
| 9 | Item No.,Entry Type,Variant Code,Drop Shipment,Global Dimension 1 Code,Global Dimension 2 Code,Location Code,Posting Date (Item No.,Entry Type,Variant Code,Drop Shipment,Global Dimension 1 Code,Global Dimension 2 Code,Location Code,Posting Date) | SumIndexFields: Quantity,Invoiced Quantity | |
| 10 | Source Type,Source No.,Global Dimension 1 Code,Global Dimension 2 Code,Item No.,Variant Code,Posting Date (Source Type,Source No.,Global Dimension 1 Code,Global Dimension 2 Code,Item No.,Variant Code,Posting Date) | SumIndexFields: Quantity | |
| 11 | Order Type,Order No.,Order Line No.,Entry Type,Prod. Order Comp. Line No. (Order Type,Order No.,Order Line No.,Entry Type,Prod. Order Comp. Line No.) | SumIndexFields: Quantity | MaintainSIFTIndex: No |
| 12 | Item No.,Applied Entry to Adjust (Item No.,Applied Entry to Adjust) | ||
| 13 | Item No.,Positive,Location Code,Variant Code (Item No.,Positive,Location Code,Variant Code) | ||
| 14 | Entry Type,Nonstock,Item No.,Posting Date (Entry Type,Nonstock,Item No.,Posting Date) | ||
| 15 | Item No.,Location Code,Open,Variant Code,Unit of Measure Code,Lot No.,Serial No. (Item No.,Location Code,Open,Variant Code,Unit of Measure Code,Lot No.,Serial No.) | SumIndexFields: Remaining Quantity | |
| 16 | Item No.,Open,Variant Code,Positive,Lot No.,Serial No. (Item No.,Open,Variant Code,Positive,Lot No.,Serial No.) | MaintainSQLIndex: No MaintainSIFTIndex: No |
|
| 17 | Item No.,Open,Variant Code,Location Code,Item Tracking,Lot No.,Serial No. (Item No.,Open,Variant Code,Location Code,Item Tracking,Lot No.,Serial No.) | SumIndexFields: Remaining Quantity | MaintainSQLIndex: No MaintainSIFTIndex: No |
| 18 | Lot No. (Lot No.) | ||
| 19 | Serial No. (Serial No.) |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Area (Area) | Area | Code (Code) |
|
1..n |
| Country/Region Code (Country/Region Code) | Country/Region | Code (Code) |
|
1..n |
| Source No. (Source No.) | Customer | No. (No.) |
|
1..n |
| Dimension Set ID (Dimension Set ID) | Dimension Set Entry | () |
|
1..n |
| Global Dimension 2 Code (Global Dimension 2 Code) | Dimension Value | Code (Code) |
|
1..n |
| Entry/Exit Point (Entry/Exit Point) | Entry/Exit Point | Code (Code) |
|
1..n |
| Originally Ordered No. (Originally Ordered No.) | Item | No. (No.) |
|
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 |
| Originally Ordered Var. Code (Originally Ordered Var. Code) | Item Variant | Code (Code) |
|
1..n |
| Job No. (Job No.) | Job | No. (No.) |
|
1..n |
| Job Task No. (Job Task No.) | Job Task | Job Task No. (Job Task No.) |
|
1..n |
| Location Code (Location Code) | Location | Code (Code) |
|
1..n |
| No. Series (No. Series) | No. Series | Code (Code) |
|
1..n |
| Purchasing Code (Purchasing Code) | Purchasing | Code (Code) |
|
1..n |
| Return Reason Code (Return Reason Code) | Return Reason | Code (Code) |
|
1..n |
| Transaction Specification (Transaction Specification) | Transaction Specification | Code (Code) |
|
1..n |
| Transaction Type (Transaction Type) | Transaction Type | Code (Code) |
|
1..n |
| Transport Method (Transport Method) | Transport Method | Code (Code) |
|
1..n |
| Source No. (Source No.) | Vendor | No. (No.) |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| Availability Calc. Overview | Attached to Entry No. (Attached to Entry No.) |
|
1..n |
| Average Cost Calc. Overview | Item Ledger Entry No. (Item Ledger Entry No.) |
|
1..n |
| Intrastat Jnl. Line | Source Entry No. (Source Entry No.) |
|
1..n |
| Inventory Adjustment Buffer | Item Ledger Entry No. (Item Ledger Entry No.) |
|
1..n |
| Item Application Entry | Transferred-from Entry No. (Transferred-from Entry No.) |
|
1..n |
| Item Application Entry History | Transferred-from Entry No. (Transferred-from Entry No.) |
|
1..n |
| Item Entry Relation | Item Entry No. (Item Entry No.) |
|
1..1 |
| Item Journal Line | Last Item Ledger Entry No. (Last Item Ledger Entry No.) |
|
1..n |
| Item Register | To Entry No. (To Entry No.) |
|
1..n |
| Item Tracing Buffer | Item Ledger Entry No. (Item Ledger Entry No.) |
|
1..n |
| Job Journal Line | Ledger Entry No. (Ledger Entry No.) |
|
1..n |
| Job Ledger Entry | Ledger Entry No. (Ledger Entry No.) |
|
1..n |
| Job Planning Line | Ledger Entry No. (Ledger Entry No.) |
|
1..n |
| Phys. Inventory Ledger Entry | Last Item Ledger Entry No. (Last Item Ledger Entry No.) |
|
1..n |
| Reservation Entry | Item Ledger Entry No. (Item Ledger Entry No.) |
|
1..n |
| Tracking Specification | Transfer Item Entry No. (Transfer Item Entry No.) |
|
1..n |
| Value Entry | Item Ledger Entry No. (Item Ledger Entry No.) |
|
1..n |
| Whse. Item Entry Relation | Item Entry No. (Item Entry No.) |
|
1..1 |