tableSustainabilityofficial - Microsoftderived - from the source, no model text

Table 6216 "Sustainability Ledger Entry"

Sustainability · Microsoft.Sustainability.Ledger

Across versions

  1. BC23-28not present
  2. BC29-30present

Neighbourhood 25 connected objects and pages

Table 480 "Dimension Set Entry" (relates to, 7 links)Dimension Set EntryTable 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 204 "Unit of Measure" (relates to)Unit of MeasureTable 5714 "Responsibility Center" (relates to)Responsibility CenterTable 6210 "Sustainability Account" (relates to)Table 6211 "Sustain. Account Category" (relates to)Sustain. Account CategoryTable 6212 "Sustain. Account Subcategory" (relates to)Sustain. Account SubcategoryTable 6213 "Sustainability Jnl. Batch" (relates to)Sustainability Jnl. BatchTable 6215 "Sustainability Jnl. Template" (relates to)Sustainability Jnl. TemplateTable 6233 "Sustainability Energy Source" (relates to)Table 9 "Country/Region" (relates to)Page 6220 "Sustainability Ledger Entries" (pages and codeunits on it, 2 links)Sustainability Ledger EntriesPage 6231 "Sustainability Ledg. Entries" (pages and codeunits on it)Table extension 6292 "Sustainability Ledger Entry" (extended by)Codeunit 6228 "Sust. Preview Posting Handler" (event subscribers)Codeunit 408 "DimensionManagement" (calls)Table 6210 "Sustainability Account" (referenced by, 18 links)Sustainability AccountTable 6219 "Sustainability Goal" (referenced by, 10 links)Sustainability GoalTable 6220 "Sustainability Cue" (referenced by, 7 links)Sustainability CueTable extension 6217 "Sust. Purch. Inv. Header" (referenced by, 4 links)Sust. Purch. Inv. HeaderTable extension 6218 "Sust. Purch. Cr. Memo Header" (referenced by, 4 links)Sust. Purch. Cr. Memo HeaderTable 6261 "Sust. G/L - Sust. Ledger Rel." (referenced by)Ad-hoc analysis of sustainability data (Learn pages)Chart of sustainability accounts and ledger (Learn pages)Record sustainability entries (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Sustainability · Microsoft.Sustainability.Ledger · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 6220 “Sustainability Ledger Entries” (3 Learn pages).

Properties

Property Value
Caption Sustainability Ledger Entry
Access Public
DataClassification CustomerContent
DrillDownPageId Sustainability Ledger Entries

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
1 Journal Template Name Code[10] Specifies the name of the journal template. via Page 6220 “Sustainability Ledger Entries” TableRelation Table 6215 “Sustainability Jnl. Template” (Sustainability Jnl. Template)
2 Journal Batch Name Code[10] Specifies the name of the journal batch. via Page 6220 “Sustainability Ledger Entries” TableRelation Table 6213 “Sustainability Jnl. Batch” (“Sustainability Jnl. Batch”.Name where(“Journal Template Name” = field(“Journal Template Name”)))
3 Line No. Integer —
4 Posting Date Date Specifies the date when the transaction is posted. via Page 6220 “Sustainability Ledger Entries”
5 Document No. Code[20] Specifies the document number. via Page 6220 “Sustainability Ledger Entries”
6 Document Type Enum “Sustainability Jnl. Doc. Type” Specifies the type of the document. via Page 6220 “Sustainability Ledger Entries” enum Enum 6213 “Sustainability Jnl. Doc. Type”
7 Account No. Code[20] Specifies the sustainability account number. via Page 6220 “Sustainability Ledger Entries” TableRelation Table 6210 “Sustainability Account” (“Sustainability Account” where(“Account Type” = const(Posting)))
8 Account Name Text[100] Specifies the sustainability account name. via Page 6220 “Sustainability Ledger Entries”
9 Account Category Code[20] Specifies the sustainability account category. via Page 6220 “Sustainability Ledger Entries” TableRelation Table 6211 “Sustain. Account Category” (Sustain. Account Category)
10 Account Subcategory Code[20] Specifies the sustainability account subcategory. via Page 6220 “Sustainability Ledger Entries” TableRelation Table 6212 “Sustain. Account Subcategory” (“Sustain. Account Subcategory”.Code where(“Category Code” = field(“Account Category”)))
11 Description Text[100] Specifies the description of the entry. via Page 6220 “Sustainability Ledger Entries”
12 Manual Input Boolean Specifies whether the amounts are input manually. via Page 6220 “Sustainability Ledger Entries”
13 Unit of Measure Code[10] Specifies the unit of measure of the entry. via Page 6220 “Sustainability Ledger Entries” TableRelation Table 204 “Unit of Measure” (Unit of Measure)
14 Fuel/Electricity Decimal Specifies the fuel or electricity of the entry. via Page 6220 “Sustainability Ledger Entries”
15 Distance Decimal Specifies the distance of the entry. via Page 6220 “Sustainability Ledger Entries”
16 Custom Amount Decimal Specifies the custom amount of the entry. via Page 6220 “Sustainability Ledger Entries”
17 Installation Multiplier Decimal Specifies the installation multiplier of the entry. via Page 6220 “Sustainability Ledger Entries”
18 Time Factor Decimal Specifies the time factor of the entry. via Page 6220 “Sustainability Ledger Entries”
19 Emission CO2 Decimal Specifies the emission CO2 of the entry. via Page 6220 “Sustainability Ledger Entries”
20 Emission CH4 Decimal Specifies the emission CH4 of the entry. via Page 6220 “Sustainability Ledger Entries”
21 Emission N2O Decimal Specifies the emission N2O of the entry. via Page 6220 “Sustainability Ledger Entries”
22 Country/Region Code Code[10] Specifies the country/region code of the entry. via Page 6220 “Sustainability Ledger Entries” TableRelation Table 9 “Country/Region” (Country/Region)
23 Responsibility Center Code[10] Specifies the responsibility center of the entry. via Page 6220 “Sustainability Ledger Entries” TableRelation Table 5714 “Responsibility Center” (Responsibility Center)
24 Recurring Method Enum “Sustain. Jnl. Recur. Method” — enum Enum 6214 “Sustain. Jnl. Recur. Method”
25 Recurring Frequency DateFormula —
26 Expiration Date Date —
480 Dimension Set ID Integer — TableRelation Table 480 “Dimension Set Entry” (Dimension Set Entry)
28 Global Dimension 1 Code Code[20] Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. via Page 6220 “Sustainability Ledger Entries” TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false)))
29 Global Dimension 2 Code Code[20] Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company’s most important activities, are available on all cards, documents, reports, and lists. via Page 6220 “Sustainability Ledger Entries” TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false)))
30 Source Code Code[10] — TableRelation Source Code
31 Reason Code Code[10] — TableRelation Reason Code
32 CO2e Emission Decimal Specifies total carbon dioxide and other equivalents emission expressing different greenhouse gases impact in terms of the amount of CO2 that would create the same effect. via Page 6220 “Sustainability Ledger Entries”
33 Carbon Fee Decimal Specifies internal carbon fee that a company charges itself for each unit of CO2 equivalent that it emits. via Page 6220 “Sustainability Ledger Entries”
34 Water Intensity Decimal Specifies the Water Intensity of the entry. via Page 6220 “Sustainability Ledger Entries”
35 Discharged Into Water Decimal Specifies the Discharged Into Water of the entry. via Page 6220 “Sustainability Ledger Entries”
36 Waste Intensity Decimal Specifies the Waste Intensity of the entry. via Page 6220 “Sustainability Ledger Entries”
37 Water/Waste Intensity Type Enum “Water/Waste Intensity Type” Specifies the Water/Waste Intensity Type of the entry. via Page 6220 “Sustainability Ledger Entries” enum Enum 6217 “Water/Waste Intensity Type”
38 Water Type Enum “Water Type” Specifies the Water Type of the entry. via Page 6220 “Sustainability Ledger Entries” enum Enum 6218 “Water Type”
40 Energy Source Code Code[20] Specifies the Energy Source Code of the entry. via Page 6220 “Sustainability Ledger Entries” TableRelation Table 6233 “Sustainability Energy Source” (Sustainability Energy Source)
42 Energy Consumption Decimal Specifies the Energy Consumption. via Page 6220 “Sustainability Ledger Entries”
43 Collected from G/L Entries Boolean Specifies whether the amount of the entry was collected from general ledger entries. Use the Collected G/L Entries action to see which entries were consumed. via Page 6220 “Sustainability Ledger Entries” not editable
44 Collect From Date Date Specifies the start of the period that the general ledger entries were collected for. via Page 6220 “Sustainability Ledger Entries” not editable
45 Collect To Date Date Specifies the end of the period that the general ledger entries were collected for. via Page 6220 “Sustainability Ledger Entries” not editable
5146 Emission Scope Enum “Emission Scope” Specifies the scope of the emission. via Page 6220 “Sustainability Ledger Entries” enum Enum 6212 “Emission Scope”
5147 CO2 Boolean —
5148 CH4 Boolean —
5149 N2O Boolean —
5150 Calculation Foundation Enum “Calculation Foundation” — enum Enum 6210 “Calculation Foundation”
5151 Emission Factor CO2 Decimal Specifies the emission factor CO2 of the entry. via Page 6220 “Sustainability Ledger Entries”
5152 Emission Factor CH4 Decimal Specifies the emission factor CH4 of the entry. via Page 6220 “Sustainability Ledger Entries”
5153 Emission Factor N2O Decimal Specifies the emission factor N2O of the entry. via Page 6220 “Sustainability Ledger Entries”
5154 Renewable Energy Boolean —
5155 Entry No. Integer Specifies the entry number of the Sustainability Ledger Entry. via Page 6220 “Sustainability Ledger Entries” AutoIncrement
5156 Shortcut Dimension 3 Code Code[20] Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6220 “Sustainability Ledger Entries” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(3)))
5157 Shortcut Dimension 4 Code Code[20] Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6220 “Sustainability Ledger Entries” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(4)))
5158 Shortcut Dimension 5 Code Code[20] Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6220 “Sustainability Ledger Entries” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(5)))
5159 Shortcut Dimension 6 Code Code[20] Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6220 “Sustainability Ledger Entries” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(6)))
5160 Shortcut Dimension 7 Code Code[20] Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6220 “Sustainability Ledger Entries” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(7)))
5161 Shortcut Dimension 8 Code Code[20] Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. via Page 6220 “Sustainability Ledger Entries” FlowField: lookup(“Dimension Set Entry”.“Dimension Value Code” where(“Dimension Set ID” = field(“Dimension Set ID”), “Global Dimension No.” = const(8)))
5162 User ID Code[50] — TableRelation User.“User Name”; DataClassification EndUserIdentifiableInformation
5817 Correction Boolean —
5818 Reversed Boolean Specifies whether this entry has been reversed. via Page 6220 “Sustainability Ledger Entries” not editable; DataClassification SystemMetadata
5819 Reversed by Entry No. Integer Specifies the entry number that reversed this entry. via Page 6220 “Sustainability Ledger Entries” TableRelation Table 6216 “Sustainability Ledger Entry” (“Sustainability Ledger Entry”.“Entry No.”); not editable; DataClassification SystemMetadata
5820 Reversed Entry No. Integer Specifies the original entry number that this entry reverses. via Page 6220 “Sustainability Ledger Entries” TableRelation Table 6216 “Sustainability Ledger Entry” (“Sustainability Ledger Entry”.“Entry No.”); not editable; DataClassification SystemMetadata
5821 G/L Entry No. Integer — not editable; DataClassification SystemMetadata

Keys

  • PK: Entry No. (clustered)
  • SummaryOnChartPage: Account No., Posting Date, Dimension Set ID, Global Dimension 1 Code, Global Dimension 2 Code, Responsibility Center
  • Key2: Document Type, Document No.
  • Key3: Journal Template Name, Journal Batch Name
  • Key4: G/L Entry No.

Trigger event subscribers

Procedures

1 local procedures, no public ones.

Relations

Referenced by

46 fields in 7 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

Extended by

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Recent changes

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Sustainability Ledger Entry"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources