Table: dbo.Shortfall_Tax_Treatment_Selection
Table that defines which client tax items are applicable for shortfall processing
Columns
Name | Type | Constraints | Description
shortfall_tax_treatment_selection_KEY | int (4) | NOT NULL |
client_KEY | int (4) | NOT NULL | Foreign key to the associated client
shortfall_tax_treatment_type_KEY | int (4) | NOT NULL | Foreign key to the associated tax treatment type

Primary key
Name | Columns | Description
PK_Shortfall_Tax_Treatment_Selection | shortfall_tax_treatment_selection_KEY |
Unique constraints
Name | Columns | Description
UK_Shortfall_Tax_Treatment_Selection$client_KEY$shortfall_tax_treatment_type_KEY | client_KEY, shortfall_tax_treatment_type_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Shortfall_Tax_Treatment_Selection__Client__client_KEY | client_KEY | Client (client_KEY) |
FK_Shortfall_Tax_Treatment_Selection__Shortfall_Tax_Treatment_Type__shortfall_tax_treatment_type_KEY | shortfall_tax_treatment_type_KEY | Shortfall_Tax_Treatment_Type (shortfall_tax_treatment_type_KEY) |