Table 6219 Sustainability Goal

Sustainability, Microsoft.Sustainability.Scorecard

src/Apps/W1/Sustainability/app/src/Scorecard/SustainabilityGoal.Table.al476 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.Sustainability.Scorecard;using Microsoft.Foundation.Address;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Location;using Microsoft.Sustainability.Ledger;using Microsoft.Sustainability.Setup;using System.Security.User;table 6219 "Sustainability Goal"{    Caption = 'Sustainability Goal';    DataClassification = CustomerContent;    DrillDownPageId = "Sustainability Goals";    LookupPageId = "Sustainability Goals";    fields    {        field(1; "No."; Code[20])        {            Caption = 'No.';            trigger OnValidate()            begin                if Rec."No." <> xRec."No." then begin                    Rec.TestField("Scorecard No.");                    UpdateScorecardInformation(Rec."Scorecard No.");                end;            end;        }        field(2; "Scorecard No."; Code[20])        {            Caption = 'Scorecard No.';            TableRelation = "Sustainability Scorecard"."No.";            NotBlank = true;            trigger OnValidate()            begin                if Rec."Scorecard No." <> xRec."Scorecard No." then                    UpdateScorecardInformation(Rec."Scorecard No.");            end;        }        field(3; "Line No."; Integer)        {            Caption = 'Line No.';        }        field(4; "Name"; Text[100])        {            Caption = 'Name';        }        field(5; "Owner"; Code[50])        {            Caption = 'Owner';            TableRelation = "User Setup"."User ID" where("Sustainability Manager" = const(true));        }        field(6; "Country/Region Code"; Code[10])        {            Caption = 'Country/Region Code';            TableRelation = "Country/Region";        }        field(7; "Responsibility Center"; Code[10])        {            Caption = 'Responsibility Center';            TableRelation = "Responsibility Center";        }        field(8; "Start Date"; Date)        {            Caption = 'Start Date';            trigger OnValidate()            begin                if (Rec."Start Date" > Rec."End Date") and (Rec."End Date" <> 0D) then                    Error(InvalidStartAndEndDateErr, Rec.FieldCaption("Start Date"), Rec.FieldCaption("End Date"));                if Rec."Start Date" <> 0D then begin                    Rec.TestField("Baseline Start Date");                    Rec.TestField("Baseline End Date");                end;                ValidateBaselineWithCurrentDateFilter(Rec."Start Date", Rec."End Date");            end;        }        field(9; "End Date"; Date)        {            Caption = 'End Date';            trigger OnValidate()            begin                Rec.Validate("Start Date");                if Rec."End Date" <> 0D then begin                    Rec.TestField("Start Date");                    Rec.TestField("Baseline Start Date");                    Rec.TestField("Baseline End Date");                end;                ValidateBaselineWithCurrentDateFilter(Rec."Start Date", Rec."End Date");            end;        }        field(10; "Baseline Period"; Date)        {            Caption = 'Baseline Period';            FieldClass = FlowFilter;            Editable = false;        }        field(11; "Current Period Filter"; Date)        {            Caption = 'Current Period Filter';            FieldClass = FlowFilter;            Editable = false;        }#pragma warning disable AA0232        field(12; "Baseline for CO2"; Decimal)#pragma warning restore AA0232        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'Baseline for CO2';            CaptionClass = '102,7,1';            FieldClass = FlowField;            CalcFormula = sum("Sustainability Ledger Entry"."Emission CO2" where("Posting Date" = field("Baseline Period"), "Country/Region Code" = field("Country/Region Code Filter"), "Responsibility Center" = field("Responsibility Center Filter")));            Editable = false;        }        field(13; "Baseline for CH4"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'Baseline for CH4';            CaptionClass = '102,7,2';            FieldClass = FlowField;            CalcFormula = sum("Sustainability Ledger Entry"."Emission CH4" where("Posting Date" = field("Baseline Period"), "Country/Region Code" = field("Country/Region Code Filter"), "Responsibility Center" = field("Responsibility Center Filter")));            Editable = false;        }        field(14; "Baseline for N2O"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'Baseline for N2O';            CaptionClass = '102,7,3';            FieldClass = FlowField;            CalcFormula = sum("Sustainability Ledger Entry"."Emission N2O" where("Posting Date" = field("Baseline Period"), "Country/Region Code" = field("Country/Region Code Filter"), "Responsibility Center" = field("Responsibility Center Filter")));            Editable = false;        }        field(15; "Current Value for CO2"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            FieldClass = FlowField;            CalcFormula = sum("Sustainability Ledger Entry"."Emission CO2" where("Posting Date" = field("Current Period Filter"), "Country/Region Code" = field("Country/Region Code Filter"), "Responsibility Center" = field("Responsibility Center Filter")));            Editable = false;            Caption = 'Current Value for CO2';            CaptionClass = '102,8,1';        }        field(16; "Current Value for CH4"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            FieldClass = FlowField;            CalcFormula = sum("Sustainability Ledger Entry"."Emission CH4" where("Posting Date" = field("Current Period Filter"), "Country/Region Code" = field("Country/Region Code Filter"), "Responsibility Center" = field("Responsibility Center Filter")));            Editable = false;            Caption = 'Current Value for CH4';            CaptionClass = '102,8,2';        }        field(17; "Current Value for N2O"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            FieldClass = FlowField;            CalcFormula = sum("Sustainability Ledger Entry"."Emission N2O" where("Posting Date" = field("Current Period Filter"), "Country/Region Code" = field("Country/Region Code Filter"), "Responsibility Center" = field("Responsibility Center Filter")));            Editable = false;            Caption = 'Current Value for N2O';            CaptionClass = '102,8,3';        }        field(18; "Unit of Measure"; Code[10])        {            Caption = 'Unit of Measure';            TableRelation = "Unit of Measure";        }        field(19; "Target Value for CO2"; Decimal)        {            AutoFormatType = 0;            Caption = 'Target Value for CO2';            CaptionClass = '102,9,1';        }        field(20; "Target Value for CH4"; Decimal)        {            AutoFormatType = 0;            Caption = 'Target Value for CH4';            CaptionClass = '102,9,2';        }        field(21; "Target Value for N2O"; Decimal)        {            AutoFormatType = 0;            Caption = 'Target Value for N2O';            CaptionClass = '102,9,3';        }        field(22; "Main Goal"; Boolean)        {            Caption = 'Main Goal';            trigger OnValidate()            begin                if Rec."Main Goal" then                    ValidateIfMainGoalIsAlreadyMarked();            end;        }        field(23; "Baseline Start Date"; Date)        {            Caption = 'Baseline Start Date';            trigger OnValidate()            begin                if (Rec."Baseline Start Date" > Rec."Baseline End Date") and (Rec."Baseline End Date" <> 0D) then                    Error(InvalidStartAndEndDateErr, Rec.FieldCaption("Baseline Start Date"), Rec.FieldCaption("Baseline End Date"));                ValidateBaselineWithCurrentDateFilter(Rec."Start Date", Rec."End Date");            end;        }        field(24; "Baseline End Date"; Date)        {            Caption = 'Baseline End Date';            trigger OnValidate()            begin                Rec.Validate("Baseline Start Date");                ValidateBaselineWithCurrentDateFilter(Rec."Start Date", Rec."End Date");            end;        }        field(25; "Country/Region Code Filter"; Code[10])        {            Caption = 'Country/Region Code Filter';            FieldClass = FlowFilter;            TableRelation = "Country/Region";        }        field(26; "Responsibility Center Filter"; Code[10])        {            Caption = 'Responsibility Center Filter';            FieldClass = FlowFilter;            TableRelation = "Responsibility Center";        }        field(27; "Baseline for Water Intensity"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'Baseline for Water Intensity';            FieldClass = FlowField;            CalcFormula = sum("Sustainability Ledger Entry"."Water Intensity" where("Posting Date" = field("Baseline Period"), "Country/Region Code" = field("Country/Region Code Filter"), "Responsibility Center" = field("Responsibility Center Filter")));            Editable = false;        }        field(28; "Baseline for Waste Intensity"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Caption = 'Baseline for Waste Intensity';            FieldClass = FlowField;            CalcFormula = sum("Sustainability Ledger Entry"."Waste Intensity" where("Posting Date" = field("Baseline Period"), "Country/Region Code" = field("Country/Region Code Filter"), "Responsibility Center" = field("Responsibility Center Filter")));            Editable = false;        }        field(29; "Current Value for Water Int."; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            FieldClass = FlowField;            CalcFormula = sum("Sustainability Ledger Entry"."Water Intensity" where("Posting Date" = field("Current Period Filter"), "Country/Region Code" = field("Country/Region Code Filter"), "Responsibility Center" = field("Responsibility Center Filter")));            Editable = false;            Caption = 'Current Value for Water Intensity';        }        field(30; "Current Value for Waste Int."; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            FieldClass = FlowField;            CalcFormula = sum("Sustainability Ledger Entry"."Waste Intensity" where("Posting Date" = field("Current Period Filter"), "Country/Region Code" = field("Country/Region Code Filter"), "Responsibility Center" = field("Responsibility Center Filter")));            Editable = false;            Caption = 'Current Value for Waste Intensity';        }        field(31; "Target Value for Water Int."; Decimal)        {            AutoFormatType = 0;            Caption = 'Target Value for Water Intensity';        }        field(32; "Target Value for Waste Int."; Decimal)        {            AutoFormatType = 0;            Caption = 'Target Value for Waste Intensity';        }    }    keys    {        key(Key1; "Scorecard No.", "No.", "Line No.")        {            Clustered = true;        }    }    trigger OnInsert()    begin        SustainabilitySetup.Get();        Rec.Validate("Unit of Measure", SustainabilitySetup."Emission Unit of Measure Code");    end;    local procedure ValidateIfMainGoalIsAlreadyMarked()    var        SustainabilityGoal: Record "Sustainability Goal";    begin        SustainabilityGoal.SetRange("Main Goal", true);        if SustainabilityGoal.FindFirst() then            Error(CanOnlyHaveOneMainGoalErr, SustainabilityGoal."Scorecard No.", SustainabilityGoal.Owner);    end;    local procedure UpdateScorecardInformation(ScorecardNo: Code[20])    var        SustainabilityScorecard: Record "Sustainability Scorecard";    begin        if ScorecardNo <> '' then begin            SustainabilityScorecard.Get(ScorecardNo);            Rec.Validate(Owner, SustainabilityScorecard.Owner);        end else            Rec.Validate(Owner, '');    end;    local procedure ValidateBaselineWithCurrentDateFilter(CurrentPeriodStartDate: Date; CurrentPeriodEndDate: Date)    begin        if (CurrentPeriodStartDate = 0D) or (CurrentPeriodEndDate = 0D) then            exit;        if (CurrentPeriodStartDate >= Rec."Baseline Start Date") and (CurrentPeriodStartDate <= Rec."Baseline End Date") then            Error(StartDateErr, CurrentPeriodStartDate, Rec."Baseline Start Date", Rec."Baseline End Date");        if (CurrentPeriodEndDate >= Rec."Baseline Start Date") and (CurrentPeriodEndDate <= Rec."Baseline End Date") then            Error(EndDateErr, CurrentPeriodStartDate, Rec."Baseline Start Date", Rec."Baseline End Date");        if (Rec."Baseline Start Date" >= CurrentPeriodStartDate) and (Rec."Baseline Start Date" <= CurrentPeriodEndDate) then            Error(StartDateErr, CurrentPeriodStartDate, Rec."Baseline Start Date", Rec."Baseline End Date");        if (Rec."Baseline End Date" >= CurrentPeriodStartDate) and (Rec."Baseline End Date" <= CurrentPeriodEndDate) then            Error(EndDateErr, CurrentPeriodStartDate, Rec."Baseline Start Date", Rec."Baseline End Date");    end;    procedure UpdateCurrentDateFilter(StartDate: Date; EndDate: Date)    begin        case true of            (StartDate = 0D) and (EndDate <> 0D):                Rec.SetFilter("Current Period Filter", '..%1', EndDate);            (StartDate <> 0D) and (EndDate = 0D):                Rec.SetFilter("Current Period Filter", '%1..', StartDate);            else                Rec.SetFilter("Current Period Filter", '%1..%2', StartDate, EndDate);        end;    end;    procedure UpdateBaselineDateFilter(StartDate: Date; EndDate: Date)    begin        case true of            (StartDate = 0D) and (EndDate <> 0D):                Rec.SetFilter("Baseline Period", '..%1', EndDate);            (StartDate <> 0D) and (EndDate = 0D):                Rec.SetFilter("Baseline Period", '%1..', StartDate);            else                Rec.SetFilter("Baseline Period", '%1..%2', StartDate, EndDate);        end;    end;    procedure UpdateFlowFiltersOnRecord()    begin        Rec.SetRange("Country/Region Code Filter");        Rec.SetRange("Responsibility Center Filter");        if Rec."Country/Region Code" <> '' then            Rec.SetRange("Country/Region Code Filter", Rec."Country/Region Code");        if Rec."Responsibility Center" <> '' then            Rec.SetRange("Country/Region Code Filter", Rec."Responsibility Center");    end;    procedure ApplyOwnerFilter(var SustainabilityGoal: Record "Sustainability Goal")    begin        SustainabilityGoal.SetRange(Owner, UserId());        if SustainabilityGoal.FindSet() then;    end;    procedure RemoveOwnerFilter(var SustainabilityGoal: Record "Sustainability Goal")    begin        SustainabilityGoal.SetRange(Owner);        if SustainabilityGoal.FindSet() then;    end;    procedure RunSustainabilityGoalsFromScorecard(SustainabilityScore: Record "Sustainability Scorecard")    var        SustainabilityGoal: Record "Sustainability Goal";        SustainabilityGoals: Page "Sustainability Goals";    begin        SustainabilityGoal.SetRange("Scorecard No.", SustainabilityScore."No.");        SustainabilityGoals.SetCalledFromScorecard(true);        SustainabilityGoals.SetTableView(SustainabilityGoal);        SustainabilityGoals.Run();    end;    procedure DrillDownSustLedgerEntries(SustainabilityGoal: Record "Sustainability Goal")    var        SustainabilityLedgEntry: Record "Sustainability Ledger Entry";    begin        SustainabilityLedgEntry.SetRange("Posting Date", SustainabilityGoal."Start Date", SustainabilityGoal."End Date");        Page.Run(Page::"Sustainability Ledger Entries", SustainabilityLedgEntry);    end;    procedure DrillDownSustLedgerEntriesForBaseline(SustainabilityGoal: Record "Sustainability Goal")    var        SustainabilityLedgEntry: Record "Sustainability Ledger Entry";    begin        if SustainabilityGoal."Country/Region Code" <> '' then            SustainabilityLedgEntry.SetRange("Country/Region Code", SustainabilityGoal."Country/Region Code");        if SustainabilityGoal."Responsibility Center" <> '' then            SustainabilityLedgEntry.SetRange("Responsibility Center", SustainabilityGoal."Responsibility Center");        case true of            (SustainabilityGoal."Baseline Start Date" = 0D) and (SustainabilityGoal."Baseline End Date" <> 0D):                SustainabilityLedgEntry.SetFilter("Posting Date", '..%1', SustainabilityGoal."Baseline End Date");            (SustainabilityGoal."Baseline Start Date" <> 0D) and (SustainabilityGoal."Baseline End Date" = 0D):                SustainabilityLedgEntry.SetFilter("Posting Date", '%1..', SustainabilityGoal."Baseline Start Date");            else                SustainabilityLedgEntry.SetFilter("Posting Date", '%1..%2', SustainabilityGoal."Baseline Start Date", SustainabilityGoal."Baseline End Date");        end;        Page.Run(Page::"Sustainability Ledger Entries", SustainabilityLedgEntry);    end;    procedure UpdateCurrentEmissionValues(var SustainabilityGoals: Record "Sustainability Goal")    var        SustainabilityGoals2: Record "Sustainability Goal";    begin        SustainabilityGoals."Current Value for CO2" := 0;        SustainabilityGoals."Current Value for CH4" := 0;        SustainabilityGoals."Current Value for N2O" := 0;        SustainabilityGoals."Current Value for Water Int." := 0;        SustainabilityGoals."Current Value for Waste Int." := 0;        SustainabilityGoals."Baseline for CO2" := 0;        SustainabilityGoals."Baseline for CH4" := 0;        SustainabilityGoals."Baseline for N2O" := 0;        SustainabilityGoals."Baseline for Water Intensity" := 0;        SustainabilityGoals."Baseline for Waste Intensity" := 0;        if not SustainabilityGoals2.Get(SustainabilityGoals."Scorecard No.", SustainabilityGoals."No.", SustainabilityGoals."Line No.") then            exit;        SustainabilityGoals2.UpdateCurrentDateFilter(SustainabilityGoals."Start Date", SustainabilityGoals."End Date");        SustainabilityGoals2.UpdateBaselineDateFilter(SustainabilityGoals."Baseline Start Date", SustainabilityGoals."Baseline End Date");        SustainabilityGoals2.UpdateFlowFiltersOnRecord();        SustainabilityGoals2.CalcFields("Current Value for CO2", "Current Value for CH4", "Current Value for N2O", "Current Value for Water Int.", "Current Value for Waste Int.");        SustainabilityGoals2.CalcFields("Baseline for CO2", "Baseline for CH4", "Baseline for N2O", "Baseline for Water Intensity", "Baseline for Waste Intensity");        SustainabilityGoals."Current Value for CO2" := SustainabilityGoals2."Current Value for CO2";        SustainabilityGoals."Current Value for CH4" := SustainabilityGoals2."Current Value for CH4";        SustainabilityGoals."Current Value for N2O" := SustainabilityGoals2."Current Value for N2O";        SustainabilityGoals."Current Value for Water Int." := SustainabilityGoals2."Current Value for Water Int.";        SustainabilityGoals."Current Value for Waste Int." := SustainabilityGoals2."Current Value for Waste Int.";        SustainabilityGoals."Baseline for CO2" := SustainabilityGoals2."Baseline for CO2";        SustainabilityGoals."Baseline for CH4" := SustainabilityGoals2."Baseline for CH4";        SustainabilityGoals."Baseline for N2O" := SustainabilityGoals2."Baseline for N2O";        SustainabilityGoals."Baseline for Water Intensity" := SustainabilityGoals2."Baseline for Water Intensity";        SustainabilityGoals."Baseline for Waste Intensity" := SustainabilityGoals2."Baseline for Waste Intensity";    end;    var        SustainabilitySetup: Record "Sustainability Setup";        CanOnlyHaveOneMainGoalErr: Label 'Main is already selected for Scorecard No.: %1 and Owner: %2.', Comment = '%1 - Scorecard No., %2 - Owner';        InvalidStartAndEndDateErr: Label '%1 cannot be after %2', Comment = '%1 - Start Date, %2 - End Date';        StartDateErr: Label 'Start Date : %1 of Current Period cannot overlap with Baseline Period : %2..%3', Comment = '%1 - Start Date of Current Period, %2 - Baseline Period Start Date, %3 - Baseline Period End Date';        EndDateErr: Label 'End Date : %1 of Current Period cannot overlap with Baseline Period : %2..%3', Comment = '%1 - End Date of Current Period, %2 - Baseline Period Start Date, %3 - Baseline Period End Date';}