tableSustainabilityofficial - Microsoftderived - from the source, no model text

Table 6214 "Sustainability Jnl. Line"

Sustainability · Microsoft.Sustainability.Journal

Across versions

  1. BC23-28not present
  2. BC29-30present

Neighbourhood 24 connected objects and pages

Table 349 "Dimension Value" (relates to, 2 links)Dimension ValueTable 204 "Unit of Measure" (relates to)Unit of MeasureTable 480 "Dimension Set Entry" (relates to)Dimension Set EntryTable 5714 "Responsibility Center" (relates to)Responsibility CenterTable 6210 "Sustainability Account" (relates to)Table 6211 "Sustain. Account Category" (relates to)Sustain. Account CategoryTable 6212 "Sustain. Account Subcategory" (relates to)Sustain. Account SubcategoryTable 6213 "Sustainability Jnl. Batch" (relates to)Sustainability Jnl. BatchTable 6215 "Sustainability Jnl. Template" (relates to)Sustainability Jnl. TemplateTable 6233 "Sustainability Energy Source" (relates to)Sustainability Energy SourceTable 9 "Country/Region" (relates to)Country/RegionPage 6219 "Sustainability Journal" (pages and codeunits on it, 2 links)Sustainability JournalCodeunit 6213 "Sustainability Jnl.-Post" (pages and codeunits on it)Codeunit 6214 "Sustainability Recur Jnl.-Post" (pages and codeunits on it)Codeunit 6216 "Sustainability Jnl.-Check" (pages and codeunits on it)Page 6226 "Sustain. Jnl. Errors Factbox" (pages and codeunits on it)Page 6230 "Sustainability Journal Line" (pages and codeunits on it)Table extension 6290 "Sustainability Journal Line" (extended by)Codeunit 6280 "Sust. Workflow Event Handling" (event subscribers, 3 links)Sust. Workflow Event HandlingCodeunit 1535 "Approvals Mgmt." (calls, 4 links)Approvals Mgmt.Codeunit 408 "DimensionManagement" (calls, 3 links)DimensionManagementCodeunit 6211 "Sustainability Journal Mgt." (calls)Table 6213 "Sustainability Jnl. Batch" (referenced by)Record sustainability entries (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

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

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

Referenced by

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

Pages and codeunits on this table

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.

Recent changes

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.

Evidence 1 sources