ストアドプロシージャ
ストアドプロシージャはファンクションライクなインターフェースで、Sage 300 の単純なSELECT 処理にとどまらず本製品 の機能を拡張します。
ストアドプロシージャは、パラメータのリストを受け取り、目的の機能を実行し、プロシージャが成功したか失敗したかを示すとともにSage 300 から関連するレスポンスデータを返します。
CData Excel Add-In for Sage 300 ストアドプロシージャ
| Name | Description |
| APCreateGLBatch | Usage information for the operation APCreateGLBatch.rsb. |
| APCreateRecurringPayableBatch | Usage information for the operation APCreateRecurringPayableBatch.rsb. |
| APCreateRetainageDocumentBatch | Usage information for the operation APCreateRetainageDocumentBatch.rsb. |
| APDeleteInactiveRecords | Usage information for the operation APDeleteInactiveRecords.rsb. |
| APPostInvoices | Usage information for the operation APPostInvoices.rsb. |
| APPostPaymentsAndAdjustments | Usage information for the operation APPostPaymentsAndAdjustments.rsb. |
| ARCreateGLBatch | Usage information for the operation ARCreateGLBatch.rsb. |
| ARCreateRecurringCharge | Usage information for the operation ARCreateRecurringCharge.rsb. |
| ARCreateRetainageDocumentBatch | Usage information for the operation ARCreateRetainageDocumentBatch.rsb. |
| ARPostInvoices | Usage information for the operation ARPostInvoices.rsb. |
| ARPostReceiptsAndAdjustments | Usage information for the operation ARPostReceiptsAndAdjustments.rsb. |
| ARPostRefunds | Usage information for the operation ARPostRefunds.rsb. |
| CreateSchema | Creates a schema file for the specified table or view. |
| GLPostJournal | Usage information for the operation GLPostJournal.rsb. |
| ICCreateGLBatch | Usage information for the operation ICCreateGLBatch.rsb. |
| ICDayEndProcessing | Usage information for the operation ICDayEndProcessing.rsb. |
| POCreateBatch | Usage information for the operation POCreateBatch.rsb. |
| PODayEndProcessing | Usage information for the operation PODayEndProcessing.rsb. |