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 |