Sustainability Ledger Entry #6216

Other table in Microsoft Dynamics 365 Business Central. 63 fields, 83 records in Cronus demo.

63
Fields
83
Records
1
Primary key
6
FlowFields
17
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Entry No..

All fields (63)

Sustainability Ledger Entry — FIELDS
NO.FIELDTYPECLASSRELATION
1 Journal Template Name Code Normal → Sustainability Jnl. Template #6215
2 Journal Batch Name Code Normal → Sustainability Jnl. Batch #6213
3 Line No. Integer Normal
4 Posting Date Date Normal
5 Document No. Code Normal
6 Document Type Option Normal
7 Account No. Code Normal → Sustainability Account #6210
8 Account Name Text Normal
9 Account Category Code Normal → Sustain. Account Category #6211
10 Account Subcategory Code Normal → Sustain. Account Subcategory #6212
11 Description Text Normal
12 Manual Input Boolean Normal
13 Unit of Measure Code Normal → Unit of Measure #204
14 Fuel/Electricity Decimal Normal
15 Distance Decimal Normal
16 Custom Amount Decimal Normal
17 Installation Multiplier Decimal Normal
18 Time Factor Decimal Normal
19 Emission CO2 Decimal Normal
20 Emission CH4 Decimal Normal
21 Emission N2O Decimal Normal
22 Country/Region Code Code Normal → Country/Region #9
23 Responsibility Center Code Normal → Responsibility Center #5714
24 Recurring Method Option Normal
25 Recurring Frequency DateFormula Normal
26 Expiration Date Date Normal
28 Global Dimension 1 Code Code Normal → Dimension Value #349
29 Global Dimension 2 Code Code Normal → Dimension Value #349
30 Source Code Code Normal → Source Code #230
31 Reason Code Code Normal → Reason Code #231
32 CO2e Emission Decimal Normal
33 Carbon Fee Decimal Normal
34 Water Intensity Decimal Normal
35 Discharged Into Water Decimal Normal
36 Waste Intensity Decimal Normal
37 Water/Waste Intensity Type Option Normal
38 Water Type Option Normal
40 Energy Source Code Code Normal → Sustainability Energy Source #6233
42 Energy Consumption Decimal Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
5146 Emission Scope Option Normal
5147 CO2 Boolean Normal
5148 CH4 Boolean Normal
5149 N2O Boolean Normal
5150 Calculation Foundation Option Normal
5151 Emission Factor CO2 Decimal Normal
5152 Emission Factor CH4 Decimal Normal
5153 Emission Factor N2O Decimal Normal
5154 Renewable Energy Boolean Normal
5155 Entry No. PK Integer Normal
5156 Shortcut Dimension 3 Code ⚡ FLOW Code FlowField
5157 Shortcut Dimension 4 Code ⚡ FLOW Code FlowField
5158 Shortcut Dimension 5 Code ⚡ FLOW Code FlowField
5159 Shortcut Dimension 6 Code ⚡ FLOW Code FlowField
5160 Shortcut Dimension 7 Code ⚡ FLOW Code FlowField
5161 Shortcut Dimension 8 Code ⚡ FLOW Code FlowField
5162 User ID Code Normal
6290 Calculated by Copilot Boolean Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (14)

Tables referenced by fields on the Sustainability Ledger Entry table through TableRelation properties.

Sustainability Jnl. Template
#6215 · Other · via Journal Template Name
Sustainability Jnl. Batch
#6213 · Other · via Journal Batch Name
Sustainability Account
#6210 · Other · via Account No.
Sustain. Account Category
#6211 · Other · via Account Category
Sustain. Account Subcategory
#6212 · Other · via Account Subcategory
Unit of Measure
#204 · Other · via Unit of Measure
Country/Region
#9 · General Ledger · via Country/Region Code
Responsibility Center
#5714 · Other · via Responsibility Center
Dimension Value
#349 · Dimensions · via Global Dimension 1 Code, Global Dimension 2 Code
Source Code
#230 · Other · via Source Code
Reason Code
#231 · Other · via Reason Code
Sustainability Energy Source
#6233 · Other · via Energy Source Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID