Table 1020 Job Usage Link

Base Application, Microsoft.Projects.Project.Job

src/Layers/W1/BaseApp/Projects/Project/Job/JobUsageLink.Table.al72 lines, Copyright (c) Microsoft Corporation. MIT

// ------------------------------------------------------------------------------------------------// Copyright (c) Microsoft Corporation. All rights reserved.// Licensed under the MIT License. See License.txt in the project root for license information.// ------------------------------------------------------------------------------------------------namespace Microsoft.Projects.Project.Job;using Microsoft.Projects.Project.Ledger;using Microsoft.Projects.Project.Planning;table 1020 "Job Usage Link"{    Caption = 'Project Usage Link';    DataClassification = CustomerContent;    fields    {        field(1; "Job No."; Code[20])        {            Caption = 'Project No.';            TableRelation = Job;        }        field(2; "Job Task No."; Code[20])        {            Caption = 'Project Task No.';            TableRelation = "Job Task"."Job Task No." where("Job No." = field("Job No."));        }        field(3; "Line No."; Integer)        {            Caption = 'Line No.';            TableRelation = "Job Planning Line"."Line No." where("Job No." = field("Job No."),                                                                  "Job Task No." = field("Job Task No."));        }        field(4; "Entry No."; Integer)        {            Caption = 'Entry No.';        }        field(5; "External Id"; Guid)        {            DataClassification = SystemMetadata;            Caption = 'External Id';        }    }    keys    {        key(Key1; "Job No.", "Job Task No.", "Line No.", "Entry No.")        {            Clustered = true;        }        key(Key2; "External Id")        {        }    }    fieldgroups    {    }    procedure Create(JobPlanningLine: Record "Job Planning Line"; JobLedgerEntry: Record "Job Ledger Entry")    begin        if Get(JobPlanningLine."Job No.", JobPlanningLine."Job Task No.", JobPlanningLine."Line No.", JobLedgerEntry."Entry No.") then            exit;        Validate("Job No.", JobPlanningLine."Job No.");        Validate("Job Task No.", JobPlanningLine."Job Task No.");        Validate("Line No.", JobPlanningLine."Line No.");        Validate("Entry No.", JobLedgerEntry."Entry No.");        Insert(true);    end;}