Table: dbo.Quick_Books_Payroll_Item_N_Client_Tax_Item
This dictionary table associates quickbooks payroll items of type tax with an associated client tax item.
Columns
Name | Type | Constraints | Description
quick_books_payroll_item_KEY | int (4) | NOT NULL | Foreign key to the quick books payroll item table. This is the primary key in that table.
client_tax_item_KEY | int (4) | NOT NULL | Foreign key to the client tax item table. This is the primary key in that table.

Primary key
Name | Columns | Description
PK_Quick_Books_Payroll_Item_N_Client_Tax_Item$quick_books_payroll_item_KEY | quick_books_payroll_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Quick_Books_Payroll_Item_N_Client_Tax_Item__Client_Tax_Item__client_tax_item_KEY | client_tax_item_KEY | Client_Tax_Item (client_tax_item_KEY) |
FK_Quick_Books_Payroll_Item_N_Client_Tax_Item__Quick_Books_Payroll_Item__quick_books_payroll_item_KEY | quick_books_payroll_item_KEY | Quick_Books_Payroll_Item (quick_books_payroll_item_KEY) |