Tips & Tricks: Database Schema - Application Object Models

    

abstract building

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

Bonnie Wittmeier

About The Author

Bonnie Wittmeier

Bonnie is a senior tech support consultant at BAASS and has over 30 years of experience with Sage300 – firstly as an accounting professional and end-user and secondly as a support technician. Her visibility into both sides of the fence gives her a unique understanding of the issues facing our customers.