Table: dbo.Tax_Reconciliation_Schedule_Line
This table will hold predefined values of tax reconcilation lines for some ultra tax entity type
Columns
NameTypeConstraintsDescription
tax_reconciliation_schedule_line_KEYint (4)NOT NULLPrimary key
ultra_tax_entity_type_KEYint (4)NOT NULLa foreign key to Ultra_Tax_Entity_Type
namenvarchar (40)NOT NULLreconciliation line name
descriptionnvarchar (250)NOT NULLdescription to a tax reconciliation line
Primary key
NameColumnsDescription
PK_Tax_Reconciliation_Schedule_Linetax_reconciliation_schedule_line_KEY
Unique constraints
NameColumnsDescription
UK_Tax_Reconciliation_Schedule_Line$ultra_tax_entity_type_KEY$descriptionultra_tax_entity_type_KEY, description
UK_Tax_Reconciliation_Schedule_Line$ultra_tax_entity_type_KEY$nameultra_tax_entity_type_KEY, name
Foreign keys
NameColumnsReferenced tableDescription
FK_Tax_Reconciliation_Schedule_Line__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEYultra_tax_entity_type_KEYUltra_Tax_Entity_Type (ultra_tax_entity_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Journal_Entry__Tax_Reconciliation_Schedule_Line__tax_reconciliation_schedule_line_KEYtax_reconciliation_schedule_line_KEYJournal_Entry

Schema diagram