Naming Conventions
.gif) |
Field naming conventions within the Microsoft CRM database are discussed below.
Attributes Obtained Through Filtered Views
While field names in Microsoft CRM are case-sensitive and in mixed case, attribute names obtained through filtered views are all lowercase.
Drop-Down List Attributes
All drop-down lists (picklists) have two associated fields for every string in the list. For each string, there exists a value (code) field and a label (name) field, for example, "listcode" and "listcodename". Reports display the label field and use the value field for numeric comparisons.
Entity Attributes
For each entity table in the database, all primary key fields are in the name format entityid, for example, accountid. Each entityid field has an associated entityidname field, which contains the value that should be displayed in reports.
Related Topics