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 |
A version identifier for the record, used for optimistic concurrency control to prevent data overwrites during simultaneous updates. |
dimension |
Account |
Account |
Refers to a lookup field for an Account entity, linking the current record to a specific customer account. |
dimension |
Account Name |
Account Name |
The primary name of an account record. |
dimension |
Account Number |
Account Number |
An ID number or code for the account, used to quickly search and identify the account. |
dimension |
Account Rating |
Account Rating |
A rating indicating the value of a customer account, often an option set with predefined values. |
metric |
Activity Status |
Activity Status |
The status of an activity, such as Open, Completed, or Canceled. |
metric |
Activity Type |
Activity Type |
The type of activity, such as Phone Call, Task, Letter, Email, Appointment, or Fax. |
dimension |
Actual End |
Actual End |
The actual end date and time of a task or an assignment. |
dimension |
Actual Start |
Actual Start |
The actual start date and time of a task or an assignment. |
dimension |
Address 1 |
Address 1 |
The complete primary address, often a composite field. |
dimension |
Address 1: Address Type |
Address 1: Address Type |
The type of the primary address, such as Bill To, Ship To, Primary, or Other. |
dimension |
Address 1: City |
Address 1: City |
The city for the primary address. |
dimension |
Address 1: Country/Region |
Address 1: Country/Region |
The country or region for the primary address. |
dimension |
Address 1: County |
Address 1: County |
The county for the primary address. |
dimension |
Address 1: Fax |
Address 1: Fax |
The fax number associated with the primary address. |
dimension |
Address 1: Freight Terms |
Address 1: Freight Terms |
The freight terms for the primary address, used to ensure correct shipping order processing. |
dimension |
Address 1: ID |
Address 1: ID |
Unique identifier for the primary address. |
dimension |
Address 1: Latitude |
Address 1: Latitude |
The latitude value for the primary address, often populated by geocoding services. |
dimension |
Address 1: Longitude |
Address 1: Longitude |
The longitude value for the primary address, often populated by geocoding services. |
dimension |
Address 1: Name |
Address 1: Name |
A descriptive name for the primary address, such as ‘Corporate Headquarters’. |
dimension |
Address 1: Phone |
Address 1: Phone |
The main phone number associated with the primary address. |
dimension |
Address 1: Post Office Box |
Address 1: Post Office Box |
The post office box number of the primary address. |
dimension |
Address 1: Primary Contact Name |
Address 1: Primary Contact Name |
The name of the main contact at the account’s primary address. |
dimension |
Address 1: Shipping Method |
Address 1: Shipping Method |
The shipping method for deliveries sent to the primary address. |
dimension |
Address 1: State/Province |
Address 1: State/Province |
The state or province of the primary address. |
dimension |
Address 1: Street 1 |
Address 1: Street 1 |
The first line of the primary address. |
dimension |
Address 1: Street 2 |
Address 1: Street 2 |
The second line of the primary address. |
dimension |
Address 1: Street 3 |
Address 1: Street 3 |
The third line of the primary address. |
dimension |
Address 1: Telephone 1 |
Address 1: Telephone 1 |
The main phone number associated with the primary address. |
dimension |
Address 1: Telephone 2 |
Address 1: Telephone 2 |
A second phone number associated with the primary address. |
dimension |
Address 1: Telephone 3 |
Address 1: Telephone 3 |
A third phone number associated with the primary address. |
dimension |
Address 1: UPS Zone |
Address 1: UPS Zone |
The United Parcel Service (UPS) zone for the primary address, used to calculate shipping charges and ensure timely deliveries. |
dimension |
Address 1: UTC Offset |
Address 1: UTC Offset |
The UTC offset for the primary address, representing the difference between local time and Coordinated Universal Time. |
dimension |
Address 1: ZIP/Postal Code |
Address 1: ZIP/Postal Code |
The ZIP Code or postal code for the primary address. |
dimension |
Address 2 |
Address 2 |
The complete secondary address, often a composite field. |
dimension |
Address 2: Address Type |
Address 2: Address Type |
The type of the secondary address, such as billing, shipping, or primary. |
metric |
Address 2: City |
Address 2: City |
The city for the secondary address. |
dimension |
Address 2: Country/Region |
Address 2: Country/Region |
The country or region for the secondary address. |
dimension |
Address 2: County |
Address 2: County |
The county for the secondary address. |
dimension |
Address 2: Fax |
Address 2: Fax |
The fax number associated with the secondary address. |
dimension |
Address 2: Freight Terms |
Address 2: Freight Terms |
The freight terms for the secondary address, used to ensure correct shipping order processing. |
metric |
Address 2: ID |
Address 2: ID |
Unique identifier for the secondary address. |
dimension |
Address 2: Latitude |
Address 2: Latitude |
The latitude value for the secondary address, used in mapping and other applications. |
dimension |
Address 2: Longitude |
Address 2: Longitude |
The longitude value for the secondary address, used in mapping and other applications. |
dimension |
Address 2: Name |
Address 2: Name |
A descriptive name for the secondary address, such as ‘Branch Office’. |
dimension |
Address 2: Post Office Box |
Address 2: Post Office Box |
The post office box number of the secondary address. |
dimension |
Address 2: Primary Contact Name |
Address 2: Primary Contact Name |
The name of the main contact at the account’s secondary address. |
dimension |
Address 2: Shipping Method |
Address 2: Shipping Method |
The shipping method for deliveries sent to the secondary address. |
metric |
Address 2: State/Province |
Address 2: State/Province |
The state or province of the secondary address. |
dimension |
Address 2: Street 1 |
Address 2: Street 1 |
The first line of the secondary address. |
dimension |
Address 2: Street 2 |
Address 2: Street 2 |
The second line of the secondary address. |
dimension |
Address 2: Street 3 |
Address 2: Street 3 |
The third line of the secondary address. |
dimension |
Address 2: Telephone 1 |
Address 2: Telephone 1 |
The main phone number associated with the secondary address. |
dimension |
Address 2: Telephone 2 |
Address 2: Telephone 2 |
A second phone number associated with the secondary address. |
dimension |
Address 2: Telephone 3 |
Address 2: Telephone 3 |
A third phone number associated with the secondary address. |
dimension |
Address 2: UPS Zone |
Address 2: UPS Zone |
The United Parcel Service (UPS) zone for the secondary address. |
dimension |
Address 2: UTC Offset |
Address 2: UTC Offset |
The UTC offset for the secondary address. |
dimension |
Address 2: ZIP/Postal Code |
Address 2: ZIP/Postal Code |
The ZIP Code or postal code for the secondary address. |
dimension |
Address 3 |
Address 3 |
The complete third address, often a composite field. |
dimension |
Address 3: Address Type |
Address 3: Address Type |
The type of the third address, such as billing, shipping, or primary. |
dimension |
Address 3: City |
Address 3: City |
The city for the third address. |
dimension |
Address 3: County |
Address 3: County |
The county for the third address. |
dimension |
Address 3: Fax |
Address 3: Fax |
The fax number associated with the third address. |
dimension |
Address 3: Freight Terms |
Address 3: Freight Terms |
The freight terms for the third address, used to ensure correct shipping order processing. |
dimension |
Address 3: ID |
Address 3: ID |
Unique identifier for the third address. |
dimension |
Address 3: Latitude |
Address 3: Latitude |
The latitude value for the third address, used in mapping and other applications. |
dimension |
Address 3: Longitude |
Address 3: Longitude |
The longitude value for the third address, used in mapping and other applications. |
dimension |
Address 3: Name |
Address 3: Name |
A descriptive name for the third address, such as ‘Warehouse’. |
dimension |
Address 3: Post Office Box |
Address 3: Post Office Box |
The post office box number of the third address. |
dimension |
Address 3: Primary Contact Name |
Address 3: Primary Contact Name |
The name of the main contact at the account’s third address. |
dimension |
Address 3: Shipping Method |
Address 3: Shipping Method |
The shipping method for deliveries sent to the third address. |
dimension |
Address 3: Telephone1 |
Address 3: Telephone1 |
The main phone number associated with the third address. |
dimension |
Address 3: Telephone2 |
Address 3: Telephone2 |
A second phone number associated with the third address. |
dimension |
Address 3: Telephone3 |
Address 3: Telephone3 |
A third phone number associated with the third address. |
dimension |
Address 3: UPS Zone |
Address 3: UPS Zone |
The United Parcel Service (UPS) zone for the third address. |
dimension |
Address 3: UTC Offset |
Address 3: UTC Offset |
The UTC offset for the third address. |
dimension |
Address Phone |
Address Phone |
The primary telephone number associated with an address. |
dimension |
Address3: Country/Region |
Address3: Country/Region |
The country or region component of the third address. |
dimension |
Address3: State/Province |
Address3: State/Province |
The state or province of the third address. |
dimension |
Address3: Street 1 |
Address3: Street 1 |
The first line of the third address. |
dimension |
Address3: Street 2 |
Address3: Street 2 |
The second line of the third address. |
dimension |
Address3: Street 3 |
Address3: Street 3 |
The third line of the third address. |
dimension |
Address3: ZIP/Postal Code |
Address3: ZIP/Postal Code |
The ZIP Code or postal code for the third address. |
dimension |
Aging 30 |
Aging 30 |
The total amount of open invoices that are 30 days past due. |
dimension |
Aging 30 (Base) |
Aging 30 (Base) |
The base currency equivalent of the ‘Aging 30’ field, for reporting purposes. |
dimension |
Aging 60 |
Aging 60 |
The total amount of open invoices that are 60 days past due. |
dimension |
Aging 60 (Base) |
Aging 60 (Base) |
The base currency equivalent of the ‘Aging 60’ field, for reporting purposes. |
dimension |
Aging 90 |
Aging 90 |
The total amount of open invoices that are 90 days past due. |
dimension |
Aging 90 (Base) |
Aging 90 (Base) |
The base currency equivalent of the ‘Aging 90’ field, for reporting purposes. |
dimension |
Amount |
Amount |
A monetary value associated with a record, such as the value of an order product or a transaction. |
dimension |
Amount (Base) |
Amount (Base) |
The monetary amount converted to the system’s default base currency. |
dimension |
Anniversary |
Anniversary |
The contact’s anniversary date. |
dimension |
Annual Income |
Annual Income |
The annual income of a contact. |
dimension |
Annual Income (Base) |
Annual Income (Base) |
The annual income of a contact converted to the system’s default base currency. |
dimension |
Annual Revenue |
Annual Revenue |
The annual revenue of an account. |
metric |
Annual Revenue (Base) |
Annual Revenue (Base) |
The annual revenue of an account converted to the system’s default base currency. |
metric |
Assistant |
Assistant |
The name of the contact’s assistant. |
dimension |
Assistant Phone |
Assistant Phone |
The phone number of the assistant. |
dimension |
Attachment Count |
Attachment Count |
The total number of attachments associated with a record, such as a lead or email. |
metric |
Attachment Open Count |
Attachment Open Count |
The number of times attachments within an email have been opened. |
dimension |
Bill To Address |
Bill To Address |
The complete billing address for an order or quote, often a composite field. |
dimension |
Bill To Address ID |
Bill To Address ID |
Unique identifier for the billing address. |
dimension |
Bill To City |
Bill To City |
The city for the billing address. |
dimension |
Bill To Contact Name |
Bill To Contact Name |
The name of the contact person for billing purposes. |
dimension |
Bill To Country/Region |
Bill To Country/Region |
The country or region for the billing address. |
dimension |
Bill To Fax |
Bill To Fax |
The fax number for the billing address. |
dimension |
Bill To Name |
Bill To Name |
A descriptive name for the customer’s billing address. |
dimension |
Bill To Phone |
Bill To Phone |
The phone number for the billing address. |
dimension |
Bill To State/Province |
Bill To State/Province |
The state or province for the billing address. |
dimension |
Bill To Street 1 |
Bill To Street 1 |
The first line of the billing address. |
dimension |
Bill To Street 2 |
Bill To Street 2 |
The second line of the billing address. |
dimension |
Bill To Street 3 |
Bill To Street 3 |
The third line of the billing address. |
dimension |
Bill To ZIP/Postal Code |
Bill To ZIP/Postal Code |
The ZIP Code or postal code for the billing address. |
dimension |
Billing Method |
Billing Method |
The chosen approach or terms for invoicing and charging customers. |
dimension |
Billing Start Date |
Billing Start Date |
The commencement date of a billing cycle or period. |
dimension |
Birthday |
Birthday |
The birthday of a contact. |
dimension |
Budget |
Budget |
The allocated financial amount for a project, campaign, or other initiative. |
dimension |
Budget Amount |
Budget Amount |
The monetary amount of the budget. |
metric |
Budget Amount (Base) |
Budget Amount (Base) |
The budget amount converted to the system’s default base currency. |
metric |
Business Phone |
Business Phone |
The main business phone number for a contact or account. |
dimension |
Business Phone 2 |
Business Phone 2 |
A secondary business phone number. |
dimension |
Business Type |
Business Type |
The legal designation or other business type of the account, used for contracts or reporting purposes. |
metric |
Callback Number |
Callback Number |
The telephone number to call back a contact. |
dimension |
Category |
Category |
A category to indicate whether the customer account is standard or preferred. |
metric |
City |
City |
The city component of an address. |
dimension |
Classification |
Classification |
A classification code indicating the potential value of the customer account based on projected return on investment or cooperation level. |
metric |
Company Name |
Company Name |
The official name of a company. |
dimension |
Company Phone |
Company Phone |
The primary telephone number for a company. |
dimension |
Confirm Interest |
Confirm Interest |
Indicates whether a potential customer (lead) has explicitly confirmed their interest. |
dimension |
Contact |
Contact |
Refers to a lookup field for a Contact entity, linking the current record to a specific individual. |
dimension |
Contract Status |
Contract Status |
The status of a contract. |
dimension |
Contract Status Reason |
Contract Status Reason |
The reason for the current contract status. |
dimension |
Conversation Index |
Conversation Index |
Shows how an email is correlated to an existing email conversation. |
dimension |
Conversation Index (Hash) |
Conversation Index (Hash) |
A hashed value used to correlate emails within a conversation, providing a unique identifier for the conversation thread. |
metric |
Conversation Tracking Id |
Conversation Tracking Id |
An ID used for tracking and correlating activities within a conversation thread, especially for emails. |
dimension |
Correlation Method |
Correlation Method |
Shows how an email is correlated to an existing email in Dynamics 365, indicating the method used for tracking the conversation. |
metric |
Cost Amount |
Cost Amount |
The monetary cost amount associated with a product or service. |
dimension |
Cost Amount (Base) |
Cost Amount (Base) |
The cost amount converted to the system’s default base currency. |
dimension |
Cost Price Per Unit |
Cost Price Per Unit |
The cost price per unit for a product or service. |
dimension |
Cost Price Per Unit (Base) |
Cost Price Per Unit (Base) |
The cost price per unit converted to the system’s default base currency. |
dimension |
Country/Region |
Country/Region |
The country or region component of an address. |
dimension |
Created On |
Created On |
Date and time when the record was created. |
dimension |
Credit Hold |
Credit Hold |
Indicates whether the account is on credit hold. |
dimension |
Credit Limit |
Credit Limit |
The credit limit of the account or contact, used as a reference for invoicing and accounting. |
dimension |
Credit Limit (Base) |
Credit Limit (Base) |
The credit limit converted to the system’s default base currency for reporting purposes. |
dimension |
Current Cost |
Current Cost |
The current cost for the product item, used in price calculations. |
metric |
Current Cost (Base) |
Current Cost (Base) |
The current cost for the product item converted to the system’s default base currency. |
metric |
Customer Size |
Customer Size |
The size of the customer, often an option set for categorizing accounts. |
metric |
Date Fulfilled |
Date Fulfilled |
The date and time when an order or activity was fulfilled. |
dimension |
Date Sent |
Date Sent |
The date and time when an email or other activity was sent. |
dimension |
Date Submitted |
Date Submitted |
Date when an item or record was submitted. |
dimension |
Decision Maker? |
Decision Maker? |
A boolean field indicating whether a contact is a decision maker. |
dimension |
Default Image |
Default Image |
The default image for the entity, typically a small icon or picture. |
dimension |
Delay email processing until |
Delay email processing until |
Specifies a future date and time to hold an email before it is sent. |
dimension |
Delivery Priority |
Delivery Priority |
The priority of delivery for an activity, such as an email, to the email server. |
metric |
Delivery Receipt Requested |
Delivery Receipt Requested |
Indicates whether the sender should receive confirmation that the email was delivered. |
dimension |
Department |
Department |
The department of the contact or employee. |
dimension |
Description |
Description |
A descriptive text field for additional information about the record or activity. |
dimension |
Direction |
Direction |
The direction of an activity, such as incoming or outbound for an email or fax. |
dimension |
Do not allow Bulk Emails |
Do not allow Bulk Emails |
Indicates whether bulk emails are allowed to be sent to the record (e.g., contact or lead). |
dimension |
Do not allow Bulk Mails |
Do not allow Bulk Mails |
Indicates whether bulk postal mails are allowed to be sent to the record. |
dimension |
Do not allow Emails |
Do not allow Emails |
Indicates whether any emails are allowed to be sent to the activity party. |
dimension |
Do not allow Faxes |
Do not allow Faxes |
Indicates whether faxes are allowed to be sent to the activity party. |
dimension |
Do not allow Mails |
Do not allow Mails |
Indicates whether postal mails are allowed to be sent to the activity party. |
dimension |
Do not allow Phone Calls |
Do not allow Phone Calls |
Indicates whether phone calls are allowed to be made to the activity party. |
dimension |
Due Date |
Due Date |
The date by which a payment is expected or a task needs to be completed. |
dimension |
Duration |
Duration |
The actual duration of an activity in minutes. |
metric |
Education |
Education |
The level of education for the contact. |
metric |
The primary email address for the contact or lead. |
dimension |
||
Email Address |
Email Address |
A general email address field for a contact or entity. |
dimension |
Email Address 2 |
Email Address 2 |
The secondary email address for the contact. |
dimension |
Email Address 3 |
Email Address 3 |
An alternate or third email address for the contact. |
dimension |
Email Message |
Email Message |
The content or body of an email message. |
dimension |
Email Reminder Expiry Time |
Email Reminder Expiry Time |
Shows the date and time when an email reminder expires. |
dimension |
Email Reminder Text |
Email Reminder Text |
For internal use only. |
dimension |
Email Reminder Type |
Email Reminder Type |
Shows the type of the email reminder. |
metric |
Email Tracking Id |
Email Tracking Id |
Email Tracking Id. |
dimension |
Employee |
Employee |
The employee associated with the record. |
dimension |
Entity Image |
Entity Image |
Shows the default image for the record. |
dimension |
Entity Image Id |
Entity Image Id |
For internal use only. |
dimension |
Est. Close Date |
Est. Close Date |
Enter the expected close date for the lead, so that the sales team can schedule timely follow-up meetings to move the prospect to the next sales stage. |
dimension |
Est. Value |
Est. Value |
Type the estimated revenue value that this lead will generate to assist in sales forecasting and planning. |
metric |
Est. Value (Base) |
Est. Value (Base) |
Value of the Est. Value in base currency. |
metric |
Est. Value (deprecated) |
Est. Value (deprecated) |
Type a numeric value of the lead’s estimated value, such as a product quantity, if no revenue amount can be specified in the Est. Value field. This can be used for sales forecasting and planning. |
dimension |
Evaluate Fit |
Evaluate Fit |
Select whether the fit between the lead’s requirements and your offerings was evaluated. |
dimension |
Exchange Rate |
Exchange Rate |
Shows the conversion rate of the record’s currency. The exchange rate is used to convert all money fields in the record from the local currency to the system’s default currency. |
metric |
Extended Amount |
Extended Amount |
Shows the total amount due for the order product, based on the sum of the unit price, quantity, discounts, and tax. |
dimension |
Extended Amount (Base) |
Extended Amount (Base) |
Value of the Extended Amount in base currency. |
dimension |
FTP Site |
FTP Site |
Type the URL for the account’s FTP site to enable users to access data and share documents. |
dimension |
Fax |
Fax |
Type the fax number associated with the primary address. |
dimension |
Field Service Product Type |
Field Service Product Type |
A classification for products or services used specifically within Dynamics 365 Field Service. |
metric |
First Name |
First Name |
Type the first name of the contact. |
dimension |
Follow Email Activity |
Follow Email Activity |
Information about whether to allow following email activity like opens, attachment views and link clicks for emails sent to the lead. |
dimension |
Followed |
Followed |
For internal use only. Shows whether this email is followed. This is evaluated state which overrides user selection of follow email. |
dimension |
Following |
Following |
Select whether the email allows following recipient activities sent from Microsoft Dynamics 365. This is user preference state which can be overridden by system evaluated state. |
dimension |
Freight Amount |
Freight Amount |
Type the cost of freight or shipping for the products included in the order for use in calculating the Total Amount field. |
dimension |
Freight Amount (Base) |
Freight Amount (Base) |
Value of the Freight Amount in base currency. |
dimension |
Freight Terms |
Freight Terms |
Select the freight terms to make sure shipping orders are processed correctly. |
dimension |
From |
From |
Sender of the email. |
dimension |
Full Name |
Full Name |
Combines first and last names of the contact to show the full name in views and reports. |
dimension |
Gender |
Gender |
Select the contact’s gender. |
metric |
Has Children |
Has Children |
Select whether the contact has children for marketing purposes. |
metric |
Hierarchy Path |
Hierarchy Path |
Hierarchy path of the account. |
dimension |
Home Phone |
Home Phone |
Type the home phone number for the primary contact for the lead. |
dimension |
Home Phone 2 |
Home Phone 2 |
A second home telephone number for the contact. |
dimension |
Import Sequence Number |
Import Sequence Number |
Sequence number of the import that created this record. |
metric |
In Reply To Message |
In Reply To Message |
Type the ID of the email message that this email activity is a response to. |
dimension |
Include Expense |
Include Expense |
A boolean indicator to include expense transactions in financial calculations or billing. |
dimension |
Include Fee |
Include Fee |
A boolean indicator to include fees in financial calculations or billing. |
dimension |
Include Material |
Include Material |
A boolean indicator to include material costs in financial calculations or billing. |
dimension |
Include Time |
Include Time |
A boolean indicator to include time (labor) costs in financial calculations or billing. |
dimension |
Industry |
Industry |
Select the account’s primary industry for use in marketing segmentation and demographic analysis. |
metric |
Initial Communication |
Initial Communication |
Choose whether someone from the sales team contacted this lead earlier. |
dimension |
Is Billed |
Is Billed |
Information regarding whether the activity was billed as part of resolving a case. |
dimension |
Is Kit |
Is Kit |
Information that specifies whether the product is a kit. |
dimension |
Is Regular Activity |
Is Regular Activity |
Information regarding whether the activity is a regular activity type or event type. |
dimension |
Is Workflow Created |
Is Workflow Created |
Information regarding whether the activity was created from a workflow rule. |
dimension |
Job Title |
Job Title |
Type the job title of the primary contact for this lead to make sure the prospect is addressed correctly in sales calls, email, and marketing campaigns. |
dimension |
Last Campaign Date |
Last Campaign Date |
Shows the date when the lead was last included in a marketing campaign or quick campaign. |
dimension |
Last Date Included in Campaign |
Last Date Included in Campaign |
Shows the date when the account was last included in a marketing campaign or quick campaign. |
dimension |
Last Name |
Last Name |
Type the last name of the primary contact for the lead to make sure the prospect is addressed correctly in sales calls, email, and marketing campaigns. |
dimension |
Last On Hold Time |
Last On Hold Time |
Contains the date and time stamp of the last on hold time. |
dimension |
Last Opened Time |
Last Opened Time |
Shows the latest date and time when email was opened. |
dimension |
Lead |
Lead |
Unique identifier of the lead. |
dimension |
Lead Source |
Lead Source |
Select the primary marketing source that prompted the lead to contact you. |
metric |
Line Item Number |
Line Item Number |
Type the line item number for the order product to easily identify the product in the order and make sure it’s listed in the correct sequence. |
dimension |
Line Type |
Line Type |
The classification of a line item, such as a product, service, or expense. |
dimension |
Links Clicked Count |
Links Clicked Count |
Shows the number of times a link in an email has been clicked. |
dimension |
List Price |
List Price |
List price for the product item. Used in price calculations. |
metric |
List Price (Base) |
List Price (Base) |
Value of the List Price in base currency. |
metric |
Main Phone |
Main Phone |
Type the main phone number for this account. |
dimension |
Manager |
Manager |
The name of the contact’s manager. |
dimension |
Manager Phone |
Manager Phone |
The telephone number of the contact’s manager. |
dimension |
Manual Discount |
Manual Discount |
Type the manual discount amount for the order product to deduct any negotiated or other savings from the product total on the order. |
dimension |
Manual Discount (Base) |
Manual Discount (Base) |
Value of the Manual Discount in base currency. |
dimension |
Marital Status |
Marital Status |
Select the contact’s marital status for marketing purposes. |
metric |
Market Capitalization |
Market Capitalization |
Type the market capitalization of the account to identify the company’s equity, used as an indicator in financial performance analysis. |
dimension |
Market Capitalization (Base) |
Market Capitalization (Base) |
Shows the market capitalization converted to the system’s default base currency. |
dimension |
Marketing Material |
Marketing Material |
Select whether the account accepts marketing materials, such as brochures or catalogs. |
dimension |
Merged |
Merged |
Tells whether the lead has been merged with another lead. |
dimension |
Message ID |
Message ID |
Unique identifier of the email message. Used only for email that is received. |
dimension |
Middle Name |
Middle Name |
Type the middle name or initial of the primary contact for the lead to make sure the prospect is addressed correctly. |
dimension |
Mime Type |
Mime Type |
MIME type of the email message data. |
dimension |
Mobile Phone |
Mobile Phone |
Type the mobile phone number for the primary contact for the lead. |
dimension |
Modified On |
Modified On |
Date and time when activity was last modified. |
dimension |
Name |
Name |
The primary name or title of the record. |
dimension |
Need |
Need |
Choose how high the level of need is for the lead’s company. |
dimension |
Nickname |
Nickname |
The contact’s nickname. |
dimension |
No. of Delivery Attempts |
No. of Delivery Attempts |
Shows the count of the number of attempts made to send the email. The count is used as an indicator of email routing issues. |
metric |
No. of Employees |
No. of Employees |
Type the number of employees that work at the company associated with the lead, for use in marketing segmentation and demographic analysis. |
metric |
Notifications |
Notifications |
Select the notification code to identify issues with the email recipients or attachments, such as blocked attachments. |
metric |
Number of Employees |
Number of Employees |
Type the number of employees that work at the company associated with the lead, for use in marketing segmentation and demographic analysis. |
metric |
On Hold Time (Minutes) |
On Hold Time (Minutes) |
Shows how long, in minutes, that the record was on hold. |
dimension |
Open Count |
Open Count |
Shows the number of times an email has been opened. |
dimension |
Open Deals |
Open Deals |
The count of active or currently open sales opportunities. |
metric |
Open Deals (Last Updated On) |
Open Deals (Last Updated On) |
The date and time when the ‘Open Deals’ count was last updated. |
dimension |
Open Deals (State) |
Open Deals (State) |
The current state of the ‘Open Deals’ metric, indicating its processing status. |
metric |
Open Revenue |
Open Revenue |
The total revenue associated with open or active sales opportunities. |
metric |
Open Revenue (Base) |
Open Revenue (Base) |
Value of the Open Revenue in base currency. |
metric |
Open Revenue (Last Updated On) |
Open Revenue (Last Updated On) |
The date and time when the ‘Open Revenue’ value was last updated. |
dimension |
Open Revenue (State) |
Open Revenue (State) |
The current state of the ‘Open Revenue’ metric, indicating its processing status. |
metric |
Order |
Order |
Unique identifier of the order. |
dimension |
Order Discount (%) |
Order Discount (%) |
Type the discount rate that should be applied to the Detail Amount field to include additional savings for the customer in the order. |
dimension |
Order Discount Amount |
Order Discount Amount |
Type the discount amount for the order if the customer is eligible for special savings. |
dimension |
Order Discount Amount (Base) |
Order Discount Amount (Base) |
Value of the Order Discount Amount in base currency. |
dimension |
Order ID |
Order ID |
Shows the order number for customer reference and to use in search. The number cannot be modified. |
dimension |
Order Is Price Locked |
Order Is Price Locked |
Select whether prices specified on the invoice are locked from any further updates. |
dimension |
Order Product |
Order Product |
Unique identifier of the product specified in the order. |
dimension |
Order Status |
Order Status |
Shows the status of the order that the order detail is associated with. |
dimension |
Order Type |
Order Type |
A classification or category for an order, such as a sales order or work order. |
dimension |
Other Phone |
Other Phone |
Type an alternate phone number for the primary contact for the lead. |
dimension |
Ownership |
Ownership |
Select the account’s ownership structure, such as public or private. |
metric |
Pager |
Pager |
Type the pager number for the primary contact for the lead. |
dimension |
Parent Bundle |
Parent Bundle |
Choose the parent bundle associated with this product. |
dimension |
Participates in Workflow |
Participates in Workflow |
Shows whether the lead participates in workflow rules. |
dimension |
Payment Terms |
Payment Terms |
Select the payment terms to indicate when the customer needs to pay the total amount. |
dimension |
Preferred Day |
Preferred Day |
Select the preferred day of the week for service appointments. |
dimension |
Preferred Method of Contact |
Preferred Method of Contact |
Select the preferred method of contact. |
metric |
Preferred Time |
Preferred Time |
Select the preferred time of day for service appointments. |
metric |
Price Per Unit |
Price Per Unit |
Type the price per unit of the order product. The default is the value in the price list specified on the order for existing products. |
dimension |
Price Per Unit (Base) |
Price Per Unit (Base) |
Value of the Price Per Unit in base currency. |
dimension |
Prices Locked |
Prices Locked |
Select whether prices specified on the invoice are locked from any further updates. |
dimension |
Pricing |
Pricing |
Select whether the price per unit is fixed at the value in the specified price list or can be overridden by users who have edit rights to the order product. |
dimension |
Pricing Error |
Pricing Error |
Select the type of pricing error, such as a missing or invalid product, or missing quantity. |
dimension |
Primary Contact |
Primary Contact |
A lookup field referencing the primary contact person associated with an account or other entity. |
dimension |
Primary Contact Full Name |
Primary Contact Full Name |
The full name of the primary contact associated with a record. |
dimension |
Priority |
Priority |
Select the priority so that preferred customers or critical issues are handled quickly. |
metric |
Process |
Process |
Shows the ID of the process. |
dimension |
Process Id |
Process Id |
Unique identifier of the Process. |
dimension |
Process Stage |
Process Stage |
Shows the ID of the stage (Deprecated). |
dimension |
Product |
Product |
Choose the product to include on the order to link the product’s pricing and other information to the parent order. |
dimension |
Product ID |
Product ID |
Unique identifier of the product. |
dimension |
Product Name |
Product Name |
Calculated field that will be populated by name and description of the product. |
dimension |
Product Structure |
Product Structure |
Product Structure. |
metric |
Product Type |
Product Type |
Type of product. |
metric |
Product type |
Product type |
Type of product. |
dimension |
Purchase Process |
Purchase Process |
Choose whether an individual or a committee will be involved in the purchase process for the lead. |
metric |
Purchase Timeframe |
Purchase Timeframe |
The estimated period within which a purchase is anticipated to be made. |
metric |
Qualification Comments |
Qualification Comments |
Type comments about the qualification or scoring of the lead. |
dimension |
Quantity |
Quantity |
Type the amount or quantity of the product ordered by the customer. |
dimension |
Quantity Back Ordered |
Quantity Back Ordered |
Type the amount or quantity of the product that is back ordered for the order. |
dimension |
Quantity Canceled |
Quantity Canceled |
Type the amount or quantity of the product that was canceled. |
dimension |
Quantity On Hand |
Quantity On Hand |
Quantity of the product in stock. |
metric |
Quantity Shipped |
Quantity Shipped |
Type the amount or quantity of the product that was shipped for the order. |
dimension |
Quote Line |
Quote Line |
Unique identifier for Quote Line associated with Order Line. |
dimension |
Rating |
Rating |
Select a rating value to indicate the lead’s potential to become a customer. |
metric |
Read Receipt Requested |
Read Receipt Requested |
Indicates that a read receipt is requested. |
dimension |
Record Created On |
Record Created On |
Date and time that the record was migrated. |
dimension |
Relationship Type |
Relationship Type |
Select the category that best describes the relationship between the account and your organization. |
metric |
Reminder Set |
Reminder Set |
For internal use only. Shows whether this email Reminder is Set. |
dimension |
Requested Delivery Date |
Requested Delivery Date |
Enter the delivery date requested by the customer for all products in the order. |
dimension |
Role |
Role |
The contact’s role within the company or sales process, such as decision maker or influencer. |
dimension |
SIC Code |
SIC Code |
Type the Standard Industrial Classification (SIC) code that indicates the lead’s primary industry of business for use in marketing segmentation and demographic analysis. |
dimension |
Sales Stage |
Sales Stage |
Select the sales stage of this lead to aid the sales team in their efforts to convert this lead to an opportunity. |
dimension |
Sales Stage Code |
Sales Stage Code |
Select the sales process stage for the lead to help determine the probability of the lead converting to an opportunity. |
metric |
Salutation |
Salutation |
Type the salutation of the primary contact for this lead to make sure the prospect is addressed correctly in sales calls, email messages, and marketing campaigns. |
dimension |
Schedule Follow Up (Prospect) |
Schedule Follow Up (Prospect) |
Enter the date and time of the prospecting follow-up meeting with the lead. |
dimension |
Schedule Follow Up (Qualify) |
Schedule Follow Up (Qualify) |
Enter the date and time of the qualifying follow-up meeting with the lead. |
dimension |
Scheduled Duration |
Scheduled Duration |
Scheduled duration of the activity, specified in minutes. |
dimension |
Send Later |
Send Later |
Enter the expected date and time when email will be sent. |
dimension |
Send Marketing Materials |
Send Marketing Materials |
Select whether the account accepts marketing materials, such as brochures or catalogs. |
dimension |
Sequence Number |
Sequence Number |
Shows the ID of the data that maintains the sequence. |
dimension |
Shares Outstanding |
Shares Outstanding |
Type the number of shares available to the public for the account. This number is used as an indicator in financial performance analysis. |
dimension |
Ship To |
Ship To |
Select whether the products included in the order should be shipped to the specified address or held until the customer calls with further pick-up or delivery instructions. |
dimension |
Ship To Address |
Ship To Address |
Shows the complete Ship To address. |
dimension |
Ship To Address ID |
Ship To Address ID |
Unique identifier of the shipping address. |
dimension |
Ship To City |
Ship To City |
Type the city for the customer’s shipping address. |
dimension |
Ship To Contact Name |
Ship To Contact Name |
Type the primary contact name at the customer’s shipping address. |
dimension |
Ship To Country/Region |
Ship To Country/Region |
Type the country or region for the customer’s shipping address. |
dimension |
Ship To Fax |
Ship To Fax |
Type the fax number for the customer’s shipping address. |
dimension |
Ship To Freight Terms |
Ship To Freight Terms |
Select the freight terms to make sure shipping orders are processed correctly. |
dimension |
Ship To Name |
Ship To Name |
Type a name for the customer’s shipping address, such as ‘Headquarters’ or ‘Field office’, to identify the address. |
dimension |
Ship To Phone |
Ship To Phone |
Type the phone number for the customer’s shipping address. |
dimension |
Ship To State/Province |
Ship To State/Province |
Type the state or province for the shipping address. |
dimension |
Ship To Street 1 |
Ship To Street 1 |
Type the first line of the customer’s shipping address. |
dimension |
Ship To Street 2 |
Ship To Street 2 |
Type the second line of the customer’s shipping address. |
dimension |
Ship To Street 3 |
Ship To Street 3 |
Type the third line of the shipping address. |
dimension |
Ship To ZIP/Postal Code |
Ship To ZIP/Postal Code |
Type the ZIP Code or postal code for the shipping address. |
dimension |
Ship to Fax |
Ship to Fax |
Type the fax number for the customer’s shipping address. |
dimension |
Shipping Method |
Shipping Method |
Select a shipping method for deliveries sent to this address. |
metric |
Size |
Size |
Product size. |
dimension |
Sort Date |
Sort Date |
Shows the date and time by which the activities are sorted. |
dimension |
Spouse/Partner Name |
Spouse/Partner Name |
The name of the contact’s spouse or partner. |
dimension |
Stage Id |
Stage Id |
Contains the id of the stage where the entity is located (Deprecated). |
dimension |
Standard Cost |
Standard Cost |
Standard cost for the product item. Used in price calculations. |
metric |
Standard Cost (Base) |
Standard Cost (Base) |
Value of the Standard Cost in base currency. |
metric |
Start Date |
Start Date |
Scheduled start time of the activity. |
dimension |
State/Province |
State/Province |
Type the state or province of the primary address. |
dimension |
Status |
Status |
Shows whether the order is active, submitted, fulfilled, canceled, or invoiced. Only active orders can be edited. |
metric |
Status Reason |
Status Reason |
Select the order’s status. |
metric |
Stock Exchange |
Stock Exchange |
Type the stock exchange at which the account is listed to track their stock and financial performance of the company. |
dimension |
Stock Item |
Stock Item |
Information about whether the product is a stock item. |
dimension |
Stock Volume |
Stock Volume |
Stock volume of the product. |
metric |
Stock Weight |
Stock Weight |
Stock weight of the product. |
metric |
Street 1 |
Street 1 |
Type the first line of the primary address. |
dimension |
Street 2 |
Street 2 |
Type the second line of the primary address. |
dimension |
Street 3 |
Street 3 |
Type the third line of the primary address. |
dimension |
Sub-Category |
Sub-Category |
Type a subcategory to identify the email type and relate the activity to a specific product, sales region, business group, or other function. |
dimension |
Subject |
Subject |
Subject associated with the activity. |
dimension |
Submitted By |
Submitted By |
Shows the Microsoft Office Outlook account for the user who submitted the email to Microsoft Dynamics 365. |
dimension |
Submitted Status |
Submitted Status |
Type the code for the submitted status in the fulfillment or shipping center system. |
dimension |
Submitted Status Description |
Submitted Status Description |
Type additional details or notes about the order for the fulfillment or shipping center. |
dimension |
Subscription |
Subscription |
Information related to a recurring service or product agreement. |
dimension |
Suffix |
Suffix |
Type the suffix for the contact’s name, such as Jr. or Sr. |
dimension |
Supplier Name |
Supplier Name |
Name of the product’s supplier. |
dimension |
Tax |
Tax |
Shows the Tax amounts specified on all products included in the order, included in the Total Amount due calculation for the order. |
dimension |
Tax (Base) |
Tax (Base) |
Value of the Total Tax in base currency. |
dimension |
Tax Exempt |
Tax Exempt |
A boolean field indicating if an entity or transaction is exempt from sales tax. |
dimension |
Tax Exempt Number |
Tax Exempt Number |
An identification number used to signify tax-exempt status for a customer or transaction. |
dimension |
Taxable |
Taxable |
A boolean field indicating whether an item or transaction is subject to taxation. |
dimension |
Telephone 3 |
Telephone 3 |
Type a third phone number for this account. |
dimension |
Territory |
Territory |
The sales territory or region associated with the record. |
metric |
Territory Code |
Territory Code |
Select a region or territory for the account for use in segmentation and analysis. |
metric |
Ticker Symbol |
Ticker Symbol |
Type the stock exchange symbol for the account to track financial performance of the company. |
dimension |
Time Zone Rule Version Number |
Time Zone Rule Version Number |
For internal use only. |
dimension |
To Recipients |
To Recipients |
Shows the email addresses corresponding to the recipients. |
dimension |
Topic |
Topic |
Subject associated with the activity. |
dimension |
Total Amount |
Total Amount |
Shows the total amount due, calculated as the sum of the products, discounts, freight, and taxes for the order. |
dimension |
Total Amount (Base) |
Total Amount (Base) |
Value of the Total Amount in base currency. |
dimension |
Total Chargeable Cost |
Total Chargeable Cost |
The aggregate cost that can be billed to a client for services or products. |
dimension |
Total Chargeable Cost (Base) |
Total Chargeable Cost (Base) |
Value of the Total Chargeable Cost in base currency. |
dimension |
Total Chargeable Cost (Last Updated On) |
Total Chargeable Cost (Last Updated On) |
The date and time when the total chargeable cost was last updated. |
dimension |
Total Chargeable Cost (State) |
Total Chargeable Cost (State) |
The current processing state or status of the total chargeable cost. |
dimension |
Total Detail Amount |
Total Detail Amount |
Shows the sum of all existing and write-in products included on the order, based on the specified price list and quantities. |
dimension |
Total Detail Amount (Base) |
Total Detail Amount (Base) |
Value of the Total Detail Amount in base currency. |
dimension |
Total Discount Amount |
Total Discount Amount |
Shows the total discount amount, based on the discount price and rate entered on the order. |
dimension |
Total Discount Amount (Base) |
Total Discount Amount (Base) |
Value of the Total Discount Amount in base currency. |
dimension |
Total Line Item Discount Amount |
Total Line Item Discount Amount |
Shows the total of the Manual Discount amounts specified on all products included in the order. |
dimension |
Total Line Item Discount Amount (Base) |
Total Line Item Discount Amount (Base) |
Value of the Total Line Item Discount Amount in base currency. |
dimension |
Total Non-chargeable Cost |
Total Non-chargeable Cost |
The aggregate cost incurred that cannot be billed to a client. |
dimension |
Total Non-chargeable Cost (Base) |
Total Non-chargeable Cost (Base) |
Value of the Total Non-chargeable Cost in base currency. |
dimension |
Total Non-chargeable Cost (Last Updated On) |
Total Non-chargeable Cost (Last Updated On) |
The date and time when the total non-chargeable cost was last updated. |
dimension |
Total Non-chargeable Cost (State) |
Total Non-chargeable Cost (State) |
The current processing state or status of the total non-chargeable cost. |
dimension |
Total Pre-Freight Amount |
Total Pre-Freight Amount |
Shows the total product amount for the order, minus any discounts. This value is added to freight and tax amounts in the calculation for the total amount due for the order. |
dimension |
Total Pre-Freight Amount (Base) |
Total Pre-Freight Amount (Base) |
Value of the Total Pre-Freight Amount in base currency. |
dimension |
Total Tax |
Total Tax |
Shows the Tax amounts specified on all products included in the order, included in the Total Amount due calculation for the order. |
dimension |
Total Tax (Base) |
Total Tax (Base) |
Value of the Total Tax in base currency. |
dimension |
Trace ID |
Trace ID |
A unique identifier used to track and trace requests or operations through a system. |
dimension |
Tracking Token |
Tracking Token |
Shows the tracking token assigned to the email to make sure responses are automatically tracked in Microsoft Dynamics 365. |
dimension |
Travel Charge |
Travel Charge |
A fee or cost associated with travel to a work site, typically in Field Service. |
dimension |
Travel Charge (Base) |
Travel Charge (Base) |
Value of the Travel Charge in base currency. |
dimension |
Travel Charge Type |
Travel Charge Type |
The method or classification used for calculating travel charges. |
metric |
Type |
Type |
metric |
|
UPC Code |
UPC Code |
The Universal Product Code, a barcode symbology used for tracking trade items. |
dimension |
URL |
URL |
Type the account’s website URL to get quick details about the company profile. |
dimension |
UTC Conversion Time Zone Code |
UTC Conversion Time Zone Code |
Time zone code that was in use when the record was created. |
dimension |
Valid From |
Valid From |
Date from which this product is valid. |
dimension |
Valid To |
Valid To |
Date to which this product is valid. |
dimension |
Vendor |
Vendor |
Name of the product vendor. |
dimension |
Vendor ID |
Vendor ID |
Unique identifier of vendor supplying the product. |
dimension |
Vendor Name |
Vendor Name |
Name of the product vendor. |
dimension |
Version Number |
Version Number |
A system-generated version number for the record, often used for optimistic concurrency control. |
metric |
Volume Discount |
Volume Discount |
The discount applied due to the volume of the purchase. |
dimension |
Volume Discount (Base) |
Volume Discount (Base) |
The base currency equivalent of the volume discount applied. |
dimension |
Website |
Website |
The URL of the website associated with the account or contact. |
dimension |
Work Order Instructions |
Work Order Instructions |
Specific directions or steps to be followed when executing a work order. |
dimension |
Write-In Product |
Write-In Product |
Indicates if the product is a write-in product not found in the product catalog. |
dimension |
Yomi Account Name |
Yomi Account Name |
The phonetic spelling of the account name, used for proper sorting and pronunciation, particularly for East Asian languages. |
dimension |
Yomi Company Name |
Yomi Company Name |
The phonetic spelling of the company name, used for proper sorting and pronunciation. |
dimension |
Yomi First Name |
Yomi First Name |
The phonetic spelling of the first name, used for proper sorting and pronunciation. |
dimension |
Yomi Full Name |
Yomi Full Name |
The phonetic spelling of the full name, used for proper sorting and pronunciation. |
dimension |
Yomi Last Name |
Yomi Last Name |
The phonetic spelling of the last name, used for proper sorting and pronunciation. |
dimension |
Yomi Middle Name |
Yomi Middle Name |
The phonetic spelling of the middle name, used for proper sorting and pronunciation. |
dimension |
ZIP/Postal Code |
ZIP/Postal Code |
The ZIP Code or postal code for the primary address. |
dimension |
_accountid_value |
_accountid_value |
Unique identifier of the associated account record. |
dimension |
_campaignid_value |
_campaignid_value |
Unique identifier (GUID) of the campaign associated with the record. |
dimension |
The display name of the associated campaign. |
dimension |
||
_contactid_value |
_contactid_value |
Unique identifier (GUID) of the contact associated with the record. |
dimension |
_createdby_value |
_createdby_value |
Unique identifier of the user who created the record. This is a lookup field storing the GUID of the creating user. |
dimension |
The formatted display name of the user who created the record, derived from the _createdby_value lookup field. |
dimension |
||
_createdbyexternalparty_value |
_createdbyexternalparty_value |
Unique identifier (GUID) of the external party who created the record. |
dimension |
_createdonbehalfby_value |
_createdonbehalfby_value |
Unique identifier of the user who created the record on behalf of another user. |
dimension |
_createdonbehalfby_value@OData.Community.Display.V1.FormattedValue |
_createdonbehalfby_value@OData.Community.Display.V1.FormattedValue |
The display name of the user on whose behalf the record was created. |
dimension |
_defaultpricelevelid_value |
_defaultpricelevelid_value |
Unique identifier (GUID) of the default price level (price list) associated with the record. |
dimension |
_masterid_value |
_masterid_value |
Unique identifier of the master record this record is related to. This is a lookup field that stores the GUID of the associated record. |
dimension |
The formatted display name of the master record associated through the _masterid_value lookup field. |
dimension |
||
_modifiedby_value |
_modifiedby_value |
Unique identifier of the user who last modified the record. |
dimension |
The formatted display value (name) of the user who last modified the record. |
dimension |
||
_modifiedbyexternalparty_value |
_modifiedbyexternalparty_value |
Unique identifier (GUID) of the external party who last modified the record. |
dimension |
_modifiedonbehalfby_value |
_modifiedonbehalfby_value |
Unique identifier of the delegate user who last modified the record. |
dimension |
_modifiedonbehalfby_value@OData.Community.Display.V1.FormattedValue |
_modifiedonbehalfby_value@OData.Community.Display.V1.FormattedValue |
The formatted display value (name) of the delegate user who last modified the record. |
dimension |
_msdyn_account_value |
_msdyn_account_value |
A lookup field representing the unique identifier (GUID) of a related Account record in Dynamics 365. The connector automatically resolves this to retrieve associated account details. |
dimension |
_msdyn_leadkpiid_value |
_msdyn_leadkpiid_value |
Unique identifier of the associated Lead KPI (Key Performance Indicator) item. This is a lookup field to the msdyn_leadkpiitem entity. |
dimension |
_msdyncrm_fromuser_value |
_msdyncrm_fromuser_value |
Unique identifier of the user who initiated or sent a marketing-related activity or email. |
dimension |
_msdyncrm_fromuser_value@OData.Community.Display.V1.FormattedValue |
_msdyncrm_fromuser_value@OData.Community.Display.V1.FormattedValue |
The formatted display value (name) of the user who initiated or sent a marketing-related activity or email. |
dimension |
_msdyncrm_templateid_value |
_msdyncrm_templateid_value |
Unique identifier of the marketing template used. |
dimension |
_msdyncrm_templateid_value@OData.Community.Display.V1.FormattedValue |
_msdyncrm_templateid_value@OData.Community.Display.V1.FormattedValue |
The formatted display value (name) of the marketing template. |
dimension |
_opportunityid_value |
_opportunityid_value |
Unique identifier (GUID) of the associated opportunity. |
dimension |
_opportunityid_value@OData.Community.Display.V1.FormattedValue |
_opportunityid_value@OData.Community.Display.V1.FormattedValue |
The display name of the associated opportunity. |
dimension |
_organizationid_value |
_organizationid_value |
Unique identifier (GUID) of the organization that owns the record. |
dimension |
_organizationid_value@OData.Community.Display.V1.FormattedValue |
_organizationid_value@OData.Community.Display.V1.FormattedValue |
The display name of the owning organization. |
dimension |
_originatingcaseid_value |
_originatingcaseid_value |
Unique identifier (GUID) of the originating customer service case. |
dimension |
_originatingleadid_value |
_originatingleadid_value |
Unique identifier of the lead from which the account, contact, or opportunity was created. |
dimension |
_originatingleadid_value@OData.Community.Display.V1.FormattedValue |
_originatingleadid_value@OData.Community.Display.V1.FormattedValue |
The formatted display value (name) of the originating lead. |
dimension |
_owningbusinessunit_value |
_owningbusinessunit_value |
Unique identifier of the business unit that owns the record. This is a lookup field storing the GUID of the owning business unit. |
dimension |
_owningbusinessunit_value@OData.Community.Display.V1.FormattedValue |
_owningbusinessunit_value@OData.Community.Display.V1.FormattedValue |
The formatted display name of the business unit that owns the record, derived from the _owningbusinessunit_value lookup field. |
dimension |
_owningteam_value |
_owningteam_value |
Unique identifier of the team that owns the record. |
dimension |
_owninguser_value |
_owninguser_value |
Unique identifier of the user that owns the record. |
dimension |
_parent_contactid_value |
_parent_contactid_value |
Unique identifier of the parent contact record. This is a lookup field that stores the GUID of the associated contact. |
dimension |
_parent_contactid_value@OData.Community.Display.V1.FormattedValue |
_parent_contactid_value@OData.Community.Display.V1.FormattedValue |
The formatted display name of the parent contact associated through the _parent_contactid_value lookup field. |
dimension |
_parentaccountid_value |
_parentaccountid_value |
Unique identifier of the parent account record. This lookup field stores the GUID of the associated account. |
dimension |
_parentaccountid_value@OData.Community.Display.V1.FormattedValue |
_parentaccountid_value@OData.Community.Display.V1.FormattedValue |
The formatted display name of the parent account associated through the _parentaccountid_value lookup field. |
dimension |
_parentcontactid_value |
_parentcontactid_value |
Unique identifier (GUID) of the parent contact for the record. |
dimension |
_parentcontactid_value@OData.Community.Display.V1.FormattedValue |
_parentcontactid_value@OData.Community.Display.V1.FormattedValue |
The display name of the parent contact. |
dimension |
_preferredequipmentid_value |
_preferredequipmentid_value |
Unique identifier (GUID) of the preferred equipment for a service activity or resource. |
dimension |
_preferredserviceid_value |
_preferredserviceid_value |
Unique identifier (GUID) of the preferred service for the record. |
dimension |
_preferredsystemuserid_value |
_preferredsystemuserid_value |
Unique identifier (GUID) of the preferred system user (employee) for the record. |
dimension |
_pricelevelid_value |
_pricelevelid_value |
Unique identifier (GUID) of the price level (price list) associated with the record. |
dimension |
_pricelevelid_value@OData.Community.Display.V1.FormattedValue |
_pricelevelid_value@OData.Community.Display.V1.FormattedValue |
The display name of the associated price level (price list). |
dimension |
_pricelistid_value |
_pricelistid_value |
Unique identifier (GUID) of the price list associated with the record. |
dimension |
_productid_value |
_productid_value |
Unique identifier (GUID) of the associated product. |
dimension |
The display name of the associated product. |
dimension |
||
_qualifyingopportunityid_value |
_qualifyingopportunityid_value |
Unique identifier (GUID) of the qualifying opportunity associated with the record. |
dimension |
_qualifyingopportunityid_value@OData.Community.Display.V1.FormattedValue |
_qualifyingopportunityid_value@OData.Community.Display.V1.FormattedValue |
The display name of the qualifying opportunity. |
dimension |
_quotedetailid_value |
_quotedetailid_value |
Unique identifier (GUID) of the associated quote detail line item. |
dimension |
_quoteid_value |
_quoteid_value |
Unique identifier (GUID) of the associated quote. |
dimension |
_regardingobjectid_value |
_regardingobjectid_value |
Unique identifier (GUID) of the record that the activity is regarding (e.g., account, contact, opportunity). |
dimension |
_regardingobjectid_value@OData.Community.Display.V1.FormattedValue |
_regardingobjectid_value@OData.Community.Display.V1.FormattedValue |
The display name of the record that the activity is regarding. |
dimension |
_relatedobjectid_value |
_relatedobjectid_value |
Unique identifier (GUID) of a related object or record in Dynamics 365, used to establish relationships between entities. |
dimension |
_salesorderid_value |
_salesorderid_value |
Unique identifier (GUID) of the associated sales order. |
dimension |
_salesorderid_value@OData.Community.Display.V1.FormattedValue |
_salesorderid_value@OData.Community.Display.V1.FormattedValue |
The display name of the associated sales order. |
metric |
_salesrepid_value |
_salesrepid_value |
Unique identifier (GUID) of the sales representative associated with the record. |
dimension |
_serviceid_value |
_serviceid_value |
Unique identifier (GUID) of the service associated with the record. |
dimension |
_slaid_value |
_slaid_value |
Unique identifier (GUID) of the Service Level Agreement (SLA) associated with the record. |
dimension |
_slainvokedid_value |
_slainvokedid_value |
Unique identifier (GUID) of the SLA item that was invoked for the record. |
dimension |
_transactioncurrencyid_value |
_transactioncurrencyid_value |
Unique identifier of the transaction currency for the record. This lookup field stores the GUID of the associated currency. |
dimension |
_transactioncurrencyid_value@OData.Community.Display.V1.FormattedValue |
_transactioncurrencyid_value@OData.Community.Display.V1.FormattedValue |
The formatted display name of the transaction currency, such as ‘US Dollar’, derived from the _transactioncurrencyid_value lookup field. |
dimension |
_uomid_value |
_uomid_value |
Unique identifier (GUID) of the unit of measure (UoM) associated with the record. |
dimension |
The display name of the associated unit of measure (UoM). |
dimension |
||
accountid |
accountid |
Unique identifier of the account record. |
dimension |
accountnumber |
accountnumber |
An ID number or code for the account, used for quick searching and identification. |
dimension |
accountrolecode |
accountrolecode |
Selects the contact’s role within an account or sales process, such as a decision maker, employee, or influencer. |
dimension |
activityid |
activityid |
Unique identifier (GUID) of the activity record. |
dimension |
activitytypecode |
activitytypecode |
Type of activity (e.g., Email, Phone Call, Task). |
dimension |
The display name for the activity type (e.g., ‘Email’ for activitytypecode=4202). |
dimension |
||
actualclosedate |
actualclosedate |
The actual date and time when the opportunity or activity was closed. |
dimension |
The formatted display value of the actual close date. |
dimension |
||
actualdurationminutes |
actualdurationminutes |
Actual duration of the activity in minutes. |
metric |
actualdurationminutes@OData.Community.Display.V1.FormattedValue |
actualdurationminutes@OData.Community.Display.V1.FormattedValue |
Formatted display value of the actual duration of the activity. |
dimension |
actualend |
actualend |
Actual end date and time of the activity. |
dimension |
Formatted display value of the actual end date and time of the activity. |
dimension |
||
actualstart |
actualstart |
Actual start date and time of the activity. |
dimension |
Formatted display value of the actual start date and time of the activity. |
dimension |
||
address1_addresstypecode |
address1_addresstypecode |
Type of address for address 1 (e.g., Bill To, Ship To). |
metric |
address1_addresstypecode@OData.Community.Display.V1.FormattedValue |
address1_addresstypecode@OData.Community.Display.V1.FormattedValue |
The display name for the address type of address 1. |
dimension |
address1_city |
address1_city |
City for address 1. |
dimension |
address1_composite |
address1_composite |
A composite field that automatically formats and displays the complete primary address based on its individual street, city, state/province, postal code, and country components. |
dimension |
address1_country |
address1_country |
The country or region component of the primary address. |
dimension |
address1_county |
address1_county |
County for address 1. |
dimension |
address1_fax |
address1_fax |
Fax number for address 1. |
dimension |
address1_freighttermscode |
address1_freighttermscode |
Freight terms for address 1. |
dimension |
address1_latitude |
address1_latitude |
Latitude for address 1, used for mapping and other applications. |
dimension |
address1_line1 |
address1_line1 |
First line of address 1. |
dimension |
address1_line2 |
address1_line2 |
Second line of address 1. |
dimension |
address1_line3 |
address1_line3 |
Third line of address 1. |
dimension |
address1_longitude |
address1_longitude |
Longitude for address 1, used for mapping and other applications. |
dimension |
address1_name |
address1_name |
Descriptive name for address 1 (e.g., ‘Corporate Headquarters’). |
dimension |
address1_postalcode |
address1_postalcode |
ZIP Code or postal code for address 1. |
dimension |
address1_postofficebox |
address1_postofficebox |
Post office box number for address 1. |
dimension |
address1_primarycontactname |
address1_primarycontactname |
Name of the primary contact at address 1. |
dimension |
address1_shippingmethodcode |
address1_shippingmethodcode |
Shipping method for deliveries sent to this address. |
metric |
address1_shippingmethodcode@OData.Community.Display.V1.FormattedValue |
address1_shippingmethodcode@OData.Community.Display.V1.FormattedValue |
The display name for the shipping method of address 1. |
dimension |
address1_stateorprovince |
address1_stateorprovince |
State or province for address 1. |
dimension |
address1_telephone1 |
address1_telephone1 |
Main phone number associated with address 1. |
dimension |
address1_telephone2 |
address1_telephone2 |
Second phone number associated with address 1. |
dimension |
address1_telephone3 |
address1_telephone3 |
Third phone number associated with address 1. |
dimension |
address1_upszone |
address1_upszone |
UPS Zone for address 1. |
dimension |
address1_utcoffset |
address1_utcoffset |
UTC offset for address 1. |
dimension |
address2_addresstypecode |
address2_addresstypecode |
Type of address for address 2. |
metric |
address2_addresstypecode@OData.Community.Display.V1.FormattedValue |
address2_addresstypecode@OData.Community.Display.V1.FormattedValue |
The display name for the address type of address 2. |
dimension |
address2_city |
address2_city |
City for address 2. |
dimension |
address2_composite |
address2_composite |
Complete secondary address. |
dimension |
address2_country |
address2_country |
Country or region for address 2. |
dimension |
address2_county |
address2_county |
County for address 2. |
dimension |
address2_fax |
address2_fax |
Fax number for address 2. |
dimension |
address2_freighttermscode |
address2_freighttermscode |
Freight terms for address 2. |
metric |
address2_freighttermscode@OData.Community.Display.V1.FormattedValue |
address2_freighttermscode@OData.Community.Display.V1.FormattedValue |
The display name for the freight terms of address 2. |
dimension |
address2_latitude |
address2_latitude |
Latitude for address 2, used for mapping and other applications. |
dimension |
address2_line1 |
address2_line1 |
First line of address 2. |
dimension |
address2_line2 |
address2_line2 |
Second line of address 2. |
dimension |
address2_line3 |
address2_line3 |
Third line of address 2. |
dimension |
address2_longitude |
address2_longitude |
Longitude for address 2, used for mapping and other applications. |
dimension |
address2_name |
address2_name |
Descriptive name for address 2. |
dimension |
address2_postalcode |
address2_postalcode |
ZIP Code or postal code for address 2. |
dimension |
address2_postofficebox |
address2_postofficebox |
Post office box number for address 2. |
dimension |
address2_primarycontactname |
address2_primarycontactname |
Name of the primary contact at address 2. |
dimension |
address2_shippingmethodcode |
address2_shippingmethodcode |
Shipping method for deliveries sent to this address. |
metric |
address2_shippingmethodcode@OData.Community.Display.V1.FormattedValue |
address2_shippingmethodcode@OData.Community.Display.V1.FormattedValue |
The display name for the shipping method of address 2. |
dimension |
address2_stateorprovince |
address2_stateorprovince |
State or province for address 2. |
dimension |
address2_telephone1 |
address2_telephone1 |
Main phone number associated with address 2. |
dimension |
address2_telephone2 |
address2_telephone2 |
Second phone number associated with address 2. |
dimension |
address2_telephone3 |
address2_telephone3 |
Third phone number associated with address 2. |
dimension |
address2_upszone |
address2_upszone |
UPS Zone for address 2. |
dimension |
address2_utcoffset |
address2_utcoffset |
UTC offset for address 2. |
dimension |
address3_addresstypecode |
address3_addresstypecode |
Type of address for address 3. |
dimension |
address3_city |
address3_city |
City for address 3. |
dimension |
address3_composite |
address3_composite |
Complete third address. |
dimension |
address3_country |
address3_country |
Country or region for address 3. |
dimension |
address3_county |
address3_county |
County for address 3. |
dimension |
address3_fax |
address3_fax |
Fax number for address 3. |
dimension |
address3_freighttermscode |
address3_freighttermscode |
Freight terms for address 3. |
dimension |
address3_latitude |
address3_latitude |
Latitude for address 3, used for mapping and other applications. |
dimension |
address3_line1 |
address3_line1 |
First line of address 3. |
dimension |
address3_line2 |
address3_line2 |
Second line of address 3. |
dimension |
address3_line3 |
address3_line3 |
Third line of address 3. |
dimension |
address3_longitude |
address3_longitude |
Longitude for address 3, used for mapping and other applications. |
dimension |
address3_name |
address3_name |
Descriptive name for address 3. |
dimension |
address3_postalcode |
address3_postalcode |
ZIP Code or postal code for address 3. |
metric |
address3_postofficebox |
address3_postofficebox |
Post office box number for address 3. |
dimension |
address3_primarycontactname |
address3_primarycontactname |
Name of the primary contact at address 3. |
dimension |
address3_shippingmethodcode |
address3_shippingmethodcode |
Shipping method for deliveries sent to this address. |
dimension |
address3_stateorprovince |
address3_stateorprovince |
State or province for address 3. |
dimension |
address3_telephone1 |
address3_telephone1 |
Main phone number associated with address 3. |
dimension |
address3_telephone2 |
address3_telephone2 |
Second phone number associated with address 3. |
dimension |
address3_telephone3 |
address3_telephone3 |
Third phone number associated with address 3. |
dimension |
address3_upszone |
address3_upszone |
UPS Zone for address 3. |
dimension |
address3_utcoffset |
address3_utcoffset |
UTC offset for address 3. |
dimension |
aging30 |
aging30 |
Value of open invoices that are 30 days overdue. |
dimension |
aging30_base |
aging30_base |
Value of open invoices that are 30 days overdue in the base currency. |
dimension |
aging60 |
aging60 |
Value of open invoices that are 60 days overdue. |
dimension |
aging60_base |
aging60_base |
Value of open invoices that are 60 days overdue in the base currency. |
dimension |
aging90 |
aging90 |
Value of open invoices that are 90 days overdue. |
dimension |
aging90_base |
aging90_base |
Value of open invoices that are 90 days overdue in the base currency. |
dimension |
anniversary |
anniversary |
Date of the anniversary for the record (e.g., account or contact). |
dimension |
Formatted display value of the anniversary date. |
dimension |
||
annualincome |
annualincome |
Annual income of the contact or annual revenue of the account. |
dimension |
annualincome_base |
annualincome_base |
Annual income of the contact or annual revenue of the account in the base currency. |
dimension |
assistantname |
assistantname |
Name of the assistant for the contact or user. |
dimension |
assistantphone |
assistantphone |
Phone number of the assistant for the contact or user. |
dimension |
attachmenterrors |
attachmenterrors |
Indicates if any errors occurred during the processing of attachments. |
metric |
Formatted display value of the attachment errors count. |
dimension |
||
baseamount |
baseamount |
Base amount of the product, opportunity, quote, or order. |
metric |
Formatted display value of the base amount. |
dimension |
||
baseamount_base |
baseamount_base |
Base amount in the base currency. |
metric |
Formatted display value of the base amount in the base currency. |
dimension |
||
billto_city |
billto_city |
City for the ‘Bill To’ address. |
dimension |
billto_composite |
billto_composite |
Complete ‘Bill To’ address. |
dimension |
billto_contactname |
billto_contactname |
Contact name for the ‘Bill To’ address. |
dimension |
billto_country |
billto_country |
Country or region for the ‘Bill To’ address. |
dimension |
billto_fax |
billto_fax |
Fax number for the ‘Bill To’ address. |
dimension |
billto_line1 |
billto_line1 |
First line of the ‘Bill To’ address. |
dimension |
billto_line2 |
billto_line2 |
Second line of the ‘Bill To’ address. |
dimension |
billto_line3 |
billto_line3 |
Third line of the ‘Bill To’ address. |
dimension |
billto_name |
billto_name |
Name for the ‘Bill To’ address. |
dimension |
billto_postalcode |
billto_postalcode |
ZIP Code or postal code for the ‘Bill To’ address. |
dimension |
billto_stateorprovince |
billto_stateorprovince |
State or province for the ‘Bill To’ address. |
dimension |
billto_telephone |
billto_telephone |
Telephone number for the ‘Bill To’ address. |
dimension |
birthdate |
birthdate |
Date of birth for a contact. |
dimension |
Formatted display value of the birthdate. |
dimension |
||
budgetamount |
budgetamount |
Budgeted amount for an opportunity or project. |
dimension |
budgetamount_base |
budgetamount_base |
Budgeted amount in the base currency. |
dimension |
budgetedcost |
budgetedcost |
Budgeted cost for a campaign or project. |
metric |
Formatted display value of the budgeted cost. |
dimension |
||
budgetedcost_base |
budgetedcost_base |
Budgeted cost in the base currency. |
metric |
Formatted display value of the budgeted cost in the base currency. |
dimension |
||
budgetstatus |
budgetstatus |
Status of the budget for an opportunity or project. |
dimension |
callback |
callback |
Scheduled callback date and time for an activity. |
dimension |
campaignid |
campaignid |
Unique identifier of the campaign. |
dimension |
category |
category |
Category of the record. |
dimension |
companyname |
companyname |
The name of the company associated with a lead or contact record. |
dimension |
confirminterest |
confirminterest |
Indicates whether the prospect has confirmed interest in a campaign or offer. |
dimension |
Formatted display value indicating whether interest is confirmed (e.g., ‘Yes’ or ‘No’). |
dimension |
||
contactid |
contactid |
Unique identifier for the contact record. |
dimension |
createdon |
createdon |
Date and time when the record was created. |
dimension |
The formatted display value of the creation date and time, adjusted to the user’s local time zone. |
dimension |
||
creditlimit |
creditlimit |
Credit limit for an account. |
dimension |
creditlimit_base |
creditlimit_base |
Credit limit for an account in the base currency. |
dimension |
creditonhold |
creditonhold |
Indicates if the account’s credit is on hold. |
dimension |
Formatted display value indicating if the credit is on hold (e.g., ‘Yes’ or ‘No’). |
dimension |
||
customersizecode |
customersizecode |
Code indicating the size of the customer. |
metric |
The display name for the customer size. |
dimension |
||
customertypecode |
customertypecode |
Code indicating the type of customer. |
metric |
The display name for the customer type. |
dimension |
||
datefulfilled |
datefulfilled |
Date when the order was fulfilled. |
dimension |
Formatted display value of the order fulfillment date. |
dimension |
||
decisionmaker |
decisionmaker |
Indicates if the contact is a decision maker. |
dimension |
Formatted display value indicating if the contact is a decision maker (e.g., ‘Yes’ or ‘No’). |
dimension |
||
deliveryattempts |
deliveryattempts |
Number of delivery attempts made for an activity. |
metric |
Formatted display value of the number of delivery attempts. |
metric |
||
department |
department |
Department of the contact or user. |
metric |
description |
description |
Description or notes for the record. |
dimension |
discountamount |
discountamount |
Discount amount applied to a product, opportunity, quote, or order. |
metric |
The formatted, user-friendly display value of the discount amount for a record. |
dimension |
||
discountamount_base |
discountamount_base |
The discount amount for the record, expressed in the base currency of the system. |
metric |
discountamount_base@OData.Community.Display.V1.FormattedValue |
discountamount_base@OData.Community.Display.V1.FormattedValue |
The formatted, user-friendly display value of the discount amount in the base currency. |
dimension |
discountpercentage |
discountpercentage |
The percentage of discount applied to the record. |
dimension |
donotbulkemail |
donotbulkemail |
Indicates whether the contact or lead has opted out of bulk emails. |
dimension |
The formatted, user-friendly display value indicating whether the contact or lead has opted out of bulk emails (e.g., Yes/No). |
dimension |
||
donotbulkpostalmail |
donotbulkpostalmail |
Indicates whether the contact or lead has opted out of bulk postal mail. |
dimension |
donotbulkpostalmail@OData.Community.Display.V1.FormattedValue |
donotbulkpostalmail@OData.Community.Display.V1.FormattedValue |
The formatted, user-friendly display value indicating whether the contact or lead has opted out of bulk postal mail (e.g., Yes/No). |
dimension |
donotemail |
donotemail |
Indicates whether the contact or lead has opted out of all emails. |
dimension |
The formatted, user-friendly display value indicating whether the contact or lead has opted out of all emails (e.g., Yes/No). |
dimension |
||
donotfax |
donotfax |
Indicates whether the contact or lead has opted out of faxes. |
dimension |
The formatted, user-friendly display value indicating whether the contact or lead has opted out of faxes (e.g., Yes/No). |
dimension |
||
donotphone |
donotphone |
Indicates whether the contact or lead has opted out of phone calls. |
dimension |
The formatted, user-friendly display value indicating whether the contact or lead has opted out of phone calls (e.g., Yes/No). |
dimension |
||
donotpostalmail |
donotpostalmail |
Indicates whether the contact or lead has opted out of all postal mail. |
dimension |
The formatted, user-friendly display value indicating whether the contact or lead has opted out of all postal mail (e.g., Yes/No). |
dimension |
||
donotsendmm |
donotsendmm |
Indicates whether the contact or lead has opted out of direct marketing materials. |
dimension |
The formatted, user-friendly display value indicating whether the contact or lead has opted out of direct marketing materials (e.g., Yes/No). |
dimension |
||
educationcode |
educationcode |
A code representing the highest level of education attained by a contact or lead. |
metric |
The formatted, user-friendly display value of the education level (e.g., ‘High School’, ‘Some College’, ‘Graduate’). |
dimension |
||
emailaddress |
emailaddress |
The primary email address for the record. |
dimension |
emailaddress1 |
emailaddress1 |
The primary email address for the contact or lead. |
dimension |
emailaddress2 |
emailaddress2 |
A secondary email address for the record. |
dimension |
emailaddress3 |
emailaddress3 |
A third email address for the record. |
dimension |
employeeid |
employeeid |
The employee identifier for a contact, if applicable. |
dimension |
estimatedamount |
estimatedamount |
The estimated revenue amount for an opportunity or order. |
dimension |
estimatedamount_base |
estimatedamount_base |
The estimated revenue amount for an opportunity or order, expressed in the base currency. |
dimension |
estimatedclosedate |
estimatedclosedate |
The estimated date when an opportunity or order is expected to close. |
dimension |
estimatedvalue |
estimatedvalue |
The estimated monetary value of a lead or opportunity. |
dimension |
evaluatefit |
evaluatefit |
Indicates whether the lead or opportunity needs to be evaluated for its suitability. |
dimension |
The formatted, user-friendly display value indicating whether the lead or opportunity needs to be evaluated for its suitability (e.g., Yes/No). |
dimension |
||
exchangerate |
exchangerate |
Exchange rate for the transaction currency associated with the record with respect to the base currency. |
metric |
The formatted display value of the exchange rate. |
metric |
||
expectedresponse |
expectedresponse |
A code representing the expected response for a marketing campaign or activity. |
metric |
The formatted, user-friendly display value of the expected response for a marketing campaign or activity. |
metric |
||
expectedrevenue |
expectedrevenue |
The projected revenue for an opportunity. |
metric |
The formatted, user-friendly display value of the projected revenue for an opportunity. |
dimension |
||
expectedrevenue_base |
expectedrevenue_base |
The projected revenue for an opportunity, expressed in the base currency. |
metric |
expectedrevenue_base@OData.Community.Display.V1.FormattedValue |
expectedrevenue_base@OData.Community.Display.V1.FormattedValue |
The formatted, user-friendly display value of the projected revenue for an opportunity in the base currency. |
dimension |
extendedamount |
extendedamount |
The extended amount for a line item in an order or opportunity. |
metric |
The formatted, user-friendly display value of the extended amount for a line item. |
dimension |
||
extendedamount_base |
extendedamount_base |
The extended amount for a line item, expressed in the base currency. |
metric |
extendedamount_base@OData.Community.Display.V1.FormattedValue |
extendedamount_base@OData.Community.Display.V1.FormattedValue |
The formatted, user-friendly display value of the extended amount for a line item in the base currency. |
dimension |
externaluseridentifier |
externaluseridentifier |
An identifier for the user from an external system. |
dimension |
familystatuscode |
familystatuscode |
A code representing the marital or family status of a contact. |
metric |
The formatted, user-friendly display value of the family status (e.g., ‘Single’, ‘Married’). |
dimension |
||
fax |
fax |
The fax number for the record. |
dimension |
firstname |
firstname |
The first name of the contact or lead. |
dimension |
followemail |
followemail |
Indicates whether the email allows tracking of recipient activities (e.g., opens, clicks). |
dimension |
The formatted, user-friendly display value indicating whether email recipient activities are tracked (e.g., Yes/No). |
dimension |
||
formattedscheduledend |
formattedscheduledend |
The formatted, user-friendly display value of the scheduled end date and time of an activity. |
dimension |
formattedscheduledstart |
formattedscheduledstart |
The formatted, user-friendly display value of the scheduled start date and time of an activity. |
dimension |
freightamount |
freightamount |
The freight charge amount for an order. |
metric |
The formatted, user-friendly display value of the freight charge amount for an order. |
dimension |
||
freightamount_base |
freightamount_base |
The freight charge amount for an order, expressed in the base currency. |
metric |
freightamount_base@OData.Community.Display.V1.FormattedValue |
freightamount_base@OData.Community.Display.V1.FormattedValue |
The formatted, user-friendly display value of the freight charge amount for an order in the base currency. |
dimension |
freighttermscode |
freighttermscode |
A code indicating the freight terms for an order or shipment. |
dimension |
ftpsiteurl |
ftpsiteurl |
The URL of an FTP site associated with the record. |
dimension |
fullname |
fullname |
Combines and displays the contact’s or lead’s first and last names. This is often a read-only, composite field. |
dimension |
gendercode |
gendercode |
A code representing the gender of a contact or lead. |
metric |
The formatted, user-friendly display value of the gender (e.g., ‘Male’, ‘Female’). |
dimension |
||
globalobjectid |
globalobjectid |
dimension |
|
governmentid |
governmentid |
A government-issued identification number for a contact. |
dimension |
haschildrencode |
haschildrencode |
A code indicating whether a contact has children. |
metric |
The formatted, user-friendly display value indicating whether a contact has children (e.g., Yes/No). |
dimension |
||
home2 |
home2 |
A secondary home phone number for a contact. |
dimension |
importsequencenumber |
importsequencenumber |
Unique identifier of the data import or data migration that created this record. |
dimension |
importsequencenumber@OData.Community.Display.V1.FormattedValue |
importsequencenumber@OData.Community.Display.V1.FormattedValue |
The formatted, user-friendly display value of the sequence number for data import that created this record. |
metric |
industrycode |
industrycode |
A code representing the industry of an account or contact’s organization. |
dimension |
initialcommunication |
initialcommunication |
The initial method of communication with a contact or lead. |
dimension |
instancetypecode |
instancetypecode |
A code representing the type of instance for a recurring activity (e.g., Single, Recurring Master, Recurring Exception). |
metric |
The formatted, user-friendly display value of the instance type for a recurring activity. |
dimension |
||
isalldayevent |
isalldayevent |
Indicates whether an appointment or activity is an all-day event. |
dimension |
The formatted, user-friendly display value indicating whether an appointment or activity is an all-day event (e.g., Yes/No). |
dimension |
||
isbackofficecustomer |
isbackofficecustomer |
Indicates whether the customer is managed in a back-office system. |
dimension |
isbackofficecustomer@OData.Community.Display.V1.FormattedValue |
isbackofficecustomer@OData.Community.Display.V1.FormattedValue |
The formatted, user-friendly display value indicating whether the customer is managed in a back-office system (e.g., Yes/No). |
dimension |
isbilled |
isbilled |
Indicates whether an activity has been billed as part of a case resolution. |
dimension |
The formatted, user-friendly display value indicating whether an activity has been billed (e.g., Yes/No). |
dimension |
||
iscopied |
iscopied |
Indicates whether the email activity is a copy. |
dimension |
The formatted, user-friendly display value indicating whether the email activity is a copy (e.g., Yes/No). |
dimension |
||
isdraft |
isdraft |
Indicates whether the record is currently in a draft state. |
dimension |
The formatted, user-friendly display value indicating whether the record is in draft state (e.g., Yes/No). |
dimension |
||
ismapiprivate |
ismapiprivate |
For internal use, indicates if the email activity is private (MAPI private property). |
dimension |
The formatted, user-friendly display value indicating if the email activity is private (e.g., Yes/No). |
dimension |
||
isonlinemeeting |
isonlinemeeting |
Indicates whether the appointment is an online meeting. |
dimension |
The formatted, user-friendly display value indicating whether the appointment is an online meeting (e.g., Yes/No). |
dimension |
||
ispricelocked |
ispricelocked |
Indicates whether the pricing for the order or opportunity is locked. |
dimension |
The formatted, user-friendly display value indicating whether the pricing is locked (e.g., Yes/No). |
dimension |
||
ispriceoverridden |
ispriceoverridden |
Indicates whether the price for a product or service has been manually overridden. |
dimension |
The formatted, user-friendly display value indicating whether the price has been manually overridden (e.g., Yes/No). |
dimension |
||
isproductoverridden |
isproductoverridden |
Indicates whether the products for an order or opportunity have been manually overridden. |
dimension |
isproductoverridden@OData.Community.Display.V1.FormattedValue |
isproductoverridden@OData.Community.Display.V1.FormattedValue |
The formatted, user-friendly display value indicating whether the products have been manually overridden (e.g., Yes/No). |
dimension |
isregularactivity |
isregularactivity |
Indicates whether the activity is a regular activity type or an event type. |
dimension |
The formatted, user-friendly display value indicating whether the activity is a regular type or an event type (e.g., Yes/No). |
dimension |
||
istemplate |
istemplate |
Indicates whether the record is a template. |
dimension |
The formatted, user-friendly display value indicating whether the record is a template (e.g., Yes/No). |
dimension |
||
isunsafe |
isunsafe |
For internal use, indicates whether an email is considered unsafe. |
metric |
The formatted, user-friendly display value indicating whether an email is considered unsafe (e.g., Yes/No). |
metric |
||
isworkflowcreated |
isworkflowcreated |
Indicates whether the activity was created from a workflow rule. |
dimension |
The formatted, user-friendly display value indicating whether the activity was created from a workflow rule (e.g., Yes/No). |
dimension |
||
jobtitle |
jobtitle |
The job title of the contact or lead. |
dimension |
lastbackofficesubmit |
lastbackofficesubmit |
The date and time when the record was last submitted to a back-office system. |
dimension |
lastname |
lastname |
The last name of the contact or lead. |
dimension |
lastonholdtime |
lastonholdtime |
The date and time when the record was last placed on hold. |
dimension |
lastopenedtime |
lastopenedtime |
The latest date and time when an email was opened. |
dimension |
The formatted, user-friendly display value of the latest date and time when an email was opened. |
dimension |
||
lastusedincampaign |
lastusedincampaign |
The date and time when the record was last used in a marketing campaign. |
dimension |
lastusedincampaign@OData.Community.Display.V1.FormattedValue |
lastusedincampaign@OData.Community.Display.V1.FormattedValue |
The formatted, user-friendly display value of the date and time when the record was last used in a marketing campaign. |
dimension |
leadid |
leadid |
Unique identifier of the lead record. |
dimension |
leadqualitycode |
leadqualitycode |
Code indicating the quality of the lead. |
metric |
The formatted display name of the lead quality code (e.g., Hot, Warm, Cold). |
dimension |
||
leadsourcecode |
leadsourcecode |
A code representing the source from which the lead was generated. |
metric |
The formatted, user-friendly display value of the lead source (e.g., ‘Web’, ‘Referral’, ‘Advertisement’). |
dimension |
||
lineitemnumber |
lineitemnumber |
The line item number for an order or quote product. |
dimension |
linksclickedcount |
linksclickedcount |
The number of times a link in an email has been clicked. |
metric |
The formatted, user-friendly display value of the number of times a link in an email has been clicked. |
metric |
||
location |
location |
The physical location associated with an activity or record. |
dimension |
managername |
managername |
The name of the manager for a contact. |
dimension |
managerphone |
managerphone |
The phone number of the manager for a contact. |
dimension |
manualdiscountamount |
manualdiscountamount |
The total amount of any manual discount applied to an order or line item. |
dimension |
manualdiscountamount_base |
manualdiscountamount_base |
The total amount of any manual discount applied to an order or line item, expressed in the base currency. |
dimension |
marketingonly |
marketingonly |
Indicates whether the contact is for marketing purposes only. |
dimension |
The formatted, user-friendly display value indicating whether the contact is for marketing purposes only (e.g., Yes/No). |
dimension |
||
merged |
merged |
Indicates whether the record has been merged with another record. |
dimension |
The formatted, user-friendly display value indicating whether the record has been merged (e.g., Yes/No). |
dimension |
||
message |
message |
The content or body of a message or email. |
dimension |
middlename |
middlename |
The middle name of the contact or lead. |
dimension |
mobilephone |
mobilephone |
The mobile phone number for the record. |
dimension |
modifiedfieldsmask |
modifiedfieldsmask |
An internal system field used to track which fields of a record were modified during an update operation. |
dimension |
modifiedon |
modifiedon |
Date and time when the record was last modified. |
dimension |
The formatted display value of the last modification date and time, adjusted to the user’s local time zone. |
dimension |
||
msdyn_acilastupdatetimestamp |
msdyn_acilastupdatetimestamp |
Timestamp of the last update related to Agent Conversation Intelligence (ACI) or a similar Dynamics 365 solution feature. |
dimension |
msdyn_averagefirstresponsetimebytheminhrs |
msdyn_averagefirstresponsetimebytheminhrs |
The average first response time in minutes or hours, typically measured for customer interactions. |
metric |
msdyn_averagefirstresponsetimebytheminhrs@OData.Community.Display.V1.FormattedValue |
msdyn_averagefirstresponsetimebytheminhrs@OData.Community.Display.V1.FormattedValue |
The formatted string value of the average first response time by the recipient in minutes or hours. |
metric |
msdyn_averagefirstresponsetimebyusinhrs |
msdyn_averagefirstresponsetimebyusinhrs |
The average first response time in minutes or hours, specifically from the perspective of the Dynamics 365 user or team. |
metric |
msdyn_averagefirstresponsetimebyusinhrs@OData.Community.Display.V1.FormattedValue |
msdyn_averagefirstresponsetimebyusinhrs@OData.Community.Display.V1.FormattedValue |
The formatted string value of the average first response time by the user or team in minutes or hours. |
metric |
msdyn_computationaccuracy |
msdyn_computationaccuracy |
A metric indicating the accuracy of a computation within a Dynamics 365 application or solution. |
metric |
msdyn_computationaccuracy@OData.Community.Display.V1.FormattedValue |
msdyn_computationaccuracy@OData.Community.Display.V1.FormattedValue |
The formatted string value of the computation accuracy. |
dimension |
msdyn_datainsightsandanalyticsfeatureid |
msdyn_datainsightsandanalyticsfeatureid |
The unique identifier (GUID) for a specific data insights and analytics feature record within Dynamics 365. This field serves as the primary key for the msdyn_datainsightsandanalyticsfeature entity. |
dimension |
msdyn_date |
msdyn_date |
A date field used within a specific Dynamics 365 solution for various date-related tracking. |
dimension |
msdyn_decisioninfluencetag |
msdyn_decisioninfluencetag |
A tag used to categorize factors that influenced a decision, often in sales or marketing contexts. |
dimension |
msdyn_disablewebtracking |
msdyn_disablewebtracking |
Indicates whether web tracking is disabled for a contact, respecting privacy preferences. |
dimension |
msdyn_disablewebtracking@OData.Community.Display.V1.FormattedValue |
msdyn_disablewebtracking@OData.Community.Display.V1.FormattedValue |
The formatted string value (e.g., ‘Yes’ or ‘No’) indicating if web tracking is disabled. |
dimension |
msdyn_emailattachmentopens |
msdyn_emailattachmentopens |
The number of times attachments in an email have been opened or viewed. |
metric |
msdyn_emailattachmentopens@OData.Community.Display.V1.FormattedValue |
msdyn_emailattachmentopens@OData.Community.Display.V1.FormattedValue |
The formatted string value of the email attachment open count. |
metric |
msdyn_emailengagementinteractions |
msdyn_emailengagementinteractions |
Aggregated data on interactions with email engagement features. |
dimension |
msdyn_emaillinksclicked |
msdyn_emaillinksclicked |
The number of times links embedded within an email have been clicked. |
metric |
msdyn_emaillinksclicked@OData.Community.Display.V1.FormattedValue |
msdyn_emaillinksclicked@OData.Community.Display.V1.FormattedValue |
The formatted string value of the email links clicked count. |
metric |
msdyn_emailsreceived |
msdyn_emailsreceived |
The total number of emails received for a specific record or entity. |
metric |
msdyn_emailsreceived@OData.Community.Display.V1.FormattedValue |
msdyn_emailsreceived@OData.Community.Display.V1.FormattedValue |
The formatted string value of the number of emails received. |
metric |
msdyn_emailssent |
msdyn_emailssent |
The total number of emails sent from a specific record or entity. |
metric |
The formatted string value of the number of emails sent. |
metric |
||
msdyn_facetimewithcustomer |
msdyn_facetimewithcustomer |
Indicates whether a video call interaction (e.g., FaceTime) occurred with a customer. |
metric |
msdyn_facetimewithcustomer@OData.Community.Display.V1.FormattedValue |
msdyn_facetimewithcustomer@OData.Community.Display.V1.FormattedValue |
The formatted string value (e.g., ‘Yes’ or ‘No’) indicating if a video call occurred with a customer. |
metric |
msdyn_gdproptout |
msdyn_gdproptout |
Indicates if a contact or product is opted out of GDPR (General Data Protection Regulation) data processing. |
dimension |
The formatted string value (e.g., ‘Yes’ or ‘No’) indicating GDPR opt-out status. |
dimension |
||
msdyn_isassistantinorgchart |
msdyn_isassistantinorgchart |
Indicates if a person is designated as an assistant within an organizational chart structure. |
dimension |
msdyn_isassistantinorgchart@OData.Community.Display.V1.FormattedValue |
msdyn_isassistantinorgchart@OData.Community.Display.V1.FormattedValue |
The formatted string value (e.g., ‘Yes’ or ‘No’) indicating if the person is an assistant in the organizational chart. |
dimension |
msdyn_isminor |
msdyn_isminor |
Indicates if a contact is considered a minor. |
dimension |
The formatted string value (e.g., ‘Yes’ or ‘No’) indicating if the contact is a minor. |
dimension |
||
msdyn_isminorwithparentalconsent |
msdyn_isminorwithparentalconsent |
Indicates if a contact, identified as a minor, has parental consent for data processing or engagement. |
dimension |
msdyn_isminorwithparentalconsent@OData.Community.Display.V1.FormattedValue |
msdyn_isminorwithparentalconsent@OData.Community.Display.V1.FormattedValue |
The formatted string value (e.g., ‘Yes’ or ‘No’) indicating if the minor has parental consent. |
dimension |
msdyn_isocurrencycode |
msdyn_isocurrencycode |
The ISO currency code used in a Microsoft Dynamics 365 solution. |
dimension |
msdyn_lastactivitybyteam |
msdyn_lastactivitybyteam |
The timestamp of the most recent activity performed by a team. |
dimension |
msdyn_lastactivitydirection |
msdyn_lastactivitydirection |
The direction (e.g., incoming or outgoing) of the last activity recorded for a team. |
dimension |
msdyn_lastactivityid |
msdyn_lastactivityid |
Unique identifier of the last activity associated with the record. |
dimension |
msdyn_lastactivitytype |
msdyn_lastactivitytype |
Type of the last activity associated with the record (e.g., email, phone call, appointment). |
dimension |
msdyn_leadgrade |
msdyn_leadgrade |
The grade assigned to a lead, indicating its quality or potential. |
dimension |
msdyn_leadkpiitemid |
msdyn_leadkpiitemid |
Unique identifier for a Key Performance Indicator (KPI) item related to lead scoring. |
dimension |
msdyn_leadscore |
msdyn_leadscore |
The calculated score for a lead, indicating its engagement and potential. |
dimension |
msdyn_leadscoretrend |
msdyn_leadscoretrend |
Indicates the trend of the lead score (e.g., increasing, decreasing, stable). |
dimension |
msdyn_liemailssent |
msdyn_liemailssent |
The total number of LinkedIn emails sent to or from the record. |
metric |
msdyn_liemailssent@OData.Community.Display.V1.FormattedValue |
msdyn_liemailssent@OData.Community.Display.V1.FormattedValue |
Formatted value of the total number of LinkedIn emails sent. |
metric |
msdyn_meetingsreceived |
msdyn_meetingsreceived |
The total number of meetings received by or associated with the record. |
metric |
msdyn_meetingsreceived@OData.Community.Display.V1.FormattedValue |
msdyn_meetingsreceived@OData.Community.Display.V1.FormattedValue |
Formatted value of the total number of meetings received. |
metric |
msdyn_meetingssent |
msdyn_meetingssent |
The total number of meetings sent from or associated with the record. |
metric |
msdyn_meetingssent@OData.Community.Display.V1.FormattedValue |
msdyn_meetingssent@OData.Community.Display.V1.FormattedValue |
Formatted value of the total number of meetings sent. |
metric |
msdyn_name |
msdyn_name |
The name or title of a record within a specific Dynamics 365 solution. |
dimension |
msdyn_nextactivitybyteam |
msdyn_nextactivitybyteam |
The scheduled timestamp for the next activity involving a team. |
dimension |
msdyn_nextactivitydirection |
msdyn_nextactivitydirection |
The direction (e.g., incoming or outgoing) of the next scheduled activity for a team. |
dimension |
msdyn_nextactivityid |
msdyn_nextactivityid |
Unique identifier of the next scheduled activity associated with the record. |
dimension |
msdyn_nextactivitytype |
msdyn_nextactivitytype |
Type of the next activity scheduled for the record. |
dimension |
msdyn_openedemails |
msdyn_openedemails |
The total number of emails opened by or for the record. |
metric |
msdyn_openedemails@OData.Community.Display.V1.FormattedValue |
msdyn_openedemails@OData.Community.Display.V1.FormattedValue |
Formatted value of the total number of opened emails. |
metric |
msdyn_orgchangestatus |
msdyn_orgchangestatus |
The organizational change status for an account or contact. |
metric |
msdyn_orgchangestatus@OData.Community.Display.V1.FormattedValue |
msdyn_orgchangestatus@OData.Community.Display.V1.FormattedValue |
Formatted value of the organizational change status. |
dimension |
msdyn_phonecallsmade |
msdyn_phonecallsmade |
The total number of phone calls made to or from the record. |
metric |
msdyn_phonecallsmade@OData.Community.Display.V1.FormattedValue |
msdyn_phonecallsmade@OData.Community.Display.V1.FormattedValue |
Formatted value of the total number of phone calls made. |
metric |
msdyn_phonecallsreceived |
msdyn_phonecallsreceived |
The total number of phone calls received by or for the record. |
metric |
msdyn_phonecallsreceived@OData.Community.Display.V1.FormattedValue |
msdyn_phonecallsreceived@OData.Community.Display.V1.FormattedValue |
Formatted value of the total number of phone calls received. |
metric |
msdyn_portaltermsagreementdate |
msdyn_portaltermsagreementdate |
The date when a contact accepted the terms and conditions for the portal. |
dimension |
msdyn_primarytimezone |
msdyn_primarytimezone |
Indicates the primary time zone in which the contact or client operates. |
dimension |
msdyn_relationshiphealthscorestate |
msdyn_relationshiphealthscorestate |
The current state or status of the relationship health score. |
metric |
msdyn_relationshiphealthscorestate@OData.Community.Display.V1.FormattedValue |
msdyn_relationshiphealthscorestate@OData.Community.Display.V1.FormattedValue |
Formatted value of the relationship health score state. |
dimension |
msdyn_relationshiphealthscorevalue |
msdyn_relationshiphealthscorevalue |
The numerical value representing the health of a relationship. |
metric |
msdyn_relationshiphealthscorevalue@OData.Community.Display.V1.FormattedValue |
msdyn_relationshiphealthscorevalue@OData.Community.Display.V1.FormattedValue |
Formatted value of the relationship health score. |
metric |
msdyn_relationshiphealthtrend |
msdyn_relationshiphealthtrend |
Indicates the trend of the relationship health (e.g., improving, declining, stable). |
metric |
msdyn_relationshiphealthtrend@OData.Community.Display.V1.FormattedValue |
msdyn_relationshiphealthtrend@OData.Community.Display.V1.FormattedValue |
Formatted value of the relationship health trend. |
dimension |
msdyn_responseratebythem |
msdyn_responseratebythem |
A metric representing the response rate from the customer or recipient. |
metric |
msdyn_responseratebythem@OData.Community.Display.V1.FormattedValue |
msdyn_responseratebythem@OData.Community.Display.V1.FormattedValue |
Formatted value of the response rate by the customer or external party. |
metric |
msdyn_responseratebyus |
msdyn_responseratebyus |
A metric representing the response rate from the perspective of the Dynamics 365 user or team. |
metric |
msdyn_responseratebyus@OData.Community.Display.V1.FormattedValue |
msdyn_responseratebyus@OData.Community.Display.V1.FormattedValue |
Formatted value of the response rate by the organization or internal team. |
metric |
msdyn_salesassignmentresult |
msdyn_salesassignmentresult |
The result or outcome of a sales assignment. |
dimension |
msdyn_scorehistory |
msdyn_scorehistory |
Historical data of lead or other scores over time. |
dimension |
msdyn_scorereasons |
msdyn_scorereasons |
The reasons or factors that influenced the lead or other scores. |
dimension |
msdyn_timespentbycustomer |
msdyn_timespentbycustomer |
A metric tracking the total time a customer has spent on interactions. |
dimension |
msdyn_timespentbycustomer_calculated |
msdyn_timespentbycustomer_calculated |
Calculated value of the total time spent by the customer. |
dimension |
msdyn_timespentbyteam |
msdyn_timespentbyteam |
A metric tracking the total time a team has spent on interactions. |
metric |
msdyn_timespentbyteam@OData.Community.Display.V1.FormattedValue |
msdyn_timespentbyteam@OData.Community.Display.V1.FormattedValue |
Formatted value of the total time spent by the internal team. |
metric |
msdyn_timespentbyteam_calculated |
msdyn_timespentbyteam_calculated |
Calculated value of the total time spent by the internal team. |
metric |
msdyn_timespentbyteam_calculated@OData.Community.Display.V1.FormattedValue |
msdyn_timespentbyteam_calculated@OData.Community.Display.V1.FormattedValue |
Formatted value of the calculated total time spent by the internal team. |
metric |
msdyncrm_activityid |
msdyncrm_activityid |
Unique identifier for a CRM activity record. |
dimension |
msdyncrm_code |
msdyncrm_code |
A custom code or identifier defined within the CRM system. |
dimension |
msdyncrm_companysize |
msdyncrm_companysize |
A custom field representing the size of a company. |
dimension |
msdyncrm_contactid |
msdyncrm_contactid |
Unique identifier for a contact record. |
dimension |
msdyncrm_customerjourneyid |
msdyncrm_customerjourneyid |
Unique identifier for the customer journey in Dynamics 365 Marketing. |
dimension |
msdyncrm_degree |
msdyncrm_degree |
A custom field for recording an educational degree. |
dimension |
msdyncrm_description |
msdyncrm_description |
A description of the marketing-related record or activity. |
dimension |
msdyncrm_designerhtml |
msdyncrm_designerhtml |
HTML content designed for marketing emails or web pages within Dynamics 365. This field captures the visual layout and text of customer-facing communications. |
dimension |
msdyncrm_email_contenttype |
msdyncrm_email_contenttype |
The content type of the marketing email (e.g., HTML, plain text). |
metric |
msdyncrm_email_contenttype@OData.Community.Display.V1.FormattedValue |
msdyncrm_email_contenttype@OData.Community.Display.V1.FormattedValue |
The formatted display value of the marketing email content type. |
dimension |
msdyncrm_emailbody |
msdyncrm_emailbody |
The main textual or HTML content of an email record, as sent or received within Dynamics 365. |
dimension |
msdyncrm_enddatetime |
msdyncrm_enddatetime |
The scheduled end date and time for a marketing activity or customer journey. |
dimension |
msdyncrm_enddatetime@OData.Community.Display.V1.FormattedValue |
msdyncrm_enddatetime@OData.Community.Display.V1.FormattedValue |
The formatted display value of the marketing end date and time. |
dimension |
msdyncrm_fieldofstudy |
msdyncrm_fieldofstudy |
A custom field for recording a field of study or specialization. |
dimension |
msdyncrm_formtosave |
msdyncrm_formtosave |
Unique identifier for the marketing form used to save data. |
dimension |
msdyncrm_formtosave@OData.Community.Display.V1.FormattedValue |
msdyncrm_formtosave@OData.Community.Display.V1.FormattedValue |
The formatted display value (name) of the marketing form used to save data. |
dimension |
msdyncrm_fromemail |
msdyncrm_fromemail |
The sender’s email address for a marketing email. |
dimension |
msdyncrm_fromname |
msdyncrm_fromname |
The sender’s name for a marketing email. |
dimension |
msdyncrm_graduationdate |
msdyncrm_graduationdate |
A custom field for recording a graduation date. |
dimension |
msdyncrm_industry |
msdyncrm_industry |
A custom field to specify the industry of a company or contact. |
dimension |
msdyncrm_insights_placeholder |
msdyncrm_insights_placeholder |
A placeholder field typically used for displaying insights generated by CRM analytics or custom logic. |
dimension |
msdyncrm_istemplategalleryneeded |
msdyncrm_istemplategalleryneeded |
Indicates whether a template gallery is required for the creation or editing of a marketing item. |
dimension |
msdyncrm_istemplategalleryneeded@OData.Community.Display.V1.FormattedValue |
msdyncrm_istemplategalleryneeded@OData.Community.Display.V1.FormattedValue |
The formatted display value (Yes/No) indicating if a template gallery is needed. |
dimension |
msdyncrm_jobfunction |
msdyncrm_jobfunction |
A custom field for recording a job function or role. |
dimension |
msdyncrm_latestsubmissiondate |
msdyncrm_latestsubmissiondate |
A custom field to record the most recent submission date. |
dimension |
msdyncrm_leadid |
msdyncrm_leadid |
The unique identifier (GUID) for a Lead record in Dynamics 365. This field serves as the primary key for the Lead entity. |
dimension |
msdyncrm_leadsourcetype |
msdyncrm_leadsourcetype |
The type of source from which a lead originated. |
metric |
msdyncrm_leadsourcetype@OData.Community.Display.V1.FormattedValue |
msdyncrm_leadsourcetype@OData.Community.Display.V1.FormattedValue |
Formatted value of the lead source type. |
dimension |
msdyncrm_linkedinsubmissioncount |
msdyncrm_linkedinsubmissioncount |
The total number of submissions associated with LinkedIn interactions. |
metric |
msdyncrm_linkedinsubmissioncount@OData.Community.Display.V1.FormattedValue |
msdyncrm_linkedinsubmissioncount@OData.Community.Display.V1.FormattedValue |
Formatted value of the LinkedIn submission count. |
metric |
msdyncrm_linkedinsubmissioncount_date |
msdyncrm_linkedinsubmissioncount_date |
The date associated with the LinkedIn submission count. |
dimension |
msdyncrm_linkedinsubmissioncount_date@OData.Community.Display.V1.FormattedValue |
msdyncrm_linkedinsubmissioncount_date@OData.Community.Display.V1.FormattedValue |
Formatted value of the date associated with the LinkedIn submission count. |
dimension |
msdyncrm_linkedinsubmissioncount_state |
msdyncrm_linkedinsubmissioncount_state |
The state or status related to the LinkedIn submission count. |
metric |
msdyncrm_linkedinsubmissioncount_state@OData.Community.Display.V1.FormattedValue |
msdyncrm_linkedinsubmissioncount_state@OData.Community.Display.V1.FormattedValue |
Formatted value of the state related to the LinkedIn submission count. |
metric |
msdyncrm_marketingemailid |
msdyncrm_marketingemailid |
Unique identifier for the marketing email record in Dynamics 365 Marketing. |
dimension |
msdyncrm_marketingformsubmissiondateprecise |
msdyncrm_marketingformsubmissiondateprecise |
The precise date and time when a marketing form was submitted. |
dimension |
msdyncrm_messagedesignation |
msdyncrm_messagedesignation |
The designation or purpose of the marketing message (e.g., commercial, transactional). |
metric |
msdyncrm_messagedesignation@OData.Community.Display.V1.FormattedValue |
msdyncrm_messagedesignation@OData.Community.Display.V1.FormattedValue |
The formatted display value of the marketing message designation. |
dimension |
msdyncrm_name |
msdyncrm_name |
The name or title of the marketing-related record. |
dimension |
msdyncrm_previewhtml |
msdyncrm_previewhtml |
The HTML content used for previewing the marketing email. |
dimension |
msdyncrm_previewtext |
msdyncrm_previewtext |
The plain text content used for previewing the marketing email. |
dimension |
msdyncrm_profileid |
msdyncrm_profileid |
A custom identifier for a profile within the CRM system. |
dimension |
msdyncrm_purchaseneed |
msdyncrm_purchaseneed |
Indicates the specific purchasing need or requirement of a lead or contact. |
dimension |
msdyncrm_purchaseneed@OData.Community.Display.V1.FormattedValue |
msdyncrm_purchaseneed@OData.Community.Display.V1.FormattedValue |
Formatted value of the purchase need. |
dimension |
msdyncrm_recycled |
msdyncrm_recycled |
Indicates if a lead or other record has been recycled for re-engagement. |
dimension |
Formatted value indicating if a record has been recycled. |
dimension |
||
msdyncrm_rememberme |
msdyncrm_rememberme |
A custom boolean field indicating whether ‘remember me’ functionality is enabled. |
dimension |
msdyncrm_rememberme@OData.Community.Display.V1.FormattedValue |
msdyncrm_rememberme@OData.Community.Display.V1.FormattedValue |
Formatted value of the ‘remember me’ preference. |
dimension |
msdyncrm_replytoemail |
msdyncrm_replytoemail |
The email address to which replies for the marketing email should be sent. |
dimension |
msdyncrm_salesaccepted |
msdyncrm_salesaccepted |
Indicates whether a lead or opportunity has been accepted by the sales team. |
dimension |
msdyncrm_salesaccepted@OData.Community.Display.V1.FormattedValue |
msdyncrm_salesaccepted@OData.Community.Display.V1.FormattedValue |
Formatted value indicating if a lead or opportunity has been sales accepted. |
dimension |
msdyncrm_salesready |
msdyncrm_salesready |
Indicates whether a lead or contact is qualified and ready for sales engagement. |
dimension |
msdyncrm_salesready@OData.Community.Display.V1.FormattedValue |
msdyncrm_salesready@OData.Community.Display.V1.FormattedValue |
Formatted value indicating if a lead or contact is sales ready. |
dimension |
msdyncrm_sastoken |
msdyncrm_sastoken |
A Shared Access Signature (SAS) token used for secure access to Azure storage resources. |
dimension |
msdyncrm_school |
msdyncrm_school |
A custom field for recording the name of an educational institution. |
dimension |
msdyncrm_scores |
msdyncrm_scores |
A custom field for storing scores or ratings. |
dimension |
msdyncrm_scoringgrade |
msdyncrm_scoringgrade |
A custom field for recording a scoring grade. |
dimension |
msdyncrm_seniority |
msdyncrm_seniority |
A custom field for indicating a person’s seniority level. |
dimension |
msdyncrm_startdate |
msdyncrm_startdate |
A custom field for recording a start date. |
dimension |
msdyncrm_startdatetime |
msdyncrm_startdatetime |
The scheduled start date and time for a marketing activity or customer journey. |
dimension |
msdyncrm_startdatetime@OData.Community.Display.V1.FormattedValue |
msdyncrm_startdatetime@OData.Community.Display.V1.FormattedValue |
The formatted display value of the marketing start date and time. |
dimension |
msdyncrm_subject |
msdyncrm_subject |
The subject line of the marketing email. |
dimension |
msdyncrm_teleprospectaccepted |
msdyncrm_teleprospectaccepted |
Indicates whether a teleprospecting effort has been accepted. |
dimension |
msdyncrm_teleprospectaccepted@OData.Community.Display.V1.FormattedValue |
msdyncrm_teleprospectaccepted@OData.Community.Display.V1.FormattedValue |
Formatted value indicating if teleprospecting was accepted. |
dimension |
msdyncrm_teleprospectready |
msdyncrm_teleprospectready |
Indicates whether a lead or contact is ready for teleprospecting efforts. |
dimension |
msdyncrm_teleprospectready@OData.Community.Display.V1.FormattedValue |
msdyncrm_teleprospectready@OData.Community.Display.V1.FormattedValue |
Formatted value indicating if a lead or contact is teleprospect ready. |
dimension |
msdyncrm_testconfiguration |
msdyncrm_testconfiguration |
Configuration details or settings for testing a marketing item or campaign. |
dimension |
msdyncrm_textpart |
msdyncrm_textpart |
The plain text version of the marketing email content. |
dimension |
msdyncrm_to |
msdyncrm_to |
The recipient(s) of the marketing email. |
dimension |
msdyncrm_triggerrecycle |
msdyncrm_triggerrecycle |
A flag or indicator to trigger the recycling process for a lead or record. |
dimension |
msdyncrm_triggerrecycle@OData.Community.Display.V1.FormattedValue |
msdyncrm_triggerrecycle@OData.Community.Display.V1.FormattedValue |
Formatted value indicating if the recycling process is triggered. |
dimension |
msdyncrm_uicentityid |
msdyncrm_uicentityid |
A custom identifier for a UI (User Interface) C entity, likely related to a specific CRM customization. |
dimension |
msdynmkt_emailid |
msdynmkt_emailid |
Unique identifier for a marketing email record in Dynamics 365 Marketing. |
dimension |
msdynmkt_issalesreadysetmanually |
msdynmkt_issalesreadysetmanually |
Indicates if the sales-ready status was manually set for a lead or contact in Dynamics 365 Marketing. |
dimension |
msdynmkt_issalesreadysetmanually@OData.Community.Display.V1.FormattedValue |
msdynmkt_issalesreadysetmanually@OData.Community.Display.V1.FormattedValue |
Formatted value indicating if the sales-ready status was manually set. |
dimension |
msdynmkt_journeyactionid |
msdynmkt_journeyactionid |
Unique identifier for an action performed within a customer journey in Dynamics 365 Marketing. |
dimension |
msdynmkt_subject |
msdynmkt_subject |
The subject line of the marketing email. |
dimension |
msevtmgt_aadobjectid |
msevtmgt_aadobjectid |
The Azure Active Directory (AAD) object ID associated with an entity in the Event Management solution. |
dimension |
msgdpr_donottrack |
msgdpr_donottrack |
Indicates a contact’s preference to opt-out of tracking for GDPR compliance. |
dimension |
Formatted value of the ‘do not track’ preference. |
dimension |
||
msgdpr_gdprconsent |
msgdpr_gdprconsent |
The consent status of a contact regarding GDPR regulations. |
metric |
msgdpr_gdprconsent@OData.Community.Display.V1.FormattedValue |
msgdpr_gdprconsent@OData.Community.Display.V1.FormattedValue |
Formatted value of the GDPR consent status. |
dimension |
msgdpr_gdprischild |
msgdpr_gdprischild |
Indicates whether the contact is identified as a child for GDPR compliance purposes. |
dimension |
msgdpr_gdprischild@OData.Community.Display.V1.FormattedValue |
msgdpr_gdprischild@OData.Community.Display.V1.FormattedValue |
Formatted value indicating if the contact is identified as a child for GDPR. |
dimension |
mspp_userpreferredlcid |
mspp_userpreferredlcid |
The locale identifier (LCID) preferred by the user, commonly used in Power Pages (Portals) for language and regional settings. |
dimension |
name |
name |
The primary name, title, or description of the record. |
dimension |
need |
need |
A specific need or requirement identified for a lead or customer. |
dimension |
nickname |
nickname |
The informal name or nickname of a contact. |
dimension |
numberofchildren |
numberofchildren |
The number of children associated with a contact. |
dimension |
numberofemployees |
numberofemployees |
The number of employees in the associated company or account. |
dimension |
objective |
objective |
A stated goal or target for a record, such as a campaign or opportunity. |
dimension |
onholdtime |
onholdtime |
The total duration, in minutes, that a case or other record was on hold. |
dimension |
onlinemeetingchatid |
onlinemeetingchatid |
The unique identifier for the chat associated with an online meeting. |
dimension |
onlinemeetingid |
onlinemeetingid |
The unique identifier for an online meeting. |
dimension |
onlinemeetingjoinurl |
onlinemeetingjoinurl |
The URL used to join an online meeting. |
dimension |
onlinemeetingtype |
onlinemeetingtype |
The type of online meeting (e.g., Teams meeting, Skype meeting). |
metric |
Formatted value of the online meeting type. |
dimension |
||
opencount |
opencount |
The total number of times an email message or other trackable item has been opened. |
metric |
Formatted value of the open count. |
metric |
||
opportunity_close_date |
opportunity_close_date |
The estimated or actual date an opportunity is expected to close. |
dimension |
opportunityid |
opportunityid |
Unique identifier for the opportunity record. |
dimension |
ordercreationmethod |
ordercreationmethod |
The method or source through which a sales order was created. |
metric |
ordercreationmethod@OData.Community.Display.V1.FormattedValue |
ordercreationmethod@OData.Community.Display.V1.FormattedValue |
Formatted value of the order creation method. |
dimension |
ordernumber |
ordernumber |
A unique identifier or number assigned to a sales order. |
dimension |
originalstartdate |
originalstartdate |
The original scheduled start date for an activity or appointment. |
dimension |
othercost |
othercost |
Additional costs incurred that do not fit into predefined cost categories. |
metric |
Formatted value of other costs. |
dimension |
||
othercost_base |
othercost_base |
The base currency equivalent of any additional or miscellaneous costs. |
metric |
Formatted value of other costs in base currency. |
dimension |
||
outlookownerapptid |
outlookownerapptid |
The unique identifier used to synchronize an appointment with Microsoft Outlook. |
metric |
outlookownerapptid@OData.Community.Display.V1.FormattedValue |
outlookownerapptid@OData.Community.Display.V1.FormattedValue |
Formatted value of the Outlook appointment ID. |
dimension |
overriddencreatedon |
overriddencreatedon |
A field used during data migration to set the ‘Created On’ date of a record to a historical value, overriding the actual system creation date. |
dimension |
owning_team_name |
owning_team_name |
The name of the team that owns the record. |
dimension |
pager |
pager |
The pager number for a contact. |
dimension |
participatesinworkflow |
participatesinworkflow |
Indicates whether the entity or record is configured to participate in a workflow process. |
dimension |
participatesinworkflow@OData.Community.Display.V1.FormattedValue |
participatesinworkflow@OData.Community.Display.V1.FormattedValue |
Formatted value indicating if the entity participates in a workflow. |
dimension |
paymenttermscode |
paymenttermscode |
A code indicating the payment terms for an order or invoice. |
dimension |
preferredappointmentdaycode |
preferredappointmentdaycode |
The preferred day of the week for a contact’s appointments. |
dimension |
preferredappointmenttimecode |
preferredappointmenttimecode |
The preferred time of day for a contact’s appointments. |
metric |
preferredappointmenttimecode@OData.Community.Display.V1.FormattedValue |
preferredappointmenttimecode@OData.Community.Display.V1.FormattedValue |
Formatted value of the preferred appointment time. |
dimension |
preferredcontactmethodcode |
preferredcontactmethodcode |
The preferred method of communication for a contact (e.g., email, phone, mail). |
metric |
preferredcontactmethodcode@OData.Community.Display.V1.FormattedValue |
preferredcontactmethodcode@OData.Community.Display.V1.FormattedValue |
Formatted value of the preferred contact method. |
dimension |
priceperunit |
priceperunit |
The price of a single unit of a product or service. |
metric |
Formatted value of the price per unit. |
dimension |
||
priceperunit_base |
priceperunit_base |
The base currency equivalent of the price per unit. |
metric |
Formatted value of the price per unit in base currency. |
dimension |
||
pricingerrorcode |
pricingerrorcode |
An error code indicating an issue with pricing calculations for an opportunity, quote, or order. |
metric |
Formatted value of the pricing error code. |
dimension |
||
prioritycode |
prioritycode |
A code indicating the priority level of a record, such as an activity or a lead. |
metric |
Formatted value of the priority code. |
dimension |
||
productdescription |
productdescription |
A detailed description of the product. |
dimension |
productname |
productname |
The name of the product. |
dimension |
productnumber |
productnumber |
A unique identifier or number for the product. |
metric |
producttypecode |
producttypecode |
A code that categorizes the type of a product. |
metric |
Formatted value of the product type code. |
dimension |
||
propertyconfigurationstatus |
propertyconfigurationstatus |
metric |
|
propertyconfigurationstatus@OData.Community.Display.V1.FormattedValue |
propertyconfigurationstatus@OData.Community.Display.V1.FormattedValue |
Formatted value of the property configuration status. |
dimension |
proposedend |
proposedend |
The suggested or anticipated end date and time for an activity or project phase. |
dimension |
Formatted display value of the proposed end date and time. |
dimension |
||
proposedstart |
proposedstart |
The suggested or anticipated start date and time for an activity or project phase. |
dimension |
Formatted display value of the proposed start date and time. |
dimension |
||
purchaseprocess |
purchaseprocess |
The current stage or type of process a lead is undergoing related to a purchase. |
dimension |
purchasetimeframe |
purchasetimeframe |
The estimated period or duration within which a purchase is expected to occur. |
metric |
Formatted display value of the purchase timeframe. |
dimension |
||
qualificationcomments |
qualificationcomments |
Comments and notes recorded during the lead qualification process. |
dimension |
quantity |
quantity |
The quantity of the product included in the sales order detail. |
metric |
Formatted display value of the quantity of the product. |
metric |
||
quantitybackordered |
quantitybackordered |
The quantity of the product that is backordered on the sales order detail. |
dimension |
quantitycancelled |
quantitycancelled |
The quantity of the product that was canceled on the sales order detail. |
dimension |
quantityshipped |
quantityshipped |
The quantity of the product that has been shipped for the sales order detail. |
dimension |
requestdeliveryby |
requestdeliveryby |
The requested delivery date for the sales order or sales order detail. |
dimension |
revenue |
revenue |
The total estimated or actual revenue associated with an account, lead, or sales order. |
dimension |
revenue_base |
revenue_base |
The value of the revenue field converted to the system’s base currency. |
dimension |
salesorderdetailid |
salesorderdetailid |
Unique identifier for the sales order detail (order product). |
dimension |
salesorderdetailname |
salesorderdetailname |
The name of the sales order detail. |
dimension |
salesorderid |
salesorderid |
Unique identifier of the sales order record. |
dimension |
salesorderispricelocked |
salesorderispricelocked |
Indicates if 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 |
Status of the sales order, such as Active, Submitted, or Canceled. |
metric |
salesorderstatecode@OData.Community.Display.V1.FormattedValue |
salesorderstatecode@OData.Community.Display.V1.FormattedValue |
Formatted display value of the sales order status. |
dimension |
salesstage |
salesstage |
The current stage of a sales process. |
dimension |
salesstagecode |
salesstagecode |
A code representing the current stage of a sales process. |
metric |
Formatted display value of the sales stage code. |
dimension |
||
salutation |
salutation |
The salutation for the contact, such as Mr., Ms., Dr. |
dimension |
scheduleddurationminutes |
scheduleddurationminutes |
The planned duration of an activity in minutes. |
metric |
scheduleddurationminutes@OData.Community.Display.V1.FormattedValue |
scheduleddurationminutes@OData.Community.Display.V1.FormattedValue |
Formatted display value of the scheduled duration in minutes. |
dimension |
scheduledend |
scheduledend |
The planned end date and time for an activity or event. |
dimension |
Formatted display value of the scheduled end date and time. |
dimension |
||
scheduledstart |
scheduledstart |
The planned start date and time for an activity or event. |
dimension |
Formatted display value of the scheduled start date and time. |
dimension |
||
sequencenumber |
sequencenumber |
Unique sequential number of the sales order detail. |
metric |
Formatted display value of the sequence number. |
metric |
||
shippingmethodcode |
shippingmethodcode |
Code indicating the preferred shipping method for deliveries. |
dimension |
shippingmethodcode@OData.Community.Display.V1.FormattedValue |
shippingmethodcode@OData.Community.Display.V1.FormattedValue |
Formatted display value of the shipping method code. |
dimension |
shipto_city |
shipto_city |
The city for the ship-to address. |
dimension |
shipto_composite |
shipto_composite |
The complete ship-to address. |
dimension |
shipto_contactname |
shipto_contactname |
The name of the contact person at the ship-to address. |
dimension |
shipto_country |
shipto_country |
The country/region for the ship-to address. |
dimension |
shipto_fax |
shipto_fax |
The fax number for the ship-to address. |
dimension |
shipto_freighttermscode |
shipto_freighttermscode |
Code indicating the freight terms for the ship-to address. |
dimension |
shipto_freighttermscode@OData.Community.Display.V1.FormattedValue |
shipto_freighttermscode@OData.Community.Display.V1.FormattedValue |
Formatted display value of the freight terms code for the ship-to address. |
dimension |
shipto_line1 |
shipto_line1 |
The first line of the street address for the ship-to address. |
dimension |
shipto_line2 |
shipto_line2 |
The second line of the street address for the ship-to address. |
dimension |
shipto_line3 |
shipto_line3 |
The third line of the street address for the ship-to address. |
dimension |
shipto_name |
shipto_name |
A descriptive name for the ship-to address. |
dimension |
shipto_postalcode |
shipto_postalcode |
The ZIP Code or postal code for the ship-to address. |
dimension |
shipto_stateorprovince |
shipto_stateorprovince |
The state or province for the ship-to address. |
dimension |
shipto_telephone |
shipto_telephone |
The telephone number for the ship-to address. |
dimension |
sic |
sic |
The Standard Industrial Classification (SIC) code for a company or lead. |
dimension |
skippricecalculation |
skippricecalculation |
Indicates whether to skip price calculation for the sales order detail. |
metric |
skippricecalculation@OData.Community.Display.V1.FormattedValue |
skippricecalculation@OData.Community.Display.V1.FormattedValue |
Formatted display value indicating whether to skip price calculation. |
dimension |
sortdate |
sortdate |
A date used primarily for sorting records in views or reports. |
dimension |
spousesname |
spousesname |
The name of the contact’s spouse or partner. |
dimension |
statecode |
statecode |
Status of the record. |
metric |
The formatted display name of the record’s state code (e.g., Active, Inactive, Open). |
dimension |
||
statuscode |
statuscode |
Reason for the status of the record. |
metric |
The formatted display name of the record’s status reason (e.g., Active, Fulfilled, Canceled). |
dimension |
||
subcategory |
subcategory |
A subcategory used to further classify records or activities. |
dimension |
subject |
subject |
The subject or title of an activity or record, providing a brief description of its purpose. |
dimension |
submitdate |
submitdate |
Date when the sales order was submitted. |
dimension |
submitstatus |
submitstatus |
The submission status of the sales order. |
dimension |
submitstatusdescription |
submitstatusdescription |
Description of the submission status of the sales order. |
dimension |
suffix |
suffix |
The suffix for the contact’s name, such as Jr. or Sr. |
dimension |
tax |
tax |
The amount of tax charged on the sales order detail. |
metric |
Formatted display value of the tax amount. |
dimension |
||
tax_base |
tax_base |
The tax amount converted to the system’s default base currency for reporting purposes. |
metric |
Formatted display value of the base currency equivalent of the tax amount. |
dimension |
||
telephone1 |
telephone1 |
The primary telephone number. |
dimension |
telephone2 |
telephone2 |
A second telephone number for the contact. |
dimension |
telephone3 |
telephone3 |
A third telephone number for the contact. |
dimension |
territorycode |
territorycode |
Code indicating the sales territory or region. |
metric |
Formatted display value of the territory code. |
dimension |
||
timezoneruleversionnumber |
timezoneruleversionnumber |
The version number of the time zone rule being used. |
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 |
totalactualcost |
totalactualcost |
The sum of all actual costs incurred for a project or other financial item. |
metric |
Formatted display value of the total actual cost incurred. |
dimension |
||
totalactualcost_base |
totalactualcost_base |
The total actual cost converted to the system’s default base currency. |
metric |
totalactualcost_base@OData.Community.Display.V1.FormattedValue |
totalactualcost_base@OData.Community.Display.V1.FormattedValue |
Formatted display value of the base currency equivalent of the total actual cost incurred. |
dimension |
totalamount |
totalamount |
The total monetary amount for a sales document, such as a sales order or invoice. |
metric |
The formatted display value of the total monetary amount, including currency symbols and proper formatting. |
dimension |
||
totalamount_base |
totalamount_base |
The base currency equivalent of the total amount of the sales order. |
metric |
Formatted display value of the base currency equivalent of the total amount. |
dimension |
||
totalamountlessfreight |
totalamountlessfreight |
The total amount of the sales order, excluding freight charges. |
metric |
totalamountlessfreight@OData.Community.Display.V1.FormattedValue |
totalamountlessfreight@OData.Community.Display.V1.FormattedValue |
Formatted display value of the total amount less freight. |
dimension |
totalamountlessfreight_base |
totalamountlessfreight_base |
The base currency equivalent of the total amount of the sales order, excluding freight charges. |
metric |
totalamountlessfreight_base@OData.Community.Display.V1.FormattedValue |
totalamountlessfreight_base@OData.Community.Display.V1.FormattedValue |
Formatted display value of the base currency equivalent of the total amount less freight. |
dimension |
totalcampaignactivityactualcost |
totalcampaignactivityactualcost |
The aggregate of actual costs incurred for all activities within a marketing campaign. |
metric |
totalcampaignactivityactualcost@OData.Community.Display.V1.FormattedValue |
totalcampaignactivityactualcost@OData.Community.Display.V1.FormattedValue |
Formatted display value of the total actual cost of campaign activities. |
dimension |
totalcampaignactivityactualcost_base |
totalcampaignactivityactualcost_base |
The total actual cost for campaign activities converted to the system’s base currency. |
metric |
totalcampaignactivityactualcost_base@OData.Community.Display.V1.FormattedValue |
totalcampaignactivityactualcost_base@OData.Community.Display.V1.FormattedValue |
Formatted display value of the base currency equivalent of the total actual cost of campaign activities. |
dimension |
totaldiscountamount |
totaldiscountamount |
The total discount amount applied to the sales order. |
metric |
totaldiscountamount@OData.Community.Display.V1.FormattedValue |
totaldiscountamount@OData.Community.Display.V1.FormattedValue |
Formatted display value of the total discount amount. |
dimension |
totaldiscountamount_base |
totaldiscountamount_base |
The base currency equivalent of the total discount amount. |
metric |
totaldiscountamount_base@OData.Community.Display.V1.FormattedValue |
totaldiscountamount_base@OData.Community.Display.V1.FormattedValue |
Formatted display value of the base currency equivalent of the total discount amount. |
dimension |
totallineitemamount |
totallineitemamount |
The total amount for all line items (products) in the sales order. |
metric |
totallineitemamount@OData.Community.Display.V1.FormattedValue |
totallineitemamount@OData.Community.Display.V1.FormattedValue |
Formatted display value of the total line item amount. |
dimension |
totallineitemamount_base |
totallineitemamount_base |
The base currency equivalent of the total amount for all line items in the sales order. |
metric |
totallineitemamount_base@OData.Community.Display.V1.FormattedValue |
totallineitemamount_base@OData.Community.Display.V1.FormattedValue |
Formatted display value of the base currency equivalent of the total line item amount. |
dimension |
totallineitemdiscountamount |
totallineitemdiscountamount |
The total discount amount for all line items (products) in the sales order. |
metric |
totallineitemdiscountamount@OData.Community.Display.V1.FormattedValue |
totallineitemdiscountamount@OData.Community.Display.V1.FormattedValue |
Formatted display value of the total line item discount amount. |
dimension |
totallineitemdiscountamount_base |
totallineitemdiscountamount_base |
The base currency equivalent of the total discount amount for all line items in the sales order. |
metric |
totallineitemdiscountamount_base@OData.Community.Display.V1.FormattedValue |
totallineitemdiscountamount_base@OData.Community.Display.V1.FormattedValue |
Formatted display value of the base currency equivalent of the total line item discount amount. |
dimension |
totaltax |
totaltax |
The total tax amount for the sales order. |
metric |
Formatted display value of the total tax amount. |
dimension |
||
totaltax_base |
totaltax_base |
The base currency equivalent of the total tax amount. |
metric |
Formatted display value of the base currency equivalent of the total tax amount. |
dimension |
||
traversedpath |
traversedpath |
For internal use only. The traversed path of a business process flow instance. |
dimension |
typecode |
typecode |
A numeric identifier representing the type of an entity or record. |
metric |
Formatted display value of the type code. |
dimension |
||
utcconversiontimezonecode |
utcconversiontimezonecode |
Time zone code that was in use when the record was created. |
dimension |
versionnumber |
versionnumber |
A system-generated version number for the record, often used for optimistic concurrency control. |
metric |
The formatted display value of the version number. |
dimension |
||
volumediscountamount |
volumediscountamount |
The monetary amount of discount applied due to the volume of items purchased. |
metric |
volumediscountamount@OData.Community.Display.V1.FormattedValue |
volumediscountamount@OData.Community.Display.V1.FormattedValue |
Formatted display value of the volume discount amount. |
dimension |
volumediscountamount_base |
volumediscountamount_base |
The volume discount amount converted to the system’s default base currency. |
metric |
volumediscountamount_base@OData.Community.Display.V1.FormattedValue |
volumediscountamount_base@OData.Community.Display.V1.FormattedValue |
Formatted display value of the base currency equivalent of the volume discount amount. |
dimension |
websiteurl |
websiteurl |
The URL of the contact’s or account’s website. |
dimension |
willcall |
willcall |
Indicates whether the customer will call in to pick up the order. |
dimension |
Formatted display value indicating if the customer will pick up the order. |
dimension |
||
yomicompanyname |
yomicompanyname |
The phonetic spelling of the company name. |
dimension |
yomifirstname |
yomifirstname |
The phonetic spelling of the contact’s first name. |
dimension |
yomifullname |
yomifullname |
The phonetic spelling of the contact’s full name. |
dimension |
yomilastname |
yomilastname |
The phonetic spelling of the contact’s last name. |
dimension |
yomimiddlename |
yomimiddlename |
The phonetic spelling of the contact’s middle name. |
dimension |