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 |
_correlatedactivityid_value |
_correlatedactivityid_value |
The unique identifier (GUID) of the correlated activity. This field links the current record to a specific activity record within Dynamics 365. |
dimension |
_correlatedactivityid_value@OData.Community.Display.V1.FormattedValue |
_correlatedactivityid_value@OData.Community.Display.V1.FormattedValue |
The display name or formatted value of the correlated activity. This provides a user-friendly text representation of the activity. |
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 |
_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 |
_ownerid_value |
_ownerid_value |
Unique identifier (GUID) of the record owner, which can be a user or a team. |
dimension |
The display name or formatted value of the owner of the record. This provides the user-friendly name of the user or team. |
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 |
A lookup field representing the unique identifier of the parent activity record associated with the current record. |
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 |
The unique identifier (GUID) of a parent bundle or package record. This is a lookup field indicating a hierarchical relationship. |
dimension |
_productid_value |
_productid_value |
Unique identifier of the product associated with the record. |
dimension |
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 |
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 |
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 |
Formatted display value of the base amount. |
dimension |
||
baseamount_base |
baseamount_base |
Base amount of the product in the organization’s base currency. |
metric |
Formatted display value of the base amount in base currency. |
dimension |
||
category |
category |
A classification or grouping for the record. This field is used for organizing and filtering records within Dynamics 365. |
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 |
||
deliveryattempts |
deliveryattempts |
Number of times the activity has been attempted for delivery. |
metric |
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 |
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 |
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 |
Formatted display value indicating if the record was copied. |
dimension |
||
ispriceoverridden |
ispriceoverridden |
Indicates whether the price has been manually overridden for the product. |
dimension |
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 |
The date and time when the record was last opened. |
dimension |
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 |
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 |
The formatted display value of the date and time when the record was last modified. |
dimension |
||
msdyn_acilastupdatetimestamp |
msdyn_acilastupdatetimestamp |
The date and time when the Agent Core Interface (ACI) record was last updated. |
dimension |
msdyn_averagefirstresponsetimebytheminhrs |
msdyn_averagefirstresponsetimebytheminhrs |
The average time, in hours, for the first response from the customer’s perspective. |
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 |
The average time, in hours, for the first response from the organization’s (team’s) perspective. |
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 |
The accuracy level of a computation or calculation, likely related to analytics or data processing within a Dynamics 365 solution (e.g., Sales, Service, or custom entities). |
metric |
msdyn_computationaccuracy@OData.Community.Display.V1.FormattedValue |
msdyn_computationaccuracy@OData.Community.Display.V1.FormattedValue |
Formatted display value of the computation accuracy. |
dimension |
msdyn_date |
msdyn_date |
Date associated with the Microsoft Dynamics 365 record or data point. |
dimension |
msdyn_emailattachmentopens |
msdyn_emailattachmentopens |
The total count of times attachments in marketing emails have been opened by recipients. |
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 |
The total number of engagement interactions related to emails, such as opens, clicks, or replies. |
dimension |
msdyn_emaillinksclicked |
msdyn_emaillinksclicked |
The total count of times links embedded in marketing emails have been clicked by recipients. |
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 |
The total count 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 |
The total count of emails sent. |
metric |
Formatted display value of the number of emails sent. |
metric |
||
msdyn_facetimewithcustomer |
msdyn_facetimewithcustomer |
The amount of time spent directly interacting with a customer, often referred to as ‘face time’. |
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_lastactivitybyteam |
msdyn_lastactivitybyteam |
Records the date and time of the most recent activity performed by a team on the associated record. This field helps track team engagement. |
dimension |
msdyn_lastactivitydirection |
msdyn_lastactivitydirection |
The direction of the last activity, indicating whether it was incoming or outgoing. |
dimension |
msdyn_lastactivityid |
msdyn_lastactivityid |
The unique identifier of the last activity performed. |
dimension |
msdyn_lastactivitytype |
msdyn_lastactivitytype |
The type of the last activity performed (e.g., phone call, email, meeting, task). |
dimension |
msdyn_leadkpiitemid |
msdyn_leadkpiitemid |
The unique identifier for a Key Performance Indicator (KPI) item associated with a lead. |
dimension |
msdyn_liemailssent |
msdyn_liemailssent |
The number of emails sent through a LinkedIn integration. This suggests a connection between Dynamics 365 and LinkedIn for communication purposes. |
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 |
The total count 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 |
The total count 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 |
Records the date and time of the next scheduled activity to be performed by a team on the associated record. This field helps in planning future team engagements. |
dimension |
msdyn_nextactivitydirection |
msdyn_nextactivitydirection |
The direction of the next activity, indicating whether it is incoming or outgoing. |
dimension |
msdyn_nextactivityid |
msdyn_nextactivityid |
The unique identifier of the next scheduled activity. |
dimension |
msdyn_nextactivitytype |
msdyn_nextactivitytype |
The type of the next scheduled activity (e.g., phone call, email, meeting, task). |
dimension |
msdyn_openedemails |
msdyn_openedemails |
The total count of emails that have been 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 |
The total count 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 |
The total count 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 |
The state or status of the relationship health score, indicating its current condition. |
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 |
The numerical value of the relationship health score. |
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 |
The trend of the relationship health score, indicating whether it is improving, declining, or stable. |
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 |
The response rate from the customer’s perspective. |
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 |
The response rate from the organization’s (team’s) perspective. |
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 |
The amount of time spent by the customer interacting with the organization or its resources. |
dimension |
msdyn_timespentbycustomer_calculated |
msdyn_timespentbycustomer_calculated |
A calculated amount of time spent by the customer interacting with the organization or its resources. |
dimension |
msdyn_timespentbyteam |
msdyn_timespentbyteam |
The amount of time spent by the team interacting with customers or working on related tasks. |
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 |
A calculated amount of time spent by the team interacting with customers or working on related tasks. |
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 |
Formatted display value of the open count. |
metric |
||
ordercreationmethod |
ordercreationmethod |
The method by which the sales order was created (e.g., manually, via import, from a web portal). |
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 |
priceperunit |
priceperunit |
Price of each unit of the product. |
metric |
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 |
Formatted display value of the price per unit in base currency. |
dimension |
||
pricingerrorcode |
pricingerrorcode |
An error code indicating a specific issue encountered during the pricing calculation for an opportunity or sales order. |
metric |
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 |
A code indicating the type of product (e.g., standard product, product bundle, write-in product). |
metric |
Formatted display value of the product type code. |
dimension |
||
propertyconfigurationstatus |
propertyconfigurationstatus |
The current status of a property’s configuration, indicating whether it’s active, pending, or completed. |
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 |
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 |
The requested date by which a delivery should occur. |
dimension |
safedescription |
safedescription |
dimension |
|
salesorderdetailid |
salesorderdetailid |
Unique identifier of the sales order detail (line item) record. |
dimension |
salesorderdetailname |
salesorderdetailname |
The name or description of a specific line item or detail within a sales order. |
dimension |
salesorderispricelocked |
salesorderispricelocked |
A boolean value indicating whether the pricing on the sales order is locked and cannot be changed. |
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 |
The scheduled end date and time of an activity or record. |
dimension |
The formatted display value of the scheduled end date and time, reflecting user-specific locale and formatting settings. |
dimension |
||
scheduledstart |
scheduledstart |
The scheduled start date and time of an activity or record. |
dimension |
The formatted display value of the scheduled start date and time, reflecting user-specific locale and formatting settings. |
dimension |
||
sequencenumber |
sequencenumber |
A unique identifier that maintains the sequence of the order product or a related data record. |
metric |
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 |
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 |
||
subject |
subject |
The descriptive title or subject line of an activity (e.g., email, phone call, task) or a record like a lead. |
dimension |
tax |
tax |
The tax amount for a specific product included in the sales order. |
metric |
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 |
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. |
dimension |
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 |
||
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 |
The formatted string value indicating the ‘Ship To’ preference (Will Call or Address). |
dimension |