Table: dbo.Quick_Books_Payroll_Item
This table contains information about payroll items that we have imported from quickbooks.
Columns
NameTypeConstraintsDescription
quick_books_payroll_item_KEYint (4)NOT NULLThe primary key.
client_KEYint (4)NOT NULLForeign key to Client table. Client for whom this payroll item was imported.
quick_books_payroll_item_type_KEYint (4)NOT NULLThe quickbooks payroll item type. Foreign key to the Quick Books Payroll Item Type table.
is_wage_itembit (1)NOT NULLpayroll items in quickboks are divided into two categories: wage and non wage.
list_idnvarchar (120)NOT NULLUnique identifier of the payroll item, according to Intuit documentation.
namenvarchar (100)NOT NULLThe name of the payroll item in quick books.
is_activebit (1)NOT NULLflag to tell us if the payroll item is active or not in quickbooks.
Primary key
NameColumnsDescription
PK_Quick_Books_Payroll_Itemquick_books_payroll_item_KEY
Unique constraints
NameColumnsDescription
UK_Quick_Books_Payroll_Item$list_id$client_KEYlist_id, client_KEY
UK_Quick_Books_Payroll_Item$name$client_KEYname, client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Payroll_Item__Client__client_KEYclient_KEYClient (client_KEY)
FK_Quick_Books_Payroll_Item__Quick_Books_Payroll_Item_Type__quick_books_payroll_item_type_KEYquick_books_payroll_item_type_KEYQuick_Books_Payroll_Item_Type (quick_books_payroll_item_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
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_N_Client_Payroll_Item
FK_Quick_Books_Payroll_Item_N_Client_Tax_Item__Quick_Books_Payroll_Item__quick_books_payroll_item_KEYquick_books_payroll_item_KEYQuick_Books_Payroll_Item_N_Client_Tax_Item

Schema diagram