The adapter models the Acumatica ERP API as relational tables. 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 tables and the metadata for the tables 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.

Tables

Shows default table definitions from Acumatica ERP. Your actual tables may differ depending on your customizations. These tables were recorded as of version 17.200.001, but later versions may include more tables and fields than displayed here. The Acumatica ERP Adapter reads table 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. You just need to set the Url connection property to the latest version to get the changes.

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.