---
id: object/table/6241
type: object
title: Table 6241 "Sust. Excise Taxes Trans. Log"
summary: Table 6241 "Sust. Excise Taxes Trans. Log" in Sustainability (Microsoft.Sustainability.ExciseTax). 51 fields, 1 public procedures, 1 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: 6587e0d2f5a2f33dc8edede2df430415b7778610c92fe8dd5356813a722df2ec
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/Apps/W1/Sustainability/app/src/ExciseTax/SustExciseTaxesTransLog.Table.al
    title: src/Apps/W1/Sustainability/app/src/ExciseTax/SustExciseTaxesTransLog.Table.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/10675
object_type: table
object_id: 6241
name: Sust. Excise Taxes Trans. Log
caption: Excise Taxes Transaction Log
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: 51
  procedures: 3
  events: 1
  subscribers: 0
relations:
  out: 26
  referenced_by: 0
  pages: 1
  extended_by: 1
  event_subscribers: 1
  calls: 1
  called_by: 0
  implements: 0
---

# Table 6241 "Sust. Excise Taxes Trans. Log"

> Table 6241 "Sust. Excise Taxes Trans. Log" in Sustainability (Microsoft.Sustainability.ExciseTax). 51 fields, 1 public procedures, 1 events. Introduced in BC29, still in BC30.

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

## Properties

| Property | Value |
|---|---|
| Caption | Excise Taxes Transaction Log |
| DataClassification | CustomerContent |
| LookupPageId | Sust. Excise Taxes Trans. Logs |

