Table: dbo.Payroll_Check_Tax_Item
Columns
Name | Type | Constraints | Description
payroll_check_tax_item_KEY | int (4) | NOT NULL | Primary key for this table
bank_transaction_KEY | int (4) | NOT NULL | Reference to payroll check
client_tax_item_KEY | int (4) | NOT NULL | Mandatory reference to client level tax item
employee_tax_item_KEY | int (4) |  | Optional reference to employee level tax item
description | nvarchar (200) | NOT NULL | Description of Payroll_Check_Tax_Item record
vendor_KEY | int (4) |  | Associated vendor for payroll payable generation
liability__gl_account_KEY | int (4) |  | Key to the gl_account table for liability account.
expense__gl_account_KEY | int (4) |  | Key to the gl_account table for expense account.
reason_for_taxable_wages_override | nvarchar (2048) | NOT NULL | Optional 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
Name | Columns | Description
PK_Payroll_Check_Tax_Item | payroll_check_tax_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payroll_Check_Tax_Item__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Client_Tax_Item (client_tax_item_KEY) |
FK_Payroll_Check_Tax_Item__Employee_Tax_Item__employee_tax_item_KEY | employee_tax_item_KEY | Employee_Tax_Item (employee_tax_item_KEY) |
FK_Payroll_Check_Tax_Item__GL_Account__expense__gl_account_KEY | expense__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Payroll_Check_Tax_Item__GL_Account__liability__gl_account_KEY | liability__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Payroll_Check_Tax_Item__Payroll_Bank_Transaction__bank_transaction_KEY | bank_transaction_KEY | Payroll_Bank_Transaction (bank_transaction_KEY) |
FK_Payroll_Check_Tax_Item__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Shortfall_Transaction_N_Payroll_Check_Tax_Item__Payroll_Check_Tax_Item__payroll_check_tax_item_KEY | payroll_check_tax_item_KEY | Shortfall_Transaction_N_Payroll_Check_Tax_Item |
FK_Payroll_Check_Tax_Item_Distribution__Payroll_Check_Tax_Item__payroll_check_tax_item_KEY | payroll_check_tax_item_KEY | Payroll_Check_Tax_Item_Distribution |
FK_Payable_Transaction_N_Payroll_Check_Tax_Item__Payroll_Check_Tax_Item__payroll_check_tax_item_KEY | payroll_check_tax_item_KEY | Payable_Transaction_N_Payroll_Check_Tax_Item |