Introduction to Microsoft Dynamics AX 2012 R3 Development-1

Microsoft Dynamics AX 2012 R3 Development-1

Locus IT ServicesMicrosoft Dynamics AX 2012 R3 Development-1

Lesson 3 : Tables

Microsoft Dynamics AX 2012 Tables Overview

The Microsoft Dynamics AX2012 SQL database created during installation contains the complete repository. Dynamics AX 2012 Tables Overview are at the core of the Microsoft Dynamics

AX application and enable storage of a company’s information and transactions.Storing data about company transactions, inventory, general ledger, journals and more, form the base of the Microsoft Dynamics AX2012 application. These are referred to as base tables or application tables. Some frequently used tables include:

Table names and Application Details in Microsoft Dynamics AX 2012:


Application Data Detail:
CustTable The table for basic customer information.
VendTable The table for basic vendor information.
LedgerTable The table for the general ledger that contains the chart of accounts information.
InventTable The table for the general inventory catalog.
PurchTable The table for purchase order creation information.

AX tables are similar to SQL Server tables in that the data is stored in columns and rows. In fact, when saving changes to an AX table, AX will synchronize these changes with the SQL Server database and in the end create a SQL Server table.

Most of these subfolders look similar to SQL Server objects. We have the “fields” folder which represents the columns in the table and also objects like indexes, full-text indexes, relations and delete actions.  Delete actions can be thought of as SQL delete triggers.

There are other folders which provide additional functionality to AX tables and are not available in standard SQL Server tables. Objects like: Field groups and methods.

Field groups allows the user to create a subset of fields in order to facilitate the retrieval of specific data columns.

Methods provide the capability of adding X++ code to tables. For example, you can add code to recreate SQL Server’s triggers functionality for update and insert methods or to provide more complex routines when deleting data.  The possibilities that methods provide to the functionality of a standard table are limitless.  You can implement complex business rules, validations, lookups, etc.

An AX table is treated as an object and new static methods can be created so that search functions can be implemented. A common example is the find method that is implemented in most of the standard AX tables in the system.  You can also extend the functionality of a standard table method by using inheritance which is a concept used by object oriented programming.

Locus IT Project Management Office
What’s it?