ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Sage Intacct の単純なSELECT/INSERT/UPDATE/DELETE 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにSage Intacct から関連するレスポンスデータを返します。
CData JDBC Driver for Sage Intacct ストアドプロシージャ
| Name | Description |
| AccountBalanceReport | Create an Account Balance report. |
| ApproveVendor | Approves vendors by recordno. |
| CreateAttachment | Create an attachment. |
| CreateCustomReportSchema | Creates a schema file for the specified custom report. |
| CreateSchema | Creates a schema file for the specified table or view. |
| CreateTrialBalancesReport | Creates a schema file for the specified custom report. |
| DeclineVendor | Declines vendors by recordno. |
| GetCustomFields | Retrieves custom fields and values from a table / record. |
| GetDimensionRestrictedData | Lists the IDs of related dimensions that are the targets of to-many relationships from a single source dimension. |
| GetKeys | Retrieves a list of keys in an object. |
| GetRelationshipColumns | Sets relationship columns in Intacct. |
| GetUserDateTimePreferences | Obtains Date and Time preferences for a specified user. |
| GetVendorApprovalHistory | Generated a report on the vendor's approval history. |
| ReverseInvoice | Reverses invoice by key and date. |
| SetRelationship | Sets relationship columns in Intacct. |
| UpdateAttachment | Updates the attachment Table. |
| VoidAPPayment | Stored procedure will void appayment records. |