---
id: object/table/6240
type: object
title: Table 6240 "Sust. Excise Jnl. Line"
summary: Table 6240 "Sust. Excise Jnl. Line" in Sustainability (Microsoft.Sustainability.ExciseTax). 49 fields, 9 public procedures, 6 events. 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: 02ff5d99fded7854fe1b30324cbcc61138aca08c3562e3cf1672e4282b682498
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Sustainability/app/src/ExciseTax/SustExciseJnlLine.Table.al
    title: src/Apps/W1/Sustainability/app/src/ExciseTax/SustExciseJnlLine.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn:
    - https://learn.microsoft.com/dynamics365/business-central/finance-register-excise-tax
  objects: []
  features: []
  topics:
    - topic/business-central/business-functionality/finance
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/10675
object_type: table
object_id: 6240
name: Sust. Excise Jnl. Line
caption: Excise Journal Line
namespace: Microsoft.Sustainability.ExciseTax
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: 49
  procedures: 23
  events: 6
  subscribers: 0
relations:
  out: 21
  referenced_by: 1
  pages: 1
  extended_by: 1
  event_subscribers: 4
  calls: 2
  called_by: 0
  implements: 0
---

# Table 6240 "Sust. Excise Jnl. Line"

> Table 6240 "Sust. Excise Jnl. Line" in Sustainability (Microsoft.Sustainability.ExciseTax). 49 fields, 9 public procedures, 6 events. Introduced in BC29, still in BC30.

Sustainability · Microsoft.Sustainability.ExciseTax · captioned "Excise Journal Line" · BC29-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Sustainability/app/src/ExciseTax/SustExciseJnlLine.Table.al) · facts from BC29

Learn documents this table through its pages: [Page 6287 "Sustainability Excise Journal"](../page/6287.md) (1 Learn page).

## Properties

| Property | Value |
|---|---|
| Caption | Excise Journal Line |
| Extensible | true |
| DataClassification | CustomerContent |
| LookupPageId | Sustainability Excise Journal |

