Table: dbo.Shortfall_Tax_Treatment_Selection
Table that defines which client tax items are applicable for shortfall processing
Columns
NameTypeConstraintsDescription
shortfall_tax_treatment_selection_KEYint (4)NOT NULL
client_KEYint (4)NOT NULLForeign key to the associated client
shortfall_tax_treatment_type_KEYint (4)NOT NULLForeign key to the associated tax treatment type
Primary key
NameColumnsDescription
PK_Shortfall_Tax_Treatment_Selectionshortfall_tax_treatment_selection_KEY
Unique constraints
NameColumnsDescription
UK_Shortfall_Tax_Treatment_Selection$client_KEY$shortfall_tax_treatment_type_KEYclient_KEY, shortfall_tax_treatment_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Shortfall_Tax_Treatment_Selection__Client__client_KEYclient_KEYClient (client_KEY)
FK_Shortfall_Tax_Treatment_Selection__Shortfall_Tax_Treatment_Type__shortfall_tax_treatment_type_KEYshortfall_tax_treatment_type_KEYShortfall_Tax_Treatment_Type (shortfall_tax_treatment_type_KEY)

Schema diagram