Understand Tables in Axapta 2012

It is basically storing Company data like Transactions, Journals, Inventory and General Ledger etc… as per the Axapta application

System table
 

Identified by SYS prefix that starts the name of the table

 

Fields

Using MorphX to access the fields node to create of modify the physical columns in the database table, any changes made in table node will be reflected in the database

 

Field Groups

It is logical groupings of physical database fields, field group can be used in forms and reports using field group to cluster fields into logical group, once modification made to the fields group the entire application element related to that group will be automatically updated. Apply when many fields logically belong together and are shown together on forms, all fields on a table should belong to a group

 

Indexes

                Any index define in AX table are physical indexes that exist on the tables in the database

 

Full text indexes

X++ select statement cannot use a full text index; these are queries that search for words embedded in the middle of the string fields.

Relations

Relationship can be created between tables, Microsoft Dynamics Axapta uses a relational database

Delete Actions

How data will be handled when deletion event occurs in a parent table

Type of deletion action

1. None: Particular row in this table deleted but nothing occurs in the specified table.

2. Cascade: Row in this table deleted and all relevant data in the specific table is also deleted

3. Restricted: row from this table only deleted if no relevant data found in the specific table, useful when parent data should not be deleted

4. Cascade + Restricted: Same as Restricted.

Methods

If you would like to perform functions to the table, Like Data Lookup or any manipulation in data based on events