Table: dbo.Ultra_Tax_Staged_Tax_Code
This table is used to stage incoming Ultra Tax tax codes before they are merged into the global and client Ultra Tax tax codes.
Columns
Name | Type | Constraints | Description
ultra_tax_staged_tax_code_KEY | int (4) | NOT NULL | Primary Key
code_year | int (4) | NOT NULL | Year this tax code is for
tax_code | nvarchar (10) | NOT NULL | Ultra Tax tax code
ultra_tax_entity_type_KEY | int (4) | NOT NULL | Entity type this tax code is for
ultra_tax_category_type_KEY | int (4) | NOT NULL | Tax code category; Standard, Puerto Rico, M3A, M3B, M3C, ALL
description | nvarchar (100) | NOT NULL | Ultra Tax tax code form line and description concatenated
gl_account_type_KEY | int (4) |  | Account type; A, L, E, R for entity types 1120, 1120S and 1065, otherwise NULL.

Primary key
Name | Columns | Description
PK_Ultra_Tax_Staged_Tax_Code | ultra_tax_staged_tax_code_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Ultra_Tax_Staged_Tax_Code__GL_Account_Type__gl_account_type_KEY | gl_account_type_KEY | GL_Account_Type (gl_account_type_KEY) |
FK_Ultra_Tax_Staged_Tax_Code__Ultra_Tax_Category_Type__ultra_tax_category_type_KEY | ultra_tax_category_type_KEY | Ultra_Tax_Category_Type (ultra_tax_category_type_KEY) |
FK_Ultra_Tax_Staged_Tax_Code__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEY | ultra_tax_entity_type_KEY | Ultra_Tax_Entity_Type (ultra_tax_entity_type_KEY) |