Table 6240 "Sust. Excise Jnl. Line"

Sustainability · Microsoft.Sustainability.ExciseTax · captioned “Excise Journal Line” · BC29-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 6287 “Sustainability Excise Journal” (1 Learn page).

Properties

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.

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” OnValidateSourceNoBeforeTestFieldPartnerNo
• OnAfterCopyFromItem(var ExciseJournalLine: Record "Sust. Excise Jnl. Line"; Item: Record Item) (integration)
  • subscribers: Codeunit 7413 “Excise Tax Trans Subscriber” OnAfterCopyFromItem
• OnAfterCopyFromFixedAsset(var ExciseJournalLine: Record "Sust. Excise Jnl. Line"; FixedAsset: Record "Fixed Asset") (integration)
  • subscribers: Codeunit 7413 “Excise Tax Trans Subscriber” OnAfterCopyFromFixedAsset
• OnValidateSustainabilityExciseJournalLineByFieldOnBeforeShowUnsupportedEntryError(var ExciseJournalLine: Record "Sust. Excise Jnl. Line"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
  • subscribers: Codeunit 7413 “Excise Tax Trans Subscriber” 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”
• 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”
• Shortcut Dimension 1 Code: TableRelation Table 349 “Dimension Value”
• Shortcut Dimension 2 Code: TableRelation Table 349 “Dimension Value”
• 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”
• Material Breakdown No.: TableRelation Table 6236 “Sust. Item Mat. Comp. Header”
• 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”

Referenced by

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

• Table 6239 “Sust. Excise Journal Batch”: No. of Lines

Pages and codeunits on this table

• Page 6287 “Sustainability Excise Journal” (source table)
• Codeunit 6271 “Sust. Excise Jnl.-Post” (codeunit runs on it)

Extended by

• Table extension 7413 “Excise Journal Line Ext”

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” (3 calls: CreateDim → GetRecDefaultDimID, InitDefaultDimensionSources → AddDimSource, ShowDimensions → EditDimensionSet)
• Codeunit 6270 “Sust. Excise Journal Mgt.” (1 call: SetupNewLine → GetDocumentNo)

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