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