Table: dbo.Shortfall_Tax_Treatment_Type
Type table which defines the selectable tax types
Columns
NameTypeConstraintsDescription
shortfall_tax_treatment_type_KEYint (4)NOT NULLPrimary Key
descriptionnvarchar (40)NOT NULLDescription of the selectable tax type
Primary key
NameColumnsDescription
PK_Shortfall_Tax_Treatment_Typeshortfall_tax_treatment_type_KEY
Unique constraints
NameColumnsDescription
UK_Shortfall_Tax_Treatment_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Shortfall_Tax_Treatment_Selection__Shortfall_Tax_Treatment_Type__shortfall_tax_treatment_type_KEYshortfall_tax_treatment_type_KEYShortfall_Tax_Treatment_Selection
FK_Payroll_Check_Entry_Option_Shortfall_Tax_Treatment__Shortfall_Tax_Treatment_Type__shortfall_tax_treatment_type_KEYshortfall_tax_treatment_type_KEYPayroll_Check_Entry_Option_Shortfall_Tax_Treatment

Schema diagram