CHAPTER 1: ARCHITECTURE
CHAPTER 2 : DATA DICTIONARY
CHAPTER 3 : USER INTERFACES
CHAPTER 4 : SECURITY
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.