Microsoft Dynamics 365: Most-used fields

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

_createdby_value@OData.Community.Display.V1.FormattedValue

_createdby_value@OData.Community.Display.V1.FormattedValue

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

_modifiedby_value@OData.Community.Display.V1.FormattedValue

_modifiedby_value@OData.Community.Display.V1.FormattedValue

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

_msdyn_datainsightsandanalyticsfeatureid_value

_msdyn_datainsightsandanalyticsfeatureid_value

Unique identifier for a data insights and analytics feature within Dynamics 365.

dimension

_msdyn_datainsightsandanalyticsfeatureid_value@OData.Community.Display.V1.FormattedValue

_msdyn_datainsightsandanalyticsfeatureid_value@OData.Community.Display.V1.FormattedValue

Formatted display value of the data insights and analytics feature ID.

dimension

_msdyn_leadid_value

_msdyn_leadid_value

Unique identifier of the associated lead record.

dimension

_msdyn_leadid_value@OData.Community.Display.V1.FormattedValue

_msdyn_leadid_value@OData.Community.Display.V1.FormattedValue

Formatted display value of the associated lead ID.

dimension

_organizationid_value

_organizationid_value

Unique identifier of the organization that owns the record.

dimension

_organizationid_value@OData.Community.Display.V1.FormattedValue

_organizationid_value@OData.Community.Display.V1.FormattedValue

Formatted display value of the organization ID.

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

_parentactivityid_value

_parentactivityid_value

Unique identifier of the parent activity record, typically a GUID.

dimension

_parentactivityid_value@OData.Community.Display.V1.FormattedValue

_parentactivityid_value@OData.Community.Display.V1.FormattedValue

Formatted display value of the parent activity ID.

dimension

_parentbundleidref_value

_parentbundleidref_value

dimension

_productid_value

_productid_value

Unique identifier of the product associated with the record.

dimension

_productid_value@OData.Community.Display.V1.FormattedValue

_productid_value@OData.Community.Display.V1.FormattedValue

Formatted display value of the associated product ID.

dimension

_quotedetailid_value

_quotedetailid_value

Unique identifier of the associated quote detail (line item) record.

dimension

_salesorderid_value

_salesorderid_value

Unique identifier of the associated sales order record.

dimension

_salesorderid_value@OData.Community.Display.V1.FormattedValue

_salesorderid_value@OData.Community.Display.V1.FormattedValue

Formatted display value of the associated sales order ID.

metric

_salesrepid_value

_salesrepid_value

Unique identifier of the sales representative associated with the record.

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

_uomid_value

_uomid_value

Unique identifier of the unit of measure (UoM) for the product.

dimension

_uomid_value@OData.Community.Display.V1.FormattedValue

_uomid_value@OData.Community.Display.V1.FormattedValue

Formatted display value of the unit of measure (UoM) ID.

dimension

accountid

accountid

Unique identifier of the account record.

dimension

accountnumber

accountnumber

A unique identifier or number assigned to an account.

dimension

activityid

activityid

Unique identifier of the activity.

dimension

actualend

actualend

Date and time when the activity was actually completed.

dimension

actualend@OData.Community.Display.V1.FormattedValue

actualend@OData.Community.Display.V1.FormattedValue

Formatted display value of the actual end date and time of the activity.

dimension

actualstart

actualstart

Date and time when the activity actually started.

dimension

baseamount

baseamount

Base amount of the product, excluding any discounts or taxes.

metric

baseamount@OData.Community.Display.V1.FormattedValue

baseamount@OData.Community.Display.V1.FormattedValue

Formatted display value of the base amount.

dimension

baseamount_base

baseamount_base

Base amount of the product in the organization’s base currency.

metric

baseamount_base@OData.Community.Display.V1.FormattedValue

baseamount_base@OData.Community.Display.V1.FormattedValue

Formatted display value of the base amount in base currency.

dimension

componentstate

componentstate

Indicates the state of a solution component, such as Published or Unpublished.

metric

componentstate@OData.Community.Display.V1.FormattedValue

componentstate@OData.Community.Display.V1.FormattedValue

Formatted display value of the component state.

dimension

createdon

createdon

Date and time when the record was created.

dimension

createdon@OData.Community.Display.V1.FormattedValue

createdon@OData.Community.Display.V1.FormattedValue

The formatted display value of the date and time when the record was created.

dimension

deliveryattempts

