Tables Over View

In this post we will be exploring the basics of tables in Dynamics Ax 2012.

OVER VIEW:

•    Tables store business data. Each table in the AOT has a corresponding table in the underlying Microsoft SQL Server database.
•    In Microsoft Dynamics AX, tables have advanced features beyond what tables might have in the underlying database. The advanced features include the following:
•    Method members – A table can have methods, just as a class in X++ or C# can have methods.
•    Table inheritance – A table can extend, or be derived from another table. That same table can be the base table for several derived tables.
•    Tables are specified at AOT > Data Dictionary > Tables

•    In Microsoft Dynamics AX, tables are located in the Application Object Tree (AOT) under the Data Dictionary\Tables node. Each table contains the following primary elements:
•Fields
•Field Groups
•Indexes
•Relations
•Delete Actions
•Methods


      We will be discussing all these elements in detail in further posts, in this post we will be having brief look up on these elements.

Fields

The Fields node contains all the fields in the table. By specifying a field's data type, you define the type of data that can be stored in it. Microsoft Dynamics AX performs data validation to ensure that only valid data is entered into each field in the table.

Field Groups

Field groups are objects that group together fields that logically belong together. 

Indexes

An index is a table-specific database structure that speeds the retrieval of rows from the table. Indexes are used to improve the performance of data retrieval and sometimes to ensure the existence of unique records.

Relations

Relations define the relationship between two tables that contain related data.

Delete Actions

The Delete Action element is used to maintain database consistency when a record is deleted. 
Define delete actions to specify what should occur when data being deleted in the current table is 
related to data in another table. The delete action values are None, Cascade, Restricted, and 
Cascade + Restricted.  



Comments

Post a Comment

Popular posts from this blog

D365: SSRS Report Development/ Customization

Image
Hi guys, Today in this blog I will be demonstrating the procedure for the SSRS Reports development and customization in D365FO. Before proceeding with the Development or customization make sure that you have created a new model for your customization since we will be using extensions approach in our customization because An extension enables you to add functionality to existing model elements and source code. Coming back to the main objective of this blog which is to Develop SSRS reports in D365. One point to keep in mind is that there is no change on How you develop query based report and RDP based report in D365FO . The only change is you have to use extensions for standard report. If you are developing brand new report based on custom tables, there is no change. So in this Blog I will discuss How to customize an existing SSRS Report in D365 using Extensions approach step by step: Step#1:  The first step is to create a new model, Below are the steps to create a new model: Navigate to
Read more

D365: X++ code to add custom lookup on worker to show specific workers team workers only

/// <summary>             ///             /// </summary>             /// <param name = "_formReferenceControl"></param>             /// <returns></returns>             public Common lookupReference( FormReferenceControl _formReferenceControl)             {                 SysReferenceTableLookup      sysTableLookup = SysReferenceTableLookup ::newParameters( tablenum ( HcmWorker ), _formReferenceControl, true );                 Query                        query = new Query ();                 QueryBuildDataSource         queryBuildDataSource;                  QueryBuildRange              queryBuildRange;                 HcmPosition                  hcmPositionPareant;                 HcmPositionHierarchy         hcmPositionHierarchy;                 utcdatetime                  _validFrom = DateTimeUtil ::utcNow();                 utcdatetime                  _validTo    = _validFrom;                 H
Read more

Error message when you log on to a Microsoft Dynamics AX 4.0 client: "You are not a recognized user of Microsoft Dynamics AX"

When you log on to a Microsoft Dynamics AX 4.0 client after you restore a database, you receive the following error message: You are not a recognized user of Microsoft Dynamics AX. Contact your system administrator for help. This problem occurs if you restore a Microsoft Dynamics AX 4.0 environment in a different Active Directory directory service environment. This problem occurs when one or more of the following conditions are true: The security identifier (SID) is incorrect. The network alias is incorrect. The network domain is incorrect Resolution To resolve this problem, run the following script in SQL Query Analyzer after you restore the database. Note  You must obtain a SID in the current Microsoft Dynamics AX 4.0 environment. --Extract the user's SID from the current installation to update the restored database. select id, SID, Networkdomain, networkalias from userinfo where Id = 'admin'-- networkalias = '<UserAlias>' To extract t
Read more