Dynamics AX 2012 - Table Keys

Terminology for keys
Important concepts.

Term
Description
foreign key
In Microsoft Dynamics AX, an AOT node under MyTable > Relations represents a foreign key. 
natural key
A key whose value has meaning to people. Most replacement keys are natural keys.
surrogate key
A key whose value has no meaning to people. A large number generated by the system, such as RecId, could be a surrogate key.
unique key
A broad term that applies to primary keys and to alternate keys. It does not apply to foreign keys. This term emphasizes that all values for a given key must be unique within one table. All fields in a unique key must be not-nullable.

Comments

Popular posts from this blog

Export Data from AX 2012 - using DIXF (Data Migration Framework)

The virtual path maps to another application, which is not allowed

Agile Management - TFS (Priority, Stack Rank and Severity)