Table extension 6212 Sustainability Purch. Header

Sustainability, Microsoft.Sustainability.Purchase

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

namespace Microsoft.Sustainability.Purchase;using Microsoft.Purchases.Document;using Microsoft.Sustainability.Setup;tableextension 6212 "Sustainability Purch. Header" extends "Purchase Header"{    fields    {        field(6210; "Sustainability Lines Exist"; Boolean)        {            Caption = 'Sustainability Lines Exist';            Editable = false;            FieldClass = FlowField;            CalcFormula = exist("Purchase Line" where("Sust. Account No." = filter('<>'''''), "Document No." = field("No.")));        }        field(6211; "Emission C02"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Purchase Line"."Emission CO2" where("Document Type" = field("Document Type"),                                                            "Document No." = field("No.")));            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("Purchase Line"."Emission CH4" where("Document Type" = field("Document Type"),                                                            "Document No." = field("No.")));            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("Purchase Line"."Emission N2O" where("Document Type" = field("Document Type"),                                                            "Document No." = field("No.")));            Caption = 'Emission N2O';            CaptionClass = '102,6,3';            Editable = false;            FieldClass = FlowField;        }        field(6214; "Posted Emission C02"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Purchase Line"."Posted Emission CO2" where("Document Type" = field("Document Type"),                                                            "Document No." = field("No.")));            Caption = 'Posted Emission CO2';            CaptionClass = '102,11,1';            Editable = false;            FieldClass = FlowField;        }        field(6215; "Posted Emission CH4"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Purchase Line"."Posted Emission CH4" where("Document Type" = field("Document Type"),                                                            "Document No." = field("No.")));            Caption = 'Posted Emission CH4';            CaptionClass = '102,11,2';            Editable = false;            FieldClass = FlowField;        }        field(6216; "Posted Emission N2O"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Purchase Line"."Posted Emission N2O" where("Document Type" = field("Document Type"),                                                            "Document No." = field("No.")));            Caption = 'Posted Emission N2O';            CaptionClass = '102,11,3';            Editable = false;            FieldClass = FlowField;        }        field(6217; "Energy Consumption"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Purchase Line"."Energy Consumption" where("Document Type" = field("Document Type"),                                                                         "Document No." = field("No.")));            Caption = 'Energy Consumption';            CaptionClass = '102,13,4';            Editable = false;            FieldClass = FlowField;        }        field(6218; "Posted Energy Consumption"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Purchase Line"."Posted Energy Consumption" where("Document Type" = field("Document Type"),                                                                                "Document No." = field("No.")));            Caption = 'Posted Energy Consumption';            CaptionClass = '102,14,4';            Editable = false;            FieldClass = FlowField;        }        field(6219; "Total Emission Cost"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Purchase Line"."Total Emission Cost" where("Document Type" = field("Document Type"),                                                                          "Document No." = field("No.")));            Caption = 'Total Emission Cost';            CaptionClass = '102,15,5';            Editable = false;            FieldClass = FlowField;        }        field(6220; "Posted Total Emission Cost"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Purchase Line"."Posted Total Emission Cost" where("Document Type" = field("Document Type"),                                                                                 "Document No." = field("No.")));            Caption = 'Posted Total Emission Cost';            CaptionClass = '102,16,5';            Editable = false;            FieldClass = FlowField;        }    }    var        SustainabilitySetup: Record "Sustainability Setup";}