Table 322 "Tax Detail"

Base Application · Microsoft.Finance.SalesTax · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 468 “Tax Details” (6 Learn pages).

Properties

Property	Value
Caption	Tax Detail
DataClassification	CustomerContent

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	Tax Jurisdiction Code Δ BC29	Code[10]	Specifies the tax jurisdiction code for the tax-detail entry.	TableRelation Table 320 “Tax Jurisdiction” (Tax Jurisdiction); NotBlank
2	Tax Group Code Δ BC29	Code[20]	Specifies the tax group code for the tax-detail entry.	TableRelation Table 321 “Tax Group” (Tax Group)
3	Tax Type Δ BC29	Option	Specifies the type of tax (Sales Tax or Excise Tax) that applies to the tax-detail entry.	OptionCaption: Sales Tax,Excise Tax
4	Maximum Amount/Qty. Δ BC28 Δ BC29	Decimal	Specifies a maximum amount or quantity. The program finds the appropriate tax percentage in either the Tax Below Maximum or the Tax Above Maximum field.
5	Tax Below Maximum Δ BC28 Δ BC29	Decimal	Specifies the percentage that will be used to calculate tax for all amounts or quantities below the maximum amount quantity in the Maximum Amount/Qty. field.
6	Tax Above Maximum Δ BC28 Δ BC29	Decimal	Specifies the percentage that will be used to calculate tax for all amounts or quantities above the maximum amount quantity in the Maximum Amount/Qty. field.
7	Effective Date Δ BC29	Date	Specifies a date on which the tax-detail entry will go into effect. This allows you to set up tax details in advance.
8	Calculate Tax on Tax	Boolean	—	not editable

Keys

Key1: Tax Jurisdiction Code, Tax Group Code, Tax Type, Effective Date (clustered)

Procedures

ValidateTaxSetup(TaxAreaCode: Code[20]; TaxGroupCode: Code[20]; EffectiveDate: Date): Validates and creates missing tax details for a specific tax area and group combination. Ensures all required tax detail records exist for proper tax calculation.
GetSalesTaxRate(TaxAreaCode: Code[20]; TaxGroupCode: Code[20]; EffectiveDate: Date; TaxLiable: Boolean): Decimal: Calculates the total sales tax rate for a tax area and group combination. Sums tax rates across all jurisdictions within the specified tax area.
SetSalesTaxRate(TaxAreaCode: Code[20]; TaxGroupCode: Code[20]; NewTaxRate: Decimal; EffectiveDate: Date): Updates the sales tax rate for a specific tax area and group combination. Automatically distributes rate changes across appropriate jurisdictions.
SetSalesTaxRateDetailed(TaxAreaCode: Code[20]; TaxGroupCode: Code[20]; NewCityRate: Decimal; NewCountyRate: Decimal; NewStateRate: Decimal; EffectiveDate: Date): Sets detailed sales tax rates for city, county, and state jurisdictions separately. Allows precise control over multi-level jurisdiction tax rates.

Plus 3 local procedures.

Triggers

OnInsert, OnRename

Relations

Tax Jurisdiction Code: TableRelation Table 320 “Tax Jurisdiction”
Tax Group Code: TableRelation Table 321 “Tax Group”

Pages and codeunits on this table

Page 468 “Tax Details” (source table)

Countries that replace it

CA, MX, US

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

Across versions

Neighbourhood 9 connected objects and pages