Table: dbo.Quick_Books_Payroll_Item_N_Client_Payroll_Item
This dictionary table associates quickbooks payroll items with an associated client payroll item.
Columns
NameTypeConstraintsDescription
quick_books_payroll_item_KEYint (4)NOT NULLForeign key to quick books payroll item table. This is the primary key in that table.
client_payroll_item_KEYint (4)NOT NULLForeign key to the client payroll item table. This is the primary key in that table.
Primary key
NameColumnsDescription
PK_Quick_Books_Payroll_Item_N_Client_Payroll_Item$quick_books_payroll_item_KEYquick_books_payroll_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Payroll_Item_N_Client_Payroll_Item__Client_Payroll_Item__client_payroll_item_KEYclient_payroll_item_KEYClient_Payroll_Item (client_payroll_item_KEY)
FK_Quick_Books_Payroll_Item_N_Client_Payroll_Item__Quick_Books_Payroll_Item__quick_books_payroll_item_KEYquick_books_payroll_item_KEYQuick_Books_Payroll_Item (quick_books_payroll_item_KEY)

Schema diagram