deliveryattempts

Number of times the activity has been attempted for delivery.

metric

deliveryattempts@OData.Community.Display.V1.FormattedValue

deliveryattempts@OData.Community.Display.V1.FormattedValue

Formatted display value of the number of delivery attempts.

metric

description

description

Description or notes related to the record.

dimension

exchangerate

exchangerate

The exchange rate used to convert money fields from the transaction currency to the base currency.

metric

exchangerate@OData.Community.Display.V1.FormattedValue

exchangerate@OData.Community.Display.V1.FormattedValue

The formatted display value of the exchange rate.

metric

extendedamount

extendedamount

Extended amount of the product, usually calculated as quantity multiplied by price per unit.

metric

extendedamount@OData.Community.Display.V1.FormattedValue

extendedamount@OData.Community.Display.V1.FormattedValue

Formatted display value of the extended amount.

dimension

extendedamount_base

extendedamount_base

Extended amount of the product in the organization’s base currency.

metric

extendedamount_base@OData.Community.Display.V1.FormattedValue

extendedamount_base@OData.Community.Display.V1.FormattedValue

Formatted display value of the extended amount in base currency.

dimension

importsequencenumber

importsequencenumber

Unique identifier of the data import sequence that created the record.

dimension

iscopied

iscopied

Indicates whether the record has been copied.

dimension

iscopied@OData.Community.Display.V1.FormattedValue

iscopied@OData.Community.Display.V1.FormattedValue

Formatted display value indicating if the record was copied.

dimension

iscustomizable

iscustomizable

Indicates whether the solution component is customizable.

dimension

ismanaged

ismanaged

Indicates whether the solution component is part of a managed solution.

dimension

ismanaged@OData.Community.Display.V1.FormattedValue

ismanaged@OData.Community.Display.V1.FormattedValue

Formatted display value indicating if the solution component is managed.

dimension

ispriceoverridden

ispriceoverridden

Indicates whether the price has been manually overridden for the product.

dimension

ispriceoverridden@OData.Community.Display.V1.FormattedValue

ispriceoverridden@OData.Community.Display.V1.FormattedValue

Formatted display value indicating if the price was overridden.

dimension

isproductoverridden

isproductoverridden

Indicates whether the product has been manually overridden for the order line item.

dimension

isproductoverridden@OData.Community.Display.V1.FormattedValue

isproductoverridden@OData.Community.Display.V1.FormattedValue

Formatted display value indicating if the product was overridden.

dimension

lastonholdtime

lastonholdtime

Date and time when the record was last put on hold.

dimension

lastopenedtime

lastopenedtime

Date and time when the record was last opened.

dimension

lastopenedtime@OData.Community.Display.V1.FormattedValue

lastopenedtime@OData.Community.Display.V1.FormattedValue

Formatted display value of the last opened date and time.

dimension

lineitemnumber

lineitemnumber

Sequential number for the line item within a document, such as an order or quote.

dimension

linksclickedcount

linksclickedcount

Number of links clicked in an email activity.

metric

linksclickedcount@OData.Community.Display.V1.FormattedValue

linksclickedcount@OData.Community.Display.V1.FormattedValue

Formatted display value of the count of links clicked.

metric

manualdiscountamount

manualdiscountamount

Amount of manual discount applied to the record.

dimension

manualdiscountamount_base

manualdiscountamount_base

Amount of manual discount applied to the record in the organization’s base currency.

dimension

messageid

messageid

Unique identifier of the message, such as an email message ID returned from an Exchange Server, or a custom channel message ID.

dimension

modifiedon

modifiedon

Date and time when the record was last modified.

dimension

modifiedon@OData.Community.Display.V1.FormattedValue

modifiedon@OData.Community.Display.V1.FormattedValue

The formatted display value of the date and time when the record was last modified.

dimension

msdyn_acilastupdatetimestamp

msdyn_acilastupdatetimestamp

Timestamp of the last update related to ACI (Agent Console Integration) or similar analytics.

dimension

msdyn_averagefirstresponsetimebytheminhrs

msdyn_averagefirstresponsetimebytheminhrs

Average first response time measured in minutes or hours, often related to customer service or sales engagements.

metric

msdyn_averagefirstresponsetimebytheminhrs@OData.Community.Display.V1.FormattedValue

msdyn_averagefirstresponsetimebytheminhrs@OData.Community.Display.V1.FormattedValue

