Table 6241 "Sust. Excise Taxes Trans. Log"
Sustainability · Microsoft.Sustainability.ExciseTax
Across versions
- BC23-28not present
- BC29-30present
Neighbourhood 20 connected objects and pages
Sustainability · Microsoft.Sustainability.ExciseTax · captioned “Excise Taxes Transaction Log” · BC29-30 · source at ea08af5e · 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. via Page 6288 “Sust. Excise Taxes Trans. Logs” | AutoIncrement |
| 2 | Journal Template Name | Code[10] | Specifies the name of the journal template. via Page 6288 “Sust. Excise Taxes Trans. Logs” | TableRelation Table 6238 “Sust. Excise Journal Template” (Sust. Excise Journal Template) |
| 3 | Journal Batch Name | Code[10] | Specifies the name of the journal batch. via Page 6288 “Sust. Excise Taxes Trans. Logs” | TableRelation Table 6239 “Sust. Excise Journal Batch” (“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. via Page 6288 “Sust. Excise Taxes Trans. Logs” | enum Enum 6226 “Sust. Excise Jnl. Tax Type” |
| 10 | Entry Type | Enum “Sust. Excise Jnl. Entry Type” | Specifies the value of the Entry Type field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | enum Enum 6228 “Sust. Excise Jnl. Entry Type” |
| 11 | Posting Date | Date | Specifies the date when the transaction is posted. via Page 6288 “Sust. Excise Taxes Trans. Logs” | NotBlank |
| 12 | Document Type | Enum “Sust. Excise Document Type” | Specifies the type of the document. via Page 6288 “Sust. Excise Taxes Trans. Logs” | enum Enum 6229 “Sust. Excise Document Type” |
| 15 | Document No. | Code[20] | Specifies the document number. via Page 6288 “Sust. Excise Taxes Trans. Logs” | NotBlank |
| 16 | Account No. | Code[20] | Specifies the sustainability account number. via Page 6288 “Sust. Excise Taxes Trans. Logs” | obsolete Pending 28.0; #if not CLEANSCHEMA29; TableRelation Table 6210 “Sustainability Account” (“Sustainability Account” where(“Account Type” = const(Posting), Blocked = const(false))) |
| 17 | Account Name | Text[100] | Specifies the sustainability account name. via Page 6288 “Sust. Excise Taxes Trans. Logs” | obsolete Pending 28.0; #if not CLEANSCHEMA29 |
| 18 | Account Category | Code[20] | Specifies the sustainability account category. via Page 6288 “Sust. Excise Taxes Trans. Logs” | obsolete Pending 28.0; #if not CLEANSCHEMA29; TableRelation Table 6211 “Sustain. Account Category” (Sustain. Account Category); not editable |
| 19 | Account Subcategory | Code[20] | Specifies the sustainability account subcategory. via Page 6288 “Sust. Excise Taxes Trans. Logs” | obsolete Pending 28.0; #if not CLEANSCHEMA29; TableRelation Table 6212 “Sustain. Account Subcategory” (“Sustain. Account Subcategory”.Code where(“Category Code” = field(“Account Category”))) |
| 20 | Description | Text[100] | Specifies the description of the journal line. via Page 6288 “Sust. Excise Taxes Trans. Logs” | |
| 21 | Partner Type | Enum “Sust. Excise Jnl. Partner Type” | Specifies the value of the Partner Type field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | enum Enum 6231 “Sust. Excise Jnl. Partner Type” |
| 22 | Partner No. | Code[20] | Specifies the value of the Partner No. field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | TableRelation Table 18 “Customer”, Table 23 “Vendor” (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. via Page 6288 “Sust. Excise Taxes Trans. Logs” | enum Enum 6230 “Sust. Excise Jnl. Source Type” |
| 26 | Source No. | Code[20] | Specifies the value of the Source No. field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | TableRelation Table 15 “G/L Account”, Table 27 “Item”, Table 5600 “Fixed Asset” (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. via Page 6288 “Sust. Excise Taxes Trans. Logs” | |
| 28 | Source Unit of Measure Code | Code[10] | Specifies the value of the Source Unit of Measure field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | TableRelation Table 204 “Unit of Measure” (Unit of Measure) |
| 29 | Source Qty. | Decimal | Specifies the value of the Source Qty. field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | |
| 40 | Material Breakdown No. | Code[20] | Specifies the value of the Material Breakdown No. field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | |
| 41 | Material Breakdown Description | Text[100] | Specifies the value of the Material Breakdown Description field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | |
| 42 | Material Breakdown Weight | Decimal | Specifies the value of the Material Breakdown Weight field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | |
| 43 | Material Breakdown UOM | Code[10] | Specifies the value of the Material Breakdown Unit of Measure field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | TableRelation Table 204 “Unit of Measure” (Unit of Measure) |
| 50 | Total Embedded CO2e Emission | Decimal | Specifies the value of the Total Embedded CO2e Emission field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | |
| 51 | CO2e Unit of Measure | Code[10] | Specifies the value of the CO2e Unit of Measure field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | TableRelation Table 204 “Unit of Measure” (Unit of Measure) |
| 60 | CBAM Certificates Required | Boolean | Specifies the value of the CBAM Certificates Required field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | |
| 61 | Total Emission Cost | Decimal | Specifies the value of the Total Emission Cost field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | |
| 65 | Carbon Pricing Paid | Boolean | Specifies the value of the Carbon Pricing Paid field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | |
| 70 | Already Paid Emission | Decimal | Specifies the value of the Already Paid Emission field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | |
| 80 | Adjusted CBAM Cost | Decimal | Specifies the value of the Adjusted CBAM Cost field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | |
| 90 | Certificate Amount | Decimal | Specifies the value of the Certificate Amount field. via Page 6288 “Sust. Excise Taxes Trans. Logs” | |
| 100 | Qty. per Unit of Measure | Decimal | — | not editable |
| 110 | Country/Region Code | Code[10] | Specifies the country/region code of the entry. via Page 6288 “Sust. Excise Taxes Trans. Logs” | TableRelation Table 9 “Country/Region” (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. via Page 6288 “Sust. Excise Taxes Trans. Logs” | TableRelation Table 5714 “Responsibility Center” (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. via Page 6288 “Sust. Excise Taxes Trans. Logs” | TableRelation Table 349 “Dimension Value” (“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. via Page 6288 “Sust. Excise Taxes Trans. Logs” | TableRelation Table 349 “Dimension Value” (“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” (Dimension Set Entry) |
| 500 | Item Ledger Entry No. | Integer | Specifies the related item ledger entry number. via Page extension 7416 “Excise Tax Trans Log Ext” | TableRelation Table 32 “Item Ledger Entry” (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. via Page 6288 “Sust. Excise Taxes Trans. Logs” | 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. via Page 6288 “Sust. Excise Taxes Trans. Logs” | 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. via Page 6288 “Sust. Excise Taxes Trans. Logs” | 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. via Page 6288 “Sust. Excise Taxes Trans. Logs” | 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. via Page 6288 “Sust. Excise Taxes Trans. Logs” | 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. via Page 6288 “Sust. Excise Taxes Trans. Logs” | 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” OnAfterCopyFromSustainabilityExciseJnlLine
Procedures
CopyFromSustainabilityExciseJnlLine(SustainabilityExciseJnlLine: Record "Sust. Excise Jnl. Line")
Plus 1 local procedures.
Relations
- lookup page Page 6288 “Sust. Excise Taxes Trans. Logs”
- Source No.: TableRelation Table 15 “G/L Account” (conditional)
- Partner No.: TableRelation Table 18 “Customer” (conditional)
- CO2e Unit of Measure: TableRelation Table 204 “Unit of Measure”
- Material Breakdown UOM: TableRelation Table 204 “Unit of Measure”
- Source Unit of Measure Code: TableRelation Table 204 “Unit of Measure”
- Partner No.: TableRelation Table 23 “Vendor” (conditional)
- Source No.: TableRelation Table 27 “Item” (conditional)
- Item Ledger Entry No.: TableRelation Table 32 “Item Ledger Entry”
- Global Dimension 1 Code: TableRelation Table 349 “Dimension Value”
- Global Dimension 2 Code: TableRelation Table 349 “Dimension Value”
- Shortcut Dimension 3 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 4 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 5 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 6 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 7 Code: CalcFormula Table 480 “Dimension Set Entry”
- Shortcut Dimension 8 Code: CalcFormula Table 480 “Dimension Set Entry”
- Dimension Set ID: TableRelation Table 480 “Dimension Set Entry”
- Source No.: TableRelation Table 5600 “Fixed Asset” (conditional)
- Responsibility Center: TableRelation Table 5714 “Responsibility Center”
- Account No.: TableRelation Table 6210 “Sustainability Account”
- Account Category: TableRelation Table 6211 “Sustain. Account Category”
- Account Subcategory: TableRelation Table 6212 “Sustain. Account Subcategory”
- Journal Template Name: TableRelation Table 6238 “Sust. Excise Journal Template”
- Journal Batch Name: TableRelation Table 6239 “Sust. Excise Journal Batch”
- Country/Region Code: TableRelation Table 9 “Country/Region”
Pages and codeunits on this table
- Page 6288 “Sust. Excise Taxes Trans. Logs” (source table)
Extended by
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” (1 call:
ShowDimensions → ShowDimensionSet)
Recent changes
- 2026-08-27 #10675 Temporarily suppress AS0072 (ObsoleteTag 29.0) on 10 Base App elements for v30 prep (main, BC30, fix)
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.