---
id: object/table/6227
type: object
title: Table 6227 "Sustainability Value Entry"
summary: Table 6227 "Sustainability Value Entry" in Sustainability (Microsoft.Sustainability.Ledger). 41 fields, 7 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: 4a4fb2353fa0a16903ea4a871471318d5659e48ee6064cb6a8a7cf2db9eb3a28
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Sustainability/app/src/Ledger/SustainabilityValueEntry.Table.al
    title: src/Apps/W1/Sustainability/app/src/Ledger/SustainabilityValueEntry.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: 6227
name: Sustainability Value Entry
namespace: Microsoft.Sustainability.Ledger
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: 41
  procedures: 7
  events: 0
  subscribers: 0
relations:
  out: 24
  referenced_by: 13
  pages: 2
  extended_by: 0
  event_subscribers: 1
  calls: 2
  called_by: 0
  implements: 0
---

# Table 6227 "Sustainability Value Entry"

> Table 6227 "Sustainability Value Entry" in Sustainability (Microsoft.Sustainability.Ledger). 41 fields, 7 public procedures. Introduced in BC29, still in BC30.

Sustainability · Microsoft.Sustainability.Ledger · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Sustainability/app/src/Ledger/SustainabilityValueEntry.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Sustainability Value Entry |
| 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 | Entry No. | Integer | Specifies the value of the Entry No. field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 2 | Item No. | Code[20] | Specifies the value of the Item No. field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | TableRelation [Table 27 "Item"](../table/27.md) |
| 3 | Posting Date | Date | Specifies the value of the Posting Date field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 4 | Item Ledger Entry Type | Enum "Item Ledger Entry Type" | Specifies the value of the Item Ledger Entry Type field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | enum [Enum 78 "Item Ledger Entry Type"](../enum/78.md) |
| 5 | Document No. | Code[20] | Specifies the value of the Document No. field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 6 | Item Ledger Entry No. | Integer | Specifies the value of the Item Ledger Entry No. field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | TableRelation [Table 32 "Item Ledger Entry"](../table/32.md) (Item Ledger Entry) |
| 7 | Valued Quantity | Decimal | Specifies the value of the Valued Quantity field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 8 | Item Ledger Entry Quantity | Decimal | Specifies the value of the Item Ledger Entry Quantity field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 9 | Invoiced Quantity | Decimal | Specifies the value of the Invoiced Quantity field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 10 | CO2e per Unit | Decimal | Specifies the value of the CO2e per Unit field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 11 | User ID | Code[50] | Specifies the value of the User ID field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | TableRelation User."User Name"; DataClassification EndUserIdentifiableInformation |
| 12 | Source Code | Code[10] | Specifies the value of the Source Code field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | TableRelation Source Code |
| 13 | Applies-to Entry | Integer | Specifies the value of the Applies-to Entry field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 14 | Global Dimension 1 Code | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1))) |
| 15 | Global Dimension 2 Code | Code[20] | Specifies the code for the global dimension that is linked to the record or entry for analysis purposes. Two global dimensions, typically for the company's most important activities, are available on all cards, documents, reports, and lists. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2))) |
| 16 | Expected Emission | Boolean | Specifies the value of the Expected Emission field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 17 | CO2e Amount (Actual) | Decimal | Specifies the value of the CO2e Amount (Actual) field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 18 | CO2e Amount (Expected) | Decimal | Specifies the value of the CO2e Amount (Expected) field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 19 | Journal Batch Name | Code[10] | Specifies the value of the Journal Batch Name field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 20 | Document Date | Date | Specifies the value of the Document Date field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 21 | External Document No. | Code[35] | Specifies the value of the External Document No. field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 22 | Document Type | Enum "Item Ledger Document Type" | Specifies the value of the Document Type field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | enum [Enum 79 "Item Ledger Document Type"](../enum/79.md) |
| 23 | Document Line No. | Integer | Specifies the value of the Document Line No. field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 30 | Account No. | Code[20] | — | TableRelation [Table 6210 "Sustainability Account"](../table/6210.md) ("Sustainability Account" where("Account Type" = const(Posting))) |
| 31 | Account Name | Text[100] | — |  |
| 32 | Account Category | Code[20] | — | TableRelation [Table 6211 "Sustain. Account Category"](../table/6211.md) (Sustain. Account Category) |
| 33 | Account Subcategory | Code[20] | — | TableRelation [Table 6212 "Sustain. Account Subcategory"](../table/6212.md) ("Sustain. Account Subcategory".Code where("Category Code" = field("Account Category"))) |
| 105 | Entry Type | Enum "Cost Entry Type" | Specifies the value of the Entry Type field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | enum [Enum 104 "Cost Entry Type"](../enum/104.md); not editable |
| 480 | Dimension Set ID | Integer | — | TableRelation [Table 480 "Dimension Set Entry"](../table/480.md) (Dimension Set Entry); not editable |
| 1000 | Job No. | Code[20] | Specifies the number of the project that the value entry relates to. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | TableRelation Job."No." |
| 1001 | Job Task No. | Code[20] | Specifies the number of the related project task. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | TableRelation [Table 1001 "Job Task"](../table/1001.md) ("Job Task"."Job Task No." where("Job No." = field("Job No."))) |
| 5831 | Capacity Ledger Entry No. | Integer | Specifies the value of the Capacity Ledger Entry No. field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | TableRelation [Table 5832 "Capacity Ledger Entry"](../table/5832.md) (Capacity Ledger Entry) |
| 5832 | Type | Enum "Sust. Value Type" | Specifies the value of the Type field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | enum [Enum 6219 "Sust. Value Type"](../enum/6219.md) |
| 5834 | No. | Code[20] | Specifies the value of the No. field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | TableRelation [Table 15 "G/L Account"](../table/15.md), [Table 156 "Resource"](../table/156.md), [Table 27 "Item"](../table/27.md) (if (Type = const("Machine Center")) "Machine Center" else if (Type = const("Work Center")) "Work Center" else if (Type = const(Resource)) Resource else if (Type = const(Item)) Item else if (Type = const("Charge (Item)")) "Item Charge" else if (Type = const("G/L Account")) "G/L Account" else if (Type...) |
| 5818 | Adjustment | Boolean | Specifies the value of the Adjustment field. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> |  |
| 5156 | Shortcut Dimension 3 Code | Code[20] | Specifies the code for Shortcut Dimension 3, which is one of dimension codes that you set up in the General Ledger Setup window. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(3))) |
| 5157 | Shortcut Dimension 4 Code | Code[20] | Specifies the code for Shortcut Dimension 4, which is one of dimension codes that you set up in the General Ledger Setup window. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(4))) |
| 5158 | Shortcut Dimension 5 Code | Code[20] | Specifies the code for Shortcut Dimension 5, which is one of dimension codes that you set up in the General Ledger Setup window. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(5))) |
| 5159 | Shortcut Dimension 6 Code | Code[20] | Specifies the code for Shortcut Dimension 6, which is one of dimension codes that you set up in the General Ledger Setup window. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(6))) |
| 5160 | Shortcut Dimension 7 Code | Code[20] | Specifies the code for Shortcut Dimension 7, which is one of dimension codes that you set up in the General Ledger Setup window. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(7))) |
| 5161 | Shortcut Dimension 8 Code | Code[20] | Specifies the code for Shortcut Dimension 8, which is one of dimension codes that you set up in the General Ledger Setup window. <small>via [Page 6248 "Sustainability Value Entries"](../page/6248.md)</small> | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(8))) |

