Table 6216 Sustainability Ledger Entry
src/Apps/W1/Sustainability/app/src/Ledger/SustainabilityLedgerEntry.Table.al418 lines, Copyright (c) Microsoft Corporation. MIT
namespace Microsoft.Sustainability.Ledger;using Microsoft.Finance.Dimension;using Microsoft.Foundation.Address;using Microsoft.Foundation.AuditCodes;using Microsoft.Foundation.UOM;using Microsoft.Inventory.Location;using Microsoft.Sustainability.Account;using Microsoft.Sustainability.Energy;using Microsoft.Sustainability.Journal;using Microsoft.Sustainability.Setup;using System.Security.AccessControl;table 6216 "Sustainability Ledger Entry"{ Access = Public; Caption = 'Sustainability Ledger Entry'; DataClassification = CustomerContent; DataPerCompany = true; DrillDownPageId = "Sustainability Ledger Entries"; fields { field(1; "Journal Template Name"; Code[10]) { Caption = 'Journal Template Name'; TableRelation = "Sustainability Jnl. Template"; } field(2; "Journal Batch Name"; Code[10]) { Caption = 'Journal Batch Name'; TableRelation = "Sustainability Jnl. Batch".Name where("Journal Template Name" = field("Journal Template Name")); } field(3; "Line No."; Integer) { Caption = 'Line No.'; } field(4; "Posting Date"; Date) { Caption = 'Posting Date'; } field(5; "Document No."; Code[20]) { Caption = 'Document No.'; } field(6; "Document Type"; Enum "Sustainability Jnl. Doc. Type") { Caption = 'Document Type'; } field(7; "Account No."; Code[20]) { Caption = 'Account No.'; TableRelation = "Sustainability Account" where("Account Type" = const(Posting)); } field(8; "Account Name"; Text[100]) { Caption = 'Account Name'; } field(9; "Account Category"; Code[20]) { Caption = 'Account Category'; TableRelation = "Sustain. Account Category"; } field(10; "Account Subcategory"; Code[20]) { Caption = 'Account Subcategory'; TableRelation = "Sustain. Account Subcategory".Code where("Category Code" = field("Account Category")); } field(11; Description; Text[100]) { Caption = 'Description'; } field(12; "Manual Input"; Boolean) { Caption = 'Manual Input'; } field(13; "Unit of Measure"; Code[10]) { Caption = 'Unit of Measure'; TableRelation = "Unit of Measure"; } field(14; "Fuel/Electricity"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Fuel/El. Decimal Places")); Caption = 'Fuel/Electricity'; } field(15; Distance; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Distance Decimal Places")); Caption = 'Distance'; } field(16; "Custom Amount"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Custom Amt. Decimal Places")); Caption = 'Custom Amount'; } field(17; "Installation Multiplier"; Decimal) { AutoFormatType = 0; Caption = 'Installation Multiplier'; } field(18; "Time Factor"; Decimal) { AutoFormatType = 0; Caption = 'Time Factor'; MaxValue = 1; } field(19; "Emission CO2"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission CO2'; CaptionClass = '102,6,1'; } field(20; "Emission CH4"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission CH4'; CaptionClass = '102,6,2'; } field(21; "Emission N2O"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Emission N2O'; CaptionClass = '102,6,3'; } field(22; "Country/Region Code"; Code[10]) { Caption = 'Country/Region Code'; TableRelation = "Country/Region"; } field(23; "Responsibility Center"; Code[10]) { Caption = 'Responsibility Center'; TableRelation = "Responsibility Center"; } field(24; "Recurring Method"; Enum "Sustain. Jnl. Recur. Method") { Caption = 'Recurring Method'; BlankZero = true; } field(25; "Recurring Frequency"; DateFormula) { Caption = 'Recurring Frequency'; } field(26; "Expiration Date"; Date) { Caption = 'Expiration Date'; } field(480; "Dimension Set ID"; Integer) { Caption = 'Dimension Set ID'; TableRelation = "Dimension Set Entry"; trigger OnLookup() begin ShowDimensions(); end; } field(28; "Global Dimension 1 Code"; Code[20]) { CaptionClass = '1,2,1'; Caption = 'Global Dimension 1 Code'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(1), Blocked = const(false)); } field(29; "Global Dimension 2 Code"; Code[20]) { CaptionClass = '1,2,2'; Caption = 'Global Dimension 2 Code'; TableRelation = "Dimension Value".Code where("Global Dimension No." = const(2), Blocked = const(false)); } field(30; "Source Code"; Code[10]) { Caption = 'Source Code'; TableRelation = "Source Code"; } field(31; "Reason Code"; Code[10]) { Caption = 'Reason Code'; TableRelation = "Reason Code"; } field(32; "CO2e Emission"; Decimal) { AutoFormatType = 0; DataClassification = CustomerContent; Caption = 'CO2e Emission'; DecimalPlaces = 2 : 5; } field(33; "Carbon Fee"; Decimal) { AutoFormatType = 2; AutoFormatExpression = ''; DataClassification = CustomerContent; Caption = 'Carbon Fee'; DecimalPlaces = 2 : 5; } field(34; "Water Intensity"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Water Intensity'; } field(35; "Discharged Into Water"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Discharged Into Water'; } field(36; "Waste Intensity"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Waste Intensity'; } field(37; "Water/Waste Intensity Type"; Enum "Water/Waste Intensity Type") { Caption = 'Water/Waste Intensity Type'; } field(38; "Water Type"; Enum "Water Type") { Caption = 'Water Type'; } field(40; "Energy Source Code"; Code[20]) { Caption = 'Energy Source Code'; TableRelation = "Sustainability Energy Source"; } field(42; "Energy Consumption"; Decimal) { AutoFormatType = 11; AutoFormatExpression = SustainabilitySetup.GetFormat(SustainabilitySetup.FieldNo("Emission Decimal Places")); Caption = 'Energy Consumption'; CaptionClass = '102,13,4'; } field(43; "Collected from G/L Entries"; Boolean) { Caption = 'Collected from G/L Entries'; Editable = false; } field(44; "Collect From Date"; Date) { Caption = 'Collect From Date'; Editable = false; } field(45; "Collect To Date"; Date) { Caption = 'Collect To Date'; Editable = false; } field(5146; "Emission Scope"; Enum "Emission Scope") { Caption = 'Emission Scope'; } field(5147; CO2; Boolean) { Caption = 'CO2'; CaptionClass = '102,4,1'; } field(5148; CH4; Boolean) { Caption = 'CH4'; CaptionClass = '102,4,2'; } field(5149; N2O; Boolean) { Caption = 'N2O'; CaptionClass = '102,4,3'; } field(5150; "Calculation Foundation"; Enum "Calculation Foundation") { Caption = 'Calculation Foundation'; } field(5151; "Emission Factor CO2"; Decimal) { AutoFormatType = 0; Caption = 'Emission Factor CO2'; CaptionClass = '102,5,1'; } field(5152; "Emission Factor CH4"; Decimal) { AutoFormatType = 0; Caption = 'Emission Factor CH4'; CaptionClass = '102,5,2'; } field(5153; "Emission Factor N2O"; Decimal) { AutoFormatType = 0; Caption = 'Emission Factor N2O'; CaptionClass = '102,5,3'; } field(5154; "Renewable Energy"; Boolean) { Caption = 'Renewable Energy'; } field(5155; "Entry No."; Integer) { Caption = 'Entry No.'; AutoIncrement = true; } 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(5162; "User ID"; Code[50]) { Caption = 'User ID'; TableRelation = User."User Name"; DataClassification = EndUserIdentifiableInformation; ValidateTableRelation = false; } field(5817; Correction; Boolean) { Caption = 'Correction'; } field(5818; Reversed; Boolean) { Caption = 'Reversed'; DataClassification = SystemMetadata; Editable = false; } field(5819; "Reversed by Entry No."; Integer) { Caption = 'Reversed by Entry No.'; DataClassification = SystemMetadata; Editable = false; TableRelation = "Sustainability Ledger Entry"."Entry No."; } field(5820; "Reversed Entry No."; Integer) { Caption = 'Reversed Entry No.'; DataClassification = SystemMetadata; Editable = false; TableRelation = "Sustainability Ledger Entry"."Entry No."; } field(5821; "G/L Entry No."; Integer) { Caption = 'G/L Entry No.'; DataClassification = SystemMetadata; Editable = false; } } keys { key(PK; "Entry No.") { Clustered = true; } key(SummaryOnChartPage; "Account No.", "Posting Date", "Dimension Set ID", "Global Dimension 1 Code", "Global Dimension 2 Code", "Responsibility Center") { SumIndexFields = "Emission CO2", "Emission CH4", "Emission N2O"; } key(Key2; "Document Type", "Document No.") { } key(Key3; "Journal Template Name", "Journal Batch Name") { } key(Key4; "G/L Entry No.") { } } var SustainabilitySetup: Record "Sustainability Setup"; EntryRecIDLbl: Label '%1 %2', Locked = true; local procedure ShowDimensions() var DimMgt: Codeunit DimensionManagement; begin DimMgt.ShowDimensionSet("Dimension Set ID", StrSubstNo(EntryRecIDLbl, TableCaption(), "Entry No.")); end;}