Microsoft Dynamics 365: Most-used fields#
The table below gives information about most-used fields that you can import from Microsoft Dynamics 365. Other fields might also be available in Adverity.
The fields that you can fetch in Adverity are updated regularly to reflect updates to data source APIs.
API name |
Adverity UI name |
Description |
Use in Adverity |
|---|---|---|---|
@odata.etag |
@odata.etag |
An opaque identifier used for optimistic concurrency control in OData operations. |
dimension |
_createdby_value |
_createdby_value |
Unique identifier of the user who created the record (lookup field to the SystemUser entity). |
dimension |
The formatted display name of the user who created the record. |
dimension |
||
_createdonbehalfby_value |
_createdonbehalfby_value |
Unique identifier of the delegate user who created the record (lookup field to the SystemUser entity). |
dimension |
_modifiedby_value |
_modifiedby_value |
Unique identifier of the user who last modified the record (lookup field to the SystemUser entity). |
dimension |
The formatted display name of the user who last modified the record. |
dimension |
||
_modifiedonbehalfby_value |
_modifiedonbehalfby_value |
Unique identifier of the delegate user who last modified the record (lookup field to the SystemUser entity). |
dimension |
_modifiedonbehalfby_value@OData.Community.Display.V1.FormattedValue |
_modifiedonbehalfby_value@OData.Community.Display.V1.FormattedValue |
The formatted display name of the delegate user who last modified the record. |
dimension |
_owningbusinessunit_value |
_owningbusinessunit_value |
Unique identifier of the business unit that owns the record (lookup field to the BusinessUnit entity). |
dimension |
_owningbusinessunit_value@OData.Community.Display.V1.FormattedValue |
_owningbusinessunit_value@OData.Community.Display.V1.FormattedValue |
The display name of the business unit that owns the record, providing a user-friendly representation of the owning business unit’s ID. |
dimension |
_owningteam_value |
_owningteam_value |
Unique identifier of the team that owns the record (lookup field to the Team entity). |
dimension |
_owninguser_value |
_owninguser_value |
Unique identifier of the user that owns the record (lookup field to the SystemUser entity). |
dimension |
_transactioncurrencyid_value |
_transactioncurrencyid_value |
Unique identifier of the transaction currency for the record (lookup field to the TransactionCurrency entity). |
dimension |
_transactioncurrencyid_value@OData.Community.Display.V1.FormattedValue |
_transactioncurrencyid_value@OData.Community.Display.V1.FormattedValue |
The formatted display name of the transaction currency. |
dimension |
accountid |
accountid |
Unique identifier of the account record. |
dimension |
accountnumber |
accountnumber |
A unique identifier or number assigned to an account. |
dimension |
createdon |
createdon |
Date and time when the record was created. |
dimension |
The formatted display value of the date and time when the record was created. |
dimension |
||
exchangerate |
exchangerate |
The exchange rate used to convert money fields from the transaction currency to the base currency. |
metric |
The formatted display value of the exchange rate. |
metric |
||
importsequencenumber |
importsequencenumber |
Unique identifier of the data import sequence that created the record. |
dimension |
modifiedon |
modifiedon |
Date and time when the record was last modified. |
dimension |
The formatted display value of the date and time when the record was last modified. |
dimension |
||
name |
name |
The primary name of the record (e.g., Account Name, Contact Full Name). |
dimension |
overriddencreatedon |
overriddencreatedon |
Date and time that the record was migrated. |
dimension |
statecode |
statecode |
An integer value indicating the primary status of an entity record, such as ‘Active,’ ‘Inactive’ for accounts, or ‘Open,’ ‘Qualified,’ ‘Disqualified’ for leads. |
metric |
The formatted display value of the record’s status. |
dimension |
||
statuscode |
statuscode |
The reason for the current status of the record, an option set that provides more granular details than the state code. |
metric |
The display name of the status code, providing a user-friendly value for the ‘statuscode’ field. |
dimension |
||
timezoneruleversionnumber |
timezoneruleversionnumber |
An integer that represents the version of the time zone rule in effect, used for internal time zone conversions, particularly for defining how local time is converted to or from Coordinated Universal Time (UTC) and handling Daylight Saving Time (DST). This field is primarily for internal system use. |
metric |
timezoneruleversionnumber@OData.Community.Display.V1.FormattedValue |
timezoneruleversionnumber@OData.Community.Display.V1.FormattedValue |
The formatted display value of the time zone rule version number. |
metric |
utcconversiontimezonecode |
utcconversiontimezonecode |
Time zone code that was in use when the record was created. |
dimension |
versionnumber |
versionnumber |
Version number of the record. |
metric |
The formatted display value of the version number. |
dimension |