Formatted display value of the average first response time in minutes or hours.

metric

msdyn_averagefirstresponsetimebyusinhrs

msdyn_averagefirstresponsetimebyusinhrs

Average first response time by the user or team, measured in hours, often related to customer service or sales engagements.

metric

msdyn_averagefirstresponsetimebyusinhrs@OData.Community.Display.V1.FormattedValue

msdyn_averagefirstresponsetimebyusinhrs@OData.Community.Display.V1.FormattedValue

Formatted display value of the average first response time by user or team in hours.

metric

msdyn_computationaccuracy

msdyn_computationaccuracy

Indicates the accuracy level of a specific computation or data insight.

metric

msdyn_computationaccuracy@OData.Community.Display.V1.FormattedValue

msdyn_computationaccuracy@OData.Community.Display.V1.FormattedValue

Formatted display value of the computation accuracy.

dimension

msdyn_dataanalyticsreport_emailid

msdyn_dataanalyticsreport_emailid

Unique identifier for an email related to a data analytics report.

dimension

msdyn_dataanalyticsreportid

msdyn_dataanalyticsreportid

Unique identifier of a data analytics report.

dimension

msdyn_date

msdyn_date

Date associated with the Microsoft Dynamics 365 record or data point.

dimension

msdyn_displayorder

msdyn_displayorder

Order in which the item should be displayed in a list or report.

metric

msdyn_displayorder@OData.Community.Display.V1.FormattedValue

msdyn_displayorder@OData.Community.Display.V1.FormattedValue

Formatted display value of the display order.

metric

msdyn_emailattachmentopens

msdyn_emailattachmentopens

Number of times email attachments have been opened.

metric

msdyn_emailattachmentopens@OData.Community.Display.V1.FormattedValue

msdyn_emailattachmentopens@OData.Community.Display.V1.FormattedValue

Formatted display value of the count of email attachment opens.

metric

msdyn_emailengagementinteractions

msdyn_emailengagementinteractions

Count of interactions related to email engagement.

dimension

msdyn_emaillinksclicked

msdyn_emaillinksclicked

Number of links clicked within emails.

metric

msdyn_emaillinksclicked@OData.Community.Display.V1.FormattedValue

msdyn_emaillinksclicked@OData.Community.Display.V1.FormattedValue

Formatted display value of the count of email links clicked.

metric

msdyn_emailsreceived

msdyn_emailsreceived

Number of emails received.

metric

msdyn_emailsreceived@OData.Community.Display.V1.FormattedValue

msdyn_emailsreceived@OData.Community.Display.V1.FormattedValue

Formatted display value of the number of emails received.

metric

msdyn_emailssent

msdyn_emailssent

Number of emails sent.

metric

msdyn_emailssent@OData.Community.Display.V1.FormattedValue

msdyn_emailssent@OData.Community.Display.V1.FormattedValue

Formatted display value of the number of emails sent.

metric

msdyn_facetimewithcustomer

msdyn_facetimewithcustomer

Total time spent in face-to-face interactions with a customer.

metric

msdyn_facetimewithcustomer@OData.Community.Display.V1.FormattedValue

msdyn_facetimewithcustomer@OData.Community.Display.V1.FormattedValue

Formatted display value of the face time with the customer.

metric

msdyn_isvisible

msdyn_isvisible

Indicates whether the item is visible.

dimension

msdyn_isvisible@OData.Community.Display.V1.FormattedValue

msdyn_isvisible@OData.Community.Display.V1.FormattedValue

Formatted display value indicating if the item is visible.

dimension

msdyn_lastactivitybyteam

msdyn_lastactivitybyteam

Date and time of the last activity performed by the team.

dimension

msdyn_lastactivitydirection

msdyn_lastactivitydirection

Direction of the last activity (e.g., incoming, outgoing).

dimension

msdyn_lastactivityid

msdyn_lastactivityid

Unique identifier of the last activity.

dimension

msdyn_lastactivitytype

msdyn_lastactivitytype

Type of the last activity (e.g., email, phone call, meeting).

dimension

msdyn_leadkpiitemid

msdyn_leadkpiitemid

Unique identifier for a Key Performance Indicator (KPI) item related to a lead.

dimension

msdyn_liemailssent

msdyn_liemailssent

metric

msdyn_liemailssent@OData.Community.Display.V1.FormattedValue

