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.
@odata.etag Dimension
An opaque identifier used for optimistic concurrency control in OData operations.
_owninguser_value Dimension
Unique identifier of the user that owns the record (lookup field to the SystemUser entity).
_transactioncurrencyid_value Dimension
Unique identifier of the transaction currency for the record (lookup field to the TransactionCurrency entity).
_transactioncurrencyid_value@OData.Community.Display.V1.FormattedValue Dimension
The formatted display name of the transaction currency.
accountid Dimension
Unique identifier of the account record.
accountnumber Dimension
A unique identifier or number assigned to an account.
createdon Dimension
Date and time when the record was created.
createdon@OData.Community.Display.V1.FormattedValue Dimension
The formatted display value of the date and time when the record was created.
modifiedon Dimension
Date and time when the record was last modified.
modifiedon@OData.Community.Display.V1.FormattedValue Dimension
The formatted display value of the date and time when the record was last modified.
name Dimension
The primary name of the record (e.g., Account Name, Contact Full Name).
statecode Metric
An integer value indicating the primary status of an entity record, such as 'Active,' 'Inactive' for accounts, or 'Open,' 'Qualified,' 'Disqualified' for leads.
statecode@OData.Community.Display.V1.FormattedValue Dimension
The formatted display value of the record's status.
statuscode Metric
The reason for the current status of the record, an option set that provides more granular details than the state code.
statuscode@OData.Community.Display.V1.FormattedValue Dimension
The display name of the status code, providing a user-friendly value for the 'statuscode' field.
timezoneruleversionnumber Metric
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.
timezoneruleversionnumber@OData.Community.Display.V1.FormattedValue Metric
The formatted display value of the time zone rule version number.
utcconversiontimezonecode Dimension
Time zone code that was in use when the record was created.