Table: dbo.Shortfall_Balance_Payroll_Check_Treatment
Type table which defines the actions to take to apply gains to a prior shortfall.
Columns
NameTypeConstraintsDescription
shortfall_balance_payroll_check_treatment_KEYint (4)NOT NULLPrimary Key
descriptionnvarchar (200)NOT NULLShortfall balance treatment description.
Primary key
NameColumnsDescription
PK_Shortfall_Balance_Payroll_Check_Treatmentshortfall_balance_payroll_check_treatment_KEY
Unique constraints
NameColumnsDescription
UK_Shortfall_Balance_Payroll_Check_Treatment$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payroll_Check_Entry_Option__Shortfall_Balance_Payroll_Check_Treatment__shortfall_balance_payroll_check_treatment_KEYshortfall_balance_payroll_check_treatment_KEYPayroll_Check_Entry_Option

Schema diagram