Post#1: List of AX Tables

In order to help other AX specialists understand the tables in AX, Microsoft came up with a excel file that shows each table name and the below some of the attributes:

  • Table group (main, transaction, misc, group, etc.)
  • Table Type (Regular, tempdb, inMemory)
  • System Table (Yes,No)
  • Visible (Yes,No)
  • Shared
  • Release added to AX

These will help you navigate the abyss which is AX.

You can find the link below:

https://www.microsoft.com/en-us/download/confirmation.aspx?id=17093

Please do note however that in true Microsoft fashion they have not used shared as a normal yes and no but instead are displaying the property savedatapercompany value which is quite confusing.

E.g. HcmWorker which is the employee table is a shared table so its savedatapercompany will be no and no is what you will find in the Shared column of the excel.

SystemTables_eg

I inverted the same in my sheet since it made more logical sense. You may want to do the same.

Happy Axing 🙂

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s