Stored Procedures
Stored procedures are function-like interfaces that extend the functionality of the provider beyond simple SELECT/INSERT/UPDATE/DELETE operations with Sage Intacct.
Stored procedures accept a list of parameters, perform their intended function, and then return any relevant response data from Sage Intacct, along with an indication of whether the procedure succeeded or failed.
CData ADO.NET Provider for Sage Intacct Stored Procedures
| Name | Description |
| 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. |
| 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. |
| SetRelationship | Sets relationship columns in Intacct. |
| UpdateAttachment | Updates the attachment Table. |