Table 32 Item Ledger Entry

Base Application, Microsoft.Inventory.Ledger

19 keys

KeyVersions
key(Key1; "Entry No.") { Clustered = true; }17-29
key(Key2; "Item No.", "SIFT Bucket No.") { SumIndexFields = "Invoiced Quantity", Quantity; }17-29changed in 26
key(Key3; "Item No.", "Posting Date") { IncludedFields = Quantity, "Location Code"; }17-29changed in 24
key(Key4; "Item No.", "Entry Type", "Variant Code", "Drop Shipment", "Location Code", "Posting Date", "SIFT Bucket No.") { SumIndexFields = Quantity, "Invoiced Quantity"; }17-29changed in 26
key(Key5; "Source Type", "Source No.", "Item No.", "Variant Code", "Posting Date") { IncludedFields = Quantity; }17-29changed in 26
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
key(Key7; "Location Code", "Item No.", "Variant Code", Open, Positive) { IncludedFields = Quantity, "Remaining Quantity"; }17-21, 28-29changed in 18
key(Key8; "Country/Region Code", "Entry Type", "Posting Date")17-29
key(Key9; "Document No.", "Document Type", "Document Line No.") { IncludedFields = "Entry Type", "Item No.", Correction; }17-29changed in 23, 24
key(Key12; "Order Type", "Order No.", "Order Line No.", "Entry Type", "Prod. Order Comp. Line No.") { IncludedFields = Quantity, "Posting Date", Positive, "Applies-to Entry"; }17-29changed in 21, 23
key(Key13; "Item No.", "Applied Entry to Adjust")17-29
key(Key14; "Item No.", Positive, "Location Code", "Variant Code")17-29
key(Key17; "Item No.", Open, "Variant Code", Positive, "Lot No.", "Serial No.", "Package No.") { IncludedFields = "Remaining Quantity"; }17-29changed in 18, 21
key(Key19; "Lot No.")17-29
key(Key20; "Serial No.", "Item No.", Open, "Variant Code", Positive, "Location Code", "Posting Date")17-29changed in 20
key(Key21; "Entry Type", "Item No.", "Variant Code", "Source Type", "Source No.", "Posting Date")17-29
key(Key22; "Item No.", "Variant Code", "Location Code", "Posting Date")17-29
key(Key23; SystemModifiedAt)new in 18
key(Key25; "Entry Type", "Item No.")new in 24