## Keys

- Key1: Entry No. (clustered)
- Key2: Document Type, Document No., Item No.

## Trigger event subscribers

- OnAfterInsertEvent: [Codeunit 6228 "Sust. Preview Posting Handler"](../codeunit/6228.md) OnInsertSustValueEntry

## Procedures

- `ShowDimensions()`
- `CopyFromValueEntry(ValueEntry: Record "Value Entry")`
- `CopyFromResourceLedgerEntry(ResourceLedgerEntry: Record "Res. Ledger Entry")`
- `CopyFromFALedgerEntry(FALedgerEntry: Record "FA Ledger Entry")`
- `CopyFromJobLedgerEntry(JobLedgerEntry: Record "Job Ledger Entry")`
- `CopyFromSustainabilityJnlLine(SustainabilityJnlLine: Record "Sustainability Jnl. Line")`
- `GetLastEntryNo(): Integer`

## Relations

- drill-down page [Page 6248 "Sustainability Value Entries"](../page/6248.md)
- lookup page [Page 6248 "Sustainability Value Entries"](../page/6248.md)
- Job Task No.: TableRelation [Table 1001 "Job Task"](../table/1001.md)
- No.: TableRelation [Table 15 "G/L Account"](../table/15.md) (conditional)
- No.: TableRelation [Table 156 "Resource"](../table/156.md) (conditional)
- Item No.: TableRelation [Table 27 "Item"](../table/27.md)
- No.: TableRelation [Table 27 "Item"](../table/27.md) (conditional)
- Item Ledger Entry No.: TableRelation [Table 32 "Item Ledger Entry"](../table/32.md)
- Global Dimension 1 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Global Dimension 2 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Shortcut Dimension 3 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 4 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 5 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 6 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 7 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Shortcut Dimension 8 Code: CalcFormula [Table 480 "Dimension Set Entry"](../table/480.md)
- Dimension Set ID: TableRelation [Table 480 "Dimension Set Entry"](../table/480.md)
- No.: TableRelation [Table 5800 "Item Charge"](../table/5800.md) (conditional)
- Capacity Ledger Entry No.: TableRelation [Table 5832 "Capacity Ledger Entry"](../table/5832.md)
- Account No.: TableRelation [Table 6210 "Sustainability Account"](../table/6210.md)
- Account Category: TableRelation [Table 6211 "Sustain. Account Category"](../table/6211.md)
- Account Subcategory: TableRelation [Table 6212 "Sustain. Account Subcategory"](../table/6212.md)
- No.: TableRelation [Table 99000754 "Work Center"](../table/99000754.md) (conditional)
- No.: TableRelation [Table 99000758 "Machine Center"](../table/99000758.md) (conditional)

