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
Name | Type | Constraints | Description
client_KEY | int (4) | NOT NULL | The 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_id | nvarchar (-1) | NOT NULL | The 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_name | nvarchar (200) | NOT NULL |

Primary key
Name | Columns | Description
PK_Quick_Books_Online_Integration_Client$client_KEY | client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Quick_Books_Online_Integration_Client__Client__client_KEY | client_KEY | Client (client_KEY) |