---
id: object/table/6214
type: object
title: Table 6214 "Sustainability Jnl. Line"
summary: Table 6214 "Sustainability Jnl. Line" in Sustainability (Microsoft.Sustainability.Journal). 44 fields, 7 public procedures, 3 events. Introduced in BC29, still in BC30.
tier: official
language: en
tags:
  - table
  - sustainability
versions:
  introduced: "29"
  last_changed: null
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 599317b5a12154715bf33ad1450bfbf5c4ffdda23593b491a049d9073ae53b89
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Sustainability/app/src/Journal/SustainabilityJnlLine.Table.al
    title: src/Apps/W1/Sustainability/app/src/Journal/SustainabilityJnlLine.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/finance-sustainability-journal
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/sustainability-management
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/10541
object_type: table
object_id: 6214
name: Sustainability Jnl. Line
caption: Sustainability Journal Line
namespace: Microsoft.Sustainability.Journal
app: Sustainability
extends: null
first_version: "29"
last_version: "30"
present_in:
  - "29"
  - "30"
changed_in: []
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 44
  procedures: 22
  events: 3
  subscribers: 0
relations:
  out: 13
  referenced_by: 1
  pages: 3
  extended_by: 1
  event_subscribers: 3
  calls: 3
  called_by: 0
  implements: 0
---

# Table 6214 "Sustainability Jnl. Line"

> Table 6214 "Sustainability Jnl. Line" in Sustainability (Microsoft.Sustainability.Journal). 44 fields, 7 public procedures, 3 events. Introduced in BC29, still in BC30.

Sustainability · Microsoft.Sustainability.Journal · captioned "Sustainability Journal Line" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Sustainability/app/src/Journal/SustainabilityJnlLine.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 6219 "Sustainability Journal"](../page/6219.md) (1 Learn page).

## Properties

| Property | Value |
|---|---|
| Caption | Sustainability Journal Line |
| Access | Public |
| Extensible | true |
| DataClassification | CustomerContent |
| LookupPageId | Sustainability Journal |

