When we create table in Dynamics AX, we create fields in that table. Those fields are then created as columns in the SQL database. These are called Custom Fields.
The AX framework manages some fields by itself, these are called System Fields. Some of the system fields are automatically generated (with a table property value set to Always in below table) and some fields are created on the choice of the developer.
To create the desired system field on your table you need to set table's property according to the following table:
The AX framework manages some fields by itself, these are called System Fields. Some of the system fields are automatically generated (with a table property value set to Always in below table) and some fields are created on the choice of the developer.
To create the desired system field on your table you need to set table's property according to the following table:
System field
|
Table property
|
|---|---|
RecId
|
Always
|
RecVersion
|
Always
|
DataAreaId
|
SaveDataPerCompany = Yes
|
CreatedBy
|
CreatedBy = Yes
|
CreatedDate
|
CreatedDate = Yes
|
CreatedTime
|
CreatedTime = Yes
|
CreateTransactionId
|
CreateTransactionId = Yes
|
ModifiedBy
|
ModifiedBy = Yes
|
ModifiedDate
|
ModifiedDate = Yes
|
ModifiedTime
|
ModifiedTime = Yes
|
ModifiedTransactionId
|
ModifiedTransactionId = Yes
|
Hope it helps !!!
No comments:
Post a Comment