# Schema Information

## 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>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/saas-integrations/quickbooks-v2/schema-information.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.