## 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] | — | TableRelation [Table 6238 "Sust. Excise Journal Template"](../table/6238.md) (Sust. Excise Journal Template); NotBlank |
| 2 | Journal Batch Name | Code[10] | — | TableRelation [Table 6239 "Sust. Excise Journal Batch"](../table/6239.md) ("Sust. Excise Journal Batch".Name where("Journal Template Name" = field("Journal Template Name"))); NotBlank |
| 3 | Line No. | Integer | — |  |
| 4 | Posting Date | Date | Specifies the date when the transaction is posted. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | NotBlank |
| 5 | Entry Type | Enum "Sust. Excise Jnl. Entry Type" | Specifies the value of the Entry Type field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | enum [Enum 6228 "Sust. Excise Jnl. Entry Type"](../enum/6228.md) |
| 6 | Document Type | Enum "Sust. Excise Document Type" | Specifies the type of the document. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | enum [Enum 6229 "Sust. Excise Document Type"](../enum/6229.md) |
| 7 | Document No. | Code[20] | Specifies the document number. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | NotBlank |
| 8 | Account No. | Code[20] | Specifies the sustainability account number. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | obsolete Pending 28.0; #if not CLEANSCHEMA29; TableRelation [Table 6210 "Sustainability Account"](../table/6210.md) ("Sustainability Account" where("Account Type" = const(Posting), Blocked = const(false))) |
| 9 | Account Name | Text[100] | Specifies the sustainability account name. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | obsolete Pending 28.0; #if not CLEANSCHEMA29 |
| 10 | Account Category | Code[20] | Specifies the sustainability account category. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | obsolete Pending 28.0; #if not CLEANSCHEMA29; TableRelation [Table 6211 "Sustain. Account Category"](../table/6211.md) (Sustain. Account Category); not editable |
| 11 | Account Subcategory | Code[20] | Specifies the sustainability account subcategory. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | obsolete Pending 28.0; #if not CLEANSCHEMA29; TableRelation [Table 6212 "Sustain. Account Subcategory"](../table/6212.md) ("Sustain. Account Subcategory".Code where("Category Code" = field("Account Category"))) |
| 12 | Description | Text[100] | Specifies the description of the journal line. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> |  |
| 13 | Partner Type | Enum "Sust. Excise Jnl. Partner Type" | Specifies the value of the Partner Type field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | enum [Enum 6231 "Sust. Excise Jnl. Partner Type"](../enum/6231.md) |
| 14 | Partner No. | Code[20] | Specifies the value of the Partner No. field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | TableRelation [Table 18 "Customer"](../table/18.md), [Table 23 "Vendor"](../table/23.md) (if ("Partner Type" = const(Vendor)) Vendor else if ("Partner Type" = const(Customer)) Customer) |
| 17 | Source of Emission Data | Enum "Sust. Source of Emission" | Specifies the value of the Source of Emission Data field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | enum [Enum 6224 "Sust. Source of Emission"](../enum/6224.md) |
| 18 | Emission Verified | Boolean | Specifies the value of the Emission Verified field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> |  |
| 19 | CBAM Compliance | Boolean | Specifies the value of the CBAM Compliance field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> |  |
| 20 | Source Type | Enum "Sust. Excise Jnl. Source Type" | Specifies the value of the Source Type field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | enum [Enum 6230 "Sust. Excise Jnl. Source Type"](../enum/6230.md) |
| 21 | Source No. | Code[20] | Specifies the value of the Source No. field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | TableRelation [Table 15 "G/L Account"](../table/15.md), [Table 27 "Item"](../table/27.md), [Table 5600 "Fixed Asset"](../table/5600.md) (if ("Source Type" = const(Item)) Item else if ("Source Type" = const("G/L Account")) "G/L Account" where("Direct Posting" = const(true), "Account Type" = const(Posting), Blocked = const(false)) else if ("Source Type" = const("Fixed Asset")) "Fixed Asset" else if ("Source Type" = const("Charge (Item)...) |
| 22 | Source Description | Text[100] | Specifies the value of the Source Description field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> |  |
| 23 | Source Unit of Measure Code | Code[10] | Specifies the value of the Source Unit of Measure field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | TableRelation [Table 204 "Unit of Measure"](../table/204.md) (Unit of Measure) |
| 24 | Source Qty. | Decimal | Specifies the value of the Source Qty. field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> |  |
| 25 | Material Breakdown No. | Code[20] | Specifies the value of the Material Breakdown No. field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | TableRelation [Table 6236 "Sust. Item Mat. Comp. Header"](../table/6236.md) ("Sust. Item Mat. Comp. Header"."No.") |
| 26 | Material Breakdown Description | Text[100] | Specifies the value of the Material Breakdown Description field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> |  |
| 27 | Material Breakdown UOM | Code[10] | Specifies the value of the Material Breakdown Unit of Measure field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | TableRelation [Table 204 "Unit of Measure"](../table/204.md) (Unit of Measure) |
| 28 | Material Breakdown Weight | Decimal | Specifies the value of the Material Breakdown Weight field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> |  |
| 29 | CO2e Emission per Unit | Decimal | — |  |
| 30 | CO2e Unit of Measure | Code[10] | Specifies the value of the CO2e Unit of Measure field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | TableRelation [Table 204 "Unit of Measure"](../table/204.md) (Unit of Measure) |
| 31 | Total Embedded CO2e Emission | Decimal | Specifies the value of the Total Embedded CO2e Emission field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> |  |
| 32 | CBAM Certificates Required | Boolean | Specifies the value of the CBAM Certificates Required field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> |  |
| 35 | Emission Cost per Unit | Decimal | — |  |
| 36 | Total Emission Cost | Decimal | Specifies the value of the Total Emission Cost field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> |  |
| 40 | Carbon Pricing Paid | Boolean | Specifies the value of the Carbon Pricing Paid field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> |  |
| 41 | Already Paid Emission | Decimal | Specifies the value of the Already Paid Emission field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> |  |
| 42 | Adjusted CBAM Cost | Decimal | Specifies the value of the Adjusted CBAM Cost field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | not editable |
| 43 | Certificate Amount | Decimal | Specifies the value of the Certificate Amount field. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> |  |
| 45 | Qty. per Unit of Measure | Decimal | — | not editable |
| 50 | Country/Region Code | Code[10] | Specifies the country/region code of the journal line. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region) |
| 55 | Source Document No. | Code[20] | — |  |
| 56 | Source Document Line No. | Integer | — | not editable |
| 60 | Responsibility Center | Code[10] | Specifies the responsibility center of the journal line. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | TableRelation [Table 5714 "Responsibility Center"](../table/5714.md) (Responsibility Center) |
| 70 | Shortcut Dimension 1 Code | Code[20] | Specifies the code for Shortcut Dimension 1, which is one of two global dimension codes that you set up in the General Ledger Setup window. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1), Blocked = const(false))) |
| 71 | Shortcut Dimension 2 Code | Code[20] | Specifies the code for Shortcut Dimension 2, which is one of two global dimension codes that you set up in the General Ledger Setup window. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2), Blocked = const(false))) |
| 80 | Source Code | Code[10] | Specifies the source code of the journal line. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | TableRelation Source Code |
| 90 | Reason Code | Code[10] | Specifies the reason code of the journal line. <small>via [Page 6287 "Sustainability Excise Journal"](../page/6287.md)</small> | TableRelation Reason Code |
| 480 | Dimension Set ID | Integer | — | TableRelation [Table 480 "Dimension Set Entry"](../table/480.md) (Dimension Set Entry); not editable |
| 500 | Item Ledger Entry No. | Integer | — | TableRelation [Table 32 "Item Ledger Entry"](../table/32.md) (Item Ledger Entry) |
| 5170 | Calculated Date | Date | — |  |
| 5171 | Calculated By | Code[50] | — | TableRelation User."User Name"; DataClassification EndUserIdentifiableInformation |

