Table: dbo.Ultra_Tax_Entity_Type
Ultra Tax Enity information
Columns
Name | Type | Constraints | Description
ultra_tax_entity_type_KEY | int (4) | NOT NULL | Primary Key
map_file_prefix | nvarchar (4) | NOT NULL | Ultra Tax map file prefix for this entity type
description | nvarchar (100) | NOT NULL | Values: 1120, 1120S, 1065, 1040, 1041, 990, 990PF, 5500, 1120PR, 1065PR, 1120SPR
entity_code | nvarchar (2) | NOT NULL | Single character code for this entity type.

Primary key
Name | Columns | Description
PK_Ultra_Tax_Entity_Type | ultra_tax_entity_type_KEY |
Unique constraints
Name | Columns | Description
UK_Ultra_Tax_Entity_Type$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Ultra_Tax_Tax_Code__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEY | ultra_tax_entity_type_KEY | Ultra_Tax_Tax_Code |
FK_Ultra_Tax_Staged_Tax_Code__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEY | ultra_tax_entity_type_KEY | Ultra_Tax_Staged_Tax_Code |
FK_Tax_Reconciliation_Schedule_Line__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEY | ultra_tax_entity_type_KEY | Tax_Reconciliation_Schedule_Line |
FK_GL_Account_Classification_N_Tax_Code__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEY | ultra_tax_entity_type_KEY | GL_Account_Classification_N_Tax_Code |
FK_GL_Account_Classification_N_Tax_Code_M3__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEY | ultra_tax_entity_type_KEY | GL_Account_Classification_N_Tax_Code_M3 |
FK_Client_GL_Setup__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEY | ultra_tax_entity_type_KEY | Client_GL_Setup |