msdyn_liemailssent@OData.Community.Display.V1.FormattedValue

Formatted display value of the number of LinkedIn emails sent.

metric

msdyn_meetingsreceived

msdyn_meetingsreceived

Number of meetings received.

metric

msdyn_meetingsreceived@OData.Community.Display.V1.FormattedValue

msdyn_meetingsreceived@OData.Community.Display.V1.FormattedValue

Formatted display value of the number of meetings received.

metric

msdyn_meetingssent

msdyn_meetingssent

Number of meetings sent.

metric

msdyn_meetingssent@OData.Community.Display.V1.FormattedValue

msdyn_meetingssent@OData.Community.Display.V1.FormattedValue

Formatted display value of the number of meetings sent.

metric

msdyn_name

msdyn_name

Primary name or title of the Dynamics 365 custom entity or record.

dimension

msdyn_nextactivitybyteam

msdyn_nextactivitybyteam

Date and time of the next activity scheduled for the team.

dimension

msdyn_nextactivitydirection

msdyn_nextactivitydirection

Direction of the next activity (e.g., incoming, outgoing).

dimension

msdyn_nextactivityid

msdyn_nextactivityid

Unique identifier of the next scheduled activity.

dimension

msdyn_nextactivitytype

msdyn_nextactivitytype

Type of the next scheduled activity (e.g., email, phone call, meeting).

dimension

msdyn_openedemails

msdyn_openedemails

Number of emails opened.

metric

msdyn_openedemails@OData.Community.Display.V1.FormattedValue

msdyn_openedemails@OData.Community.Display.V1.FormattedValue

Formatted display value of the number of opened emails.

metric

msdyn_phonecallsmade

msdyn_phonecallsmade

Number of phone calls made.

metric

msdyn_phonecallsmade@OData.Community.Display.V1.FormattedValue

msdyn_phonecallsmade@OData.Community.Display.V1.FormattedValue

Formatted display value of the number of phone calls made.

metric

msdyn_phonecallsreceived

msdyn_phonecallsreceived

Number of phone calls received.

metric

msdyn_phonecallsreceived@OData.Community.Display.V1.FormattedValue

msdyn_phonecallsreceived@OData.Community.Display.V1.FormattedValue

Formatted display value of the number of phone calls received.

metric

msdyn_relationshiphealthscorestate

msdyn_relationshiphealthscorestate

Indicates the state or status of a relationship health score, often used in sales or customer service insights.

metric

msdyn_relationshiphealthscorestate@OData.Community.Display.V1.FormattedValue

msdyn_relationshiphealthscorestate@OData.Community.Display.V1.FormattedValue

Formatted display value of the relationship health score state.

dimension

msdyn_relationshiphealthscorevalue

msdyn_relationshiphealthscorevalue

Numerical value representing the health score of a customer relationship.

metric

msdyn_relationshiphealthscorevalue@OData.Community.Display.V1.FormattedValue

msdyn_relationshiphealthscorevalue@OData.Community.Display.V1.FormattedValue

Formatted display value of the relationship health score value.

metric

msdyn_relationshiphealthtrend

msdyn_relationshiphealthtrend

Indicates the trend of the relationship health score (e.g., improving, stable, declining).

metric

msdyn_relationshiphealthtrend@OData.Community.Display.V1.FormattedValue

msdyn_relationshiphealthtrend@OData.Community.Display.V1.FormattedValue

Formatted display value of the relationship health trend.

dimension

msdyn_responseratebythem

msdyn_responseratebythem

Response rate by the customer or external party, often in percentage.

metric

msdyn_responseratebythem@OData.Community.Display.V1.FormattedValue

msdyn_responseratebythem@OData.Community.Display.V1.FormattedValue

Formatted display value of the response rate by the customer.

metric

msdyn_responseratebyus

msdyn_responseratebyus

Response rate by the user or team, often in percentage.

metric

msdyn_responseratebyus@OData.Community.Display.V1.FormattedValue

msdyn_responseratebyus@OData.Community.Display.V1.FormattedValue

Formatted display value of the response rate by the user or team.

metric

msdyn_timespentbycustomer

msdyn_timespentbycustomer

Total time spent by the customer interacting with the business.

dimension

msdyn_timespentbycustomer_calculated

msdyn_timespentbycustomer_calculated

Calculated total time spent by the customer interacting with the business.

dimension

msdyn_timespentbyteam

msdyn_timespentbyteam

