ビュー

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

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

CData Excel Add-In 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.