---
id: object/table/6290
type: object
title: Table 6290 "Sustain. Emission Suggestion"
summary: Table 6290 "Sustain. Emission Suggestion" in SustainabilityCopilotSuggestion (Microsoft.Sustainability.Copilot). 29 fields, 6 public procedures. Introduced in BC29, still in BC30.
tier: official
language: en
tags:
  - table
  - sustainabilitycopilotsuggestion
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: 76877249b13d8a675c77a3338809565dfe77a00b50568b21ded574465cb16f92
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/SustainabilityCopilotSuggestion/app/src/Suggestion/SustainEmissionSuggestion.Table.al
    title: src/Apps/W1/SustainabilityCopilotSuggestion/app/src/Suggestion/SustainEmissionSuggestion.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: 6290
name: Sustain. Emission Suggestion
caption: Sustainability Emission Suggestion
namespace: Microsoft.Sustainability.Copilot
app: SustainabilityCopilotSuggestion
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: 29
  procedures: 8
  events: 0
  subscribers: 0
relations:
  out: 7
  referenced_by: 0
  pages: 2
  extended_by: 0
  event_subscribers: 0
  calls: 1
  called_by: 0
  implements: 0
---

# Table 6290 "Sustain. Emission Suggestion"

> Table 6290 "Sustain. Emission Suggestion" in SustainabilityCopilotSuggestion (Microsoft.Sustainability.Copilot). 29 fields, 6 public procedures. Introduced in BC29, still in BC30.

SustainabilityCopilotSuggestion · Microsoft.Sustainability.Copilot · captioned "Sustainability Emission Suggestion" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/SustainabilityCopilotSuggestion/app/src/Suggestion/SustainEmissionSuggestion.Table.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Sustainability Emission Suggestion |
| Access | Internal |
| TableType | Temporary |
| 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 | Journal Template Name | Code[10] | Specifies the name of the journal template | TableRelation [Table 6215 "Sustainability Jnl. Template"](../table/6215.md) (Sustainability Jnl. Template); not editable; NotBlank |
| 2 | Journal Batch Name | Code[10] | Specifies the name of the journal batch | TableRelation [Table 6213 "Sustainability Jnl. Batch"](../table/6213.md) ("Sustainability Jnl. Batch".Name where("Journal Template Name" = field("Journal Template Name"))); not editable; NotBlank |
| 3 | Line No. | Integer | Specifies the line number of the journal line | not editable; NotBlank |
| 7 | Account No. | Code[20] | Specifies the sustainability account number | TableRelation [Table 6210 "Sustainability Account"](../table/6210.md) ("Sustainability Account" where("Account Type" = const(Posting), Blocked = const(false))); not editable |
| 8 | Account Name | Text[100] | Specifies the sustainability account name | not editable |
| 9 | Account Category | Code[20] | Specifies the sustainability account category | TableRelation [Table 6211 "Sustain. Account Category"](../table/6211.md) (Sustain. Account Category); not editable |
| 10 | Account Subcategory | Code[20] | Specifies the sustainability account subcategory | TableRelation [Table 6212 "Sustain. Account Subcategory"](../table/6212.md) ("Sustain. Account Subcategory".Code where("Category Code" = field("Account Category"))); not editable |
| 11 | Description | Text[100] | Specifies the description of the journal line |  |
| 13 | Unit of Measure | Code[10] | Specifies the unit of measure of the journal line. | TableRelation [Table 204 "Unit of Measure"](../table/204.md) (Unit of Measure) |
| 14 | Fuel/Electricity | Decimal | Specifies the amount of fuel or electricity used in the journal line |  |
| 15 | Distance | Decimal | Specifies the distance of the journal line |  |
| 16 | Custom Amount | Decimal | Specifies the custom amount of the journal line |  |
| 17 | Installation Multiplier | Decimal | Specifies the installation multiplier of the journal line |  |
| 18 | Time Factor | Decimal | Specifies the time factor of the journal line |  |
| 19 | Emission CO2 | Decimal | Specifies the CO2 emission of the journal line | not editable |
| 22 | Country/Region Code | Code[10] | Specifies the country/region code of the journal line | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region) |
| 23 | Emission Calc. Explanation | Blob | Specifies the explanation of the emission calculation |  |
| 24 | Emission Formula Json | Blob | Specifies the json of the formula |  |
| 25 | Emission Factor CO2 | Decimal | Specifies the CO2 emission factor | not editable |
| 26 | Factor Taken From Source | Boolean | Specifies whether the emission factor is taken from the source | not editable |
| 28 | Emission Factor Source | Text[1024] | Specifies the source of the emission factor | not editable |
| 29 | Calculated by Copilot | Boolean | Specifies whether the emission factor is calculated by Copilot | not editable |
| 30 | Exclude From Copilot | Boolean | Specifies if the account category should be excluded from Copilot suggestions. | not editable |
| 31 | No. of Warnings | Integer | Specifies the number of warnings | not editable |
| 32 | Warning Text | Text[1024] | Specifies the warning text | not editable |
| 33 | Warning Confidence | Decimal | Specifies the confidence based on the warnings | not editable |
| 34 | Raw Formula | Text[1024] | Specifies the raw formula retrieved by Copilot. | not editable |
| 51 | Accept Emission Factor | Boolean | Specifies whether the emission factor is accepted and will be updated on sustainability account subcategory | not editable |
| 52 | Exclude From User Message | Boolean | Specifies whether the emission suggestion should be excluded from user message | not editable |

## Keys

- PK: Journal Template Name, Journal Batch Name, Line No. (clustered)

## Procedures

- `SetStyle(): Text`
- `GetFormat(FieldNo: Integer): Text`
- `UpdateSustainabilityJournalLine()`
- `UpdateSubcategory()`
- `GetFormulaText(): Text` (internal)
- `UpdateWarnings(NewWarningText: Text[1024])`

Plus 2 local procedures.

## Relations

- Unit of Measure: TableRelation [Table 204 "Unit of Measure"](../table/204.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)
- Journal Batch Name: TableRelation [Table 6213 "Sustainability Jnl. Batch"](../table/6213.md)
- Journal Template Name: TableRelation [Table 6215 "Sustainability Jnl. Template"](../table/6215.md)
- Country/Region Code: TableRelation [Table 9 "Country/Region"](../table/9.md)

## Pages and codeunits on this table

- [Page 6330 "Sust. Emis. Suggestion List"](../page/6330.md) (source table)
- [Page 6331 "Sust. Emis. Suggestion Subpage"](../page/6331.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 10 "Type Helper"](../codeunit/10.md) (1 call: `GetFormulaText → CRLFSeparator`)

## 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: "Sustain. Emission Suggestion")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.