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) |