Table: dbo.Shortfall_Balance_Payroll_Check_Treatment | |||
Type table which defines the actions to take to apply gains to a prior shortfall. | |||
Columns | |||
Name | Type | Constraints | Description |
shortfall_balance_payroll_check_treatment_KEY | int (4) | NOT NULL | Primary Key |
description | nvarchar (200) | NOT NULL | Shortfall balance treatment description. |
Primary key | |||
Name | Columns | Description | |
PK_Shortfall_Balance_Payroll_Check_Treatment | shortfall_balance_payroll_check_treatment_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Shortfall_Balance_Payroll_Check_Treatment$description | description |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Payroll_Check_Entry_Option__Shortfall_Balance_Payroll_Check_Treatment__shortfall_balance_payroll_check_treatment_KEY | shortfall_balance_payroll_check_treatment_KEY | Payroll_Check_Entry_Option |