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.etagDimension
An opaque identifier used for optimistic concurrency control in OData operations.
_owninguser_valueDimension
Unique identifier of the user that owns the record (lookup field to the SystemUser entity).
_transactioncurrencyid_valueDimension
Unique identifier of the transaction currency for the record (lookup field to the TransactionCurrency entity).
_transactioncurrencyid_value@OData.Community.Display.V1.FormattedValueDimension
The formatted display name of the transaction currency.
accountidDimension
Unique identifier of the account record.
accountnumberDimension
A unique identifier or number assigned to an account.
createdonDimension
Date and time when the record was created.
createdon@OData.Community.Display.V1.FormattedValueDimension
The formatted display value of the date and time when the record was created.
modifiedonDimension
Date and time when the record was last modified.
modifiedon@OData.Community.Display.V1.FormattedValueDimension
The formatted display value of the date and time when the record was last modified.
nameDimension
The primary name of the record (e.g., Account Name, Contact Full Name).
statecodeMetric
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.FormattedValueDimension
The formatted display value of the record's status.
statuscodeMetric
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.FormattedValueDimension
The display name of the status code, providing a user-friendly value for the 'statuscode' field.
timezoneruleversionnumberMetric
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.FormattedValueMetric
The formatted display value of the time zone rule version number.
utcconversiontimezonecodeDimension
Time zone code that was in use when the record was created.