ストアドプロシージャ

ストアドプロシージャはファンクションライクなインターフェースで、QuickBooks Online の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品の機能を拡張します。

ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、該当する場合は、プロシージャが成功したか失敗したかを示すとともにQuickBooks Online から関連するレスポンスデータを返します。

CData JDBC Driver for QuickBooks Online ストアドプロシージャ


Name	Description
CreateAccountListReport	Generates an Account list report schema file.
CreateAPAgingDetailReport	Generates an A/P Aging Detail report schema file.
CreateAPAgingSummaryReport	Generates an A/P Aging Summary report schema file.
CreateARAgingDetailReport	Generates an A/R Aging Detail report schema file.
CreateARAgingSummaryReport	Generates an A/R Aging Summary report schema file.
CreateBalanceSheetSummaryReport	Generates a Balance Sheet Summary report schema file.
CreateCustomerBalanceDetailReport	Generates a Customer Balance detail report schema file.
CreateCustomerBalanceReport	Generates a Customer Balance report schema file.
CreateCustomerIncomeReport	Generates a Customer Income report schema file.
CreateCustomerSalesReport	Generates a Sales by Customer Summary report schema file.
CreateExpensesByVendorReport	Generates an Expenses by Vendor report schema file.
CreateGeneralLedgerDetailReport	Generates a General Ledger Detail report schema file.
CreateInventoryValuationSummaryReport	Generates an Inventory Valuation Summary report schema file.
CreateJournalReport	Generates a Journal report schema file.
CreateProfitAndLossDetailReport	Generates a Profit and Loss Detail report schema file.
CreateProfitAndLossSummaryReport	Generates a Profit and Loss Summary report schema file.
CreateSalesByClassReport	Generates a Sales by Class report schema file.
CreateSalesByDepartmentReport	Generates a Sales by Department report schema file.
CreateSalesByProductReport	Generates a Sales by Product report schema file.
CreateStatementOfCashFlowReport	Generates a Statement of Cash Flow report schema file.
CreateTransactionListReport	Generates a Transaction List report schema file.
CreateTransactionListWithSplitsReport	Generates an Account list report schema file.
CreateTrialBalanceReport	Generates a Trial Balance report schema file.
CreateVendorBalanceDetailReport	Generates a Vendor Balance Detail report schema file.
CreateVendorBalanceReport	Generates a Vendor Balance report schema file.
DisconnectOAuthAccessToken	Disconnects the OAuth access token used for authentication with various QuickBooks services.
DownloadAttachment	Download Attachment
DownloadPDF	Download an Invoice, SalesReceipt or Estimate as a PDF
GetOAuthAccessToken	Gets the OAuth access token and OAuth secret key from Intuit.
GetOAuthAuthorizationURL	Gets the URL, AuthToken, and AuthKey from Intuit. Access the URL returned in the output in an Internet browser. This request returns a verifier token that you will need to use as input along with the AuthToken and AuthKey for GetOAuthAccessToken.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with various QuickBooks services.
SendInvoice	Send linked payment Invoices via Email
UploadAttachment	Upload Attachment
VoidInvoice	To void an existing invoice object