Table 1021 Job WIP Total

Base Application, Microsoft.Projects.Project.WIP

src/Layers/W1/BaseApp/Projects/Project/WIP/JobWIPTotal.Table.al201 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.WIP;using Microsoft.Projects.Project.Job;table 1021 "Job WIP Total"{    Caption = 'Project WIP Total';    DrillDownPageID = "Job WIP Totals";    LookupPageID = "Job WIP Totals";    DataClassification = CustomerContent;    fields    {        field(1; "Entry No."; Integer)        {            AutoIncrement = true;            Caption = 'Entry No.';        }        field(2; "Job No."; Code[20])        {            Caption = 'Project No.';            Editable = false;            NotBlank = true;            TableRelation = Job;        }        field(3; "Job Task No."; Code[20])        {            Caption = 'Project Task No.';            ToolTip = 'Specifies the number of the project task that is associated with the project WIP total. The project task number is generally the final task in a group of tasks that is set to Total or the last project task line.';            NotBlank = true;            TableRelation = "Job Task"."Job Task No." where("Job No." = field("Job No."));            ValidateTableRelation = false;        }        field(4; "WIP Method"; Code[20])        {            Caption = 'WIP Method';            ToolTip = 'Specifies the name of the work in process (WIP) calculation method that is associated with a project. The value in the field comes from the WIP method specified on the project card.';            Editable = false;            TableRelation = "Job WIP Method".Code;        }        field(5; "WIP Posting Date"; Date)        {            Caption = 'WIP Posting Date';            ToolTip = 'Specifies the date when work in process (WIP) was last calculated and entered in the Project WIP Entries window.';            Editable = false;        }        field(6; "WIP Posting Date Filter"; Text[250])        {            Caption = 'WIP Posting Date Filter';            Editable = false;        }        field(7; "WIP Planning Date Filter"; Text[250])        {            Caption = 'WIP Planning Date Filter';            Editable = false;        }        field(8; "WIP Warnings"; Boolean)        {            CalcFormula = exist("Job WIP Warning" where("Job WIP Total Entry No." = field("Entry No.")));            Caption = 'WIP Warnings';            ToolTip = 'Specifies if there are WIP warnings associated with a project for which you have calculated WIP.';            FieldClass = FlowField;        }        field(9; "Posted to G/L"; Boolean)        {            Caption = 'Posted to G/L';        }        field(10; "Schedule (Total Cost)"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Budget (Total Cost)';            Editable = false;        }        field(11; "Schedule (Total Price)"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Budget (Total Price)';            Editable = false;        }        field(12; "Usage (Total Cost)"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Usage (Total Cost)';            Editable = false;        }        field(13; "Usage (Total Price)"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Usage (Total Price)';            Editable = false;        }        field(14; "Contract (Total Cost)"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Billable (Total Cost)';            Editable = false;        }        field(15; "Contract (Total Price)"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Billable (Total Price)';            Editable = false;        }        field(16; "Contract (Invoiced Price)"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Billable (Invoiced Price)';            Editable = false;        }        field(17; "Contract (Invoiced Cost)"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Billable (Invoiced Cost)';            Editable = false;        }        field(20; "Calc. Recog. Sales Amount"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Calc. Recog. Sales Amount';            ToolTip = 'Specifies the calculated sum of recognized sales amounts in the current WIP calculation.';            Editable = false;        }        field(21; "Calc. Recog. Costs Amount"; Decimal)        {            AutoFormatType = 1;            AutoFormatExpression = '';            Caption = 'Calc. Recog. Costs Amount';            ToolTip = 'Specifies the calculated sum of recognized costs amounts in the current WIP calculation.';            Editable = false;        }        field(30; "Cost Completion %"; Decimal)        {            AutoFormatType = 0;            DecimalPlaces = 0 : 5;            BlankZero = true;            Caption = 'Cost Completion %';            ToolTip = 'Specifies the cost completion percentage for project tasks that have been budgeted in the current WIP calculation.';            Editable = false;        }        field(31; "Invoiced %"; Decimal)        {            AutoFormatType = 0;            DecimalPlaces = 0 : 5;            BlankZero = true;            Caption = 'Invoiced %';            ToolTip = 'Specifies the percentage of contracted project tasks that have been invoiced in the current WIP calculation.';            Editable = false;        }    }    keys    {        key(Key1; "Entry No.")        {            Clustered = true;        }        key(Key2; "Job No.", "Job Task No.")        {        }        key(Key3; "Job No.", "Posted to G/L")        {            SumIndexFields = "Calc. Recog. Sales Amount", "Calc. Recog. Costs Amount";        }    }    fieldgroups    {    }    trigger OnDelete()    var        JobWIPWarning: Record "Job WIP Warning";    begin        JobWIPWarning.DeleteEntries(Rec);    end;    procedure DeleteEntriesForJobTask(JobTask: Record "Job Task")    begin        SetCurrentKey("Job No.", "Job Task No.");        SetRange("Job No.", JobTask."Job No.");        SetRange("Job Task No.", JobTask."Job Task No.");        SetRange("Posted to G/L", false);        if not IsEmpty() then            DeleteAll(true);    end;}