> For the complete documentation index, see [llms.txt](https://daton-sarasanalytics.gitbook.io/daton/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/saas-integrations/quickbooks-v2/schema-information.md).

# Schema Information

This topic provides a structured reference to assist you in working with Daton's Quickbooks v2 connector and the associated fields and tables.

## Tables/APIs 

The following is the list of tables or APIs associated with the Quickbooks v2 connector:

* [AP\_Aging\_Detail](#ap_aging_detail) 
* [AP\_Aging\_Summary](#ap_aging_summary) 
* [Account\_List\_Detail](#account_list_detail) 
* [BalanceSheet](#balancesheet) 
* [GeneralLedger](#generalledger) 
* [JournalReport](#journalreport) 
* [ProfitAndLoss](#profitandloss) 
* [ProfitAndLossDetail](#profitandlossdetail) 
* [CustomerBalance](#customerbalance) 
* [DepartmentSales](#departmentsales) 
* [TransactionList](#transactionlist) 
* [TrialBalance](#trialbalance) 
* [VendorBalance](#vendorbalance) 
* [VendorExpenses](#vendorexpenses) 
* [CustomerBalanceDetail](#customerbalancedetail) 
* [InventoryValuationSummary](#inventoryvaluationsummary) 
* [CashFlow](#cashflow) 
* [CustomerSales](#customersales) 
* [AgedReceivableDetail](#agedreceivabledetail) 
* [AgedReceivables](#agedreceivables) 
* [ClassSales](#classsales) 
* [ItemSales](#itemsales)

#### AP\_Aging\_Detail 

This API provides a detailed view of the accounts payable aging, showing the outstanding payments to suppliers and vendors. For more information, see [QuickBooks AP Aging Detail.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/apagingdetail)

Note: This table in Daton doesn't support any primary key. 

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### AP\_Aging\_Summary&#x20;

This API offers a summarized overview of the accounts payable aging, providing a snapshot of how much is owed to suppliers in different time periods. For more information, see [QuickBooks AP Aging Summary.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/aragingsummary)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### Account\_List\_Detail&#x20;

The Account List Detail API helps retrieve detailed information about your accounts, including balances and transaction history. For more information, see [QuickBooks Account List Details.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/accountlistdetail)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### BalanceSheet&#x20;

This API generates a balance sheet report, which shows your company's financial position by listing assets, liabilities, and equity. For more information, see [QuickBooks Balance Sheet.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/balancesheet)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### GeneralLedger&#x20;

The General Ledger API offers a detailed record of all financial transactions in your accounts, providing a comprehensive view of how money flows through your business. For more information, see [QuickBooks General Ledger.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/generalledger)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### JournalReport&#x20;

This API provides access to journal entries, which are chronological records of financial transactions within your company.  For more information, see [QuickBooks Journal Report.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/journalreport)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### ProfitAndLoss&#x20;

The Profit and Loss API generates an income statement, summarizing your revenue, expenses, and net income over a specific period. For more information, see [QuickBooks Profit and Loss.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/profitandloss)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### ProfitAndLossDetail&#x20;

This API provides a more detailed breakdown of your company's income and expenses, offering insights into different sources of revenue and costs. For more information, see [QuickBooks Profit and Loss Detail.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/profitandlossdetail)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### CustomerBalance&#x20;

This API retrieves the balances owed by your customers, helping you track outstanding payments and manage accounts receivable. For more information, see [QuickBooks Customer Balance.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/customerbalance)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### DepartmentSales&#x20;

The Department Sales API allows you to view sales data categorized by different departments within your organization. For more information, see [QuickBooks Department Sales.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/salesbydepartment)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### TransactionList&#x20;

This API provides a list of transactions, offering insights into financial activities such as purchases, sales, and expenses. For more information, see [QuickBooks Transaction List.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/transactionlist)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### TrialBalance&#x20;

The Trial Balance API generates a trial balance report, which lists all your accounts and their balances to ensure they are in balance. For more information, see [QuickBooks Trial Balance.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/trialbalance)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### VendorBalance&#x20;

Similar to the Customer Balance API, this one shows the balances owed to your vendors. For more information, see [QuickBooks Vendor Balance.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/vendorbalance)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### VendorExpenses&#x20;

This API provides a breakdown of expenses related to your vendors, helping you analyze spending patterns. For more information, see [QuickBooks Vendor Expenses.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/vendorexpenses)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### CustomerBalanceDetail&#x20;

This API offers a detailed view of customer balances, showcasing individual transactions that contribute to those balances. For more information, see [QuickBooks Customer Balance Detail.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/customerbalancedetail)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### InventoryValuationSummary&#x20;

The Inventory Valuation Summary API provides insights into the value of your inventory items. For more information, see [QuickBooks Inventory Valuation Summary.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/inventoryvaluationsummary)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### CashFlow&#x20;

This API generates a cash flow statement, showing how cash is moving in and out of your business. For more information, see [QuickBooks Cash Flow.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/cashflow)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### CustomerSales&#x20;

The Customer Sales API presents a breakdown of your sales data by individual customers. For more information, see [QuickBooks customer Sales.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/salesbycustomer)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### AgedReceivableDetail&#x20;

This API offers a detailed view of aged accounts receivable, showing overdue payments from customers. For more information, see [QuickBooks Aged Receivable Detail.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/account)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### AgedReceivables&#x20;

Similar to the above, this API provides a summarized overview of aged accounts receivable. For more information, see [QuickBooks Aged Receivables.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/account)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### ClassSales&#x20;

The Class Sales API allows you to view sales data categorized by different classes or categories within your business. For more information, see [QuickBooks Class Sales.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/all-entities/salesbyclasssummary)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>

#### ItemSales

This API provides insights into sales data categorized by different items or products. For more information, see [QuickBooks Item Sales.](https://developer.intuit.com/app/developer/qbo/docs/api/accounting/most-commonly-used/item#item)

Note: This table in Daton doesn't support any primary key.&#x20;

**Fields**

<table><thead><tr><th width="64">Field Name</th><th width="64">Data Type</th></tr></thead><tbody><tr><td>Header</td><td>RECORD</td></tr><tr><td>Columns</td><td>RECORD</td></tr><tr><td>Rows</td><td>RECORD</td></tr></tbody></table>