Table 6246 "Sust. ESG Fact"

Sustainability · Microsoft.Sustainability.CRM · captioned “Fact” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Fact
TableType	CRM
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	ESGFactId	Guid	Fact caption
2	CreatedOn	DateTime	Created On caption
3	CreatedBy	Guid	Created By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
4	ModifiedOn	DateTime	Modified On caption
5	ModifiedBy	Guid	Modified By caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
6	CreatedOnBehalfBy	Guid	Created By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
7	ModifiedOnBehalfBy	Guid	Modified By (Delegate) caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
16	OwnerId	Guid	Owner caption
21	OwningBusinessUnit	Guid	Owning Business Unit caption	TableRelation Table 5364 “CRM Businessunit” (“CRM Businessunit”.BusinessUnitId)
22	OwningUser	Guid	Owning User caption	TableRelation Table 5340 “CRM Systemuser” (“CRM Systemuser”.SystemUserId)
23	OwningTeam	Guid	Owning Team caption	TableRelation Table 5359 “CRM Team” (“CRM Team”.TeamId)
25	StateCode	Option	Status caption
27	StatusCode	Option	Status Reason caption
29	VersionNumber	BigInteger	Version Number caption
30	ImportSequenceNumber	Integer	Import Sequence Number caption
31	OverriddenCreatedOn	Date	Record Created On caption
32	TimeZoneRuleVersionNumber	Integer	Time Zone Rule Version Number caption
33	UTCConversionTimeZoneCode	Integer	UTC Conversion Time Zone Code caption
34	Name	Text[500]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center. via Page 6292 “Sust. ESG Fact List”
37	Concept	Guid	—	TableRelation Table 6245 “Sust. Concept” (“Sust. Concept”.ConceptId)
38	FactStatus	Option	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center. via Page 6292 “Sust. ESG Fact List”
40	NumericValue	Decimal	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center. via Page 6292 “Sust. ESG Fact List”
41	Period	Guid	—	TableRelation Table 6247 “Sust. Range Period” (“Sust. Range Period”.RangePeriodId)
42	Precision	Integer	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center. via Page 6292 “Sust. ESG Fact List”
43	TextValue	Blob	Text Value caption
44	Unit	Guid	—	TableRelation Table 6251 “Sust. Unit” (“Sust. Unit”.UnitId)
45	BooleanValue	Boolean	Boolean Value caption
47	RichTextValue	Blob	Rich Text Value caption
48	Source	Option	—
50	AccuracyReviewed	Boolean	Reviewed For Accuracy caption
52	CopilotGenerated	Boolean	Found With Copilot caption
54	OriginCorrelationId	Text[100]	Origin Correlation ID caption
55	FactGenerationPartialSuccess	Boolean	Fact Generation Partial Success caption
60	PeriodName	Text[100]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center. via Page 6292 “Sust. ESG Fact List”	FlowField: lookup(“Sust. Range Period”.Name where(RangePeriodId = field(Period)))
65	ConceptName	Text[400]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center. via Page 6292 “Sust. ESG Fact List”	FlowField: lookup(“Sust. Concept”.Name where(ConceptId = field(Concept)))
70	UnitName	Text[100]	Specifies data from a corresponding field in a Dataverse entity. For more information about Dataverse, see Dataverse Help Center. via Page 6292 “Sust. ESG Fact List”	FlowField: lookup(“Sust. Unit”.Name where(UnitId = field(Unit)))

Keys

PK: ESGFactId (clustered)
Name: Name

Relations

CreatedBy: TableRelation Table 5340 “CRM Systemuser”
CreatedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedBy: TableRelation Table 5340 “CRM Systemuser”
ModifiedOnBehalfBy: TableRelation Table 5340 “CRM Systemuser”
OwningUser: TableRelation Table 5340 “CRM Systemuser”
OwningTeam: TableRelation Table 5359 “CRM Team”
OwningBusinessUnit: TableRelation Table 5364 “CRM Businessunit”
ConceptName: CalcFormula Table 6245 “Sust. Concept”
Concept: TableRelation Table 6245 “Sust. Concept”
PeriodName: CalcFormula Table 6247 “Sust. Range Period”
Period: TableRelation Table 6247 “Sust. Range Period”
UnitName: CalcFormula Table 6251 “Sust. Unit”
Unit: TableRelation Table 6251 “Sust. Unit”

Referenced by

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

Table 6243 “Sust. Assessment Req. Fact”: Esg Fact

Pages and codeunits on this table

Page 6292 “Sust. ESG Fact List” (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. ESG Fact"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.