JOP-AL

Objects/Tables/Table 5802 Value Entry

Table 5802 Value Entry in 26

, Base Application 26.5.38752.40541, checked

App
Base Application
Namespace
Microsoft.Inventory.Ledger

Fields, 79Keys, 17Procedures, 15Events, 8

Versions171819202122232425262728latest

Source29

Fields, 79

IdNameTypeObsolete
1Entry No.Integer-
2Item No.Code[20]-
3Posting DateDate-
4Item Ledger Entry TypeEnum Item Ledger Entry Type-
5Source No.Code[20]-
6Document No.Code[20]-
7DescriptionText[100]-
8Location CodeCode[10]-
9Inventory Posting GroupCode[20]-
10Source Posting GroupCode[20]-
11Item Ledger Entry No.Integer-
12Valued QuantityDecimal-
13Item Ledger Entry QuantityDecimal-
14Invoiced QuantityDecimal-
15Cost per UnitDecimal-
17Sales Amount (Actual)Decimal-
20Item Register No.Integer-
21SIFT Bucket No.Integer-
22Salespers./Purch. CodeCode[20]-
23Discount AmountDecimal-
24User IDCode[50]-
25Source CodeCode[10]-
28Applies-to EntryInteger-
33Global Dimension 1 CodeCode[20]-
34Global Dimension 2 CodeCode[20]-
41Source TypeEnum Analysis Source Type-
43Cost Amount (Actual)Decimal-
45Cost Posted to G/LDecimal-
46Reason CodeCode[10]-
47Drop ShipmentBoolean-
48Journal Batch NameCode[10]-
57Gen. Bus. Posting GroupCode[20]-
58Gen. Prod. Posting GroupCode[20]-
60Document DateDate-
61External Document No.Code[35]-
68Cost Amount (Actual) (ACY)Decimal-
70Cost Posted to G/L (ACY)Decimal-
72Cost per Unit (ACY)Decimal-
79Document TypeEnum Item Ledger Document Type-
80Document Line No.Integer-
86VAT Reporting DateDate-
90Order TypeEnum Inventory Order Type-
91Order No.Code[20]-
92Order Line No.Integer-
98Expected CostBoolean-
99Item Charge No.Code[20]-
100Valued By Average CostBoolean-
102Partial RevaluationBoolean-
103InventoriableBoolean-
104Valuation DateDate-
105Entry TypeEnum Cost Entry Type-
106Variance TypeEnum Cost Variance Type-
148Purchase Amount (Actual)Decimal-
149Purchase Amount (Expected)Decimal-
150Sales Amount (Expected)Decimal-
151Cost Amount (Expected)Decimal-
152Cost Amount (Non-Invtbl.)Decimal-
156Cost Amount (Expected) (ACY)Decimal-
157Cost Amount (Non-Invtbl.)(ACY)Decimal-
158Expected Cost Posted to G/LDecimal-
159Exp. Cost Posted to G/L (ACY)Decimal-
480Dimension Set IDInteger-
481Shortcut Dimension 3 CodeCode[20]-
482Shortcut Dimension 4 CodeCode[20]-
483Shortcut Dimension 5 CodeCode[20]-
484Shortcut Dimension 6 CodeCode[20]-
485Shortcut Dimension 7 CodeCode[20]-
486Shortcut Dimension 8 CodeCode[20]-
1000Job No.Code[20]-
1001Job Task No.Code[20]-
1002Job Ledger Entry No.Integer-
5402Variant CodeCode[10]-
5818AdjustmentBoolean-
5819Average Cost ExceptionBoolean-
5831Capacity Ledger Entry No.Integer-
5832TypeEnum Capacity Type Journal-
5834No.Code[20]-
6602Return Reason CodeCode[10]-
6603Item DescriptionText[100]-

Keys, 17

NameFieldsObsolete
Key1, clusteredEntry No.-
Key2Item Ledger Entry No., Entry Type-
Key3Item Ledger Entry No., Document No., Document Line No.-
Key5Item No., Posting Date, Item Ledger Entry Type, Entry Type, Variance Type, Item Charge No., Location Code, Variant Code, Global Dimension 1 Code, Global Dimension 2 Code, Source Type, Source No., SIFT Bucket No.-
Key6Document No.-
Key7Item No., Valuation Date, Location Code, Variant Code, SIFT Bucket No.-
Key8Source Type, Source No., Item No., Posting Date, Entry Type, Adjustment, Item Ledger Entry Type-
Key9Item Charge No., Inventory Posting Group, Item No.-
Key10Capacity Ledger Entry No., Entry Type-
Key11Order Type, Order No., Order Line No.-
Key13Job No., Job Task No., Document No.-
Key14Item Ledger Entry Type, Posting Date, Item No., Inventory Posting Group, Dimension Set ID-
Key15Item Ledger Entry No., Valuation Date, Posting Date-
Key16Location Code, Inventory Posting Group-
Key17Item Ledger Entry Type, Order No., Valuation Date-
Key18Item No., Item Ledger Entry Type, Order Type, Order No., Order Line No.-
Key19Document No., Document Line No., Document Type-

Procedures, 15

NameParametersReturnsAccessObsolete
GetLastEntryNo()Integerpublic-
GetValuationDate()Datepublic-
AddCost(Record Inventory Adjustment Buffer)public-
SumCostsTillValuationDate(var Record Value Entry)public-
CalcItemLedgEntryCost(Integer, Boolean)public-
NotInvdRevaluationExists(Integer)Booleanpublic-
CalcQtyFactor(Date, Date)Decimalpublic-
ShowGL()public-
IsAvgCostException(Boolean)BooleanpublicPending 27.0
Moved to the Inventory Adjustment codeunit
ShowDimensions()public-
GetAvgToDate(Date)Datepublic-
GetAvgFromDate(Date, var Record Accounting Period, var Boolean)Datepublic-
FindFirstValueEntryByItemLedgerEntryNo(Integer)public-
IsInbound()Booleanpublic-
GetNextEntryNo()Integerpublic-

Events, 8

KindNameParametersObsolete
Integration eventOnSumCostsTillValuationDateOnAfterGetItem(var Record Item, var Record Value Entry)-
Integration eventOnShowGLOnBeforeCopyToTempGLEntry(var Record G/L Entry, var Record G/L - Item Ledger Relation)-
Integration eventOnBeforeCheckApplyLocationVariantFilters(var Record Value Entry, Record Accounting Period, Record Value Entry, var Boolean, Record Item, Boolean, var Decimal, Date, Date)-
Integration eventOnSumCostsTillValuationDateOnAfterCalcSums(var Record Value Entry)-
Integration eventOnSumCostsTillValuationDateOnAfterSetFilters(var Record Value Entry, var Record Value Entry, var Record Item)-
Integration eventOnSumCostsTillValuationDateOnAfterSetCostAmounts(var Record Value Entry, Record Value Entry, Decimal)-
Integration eventOnBeforeCalcItemLedgEntryCost(var Record Value Entry, Integer, Boolean, var Boolean)-
Integration eventOnBeforeAddCost(var Record Value Entry, Record Inventory Adjustment Buffer)-