Best Practices: Tables
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
This section of the SDK describes the best practices for tables.
Best Practice Checks
The following table lists the best practices error messages and how to fix the errors.
Message |
Message type |
How to fix the error or warning |
|---|---|---|
Table %1 with SysDeletedObjects configuration key (%2) has no DEL_prefix. |
Error |
The object is linked to a SysDeletedObjects configuration key but is not marked as DEL_. Mark the object as DEL_. |
Table %1 with DEL_prefix has configuration %2 instead of SysDeletedObjects. |
Error |
The object is marked as DEL_ but it is not linked to a SysDeletedObjects configuration key. Unmark the object as DEL_ or link to the SysDeletedObjects configuration key. |
Index %1 with SysDeletedObjects configuration key (%2) has no DEL_prefix. |
Error |
The object is linked to a SysDeletedObjects configuration key but is not marked as DEL_. Mark the object as DEL_. |
Field %1 with DEL_ prefix has configuration %2 instead of SysDeletedObjects. |
Error |
The object is marked as DEL_ but it is not linked to a SysDeletedObjects configuration key. Link to the SysDeletedObjects configuration key. |
Field %1 with SysDeletedObjects configuration key (%2) has no DEL_ prefix. |
Error |
The object is linked to a SysDeletedObjects configuration key but is not marked as DEL_. Mark the object as DEL_. |
RecID field cannot be part of the NaturalKey index. |
Error |
A RecID field was set as the replacement key. Best practice rule that supports relational application design. This best practice check requires an exclusive RecID in the inheritance hierarchy. When you create a new field in a table, the best practice logic iterates through the inheritance hierarchy to ensure the RecID and ReplacementKey indexes are exclusive. |
Table is using CreatedDateTime or ModifiedDateTime, RecId index needs to be created. |
Error |
When a table has a CreatedDateTime or ModifiedDateTime field, it must have a RecID index. |
In This Section
Additional best practice errors relating to tables are described in the following topics.
Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.