BAASS Insights Technology Blog

Tips & Tricks: Database Schema - Application Object Models

Written by Bonnie Wittmeier | Mar 10, 2016 6:25:00 PM

The database schema published by Sage is referred to as the Application Object Model.  The AOM illustrates the structure and framework of the tables and views for a Sage database.  

This information can be helpful for importing and exporting functions, building integrations into Sage from other software, or doing data manipulation or repair. The AOM for the three current Sage versions is accessible by clicking on the attachments provided.

Extract or unzip the file and click on the Advantage.xml file.  (note that the AOM works best in Internet Explorer).  From this screen, select the module, and click into it.  From here you have the ability to look at views, tables, or objects.  For each, fields are identified along with the type of data required and (in some cases) lists of the values expected in that field.

Sage 300 2016 AOM

Sage 300 ERP 2014 AOM

Sage 300 ERP 2012 AOM