Table 83 Item Journal Line

Base Application, Microsoft.Inventory.Journal

145 fields

IdNameTypeVersions
1Journal Template NameCode[10]17-29
2Line No.Integer17-29
3Item No.Code[20]17-29
4Posting DateDate17-29
5Entry TypeEnum "Item Ledger Entry Type"17-29
6Source No.Code[20]17-29
7Document No.Code[20]17-29
8DescriptionText[100]17-29
9Location CodeCode[10]17-29
10Inventory Posting GroupCode[20]17-29
11Source Posting GroupCode[20]17-29
13QuantityDecimal17-29
15Invoiced QuantityDecimal17-29
16Unit AmountDecimal17-29
17Unit CostDecimal17-29
18AmountDecimal17-29
22Discount AmountDecimal17-29
23Salespers./Purch. CodeCode[20]17-29
26Source CodeCode[10]17-29
29Applies-to EntryInteger17-29
32Item Shpt. Entry No.Integer17-29
34Shortcut Dimension 1 CodeCode[20]17-29
35Shortcut Dimension 2 CodeCode[20]17-29
37Indirect Cost %Decimal17-29
39Source TypeEnum "Analysis Source Type"17-29changed in 18
40Shpt. Method CodeCode[10]17-29
41Journal Batch NameCode[10]17-29
42Reason CodeCode[10]17-29
43Recurring MethodOption17-29
44Expiration DateDate17-29
45Recurring FrequencyDateFormula17-29
46Drop ShipmentBoolean17-29
47Transaction TypeCode[10]17-29
48Transport MethodCode[10]17-29
49Country/Region CodeCode[10]17-29
50New Location CodeCode[10]17-29
51New Shortcut Dimension 1 CodeCode[20]17-29
52New Shortcut Dimension 2 CodeCode[20]17-29
53Qty. (Calculated)Decimal17-29
54Qty. (Phys. Inventory)Decimal17-29
55Last Item Ledger Entry No.Integer17-29
56Phys. InventoryBoolean17-29
57Gen. Bus. Posting GroupCode[20]17-29
58Gen. Prod. Posting GroupCode[20]17-29
59Entry/Exit PointCode[10]17-29
60Document DateDate17-29
62External Document No.Code[35]17-29
63AreaCode[10]17-29
64Transaction SpecificationCode[10]17-29
65Posting No. SeriesCode[20]17-29
68Reserved QuantityDecimal17-29
72Unit Cost (ACY)Decimal17-29
73Source Currency CodeCode[10]17-29
79Document TypeEnum "Item Ledger Document Type"17-29
80Document Line No.Integer17-29
86VAT Reporting DateDatenew in 21
90Order TypeEnum "Inventory Order Type"17-29
91Order No.Code[20]17-29
92Order Line No.Integer17-29
101Applies-to Rem. QuantityDecimalnew in 26
480Dimension Set IDInteger17-29
481New Dimension Set IDInteger17-29
904Assemble to OrderBoolean17-29
1000Job No.Code[20]17-29
1001Job Task No.Code[20]17-29
1002Job PurchaseBoolean17-29
1030Job Contract Entry No.Integer17-29
5402Variant CodeCode[10]17-29
5403Bin CodeCode[20]17-29
5404Qty. per Unit of MeasureDecimal17-29
5406New Bin CodeCode[20]17-29
5407Unit of Measure CodeCode[10]17-29
5408Derived from Blanket OrderBoolean17-29
5410Qty. Rounding PrecisionDecimalnew in 19
5411Qty. Rounding Precision (Base)Decimalnew in 19
5413Quantity (Base)Decimal17-29
5415Invoiced Qty. (Base)Decimal17-29
5468Reserved Qty. (Base)Decimal17-29
5560LevelInteger17-29
5561Flushing MethodEnum "Flushing Method"17-25, 27-29
5562Changed by UserBoolean17-29
5701Originally Ordered No.Code[20]17-29
5702Originally Ordered Var. CodeCode[10]17-29
5703Out-of-Stock SubstitutionBoolean17-29
5704Item Category CodeCode[20]17-29
5705NonstockBoolean17-29
5706Purchasing CodeCode[10]17-29
5725Item Reference No.Code[50]17-29
5726Item Reference Unit of MeasureCode[10]new in 22
5727Item Reference TypeEnum "Item Reference Type"new in 22
5728Item Reference Type No.Code[30]new in 22
5791Planned Delivery DateDate17-29
5793Order DateDate17-29
5800Value Entry TypeEnum "Cost Entry Type"17-29
5801Item Charge No.Code[20]17-29
5802Inventory Value (Calculated)Decimal17-29
5803Inventory Value (Revalued)Decimal17-29
5804Variance TypeEnum "Cost Variance Type"17-29
5805Inventory Value PerOption17-29
5806Partial RevaluationBoolean17-29
5807Applies-from EntryInteger17-29
5808Invoice No.Code[20]17-29
5809Unit Cost (Calculated)Decimal17-29
5810Unit Cost (Revalued)Decimal17-29
5811Applied AmountDecimal17-29
5812Update Standard CostBoolean17-29
5813Amount (ACY)Decimal17-29
5817CorrectionBoolean17-29
5818AdjustmentBoolean17-29
5819Applies-to Value EntryInteger17-29
5820Invoice-to Source No.Code[20]17-29
5830TypeEnum "Capacity Type Journal"17-29
5831No.Code[20]17-29
5858Cap. Unit of Measure CodeCode[10]17-29
5859Qty. per Cap. Unit of MeasureDecimal17-29
5887Unit Cost CalculationEnum "Unit Cost Calculation Type"17-29changed in 23
5888SubcontractingBoolean17-25, 27-29
6500Serial No.Code[50]17-29
6501Lot No.Code[50]17-29
6502Warranty DateDate17-29
6503New Serial No.Code[50]17-29
6504New Lot No.Code[50]17-29
6505New Item Expiration DateDate17-29
6506Item Expiration DateDate17-29
6515Package No.Code[50]new in 18
6516New Package No.Code[50]new in 18
6600Return Reason CodeCode[10]17-29
7000Price Calculation MethodEnum "Price Calculation Method"17-29
7315Warehouse AdjustmentBoolean17-29
7316Direct TransferBoolean17-29
7380Phys Invt Counting Period CodeCode[10]17-29
7381Phys Invt Counting Period TypeOption17-29
99000755Overhead RateDecimal17-29
99000756Single-Level Material CostDecimal17-29
99000757Single-Level Capacity CostDecimal17-29
99000758Single-Level Subcontrd. CostDecimal17-29
99000759Single-Level Cap. Ovhd CostDecimal17-29
99000760Single-Level Mfg. Ovhd CostDecimal17-29
99000761Rolled-up Material CostDecimal17-29
99000762Rolled-up Capacity CostDecimal17-29
99000763Rolled-up Subcontracted CostDecimal17-29
99000764Rolled-up Mfg. Ovhd CostDecimal17-29
99000765Rolled-up Cap. Overhead CostDecimal17-29
99000766Single-Lvl Mat. Non-Invt. CostDecimalnew in 26
99000767Rolled-up Mat. Non-Invt. CostDecimalnew in 26