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

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

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

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

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