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