Table: dbo.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_KEYint (4)NOT NULLDatabase assigned primary key for this table.
descriptionnvarchar (60)NOT NULLDescription for this Taxing Authority
ratedecimal (5, 6)NOT NULLPercentage rate that this Taxing Authority's tax calculation.
taxing_authority_type_KEYint (4)NOT NULLThe type of tax that this authority is authorized to tax.
apply_to_shippingbit (1)NOT NULLFlag, true if this tax applies to shipping amounts
apply_to_discountbit (1)NOT NULLFlag, true if this tax applies to discount amounts
Primary key
NameColumnsDescription
PK_Taxing_Authoritytaxing_authority_KEY
Unique constraints
NameColumnsDescription
UK_Taxing_Authority$descriptiondescription
Foreign keys
NameColumnsReferenced tableDescription
FK_Taxing_Authority__Taxing_Authority_Type__taxing_authority_type_KEYtaxing_authority_type_KEYTaxing_Authority_Type (taxing_authority_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Spreadsheet_Import_Taxing_Authority__Taxing_Authority__taxing_authority_KEYtaxing_authority_KEYSpreadsheet_Import_Taxing_Authority
FK_AR_Item__Taxing_Authority__taxing_authority_KEYtaxing_authority_KEYAR_Item
FK_Client_Billing_Sales_Tax__Taxing_Authority__taxing_authority_KEYtaxing_authority_KEYClient_Billing_Sales_Tax

Schema diagram