Table 32 Item Ledger Entry

Base Application, Microsoft.Inventory.Ledger

Source AL, 1,341 lines

src/Layers/W1/BaseApp/Inventory/Ledger/ItemLedgerEntry.Table.allines 29 to 44 of 1,341, Copyright (c) Microsoft Corporation. MIT

table 32 "Item Ledger Entry"{    Caption = 'Item Ledger Entry';    DrillDownPageID = "Item Ledger Entries";    LookupPageID = "Item Ledger Entries";    Permissions = TableData "Item Ledger Entry" = rimd;    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 1,341 lines

Fields 85 in 29

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

All 87 fields in 17-29

Events 24 in 29

[IntegrationEvent] OnAfterClearTrackingFilter(var ItemLedgerEntry: Record "Item Ledger Entry")17-29
[IntegrationEvent] OnAfterCopyTrackingFromItemJnlLine(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemJnlLine: Record "Item Journal Line")17-29
[IntegrationEvent] OnAfterCopyTrackingFromNewItemJnlLine(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemJnlLine: Record "Item Journal Line")17-29
[IntegrationEvent] OnAfterFilterLinesForTracking(var ItemLedgerEntry: Record "Item Ledger Entry"; CalcReservEntry: Record "Reservation Entry"; Positive: Boolean)17-29
[IntegrationEvent] OnAfterSetReservationFilters(var ReservEntry: Record "Reservation Entry"; ItemLedgerEntry: Record "Item Ledger Entry")17-29
[IntegrationEvent] OnAfterSetTrackingFilterFromItemLedgEntry(var ItemLedgerEntry: Record "Item Ledger Entry"; FromItemLedgerEntry: Record "Item Ledger Entry")17-29
[IntegrationEvent] OnAfterSetTrackingFilterFromItemJournalLine(var ItemLedgerEntry: Record "Item Ledger Entry"; ItemJournalLine: Record "Item Journal Line")17-29

All 26 events in 17-29

Public procedures 44 in 29

GetLastEntryNo(): Integer17-29
ShowReservationEntries(Modal: Boolean)17-29
SetAppliedEntryToAdjust(AppliedEntryToAdjust: Boolean)17-29
SetAvgTransCompletelyInvoiced(): Boolean17-29
SetCompletelyInvoiced()17-29
IsOutbndConsump(): Boolean17-29

All 48 procedures in 17-29

Extended in Microsoft's apps by 3

tableextension 6261 "Sust. Item Ledger Entry"Sustainabilitynew in 27
tableextension 20500 "Subc. Item Ledger Entry"Subcontractingnew in 28
tableextension 99000787 "Mfg. Item Ledger Entry"Base Applicationnew in 26

Trigger events 10

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

Changes 2 in 28

List17181920212223242526272829
Fields2162
Keys5183342
Procedures2221214
Events41512
key(Key6; "Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date") { IncludedFields = "Job No.", "Job Task No.", "Document Type", "Document No.", "Order Type", "Order No.", "Serial No.", "Lot No.", "Package No.", Quantity, "Remaining Quantity"; }17-29changed in 23, 26, 28
changed, was key(Key6; "Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date", "SIFT Bucket No.") { IncludedFields = "Job No.", "Job Task No.", "Document Type", "Document No.", "Order Type", "Order No.", "Serial No.", "Lot No.", "Package No."; SumIndexFields = Quantity, "Remaining Quantity"; }
key(Key7; "Location Code", "Item No.", "Variant Code", Open, Positive) { IncludedFields = Quantity, "Remaining Quantity"; }17-20, 28-29changed in 18
added

All 64 changes in 17-29