Total time spent by the team interacting with the customer.

metric

msdyn_timespentbyteam@OData.Community.Display.V1.FormattedValue

msdyn_timespentbyteam@OData.Community.Display.V1.FormattedValue

Formatted display value of the time spent by the team.

metric

msdyn_timespentbyteam_calculated

msdyn_timespentbyteam_calculated

Calculated total time spent by the team interacting with the customer.

metric

msdyn_timespentbyteam_calculated@OData.Community.Display.V1.FormattedValue

msdyn_timespentbyteam_calculated@OData.Community.Display.V1.FormattedValue

Formatted display value of the calculated time spent by the team.

metric

name

name

The primary name of the record (e.g., Account Name, Contact Full Name).

dimension

opencount

opencount

Number of times a record or email has been opened.

metric

opencount@OData.Community.Display.V1.FormattedValue

opencount@OData.Community.Display.V1.FormattedValue

Formatted display value of the open count.

metric

ordercreationmethod

ordercreationmethod

Method by which the order was created (e.g., manually, web, import).

metric

ordercreationmethod@OData.Community.Display.V1.FormattedValue

ordercreationmethod@OData.Community.Display.V1.FormattedValue

Formatted display value of the order creation method.

dimension

overriddencreatedon

overriddencreatedon

Date and time that the record was migrated.

dimension

overwritetime

overwritetime

Date and time when the record was overwritten.

dimension

overwritetime@OData.Community.Display.V1.FormattedValue

overwritetime@OData.Community.Display.V1.FormattedValue

Formatted display value of the overwrite time.

dimension

priceperunit

priceperunit

Price of each unit of the product.

metric

priceperunit@OData.Community.Display.V1.FormattedValue

priceperunit@OData.Community.Display.V1.FormattedValue

Formatted display value of the price per unit.

dimension

priceperunit_base

priceperunit_base

Price of each unit of the product in the organization’s base currency.

metric

priceperunit_base@OData.Community.Display.V1.FormattedValue

priceperunit_base@OData.Community.Display.V1.FormattedValue

Formatted display value of the price per unit in base currency.

dimension

pricingerrorcode

pricingerrorcode

Code indicating any errors encountered during pricing calculations.

metric

pricingerrorcode@OData.Community.Display.V1.FormattedValue

pricingerrorcode@OData.Community.Display.V1.FormattedValue

Formatted display value of the pricing error code.

dimension

productdescription

productdescription

Description of the product.

dimension

productname

productname

Name of the product.

dimension

productnumber

productnumber

Identifier or code for the product.

metric

producttypecode

producttypecode

Type code of the product, categorizing its nature.

metric

producttypecode@OData.Community.Display.V1.FormattedValue

producttypecode@OData.Community.Display.V1.FormattedValue

Formatted display value of the product type code.

dimension

propertyconfigurationstatus

propertyconfigurationstatus

metric

propertyconfigurationstatus@OData.Community.Display.V1.FormattedValue

propertyconfigurationstatus@OData.Community.Display.V1.FormattedValue

Formatted display value of the property configuration status.

dimension

quantity

quantity

Quantity of the product ordered or sold.

metric

quantity@OData.Community.Display.V1.FormattedValue

quantity@OData.Community.Display.V1.FormattedValue

Formatted display value of the quantity.

metric

quantitybackordered

quantitybackordered

Quantity of the product that is on backorder.

dimension

quantitycancelled

quantitycancelled

Quantity of the product that has been cancelled.

dimension

quantityshipped

quantityshipped

Quantity of the product that has been shipped.

dimension

requestdeliveryby

requestdeliveryby

Date by which the delivery of the product is requested.

dimension

salesorderdetailid

salesorderdetailid

Unique identifier of the sales order detail (line item) record.

dimension

salesorderdetailname

salesorderdetailname

Name or description of the sales order detail.

dimension

salesorderispricelocked

salesorderispricelocked

Indicates whether the pricing for the sales order is locked.

dimension

salesorderispricelocked@OData.Community.Display.V1.FormattedValue

salesorderispricelocked@OData.Community.Display.V1.FormattedValue

Formatted display value indicating if the sales order pricing is locked.

dimension

salesorderstatecode

salesorderstatecode

Indicates the status of the sales order, such as active, submitted, fulfilled, canceled, or invoiced. Only active orders can be edited.

metric

