Simple summary Keys are in Dynamics AX
There is a maximum of one
Primary Keyper table, whereas a table can have several
alternate keys. The
primary keyis usually the type of key that other tables, called child tables, refer to when a
foreign keyfield in those other tables need a relational identifier.
For new tables the default is a
primary keybased on the
RecIdfield , incremented number or a completely meaningless number that is generated by the system
A surrogate keyis a system-generated value that acts as the primary key of a table. This value is typically used instead of a set of fields called the natural key which would typically act as the primary key of a table. Microsoft Dynamics AX 2012 uses Recld as the
Alternate keycan be chosen as the
Replacement Keyof a table that can display on forms instead of a meaningless numeric
primary keyvalue. Each table can have a maximum of one
Natural keyhas meaning to people. Most
Relations represents a
Thank you for reading!