| 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 | |