Table 337 Reservation Entry

Base Application, Microsoft.Inventory.Tracking

12 keys

KeyVersions
key(Key1; "Entry No.", Positive) { Clustered = true; }17-29
key(Key2; "Source ID", "Source Ref. No.", "Source Type", "Source Subtype", "Source Batch Name", "Source Prod. Order Line", "Reservation Status", "Shipment Date", "Expected Receipt Date") { IncludedFields = "Quantity (Base)", "Qty. to Handle (Base)", "Serial No.", "Lot No.", "Package No.", "Item No.", Quantity, "Untracked Surplus"; }17-29changed in 21, 23, 24
key(Key3; "Item No.", "Variant Code", "Location Code") { IncludedFields = "Item Tracking"; }17-29changed in 23
key(Key4; "Item No.", "Variant Code", "Location Code", "Reservation Status", "Shipment Date", "Expected Receipt Date", "Serial No.", "Lot No.", "Package No.") { IncludedFields = "Source Type", "Source Subtype", "Quantity (Base)", "Untracked Surplus"; }17-29changed in 18, 21, 23, 24
key(Key5; "Item No.", "Source Type", "Source Subtype", "Reservation Status", "Location Code", "Variant Code", "Shipment Date", "Expected Receipt Date", "Serial No.", "Lot No.", "Package No.") { SumIndexFields = "Quantity (Base)", Quantity; }gone after 20changed in 18
key(Key6; "Item No.", "Variant Code", "Location Code", "Item Tracking", "Reservation Status", "Lot No.", "Serial No.", "Package No.") { SumIndexFields = "Quantity (Base)"; }gone after 20changed in 18
key(Key7; "Lot No.") { Enabled = false; }gone after 17
key(Key8; "Serial No.") { Enabled = false; }gone after 17
key(Key9; "Source Type", "Source Subtype", "Source ID", "Source Batch Name", "Source Prod. Order Line", "Source Ref. No.") { IncludedFields = "Qty. to Handle (Base)", "Item Tracking", "Untracked Surplus"; }17-29changed in 21, 23
key(Key10; "Reservation Status", "Item No.", "Variant Code", "Location Code", "Expected Receipt Date") { IncludedFields = "Quantity (Base)"; }17-29changed in 21
key(Key11; "Serial No.", "Source ID", "Source Ref. No.", "Source Type", "Source Subtype", "Source Batch Name", "Source Prod. Order Line") { IncludedFields = "Reservation Status", "Quantity (Base)", "Lot No.", "Package No.", Binding; }new in 20changed in 23
key(Key12; Positive, "Reservation Status", "Source Type")new in 24