Table 83 Item Journal Line

Base Application, Microsoft.Inventory.Journal

170 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
5700Cross-Reference No.Code[20]gone after 25
Removed, tag 22.0, obsolete since 17: Cross-Reference replaced by Item Reference feature.
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
5707Product Group CodeCode[10]gone after 25
Removed, tag 15.0, obsolete since 17: Product Groups became first level children of Item Categories.
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
5838Operation No.Code[10]gone after 25
5839Work Center No.Code[20]gone after 25
5841Setup TimeDecimalgone after 25
5842Run TimeDecimalgone after 25
5843Stop TimeDecimalgone after 25
5846Output QuantityDecimalgone after 25
5847Scrap QuantityDecimalgone after 25
5849Concurrent CapacityDecimalgone after 25
5851Setup Time (Base)Decimalgone after 25
5852Run Time (Base)Decimalgone after 25
5853Stop Time (Base)Decimalgone after 25
5856Output Quantity (Base)Decimalgone after 25
5857Scrap Quantity (Base)Decimalgone after 25
5858Cap. Unit of Measure CodeCode[10]17-29
5859Qty. per Cap. Unit of MeasureDecimal17-29
5873Starting TimeTimegone after 25
5874Ending TimeTimegone after 25
5882Routing No.Code[20]gone after 25
5883Routing Reference No.Integergone after 25
5884Prod. Order Comp. Line No.Integergone after 25
5885FinishedBooleangone after 25
5887Unit Cost CalculationEnum "Unit Cost Calculation Type"17-29changed in 23
5888SubcontractingBoolean17-25, 27-29
5895Stop CodeCode[10]gone after 25
5896Scrap CodeCode[10]gone after 25
5898Work Center Group CodeCode[10]gone after 25
5899Work Shift CodeCode[10]gone after 25
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