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
Name | Type | Constraints | Description
taxing_authority_KEY | int (4) | NOT NULL | Database assigned primary key for this table.
description | nvarchar (60) | NOT NULL | Description for this Taxing Authority
rate | decimal (5, 6) | NOT NULL | Percentage rate that this Taxing Authority's tax calculation.
taxing_authority_type_KEY | int (4) | NOT NULL | The type of tax that this authority is authorized to tax.
apply_to_shipping | bit (1) | NOT NULL | Flag, true if this tax applies to shipping amounts
apply_to_discount | bit (1) | NOT NULL | Flag, true if this tax applies to discount amounts

Primary key
Name | Columns | Description
PK_Taxing_Authority | taxing_authority_KEY |
Unique constraints
Name | Columns | Description
UK_Taxing_Authority$description | description |

Foreign keys
Name | Columns | Referenced table | Description
FK_Taxing_Authority__Taxing_Authority_Type__taxing_authority_type_KEY | taxing_authority_type_KEY | Taxing_Authority_Type (taxing_authority_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Spreadsheet_Import_Taxing_Authority__Taxing_Authority__taxing_authority_KEY | taxing_authority_KEY | Spreadsheet_Import_Taxing_Authority |
FK_AR_Item__Taxing_Authority__taxing_authority_KEY | taxing_authority_KEY | AR_Item |
FK_Client_Billing_Sales_Tax__Taxing_Authority__taxing_authority_KEY | taxing_authority_KEY | Client_Billing_Sales_Tax |