JDBC Driver for QuickBooks Online

Build 20.0.7587

テーブル

本製品 はQuickBooks Online のデータを、標準のSQL ステートメントを使用してクエリできるテーブルのリストにモデル化します。

一般的には、QuickBooks Online テーブルのクエリは、リレーショナルデータベースのテーブルのクエリと同じです。時には特別なケースもあります。例えば、テーブルの特定のカラムデータを取得するために特定のカラムをWHERE 句に含める必要がある場合などです。これは通常、特定のカラムを取得するために行ごとに個別のリクエストを行う必要がある場合に必要です。これらの特別な状況は、以下にリンクされているテーブルページの上部に明確に文書化されています。

CData JDBC Driver for QuickBooks Online テーブル

Name Description
Accounts Create, update, delete, and query QuickBooks Accounts.
AttachableRefs Attachables
Attachables Attachables
BillLineItems Create, update, delete, and query QuickBooks Bill Line Items.
BillLinkedTransactions Create, update, delete, and query QuickBooks Invoice Line Items.
BillPaymentLineItems Create, update, delete, and query QuickBooks Bill Payment Line Items.
BillPayments Create, update, delete, and query QuickBooks Bill Payments.
Bills Create, update, delete, and query QuickBooks Bills.
BudgetDetails Query QuickBooks BudgetDetails.
Budgets Query QuickBooks Budgets.
Class Create, update, delete, and query QuickBooks Classes.
CompanyCurrency Create, update, delete, and query QuickBooks CompanyCurrency. Applicable only for those companies that enable multicurrency, a companycurrency object defines a currency that is active in the QuickBooks Online company. One or more companycurrency objects are active based on the company's multicurrency business requirements and correspond to the list displayed by the Currency Center in the QuickBooks Online UI.
CompanyInfo Retrieve information about the QuickBooks company.
CreditMemoLineItems Create, update, delete, and query QuickBooks Credit Memo Line Items.
CreditMemos Create, update, delete, and query QuickBooks Credit Memos.
Customers Create, update, delete, and query QuickBooks Customers.
Departments Create, update, delete, and query QuickBooks Departments.
DepositLineItems Create, update, delete, and query QuickBooks Deposit Line Items.
Deposits Create, update, delete, and query QuickBooks Deposits.
Employees Create, update, delete, and query QuickBooks Employees.
EstimateLineItems Create, update, delete, and query QuickBooks Estimate Line Items.
EstimateLinkedTransactions Create, update, delete, and query QuickBooks Estimate Line Items.
Estimates Create, update, delete, and query QuickBooks Estimates.
ExchangeRates Retrieves QuickBooks exchange rates.
InvoiceLineItems Create, update, delete, and query QuickBooks Invoice Line Items.
InvoiceLinkedTransactions Create, update, delete, and query QuickBooks Invoice Line Items.
Invoices Create, update, delete, and query QuickBooks Invoices.
Items Create, update, delete, and query QuickBooks Items.
JournalCode Create, update, delete, and query QuickBooks Journal Codes.
JournalEntries Create, update, delete, and query QuickBooks Journal Entries.
JournalEntryLineItems Create, update, delete, and query QuickBooks Journal Entry Line Items.
PaymentLineItems Create, update, delete, and query QuickBooks Payment Line Items.
PaymentMethods Create, update, delete, and query QuickBooks Payment Methods.
Payments Create, update, delete, and query QuickBooks Payments.
Preferences Query QuickBooks Preferences. The Preferences table contains settings for company-wide preferences, which affect all users.
PurchaseLineItems Create, update, delete, and query QuickBooks Purchase Line Items.
PurchaseOrderLineItems Create, update, delete, and query QuickBooks Purchase Order Line Items.
PurchaseOrderLinkedTransactions Create, update, delete, and query QuickBooks Invoice Line Items.
PurchaseOrders Create, update, delete, and query QuickBooks Purchase Orders.
Purchases Create, update, delete, and query QuickBooks Purchases.
RefundReceiptLineItems Create, update, delete, and query QuickBooks RefundReceiptLineItems.
RefundReceipts Create, update, delete, and query QuickBooks RefundReceipts.
SalesReceiptLineItems Create, update, delete, and query QuickBooks Sales Receipt Line Items.
SalesReceipts Create, update, delete, and query QuickBooks Sales Receipts.
TaxAgency Create and Query QuickBooks Tax Agency.
Terms Create, update, delete, and query QuickBooks Terms.
TimeActivities Create, update, delete, and query QuickBooks Time Activities.
Transfers Create, update, delete, and query QuickBooks Transfers
VendorCreditLineItems Create, update, delete, and query QuickBooks Vendor Credit Line Items.
VendorCredits Create, update, delete, and query QuickBooks Vendor Credits.
Vendors Create, update, delete, and query QuickBooks Vendors.

Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 20.0.7587