Table: dbo.Tax_Jurisdiction | |||
Columns | |||
Name | Type | Constraints | Description |
tax_jurisdiction_KEY | int (4) | NOT NULL | Primary key of this table. |
description | nvarchar (160) | NOT NULL | Description of Tax_Jurisdiction record. |
client_KEY | int (4) | NOT NULL | Key of associated client. |
tax_jurisdiction_type_KEY | nvarchar (30) | NOT NULL | Type of tax jurisdiction. |
parent__tax_jurisdiction_KEY | int (4) | parent__tax_jurisdiction_KEY | |
ste_state_code_KEY | nvarchar (4) | NOT NULL | STE state code |
do_not_consolidate | bit (1) | NOT NULL | A flag to mark certain jurisdictions as not consolidated.["BR"] If this flag is true, payroll tax forms should be filed at an individual client level. |
Primary key | |||
Name | Columns | Description | |
PK_Tax_Jurisdiction | tax_jurisdiction_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Tax_Jurisdiction$client_KEY$description$tax_jurisdiction_type_KEY$ste_state_code_KEY | client_KEY, description, tax_jurisdiction_type_KEY, ste_state_code_KEY |