Table 32 Item Ledger Entry

Base Application, Microsoft.Inventory.Ledger

87 fields

IdNameTypeVersions
1Entry No.Integer17-29
2Item No.Code[20]17-29
3Posting DateDate17-29
4Entry TypeEnum "Item Ledger Entry Type"17-29
5Source No.Code[20]17-29
6Document No.Code[20]17-29
7DescriptionText[100]17-29
8Location CodeCode[10]17-29
12QuantityDecimal17-29
13Remaining QuantityDecimal17-29
14Invoiced QuantityDecimal17-29
20Item Register No.Integernew in 26
21SIFT Bucket No.Integernew in 26
28Applies-to EntryInteger17-29
29OpenBoolean17-29
33Global Dimension 1 CodeCode[20]17-29
34Global Dimension 2 CodeCode[20]17-29
36PositiveBoolean17-29
40Shpt. Method CodeCode[10]17-29
41Source TypeEnum "Analysis Source Type"17-29changed in 18
47Drop ShipmentBoolean17-29
50Transaction TypeCode[10]17-29
51Transport MethodCode[10]17-29
52Country/Region CodeCode[10]17-29
59Entry/Exit PointCode[10]17-29
60Document DateDate17-29
61External Document No.Code[35]17-29
62AreaCode[10]17-29
63Transaction SpecificationCode[10]17-29
64No. SeriesCode[20]17-29
70Reserved QuantityDecimal17-29
79Document TypeEnum "Item Ledger Document Type"17-29
80Document Line No.Integer17-29
90Order TypeEnum "Inventory Order Type"17-29
91Order No.Code[20]17-29
92Order Line No.Integer17-29
480Dimension Set IDInteger17-29
481Shortcut Dimension 3 CodeCode[20]17-29
482Shortcut Dimension 4 CodeCode[20]17-29
483Shortcut Dimension 5 CodeCode[20]17-29
484Shortcut Dimension 6 CodeCode[20]17-29
485Shortcut Dimension 7 CodeCode[20]17-29
486Shortcut Dimension 8 CodeCode[20]17-29
904Assemble to OrderBoolean17-29
1000Job No.Code[20]17-29
1001Job Task No.Code[20]17-29
1002Job PurchaseBoolean17-29
5402Variant CodeCode[10]17-29
5404Qty. per Unit of MeasureDecimal17-29
5407Unit of Measure CodeCode[10]17-29
5408Derived from Blanket OrderBoolean17-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
5800Completely InvoicedBoolean17-29
5801Last Invoice DateDate17-29
5802Applied Entry to AdjustBoolean17-29
5803Cost Amount (Expected)Decimal17-29
5804Cost Amount (Actual)Decimal17-29
5805Cost Amount (Non-Invtbl.)Decimal17-29
5806Cost Amount (Expected) (ACY)Decimal17-29
5807Cost Amount (Actual) (ACY)Decimal17-29
5808Cost Amount (Non-Invtbl.)(ACY)Decimal17-29
5813Purchase Amount (Expected)Decimal17-29
5814Purchase Amount (Actual)Decimal17-29
5815Sales Amount (Expected)Decimal17-29
5816Sales Amount (Actual)Decimal17-29
5817CorrectionBoolean17-29
5818Shipped Qty. Not ReturnedDecimal17-29
5819Item Ledger Entry QuantityDecimalnew in 26
5820Remaining Qty. by DateDecimalnew in 27
5821Date FilterDatenew in 27
5833Prod. Order Comp. Line No.Integer17-29
6500Serial No.Code[50]17-29
6501Lot No.Code[50]17-29
6502Warranty DateDate17-29
6503Expiration DateDate17-29
6510Item TrackingEnum "Item Tracking Entry Type"17-29
6515Package No.Code[50]new in 18
6602Return Reason CodeCode[10]17-29
6603Item DescriptionText[100]new in 26