ストアドプロシージャ

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

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

CData Excel Add-In for Reckon Accounts Hosted ストアドプロシージャ


Name	Description
CreateReportSchema	Generates a report schema file.
CreateSimpleReportSchema	Generates a simple report schema file.
GetOAuthAccessToken	Gets the OAuth access token from Reckon Accounts Hosted.
GetOAuthAuthorizationURL	Gets the Reckon Accounts Hosted authorization URL. Access the URL returned in the output in an Internet browser. This requests the access token that can be used as part of the connection string to Reckon Accounts Hosted.
RefreshOAuthAccessToken	Refreshes the OAuth access token used for authentication with Reckon Accounts Hosted.
ReportAging	Generates Reckon aging reports.
ReportBudgetSummary	Generates budget reports.
ReportCustomDetail	Generates a custom transaction detail report.
ReportCustomSummary	Generates a custom summary report.
ReportGeneralDetail	Generates a general detail report.
ReportGeneralSummary	Generate a general summary report.
ReportJob	Generates job reports.
ReportPayrollDetail	Generates payroll reports.
ReportPayrollSummary	Generates payroll summary reports.
ReportTime	Generates summary and detail reports related by time.
SearchEntities	Search entities in Reckon.
SendQBXML	Sends the provided QBXML directly to Reckon.
VoidTransaction	Voids a given transaction in Reckon.