Table 7416 "Excise Tax Rate"

ExciseTaxes · Microsoft.ExciseTaxes · captioned “Excise Duty Rate” · BC29-30 · source at ea08af5e · facts from BC29

Properties

Property	Value
Caption	Excise Duty Rate
DataClassification	CustomerContent
LookupPageId	Excise Tax Rates
DrillDownPageId	Excise Tax Rates

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	Excise Tax Type Code	Code[20]	Specifies the excise tax type code. via Page 7418 “Excise Tax Rates”	TableRelation Table 7412 “Excise Tax Type” (“Excise Tax Type”.Code); NotBlank
2	Source Type	Enum “Excise Source Type”	Specifies whether this rate applies to an Item or Fixed Asset. via Page 7418 “Excise Tax Rates”	enum Enum 7413 “Excise Source Type”; NotBlank
3	Source No.	Code[20]	Specifies the Item or Fixed Asset number. via Page 7418 “Excise Tax Rates”	TableRelation Table 27 “Item”, Table 5600 “Fixed Asset” (if (“Source Type” = const(Item)) Item else if (“Source Type” = const(“Fixed Asset”)) “Fixed Asset”)
4	Excise Duty	Decimal	Specifies the excise duty. via Page 7418 “Excise Tax Rates”
5	Effective From Date	Date	Specifies when this excise duty becomes effective. via Page 7418 “Excise Tax Rates”	NotBlank
7	Description	Text[100]	—
8	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 7418 “Excise Tax Rates”	enum Enum 7415 “Excise Calculation Type”
9	Excise Duty %	Decimal	Specifies the percentage of the taxable amount that is charged as excise duty. via Page 7418 “Excise Tax Rates”
10	Item Category Code	Code[20]	Specifies the item category that this rate applies to. Leave it blank to apply the rate to all item categories. via Page 7418 “Excise Tax Rates”	TableRelation Table 5722 “Item Category” (“Item Category”.Code)

Keys

Key1: Excise Tax Type Code, Source Type, Source No., Item Category Code, Effective From Date (clustered)
Key2: Excise Tax Type Code

Procedures

GetEffectiveExciseRate(TaxTypeCode: Code[20]; SourceType: Enum "Excise Source Type"; SourceNo: Code[20]; ItemCategoryCode: Code[20]; EffectiveDate: Date): Boolean: Loads the rate line that applies to the given source, from the most specific match to the rate that applies to every source of that type.
ConvertSustSourceTypeToExciseSourceType(SustSourceType: Enum "Sust. Excise Jnl. Source Type"): Enum "Excise Source Type"

Plus 5 local procedures.

Triggers

OnInsert, OnModify

Relations

drill-down page Page 7418 “Excise Tax Rates”
lookup page Page 7418 “Excise Tax Rates”
Source No.: TableRelation Table 27 “Item” (conditional)
Source No.: TableRelation Table 5600 “Fixed Asset” (conditional)
Item Category Code: TableRelation Table 5722 “Item Category”
Excise Tax Type Code: TableRelation Table 7412 “Excise Tax Type”

Pages and codeunits on this table

Page 7418 “Excise Tax Rates” (source table)

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.

Page 31 “Item List” (1 call: LookupItem → (object))
Page 5601 “Fixed Asset List” (1 call: LookupFixedAsset → (object))

Recent changes

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

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: "Excise Tax Rate"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.