Table: dbo.Quick_Books_Online_Integration_Client
A table to store tokens needed to access a client's QuickBooks Online account. The QuickBooks Online ACS identifiers stored in table Quick_Books_Online_Integration are used to get access tokens (Access Token, Access Token Secret) and an identifier (Company ID) for an individual client QBO accounts. These access tokens allow ACS to grab information from a client's QBO account. The Access Token and Access Token Secret expire periodically and need to be refreshed.
Columns
NameTypeConstraintsDescription
client_KEYint (4)NOT NULLThe primary key for this table. A client will have a row in this table if ACS/SBPR has been set up to access the client's QuickBooks Online account.
encrypted_company_idnvarchar (-1)NOT NULLThe Company ID, also known as the realmId, uniquely identifies the data for a company. In QuickBooks Online, the Company ID appears on the My Account page. This value is encrypted.
company_namenvarchar (200)NOT NULL
Primary key
NameColumnsDescription
PK_Quick_Books_Online_Integration_Client$client_KEYclient_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Quick_Books_Online_Integration_Client__Client__client_KEYclient_KEYClient (client_KEY)

Schema diagram