Table: dbo.Payroll_Check_Tax_Item
Columns
NameTypeConstraintsDescription
payroll_check_tax_item_KEYint (4)NOT NULLPrimary key for this table
bank_transaction_KEYint (4)NOT NULLReference to payroll check
client_tax_item_KEYint (4)NOT NULLMandatory reference to client level tax item
employee_tax_item_KEYint (4)Optional reference to employee level tax item
descriptionnvarchar (200)NOT NULLDescription of Payroll_Check_Tax_Item record
vendor_KEYint (4)Associated vendor for payroll payable generation
liability__gl_account_KEYint (4)Key to the gl_account table for liability account.
expense__gl_account_KEYint (4)Key to the gl_account table for expense account.
reason_for_taxable_wages_overridenvarchar (2048)NOT NULLOptional note the user may create to explain overriding the subject wages and/or gross subject wages for the distributions for a payroll check tax item
Primary key
NameColumnsDescription
PK_Payroll_Check_Tax_Itempayroll_check_tax_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payroll_Check_Tax_Item__Client_Tax_Item__client_tax_item_KEYclient_tax_item_KEYClient_Tax_Item (client_tax_item_KEY)
FK_Payroll_Check_Tax_Item__Employee_Tax_Item__employee_tax_item_KEYemployee_tax_item_KEYEmployee_Tax_Item (employee_tax_item_KEY)
FK_Payroll_Check_Tax_Item__GL_Account__expense__gl_account_KEYexpense__gl_account_KEYGL_Account (gl_account_KEY)
FK_Payroll_Check_Tax_Item__GL_Account__liability__gl_account_KEYliability__gl_account_KEYGL_Account (gl_account_KEY)
FK_Payroll_Check_Tax_Item__Payroll_Bank_Transaction__bank_transaction_KEYbank_transaction_KEYPayroll_Bank_Transaction (bank_transaction_KEY)
FK_Payroll_Check_Tax_Item__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Shortfall_Transaction_N_Payroll_Check_Tax_Item__Payroll_Check_Tax_Item__payroll_check_tax_item_KEYpayroll_check_tax_item_KEYShortfall_Transaction_N_Payroll_Check_Tax_Item
FK_Payroll_Check_Tax_Item_Distribution__Payroll_Check_Tax_Item__payroll_check_tax_item_KEYpayroll_check_tax_item_KEYPayroll_Check_Tax_Item_Distribution
FK_Payable_Transaction_N_Payroll_Check_Tax_Item__Payroll_Check_Tax_Item__payroll_check_tax_item_KEYpayroll_check_tax_item_KEYPayable_Transaction_N_Payroll_Check_Tax_Item

Schema diagram