Other table in Microsoft Dynamics 365 Business Central. 63 fields, 83 records in Cronus demo.
The Sustainability Ledger Entry table (ID 6216) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 63 fields, with a primary key of Entry No., and includes 6 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.
The primary key uniquely identifies each record in this table. It consists of: Entry No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 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 |
Tables referenced by fields on the Sustainability Ledger Entry table through TableRelation properties.