Table 5950 Service Order Allocation

Base Application, Microsoft.Service.Document

6 keys

KeyVersions
key(Key1; "Entry No.") { Clustered = true; }17-29
key(Key2; Status, "Document Type", "Document No.", "Service Item Line No.", "Allocation Date", "Starting Time", Posted) { SumIndexFields = "Allocated Hours"; }17-29
key(Key3; "Document Type", "Document No.", Status, "Resource Group No.", "Allocation Date", "Starting Time", Posted) { SumIndexFields = "Allocated Hours"; }17-29
key(Key4; Status, "Document Type", "Document No.", "Service Item Line No.", "Resource No.", "Allocation Date", "Starting Time", Posted) { SumIndexFields = "Allocated Hours"; }17-29
key(Key5; "Document Type", "Document No.", "Service Item Line No.", "Allocation Date", "Starting Time", Posted) { SumIndexFields = "Allocated Hours"; }17-29
key(Key6; "Resource No.", "Document Type", "Allocation Date", Status, Posted)17-29