Rec id generation in AX


As you all know that Dynamics Ax uses recid(Record Id)to uniquelly identify a record in the database. 

By default system uses Recid as primary index,so if query optimizer didn't find any index to use then it will use RecId.

Dyamics Ax uses SystemSequence class(AOT->SystemDocumentation->Classes) to generate recId for table.
Using SystemSequence class you can reserve RECID's for your table.

Ax Kernel uses SystemSequences Table to generate the Recid for table as shown below
Goto AOT->SystemDocumentation->Tables->SystemSequences
And sometime many of us tries to generate rec id in SQL, even this is possible just by a sample query described here:
http://sumitsaxfactor.wordpress.com/2011/04/01/handling-recids-in-sql-server/

No comments

Powered by Blogger.