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 | Item Ledger 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 |
|
|
| 9 | Inventory Posting Group | Code10 |
|
|
| 10 | Source Posting Group | Code10 |
|
|
| 11 | Item Ledger Entry No. | Integer |
|
|
| 12 | Valued Quantity | Decimal (0:5) | ||
| 13 | Item Ledger Entry Quantity | Decimal (0:5) | ||
| 14 | Invoiced Quantity | Decimal (0:5) | ||
| 15 | Cost per Unit | Decimal | AutoFormatType: 2 | |
| 17 | Sales Amount (Actual) | Decimal | AutoFormatType: 1 | |
| 22 | Salespers./Purch. Code | Code10 |
|
|
| 23 | Discount Amount | Decimal | AutoFormatType: 1 | |
| 24 | User ID | Code50 |
|
|
| 25 | Source Code | Code10 |
|
|
| 28 | Applies-to Entry | Integer | ||
| 33 | Global Dimension 1 Code | Code20 | CaptionClass: '1,1,1'
|
|
| 34 | Global Dimension 2 Code | Code20 | CaptionClass: '1,1,2'
|
|
| 41 | Source Type | Option | [ ,Customer,Vendor,Item] | |
| 43 | Cost Amount (Actual) | Decimal | AutoFormatType: 1 | |
| 45 | Cost Posted to G/L | Decimal | AutoFormatType: 1 | |
| 46 | Reason Code | Code10 | AccessByPermission: TableData 223=R
|
|
| 47 | Drop Shipment | Boolean | ||
| 48 | Journal Batch Name | Code10 | ||
| 57 | Gen. Bus. Posting Group | Code10 |
|
|
| 58 | Gen. Prod. Posting Group | Code10 |
|
|
| 60 | Document Date | Date | ||
| 61 | External Document No. | Code35 | ||
| 68 | Cost Amount (Actual) (ACY) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
|
| 70 | Cost Posted to G/L (ACY) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode AccessByPermission: TableData 4=R |
|
| 72 | Cost per Unit (ACY) | Decimal | AutoFormatType: 2 AutoFormatExpr: GetCurrencyCode AccessByPermission: TableData 4=R |
|
| 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 | |
| 98 | Expected Cost | Boolean | ||
| 99 | Item Charge No. | Code20 |
|
|
| 100 | Valued By Average Cost | Boolean | ||
| 102 | Partial Revaluation | Boolean | ||
| 103 | Inventoriable | Boolean | ||
| 104 | Valuation Date | Date | ||
| 105 | Entry Type | Option | [Direct Cost,Revaluation,Rounding,Indirect Cost,Variance] | Editable: No |
| 106 | Variance Type | Option | [ ,Purchase,Material,Capacity,Capacity Overhead,Manufacturing Overhead,Subcontracted] | Editable: No |
| 148 | Purchase Amount (Actual) | Decimal | AutoFormatType: 1 | |
| 149 | Purchase Amount (Expected) | Decimal | AutoFormatType: 1 AccessByPermission: TableData 120=R |
|
| 150 | Sales Amount (Expected) | Decimal | AutoFormatType: 1 AccessByPermission: TableData 110=R |
|
| 151 | Cost Amount (Expected) | Decimal | AutoFormatType: 1 | |
| 152 | Cost Amount (Non-Invtbl.) | Decimal | AutoFormatType: 1 AccessByPermission: TableData 5800=R |
|
| 156 | Cost Amount (Expected) (ACY) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode |
|
| 157 | Cost Amount (Non-Invtbl.)(ACY) | Decimal | AutoFormatType: 1 AutoFormatExpr: GetCurrencyCode AccessByPermission: TableData 5800=R |
|
| 158 | Expected Cost Posted to G/L | Decimal | AutoFormatType: 1 | |
| 159 | Exp. Cost Posted to G/L (ACY) | Decimal | AutoFormatType: 1 | |
| 480 | Dimension Set ID | Integer |
|
Editable: No |
| 1000 | Job No. | Code20 |
|
|
| 1001 | Job Task No. | Code20 |
|
|
| 1002 | Job Ledger Entry No. | Integer |
|
BlankZero: Yes |
| 5402 | Variant Code | Code10 |
|
|
| 5818 | Adjustment | Boolean | Editable: No | |
| 5819 | Average Cost Exception | Boolean | ||
| 5831 | Capacity Ledger Entry No. | Integer |
|
|
| 5832 | Type | Option | [Work Center,Machine Center, ,Resource] | |
| 5834 | No. | Code20 |
|
|
| 6602 | Return Reason Code | Code10 |
|
Keys
| # | Fields | ||
|---|---|---|---|
| 0 | Entry No. | Clustered: Yes | |
| 1 | Item Ledger Entry No.,Entry Type | SumIndexFields: Invoiced Quantity,Sales Amount (Expected),Sales Amount (Actual),Cost Amount (Expected),Cost Amount (Actual),Cost Amount (Non-Invtbl.),Cost Amount (Expected) (ACY),Cost Amount (Actual) (ACY),Cost Amount (Non-Invtbl.)(ACY),Purchase Amount (Actual),Purchase Amount (Expected),Discount Amount | MaintainSIFTIndex: No |
| 2 | Item Ledger Entry No.,Document No.,Document Line No. | MaintainSQLIndex: No | |
| 3 | Item No.,Posting Date,Item Ledger Entry Type,Entry Type,Variance Type,Item Charge No.,Location Code,Variant Code | SumIndexFields: Invoiced Quantity,Sales Amount (Expected),Sales Amount (Actual),Cost Amount (Expected),Cost Amount (Actual),Cost Amount (Non-Invtbl.),Purchase Amount (Actual),Expected Cost Posted to G/L,Cost Posted to G/L,Item Ledger Entry Quantity | |
| 4 | Item No.,Posting Date,Item Ledger Entry Type,Entry Type,Variance Type,Item Charge No.,Location Code,Variant Code,Global Dimension 1 Code,Global Dimension 2 Code,Source Type,Source No. | SumIndexFields: Invoiced Quantity,Sales Amount (Expected),Sales Amount (Actual),Cost Amount (Expected),Cost Amount (Actual),Cost Amount (Non-Invtbl.),Purchase Amount (Actual),Expected Cost Posted to G/L,Cost Posted to G/L,Item Ledger Entry Quantity | |
| 5 | Document No. | ||
| 6 | Item No.,Valuation Date,Location Code,Variant Code | SumIndexFields: Cost Amount (Expected),Cost Amount (Actual),Cost Amount (Expected) (ACY),Cost Amount (Actual) (ACY),Item Ledger Entry Quantity | |
| 7 | Source Type,Source No.,Item No.,Posting Date,Entry Type,Adjustment,Item Ledger Entry Type | SumIndexFields: Discount Amount,Cost Amount (Non-Invtbl.),Cost Amount (Actual),Cost Amount (Expected),Sales Amount (Actual),Sales Amount (Expected),Invoiced Quantity | |
| 8 | Item Charge No.,Inventory Posting Group,Item No. | ||
| 9 | Capacity Ledger Entry No.,Entry Type | SumIndexFields: Cost Amount (Actual),Cost Amount (Actual) (ACY) | |
| 10 | Order Type,Order No.,Order Line No. | ||
| 11 | Source Type,Source No.,Global Dimension 1 Code,Global Dimension 2 Code,Item No.,Posting Date,Entry Type,Adjustment | SumIndexFields: Discount Amount,Cost Amount (Non-Invtbl.),Cost Amount (Actual),Cost Amount (Expected),Sales Amount (Actual),Sales Amount (Expected),Invoiced Quantity | |
| 12 | Job No.,Job Task No.,Document No. | ||
| 13 | Item Ledger Entry Type,Posting Date,Item No.,Inventory Posting Group,Dimension Set ID | SumIndexFields: Invoiced Quantity,Sales Amount (Actual),Purchase Amount (Actual) | |
| 14 | Item Ledger Entry No.,Valuation Date |
Table Relations To Other Tables
| Field | Related Table | Related Field | ||
|---|---|---|---|---|
| Capacity Ledger Entry No. | Capacity Ledger Entry | Entry No. |
|
1..n |
| Source No. | Customer | No. |
|
1..n |
| Source Posting Group | Customer Posting Group | Code |
|
1..n |
| Dimension Set ID | Dimension Set Entry |
|
1..n | |
| Global Dimension 2 Code | Dimension Value | Code |
|
1..n |
| Gen. Bus. Posting Group | Gen. Business Posting Group | Code |
|
1..n |
| Gen. Prod. Posting Group | Gen. Product Posting Group | Code |
|
1..n |
| Source Posting Group | Inventory Posting Group | Code |
|
1..n |
| Source No. | Item | No. |
|
1..n |
| Item Charge No. | Item Charge | No. |
|
1..n |
| Item Ledger Entry No. | Item Ledger Entry | Entry No. |
|
1..n |
| Variant Code | Item Variant | Code |
|
1..n |
| Job No. | Job | No. |
|
1..n |
| Job Ledger Entry No. | Job Ledger Entry | Entry No. |
|
1..n |
| Job Task No. | Job Task | Job Task No. |
|
1..n |
| Location Code | Location | Code |
|
1..n |
| No. | Machine Center | No. |
|
1..n |
| Reason Code | Reason Code | Code |
|
1..n |
| No. | Resource | No. |
|
1..n |
| Return Reason Code | Return Reason | Code |
|
1..n |
| Salespers./Purch. Code | Salesperson/Purchaser | Code |
|
1..n |
| Source Code | Source Code | Code |
|
1..n |
| User ID | User | User Name |
|
1..n |
| Source No. | Vendor | No. |
|
1..n |
| Source Posting Group | Vendor Posting Group | Code |
|
1..n |
| No. | Work Center | No. |
|
1..n |
Table Relations From Other Tables
| From Table | From Field | ||
|---|---|---|---|
| G/L - Item Ledger Relation | Value Entry No. |
|
1..n |
| Invt. Post to G/L Test Buffer | Value Entry No. |
|
1..n |
| Item Register | To Value Entry No. |
|
1..n |
| Post Value Entry to G/L | Value Entry No. |
|
1..1 |
| Value Entry Relation | Value Entry No. |
|
1..1 |