salesorderstatecode@OData.Community.Display.V1.FormattedValue

salesorderstatecode@OData.Community.Display.V1.FormattedValue

The formatted string value representing the sales order status.

dimension

scheduledend

scheduledend

dimension

scheduledend@OData.Community.Display.V1.FormattedValue

scheduledend@OData.Community.Display.V1.FormattedValue

dimension

scheduledstart

scheduledstart

dimension

scheduledstart@OData.Community.Display.V1.FormattedValue

scheduledstart@OData.Community.Display.V1.FormattedValue

dimension

sequencenumber

sequencenumber

A unique identifier that maintains the sequence of the order product or a related data record.

metric

sequencenumber@OData.Community.Display.V1.FormattedValue

sequencenumber@OData.Community.Display.V1.FormattedValue

The formatted string value representing the sequence number.

metric

shipto_city

shipto_city

The city component of the customer’s shipping address for the sales order.

dimension

shipto_contactname

shipto_contactname

The name of the primary contact at the customer’s shipping address for the sales order.

dimension

shipto_country

shipto_country

The country or region component of the customer’s shipping address for the sales order.

dimension

shipto_fax

shipto_fax

The fax number associated with the customer’s shipping address for the sales order.

dimension

shipto_freighttermscode

shipto_freighttermscode

The selected freight terms for shipping orders to ensure correct processing.

dimension

shipto_line1

shipto_line1

The first line of the customer’s shipping address for the sales order.

dimension

shipto_line2

shipto_line2

The second line of the customer’s shipping address for the sales order.

dimension

shipto_line3

shipto_line3

The third line of the customer’s shipping address for the sales order.

dimension

shipto_name

shipto_name

A descriptive name for the customer’s shipping address (e.g., ‘Headquarters’ or ‘Field office’).

dimension

shipto_postalcode

shipto_postalcode

The ZIP Code or postal code for the customer’s shipping address for the sales order.

dimension

shipto_stateorprovince

shipto_stateorprovince

The state or province component of the customer’s shipping address for the sales order.

dimension

shipto_telephone

shipto_telephone

The phone number associated with the customer’s shipping address for the sales order.

dimension

skippricecalculation

skippricecalculation

Indicates whether the price calculation should be skipped for the sales order or order product.

metric

skippricecalculation@OData.Community.Display.V1.FormattedValue

skippricecalculation@OData.Community.Display.V1.FormattedValue

The formatted string value indicating whether price calculation is skipped.

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

statecode@OData.Community.Display.V1.FormattedValue

statecode@OData.Community.Display.V1.FormattedValue

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

statuscode@OData.Community.Display.V1.FormattedValue

statuscode@OData.Community.Display.V1.FormattedValue

The display name of the status code, providing a user-friendly value for the ‘statuscode’ field.

dimension

subject

subject

dimension

tax

tax

The tax amount for a specific product included in the sales order.

metric

tax@OData.Community.Display.V1.FormattedValue

tax@OData.Community.Display.V1.FormattedValue

The formatted string value representing the tax amount for the order product.

dimension

tax_base

tax_base

The tax amount for the order product in the base currency.

metric

tax_base@OData.Community.Display.V1.FormattedValue

tax_base@OData.Community.Display.V1.FormattedValue

The formatted string value representing the tax amount in base currency for the order product.

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

versionnumber@OData.Community.Display.V1.FormattedValue

versionnumber@OData.Community.Display.V1.FormattedValue

The formatted display value of the version number.

dimension

volumediscountamount

volumediscountamount

The discount amount per unit applied if a specified volume of products is purchased within an order.

metric

volumediscountamount@OData.Community.Display.V1.FormattedValue

volumediscountamount@OData.Community.Display.V1.FormattedValue

The formatted string value representing the volume discount amount.

dimension

volumediscountamount_base

volumediscountamount_base

The volume discount amount in the base currency for the order product.

metric

volumediscountamount_base@OData.Community.Display.V1.FormattedValue

volumediscountamount_base@OData.Community.Display.V1.FormattedValue

The formatted string value representing the volume discount amount in base currency.

dimension

willcall

willcall

Indicates whether the products in the order should be shipped to an address or held for customer pick-up or further instructions.

dimension

willcall@OData.Community.Display.V1.FormattedValue

willcall@OData.Community.Display.V1.FormattedValue

The formatted string value indicating the ‘Ship To’ preference (Will Call or Address).

dimension