Other table in Microsoft Dynamics 365 Business Central. 44 fields, 98 records in Cronus demo.
The Sustainability Account table (ID 6210) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 44 fields, with a primary key of No., and includes 20 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: No..
| NO. | FIELD | TYPE | CLASS | RELATION |
|---|---|---|---|---|
| 1 | No. PK | Code | Normal | |
| 2 | No. 2 | Code | Normal | |
| 3 | Name | Text | Normal | |
| 4 | Name 2 | Text | Normal | |
| 5 | Search Name | Code | Normal | |
| 6 | Category | Code | Normal | → Sustain. Account Category #6211 |
| 7 | Subcategory | Code | Normal | → Sustain. Account Subcategory #6212 |
| 8 | Emission Scope ⚡ FLOW | Option | FlowField | |
| 9 | Account Type | Option | Normal | |
| 10 | Totaling | Text | Normal | |
| 11 | Blocked | Boolean | Normal | |
| 12 | Direct Posting | Boolean | Normal | |
| 13 | Indentation | Integer | Normal | |
| 14 | Global Dimension 1 Code | Code | Normal | → Dimension Value #349 |
| 15 | Global Dimension 2 Code | Code | Normal | → Dimension Value #349 |
| 16 | Comment ⚡ FLOW | Boolean | FlowField | |
| 100 | Net Change (CO2) ⚡ FLOW | Decimal | FlowField | |
| 101 | Balance at Date (CO2) ⚡ FLOW | Decimal | FlowField | |
| 102 | Balance (CO2) ⚡ FLOW | Decimal | FlowField | |
| 103 | Net Change (CH4) ⚡ FLOW | Decimal | FlowField | |
| 104 | Balance at Date (CH4) ⚡ FLOW | Decimal | FlowField | |
| 105 | Balance (CH4) ⚡ FLOW | Decimal | FlowField | |
| 106 | Net Change (N2O) ⚡ FLOW | Decimal | FlowField | |
| 107 | Balance at Date (N2O) ⚡ FLOW | Decimal | FlowField | |
| 108 | Balance (N2O) ⚡ FLOW | Decimal | FlowField | |
| 109 | Net Change (Water) ⚡ FLOW | Decimal | FlowField | |
| 110 | Balance at Date (Water) ⚡ FLOW | Decimal | FlowField | |
| 111 | Balance (Water) ⚡ FLOW | Decimal | FlowField | |
| 112 | Net Change (Disch. Water) ⚡ FLOW | Decimal | FlowField | |
| 113 | Balance at Date (Disch. Water) ⚡ FLOW | Decimal | FlowField | |
| 114 | Balance (Disch. Water) ⚡ FLOW | Decimal | FlowField | |
| 115 | Net Change (Waste) ⚡ FLOW | Decimal | FlowField | |
| 116 | Balance at Date (Waste) ⚡ FLOW | Decimal | FlowField | |
| 117 | Balance (Waste) ⚡ FLOW | Decimal | FlowField | |
| 200 | Responsibility Center Filter | Code | FlowFilter | → Responsibility Center #5714 |
| 201 | Date Filter | Date | FlowFilter | |
| 202 | Global Dimension 1 Filter | Code | FlowFilter | → Dimension Value #349 |
| 203 | Global Dimension 2 Filter | Code | FlowFilter | → Dimension Value #349 |
| 204 | Dimension Set ID Filter | Integer | FlowFilter | |
| 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 Account table through TableRelation properties.