## 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 entry number of the Excise Taxes Transaction Logs. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | AutoIncrement |
| 2 | Journal Template Name | Code[10] | Specifies the name of the journal template. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | TableRelation [Table 6238 "Sust. Excise Journal Template"](../table/6238.md) (Sust. Excise Journal Template) |
| 3 | Journal Batch Name | Code[10] | Specifies the name of the journal batch. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | TableRelation [Table 6239 "Sust. Excise Journal Batch"](../table/6239.md) ("Sust. Excise Journal Batch".Name where("Journal Template Name" = field("Journal Template Name"))) |
| 5 | Log Type | Enum "Sust. Excise Jnl. Tax Type" | Specifies the value of the Log Type field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | enum [Enum 6226 "Sust. Excise Jnl. Tax Type"](../enum/6226.md) |
| 10 | Entry Type | Enum "Sust. Excise Jnl. Entry Type" | Specifies the value of the Entry Type field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | enum [Enum 6228 "Sust. Excise Jnl. Entry Type"](../enum/6228.md) |
| 11 | Posting Date | Date | Specifies the date when the transaction is posted. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | NotBlank |
| 12 | Document Type | Enum "Sust. Excise Document Type" | Specifies the type of the document. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | enum [Enum 6229 "Sust. Excise Document Type"](../enum/6229.md) |
| 15 | Document No. | Code[20] | Specifies the document number. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | NotBlank |
| 16 | Account No. | Code[20] | Specifies the sustainability account number. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.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))) |
| 17 | Account Name | Text[100] | Specifies the sustainability account name. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | obsolete Pending 28.0; #if not CLEANSCHEMA29 |
| 18 | Account Category | Code[20] | Specifies the sustainability account category. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | obsolete Pending 28.0; #if not CLEANSCHEMA29; TableRelation [Table 6211 "Sustain. Account Category"](../table/6211.md) (Sustain. Account Category); not editable |
| 19 | Account Subcategory | Code[20] | Specifies the sustainability account subcategory. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.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"))) |
| 20 | Description | Text[100] | Specifies the description of the journal line. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> |  |
| 21 | Partner Type | Enum "Sust. Excise Jnl. Partner Type" | Specifies the value of the Partner Type field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | enum [Enum 6231 "Sust. Excise Jnl. Partner Type"](../enum/6231.md) |
| 22 | Partner No. | Code[20] | Specifies the value of the Partner No. field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.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) |
| 25 | Source Type | Enum "Sust. Excise Jnl. Source Type" | Specifies the value of the Source Type field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | enum [Enum 6230 "Sust. Excise Jnl. Source Type"](../enum/6230.md) |
| 26 | Source No. | Code[20] | Specifies the value of the Source No. field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.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)...) |
| 27 | Source Description | Text[100] | Specifies the value of the Source Description field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> |  |
| 28 | Source Unit of Measure Code | Code[10] | Specifies the value of the Source Unit of Measure field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | TableRelation [Table 204 "Unit of Measure"](../table/204.md) (Unit of Measure) |
| 29 | Source Qty. | Decimal | Specifies the value of the Source Qty. field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> |  |
| 40 | Material Breakdown No. | Code[20] | Specifies the value of the Material Breakdown No. field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> |  |
| 41 | Material Breakdown Description | Text[100] | Specifies the value of the Material Breakdown Description field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> |  |
| 42 | Material Breakdown Weight | Decimal | Specifies the value of the Material Breakdown Weight field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> |  |
| 43 | Material Breakdown UOM | Code[10] | Specifies the value of the Material Breakdown Unit of Measure field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | TableRelation [Table 204 "Unit of Measure"](../table/204.md) (Unit of Measure) |
| 50 | Total Embedded CO2e Emission | Decimal | Specifies the value of the Total Embedded CO2e Emission field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> |  |
| 51 | CO2e Unit of Measure | Code[10] | Specifies the value of the CO2e Unit of Measure field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | TableRelation [Table 204 "Unit of Measure"](../table/204.md) (Unit of Measure) |
| 60 | CBAM Certificates Required | Boolean | Specifies the value of the CBAM Certificates Required field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> |  |
| 61 | Total Emission Cost | Decimal | Specifies the value of the Total Emission Cost field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> |  |
| 65 | Carbon Pricing Paid | Boolean | Specifies the value of the Carbon Pricing Paid field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> |  |
| 70 | Already Paid Emission | Decimal | Specifies the value of the Already Paid Emission field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> |  |
| 80 | Adjusted CBAM Cost | Decimal | Specifies the value of the Adjusted CBAM Cost field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> |  |
| 90 | Certificate Amount | Decimal | Specifies the value of the Certificate Amount field. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> |  |
| 100 | Qty. per Unit of Measure | Decimal | — | not editable |
| 110 | Country/Region Code | Code[10] | Specifies the country/region code of the entry. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | TableRelation [Table 9 "Country/Region"](../table/9.md) (Country/Region) |
| 120 | Source Document No. | Code[20] | — |  |
| 121 | Source Document Line No. | Integer | — | not editable |
| 130 | Responsibility Center | Code[10] | Specifies the responsibility center of the entry. <small>via [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | TableRelation [Table 5714 "Responsibility Center"](../table/5714.md) (Responsibility Center) |
| 140 | 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 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(1))) |
| 150 | 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 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | TableRelation [Table 349 "Dimension Value"](../table/349.md) ("Dimension Value".Code where("Global Dimension No." = const(2))) |
| 200 | Source Code | Code[10] | — | TableRelation Source Code |
| 201 | Reason Code | Code[10] | — | TableRelation Reason Code |
| 480 | Dimension Set ID | Integer | — | TableRelation [Table 480 "Dimension Set Entry"](../table/480.md) (Dimension Set Entry) |
| 500 | Item Ledger Entry No. | Integer | Specifies the related item ledger entry number. <small>via [Page extension 7416 "Excise Tax Trans Log Ext"](../pageextension/7416.md)</small> | TableRelation [Table 32 "Item Ledger Entry"](../table/32.md) (Item Ledger Entry) |
| 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 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.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 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.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 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.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 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.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 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.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 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md)</small> | FlowField: lookup("Dimension Set Entry"."Dimension Value Code" where("Dimension Set ID" = field("Dimension Set ID"), "Global Dimension No." = const(8))) |
| 5170 | Calculated Date | Date | — |  |
| 5171 | Calculated By | Code[50] | — | TableRelation User."User Name"; DataClassification EndUserIdentifiableInformation |

## Keys

- PK: Entry No. (clustered)

## Events published

- `OnAfterCopyFromSustainabilityExciseJnlLine(var SustExciseTaxesTransactionLog: Record "Sust. Excise Taxes Trans. Log"; SustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line")` (integration)
  - subscribers: [Codeunit 7413 "Excise Tax Trans Subscriber"](../codeunit/7413.md) OnAfterCopyFromSustainabilityExciseJnlLine

## Procedures

- `CopyFromSustainabilityExciseJnlLine(SustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line")`

Plus 1 local procedures.

## Relations

- lookup page [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.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)
- 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)
- 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)
- 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)

## Pages and codeunits on this table

- [Page 6288 "Sust. Excise Taxes Trans. Logs"](../page/6288.md) (source table)

## Extended by

- [Table extension 7414 "Excise Taxes Trans. Log Ext"](../tableextension/7414.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) (1 call: `ShowDimensions → ShowDimensionSet`)

## 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 Taxes Trans. Log")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.