## 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] | — | TableRelation [Table 6215 "Sustainability Jnl. Template"](../table/6215.md) (Sustainability Jnl. Template); NotBlank |
| 2 | Journal Batch Name | Code[10] | — | TableRelation [Table 6213 "Sustainability Jnl. Batch"](../table/6213.md) ("Sustainability Jnl. Batch".Name where("Journal Template Name" = field("Journal Template Name"))); NotBlank |
| 3 | Line No. | Integer | — |  |
| 4 | Posting Date | Date | Specifies the date when the transaction is posted. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | NotBlank |
| 5 | Document No. | Code[20] | Specifies the document number. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | NotBlank |
| 6 | Document Type | Enum "Sustainability Jnl. Doc. Type" | Specifies the type of the document. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | enum [Enum 6213 "Sustainability Jnl. Doc. Type"](../enum/6213.md) |
| 7 | Account No. | Code[20] | Specifies the sustainability account number. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | TableRelation [Table 6210 "Sustainability Account"](../table/6210.md) ("Sustainability Account" where("Account Type" = const(Posting), Blocked = const(false))) |
| 8 | Account Name | Text[100] | Specifies the sustainability account name. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 9 | Account Category | Code[20] | Specifies the sustainability account category. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | TableRelation [Table 6211 "Sustain. Account Category"](../table/6211.md) (Sustain. Account Category); not editable |
| 10 | Account Subcategory | Code[20] | Specifies the sustainability account subcategory. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | TableRelation [Table 6212 "Sustain. Account Subcategory"](../table/6212.md) ("Sustain. Account Subcategory".Code where("Category Code" = field("Account Category"))) |
| 11 | Description | Text[100] | Specifies the description of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 12 | Manual Input | Boolean | Specifies whether the amounts will be input manually. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 13 | Unit of Measure | Code[10] | Specifies the unit of measure of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | TableRelation [Table 204 "Unit of Measure"](../table/204.md) (Unit of Measure); NotBlank |
| 14 | Fuel/Electricity | Decimal | Specifies the fuel or electricity of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 15 | Distance | Decimal | Specifies the distance of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 16 | Custom Amount | Decimal | Specifies the custom amount of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 17 | Installation Multiplier | Decimal | Specifies the installation multiplier of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 18 | Time Factor | Decimal | Specifies the time factor of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 19 | Emission CO2 | Decimal | Specifies the emission CO2 of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 20 | Emission CH4 | Decimal | Specifies the emission CH4 of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 21 | Emission N2O | Decimal | Specifies the emission N2O of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 22 | Country/Region Code | Code[10] | Specifies the country/region code of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region) |
| 23 | Responsibility Center | Code[10] | Specifies the responsibility center of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | TableRelation [Table 5714 "Responsibility Center"](../table/5714.md) (Responsibility Center) |
| 24 | Recurring Method | Enum "Sustain. Jnl. Recur. Method" | Specifies the recurring method. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | enum [Enum 6214 "Sustain. Jnl. Recur. Method"](../enum/6214.md) |
| 25 | Recurring Frequency | DateFormula | Specifies the recurring frequency. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 26 | Expiration Date | Date | Specifies the expiration date. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 34 | Water Intensity | Decimal | Specifies the Water Intensity of the entry. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 35 | Discharged Into Water | Decimal | Specifies the Discharged Into Water of the entry. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 36 | Waste Intensity | Decimal | Specifies the Waste Intensity of the entry. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 37 | Water/Waste Intensity Type | Enum "Water/Waste Intensity Type" | Specifies the Water/Waste Intensity Type of the entry. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | enum [Enum 6217 "Water/Waste Intensity Type"](../enum/6217.md) |
| 38 | Water Type | Enum "Water Type" | Specifies the Water Type of the entry. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | enum [Enum 6218 "Water Type"](../enum/6218.md) |
| 480 | Dimension Set ID | Integer | — | TableRelation [Table 480 "Dimension Set Entry"](../table/480.md) (Dimension Set Entry); not editable |
| 28 | Shortcut Dimension 1 Code | Code[20] | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1), Blocked = const(false))) |
| 29 | Shortcut Dimension 2 Code | Code[20] | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2), Blocked = const(false))) |
| 30 | Source Code | Code[10] | Specifies the source code of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | TableRelation Source Code |
| 31 | Reason Code | Code[10] | Specifies the reason code of the journal line. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | TableRelation Reason Code |
| 32 | CO2e Emission | Decimal | — |  |
| 40 | Energy Source Code | Code[20] | Specifies the Energy Source Code. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> | TableRelation [Table 6233 "Sustainability Energy Source"](../table/6233.md) (Sustainability Energy Source) |
| 42 | Energy Consumption | Decimal | Specifies the Energy Consumption. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 43 | Collected from G/L Entries | Boolean | — | not editable |
| 44 | Collect From Date | Date | — | not editable |
| 45 | Collect To Date | Date | — | not editable |
| 5154 | Renewable Energy | Boolean | Specifies the Renewable Energy. <small>via [Page 6219 "Sustainability Journal"](../page/6219.md)</small> |  |
| 5817 | Correction | Boolean | — |  |

## Keys

- PK: Journal Template Name, Journal Batch Name, Line No. (clustered)
- SortOnDocumentNo: Document No.

## Events published

- `OnAfterInitDefaultDimensionSources(var SustainabilityJnlLine: Record "Sustainability Jnl. Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; FieldNo: Integer)` (integration)
- `OnAfterSetupNewLine(var SustainabilityJnlLine: Record "Sustainability Jnl. Line"; SustainabilityJnlBatch: Record "Sustainability Jnl. Batch"; PreviousSustainabilityJnlLine: Record "Sustainability Jnl. Line")` (integration)
- `OnBeforeCheckOpenApprovalEntryExistForCurrentUser(SustJnlLine: Record "Sustainability Jnl. Line"; CurrFieldNo: Integer; var IsHandled: Boolean)` (integration)

## Trigger event subscribers

- OnAfterInsertEvent: [Codeunit 6280 "Sust. Workflow Event Handling"](../codeunit/6280.md) RestrictSustJournalLineAfterInsert
- OnAfterModifyEvent: [Codeunit 6280 "Sust. Workflow Event Handling"](../codeunit/6280.md) RestrictSustJournalLineAfterModify
- OnBeforeDeleteEvent: [Codeunit 6280 "Sust. Workflow Event Handling"](../codeunit/6280.md) RemoveSustJournalLineRestrictionsBeforeDelete

