Table: dbo.Payroll_Check_Entry_Option_Shortfall_Tax_Treatment
This table contains the client tax items used to reduce a negative check.
Columns
NameTypeConstraintsDescription
payroll_check_entry_option_shortfall_tax_treatment_KEYint (4)NOT NULLPrimary Key.
client_pay_schedule_KEYint (4)NOT NULLIndicates which payroll check entry option this is related to.
shortfall_tax_treatment_type_KEYint (4)NOT NULLIndicates which tax treatment types can be used to reduce a negative check.
payroll_check_entry_option_shortfall_tax_treatment_versiontimestamp (8)NOT NULLThe version of this row. It's an aid in versioning the row.
Primary key
NameColumnsDescription
PK_Payroll_Check_Entry_Option_Shortfall_Tax_Treatmentpayroll_check_entry_option_shortfall_tax_treatment_KEY
Unique constraints
NameColumnsDescription
UK_Payroll_Check_Entry_Option_Shortfall_Tax_Treatment$client_pay_schedule_KEY$shortfall_tax_treatment_type_KEYclient_pay_schedule_KEY, shortfall_tax_treatment_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Entry_Option_Shortfall_Tax_Treatment__Payroll_Check_Entry_Option__client_pay_schedule_KEYclient_pay_schedule_KEYPayroll_Check_Entry_Option (client_pay_schedule_KEY)
FK_Payroll_Check_Entry_Option_Shortfall_Tax_Treatment__Shortfall_Tax_Treatment_Type__shortfall_tax_treatment_type_KEYshortfall_tax_treatment_type_KEYShortfall_Tax_Treatment_Type (shortfall_tax_treatment_type_KEY)

Schema diagram