## Referenced by

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

- [Table extension 6257 "Sust. Job"](../tableextension/6257.md): G/L Account (Total CO2e), Item (Total CO2e), Resource (Total CO2e), Total CO2e
- [Table extension 6260 "Sust. Job Task"](../tableextension/6260.md): G/L Account (Total CO2e), Item (Total CO2e), Resource (Total CO2e), Total CO2e
- [Table extension 6236 "Sust. Sales Cr. Memo Header"](../tableextension/6236.md): Total CO2e
- [Table extension 6238 "Sust. Sales Invoice Header"](../tableextension/6238.md): Total CO2e
- [Table extension 6255 "Sust. Transfer Shipment Header"](../tableextension/6255.md): Total CO2e
- [Table extension 6272 "Sust. Service Cr. Memo Header"](../tableextension/6272.md): Total CO2e
- [Table extension 6274 "Sust. Service Invoice Header"](../tableextension/6274.md): Total CO2e

## Pages and codeunits on this table

- [Page 6248 "Sustainability Value Entries"](../page/6248.md) (source table)
- [Page 6335 "Sustainability Value Entry"](../page/6335.md) (source table)

## Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an `Object::"Name"` argument. Interface dispatch and calls through events are not counted, so the list is not complete.

- [Codeunit 408 "DimensionManagement"](../codeunit/408.md) (1 call: `ShowDimensions → ShowDimensionSet`)
- [Codeunit 703 "Find Record Management"](../codeunit/703.md) (1 call: `GetLastEntryNo → GetLastEntryIntFieldValue`)

## 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). The call sections above are our own, per object, from the BC29 call graph. 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: "Sustainability Value Entry")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.