Table 5802 Value Entry

Base Application, Microsoft.Inventory.Ledger

79 fields

IdNameTypeVersions
1Entry No.Integer17-29
2Item No.Code[20]17-29
3Posting DateDate17-29
4Item Ledger Entry 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
9Inventory Posting GroupCode[20]17-29
10Source Posting GroupCode[20]17-29
11Item Ledger Entry No.Integer17-29
12Valued QuantityDecimal17-29
13Item Ledger Entry QuantityDecimal17-29
14Invoiced QuantityDecimal17-29
15Cost per UnitDecimal17-29
17Sales Amount (Actual)Decimal17-29
20Item Register No.Integernew in 26
21SIFT Bucket No.Integernew in 26
22Salespers./Purch. CodeCode[20]17-29
23Discount AmountDecimal17-29
24User IDCode[50]17-29
25Source CodeCode[10]17-29
28Applies-to EntryInteger17-29
33Global Dimension 1 CodeCode[20]17-29
34Global Dimension 2 CodeCode[20]17-29
41Source TypeEnum "Analysis Source Type"17-29changed in 18
43Cost Amount (Actual)Decimal17-29
45Cost Posted to G/LDecimal17-29
46Reason CodeCode[10]17-29
47Drop ShipmentBoolean17-29
48Journal Batch NameCode[10]17-29
57Gen. Bus. Posting GroupCode[20]17-29
58Gen. Prod. Posting GroupCode[20]17-29
60Document DateDate17-29
61External Document No.Code[35]17-29
68Cost Amount (Actual) (ACY)Decimal17-29
70Cost Posted to G/L (ACY)Decimal17-29
72Cost per Unit (ACY)Decimal17-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
98Expected CostBoolean17-29
99Item Charge No.Code[20]17-29
100Valued By Average CostBoolean17-29
102Partial RevaluationBoolean17-29
103InventoriableBoolean17-29
104Valuation DateDate17-29
105Entry TypeEnum "Cost Entry Type"17-29
106Variance TypeEnum "Cost Variance Type"17-29
148Purchase Amount (Actual)Decimal17-29
149Purchase Amount (Expected)Decimal17-29
150Sales Amount (Expected)Decimal17-29
151Cost Amount (Expected)Decimal17-29
152Cost Amount (Non-Invtbl.)Decimal17-29
156Cost Amount (Expected) (ACY)Decimal17-29
157Cost Amount (Non-Invtbl.)(ACY)Decimal17-29
158Expected Cost Posted to G/LDecimal17-29
159Exp. Cost Posted to G/L (ACY)Decimal17-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
1000Job No.Code[20]17-29
1001Job Task No.Code[20]17-29
1002Job Ledger Entry No.Integer17-29
5402Variant CodeCode[10]17-29
5818AdjustmentBoolean17-29
5819Average Cost ExceptionBoolean17-29
5831Capacity Ledger Entry No.Integer17-29
5832TypeEnum "Capacity Type Journal"17-29
5834No.Code[20]17-29
6602Return Reason CodeCode[10]17-29
6603Item DescriptionText[100]new in 26