Table 1003 Job Planning Line

Base Application, Microsoft.Projects.Project.Planning

14 keys

KeyVersions
key(Key1; "Job No.", "Job Task No.", "Line No.") { Clustered = true; }17-29
key(Key2; "Job No.", "Job Task No.", "Schedule Line", "Planning Date") { SumIndexFields = "Total Price (LCY)", "Total Cost (LCY)", "Line Amount (LCY)", "Remaining Total Cost (LCY)", "Remaining Line Amount (LCY)", "Total Cost", "Line Amount"; }17-29
key(Key3; "Job No.", "Job Task No.", "Contract Line", "Planning Date") { SumIndexFields = "Total Price (LCY)", "Total Cost (LCY)", "Line Amount (LCY)", "Remaining Total Cost (LCY)", "Remaining Line Amount (LCY)", "Total Cost", "Line Amount"; }17-29
key(Key4; "Job No.", "Job Task No.", "Schedule Line", "Currency Date")17-29
key(Key5; "Job No.", "Job Task No.", "Contract Line", "Currency Date")17-29
key(Key6; "Job No.", "Schedule Line", Type, "No.", "Planning Date") { SumIndexFields = "Quantity (Base)"; }17-29
key(Key7; "Job No.", "Schedule Line", Type, "Resource Group No.", "Planning Date") { SumIndexFields = "Quantity (Base)"; }17-29
key(Key8; Status, "Schedule Line", Type, "No.", "Planning Date") { SumIndexFields = "Quantity (Base)"; }17-29
key(Key9; Status, "Schedule Line", Type, "Resource Group No.", "Planning Date") { SumIndexFields = "Quantity (Base)"; }17-29
key(Key10; "Job No.", "Contract Line")17-29
key(Key11; "Job Contract Entry No.")17-29
key(Key12; Type, "No.", "Job No.", "Job Task No.", "Usage Link", "System-Created Entry")17-29
key(Key13; Status, Type, "No.", "Variant Code", "Location Code", "Planning Date") { SumIndexFields = "Remaining Qty. (Base)"; }17-29
key(Key14; "Job No.", "Planning Date", "Document No.")17-29