Table: dbo.Payroll_Check_Tax_Item_Distribution
Columns
NameTypeConstraintsDescription
payroll_check_tax_item_distribution_KEYint (4)NOT NULLPrimary key for this table
payroll_check_tax_item_KEYint (4)NOT NULLReference to payroll check tax item
work_location_KEYint (4)NOT NULLReference to work location
payroll_department_KEYint (4)Reference to payroll department
amount_originaldecimal (9, 2)NOT NULLDistribution amount
gross_subject_wages_originaldecimal (9, 2)NOT NULLOriginal gross subject wages amount as it was initially calculated
subject_wages_originaldecimal (9, 2)NOT NULLOriginal subject wages amount as it was initially calculated
tax_ratedecimal (5, 6)NOT NULLRate used to calculate tax amount at time of calculation.
tax_limitdecimal (9, 2)NOT NULLLimit of tax item at time of calculation.
amount_overridedecimal (9, 2)Overridden amount
liability__gl_account_KEYint (4)NOT NULLKey to the gl_account table for the liability account.
expense__gl_account_KEYint (4)Key to the gl_account table for the expense account.
subject_wages_overridedecimal (9, 2)Optional user override of the original subject wages amount
gross_subject_wages_overridedecimal (9, 2)Optional user override of the original gross subject wages amount
amountdecimal (9, 2)NOT NULLAmount of distribution, either amount_override if not null otherwise amount_original.
gross_subject_wagesdecimal (9, 2)NOT NULLDisplay gross subject wages that is based on an existing override to this field. Will display the initially calculated gross subject wages if no override is present.
subject_wagesdecimal (9, 2)NOT NULLDisplay subject wages that is based on an existing override to this field. Will display the initially calculated subject wages if no override is present.
Primary key
NameColumnsDescription
PK_Payroll_Check_Tax_Item_Distributionpayroll_check_tax_item_distribution_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Tax_Item_Distribution__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYGL_Account (gl_account_KEY)
FK_Payroll_Check_Tax_Item_Distribution__GL_Account__liability__gl_account_KEYliability__gl_account_KEYGL_Account (gl_account_KEY)
FK_Payroll_Check_Tax_Item_Distribution__Payroll_Check_Tax_Item__payroll_check_tax_item_KEYpayroll_check_tax_item_KEYPayroll_Check_Tax_Item (payroll_check_tax_item_KEY)
FK_Payroll_Check_Tax_Item_Distribution__Payroll_Department__payroll_department_KEYpayroll_department_KEYPayroll_Department (payroll_department_KEY)
FK_Payroll_Check_Tax_Item_Distribution__Work_Location__work_location_KEYwork_location_KEYWork_Location (work_location_KEY)

Schema diagram