Table: dbo.Shortfall_Tax_Treatment_Type
Type table which defines the selectable tax types
Columns
Name | Type | Constraints | Description
shortfall_tax_treatment_type_KEY | int (4) | NOT NULL | Primary Key
description | nvarchar (40) | NOT NULL | Description of the selectable tax type

Primary key
Name | Columns | Description
PK_Shortfall_Tax_Treatment_Type | shortfall_tax_treatment_type_KEY |
Unique constraints
Name | Columns | Description
UK_Shortfall_Tax_Treatment_Type$description | description |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Shortfall_Tax_Treatment_Selection__Shortfall_Tax_Treatment_Type__shortfall_tax_treatment_type_KEY | shortfall_tax_treatment_type_KEY | Shortfall_Tax_Treatment_Selection |
FK_Payroll_Check_Entry_Option_Shortfall_Tax_Treatment__Shortfall_Tax_Treatment_Type__shortfall_tax_treatment_type_KEY | shortfall_tax_treatment_type_KEY | Payroll_Check_Entry_Option_Shortfall_Tax_Treatment |