Table: dbo.Quick_Books_Retrieved_Vendor
this table contains information on vendors retrieved from quickbooks for a given ACS client, where the vendors have not yet been imported into the permanent ACS tables for that client. For quickbooks online, the process of importing data has two steps. First, we retrieve the data from a quickbooks online company, and then we import the retrieved data into the permanent ACS tables. We need a means to store off the information after that first step has completed, but before that second step. This table provides the means for us to store information on vendors that have been retrieved from a quickbooks online company, but not yet imported into the permanent tables in ACS for the client. Once the import completes for one client, the records in this table for that one client will be removed.
Columns
NameTypeConstraintsDescription
quick_books_retrieved_vendor_KEYint (4)NOT NULLthe primary Key for this table.
client_KEYint (4)NOT NULLthe client key, to allow us to group retrieved vendors by ACS client.
is_activebit (1)NOT NULLTrue if the vendor is active, and false if the vendor is not active, in quickbooks.
is_1099_vendorbit (1)NOT NULLTrue if the vendor is a 1099 vendor, and false if the vendor is not a 1099 vendor, in quickbooks.
list_idnvarchar (120)NOT NULLthe id of the vendor. this is supposed to be a unique value, at least for the vendors of one quickbooks company.
tax_idnvarchar (60)NOT NULLthe tax identifier of the vendor.
company_namenvarchar (100)NOT NULLthe name of the company associated with this vendor. This could be a person or organization.
display_namenvarchar (200)NOT NULLthe name of the vendor, as displayed. This could be a person or organization.
first_namenvarchar (50)NOT NULLthe first name of the vendor.
middle_namenvarchar (50)NOT NULLThe middle name of the vendor.
last_namenvarchar (50)NOT NULLThe last name of the vendor.
address_line_onenvarchar (1000)NOT NULLthe first line of the vendor address.
address_line_twonvarchar (1000)NOT NULLthe second line of the vendor address.
address_citynvarchar (510)NOT NULLthe city of the vendor address.
address_statenvarchar (510)NOT NULLthe state of the vendor address.
address_postal_codenvarchar (62)NOT NULLthe zip code or other postal code of the vendor address.
primary_phonenvarchar (42)NOT NULLthe primary phone number of the vendor
alternate_phonenvarchar (42)NOT NULLan alternate phone number for the vendor.
mobile_phonenvarchar (42)NOT NULLa mobile phone number for the vendor.
fax_phonenvarchar (42)NOT NULLa fax phone number for the vendor.
primary_emailnvarchar (200)NOT NULLthe primary email address for the vendor.
Primary key
NameColumnsDescription
PK_Quick_Books_Retrieved_Vendorquick_books_retrieved_vendor_KEY
Unique constraints
NameColumnsDescription
UK_Quick_Books_Retrieved_Vendor$client_KEY$list_idclient_KEY, list_id
UK_Quick_Books_Retrieved_Vendor$client_KEY$display_nameclient_KEY, display_name
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Retrieved_Vendor__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram