Table 6261 "Sust. G/L - Sust. Ledger Rel."

Sustainability · Microsoft.Sustainability.Ledger · captioned “G/L - Sustainability Entry Relation” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	G/L - Sustainability Entry Relation
Extensible	true
DataClassification	CustomerContent
LookupPageId	Sust. G/L - Sust. Ledger Rel.
DrillDownPageId	Sust. G/L - Sust. Ledger Rel.

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	G/L Entry No.	Integer	Specifies the general ledger entry that the amount was collected from. via Page 6339 “Sust. G/L - Sust. Ledger Rel.”	TableRelation Table 17 “G/L Entry” (G/L Entry); not editable
2	Sust. Ledger Entry No.	Integer	Specifies the sustainability ledger entry that was created from the collected amount. via Page 6339 “Sust. G/L - Sust. Ledger Rel.”	TableRelation Table 6216 “Sustainability Ledger Entry” (Sustainability Ledger Entry); not editable
3	Account Category	Code[20]	Specifies the sustainability account category that the general ledger entry was collected under. via Page 6339 “Sust. G/L - Sust. Ledger Rel.”	TableRelation Table 6211 “Sustain. Account Category” (Sustain. Account Category); not editable
4	Posting Date	Date	Specifies the posting date of the collected general ledger entry. via Page 6339 “Sust. G/L - Sust. Ledger Rel.”	not editable
5	Collected Amount	Decimal	Specifies the amount that was collected from the general ledger entry. via Page 6339 “Sust. G/L - Sust. Ledger Rel.”	not editable

Keys

PK: G/L Entry No., Sust. Ledger Entry No. (clustered)
SustLedgerEntryNo: Sust. Ledger Entry No.
AccountCategory: Account Category, Posting Date, G/L Entry No.

Procedures

CreateRelation(GLEntry: Record "G/L Entry"; SustLedgerEntryNo: Integer; AccountCategoryCode: Code[20]) (internal)
RemoveRelations(SustLedgerEntryNo: Integer) (internal)

Relations

drill-down page Page 6339 “Sust. G/L - Sust. Ledger Rel.”
lookup page Page 6339 “Sust. G/L - Sust. Ledger Rel.”
G/L Entry No.: TableRelation Table 17 “G/L Entry”
Account Category: TableRelation Table 6211 “Sustain. Account Category”
Sust. Ledger Entry No.: TableRelation Table 6216 “Sustainability Ledger Entry”

Pages and codeunits on this table

Page 6339 “Sust. G/L - Sust. Ledger Rel.” (source table)

Recent changes

2026-09-16 #10541 [Master] - Slice 641375: [Sustainability] Collect Amount from G/L Entries: track collected entries to prevent double counting (main, BC30, feature, added)

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. G/L - Sust. Ledger Rel."), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.