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.

• Best Practices for Table Properties

• Best Practices: Table Fields

• Best Practices for Indexes

• Best Practices for Table Relations

• Best Practices for Table Methods

Announcements: New book: "Inside Microsoft Dynamics AX 2012 R3" now available. Get your copy at the MS Press Store.