Table 5406 Prod. Order Line

Base Application, Microsoft.Manufacturing.Document

12 keys

KeyVersions
key(Key1; Status, "Prod. Order No.", "Line No.") { Clustered = true; }17-29
key(Key2; "Prod. Order No.", "Line No.", Status)17-29
key(Key3; Status, "Item No.", "Variant Code", "Location Code", "Ending Date") { SumIndexFields = "Remaining Qty. (Base)", "Cost Amount"; }17-29
key(Key4; Status, "Item No.", "Variant Code", "Location Code", "Starting Date") { SumIndexFields = "Remaining Qty. (Base)"; }17-29
key(Key5; Status, "Item No.", "Variant Code", "Location Code", "Due Date") { SumIndexFields = "Remaining Qty. (Base)"; }17-29
key(Key6; Status, "Item No.", "Variant Code", "Shortcut Dimension 1 Code", "Shortcut Dimension 2 Code", "Location Code", "Due Date") { Enabled = false; SumIndexFields = "Remaining Qty. (Base)"; }17-29
key(Key7; Status, "Prod. Order No.", "Item No.")17-29
key(Key8; Status, "Prod. Order No.", "Routing No.", "Routing Reference No.") { SumIndexFields = Quantity, "Finished Quantity"; }17-29
key(Key9; Status, "Prod. Order No.", "Planning Level Code")17-29
key(Key10; "Planning Level Code", Priority) { Enabled = false; }17-29
key(Key11; "Item No.", "Variant Code", "Location Code", Status, "Ending Date") { SumIndexFields = "Remaining Qty. (Base)"; }17-29
key(Key12; "Item No.", "Variant Code", "Location Code", Status, "Due Date") { SumIndexFields = "Remaining Qty. (Base)"; }17-29