Table extension 6260 Sust. Job Task

Sustainability, Microsoft.Sustainability.Job

src/Apps/W1/Sustainability/app/src/Job/SustJobTask.TableExt.al55 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.Sustainability.Job;using Microsoft.Projects.Project.Job;using Microsoft.Sustainability.Ledger;using Microsoft.Sustainability.Setup;tableextension 6260 "Sust. Job Task" extends "Job Task"{    fields    {        field(6210; "Resource (Total CO2e)"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Sustainability Value Entry"."CO2e Amount (Actual)" where("Job No." = field("Job No."), "Job Task No." = field("Job Task No."), Type = const(Resource)));            Caption = 'Resource (Total CO2e)';            Editable = false;            FieldClass = FlowField;        }        field(6211; "Item (Total CO2e)"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Sustainability Value Entry"."CO2e Amount (Actual)" where("Job No." = field("Job No."), "Job Task No." = field("Job Task No."), Type = const(Item)));            Caption = 'Item (Total CO2e)';            Editable = false;            FieldClass = FlowField;        }        field(6212; "G/L Account (Total CO2e)"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Sustainability Value Entry"."CO2e Amount (Actual)" where("Job No." = field("Job No."), "Job Task No." = field("Job Task No."), Type = const("G/L Account")));            Caption = 'G/L Account (Total CO2e)';            Editable = false;            FieldClass = FlowField;        }        field(6213; "Total CO2e"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Sustainability Value Entry"."CO2e Amount (Actual)" where("Job No." = field("Job No."), "Job Task No." = field("Job Task No.")));            Caption = 'Total CO2e';            Editable = false;            FieldClass = FlowField;        }    }    var        SustainabilitySetup: Record "Sustainability Setup";}