Table: dbo.Tax_Reconciliation_Schedule_Line
This table will hold predefined values of tax reconcilation lines for some ultra tax entity type
Columns
Name | Type | Constraints | Description
tax_reconciliation_schedule_line_KEY | int (4) | NOT NULL | Primary key
ultra_tax_entity_type_KEY | int (4) | NOT NULL | a foreign key to Ultra_Tax_Entity_Type
name | nvarchar (40) | NOT NULL | reconciliation line name
description | nvarchar (250) | NOT NULL | description to a tax reconciliation line

Primary key
Name | Columns | Description
PK_Tax_Reconciliation_Schedule_Line | tax_reconciliation_schedule_line_KEY |
Unique constraints
Name | Columns | Description
UK_Tax_Reconciliation_Schedule_Line$ultra_tax_entity_type_KEY$description | ultra_tax_entity_type_KEY, description |
UK_Tax_Reconciliation_Schedule_Line$ultra_tax_entity_type_KEY$name | ultra_tax_entity_type_KEY, name |

Foreign keys
Name | Columns | Referenced table | Description
FK_Tax_Reconciliation_Schedule_Line__Ultra_Tax_Entity_Type__ultra_tax_entity_type_KEY | ultra_tax_entity_type_KEY | Ultra_Tax_Entity_Type (ultra_tax_entity_type_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Journal_Entry__Tax_Reconciliation_Schedule_Line__tax_reconciliation_schedule_line_KEY | tax_reconciliation_schedule_line_KEY | Journal_Entry |