Table 6241 Sust. Excise Taxes Trans. Log

Sustainability, Microsoft.Sustainability.ExciseTax

src/Apps/W1/Sustainability/app/src/ExciseTax/SustExciseTaxesTransLog.Table.al420 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.ExciseTax;using Microsoft.Finance.Dimension;using Microsoft.Finance.GeneralLedger.Account;using Microsoft.FixedAssets.FixedAsset;using Microsoft.Foundation.Address;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Item;using Microsoft.Inventory.Ledger;using Microsoft.Inventory.Location;using Microsoft.Projects.Resources.Resource;using Microsoft.Purchases.Vendor;using Microsoft.Sales.Customer;using Microsoft.Sustainability.Account;using Microsoft.Sustainability.Certificate;using Microsoft.Sustainability.Setup;using System.Security.AccessControl;table 6241 "Sust. Excise Taxes Trans. Log"{    Caption = 'Excise Taxes Transaction Log';    DataClassification = CustomerContent;    LookupPageId = "Sust. Excise Taxes Trans. Logs";    fields    {        field(1; "Entry No."; Integer)        {            Caption = 'Entry No.';            AutoIncrement = true;        }        field(2; "Journal Template Name"; Code[10])        {            Caption = 'Journal Template Name';            TableRelation = "Sust. Excise Journal Template";        }        field(3; "Journal Batch Name"; Code[10])        {            Caption = 'Journal Batch Name';            TableRelation = "Sust. Excise Journal Batch".Name where("Journal Template Name" = field("Journal Template Name"));        }        field(5; "Log Type"; Enum "Sust. Excise Jnl. Tax Type")        {            Caption = 'Log Type';        }        field(10; "Entry Type"; Enum "Sust. Excise Jnl. Entry Type")        {            Caption = 'Entry Type';        }        field(11; "Posting Date"; Date)        {            Caption = 'Posting Date';            NotBlank = true;        }        field(12; "Document Type"; Enum "Sust. Excise Document Type")        {            Caption = 'Document Type';        }        field(15; "Document No."; Code[20])        {            Caption = 'Document No.';            NotBlank = true;        }#if not CLEANSCHEMA29        field(16; "Account No."; Code[20])        {            Caption = 'Account No.';            TableRelation = "Sustainability Account" where("Account Type" = const(Posting), Blocked = const(false));            ObsoleteReason = 'This field is no longer required and will be removed in a future release.';#if not CLEAN28            ObsoleteState = Pending;            ObsoleteTag = '28.0';#else            ObsoleteState = Removed;            ObsoleteTag = '29.0';#endif        }        field(17; "Account Name"; Text[100])        {            Caption = 'Account Name';            DataClassification = CustomerContent;            ObsoleteReason = 'This field is no longer required and will be removed in a future release.';#if not CLEAN28            ObsoleteState = Pending;            ObsoleteTag = '28.0';#else            ObsoleteState = Removed;            ObsoleteTag = '29.0';#endif        }        field(18; "Account Category"; Code[20])        {            Caption = 'Account Category';            Editable = false;            TableRelation = "Sustain. Account Category";            ObsoleteReason = 'This field is no longer required and will be removed in a future release.';#if not CLEAN28            ObsoleteState = Pending;            ObsoleteTag = '28.0';#else            ObsoleteState = Removed;            ObsoleteTag = '29.0';#endif        }        field(19; "Account Subcategory"; Code[20])        {            Caption = 'Account Subcategory';            TableRelation = "Sustain. Account Subcategory".Code where("Category Code" = field("Account Category"));            ObsoleteReason = 'This field is no longer required and will be removed in a future release.';#if not CLEAN28            ObsoleteState = Pending;            ObsoleteTag = '28.0';#else            ObsoleteState = Removed;            ObsoleteTag = '29.0';#endif        }#endif        field(20; Description; Text[100])        {            Caption = 'Description';        }        field(21; "Partner Type"; Enum "Sust. Excise Jnl. Partner Type")        {            Caption = 'Partner Type';        }        field(22; "Partner No."; Code[20])        {            Caption = 'Partner No.';            TableRelation = if ("Partner Type" = const(Vendor)) Vendor            else            if ("Partner Type" = const(Customer)) Customer;        }        field(25; "Source Type"; Enum "Sust. Excise Jnl. Source Type")        {            Caption = 'Source Type';        }        field(26; "Source No."; Code[20])        {            Caption = 'Source No.';            TableRelation = if ("Source Type" = const(Item)) Item            else            if ("Source Type" = const("G/L Account")) "G/L Account" where("Direct Posting" = const(true), "Account Type" = const(Posting), Blocked = const(false))            else            if ("Source Type" = const("Fixed Asset")) "Fixed Asset"            else            if ("Source Type" = const("Charge (Item)")) "Item Charge"            else            if ("Source Type" = const(Resource)) Resource            else            if ("Source Type" = const(Certificate)) "Sustainability Certificate";        }        field(27; "Source Description"; Text[100])        {            Caption = 'Source Description';        }        field(28; "Source Unit of Measure Code"; Code[10])        {            TableRelation = "Unit of Measure";            Caption = 'Source Unit of Measure';        }        field(29; "Source Qty."; Decimal)        {            AutoFormatType = 0;            Caption = 'Source Qty.';        }        field(40; "Material Breakdown No."; Code[20])        {            Caption = 'Material Breakdown No.';        }        field(41; "Material Breakdown Description"; Text[100])        {            Caption = 'Material Breakdown Description';        }        field(42; "Material Breakdown Weight"; Decimal)        {            AutoFormatType = 0;            Caption = 'Material Breakdown Weight';        }        field(43; "Material Breakdown UOM"; Code[10])        {            TableRelation = "Unit of Measure";            Caption = 'Material Breakdown UOM';        }        field(50; "Total Embedded CO2e Emission"; Decimal)        {            Caption = 'Total Embedded CO2e Emission';            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));        }        field(51; "CO2e Unit of Measure"; Code[10])        {            TableRelation = "Unit of Measure";            Caption = 'CO2e Unit of Measure';        }        field(60; "CBAM Certificates Required"; Boolean)        {            Caption = 'CBAM Certificates Required';        }        field(61; "Total Emission Cost"; Decimal)        {            Caption = 'Total Emission Cost';            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));        }        field(65; "Carbon Pricing Paid"; Boolean)        {            Caption = 'Carbon Pricing Paid';        }        field(70; "Already Paid Emission"; Decimal)        {            Caption = 'Already Paid Emission';            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));        }        field(80; "Adjusted CBAM Cost"; Decimal)        {            Caption = 'Adjusted CBAM Cost';            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));        }        field(90; "Certificate Amount"; Decimal)        {            Caption = 'Certificate Amount';            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));        }        field(100; "Qty. per Unit of Measure"; Decimal)        {            Caption = 'Qty. per Unit of Measure';            AutoFormatType = 11;            AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places"));            Editable = false;            InitValue = 1;        }        field(110; "Country/Region Code"; Code[10])        {            Caption = 'Country/Region Code';            TableRelation = "Country/Region";        }        field(120; "Source Document No."; Code[20])        {            Caption = 'Source Document No.';        }        field(121; "Source Document Line No."; Integer)        {            Caption = 'Source Document Line No.';            Editable = false;        }        field(130; "Responsibility Center"; Code[10])        {            Caption = 'Responsibility Center';            TableRelation = "Responsibility Center";        }        field(140; "Global Dimension 1 Code"; Code[20])        {            CaptionClass = '1,1,1';            Caption = 'Global Dimension 1 Code';            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1));        }        field(150; "Global Dimension 2 Code"; Code[20])        {            CaptionClass = '1,1,2';            Caption = 'Global Dimension 2 Code';            TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2));        }        field(200; "Source Code"; Code[10])        {            Caption = 'Source Code';            TableRelation = "Source Code";        }        field(201; "Reason Code"; Code[10])        {            Caption = 'Reason Code';            TableRelation = "Reason Code";        }        field(480; "Dimension Set ID"; Integer)        {            Caption = 'Dimension Set ID';            TableRelation = "Dimension Set Entry";            trigger OnLookup()            begin                ShowDimensions();            end;        }        field(500; "Item Ledger Entry No."; Integer)        {            Caption = 'Item Ledger Entry No.';            TableRelation = "Item Ledger Entry";        }        field(5156; "Shortcut Dimension 3 Code"; Code[20])        {            CaptionClass = '1,2,3';            Caption = 'Shortcut Dimension 3 Code';            FieldClass = FlowField;            CalcFormula = lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(3)));        }        field(5157; "Shortcut Dimension 4 Code"; Code[20])        {            CaptionClass = '1,2,4';            Caption = 'Shortcut Dimension 4 Code';            FieldClass = FlowField;            CalcFormula = lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(4)));        }        field(5158; "Shortcut Dimension 5 Code"; Code[20])        {            CaptionClass = '1,2,5';            Caption = 'Shortcut Dimension 5 Code';            FieldClass = FlowField;            CalcFormula = lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(5)));        }        field(5159; "Shortcut Dimension 6 Code"; Code[20])        {            CaptionClass = '1,2,6';            Caption = 'Shortcut Dimension 6 Code';            FieldClass = FlowField;            CalcFormula = lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(6)));        }        field(5160; "Shortcut Dimension 7 Code"; Code[20])        {            CaptionClass = '1,2,7';            Caption = 'Shortcut Dimension 7 Code';            FieldClass = FlowField;            CalcFormula = lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(7)));        }        field(5161; "Shortcut Dimension 8 Code"; Code[20])        {            CaptionClass = '1,2,8';            Caption = 'Shortcut Dimension 8 Code';            FieldClass = FlowField;            CalcFormula = lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(8)));        }        field(5170; "Calculated Date"; Date)        {            Caption = 'Calculated Date';        }        field(5171; "Calculated By"; Code[50])        {            Caption = 'Calculated By';            TableRelation = User."User Name";            DataClassification = EndUserIdentifiableInformation;            ValidateTableRelation = false;        }    }    keys    {        key(PK; "Entry No.")        {            Clustered = true;        }    }    var        SustainabilitySetup: Record "Sustainability Setup";        EntryRecIDLbl: Label '%1 %2', Locked = true;    procedure CopyFromSustainabilityExciseJnlLine(SustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line")    begin        Rec."Journal Template Name" := SustainabilityExciseJnlLine."Journal Template Name";        Rec."Journal Batch Name" := SustainabilityExciseJnlLine."Journal Batch Name";        Rec."Entry Type" := SustainabilityExciseJnlLine."Entry Type";        Rec."Posting Date" := SustainabilityExciseJnlLine."Posting Date";        Rec."Document Type" := SustainabilityExciseJnlLine."Document Type";        Rec."Document No." := SustainabilityExciseJnlLine."Document No.";        Rec.Description := SustainabilityExciseJnlLine.Description;        Rec."Partner Type" := SustainabilityExciseJnlLine."Partner Type";        Rec."Partner No." := SustainabilityExciseJnlLine."Partner No.";        Rec."Source Type" := SustainabilityExciseJnlLine."Source Type";        Rec."Source No." := SustainabilityExciseJnlLine."Source No.";        Rec."Source Description" := SustainabilityExciseJnlLine."Source Description";        Rec."Source Unit of Measure Code" := SustainabilityExciseJnlLine."Source Unit of Measure Code";        Rec."Source Qty." := SustainabilityExciseJnlLine."Source Qty.";        Rec."Material Breakdown No." := SustainabilityExciseJnlLine."Material Breakdown No.";        Rec."Material Breakdown Description" := SustainabilityExciseJnlLine."Material Breakdown Description";        Rec."Material Breakdown UOM" := SustainabilityExciseJnlLine."Material Breakdown UOM";        Rec."Material Breakdown Weight" := SustainabilityExciseJnlLine."Material Breakdown Weight";        Rec."Total Embedded CO2e Emission" := SustainabilityExciseJnlLine."Total Embedded CO2e Emission";        Rec."CO2e Unit of Measure" := SustainabilityExciseJnlLine."CO2e Unit of Measure";        Rec."CBAM Certificates Required" := SustainabilityExciseJnlLine."CBAM Certificates Required";        Rec."Total Emission Cost" := SustainabilityExciseJnlLine."Total Emission Cost";        Rec."Carbon Pricing Paid" := SustainabilityExciseJnlLine."Carbon Pricing Paid";        Rec."Already Paid Emission" := SustainabilityExciseJnlLine."Already Paid Emission";        Rec."Adjusted CBAM Cost" := SustainabilityExciseJnlLine."Adjusted CBAM Cost";        Rec."Certificate Amount" := SustainabilityExciseJnlLine."Certificate Amount";        Rec."Qty. per Unit of Measure" := SustainabilityExciseJnlLine."Qty. per Unit of Measure";        Rec."Country/Region Code" := SustainabilityExciseJnlLine."Country/Region Code";        Rec."Source Document No." := SustainabilityExciseJnlLine."Source Document No.";        Rec."Source Document Line No." := SustainabilityExciseJnlLine."Source Document Line No.";        Rec."Responsibility Center" := SustainabilityExciseJnlLine."Responsibility Center";        Rec."Global Dimension 1 Code" := SustainabilityExciseJnlLine."Shortcut Dimension 1 Code";        Rec."Global Dimension 2 Code" := SustainabilityExciseJnlLine."Shortcut Dimension 2 Code";        Rec."Reason Code" := SustainabilityExciseJnlLine."Reason Code";        Rec."Source Code" := SustainabilityExciseJnlLine."Source Code";        Rec."Item Ledger Entry No." := SustainabilityExciseJnlLine."Item Ledger Entry No.";        Rec."Dimension Set ID" := SustainabilityExciseJnlLine."Dimension Set ID";        Rec."Calculated Date" := SustainabilityExciseJnlLine."Calculated Date";        Rec."Calculated By" := SustainabilityExciseJnlLine."Calculated By";        OnAfterCopyFromSustainabilityExciseJnlLine(Rec, SustainabilityExciseJnlLine);    end;    local procedure ShowDimensions()    var        DimMgt: Codeunit DimensionManagement;    begin        DimMgt.ShowDimensionSet("Dimension Set ID", StrSubstNo(EntryRecIDLbl, TableCaption(), "Entry No."));    end;    [IntegrationEvent(false, false)]    local procedure OnAfterCopyFromSustainabilityExciseJnlLine(var SustExciseTaxesTransactionLog: Record "Sust. Excise Taxes Trans. Log"; SustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line")    begin    end;}