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
Name | Type | Constraints | Description
taxing_authority_KEY | int | NOT NULL | AUTO-INCREMENT: Database assigned primary key for this table.
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
description | nvarchar (30) | NOT NULL | Description for this Taxing Authority
rate | decimal (7, 6) | NOT NULL | Percentage rate that this Taxing Authority's tax calculation.
taxing_authority_type_KEY | int | NOT NULL | The type of tax that this authority is authorized to tax.
gl_account | nvarchar (60) | NOT NULL | General Ledger account number used in CSA
create_date | datetime | NOT NULL |
apply_to_shipping | bit | NOT NULL | Flag, true if this tax applies to shipping amounts
apply_to_discount | bit | NOT NULL | Flag, true if this tax applies to discount amounts

Primary key
Name | Columns | Description
PK_Taxing_Authority$taxing_authority_KEY | taxing_authority_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Taxing_Authority__description | description | Each description must be unique.
Indexes
Name | Columns | Description
IX_Taxing_Authority$taxing_authority_type_KEY | taxing_authority_type_KEY | Index supports foreign key FK_Taxing_Authority__Taxing_Authority_Type__taxing_authority_type_KEY

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

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Tax_Area_Taxing_Authority__Taxing_Authority__taxing_authority_KEY | taxing_authority_KEY | Tax_Area_Taxing_Authority |
FK_Billing_Decision_Taxing_Authority__Taxing_Authority__taxing_authority_KEY | taxing_authority_KEY | Billing_Decision_Taxing_Authority |