Table extension 7413 "Excise Journal Line Ext"

ExciseTaxes · Microsoft.ExciseTaxes · BC29-30 · source at ea08af5e · facts from BC29

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
7412	Excise Tax Type	Code[20]	Specifies the excise tax type for this journal line. via Page extension 7414 “Excise Journal Line Ext”	TableRelation Table 7412 “Excise Tax Type” (“Excise Tax Type”.Code where(Enabled = const(true))); DataClassification CustomerContent
7413	Excise Entry Type	Enum “Excise Entry Type”	Specifies which entry type was used to calculate the quantity from Item Ledger Entries for this journal line. via Page extension 7414 “Excise Journal Line Ext”	enum Enum 7412 “Excise Entry Type”; not editable; DataClassification CustomerContent
7414	Excise Unit of Measure Code	Code[10]	Specifies the unit of measure for the excise tax quantity. via Page extension 7414 “Excise Journal Line Ext”	TableRelation Table 204 “Unit of Measure” (“Unit of Measure”.Code); DataClassification CustomerContent
7415	Quantity for Excise Tax	Decimal	Specifies the quantity for excise tax calculation. via Page extension 7414 “Excise Journal Line Ext”	DataClassification CustomerContent
7416	Excise Duty	Decimal	Specifies the excise duty applied to this journal line. via Page extension 7414 “Excise Journal Line Ext”	not editable; DataClassification CustomerContent
7417	Tax Amount	Decimal	Specifies the calculated excise tax amount for this journal line. via Page extension 7414 “Excise Journal Line Ext”	not editable; DataClassification CustomerContent
7418	Excise Calculation Type	Enum “Excise Calculation Type”	Specifies whether the excise duty is calculated per unit, as a percentage of the taxable amount, or as a combination of both. via Page extension 7414 “Excise Journal Line Ext”	enum Enum 7415 “Excise Calculation Type”; not editable; DataClassification CustomerContent
7419	Excise Duty %	Decimal	Specifies the percentage of the taxable amount that is charged as excise duty on this journal line. via Page extension 7414 “Excise Journal Line Ext”	not editable; DataClassification CustomerContent
7420	FA Ledger Entry No.	Integer	—	TableRelation Table 5601 “FA Ledger Entry” (“FA Ledger Entry”.“Entry No.”); not editable; DataClassification CustomerContent
7421	Excise Taxable Amount	Decimal	Specifies the amount that the ad valorem part of the excise duty is calculated from. via Page extension 7414 “Excise Journal Line Ext”	DataClassification CustomerContent
7422	Item Category Code	Code[20]	Specifies the item category copied from the item ledger entry. via Page extension 7414 “Excise Journal Line Ext”	TableRelation Table 5722 “Item Category” (“Item Category”.Code); not editable; DataClassification CustomerContent

Procedures

2 local procedures, no public ones.

Triggers

OnInsert

Relations

Excise Unit of Measure Code: TableRelation Table 204 “Unit of Measure”
FA Ledger Entry No.: TableRelation Table 5601 “FA Ledger Entry”
Item Category Code: TableRelation Table 5722 “Item Category”
extends Table 6240 “Sust. Excise Jnl. Line”
Excise Tax Type: TableRelation Table 7412 “Excise Tax Type”

Recent changes

2026-09-15 #11002 [Master] - Slice 626305: [Excise Tax][VENDOR] Improving Excise Duty Calculation (main, BC30, feature)

Ask your agent

Procedure bodies are not stored here (D10). 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: "tableextension", object_name: "Excise Journal Line Ext"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.