The adapter models the Acumatica ERP OData API as relational views. Only read only tables (views) are supported on OData schema.
Any changes to the remote data are immediately reflected in your queries; the table definitions are dynamically retrieved. When you connect, the adapter connects to Acumatica ERP and gets the list of views and the metadata for the views by calling the appropriate Web services.

API limitations and requirements are documented in this section; you can use the SupportEnhancedSQL feature, set by default, to circumvent most of these limitations.

Views

Shows all the Generic Inquires exposed via OData from Acumatica ERP. The Acumatica ERP Adapter reads view and column metadata dynamically, so it will include both your customizations and any new features that are added to standard Acumatica ERP entities in the future.

Note: Generic Inquiries are not exposed via OData by default, and you may need to expose them. To do this, on the Acumatica ERP Generic Inquiries Screen check the "Expose via OData" checkbox.

Stored Procedures

Stored Procedures are function-like interfaces to Acumatica ERP. They can be used to peform extra tasks that do not fit into the standard operation of directly interacting with a table.