Table: dbo.Tax_Code_N_Ultra_Tax_Tax_Code | |||
Connects a client's tax code to the Ultra Tax tax code info for a specific year and entity type. | |||
Columns | |||
Name | Type | Constraints | Description |
tax_code_n_ultra_tax_tax_code_KEY | int (4) | NOT NULL | Primary Key. |
tax_code_KEY | int (4) | NOT NULL | Key to the Tax_Code table |
ultra_tax_tax_code_KEY | int (4) | NOT NULL | Key to the Ultra_Tax_Tax_Code table |
tax_subcode_description | nvarchar (100) | NOT NULL | User entered descriptive text for the user entered custom tax code |
Primary key | |||
Name | Columns | Description | |
PK_Tax_Code_N_Ultra_Tax_Tax_Code | tax_code_n_ultra_tax_tax_code_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Tax_Code_N_Ultra_Tax_Tax_Code$tax_code_KEY$ultra_tax_tax_code_KEY | tax_code_KEY, ultra_tax_tax_code_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Tax_Code_N_Ultra_Tax_Tax_Code__Tax_Code__tax_code_KEY | tax_code_KEY | Tax_Code (tax_code_KEY) | |
FK_Tax_Code_N_Ultra_Tax_Tax_Code__Ultra_Tax_Tax_Code__ultra_tax_tax_code_KEY | ultra_tax_tax_code_KEY | Ultra_Tax_Tax_Code (ultra_tax_tax_code_KEY) |