## Procedures

- `SetupNewLine(PreviousLine: Record "Sustainability Jnl. Line")`
- `CreateDimFromDefaultDim(FieldNo: Integer)`
- `CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])`
- `GetPostingSign(SustainabilityJnlLine: Record "Sustainability Jnl. Line"): Integer`
- `UpdateSustainabilityJnlLineWithPostingSign(var SustainabilityJnlLine: Record "Sustainability Jnl. Line"; SignFactor: Integer)`
- `ShowDimensions(): Boolean` (internal)
- `SetGLCollectionInformation(FromDate: Date; ToDate: Date)` (internal)

Plus 12 local procedures.

## Triggers

OnDelete, OnInsert, OnModify, OnRename

## Relations

- lookup page [Page 6219 "Sustainability Journal"](../page/6219.md)
- Unit of Measure: TableRelation [Table 204 "Unit of Measure"](../table/204.md)
- Shortcut Dimension 1 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Shortcut Dimension 2 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Dimension Set ID: TableRelation [Table 480 "Dimension Set Entry"](../table/480.md)
- Responsibility Center: TableRelation [Table 5714 "Responsibility Center"](../table/5714.md)
- Account No.: TableRelation [Table 6210 "Sustainability Account"](../table/6210.md)
- Account Category: TableRelation [Table 6211 "Sustain. Account Category"](../table/6211.md)
- Account Subcategory: TableRelation [Table 6212 "Sustain. Account Subcategory"](../table/6212.md)
- Journal Batch Name: TableRelation [Table 6213 "Sustainability Jnl. Batch"](../table/6213.md)
- Journal Template Name: TableRelation [Table 6215 "Sustainability Jnl. Template"](../table/6215.md)
- Energy Source Code: TableRelation [Table 6233 "Sustainability Energy Source"](../table/6233.md)
- Country/Region Code: TableRelation [Table 9 "Country/Region"](../table/9.md)

## Referenced by

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

- [Table 6213 "Sustainability Jnl. Batch"](../table/6213.md): No. of Lines

## Pages and codeunits on this table

- [Page 6219 "Sustainability Journal"](../page/6219.md) (source table)
- [Page 6226 "Sustain. Jnl. Errors Factbox"](../page/6226.md) (source table)
- [Page 6230 "Sustainability Journal Line"](../page/6230.md) (source table)
- [Codeunit 6213 "Sustainability Jnl.-Post"](../codeunit/6213.md) (codeunit runs on it)
- [Codeunit 6214 "Sustainability Recur Jnl.-Post"](../codeunit/6214.md) (codeunit runs on it)
- [Codeunit 6216 "Sustainability Jnl.-Check"](../codeunit/6216.md) (codeunit runs on it)

## Extended by

- [Table extension 6290 "Sustainability Journal Line"](../tableextension/6290.md)

## 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.

- [Codeunit 1535 "Approvals Mgmt."](../codeunit/1535.md) (4 calls: `CheckOpenApprovalEntryExistForCurrentUser → PreventModifyRecIfOpenApprovalEntryExistForCurrentUser`, `OnDelete → PreventDeletingRecordWithOpenApprovalEntry`, `OnInsert → PreventInsertRecIfOpenApprovalEntryExist`, …)
- [Codeunit 408 "DimensionManagement"](../codeunit/408.md) (3 calls: `CreateDim → GetRecDefaultDimID`, `InitDefaultDimensionSources → AddDimSource`, `ShowDimensions → EditDimensionSet`)
- [Codeunit 6211 "Sustainability Journal Mgt."](../codeunit/6211.md) (1 call: `SetupNewLine → GetDocumentNo`)

## Recent changes

- 2026-09-16 [#10541 [Master] - Slice 641375: [Sustainability] Collect Amount from G/L Entries: track collected entries to prevent double counting](../../changes/bcapps/10541.md) (main, BC30, feature)

## Across versions

- Present in: BC29-30
- Changed (declaration) in: none

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## 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 Jnl. Line")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.