Table: dbo.Payroll_Check_Entry_Option_Shortfall_Tax_Treatment | |||
This table contains the client tax items used to reduce a negative check. | |||
Columns | |||
Name | Type | Constraints | Description |
payroll_check_entry_option_shortfall_tax_treatment_KEY | int (4) | NOT NULL | Primary Key. |
client_pay_schedule_KEY | int (4) | NOT NULL | Indicates which payroll check entry option this is related to. |
shortfall_tax_treatment_type_KEY | int (4) | NOT NULL | Indicates which tax treatment types can be used to reduce a negative check. |
payroll_check_entry_option_shortfall_tax_treatment_version | timestamp (8) | NOT NULL | The version of this row. It's an aid in versioning the row. |
Primary key | |||
Name | Columns | Description | |
PK_Payroll_Check_Entry_Option_Shortfall_Tax_Treatment | payroll_check_entry_option_shortfall_tax_treatment_KEY | ||
Unique constraints | |||
Name | Columns | Description | |
UK_Payroll_Check_Entry_Option_Shortfall_Tax_Treatment$client_pay_schedule_KEY$shortfall_tax_treatment_type_KEY | client_pay_schedule_KEY, shortfall_tax_treatment_type_KEY |