Table: dbo.Ultra_Tax_Entity_Type
Ultra Tax Enity information
Columns
NameTypeConstraintsDescription
ultra_tax_entity_type_KEYint (4)NOT NULLPrimary Key
map_file_prefixnvarchar (4)NOT NULLUltra Tax map file prefix for this entity type
descriptionnvarchar (100)NOT NULLValues: 1120, 1120S, 1065, 1040, 1041, 990, 990PF, 5500, 1120PR, 1065PR, 1120SPR
entity_codenvarchar (2)NOT NULLSingle character code for this entity type.
Primary key
NameColumnsDescription
PK_Ultra_Tax_Entity_Typeultra_tax_entity_type_KEY
Unique constraints
NameColumnsDescription
UK_Ultra_Tax_Entity_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Ultra_Tax_Tax_Code__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEYultra_tax_entity_type_KEYUltra_Tax_Tax_Code
FK_Ultra_Tax_Staged_Tax_Code__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEYultra_tax_entity_type_KEYUltra_Tax_Staged_Tax_Code
FK_Tax_Reconciliation_Schedule_Line__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEYultra_tax_entity_type_KEYTax_Reconciliation_Schedule_Line
FK_GL_Account_Classification_N_Tax_Code__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEYultra_tax_entity_type_KEYGL_Account_Classification_N_Tax_Code
FK_GL_Account_Classification_N_Tax_Code_M3__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEYultra_tax_entity_type_KEYGL_Account_Classification_N_Tax_Code_M3
FK_Client_GL_Setup__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEYultra_tax_entity_type_KEYClient_GL_Setup

Schema diagram