Attributes List of Dynamics 365 CRM Metadata

 

Account accountcategorycode Select a category to indicate whether the customer account is standard or preferred. Picklist
Account accountclassificationcode Select a classification code to indicate the potential value of the customer account based on the projected return on investment, cooperation level, sales cycle length or other criteria. Picklist
Account accountid Unique identifier of the account. Uniqueidentifier
Account accountnumber Type an ID number or code for the account to quickly search and identify the account in system views. String
Account accountratingcode Select a rating to indicate the value of the customer account. Picklist
Account address1_addressid Unique identifier for address 1. Uniqueidentifier
Account address1_addresstypecode Select the primary address type. Picklist
Account address1_city Type the city for the primary address. String
Account address1_composite Shows the complete primary address. Memo
Account address1_country Type the country or region for the primary address. String
Account address1_county Type the county for the primary address. String
Account address1_fax Type the fax number associated with the primary address. String
Account address1_freighttermscode Select the freight terms for the primary address to make sure shipping orders are processed correctly. Picklist
Account address1_latitude Type the latitude value for the primary address for use in mapping and other applications. Double
Account address1_line1 Type the first line of the primary address. String
Account address1_line2 Type the second line of the primary address. String
Account address1_line3 Type the third line of the primary address. String
Account address1_longitude Type the longitude value for the primary address for use in mapping and other applications. Double
Account address1_name Type a descriptive name for the primary address, such as Corporate Headquarters. String
Account address1_postalcode Type the ZIP Code or postal code for the primary address. String
Account address1_postofficebox Type the post office box number of the primary address. String
Account address1_primarycontactname Type the name of the main contact at the account’s primary address. String
Account address1_shippingmethodcode Select a shipping method for deliveries sent to this address. Picklist
Account address1_stateorprovince Type the state or province of the primary address. String
Account address1_telephone1 Type the main phone number associated with the primary address. String
Account address1_telephone2 Type a second phone number associated with the primary address. String
Account address1_telephone3 Type a third phone number associated with the primary address. String
Account address1_upszone Type the UPS zone of the primary address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS. String
Account address1_utcoffset Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address. Integer
Account address2_addressid Unique identifier for address 2. Uniqueidentifier
Account address2_addresstypecode Select the secondary address type. Picklist
Account address2_city Type the city for the secondary address. String
Account address2_composite Shows the complete secondary address. Memo
Account address2_country Type the country or region for the secondary address. String
Account address2_county Type the county for the secondary address. String
Account address2_fax Type the fax number associated with the secondary address. String
Account address2_freighttermscode Select the freight terms for the secondary address to make sure shipping orders are processed correctly. Picklist
Account address2_latitude Type the latitude value for the secondary address for use in mapping and other applications. Double
Account address2_line1 Type the first line of the secondary address. String
Account address2_line2 Type the second line of the secondary address. String
Account address2_line3 Type the third line of the secondary address. String
Account address2_longitude Type the longitude value for the secondary address for use in mapping and other applications. Double
Account address2_name Type a descriptive name for the secondary address, such as Corporate Headquarters. String
Account address2_postalcode Type the ZIP Code or postal code for the secondary address. String
Account address2_postofficebox Type the post office box number of the secondary address. String
Account address2_primarycontactname Type the name of the main contact at the account’s secondary address. String
Account address2_shippingmethodcode Select a shipping method for deliveries sent to this address. Picklist
Account address2_stateorprovince Type the state or province of the secondary address. String
Account address2_telephone1 Type the main phone number associated with the secondary address. String
Account address2_telephone2 Type a second phone number associated with the secondary address. String
Account address2_telephone3 Type a third phone number associated with the secondary address. String
Account address2_upszone Type the UPS zone of the secondary address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS. String
Account address2_utcoffset Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address. Integer
Account aging30 For system use only. Money
Account aging30_base The base currency equivalent of the aging 30 field. Money
Account aging60 For system use only. Money
Account aging60_base The base currency equivalent of the aging 60 field. Money
Account aging90 For system use only. Money
Account aging90_base The base currency equivalent of the aging 90 field. Money
Account businesstypecode Select the legal designation or other business type of the account for contracts or reporting purposes. Picklist
Account createdby Shows who created the record. Lookup
Account createdbyexternalparty Shows the external party who created the record. Lookup
Account createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Account createdonbehalfby Shows who created the record on behalf of another user. Lookup
Account creditlimit Type the credit limit of the account. This is a useful reference when you address invoice and accounting issues with the customer. Money
Account creditlimit_base Shows the credit limit converted to the system’s default base currency for reporting purposes. Money
Account creditonhold Select whether the credit for the account is on hold. This is a useful reference while addressing the invoice and accounting issues with the customer. Boolean
Account customersizecode Select the size category or range of the account for segmentation and reporting purposes. Picklist
Account customertypecode Select the category that best describes the relationship between the account and your organization. Picklist
Account defaultpricelevelid Choose the default price list associated with the account to make sure the correct product prices for this customer are applied in sales opportunities, quotes, and orders. Lookup
Account description Type additional information to describe the account, such as an excerpt from the company’s website. Memo
Account donotbulkemail Select whether the account allows bulk email sent through campaigns. If Do Not Allow is selected, the account can be added to marketing lists, but is excluded from email. Boolean
Account donotbulkpostalmail Select whether the account allows bulk postal mail sent through marketing campaigns or quick campaigns. If Do Not Allow is selected, the account can be added to marketing lists, but will be excluded from the postal mail. Boolean
Account donotemail Select whether the account allows direct email sent from Microsoft Dynamics 365. Boolean
Account donotfax Select whether the account allows faxes. If Do Not Allow is selected, the account will be excluded from fax activities distributed in marketing campaigns. Boolean
Account donotphone Select whether the account allows phone calls. If Do Not Allow is selected, the account will be excluded from phone call activities distributed in marketing campaigns. Boolean
Account donotpostalmail Select whether the account allows direct mail. If Do Not Allow is selected, the account will be excluded from letter activities distributed in marketing campaigns. Boolean
Account donotsendmm Select whether the account accepts marketing materials, such as brochures or catalogs. Boolean
Account emailaddress1 Type the primary email address for the account. String
Account emailaddress2 Type the secondary email address for the account. String
Account emailaddress3 Type an alternate email address for the account. String
Account entityimageid For internal use only. Uniqueidentifier
Account exchangerate 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. Decimal
Account fax Type the fax number for the account. String
Account followemail Information about whether to allow following email activity like opens, attachment views and link clicks for emails sent to the account. Boolean
Account ftpsiteurl Type the URL for the account’s FTP site to enable users to access data and share documents. String
Account importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Account industrycode Select the account’s primary industry for use in marketing segmentation and demographic analysis. Picklist
Account isprivate Boolean
Account lastonholdtime Contains the date and time stamp of the last on hold time. DateTime
Account lastusedincampaign Shows the date when the account was last included in a marketing campaign or quick campaign. DateTime
Account marketcap Type the market capitalization of the account to identify the company’s equity, used as an indicator in financial performance analysis. Money
Account marketcap_base Shows the market capitalization converted to the system’s default base currency. Money
Account marketingonly Whether is only for marketing Boolean
Account masterid Shows the master account that the account was merged with. Lookup
Account merged Shows whether the account has been merged with another account. Boolean
Account modifiedby Shows who last updated the record. Lookup
Account modifiedbyexternalparty Shows the external party who modified the record. Lookup
Account modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Account modifiedonbehalfby Shows who created the record on behalf of another user. Lookup
Account name Type the company or business name. String
Account numberofemployees Type the number of employees that work at the account for use in marketing segmentation and demographic analysis. Integer
Account onholdtime Shows how long, in minutes, that the record was on hold. Integer
Account opendeals Number of open opportunities against an account and its child accounts. Integer
Account opendeals_date The date time for Open Deals. DateTime
Account opendeals_state State of Open Deals. Integer
Account openrevenue Sum of open revenue against an account and its child accounts. Money
Account openrevenue_base Sum of open revenue against an account and its child accounts. Money
Account openrevenue_date The date time for Open Revenue. DateTime
Account openrevenue_state State of Open Revenue. Integer
Account originatingleadid Shows the lead that the account was created from if the account was created by converting a lead in Microsoft Dynamics 365. This is used to relate the account to data on the originating lead for use in reporting and analytics. Lookup
Account overriddencreatedon Date and time that the record was migrated. DateTime
Account ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
Account ownershipcode Select the account’s ownership structure, such as public or private. Picklist
Account owningbusinessunit Shows the business unit that the record owner belongs to. Lookup
Account owningteam Unique identifier of the team who owns the account. Lookup
Account owninguser Unique identifier of the user who owns the account. Lookup
Account parentaccountid Choose the parent account associated with this account to show parent and child businesses in reporting and analytics. Lookup
Account participatesinworkflow For system use only. Legacy Microsoft Dynamics CRM 3.0 workflow data. Boolean
Account paymenttermscode Select the payment terms to indicate when the customer needs to pay the total amount. Picklist
Account preferredappointmentdaycode Select the preferred day of the week for service appointments. Picklist
Account preferredappointmenttimecode Select the preferred time of day for service appointments. Picklist
Account preferredcontactmethodcode Select the preferred method of contact. Picklist
Account preferredequipmentid Choose the account’s preferred service facility or equipment to make sure services are scheduled correctly for the customer. Lookup
Account preferredserviceid Choose the account’s preferred service for reference when you schedule service activities. Lookup
Account preferredsystemuserid Choose the preferred service representative for reference when you schedule service activities for the account. Lookup
Account primarycontactid Choose the primary contact for the account to provide quick access to contact details. Lookup
Account primarysatoriid Primary Satori ID for Account String
Account primarytwitterid Primary Twitter ID for Account String
Account processid Shows the ID of the process. Uniqueidentifier
Account revenue Type the annual revenue for the account, used as an indicator in financial performance analysis. Money
Account revenue_base Shows the annual revenue converted to the system’s default base currency. The calculations use the exchange rate specified in the Currencies area. Money
Account sharesoutstanding Type the number of shares available to the public for the account. This number is used as an indicator in financial performance analysis. Integer
Account shippingmethodcode Select a shipping method for deliveries sent to the account’s address to designate the preferred carrier or other delivery option. Picklist
Account sic Type the Standard Industrial Classification (SIC) code that indicates the account’s primary industry of business, for use in marketing segmentation and demographic analysis. String
Account slaid Choose the service level agreement (SLA) that you want to apply to the Account record. Lookup
Account slainvokedid Last SLA that was applied to this case. This field is for internal use only. Lookup
Account stageid Shows the ID of the stage. Uniqueidentifier
Account statecode Shows whether the account is active or inactive. Inactive accounts are read-only and can’t be edited unless they are reactivated. State
Account statuscode Select the account’s status. Status
Account stockexchange Type the stock exchange at which the account is listed to track their stock and financial performance of the company. String
Account telephone1 Type the main phone number for this account. String
Account telephone2 Type a second phone number for this account. String
Account telephone3 Type a third phone number for this account. String
Account territorycode Select a region or territory for the account for use in segmentation and analysis. Picklist
Account territoryid Choose the sales region or territory for the account to make sure the account is assigned to the correct representative and for use in segmentation and analysis. Lookup
Account tickersymbol Type the stock exchange symbol for the account to track financial performance of the company. You can click the code entered in this field to access the latest trading information from MSN Money. String
Account timespentbymeonemailandmeetings Total time spent for emails (read and write) and meetings by me in relation to account record. String
Account timezoneruleversionnumber For internal use only. Integer
Account transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Account traversedpath For internal use only. String
Account utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Account versionnumber Version number of the account. BigInt
Account websiteurl Type the account’s website URL to get quick details about the company profile. String
Account yominame Type the phonetic spelling of the company name, if specified in Japanese, to make sure the name is pronounced correctly in phone calls and other communications. String
AccountLeads accountid Uniqueidentifier
AccountLeads accountleadid Unique identifier of the lead for the account. Uniqueidentifier
AccountLeads leadid Uniqueidentifier
AccountLeads versionnumber BigInt
ActionCard actioncardid Unique identifier of the action card. Uniqueidentifier
ActionCard cardtype The CardType ENUM value. Integer
ActionCard cardtypeid Unique identifier of the card type. Lookup
ActionCard createdby Unique identifier of the user who created the action card. Lookup
ActionCard createdon Date and time when action card was created. DateTime
ActionCard createdonbehalfby Unique identifier of the delegate user who created the action card. Lookup
ActionCard data For internal use only. Memo
ActionCard description For internal use only. Memo
ActionCard exchangerate Exchange rate for the currency associated with the action card with respect to the base currency. Decimal
ActionCard expirydate Shows the Expiry Date DateTime
ActionCard importsequencenumber Sequence number of the import that created this record. Integer
ActionCard modifiedby Unique identifier of the user who last modified the action card. Lookup
ActionCard modifiedon Date and time when action card was last modified. DateTime
ActionCard modifiedonbehalfby Unique identifier of the delegate user who last modified action card. Lookup
ActionCard overriddencreatedon Date and time that the record was migrated. DateTime
ActionCard ownerid Unique identifier of the user or team who owns the action card. Owner
ActionCard owningbusinessunit Unique identifier of the business unit that owns the action card. Lookup
ActionCard owningteam Unique identifier of the team who owns the action card. Lookup
ActionCard owninguser Unique identifier of the user who owns the action card. Lookup
ActionCard priority Priority of the ActionCard Integer
ActionCard recordid Shows the record ID. Lookup
ActionCard referencetokens For internal use only. Memo
ActionCard regardingobjectid Choose the record that the card relates to. Lookup
ActionCard source Source for the Action Card Picklist
ActionCard startdate Shows the Start Date DateTime
ActionCard state State of the Action Card Picklist
ActionCard title Title of the ActionCard String
ActionCard transactioncurrencyid Unique identifier of the currency associated with the action card. Lookup
ActionCard versionnumber Version number of the action card. BigInt
ActionCard visibility Select whether the visibility should be set to public/private. Boolean
ActionCardUserSettings actioncardusersettingsid Unique identifier user entity Uniqueidentifier
ActionCardUserSettings boolcardoption Bolean option for a cardtype. Boolean
ActionCardUserSettings cardtype The CardType ENUM value. Integer
ActionCardUserSettings cardtypeid card type attribute Lookup
ActionCardUserSettings intcardoption Any int option for a cardtype. Integer
ActionCardUserSettings isenabled Select whether the card is enabled for user or not. Boolean
ActionCardUserSettings ownerid Unique identifier of the user or team who owns the settings. Owner
ActionCardUserSettings owningbusinessunit Unique identifier of the business unit that owns this. Lookup
ActionCardUserSettings owningteam Unique identifier of the team who owns this saved view. Lookup
ActionCardUserSettings owninguser Unique identifier of the user who owns this saved view. Lookup
ActionCardUserSettings stringcardoption Any string option for a cardtype. Memo
ActionCardUserSettings versionnumber BigInt
ActionCardUserState actioncardid Parent ActionCard Id. Lookup
ActionCardUserState actioncarduserstateid Unique identifier for entity instances Uniqueidentifier
ActionCardUserState exchangerate Exchange rate for the currency associated with the ActionCardUserState with respect to the base currency. Decimal
ActionCardUserState ownerid Unique identifier of the user or team who owns the state of this action card. Owner
ActionCardUserState owningbusinessunit Unique identifier for the business unit that owns the record Lookup
ActionCardUserState startdate Shows the Start Date DateTime
ActionCardUserState state State of the Action Card Picklist
ActionCardUserState timezoneruleversionnumber For internal use only. Integer
ActionCardUserState transactioncurrencyid Exchange rate for the currency associated with the ActionCardUserState with respect to the base currency. Lookup
ActionCardUserState utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
ActionCardUserState versionnumber BigInt
ActivityMimeAttachment activityid Unique identifier of the activity with which the attachment is associated. Lookup
ActivityMimeAttachment activitymimeattachmentid Unique identifier of the attachment. Uniqueidentifier
ActivityMimeAttachment activitymimeattachmentidunique For internal use only. Uniqueidentifier
ActivityMimeAttachment activitysubject Descriptive subject for the activity. String
ActivityMimeAttachment anonymouslink anonymous link String
ActivityMimeAttachment attachmentcontentid For internal use only String
ActivityMimeAttachment attachmentid Unique identifier of the attachment with which this activitymimeattachment is associated. Lookup
ActivityMimeAttachment attachmentnumber Number of the attachment. Integer
ActivityMimeAttachment body Contents of the attachment. String
ActivityMimeAttachment componentstate For internal use only. Picklist
ActivityMimeAttachment filename File name of the attachment. String
ActivityMimeAttachment filesize File size of the attachment. Integer
ActivityMimeAttachment isfollowed Indicates if this attachment is followed. Boolean
ActivityMimeAttachment ismanaged Indicates whether the solution component is part of a managed solution. Boolean
ActivityMimeAttachment mimetype MIME type of the attachment. String
ActivityMimeAttachment objectid Unique identifier of the record with which the attachment is associated Lookup
ActivityMimeAttachment objecttypecode Object Type Code of the entity that is associated with the attachment. EntityName
ActivityMimeAttachment overwritetime For internal use only. DateTime
ActivityMimeAttachment ownerid Unique identifier of the user or team who owns the activity_mime_attachment. Owner
ActivityMimeAttachment owningbusinessunit Unique identifier of the business unit that owns the activity mime attachment. Lookup
ActivityMimeAttachment owninguser Unique identifier of the user who owns the activity mime attachment. Lookup
ActivityMimeAttachment solutionid Unique identifier of the associated solution. Uniqueidentifier
ActivityMimeAttachment subject Descriptive subject for the attachment. String
ActivityMimeAttachment supportingsolutionid For internal use only. Uniqueidentifier
ActivityMimeAttachment versionnumber Version number of the activity mime attachment. BigInt
ActivityParty activityid Unique identifier of the activity associated with the activity party. (A “party” is any person who is associated with an activity.) Lookup
ActivityParty activitypartyid Unique identifier of the activity party. Uniqueidentifier
ActivityParty addressused Email address to which an email is delivered, and which is associated with the target entity. String
ActivityParty addressusedemailcolumnnumber Email address column number from associated party. Integer
ActivityParty donotemail Information about whether to allow sending email to the activity party. Boolean
ActivityParty donotfax Information about whether to allow sending faxes to the activity party. Boolean
ActivityParty donotphone Information about whether to allow phone calls to the lead. Boolean
ActivityParty donotpostalmail Information about whether to allow sending postal mail to the lead. Boolean
ActivityParty effort Amount of effort used by the resource in a service appointment activity. Double
ActivityParty exchangeentryid For internal use only. String
ActivityParty instancetypecode Type of instance of a recurring series. Picklist
ActivityParty ispartydeleted Information about whether the underlying entity record is deleted. Boolean
ActivityParty ownerid Unique identifier of the user or team who owns the activity_party. Owner
ActivityParty owningbusinessunit Uniqueidentifier
ActivityParty owninguser Uniqueidentifier
ActivityParty participationtypemask Role of the person in the activity, such as sender, to, cc, bcc, required, optional, organizer, regarding, or owner. Picklist
ActivityParty partyid Unique identifier of the party associated with the activity. Lookup
ActivityParty resourcespecid Unique identifier of the resource specification for the activity party. Lookup
ActivityParty scheduledend Scheduled end time of the activity. DateTime
ActivityParty scheduledstart Scheduled start time of the activity. DateTime
ActivityParty versionnumber BigInt
ActivityPointer activityadditionalparams Additional information provided by the external application as JSON. For internal use only. Memo
ActivityPointer activityid Unique identifier of the activity. Uniqueidentifier
ActivityPointer activitytypecode Type of activity. EntityName
ActivityPointer actualdurationminutes Actual duration of the activity in minutes. Integer
ActivityPointer actualend Actual end time of the activity. DateTime
ActivityPointer actualstart Actual start time of the activity. DateTime
ActivityPointer allparties All activity parties associated with this activity. PartyList
ActivityPointer community Shows how contact about the social activity originated, such as from Twitter or Facebook. This field is read-only. Picklist
ActivityPointer createdby Unique identifier of the user who created the activity. Lookup
ActivityPointer createdon Date and time when the activity was created. DateTime
ActivityPointer createdonbehalfby Unique identifier of the delegate user who created the activitypointer. Lookup
ActivityPointer deliverylastattemptedon Date and time when the delivery of the activity was last attempted. DateTime
ActivityPointer deliveryprioritycode Priority of delivery of the activity to the email server. Picklist
ActivityPointer description Description of the activity. Memo
ActivityPointer exchangeitemid The message id of activity which is returned from Exchange Server. String
ActivityPointer exchangerate Exchange rate for the currency associated with the activitypointer with respect to the base currency. Decimal
ActivityPointer exchangeweblink Shows the web link of Activity of type email. String
ActivityPointer instancetypecode Type of instance of a recurring series. Picklist
ActivityPointer isbilled Information regarding whether the activity was billed as part of resolving a case. Boolean
ActivityPointer ismapiprivate For internal use only. Boolean
ActivityPointer isregularactivity Information regarding whether the activity is a regular activity type or event type. Boolean
ActivityPointer isworkflowcreated Information regarding whether the activity was created from a workflow rule. Boolean
ActivityPointer lastonholdtime Contains the date and time stamp of the last on hold time. DateTime
ActivityPointer leftvoicemail Left the voice mail Boolean
ActivityPointer modifiedby Unique identifier of user who last modified the activity. Lookup
ActivityPointer modifiedon Date and time when activity was last modified. DateTime
ActivityPointer modifiedonbehalfby Unique identifier of the delegate user who last modified the activitypointer. Lookup
ActivityPointer onholdtime Shows how long, in minutes, that the record was on hold. Integer
ActivityPointer ownerid Unique identifier of the user or team who owns the activity. Owner
ActivityPointer owningbusinessunit Unique identifier of the business unit that owns the activity. Lookup
ActivityPointer owningteam Unique identifier of the team that owns the activity. Lookup
ActivityPointer owninguser Unique identifier of the user that owns the activity. Lookup
ActivityPointer postponeactivityprocessinguntil For internal use only. DateTime
ActivityPointer prioritycode Priority of the activity. Picklist
ActivityPointer processid Unique identifier of the Process. Uniqueidentifier
ActivityPointer regardingobjectid Unique identifier of the object with which the activity is associated. Lookup
ActivityPointer scheduleddurationminutes Scheduled duration of the activity, specified in minutes. Integer
ActivityPointer scheduledend Scheduled end time of the activity. DateTime
ActivityPointer scheduledstart Scheduled start time of the activity. DateTime
ActivityPointer sendermailboxid Unique identifier of the mailbox associated with the sender of the email message. Lookup
ActivityPointer senton Date and time when the activity was sent. DateTime
ActivityPointer seriesid Uniqueidentifier specifying the id of recurring series of an instance. Uniqueidentifier
ActivityPointer serviceid Unique identifier of an associated service. Lookup
ActivityPointer slaid Choose the service level agreement (SLA) that you want to apply to the case record. Lookup
ActivityPointer slainvokedid Last SLA that was applied to this case. This field is for internal use only. Lookup
ActivityPointer sortdate Shows the date and time by which the activities are sorted. DateTime
ActivityPointer stageid Unique identifier of the Stage. Uniqueidentifier
ActivityPointer statecode Status of the activity. State
ActivityPointer statuscode Reason for the status of the activity. Status
ActivityPointer subject Subject associated with the activity. String
ActivityPointer timezoneruleversionnumber For internal use only. Integer
ActivityPointer transactioncurrencyid Unique identifier of the currency associated with the activitypointer. Lookup
ActivityPointer traversedpath For internal use only. String
ActivityPointer utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
ActivityPointer versionnumber Version number of the activity. BigInt
AdvancedSimilarityRule advancedsimilarityruleid Unique identifier for entity instances Uniqueidentifier
AdvancedSimilarityRule advancedsimilarityruleidunique Unique identifier of the Advanced Similarity Rule used when synchronizing customizations for the Microsoft Dynamics 365 client for Outlook Uniqueidentifier
AdvancedSimilarityRule azureserviceconnectionid Unique identifier for AzureServiceConnection associated with AdvancedSimilarityRule. Lookup
AdvancedSimilarityRule componentstate For internal use only. Picklist
AdvancedSimilarityRule createdby Unique identifier of the user who created the Advanced Similarity Rules. Lookup
AdvancedSimilarityRule createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
AdvancedSimilarityRule createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
AdvancedSimilarityRule description Enter a description for the Advanced Similarity Rule Memo
AdvancedSimilarityRule entity entity String
AdvancedSimilarityRule exactmatchlist For internal use only. Memo
AdvancedSimilarityRule fetchxmllist For internal use only. Memo
AdvancedSimilarityRule filterresultbystatus Filter Result By Status EntityName
AdvancedSimilarityRule filterresultbystatusdisplayname Filter Result By Status String
AdvancedSimilarityRule isazuremlrequired Use Text Analytics for Target Match Boolean
AdvancedSimilarityRule ismanaged Is Manageed Boolean
AdvancedSimilarityRule maxnumberkeyphrases Enter the maximum number of keywords and key phrases to use with text analytics. Integer
AdvancedSimilarityRule modifiedby Unique identifier of the user who modified the Advanced Similarity Rules. Lookup
AdvancedSimilarityRule modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
AdvancedSimilarityRule modifiedonbehalfby Unique identifier of the delegate user who last modified the advanced similarity rules. Lookup
AdvancedSimilarityRule name Type a logical name for the similarity configuration String
AdvancedSimilarityRule ngramsize Enter the maximum number of words in a key phrase to use with text analytics. Integer
AdvancedSimilarityRule organizationid Unique identifier of the organization associated with the advanced similarity rules Lookup
AdvancedSimilarityRule overwritetime Date and time when the record was created. DateTime
AdvancedSimilarityRule solutionid Unique identifier of the associated solution. Uniqueidentifier
AdvancedSimilarityRule sourceentity Enter an entity that similar records will be suggested for EntityName
AdvancedSimilarityRule statecode Status of the advanced similarity rules State
AdvancedSimilarityRule statuscode Reason for the status of the advanced similarity rules Status
AdvancedSimilarityRule supportingsolutionid For internal use only. Uniqueidentifier
Annotation annotationid Unique identifier of the note. Uniqueidentifier
Annotation createdby Unique identifier of the user who created the note. Lookup
Annotation createdon Date and time when the note was created. DateTime
Annotation createdonbehalfby Unique identifier of the delegate user who created the annotation. Lookup
Annotation documentbody Contents of the note’s attachment. String
Annotation filename File name of the note. String
Annotation filesize File size of the note. Integer
Annotation importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Annotation isdocument Specifies whether the note is an attachment. Boolean
Annotation isprivate Boolean
Annotation langid Language identifier for the note. String
Annotation mimetype MIME type of the note’s attachment. String
Annotation modifiedby Unique identifier of the user who last modified the note. Lookup
Annotation modifiedon Date and time when the note was last modified. DateTime
Annotation modifiedonbehalfby Unique identifier of the delegate user who last modified the annotation. Lookup
Annotation notetext Text of the note. Memo
Annotation objectid Unique identifier of the object with which the note is associated. Lookup
Annotation objecttypecode Type of entity with which the note is associated. EntityName
Annotation overriddencreatedon Date and time that the record was migrated. DateTime
Annotation ownerid Unique identifier of the user or team who owns the note. Owner
Annotation owningbusinessunit Unique identifier of the business unit that owns the note. Lookup
Annotation owningteam Unique identifier of the team who owns the note. Lookup
Annotation owninguser Unique identifier of the user who owns the note. Lookup
Annotation stepid workflow step id associated with the note. String
Annotation subject Subject associated with the note. String
Annotation versionnumber Version number of the note. BigInt
AnnualFiscalCalendar annual Sales quota for the first period in the fiscal year. Money
AnnualFiscalCalendar annual_base Base currency equivalent of the sales quota for the first period in the fiscal year. Money
AnnualFiscalCalendar businessunitid Lookup
AnnualFiscalCalendar createdby Unique identifier of the user who created the quota for the annual fiscal calendar. Lookup
AnnualFiscalCalendar createdon Date and time when the quota for the annual fiscal calendar was created. DateTime
AnnualFiscalCalendar createdonbehalfby Unique identifier of the delegate user who created the annualfiscalcalendar. Lookup
AnnualFiscalCalendar effectiveon Date and time when the fiscal calendar sales quota takes effect. DateTime
AnnualFiscalCalendar exchangerate Exchange rate for the currency associated with the annual fiscal calendar with respect to the base currency. Decimal
AnnualFiscalCalendar fiscalperiodtype Type of fiscal period used in the sales quota. Integer
AnnualFiscalCalendar modifiedby Unique identifier of the user who last modified the quota for the annual fiscal calendar. Lookup
AnnualFiscalCalendar modifiedon Date and time when the annual fiscal calendar was last modified. DateTime
AnnualFiscalCalendar modifiedonbehalfby Unique identifier of the delegate user who last modified the annualfiscalcalendar. Lookup
AnnualFiscalCalendar salespersonid Unique identifier of the sales person associated with the sales quota. Lookup
AnnualFiscalCalendar timezoneruleversionnumber For internal use only. Integer
AnnualFiscalCalendar transactioncurrencyid Unique identifier of the currency associated with the annual fiscal calendar. Lookup
AnnualFiscalCalendar userfiscalcalendarid Unique identifier of the user associated with the annual fiscal calendar. Uniqueidentifier
AnnualFiscalCalendar utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
ApplicationFile body Body of application file String
ApplicationFile createdby Unique identifier of the user who created the application file. Lookup
ApplicationFile createdon Date and time when the application file was created. DateTime
ApplicationFile createdonbehalfby Unique identifier of the delegate user who created the applicationfile. Lookup
ApplicationFile fileid Unique identifier for application file instances Uniqueidentifier
ApplicationFile modifiedby Unique identifier of the user who last modified the application file. Lookup
ApplicationFile modifiedon Date and time when the application file was modified. DateTime
ApplicationFile modifiedonbehalfby Unique identifier of the delegate user who last modified the applicationfile. Lookup
ApplicationFile name File name String
ApplicationFile organizationid Unique identifier for the organization Lookup
ApplicationFile versionnumber BigInt
AppModule appmoduleid Unique identifier for entity instances Uniqueidentifier
AppModule appmoduleidunique Unique identifier of the App Module used when synchronizing customizations for the Microsoft Dynamics 365 client for Outlook Uniqueidentifier
AppModule appmoduleversion App Module Version String
AppModule appmodulexmlmanaged App Module Xml Managed Memo
AppModule clienttype Client Type such as desktop or MoCA Integer
AppModule componentstate For internal use only Picklist
AppModule configxml Contains configuration XML Memo
AppModule createdby Unique identifier of the user who created the record. Lookup
AppModule createdon Date and time when the record was created. DateTime
AppModule createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
AppModule description Description for entity String
AppModule formfactor Form Factor Integer
AppModule importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
AppModule introducedversion Version in which the similarity rule is introduced. String
AppModule isdefault Is Default Boolean
AppModule isfeatured Is Featured Boolean
AppModule ismanaged Is Managed Boolean
AppModule modifiedby Unique identifier of the user who modified the record. Lookup
AppModule modifiedon Date and time when the record was modified. DateTime
AppModule modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
AppModule name Name of App Module String
AppModule organizationid Unique identifier of the organization associated with the app. Lookup
AppModule overriddencreatedon Date and time that the record was migrated. DateTime
AppModule overwritetime Internal use only DateTime
AppModule publishedon Date and time when the record was published. DateTime
AppModule publisherid Unique identifier of the publisher. Lookup
AppModule solutionid Unique identifier of the associated solution. Uniqueidentifier
AppModule supportingsolutionid For internal use only. Uniqueidentifier
AppModule uniquename Unique Name of App Module String
AppModule url Contains URL String
AppModule versionnumber BigInt
AppModule webresourceid Unique identifier of the Web Resource Uniqueidentifier
AppModuleComponent appmodulecomponentid Unique identifier for entity instances Uniqueidentifier
AppModuleComponent appmodulecomponentidunique Unique identifier of the Application Component used when synchronizing customizations for the Microsoft Dynamics 365 client for Outlook Uniqueidentifier
AppModuleComponent appmoduleidunique The App Module Id Unique Lookup
AppModuleComponent componenttype The object type code of the component. Picklist
AppModuleComponent createdby Unique identifier of the user who created the record. Lookup
AppModuleComponent createdon Date and time when the record was created. DateTime
AppModuleComponent createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
AppModuleComponent exchangerate Exchange rate for the currency associated with the Application Component with respect to the base currency. Decimal
AppModuleComponent introducedversion Version in which the application component record is introduced. String
AppModuleComponent isdefault Is Default Boolean
AppModuleComponent ismetadata Is Metadata Boolean
AppModuleComponent modifiedby Unique identifier of the user who modified the record. Lookup
AppModuleComponent modifiedon Date and time when the record was modified. DateTime
AppModuleComponent modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
AppModuleComponent objectid Object Id Uniqueidentifier
AppModuleComponent overwritetime Date and time when the record was created. DateTime
AppModuleComponent rootappmodulecomponentid The parent ID of the subcomponent, which will be a root Uniqueidentifier
AppModuleComponent rootcomponentbehavior Indicates the include behavior of the root component. Picklist
AppModuleComponent timezoneruleversionnumber For internal use only. Integer
AppModuleComponent utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
AppModuleComponent versionnumber BigInt
AppModuleRoles appmoduleid Unique identifier of the app module. Lookup
AppModuleRoles appmoduleroleid For internal use only. Uniqueidentifier
AppModuleRoles appmoduleroleidunique Uniqueidentifier
AppModuleRoles componentstate Picklist
AppModuleRoles introducedversion String
AppModuleRoles ismanaged Boolean
AppModuleRoles overwritetime DateTime
AppModuleRoles roleid Lookup
AppModuleRoles solutionid Uniqueidentifier
AppModuleRoles supportingsolutionid Uniqueidentifier
AppModuleRoles versionnumber BigInt
Appointment activityadditionalparams For internal use only. Memo
Appointment activityid Unique identifier of the appointment. Uniqueidentifier
Appointment activitytypecode Type of activity. EntityName
Appointment actualdurationminutes Shows the value selected in the Duration field on the appointment at the time that the appointment is closed as completed. The duration is used to report the time spent on the activity. Integer
Appointment actualend Enter the actual end date and time of the appointment. By default, it displays the date and time when the activity was completed or canceled, but can be edited to capture the actual duration of the appointment. DateTime
Appointment actualstart Enter the actual start date and time for the appointment. By default, it displays the date and time when the activity was created, but can be edited to capture the actual duration of the appointment. DateTime
Appointment attachmentcount Shows the number of attachments on the appointment. Integer
Appointment attachmenterrors Select the error code to identify issues with the outlook item recipients or attachments, such as blocked attachments. Picklist
Appointment category Type a category to identify the appointment type, such as sales demo, prospect call, or service call, to tie the appointment to a business group or function. String
Appointment createdby Shows who created the record. Lookup
Appointment createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Appointment createdonbehalfby Shows who created the record on behalf of another user. Lookup
Appointment description Type additional information to describe the purpose of the appointment. Memo
Appointment exchangerate 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. Decimal
Appointment globalobjectid Shows the ID of the appointment in Microsoft Office Outlook. The ID is used to synchronize the appointment between Microsoft Dynamics 365 and the correct Exchange account. String
Appointment importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Appointment instancetypecode Type of instance of a recurring series. Picklist
Appointment isalldayevent Select whether the appointment is an all-day event to make sure that the required resources are scheduled for the full day. Boolean
Appointment isbilled Information regarding whether the appointment was billed as part of resolving a case. Boolean
Appointment ismapiprivate For internal use only. Boolean
Appointment isregularactivity Information regarding whether the activity is a regular activity type or event type. Boolean
Appointment isworkflowcreated Information regarding whether the appointment was created from a workflow rule. Boolean
Appointment lastonholdtime Contains the date and time stamp of the last on hold time. DateTime
Appointment location Type the location where the appointment will take place, such as a conference room or customer office. String
Appointment modifiedby Shows who last updated the record. Lookup
Appointment modifiedfieldsmask For internal use only. Memo
Appointment modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Appointment modifiedonbehalfby Shows who created the record on behalf of another user. Lookup
Appointment onholdtime Shows how long, in minutes, that the record was on hold. Integer
Appointment optionalattendees Enter the account, contact, lead, user, or other equipment resources that are not needed at the appointment, but can optionally attend. PartyList
Appointment organizer Enter the user who is in charge of coordinating or leading the appointment to make sure the appointment is displayed in the user’s My Activities view. PartyList
Appointment originalstartdate The original start date of the appointment. DateTime
Appointment outlookownerapptid Unique identifier of the Microsoft Office Outlook appointment owner that correlates to the PR_OWNER_APPT_ID MAPI property. Integer
Appointment overriddencreatedon Date and time that the record was migrated. DateTime
Appointment ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
Appointment owningbusinessunit Shows the business unit that the record owner belongs to. Lookup
Appointment owningteam Unique identifier of the team that owns the appointment. Lookup
Appointment owninguser Unique identifier of the user that owns the appointment. Lookup
Appointment prioritycode Select the priority so that preferred customers or critical issues are handled quickly. Picklist
Appointment processid Shows the ID of the process. Uniqueidentifier
Appointment regardingobjectid Choose the record that the appointment relates to. Lookup
Appointment requiredattendees Enter the account, contact, lead, user, or other equipment resources that are required to attend the appointment. PartyList
Appointment scheduleddurationminutes Shows the expected duration of the appointment, in minutes. Integer
Appointment scheduledend Enter the expected due date and time for the activity to be completed to provide details about the timing of the appointment. DateTime
Appointment scheduledstart Enter the expected start date and time for the activity to provide details about the timing of the appointment. DateTime
Appointment seriesid Shows the ID of the recurring series of an instance. Uniqueidentifier
Appointment serviceid Unique identifier for an associated service. Lookup
Appointment slaid Choose the service level agreement (SLA) that you want to apply to the appointment record. Lookup
Appointment slainvokedid Last SLA that was applied to this appointment. This field is for internal use only. Lookup
Appointment sortdate Shows the date and time by which the activities are sorted. DateTime
Appointment stageid Shows the ID of the stage. Uniqueidentifier
Appointment statecode Shows whether the appointment is open, completed, or canceled. Completed and canceled appointments are read-only and can’t be edited. State
Appointment statuscode Select the appointment’s status. Status
Appointment subcategory Type a subcategory to identify the appointment type and relate the activity to a specific product, sales region, business group, or other function. String
Appointment subject Type a short description about the objective or primary topic of the appointment. String
Appointment subscriptionid For internal use only. Uniqueidentifier
Appointment timezoneruleversionnumber For internal use only. Integer
Appointment transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Appointment traversedpath For internal use only. String
Appointment utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Appointment versionnumber Version number of the appointment. BigInt
AsyncOperation asyncoperationid Unique identifier of the system job. Uniqueidentifier
AsyncOperation completedon Date and time when the system job was completed. DateTime
AsyncOperation correlationid Unique identifier used to correlate between multiple SDK requests and system jobs. Uniqueidentifier
AsyncOperation correlationupdatedtime Last time the correlation depth was updated. DateTime
AsyncOperation createdby Unique identifier of the user who created the system job. Lookup
AsyncOperation createdon Date and time when the system job was created. DateTime
AsyncOperation createdonbehalfby Unique identifier of the delegate user who created the asyncoperation. Lookup
AsyncOperation data Unstructured data associated with the system job. Memo
AsyncOperation dependencytoken Execution of all operations with the same dependency token is serialized. String
AsyncOperation depth Number of SDK calls made since the first call. Integer
AsyncOperation errorcode Error code returned from a canceled system job. Integer
AsyncOperation executiontimespan Time that the system job has taken to execute. Double
AsyncOperation friendlymessage Message provided by the system job. Memo
AsyncOperation hostid Unique identifier of the host that owns this system job. String
AsyncOperation iswaitingforevent Indicates that the system job is waiting for an event. Boolean
AsyncOperation message Message related to the system job. Memo
AsyncOperation messagename Name of the message that started this system job. String
AsyncOperation modifiedby Unique identifier of the user who last modified the system job. Lookup
AsyncOperation modifiedon Date and time when the system job was last modified. DateTime
AsyncOperation modifiedonbehalfby Unique identifier of the delegate user who last modified the asyncoperation. Lookup
AsyncOperation name Name of the system job. String
AsyncOperation operationtype Type of the system job. Picklist
AsyncOperation ownerid Unique identifier of the user or team who owns the system job. Owner
AsyncOperation owningbusinessunit Unique identifier of the business unit that owns the system job. Lookup
AsyncOperation owningextensionid Unique identifier of the owning extension with which the system job is associated. Lookup
AsyncOperation owningteam Unique identifier of the team who owns the record. Lookup
AsyncOperation owninguser Unique identifier of the user who owns the record. Lookup
AsyncOperation parentpluginexecutionid Uniqueidentifier
AsyncOperation postponeuntil Indicates whether the system job should run only after the specified date and time. DateTime
AsyncOperation primaryentitytype Type of entity with which the system job is primarily associated. EntityName
AsyncOperation recurrencepattern Pattern of the system job’s recurrence. String
AsyncOperation recurrencestarttime Starting time in UTC for the recurrence pattern. DateTime
AsyncOperation regardingobjectid Unique identifier of the object with which the system job is associated. Lookup
AsyncOperation requestid Unique identifier of the request that generated the system job. Uniqueidentifier
AsyncOperation retrycount Number of times to retry the system job. Integer
AsyncOperation sequence Order in which operations were submitted. BigInt
AsyncOperation startedon Date and time when the system job was started. DateTime
AsyncOperation statecode Status of the system job. State
AsyncOperation statuscode Reason for the status of the system job. Status
AsyncOperation subtype The Subtype of the Async Job Integer
AsyncOperation timezoneruleversionnumber For internal use only. Integer
AsyncOperation utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
AsyncOperation workflowactivationid Unique identifier of the workflow activation related to the system job. Lookup
AsyncOperation workflowisblocked Indicates whether the workflow instance was blocked when it was persisted. Boolean
AsyncOperation workflowstagename Name of a workflow stage. String
AsyncOperation workflowstate State of the workflow job. String
Attachment attachmentid Unique identifier of the attachment. Uniqueidentifier
Attachment body Contents of the attachment. String
Attachment filename File name of the attachment. String
Attachment filesize File size of the attachment. Integer
Attachment mimetype MIME type of the attachment. String
Attachment subject Subject associated with the attachment. String
Attachment versionnumber Version number of the attachment. BigInt
AttributeMap attributemapid Unique identifier of the attribute map. Uniqueidentifier
AttributeMap attributemapidunique For internal use only. Uniqueidentifier
AttributeMap componentstate For internal use only. Picklist
AttributeMap createdby Unique identifier of the user who created the attribute map. Lookup
AttributeMap createdon Date and time when the attribute map was created. DateTime
AttributeMap createdonbehalfby Unique identifier of the delegate user who created the attributemap. Lookup
AttributeMap entitymapid Unique identifier of the entity map with which the attribute map is associated. Lookup
AttributeMap ismanaged Boolean
AttributeMap issystem Information about whether this attribute map is user-defined or system-defined. Boolean
AttributeMap modifiedby Unique identifier of the user who last modified the attribute map. Lookup
AttributeMap modifiedon Date and time when the attribute map was last modified. DateTime
AttributeMap modifiedonbehalfby Unique identifier of the delegate user who last modified the attributemap. Lookup
AttributeMap organizationid Unique identifier of the organization with which the attribute map is associated. Lookup
AttributeMap overwritetime For internal use only. DateTime
AttributeMap parentattributemapid Unique identifier of the parent attribute map. Lookup
AttributeMap solutionid Unique identifier of the associated solution. Uniqueidentifier
AttributeMap sourceattributename Name of the source attribute for the mapping. String
AttributeMap supportingsolutionid For internal use only. Uniqueidentifier
AttributeMap targetattributename Name of the target attribute for the mapping. String
AttributeMap versionnumber BigInt
Audit action Actions the user can perform that cause a change Picklist
Audit attributemask Contains a CSV of the ColumnNumber metadata property of attributes Memo
Audit auditid Unique identifier of the auditing instance Uniqueidentifier
Audit callinguserid Unique identifier of the calling user in case of an impersonated call Lookup
Audit changedata Contains a CSV of old values of all the attributes whose IsAuditEnabled property is True and are being changed Memo
Audit createdon Date and time when the audit record was created. DateTime
Audit objectid Unique identifier of the record that is being audited Lookup
Audit operation The action that causes the audit–it will be create, delete, or update Picklist
Audit regardingobjectid Unique identifier of the object with which the record is associated. Lookup
Audit transactionid Unique identifier for multiple changes that are part of a single operation; this field contains the same GUID for all the audit rows generated in a single transaction Uniqueidentifier
Audit useradditionalinfo Additional information associated to the user who caused the change. String
Audit userid Unique identifier of the user who caused a change Lookup
AuthorizationServer authorizationserverid Unique identifier for entity instances Uniqueidentifier
AuthorizationServer authorizationservertype The type of the Authorization Server Picklist
AuthorizationServer createdby Unique identifier of the user who created the record. Lookup
AuthorizationServer createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
AuthorizationServer createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
AuthorizationServer metadata Contains the metadata for the authorization server. String
AuthorizationServer metadatarefreshedon Shows the date and time when the metadata was refreshed from the authorization server. DateTime
AuthorizationServer metadataurl Contains the URL for the metadata. String
AuthorizationServer modifiedby Shows who last updated the record. Lookup
AuthorizationServer modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
AuthorizationServer modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
AuthorizationServer name Type the name of the authorization server. String
AuthorizationServer organizationid Unique identifier for the organization Lookup
AuthorizationServer principalid Contains the issuer ID of the authorization server. String
AuthorizationServer realm Indicates the realm. String
AuthorizationServer statecode Shows whether the authorization server is active or inactive. State
AuthorizationServer statuscode Select the authorization server’s status. Status
AuthorizationServer tenantid Shows the tenant ID. Uniqueidentifier
AuthorizationServer timezoneruleversionnumber For internal use only. Integer
AuthorizationServer utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
AzureServiceConnection accountkey Type the Azure account key. String
AzureServiceConnection azureserviceconnectionid Unique identifier of the Azure service connection. Uniqueidentifier
AzureServiceConnection connectiontype Azure service connection type Picklist
AzureServiceConnection createdby Unique identifier of the user who created the Azure service connection. Lookup
AzureServiceConnection createdon Date and time when the Azure service connection was created. DateTime
AzureServiceConnection createdonbehalfby Unique identifier of the delegate user who created the Azure service connection. Lookup
AzureServiceConnection description Enter a description of the Azure service connection. Memo
AzureServiceConnection lastconnectionstatuscode Shows the status of the last connection to the Azure service. Picklist
AzureServiceConnection lastconnectiontime shows the time of the last connection to the Azure service. DateTime
AzureServiceConnection modifiedby Unique identifier of the user who modified the Azure service connection. Lookup
AzureServiceConnection modifiedon Date and time when the Azure service connection was last modified. DateTime
AzureServiceConnection modifiedonbehalfby Unique identifier of the delegate user who last modified the Azure service connection. Lookup
AzureServiceConnection name Type a logical name for the connection. String
AzureServiceConnection organizationid Unique identifier of the organization associated with the Azure service connection. Lookup
AzureServiceConnection serviceuri Type the service URL for the Azure service. String
AzureServiceConnection statecode Shows whether the Azure service connection is active or inactive. State
AzureServiceConnection statuscode Select the Azure service connection’s status. Status
BookableResource accountid Select the account that represents this resource. Lookup
BookableResource bookableresourceid Unique identifier of the resource. Uniqueidentifier
BookableResource calendarid Specifies the working days and hours of the resource. Lookup
BookableResource contactid Select the contact that represents this resource. Lookup
BookableResource createdby Unique identifier of the user who created the record. Lookup
BookableResource createdon Date and time when the record was created. DateTime
BookableResource createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
BookableResource exchangerate Exchange rate for the currency associated with the bookableresource with respect to the base currency. Decimal
BookableResource importsequencenumber Sequence number of the import that created this record. Integer
BookableResource modifiedby Unique identifier of the user who modified the record. Lookup
BookableResource modifiedon Date and time when the record was modified. DateTime
BookableResource modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
BookableResource name Type the name of the resource. String
BookableResource overriddencreatedon Date and time that the record was migrated. DateTime
BookableResource ownerid Unique identifier of the user or team who owns the record. Owner
BookableResource owningbusinessunit Unique identifier for the business unit that owns the record Lookup
BookableResource owningteam Unique identifier for the team that owns the record. Lookup
BookableResource owninguser Unique identifier for the user that owns the record. Lookup
BookableResource processid Shows the ID of the process. Uniqueidentifier
BookableResource resourcetype Select whether the resource is a user, equipment, contact, account, generic resource or a group of resources. Picklist
BookableResource stageid Shows the ID of the stage. Uniqueidentifier
BookableResource statecode Status of the Bookable Resource State
BookableResource statuscode Reason for the status of the Bookable Resource Status
BookableResource timezone Specifies the timezone for the resource’s working hours. Integer
BookableResource timezoneruleversionnumber For internal use only. Integer
BookableResource transactioncurrencyid Exchange rate for the currency associated with the BookableResource with respect to the base currency. Lookup
BookableResource traversedpath For internal use only. String
BookableResource userid Select the user who represents this resource. Lookup
BookableResource utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
BookableResource versionnumber BigInt
BookableResourceBooking bookableresourcebookingid Unique identifier of the resource booking. Uniqueidentifier
BookableResourceBooking bookingstatus Select the status of the booking. Lookup
BookableResourceBooking bookingtype Select whether the booking is solid or liquid. Solid bookings are firm and cannot be changed whereas liquid bookings can be changed. Picklist
BookableResourceBooking createdby Unique identifier of the user who created the record. Lookup
BookableResourceBooking createdon Date and time when the record was created. DateTime
BookableResourceBooking createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
BookableResourceBooking duration Enter the duration of the booking. Integer
BookableResourceBooking endtime Enter the end date and time of the booking. DateTime
BookableResourceBooking exchangerate Exchange rate for the currency associated with the bookableresourcebooking with respect to the base currency. Decimal
BookableResourceBooking header Shows the reference to the booking header record that represents the summary of bookings. Lookup
BookableResourceBooking importsequencenumber Sequence number of the import that created this record. Integer
BookableResourceBooking modifiedby Unique identifier of the user who modified the record. Lookup
BookableResourceBooking modifiedon Date and time when the record was modified. DateTime
BookableResourceBooking modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
BookableResourceBooking name Type a name for the booking. String
BookableResourceBooking overriddencreatedon Date and time that the record was migrated. DateTime
BookableResourceBooking ownerid Unique identifier of the user or team who owns the record. Owner
BookableResourceBooking owningbusinessunit Unique identifier for the business unit that owns the record Lookup
BookableResourceBooking owningteam Unique identifier for the team that owns the record. Lookup
BookableResourceBooking owninguser Unique identifier for the user that owns the record. Lookup
BookableResourceBooking processid Shows the ID of the process. Uniqueidentifier
BookableResourceBooking resource Shows the resource that is booked. Lookup
BookableResourceBooking stageid Shows the ID of the stage. Uniqueidentifier
BookableResourceBooking starttime Enter the start date and time of the booking. DateTime
BookableResourceBooking statecode Status of the Bookable Resource Booking State
BookableResourceBooking statuscode Reason for the status of the Bookable Resource Booking Status
BookableResourceBooking timezoneruleversionnumber For internal use only. Integer
BookableResourceBooking transactioncurrencyid Exchange rate for the currency associated with the BookableResourceBooking with respect to the base currency. Lookup
BookableResourceBooking traversedpath For internal use only. String
BookableResourceBooking utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
BookableResourceBooking versionnumber BigInt
BookableResourceBookingExchangeSyncIdMapping bookableresourcebookingexchangesyncidmappingid Uniqueidentifier
BookableResourceBookingExchangeSyncIdMapping bookableresourcebookingid Uniqueidentifier
BookableResourceBookingExchangeSyncIdMapping createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
BookableResourceBookingExchangeSyncIdMapping exchangeentryid String
BookableResourceBookingExchangeSyncIdMapping isdeletedinexchange Boolean
BookableResourceBookingExchangeSyncIdMapping lastsyncerror String
BookableResourceBookingExchangeSyncIdMapping lastsyncerrorcode Integer
BookableResourceBookingExchangeSyncIdMapping lastsyncerroroccurredon Last Sync Error Time DateTime
BookableResourceBookingExchangeSyncIdMapping modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
BookableResourceBookingExchangeSyncIdMapping ownerid Owner
BookableResourceBookingExchangeSyncIdMapping owningbusinessunit Lookup
BookableResourceBookingExchangeSyncIdMapping owningteam Lookup
BookableResourceBookingExchangeSyncIdMapping owninguser Lookup
BookableResourceBookingExchangeSyncIdMapping retries Integer
BookableResourceBookingExchangeSyncIdMapping syncstatus Picklist
BookableResourceBookingExchangeSyncIdMapping syncversionnumber BigInt
BookableResourceBookingExchangeSyncIdMapping userid Lookup
BookableResourceBookingExchangeSyncIdMapping versionnumber BigInt
BookableResourceBookingHeader bookableresourcebookingheaderid Unique identifier of the resource booking header. Uniqueidentifier
BookableResourceBookingHeader createdby Unique identifier of the user who created the record. Lookup
BookableResourceBookingHeader createdon Date and time when the record was created. DateTime
BookableResourceBookingHeader createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
BookableResourceBookingHeader duration Shows the aggregate duration of the linked bookings. Integer
BookableResourceBookingHeader endtime Shows the end date and time of the booking summary. DateTime
BookableResourceBookingHeader exchangerate Exchange rate for the currency associated with the bookableresourcebookingheader with respect to the base currency. Decimal
BookableResourceBookingHeader importsequencenumber Sequence number of the import that created this record. Integer
BookableResourceBookingHeader modifiedby Unique identifier of the user who modified the record. Lookup
BookableResourceBookingHeader modifiedon Date and time when the record was modified. DateTime
BookableResourceBookingHeader modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
BookableResourceBookingHeader name The name of the booking summary. String
BookableResourceBookingHeader overriddencreatedon Date and time that the record was migrated. DateTime
BookableResourceBookingHeader ownerid Unique identifier of the user or team who owns the record. Owner
BookableResourceBookingHeader owningbusinessunit Unique identifier for the business unit that owns the record Lookup
BookableResourceBookingHeader owningteam Unique identifier for the team that owns the record. Lookup
BookableResourceBookingHeader owninguser Unique identifier for the user that owns the record. Lookup
BookableResourceBookingHeader processid Shows the ID of the process. Uniqueidentifier
BookableResourceBookingHeader stageid Shows the ID of the stage. Uniqueidentifier
BookableResourceBookingHeader starttime Shows the start date and time of the booking summary. DateTime
BookableResourceBookingHeader statecode Status of the Bookable Resource Booking Header State
BookableResourceBookingHeader statuscode Reason for the status of the Bookable Resource Booking Header Status
BookableResourceBookingHeader timezoneruleversionnumber For internal use only. Integer
BookableResourceBookingHeader transactioncurrencyid Exchange rate for the currency associated with the BookableResourceBookingHeader with respect to the base currency. Lookup
BookableResourceBookingHeader traversedpath For internal use only. String
BookableResourceBookingHeader utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
BookableResourceBookingHeader versionnumber BigInt
BookableResourceCategory bookableresourcecategoryid Unique identifier of the resource category. Uniqueidentifier
BookableResourceCategory createdby Unique identifier of the user who created the record. Lookup
BookableResourceCategory createdon Date and time when the record was created. DateTime
BookableResourceCategory createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
BookableResourceCategory description Type a detailed description of what the categorization is about. String
BookableResourceCategory exchangerate Exchange rate for the currency associated with the bookableresourcecategory with respect to the base currency. Decimal
BookableResourceCategory importsequencenumber Sequence number of the import that created this record. Integer
BookableResourceCategory modifiedby Unique identifier of the user who modified the record. Lookup
BookableResourceCategory modifiedon Date and time when the record was modified. DateTime
BookableResourceCategory modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
BookableResourceCategory name Type the name of the resource category. String
BookableResourceCategory overriddencreatedon Date and time that the record was migrated. DateTime
BookableResourceCategory ownerid Unique identifier of the user or team who owns the record. Owner
BookableResourceCategory owningbusinessunit Unique identifier for the business unit that owns the record Lookup
BookableResourceCategory owningteam Unique identifier for the team that owns the record. Lookup
BookableResourceCategory owninguser Unique identifier for the user that owns the record. Lookup
BookableResourceCategory statecode Status of the Resource Category State
BookableResourceCategory statuscode Reason for the status of the Resource Category Status
BookableResourceCategory timezoneruleversionnumber For internal use only. Integer
BookableResourceCategory transactioncurrencyid Exchange rate for the currency associated with the BookableResourceCategory with respect to the base currency. Lookup
BookableResourceCategory utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
BookableResourceCategory versionnumber BigInt
BookableResourceCategoryAssn bookableresourcecategoryassnid Unique identifier of the resource and category association. Uniqueidentifier
BookableResourceCategoryAssn createdby Unique identifier of the user who created the record. Lookup
BookableResourceCategoryAssn createdon Date and time when the record was created. DateTime
BookableResourceCategoryAssn createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
BookableResourceCategoryAssn exchangerate Exchange rate for the currency associated with the bookableresourcecategoryassn with respect to the base currency. Decimal
BookableResourceCategoryAssn importsequencenumber Sequence number of the import that created this record. Integer
BookableResourceCategoryAssn modifiedby Unique identifier of the user who modified the record. Lookup
BookableResourceCategoryAssn modifiedon Date and time when the record was modified. DateTime
BookableResourceCategoryAssn modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
BookableResourceCategoryAssn name The name of the association beween a resource and a category. String
BookableResourceCategoryAssn overriddencreatedon Date and time that the record was migrated. DateTime
BookableResourceCategoryAssn ownerid Unique identifier of the user or team who owns the record. Owner
BookableResourceCategoryAssn owningbusinessunit Unique identifier for the business unit that owns the record Lookup
BookableResourceCategoryAssn owningteam Unique identifier for the team that owns the record. Lookup
BookableResourceCategoryAssn owninguser Unique identifier for the user that owns the record. Lookup
BookableResourceCategoryAssn resource Shows the resource associated with the category. Lookup
BookableResourceCategoryAssn resourcecategory Choose a category to associate with the resource. Lookup
BookableResourceCategoryAssn statecode Status of the Resource Category Assn State
BookableResourceCategoryAssn statuscode Reason for the status of the Resource Category Assn Status
BookableResourceCategoryAssn timezoneruleversionnumber For internal use only. Integer
BookableResourceCategoryAssn transactioncurrencyid Exchange rate for the currency associated with the BookableResourceCategoryAssn with respect to the base currency. Lookup
BookableResourceCategoryAssn utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
BookableResourceCategoryAssn versionnumber BigInt
BookableResourceCharacteristic bookableresourcecharacteristicid Unique identifier of the resource characteristic. Uniqueidentifier
BookableResourceCharacteristic characteristic Choose the characteristic to associate with the resource. Lookup
BookableResourceCharacteristic createdby Unique identifier of the user who created the record. Lookup
BookableResourceCharacteristic createdon Date and time when the record was created. DateTime
BookableResourceCharacteristic createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
BookableResourceCharacteristic exchangerate Exchange rate for the currency associated with the bookableresourcecharacteristic with respect to the base currency. Decimal
BookableResourceCharacteristic importsequencenumber Sequence number of the import that created this record. Integer
BookableResourceCharacteristic modifiedby Unique identifier of the user who modified the record. Lookup
BookableResourceCharacteristic modifiedon Date and time when the record was modified. DateTime
BookableResourceCharacteristic modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
BookableResourceCharacteristic name Type the name of the association between the resource and characteristic. String
BookableResourceCharacteristic overriddencreatedon Date and time that the record was migrated. DateTime
BookableResourceCharacteristic ownerid Unique identifier of the user or team who owns the record. Owner
BookableResourceCharacteristic owningbusinessunit Unique identifier for the business unit that owns the record Lookup
BookableResourceCharacteristic owningteam Unique identifier for the team that owns the record. Lookup
BookableResourceCharacteristic owninguser Unique identifier for the user that owns the record. Lookup
BookableResourceCharacteristic processid Shows the ID of the process. Uniqueidentifier
BookableResourceCharacteristic ratingvalue Select a rating value that represents the evaluation of a characteristic for a particular resource. Lookup
BookableResourceCharacteristic resource Shows the resource associated with the characteristic. Lookup
BookableResourceCharacteristic stageid Shows the ID of the stage. Uniqueidentifier
BookableResourceCharacteristic statecode Status of the Bookable Resource Characteristic State
BookableResourceCharacteristic statuscode Reason for the status of the Bookable Resource Characteristic Status
BookableResourceCharacteristic timezoneruleversionnumber For internal use only. Integer
BookableResourceCharacteristic transactioncurrencyid Exchange rate for the currency associated with the BookableResourceCharacteristic with respect to the base currency. Lookup
BookableResourceCharacteristic traversedpath For internal use only. String
BookableResourceCharacteristic utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
BookableResourceCharacteristic versionnumber BigInt
BookableResourceGroup bookableresourcegroupid Unique identifier of the resource group. Uniqueidentifier
BookableResourceGroup childresource The child resource that is a part of the group. Lookup
BookableResourceGroup createdby Unique identifier of the user who created the record. Lookup
BookableResourceGroup createdon Date and time when the record was created. DateTime
BookableResourceGroup createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
BookableResourceGroup exchangerate Exchange rate for the currency associated with the bookableresourcegroup with respect to the base currency. Decimal
BookableResourceGroup fromdate Enter the group membership start date. DateTime
BookableResourceGroup importsequencenumber Sequence number of the import that created this record. Integer
BookableResourceGroup modifiedby Unique identifier of the user who modified the record. Lookup
BookableResourceGroup modifiedon Date and time when the record was modified. DateTime
BookableResourceGroup modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
BookableResourceGroup name Type the name of the resource group. String
BookableResourceGroup overriddencreatedon Date and time that the record was migrated. DateTime
BookableResourceGroup ownerid Unique identifier of the user or team who owns the record. Owner
BookableResourceGroup owningbusinessunit Unique identifier for the business unit that owns the record Lookup
BookableResourceGroup owningteam Unique identifier for the team that owns the record. Lookup
BookableResourceGroup owninguser Unique identifier for the user that owns the record. Lookup
BookableResourceGroup parentresource The parent resource that is a part of the group. Lookup
BookableResourceGroup statecode Status of the Bookable Resource Group State
BookableResourceGroup statuscode Reason for the status of the Bookable Resource Group Status
BookableResourceGroup timezoneruleversionnumber For internal use only. Integer
BookableResourceGroup todate Enter the group membership end date. DateTime
BookableResourceGroup transactioncurrencyid Exchange rate for the currency associated with the BookableResourceGroup with respect to the base currency. Lookup
BookableResourceGroup utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
BookableResourceGroup versionnumber BigInt
BookingStatus bookingstatusid Unique identifier of the booking status. Uniqueidentifier
BookingStatus createdby Unique identifier of the user who created the record. Lookup
BookingStatus createdon Date and time when the record was created. DateTime
BookingStatus createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
BookingStatus description Type a detailed description for the booking status. String
BookingStatus exchangerate Exchange rate for the currency associated with the bookingstatus with respect to the base currency. Decimal
BookingStatus importsequencenumber Sequence number of the import that created this record. Integer
BookingStatus modifiedby Unique identifier of the user who modified the record. Lookup
BookingStatus modifiedon Date and time when the record was modified. DateTime
BookingStatus modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
BookingStatus name Type the name of the booking status. String
BookingStatus overriddencreatedon Date and time that the record was migrated. DateTime
BookingStatus ownerid Unique identifier of the user or team who owns the record. Owner
BookingStatus owningbusinessunit Unique identifier for the business unit that owns the record Lookup
BookingStatus owningteam Unique identifier for the team that owns the record. Lookup
BookingStatus owninguser Unique identifier for the user that owns the record. Lookup
BookingStatus statecode Status of the Booking Status State
BookingStatus status Select whether the booking status should be proposed, committed or canceled. Picklist
BookingStatus statuscode Reason for the status of the Booking Status Status
BookingStatus timezoneruleversionnumber For internal use only. Integer
BookingStatus transactioncurrencyid Exchange rate for the currency associated with the BookingStatus with respect to the base currency. Lookup
BookingStatus utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
BookingStatus versionnumber BigInt
BulkDeleteFailure asyncoperationid Unique identifier of the system job that created this record. Lookup
BulkDeleteFailure bulkdeletefailureid Unique identifier of the bulk deletion failure record. Uniqueidentifier
BulkDeleteFailure bulkdeleteoperationid Unique identifier of the bulk operation job which created this record Lookup
BulkDeleteFailure errordescription Description of the error. String
BulkDeleteFailure errornumber Error code for the failed bulk deletion. Integer
BulkDeleteFailure orderedqueryindex Index of the ordered query expression that retrieved this record. Integer
BulkDeleteFailure ownerid Unique identifier of the user or team who owns the bulk operation log. Owner
BulkDeleteFailure owningbusinessunit Unique identifier of the business unit that owns the bulk deletion failure. Uniqueidentifier
BulkDeleteFailure owninguser Unique identifier of the user who owns the bulk deletion failure record. Uniqueidentifier
BulkDeleteFailure regardingobjectid Unique identifier of the record that can not be deleted. Lookup
BulkDeleteOperation asyncoperationid Unique identifier of the system job that created this record Lookup
BulkDeleteOperation bulkdeleteoperationid Unique identifier of the bulk deletion job. Uniqueidentifier
BulkDeleteOperation createdby Unique identifier of the user who created the bulk deletion job. Lookup
BulkDeleteOperation createdon Date and time when the bulk deletion job was created. DateTime
BulkDeleteOperation createdonbehalfby Unique identifier of the delegate user who created the bulkdeleteoperation. Lookup
BulkDeleteOperation failurecount Number of records that could not be deleted by the bulk deletion job. Integer
BulkDeleteOperation isrecurring Information about if recurrence is defined for the bulk deletion job. Boolean
BulkDeleteOperation modifiedby Unique identifier of the user who last modified the bulk deletion job. Lookup
BulkDeleteOperation modifiedon Date and time when the bulk deletion job record was last modified. DateTime
BulkDeleteOperation modifiedonbehalfby Unique identifier of the delegate user who last modified the bulkdeleteoperation. Lookup
BulkDeleteOperation name Name of the bulk deletion job. String
BulkDeleteOperation nextrun Next scheduled time for the bulk deletion job to run. DateTime
BulkDeleteOperation orderedquerysetxml Fetch XML of the ordered query set. String
BulkDeleteOperation ownerid Unique identifier of the user or team who owns the bulk delete operation. Owner
BulkDeleteOperation owningbusinessunit Business unit that owns the bulk deletion job. Lookup
BulkDeleteOperation owninguser Business user what owns the bulk delete operation. Lookup
BulkDeleteOperation processingqeindex Index of the ordered query expression that defines the deletion set. Integer
BulkDeleteOperation statecode Status of the bulk deletion job. State
BulkDeleteOperation statuscode Reason for the status of the bulk deletion job. Status
BulkDeleteOperation successcount Number of records deleted by the bulk deletion job. Integer
BulkDeleteOperation timezoneruleversionnumber For internal use only. Integer
BulkDeleteOperation utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
BulkOperation activityid Unique identifier of the bulk operation. Uniqueidentifier
BulkOperation activitytypecode Type of activity. EntityName
BulkOperation actualdurationminutes Actual duration of the bulk operation in minutes. Integer
BulkOperation actualend Shows the date and time when the quick campaign was completed or canceled. DateTime
BulkOperation actualstart Shows the date and time when the activity was started or created. DateTime
BulkOperation bulkoperationnumber Shows the number for the quick campaign record, used to identify the quick campaign. String
BulkOperation createdby Shows who created the record. Lookup
BulkOperation createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
BulkOperation createdonbehalfby Unique identifier of the delegate user who created the bulk operation. Lookup
BulkOperation createdrecordtypecode Choose the activity to create that determines how target prospects or customers in this quick campaign are contacted. Picklist
BulkOperation description Type additional information to describe the quick campaign, such as the products or services offered. Memo
BulkOperation errornumber Shows the error code that is used to troubleshoot issues in the quick campaign. Integer
BulkOperation failurecount Number of records which failed in the bulk operation. Integer
BulkOperation isbilled For internal use only. Boolean
BulkOperation isregularactivity Information regarding whether the activity is a regular activity type or event type. Boolean
BulkOperation isworkflowcreated Specifies if the bulk operation was created from a workflow rule. Boolean
BulkOperation modifiedby Shows who last updated the record. Lookup
BulkOperation modifiedon Date and time when the bulk operation was last modified. DateTime
BulkOperation modifiedonbehalfby Unique identifier of the delegate user who last modified the bulk operation. Lookup
BulkOperation operationtypecode Select the type of bulk operation process, such as quick campaign or campaign activity distribution. Picklist
BulkOperation ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
BulkOperation owningbusinessunit Unique identifier of the business unit that owns the bulk operation. Lookup
BulkOperation owningteam Unique identifier of the team who owns the bulk operation. Lookup
BulkOperation owninguser Unique identifier of the user who owns the bulk operation. Lookup
BulkOperation parameters XML string that contains the parameters to the bulk operation. Memo
BulkOperation regardingobjectid Choose the campaign from which the campaign activities were bulk-distributed. Lookup
BulkOperation scheduleddurationminutes Scheduled duration of the bulk operation, specified in minutes. Integer
BulkOperation scheduledend Scheduled end date and time of the bulk operation. DateTime
BulkOperation scheduledstart Scheduled start date and time of the bulk operation. DateTime
BulkOperation serviceid Unique identifier for an associated service. Lookup
BulkOperation statecode Shows whether the quick campaign is open, closed, or canceled. Closed or canceled quick campaigns are read-only and can’t be edited. State
BulkOperation statuscode Select the quick campaign’s status. Status
BulkOperation subject Type a short description about the objective or primary topic of the quick campaign. String
BulkOperation successcount Number of records which succeeded in the bulk operation. Integer
BulkOperation targetedrecordtypecode Select the type of records targeted in the quick campaign to identify the target audience. Picklist
BulkOperation targetmemberscount Number of members to target. Integer
BulkOperation timezoneruleversionnumber For internal use only. Integer
BulkOperation utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
BulkOperation versionnumber Version number of the bulk operation. BigInt
BulkOperationLog additionalinfo Shows the data value at which an error occurred during the quick campaign. Memo
BulkOperationLog bulkoperationid Shows the quick campaign record that the log applies to. This information is used to relate log data to the parent quick campaign. Lookup
BulkOperationLog bulkoperationlogid Unique identifier of the bulk operation log. Uniqueidentifier
BulkOperationLog createdobjectid Choose the activity or other item created by the bulk operation. Lookup
BulkOperationLog errornumber Shows the error code that is used to troubleshoot issues in the bulk operation. Integer
BulkOperationLog ownerid Unique identifier of the user or team who owns the bulk operation log. Owner
BulkOperationLog owningbusinessunit Unique identifier of the business unit that owns the bulk operation log. Uniqueidentifier
BulkOperationLog owninguser Unique identifier of the user who owns the bulk operation log. Uniqueidentifier
BulkOperationLog regardingobjectid Choose the account, contact, lead, or list that the bulk operation log item applies to. Lookup
BusinessDataLocalizedLabel businessdatalocalizedlabelid Unique identifier of the Business Data Localized Label. Uniqueidentifier
BusinessDataLocalizedLabel label Label String
BusinessDataLocalizedLabel languageid Language Id Integer
BusinessDataLocalizedLabel objectcolumnname Object Column Name String
BusinessDataLocalizedLabel objectcolumnnumber Object Column Number Integer
BusinessDataLocalizedLabel objectid Object Id Lookup
BusinessDataLocalizedLabel versionnumber BigInt
BusinessProcessFlowInstance activestagestartedon Date and time when the active stage was started. DateTime
BusinessProcessFlowInstance businessprocessflowinstanceid Unique identifier of the business process flow instance. Uniqueidentifier
BusinessProcessFlowInstance completedon Date and time when the process completed. DateTime
BusinessProcessFlowInstance createdby Shows who created the record. Lookup
BusinessProcessFlowInstance createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
BusinessProcessFlowInstance createdonbehalfby Shows who created the record on behalf of another user. Lookup
BusinessProcessFlowInstance entity1id Unique identifier of the first entity instance. Uniqueidentifier
BusinessProcessFlowInstance entity1objecttypecode Object type code for the first entity of the business process flow instance. EntityName
BusinessProcessFlowInstance entity2id Unique identifier of the second entity instance. Uniqueidentifier
BusinessProcessFlowInstance entity2objecttypecode Object type code for the second entity of the business process flow instance. EntityName
BusinessProcessFlowInstance entity3id Unique identifier of the third entity instance. Uniqueidentifier
BusinessProcessFlowInstance entity3objecttypecode Object type code for the third entity of the business process flow instance. EntityName
BusinessProcessFlowInstance entity4id Unique identifier of the fourth entity instance. Uniqueidentifier
BusinessProcessFlowInstance entity4objecttypecode Object type code for the fourth entity of the business process flow instance. EntityName
BusinessProcessFlowInstance entity5id Unique identifier of the fifth entity instance. Uniqueidentifier
BusinessProcessFlowInstance entity5objecttypecode Object type code for the fifth entity of the business process flow instance. EntityName
BusinessProcessFlowInstance modifiedby Shows who last updated the record. Lookup
BusinessProcessFlowInstance modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
BusinessProcessFlowInstance modifiedonbehalfby Shows who created the record on behalf of another user. Lookup
BusinessProcessFlowInstance name Type a descriptive name for the instance. String
BusinessProcessFlowInstance processid Unique identifier of the business process flow. Lookup
BusinessProcessFlowInstance processstageid Unique identifier of active stage in the business process flow instance. Uniqueidentifier
BusinessProcessFlowInstance statecode Shows whether the business process flow instance is active or inactive. State
BusinessProcessFlowInstance statuscode Business process flow instance’s status. Status
BusinessProcessFlowInstance traversedpath For internal use only. String
BusinessProcessFlowInstance versionnumber Version number of the business process flow instance. BigInt
BusinessUnit address1_addressid Unique identifier for address 1. Uniqueidentifier
BusinessUnit address1_addresstypecode Type of address for address 1, such as billing, shipping, or primary address. Picklist
BusinessUnit address1_city City name for address 1. String
BusinessUnit address1_country Country/region name for address 1. String
BusinessUnit address1_county County name for address 1. String
BusinessUnit address1_fax Fax number for address 1. String
BusinessUnit address1_latitude Latitude for address 1. Double
BusinessUnit address1_line1 First line for entering address 1 information. String
BusinessUnit address1_line2 Second line for entering address 1 information. String
BusinessUnit address1_line3 Third line for entering address 1 information. String
BusinessUnit address1_longitude Longitude for address 1. Double
BusinessUnit address1_name Name to enter for address 1. String
BusinessUnit address1_postalcode ZIP Code or postal code for address 1. String
BusinessUnit address1_postofficebox Post office box number for address 1. String
BusinessUnit address1_shippingmethodcode Method of shipment for address 1. Picklist
BusinessUnit address1_stateorprovince State or province for address 1. String
BusinessUnit address1_telephone1 First telephone number associated with address 1. String
BusinessUnit address1_telephone2 Second telephone number associated with address 1. String
BusinessUnit address1_telephone3 Third telephone number associated with address 1. String
BusinessUnit address1_upszone United Parcel Service (UPS) zone for address 1. String
BusinessUnit address1_utcoffset UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time. Integer
BusinessUnit address2_addressid Unique identifier for address 2. Uniqueidentifier
BusinessUnit address2_addresstypecode Type of address for address 2, such as billing, shipping, or primary address. Picklist
BusinessUnit address2_city City name for address 2. String
BusinessUnit address2_country Country/region name for address 2. String
BusinessUnit address2_county County name for address 2. String
BusinessUnit address2_fax Fax number for address 2. String
BusinessUnit address2_latitude Latitude for address 2. Double
BusinessUnit address2_line1 First line for entering address 2 information. String
BusinessUnit address2_line2 Second line for entering address 2 information. String
BusinessUnit address2_line3 Third line for entering address 2 information. String
BusinessUnit address2_longitude Longitude for address 2. Double
BusinessUnit address2_name Name to enter for address 2. String
BusinessUnit address2_postalcode ZIP Code or postal code for address 2. String
BusinessUnit address2_postofficebox Post office box number for address 2. String
BusinessUnit address2_shippingmethodcode Method of shipment for address 2. Picklist
BusinessUnit address2_stateorprovince State or province for address 2. String
BusinessUnit address2_telephone1 First telephone number associated with address 2. String
BusinessUnit address2_telephone2 Second telephone number associated with address 2. String
BusinessUnit address2_telephone3 Third telephone number associated with address 2. String
BusinessUnit address2_upszone United Parcel Service (UPS) zone for address 2. String
BusinessUnit address2_utcoffset UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time. Integer
BusinessUnit businessunitid Unique identifier of the business unit. Uniqueidentifier
BusinessUnit calendarid Fiscal calendar associated with the business unit. Lookup
BusinessUnit costcenter Name of the business unit cost center. String
BusinessUnit createdby Unique identifier of the user who created the business unit. Lookup
BusinessUnit createdon Date and time when the business unit was created. DateTime
BusinessUnit createdonbehalfby Unique identifier of the delegate user who created the businessunit. Lookup
BusinessUnit creditlimit Credit limit for the business unit. Double
BusinessUnit description Description of the business unit. Memo
BusinessUnit disabledreason Reason for disabling the business unit. String
BusinessUnit divisionname Name of the division to which the business unit belongs. String
BusinessUnit emailaddress Email address for the business unit. String
BusinessUnit exchangerate Exchange rate for the currency associated with the businessunit with respect to the base currency. Decimal
BusinessUnit fileasname Alternative name under which the business unit can be filed. String
BusinessUnit ftpsiteurl FTP site URL for the business unit. String
BusinessUnit importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
BusinessUnit inheritancemask Inheritance mask for the business unit. Integer
BusinessUnit isdisabled Information about whether the business unit is enabled or disabled. Boolean
BusinessUnit modifiedby Unique identifier of the user who last modified the business unit. Lookup
BusinessUnit modifiedon Date and time when the business unit was last modified. DateTime
BusinessUnit modifiedonbehalfby Unique identifier of the delegate user who last modified the businessunit. Lookup
BusinessUnit name Name of the business unit. String
BusinessUnit organizationid Unique identifier of the organization associated with the business unit. Lookup
BusinessUnit overriddencreatedon Date and time that the record was migrated. DateTime
BusinessUnit parentbusinessunitid Unique identifier for the parent business unit. Lookup
BusinessUnit picture Picture or diagram of the business unit. Memo
BusinessUnit stockexchange Stock exchange on which the business is listed. String
BusinessUnit tickersymbol Stock exchange ticker symbol for the business unit. String
BusinessUnit transactioncurrencyid Unique identifier of the currency associated with the businessunit. Lookup
BusinessUnit usergroupid Uniqueidentifier
BusinessUnit utcoffset UTC offset for the business unit. This is the difference between local time and standard Coordinated Universal Time. Integer
BusinessUnit versionnumber Version number of the business unit. BigInt
BusinessUnit websiteurl Website URL for the business unit. String
BusinessUnit workflowsuspended Information about whether workflow or sales process rules have been suspended. Boolean
BusinessUnitMap businessid Uniqueidentifier
BusinessUnitMap businessunitmapid Unique identifier of the business unit. Uniqueidentifier
BusinessUnitMap subbusinessid Uniqueidentifier
BusinessUnitMap versionnumber BigInt
BusinessUnitNewsArticle activeon Date and time for the announcement to become active. DateTime
BusinessUnitNewsArticle activeuntil Date and time of the last day the announcement is active. DateTime
BusinessUnitNewsArticle articletitle Title of the announcement. String
BusinessUnitNewsArticle articletypecode Type of announcement. Picklist
BusinessUnitNewsArticle articleurl URL for the Website on which the announcement is located. String
BusinessUnitNewsArticle businessunitnewsarticleid Unique identifier of the announcement. Uniqueidentifier
BusinessUnitNewsArticle createdby Unique identifier of the user who created the announcement. Lookup
BusinessUnitNewsArticle createdon Date and time when the announcement was created. DateTime
BusinessUnitNewsArticle createdonbehalfby Unique identifier of the delegate user who created the businessunitnewsarticle. Lookup
BusinessUnitNewsArticle importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
BusinessUnitNewsArticle modifiedby Unique identifier of the user who last modified the announcement. Lookup
BusinessUnitNewsArticle modifiedon Date and time when the announcement was last modified. DateTime
BusinessUnitNewsArticle modifiedonbehalfby Unique identifier of the delegate user who last modified the businessunitnewsarticle. Lookup
BusinessUnitNewsArticle newsarticle Text for the announcement. Memo
BusinessUnitNewsArticle organizationid Unique identifier of the organization associated with the announcement. Lookup
BusinessUnitNewsArticle overriddencreatedon Date and time that the record was migrated. DateTime
BusinessUnitNewsArticle showonhomepage Information about whether to show the announcement on the Website home page. Boolean
BusinessUnitNewsArticle timezoneruleversionnumber For internal use only. Integer
BusinessUnitNewsArticle utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
BusinessUnitNewsArticle versionnumber BigInt
Calendar businessunitid Unique identifier of the business unit with which the calendar is associated. Lookup
Calendar calendarid Unique identifier of the calendar. Uniqueidentifier
Calendar createdby Unique identifier of the user who created the calendar. Lookup
Calendar createdon Date and time when the calendar was created. DateTime
Calendar createdonbehalfby Unique identifier of the delegate user who created the calendar. Lookup
Calendar description Calendar used by the scheduling system to define when an appointment or activity is to occur. Memo
Calendar holidayschedulecalendarid Holiday Schedule CalendarId Lookup
Calendar isshared Calendar is shared by other calendars, such as the organization calendar. Boolean
Calendar modifiedby Unique identifier of the user who last modified the calendar. Lookup
Calendar modifiedon Date and time when the calendar was last modified. DateTime
Calendar modifiedonbehalfby Unique identifier of the delegate user who last modified the calendar. Lookup
Calendar name Name of the calendar. String
Calendar organizationid Unique identifier of the organization with which the calendar is associated. Lookup
Calendar primaryuserid Unique identifier of the primary user of this calendar. Uniqueidentifier
Calendar type Calendar type, such as User work hour calendar, or Customer service hour calendar. Picklist
Calendar versionnumber BigInt
CalendarRule businessunitid Unique identifier of the business unit with which the calendar rule is associated. Uniqueidentifier
CalendarRule calendarid Unique identifier of the calendar with which the calendar rule is associated. Lookup
CalendarRule calendarruleid Unique identifier of the calendar rule. Uniqueidentifier
CalendarRule createdby Unique identifier of the user who created the calendar rule. Lookup
CalendarRule createdon Date and time when the calendar rule was created. DateTime
CalendarRule createdonbehalfby Unique identifier of the delegate user who created the calendarrule. Lookup
CalendarRule description Defines free/busy times for a service and for resources or resource groups, such as working, non-working, vacation, and blocked. Memo
CalendarRule duration Duration of the calendar rule in minutes. Integer
CalendarRule effectiveintervalend Effective interval end of the calendar rule. DateTime
CalendarRule effectiveintervalstart Effective interval start of the calendar rule. DateTime
CalendarRule effort Effort available for a resource during the time described by the calendar rule. Double
CalendarRule endtime For internal use only. DateTime
CalendarRule extentcode Extent of the calendar rule. Integer
CalendarRule groupdesignator Unique identifier of the group. String
CalendarRule innercalendarid Unique identifier of the inner calendar for non-leaf calendar rules. Lookup
CalendarRule ismodified For internal use only. Boolean
CalendarRule isselected Flag used in vary-by-day calendar rules. Boolean
CalendarRule issimple Flag used in vary-by-day calendar rules. Boolean
CalendarRule isvaried Flag used in leaf nonrecurring rules. Boolean
CalendarRule modifiedby Unique identifier of the user who last modified the calendar rule. Lookup
CalendarRule modifiedon Date and time when the calendar rule was last modified. DateTime
CalendarRule modifiedonbehalfby Unique identifier of the delegate user who last modified the calendarrule. Lookup
CalendarRule name Name of the calendar rule. String
CalendarRule offset Start offset for leaf nonrecurring rules. Integer
CalendarRule organizationid Unique identifier of the organization with which the calendar rule is associated. Uniqueidentifier
CalendarRule pattern Pattern of the rule recurrence. String
CalendarRule rank Rank of the calendar rule. Integer
CalendarRule serviceid Unique identifier of the service with which the calendar rule is associated. Lookup
CalendarRule starttime Start time for the rule. DateTime
CalendarRule subcode Sub-type of calendar rule. Integer
CalendarRule timecode Type of calendar rule such as working hours, break, holiday, or time off. Integer
CalendarRule timezonecode Local time zone for the calendar rule. Integer
CalendarRule versionnumber BigInt
Campaign actualend Enter the date when the campaign was closed or completed. DateTime
Campaign actualstart Enter the actual start date and time for the campaign. DateTime
Campaign budgetedcost Type the amount budgeted for the campaign to define a limit for how much you can spend. Money
Campaign budgetedcost_base Shows the Budget Allocated field converted to the system’s default base currency. The calculations use the exchange rate specified in the Currencies area. Money
Campaign campaignid Unique identifier of the campaign. Uniqueidentifier
Campaign codename Type a number or other tracking code to identify the campaign. If no value is entered, a code will be generated automatically. String
Campaign createdby Shows who created the record. Lookup
Campaign createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Campaign createdonbehalfby Shows who created the record on behalf of another user. Lookup
Campaign description Type additional information to describe the campaign, such as the products or services offered or the targeted audience. Memo
Campaign entityimageid For internal use only. Uniqueidentifier
Campaign exchangerate 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. Decimal
Campaign expectedresponse Type the expected response rate for the campaign as a full number between 0 and 100. Integer
Campaign expectedrevenue Type the expected revenue for the campaign for return on investment projections and post-campaign reporting. Money
Campaign expectedrevenue_base Shows the estimated revenue converted to the system’s default base currency. The calculations use the exchange rate specified in the Currencies area. Money
Campaign importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Campaign istemplate Select whether the campaign is a template that can be copied when you create future campaigns. Boolean
Campaign message Type the promotional message or marketing copy for the campaign. String
Campaign modifiedby Shows who last updated the record. Lookup
Campaign modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Campaign modifiedonbehalfby Shows who created the record on behalf of another user. Lookup
Campaign name Type a name for the campaign so that it is identified correctly in lists. String
Campaign objective Type the objective of the campaign, including products, services, discounts, and pricing. Memo
Campaign othercost Type the sum of any miscellaneous campaign costs not included in the campaign activities to make sure the actual cost of the campaign is calculated correctly. Money
Campaign othercost_base Shows the Miscellaneous Costs field converted to the system’s default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area. Money
Campaign overriddencreatedon Date and time that the record was migrated. DateTime
Campaign ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
Campaign owningbusinessunit Shows the business unit that the record owner belongs to. Lookup
Campaign owningteam Unique identifier of the team who owns the campaign. Lookup
Campaign owninguser Unique identifier of the user who owns the campaign. Lookup
Campaign pricelistid Choose the price list associated with this item to make sure the products associated with the campaign are offered at the correct prices. Lookup
Campaign processid Shows the ID of the process. Uniqueidentifier
Campaign promotioncodename Type a promotional code to track sales related to the campaign or allow customers to redeem a discount offer. String
Campaign proposedend Enter the date when the campaign is scheduled to end. DateTime
Campaign proposedstart Enter the date when the campaign is scheduled to start. DateTime
Campaign stageid Shows the ID of the stage. Uniqueidentifier
Campaign statecode Shows the status of the campaign. By default, campaigns are active and can’t be deactivated. State
Campaign statuscode Select the campaign’s status. Status
Campaign timezoneruleversionnumber For internal use only. Integer
Campaign totalactualcost Shows the sum of the amounts entered in the Total Cost of Campaign Activities and Miscellaneous Costs fields. Money
Campaign totalactualcost_base Shows the Total Cost of Campaign field converted to the system’s default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area. Money
Campaign totalcampaignactivityactualcost Shows the sum of the values entered in the Actual Cost field on all campaign activities related to the campaign. Money
Campaign totalcampaignactivityactualcost_base Shows the Total Cost of Campaign Activities field converted to the system’s default base currency. The calculations use the exchange rate specified in the Currencies area. Money
Campaign transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Campaign traversedpath For internal use only. String
Campaign typecode Select the type of the campaign. Picklist
Campaign utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Campaign versionnumber Version number of the campaign. BigInt
CampaignActivity activityid Unique identifier of the campaign activity. Uniqueidentifier
CampaignActivity activitytypecode Type of activity. EntityName
CampaignActivity actualcost Type the actual cost of the campaign activity. The value entered is rolled up to the related campaign in the total cost calculations. Money
CampaignActivity actualcost_base Shows the Actual Cost field converted to the system’s default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area. Money
CampaignActivity actualdurationminutes Shows the value selected in the Duration field on the campaign activity. The duration is used to report the time spent on the activity. Integer
CampaignActivity actualend Enter the date when the campaign activity was actually completed. DateTime
CampaignActivity actualstart Enter the actual start date and time for the campaign activity to determine if the campaign activity started on the scheduled time. DateTime
CampaignActivity budgetedcost Type the allocated budget of the campaign activity for estimated versus actual cost reporting. Money
CampaignActivity budgetedcost_base Shows the Budget Allocated field converted to the system’s default base currency. The calculations use the exchange rate specified in the Currencies area. Money
CampaignActivity category Type a category to identify the campaign activity type, such as new business development or customer retention, to tie the campaign activity to a business group or function. String
CampaignActivity channeltypecode Select how communications for this activity will be sent, such as phone, letter, fax, or email. Picklist
CampaignActivity createdby Shows who created the record. Lookup
CampaignActivity createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
CampaignActivity createdonbehalfby Shows who created the record on behalf of another user. Lookup
CampaignActivity description Type additional information to describe the campaign activity, such as key talking points, objectives, or details about the target audience. Memo
CampaignActivity donotsendonoptout Select whether to override the opt-out settings on leads, contacts, and accounts for the members of the target marketing lists of the campaign activity. If No is selected, marketing materials will be sent to members who have opted out. Boolean
CampaignActivity exchangerate 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. Decimal
CampaignActivity excludeifcontactedinxdays Type the minimum number of days that must be passed before a marketing list member can be contacted in a campaign again. The campaign activity will not be applied to members contacted within the specified time period. Integer
CampaignActivity from For system use only. PartyList
CampaignActivity ignoreinactivelistmembers Select whether inactive marketing list members will be excluded from the campaign activity distribution. Boolean
CampaignActivity importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
CampaignActivity isbilled Information regarding whether the campaign activity was billed as part of resolving a case. Boolean
CampaignActivity isregularactivity Information regarding whether the activity is a regular activity type or event type. Boolean
CampaignActivity isworkflowcreated Information about whether the campaign activity is created by a workflow rule. Boolean
CampaignActivity modifiedby Shows who last updated the record. Lookup
CampaignActivity modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
CampaignActivity modifiedonbehalfby Shows who created the record on behalf of another user. Lookup
CampaignActivity overriddencreatedon Date and time that the record was migrated. DateTime
CampaignActivity ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
CampaignActivity owningbusinessunit Unique identifier of the business unit that owns the campaign activity. Lookup
CampaignActivity owningteam Unique identifier of the team who owns the campaign activity. Lookup
CampaignActivity owninguser Unique identifier of the user who owns the campaign activity. Lookup
CampaignActivity partners Enter the vendor accounts or contacts to capture any third-party suppliers used for the campaign activity. PartyList
CampaignActivity prioritycode Select the priority so that preferred customers or critical issues are handled quickly. Picklist
CampaignActivity processid Shows the ID of the process. Uniqueidentifier
CampaignActivity regardingobjectid Choose the parent campaign so that the campaign activity costs reflect in the correct campaign for reporting. Lookup
CampaignActivity scheduleddurationminutes Scheduled duration, specified in minutes, of the campaign activity. Integer
CampaignActivity scheduledend Enter the expected due date and time for the activity to be completed to provide details about the timing of the campaign activity. DateTime
CampaignActivity scheduledstart Enter the expected start date and time for the activity to provide details about timing of the campaign activity. DateTime
CampaignActivity serviceid Unique identifier of the associated service. Lookup
CampaignActivity stageid Shows the ID of the stage. Uniqueidentifier
CampaignActivity statecode Shows whether the campaign activity is open, completed, or canceled. Completed and canceled campaign activities are read-only and can’t be edited. State
CampaignActivity statuscode Select the campaign activity’s status. Status
CampaignActivity subcategory Type a subcategory to identify the campaign activity type and relate the activity to a specific product, sales region, business group, or other function. String
CampaignActivity subject Type a short description about the objective or primary topic of the campaign activity. String
CampaignActivity timezoneruleversionnumber For internal use only. Integer
CampaignActivity transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
CampaignActivity traversedpath For internal use only. String
CampaignActivity typecode Select the type of campaign activity to indicate the purpose of the activity. Picklist
CampaignActivity utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
CampaignActivity versionnumber Version number of the campaign activity. BigInt
CampaignActivityItem campaignactivityid Unique identifier of the campaign activity for the item. Lookup
CampaignActivityItem campaignactivityitemid Unique identifier of the campaign activity item. Uniqueidentifier
CampaignActivityItem itemid Unique identifier of the item. Uniqueidentifier
CampaignActivityItem itemobjecttypecode Identification of the type of the campaign activity item. EntityName
CampaignActivityItem ownerid Unique identifier of the user or team who owns the campaign activity item. Owner
CampaignActivityItem owningbusinessunit Unique identifier of the business unit that owns the campaign activity item. Uniqueidentifier
CampaignActivityItem owninguser Unique identifier of the user that owns the campaign activity item. Uniqueidentifier
CampaignActivityItem versionnumber BigInt
CampaignItem campaignid Unique identifier of the campaign that is associated with the individual item. Lookup
CampaignItem campaignitemid Unique identifier of the campaign item. Uniqueidentifier
CampaignItem entityid Unique identifier of the entity for the campaign item. Uniqueidentifier
CampaignItem entitytype Object type of entity for the campaign item. EntityName
CampaignItem ownerid Unique identifier of the user or team who owns the campaign item. Owner
CampaignItem owningbusinessunit Unique identifier of the business unit that owns the campaign item. Uniqueidentifier
CampaignItem owninguser Unique identifier of the user that owns the campaign item. Uniqueidentifier
CampaignItem versionnumber BigInt
CampaignResponse activityadditionalparams For internal use only. Memo
CampaignResponse activityid Unique identifier of the campaign response. Uniqueidentifier
CampaignResponse activitytypecode Type of activity. EntityName
CampaignResponse actualdurationminutes Type the number of minutes spent on this activity. The duration is used in reporting. Integer
CampaignResponse actualend Enter the date when the campaign response was actually completed. DateTime
CampaignResponse actualstart Enter the actual start date and time for the campaign response. DateTime
CampaignResponse category Type a category to identify the campaign response type, such as new business development or customer retention, to tie the campaign response to a business group or function. String
CampaignResponse channeltypecode Select how the response was received, such as phone, letter, fax, or email. Picklist
CampaignResponse companyname Type the name of the company if the campaign response was received from a new prospect or customer. String
CampaignResponse createdby Shows who created the record. Lookup
CampaignResponse createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
CampaignResponse createdonbehalfby Shows who created the record on behalf of another user. Lookup
CampaignResponse customer Enter the account, contact, or lead that submitted the campaign response, if it was received from an existing prospect or customer. PartyList
CampaignResponse description Type additional information to describe the campaign response, such as key discussion points or objectives. Memo
CampaignResponse emailaddress Type the responder’s email address. String
CampaignResponse exchangerate 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. Decimal
CampaignResponse fax Type the responder’s fax number. String
CampaignResponse firstname Type the responder’s first name if the campaign response was received from a new prospect or customer. String
CampaignResponse from For system use only. PartyList
CampaignResponse importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
CampaignResponse isbilled Specifies whether the campaign response was billed as part of resolving a case. Boolean
CampaignResponse isregularactivity Information regarding whether the activity is a regular activity type or event type. Boolean
CampaignResponse isworkflowcreated Specifies whether the campaign response is created by a workflow rule. Boolean
CampaignResponse lastname Type the responder’s last name if the campaign response was received from a new prospect or customer. String
CampaignResponse modifiedby Shows who last updated the record. Lookup
CampaignResponse modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
CampaignResponse modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
CampaignResponse originatingactivityid Choose the phone call, email, fax, letter, or appointment activity that led the prospect or customer to respond to the campaign. Lookup
CampaignResponse overriddencreatedon Date and time that the record was migrated. DateTime
CampaignResponse ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
CampaignResponse owningbusinessunit Unique identifier for the business unit that owns the campaign response. Lookup
CampaignResponse owningteam Unique identifier of the team who owns the campaign response. Lookup
CampaignResponse owninguser Unique identifier of the user who owns the campaign response. Lookup
CampaignResponse partner Enter the vendor account or contact to capture any third-party used to obtain the campaign response. PartyList
CampaignResponse prioritycode Select the priority so that preferred customers or critical issues are handled quickly. Picklist
CampaignResponse processid Shows the ID of the process. Uniqueidentifier
CampaignResponse promotioncodename Type a promotional code to track sales related to the campaign response or to allow the responder to redeem a discount offer. String
CampaignResponse receivedon Enter the date when the campaign response was received. DateTime
CampaignResponse regardingobjectid Choose the parent campaign so that the campaign’s response rate is tracked correctly. Lookup
CampaignResponse responsecode Select the type of response from the prospect or customer to indicate their interest in the campaign. Picklist
CampaignResponse scheduleddurationminutes Scheduled duration of the campaign response in minutes. Integer
CampaignResponse scheduledend Enter the expected due date and time for the activity to be completed to provide details about the timing of the campaign response. DateTime
CampaignResponse scheduledstart Enter the expected start date and time for the activity to provide details about the timing of the campaign response. DateTime
CampaignResponse serviceid Unique identifier for the associated service. Lookup
CampaignResponse stageid Shows the ID of the stage. Uniqueidentifier
CampaignResponse statecode Shows whether the campaign response is open, closed, or canceled. Closed and canceled campaign responses are read-only and can’t be edited. State
CampaignResponse statuscode Select the campaign response’s status. Status
CampaignResponse subcategory Type a subcategory to identify the campaign response type and relate the activity to a specific product, sales region, business group, or other function. String
CampaignResponse subject Type a short description about the objective or primary topic of the campaign response. String
CampaignResponse telephone Type the responder’s primary phone number. String
CampaignResponse timezoneruleversionnumber For internal use only. Integer
CampaignResponse transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
CampaignResponse traversedpath For internal use only. String
CampaignResponse utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
CampaignResponse versionnumber Version number of the campaign response. BigInt
CampaignResponse yomicompanyname Type the phonetic spelling of the company name, if specified in Japanese, to make sure the name is pronounced correctly in phone calls and other communications. String
CampaignResponse yomifirstname Type the phonetic spelling of the campaign responder’s first name, if specified in Japanese, to make sure the name is pronounced correctly in phone calls and other communications. String
CampaignResponse yomilastname Type the phonetic spelling of the campaign responder’s last name, if specified in Japanese, to make sure the name is pronounced correctly in phone calls and other communications. String
CardType actions For internal use only. Memo
CardType boolcardoption Bolean option for a cardtype. Boolean
CardType cardname The name of the custom entity. String
CardType cardtype The CardType ENUM value. Integer
CardType cardtypeicon The CardTypeIcon of the card. String
CardType cardtypeid Unique identifier for entity instances Uniqueidentifier
CardType clientavailability Determines on which client is this card available on. Picklist
CardType createdby Unique identifier of the user who created the record. Lookup
CardType createdon Date and time when the record was created. DateTime
CardType createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
CardType exchangerate Exchange rate for the currency associated with the CardType with respect to the base currency. Decimal
CardType grouptype Specifies the card group type String
CardType hassnoozedismiss Specifies if the card type has snooze dismiss Boolean
CardType intcardoption Any int option for a cardtype. Integer
CardType isbasecard IsBaseCard Boolean
CardType isenabled IsEnabled Boolean
CardType isliveonly IsLiveOnly Boolean
CardType ispreviewcard IsPreviewCard Boolean
CardType lastsynctime This column is updated by the Plugin based on the last fetched data. DateTime
CardType modifiedby Unique identifier of the user who modified the record. Lookup
CardType modifiedon Date and time when the record was modified. DateTime
CardType modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
CardType scheduletime This column is updated by the Plugin based on the last fetched data. DateTime
CardType softtitle The soft title of the card. String
CardType stringcardoption Any string option for a cardtype. Memo
CardType summarytext The summary text of the card. String
CardType transactioncurrencyid Exchange rate for the currency associated with the CardType with respect to the base currency. Lookup
CardType versionnumber BigInt
Category categoryid Shows the category. Uniqueidentifier
Category categorynumber Shows the category number for customer reference. String
Category createdby Unique identifier of the user who created the record. Lookup
Category createdon Date and time when the record was created. DateTime
Category createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
Category description Type a detailed description of the category Memo
Category exchangerate 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. Decimal
Category importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Category modifiedby Unique identifier of the user who modified the record. Lookup
Category modifiedon Date and time when the record was modified. DateTime
Category modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
Category overriddencreatedon Date and time that the record was migrated. DateTime
Category ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
Category owningbusinessunit Shows the business unit that the record owner belongs to. Lookup
Category owningteam Unique identifier of the team who owns the category. Lookup
Category owninguser Unique identifier of the user who owns this category. Lookup
Category parentcategoryid Select an existing category article for the category. Lookup
Category sequencenumber Enter a number to define the display position of the category in the hierarchy. Integer
Category title Type a title for the Category. String
Category transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Category versionnumber BigInt
ChannelAccessProfile channelaccessprofileid Unique identifier for entity instances Uniqueidentifier
ChannelAccessProfile channelaccessprofileidunique Unique identifier of the Channel Access Profile used when synchronizing customizations for the Microsoft Dynamics 365 client for Outlook Uniqueidentifier
ChannelAccessProfile componentstate For internal use only. Picklist
ChannelAccessProfile createdby Unique identifier of the user who created the record. Lookup
ChannelAccessProfile createdon Date and time when the record was created. DateTime
ChannelAccessProfile createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
ChannelAccessProfile emailaccess Select whether access to the email channel is allowed. Boolean
ChannelAccessProfile exchangerate Exchange rate for the currency associated with the ChannelAccessProfile with respect to the base currency. Decimal
ChannelAccessProfile facebookaccess Select whether access to the Facebook channel is allowed. Boolean
ChannelAccessProfile haveprivilegeschanged For internal use only Boolean
ChannelAccessProfile importsequencenumber Sequence number of the import that created this record. Integer
ChannelAccessProfile introducedversion Version in which the similarity rule is introduced. String
ChannelAccessProfile isguestprofile For internal use only. Boolean
ChannelAccessProfile ismanaged Is Managed Boolean
ChannelAccessProfile modifiedby Unique identifier of the user who modified the record. Lookup
ChannelAccessProfile modifiedon Date and time when the record was modified. DateTime
ChannelAccessProfile modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
ChannelAccessProfile name Type a descriptive name for the channel access profile. String
ChannelAccessProfile overriddencreatedon Date and time that the record was migrated. DateTime
ChannelAccessProfile overwritetime Date and time when the record was created. DateTime
ChannelAccessProfile ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user or team. Owner
ChannelAccessProfile owningbusinessunit Unique identifier for the business unit that owns the record Lookup
ChannelAccessProfile owningteam Unique identifier for the team that owns the record. Lookup
ChannelAccessProfile owninguser Unique identifier for the user that owns the record. Lookup
ChannelAccessProfile phoneaccess Select whether access to the phone channel is allowed. Boolean
ChannelAccessProfile rateknowledgearticles Select whether access to rate a knowledge article is allowed. Boolean
ChannelAccessProfile solutionid Unique identifier of the associated solution. Uniqueidentifier
ChannelAccessProfile statecode Shows whether the channel access profile is active or inactive. State
ChannelAccessProfile statuscode Select the the channel access profiles status. Status
ChannelAccessProfile submitfeedback Select whether access to submit feedback on knowledge articles is allowed. Boolean
ChannelAccessProfile supportingsolutionid For internal use only. Uniqueidentifier
ChannelAccessProfile timezoneruleversionnumber For internal use only. Integer
ChannelAccessProfile transactioncurrencyid Exchange rate for the currency associated with the ChannelAccessProfile with respect to the base currency. Lookup
ChannelAccessProfile twitteraccess Select whether access to the Twitter channel is allowed. Boolean
ChannelAccessProfile utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
ChannelAccessProfile versionnumber BigInt
ChannelAccessProfile viewarticlerating Select whether access to view a knowledge article rating is allowed. Boolean
ChannelAccessProfile viewknowledgearticles Select whether access to view knowledge articles is allowed. Boolean
ChannelAccessProfile webaccess Select whether access to the web channel is allowed. Boolean
ChannelAccessProfileEntityAccessLevel channelaccessprofileentityaccesslevelid Unique identifier of the entity access level associated with the channel access profile. Uniqueidentifier
ChannelAccessProfileEntityAccessLevel channelaccessprofileentityaccesslevelidunique For internal use only. Uniqueidentifier
ChannelAccessProfileEntityAccessLevel channelaccessprofileid Unique identifier of the channel access profile. Uniqueidentifier
ChannelAccessProfileEntityAccessLevel componentstate For internal use only. Picklist
ChannelAccessProfileEntityAccessLevel entityaccessleveldepthmask System-generated attribute that stores the privileges associated with the role. Integer
ChannelAccessProfileEntityAccessLevel entityaccesslevelid Unique identifier of the entity access level associated with the channel access profile Uniqueidentifier
ChannelAccessProfileEntityAccessLevel ismanaged Boolean
ChannelAccessProfileEntityAccessLevel overwritetime For internal use only. DateTime
ChannelAccessProfileEntityAccessLevel solutionid Unique identifier of the associated solution. Uniqueidentifier
ChannelAccessProfileEntityAccessLevel supportingsolutionid For internal use only. Uniqueidentifier
ChannelAccessProfileEntityAccessLevel versionnumber BigInt
ChannelAccessProfileRule channelaccessprofileruleid Unique identifier for entity instances Uniqueidentifier
ChannelAccessProfileRule channelaccessprofileruleidunique Unique identifier of the Channel Access Profile Rule Item used when synchronizing customizations for the Microsoft Dynamics 365 client for Outlook Uniqueidentifier
ChannelAccessProfileRule componentstate For internal use only. Picklist
ChannelAccessProfileRule createdby Unique identifier of the user who created the record. Lookup
ChannelAccessProfileRule createdon Date and time when the record was created. DateTime
ChannelAccessProfileRule createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
ChannelAccessProfileRule description Type a short description for the channel access profile rule. Memo
ChannelAccessProfileRule exchangerate Exchange rate for the currency associated with the channel access profile rule with respect to the base currency. Decimal
ChannelAccessProfileRule introducedversion Version in which the similarity rule is introduced. String
ChannelAccessProfileRule ismanaged Is Managed Boolean
ChannelAccessProfileRule modifiedby Unique identifier of the user who modified the record. Lookup
ChannelAccessProfileRule modifiedon Date and time when the record was modified. DateTime
ChannelAccessProfileRule modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
ChannelAccessProfileRule name Type a descriptive name for the channel access profile rule. String
ChannelAccessProfileRule overwritetime Date and time when the record was created. DateTime
ChannelAccessProfileRule ownerid Enter the user or team that owns the channel access profile rule. Owner
ChannelAccessProfileRule owningbusinessunit Unique identifier for the business unit that owns the record Lookup
ChannelAccessProfileRule owningteam Unique identifier for the team that owns the record. Lookup
ChannelAccessProfileRule owninguser Unique identifier for the user that owns the record. Lookup
ChannelAccessProfileRule solutionid Unique identifier of the associated solution. Uniqueidentifier
ChannelAccessProfileRule statecode Shows whether the channel access profile rule is in a draft state or an active state. State
ChannelAccessProfileRule statuscode Select the channel access profile rule’s status. Status
ChannelAccessProfileRule supportingsolutionid For internal use only. Uniqueidentifier
ChannelAccessProfileRule timezoneruleversionnumber For internal use only. Integer
ChannelAccessProfileRule transactioncurrencyid Exchange rate for the currency associated with the channel access profile rule with respect to the base currency. Lookup
ChannelAccessProfileRule utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
ChannelAccessProfileRule versionnumber BigInt
ChannelAccessProfileRule workflowid Shows the workflow for this rule. Lookup
ChannelAccessProfileRuleItem associatedchannelaccessprofile Choose the channel access profile that the item is assigned to. Lookup
ChannelAccessProfileRuleItem channelaccessprofileruleid Shows the channel access profile rule associated with this channel access profile rule item. Lookup
ChannelAccessProfileRuleItem channelaccessprofileruleitemid Unique identifier for entity instances Uniqueidentifier
ChannelAccessProfileRuleItem channelaccessprofileruleitemidunique Unique identifier of the channel access profile rule item. Uniqueidentifier
ChannelAccessProfileRuleItem componentstate For internal use only. Picklist
ChannelAccessProfileRuleItem conditionxml Condition for Rule item Memo
ChannelAccessProfileRuleItem createdby Shows who created the record. Lookup
ChannelAccessProfileRuleItem createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
ChannelAccessProfileRuleItem createdonbehalfby Shows who created the record on behalf of another user. Lookup
ChannelAccessProfileRuleItem description Type additional information to describe the channel access profile rule item. Memo
ChannelAccessProfileRuleItem exchangerate Exchange rate for the currency associated with the channel access profile rule item with respect to the base currency. Decimal
ChannelAccessProfileRuleItem introducedversion Version in which the channel access profile rule item is introduced. String
ChannelAccessProfileRuleItem ismanaged Is Managed Boolean
ChannelAccessProfileRuleItem modifiedby Shows who last updated the record Lookup
ChannelAccessProfileRuleItem modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
ChannelAccessProfileRuleItem modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
ChannelAccessProfileRuleItem name Type a descriptive name for the channel access profile rule item. String
ChannelAccessProfileRuleItem overwritetime Date and time when the record was created. DateTime
ChannelAccessProfileRuleItem ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user or team. Owner
ChannelAccessProfileRuleItem owningbusinessunit Unique identifier for the business unit that owns the record Lookup
ChannelAccessProfileRuleItem owninguser Unique identifier for the user that owns the record. Lookup
ChannelAccessProfileRuleItem sequencenumber Sequence number of the Channel access profile rule item Integer
ChannelAccessProfileRuleItem solutionid Unique identifier of the associated solution. Uniqueidentifier
ChannelAccessProfileRuleItem supportingsolutionid For internal use only. Uniqueidentifier
ChannelAccessProfileRuleItem timezoneruleversionnumber For internal use only. Integer
ChannelAccessProfileRuleItem transactioncurrencyid Exchange rate for the currency associated with the channel access profile rule item with respect to the base currency. Lookup
ChannelAccessProfileRuleItem utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
ChannelAccessProfileRuleItem versionnumber BigInt
ChannelProperty applicationsource Type the name of the application that the property is associated with. String
ChannelProperty channelpropertyid Unique identifier of the channel property Uniqueidentifier
ChannelProperty channelpropertyidunique For Internal Use Only Uniqueidentifier
ChannelProperty componentstate For internal use only. Picklist
ChannelProperty createdby Shows who created the record. Lookup
ChannelProperty createdon Shows the date and time when the record was created. DateTime
ChannelProperty createdonbehalfby Shows who created the record on behalf of another user. Lookup
ChannelProperty datatype Enter the data type for the property. Picklist
ChannelProperty description Description of property String
ChannelProperty importsequencenumber Unique identifier of the data import or data migration that created this property. Integer
ChannelProperty ismanaged For internal use only. Boolean
ChannelProperty modifiedby Shows who last updated the record. Lookup
ChannelProperty modifiedon Shows the date and time when the record was last updated. DateTime
ChannelProperty modifiedonbehalfby Shows who updated the record on behalf of another user. Lookup
ChannelProperty name Type the name of the property as received in the information provided by the external application. String
ChannelProperty organizationid Unique identifier of the organization associated with the channel property. Lookup
ChannelProperty overriddencreatedon Date and time that the attribute was migrated. DateTime
ChannelProperty overwritetime For internal use only. DateTime
ChannelProperty regardingobjectid Properties contained with a particular bag. Lookup
ChannelProperty solutionid Unique identifier of the associated solution. Uniqueidentifier
ChannelProperty statecode State of the channel property State
ChannelProperty statuscode Status of the channel property Status
ChannelProperty supportingsolutionid For internal use only. Uniqueidentifier
ChannelProperty versionnumber Version number of the channel property. BigInt
ChannelPropertyGroup channelpropertygroupid Unique identifier of the channel property group Uniqueidentifier
ChannelPropertyGroup channelpropertygroupidunique For Internal Use Only Uniqueidentifier
ChannelPropertyGroup componentstate For internal use only. Picklist
ChannelPropertyGroup createdby Shows who created the record. Lookup
ChannelPropertyGroup createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
ChannelPropertyGroup createdonbehalfby Shows who created the record on behalf of another user. Lookup
ChannelPropertyGroup description Type a description for the property group. Memo
ChannelPropertyGroup importsequencenumber Unique identifier of the data import or data migration that created this property. Integer
ChannelPropertyGroup ismanaged For internal use only. Boolean
ChannelPropertyGroup modifiedby Shows who last updated the record. Lookup
ChannelPropertyGroup modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
ChannelPropertyGroup modifiedonbehalfby Shows who updated the record on behalf of another user. Lookup
ChannelPropertyGroup name Type the name of the channel property group. String
ChannelPropertyGroup organizationid Unique identifier of the organization associated with the channel property group. Lookup
ChannelPropertyGroup overriddencreatedon Date and time that the attribute was migrated. DateTime
ChannelPropertyGroup overwritetime For internal use only. DateTime
ChannelPropertyGroup regardingtypecode Select the activity that the property group is associated with. Picklist
ChannelPropertyGroup solutionid Unique identifier of the associated solution. Uniqueidentifier
ChannelPropertyGroup statecode State of the channel property group State
ChannelPropertyGroup statuscode Status of the channel property group Status
ChannelPropertyGroup supportingsolutionid For internal use only. Uniqueidentifier
ChannelPropertyGroup versionnumber Version number of the channel property group. BigInt
Characteristic characteristicid Unique identifier of the characteristic. Uniqueidentifier
Characteristic characteristictype Select the type of characteristic. Picklist
Characteristic createdby Unique identifier of the user who created the record. Lookup
Characteristic createdon Date and time when the record was created. DateTime
Characteristic createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
Characteristic description Type a detailed description of the characteristic. String
Characteristic exchangerate Exchange rate for the currency associated with the characteristic with respect to the base currency. Decimal
Characteristic importsequencenumber Sequence number of the import that created this record. Integer
Characteristic modifiedby Unique identifier of the user who modified the record. Lookup
Characteristic modifiedon Date and time when the record was modified. DateTime
Characteristic modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
Characteristic name Type a name for the characteristic. String
Characteristic overriddencreatedon Date and time that the record was migrated. DateTime
Characteristic ownerid Unique identifier of the user or team who owns the record. Owner
Characteristic owningbusinessunit Unique identifier for the business unit that owns the record Lookup
Characteristic owningteam Unique identifier for the team that owns the record. Lookup
Characteristic owninguser Unique identifier for the user that owns the record. Lookup
Characteristic statecode Status of the Characteristic State
Characteristic statuscode Reason for the status of the Characteristic Status
Characteristic timezoneruleversionnumber For internal use only. Integer
Characteristic transactioncurrencyid Exchange rate for the currency associated with the Characteristic with respect to the base currency. Lookup
Characteristic utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Characteristic versionnumber BigInt
ChildIncidentCount childincidentcountid Uniqueidentifier
ChildIncidentCount numberofchildincidents EntityName
ChildIncidentCount parentcaseid Uniqueidentifier
ClientUpdate clientupdateid Unique identifier of the client update. Uniqueidentifier
ClientUpdate createdon For internal use only. Date and time when the ClientUpdate script was created on server. DateTime
ClientUpdate description Description of the client update. String
ClientUpdate sqlscript Contents of the client update. String
ClientUpdate versionnumber BigInt
ClientUpdate wasexecuted For internal use only. Should be set by client to 1 after action was executed. Boolean
ClientUpdate whenexecute For internal use only. Values are: 1 – Before SchemaChanges; 2 – After SchemaChanges but before Download data; 3 – After download data. Picklist
ColumnMapping columnmappingid Unique identifier of the column mapping. Uniqueidentifier
ColumnMapping createdby Unique identifier of the user who created the column mapping. Lookup
ColumnMapping createdon Date and time when the column mapping was created. DateTime
ColumnMapping createdonbehalfby Unique identifier of the delegate user who created the columnmapping. Lookup
ColumnMapping importmapid Unique identifier of the associated data map. Lookup
ColumnMapping modifiedby Unique identifier of the user who last modified the column mapping. Lookup
ColumnMapping modifiedon Date and time when the column mapping was last modified. DateTime
ColumnMapping modifiedonbehalfby Unique identifier of the delegate user who last modified the columnmapping. Lookup
ColumnMapping processcode Information about whether the column mapping needs to be processed. Picklist
ColumnMapping sourceattributename Name of the source attribute. String
ColumnMapping sourceentityname Name of the source entity. String
ColumnMapping statecode Status of the column mapping. State
ColumnMapping statuscode Reason for the status of the column mapping. Status
ColumnMapping targetattributename Name of the Microsoft Dynamics 365 attribute. String
ColumnMapping targetentityname Name of the Microsoft Dynamics 365 entity. String
Commitment activityid Uniqueidentifier
Commitment activitytypecode EntityName
Commitment commitmentid Uniqueidentifier
Commitment effort Double
Commitment participationtypemask Integer
Commitment partyid Uniqueidentifier
Commitment resourcespecid Uniqueidentifier
Commitment scheduledend DateTime
Commitment scheduledstart DateTime
Commitment serviceid Lookup
Commitment statecode State
Commitment statuscode Status
Commitment subject String
Competitor address1_addressid Unique identifier for address 1. Uniqueidentifier
Competitor address1_addresstypecode Select the primary address type. Picklist
Competitor address1_city Type the city for the primary address. String
Competitor address1_composite Shows the complete primary address. Memo
Competitor address1_country Type the country or region for the primary address. String
Competitor address1_county Type the county for the primary address. String
Competitor address1_fax Type the fax number associated with the primary address. String
Competitor address1_latitude Type the latitude value for the primary address for use in mapping and other applications. Double
Competitor address1_line1 Type the first line of the primary address. String
Competitor address1_line2 Type the second line of the primary address. String
Competitor address1_line3 Type the third line of the primary address. String
Competitor address1_longitude Type the longitude value for the primary address for use in mapping and other applications. Double
Competitor address1_name Type a descriptive name for the primary address, such as Corporate Headquarters. String
Competitor address1_postalcode Type the ZIP Code or postal code for the primary address. String
Competitor address1_postofficebox Type the post office box number of the primary address. String
Competitor address1_shippingmethodcode Select a shipping method for deliveries sent to this address. Picklist
Competitor address1_stateorprovince Type the state or province of the primary address. String
Competitor address1_telephone1 Type the main phone number associated with the primary address. String
Competitor address1_telephone2 Type a second phone number associated with the primary address. String
Competitor address1_telephone3 Type a third phone number associated with the primary address. String
Competitor address1_upszone Type the UPS zone of the primary address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS. String
Competitor address1_utcoffset Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address. Integer
Competitor address2_addressid Unique identifier for address 2. Uniqueidentifier
Competitor address2_addresstypecode Select the secondary address type. Picklist
Competitor address2_city Type the city for the secondary address. String
Competitor address2_composite Shows the complete secondary address. Memo
Competitor address2_country Type the country or region for the secondary address. String
Competitor address2_county Type the county for the secondary address. String
Competitor address2_fax Type the fax number associated with the secondary address. String
Competitor address2_latitude Type the latitude value for the secondary address for use in mapping and other applications. Double
Competitor address2_line1 Type the first line of the secondary address. String
Competitor address2_line2 Type the second line of the secondary address. String
Competitor address2_line3 Type the third line of the secondary address. String
Competitor address2_longitude Type the longitude value for the secondary address for use in mapping and other applications. Double
Competitor address2_name Type a descriptive name for the secondary address, such as Corporate Headquarters. String
Competitor address2_postalcode Type the ZIP Code or postal code for the secondary address. String
Competitor address2_postofficebox Type the post office box number of the secondary address. String
Competitor address2_shippingmethodcode Select a shipping method for deliveries sent to this address. Picklist
Competitor address2_stateorprovince Type the state or province of the secondary address. String
Competitor address2_telephone1 Type the main phone number associated with the secondary address. String
Competitor address2_telephone2 Type a second phone number associated with the secondary address. String
Competitor address2_telephone3 Type a third phone number associated with the secondary address. String
Competitor address2_upszone Type the UPS zone of the secondary address to make sure shipping charges are calculated correctly and deliveries are made promptly , if shipped by UPS. String
Competitor address2_utcoffset Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address. Integer
Competitor competitorid Unique identifier of the competitor. Uniqueidentifier
Competitor createdby Shows who created the record. Lookup
Competitor createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Competitor createdonbehalfby Shows who created the record on behalf of another user. Lookup
Competitor entityimageid For internal use only. Uniqueidentifier
Competitor exchangerate 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. Decimal
Competitor importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Competitor keyproduct Type the competitor’s primary product, service, or specialty. String
Competitor modifiedby Shows who last updated the record. Lookup
Competitor modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Competitor modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
Competitor name Type the company or business name used to identify the competitor in data views and related records. String
Competitor opportunities Type notes or other information about the competitive opportunities or selling points you can make. Memo
Competitor organizationid Unique identifier of the associated organization. Lookup
Competitor overriddencreatedon Date and time that the record was migrated. DateTime
Competitor overview Type notes or other information about the competitor’s business, such as location, revenue, or distribution channel. Memo
Competitor processid Shows the ID of the process. Uniqueidentifier
Competitor referenceinfourl Type the URL for the website used to obtain reference information about the competitor. String
Competitor reportedrevenue Type the amount of revenue reported in the competitor’s annual report or other source. Money
Competitor reportedrevenue_base Shows the Reported Revenue field converted to the system’s default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area. Money
Competitor reportingquarter Type the quarter number during which the competitor’s reported revenue was recorded or announced for use in reporting and analysis. Integer
Competitor reportingyear Type the fiscal year during which the competitor’s reported revenue was announced for use in reporting and analysis. Integer
Competitor stageid Shows the ID of the stage. Uniqueidentifier
Competitor stockexchange Type the stock exchange at which the competitor is listed to track their stock and financial performance of the company. String
Competitor strengths Type notes or other information about the competitor’s strengths, such as top-selling products and targeted industries or markets. Memo
Competitor threats Type notes or other information about the competitor’s threats to your organization when you sell to the same prospect or customer. Memo
Competitor tickersymbol Type the stock exchange symbol for the competitor to track financial performance of the company. You can click the code entered in this field to access the latest trading information from MSN Money. String
Competitor timezoneruleversionnumber For internal use only. Integer
Competitor transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Competitor traversedpath For internal use only. String
Competitor utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Competitor versionnumber Version number of the competitor. BigInt
Competitor weaknesses Type notes or other information about the competitor’s weaknesses or areas in which your organization outperforms the competitor. Memo
Competitor websiteurl Type the website URL for the competitor. String
Competitor winpercentage Type the percentage of your organization’s lost opportunities that are won by the competitor to identify your strongest competitors. Double
Competitor yominame Type the phonetic spelling of the competitor’s name, if specified in Japanese, to make sure the name is pronounced correctly in phone calls and other communications. String
CompetitorAddress addressnumber Information about which competitor address is applicable. Integer
CompetitorAddress addresstypecode Type of address for the competitor, such as primary address. Picklist
CompetitorAddress city City name in the competitor address. String
CompetitorAddress competitoraddressid Unique identifier of the competitor address. Uniqueidentifier
CompetitorAddress composite Shows the complete address. Memo
CompetitorAddress country Country/region name in the competitor address. String
CompetitorAddress county County name in the competitor address. String
CompetitorAddress createdby Unique identifier of the user who created the competitor address. Lookup
CompetitorAddress createdon Date and time when the competitor address was created. DateTime
CompetitorAddress createdonbehalfby Unique identifier of the delegate user who created the competitor address. Lookup
CompetitorAddress fax Fax number for the competitor address. String
CompetitorAddress latitude Latitude for the competitor address. Double
CompetitorAddress line1 First line for entering address information. String
CompetitorAddress line2 Second line for entering address information. String
CompetitorAddress line3 Third line for entering address information. String
CompetitorAddress longitude Longitude for the address for the competitor. Double
CompetitorAddress modifiedby Unique identifier of the user who last modified the competitor address. Lookup
CompetitorAddress modifiedon Date and time when the competitor address was last modified. DateTime
CompetitorAddress modifiedonbehalfby Unique identifier of the delegate user who last modified the competitor address. Lookup
CompetitorAddress name Name used to identify the competitor address. String
CompetitorAddress parentid Unique identifier of the parent object with which the competitor address is associated. Lookup
CompetitorAddress postalcode ZIP Code or postal code in the competitor address. String
CompetitorAddress postofficebox Post office box number in the competitor address. String
CompetitorAddress shippingmethodcode Method of shipment for the competitor. Picklist
CompetitorAddress stateorprovince State or province in the competitor address. String
CompetitorAddress telephone1 First telephone number for the competitor address. String
CompetitorAddress telephone2 Second telephone number for the competitor address. String
CompetitorAddress telephone3 Third telephone number for the competitor address. String
CompetitorAddress upszone United Parcel Service (UPS) zone for the address of the competitor. String
CompetitorAddress utcoffset UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time. Integer
CompetitorAddress versionnumber Version number of the competitor address. BigInt
CompetitorProduct competitorid Uniqueidentifier
CompetitorProduct competitorproductid Unique identifier of the competitor product. Uniqueidentifier
CompetitorProduct productid Uniqueidentifier
CompetitorProduct versionnumber BigInt
CompetitorSalesLiterature competitorid Uniqueidentifier
CompetitorSalesLiterature competitorsalesliteratureid Unique identifier of the sales literature for the competitor product. Uniqueidentifier
CompetitorSalesLiterature salesliteratureid Uniqueidentifier
CompetitorSalesLiterature versionnumber BigInt
ComplexControl complexcontrolid Unique identifier of the complex control. Uniqueidentifier
ComplexControl complexcontrolidunique Unique identifier of the form used when synchronizing customizations for the Microsoft Dynamics 365 client for Outlook. Uniqueidentifier
ComplexControl complexcontrolxml XML representation of the complex control layout. Memo
ComplexControl description Description of the complex control. Memo
ComplexControl name Name of the complex control. String
ComplexControl organizationid Unique identifier of the organization. Lookup
ComplexControl type Type of the complex control, for example, Process Control or Link Control. Picklist
ComplexControl version For internal use only. Integer
ComplexControl versionnumber Represents a version of customizations to be synchronized with the Microsoft Dynamics 365 client for Outlook. BigInt
Connection connectionid Unique identifier of the connection. Uniqueidentifier
Connection createdby Shows who created the record. Lookup
Connection createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Connection createdonbehalfby Shows who created the record on behalf of another user. Lookup
Connection description Type additional information to describe the connection, such as the length or quality of the relationship. Memo
Connection effectiveend Enter the end date of the connection. DateTime
Connection effectivestart Enter the start date of the connection. DateTime
Connection entityimageid For internal use only. Uniqueidentifier
Connection exchangerate 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. Decimal
Connection importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Connection ismaster Indicates that this is the master record. Boolean
Connection modifiedby Shows who last updated the record. Lookup
Connection modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Connection modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
Connection name Name of the connection. String
Connection overriddencreatedon Date and time that the record was migrated. DateTime
Connection ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
Connection owningbusinessunit Shows the business unit that the record owner belongs to. Lookup
Connection owningteam Unique identifier of the team who owns the connection. Lookup
Connection owninguser Unique identifier of the user who owns the connection. Lookup
Connection record1id Unique identifier of the source record. Lookup
Connection record1objecttypecode Shows the record type of the source record. Picklist
Connection record1roleid Choose the primary party’s role or relationship with the second party. Lookup
Connection record2id Unique identifier of the target record. Lookup
Connection record2objecttypecode Shows the record type of the target record. Picklist
Connection record2roleid Choose the secondary party’s role or relationship with the primary party. Lookup
Connection relatedconnectionid Unique identifier for the reciprocal connection record. Lookup
Connection statecode Shows whether the connection is active or inactive. Inactive connections are read-only and can’t be edited unless they are reactivated. State
Connection statuscode Reason for the status of the connection. Status
Connection transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Connection versionnumber Version number of the connection. BigInt
ConnectionRole category Categories for connection roles. Picklist
ConnectionRole componentstate State of the component. Picklist
ConnectionRole connectionroleid Unique identifier of the connection role. Uniqueidentifier
ConnectionRole connectionroleidunique Unique identifier of the published or unpublished connection role record. Uniqueidentifier
ConnectionRole createdby Unique identifier of the user who created the relationship role. Lookup
ConnectionRole createdon Date and time when the connection role was created. DateTime
ConnectionRole createdonbehalfby Unique identifier of the delegate user who created the relationship role. Lookup
ConnectionRole description Description of the connection role. String
ConnectionRole importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
ConnectionRole introducedversion Version in which the form is introduced. String
ConnectionRole iscustomizable Information that specifies whether this component can be customized. ManagedProperty
ConnectionRole ismanaged Indicates whether the solution component is part of a managed solution. Boolean
ConnectionRole modifiedby Unique identifier of the user who last modified the connection role. Lookup
ConnectionRole modifiedon Date and time when the connection role was last modified. DateTime
ConnectionRole modifiedonbehalfby Unique identifier of the delegate user who modified the relationship role. Lookup
ConnectionRole name Name of the connection role. String
ConnectionRole organizationid Unique identifier of the organization that this connection role belongs to. Lookup
ConnectionRole overwritetime Date and time when the record was last overwritten. DateTime
ConnectionRole solutionid Unique identifier of the associated solution. Uniqueidentifier
ConnectionRole statecode Status of the connection role. State
ConnectionRole statuscode Reason for the status of the connection role. Status
ConnectionRole supportingsolutionid For internal use only. Uniqueidentifier
ConnectionRole versionnumber Version number of the connection role. BigInt
ConnectionRoleAssociation associatedconnectionroleid Uniqueidentifier
ConnectionRoleAssociation connectionroleassociationid Unique identifier of the connection role association. Uniqueidentifier
ConnectionRoleAssociation connectionroleid Uniqueidentifier
ConnectionRoleAssociation versionnumber BigInt
ConnectionRoleObjectTypeCode associatedobjecttypecode EntityName
ConnectionRoleObjectTypeCode connectionroleid Unique identifier of the connection role associated with the Connection Role Object Type Code. Lookup
ConnectionRoleObjectTypeCode connectionroleobjecttypecodeid Unique identifier of the connection role object type association. Uniqueidentifier
ConnectionRoleObjectTypeCode organizationid Unique identifier of the organization associated with the connectionroleobjecttypecode. Uniqueidentifier
ConnectionRoleObjectTypeCode versionnumber BigInt
ConstraintBasedGroup businessunitid Shows the business unit that the record owner belongs to. Lookup
ConstraintBasedGroup constraintbasedgroupid Unique identifier of the resource group. Uniqueidentifier
ConstraintBasedGroup constraints Shows the constraints defined for the users, equipment, teams, and other resource groups included as resources for the group, stored in XML format. String
ConstraintBasedGroup createdby Unique identifier of the user who created the resource group. Lookup
ConstraintBasedGroup createdon Date and time when the resource group was created. DateTime
ConstraintBasedGroup createdonbehalfby Unique identifier of the delegate user who created the constraintbasedgroup. Lookup
ConstraintBasedGroup description Type additional information to describe the resource group, such as the intended use or associated resource types. Memo
ConstraintBasedGroup grouptypecode Shows whether the resource group is static, dynamic or hidden. Hidden groups are for system use only and are not viewable in Microsoft Dynamics 365. Picklist
ConstraintBasedGroup modifiedby Unique identifier of the user who last modified the resource group. Lookup
ConstraintBasedGroup modifiedon Date and time when the resource group was last modified. DateTime
ConstraintBasedGroup modifiedonbehalfby Unique identifier of the delegate user who last modified the constraintbasedgroup. Lookup
ConstraintBasedGroup name Type a title or name that describes the resource group. String
ConstraintBasedGroup organizationid Unique identifier of the organization associated with the resource group. Lookup
ConstraintBasedGroup versionnumber BigInt
Contact accountid Unique identifier of the account with which the contact is associated. Lookup
Contact accountrolecode Select the contact’s role within the company or sales process, such as decision maker, employee, or influencer. Picklist
Contact address1_addressid Unique identifier for address 1. Uniqueidentifier
Contact address1_addresstypecode Select the primary address type. Picklist
Contact address1_city Type the city for the primary address. String
Contact address1_composite Shows the complete primary address. Memo
Contact address1_country Type the country or region for the primary address. String
Contact address1_county Type the county for the primary address. String
Contact address1_fax Type the fax number associated with the primary address. String
Contact address1_freighttermscode Select the freight terms for the primary address to make sure shipping orders are processed correctly. Picklist
Contact address1_latitude Type the latitude value for the primary address for use in mapping and other applications. Double
Contact address1_line1 Type the first line of the primary address. String
Contact address1_line2 Type the second line of the primary address. String
Contact address1_line3 Type the third line of the primary address. String
Contact address1_longitude Type the longitude value for the primary address for use in mapping and other applications. Double
Contact address1_name Type a descriptive name for the primary address, such as Corporate Headquarters. String
Contact address1_postalcode Type the ZIP Code or postal code for the primary address. String
Contact address1_postofficebox Type the post office box number of the primary address. String
Contact address1_primarycontactname Type the name of the main contact at the account’s primary address. String
Contact address1_shippingmethodcode Select a shipping method for deliveries sent to this address. Picklist
Contact address1_stateorprovince Type the state or province of the primary address. String
Contact address1_telephone1 Type the main phone number associated with the primary address. String
Contact address1_telephone2 Type a second phone number associated with the primary address. String
Contact address1_telephone3 Type a third phone number associated with the primary address. String
Contact address1_upszone Type the UPS zone of the primary address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS. String
Contact address1_utcoffset Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address. Integer
Contact address2_addressid Unique identifier for address 2. Uniqueidentifier
Contact address2_addresstypecode Select the secondary address type. Picklist
Contact address2_city Type the city for the secondary address. String
Contact address2_composite Shows the complete secondary address. Memo
Contact address2_country Type the country or region for the secondary address. String
Contact address2_county Type the county for the secondary address. String
Contact address2_fax Type the fax number associated with the secondary address. String
Contact address2_freighttermscode Select the freight terms for the secondary address to make sure shipping orders are processed correctly. Picklist
Contact address2_latitude Type the latitude value for the secondary address for use in mapping and other applications. Double
Contact address2_line1 Type the first line of the secondary address. String
Contact address2_line2 Type the second line of the secondary address. String
Contact address2_line3 Type the third line of the secondary address. String
Contact address2_longitude Type the longitude value for the secondary address for use in mapping and other applications. Double
Contact address2_name Type a descriptive name for the secondary address, such as Corporate Headquarters. String
Contact address2_postalcode Type the ZIP Code or postal code for the secondary address. String
Contact address2_postofficebox Type the post office box number of the secondary address. String
Contact address2_primarycontactname Type the name of the main contact at the account’s secondary address. String
Contact address2_shippingmethodcode Select a shipping method for deliveries sent to this address. Picklist
Contact address2_stateorprovince Type the state or province of the secondary address. String
Contact address2_telephone1 Type the main phone number associated with the secondary address. String
Contact address2_telephone2 Type a second phone number associated with the secondary address. String
Contact address2_telephone3 Type a third phone number associated with the secondary address. String
Contact address2_upszone Type the UPS zone of the secondary address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS. String
Contact address2_utcoffset Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address. Integer
Contact address3_addressid Unique identifier for address 3. Uniqueidentifier
Contact address3_addresstypecode Select the third address type. Picklist
Contact address3_city Type the city for the 3rd address. String
Contact address3_composite Shows the complete third address. Memo
Contact address3_country the country or region for the 3rd address. String
Contact address3_county Type the county for the third address. String
Contact address3_fax Type the fax number associated with the third address. String
Contact address3_freighttermscode Select the freight terms for the third address to make sure shipping orders are processed correctly. Picklist
Contact address3_latitude Type the latitude value for the third address for use in mapping and other applications. Double
Contact address3_line1 the first line of the 3rd address. String
Contact address3_line2 the second line of the 3rd address. String
Contact address3_line3 the third line of the 3rd address. String
Contact address3_longitude Type the longitude value for the third address for use in mapping and other applications. Double
Contact address3_name Type a descriptive name for the third address, such as Corporate Headquarters. String
Contact address3_postalcode the ZIP Code or postal code for the 3rd address. String
Contact address3_postofficebox the post office box number of the 3rd address. String
Contact address3_primarycontactname Type the name of the main contact at the account’s third address. String
Contact address3_shippingmethodcode Select a shipping method for deliveries sent to this address. Picklist
Contact address3_stateorprovince the state or province of the third address. String
Contact address3_telephone1 Type the main phone number associated with the third address. String
Contact address3_telephone2 Type a second phone number associated with the third address. String
Contact address3_telephone3 Type a third phone number associated with the primary address. String
Contact address3_upszone Type the UPS zone of the third address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS. String
Contact address3_utcoffset Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address. Integer
Contact aging30 For system use only. Money
Contact aging30_base Shows the Aging 30 field converted to the system’s default base currency. The calculations use the exchange rate specified in the Currencies area. Money
Contact aging60 For system use only. Money
Contact aging60_base Shows the Aging 60 field converted to the system’s default base currency. The calculations use the exchange rate specified in the Currencies area. Money
Contact aging90 For system use only. Money
Contact aging90_base Shows the Aging 90 field converted to the system’s default base currency. The calculations use the exchange rate specified in the Currencies area. Money
Contact anniversary Enter the date of the contact’s wedding or service anniversary for use in customer gift programs or other communications. DateTime
Contact annualincome Type the contact’s annual income for use in profiling and financial analysis. Money
Contact annualincome_base Shows the Annual Income field converted to the system’s default base currency. The calculations use the exchange rate specified in the Currencies area. Money
Contact assistantname Type the name of the contact’s assistant. String
Contact assistantphone Type the phone number for the contact’s assistant. String
Contact birthdate Enter the contact’s birthday for use in customer gift programs or other communications. DateTime
Contact business2 Type a second business phone number for this contact. String
Contact callback Type a callback phone number for this contact. String
Contact childrensnames Type the names of the contact’s children for reference in communications and client programs. String
Contact company Type the company phone of the contact. String
Contact contactid Unique identifier of the contact. Uniqueidentifier
Contact createdby Shows who created the record. Lookup
Contact createdbyexternalparty Shows the external party who created the record. Lookup
Contact createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Contact createdonbehalfby Shows who created the record on behalf of another user. Lookup
Contact creditlimit Type the credit limit of the contact for reference when you address invoice and accounting issues with the customer. Money
Contact creditlimit_base Shows the Credit Limit field converted to the system’s default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area. Money
Contact creditonhold Select whether the contact is on a credit hold, for reference when addressing invoice and accounting issues. Boolean
Contact customersizecode Select the size of the contact’s company for segmentation and reporting purposes. Picklist
Contact customertypecode Select the category that best describes the relationship between the contact and your organization. Picklist
Contact defaultpricelevelid Choose the default price list associated with the contact to make sure the correct product prices for this customer are applied in sales opportunities, quotes, and orders. Lookup
Contact department Type the department or business unit where the contact works in the parent company or business. String
Contact description Type additional information to describe the contact, such as an excerpt from the company’s website. Memo
Contact donotbulkemail Select whether the contact accepts bulk email sent through marketing campaigns or quick campaigns. If Do Not Allow is selected, the contact can be added to marketing lists, but will be excluded from the email. Boolean
Contact donotbulkpostalmail Select whether the contact accepts bulk postal mail sent through marketing campaigns or quick campaigns. If Do Not Allow is selected, the contact can be added to marketing lists, but will be excluded from the letters. Boolean
Contact donotemail Select whether the contact allows direct email sent from Microsoft Dynamics 365. If Do Not Allow is selected, Microsoft Dynamics 365 will not send the email. Boolean
Contact donotfax Select whether the contact allows faxes. If Do Not Allow is selected, the contact will be excluded from any fax activities distributed in marketing campaigns. Boolean
Contact donotphone Select whether the contact accepts phone calls. If Do Not Allow is selected, the contact will be excluded from any phone call activities distributed in marketing campaigns. Boolean
Contact donotpostalmail Select whether the contact allows direct mail. If Do Not Allow is selected, the contact will be excluded from letter activities distributed in marketing campaigns. Boolean
Contact donotsendmm Select whether the contact accepts marketing materials, such as brochures or catalogs. Contacts that opt out can be excluded from marketing initiatives. Boolean
Contact educationcode Select the contact’s highest level of education for use in segmentation and analysis. Picklist
Contact emailaddress1 Type the primary email address for the contact. String
Contact emailaddress2 Type the secondary email address for the contact. String
Contact emailaddress3 Type an alternate email address for the contact. String
Contact employeeid Type the employee ID or number for the contact for reference in orders, service cases, or other communications with the contact’s organization. String
Contact entityimageid For internal use only. Uniqueidentifier
Contact exchangerate 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. Decimal
Contact externaluseridentifier Identifier for an external user. String
Contact familystatuscode Select the marital status of the contact for reference in follow-up phone calls and other communications. Picklist
Contact fax Type the fax number for the contact. String
Contact firstname Type the contact’s first name to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns. String
Contact followemail Information about whether to allow following email activity like opens, attachment views and link clicks for emails sent to the contact. Boolean
Contact ftpsiteurl Type the URL for the contact’s FTP site to enable users to access data and share documents. String
Contact fullname Combines and shows the contact’s first and last names so that the full name can be displayed in views and reports. String
Contact gendercode Select the contact’s gender to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns. Picklist
Contact governmentid Type the passport number or other government ID for the contact for use in documents or reports. String
Contact haschildrencode Select whether the contact has any children for reference in follow-up phone calls and other communications. Picklist
Contact home2 Type a second home phone number for this contact. String
Contact importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Contact isautocreate Information about whether the contact was auto-created when promoting an email or an appointment. Boolean
Contact isbackofficecustomer Select whether the contact exists in a separate accounting or other system, such as Microsoft Dynamics GP or another ERP database, for use in integration processes. Boolean
Contact isprivate Boolean
Contact jobtitle Type the job title of the contact to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns. String
Contact lastname Type the contact’s last name to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns. String
Contact lastonholdtime Contains the date and time stamp of the last on hold time. DateTime
Contact lastusedincampaign Shows the date when the contact was last included in a marketing campaign or quick campaign. DateTime
Contact leadsourcecode Select the primary marketing source that directed the contact to your organization. Picklist
Contact managername Type the name of the contact’s manager for use in escalating issues or other follow-up communications with the contact. String
Contact managerphone Type the phone number for the contact’s manager. String
Contact marketingonly Whether is only for marketing Boolean
Contact masterid Unique identifier of the master contact for merge. Lookup
Contact merged Shows whether the account has been merged with a master contact. Boolean
Contact middlename Type the contact’s middle name or initial to make sure the contact is addressed correctly. String
Contact mobilephone Type the mobile phone number for the contact. String
Contact modifiedby Shows who last updated the record. Lookup
Contact modifiedbyexternalparty Shows the external party who modified the record. Lookup
Contact modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Contact modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
Contact nickname Type the contact’s nickname. String
Contact numberofchildren Type the number of children the contact has for reference in follow-up phone calls and other communications. Integer
Contact onholdtime Shows how long, in minutes, that the record was on hold. Integer
Contact originatingleadid Shows the lead that the contact was created if the contact was created by converting a lead in Microsoft Dynamics 365. This is used to relate the contact to the data on the originating lead for use in reporting and analytics. Lookup
Contact overriddencreatedon Date and time that the record was migrated. DateTime
Contact ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
Contact owningbusinessunit Unique identifier of the business unit that owns the contact. Lookup
Contact owningteam Unique identifier of the team who owns the contact. Lookup
Contact owninguser Unique identifier of the user who owns the contact. Lookup
Contact pager Type the pager number for the contact. String
Contact parentcontactid Unique identifier of the parent contact. Lookup
Contact parentcustomerid Select the parent account or parent contact for the contact to provide a quick link to additional details, such as financial information, activities, and opportunities. Customer
Contact participatesinworkflow Shows whether the contact participates in workflow rules. Boolean
Contact paymenttermscode Select the payment terms to indicate when the customer needs to pay the total amount. Picklist
Contact preferredappointmentdaycode Select the preferred day of the week for service appointments. Picklist
Contact preferredappointmenttimecode Select the preferred time of day for service appointments. Picklist
Contact preferredcontactmethodcode Select the preferred method of contact. Picklist
Contact preferredequipmentid Choose the contact’s preferred service facility or equipment to make sure services are scheduled correctly for the customer. Lookup
Contact preferredserviceid Choose the contact’s preferred service to make sure services are scheduled correctly for the customer. Lookup
Contact preferredsystemuserid Choose the regular or preferred customer service representative for reference when scheduling service activities for the contact. Lookup
Contact processid Shows the ID of the process. Uniqueidentifier
Contact salutation Type the salutation of the contact to make sure the contact is addressed correctly in sales calls, email messages, and marketing campaigns. String
Contact shippingmethodcode Select a shipping method for deliveries sent to this address. Picklist
Contact slaid Choose the service level agreement (SLA) that you want to apply to the Contact record. Lookup
Contact slainvokedid Last SLA that was applied to this case. This field is for internal use only. Lookup
Contact spousesname Type the name of the contact’s spouse or partner for reference during calls, events, or other communications with the contact. String
Contact stageid Shows the ID of the stage. Uniqueidentifier
Contact statecode Shows whether the contact is active or inactive. Inactive contacts are read-only and can’t be edited unless they are reactivated. State
Contact statuscode Select the contact’s status. Status
Contact subscriptionid For internal use only. Uniqueidentifier
Contact suffix Type the suffix used in the contact’s name, such as Jr. or Sr. to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns. String
Contact telephone1 Type the main phone number for this contact. String
Contact telephone2 Type a second phone number for this contact. String
Contact telephone3 Type a third phone number for this contact. String
Contact territorycode Select a region or territory for the contact for use in segmentation and analysis. Picklist
Contact timespentbymeonemailandmeetings Total time spent for emails (read and write) and meetings by me in relation to the contact record. String
Contact timezoneruleversionnumber For internal use only. Integer
Contact transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Contact traversedpath For internal use only. String
Contact utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Contact versionnumber Version number of the contact. BigInt
Contact websiteurl Type the contact’s professional or personal website or blog URL. String
Contact yomifirstname Type the phonetic spelling of the contact’s first name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the contact. String
Contact yomifullname Shows the combined Yomi first and last names of the contact so that the full phonetic name can be displayed in views and reports. String
Contact yomilastname Type the phonetic spelling of the contact’s last name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the contact. String
Contact yomimiddlename Type the phonetic spelling of the contact’s middle name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the contact. String
ContactInvoices contactid Uniqueidentifier
ContactInvoices contactinvoiceid Unique identifier of the invoices for the contact. Uniqueidentifier
ContactInvoices invoiceid Uniqueidentifier
ContactInvoices versionnumber BigInt
ContactLeads contactid Uniqueidentifier
ContactLeads contactleadid Unique identifier of the leads for the contact. Uniqueidentifier
ContactLeads leadid Uniqueidentifier
ContactLeads versionnumber BigInt
ContactOrders contactid Uniqueidentifier
ContactOrders contactorderid Unique identifier of the orders for the contact. Uniqueidentifier
ContactOrders salesorderid Uniqueidentifier
ContactOrders versionnumber BigInt
ContactQuotes contactid Uniqueidentifier
ContactQuotes contactquoteid Unique identifier of the quotes for the contact. Uniqueidentifier
ContactQuotes quoteid Uniqueidentifier
ContactQuotes versionnumber BigInt
Contract accountid Unique identifier of the account with which the contract is associated. Lookup
Contract activeon Enter the date when the contract becomes active. DateTime
Contract allotmenttypecode Type of allotment that the contract supports. Picklist
Contract billingaccountid Unique identifier of the account to which the contract is to be billed. Lookup
Contract billingcontactid Unique identifier of the contact to whom the contract is to be billed. Lookup
Contract billingcustomerid Select the customer account or contact to which the contract should be billed to provide a quick link to address and other customer details. Customer
Contract billingendon Enter the end date for the contract’s billing period to indicate the period for which the customer must pay for a service. DateTime
Contract billingfrequencycode Select the billing schedule of the contract to indicate how often the customer should be invoiced. Picklist
Contract billingstarton Enter the start date for the contract’s billing period to indicate the period for which the customer must pay for a service. This defaults to the same date that is selected in the Contract Start Date field. DateTime
Contract billtoaddress Choose which address to send the invoice to. Lookup
Contract cancelon Shows the date and time when the contract was canceled. DateTime
Contract contactid Unique identifier of the contact specified for the contract. Lookup
Contract contractid Unique identifier of the contract. Uniqueidentifier
Contract contractlanguage Type additional information about the contract, such as the products or services provided to the customer. Memo
Contract contractnumber Shows the number for the contract for customer reference and searching capabilities. You cannot modify this number. String
Contract contractservicelevelcode Select the level of service that should be provided for the contract based on your company’s definition of bronze, silver, or gold. Picklist
Contract contracttemplateabbreviation Shows the abbreviation of the contract template selected when the contract is created. String
Contract contracttemplateid Choose the contract template that should be used to determine the terms of the contract, such as allotment type, available hours, and billing frequency. Lookup
Contract createdby Shows who created the record. Lookup
Contract createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Contract createdonbehalfby Shows who created the record on behalf of another user. Lookup
Contract customerid Select the customer account or contact to provide a quick link to additional customer details, such as address, phone number, activities, and orders. Customer
Contract duration Shows for the duration of the contract, in days, based on the contract start and end dates. Integer
Contract effectivitycalendar Days of the week and times during which customer service support is available for the duration of the contract. String
Contract entityimageid For internal use only. Uniqueidentifier
Contract exchangerate 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. Decimal
Contract expireson Enter the date when the contract expires. DateTime
Contract importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Contract modifiedby Shows who last updated the record. Lookup
Contract modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Contract modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
Contract netprice Shows the total charge to the customer for the service contract, calculated as the sum of values in the Net field for each existing contract line related to the contract. Money
Contract netprice_base Shows the Net Price field converted to the system’s default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area. Money
Contract originatingcontract Choose the original contract that this contract was created from. This information is used to track renewal history. Lookup
Contract overriddencreatedon Date and time that the record was migrated. DateTime
Contract ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
Contract owningbusinessunit Unique identifier of the business unit that owns the contract. Lookup
Contract owningteam Unique identifier of the team who owns the contract. Lookup
Contract owninguser Unique identifier of the user who owns the contract. Lookup
Contract serviceaddress Choose the address for the customer account or contact where the services are provided. Lookup
Contract statecode Shows whether the contract is in draft, invoiced, active, on hold, canceled, or expired. You can edit only the contracts that are in draft status. State
Contract statuscode Select the contract’s status. Status
Contract timezoneruleversionnumber For internal use only. Integer
Contract title Type a title or name for the contract that indicates the purpose of the contract. String
Contract totaldiscount Shows the total discount applied to the contract’s service charges, calculated as the sum of values in the Discount fields for each existing contract line related to the contract. Money
Contract totaldiscount_base Shows the Total Discount field converted to the system’s default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area. Money
Contract totalprice Shows the total service charge for the contract, before any discounts are credited. This is calculated as the sum of values in the Total Price field for each existing contract line related to the contract. Money
Contract totalprice_base Shows the Total Price field converted to the system’s default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area. Money
Contract transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Contract usediscountaspercentage Select whether the discounts entered on contract lines for this contract should be entered as a percentage or a fixed dollar value. Boolean
Contract utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Contract versionnumber Version number of the contract. BigInt
ContractDetail accountid Unique identifier of the account with which the contract is associated. Lookup
ContractDetail activeon Enter the date when the contract line becomes active. DateTime
ContractDetail allotmentsoverage Shows the number of minutes over the Total Allotments field that have been spent on resolved cases related to the contract line. Integer
ContractDetail allotmentsremaining Shows the number of cases or minutes remaining, based on the resolved cases logged to the contract line. Integer
ContractDetail allotmentsused Shows the number of cases or minutes used in the resolved cases on the contract line. Integer
ContractDetail contactid Unique identifier for the contact associated with the contract line. Lookup
ContractDetail contractdetailid Unique identifier of the contract line. Uniqueidentifier
ContractDetail contractid Unique identifier of the contract associated with the contract line. Lookup
ContractDetail contractstatecode Status of the contract. Picklist
ContractDetail createdby Shows who created the record. Lookup
ContractDetail createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
ContractDetail createdonbehalfby Shows who created the record on behalf of another user. Lookup
ContractDetail customerid Select the customer account or contact to provide a quick link to additional customer details, such as address, phone number, activities, and orders. Customer
ContractDetail discount Type the discount amount for the contract line to deduct any negotiated or other savings from the net amount due. Money
ContractDetail discount_base Shows the Discount field converted to the system’s default base currency. The calculation uses the exchange rate specified in the Currencies area. Money
ContractDetail discountpercentage Type the discount rate that should be applied to the Total Price, for use in calculating the net amount due for the contract line. Decimal
ContractDetail effectivitycalendar Days of the week and times for which the contract line item is effective. String
ContractDetail exchangerate 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. Decimal
ContractDetail expireson Enter the date when the contract line expires. The date is automatically filled with the contract date, but you can change it if required. DateTime
ContractDetail importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
ContractDetail initialquantity Type the number of units of the specified product or service that are eligible for support on the contract line. Integer
ContractDetail lineitemorder Type the line item number for the contract line to easily identify the contract line and make sure it’s listed in the correct order in the parent contract. Integer
ContractDetail modifiedby Shows who last updated the record. Lookup
ContractDetail modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
ContractDetail modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
ContractDetail net Shows the total charge to the customer for the contract line, calculated as the Total Price minus any discounts. Money
ContractDetail net_base Shows the Net field converted to the system’s default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Money
ContractDetail overriddencreatedon Date and time that the record was migrated. DateTime
ContractDetail ownerid Unique identifier of the user or team who owns the contract detail. Owner
ContractDetail owningbusinessunit Unique identifier of the business unit that owns the contract line. Uniqueidentifier
ContractDetail owninguser Unique identifier of the user who owns the contract line. Uniqueidentifier
ContractDetail price Type the total service charge for the contract line before any discounts are credited. Money
ContractDetail price_base Shows the Total Price field converted to the system’s default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Money
ContractDetail productid Choose the product that is eligible for services on the contract line. Lookup
ContractDetail productserialnumber Type the serial number for the product that is eligible for services on the contract line. String
ContractDetail rate Shows the cost per case or minute, calculated by dividing the Total Price value by the total number of cases or minutes allocated to the contract line. Money
ContractDetail rate_base Shows the Rate field converted to the system’s default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Money
ContractDetail serviceaddress Choose the address for the customer account or contact where the services are provided. Lookup
ContractDetail servicecontractunitscode Select the unit type allotted in the contract line, such as cases or minutes, to determine the level of support. Picklist
ContractDetail statecode Shows whether the contract line is existing, renewed, canceled, or expired. You can’t edit a contract line after it is saved, regardless of the status. State
ContractDetail statuscode Select the contract line’s status. Status
ContractDetail timezoneruleversionnumber For internal use only. Integer
ContractDetail title Type a title or name that describes the contract line. String
ContractDetail totalallotments Type the total number of minutes or cases allowed for the contract line. Integer
ContractDetail transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
ContractDetail uomid Choose the unit of measurement for the base unit quantity for this purchase, such as each or dozen. Lookup
ContractDetail uomscheduleid Unique identifier of the unit group associated with the contract line. Lookup
ContractDetail utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
ContractDetail versionnumber Version number of the contract template. BigInt
ContractTemplate abbreviation Abbreviation of the contract template name. String
ContractTemplate allotmenttypecode Criteria for the contracts based on the template, such as number of cases, time, or coverage dates. Picklist
ContractTemplate billingfrequencycode How often the customer or account is to be billed in contracts that are based on the template. Picklist
ContractTemplate componentstate For internal use only. Picklist
ContractTemplate contractservicelevelcode Unique identifier of the level of service specified in contracts that are based on the template. Picklist
ContractTemplate contracttemplateid Unique identifier of the contract template. Uniqueidentifier
ContractTemplate contracttemplateidunique For internal use only. Uniqueidentifier
ContractTemplate createdby Unique identifier of the user who created the contract template. Lookup
ContractTemplate createdon Date and time when the contract template was created. DateTime
ContractTemplate createdonbehalfby Unique identifier of the delegate user who created the contracttemplate. Lookup
ContractTemplate description Description of the contract template. Memo
ContractTemplate effectivitycalendar Days of the week and times for which contracts based on the template are effective. String
ContractTemplate importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
ContractTemplate introducedversion Version in which the form is introduced. String
ContractTemplate iscustomizable Information that specifies whether this component can be customized. ManagedProperty
ContractTemplate ismanaged Indicates whether the solution component is part of a managed solution. Boolean
ContractTemplate modifiedby Unique identifier of the user who last modified the contract template. Lookup
ContractTemplate modifiedon Date and time when the contract template was last modified. DateTime
ContractTemplate modifiedonbehalfby Unique identifier of the delegate user who last modified the contracttemplate. Lookup
ContractTemplate name Name of the contract template. String
ContractTemplate organizationid Unique identifier of the organization associated with the contract template. Lookup
ContractTemplate overriddencreatedon Date and time that the record was migrated. DateTime
ContractTemplate overwritetime For internal use only. DateTime
ContractTemplate solutionid Unique identifier of the associated solution. Uniqueidentifier
ContractTemplate supportingsolutionid For internal use only. Uniqueidentifier
ContractTemplate usediscountaspercentage Specifies whether the discount is a percentage or a monetary amount in contracts based on the template. Boolean
ContractTemplate versionnumber Version number of the contract template. BigInt
ConvertRule allowunknownsender Choose whether items from unknown senders should be converted to records. Boolean
ConvertRule channelpropertygroupid channel property group associated with the convert rule. Lookup
ConvertRule checkactiveentitlement Choose whether cases should be created for customers with active entitlements. Boolean
ConvertRule checkblockedsocialprofile Information whether record needs to be created for black listed social profiles. Boolean
ConvertRule checkdirectmessages Information whether record needs to be created for direct messages. Boolean
ConvertRule checkifresolved Choose whether an item related to a resolved case should be converted to a case. Boolean
ConvertRule componentstate For internal use only. Picklist
ConvertRule convertruleid Unique identifier for entity instances Uniqueidentifier
ConvertRule convertruleidunique For internal use only. Uniqueidentifier
ConvertRule createdby Unique identifier of the user who created the record. Lookup
ConvertRule createdon Date and time when the record was created. DateTime
ConvertRule createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
ConvertRule description Type additional information to describe the rule for creating records automatically. Memo
ConvertRule exchangerate Exchange rate for the currency associated with the queue with respect to the base currency. Decimal
ConvertRule ismanaged For internal use only. Boolean
ConvertRule modifiedby Unique identifier of the user who modified the record. Lookup
ConvertRule modifiedon Date and time when the record was modified. DateTime
ConvertRule modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
ConvertRule name Type a title or name of the queue for which the setting is defined. String
ConvertRule overwritetime For internal use only. DateTime
ConvertRule ownerid Owner Id Owner
ConvertRule owningbusinessunit Shows the business unit that the convert rule owner belongs to. Lookup
ConvertRule owningteam Unique identifier for the team that owns the record. Lookup
ConvertRule owninguser Unique identifier for the user that owns the record. Lookup
ConvertRule queueid Choose the queue that the rule is assigned to. Lookup
ConvertRule recordversion Record Version String
ConvertRule resolvedsince If you want to create a new case for an item associated with a resolved case, type how long a case must remain resolved before a new case is created for the associated item. Integer
ConvertRule responsetemplateid Choose the email template to use to create an automatic response to the customer. Lookup
ConvertRule sendautomaticresponse Choose whether to send an automatic email response to the customer after a record is created. Boolean
ConvertRule solutionid Unique identifier of the associated solution. Uniqueidentifier
ConvertRule sourcechanneltypecode Identifies the Dynamics 365 activity that’s the source of the record. EntityName
ConvertRule sourcetypecode Source of the record. Picklist
ConvertRule statecode Status of the Convert Rule State
ConvertRule statuscode Reason for the status of the Convert Rule Status
ConvertRule supportingsolutionid For internal use only. Uniqueidentifier
ConvertRule transactioncurrencyid Unique identifier of the currency associated with the queue. Lookup
ConvertRule versionnumber Version number of the convert rule. BigInt
ConvertRule workflowid Shows the workflow for this rule. Lookup
ConvertRuleItem componentstate For internal use only. Picklist
ConvertRuleItem conditionid Identifies the step of the associated workflow Lookup
ConvertRuleItem conditionxml Condition for convert rule item Memo
ConvertRuleItem convertruleid Unique identifier of the convert rule associated with the convert rule item. Lookup
ConvertRuleItem convertruleitemid Unique identifier for entity instances Uniqueidentifier
ConvertRuleItem convertruleitemidunique For internal use only. Uniqueidentifier
ConvertRuleItem createdby Unique identifier of the user who created the record. Lookup
ConvertRuleItem createdon Date and time when the record was created. DateTime
ConvertRuleItem createdonbehalfby Shows who created the record on behalf of another user. Lookup
ConvertRuleItem description Type additional information to describe the rule item for automatic record creation. Memo
ConvertRuleItem exchangerate Exchange rate for the currency associated with the queue with respect to the base currency. Decimal
ConvertRuleItem ismanaged For internal use only. Boolean
ConvertRuleItem modifiedby Unique identifier of the user who modified the record. Lookup
ConvertRuleItem modifiedon Date and time when the record was modified. DateTime
ConvertRuleItem modifiedonbehalfby Shows who created the record on behalf of another user. Lookup
ConvertRuleItem name Type a name or title of the rule item that is used for automatic record creation and update. String
ConvertRuleItem overwritetime For internal use only. DateTime
ConvertRuleItem ownerid Owner Id Owner
ConvertRuleItem owningbusinessunit Shows the business unit that the convert rule item owner belongs to. Lookup
ConvertRuleItem owninguser Unique identifier of the user who owns the Convert Rule Item. Lookup
ConvertRuleItem propertiesxml Set properties xml for convert rule item Memo
ConvertRuleItem queueid Choose the queue that the rule is assigned to. Lookup
ConvertRuleItem sequencenumber Sequence number of the convert rule item Integer
ConvertRuleItem solutionid Unique identifier of the associated solution. Uniqueidentifier
ConvertRuleItem supportingsolutionid For internal use only. Uniqueidentifier
ConvertRuleItem transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
ConvertRuleItem versionnumber Version number of the Covert Rule Item. BigInt
ConvertRuleItem workflowid Workflow associated with the Convert Rule Item. Lookup
CustomControl compatibledatatypes Compatible Data Types For Custom Controls String
CustomControl componentstate For internal use only. Picklist
CustomControl createdby Unique identifier of the user who created the record. Lookup
CustomControl createdon Date and time when the record was created. DateTime
CustomControl createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
CustomControl customcontrolid Unique identifier of the Custom Control for the Microsoft Dynamics 365. Uniqueidentifier
CustomControl customcontrolidunique For internal use only. Uniqueidentifier
CustomControl introducedversion Version in which the form is introduced. String
CustomControl ismanaged Boolean
CustomControl manifest Manifest of the CustomControl. Memo
CustomControl modifiedby Unique identifier of the user who modified the record. Lookup
CustomControl modifiedon Date and time when the record was modified. DateTime
CustomControl modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
CustomControl name Name of the custom control. String
CustomControl organizationid Unique identifier of the organization associated with the custom control. Lookup
CustomControl overwritetime For internal use only. DateTime
CustomControl solutionid Unique identifier of the associated solution. Uniqueidentifier
CustomControl supportingsolutionid For internal use only. Uniqueidentifier
CustomControl version For internal use only. String
CustomControl versionnumber Version number of the Custom Control. BigInt
CustomControlDefaultConfig componentstate For internal use only. Picklist
CustomControlDefaultConfig controldescriptionxml controlDescriptionXML of the custom control default config. Memo
CustomControlDefaultConfig createdby Unique identifier of the user who created the record. Lookup
CustomControlDefaultConfig createdon Date and time when the record was created. DateTime
CustomControlDefaultConfig createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
CustomControlDefaultConfig customcontroldefaultconfigid Unique identifier of the Custom Control Default Config for the Microsoft Dynamics 365. Uniqueidentifier
CustomControlDefaultConfig customcontroldefaultconfigidunique For internal use only. Uniqueidentifier
CustomControlDefaultConfig eventsxml The events XML of the custom control default config. Memo
CustomControlDefaultConfig introducedversion Version in which the form is introduced. String
CustomControlDefaultConfig ismanaged Boolean
CustomControlDefaultConfig modifiedby Unique identifier of the user who modified the record. Lookup
CustomControlDefaultConfig modifiedon Date and time when the record was modified. DateTime
CustomControlDefaultConfig modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
CustomControlDefaultConfig organizationid Unique identifier of the organization associated with the web resource. Lookup
CustomControlDefaultConfig overwritetime For internal use only. DateTime
CustomControlDefaultConfig primaryentitytypecode Entity Type Code of the Custom Control Default Config. EntityName
CustomControlDefaultConfig solutionid Unique identifier of the associated solution. Uniqueidentifier
CustomControlDefaultConfig supportingsolutionid For internal use only. Uniqueidentifier
CustomControlDefaultConfig versionnumber Version number of the Custom Control Default Config. BigInt
CustomControlResource componentstate For internal use only. Picklist
CustomControlResource createdby Unique identifier of the user who created the record. Lookup
CustomControlResource createdon Date and time when the record was created. DateTime
CustomControlResource createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
CustomControlResource customcontrolid Unique identifier of the custom control. Uniqueidentifier
CustomControlResource customcontrolresourceid Unique identifier of the Custom Control Resource. Uniqueidentifier
CustomControlResource customcontrolresourceidunique For internal use only. Uniqueidentifier
CustomControlResource introducedversion Version in which the form is introduced. String
CustomControlResource ismanaged Boolean
CustomControlResource modifiedby Unique identifier of the user who modified the record. Lookup
CustomControlResource modifiedon Date and time when the record was modified. DateTime
CustomControlResource modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
CustomControlResource name Name of the custom control resource. String
CustomControlResource organizationid Unique identifier of the organization associated with the web resource. Lookup
CustomControlResource overwritetime For internal use only. DateTime
CustomControlResource solutionid Unique identifier of the associated solution. Uniqueidentifier
CustomControlResource supportingsolutionid For internal use only. Uniqueidentifier
CustomControlResource version For internal use only. String
CustomControlResource versionnumber Version number of the Custom Control Resource. BigInt
CustomControlResource versionrequirement For internal use only. String
CustomControlResource webresourceid Unique identifier of the web resource. Uniqueidentifier
CustomerAddress addressnumber Shows the number of the address, to indicate whether the address is the primary, secondary, or other address for the customer. Integer
CustomerAddress addresstypecode Select the address type, such as primary or billing. Picklist
CustomerAddress city Type the city for the customer’s address to help identify the location. String
CustomerAddress composite Shows the complete address. Memo
CustomerAddress country Type the country or region for the customer’s address. String
CustomerAddress county Type the county for the customer’s address. String
CustomerAddress createdby Shows who created the record. Lookup
CustomerAddress createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
CustomerAddress createdonbehalfby Shows who created the record on behalf of another user. Lookup
CustomerAddress customeraddressid Unique identifier of the customer address. Uniqueidentifier
CustomerAddress exchangerate 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. Decimal
CustomerAddress fax Type the fax number associated with the customer’s address. String
CustomerAddress freighttermscode Select the freight terms to make sure shipping charges are processed correctly. Picklist
CustomerAddress importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
CustomerAddress latitude Type the latitude value for the customer’s address, for use in mapping and other applications. Double
CustomerAddress line1 Type the first line of the customer’s address to help identify the location. String
CustomerAddress line2 Type the second line of the customer’s address. String
CustomerAddress line3 Type the third line of the customer’s address. String
CustomerAddress longitude Type the longitude value for the customer’s address, for use in mapping and other applications. Double
CustomerAddress modifiedby Shows who last updated the record. Lookup
CustomerAddress modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
CustomerAddress modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
CustomerAddress name Type a descriptive name for the customer’s address, such as Corporate Headquarters. String
CustomerAddress objecttypecode Shows the type code of the customer record to indicate whether the address belongs to a customer account or contact. EntityName
CustomerAddress overriddencreatedon Date and time that the record was migrated. DateTime
CustomerAddress ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
CustomerAddress owningbusinessunit Shows the business unit that the record owner belongs to. Lookup
CustomerAddress owninguser Unique identifier of the user who owns the customer address. Lookup
CustomerAddress parentid Choose the customer’s address. Lookup
CustomerAddress postalcode Type the ZIP Code or postal code for the address. String
CustomerAddress postofficebox Type the post office box number of the customer’s address. String
CustomerAddress primarycontactname Type the name of the primary contact person for the customer’s address. String
CustomerAddress shippingmethodcode Select a shipping method for deliveries sent to this address. Picklist
CustomerAddress stateorprovince Type the state or province of the customer’s address. String
CustomerAddress telephone1 Type the primary phone number for the customer’s address. String
CustomerAddress telephone2 Type a second phone number for the customer’s address. String
CustomerAddress telephone3 Type a third phone number for the customer’s address. String
CustomerAddress timezoneruleversionnumber For internal use only. Integer
CustomerAddress transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
CustomerAddress upszone Type the UPS zone of the customer’s address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS. String
CustomerAddress utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
CustomerAddress utcoffset Select the time zone for the address. Integer
CustomerAddress versionnumber Version number of the customer address. BigInt
CustomerOpportunityRole createdby Shows who created the record. Lookup
CustomerOpportunityRole createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
CustomerOpportunityRole createdonbehalfby Shows who created the record on behalf of another user. Lookup
CustomerOpportunityRole customerid Select the account or contact associated to the opportunity, such as a strategic partner, third-party vendor, or key decision maker. Customer
CustomerOpportunityRole customeropportunityroleid Unique identifier of the opportunity relationship. Uniqueidentifier
CustomerOpportunityRole description Type additional information to describe the opportunity relationship, such as the length or quality of the relationship. String
CustomerOpportunityRole importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
CustomerOpportunityRole modifiedby Shows who last updated the record. Lookup
CustomerOpportunityRole modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
CustomerOpportunityRole modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
CustomerOpportunityRole opportunityid Choose the opportunity that the specified account or contact is related to. The opportunity relationship will be displayed in the Relationships view on the selected opportunity. Lookup
CustomerOpportunityRole opportunityroleid Choose the role or nature of the relationship that the customer has with the opportunity. The field is read-only until a customer has been selected. Administrators can configure role values under Business Management in the Settings area. Lookup
CustomerOpportunityRole opportunitystatecode Status of the opportunity. Integer
CustomerOpportunityRole opportunitystatuscode Reason for the status of the opportunity. Integer
CustomerOpportunityRole overriddencreatedon Date and time that the record was migrated. DateTime
CustomerOpportunityRole ownerid Unique identifier of the user or team who owns the customer opportunity role. Owner
CustomerOpportunityRole owningbusinessunit Unique identifier for the business unit that owns the customer opportunity role. Lookup
CustomerOpportunityRole owningteam Unique identifier of the team who owns the customer opportunity role. Lookup
CustomerOpportunityRole owninguser Unique identifier of the user who owns the customer opportunity role. Lookup
CustomerOpportunityRole uniquedscid For internal use only. Uniqueidentifier
CustomerOpportunityRole versionnumber Version number of the customer opportunity role. BigInt
CustomerRelationship converserelationshipid Unique identifier of the converse relationship of the customer relationship. Lookup
CustomerRelationship createdby Shows who created the record. Lookup
CustomerRelationship createdon Shows the date and time when the customer relationship was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
CustomerRelationship createdonbehalfby Shows who created the record on behalf of another user. Lookup
CustomerRelationship customerid Select the primary account or contact involved in the customer relationship. Customer
CustomerRelationship customerrelationshipid Unique identifier of the customer relationship. Uniqueidentifier
CustomerRelationship customerroledescription Type additional information about the primary party’s role in the customer relationship, such as the length or quality of the relationship. Memo
CustomerRelationship customerroleid Choose the primary party’s role or nature of the relationship the customer has with the second party. The field is read-only until both parties have been selected. Administrators can configure role values under Business Management in the Settings area. Lookup
CustomerRelationship importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
CustomerRelationship modifiedby Shows who last updated the record. Lookup
CustomerRelationship modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
CustomerRelationship modifiedonbehalfby Shows who created the record on behalf of another user. Lookup
CustomerRelationship overriddencreatedon Date and time that the record was migrated. DateTime
CustomerRelationship ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
CustomerRelationship owningbusinessunit Unique identifier of the business unit that owns the customer relationship. Lookup
CustomerRelationship owningteam Unique identifier of the team who owns the customer relationship. Lookup
CustomerRelationship owninguser Unique identifier of the user who owns the customer relationship. Lookup
CustomerRelationship partnerid Select the secondary account or contact involved in the customer relationship. Customer
CustomerRelationship partnerroledescription Type additional information about the secondary party’s role in the customer relationship, such as the length or quality of the relationship. Memo
CustomerRelationship partnerroleid Choose the secondary party’s role or nature of the relationship the customer has with the primary party. The field is read-only until both parties have been selected. Administrators can configure role values under Business Management in the Settings area. Lookup
CustomerRelationship uniquedscid For internal use only. Uniqueidentifier
CustomerRelationship versionnumber BigInt
DataPerformance anyoptimizationapplied An internal state which indicates whether at least one optimization is applied. Boolean
DataPerformance anyoptimizationavailable An internal state which indicates whether at least one optimization is available for this record. Boolean
DataPerformance component Name of the component String
DataPerformance count Number of times a queries were executed (Aggregated) Integer
DataPerformance dataperformanceid Unique identifier of the performance suggestion. Uniqueidentifier
DataPerformance entity Primary entity String
DataPerformance estimatedoptimizationimpact The expected average cost benefit of an optimization. Decimal
DataPerformance executionperiod The execution period for which the performance metrics are calculated. String
DataPerformance lastactionresult An internal state which shows the result of the last action that was taken on this record. String
DataPerformance lastoptimizationdate Last time an optimization was applied. DateTime
DataPerformance maxtime Maximum execution time in seconds. (Aggregated) Decimal
DataPerformance mediantime Average execution time in seconds. (Aggregated) Decimal
DataPerformance mintime Minimum execution time in seconds. (Aggregated) Decimal
DataPerformance operation Data operation that triggered the query (Retrieve Multiple, etc.) String
DataPerformance optimizationstatus Current optimization status of the record, showed to the customer. String
DataPerformance optimizationstorage Storage consumed by the optimization. (MB) Decimal
DataPerformance organizationid Unique identifier of the organization associated. Lookup
DataPerformance realizedoptimizationimpact Actual performance change after taking an optimization action on the record. String
DataPerformance solution Name of the solution that owns the component String
DataPerformance weight Query Weight of the component. Factored with the Optimization Impact to determine the overall importance of applying an optimization. (P2) Decimal
DelveActionHub cardtype Shows the type of the message. Picklist
DelveActionHub createdby Shows who created the record. Lookup
DelveActionHub createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
DelveActionHub createdonbehalfby Shows who created the record on behalf of another user. Lookup
DelveActionHub createdtime Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
DelveActionHub delveactionhubid Shows the entity instances. Uniqueidentifier
DelveActionHub description For internal use only. Memo
DelveActionHub exchangerate Shows the exchange rate for the currency associated with the Delve action hub with respect to the base currency. Decimal
DelveActionHub iconclassname Stores the Icon Class name of the Delve ActionHub Card. String
DelveActionHub mailweblink Shows the mail web link. String
DelveActionHub messageid Shows the email message. This information is used only for email that is received. String
DelveActionHub messagetime Shows the date and time when the email message is received. DateTime
DelveActionHub modifiedby Shows who last updated the record. Lookup
DelveActionHub modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
DelveActionHub modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
DelveActionHub modifiedtime Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
DelveActionHub organizationid Shows the organization that the record belongs to. Lookup
DelveActionHub recordid Shows the record ID. Lookup
DelveActionHub regardingobjectid Choose the record that the email relates to. Lookup
DelveActionHub relatedmailids For internal use only. Memo
DelveActionHub sender Enter the sender of the email. String
DelveActionHub senderentityid Record ID of the sender entity. Uniqueidentifier
DelveActionHub senderentityobjecttypecode Object Type code of the sender entity. Integer
DelveActionHub senderimageurl Image of the sender. String
DelveActionHub statecode Shows whether the Delve action record is pending, completed, or tracking. State
DelveActionHub statuscode Select the delve action record status. Status
DelveActionHub subject Type a short description about the objective or primary topic of the email. String
DelveActionHub timezoneruleversionnumber For internal use only. Integer
DelveActionHub transactioncurrencyid Shows the exchange rate for the currency associated with the Delve action hub with respect to the base currency. Lookup
DelveActionHub utcconversiontimezonecode Shows the time zone code that was in use when the record was created. Integer
DelveActionHub versionnumber BigInt
Dependency dependencyid Unique identifier of a dependency. Uniqueidentifier
Dependency dependencytype The dependency type of the dependency. Picklist
Dependency dependentcomponentbasesolutionid Uniqueidentifier
Dependency dependentcomponentnodeid Unique identifier of the dependent component’s node. Lookup
Dependency dependentcomponentobjectid Uniqueidentifier
Dependency dependentcomponentparentid Uniqueidentifier
Dependency dependentcomponenttype Picklist
Dependency requiredcomponentbasesolutionid Uniqueidentifier
Dependency requiredcomponentintroducedversion Double
Dependency requiredcomponentnodeid Unique identifier of the required component’s node Lookup
Dependency requiredcomponentobjectid Uniqueidentifier
Dependency requiredcomponentparentid Uniqueidentifier
Dependency requiredcomponenttype Picklist
DependencyFeature componentstate For internal use only. Picklist
DependencyFeature dependencyfeatureid Unique identifier of a dependency feature. Uniqueidentifier
DependencyFeature dependencyfeatureidunique For internal use only. Uniqueidentifier
DependencyFeature introducedversion Version in which the feature is introduced. String
DependencyFeature ismanaged Tells whether the record is part of a managed solution. Boolean
DependencyFeature overwritetime For internal use only. DateTime
DependencyFeature solutionid Unique identifier of the associated solution. Uniqueidentifier
DependencyFeature supportingsolutionid For internal use only. Uniqueidentifier
DependencyNode basesolutionid Unique identifier of the user who created the solution Lookup
DependencyNode componenttype The type code of the component. Picklist
DependencyNode dependencynodeid Unique identifier of the dependency node. Uniqueidentifier
DependencyNode introducedversion Introduced version for the component Double
DependencyNode issharedcomponent Whether this component is shared by two solutions with the same publisher. Boolean
DependencyNode objectid Unique identifier of the object with which the node is associated. Uniqueidentifier
DependencyNode parentid Unique identifier of the parent entity. Uniqueidentifier
DependencyNode topsolutionid Unique identifier of the top solution. Lookup
Discount amount Amount of the discount, specified either as a percentage or as a monetary amount. Money
Discount amount_base Shows the Amount field converted to the system’s default base currency, if specified as a fixed amount. The calculation uses the exchange rate specified in the Currencies area. Money
Discount createdby Unique identifier of the user who created the discount. Lookup
Discount createdon Date and time when the discount was created. DateTime
Discount createdonbehalfby Unique identifier of the delegate user who created the discount. Lookup
Discount discountid Unique identifier of the discount. Uniqueidentifier
Discount discounttypeid Unique identifier of the discount list associated with the discount. Lookup
Discount exchangerate 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. Decimal
Discount highquantity Upper boundary for the quantity range to which a particular discount can be applied. Decimal
Discount importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Discount isamounttype Specifies whether the discount is specified as a monetary amount or a percentage. Boolean
Discount lowquantity Lower boundary for the quantity range to which a particular discount is applied. Decimal
Discount modifiedby Unique identifier of the user who last modified the discount. Lookup
Discount modifiedon Date and time when the discount was last modified. DateTime
Discount modifiedonbehalfby Unique identifier of the delegate user who last modified the discount. Lookup
Discount organizationid Unique identifier of the organization associated with the discount. Uniqueidentifier
Discount overriddencreatedon Date and time that the record was migrated. DateTime
Discount percentage Percentage discount value. Decimal
Discount statuscode Select the discount’s status. Status
Discount transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Discount versionnumber Version number of the discount. BigInt
DiscountType createdby Unique identifier of the user who created the discount list. Lookup
DiscountType createdon Date and time when the discount list was created. DateTime
DiscountType createdonbehalfby Unique identifier of the delegate user who created the discounttype. Lookup
DiscountType description Description of the discount list. Memo
DiscountType discounttypeid Unique identifier of the discount list. Uniqueidentifier
DiscountType importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
DiscountType isamounttype Information about whether the discount list amounts are specified as monetary amounts or percentages. Boolean
DiscountType modifiedby Unique identifier of the user who last modified the discount list. Lookup
DiscountType modifiedon Date and time when the discount list was last modified. DateTime
DiscountType modifiedonbehalfby Unique identifier of the delegate user who last modified the discounttype. Lookup
DiscountType name Name of the discount list. String
DiscountType organizationid Unique identifier of the organization associated with the discount list. Lookup
DiscountType overriddencreatedon Date and time that the record was migrated. DateTime
DiscountType statecode Status of the discount list. State
DiscountType statuscode Reason for the status of the discount list. Status
DiscountType transactioncurrencyid Unique identifier of the currency associated with the discount type. Lookup
DiscountType versionnumber Version number of the discount type. BigInt
DisplayString componentstate For internal use only. Picklist
DisplayString createdby Unique identifier of the user who created the display string. Lookup
DisplayString createdon Date and time when the display string was created. DateTime
DisplayString createdonbehalfby Unique identifier of the delegate user who created the displaystring. Lookup
DisplayString customcomment Comment for a customized display string. String
DisplayString customdisplaystring Customized display string. String
DisplayString displaystringid Unique identifier of the display string. Uniqueidentifier
DisplayString displaystringidunique For internal use only. Uniqueidentifier
DisplayString displaystringkey For internal use only. String
DisplayString formatparameters Parameters used for formatting the display string. Integer
DisplayString ismanaged Boolean
DisplayString languagecode Language code of the display string. Integer
DisplayString modifiedby Unique identifier of the user who last modified the display string. Lookup
DisplayString modifiedon Date and time when the display string was last modified. DateTime
DisplayString modifiedonbehalfby Unique identifier of the delegate user who last modified the displaystring. Lookup
DisplayString organizationid Unique identifier of the organization associated with the display string. Lookup
DisplayString overwritetime For internal use only. DateTime
DisplayString publisheddisplaystring Published display string. String
DisplayString solutionid Unique identifier of the associated solution. Uniqueidentifier
DisplayString supportingsolutionid For internal use only. Uniqueidentifier
DisplayString versionnumber BigInt
DisplayStringMap componentstate For internal use only. Picklist
DisplayStringMap displaystringid Unique identifier of the display string. Uniqueidentifier
DisplayStringMap displaystringmapid Unique identifier of the display string map. Uniqueidentifier
DisplayStringMap displaystringmapidunique For internal use only. Uniqueidentifier
DisplayStringMap ismanaged Boolean
DisplayStringMap objecttypecode Type of entity with which the note is associated. EntityName
DisplayStringMap overwritetime For internal use only. DateTime
DisplayStringMap solutionid Unique identifier of the associated solution. Uniqueidentifier
DisplayStringMap supportingsolutionid For internal use only. Uniqueidentifier
DocumentIndex createdby Unique identifier of the user who created the indexed article. Lookup
DocumentIndex createdon Date and time when the indexed article was created. DateTime
DocumentIndex createdonbehalfby Unique identifier of the delegate user who created the documentindex. Lookup
DocumentIndex documentid Choose the parent article for the document index item. The ID links the index to article information such as the article number, title, and keywords. Lookup
DocumentIndex documentindexid Unique identifier of the indexed article. Uniqueidentifier
DocumentIndex documenttypecode For internal use only. Picklist
DocumentIndex islatestversion Shows which version of the knowledge article is the latest version. Boolean
DocumentIndex ispublished Tells whether the parent knowledge base article is published in Microsoft Dynamics 365, so that the keywords and article content are added to the search index. Boolean
DocumentIndex keywords Type the keywords for the article. The keywords are updated in the search index every time the article is published. Memo
DocumentIndex location For system use only. String
DocumentIndex modifiedby Unique identifier of the user who last modified the indexed article. Lookup
DocumentIndex modifiedon Date and time when the indexed article was last modified. DateTime
DocumentIndex modifiedonbehalfby Unique identifier of the delegate user who last modified the documentindex. Lookup
DocumentIndex number For internal use only. String
DocumentIndex organizationid Choose the ID of the organization that the record is associated with. Lookup
DocumentIndex searchtext For internal use only. Memo
DocumentIndex subjectid Shows the subject record selected on the parent knowledge base article. The ID is updated in the search index every time the article is published. Lookup
DocumentIndex title Type the title of the parent knowledge base article. This is updated in the search index every time the article is published. String
DocumentIndex versionnumber BigInt
DocumentTemplate associatedentitytypecode Associated Entity Type Code. EntityName
DocumentTemplate clientdata Client data regarding this document template. String
DocumentTemplate content Bytes of the document template. String
DocumentTemplate createdby Unique identifier of the user who created the document template. Lookup
DocumentTemplate createdon Date and time when the document template was created. DateTime
DocumentTemplate createdonbehalfby Unique identifier of the delegate user who created the document template. Lookup
DocumentTemplate description Additional information to describe the Document Template String
DocumentTemplate documenttemplateid Unique identifier of the document template. Uniqueidentifier
DocumentTemplate documenttype Option set for selecting the type of the document template Picklist
DocumentTemplate languagecode Language of Document Template. Integer
DocumentTemplate modifiedby Unique identifier of the user who last modified the document template. Lookup
DocumentTemplate modifiedon Date and time when the document template was last modified. DateTime
DocumentTemplate modifiedonbehalfby Unique identifier of the delegate user who modified the document template. Lookup
DocumentTemplate name Name of the document template. String
DocumentTemplate organizationid Unique identifier of the organization associated with the web resource. Lookup
DocumentTemplate status Information about whether the document template is active. Boolean
DocumentTemplate versionnumber BigInt
DuplicateRecord asyncoperationid Unique identifier of the system job that created this record. Lookup
DuplicateRecord baserecordid Unique identifier of the base record. Lookup
DuplicateRecord createdon Date and time when the duplicate record was created. DateTime
DuplicateRecord duplicateid Unique identifier of the duplicate record. Uniqueidentifier
DuplicateRecord duplicaterecordid Unique identifier of the potential duplicate record. Lookup
DuplicateRecord duplicateruleid Unique identifier of the duplicate rule against which this duplicate was found. Lookup
DuplicateRecord ownerid Unique identifier of the user or team who owns the duplicate record. Owner
DuplicateRecord owningbusinessunit Unique identifier of the business unit that owns the duplicate record. Uniqueidentifier
DuplicateRecord owninguser Unique identifier of the user who owns the duplicate record. Uniqueidentifier
DuplicateRule baseentitymatchcodetable Database table that stores match codes for the record type being evaluated for potential duplicates. String
DuplicateRule baseentityname Record type of the record being evaluated for potential duplicates. String
DuplicateRule baseentitytypecode Record type of the record being evaluated for potential duplicates. Picklist
DuplicateRule createdby Unique identifier of the user who created the duplicate detection rule. Lookup
DuplicateRule createdon Date and time when the duplicate detection rule was created. DateTime
DuplicateRule createdonbehalfby Unique identifier of the delegate user who created the duplicaterule. Lookup
DuplicateRule description Description of the duplicate detection rule. String
DuplicateRule duplicateruleid Unique identifier of the duplicate detection rule. Uniqueidentifier
DuplicateRule excludeinactiverecords Determines whether to flag inactive records as duplicates Boolean
DuplicateRule iscasesensitive Indicates if the operator is case-sensitive. Boolean
DuplicateRule matchingentitymatchcodetable Database table that stores match codes for potential duplicate records. String
DuplicateRule matchingentityname Record type of the records being evaluated as potential duplicates. String
DuplicateRule matchingentitytypecode Record type of the records being evaluated as potential duplicates. Picklist
DuplicateRule modifiedby Unique identifier of the user who last modified the duplicate detection rule. Lookup
DuplicateRule modifiedon Date and time when the duplicate detection rule was last modified. DateTime
DuplicateRule modifiedonbehalfby Unique identifier of the delegate user who last modified the duplicaterule. Lookup
DuplicateRule name Name of the duplicate detection rule. String
DuplicateRule ownerid Unique identifier of the user or team who owns the duplicate detection rule. Owner
DuplicateRule owningbusinessunit Unique identifier of the business unit that owns duplicate detection rule. Lookup
DuplicateRule owningteam Unique identifier of the team who owns the duplicate detection rule. Lookup
DuplicateRule owninguser Unique identifier of the user who owns the duplicate detection rule. Lookup
DuplicateRule statecode Status of the duplicate detection rule. State
DuplicateRule statuscode Reason for the status of the duplicate detection rule. Status
DuplicateRule timezoneruleversionnumber For internal use only. Integer
DuplicateRule utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
DuplicateRuleCondition baseattributename Field that is being compared. String
DuplicateRuleCondition createdby Unique identifier of the user who created the condition. Lookup
DuplicateRuleCondition createdon Date and time when the condition was created. DateTime
DuplicateRuleCondition createdonbehalfby Unique identifier of the delegate user who created the duplicate rule condition. Lookup
DuplicateRuleCondition duplicateruleconditionid Unique identifier of the condition. Uniqueidentifier
DuplicateRuleCondition ignoreblankvalues Determines whether to consider blank values as non-duplicate values Boolean
DuplicateRuleCondition matchingattributename Field that is being compared with the base field. String
DuplicateRuleCondition modifiedby Unique identifier of the user who last modified the condition. Lookup
DuplicateRuleCondition modifiedon Date and time when the condition was last modified. DateTime
DuplicateRuleCondition modifiedonbehalfby Unique identifier of the delegate user who last modified the duplicate rule condition. Lookup
DuplicateRuleCondition operatorcode Operator for this rule condition. Picklist
DuplicateRuleCondition operatorparam Parameter value of N if the operator is Same First Characters or Same Last Characters. Integer
DuplicateRuleCondition ownerid Unique identifier of the user or team who owns the duplicate rule condition. Owner
DuplicateRuleCondition owningbusinessunit Unique identifier of the business unit that owns the condition. Uniqueidentifier
DuplicateRuleCondition owninguser Unique identifier of the user who owns the condition. Uniqueidentifier
DuplicateRuleCondition regardingobjectid Unique identifier of the object with which the condition is associated. Lookup
DynamicProperty basedynamicpropertyid Shows the property in the product family that this property is being inherited from. Lookup
DynamicProperty createdby Shows who created the record. Lookup
DynamicProperty createdon Shows the date and time when the record was created. DateTime
DynamicProperty createdonbehalfby Shows who created the record on behalf of another user. Lookup
DynamicProperty datatype Select the data type of the property. Picklist
DynamicProperty defaultvaluedecimal Shows the default value of the property for a decimal data type. Decimal
DynamicProperty defaultvaluedouble Shows the default value of the property for a double data type. Double
DynamicProperty defaultvalueinteger Shows the default value of the property for a whole number data type. Integer
DynamicProperty defaultvalueoptionset Shows the default value of the property. Lookup
DynamicProperty defaultvaluestring Shows the default value of the property for a string data type. String
DynamicProperty description Type a description for the property. Memo
DynamicProperty dmtimportstate Internal Use Only Integer
DynamicProperty dynamicpropertyid Shows the unique identifier of the property. Uniqueidentifier
DynamicProperty importsequencenumber Unique identifier of the data import or data migration that created this property. Integer
DynamicProperty ishidden Defines whether the attribute is hidden or shown. Boolean
DynamicProperty isreadonly Defines whether the attribute is read-only or if it can be edited. Boolean
DynamicProperty isrequired Defines whether the attribute is mandatory. Boolean
DynamicProperty maxlengthstring Shows the maximum allowed length of the property for a string data type. Integer
DynamicProperty maxvaluedecimal Shows the maximum allowed value of the property for a decimal data type. Decimal
DynamicProperty maxvaluedouble Shows the maximum allowed value of the property for a double data type. Double
DynamicProperty maxvalueinteger Shows the maximum allowed value of the property for a whole number data type. Integer
DynamicProperty minvaluedecimal Shows the minimum allowed value of the property for a decimal data type. Decimal
DynamicProperty minvaluedouble Shows the minimum allowed value of the property for a double data type. Double
DynamicProperty minvalueinteger Shows the minimum allowed value of the property for a whole number data type. Integer
DynamicProperty modifiedby Shows who last updated the record. Lookup
DynamicProperty modifiedon Shows the date and time when the record was last updated. DateTime
DynamicProperty modifiedonbehalfby Shows who created the record on behalf of another user. Lookup
DynamicProperty name Type the name of the property. String
DynamicProperty organizationid Unique identifier of the organization associated with the property. Lookup
DynamicProperty overriddencreatedon Date and time that the attribute was migrated. DateTime
DynamicProperty overwrittendynamicpropertyid Shows the related overwritten property. Uniqueidentifier
DynamicProperty precision Shows the allowed precision of the property for a whole number data type. Integer
DynamicProperty regardingobjectid Choose the product that the property is associated with. Lookup
DynamicProperty rootdynamicpropertyid Shows the root property that this property is derived from. Uniqueidentifier
DynamicProperty statecode Shows the state of the property. State
DynamicProperty statuscode Shows whether the property is active or inactive. Status
DynamicProperty versionnumber Version number of the property. BigInt
DynamicPropertyAssociation associationstatus Shows the status of the property association. Picklist
DynamicPropertyAssociation createdby Shows who created the record. Lookup
DynamicPropertyAssociation createdon Shows the date and time when the record was created. DateTime
DynamicPropertyAssociation createdonbehalfby Shows who created the record on behalf of another user. Lookup
DynamicPropertyAssociation dmtimportstate Internal Use Only Integer
DynamicPropertyAssociation dynamicpropertyassociationid Shows the unique identifier of the property association. Uniqueidentifier
DynamicPropertyAssociation dynamicpropertyid Shows the property that uses this option set item. Lookup
DynamicPropertyAssociation exchangerate 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. Decimal
DynamicPropertyAssociation importsequencenumber Shows the data import or data migration that created this record. Integer
DynamicPropertyAssociation inheritancestate Shows the inheritance state in relationship to the parent property. Picklist
DynamicPropertyAssociation modifiedby Shows who last updated the record. Lookup
DynamicPropertyAssociation modifiedon Shows the date and time when the record was last updated. DateTime
DynamicPropertyAssociation modifiedonbehalfby Shows who created the record on behalf of another user. Lookup
DynamicPropertyAssociation organizationid Shows the organization associated with the record. Lookup
DynamicPropertyAssociation overriddencreatedon Shows the date and time that the record was migrated. DateTime
DynamicPropertyAssociation regardingobjectid Shows the object that the property is associated with. Lookup
DynamicPropertyAssociation transactioncurrencyid Shows the currency associated with the record. Lookup
DynamicPropertyAssociation versionnumber Shows the version number of the property association. BigInt
DynamicPropertyInstance createdby Shows who created the record. Lookup
DynamicPropertyInstance createdon Shows the date and time when the record was created. DateTime
DynamicPropertyInstance createdonbehalfby Shows who created the record on behalf of another user. Lookup
DynamicPropertyInstance dmtimportstate Internal Use Only Integer
DynamicPropertyInstance dynamicpropertyid Shows the property that this record is associated with. Lookup
DynamicPropertyInstance dynamicpropertyinstanceid Shows the unique identifier of the property instance. Uniqueidentifier
DynamicPropertyInstance exchangerate 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. Decimal
DynamicPropertyInstance modifiedby Shows who last updated the record. Lookup
DynamicPropertyInstance modifiedon Shows the date and time when the record was last updated. DateTime
DynamicPropertyInstance modifiedonbehalfby Shows who created the record on behalf of another user. Lookup
DynamicPropertyInstance ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
DynamicPropertyInstance owningbusinessunit Shows the business unit that the record owner belongs to. Lookup
DynamicPropertyInstance owningteam Shows the team who owns the property instance. Lookup
DynamicPropertyInstance owninguser Shows the user who owns the property instance. Lookup
DynamicPropertyInstance regardingobjectid Shows the object that the property is associated with. Lookup
DynamicPropertyInstance transactioncurrencyid Shows the currency associated with the record. Lookup
DynamicPropertyInstance validationstatus Shows whether the property value is valid. Boolean
DynamicPropertyInstance valuedecimal Shows the decimal value of the property. Decimal
DynamicPropertyInstance valuedouble Shows the double value of the property. Double
DynamicPropertyInstance valueinteger Shows the integer value of the property. Integer
DynamicPropertyInstance valuestring Shows the string value of the property. String
DynamicPropertyInstance versionnumber Shows the version number of the property instance. BigInt
DynamicPropertyOptionSetItem createdby Shows who created the record. Lookup
DynamicPropertyOptionSetItem createdon Shows the date and time when the record was created. DateTime
DynamicPropertyOptionSetItem createdonbehalfby Shows who created the record on behalf of another user. Lookup
DynamicPropertyOptionSetItem dmtimportstate Internal Use Only Integer
DynamicPropertyOptionSetItem dynamicpropertyid Shows the property that uses this option set item. Lookup
DynamicPropertyOptionSetItem dynamicpropertyoptiondescription Type additional information about the property option set item. String
DynamicPropertyOptionSetItem dynamicpropertyoptionname Type the name of the property option set item. String
DynamicPropertyOptionSetItem dynamicpropertyoptionsetvalueid Shows the unique identifier of the property option set item. Uniqueidentifier
DynamicPropertyOptionSetItem dynamicpropertyoptionsetvaluesequencenumber Internal Use Only Integer
DynamicPropertyOptionSetItem dynamicpropertyoptionvalue Shows the value of the property option set item. Integer
DynamicPropertyOptionSetItem exchangerate 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. Decimal
DynamicPropertyOptionSetItem importsequencenumber Shows the data import or data migration that created this record. Integer
DynamicPropertyOptionSetItem modifiedby Shows who last updated the record. Lookup
DynamicPropertyOptionSetItem modifiedon Shows the date and time when the record was last updated. DateTime
DynamicPropertyOptionSetItem modifiedonbehalfby Shows who created the record on behalf of another user. Lookup
DynamicPropertyOptionSetItem organizationid Shows the organization associated with the record. Lookup
DynamicPropertyOptionSetItem overriddencreatedon Shows the date and time that the record was migrated. DateTime
DynamicPropertyOptionSetItem transactioncurrencyid Shows the currency associated with the record. Lookup
DynamicPropertyOptionSetItem versionnumber Shows the version number of the property option set item. BigInt
Email activityadditionalparams For internal use only. Memo
Email activityid Unique identifier of the email activity. Uniqueidentifier
Email activitytypecode Shows the type of activity. EntityName
Email actualdurationminutes Type the number of minutes spent creating and sending the email. The duration is used in reporting. Integer
Email actualend Enter the actual end date and time of the email. By default, it displays the date and time when the activity was completed or canceled, but can be edited to capture the actual time to create and send the email. DateTime
Email actualstart Enter the actual start date and time for the email. By default, it displays the date and time when the activity was created, but can be edited to capture the actual time to create and send the email. DateTime
Email attachmentcount Shows the umber of attachments of the email message. Integer
Email attachmentopencount Shows the number of times an email attachment has been viewed. Integer
Email baseconversationindexhash Hash of base of conversation index. Integer
Email bcc Enter the recipients that are included on the email distribution, but are not displayed to other recipients. PartyList
Email category Type a category to identify the email type, such as lead outreach, customer follow-up, or service alert, to tie the email to a business group or function. String
Email cc Enter the recipients that should be copied on the email. PartyList
Email compressed Indicates if the body is compressed. Boolean
Email conversationindex Identifier for all the email responses for this conversation. String
Email conversationtrackingid Conversation Tracking Id. Uniqueidentifier
Email correlationmethod Shows how an email is matched to an existing email in Microsoft Dynamics 365. For system use only. Picklist
Email createdby Shows who created the record. Lookup
Email createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Email createdonbehalfby Shows who created the record on behalf of another user. Lookup
Email delayedemailsendtime Enter the expected date and time when email will be sent. DateTime
Email deliveryattempts Shows the count of the number of attempts made to send the email. The count is used as an indicator of email routing issues. Integer
Email deliveryprioritycode Select the priority of delivery of the email to the email server. Picklist
Email deliveryreceiptrequested Select whether the sender should receive confirmation that the email was delivered. Boolean
Email description Type the greeting and message text of the email. Memo
Email directioncode Select the direction of the email as incoming or outbound. Boolean
Email emailreminderexpirytime Shows the date and time when an email reminder expires. DateTime
Email emailreminderstatus Shows the status of the email reminder. Picklist
Email emailremindertext For internal use only. String
Email emailremindertype Shows the type of the email reminder. Picklist
Email emailsender Shows the sender of the email. Lookup
Email emailtrackingid Email Tracking Id. Uniqueidentifier
Email exchangerate 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. Decimal
Email followemailuserpreference 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. Boolean
Email from Enter the sender of the email. PartyList
Email importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Email inreplyto Type the ID of the email message that this email activity is a response to. String
Email isbilled Information regarding whether the email activity was billed as part of resolving a case. Boolean
Email isemailfollowed For internal use only. Shows whether this email is followed. This is evaluated state which overrides user selection of follow email. Boolean
Email isregularactivity Information regarding whether the activity is a regular activity type or event type. Boolean
Email isunsafe For internal use only. Integer
Email isworkflowcreated Indication if the email was created by a workflow rule. Boolean
Email lastonholdtime Contains the date and time stamp of the last on hold time. DateTime
Email lastopenedtime Shows the date and time when an email was last opened. DateTime
Email linksclickedcount Shows the number of times a link in an email has been clicked. Integer
Email messageid Unique identifier of the email message. Used only for email that is received. String
Email messageiddupcheck For internal use only. Uniqueidentifier
Email mimetype MIME type of the email message data. String
Email modifiedby Shows who last updated the record. Lookup
Email modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Email modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
Email notifications Select the notification code to identify issues with the email recipients or attachments, such as blocked attachments. Picklist
Email onholdtime Shows how long, in minutes, that the record was on hold. Integer
Email opencount Shows the number of times an email has been opened. Integer
Email overriddencreatedon Date and time that the record was migrated. DateTime
Email ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
Email owningbusinessunit Unique identifier of the business unit that owns the email activity. Lookup
Email owningteam Unique identifier of the team who owns the email activity. Lookup
Email owninguser Unique identifier of the user who owns the email activity. Lookup
Email parentactivityid Select the activity that the email is associated with. Lookup
Email postponeemailprocessinguntil For internal use only. DateTime
Email prioritycode Select the priority so that preferred customers or critical issues are handled quickly. Picklist
Email processid Shows the ID of the process. Uniqueidentifier
Email readreceiptrequested Indicates that a read receipt is requested. Boolean
Email regardingobjectid Choose the record that the email relates to. Lookup
Email reminderactioncardid Reminder Action Card ID. Uniqueidentifier
Email replycount Shows the number of replies received for an email. Integer
Email scheduleddurationminutes Scheduled duration of the email activity, specified in minutes. Integer
Email scheduledend Enter the expected due date and time for the activity to be completed to provide details about when the email will be sent. DateTime
Email scheduledstart Enter the expected start date and time for the activity to provide details about the tentative time when the email activity must be initiated. DateTime
Email sender Sender of the email. String
Email sendermailboxid Select the mailbox associated with the sender of the email message. Lookup
Email sendersaccount Shows the parent account of the sender of the email. Lookup
Email senton Shows the date and time that the email was sent. DateTime
Email serviceid Unique identifier for the associated service. Lookup
Email slaid Choose the service level agreement (SLA) that you want to apply to the email record. Lookup
Email slainvokedid Last SLA that was applied to this email. This field is for internal use only. Lookup
Email sortdate Shows the date and time by which the activities are sorted. DateTime
Email stageid Shows the ID of the stage. Uniqueidentifier
Email statecode Shows whether the email is open, completed, or canceled. Completed and canceled email is read-only and can’t be edited. State
Email statuscode Select the email’s status. Status
Email subcategory Type a subcategory to identify the email type and relate the activity to a specific product, sales region, business group, or other function. String
Email subject Type a short description about the objective or primary topic of the email. String
Email submittedby Shows the Microsoft Office Outlook account for the user who submitted the email to Microsoft Dynamics 365. String
Email templateid For internal use only. ID for template used in email. Lookup
Email timezoneruleversionnumber For internal use only. Integer
Email to Enter the account, contact, lead, queue, or user recipients for the email. PartyList
Email torecipients Shows the email addresses corresponding to the recipients. String
Email trackingtoken Shows the tracking token assigned to the email to make sure responses are automatically tracked in Microsoft Dynamics 365. String
Email transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Email traversedpath For internal use only. String
Email utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Email versionnumber Version number of the email message. BigInt
EmailHash activityid Unique identifier of the activity with which the hash is associated. Lookup
EmailHash emailhashid Unique identifier of the email hash. Uniqueidentifier
EmailHash hash Hash value. Integer
EmailHash hashtype Hash type. Integer
EmailHash ownerid Unique identifier of the user or team who owns the email hash. Owner
EmailHash owningbusinessunit Unique identifier of the business unit that owns the email hash. Uniqueidentifier
EmailHash owninguser Unique identifier of the user who owns the email hash. Uniqueidentifier
EmailHash versionnumber BigInt
EmailSearch emailaddress The email address String
EmailSearch emailsearchid Unique identifier of the email search entry. Uniqueidentifier
EmailSearch parentobjectid Unique identifier of the parent object with which the email address is associated. Lookup
EmailSearch versionnumber BigInt
EmailServerProfile createdby Shows who created the record. Lookup
EmailServerProfile createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
EmailServerProfile createdonbehalfby Shows who created the record on behalf of another user. Lookup
EmailServerProfile defaultserverlocation Type the default location of the server. String
EmailServerProfile description Type additional information that describes the email server profile. Memo
EmailServerProfile emailserverprofileid Unique identifier of the email server profile. Uniqueidentifier
EmailServerProfile emailservertypename Email Server Type Name String
EmailServerProfile encodingcodepage Indicates the code page to use when encoding email content. String
EmailServerProfile entityimageid For internal use only. Uniqueidentifier
EmailServerProfile exchangeonlinetenantid Type the tenant ID of Exchange Online. String
EmailServerProfile exchangeversion Select the version of Exchange that is on the email server. Picklist
EmailServerProfile incomingauthenticationprotocol Select the incoming email authentication protocol that is used for connecting to the email server. Picklist
EmailServerProfile incomingcredentialretrieval Select how credentials will be retrieved for incoming email. Picklist
EmailServerProfile incomingpartnerapplication Indicates the incoming partner application. Lookup
EmailServerProfile incomingpassword Type the password for incoming email. String
EmailServerProfile incomingportnumber Type the Exchange port number for incoming mail. Integer
EmailServerProfile incomingserverlocation Type the location of the server for incoming email. String
EmailServerProfile incominguseimpersonation Select whether to use impersonation to access the mailbox to process incoming emails. Boolean
EmailServerProfile incomingusername Type the user name for incoming email. String
EmailServerProfile incomingusessl Select whether to use the Secure Sockets Layer (SSL) protocol for incoming email. Boolean
EmailServerProfile isincomingpasswordset Boolean
EmailServerProfile isoutgoingpasswordset Boolean
EmailServerProfile lastauthorizationstatus Shows the last test authorization status of email server profile Picklist
EmailServerProfile lastcrmmessage Shows the Dynamics 365 message obtained during the Last Test Memo
EmailServerProfile lasttestexecutionstatus Shows the last test Execution status of email server profile Picklist
EmailServerProfile lasttestrequest Shows the EWS Request created during the Last Test Memo
EmailServerProfile lasttestresponse Shows the EWS Response obtained during the Last Test Memo
EmailServerProfile lastteststarttime Shows the Last Test Start date and time DateTime
EmailServerProfile lasttesttotalexecutiontime Shows the Time taken while running the last test BigInt
EmailServerProfile lasttestvalidationstatus Shows the last test Validation status of email server profile Picklist
EmailServerProfile maxconcurrentconnections Maximum number of concurrent connections allowed to the email server per authenticated user. Integer
EmailServerProfile minpollingintervalinminutes Minimum polling interval, in minutes, for mailboxes that are associated with this email server profile. Integer
EmailServerProfile modifiedby Shows who last updated the record. Lookup
EmailServerProfile modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
EmailServerProfile modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
EmailServerProfile moveundeliveredemails Indicates whether to move undelivered incoming emails to the Undeliverable folder in Microsoft Exchange. Boolean
EmailServerProfile name Type a meaningful name for the email server profile. This name is displayed when you need to select an email server profile. String
EmailServerProfile organizationid Unique identifier of the organization associated with the record. Lookup
EmailServerProfile outgoingauthenticationprotocol Select the outgoing email authentication protocol that is used for connecting to the email server. Picklist
EmailServerProfile outgoingautograntdelegateaccess Indicates whether the email connector will grant delegate access permissions to the accessing user when required while processing outgoing emails. Boolean
EmailServerProfile outgoingcredentialretrieval Select how credentials will be retrieved for outgoing email. Picklist
EmailServerProfile outgoingpartnerapplication Indicates the outgoing partner application. Lookup
EmailServerProfile outgoingpassword Type the password for outgoing email. String
EmailServerProfile outgoingportnumber Type the Exchange port number for outgoing mail. Integer
EmailServerProfile outgoingserverlocation Type the location of the server for outgoing email. String
EmailServerProfile outgoinguseimpersonation Select whether to use impersonation for accessing the mailbox to process outgoing emails. Boolean
EmailServerProfile outgoingusername Type the user name for outgoing email. String
EmailServerProfile outgoingusessl Select whether to use the Secure Sockets Layer (SSL) protocol for outgoing email. Boolean
EmailServerProfile owneremailaddress Email Server Profile Owner’s email address String
EmailServerProfile ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
EmailServerProfile owningbusinessunit Select the business unit that owns the record. Lookup
EmailServerProfile owningteam Unique identifier for the team that owns the record. Lookup
EmailServerProfile owninguser Unique identifier for the user that owns the record. Lookup
EmailServerProfile processemailsreceivedafter Shows the date and time after which email messages that are received will be processed for mailboxes associated with the email server profile. DateTime
EmailServerProfile sendemailalert Select whether to send an email alert if more than 50% of the mailboxes in this email server profile failed to synchronize in an hour period. Boolean
EmailServerProfile servertype Select the profile’s email server type. Picklist
EmailServerProfile statecode Shows whether the email server profile is active or inactive. State
EmailServerProfile statuscode Select the email server profile’s status. Status
EmailServerProfile timeoutmailboxconnection Select whether to timeout a single mailbox. Boolean
EmailServerProfile timeoutmailboxconnectionafteramount Type the number of milliseconds to timeout a single mailbox. The upper limit is 100 seconds. Integer
EmailServerProfile timezoneruleversionnumber For internal use only. Integer
EmailServerProfile useautodiscover Select whether to automatically discover the server location Boolean
EmailServerProfile usedefaulttenantid Select whether to use the Exchange Online Tenant ID obtained from running Microsoft Azure PowerShell cmdlets (highly recommended). If you select No, you can edit this field manually Boolean
EmailServerProfile usesamesettingsforoutgoingconnections Select whether to use the same settings for incoming and outgoing connections. Boolean
EmailServerProfile utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
EmailSignature body Body text of the email signature. Memo
EmailSignature componentstate For internal use only. Picklist
EmailSignature createdby Unique identifier of the user who created the email signature. Lookup
EmailSignature createdon Date and time when the email signature was created. DateTime
EmailSignature createdonbehalfby Unique identifier of the delegate user who created the email signature. Lookup
EmailSignature description Description of the email signature. Memo
EmailSignature emailsignatureid Unique identifier of the email signature. Uniqueidentifier
EmailSignature generationtypecode For internal use only. Integer
EmailSignature importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
EmailSignature iscustomizable Information that specifies whether this component can be customized. ManagedProperty
EmailSignature isdefault Information that specifies whether the email signature is default to the user. Boolean
EmailSignature ispersonal Information about whether the email signature is personal or is available to all users. Boolean
EmailSignature languagecode Language of the email signature. Integer
EmailSignature mimetype MIME type of the email signature. String
EmailSignature modifiedby Unique identifier of the user who last modified the email signature. Lookup
EmailSignature modifiedon Date and time when the email signature was last modified. DateTime
EmailSignature modifiedonbehalfby Unique identifier of the delegate user who last modified the email signature. Lookup
EmailSignature overriddencreatedon Date and time that the record was migrated. DateTime
EmailSignature overwritetime For internal use only. DateTime
EmailSignature ownerid Unique identifier of the user or team who owns the email signature for the email activity. Owner
EmailSignature owningbusinessunit Unique identifier of the business unit that owns the email signature. Lookup
EmailSignature owningteam Unique identifier of the team who owns the email signature. Lookup
EmailSignature owninguser Unique identifier of the user who owns the email signature. Lookup
EmailSignature presentationxml XML data for the body of the email signature. Memo
EmailSignature title Title of the email signature. String
Entitlement accountid Unique identifier for Account associated with Entitlement. Lookup
Entitlement allocationtypecode Select the type of entitlement terms. Picklist
Entitlement contactid Unique identifier for Contact associated with Entitlement. Lookup
Entitlement createdby Unique identifier of the user who created the record. Lookup
Entitlement createdon Date and time when the entitlement was created. DateTime
Entitlement createdonbehalfby Unique identifier of the delegate user who created the entitlement. Lookup
Entitlement customerid Choose a contact or account for which this entitlement has been defined. Customer
Entitlement decreaseremainingon Select whether to decrease the remaining terms when the case is created or when it is resolved. Picklist
Entitlement description Type additional information to describe the Entitlement Memo
Entitlement enddate Enter the date when the entitlement ends. DateTime
Entitlement entitlementid Unique identifier for entity instances Uniqueidentifier
Entitlement entitlementtemplateid Unique identifier for Entitlement Template associated with Entitlement. Lookup
Entitlement exchangerate Exchange rate for the currency associated with the contact with respect to the base currency. Decimal
Entitlement importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Entitlement isdefault Shows whether this entitlement is the default one for the specified customer. Boolean
Entitlement kbaccesslevel Select the access someone will have to the knowledge base on the portal. Picklist
Entitlement modifiedby Unique identifier of the user who modified the record. Lookup
Entitlement modifiedon Date and time when the record was modified. DateTime
Entitlement modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
Entitlement name Type a meaningful name for the entitlement. String
Entitlement overriddencreatedon Date and time that the record was migrated. DateTime
Entitlement ownerid Enter the user or team who owns the entitlement. This field is updated every time the item is assigned to a different user. Owner
Entitlement owningbusinessunit Unique identifier for the business unit that owns the record Lookup
Entitlement owningteam Unique identifier for the team that owns the record. Lookup
Entitlement owninguser Unique identifier for the user that owns the record. Lookup
Entitlement processid Unique identifier of the Process. Uniqueidentifier
Entitlement remainingterms Type the total number of entitlement terms that are left. Decimal
Entitlement restrictcasecreation Tells whether case creation is restricted based on entitlement terms. Boolean
Entitlement slaid Choose the service level agreement (SLA) associated with the entitlement. Lookup
Entitlement stageid Unique identifier of the Stage. Uniqueidentifier
Entitlement startdate Enter the date when the entitlement starts. DateTime
Entitlement statecode For internal use only. State
Entitlement statuscode Select the reason code that explains the status of the entitlement. Status
Entitlement timezoneruleversionnumber For internal use only. Integer
Entitlement totalterms Type the total number of entitlement terms. Decimal
Entitlement transactioncurrencyid Unique identifier of the currency associated with the contact. Lookup
Entitlement traversedpath For internal use only. String
Entitlement utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Entitlement versionnumber Version number of the entitlement item. BigInt
EntitlementChannel channel Select a channel for which you are defining the entitlement terms. Picklist
EntitlementChannel createdby Unique identifier of the user who created the record. Lookup
EntitlementChannel createdon Date and time when the entitlement was created. DateTime
EntitlementChannel createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
EntitlementChannel entitlementchannelid Unique identifier for entity instances Uniqueidentifier
EntitlementChannel entitlementid Unique identifier for Entitlement associated with Entitlement Channel. Lookup
EntitlementChannel exchangerate Exchange rate for the currency associated with the incident with respect to the base currency. Decimal
EntitlementChannel importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
EntitlementChannel modifiedby Unique identifier of the user who modified the record. Lookup
EntitlementChannel modifiedon Date and time when the record was modified. DateTime
EntitlementChannel modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
EntitlementChannel name The name of the custom entity. String
EntitlementChannel organizationid Unique identifier of the organization with which the entitlement channel is associated. Lookup
EntitlementChannel overriddencreatedon Date and time that the record was migrated. DateTime
EntitlementChannel ownerid Unique identifier of the user or team who owns the entitlement channel. Owner
EntitlementChannel owningbusinessunit Unique identifier for the business unit that owns the record Lookup
EntitlementChannel owninguser Unique identifier for the user that owns the record. Lookup
EntitlementChannel remainingterms Type the total number of entitlement terms that are left. Decimal
EntitlementChannel timezoneruleversionnumber For internal use only. Integer
EntitlementChannel totalterms Type the total number of entitlement terms. Decimal
EntitlementChannel transactioncurrencyid Unique identifier of the currency associated with the incident. Lookup
EntitlementChannel utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
EntitlementChannel versionnumber Version number of the entitlement channel item. BigInt
EntitlementContacts contactid Uniqueidentifier
EntitlementContacts entitlementcontactid Unique identifier of the contacts for the entitlements. Uniqueidentifier
EntitlementContacts entitlementid Uniqueidentifier
EntitlementContacts versionnumber BigInt
EntitlementProducts entitlementid Uniqueidentifier
EntitlementProducts entitlementproductid Unique identifier of the contacts for the entitlements. Uniqueidentifier
EntitlementProducts productid Uniqueidentifier
EntitlementProducts versionnumber BigInt
EntitlementTemplate allocationtypecode Select whether the entitlement allocation is based on number of cases or number of hours. Picklist
EntitlementTemplate createdby Unique identifier of the user who created the record. Lookup
EntitlementTemplate createdon Date and time when the entitlement was created. DateTime
EntitlementTemplate createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
EntitlementTemplate decreaseremainingon Information about whether to decrease the remaining terms when the case is created or when it is resolved Picklist
EntitlementTemplate description Type additional information to describe the account, such as an excerpt from the company’s website. Memo
EntitlementTemplate enddate Enter the date and time when the entitlement ends. DateTime
EntitlementTemplate entitlementtemplateid Unique identifier for entity instances Uniqueidentifier
EntitlementTemplate exchangerate Exchange rate for the currency associated with the contact with respect to the base currency. Decimal
EntitlementTemplate importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
EntitlementTemplate kbaccesslevel Select the access someone will have to the knowledge base on the portal. Picklist
EntitlementTemplate modifiedby Unique identifier of the user who modified the record. Lookup
EntitlementTemplate modifiedon Date and time when the record was modified. DateTime
EntitlementTemplate modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
EntitlementTemplate name Type a descriptive name for the entitlement template. String
EntitlementTemplate organizationid Unique identifier of the organization associated with the entitlement template. Lookup
EntitlementTemplate overriddencreatedon Date and time that the record was migrated. DateTime
EntitlementTemplate restrictcasecreation Tells whether case creation is restricted based on entitlement terms. Boolean
EntitlementTemplate slaid Choose the service level agreement (SLA) associated with the entitlement. Lookup
EntitlementTemplate startdate Enter the date and time when the entitlement begins. DateTime
EntitlementTemplate timezoneruleversionnumber For internal use only. Integer
EntitlementTemplate totalterms Type the total number of entitlement terms. Decimal
EntitlementTemplate transactioncurrencyid Unique identifier of the currency associated with the contact. Lookup
EntitlementTemplate utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
EntitlementTemplate versionnumber Version number of the entitlement template item. BigInt
EntitlementTemplateChannel channel Select a channel for which you are defining the entitlement terms. Picklist
EntitlementTemplateChannel createdby Unique identifier of the user who created the record. Lookup
EntitlementTemplateChannel createdon Date and time when the entitlement was created. DateTime
EntitlementTemplateChannel createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
EntitlementTemplateChannel entitlementtemplatechannelid Unique identifier for entity instances Uniqueidentifier
EntitlementTemplateChannel entitlementtemplateid Unique identifier for Entitlement Template associated with Entitlement Template Channel. Lookup
EntitlementTemplateChannel exchangerate Exchange rate for the currency associated with the incident with respect to the base currency. Decimal
EntitlementTemplateChannel importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
EntitlementTemplateChannel modifiedby Unique identifier of the user who modified the record. Lookup
EntitlementTemplateChannel modifiedon Date and time when the record was modified. DateTime
EntitlementTemplateChannel modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
EntitlementTemplateChannel name The name of the custom entity. String
EntitlementTemplateChannel organizationid Unique identifier of the organization with which the entitlement template channel is associated. Lookup
EntitlementTemplateChannel overriddencreatedon Date and time that the record was migrated. DateTime
EntitlementTemplateChannel timezoneruleversionnumber For internal use only. Integer
EntitlementTemplateChannel totalterms Type the total number of entitlement terms. Decimal
EntitlementTemplateChannel transactioncurrencyid Unique identifier of the currency associated with the incident. Lookup
EntitlementTemplateChannel utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
EntitlementTemplateChannel versionnumber Version number of the entitlement template channel item. BigInt
EntitlementTemplateProducts entitlementtemplateid Uniqueidentifier
EntitlementTemplateProducts entitlementtemplateproductid Unique identifier of the contacts for the EntitlementTemplates. Uniqueidentifier
EntitlementTemplateProducts productid Uniqueidentifier
EntitlementTemplateProducts versionnumber BigInt
EntityMap componentstate For internal use only. Picklist
EntityMap createdby Unique identifier of the user who created the entity map. Lookup
EntityMap createdon Date and time when the entity map was created. DateTime
EntityMap createdonbehalfby Unique identifier of the delegate user who created the entitymap. Lookup
EntityMap entitymapid Unique identifier of the entity map. Uniqueidentifier
EntityMap entitymapidunique For internal use only. Uniqueidentifier
EntityMap ismanaged Boolean
EntityMap modifiedby Unique identifier of the user who last modified the entity map. Lookup
EntityMap modifiedon Date and time when the entity map was last modified. DateTime
EntityMap modifiedonbehalfby Unique identifier of the delegate user who last modified the entitymap. Lookup
EntityMap organizationid Unique identifier of the organization with which the entity map is associated. Lookup
EntityMap overwritetime For internal use only. DateTime
EntityMap solutionid Unique identifier of the associated solution. Uniqueidentifier
EntityMap sourceentityname Name of the source entity for the entity mapping. String
EntityMap supportingsolutionid For internal use only. Uniqueidentifier
EntityMap targetentityname Name of the Microsoft Dynamics 365 entity. String
EntityMap versionnumber BigInt
Equipment businessunitid Unique identifier of the associated business unit. Lookup
Equipment calendarid Fiscal calendar associated with the facility/equipment. Lookup
Equipment createdby Unique identifier of the user who created the facility/equipment entry. Lookup
Equipment createdon Date and time when the facility/equipment entry was created. DateTime
Equipment createdonbehalfby Unique identifier of the delegate user who created the equipment. Lookup
Equipment description Description of the facility/equipment. Memo
Equipment displayinserviceviews For internal use only. Boolean
Equipment emailaddress Email address of person to contact about the use of the facility/equipment. String
Equipment equipmentid Unique identifier of the facility/equipment. Uniqueidentifier
Equipment exchangerate Exchange rate for the currency associated with the equipment with respect to the base currency. Decimal
Equipment importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Equipment isdisabled Whether the facility/equipment is disabled or operational. Boolean
Equipment modifiedby Unique identifier of the user who last modified the facility/equipment. Lookup
Equipment modifiedon Date and time when the facility/equipment entry was last modified. DateTime
Equipment modifiedonbehalfby Unique identifier of the delegate user who last modified the equipment. Lookup
Equipment name Name of the facility/equipment. String
Equipment organizationid Unique identifier of the parent business unit. Lookup
Equipment overriddencreatedon Date and time that the record was migrated. DateTime
Equipment siteid Site where the facility/equipment is located. Lookup
Equipment skills Skills needed to operate the facility/equipment. String
Equipment timezonecode Local time zone where the facility/equipment is located. Integer
Equipment timezoneruleversionnumber For internal use only. Integer
Equipment transactioncurrencyid Unique identifier of the currency associated with the equipment. Lookup
Equipment utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Equipment versionnumber Version number of the equipment. BigInt
ExchangeSyncIdMapping createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
ExchangeSyncIdMapping exchangeentryid String
ExchangeSyncIdMapping exchangesyncidmappingid Uniqueidentifier
ExchangeSyncIdMapping fromcrmchangetype Integer
ExchangeSyncIdMapping isdeletedinexchange Boolean
ExchangeSyncIdMapping isunlinkedincrm Boolean
ExchangeSyncIdMapping lastsyncerror String
ExchangeSyncIdMapping lastsyncerrorcode Integer
ExchangeSyncIdMapping lastsyncerroroccurredon Last Sync Error Time DateTime
ExchangeSyncIdMapping modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
ExchangeSyncIdMapping objectid Uniqueidentifier
ExchangeSyncIdMapping objecttypecode Integer
ExchangeSyncIdMapping ownerid Owner
ExchangeSyncIdMapping owningbusinessunit Lookup
ExchangeSyncIdMapping owningteam Lookup
ExchangeSyncIdMapping owninguser Lookup
ExchangeSyncIdMapping retries Integer
ExchangeSyncIdMapping tocrmchangetype Integer
ExchangeSyncIdMapping userdecision Integer
ExchangeSyncIdMapping versionnumber BigInt
ExpiredProcess activestageid Unique identifier of the active stage for the Business Process Flow instance. Lookup
ExpiredProcess activestagestartedon Date and time when current active stage is started. DateTime
ExpiredProcess businessprocessflowinstanceid Unique identifier for Expired Process bpf entity instances Uniqueidentifier
ExpiredProcess completedon Date and time when Business Process Flow instance is completed. DateTime
ExpiredProcess createdby Shows who created the record. Lookup
ExpiredProcess createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options. DateTime
ExpiredProcess createdonbehalfby Shows who created the record on behalf of another user. Lookup
ExpiredProcess duration Duration the business process flow was active. Integer
ExpiredProcess exchangerate 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. Decimal
ExpiredProcess importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
ExpiredProcess knowledgearticleid Unique identifier of the workflow associated to the Business Process Flow instance. Lookup
ExpiredProcess modifiedby Shows who last updated the record. Lookup
ExpiredProcess modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options. DateTime
ExpiredProcess modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
ExpiredProcess name Process Name. String
ExpiredProcess organizationid Unique identifier of the organization with which the SDK message request is associated. Lookup
ExpiredProcess overriddencreatedon Date and time that the record was migrated. DateTime
ExpiredProcess processid Unique identifier of the workflow associated to the Business Process Flow instance. Lookup
ExpiredProcess statecode Shows whether the Delve action record is pending, completed, or tracking. State
ExpiredProcess statuscode Select the delve action record status. Status
ExpiredProcess transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
ExpiredProcess traversedpath Traversed Path String
ExpiredProcess versionnumber Version number of the business process instance. BigInt
ExternalParty correlationkey Contains the value that is used to detect and avoid duplicate external party records. String
ExternalParty createdby Unique identifier of the user who created the record. Lookup
ExternalParty createdon Date and time when the record was created. DateTime
ExternalParty createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
ExternalParty emailaddress Shows the email address derived from the equivalent record that’s enabled as the external party and shows the external user’s email address. String
ExternalParty exchangerate Exchange rate for the currency associated with the ExternalParty with respect to the base currency. Decimal
ExternalParty externalpartyid Unique identifier for entity instances Uniqueidentifier
ExternalParty externalpartyidunique Unique identifier of the External Party used when synchronizing customizations for the Microsoft Dynamics 365 client for Outlook Uniqueidentifier
ExternalParty firstname Type the external party’s first name. String
ExternalParty fullname Type the full name of the external party. String
ExternalParty importsequencenumber Sequence number of the import that created this record. Integer
ExternalParty lastdisabledon Shows the date when the external party was last disabled on. DateTime
ExternalParty lastenabledon Shows the date when the external party was last enabled on. DateTime
ExternalParty lastname Type the external party’s last name. String
ExternalParty middlename Type the external party’s middle name. String
ExternalParty modifiedby Unique identifier of the user who modified the record. Lookup
ExternalParty modifiedon Date and time when the record was modified. DateTime
ExternalParty modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
ExternalParty overriddencreatedon Date and time that the record was migrated. DateTime
ExternalParty ownerid Unique identifier of the user or team who owns the record. Owner
ExternalParty owningbusinessunit Unique identifier for the business unit that owns the record Lookup
ExternalParty owningteam Unique identifier for the team that owns the record. Lookup
ExternalParty owninguser Unique identifier for the user that owns the record. Lookup
ExternalParty statecode Shows whether the external party is enabled or disabled State
ExternalParty statuscode Select the external party status Status
ExternalParty timezoneruleversionnumber For internal use only. Integer
ExternalParty transactioncurrencyid Exchange rate for the currency associated with the ExternalParty with respect to the base currency. Lookup
ExternalParty type Type of the external party. String
ExternalParty utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
ExternalParty versionnumber BigInt
ExternalParty yomifirstname Type the phonetic spelling of the external party’s first name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the external party.. String
ExternalParty yomifullname Shows the combined Yomi first and last names of the external party so that the full phonetic name can be displayed in views and reports. String
ExternalParty yomilastname Type the phonetic spelling of the external party’s last name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the external party. String
ExternalParty yomimiddlename Type the phonetic spelling of the external party’s middle name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the contact. String
ExternalPartyItem channelaccessprofileid Choose the channel access profile that’s used to determine the permissions when CRM is accessed from an external channel. Lookup
ExternalPartyItem createdby Unique identifier of the user who created the record. Lookup
ExternalPartyItem createdon Date and time when the record was created. DateTime
ExternalPartyItem createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
ExternalPartyItem exchangerate Exchange rate for the currency associated with the external party item with respect to the base currency. Decimal
ExternalPartyItem externalpartyid Type the external party record that this item is created for. Lookup
ExternalPartyItem externalpartyitemid Unique identifier for external party instances Uniqueidentifier
ExternalPartyItem importsequencenumber Sequence number of the import that created this record. Integer
ExternalPartyItem introducedversion Version in which the similarity rule is introduced. String
ExternalPartyItem lastdisabledon Shows the date and time when the external party item was last disabled for external channel access. DateTime
ExternalPartyItem lastenabledon Shows the date and time when the external party item was last enabled for external channel access. DateTime
ExternalPartyItem modifiedby Unique identifier of the user who modified the record. Lookup
ExternalPartyItem modifiedon Date and time when the record was modified. DateTime
ExternalPartyItem modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
ExternalPartyItem name Type the name of the external party item. String
ExternalPartyItem overriddencreatedon Date and time that the record was migrated. DateTime
ExternalPartyItem ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user or team. Owner
ExternalPartyItem owningbusinessunit Unique identifier for the business unit that owns the record Lookup
ExternalPartyItem owninguser Unique identifier for the user that owns the record. Lookup
ExternalPartyItem regardingobjectid Choose the external party enabled record that is associated with this external party item. Lookup
ExternalPartyItem statecode Shows whether the external party item is enabled or disabled. State
ExternalPartyItem statuscode Select the external party items status. Status
ExternalPartyItem transactioncurrencyid Exchange rate for the currency associated with the ExternalPartyItem with respect to the base currency. Lookup
ExternalPartyItem versionnumber BigInt
Fax activityid Unique identifier of the fax activity. Uniqueidentifier
Fax activitytypecode Type of activity. EntityName
Fax actualdurationminutes Type the number of minutes spent creating and sending the fax. The duration is used in reporting. Integer
Fax actualend Enter the actual end date and time of the fax. By default, it displays the date and time when the activity was completed or canceled, but can be edited to capture the actual time to create and send the fax. DateTime
Fax actualstart Enter the actual start date and time for the fax. By default, it displays the date and time when the activity was created, but can be edited to capture the actual time to create and send the fax. DateTime
Fax billingcode Type the billing code for the fax to make sure the fax is charged to the correct sender or customer account. String
Fax category Type a category to identify the fax type, such as sales offer or press release, to tie the fax to a business group or function. String
Fax coverpagename Type the name of the cover page to use when sending the fax. String
Fax createdby Shows who created the record. Lookup
Fax createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Fax createdonbehalfby Shows who created the record on behalf of another user. Lookup
Fax description Type additional information to describe the fax, such as the primary message or the products and services featured. Memo
Fax directioncode Select the direction of the fax as incoming or outbound. Boolean
Fax exchangerate 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. Decimal
Fax faxnumber Type the recipient’s fax number. String
Fax from Enter the account, contact, lead, queue, or user who sent the fax. PartyList
Fax importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Fax isbilled Information regarding whether the fax activity was billed as part of resolving a case. Boolean
Fax isregularactivity Information regarding whether the activity is a regular activity type or event type. Boolean
Fax isworkflowcreated Indication of whether the fax activity was created by a workflow rule. Boolean
Fax lastonholdtime Contains the date and time stamp of the last on hold time. DateTime
Fax modifiedby Shows who last updated the record. Lookup
Fax modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Fax modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
Fax numberofpages Type the number of pages included in the fax. Integer
Fax onholdtime Shows how long, in minutes, that the record was on hold. Integer
Fax overriddencreatedon Date and time that the record was migrated. DateTime
Fax ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
Fax owningbusinessunit Unique identifier of the business unit that owns the fax activity. Lookup
Fax owningteam Unique identifier of the team that owns the fax activity. Lookup
Fax owninguser Unique identifier of the user that owns the fax activity. Lookup
Fax prioritycode Select the priority so that preferred customers or critical issues are handled quickly. Picklist
Fax processid Shows the ID of the process. Uniqueidentifier
Fax regardingobjectid Choose the record that the fax relates to. Lookup
Fax scheduleddurationminutes Shows the expected duration of the fax activity, in minutes. Integer
Fax scheduledend Enter the expected due date and time. DateTime
Fax scheduledstart Enter the expected due date and time. DateTime
Fax serviceid Unique identifier for an associated service. Lookup
Fax slaid Choose the service level agreement (SLA) that you want to apply to the fax record. Lookup
Fax slainvokedid Last SLA that was applied to this fax. This field is for internal use only. Lookup
Fax sortdate Shows the date and time by which the activities are sorted. DateTime
Fax stageid Shows the ID of the stage. Uniqueidentifier
Fax statecode Shows whether the fax activity is open, completed, or canceled. Completed and canceled fax activities are read-only and can’t be edited. State
Fax statuscode Select the fax’s status. Status
Fax subcategory Type a subcategory to identify the fax type to relate the activity to a specific product, sales region, business group, or other function. String
Fax subject Type a short description about the objective or primary topic of the fax. String
Fax subscriptionid For internal use only. Uniqueidentifier
Fax timezoneruleversionnumber For internal use only. Integer
Fax to Enter the account, contact, lead, queue, or user recipients for the fax. PartyList
Fax transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Fax traversedpath For internal use only. String
Fax tsid Type the Transmitting Subscriber ID (TSID) associated with a send action. This is typically a combination of the recipient’s fax or phone number and company name. String
Fax utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Fax versionnumber Version number of the fax. BigInt
Feedback closedby Shows who closed the record. Lookup
Feedback closedon Shows the date and time when the record was closed. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Feedback comments Type the feedback comments. Memo
Feedback createdby Shows who created the record. Lookup
Feedback createdbycontact Shows the contact who created the record. Lookup
Feedback createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Feedback createdonbehalfby Shows who created the record on behalf of another user. Lookup
Feedback createdonbehalfbycontact Shows the contact who created the record on behalf of another user. Lookup
Feedback exchangerate 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. Decimal
Feedback feedbackid FeedbackId Uniqueidentifier
Feedback importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Feedback maxrating Enter the maximum rating value. Integer
Feedback minrating Enter the minimum rating value. Integer
Feedback modifiedby Shows who last updated the record. Lookup
Feedback modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Feedback modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
Feedback normalizedrating Shows the rating scaled to a value between 0 and 1 based on minimum and maximum ratings. Decimal
Feedback overriddencreatedon Date and time that the record was migrated. DateTime
Feedback ownerid Unique identifier of the user or team who owns the knowledge article views. Owner
Feedback owningbusinessunit Unique identifier of the business unit that owns the knowledge article views. Lookup
Feedback owningteam Unique identifier of the team that owns the feedback. Lookup
Feedback owninguser Unique identifier of the user who owns this feedback. Lookup
Feedback rating Specifies how helpful the related record was. Integer
Feedback regardingobjectid Shows the record that the feedback is associated with. Lookup
Feedback source Shows where the feedback was submitted from. Picklist
Feedback statecode Shows whether the feedback is open, rejected or closed. State
Feedback statuscode Select the feedback’s status. Status
Feedback title Type a title for the feedback. String
Feedback transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Feedback versionnumber Version number of the feedback. BigInt
FieldPermission attributelogicalname Attribute Name. String
FieldPermission cancreate Can this Profile create the attribute Picklist
FieldPermission canread Can this Profile read the attribute Picklist
FieldPermission canupdate Can this Profile update the attribute Picklist
FieldPermission componentstate For internal use only. Picklist
FieldPermission entityname Entity name. EntityName
FieldPermission fieldpermissionid Unique identifier of the Field Permission. Uniqueidentifier
FieldPermission fieldpermissionidunique For internal use only. Uniqueidentifier
FieldPermission fieldsecurityprofileid Unique identifier of profile to which this privilege belongs. Lookup
FieldPermission ismanaged Indicates whether the solution component is part of a managed solution. Boolean
FieldPermission organizationid Unique identifier for the organization Lookup
FieldPermission overwritetime For internal use only. DateTime
FieldPermission solutionid Unique identifier of the associated solution. Uniqueidentifier
FieldPermission supportingsolutionid For internal use only. Uniqueidentifier
FieldPermission versionnumber BigInt
FieldSecurityProfile componentstate For internal use only. Picklist
FieldSecurityProfile createdby Unique identifier of the user who created the profile. Lookup
FieldSecurityProfile createdon Date and time when the profile was created. DateTime
FieldSecurityProfile createdonbehalfby Unique identifier of the delegate user who created the role. Lookup
FieldSecurityProfile description Description of the Profile Memo
FieldSecurityProfile fieldsecurityprofileid Unique identifier of the profile. Uniqueidentifier
FieldSecurityProfile fieldsecurityprofileidunique For internal use only. Uniqueidentifier
FieldSecurityProfile ismanaged Indicates whether the solution component is part of a managed solution. Boolean
FieldSecurityProfile modifiedby Unique identifier of the user who last modified the profile. Lookup
FieldSecurityProfile modifiedon Date and time when the profile was last modified. DateTime
FieldSecurityProfile modifiedonbehalfby Unique identifier of the delegate user who last modified the profile. Lookup
FieldSecurityProfile name Name of the profile. String
FieldSecurityProfile organizationid Unique identifier of the associated organization. Lookup
FieldSecurityProfile overwritetime For internal use only. DateTime
FieldSecurityProfile solutionid Unique identifier of the associated solution. Uniqueidentifier
FieldSecurityProfile supportingsolutionid For internal use only. Uniqueidentifier
FieldSecurityProfile versionnumber BigInt
FilterTemplate description For internal use only. Memo
FilterTemplate fetchxml String that specifies the filter template in Fetch XML language. Memo
FilterTemplate filtertemplateid Unique identifier of the filter template. Uniqueidentifier
FilterTemplate name Name of the filter template. String
FilterTemplate querytype For internal use only. Integer
FilterTemplate returnedtypecode For internal use only. EntityName
FixedMonthlyFiscalCalendar businessunitid Business unit responsible for the quota associated with this calendar. Lookup
FixedMonthlyFiscalCalendar createdby Unique identifier of the user who created the fiscal calendar. Lookup
FixedMonthlyFiscalCalendar createdon Date and time when the quota for the fixed monthly fiscal calendar was created. DateTime
FixedMonthlyFiscalCalendar createdonbehalfby Unique identifier of the delegate user who created the fixedmonthlyfiscalcalendar. Lookup
FixedMonthlyFiscalCalendar effectiveon Date and time when the fixed monthly fiscal calendar sales quota takes effect. DateTime
FixedMonthlyFiscalCalendar exchangerate Exchange rate for the currency associated with the fixed monthly fiscal calendar with respect to the base currency. Decimal
FixedMonthlyFiscalCalendar fiscalperiodtype Type of fiscal period used in the fixed monthly fiscal calendar sales quota. Integer
FixedMonthlyFiscalCalendar modifiedby Unique identifier of the user who last modified the fixed monthly fiscal calendar. Lookup
FixedMonthlyFiscalCalendar modifiedon Date and time when the fixed monthly fiscal calendar was last modified. DateTime
FixedMonthlyFiscalCalendar modifiedonbehalfby Unique identifier of the delegate user who last modified the fixedmonthlyfiscalcalendar. Lookup
FixedMonthlyFiscalCalendar period1 Sales quota for the first period in the fiscal year. Money
FixedMonthlyFiscalCalendar period1_base Base currency equivalent of the sales quota for the first period in the fiscal year. Money
FixedMonthlyFiscalCalendar period10 Sales quota for the tenth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period10_base Base currency equivalent of the sales quota for the tenth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period11 Sales quota for the eleventh period in the fiscal year. Money
FixedMonthlyFiscalCalendar period11_base Base currency equivalent of the sales quota for the eleventh period in the fiscal year. Money
FixedMonthlyFiscalCalendar period12 Sales quota for the twelfth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period12_base Base currency equivalent of the sales quota for the twelfth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period13 Sales quota for the thirteenth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period13_base Base currency equivalent of the sales quota for the thirteenth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period2 Sales quota for the second period in the fiscal year. Money
FixedMonthlyFiscalCalendar period2_base Base currency equivalent of the sales quota for the second period in the fiscal year. Money
FixedMonthlyFiscalCalendar period3 Sales quota for the third period in the fiscal year. Money
FixedMonthlyFiscalCalendar period3_base Base currency equivalent of the sales quota for the third period in the fiscal year. Money
FixedMonthlyFiscalCalendar period4 Sales quota for the fourth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period4_base Base currency equivalent of the sales quota for the fourth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period5 Sales quota for the fifth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period5_base Base currency equivalent of the sales quota for the fifth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period6 Sales quota for the sixth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period6_base Base currency equivalent of the sales quota for the sixth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period7 Sales quota for the seventh period in the fiscal year. Money
FixedMonthlyFiscalCalendar period7_base Base currency equivalent of the sales quota for the seventh period in the fiscal year. Money
FixedMonthlyFiscalCalendar period8 Sales quota for the eighth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period8_base Base currency equivalent of the sales quota for the eighth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period9 Sales quota for the ninth period in the fiscal year. Money
FixedMonthlyFiscalCalendar period9_base Base currency equivalent of the sales quota for the ninth period in the fiscal year. Money
FixedMonthlyFiscalCalendar salespersonid Unique identifier of the associated salesperson. Lookup
FixedMonthlyFiscalCalendar timezoneruleversionnumber For internal use only. Integer
FixedMonthlyFiscalCalendar transactioncurrencyid Unique identifier of the currency associated with the fixed monthly fiscal calendar. Lookup
FixedMonthlyFiscalCalendar userfiscalcalendarid Unique identifier of the user of the fiscal calendar. Uniqueidentifier
FixedMonthlyFiscalCalendar utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Goal actualdecimal Shows the actual value (Decimal type) achieved towards the target as of the last rolled-up date. This field appears when the metric type of the goal is Amount and the amount data type is Decimal. Decimal
Goal actualinteger Shows the actual value (integer) achieved towards the target as of the last rolled-up date. This field appears when the metric type of the goal is Amount or Count and the amount data type is Integer. Integer
Goal actualmoney Shows the actual value (Money type) achieved towards the target as of the last rolled-up date. This field appears when the metric type of the goal is Amount and the amount data type is Money. Money
Goal actualmoney_base Shows the actual value (money type) in base currency to track goal results against the target. Money
Goal actualstring Actual Value of the goal. String
Goal amountdatatype Data type of the amount. Picklist
Goal computedtargetasoftodaydecimal Shows the expected amount for actual value (decimal type) against the target goal. Decimal
Goal computedtargetasoftodayinteger Shows the expected amount for actual value (integer type) against the target goal as of the current date. Integer
Goal computedtargetasoftodaymoney Shows the expected amount for actual value (money type) against the target goal as of the current date. Money
Goal computedtargetasoftodaymoney_base Shows the expected amount in base currency for actual value (money type) against the target goal as of the current date. Money
Goal computedtargetasoftodaypercentageachieved Shows the expected value for percentage achieved against the target goal as of the current date. Decimal
Goal consideronlygoalownersrecords Select whether only the goal owner’s records, or all records, should be rolled up for goal results. Boolean
Goal createdby Shows who created the record. Lookup
Goal createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Goal createdonbehalfby Shows who created the record on behalf of another user. Lookup
Goal customrollupfielddecimal Indicates a placeholder rollup field for a decimal value to track a third category of results other than actuals and in-progress results. Decimal
Goal customrollupfieldinteger Indicates a placeholder rollup field for an integer value to track a third category of results other than actuals and in-progress results. Integer
Goal customrollupfieldmoney Indicates a placeholder rollup field for a money value to track a third category of results other than actuals and in-progress results. Money
Goal customrollupfieldmoney_base Indicates a placeholder rollup field for a money value in base currency to track a third category of results other than actuals and in-progress results. Money
Goal customrollupfieldstring Placeholder rollup field for the goal. String
Goal depth Depth of the goal in the tree. Integer
Goal entityimageid For internal use only. Uniqueidentifier
Goal exchangerate 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. Decimal
Goal fiscalperiod Select the fiscal period for the goal. Picklist
Goal fiscalyear Select the fiscal year for the goal that’s being tracked. Picklist
Goal goalenddate Enter the date when the goal ends. DateTime
Goal goalid Unique identifier of the goal. Uniqueidentifier
Goal goalownerid Choose the user or team responsible for meeting the goal. Lookup
Goal goalstartdate Enter the date and time when the period for tracking the goal begins. DateTime
Goal goalwitherrorid Unique identifier of the goal that caused an error in the rollup of the goal hierarchy. Lookup
Goal importsequencenumber Sequence number of the import that created this record. Integer
Goal inprogressdecimal Shows the in-progress value (decimal) against the target. This value could contribute to a goal, but is not counted yet as actual. Decimal
Goal inprogressinteger Shows the in-progress value (integer) against the target. This value could contribute to a goal, but is not counted yet as actual. Integer
Goal inprogressmoney Shows the in-progress value (money) against the target. This value could contribute to a goal, but is not counted yet as actual. Money
Goal inprogressmoney_base Shows the in-progress value (money) in base currency to track goal results against the target. Money
Goal inprogressstring In-progress value of the goal. String
Goal isamount Indicates whether the metric type is Count or Amount. Boolean
Goal isfiscalperiodgoal Select whether the goal period is a fiscal period or custom period. Boolean
Goal isoverridden Select whether the system rollup fields are updated. If set to Yes, the next system rollup will not update the values of the rollup fields with the system calculated values. Boolean
Goal isoverride Indicates whether the values of system rollup fields can be updated. Boolean
Goal lastrolledupdate Shows the date and time when the goal was last rolled up. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Goal metricid Choose the metric for the goal. This metric determines how the goal is tracked. Lookup
Goal modifiedby Shows who last updated the record. Lookup
Goal modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Goal modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
Goal overriddencreatedon Date and time that the record was migrated. DateTime
Goal ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
Goal owningbusinessunit Unique identifier for the business unit that owns the record. Lookup
Goal owningteam Unique identifier of the team who owns the goal. Lookup
Goal owninguser Unique identifier for the user who owns the record. Lookup
Goal parentgoalid Choose a parent goal if the current goal is a child goal. This sets up a parent-child relationship for reporting and analytics. Lookup
Goal percentage Shows the percentage achieved against the target goal. Decimal
Goal rolluperrorcode Error code associated with rollup. Integer
Goal rolluponlyfromchildgoals Select whether the data should be rolled up only from the child goals. Boolean
Goal rollupqueryactualdecimalid Choose the query that will be used to calculate the actual data for the goal (decimal). Lookup
Goal rollupqueryactualintegerid Choose the query that will be used to calculate the actual data for the goal (integer). Lookup
Goal rollupqueryactualmoneyid Choose the query that will be used to calculate the actual data for the goal (money). Lookup
Goal rollupquerycustomdecimalid Choose the query that will be used to calculate data for the custom rollup field (decimal). Lookup
Goal rollupquerycustomintegerid Choose the query that will be used to calculate data for the custom rollup field (integer). Lookup
Goal rollupquerycustommoneyid Choose the query that will be used to calculate data for the custom rollup field (money). Lookup
Goal rollupqueryinprogressdecimalid Choose the query that will be used to calculate data for the in-progress rollup field (decimal). Lookup
Goal rollupqueryinprogressintegerid Choose the query that will be used to calculate data for the in-progress rollup field (integer). Lookup
Goal rollupqueryinprogressmoneyid Choose the query that will be used to calculate data for the in-progress rollup field (money). Lookup
Goal statecode Shows whether the goal is open, completed, or canceled. Completed and canceled goals are read-only and can’t be edited. State
Goal statuscode Select the goal’s status. Status
Goal stretchtargetdecimal Select a stretch target (decimal) of the goal to define a higher or difficult level of goal than the usual ones. Decimal
Goal stretchtargetinteger Select the stretch target (integer) of the goal to define a higher or difficult level of goal than the usual ones. Integer
Goal stretchtargetmoney Select stretch target (money) of the goal to define a higher or difficult level of goal than the usual ones. Money
Goal stretchtargetmoney_base Shows the stretch target (money) in base currency to indicate a higher or difficult level of goal than the usual ones. Money
Goal stretchtargetstring Stretch target value for all data types. String
Goal targetdecimal Select a goal target of the decimal type to use for tracking data that include partial numbers, such as pounds sold of a product sold by weight. Decimal
Goal targetinteger Select a goal target of the integer type to use for tracking anything countable in whole numbers, such as units sold. Integer
Goal targetmoney Select a goal target (money) to track a monetary amount such as revenue from a product. Money
Goal targetmoney_base Shows the goal target of the money type in base currency. Money
Goal targetstring Target value of the goal. String
Goal timezoneruleversionnumber For internal use only. Integer
Goal title Type a title or name that describes the goal. String
Goal transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Goal treeid Unique identifier of the goal tree. Uniqueidentifier
Goal utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Goal versionnumber Version number of the goal. BigInt
GoalRollupQuery createdby Shows who created the record. Lookup
GoalRollupQuery createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
GoalRollupQuery createdonbehalfby Shows who created the record on behalf of another user. Lookup
GoalRollupQuery fetchxml String that specifies the condition criteria in FetchXML. String
GoalRollupQuery goalrollupqueryid Unique identifier of the rollup query. Uniqueidentifier
GoalRollupQuery importsequencenumber Sequence number of the import that created this record. Integer
GoalRollupQuery modifiedby Shows who last updated the record. Lookup
GoalRollupQuery modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
GoalRollupQuery modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
GoalRollupQuery name Type a descriptive name for the goal rollup query. String
GoalRollupQuery overriddencreatedon Date and time that the record was migrated. DateTime
GoalRollupQuery ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
GoalRollupQuery owningbusinessunit Unique identifier of the business unit that owns the record. Lookup
GoalRollupQuery owningteam Unique identifier of the team who owns the record. Lookup
GoalRollupQuery owninguser Unique identifier of the user who owns the record. Lookup
GoalRollupQuery queryentitytype Enter the record type of the rollup query. EntityName
GoalRollupQuery statecode Shows whether the goal rollup query is active or inactive. State
GoalRollupQuery statuscode Select the goal rollup query’s status. Status
GoalRollupQuery timezoneruleversionnumber For internal use only. Integer
GoalRollupQuery utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
GoalRollupQuery versionnumber Version number of the goal rollup query. BigInt
HierarchyRule componentstate For internal use only. Picklist
HierarchyRule description Description of the hierarchy rule. Memo
HierarchyRule hierarchyruleid Unique identifier of the record type hierarchy rule. Uniqueidentifier
HierarchyRule hierarchyruleidunique Unique identifier of the hierarchy rule used when synchronizing customizations for the Microsoft Dynamics 365 client for Outlook Uniqueidentifier
HierarchyRule introducedversion Version in which the hierarchy rule is introduced. String
HierarchyRule iscustomizable Information that specifies whether this component can be customized. ManagedProperty
HierarchyRule ismanaged Boolean
HierarchyRule name Name of the hierarchy rule. String
HierarchyRule organizationid Unique identifier of the organization. Lookup
HierarchyRule overwritetime Date and time when the record was created. DateTime
HierarchyRule primaryentityformid Form Id for the Primary Entity Uniqueidentifier
HierarchyRule primaryentitylogicalname Logical Name for the Primary entity. String
HierarchyRule publishedon DateTime
HierarchyRule relatedentityformid Form Id for the Related Entity. Uniqueidentifier
HierarchyRule relatedentitylogicalname Logical Name for the Related entity. String
HierarchyRule showdisabled To show disabled records or not. Boolean
HierarchyRule solutionid Unique identifier of the associated solution. Uniqueidentifier
HierarchyRule sortby columns to sort in the primary entity Uniqueidentifier
HierarchyRule supportingsolutionid For internal use only. Uniqueidentifier
HierarchyRule versionnumber Version number of the Hierarchy rule. BigInt
HierarchySecurityConfiguration entityname Logical entity name of the entity that is configured for hierarchy security. String
HierarchySecurityConfiguration hierarchysecuritymodelingsettingid Shows the entity used for the Hierarchy Security Modeling Configuration. Uniqueidentifier
HierarchySecurityConfiguration objecttypecode For internal use only. EntityName
HierarchySecurityConfiguration versionnumber BigInt
ImageDescriptor filetype String
ImageDescriptor imagedata Virtual
ImageDescriptor imagedescriptorid Uniqueidentifier
ImageDescriptor imagetimestamp BigInt
ImageDescriptor imageurl String
ImageDescriptor objectid Uniqueidentifier
ImageDescriptor objecttypecode EntityName
ImageDescriptor size Integer
ImageDescriptor title String
Import createdby Shows who created the record. Lookup
Import createdon Shows the date and time when the import was initiated. DateTime
Import createdonbehalfby Shows who created the record on behalf of another user. Lookup
Import emailaddress Type the email address that the import completion notification must be sent to. String
Import importid Unique identifier of the import job. Uniqueidentifier
Import isimport Information about whether the source of this import job is data import or data migration. Boolean
Import modecode Select whether to create or update records in Microsoft Dynamics 365 during the import job. Picklist
Import modifiedby Shows who last updated the record. Lookup
Import modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Import modifiedonbehalfby Shows who created the record on behalf of another user. Lookup
Import name Shows the name of the import job, based on the import file and the entity being imported. String
Import ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
Import owningbusinessunit Business unit that owns the import job. Lookup
Import owningteam Unique identifier of the team who owns the import. Lookup
Import owninguser Unique identifier of the user who owns the import. Lookup
Import sendnotification Select whether to send a notification email message to a selected user after the import is completed. Boolean
Import sequence Order in which the import was created. Integer
Import statecode Shows the status of the import job. By default, import jobs are active and can’t be deactivated. State
Import statuscode Shows the reason code that explains the import job’s status to identify the job’s stage of the import processes, from transforming the data to completed. Status
ImportData createdby Unique identifier of the user who created the import data. Lookup
ImportData createdon Date and time when the import data was created. DateTime
ImportData createdonbehalfby Unique identifier of the delegate user who created the importdata. Lookup
ImportData data Data row of the import file. String
ImportData errortype Type of the import error. Picklist
ImportData haserror Information about whether this import data has an error. Boolean
ImportData importdataid Unique identifier of the import data. Uniqueidentifier
ImportData importfileid Unique identifier of the import file for this import data. Lookup
ImportData linenumber Original line number of the data present in the file. Integer
ImportData modifiedby Unique identifier of the user who last modified the import data. Lookup
ImportData modifiedon Date and time when the import data was last modified. DateTime
ImportData modifiedonbehalfby Unique identifier of the delegate user who last modified the importdata. Lookup
ImportData ownerid Unique identifier of the user or team who owns the import data. Owner
ImportData owningbusinessunit Business unit that owns the import data. Lookup
ImportData owningteam Unique identifier of the team who owns the import data. Lookup
ImportData owninguser Unique identifier of the user who owns the import data. Lookup
ImportData recordid Unique identifier of the record. Uniqueidentifier
ImportData statecode Status of the import data. State
ImportData statuscode Reason for the status of the import data. Status
ImportEntityMapping createdby Unique identifier of the user who created the import entity mapping. Lookup
ImportEntityMapping createdon Date and time when the import entity mapping was created. DateTime
ImportEntityMapping createdonbehalfby Unique identifier of the delegate user who created the importentitymapping. Lookup
ImportEntityMapping dedupe Information about whether the entity needs to be processed to find and delete duplicate records. Picklist
ImportEntityMapping importentitymappingid Unique identifier of the import entity mapping. Uniqueidentifier
ImportEntityMapping importmapid Unique identifier of the associated data map. Lookup
ImportEntityMapping modifiedby Unique identifier of the user who last modified the import entity mapping. Lookup
ImportEntityMapping modifiedon Date and time when the import entity mapping was last modified. DateTime
ImportEntityMapping modifiedonbehalfby Unique identifier of the delegate user who last modified the importentitymapping. Lookup
ImportEntityMapping processcode Information about whether the import entity mapping needs to be processed. Picklist
ImportEntityMapping sourceentityname Name of the source entity. String
ImportEntityMapping statecode Status of the import entity mapping. State
ImportEntityMapping statuscode Reason for the status of the import entity mapping. Status
ImportEntityMapping targetentityname Name of the Microsoft Dynamics 365 entity. String
ImportFile additionalheaderrow Shows the secondary column headers. The additional headers are used during the process of transforming the import file into import data records. String
ImportFile completedon Shows the date and time when the import associated with the import file was completed. DateTime
ImportFile content Stores the content of the import file, stored as comma-separated values. String
ImportFile createdby Shows who created the record. Lookup
ImportFile createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
ImportFile createdonbehalfby Shows who created the record on behalf of another user. Lookup
ImportFile datadelimitercode Select the single-character data delimiter used in the import file. This is typically a single or double quotation mark. Picklist
ImportFile enableduplicatedetection Select whether duplicate-detection rules should be run against the import job. Boolean
ImportFile failurecount Shows the number of records in the import file that cannot be imported. Integer
ImportFile fielddelimitercode Select the character that is used to separate each field in the import file. Typically, it is a comma. Picklist
ImportFile filetypecode Shows the type of source file that is uploaded for import. Picklist
ImportFile headerrow Shows a list of each column header in the import file separated by a comma. The header is used for parsing the file during the import job. String
ImportFile importfileid Unique identifier of the import file. Uniqueidentifier
ImportFile importid Choose the import job that the file was uploaded for. Lookup
ImportFile importmapid Choose a data map to match the import file and its column headers with the record types and fields in Microsoft Dynamics 365. If the column headers in the file match the display names of the target fields in Microsoft Dynamics 365, we import the data automatically. If not, you can manually define matches during import. Lookup
ImportFile isfirstrowheader Select whether the first row of the import file contains column headings, which are used for data mapping during the import job. Boolean
ImportFile modifiedby Shows who last updated the record. Lookup
ImportFile modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
ImportFile modifiedonbehalfby Shows who created the record on behalf of another user. Lookup
ImportFile name Shows the name of the import file. This name is based on the name of the uploaded file. String
ImportFile ownerid Enter the user who is assigned to follow up with or manage the import file. This field is updated every time the import file is assigned to a different user. Owner
ImportFile owningbusinessunit Shows the business unit that the record owner belongs to. Lookup
ImportFile owningteam Unique identifier of the team who owns the import file. Lookup
ImportFile owninguser Unique identifier of the user who owns the import file. Lookup
ImportFile parsedtablecolumnprefix Shows the prefix applied to each column after the import file is parsed. String
ImportFile parsedtablecolumnsnumber Shows the number of columns included in the parsed import file. Integer
ImportFile parsedtablename Shows the name of the table that contains the parsed data from the import file. String
ImportFile partialfailurecount Shows the number of records in this file that had failures during the import. Integer
ImportFile processcode Tells whether the import file should be ignored or processed during the import. Picklist
ImportFile processingstatus Shows the import file’s processing status code. This indicates whether the data in the import file has been parsed, transformed, or imported. Picklist
ImportFile progresscounter Shows the progress code for the processing of the import file. This field is used when a paused import job is resumed. Integer
ImportFile recordsownerid Choose the user that the records created during the import job should be assigned to. Lookup
ImportFile relatedentitycolumns Shows the columns that are mapped to a related record type (entity) of the primary record type (entity) included in the import file. String
ImportFile size Shows the size of the import file, in kilobytes. String
ImportFile source Shows the name of the data source file uploaded in the import job. String
ImportFile sourceentityname Shows the record type (entity) of the source data. String
ImportFile statecode Shows the status of the import file record. By default, all records are active and can’t be deactivated. State
ImportFile statuscode Shows the reason code that explains the import file’s status to identify the stage of the import process, from parsing the data to completed. Status
ImportFile successcount Shows the number of records in the import file that are imported successfully. Integer
ImportFile targetentityname Select the target record type (entity) for the records that will be created during the import job. String
ImportFile timezoneruleversionnumber For internal use only. Integer
ImportFile totalcount Shows the total number of records in the import file. Integer
ImportFile usesystemmap Tells whether an automatic system map was applied to the import file, which automatically maps the import data to the target entity in Microsoft Dynamics 365. Boolean
ImportFile utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
ImportJob completedon Date and time when the import job was completed. DateTime
ImportJob createdby Unique identifier of the user who created the importJob. Lookup
ImportJob createdon Date and time when the import job record was created. DateTime
ImportJob createdonbehalfby Unique identifier of the delegate user who created the import job record. Lookup
ImportJob data Unstructured data associated with the import job. String
ImportJob importjobid Unique identifier of the import job. Uniqueidentifier
ImportJob modifiedby Unique identifier of the user who modified the importJob. Lookup
ImportJob modifiedon Date and time when the import job was last modified. DateTime
ImportJob modifiedonbehalfby Unique identifier of the delegate user who modified the import job record. Lookup
ImportJob name Name of the import job. String
ImportJob organizationid Unique identifier of the organization associated with the importjob. Lookup
ImportJob progress Import Progress Percentage. Double
ImportJob solutionname Unique identifier of the solution. String
ImportJob startedon Date and time when the import job was started. DateTime
ImportJob timezoneruleversionnumber For internal use only. Integer
ImportJob utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
ImportLog additionalinfo Additional information related to the error. String
ImportLog columnvalue Value in the column. String
ImportLog createdby Unique identifier of the user who created the import log. Lookup
ImportLog createdon Date and time when the import log was created. DateTime
ImportLog createdonbehalfby Unique identifier of the delegate user who created the importlog. Lookup
ImportLog errordescription Description of an error. String
ImportLog errornumber Error code of an error. Integer
ImportLog headercolumn Name of the column heading. String
ImportLog importdataid Unique identifier of the import data for this import log. Lookup
ImportLog importfileid Unique identifier of the import file for this import log. Lookup
ImportLog importlogid Unique identifier of the import log. Uniqueidentifier
ImportLog linenumber Original line number of the data used in this log. Integer
ImportLog logphasecode Phase for which the log is recorded. Picklist
ImportLog modifiedby Unique identifier of the user who last modified the import log. Lookup
ImportLog modifiedon Date and time when the import log was last modified. DateTime
ImportLog modifiedonbehalfby Unique identifier of the delegate user who last modified the importlog. Lookup
ImportLog ownerid Unique identifier of the user or team who owns the import log. Owner
ImportLog owningbusinessunit Business unit that owns the import log. Lookup
ImportLog owningteam Unique identifier of the team who owns the import log. Lookup
ImportLog owninguser Unique identifier of the user who owns the import log. Lookup
ImportLog sequencenumber Sequence number of the error in this log. Integer
ImportLog statecode Status of the import log. State
ImportLog statuscode Reason for the status of the import log. Status
ImportMap createdby Shows who created the record. Lookup
ImportMap createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
ImportMap createdonbehalfby Shows who created the record on behalf of another user. Lookup
ImportMap description Type additional information to describe the data map, such as the intended use or data source. String
ImportMap entitiesperfile Choose whether a data file can contain data for one or more record types. Picklist
ImportMap importmapid Unique identifier of the data map. Uniqueidentifier
ImportMap importmaptype Select the type of data map to distinguish out-of-the-box data maps from custom maps. Picklist
ImportMap isvalidforimport Information about whether the data map is valid for use with data import. Boolean
ImportMap iswizardcreated Information about whether this data map was created by the Data Migration Manager. Boolean
ImportMap mapcustomizations Customizations XML String
ImportMap modifiedby Shows who last updated the record. Lookup
ImportMap modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
ImportMap modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
ImportMap name Type a descriptive name for the data map. String
ImportMap ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
ImportMap owningbusinessunit Business unit that owns the data map. Lookup
ImportMap owningteam Unique identifier of the team who owns the data map. Lookup
ImportMap owninguser Unique identifier of the user who owns the data map. Lookup
ImportMap source Type the name of the migration source that this data map is used for. String
ImportMap sourcetype Select the migration source type that this data map is used for. Picklist
ImportMap sourceuseridentifierforsourcecrmuserlink Source user value for source Microsoft Dynamics 365 user link. String
ImportMap sourceuseridentifierforsourcedatasourceuserlink Column in the source file that uniquely identifies a user. String
ImportMap statecode Shows whether the data map is active or inactive. Inactive data maps are read-only and can’t be edited. State
ImportMap statuscode Select the data map’s status. Status
ImportMap targetentity Select the name of the Microsoft Dynamics 365 record type that this data map is defined for. Picklist
ImportMap targetuseridentifierforsourcecrmuserlink Microsoft Dynamics 365 user. String
Incident accountid Unique identifier of the account with which the case is associated. Lookup
Incident activitiescomplete This attribute is used for Sample Service Business Processes. Boolean
Incident actualserviceunits Type the number of service units that were actually required to resolve the case. Integer
Incident billedserviceunits Type the number of service units that were billed to the customer for the case. Integer
Incident blockedprofile Details whether the profile is blocked or not. Boolean
Incident caseorigincode Select how contact about the case was originated, such as email, phone, or web, for use in reporting and analysis. Picklist
Incident casetypecode Select the type of case to identify the incident for use in case routing and analysis. Picklist
Incident checkemail This attribute is used for Sample Service Business Processes. Boolean
Incident contactid Unique identifier of the contact associated with the case. Lookup
Incident contractdetailid Choose the contract line that the case should be logged under to make sure the customer is charged correctly. Lookup
Incident contractid Choose the service contract that the case should be logged under to make sure the customer is eligible for support services. Lookup
Incident contractservicelevelcode Select the service level for the case to make sure the case is handled correctly. Picklist
Incident createdby Shows who created the record. Lookup
Incident createdbyexternalparty Shows the external party who created the record. Lookup
Incident createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Incident createdonbehalfby Shows who created the record on behalf of another user. Lookup
Incident customercontacted Tells whether customer service representative has contacted the customer or not. Boolean
Incident customerid Select the customer account or contact to provide a quick link to additional customer details, such as account information, activities, and opportunities. Customer
Incident customersatisfactioncode Select the customer’s level of satisfaction with the handling and resolution of the case. Picklist
Incident decremententitlementterm Shows whether terms of the associated entitlement should be decremented or not. Boolean
Incident description Type additional information to describe the case to assist the service team in reaching a resolution. Memo
Incident entitlementid Choose the entitlement that is applicable for the case. Lookup
Incident entityimageid For internal use only. Uniqueidentifier
Incident escalatedon Indicates the date and time when the case was escalated. DateTime
Incident exchangerate 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. Decimal
Incident existingcase Select an existing case for the customer that has been populated. For internal use only. Lookup
Incident firstresponsebykpiid For internal use only. Lookup
Incident firstresponsesent Indicates if the first response has been sent. Boolean
Incident firstresponseslastatus Shows the status of the initial response time for the case according to the terms of the SLA. Picklist
Incident followupby Enter the date by which a customer service representative has to follow up with the customer on this case. DateTime
Incident followuptaskcreated This attribute is used for Sample Service Business Processes. Boolean
Incident importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Incident incidentid Unique identifier of the case. Uniqueidentifier
Incident incidentstagecode Select the current stage of the service process for the case to assist service team members when they review or transfer a case. Picklist
Incident influencescore Will contain the Influencer score coming from NetBreeze. Double
Incident isdecrementing For system use only. Boolean
Incident isescalated Indicates if the case has been escalated. Boolean
Incident kbarticleid Choose the article that contains additional information or a resolution for the case, for reference during research or follow up with the customer. Lookup
Incident lastonholdtime Contains the date time stamp of the last on hold time. DateTime
Incident masterid Choose the primary case the current case was merged into. Lookup
Incident merged Tells whether the incident has been merged with another incident. Boolean
Incident messagetypecode Shows whether the post originated as a public or private message. Picklist
Incident modifiedby Shows who last updated the record. Lookup
Incident modifiedbyexternalparty Shows the external party who modified the record. Lookup
Incident modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Incident modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
Incident numberofchildincidents Number of child incidents associated with the incident. Integer
Incident onholdtime Shows the duration in minutes for which the case was on hold. Integer
Incident overriddencreatedon Date and time that the record was migrated. DateTime
Incident ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
Incident owningbusinessunit Unique identifier of the business unit that owns the case. Lookup
Incident owningteam Unique identifier of the team who owns the case. Lookup
Incident owninguser Unique identifier of the user who owns the case. Lookup
Incident parentcaseid Choose the parent case for a case. Lookup
Incident primarycontactid Select a primary contact for this case. Lookup
Incident prioritycode Select the priority so that preferred customers or critical issues are handled quickly. Picklist
Incident processid Shows the ID of the process. Uniqueidentifier
Incident productid Choose the product associated with the case to identify warranty, service, or other product issues and be able to report the number of incidents for each product. Lookup
Incident productserialnumber Type the serial number of the product that is associated with this case, so that the number of cases per product can be reported. String
Incident resolveby Enter the date by when the case must be resolved. DateTime
Incident resolvebykpiid For internal use only. Lookup
Incident resolvebyslastatus Shows the status of the resolution time for the case according to the terms of the SLA. Picklist
Incident responseby For internal use only. DateTime
Incident responsiblecontactid Choose an additional customer contact who can also help resolve the case. Lookup
Incident routecase Tells whether the incident has been routed to queue or not. Boolean
Incident sentimentvalue Value derived after assessing words commonly associated with a negative, neutral, or positive sentiment that occurs in a social post. Sentiment information can also be reported as numeric values. Double
Incident servicestage Select the stage, in the case resolution process, that the case is in. Picklist
Incident severitycode Select the severity of this case to indicate the incident’s impact on the customer’s business. Picklist
Incident slaid Choose the service level agreement (SLA) that you want to apply to the case record. Lookup
Incident slainvokedid Last SLA that was applied to this case. This field is for internal use only. Lookup
Incident socialprofileid Unique identifier of the social profile with which the case is associated. Lookup
Incident stageid Shows the ID of the stage. Uniqueidentifier
Incident statecode Shows whether the case is active, resolved, or canceled. Resolved and canceled cases are read-only and can’t be edited unless they are reactivated. State
Incident statuscode Select the case’s status. Status
Incident subjectid Choose the subject for the case, such as catalog request or product complaint, so customer service managers can identify frequent requests or problem areas. Administrators can configure subjects under Business Management in the Settings area. Lookup
Incident ticketnumber Shows the case number for customer reference and searching capabilities. This cannot be modified. String
Incident timezoneruleversionnumber For internal use only. Integer
Incident title Type a subject or descriptive name, such as the request, issue, or company name, to identify the case in Microsoft Dynamics 365 views. String
Incident transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Incident traversedpath For internal use only. String
Incident utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Incident versionnumber Version number of the case. BigInt
IncidentKnowledgeBaseRecord incidentid Uniqueidentifier
IncidentKnowledgeBaseRecord incidentknowledgebaserecordid Unique identifier of the knowledgebase records for the incident. Uniqueidentifier
IncidentKnowledgeBaseRecord knowledgebaserecordid Uniqueidentifier
IncidentKnowledgeBaseRecord versionnumber BigInt
IncidentResolution activityid Unique identifier of the case resolution activity. Uniqueidentifier
IncidentResolution activitytypecode Type of activity. EntityName
IncidentResolution actualdurationminutes Actual duration of the case resolution activity in minutes. Integer
IncidentResolution actualend Actual end time of the case resolution activity. DateTime
IncidentResolution actualstart Actual start time of the case resolution activity. DateTime
IncidentResolution category Category for the case resolution activity. String
IncidentResolution createdby Unique identifier of the user who created the case resolution activity. Lookup
IncidentResolution createdbyexternalparty Shows the external party who created the record. Lookup
IncidentResolution createdon Date and time when the case resolution activity was created. DateTime
IncidentResolution createdonbehalfby Unique identifier of the delegate user who created the incidentresolution. Lookup
IncidentResolution description Type additional information that describes the case resolution. Memo
IncidentResolution importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
IncidentResolution incidentid Unique identifier of the case. Lookup
IncidentResolution isbilled Information about whether the case resolution activity was billed as part of resolving a case. Boolean
IncidentResolution isregularactivity Information regarding whether the activity is a regular activity type or event type. Boolean
IncidentResolution isworkflowcreated Information that specifies if the case resolution activity was created from a workflow rule. Boolean
IncidentResolution modifiedby Unique identifier of the user who last modified the case resolution activity. Lookup
IncidentResolution modifiedbyexternalparty Shows the external party who modified the record. Lookup
IncidentResolution modifiedon Date and time when the case resolution activity was last modified. DateTime
IncidentResolution modifiedonbehalfby Unique identifier of the delegate user who last modified the incidentresolution. Lookup
IncidentResolution overriddencreatedon Date and time that the record was migrated. DateTime
IncidentResolution ownerid Unique identifier of the user or team who owns the case resolution activity. Owner
IncidentResolution owningbusinessunit Unique identifier of the business unit that owns the case resolution activity. Lookup
IncidentResolution owningteam Unique identifier of the team who owns the case resolution. Lookup
IncidentResolution owninguser Unique identifier of the user who owns the case resolution. Lookup
IncidentResolution scheduleddurationminutes Scheduled duration of the case resolution activity, specified in minutes. Integer
IncidentResolution scheduledend Scheduled end time of the case resolution activity. DateTime
IncidentResolution scheduledstart Scheduled start time of the case resolution activity. DateTime
IncidentResolution serviceid Unique identifier of the service with which the case resolution activity is associated. Lookup
IncidentResolution statecode Shows whether the case resolution is open, completed, or canceled. By default, all case resolutions are completed and the status value can’t be changed. State
IncidentResolution statuscode Reason for the status of the case resolution activity. Status
IncidentResolution subcategory Subcategory of the case resolution activity. String
IncidentResolution subject Subject associated with the case resolution activity. String
IncidentResolution timespent Time spent on the case resolution activity. Integer
IncidentResolution timezoneruleversionnumber For internal use only. Integer
IncidentResolution utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
IncidentResolution versionnumber Version number of the case. BigInt
IntegrationStatus createdby Unique identifier of the user who created the integration status. Lookup
IntegrationStatus createdon Date and time when the integration status was created. DateTime
IntegrationStatus createdonbehalfby Unique identifier of the delegate user who created the integrationstatus. Lookup
IntegrationStatus integrationentryid For internal use only. Uniqueidentifier
IntegrationStatus modifiedby Unique identifier of the user who last modified the integration status. Lookup
IntegrationStatus modifiedon Date and time when the integration status was last modified. DateTime
IntegrationStatus modifiedonbehalfby Unique identifier of the delegate user who last modified the integrationstatus. Lookup
IntegrationStatus objectid For internal use only. Uniqueidentifier
IntegrationStatus objecttypecode Type of entity with which the integration status is associated. EntityName
IntegrationStatus organizationid Unique identifier of the organization associated with the integration status. Uniqueidentifier
IntegrationStatus statecode Status of the integration. State
IntegrationStatus statedescription For internal use only. Memo
IntegrationStatus statuscode Reason for the status of the integration. Status
IntegrationStatus statusdescription For internal use only. Memo
IntegrationStatus systemname For internal use only. String
IntegrationStatus versionnumber BigInt
InteractionForEmail createdby Unique identifier of the user who created the record. Lookup
InteractionForEmail createdon Date and time when the record was created. DateTime
InteractionForEmail createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
InteractionForEmail emailactivityid Email Activity Id. Uniqueidentifier
InteractionForEmail emailinteractionreplyid Email Activity Id. Uniqueidentifier
InteractionForEmail emailinteractiontime Shows the Interaction date and time of the an email. DateTime
InteractionForEmail exchangerate Exchange rate for the currency associated with the InteractionForEmail with respect to the base currency. Decimal
InteractionForEmail importsequencenumber Sequence number of the import that created this record. Integer
InteractionForEmail interactedcomponenttext For internal use only. String
InteractionForEmail interactionforemailid Unique identifier for entity instances Uniqueidentifier
InteractionForEmail interactionlocation Shows the location for an Interaction String
InteractionForEmail interactionrepliedby Shows the Name who replied to email if interaction is reply String
InteractionForEmail interactionreplyid InteractionReplyId String
InteractionForEmail interactiontype Shows the type of Interaction. Picklist
InteractionForEmail interactionuseragent Shows the User Agent for an Interaction if available String
InteractionForEmail modifiedby Unique identifier of the user who modified the record. Lookup
InteractionForEmail modifiedon Date and time when the record was modified. DateTime
InteractionForEmail modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
InteractionForEmail name The name of the custom entity. String
InteractionForEmail overriddencreatedon Date and time that the record was migrated. DateTime
InteractionForEmail ownerid Unique identifier of the user or team who owns the record. Owner
InteractionForEmail owningbusinessunit Unique identifier for the business unit that owns the record Lookup
InteractionForEmail owningteam Unique identifier for the team that owns the record. Lookup
InteractionForEmail owninguser Unique identifier for the user that owns the record. Lookup
InteractionForEmail statecode Status of the Interaction for Email State
InteractionForEmail statuscode Reason for the status of the Interaction for Email Status
InteractionForEmail timezoneruleversionnumber For internal use only. Integer
InteractionForEmail transactioncurrencyid Exchange rate for the currency associated with the InteractionForEmail with respect to the base currency. Lookup
InteractionForEmail utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
InteractionForEmail versionnumber BigInt
InternalAddress addressnumber Information about which internal address is applicable. Integer
InternalAddress addresstypecode Type of address for the internal address. Picklist
InternalAddress businessunitid Uniqueidentifier
InternalAddress city City name in the internal address. String
InternalAddress composite Shows the complete address. Memo
InternalAddress country Country/region name in the internal address. String
InternalAddress county County name in the internal address. String
InternalAddress createdby Unique identifier of the user who created the internal address record. Lookup
InternalAddress createdon Date and time when the internal address was created. DateTime
InternalAddress createdonbehalfby Unique identifier of the delegate user who created the internal address. Lookup
InternalAddress fax Fax number for the internal address. String
InternalAddress internaladdressid Unique identifier of the internal address. Uniqueidentifier
InternalAddress latitude Latitude for the internal address. Double
InternalAddress line1 First line for entering address information. String
InternalAddress line2 Second line for entering address information. String
InternalAddress line3 Third line for entering address information. String
InternalAddress longitude Longitude for the internal address. Double
InternalAddress modifiedby Unique identifier of the user who last modified the internal address. Lookup
InternalAddress modifiedon Date and time when the internal address record was last modified. DateTime
InternalAddress modifiedonbehalfby Unique identifier of the delegate user who last modified the internaladdress. Lookup
InternalAddress name Name used to identify the internal address. String
InternalAddress objecttypecode Type of entity with which the internal address is associated. EntityName
InternalAddress organizationid Uniqueidentifier
InternalAddress parentid Unique identifier of the parent object with which the internal address is associated. Uniqueidentifier
InternalAddress postalcode ZIP Code or postal code in the internal address. String
InternalAddress postofficebox Post office box number in the internal address. String
InternalAddress shippingmethodcode Method of shipment for the internal address. Picklist
InternalAddress stateorprovince State or province in the internal address. String
InternalAddress telephone1 First telephone number for the internal address. String
InternalAddress telephone2 Second telephone number for an internal address. String
InternalAddress telephone3 Third telephone number for an internal address. String
InternalAddress upszone United Parcel Service (UPS) zone for the internal address. String
InternalAddress utcoffset UTC offset for the internal address. The difference between local time and standard Coordinated Universal Time. Integer
InternalAddress versionnumber Version number of the internal address. BigInt
InterProcessLock interprocesslockid Unique identifier of the Inter Process Lock record. Uniqueidentifier
InterProcessLock modifiedon Date and time when the record was last modified. DateTime
InterProcessLock token Lock token. Uniqueidentifier
InvalidDependency existingcomponentid Unique identifier of the object that has an invalid dependency Uniqueidentifier
InvalidDependency existingcomponenttype Component type of the object that has an invalid dependency Picklist
InvalidDependency existingdependencytype The dependency type of the invalid dependency. Picklist
InvalidDependency invaliddependencyid Unique identifier of the invalid dependency. Uniqueidentifier
InvalidDependency isexistingnoderequiredcomponent Indicates whether the existing node is the required component in the dependency Boolean
InvalidDependency missingcomponentid Unique identifier of the missing component. Uniqueidentifier
InvalidDependency missingcomponentinfo String
InvalidDependency missingcomponentlookuptype The lookup type of the missing component. Integer
InvalidDependency missingcomponenttype The object type code of the missing component. Picklist
Invoice accountid Unique identifier of the account with which the invoice is associated. Lookup
Invoice billto_city Type the city for the customer’s billing address. String
Invoice billto_composite Shows the complete Bill To address. Memo
Invoice billto_country Type the country or region for the customer’s billing address. String
Invoice billto_fax Type the fax number for the customer’s billing address. String
Invoice billto_line1 Type the first line of the customer’s billing address. String
Invoice billto_line2 Type the second line of the customer’s billing address. String
Invoice billto_line3 Type the third line of the billing address. String
Invoice billto_name Type a name for the customer’s billing address, such as “Headquarters” or “Field office”, to identify the address. String
Invoice billto_postalcode Type the ZIP Code or postal code for the billing address. String
Invoice billto_stateorprovince Type the state or province for the billing address. String
Invoice billto_telephone Type the phone number for the customer’s billing address. String
Invoice contactid Unique identifier of the contact associated with the invoice. Lookup
Invoice createdby Shows who created the record. Lookup
Invoice createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Invoice createdonbehalfby Shows who created the record on behalf of another user. Lookup
Invoice customerid Select the customer account or contact to provide a quick link to additional customer details, such as account information, activities, and opportunities. Customer
Invoice datedelivered Enter the date when the products included in the invoice were delivered. DateTime
Invoice description Type additional information to describe the invoice, such as shipping details or product substitutions. Memo
Invoice discountamount Type the discount amount for the invoice if the customer is eligible for special savings. Money
Invoice discountamount_base Shows the Invoice Discount field converted to the system’s default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Money
Invoice discountpercentage Type the discount rate that should be applied to the Detail Amount field, for use in calculating the Pre-Freight Amount and Total Amount values for the invoice. Decimal
Invoice duedate Enter the date by which the invoice should be paid by the customer. DateTime
Invoice entityimageid For internal use only. Uniqueidentifier
Invoice exchangerate 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. Decimal
Invoice freightamount Type the cost of freight or shipping for the products included in the invoice for use in calculating the total amount due. Money
Invoice freightamount_base Shows the Freight Amount field converted to the system’s default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Money
Invoice importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
Invoice invoiceid Unique identifier of the invoice. Uniqueidentifier
Invoice invoicenumber Shows the identifying number or code of the invoice. String
Invoice ispricelocked Select whether prices specified on the invoice are locked from any further updates. Boolean
Invoice lastbackofficesubmit Enter the date and time when the invoice was last submitted to an accounting or ERP system for processing. DateTime
Invoice lastonholdtime Contains the date time stamp of the last on hold time. DateTime
Invoice modifiedby Shows who last updated the record. Lookup
Invoice modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
Invoice modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
Invoice name Type a descriptive name for the invoice. String
Invoice onholdtime Shows the duration in minutes for which the invoice was on hold. Integer
Invoice opportunityid Choose the opportunity that the invoice is related to for reporting and analytics. Lookup
Invoice overriddencreatedon Date and time that the record was migrated. DateTime
Invoice ownerid Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. Owner
Invoice owningbusinessunit Unique identifier of the business unit that owns the invoice. Lookup
Invoice owningteam Unique identifier of the team who owns the invoice. Lookup
Invoice owninguser Unique identifier of the user who owns the invoice. Lookup
Invoice paymenttermscode Select the payment terms to indicate when the customer needs to pay the total amount. Picklist
Invoice pricelevelid Choose the price list associated with this record to make sure the products associated with the campaign are offered at the correct prices. Lookup
Invoice pricingerrorcode Type of pricing error for the invoice. Picklist
Invoice prioritycode Select the priority so that preferred customers or critical issues are handled quickly. Picklist
Invoice processid Shows the ID of the process. Uniqueidentifier
Invoice salesorderid Choose the order related to the invoice to make sure the order is fulfilled and invoiced correctly. Lookup
Invoice shippingmethodcode Select a shipping method for deliveries sent to this address. Picklist
Invoice shipto_city Type the city for the customer’s shipping address. String
Invoice shipto_composite Shows the complete Ship To address. Memo
Invoice shipto_country Type the country or region for the customer’s shipping address. String
Invoice shipto_fax Type the fax number for the customer’s shipping address. String
Invoice shipto_freighttermscode Select the freight terms to make sure shipping orders are processed correctly. Picklist
Invoice shipto_line1 Type the first line of the customer’s shipping address. String
Invoice shipto_line2 Type the second line of the customer’s shipping address. String
Invoice shipto_line3 Type the third line of the shipping address. String
Invoice shipto_name Type a name for the customer’s shipping address, such as “Headquarters” or “Field office”, to identify the address. String
Invoice shipto_postalcode Type the ZIP Code or postal code for the shipping address. String
Invoice shipto_stateorprovince Type the state or province for the shipping address. String
Invoice shipto_telephone Type the phone number for the customer’s shipping address. String
Invoice slaid Choose the service level agreement (SLA) that you want to apply to the invoice record. Lookup
Invoice slainvokedid Last SLA that was applied to this invoice. This field is for internal use only. Lookup
Invoice stageid Shows the ID of the stage. Uniqueidentifier
Invoice statecode Shows whether the invoice is active, paid, or canceled. Paid and canceled invoices are read-only and can’t be edited unless they are reactivated. State
Invoice statuscode Select the invoice’s status. Status
Invoice timezoneruleversionnumber For internal use only. Integer
Invoice totalamount Shows the total amount due, calculated as the sum of the products, discount, freight, and taxes for the invoice. Money
Invoice totalamount_base Shows the Total Amount field converted to the system’s default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Money
Invoice totalamountlessfreight Shows the total product amount due, minus any discounts. This value is added to freight and tax amounts in the calculation for the total amount due for the invoice. Money
Invoice totalamountlessfreight_base Shows the Pre-Freight Amount field converted to the system’s default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Money
Invoice totaldiscountamount Shows the total discount amount, based on the discount price and rate entered on the invoice. Money
Invoice totaldiscountamount_base Shows the Total Discount Amount field converted to the system’s default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Money
Invoice totallineitemamount Shows the sum of all existing and write-in products included on the invoice, based on the specified price list and quantities. Money
Invoice totallineitemamount_base Shows the Detail Amount field converted to the system’s default base currency. The calculation uses the exchange rate specified in the Currencies area. Money
Invoice totallineitemdiscountamount Shows the Manual Discount amounts specified on all products included in the invoice. This value is reflected in the Detail Amount field on the invoice and is added to any discount amount or rate specified on the invoice. Money
Invoice totallineitemdiscountamount_base Shows the total of the Manual Discount amounts specified on all products included in the invoice. This value is reflected in the Detail Amount field on the invoice and is added to any discount amount or rate specified on the invoice. Money
Invoice totaltax Shows the total of the Tax amounts specified on all products included in the invoice, included in the Total Amount due calculation for the invoice. Money
Invoice totaltax_base Shows the Total Tax field converted to the system’s default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Money
Invoice transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
Invoice traversedpath For internal use only. String
Invoice utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
Invoice versionnumber Version number of the invoice. BigInt
Invoice willcall Select whether the products included in the invoice should be shipped to the specified address or held until the customer calls with further pick up or delivery instructions. Boolean
InvoiceDetail actualdeliveryon Enter the date when the invoiced product was delivered to the customer. DateTime
InvoiceDetail baseamount Shows the total price of the invoice product, based on the price per unit, volume discount, and quantity. Money
InvoiceDetail baseamount_base Shows the Amount field converted to the system’s default base currency. The calculation uses the exchange rate specified in the Currencies area. Money
InvoiceDetail createdby Shows who created the record. Lookup
InvoiceDetail createdon Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
InvoiceDetail createdonbehalfby Shows who created the record on behalf of another user. Lookup
InvoiceDetail description Type additional information to describe the product line item of the invoice. Memo
InvoiceDetail exchangerate 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. Decimal
InvoiceDetail extendedamount Shows the total amount due for the invoice product, based on the sum of the unit price, quantity, discounts, and tax. Money
InvoiceDetail extendedamount_base Shows the Extended Amount field converted to the system’s default base currency. The calculation uses the exchange rate specified in the Currencies area. Money
InvoiceDetail importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
InvoiceDetail invoicedetailid Unique identifier of the invoice product line item. Uniqueidentifier
InvoiceDetail invoiceid Unique identifier of the invoice associated with the invoice product line item. Lookup
InvoiceDetail invoiceispricelocked Information about whether invoice product pricing is locked. Boolean
InvoiceDetail invoicestatecode Status of the invoice product. Picklist
InvoiceDetail iscopied Select whether the invoice product is copied from another item or data source. Boolean
InvoiceDetail ispriceoverridden 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 invoice product. Boolean
InvoiceDetail isproductoverridden Select whether the product exists in the Microsoft Dynamics 365 product catalog or is a write-in product specific to the parent invoice. Boolean
InvoiceDetail lineitemnumber Type the line item number for the invoice product to easily identify the product in the invoice and make sure it’s listed in the correct order. Integer
InvoiceDetail manualdiscountamount Type the manual discount amount for the invoice product to deduct any negotiated or other savings from the product total. Money
InvoiceDetail manualdiscountamount_base Shows the Manual Discount field converted to the system’s default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Money
InvoiceDetail modifiedby Shows who last updated the record. Lookup
InvoiceDetail modifiedon Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. DateTime
InvoiceDetail modifiedonbehalfby Shows who last updated the record on behalf of another user. Lookup
InvoiceDetail overriddencreatedon Date and time that the record was migrated. DateTime
InvoiceDetail ownerid Unique identifier of the user or team who owns the invoice detail. Owner
InvoiceDetail owningbusinessunit Unique identifier of the business unit that owns the invoice product line item. Uniqueidentifier
InvoiceDetail owninguser Unique identifier of the user who owns the invoice product line item. Uniqueidentifier
InvoiceDetail parentbundleid Choose the parent bundle associated with this product Uniqueidentifier
InvoiceDetail priceperunit Type the price per unit of the invoice product. The default is the value in the price list specified on the parent invoice for existing products. Money
InvoiceDetail priceperunit_base Shows the Price Per Unit field converted to the system’s default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Money
InvoiceDetail pricingerrorcode Pricing error for the invoice product line item. Picklist
InvoiceDetail productassociationid Unique identifier of the product line item association with bundle in the invoice Uniqueidentifier
InvoiceDetail productdescription Type a name or description to identify the type of write-in product included in the invoice. String
InvoiceDetail productid Choose the product to include on the invoice. Lookup
InvoiceDetail producttypecode Product Type Picklist
InvoiceDetail propertyconfigurationstatus Status of the property configuration. Picklist
InvoiceDetail quantity Type the amount or quantity of the product included in the invoice’s total amount due. Decimal
InvoiceDetail quantitybackordered Type the amount or quantity of the product that is back ordered for the invoice. Decimal
InvoiceDetail quantitycancelled Type the amount or quantity of the product that was canceled for the invoice line item. Decimal
InvoiceDetail quantityshipped Type the amount or quantity of the product that was shipped. Decimal
InvoiceDetail salesrepid Choose the user responsible for the sale of the invoice product. Lookup
InvoiceDetail sequencenumber Shows the ID of the data that maintains the sequence. Integer
InvoiceDetail shippingtrackingnumber Type a tracking number for shipment of the invoiced product. String
InvoiceDetail shipto_city Type the city for the customer’s shipping address. String
InvoiceDetail shipto_country Type the country or region for the customer’s shipping address. String
InvoiceDetail shipto_fax Type the fax number for the customer’s shipping address. String
InvoiceDetail shipto_freighttermscode Select the freight terms to make sure shipping orders are processed correctly. Picklist
InvoiceDetail shipto_line1 Type the first line of the customer’s shipping address. String
InvoiceDetail shipto_line2 Type the second line of the customer’s shipping address. String
InvoiceDetail shipto_line3 Type the third line of the shipping address. String
InvoiceDetail shipto_name Type a name for the customer’s shipping address, such as “Headquarters” or “Field office”, to identify the address. String
InvoiceDetail shipto_postalcode Type the ZIP Code or postal code for the shipping address. String
InvoiceDetail shipto_stateorprovince Type the state or province for the shipping address. String
InvoiceDetail shipto_telephone Type the phone number for the customer’s shipping address. String
InvoiceDetail tax Type the tax amount for the invoice product. Money
InvoiceDetail tax_base Shows the Tax field converted to the system’s default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Money
InvoiceDetail timezoneruleversionnumber For internal use only. Integer
InvoiceDetail transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
InvoiceDetail uomid Choose the unit of measurement for the base unit quantity for this purchase, such as each or dozen. Lookup
InvoiceDetail utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
InvoiceDetail versionnumber Version number of the invoice product line item. BigInt
InvoiceDetail volumediscountamount Shows the discount amount per unit if a specified volume is purchased. Configure volume discounts in the Product Catalog in the Settings area. Money
InvoiceDetail volumediscountamount_base Shows the Volume Discount field converted to the system’s default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area. Money
InvoiceDetail willcall Select whether the invoice product should be shipped to the specified address or held until the customer calls with further pick up or delivery instructions. Boolean
IsvConfig configxml Structured XML data representing the customizations. String
IsvConfig createdby Unique identifier of the user who created the ISV configuration. Lookup
IsvConfig createdon Date and time when the ISV configuration was created. DateTime
IsvConfig createdonbehalfby Unique identifier of the delegate user who created the isvconfig. Lookup
IsvConfig isvconfigid Unique identifier of the ISV configuration. Uniqueidentifier
IsvConfig modifiedby Unique identifier of the user who last modified the ISV configuration. Lookup
IsvConfig modifiedon Date and time when the ISV configuration was last modified. DateTime
IsvConfig modifiedonbehalfby Unique identifier of the delegate user who last modified the isvconfig. Lookup
IsvConfig organizationid Unique identifier of the organization associated with the ISV configuration XML. Uniqueidentifier
IsvConfig versionnumber BigInt
KbArticle articlexml Shows the article content and formatting, stored as XML. Memo
KbArticle comments Comments regarding the knowledge base article. Memo
KbArticle content Description of the content of the knowledge base article. Memo
KbArticle createdby Unique identifier of the user who created the knowledge base article. Lookup
KbArticle createdon Date and time when the knowledge base article was created. DateTime
KbArticle createdonbehalfby Unique identifier of the delegate user who created the article. Lookup
KbArticle description Type additional information that describes the knowledge base article. Memo
KbArticle entityimageid For internal use only. Uniqueidentifier
KbArticle exchangerate 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. Decimal
KbArticle importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
KbArticle kbarticleid Shows the ID of the article. Uniqueidentifier
KbArticle kbarticletemplateid Choose the template that you want to use as a base for creating the new article. Lookup
KbArticle keywords Keywords to be used for searches in knowledge base articles. Memo
KbArticle languagecode Select which language the article must be available in. This list is based on the list of language packs that are installed in your Microsoft Dynamics 365 environment. Integer
KbArticle modifiedby Unique identifier of the user who last modified the knowledge base article. Lookup
KbArticle modifiedon Date and time when the knowledge base article was last modified. DateTime
KbArticle modifiedonbehalfby Unique identifier of the delegate user who last modified the kbarticle. Lookup
KbArticle number Knowledge base article number. String
KbArticle organizationid Unique identifier of the organization associated with the article. Lookup
KbArticle overriddencreatedon Date and time that the record was migrated. DateTime
KbArticle statecode Shows whether the knowledge base article is in draft, unapproved, or published status. Published articles are read-only and can’t be edited unless they are unpublished. State
KbArticle statuscode Select the article’s status. Status
KbArticle subjectid Choose the subject of the article to assist with article searches. You can configure subjects under Business Management in the Settings area. Lookup
KbArticle title Type a subject or descriptive name for the article to assist with article searches. String
KbArticle transactioncurrencyid Choose the local currency for the record to make sure budgets are reported in the correct currency. Lookup
KbArticle versionnumber Title of the knowledge base article. BigInt
KbArticleComment commenttext Comment text for the knowledge base article. Memo
KbArticleComment createdby Unique identifier of the user who created the knowledge base article comment. Lookup
KbArticleComment createdon Date and time when the knowledge base article comment was created. DateTime
KbArticleComment createdonbehalfby Unique identifier of the delegate user who created the kbarticlecomment. Lookup
KbArticleComment kbarticlecommentid Unique identifier of the knowledge base article comment. Uniqueidentifier
KbArticleComment kbarticleid Unique identifier of the knowledge base article to which the comment applies. Lookup
KbArticleComment modifiedby Unique identifier of the user who last modified the knowledge base article comment. Lookup
KbArticleComment modifiedon Date and time when the knowledge base article comment was last modified. DateTime
KbArticleComment modifiedonbehalfby Unique identifier of the delegate user who last modified the kbarticlecomment. Lookup
KbArticleComment organizationid Unique identifier of the organization with which the article comment is associated. Uniqueidentifier
KbArticleComment title Title of the knowledge base article comment. String
KbArticleComment versionnumber BigInt
KbArticleTemplate componentstate For internal use only. Picklist
KbArticleTemplate createdby Unique identifier of the user who created the knowledge base article template. Lookup
KbArticleTemplate createdon Date and time when the knowledge base article template was created. DateTime
KbArticleTemplate createdonbehalfby Unique identifier of the delegate user who created the kbarticletemplate. Lookup
KbArticleTemplate description Description of the knowledge base article template. Memo
KbArticleTemplate formatxml XML format of the knowledge base article template. Memo
KbArticleTemplate importsequencenumber Unique identifier of the data import or data migration that created this record. Integer
KbArticleTemplate introducedversion Version in which the form is introduced. String
KbArticleTemplate isactive Information about whether the knowledge base article is active. Boolean
KbArticleTemplate iscustomizable Information that specifies whether this component can be customized. ManagedProperty
KbArticleTemplate ismanaged Boolean
KbArticleTemplate kbarticletemplateid Unique identifier of the knowledge base article template. Uniqueidentifier
KbArticleTemplate kbarticletemplateidunique For internal use only. Uniqueidentifier
KbArticleTemplate languagecode Language of the Article Template Integer
KbArticleTemplate modifiedby Unique identifier of the user who last modified the knowledge base article template. Lookup
KbArticleTemplate modifiedon Date and time when the knowledge base article template was last modified. DateTime
KbArticleTemplate modifiedonbehalfby Unique identifier of the delegate user who last modified the kbarticletemplate. Lookup
KbArticleTemplate organizationid Unique identifier of the organization associated with the template. Lookup
KbArticleTemplate overriddencreatedon Date and time that the record was migrated. DateTime
KbArticleTemplate overwritetime For internal use only. DateTime
KbArticleTemplate solutionid Unique identifier of the associated solution. Uniqueidentifier
KbArticleTemplate structurexml XML structure of the knowledge base article. Memo
KbArticleTemplate supportingsolutionid For internal use only. Uniqueidentifier
KbArticleTemplate title Title of the knowledge base article template. String
KbArticleTemplate versionnumber BigInt
KnowledgeArticle articlepublicnumber Shows the automatically generated ID exposed to customers, partners, and other external users to reference and look up articles. String
KnowledgeArticle content Shows the body of the article stored in HTML format. Memo
KnowledgeArticle createdby Unique identifier of the user who created the record. Lookup
KnowledgeArticle createdon Date and time when the record was created. DateTime
KnowledgeArticle createdonbehalfby Unique identifier of the delegate user who created the record. Lookup
KnowledgeArticle description A short overview of the article, primarily used in search results and for search engine optimization. String
KnowledgeArticle exchangerate Exchange rate for the currency associated with the KnowledgeArticle with respect to the base currency. Decimal
KnowledgeArticle expirationdate Enter an expiration date for the article. Leave this field blank for no expiration date. DateTime
KnowledgeArticle expirationstateid Contains the id of the expiration state of the entity. Integer
KnowledgeArticle expirationstatusid Contains the id of the expiration status of the entity. Integer
KnowledgeArticle expiredreviewoptions Expired Review Options Picklist
KnowledgeArticle importsequencenumber Sequence number of the import that created this record. Integer
KnowledgeArticle isinternal Shows whether this article is only visible internally. Boolean
KnowledgeArticle islatestversion Shows which version of the knowledge article is the latest version. Boolean
KnowledgeArticle isprimary Select whether the article is the primary article. Boolean
KnowledgeArticle isrootarticle Select whether the article is the root article. Boolean
KnowledgeArticle keywords Type keywords to be used for searches in knowledge base articles. Separate keywords by using commas. Memo
KnowledgeArticle knowledgearticleid Unique identifier for entity instances Uniqueidentifier
KnowledgeArticle knowledgearticleviews Shows the total number of article views. Integer
KnowledgeArticle knowledgearticleviews_date The date time for Knowledge Article View. DateTime
KnowledgeArticle knowledgearticleviews_state State of Knowledge Article View. Integer
KnowledgeArticle languagelocaleid Select the language that the article’s content is in. Lookup
KnowledgeArticle majorversionnumber Shows the major version number of this article’s content. Integer
KnowledgeArticle minorversionnumber Shows the minor version number of this article’s content. Integer
KnowledgeArticle modifiedby Unique identifier of the user who modified the record. Lookup
KnowledgeArticle modifiedon Date and time when the record was modified. DateTime
KnowledgeArticle modifiedonbehalfby Unique identifier of the delegate user who modified the record. Lookup
KnowledgeArticle overriddencreatedon Date and time that the record was migrated. DateTime
KnowledgeArticle ownerid Unique identifier of the user or team who owns the record. Owner
KnowledgeArticle owningbusinessunit Unique identifier for the business unit that owns the record Lookup
KnowledgeArticle owningteam Unique identifier for the team that owns the record. Lookup
KnowledgeArticle owninguser Unique identifier for the user that owns the record. Lookup
KnowledgeArticle parentarticlecontentid Contains the id of the parent article content associated with the entity. Lookup
KnowledgeArticle previousarticlecontentid Shows the version that the current article was restored from. Lookup
KnowledgeArticle primaryauthorid Contains the id of the primary author associated with the article. Lookup
KnowledgeArticle processid Contains the id of the process associated with the entity. Uniqueidentifier
KnowledgeArticle publishon Date and time when the record was published. DateTime
KnowledgeArticle publishstatusid Publish Status of the Article. Integer
KnowledgeArticle rating Information which specifies how helpful the related record was. Decimal
KnowledgeArticle rating_count Rating Count Integer
KnowledgeArticle rating_date The date time for Rating. DateTime
KnowledgeArticle rating_state State of Rating Integer
KnowledgeArticle rating_sum Total sum of Rating Decimal
KnowledgeArticle readyforreview Ready For Review Boolean
KnowledgeArticle review Review Picklist
KnowledgeArticle rootarticleid Contains the id of the root article. Lookup
KnowledgeArticle scheduledstatusid Contains the id of the scheduled status of the entity. Integer
KnowledgeArticle setcategoryassociations Shows whether category associations have been set Boolean
KnowledgeArticle setproductassociations Set Product Associations Boolean
KnowledgeArticle stageid Contains the id of the stage where the entity is located. Uniqueidentifier
KnowledgeArticle statecode Shows whether the article is a draft or is published, archived, or discarded. Draft articles aren’t available externally and can be edited. Published articles are available externally, based on applicable permissions, but can’t be edited. All metadata changes are reflected in the published version. Archived and discarded articles aren’t available externally and can’t be edited. State
KnowledgeArticle statuscode Select the article’s status. Status
KnowledgeArticle subjectid Choose the subject of the article to assist with article searches. You can configure subjects under Business Management in the Settings area. Lookup
KnowledgeArticle timezoneruleversionnumber For internal use only. Integer
KnowledgeArticle title Type a title for the article. String
KnowledgeArticle transactioncurrencyid Exchange rate for the currency associated with the KnowledgeArticle with respect to the base currency. Lookup
KnowledgeArticle traversedpath A comma separated list of string values representing the unique identifiers of stages in a Business Process Flow Instance in the order that they occur. String
KnowledgeArticle updatecontent Update Content Boolean
KnowledgeArticle utcconversiontimezonecode Time zone code that was in use when the record was created. Integer
KnowledgeArticle versionnumber BigInt
KnowledgeArticleIncident createdby Shows who created the record. Lookup
KnowledgeArticleIncident createdon Date and time when the record was created. DateTime
KnowledgeArticleIncident createdonbehalfby Unique identifier of the delegate user