Table extension 6234 Sustainability Sales Header

Sustainability, Microsoft.Sustainability.Sales

src/Apps/W1/Sustainability/app/src/Sales/SustainabilitySalesHeader.TableExt.al63 lines, Copyright (c) Microsoft Corporation. MIT

namespace Microsoft.Sustainability.Sales;using Microsoft.Sales.Document;using Microsoft.Sustainability.Setup;tableextension 6234 "Sustainability Sales Header" extends "Sales Header"{    fields    {        field(6210; "Sustainability Lines Exist"; Boolean)        {            Caption = 'Sustainability Lines Exist';            Editable = false;            FieldClass = FlowField;            CalcFormula = exist("Sales Line" where("Document Type" = field("Document Type"),                                                   "Document No." = field("No."),                                                   "Sust. Account No." = filter('<>''''')));        }        field(6211; "Total CO2e"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Sales Line"."Total CO2e" where("Document Type" = field("Document Type"),                                                              "Document No." = field("No.")));            Caption = 'Total CO2e';            Editable = false;            FieldClass = FlowField;        }        field(6212; "Posted Total CO2e"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Sales Line"."Posted Total CO2e" where("Document Type" = field("Document Type"),                                                                     "Document No." = field("No.")));            Caption = 'Posted Total CO2e';            Editable = false;            FieldClass = FlowField;        }        field(6213; "Total EPR Fee"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Sales Line"."Total EPR Fee" where("Document Type" = field("Document Type"),                                                              "Document No." = field("No.")));            Caption = 'Total EPR Fee';            Editable = false;            FieldClass = FlowField;        }        field(6214; "Posted Total EPR Fee"; Decimal)        {            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            CalcFormula = sum("Sales Line"."Posted Total EPR Fee" where("Document Type" = field("Document Type"),                                                                     "Document No." = field("No.")));            Caption = 'Posted Total EPR Fee';            Editable = false;            FieldClass = FlowField;        }    }    var        SustainabilitySetup: Record "Sustainability Setup";}