Table 6210 "Sustainability Account"

Sustainability · Microsoft.Sustainability.Account · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 6210 “Chart of Sustain. Accounts” (1 Learn page).

Properties

Property	Value
Caption	Sustainability Account
DataClassification	CustomerContent

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	No.	Code[20]	Specifies the account number of the sustainability account. via Page 6211 “Sustainability Account Card”	NotBlank
2	No. 2	Code[20]	Specifies the additional account number of the sustainability account. via Page 6211 “Sustainability Account Card”
3	Name	Text[100]	Specifies the name of the sustainability account. via Page 6211 “Sustainability Account Card”
4	Name 2	Text[100]	Specifies the additional name of the sustainability account. via Page 6211 “Sustainability Account Card”
5	Search Name	Code[100]	Specifies an alternate name that you can use to search for the record in question when you cannot remember the value in the Name field. via Page 6211 “Sustainability Account Card”
6	Category	Code[20]	Specifies the category of the sustainability account. via Page 6211 “Sustainability Account Card”	TableRelation Table 6211 “Sustain. Account Category” (Sustain. Account Category)
7	Subcategory	Code[20]	Specifies the subcategory of the category of the sustainability account. via Page 6211 “Sustainability Account Card”	TableRelation Table 6212 “Sustain. Account Subcategory” (“Sustain. Account Subcategory”.Code where(“Category Code” = field(Category)))
8	Emission Scope	Enum “Emission Scope”	Specifies the scope of the emissions that are associated with the sustainability account. Scope 1: Direct emissions from sources that are owned or controlled by the reporting entity. Scope 2: Indirect emissions from the generation of purchased electricity, heat, or steam consumed by the reporting en… via Page 6212 “Sustainability Account List”	FlowField: lookup(“Sustain. Account Category”.“Emission Scope” where(Code = field(Category))); enum Enum 6212 “Emission Scope”
9	Account Type	Enum “Sustainability Account Type”	Specifies the purpose of the account. Total: Used to total a series of balances on accounts from many different account groupings. To use Total, leave this field blank. Begin-Total: A marker for the beginning of a series of accounts to be totaled that ends with an End-Total account. End-Total: A tot… via Page 6211 “Sustainability Account Card”	enum Enum 6211 “Sustainability Account Type”
10	Totaling	Text[250]	Specifies an account interval or a list of account numbers. The entries of the account will be totaled to give a total balance. How entries are totaled depends on the value in the Account Type field. via Page 6211 “Sustainability Account Card”
11	Blocked	Boolean	Specifies if the account is blocked. If the field is selected, then the account is blocked and you cannot post to it. via Page 6211 “Sustainability Account Card”
12	Direct Posting	Boolean	Specifies whether you will be able to post directly or only indirectly to this sustainability account. To allow Direct Posting to the sustainability account, place a check mark in the check box. via Page 6211 “Sustainability Account Card”
13	Indentation	Integer	—	not editable
14	Global Dimension 1 Code	Code[20]	Specifies the global dimension 1 value. via Page 6211 “Sustainability Account Card”	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1), Blocked = const(false)))
15	Global Dimension 2 Code	Code[20]	Specifies the global dimension 2 value. via Page 6211 “Sustainability Account Card”	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2), Blocked = const(false)))
16	Comment	Boolean	—	FlowField: exist(“Comment Line” where(“Table Name” = const(“Sustainability Account”), “No.” = field(“No.”))); not editable
100	Net Change (CO2)	Decimal	Specifies the CO2 net change on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Emission CO2” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dim…; not editable
101	Balance at Date (CO2)	Decimal	Specifies the CO2 balance at date on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Emission CO2” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dim…; not editable
102	Balance (CO2)	Decimal	Specifies the CO2 balance on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Emission CO2” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dim…; not editable
103	Net Change (CH4)	Decimal	Specifies the CH4 net change on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Emission CH4” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dim…; not editable
104	Balance at Date (CH4)	Decimal	Specifies the CH4 balance at date on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Emission CH4” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dim…; not editable
105	Balance (CH4)	Decimal	Specifies the CH4 balance on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Emission CH4” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dim…; not editable
106	Net Change (N2O)	Decimal	Specifies the N2O net change on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Emission N2O” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dim…; not editable
107	Balance at Date (N2O)	Decimal	Specifies the N2O balance at date on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Emission N2O” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dim…; not editable
108	Balance (N2O)	Decimal	Specifies the N2O balance on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Emission N2O” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global Dim…; not editable
109	Net Change (Water)	Decimal	Specifies the Water net change on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Water Intensity” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global …; not editable
110	Balance at Date (Water)	Decimal	Specifies the Water balance at date on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Water Intensity” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global …; not editable
111	Balance (Water)	Decimal	Specifies the Water balance on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Water Intensity” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global …; not editable
112	Net Change (Disch. Water)	Decimal	Specifies the Disch. Water net change on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Discharged Into Water” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“G…; not editable
113	Balance at Date (Disch. Water)	Decimal	Specifies the Disch. Water balance at date on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Discharged Into Water” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“G…; not editable
114	Balance (Disch. Water)	Decimal	Specifies the Disch. Water balance on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Discharged Into Water” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“G…; not editable
115	Net Change (Waste)	Decimal	Specifies the Waste net change on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Waste Intensity” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global …; not editable
116	Balance at Date (Waste)	Decimal	Specifies the Waste balance at date on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Waste Intensity” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global …; not editable
117	Balance (Waste)	Decimal	Specifies the Waste balance on this account. via Page 6211 “Sustainability Account Card”	FlowField: sum(“Sustainability Ledger Entry”.“Waste Intensity” where(“Account No.” = field(“No.”), “Account No.” = field(filter(Totaling)), “Responsibility Center” = field(“Responsibility Center Filter”), “Global Dimension 1 Code” = field(“Global Dimension 1 Filter”), “Global Dimension 2 Code” = field(“Global …; not editable
200	Responsibility Center Filter	Code[20]	—	TableRelation Table 5714 “Responsibility Center” (Responsibility Center); FlowFilter
201	Date Filter	Date	—	FlowFilter
202	Global Dimension 1 Filter	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(1))); FlowFilter
203	Global Dimension 2 Filter	Code[20]	—	TableRelation Table 349 “Dimension Value” (“Dimension Value”.Code where(“Global Dimension No.” = const(2))); FlowFilter
204	Dimension Set ID Filter	Integer	—	FlowFilter

Keys

Key1: No. (clustered)

Procedures

CheckAccountReadyForPosting()
IsPosting(): Boolean

Plus 1 local procedures.

Triggers

OnDelete, OnInsert

Relations

drill-down page Page 6210 “Chart of Sustain. Accounts”
lookup page Page 6212 “Sustainability Account List”
Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
Global Dimension 1 Filter: TableRelation Table 349 “Dimension Value”
Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
Global Dimension 2 Filter: TableRelation Table 349 “Dimension Value”
Responsibility Center Filter: TableRelation Table 5714 “Responsibility Center”
Emission Scope: CalcFormula Table 6211 “Sustain. Account Category”
Category: TableRelation Table 6211 “Sustain. Account Category”
Subcategory: TableRelation Table 6212 “Sustain. Account Subcategory”
Balance (CH4): CalcFormula Table 6216 “Sustainability Ledger Entry”
Balance (CO2): CalcFormula Table 6216 “Sustainability Ledger Entry”
Balance (Disch. Water): CalcFormula Table 6216 “Sustainability Ledger Entry”
Balance (N2O): CalcFormula Table 6216 “Sustainability Ledger Entry”
Balance (Waste): CalcFormula Table 6216 “Sustainability Ledger Entry”
Balance (Water): CalcFormula Table 6216 “Sustainability Ledger Entry”
Balance at Date (CH4): CalcFormula Table 6216 “Sustainability Ledger Entry”
Balance at Date (CO2): CalcFormula Table 6216 “Sustainability Ledger Entry”
Balance at Date (Disch. Water): CalcFormula Table 6216 “Sustainability Ledger Entry”
Balance at Date (N2O): CalcFormula Table 6216 “Sustainability Ledger Entry”
Balance at Date (Waste): CalcFormula Table 6216 “Sustainability Ledger Entry”
Balance at Date (Water): CalcFormula Table 6216 “Sustainability Ledger Entry”
Net Change (CH4): CalcFormula Table 6216 “Sustainability Ledger Entry”
Net Change (CO2): CalcFormula Table 6216 “Sustainability Ledger Entry”
Net Change (Disch. Water): CalcFormula Table 6216 “Sustainability Ledger Entry”
Net Change (N2O): CalcFormula Table 6216 “Sustainability Ledger Entry”
Net Change (Waste): CalcFormula Table 6216 “Sustainability Ledger Entry”
Net Change (Water): CalcFormula Table 6216 “Sustainability Ledger Entry”
Comment: CalcFormula Table 97 “Comment Line”

Referenced by

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

Table 6225 “Sust. Account (Analysis View)”: No., Totaling
Table extension 6265 “Sust. FA Reclass. Journal Line”: New Sust. Account No., Sust. Account No.
Table 6214 “Sustainability Jnl. Line”: Account No.
Table 6216 “Sustainability Ledger Entry”: Account No.
Table 6227 “Sustainability Value Entry”: Account No.
Table 6240 “Sust. Excise Jnl. Line”: Account No.
Table 6241 “Sust. Excise Taxes Trans. Log”: Account No.
Table 6290 “Sustain. Emission Suggestion”: Account No.
Table extension 6211 “Sustainability Purch. Line”: Sust. Account No.
Table extension 6213 “Sust. Purch. Cr. Memo Line”: Sust. Account No.
Table extension 6214 “Sust. Purch. Inv. Line”: Sust. Account No.
Table extension 6215 “Sust. Purch. Ret. Shpt. Line”: Sust. Account No.
Table extension 6216 “Sust. Purch. Rcpt. Line”: Sust. Account No.
Table extension 6220 “Sust. Item”: Default Sust. Account
Table extension 6224 “Sust. Gen. Journal Line”: Sust. Account No.
Table extension 6225 “Sust. Posted Gen. Journal Line”: Sust. Account No.
Table extension 6227 “Sust. G/L Account”: Default Sust. Account
Table extension 6228 “Sust. Item Category”: Default Sust. Account
Table extension 6229 “Sust. Item Charge”: Default Sust. Account
Table extension 6230 “Sust. Resource”: Default Sust. Account
Table extension 6231 “Sust. Work Center”: Default Sust. Account
Table extension 6232 “Sust. Machine Center”: Default Sust. Account
Table extension 6233 “Sust. Item Journal Line”: Sust. Account No.
Table extension 6235 “Sustainability Sales Line”: Sust. Account No.
Table extension 6237 “Sust. Sales Cr. Memo Line”: Sust. Account No.
Table extension 6239 “Sust. Sales Invoice Line”: Sust. Account No.
Table extension 6240 “Sust. Sales Ret. Rcpt. Line”: Sust. Account No.
Table extension 6241 “Sust. Sales Shipment Line”: Sust. Account No.
Table extension 6246 “Sust. Prod. Order Component”: Sust. Account No.
Table extension 6247 “Sust. Prod. Order Routing Line”: Sust. Account No.
Table extension 6248 “Sust. Prod. Order Line”: Sust. Account No.
Table extension 6250 “Sust. Transfer Line”: Sust. Account No.
Table extension 6251 “Sustainability Assembly Header”: Sust. Account No.
Table extension 6252 “Sust. Assembly Line”: Sust. Account No.
Table extension 6253 “Sust. Posted Assembly Header”: Sust. Account No.
Table extension 6254 “Sust. Posted Assembly Line”: Sust. Account No.
Table extension 6256 “Sust. Transfer Shipment Line”: Sust. Account No.
Table extension 6258 “Sust. Job Journal Line”: Sust. Account No.
Table extension 6259 “Sust. Capacity Ledger Entry”: Sust. Account No.
Table extension 6261 “Sust. Item Ledger Entry”: Sust. Account No.
Table extension 6263 “Sust. FA Ledger Entry”: Sust. Account No.
Table extension 6264 “Sust. FA Journal Line”: Sust. Account No.
Table extension 6267 “Sust. Fixed Asset”: Default Sust. Account
Table extension 6271 “Sustainability Service Line”: Sust. Account No.
Table extension 6273 “Sust. Service Cr. Memo Line”: Sust. Account No.
Table extension 6275 “Sust. Service Invoice Line”: Sust. Account No.
Table extension 6276 “Sust. Service Shipment Line”: Sust. Account No.
Table extension 6279 “Sust. Resource Journal Line”: Sust. Account No.
Table extension 6281 “Sust. Invoice Posting Buffer”: Sust. Account No.

Pages and codeunits on this table

Page 6210 “Chart of Sustain. Accounts” (source table)
Page 6211 “Sustainability Account Card” (source table)
Page 6212 “Sustainability Account List” (source table)
Page 6227 “Sustainability Accounts” (source table)

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 408 “DimensionManagement” (3 calls: OnInsert → UpdateDefaultDim, ValidateShortcutDimCode → SaveDefaultDim, ValidateShortcutDimCode → ValidateDimValueCode)

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