Table 6232 "Sust. Posted ESG Report Line"

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

Properties

Property	Value
Caption	Posted ESG Report Line
DataClassification	CustomerContent
LookupPageId	Sust. Posted ESG Report Lines
DrillDownPageId	Sust. Posted ESG Report 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 6298 “Sust. Posted ESG Report 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 6298 “Sust. Posted ESG Report Lines”	TableRelation Table 6229 “Sust. ESG Reporting Name” (“Sust. ESG Reporting Name”.Name where(“ESG Reporting Template Name” = field(“ESG Reporting Template Name”)))
3	Document No.	Code[20]	Specifies the value of the Document No. field. via Page 6298 “Sust. Posted ESG Report Lines”
4	Line No.	Integer	—
5	Grouping	Text[100]	Specifies the value of the Grouping field. via Page 6298 “Sust. Posted ESG Report Lines”
6	Row No.	Code[10]	Specifies a number that identifies the line. via Page 6298 “Sust. Posted ESG Report Lines”
7	Description	Text[500]	Specifies a description of the ESG reporting line. via Page 6298 “Sust. Posted ESG Report Lines”
8	Reporting Code	Text[100]	Specifies the value of the Reporting Code field. via Page 6298 “Sust. Posted ESG Report Lines”
9	Field Type	Enum “Sust. ESG Reporting Field Type”	Specifies the value of the Field Type field. via Page 6298 “Sust. Posted ESG Report Lines”	enum Enum 6221 “Sust. ESG Reporting Field Type”
10	Table No.	Integer	Specifies the value of the Table No. field. via Page 6298 “Sust. Posted ESG Report 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 6298 “Sust. Posted ESG Report Lines”
15	Source	Text[250]	Specifies the value of the Source field. via Page 6298 “Sust. Posted ESG Report Lines”
16	Field Caption	Text[250]	Specifies the value of the Value field. via Page 6298 “Sust. Posted ESG Report Lines”
20	Value Settings	Enum “Sust. ESG Value Settings”	Specifies the value of the Value Settings field. via Page 6298 “Sust. Posted ESG Report Lines”	enum Enum 6222 “Sust. ESG Value Settings”
21	Account Filter	Text[250]	Specifies the value of the Account Filter field. via Page 6298 “Sust. Posted ESG Report Lines”
22	Date Filter	Date	—	FlowFilter; not editable
25	Reporting Unit	Code[20]	Specifies the value of the Reporting Unit field. via Page 6298 “Sust. Posted ESG Report 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 6298 “Sust. Posted ESG Report 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 6298 “Sust. Posted ESG Report Lines”
30	Calculate With	Option	Specifies the value of the Calculate with field. via Page 6298 “Sust. Posted ESG Report Lines”	OptionCaption: Sign,Opposite Sign
31	Show	Boolean	Specifies the value of the Show field. via Page 6298 “Sust. Posted ESG Report Lines”
32	Show With	Option	Specifies the value of the Show with field. via Page 6298 “Sust. Posted ESG Report Lines”	OptionCaption: Sign,Opposite Sign
33	Rounding	Enum “Sust. ESG Rounding Factor”	Specifies the value of the Rounding field. via Page 6298 “Sust. Posted ESG Report 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 6298 “Sust. Posted ESG Report Lines”
37	Concept	Text[400]	Specifies the Concept of the Source field. via Page 6298 “Sust. Posted ESG Report Lines”
40	Posted Amount	Decimal	Specifies the value of the Posted Amount field. via Page 6298 “Sust. Posted ESG Report Lines”
50	Coupled to Dataverse	Boolean	Specifies that the posted reporting line is coupled to an esg fact in Dataverse.	FlowField: exist(“CRM Integration Record” where(“Integration ID” = field(SystemId), “Table ID” = const(Database::“Sust. Posted ESG Report 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: Document No., Line No. (clustered)

Procedures

LookupTotaling()
CopyFromESGReportingLine(ESGReportingLine: Record "Sust. ESG Reporting Line") (internal)

Relations

drill-down page Page 6298 “Sust. Posted ESG Report Lines”
lookup page Page 6298 “Sust. Posted ESG Report 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”

Pages and codeunits on this table

Page 6258 “Sust. Posted ESG Report Sub.” (source table)
Page 6298 “Sust. Posted ESG Report Lines” (source table)
Page 6334 “Sust. Posted ESG Report Line” (source table)

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