| 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 |