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 |