What is RecId in Microsoft Dynamics AX/365FO
Tables are very important component of Microsoft Dynamics ERP systems. In these tables, the data is stored, later on processed and information is fetched. If you open the table in Table Browser or in Microsoft SQL Server, you may have seen the RecId field in this. So, the question arises that what is RecId in Microsoft Dynamics 365 for Finance and Operations and Microsoft Dynamics AX 2012.
RecId stands for Record Identifier. It is often called RowId (row identifier). It is a unique and incremental value stored with each and every row of the table. In Microsoft Dynamics AX 2012 and Microsoft Dynamics 365 for Finance and Operations, RecId is used as unique identifiers and to create relations between tables.
Another important point is the difference between RecId and Id. In simple words, RecId is generated by the kernel whereas the Id is generated by the application itself.
RecId is used to find out the unique row in the table. Many requirements can be achieved using this. On my blog, there is an article in which I have described how to get the last inserted record from table using x++. I have used the RecId to get the last inserted record from table.
Blog: Click here
YouTube: Click here
GitHub: Click here
Every champion was once a contender that refused to give up. – Rocky Balboa