Table 5410 Prod. Order Capacity Need

Base Application, Microsoft.Manufacturing.Document

13 keys

KeyVersions
key(Key1; Status, "Prod. Order No.", "Requested Only", "Routing No.", "Routing Reference No.", "Operation No.", "Line No.") { Clustered = true; }17-29
key(Key2; "Prod. Order No.", "Routing No.", "Routing Reference No.", "Operation No.", Status, "Line No.", "Requested Only")17-29
key(Key3; Status, "Prod. Order No.", Active, "Requested Only", "Routing No.")17-29
key(Key4; "Work Center No.", Date, Active, "Starting Date-Time") { IncludedFields = "Allocated Time", "Needed Time"; }17-29changed in 22
key(Key5; "Work Center Group Code", Date, "Starting Date-Time") { IncludedFields = "Allocated Time"; }17-29changed in 22
key(Key6; Type, "No.", Date, Active) { IncludedFields = "Allocated Time"; }17-29changed in 22
key(Key7; Type, "No.", "Starting Date-Time", "Ending Date-Time", Active)17-29
key(Key8; Type, "No.", "Ending Date-Time", "Starting Date-Time", Active)17-29
key(Key9; "Worksheet Template Name", "Worksheet Batch Name", "Worksheet Line No.", "Operation No.") { IncludedFields = "Allocated Time"; }17-29changed in 22
key(Key10; Status, "Prod. Order No.", "Routing Reference No.", "Operation No.", Date, "Starting Time")17-29
key(Key11; "Worksheet Template Name", "Worksheet Batch Name", "Worksheet Line No.", "Operation No.", Date, "Starting Time")17-29
key(Key12; "Worksheet Line No.", "Operation No.")17-29
key(Key13; Status, "Prod. Order No.", Type, "No.", "Work Center No.", Date, "Requested Only") { IncludedFields = "Allocated Time", "Needed Time"; }17-29changed in 22