Schema Information of Quickbooks v2
This topic provides a structured reference to assist you in working with Daton's Quickbooks v2 connector and the associated fields and tables.
Schema Information of Quickbooks v2
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_Summary
- Account_List_Detail
- BalanceSheet
- GeneralLedger
- JournalReport
- ProfitAndLoss
- ProfitAndLossDetail
- CustomerBalance
- DepartmentSales
- TransactionList
- TrialBalance
- VendorBalance
- VendorExpenses
- CustomerBalanceDetail
- InventoryValuationSummary
- CashFlow
- CustomerSales
- AgedReceivableDetail
- AgedReceivables
- ClassSales
- 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.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
AP_Aging_Summary
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.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
Account_List_Detail
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.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
BalanceSheet
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.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
GeneralLedger
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.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
JournalReport
This API provides access to journal entries, which are chronological records of financial transactions within your company. For more information, see QuickBooks Journal Report.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
ProfitAndLoss
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.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
ProfitAndLossDetail
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.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
CustomerBalance
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
DepartmentSales
The Department Sales API allows you to view sales data categorized by different departments within your organization. For more information, see QuickBooks Department Sales.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
TransactionList
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.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
TrialBalance
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.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
VendorBalance
Similar to the Customer Balance API, this one shows the balances owed to your vendors. For more information, see QuickBooks Vendor Balance.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
VendorExpenses
This API provides a breakdown of expenses related to your vendors, helping you analyze spending patterns. For more information, see QuickBooks Vendor Expenses.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
CustomerBalanceDetail
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
InventoryValuationSummary
The Inventory Valuation Summary API provides insights into the value of your inventory items. For more information, see QuickBooks Inventory Valuation Summary.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
CashFlow
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.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
CustomerSales
The Customer Sales API presents a breakdown of your sales data by individual customers. For more information, see QuickBooks customer Sales.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
AgedReceivableDetail
This API offers a detailed view of aged accounts receivable, showing overdue payments from customers. For more information, see QuickBooks Aged Receivable Detail.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
AgedReceivables
Similar to the above, this API provides a summarized overview of aged accounts receivable. For more information, see QuickBooks Aged Receivables.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
ClassSales
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.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
ItemSales
This API provides insights into sales data categorized by different items or products. For more information, see QuickBooks Item Sales.
Note: This table in Daton doesn't support any primary key.
Fields
Field Name |
Data Type |
|---|---|
Header |
RECORD |
Columns |
RECORD |
Rows |
RECORD |
