Table extension 6217 Sust. Purch. Inv. Header

Sustainability, Microsoft.Sustainability.Purchase

src/Apps/W1/Sustainability/app/src/Purchase/SustPurchInvHeader.TableExt.al64 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.Sustainability.Purchase;using Microsoft.Purchases.History;using Microsoft.Sustainability.Ledger;using Microsoft.Sustainability.Setup;tableextension 6217 "Sust. Purch. Inv. Header" extends "Purch. Inv. Header"{    fields    {        field(6210; "Sustainability Lines Exist"; Boolean)        {            Caption = 'Sustainability Lines Exist';            Editable = false;            FieldClass = FlowField;            CalcFormula = exist("Purch. Inv. Line" where("Sust. Account No." = filter('<>'''''), "Document No." = field("No.")));        }#pragma warning disable AA0232        field(6211; "Emission C02"; Decimal)#pragma warning restore AA0232        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Sustainability Ledger Entry"."Emission CO2" where("Document No." = field("No."), "Document Type" = filter(Invoice | "GHG Credit")));            Caption = 'Emission CO2';            CaptionClass = '102,6,1';            Editable = false;            FieldClass = FlowField;        }        field(6212; "Emission CH4"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Sustainability Ledger Entry"."Emission CH4" where("Document No." = field("No."), "Document Type" = filter(Invoice | "GHG Credit")));            Caption = 'Emission CH4';            CaptionClass = '102,6,2';            Editable = false;            FieldClass = FlowField;        }        field(6213; "Emission N2O"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Sustainability Ledger Entry"."Emission N2O" where("Document No." = field("No."), "Document Type" = filter(Invoice | "GHG Credit")));            Caption = 'Emission N2O';            CaptionClass = '102,6,3';            Editable = false;            FieldClass = FlowField;        }        field(6214; "Energy Consumption"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Sustainability Ledger Entry"."Energy Consumption" where("Document No." = field("No."), "Document Type" = filter(Invoice | "GHG Credit")));            Caption = 'Energy Consumption';            CaptionClass = '102,13,4';            Editable = false;            FieldClass = FlowField;        }    }    var        SustainabilitySetup: Record "Sustainability Setup";}