Table 6214 "Sustainability Jnl. Line"
Sustainability · Microsoft.Sustainability.Journal
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 24 connected objects and pages
Sustainability · Microsoft.Sustainability.Journal · captioned “Sustainability Journal Line” · BC29-30 · source at ea08af5e · facts from BC29
Learn documents this table through its pages: Page 6219 “Sustainability Journal” (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” (Sustainability Jnl. Template); NotBlank |
| 2 | Journal Batch Name | Code[10] | — | TableRelation Table 6213 “Sustainability Jnl. Batch” (“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. via Page 6219 “Sustainability Journal” | NotBlank |
| 5 | Document No. | Code[20] | Specifies the document number. via Page 6219 “Sustainability Journal” | NotBlank |
| 6 | Document Type | Enum “Sustainability Jnl. Doc. Type” | Specifies the type of the document. via Page 6219 “Sustainability Journal” | enum Enum 6213 “Sustainability Jnl. Doc. Type” |
| 7 | Account No. | Code[20] | Specifies the sustainability account number. via Page 6219 “Sustainability Journal” | TableRelation Table 6210 “Sustainability Account” (“Sustainability Account” where(“Account Type” = const(Posting), Blocked = const(false))) |
| 8 | Account Name | Text[100] | Specifies the sustainability account name. via Page 6219 “Sustainability Journal” | |
| 9 | Account Category | Code[20] | Specifies the sustainability account category. via Page 6219 “Sustainability Journal” | TableRelation Table 6211 “Sustain. Account Category” (Sustain. Account Category); not editable |
| 10 | Account Subcategory | Code[20] | Specifies the sustainability account subcategory. via Page 6219 “Sustainability Journal” | 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 journal line. via Page 6219 “Sustainability Journal” | |
| 12 | Manual Input | Boolean | Specifies whether the amounts will be input manually. via Page 6219 “Sustainability Journal” | |
| 13 | Unit of Measure | Code[10] | Specifies the unit of measure of the journal line. via Page 6219 “Sustainability Journal” | TableRelation Table 204 “Unit of Measure” (Unit of Measure); NotBlank |
| 14 | Fuel/Electricity | Decimal | Specifies the fuel or electricity of the journal line. via Page 6219 “Sustainability Journal” | |
| 15 | Distance | Decimal | Specifies the distance of the journal line. via Page 6219 “Sustainability Journal” | |
| 16 | Custom Amount | Decimal | Specifies the custom amount of the journal line. via Page 6219 “Sustainability Journal” | |
| 17 | Installation Multiplier | Decimal | Specifies the installation multiplier of the journal line. via Page 6219 “Sustainability Journal” | |
| 18 | Time Factor | Decimal | Specifies the time factor of the journal line. via Page 6219 “Sustainability Journal” | |
| 19 | Emission CO2 | Decimal | Specifies the emission CO2 of the journal line. via Page 6219 “Sustainability Journal” | |
| 20 | Emission CH4 | Decimal | Specifies the emission CH4 of the journal line. via Page 6219 “Sustainability Journal” | |
| 21 | Emission N2O | Decimal | Specifies the emission N2O of the journal line. via Page 6219 “Sustainability Journal” | |
| 22 | Country/Region Code | Code[10] | Specifies the country/region code of the journal line. via Page 6219 “Sustainability Journal” | TableRelation Table 9 “Country/Region” (Country/Region) |
| 23 | Responsibility Center | Code[10] | Specifies the responsibility center of the journal line. via Page 6219 “Sustainability Journal” | TableRelation Table 5714 “Responsibility Center” (Responsibility Center) |
| 24 | Recurring Method | Enum “Sustain. Jnl. Recur. Method” | Specifies the recurring method. via Page 6219 “Sustainability Journal” | enum Enum 6214 “Sustain. Jnl. Recur. Method” |
| 25 | Recurring Frequency | DateFormula | Specifies the recurring frequency. via Page 6219 “Sustainability Journal” | |
| 26 | Expiration Date | Date | Specifies the expiration date. via Page 6219 “Sustainability Journal” | |
| 34 | Water Intensity | Decimal | Specifies the Water Intensity of the entry. via Page 6219 “Sustainability Journal” | |
| 35 | Discharged Into Water | Decimal | Specifies the Discharged Into Water of the entry. via Page 6219 “Sustainability Journal” | |
| 36 | Waste Intensity | Decimal | Specifies the Waste Intensity of the entry. via Page 6219 “Sustainability Journal” | |
| 37 | Water/Waste Intensity Type | Enum “Water/Waste Intensity Type” | Specifies the Water/Waste Intensity Type of the entry. via Page 6219 “Sustainability Journal” | enum Enum 6217 “Water/Waste Intensity Type” |
| 38 | Water Type | Enum “Water Type” | Specifies the Water Type of the entry. via Page 6219 “Sustainability Journal” | enum Enum 6218 “Water Type” |
| 480 | Dimension Set ID | Integer | — | TableRelation Table 480 “Dimension Set Entry” (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. via Page 6219 “Sustainability Journal” | TableRelation Table 349 “Dimension Value” (“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. via Page 6219 “Sustainability Journal” | TableRelation Table 349 “Dimension Value” (“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. via Page 6219 “Sustainability Journal” | TableRelation Source Code |
| 31 | Reason Code | Code[10] | Specifies the reason code of the journal line. via Page 6219 “Sustainability Journal” | TableRelation Reason Code |
| 32 | CO2e Emission | Decimal | — | |
| 40 | Energy Source Code | Code[20] | Specifies the Energy Source Code. via Page 6219 “Sustainability Journal” | TableRelation Table 6233 “Sustainability Energy Source” (Sustainability Energy Source) |
| 42 | Energy Consumption | Decimal | Specifies the Energy Consumption. via Page 6219 “Sustainability Journal” | |
| 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. via Page 6219 “Sustainability Journal” | |
| 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” RestrictSustJournalLineAfterInsert
- OnAfterModifyEvent: Codeunit 6280 “Sust. Workflow Event Handling” RestrictSustJournalLineAfterModify
- OnBeforeDeleteEvent: Codeunit 6280 “Sust. Workflow Event Handling” 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"): IntegerUpdateSustainabilityJnlLineWithPostingSign(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”
- Unit of Measure: TableRelation Table 204 “Unit of Measure”
- Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Responsibility Center: TableRelation Table 5714 “Responsibility Center”
- Account No.: TableRelation Table 6210 “Sustainability Account”
- Account Category: TableRelation Table 6211 “Sustain. Account Category”
- Account Subcategory: TableRelation Table 6212 “Sustain. Account Subcategory”
- Journal Batch Name: TableRelation Table 6213 “Sustainability Jnl. Batch”
- Journal Template Name: TableRelation Table 6215 “Sustainability Jnl. Template”
- Energy Source Code: TableRelation Table 6233 “Sustainability Energy Source”
- Country/Region Code: TableRelation Table 9 “Country/Region”
Referenced by
1 fields in 1 objects relate to this table (TableRelation or CalcFormula).
- Table 6213 “Sustainability Jnl. Batch”: No. of Lines
Pages and codeunits on this table
- Page 6219 “Sustainability Journal” (source table)
- Page 6226 “Sustain. Jnl. Errors Factbox” (source table)
- Page 6230 “Sustainability Journal Line” (source table)
- Codeunit 6213 “Sustainability Jnl.-Post” (codeunit runs on it)
- Codeunit 6214 “Sustainability Recur Jnl.-Post” (codeunit runs on it)
- Codeunit 6216 “Sustainability Jnl.-Check” (codeunit runs on it)
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.
- Codeunit 1535 “Approvals Mgmt.” (4 calls:
CheckOpenApprovalEntryExistForCurrentUser → PreventModifyRecIfOpenApprovalEntryExistForCurrentUser,OnDelete → PreventDeletingRecordWithOpenApprovalEntry,OnInsert → PreventInsertRecIfOpenApprovalEntryExist, …) - Codeunit 408 “DimensionManagement” (3 calls:
CreateDim → GetRecDefaultDimID,InitDefaultDimensionSources → AddDimSource,ShowDimensions → EditDimensionSet) - Codeunit 6211 “Sustainability Journal Mgt.” (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 (main, BC30, feature)
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.