Table 5802 Value Entry

Base Application, Microsoft.Inventory.Ledger

Source AL, 996 lines

src/Layers/W1/BaseApp/Inventory/Ledger/ValueEntry.Table.allines 32 to 47 of 996, Copyright (c) Microsoft Corporation. MIT

table 5802 "Value Entry"{    Caption = 'Value Entry';    DrillDownPageID = "Value Entries";    LookupPageID = "Value Entries";    Permissions = TableData "Value Entry" = ri;    DataClassification = CustomerContent;    fields    {        field(1; "Entry No."; Integer)        {            Caption = 'Entry No.';            ToolTip = 'Specifies the number of the entry, as assigned from the specified number series when the entry was created.';        }        field(2; "Item No."; Code[20])

All 996 lines

Fields 79 in 29

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

All 79 fields

Events 8 in 29

[IntegrationEvent] OnSumCostsTillValuationDateOnAfterGetItem(var Item: Record Item; var ValueEntry: Record "Value Entry")17-29
[IntegrationEvent] OnShowGLOnBeforeCopyToTempGLEntry(var GLEntry: Record "G/L Entry"; var GLItemLedgRelation: Record "G/L - Item Ledger Relation")17-29
[IntegrationEvent] OnBeforeCheckApplyLocationVariantFilters(var RecValueEntry: Record "Value Entry"; AccountingPeriod: Record "Accounting Period"; ValueEntry: Record "Value Entry"; var IsHandled: Boolean; Item: Record Item; CostCalcIsChanged: Boolean; var QtyFactor: Decimal; FromDate: Date; ToDate: Date)new in 18
[IntegrationEvent] OnSumCostsTillValuationDateOnAfterCalcSums(var ValueEntry: Record "Value Entry")new in 18
[IntegrationEvent] OnSumCostsTillValuationDateOnAfterSetFilters(var ValueEntryRec: Record "Value Entry"; var ValueEntry: Record "Value Entry"; var Item: Record Item)new in 18
[IntegrationEvent] OnSumCostsTillValuationDateOnAfterSetCostAmounts(var ValueEntry: Record "Value Entry"; PrevValueEntrySum: Record "Value Entry"; QtyFactor: Decimal)new in 19
[IntegrationEvent] OnBeforeCalcItemLedgEntryCost(var ValueEntry: Record "Value Entry"; ItemLedgEntryNo: Integer; Expected: Boolean; var IsHandled: Boolean)new in 22

All 9 events in 17-29

Public procedures 15 in 29

GetLastEntryNo(): Integer17-29
GetValuationDate(): Date17-29
AddCost(InvtAdjmtBuffer: Record "Inventory Adjustment Buffer")17-29
SumCostsTillValuationDate(var ValueEntry: Record "Value Entry")17-29
CalcItemLedgEntryCost(ItemLedgEntryNo: Integer; Expected: Boolean)17-29
NotInvdRevaluationExists(ItemLedgEntryNo: Integer): Boolean17-29

All 16 procedures in 17-29

Extended in Microsoft's apps by 1

tableextension 99000788 "Mfg. Value Entry"Base Applicationnew in 26

Trigger events 10

OnBeforeInsertEvent(var Rec: Record "Value Entry"; RunTrigger: Boolean)
OnAfterInsertEvent(var Rec: Record "Value Entry"; RunTrigger: Boolean)
OnBeforeModifyEvent(var Rec: Record "Value Entry"; var xRec: Record "Value Entry"; RunTrigger: Boolean)
OnAfterModifyEvent(var Rec: Record "Value Entry"; var xRec: Record "Value Entry"; RunTrigger: Boolean)
OnBeforeDeleteEvent(var Rec: Record "Value Entry"; RunTrigger: Boolean)
OnAfterDeleteEvent(var Rec: Record "Value Entry"; RunTrigger: Boolean)
OnBeforeRenameEvent(var Rec: Record "Value Entry"; var xRec: Record "Value Entry"; RunTrigger: Boolean)
OnAfterRenameEvent(var Rec: Record "Value Entry"; var xRec: Record "Value Entry"; RunTrigger: Boolean)
OnBeforeValidateEvent(var Rec: Record "Value Entry"; var xRec: Record "Value Entry"; CurrFieldNo: Integer)
per field, ElementName: field name
OnAfterValidateEvent(var Rec: Record "Value Entry"; var xRec: Record "Value Entry"; CurrFieldNo: Integer)
per field, ElementName: field name

Changes 2 in 28

List17181920212223242526272829
Fields113
Keys165272
Procedures21
Events412
key(Key5; "Item 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.") { IncludedFields = "Invoiced Quantity", "Sales Amount (Expected)", "Sales Amount (Actual)", "Cost Amount (Expected)", "Cost Amount (Actual)", "Cost Amount (Non-Invtbl.)", "Purchase Amount (Actual)", "Expected Cost Posted to G/L", "Cost Posted to G/L", "Item Ledger Entry Quantity"; }17-29changed in 20, 26, 28
changed, was key(Key5; "Item 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.") { IncludedFields = "Invoiced Quantity", "Sales Amount (Expected)", "Sales Amount (Actual)", "Cost Amount (Expected)", "Cost Amount (Actual)", "Cost Amount (Non-Invtbl.)", "Purchase Amount (Actual)", "Expected Cost Posted to G/L", "Cost Posted to G/L", "Item Ledger Entry Quantity"; SumIndexFields = "Invoiced Quantity", "Sales Amount (Expected)", "Sales Amount (Actual)", "Cost Amount (Expected)", "Cost Amount (Actual)", "Cost Amount (Non-Invtbl.)", "Purchase Amount (Actual)", "Expected Cost Posted to G/L", "Cost Posted to G/L", "Item Ledger Entry Quantity"; }
key(Key8; "Source Type", "Source No.", "Item No.", "Posting Date", "Entry Type", Adjustment, "Item Ledger Entry Type") { IncludedFields = "Discount Amount", "Cost Amount (Non-Invtbl.)", "Cost Amount (Actual)", "Cost Amount (Expected)", "Sales Amount (Actual)", "Sales Amount (Expected)", "Invoiced Quantity", "Global Dimension 1 Code", "Global Dimension 2 Code"; }17-29changed in 26, 28
changed, was key(Key8; "Source Type", "Source No.", "Item No.", "Posting Date", "Entry Type", Adjustment, "Item Ledger Entry Type") { IncludedFields = "Discount Amount", "Cost Amount (Non-Invtbl.)", "Cost Amount (Actual)", "Cost Amount (Expected)", "Sales Amount (Actual)", "Sales Amount (Expected)", "Invoiced Quantity"; }

All 38 changes in 17-29