FireDAC Components for Sage 300

Build 21.0.7930

Stored Procedures

Stored procedures are available to complement the data available from the Data Model. It may be necessary to update data available from a view using a stored procedure because the data does not provide for direct, table-like, two-way updates. In these situations, the retrieval of the data is done using the appropriate view or table, while the update is done by calling a stored procedure. Stored procedures take a list of parameters and return back a dataset that contains the collection of tuples that constitute the response.

CData FireDAC Components for Sage 300 Stored Procedures

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.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930