Table: dbo.Tax_Agent_Form_Filing_Address | |||
Table for all the current form filing address for the tax agents. | |||
Columns | |||
Name | Type | Constraints | Description |
tax_agent_form_filing_address_KEY | int (4) | NOT NULL | Primary Key |
tax_agent_KEY | int (4) | NOT NULL | Foreign key to the related tax agent. |
tax_form_KEY | int (4) | NOT NULL | Foreign key to the related tax form. |
address_KEY | int (4) | NOT NULL | Foreign key to the address table. |
tax_agent_form_filing_address_scenario_KEY | int (4) | NOT NULL | Foreign key to the tax agent form filing address scenario type table. |
addressee | nvarchar (200) | NOT NULL | The name of the addressee for this address. |
Primary key | |||
Name | Columns | Description | |
PK_Tax_Agent_Form_Filing_Address | tax_agent_form_filing_address_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Tax_Agent_Form_Filing_Address$tax_agent_KEY$tax_form_KEY$tax_agent_form_filing_address_scenario_KEY | tax_agent_KEY, tax_form_KEY, tax_agent_form_filing_address_scenario_KEY | ||
UK_Tax_Agent_Form_Filing_Address$address_KEY | address_KEY |