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
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
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
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
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
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
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
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
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
Header
RECORD
Columns
RECORD
Rows
RECORD
CustomerBalance
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.
Note: This table in Daton doesn't support any primary key.
Fields
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
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
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
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
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
Header
RECORD
Columns
RECORD
Rows
RECORD
CustomerBalanceDetail
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.
Note: This table in Daton doesn't support any primary key.
Fields
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
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
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
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
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
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
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
Header
RECORD
Columns
RECORD
Rows
RECORD
Last updated