Table 83 Item Journal Line
145 fields
| Id | Name | Type | Versions |
|---|---|---|---|
| 1 | Journal Template Name | Code[10] | 17-29 |
| 2 | Line No. | Integer | 17-29 |
| 3 | Item No. | Code[20] | 17-29 |
| 4 | Posting Date | Date | 17-29 |
| 5 | Entry Type | Enum "Item Ledger Entry Type" | 17-29 |
| 6 | Source No. | Code[20] | 17-29 |
| 7 | Document No. | Code[20] | 17-29 |
| 8 | Description | Text[100] | 17-29 |
| 9 | Location Code | Code[10] | 17-29 |
| 10 | Inventory Posting Group | Code[20] | 17-29 |
| 11 | Source Posting Group | Code[20] | 17-29 |
| 13 | Quantity | Decimal | 17-29 |
| 15 | Invoiced Quantity | Decimal | 17-29 |
| 16 | Unit Amount | Decimal | 17-29 |
| 17 | Unit Cost | Decimal | 17-29 |
| 18 | Amount | Decimal | 17-29 |
| 22 | Discount Amount | Decimal | 17-29 |
| 23 | Salespers./Purch. Code | Code[20] | 17-29 |
| 26 | Source Code | Code[10] | 17-29 |
| 29 | Applies-to Entry | Integer | 17-29 |
| 32 | Item Shpt. Entry No. | Integer | 17-29 |
| 34 | Shortcut Dimension 1 Code | Code[20] | 17-29 |
| 35 | Shortcut Dimension 2 Code | Code[20] | 17-29 |
| 37 | Indirect Cost % | Decimal | 17-29 |
| 39 | Source Type | Enum "Analysis Source Type" | 17-29changed in 18 |
| 40 | Shpt. Method Code | Code[10] | 17-29 |
| 41 | Journal Batch Name | Code[10] | 17-29 |
| 42 | Reason Code | Code[10] | 17-29 |
| 43 | Recurring Method | Option | 17-29 |
| 44 | Expiration Date | Date | 17-29 |
| 45 | Recurring Frequency | DateFormula | 17-29 |
| 46 | Drop Shipment | Boolean | 17-29 |
| 47 | Transaction Type | Code[10] | 17-29 |
| 48 | Transport Method | Code[10] | 17-29 |
| 49 | Country/Region Code | Code[10] | 17-29 |
| 50 | New Location Code | Code[10] | 17-29 |
| 51 | New Shortcut Dimension 1 Code | Code[20] | 17-29 |
| 52 | New Shortcut Dimension 2 Code | Code[20] | 17-29 |
| 53 | Qty. (Calculated) | Decimal | 17-29 |
| 54 | Qty. (Phys. Inventory) | Decimal | 17-29 |
| 55 | Last Item Ledger Entry No. | Integer | 17-29 |
| 56 | Phys. Inventory | Boolean | 17-29 |
| 57 | Gen. Bus. Posting Group | Code[20] | 17-29 |
| 58 | Gen. Prod. Posting Group | Code[20] | 17-29 |
| 59 | Entry/Exit Point | Code[10] | 17-29 |
| 60 | Document Date | Date | 17-29 |
| 62 | External Document No. | Code[35] | 17-29 |
| 63 | Area | Code[10] | 17-29 |
| 64 | Transaction Specification | Code[10] | 17-29 |
| 65 | Posting No. Series | Code[20] | 17-29 |
| 68 | Reserved Quantity | Decimal | 17-29 |
| 72 | Unit Cost (ACY) | Decimal | 17-29 |
| 73 | Source Currency Code | Code[10] | 17-29 |
| 79 | Document Type | Enum "Item Ledger Document Type" | 17-29 |
| 80 | Document Line No. | Integer | 17-29 |
| 86 | VAT Reporting Date | Date | new in 21 |
| 90 | Order Type | Enum "Inventory Order Type" | 17-29 |
| 91 | Order No. | Code[20] | 17-29 |
| 92 | Order Line No. | Integer | 17-29 |
| 101 | Applies-to Rem. Quantity | Decimal | new in 26 |
| 480 | Dimension Set ID | Integer | 17-29 |
| 481 | New Dimension Set ID | Integer | 17-29 |
| 904 | Assemble to Order | Boolean | 17-29 |
| 1000 | Job No. | Code[20] | 17-29 |
| 1001 | Job Task No. | Code[20] | 17-29 |
| 1002 | Job Purchase | Boolean | 17-29 |
| 1030 | Job Contract Entry No. | Integer | 17-29 |
| 5402 | Variant Code | Code[10] | 17-29 |
| 5403 | Bin Code | Code[20] | 17-29 |
| 5404 | Qty. per Unit of Measure | Decimal | 17-29 |
| 5406 | New Bin Code | Code[20] | 17-29 |
| 5407 | Unit of Measure Code | Code[10] | 17-29 |
| 5408 | Derived from Blanket Order | Boolean | 17-29 |
| 5410 | Qty. Rounding Precision | Decimal | new in 19 |
| 5411 | Qty. Rounding Precision (Base) | Decimal | new in 19 |
| 5413 | Quantity (Base) | Decimal | 17-29 |
| 5415 | Invoiced Qty. (Base) | Decimal | 17-29 |
| 5468 | Reserved Qty. (Base) | Decimal | 17-29 |
| 5560 | Level | Integer | 17-29 |
| 5561 | Flushing Method | Enum "Flushing Method" | 17-25, 27-29 |
| 5562 | Changed by User | Boolean | 17-29 |
| 5701 | Originally Ordered No. | Code[20] | 17-29 |
| 5702 | Originally Ordered Var. Code | Code[10] | 17-29 |
| 5703 | Out-of-Stock Substitution | Boolean | 17-29 |
| 5704 | Item Category Code | Code[20] | 17-29 |
| 5705 | Nonstock | Boolean | 17-29 |
| 5706 | Purchasing Code | Code[10] | 17-29 |
| 5725 | Item Reference No. | Code[50] | 17-29 |
| 5726 | Item Reference Unit of Measure | Code[10] | new in 22 |
| 5727 | Item Reference Type | Enum "Item Reference Type" | new in 22 |
| 5728 | Item Reference Type No. | Code[30] | new in 22 |
| 5791 | Planned Delivery Date | Date | 17-29 |
| 5793 | Order Date | Date | 17-29 |
| 5800 | Value Entry Type | Enum "Cost Entry Type" | 17-29 |
| 5801 | Item Charge No. | Code[20] | 17-29 |
| 5802 | Inventory Value (Calculated) | Decimal | 17-29 |
| 5803 | Inventory Value (Revalued) | Decimal | 17-29 |
| 5804 | Variance Type | Enum "Cost Variance Type" | 17-29 |
| 5805 | Inventory Value Per | Option | 17-29 |
| 5806 | Partial Revaluation | Boolean | 17-29 |
| 5807 | Applies-from Entry | Integer | 17-29 |
| 5808 | Invoice No. | Code[20] | 17-29 |
| 5809 | Unit Cost (Calculated) | Decimal | 17-29 |
| 5810 | Unit Cost (Revalued) | Decimal | 17-29 |
| 5811 | Applied Amount | Decimal | 17-29 |
| 5812 | Update Standard Cost | Boolean | 17-29 |
| 5813 | Amount (ACY) | Decimal | 17-29 |
| 5817 | Correction | Boolean | 17-29 |
| 5818 | Adjustment | Boolean | 17-29 |
| 5819 | Applies-to Value Entry | Integer | 17-29 |
| 5820 | Invoice-to Source No. | Code[20] | 17-29 |
| 5830 | Type | Enum "Capacity Type Journal" | 17-29 |
| 5831 | No. | Code[20] | 17-29 |
| 5858 | Cap. Unit of Measure Code | Code[10] | 17-29 |
| 5859 | Qty. per Cap. Unit of Measure | Decimal | 17-29 |
| 5887 | Unit Cost Calculation | Enum "Unit Cost Calculation Type" | 17-29changed in 23 |
| 5888 | Subcontracting | Boolean | 17-25, 27-29 |
| 6500 | Serial No. | Code[50] | 17-29 |
| 6501 | Lot No. | Code[50] | 17-29 |
| 6502 | Warranty Date | Date | 17-29 |
| 6503 | New Serial No. | Code[50] | 17-29 |
| 6504 | New Lot No. | Code[50] | 17-29 |
| 6505 | New Item Expiration Date | Date | 17-29 |
| 6506 | Item Expiration Date | Date | 17-29 |
| 6515 | Package No. | Code[50] | new in 18 |
| 6516 | New Package No. | Code[50] | new in 18 |
| 6600 | Return Reason Code | Code[10] | 17-29 |
| 7000 | Price Calculation Method | Enum "Price Calculation Method" | 17-29 |
| 7315 | Warehouse Adjustment | Boolean | 17-29 |
| 7316 | Direct Transfer | Boolean | 17-29 |
| 7380 | Phys Invt Counting Period Code | Code[10] | 17-29 |
| 7381 | Phys Invt Counting Period Type | Option | 17-29 |
| 99000755 | Overhead Rate | Decimal | 17-29 |
| 99000756 | Single-Level Material Cost | Decimal | 17-29 |
| 99000757 | Single-Level Capacity Cost | Decimal | 17-29 |
| 99000758 | Single-Level Subcontrd. Cost | Decimal | 17-29 |
| 99000759 | Single-Level Cap. Ovhd Cost | Decimal | 17-29 |
| 99000760 | Single-Level Mfg. Ovhd Cost | Decimal | 17-29 |
| 99000761 | Rolled-up Material Cost | Decimal | 17-29 |
| 99000762 | Rolled-up Capacity Cost | Decimal | 17-29 |
| 99000763 | Rolled-up Subcontracted Cost | Decimal | 17-29 |
| 99000764 | Rolled-up Mfg. Ovhd Cost | Decimal | 17-29 |
| 99000765 | Rolled-up Cap. Overhead Cost | Decimal | 17-29 |
| 99000766 | Single-Lvl Mat. Non-Invt. Cost | Decimal | new in 26 |
| 99000767 | Rolled-up Mat. Non-Invt. Cost | Decimal | new in 26 |