Table: dbo.Quick_Books_Payee_N_Vendor
This table will have an entry for every quickbooks payee of type vendor that is mapped to an acs vendor.
Columns
NameTypeConstraintsDescription
quick_books_payee_KEYint (4)NOT NULLThe key which links us to a Quick_Books_Payee table record.
vendor_KEYint (4)NOT NULLThe key which links us to an Vendor table record.
Primary key
NameColumnsDescription
PK_Quick_Books_Payee_N_Vendor$quick_books_payee_KEYquick_books_payee_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Payee_N_Vendor__Quick_Books_Payee__quick_books_payee_KEYquick_books_payee_KEYQuick_Books_Payee (quick_books_payee_KEY)
FK_Quick_Books_Payee_N_Vendor__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)

Schema diagram