Views
Views are similar to tables in the way that data is represented; however, views are read-only.
Queries can be executed against a view as if it were a normal table.
CData Python Connector for QuickBooks Online Views
| Name | Description |
| BalanceSheetSummaryReport | Exposes the Balance Sheet summary report from QuickBooks Online, aggregating assets, liabilities, and equity to give a snapshot of company financial health over a selected time period. |
| CreditCardPayments | Displays a view of credit card payment transactions, summarizing payments made to credit card accounts for easier reconciliation and expense management. |
| CustomerBalanceDetail | Presents the Customer Balance Detail report from QuickBooks Online, showing outstanding invoices, payments, and credits per customer with running balances. |
| CustomerTypes | Displays a list of customer types or segments that are used to classify customers for reporting, marketing, or pricing strategies within QuickBooks Online. |
| Entitlements | Retrieves a list of product entitlements or subscriptions that are associated with the QuickBooks Online account, showing what features or modules are available. |
| GetDeletedAsView | Provides a view of records deleted from core entities such as Customers, Invoices, and Bill Payments, allowing administrators or auditors to track removed data for compliance and reconciliation purposes. |
| RecurringBillTransactions | Displays recurring bill templates that automate vendor billing, ensuring that repeat expenses are entered on a scheduled basis. |
| ReimburseCharges | Displays billable expenses marked to be reimbursed by customers, showing charges that will later be invoiced as pass-through costs. |
| TaxClassification | Displays tax classification data that is used to categorize goods or services for compliance with tax regulations. |
| TaxPayment | Shows sales tax payment records, summarizing payments made to tax agencies for easier tracking and reconciliation. |
| Thresholds | Retrieves threshold values set in QuickBooks Online, such as transaction or limit thresholds used for reporting or validation. |