Power BI Connector for QuickBooks

Build 24.0.9062

ビュー

ビューは、データを示すという点でテーブルに似ていますが、ビューは読み取り専用です。

クエリは、ビューに対して通常のテーブルと同様に実行することができます。

CData Power BI Connector for QuickBooks ビュー

Name Description
BalanceSheetDetail Balance Sheet Detail Report.
BalanceSheetStandard Balance Sheet Standard Report.
BalanceSheetSummary Balance Sheet Summary Report.
BillingRate Query QuickBooks Billing Rate. Requires QBXML Version 6.0 or higher.
BillLinkedTransactions Query QuickBooks Bill Linked Transactions.
CompanyInfo Query the company information from QuickBooks.
CreditMemoLinkedTransactions Query QuickBooks Credit Memo Linked Transactions.
CustomColumns Query QuickBooks Custom Columns.
DeletedEntities Query deleted Entities.
DeletedTransactions Query deleted Transactions.
EmployeeStateTaxesDetail Returns information of employee state taxes detail report.
EstimateLinkedTransactions Query QuickBooks Estimate Linked transactions.
Host Query the QuickBooks host process. The Host represents information about the QuickBooks process currently being executed.
InvoiceLinkedTransactions Query QuickBooks Invoice Linked Transactions.
ItemReceiptLinkedTransactions Query QuickBooks Item Receipt Linked Transactions.
ItemSites Create, update, delete, and query QuickBooks Item Sites. Item sites are only available in QuickBooks Enterprise 2010 and above, and only with the Advanced Inventory add-on. This table requires a minimum of QBXML version 10.0.
PayrollItemDetail Returns information of Payroll item detail report (lists the payroll transactions on which each payroll item appears).
PayrollReviewDetail Returns information of Payroll detail review report (provides detailed information about how QuickBooks calculates tax amounts on employee paychecks and in year-to-date transactions).
PayrollTransactionDetail Returns information of Payroll transaction detail report (shows the line-item detail that appears on each payroll transaction).
PayrollTransactionsByPayee Payroll transactions by payee report (lists payroll transactions, grouping them by payee).
Preferences Query information about many of the preferences the QuickBooks user has set in the company file.
ProfitAndLossDetail Profit & Loss Prev Year Comparison Report.
ProfitAndLossStandard Profit & Loss YTD Comparison Report.
PurchaseOrderLinkedTransactions Query QuickBooks Purchase Order Linked Transactions.
ReceivePaymentToDeposit Returns information about payments that have been received and are ready to deposit.
SalesOrderLinkedTransactions Query QuickBooks Sales Order Linked Transactions.
StatementChargeLinkedTransactions Query QuickBooks Statement Charge Linked Transactions.
Templates Query QuickBooks templates.
Transactions Query QuickBooks transactions. You may search the Transactions using a number of values including Type, Entity, Account, ReferenceNumber, Item, Class, Date, and TimeModified.
VendorCreditLinkedTransactions Query QuickBooks Vendor Credit Linked Transactions.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062