## Keys

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

## Events published

- `OnAfterInitDefaultDimensionSources(var SustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line"; var DefaultDimSource: List of [Dictionary of [Integer, Code[20]]]; FieldNo: Integer)` (integration)
- `OnAfterSetupNewLine(var SustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line"; SustainabilityExciseJnlBatch: Record "Sust. Excise Journal Batch"; PreviousSustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line")` (integration)
- `OnValidateSourceNoBeforeTestFieldPartnerNo(var SustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line"; var IsHandled: Boolean)` (integration)
  - subscribers: [Codeunit 7413 "Excise Tax Trans Subscriber"](../codeunit/7413.md) OnValidateSourceNoBeforeTestFieldPartnerNo
- `OnAfterCopyFromItem(var ExciseJournalLine: Record "Sust. Excise Jnl. Line"; Item: Record Item)` (integration)
  - subscribers: [Codeunit 7413 "Excise Tax Trans Subscriber"](../codeunit/7413.md) OnAfterCopyFromItem
- `OnAfterCopyFromFixedAsset(var ExciseJournalLine: Record "Sust. Excise Jnl. Line"; FixedAsset: Record "Fixed Asset")` (integration)
  - subscribers: [Codeunit 7413 "Excise Tax Trans Subscriber"](../codeunit/7413.md) OnAfterCopyFromFixedAsset
- `OnValidateSustainabilityExciseJournalLineByFieldOnBeforeShowUnsupportedEntryError(var ExciseJournalLine: Record "Sust. Excise Jnl. Line"; CurrentFieldNo: Integer; var IsHandled: Boolean)` (integration)
  - subscribers: [Codeunit 7413 "Excise Tax Trans Subscriber"](../codeunit/7413.md) OnValidateSustainabilityExciseJournalLineByFieldOnBeforeShowUnsupportedEntryError

## Procedures

