Table: Taxing_Authority
Taxing authorities are governmental bodies empowered to collect tax on goods, services or both. If both goods and services are taxed at different rates then two taxing authorities would be created.
Columns
NameTypeConstraintsDescription
taxing_authority_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
descriptionnvarchar (250)NOT NULLDescription for this Taxing Authority
ratedecimal (7, 6)NOT NULLPercentage rate that this Taxing Authority's tax calculation.
taxing_authority_type_KEYintNOT NULLThe type of tax that this authority is authorized to tax.
gl_accountnvarchar (60)NOT NULLGeneral Ledger account number used in CSA
create_date_utcdatetimeNOT NULL
apply_to_shippingbitNOT NULLFlag, true if this tax applies to shipping amounts
apply_to_discountbitNOT NULLFlag, true if this tax applies to discount amounts
Primary key
NameColumnsDescription
PK_Taxing_Authority$taxing_authority_KEYtaxing_authority_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Taxing_Authority$descriptiondescriptionEach description must be unique.
Indexes
NameColumnsDescription
IX_Taxing_Authority$taxing_authority_type_KEYtaxing_authority_type_KEYIndex supports foreign key FK_Taxing_Authority__Taxing_Authority_Type__taxing_authority_type_KEY
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Tax_Area_Taxing_Authority__Taxing_Authority__taxing_authority_KEYtaxing_authority_KEYTax_Area_Taxing_Authority
FK_Billing_Decision_Taxing_Authority__Taxing_Authority__taxing_authority_KEYtaxing_authority_KEYBilling_Decision_Taxing_Authority

Schema diagram