Table 6230 "Sust. ESG Reporting Line"

Sustainability · Microsoft.Sustainability.ESGReporting · captioned “ESG Reporting Line” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	ESG Reporting Line
DataClassification	CustomerContent
LookupPageId	Sust. ESG Reporting Lines
DrillDownPageId	Sust. ESG Reporting Lines

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	ESG Reporting Template Name	Code[10]	Specifies the value of the ESG Reporting Template Name field. via Page 6295 “Sust. ESG Reporting Lines”	TableRelation Table 6228 “Sust. ESG Reporting Template” (Sust. ESG Reporting Template)
2	ESG Reporting Name	Code[10]	Specifies the value of the ESG Reporting Name field. via Page 6295 “Sust. ESG Reporting Lines”	TableRelation Table 6229 “Sust. ESG Reporting Name” (“Sust. ESG Reporting Name”.Name where(“ESG Reporting Template Name” = field(“ESG Reporting Template Name”)))
4	Line No.	Integer	Specifies the value of the Line No. field. via Page 6295 “Sust. ESG Reporting Lines”
5	Grouping	Text[100]	Specifies the value of the Grouping field. via Page 6295 “Sust. ESG Reporting Lines”
6	Row No.	Code[10]	Specifies a number that identifies the line. via Page 6295 “Sust. ESG Reporting Lines”
7	Description	Text[500]	Specifies a description of the ESG reporting line. via Page 6295 “Sust. ESG Reporting Lines”
8	Reporting Code	Text[100]	Specifies the value of the Reporting Code field. via Page 6295 “Sust. ESG Reporting Lines”
9	Field Type	Enum “Sust. ESG Reporting Field Type”	Specifies the value of the Field Type field. via Page 6295 “Sust. ESG Reporting Lines”	enum Enum 6221 “Sust. ESG Reporting Field Type”
10	Table No.	Integer	Specifies the value of the Table No. field. via Page 6295 “Sust. ESG Reporting Lines”	TableRelation if (“Field Type” = const(“Table Field”)) AllObj.“Object Id” where(“Object Type” = const(Table))
11	Field No.	Integer	Specifies the value of the Field No. field. via Page 6295 “Sust. ESG Reporting Lines”
15	Source	Text[250]	Specifies the value of the Source field. via Page 6295 “Sust. ESG Reporting Lines”
16	Field Caption	Text[250]	Specifies the value of the Value field. via Page 6295 “Sust. ESG Reporting Lines”
20	Value Settings	Enum “Sust. ESG Value Settings”	Specifies the value of the Value Settings field. via Page 6295 “Sust. ESG Reporting Lines”	enum Enum 6222 “Sust. ESG Value Settings”
21	Account Filter	Text[250]	Specifies the value of the Account Filter field. via Page 6295 “Sust. ESG Reporting Lines”
22	Date Filter	Date	—	FlowFilter; not editable
25	Reporting Unit	Code[20]	Specifies the value of the Reporting Unit field. via Page 6295 “Sust. ESG Reporting Lines”	TableRelation Table 6252 “Sust. ESG Reporting Unit” (“Sust. ESG Reporting Unit”.Code)
27	Row Type	Option	Specifies the value of the Row Type field. via Page 6295 “Sust. ESG Reporting Lines”	OptionCaption: Net Change,Balance at Date,Year to Date,Beginning Balance
28	Row Totaling	Text[50]	Specifies the value of the Row Totaling field. via Page 6295 “Sust. ESG Reporting Lines”
30	Calculate With	Option	Specifies the value of the Calculate with field. via Page 6295 “Sust. ESG Reporting Lines”	OptionCaption: Sign,Opposite Sign
31	Show	Boolean	Specifies the value of the Show field. via Page 6295 “Sust. ESG Reporting Lines”
32	Show With	Option	Specifies the value of the Show with field. via Page 6295 “Sust. ESG Reporting Lines”	OptionCaption: Sign,Opposite Sign
33	Rounding	Enum “Sust. ESG Rounding Factor”	Specifies the value of the Rounding field. via Page 6295 “Sust. ESG Reporting Lines”	enum Enum 6223 “Sust. ESG Rounding Factor”
35	Goal SystemID	Guid	—
36	Concept Link	Text[840]	Specifies the Concept link of the Source field. via Page 6252 “Sust. ESG Report. Aggregation”
37	Concept	Text[400]	Specifies the Concept of the Source field. via Page 6252 “Sust. ESG Report. Aggregation”
40	Coupled to Dataverse	Boolean	Specifies that the reporting line is coupled to an assessment requirement in Dataverse.	FlowField: exist(“CRM Integration Record” where(“Integration ID” = field(SystemId), “Table ID” = const(Database::“Sust. ESG Reporting Line”))); not editable
55	Derived From SystemId	Guid	—	TableRelation Table 6230 “Sust. ESG Reporting Line” (“Sust. ESG Reporting Line”.SystemId)
60	Assessment ID	Guid	—
61	Standard Requirement ID	Guid	—
62	Parent Standard Requirement ID	Guid	—
63	Requirement Concept ID	Guid	—
64	Concept ID	Guid	—
65	Assessment Requirement ID	Guid	—

Keys

Key1: ESG Reporting Template Name, ESG Reporting Name, Line No. (clustered)

Procedures

LookupTotaling()

Plus 1 local procedures.

Relations

drill-down page Page 6295 “Sust. ESG Reporting Lines”
lookup page Page 6295 “Sust. ESG Reporting Lines”
Coupled to Dataverse: CalcFormula Table 5331 “CRM Integration Record”
ESG Reporting Template Name: TableRelation Table 6228 “Sust. ESG Reporting Template”
ESG Reporting Name: TableRelation Table 6229 “Sust. ESG Reporting Name”
Derived From SystemId: TableRelation Table 6230 “Sust. ESG Reporting Line”
Reporting Unit: TableRelation Table 6252 “Sust. ESG Reporting Unit”

Referenced by

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

Table 6230 “Sust. ESG Reporting Line”: Derived From SystemId
Table 6232 “Sust. Posted ESG Report Line”: Derived From SystemId

Pages and codeunits on this table

Page 6252 “Sust. ESG Report. Aggregation” (source table)
Page 6255 “Sust. ESG Reporting Prev. Line” (source table)
Page 6295 “Sust. ESG Reporting Lines” (source table)
Codeunit 6261 “Sust. ESG Reporting Post. Mgt” (codeunit runs on it)

Ask your agent

Procedure bodies are not stored here (D10). 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: "Sust. ESG Reporting Line"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.