- `SetupNewLine(PreviousLine: Record "Sust. Excise Jnl. Line")`
- `CreateDimFromDefaultDim(FieldNo: Integer)`
- `CreateDim(DefaultDimSource: List of [Dictionary of [Integer, Code[20]]])`
- `GetPostingSign(SustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line"): Integer`
- `UpdateSustainabilityJnlLineWithPostingSign(var SustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line"; SignFactor: Integer)`
- `ShowDimensions(): Boolean` (internal)
- `GetSustExciseJournalLineLastLineNo(SustainabilityExciseJnlBatch: Record "Sust. Excise Journal Batch"): Integer` (internal)
- `UpdateCarbonPricingInExciseJournalLine(var SustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line")` (internal)
- `ExciseLineTypeToTableID(LineType: Enum "Sust. Excise Jnl. Source Type"): Integer` (internal)

Plus 8 local procedures.

## Triggers

OnInsert

## Relations

- lookup page [Page 6287 "Sustainability Excise Journal"](../page/6287.md)
- Source No.: TableRelation [Table 15 "G/L Account"](../table/15.md) (conditional)
- Partner No.: TableRelation [Table 18 "Customer"](../table/18.md) (conditional)
- CO2e Unit of Measure: TableRelation [Table 204 "Unit of Measure"](../table/204.md)
- Material Breakdown UOM: TableRelation [Table 204 "Unit of Measure"](../table/204.md)
- Source Unit of Measure Code: TableRelation [Table 204 "Unit of Measure"](../table/204.md)
- Partner No.: TableRelation [Table 23 "Vendor"](../table/23.md) (conditional)
- Source No.: TableRelation [Table 27 "Item"](../table/27.md) (conditional)
- Item Ledger Entry No.: TableRelation [Table 32 "Item Ledger Entry"](../table/32.md)
- Shortcut Dimension 1 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Shortcut Dimension 2 Code: TableRelation [Table 349 "Dimension Value"](../table/349.md)
- Dimension Set ID: TableRelation [Table 480 "Dimension Set Entry"](../table/480.md)
- Source No.: TableRelation [Table 5600 "Fixed Asset"](../table/5600.md) (conditional)
- Responsibility Center: TableRelation [Table 5714 "Responsibility Center"](../table/5714.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)
- Material Breakdown No.: TableRelation [Table 6236 "Sust. Item Mat. Comp. Header"](../table/6236.md)
- Journal Template Name: TableRelation [Table 6238 "Sust. Excise Journal Template"](../table/6238.md)
- Journal Batch Name: TableRelation [Table 6239 "Sust. Excise Journal Batch"](../table/6239.md)
- Country/Region Code: TableRelation [Table 9 "Country/Region"](../table/9.md)

## Referenced by

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

- [Table 6239 "Sust. Excise Journal Batch"](../table/6239.md): No. of Lines

## Pages and codeunits on this table

- [Page 6287 "Sustainability Excise Journal"](../page/6287.md) (source table)
- [Codeunit 6271 "Sust. Excise Jnl.-Post"](../codeunit/6271.md) (codeunit runs on it)

## Extended by

- [Table extension 7413 "Excise Journal Line Ext"](../tableextension/7413.md)

## 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) (3 calls: `CreateDim → GetRecDefaultDimID`, `InitDefaultDimensionSources → AddDimSource`, `ShowDimensions → EditDimensionSet`)
- [Codeunit 6270 "Sust. Excise Journal Mgt."](../codeunit/6270.md) (1 call: `SetupNewLine → GetDocumentNo`)

## Recent changes

- 2026-08-27 [#10675 Temporarily suppress AS0072 (ObsoleteTag 29.0) on 10 Base App elements for v30 prep](../../changes/bcapps/10675.md) (main, BC30, fix)

## Across versions

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

## Deprecations

- field Account Category: Pending 28.0 (#if not CLEANSCHEMA29), "This field is no longer required and will be removed in a future release."
- field Account Name: Pending 28.0 (#if not CLEANSCHEMA29), "This field is no longer required and will be removed in a future release."
- field Account No.: Pending 28.0 (#if not CLEANSCHEMA29), "This field is no longer required and will be removed in a future release."
- field Account Subcategory: Pending 28.0 (#if not CLEANSCHEMA29), "This field is no longer required and will be removed in a future release."

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: "Sust. Excise Jnl. Line")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.