Table: dbo.Quick_Books_Payroll_Item_Type
This table stores the valid Quick Books payroll item types
Columns
NameTypeConstraintsDescription
quick_books_payroll_item_type_KEYint (4)NOT NULLPrimary key.
descriptionnvarchar (60)NOT NULLPayroll Item Type description.
Primary key
NameColumnsDescription
PK_Quick_Books_Payroll_Item_Typequick_books_payroll_item_type_KEY
Unique constraints
NameColumnsDescription
UK_Quick_Books_Payroll_Item_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Quick_Books_Payroll_Item__Quick_Books_Payroll_Item_Type__quick_books_payroll_item_type_KEYquick_books_payroll_item_type_KEYQuick_Books_Payroll_Item

Schema diagram