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 1: Introduction and Objectives

The objectives of Data Dictionary in Microsoft Dynamics AX 2012 are:

The objectives of data dictionary in Microsoft dynamics ax 2012 explains the following aspects.

  • Explains the MorphX development environment and the Application Object Tree.
  • Design tables using MorphX.
  • Describe the different data types within Microsoft Dynamics.
  • Create a new table.
  • Learn how to create and modify indexes using MorphX.
  • Describe relations on Microsoft Dynamics AX tables.
  • Learn how to create and modify Enumerated data types.
  • Learn how to create and modify views

This section of the SDK contains programming standards related to the following data dictionary items:

  • Best Practices: Tables
  • Best Practices for Views
  • Best Practices for Extended Data Types
  • Best Practices for Base Enums
  • Best Practices for Configuration and Security Keys
  • Best Practices for Table Collections
  • Best Practices for Perspectives

Introduction to Data Dictionary in Microsoft Dynamics AX 2012:

Introduction to Data Dictionary in Microsoft Dynamics AX 2012 introduces the tools and procedures used to create tables, data types, and relations that are required in Microsoft Dynamics AX.The Data Dictionary folder in the AOT contains the Tables folder.Tables are the main way to store data in Dynamics AX.

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.

Locus IT Project Management Office
What’s it?