---
id: object/table/6232
type: object
title: Table 6232 "Sust. Posted ESG Report Line"
summary: Table 6232 "Sust. Posted ESG Report Line" in Sustainability (Microsoft.Sustainability.ESGReporting). 35 fields, 2 public procedures. Introduced in BC29, still in BC30.
tier: official
language: en
tags:
  - table
  - sustainability
versions:
  introduced: "29"
  last_changed: null
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 98d423b7632d04e2855c5319c66039daa5061a7e7e7a9adb6a1a99f8debe693a
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Sustainability/app/src/ESGReporting/SustPostedESGReportLine.Table.al
    title: src/Apps/W1/Sustainability/app/src/ESGReporting/SustPostedESGReportLine.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
object_type: table
object_id: 6232
name: Sust. Posted ESG Report Line
caption: Posted ESG Report Line
namespace: Microsoft.Sustainability.ESGReporting
app: Sustainability
extends: null
first_version: "29"
last_version: "30"
present_in:
  - "29"
  - "30"
changed_in: []
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 35
  procedures: 2
  events: 0
  subscribers: 0
relations:
  out: 7
  referenced_by: 0
  pages: 3
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Table 6232 "Sust. Posted ESG Report Line"

> Table 6232 "Sust. Posted ESG Report Line" in Sustainability (Microsoft.Sustainability.ESGReporting). 35 fields, 2 public procedures. Introduced in BC29, still in BC30.

Sustainability · Microsoft.Sustainability.ESGReporting · captioned "Posted ESG Report Line" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Sustainability/app/src/ESGReporting/SustPostedESGReportLine.Table.al) · 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. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> | TableRelation [Table 6228 "Sust. ESG Reporting Template"](../table/6228.md) (Sust. ESG Reporting Template) |
| 2 | ESG Reporting Name | Code[10] | Specifies the value of the ESG Reporting Name field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> | TableRelation [Table 6229 "Sust. ESG Reporting Name"](../table/6229.md) ("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. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 4 | Line No. | Integer | — |  |
| 5 | Grouping | Text[100] | Specifies the value of the Grouping field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 6 | Row No. | Code[10] | Specifies a number that identifies the line. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 7 | Description | Text[500] | Specifies a description of the ESG reporting line. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 8 | Reporting Code | Text[100] | Specifies the value of the Reporting Code field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 9 | Field Type | Enum "Sust. ESG Reporting Field Type" | Specifies the value of the Field Type field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> | enum [Enum 6221 "Sust. ESG Reporting Field Type"](../enum/6221.md) |
| 10 | Table No. | Integer | Specifies the value of the Table No. field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> | 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. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 15 | Source | Text[250] | Specifies the value of the Source field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 16 | Field Caption | Text[250] | Specifies the value of the Value field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 20 | Value Settings | Enum "Sust. ESG Value Settings" | Specifies the value of the Value Settings field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> | enum [Enum 6222 "Sust. ESG Value Settings"](../enum/6222.md) |
| 21 | Account Filter | Text[250] | Specifies the value of the Account Filter field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 22 | Date Filter | Date | — | FlowFilter; not editable |
| 25 | Reporting Unit | Code[20] | Specifies the value of the Reporting Unit field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> | TableRelation [Table 6252 "Sust. ESG Reporting Unit"](../table/6252.md) ("Sust. ESG Reporting Unit".Code) |
| 27 | Row Type | Option | Specifies the value of the Row Type field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> | OptionCaption: Net Change,Balance at Date,Year to Date,Beginning Balance |
| 28 | Row Totaling | Text[50] | Specifies the value of the Row Totaling field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 30 | Calculate With | Option | Specifies the value of the Calculate with field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> | OptionCaption: Sign,Opposite Sign |
| 31 | Show | Boolean | Specifies the value of the Show field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 32 | Show With | Option | Specifies the value of the Show with field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> | OptionCaption: Sign,Opposite Sign |
| 33 | Rounding | Enum "Sust. ESG Rounding Factor" | Specifies the value of the Rounding field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> | enum [Enum 6223 "Sust. ESG Rounding Factor"](../enum/6223.md) |
| 35 | Goal SystemID | Guid | — |  |
| 36 | Concept Link | Text[840] | Specifies the Concept link of the Source field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 37 | Concept | Text[400] | Specifies the Concept of the Source field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 40 | Posted Amount | Decimal | Specifies the value of the Posted Amount field. <small>via [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)</small> |  |
| 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"](../table/6230.md) ("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"](../page/6298.md)
- lookup page [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md)
- Coupled to Dataverse: CalcFormula [Table 5331 "CRM Integration Record"](../table/5331.md)
- ESG Reporting Template Name: TableRelation [Table 6228 "Sust. ESG Reporting Template"](../table/6228.md)
- ESG Reporting Name: TableRelation [Table 6229 "Sust. ESG Reporting Name"](../table/6229.md)
- Derived From SystemId: TableRelation [Table 6230 "Sust. ESG Reporting Line"](../table/6230.md)
- Reporting Unit: TableRelation [Table 6252 "Sust. ESG Reporting Unit"](../table/6252.md)

## Pages and codeunits on this table

- [Page 6258 "Sust. Posted ESG Report Sub."](../page/6258.md) (source table)
- [Page 6298 "Sust. Posted ESG Report Lines"](../page/6298.md) (source table)
- [Page 6334 "Sust. Posted ESG Report Line"](../page/6334.md) (source table)

## Across versions

- Present in: BC29-30
- Changed (declaration) in: none

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## 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.