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