Data Model Explorer
Our Data Model Explorer provides an Entity Relationship Diagram (ERD) of your Acumatica data, allowing you to see the relationships between your different tables.
Navigating
- Drag tables around the workspace, by clicking and dragging anywhere on a table
- Drag the entire workspace around by clicking and dragging the background
- Minimize/maximize your workspace to take up your entire browser screen
Relationships
Relationships are depicted by the arrows running between table properties. For a tidier view, you may select the Relationships Only checkbox, which will hide all the other columns which are not part of a relationship
Endpoints
- GL account
- GL history
- IN item cost
- IN item cost history
- IN register
- IN site
- IN site status
- IN tran
- Inventory item
- Inventory item cury settings
- Organization
- SO shipment line
- SO shipment
- Account
- Attribute definition
- Bill
- Contact
- Currency
- Customer
- Customer location
- Invoice
- Item class
- Purchase order
- Sales invoice
- Sales order
- Salesperson
- Stock item
- Vendor
- Bill detail
- Contact address
- Contact case
- Customer contact
- Customer salesperson
- Invoice detail
- Invoice discount detail
- Purchase order tax detail
- Purchase order detail
- Sales invoice detail
- Sales order bill to address
- Sales order totals
- Sales order ship to address
- Sales order detail
- Vendor contact