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.
_correlatedactivityid_value Dimension
Unique identifier of the activity that this email activity is correlated to.
_correlatedactivityid_value@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the correlated activity.
_createdby_value Dimension
Unique identifier of the user who created the record.
_createdby_value@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the user who created the record.
_createdonbehalfby_value Dimension
Unique identifier of the delegate user who created the record on behalf of another user.
_modifiedby_value Dimension
Unique identifier of the user who last modified the record.
_modifiedby_value@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the user who last modified the record.
_modifiedonbehalfby_value Dimension
Unique identifier of the delegate user who last modified the record on behalf of another user.
_modifiedonbehalfby_value@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the delegate user who last modified the record.
_msdyn_emailclassificationcategory_value Dimension
Unique identifier for the email classification category (AI) associated with the email, allowing for categorization like 'Billing' or 'Technical Support'.
_msdyn_leadid_value Dimension
Unique identifier of the lead associated with the record.
_msdyn_leadid_value@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the associated lead.
_organizationid_value Dimension
Unique identifier of the organization associated with the record.
_organizationid_value@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the associated organization.
_ownerid_value Dimension
Unique identifier of the user or team that owns the record.
_ownerid_value@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the record owner.
_owningbusinessunit_value Dimension
Unique identifier of the business unit that owns the record.
_owningteam_value Dimension
Unique identifier of the team that owns the record.
_owninguser_value Dimension
Unique identifier of the user that owns the record (lookup field to the SystemUser entity).
_parentactivityid_value Dimension
Unique identifier of the parent activity in a hierarchical activity structure.
_parentactivityid_value@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the parent activity.
_parentbundleidref_value Dimension
Unique identifier of the parent product bundle reference for an order product.
_productid_value Dimension
Unique identifier of the product associated with the order product.
_productid_value@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the associated product.
_quotedetailid_value Dimension
Unique identifier of the quote product (quote detail) associated with the order product.
_regardingobjectid_value Dimension
Unique identifier of the record that the activity is regarding (e.g., a lead, opportunity, or sales order).
_regardingobjectid_value@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the record the activity is regarding.
_salesorderid_value Dimension
Unique identifier of the sales order associated with the order product.
_salesorderid_value@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the associated sales order.
_salesrepid_value Dimension
Unique identifier of the sales representative associated with the order product.
_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.
_uomid_value Dimension
Unique identifier of the unit of measure (UoM) for the product quantity on the order product.
_uomid_value@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the unit of measure for the product quantity.
accountid Dimension
Unique identifier of the account record.
accountnumber Dimension
A unique identifier or number assigned to an account.
activityid Dimension
Unique identifier for the activity.
activitytypecode Dimension
The type code of the activity (e.g., email, phone call, appointment).
activitytypecode@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the activity type code.
actualend Dimension
The actual end date and time of the activity.
actualend@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the actual end date and time of the activity.
actualstart Dimension
The actual start date and time of the activity.
attachmentopencount Dimension
The number of times an attachment in the email has been viewed.
baseamount Metric
The total price of the order product, based on the price per unit and quantity, less any discount and sales tax.
baseamount@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the base amount.
baseamount_base Metric
The base amount of the order product in the organization's base currency.
baseamount_base@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the base amount in the organization's base currency.
category Dimension
Category of the activity.
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.
deliveryattempts Metric
The count of delivery attempts made for the email, indicating potential routing issues.
deliveryattempts@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the number of delivery attempts.
description Dimension
Additional information to describe the order product, such as manufacturing details or acceptable substitutions.
exchangerate Metric
The exchange rate for the transaction currency associated with the sales order detail with respect to the base currency.
exchangerate@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the exchange rate.
extendedamount Metric
The total extended amount for the order product.
extendedamount@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the extended amount.
extendedamount_base Metric
The total extended amount for the order product in the organization's base currency.
extendedamount_base@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the extended amount in the organization's base currency.
importsequencenumber Dimension
Unique identifier of the data import or data migration that created this record.
iscopied Dimension
Indicates whether the order product was copied from another record.
iscopied@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value indicating if the order product was copied.
ispriceoverridden Dimension
Indicates whether the price per unit for the order product was manually overridden.
ispriceoverridden@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value indicating if the price was overridden.
isproductoverridden Dimension
Indicates whether the product is a catalog product or a write-in product specific to the order.
isproductoverridden@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value indicating if the product was overridden.
lastonholdtime Dimension
The date and time when the activity was last put on hold.
lastopenedtime Dimension
The latest date and time when the email was opened by a recipient.
lastopenedtime@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the last opened time of the email.
lineitemnumber Dimension
The line item number for the order product, used to identify its sequence in the order.
linksclickedcount Metric
The number of times a link in the email has been clicked by recipients.
linksclickedcount@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the number of links clicked in the email.
manualdiscountamount Dimension
The amount of manual discount applied to the order product.
manualdiscountamount_base Dimension
The amount of manual discount applied to the order product in the organization's base currency.
messageid Dimension
Unique identifier for the email message.
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.
msdyn_acilastupdatetimestamp Dimension
The timestamp of the last update related to Agent-Centric Intelligence (ACI) for the record.
msdyn_averagefirstresponsetimebytheminhrs Metric
The average time, in hours, it took for the customer to respond to an interaction.
msdyn_averagefirstresponsetimebytheminhrs@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the average first response time by the customer in hours.
msdyn_averagefirstresponsetimebyusinhrs Metric
The average time, in hours, it took for our team to respond to an interaction.
msdyn_averagefirstresponsetimebyusinhrs@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the average first response time by our team in hours.
msdyn_classificationStatus Metric
The status of the email classification process, indicating whether it was successful, skipped, or failed.
msdyn_classificationStatus@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the email classification status (e.g., 'Success', 'Failed').
msdyn_computationaccuracy Metric
The accuracy of a computation related to a specific metric or insight.
msdyn_computationaccuracy@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the computation accuracy.
msdyn_date Dimension
A specific date associated with the record or a related event.
msdyn_emailattachmentopens Metric
The number of times email attachments have been opened.
msdyn_emailattachmentopens@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the number of email attachment opens.
msdyn_emailengagementinteractions Dimension
Text field containing details about email engagement interactions, such as opens, clicks, or replies.
msdyn_emaillinksclicked Metric
The number of times links within the email have been clicked.
msdyn_emaillinksclicked@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the number of email links clicked.
msdyn_emailsreceived Metric
The total count of emails received for a specific record or entity.
msdyn_emailsreceived@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the total number of emails received.
msdyn_emailssent Metric
The total count of emails sent for a specific record or entity.
msdyn_emailssent@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the total number of emails sent.
msdyn_facetimewithcustomer Metric
The total duration of time spent in face-to-face meetings or video calls with a customer.
msdyn_facetimewithcustomer@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the total face time with the customer.
msdyn_lastactivitybyteam Dimension
The date and time of the last interaction by a team member with a customer or record.
msdyn_lastactivitydirection Dimension
The direction of the last activity (e.g., incoming or outgoing).
msdyn_lastactivityid Dimension
Unique identifier of the last activity performed on a record.
msdyn_lastactivitytype Dimension
The type of the last activity performed on a record.
msdyn_leadkpiitemid Dimension
Unique identifier for a Lead KPI (Key Performance Indicator) item.
msdyn_liemailssent Metric
The number of emails sent related to a lead for Sales Insights.
msdyn_liemailssent@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the number of emails sent related to a lead.
msdyn_meetingsreceived Metric
The total count of meetings received for a specific record or entity.
msdyn_meetingsreceived@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the total number of meetings received.
msdyn_meetingssent Metric
The total count of meetings sent for a specific record or entity.
msdyn_meetingssent@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the total number of meetings sent.
msdyn_name Dimension
The name of the custom entity or record.
msdyn_nextactivitybyteam Dimension
The date and time of the next scheduled activity by a team member with a customer or record.
msdyn_nextactivitydirection Dimension
The direction of the next activity (e.g., incoming or outgoing).
msdyn_nextactivityid Dimension
Unique identifier of the next scheduled activity for a record.
msdyn_nextactivitytype Dimension
The type of the next scheduled activity for a record.
msdyn_openedemails Metric
The total count of opened emails for a specific record or entity.
msdyn_openedemails@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the total number of opened emails.
msdyn_phonecallsmade Metric
The total count of outbound phone calls made for a specific record or entity.
msdyn_phonecallsmade@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the total number of phone calls made.
msdyn_phonecallsreceived Metric
The total count of inbound phone calls received for a specific record or entity.
msdyn_phonecallsreceived@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the total number of phone calls received.
msdyn_recipientlist Dimension
A list of individual recipients to whom the email will be sent.
msdyn_relationshiphealthscorestate Metric
The state of the relationship health score (e.g., 'Good', 'Fair', 'Poor').
msdyn_relationshiphealthscorestate@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the relationship health score state.
msdyn_relationshiphealthscorevalue Metric
The numerical value of the relationship health score, providing an indicator of relationship strength.
msdyn_relationshiphealthscorevalue@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the relationship health score.
msdyn_relationshiphealthtrend Metric
The trend of the relationship health (e.g., 'Improving', 'Steady', 'Declining').
msdyn_relationshiphealthtrend@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the relationship health trend.
msdyn_responseratebythem Metric
The response rate from the customer or external party.
msdyn_responseratebythem@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the response rate by the customer or external party.
msdyn_responseratebyus Metric
The response rate from our team or internal users.
msdyn_responseratebyus@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the response rate by our team or internal users.
msdyn_sentiment Metric
The sentiment analysis result for the email, indicating its emotional tone (e.g., 'Positive', 'Negative', 'Neutral').
msdyn_sentiment@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the email sentiment (e.g., 'Very positive', 'Slightly negative').
msdyn_sentimentreason Dimension
The reason behind the assigned sentiment for the email (e.g., 'Transient', 'NonTransient').
msdyn_timespentbycustomer Dimension
The total duration of time, in minutes, that the customer has spent interacting with activities or resources.
msdyn_timespentbycustomer_calculated Dimension
A calculated field representing the total duration of time, in minutes, the customer has spent interacting with activities or resources.
msdyn_timespentbyteam Metric
The total duration of time, in minutes, that the team has spent on activities or interacting with the customer.
msdyn_timespentbyteam@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the total time spent by the team.
msdynmkt_contactpointconsent4id Dimension
Unique identifier for a contact point consent record, used in real-time marketing to manage customer consent preferences for specific channels.
msdynmkt_contactpointconsenttype Metric
Specifies whether the contact point consent record is for a purpose or a topic (e.g., 'Purpose', 'Topic').
msdynmkt_contactpointconsenttype@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the contact point consent type.
msdynmkt_contactpointvalue Dimension
The value of the contact point, typically an email address or phone number, for which consent is managed.
msdynmkt_reason Dimension
The reason for a specific marketing interaction or consent change, often part of contact point consent records.
msdynmkt_source Metric
The source of a marketing interaction, such as a segment or an external system.
msdynmkt_source@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the marketing interaction source.
name Dimension
The primary name of the record (e.g., Account Name, Contact Full Name).
opencount Metric
The total number of times the email has been opened by recipients.
opencount@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the email open count.
ordercreationmethod Metric
Indicates how the order product was created, such as through a web channel, phone order, or directly in the system.
ordercreationmethod@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value of the order creation method.
overriddencreatedon Dimension
Date and time when the record was created if it was imported or migrated, overriding the system-generated creation date.
priceperunit Metric
Shows the price per unit of the order product.
priceperunit@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value of the price per unit of the order product.
priceperunit_base Metric
Shows the price per unit of the order product in the base currency.
priceperunit_base@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value of the price per unit of the order product in the base currency.
pricingerrorcode Metric
The error code associated with the pricing calculation of the order product, if any.
pricingerrorcode@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value of the pricing error code.
productdescription Dimension
A detailed description of the order product, such as manufacturing details or acceptable substitutions. This is particularly relevant for 'write-in' products.
productname Dimension
The name of the product associated with the order line item.
productnumber Metric
Unique identifier or code for the product.
producttypecode Metric
The type of product, indicating whether it's a standard product from the catalog or a write-in product.
producttypecode@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value of the product type code.
propertyconfigurationstatus Metric
Status indicating the configuration of properties for a product or order product.
propertyconfigurationstatus@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value of the property configuration status.
quantity Metric
The quantity of the product ordered in this order product line item.
quantity@OData.Community.Display.V1.FormattedValue Metric
Formatted string value of the quantity of the product ordered.
quantitybackordered Dimension
The quantity of the order product that is currently on backorder.
quantitycancelled Dimension
The quantity of the order product that has been cancelled.
quantityshipped Dimension
The quantity of the order product that has already been shipped.
replycount Metric
The number of replies received for an email.
replycount@OData.Community.Display.V1.FormattedValue Metric
The formatted, user-friendly value of the email reply count.
requestdeliveryby Dimension
Date by which the delivery of the order product is requested.
salesorderdetailid Dimension
Unique identifier for the order product (sales order detail) record.
salesorderdetailname Dimension
The name of the sales order detail record, typically a system-generated or descriptive name.
salesorderispricelocked Dimension
Indicates whether the prices on the associated sales order are locked.
salesorderispricelocked@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value indicating whether the prices on the associated sales order are locked.
salesorderstatecode Metric
The state code of the associated sales order, indicating its lifecycle stage (e.g., active, fulfilled, cancelled).
salesorderstatecode@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value of the sales order state code.
scheduledend Dimension
The scheduled end date and time for the activity.
scheduledstart Dimension
The scheduled start date and time for the activity.
senton Dimension
The date and time when the email activity was sent.
senton@OData.Community.Display.V1.FormattedValue Dimension
The formatted, user-friendly value of the date and time the email was sent.
sequencenumber Metric
Shows the sequence number of the order product, used for ordering line items.
sequencenumber@OData.Community.Display.V1.FormattedValue Metric
Formatted string value of the sequence number.
shipto_city Dimension
The 'ship to' city for the delivery address of the order product.
shipto_contactname Dimension
The name of the contact person at the 'ship to' address.
shipto_country Dimension
The 'ship to' country or region for the delivery address of the order product.
shipto_fax Dimension
Fax number for the 'ship to' address.
shipto_freighttermscode Dimension
Code representing the freight terms for shipping the order product.
shipto_line1 Dimension
First line of the 'ship to' street address.
shipto_line2 Dimension
Second line of the 'ship to' street address.
shipto_line3 Dimension
Third line of the 'ship to' street address.
shipto_name Dimension
Name of the 'ship to' address, often the company or attention name.
shipto_postalcode Dimension
Postal code for the 'ship to' address.
shipto_stateorprovince Dimension
State or province for the 'ship to' address.
shipto_telephone Dimension
Telephone number for the 'ship to' address.
skippricecalculation Metric
Indicates whether price calculation should be skipped for this order product.
skippricecalculation@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value indicating whether price calculation should be skipped.
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.
subject Dimension
The subject of the email.
tax Metric
The tax amount applicable to the order product.
tax@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value of the tax amount.
tax_base Metric
The tax amount applicable to the order product in the base currency.
tax_base@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value of the tax amount in the base currency.
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.
torecipients Dimension
A string containing the email addresses of the primary recipients of the email.
utcconversiontimezonecode Dimension
Time zone code that was in use when the record was created.
versionnumber Metric
Internal version number of the record for concurrency control.
versionnumber@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value of the version number.
volumediscountamount Metric
The amount of discount applied based on the volume of the product ordered.
volumediscountamount@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value of the volume discount amount.
volumediscountamount_base Metric
The volume discount amount in the base currency.
volumediscountamount_base@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value of the volume discount amount in the base currency.
willcall Dimension
Indicates whether the customer will pick up the order product themselves.
willcall@OData.Community.Display.V1.FormattedValue Dimension
Formatted string value indicating whether the customer will pick up the order product.