Impaortance of RecId and DataAreaId on object's properties.

Finance and Operations/AX Developer Forum
1

Hi All,

Can any one tell me the impaortance of RecId and DataAreaId on object’s(tables, maps, views) properties ???

Thanks in advance.

2

Hi Vijay,

Recid- Record Id is to uniquely 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.

DataAreaId is to differentitate the records from the different companys…
Say if have two company accounts as DEMO and EXT
so when you are using company ‘DEMO’ it will show the data related to that company…
It can be said to be more specific to company accoutns and merges all the data into one.

Naresh Kolli

3

Hi Vijay,

Recid- Record Id is to uniquely 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.

DataAreaId is to differentitate the records from the different companys…
Say if have two company accounts as DEMO and EXT
so when you are using company ‘DEMO’ it will show the data related to that company…
It can be said to be more specific to company accounts…

Naresh Kolli

4

In the Table Properties set the → Create recidindex->Yes. Then only it will be appear in the Primary index & cluster index property drop down.By default it will be set to “NO”.