편집

다음을 통해 공유


Account table/entity reference

Note

Unsure about table vs. entity? See Developers: Understand terminology in Microsoft Dataverse.

Business that represents a customer or potential customer. The company that is billed in business transactions.

Messages

Message Web API Operation SDK class or method
Assign PATCH /accounts(accountid)
Update ownerid property.
AssignRequest
Associate Associate and disassociate entities AssociateRequest or
Associate
BulkRetain This message is to be executed only by Dataverse to trigger registered plug-ins and flows.
Create POST /accounts
See Create
CreateRequest or
Create
CreateMultiple CreateMultiple CreateMultipleRequest
Delete DELETE /accounts(accountid)
See Delete
DeleteRequest or
Delete
Disassociate Associate and disassociate entities DisassociateRequest or
Disassociate
GrantAccess GrantAccess GrantAccessRequest
IsValidStateTransition IsValidStateTransition IsValidStateTransitionRequest
Merge Merge MergeRequest
ModifyAccess ModifyAccess ModifyAccessRequest
PurgeRetainedContent This message is to be executed only by Dataverse to trigger registered plug-ins and flows.
Retain This message is to be executed only by Dataverse to trigger registered plug-ins and flows.
Retrieve GET /accounts(accountid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET /accounts
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
RetrievePrincipalAccess RetrievePrincipalAccess RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess RevokeAccessRequest
RollbackRetain This message is to be executed only by Dataverse to trigger registered plug-ins and flows.
Rollup Rollup RollupRequest
SetState PATCH /accounts(accountid)
Update statecode and statuscode properties.
SetStateRequest
Update PATCH /accounts(accountid)
See Update
UpdateRequest or
Update
UpdateMultiple UpdateMultiple UpdateMultipleRequest
ValidateRetentionConfig This message is to be executed only by Dataverse to trigger registered plug-ins and flows.

Properties

Property Value
CollectionSchemaName Accounts
DisplayCollectionName Accounts
DisplayName Account
EntitySetName accounts
IsBPFEntity False
LogicalCollectionName accounts
LogicalName account
OwnershipType UserOwned
PrimaryIdAttribute accountid
PrimaryNameAttribute name
SchemaName Account

Writable columns/attributes

These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.

AccountCategoryCode

Property Value
Description Select a category to indicate whether the customer account is standard or preferred.
DisplayName Category
IsValidForForm True
IsValidForRead True
LogicalName accountcategorycode
RequiredLevel None
Type Picklist

AccountCategoryCode Choices/Options

Value Label Description
1 Preferred Customer
2 Standard

AccountClassificationCode

Property Value
Description 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.
DisplayName Classification
IsValidForForm True
IsValidForRead True
LogicalName accountclassificationcode
RequiredLevel None
Type Picklist

AccountClassificationCode Choices/Options

Value Label Description
1 Default Value

AccountId

Property Value
Description Unique identifier of the account.
DisplayName Account
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName accountid
RequiredLevel SystemRequired
Type Uniqueidentifier

AccountNumber

Property Value
Description Type an ID number or code for the account to quickly search and identify the account in system views.
DisplayName Account Number
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName accountnumber
MaxLength 20
RequiredLevel None
Type String

AccountRatingCode

Property Value
Description Select a rating to indicate the value of the customer account.
DisplayName Account Rating
IsValidForForm True
IsValidForRead True
LogicalName accountratingcode
RequiredLevel None
Type Picklist

AccountRatingCode Choices/Options

Value Label Description
1 Default Value

Address1_AddressId

Property Value
Description Unique identifier for address 1.
DisplayName Address 1: ID
IsValidForForm False
IsValidForRead True
LogicalName address1_addressid
RequiredLevel None
Type Uniqueidentifier

Address1_AddressTypeCode

Property Value
Description Select the primary address type.
DisplayName Address 1: Address Type
IsValidForForm True
IsValidForRead True
LogicalName address1_addresstypecode
RequiredLevel None
Type Picklist

Address1_AddressTypeCode Choices/Options

Value Label Description
1 Bill To
2 Ship To
3 Primary
4 Other

Address1_City

Property Value
Description Type the city for the primary address.
DisplayName Address 1: City
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_city
MaxLength 80
RequiredLevel None
Type String

Address1_Country

Property Value
Description Type the country or region for the primary address.
DisplayName Address 1: Country/Region
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_country
MaxLength 80
RequiredLevel None
Type String

Address1_County

Property Value
Description Type the county for the primary address.
DisplayName Address 1: County
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_county
MaxLength 50
RequiredLevel None
Type String

Address1_Fax

Property Value
Description Type the fax number associated with the primary address.
DisplayName Address 1: Fax
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_fax
MaxLength 50
RequiredLevel None
Type String

Address1_FreightTermsCode

Property Value
Description Select the freight terms for the primary address to make sure shipping orders are processed correctly.
DisplayName Address 1: Freight Terms
IsValidForForm True
IsValidForRead True
LogicalName address1_freighttermscode
RequiredLevel None
Type Picklist

Address1_FreightTermsCode Choices/Options

Value Label Description
1 FOB
2 No Charge

Address1_Latitude

Property Value
Description Type the latitude value for the primary address for use in mapping and other applications.
DisplayName Address 1: Latitude
IsValidForForm True
IsValidForRead True
LogicalName address1_latitude
MaxValue 90
MinValue -90
Precision 5
RequiredLevel None
Type Double

Address1_Line1

Property Value
Description Type the first line of the primary address.
DisplayName Address 1: Street 1
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_line1
MaxLength 250
RequiredLevel None
Type String

Address1_Line2

Property Value
Description Type the second line of the primary address.
DisplayName Address 1: Street 2
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_line2
MaxLength 250
RequiredLevel None
Type String

Address1_Line3

Property Value
Description Type the third line of the primary address.
DisplayName Address 1: Street 3
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_line3
MaxLength 250
RequiredLevel None
Type String

Address1_Longitude

Property Value
Description Type the longitude value for the primary address for use in mapping and other applications.
DisplayName Address 1: Longitude
IsValidForForm True
IsValidForRead True
LogicalName address1_longitude
MaxValue 180
MinValue -180
Precision 5
RequiredLevel None
Type Double

Address1_Name

Property Value
Description Type a descriptive name for the primary address, such as Corporate Headquarters.
DisplayName Address 1: Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_name
MaxLength 200
RequiredLevel None
Type String

Address1_PostalCode

Property Value
Description Type the ZIP Code or postal code for the primary address.
DisplayName Address 1: ZIP/Postal Code
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_postalcode
MaxLength 20
RequiredLevel None
Type String

Address1_PostOfficeBox

Property Value
Description Type the post office box number of the primary address.
DisplayName Address 1: Post Office Box
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_postofficebox
MaxLength 20
RequiredLevel None
Type String

Address1_PrimaryContactName

Property Value
Description Type the name of the main contact at the account's primary address.
DisplayName Address 1: Primary Contact Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_primarycontactname
MaxLength 100
RequiredLevel None
Type String

Address1_ShippingMethodCode

Property Value
Description Select a shipping method for deliveries sent to this address.
DisplayName Address 1: Shipping Method
IsValidForForm True
IsValidForRead True
LogicalName address1_shippingmethodcode
RequiredLevel None
Type Picklist

Address1_ShippingMethodCode Choices/Options

Value Label Description
1 Airborne
2 DHL
3 FedEx
4 UPS
5 Postal Mail
6 Full Load
7 Will Call

Address1_StateOrProvince

Property Value
Description Type the state or province of the primary address.
DisplayName Address 1: State/Province
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_stateorprovince
MaxLength 50
RequiredLevel None
Type String

Address1_Telephone1

Property Value
Description Type the main phone number associated with the primary address.
DisplayName Address Phone
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_telephone1
MaxLength 50
RequiredLevel None
Type String

Address1_Telephone2

Property Value
Description Type a second phone number associated with the primary address.
DisplayName Address 1: Telephone 2
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_telephone2
MaxLength 50
RequiredLevel None
Type String

Address1_Telephone3

Property Value
Description Type a third phone number associated with the primary address.
DisplayName Address 1: Telephone 3
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_telephone3
MaxLength 50
RequiredLevel None
Type String

Address1_UPSZone

Property Value
Description 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.
DisplayName Address 1: UPS Zone
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_upszone
MaxLength 4
RequiredLevel None
Type String

Address1_UTCOffset

Property Value
Description Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address.
DisplayName Address 1: UTC Offset
Format TimeZone
IsValidForForm True
IsValidForRead True
LogicalName address1_utcoffset
MaxValue 1500
MinValue -1500
RequiredLevel None
Type Integer

Address2_AddressId

Property Value
Description Unique identifier for address 2.
DisplayName Address 2: ID
IsValidForForm False
IsValidForRead True
LogicalName address2_addressid
RequiredLevel None
Type Uniqueidentifier

Address2_AddressTypeCode

Property Value
Description Select the secondary address type.
DisplayName Address 2: Address Type
IsValidForForm True
IsValidForRead True
LogicalName address2_addresstypecode
RequiredLevel None
Type Picklist

Address2_AddressTypeCode Choices/Options

Value Label Description
1 Default Value

Address2_City

Property Value
Description Type the city for the secondary address.
DisplayName Address 2: City
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_city
MaxLength 80
RequiredLevel None
Type String

Address2_Country

Property Value
Description Type the country or region for the secondary address.
DisplayName Address 2: Country/Region
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_country
MaxLength 80
RequiredLevel None
Type String

Address2_County

Property Value
Description Type the county for the secondary address.
DisplayName Address 2: County
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_county
MaxLength 50
RequiredLevel None
Type String

Address2_Fax

Property Value
Description Type the fax number associated with the secondary address.
DisplayName Address 2: Fax
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_fax
MaxLength 50
RequiredLevel None
Type String

Address2_FreightTermsCode

Property Value
Description Select the freight terms for the secondary address to make sure shipping orders are processed correctly.
DisplayName Address 2: Freight Terms
IsValidForForm True
IsValidForRead True
LogicalName address2_freighttermscode
RequiredLevel None
Type Picklist

Address2_FreightTermsCode Choices/Options

Value Label Description
1 Default Value

Address2_Latitude

Property Value
Description Type the latitude value for the secondary address for use in mapping and other applications.
DisplayName Address 2: Latitude
IsValidForForm True
IsValidForRead True
LogicalName address2_latitude
MaxValue 90
MinValue -90
Precision 5
RequiredLevel None
Type Double

Address2_Line1

Property Value
Description Type the first line of the secondary address.
DisplayName Address 2: Street 1
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_line1
MaxLength 250
RequiredLevel None
Type String

Address2_Line2

Property Value
Description Type the second line of the secondary address.
DisplayName Address 2: Street 2
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_line2
MaxLength 250
RequiredLevel None
Type String

Address2_Line3

Property Value
Description Type the third line of the secondary address.
DisplayName Address 2: Street 3
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_line3
MaxLength 250
RequiredLevel None
Type String

Address2_Longitude

Property Value
Description Type the longitude value for the secondary address for use in mapping and other applications.
DisplayName Address 2: Longitude
IsValidForForm True
IsValidForRead True
LogicalName address2_longitude
MaxValue 180
MinValue -180
Precision 5
RequiredLevel None
Type Double

Address2_Name

Property Value
Description Type a descriptive name for the secondary address, such as Corporate Headquarters.
DisplayName Address 2: Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_name
MaxLength 200
RequiredLevel None
Type String

Address2_PostalCode

Property Value
Description Type the ZIP Code or postal code for the secondary address.
DisplayName Address 2: ZIP/Postal Code
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_postalcode
MaxLength 20
RequiredLevel None
Type String

Address2_PostOfficeBox

Property Value
Description Type the post office box number of the secondary address.
DisplayName Address 2: Post Office Box
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_postofficebox
MaxLength 20
RequiredLevel None
Type String

Address2_PrimaryContactName

Property Value
Description Type the name of the main contact at the account's secondary address.
DisplayName Address 2: Primary Contact Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_primarycontactname
MaxLength 100
RequiredLevel None
Type String

Address2_ShippingMethodCode

Property Value
Description Select a shipping method for deliveries sent to this address.
DisplayName Address 2: Shipping Method
IsValidForForm True
IsValidForRead True
LogicalName address2_shippingmethodcode
RequiredLevel None
Type Picklist

Address2_ShippingMethodCode Choices/Options

Value Label Description
1 Default Value

Address2_StateOrProvince

Property Value
Description Type the state or province of the secondary address.
DisplayName Address 2: State/Province
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_stateorprovince
MaxLength 50
RequiredLevel None
Type String

Address2_Telephone1

Property Value
Description Type the main phone number associated with the secondary address.
DisplayName Address 2: Telephone 1
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_telephone1
MaxLength 50
RequiredLevel None
Type String

Address2_Telephone2

Property Value
Description Type a second phone number associated with the secondary address.
DisplayName Address 2: Telephone 2
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_telephone2
MaxLength 50
RequiredLevel None
Type String

Address2_Telephone3

Property Value
Description Type a third phone number associated with the secondary address.
DisplayName Address 2: Telephone 3
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_telephone3
MaxLength 50
RequiredLevel None
Type String

Address2_UPSZone

Property Value
Description 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.
DisplayName Address 2: UPS Zone
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_upszone
MaxLength 4
RequiredLevel None
Type String

Address2_UTCOffset

Property Value
Description Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address.
DisplayName Address 2: UTC Offset
Format TimeZone
IsValidForForm True
IsValidForRead True
LogicalName address2_utcoffset
MaxValue 1500
MinValue -1500
RequiredLevel None
Type Integer

Adx_CreatedByIPAddress

Added by: Power Pages Runtime Core Dependencies Solution

Property Value
Description
DisplayName Created By (IP Address)
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName adx_createdbyipaddress
MaxLength 100
RequiredLevel None
Type String

Adx_CreatedByUsername

Added by: Power Pages Runtime Core Dependencies Solution

Property Value
Description
DisplayName Created By (User Name)
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName adx_createdbyusername
MaxLength 100
RequiredLevel None
Type String

Adx_ModifiedByIPAddress

Added by: Power Pages Runtime Core Dependencies Solution

Property Value
Description
DisplayName Modified By (IP Address)
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName adx_modifiedbyipaddress
MaxLength 100
RequiredLevel None
Type String

Adx_ModifiedByUsername

Added by: Power Pages Runtime Core Dependencies Solution

Property Value
Description
DisplayName Modified By (User Name)
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName adx_modifiedbyusername
MaxLength 100
RequiredLevel None
Type String

BusinessTypeCode

Property Value
Description Select the legal designation or other business type of the account for contracts or reporting purposes.
DisplayName Business Type
IsValidForForm True
IsValidForRead True
LogicalName businesstypecode
RequiredLevel None
Type Picklist

BusinessTypeCode Choices/Options

Value Label Description
1 Default Value

CreditLimit

Property Value
Description Type the credit limit of the account. This is a useful reference when you address invoice and accounting issues with the customer.
DisplayName Credit Limit
IsValidForForm True
IsValidForRead True
LogicalName creditlimit
MaxValue 100000000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel None
Type Money

CreditOnHold

Property Value
Description 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.
DisplayName Credit Hold
IsValidForForm True
IsValidForRead True
LogicalName creditonhold
RequiredLevel None
Type Boolean

CreditOnHold Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

CustomerSizeCode

Property Value
Description Select the size category or range of the account for segmentation and reporting purposes.
DisplayName Customer Size
IsValidForForm True
IsValidForRead True
LogicalName customersizecode
RequiredLevel None
Type Picklist

CustomerSizeCode Choices/Options

Value Label Description
1 Default Value

CustomerTypeCode

Property Value
Description Select the category that best describes the relationship between the account and your organization.
DisplayName Relationship Type
IsValidForForm True
IsValidForRead True
LogicalName customertypecode
RequiredLevel None
Type Picklist

CustomerTypeCode Choices/Options

Value Label Description
1 Competitor
2 Consultant
3 Customer
4 Investor
5 Partner
6 Influencer
7 Press
8 Prospect
9 Reseller
10 Supplier
11 Vendor
12 Other

DefaultPriceLevelId

Added by: Product Management Solution

Property Value
Description 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.
DisplayName Price List
IsValidForForm True
IsValidForRead True
LogicalName defaultpricelevelid
RequiredLevel None
Targets pricelevel
Type Lookup

Description

Property Value
Description Type additional information to describe the account, such as an excerpt from the company's website.
DisplayName Description
Format TextArea
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName description
MaxLength 2000
RequiredLevel None
Type Memo

DoNotBulkEMail

Property Value
Description 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.
DisplayName Do not allow Bulk Emails
IsValidForForm True
IsValidForRead True
LogicalName donotbulkemail
RequiredLevel None
Type Boolean

DoNotBulkEMail Choices/Options

Value Label Description
1 Do Not Allow
0 Allow

DefaultValue: 0

DoNotBulkPostalMail

Property Value
Description 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.
DisplayName Do not allow Bulk Mails
IsValidForForm True
IsValidForRead True
LogicalName donotbulkpostalmail
RequiredLevel None
Type Boolean

DoNotBulkPostalMail Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

DoNotEMail

Property Value
Description Select whether the account allows direct email sent from Microsoft Dynamics 365.
DisplayName Do not allow Emails
IsValidForForm True
IsValidForRead True
LogicalName donotemail
RequiredLevel None
Type Boolean

DoNotEMail Choices/Options

Value Label Description
1 Do Not Allow
0 Allow

DefaultValue: 0

DoNotFax

Property Value
Description Select whether the account allows faxes. If Do Not Allow is selected, the account will be excluded from fax activities distributed in marketing campaigns.
DisplayName Do not allow Faxes
IsValidForForm True
IsValidForRead True
LogicalName donotfax
RequiredLevel None
Type Boolean

DoNotFax Choices/Options

Value Label Description
1 Do Not Allow
0 Allow

DefaultValue: 0

DoNotPhone

Property Value
Description 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.
DisplayName Do not allow Phone Calls
IsValidForForm True
IsValidForRead True
LogicalName donotphone
RequiredLevel None
Type Boolean

DoNotPhone Choices/Options

Value Label Description
1 Do Not Allow
0 Allow

DefaultValue: 0

DoNotPostalMail

Property Value
Description 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.
DisplayName Do not allow Mails
IsValidForForm True
IsValidForRead True
LogicalName donotpostalmail
RequiredLevel None
Type Boolean

DoNotPostalMail Choices/Options

Value Label Description
1 Do Not Allow
0 Allow

DefaultValue: 0

DoNotSendMM

Property Value
Description Select whether the account accepts marketing materials, such as brochures or catalogs.
DisplayName Send Marketing Materials
IsValidForForm True
IsValidForRead True
LogicalName donotsendmm
RequiredLevel None
Type Boolean

DoNotSendMM Choices/Options

Value Label Description
1 Do Not Send
0 Send

DefaultValue: 0

EMailAddress1

Property Value
Description Type the primary email address for the account.
DisplayName Email
FormatName Email
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName emailaddress1
MaxLength 100
RequiredLevel None
Type String

EMailAddress2

Property Value
Description Type the secondary email address for the account.
DisplayName Email Address 2
FormatName Email
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName emailaddress2
MaxLength 100
RequiredLevel None
Type String

EMailAddress3

Property Value
Description Type an alternate email address for the account.
DisplayName Email Address 3
FormatName Email
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName emailaddress3
MaxLength 100
RequiredLevel None
Type String

EntityImage

Property Value
Description Shows the default image for the record.
DisplayName Default Image
IsPrimaryImage True
IsValidForForm False
IsValidForRead True
LogicalName entityimage
MaxHeight 144
MaxWidth 144
RequiredLevel None
Type Image

Fax

Property Value
Description Type the fax number for the account.
DisplayName Fax
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName fax
MaxLength 50
RequiredLevel None
Type String

FollowEmail

Property Value
Description Information about whether to allow following email activity like opens, attachment views and link clicks for emails sent to the account.
DisplayName Follow Email Activity
IsValidForForm True
IsValidForRead True
LogicalName followemail
RequiredLevel None
Type Boolean

FollowEmail Choices/Options

Value Label Description
1 Allow
0 Do Not Allow

DefaultValue: 1

FtpSiteURL

Property Value
Description Type the URL for the account's FTP site to enable users to access data and share documents.
DisplayName FTP Site
FormatName Url
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName ftpsiteurl
MaxLength 200
RequiredLevel None
Type String

ImportSequenceNumber

Property Value
Description Unique identifier of the data import or data migration that created this record.
DisplayName Import Sequence Number
Format None
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName importsequencenumber
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

IndustryCode

Property Value
Description Select the account's primary industry for use in marketing segmentation and demographic analysis.
DisplayName Industry
IsValidForForm True
IsValidForRead True
LogicalName industrycode
RequiredLevel None
Type Picklist

IndustryCode Choices/Options

Value Label Description
1 Accounting
2 Agriculture and Non-petrol Natural Resource Extraction
3 Broadcasting Printing and Publishing
4 Brokers
5 Building Supply Retail
6 Business Services
7 Consulting
8 Consumer Services
9 Design, Direction and Creative Management
10 Distributors, Dispatchers and Processors
11 Doctor's Offices and Clinics
12 Durable Manufacturing
13 Eating and Drinking Places
14 Entertainment Retail
15 Equipment Rental and Leasing
16 Financial
17 Food and Tobacco Processing
18 Inbound Capital Intensive Processing
19 Inbound Repair and Services
20 Insurance
21 Legal Services
22 Non-Durable Merchandise Retail
23 Outbound Consumer Service
24 Petrochemical Extraction and Distribution
25 Service Retail
26 SIG Affiliations
27 Social Services
28 Special Outbound Trade Contractors
29 Specialty Realty
30 Transportation
31 Utility Creation and Distribution
32 Vehicle Retail
33 Wholesale

LastOnHoldTime

Property Value
DateTimeBehavior UserLocal
Description Contains the date and time stamp of the last on hold time.
DisplayName Last On Hold Time
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName lastonholdtime
RequiredLevel None
Type DateTime

LastUsedInCampaign

Property Value
DateTimeBehavior UserLocal
Description Shows the date when the account was last included in a marketing campaign or quick campaign.
DisplayName Last Date Included in Campaign
Format DateOnly
IsValidForCreate False
IsValidForForm True
IsValidForRead True
LogicalName lastusedincampaign
RequiredLevel None
Type DateTime

MarketCap

Property Value
Description Type the market capitalization of the account to identify the company's equity, used as an indicator in financial performance analysis.
DisplayName Market Capitalization
IsValidForForm True
IsValidForRead True
LogicalName marketcap
MaxValue 100000000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel None
Type Money

MarketingOnly

Property Value
Description Whether is only for marketing
DisplayName Marketing Only
IsValidForForm True
IsValidForRead True
LogicalName marketingonly
RequiredLevel None
Type Boolean

MarketingOnly Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

msa_managingpartnerid

Added by: Power Pages Runtime Core Dependencies Solution

Property Value
Description Unique identifier for Account associated with Account.
DisplayName Managing Partner
IsValidForForm True
IsValidForRead True
LogicalName msa_managingpartnerid
RequiredLevel None
Targets account
Type Lookup

msdyn_accountkpiid

Added by: Relationship analytics Solution

Property Value
Description
DisplayName KPI
IsValidForForm True
IsValidForRead True
LogicalName msdyn_accountkpiid
RequiredLevel None
Targets msdyn_accountkpiitem
Type Lookup

msdyn_gdproptout

Added by: Predictive Opportunity Scoring Solution

Property Value
Description Describes whether account is opted out or not
DisplayName GDPR Optout
IsValidForForm True
IsValidForRead True
LogicalName msdyn_gdproptout
RequiredLevel None
Type Boolean

msdyn_gdproptout Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

msdyn_salesaccelerationinsightid

Added by: Sales Acceleration Solution

Property Value
Description Sales Acceleration Insights ID
DisplayName Sales Acceleration Insights ID
IsValidForForm True
IsValidForRead True
LogicalName msdyn_salesaccelerationinsightid
RequiredLevel None
Targets msdyn_salesaccelerationinsight
Type Lookup

Name

Property Value
Description Type the company or business name.
DisplayName Account Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName name
MaxLength 160
RequiredLevel ApplicationRequired
Type String

NumberOfEmployees

Property Value
Description Type the number of employees that work at the account for use in marketing segmentation and demographic analysis.
DisplayName Number of Employees
Format None
IsValidForForm True
IsValidForRead True
LogicalName numberofemployees
MaxValue 1000000000
MinValue 0
RequiredLevel None
Type Integer

OriginatingLeadId

Added by: Lead Management Solution

Property Value
Description 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.
DisplayName Originating Lead
IsValidForForm True
IsValidForRead True
IsValidForUpdate False
LogicalName originatingleadid
RequiredLevel None
Targets lead
Type Lookup

OverriddenCreatedOn

Property Value
DateTimeBehavior UserLocal
Description Date and time that the record was migrated.
DisplayName Record Created On
Format DateOnly
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName overriddencreatedon
RequiredLevel None
Type DateTime

OwnerId

Property Value
Description 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.
DisplayName Owner
IsValidForForm True
IsValidForRead True
LogicalName ownerid
RequiredLevel SystemRequired
Targets systemuser,team
Type Owner

OwnerIdType

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName owneridtype
RequiredLevel SystemRequired
Type EntityName

OwnershipCode

Property Value
Description Select the account's ownership structure, such as public or private.
DisplayName Ownership
IsValidForForm True
IsValidForRead True
LogicalName ownershipcode
RequiredLevel None
Type Picklist

OwnershipCode Choices/Options

Value Label Description
1 Public
2 Private
3 Subsidiary
4 Other

ParentAccountId

Property Value
Description Choose the parent account associated with this account to show parent and child businesses in reporting and analytics.
DisplayName Parent Account
IsValidForForm True
IsValidForRead True
LogicalName parentaccountid
RequiredLevel None
Targets account
Type Lookup

ParticipatesInWorkflow

Property Value
Description For system use only. Legacy Microsoft Dynamics CRM 3.0 workflow data.
DisplayName Participates in Workflow
IsValidForForm False
IsValidForRead True
LogicalName participatesinworkflow
RequiredLevel None
Type Boolean

ParticipatesInWorkflow Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

PaymentTermsCode

Property Value
Description Select the payment terms to indicate when the customer needs to pay the total amount.
DisplayName Payment Terms
IsValidForForm True
IsValidForRead True
LogicalName paymenttermscode
RequiredLevel None
Type Picklist

PaymentTermsCode Choices/Options

Value Label Description
1 Net 30
2 2% 10, Net 30
3 Net 45
4 Net 60

PreferredAppointmentDayCode

Property Value
Description Select the preferred day of the week for service appointments.
DisplayName Preferred Day
IsValidForForm True
IsValidForRead True
LogicalName preferredappointmentdaycode
RequiredLevel None
Type Picklist

PreferredAppointmentDayCode Choices/Options

Value Label Description
0 Sunday
1 Monday
2 Tuesday
3 Wednesday
4 Thursday
5 Friday
6 Saturday

PreferredAppointmentTimeCode

Property Value
Description Select the preferred time of day for service appointments.
DisplayName Preferred Time
IsValidForForm True
IsValidForRead True
LogicalName preferredappointmenttimecode
RequiredLevel None
Type Picklist

PreferredAppointmentTimeCode Choices/Options

Value Label Description
1 Morning
2 Afternoon
3 Evening

PreferredContactMethodCode

Property Value
Description Select the preferred method of contact.
DisplayName Preferred Method of Contact
IsValidForForm True
IsValidForRead True
LogicalName preferredcontactmethodcode
RequiredLevel None
Type Picklist

PreferredContactMethodCode Choices/Options

Value Label Description
1 Any
2 Email
3 Phone
4 Fax
5 Mail

PreferredEquipmentId

Added by: Service Solution

Property Value
Description Choose the account's preferred service facility or equipment to make sure services are scheduled correctly for the customer.
DisplayName Preferred Facility/Equipment
IsValidForForm True
IsValidForRead True
LogicalName preferredequipmentid
RequiredLevel None
Targets equipment
Type Lookup

PreferredServiceId

Added by: Service Solution

Property Value
Description Choose the account's preferred service for reference when you schedule service activities.
DisplayName Preferred Service
IsValidForForm True
IsValidForRead True
LogicalName preferredserviceid
RequiredLevel None
Targets service
Type Lookup

PreferredSystemUserId

Property Value
Description Choose the preferred service representative for reference when you schedule service activities for the account.
DisplayName Preferred User
IsValidForForm True
IsValidForRead True
LogicalName preferredsystemuserid
RequiredLevel None
Targets systemuser
Type Lookup

PrimaryContactId

Property Value
Description Choose the primary contact for the account to provide quick access to contact details.
DisplayName Primary Contact
IsValidForForm True
IsValidForRead True
LogicalName primarycontactid
RequiredLevel None
Targets contact
Type Lookup

PrimarySatoriId

Property Value
Description Primary Satori ID for Account
DisplayName Primary Satori ID
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName primarysatoriid
MaxLength 200
RequiredLevel None
Type String

PrimaryTwitterId

Property Value
Description Primary Twitter ID for Account
DisplayName Primary Twitter ID
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName primarytwitterid
MaxLength 128
RequiredLevel None
Type String

ProcessId

Property Value
Description Shows the ID of the process.
DisplayName Process
IsValidForForm False
IsValidForRead True
LogicalName processid
RequiredLevel None
Type Uniqueidentifier

Revenue

Property Value
Description Type the annual revenue for the account, used as an indicator in financial performance analysis.
DisplayName Annual Revenue
IsValidForForm True
IsValidForRead True
LogicalName revenue
MaxValue 100000000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel None
Type Money

SharesOutstanding

Property Value
Description Type the number of shares available to the public for the account. This number is used as an indicator in financial performance analysis.
DisplayName Shares Outstanding
Format None
IsValidForForm True
IsValidForRead True
LogicalName sharesoutstanding
MaxValue 1000000000
MinValue 0
RequiredLevel None
Type Integer

ShippingMethodCode

Property Value
Description Select a shipping method for deliveries sent to the account's address to designate the preferred carrier or other delivery option.
DisplayName Shipping Method
IsValidForForm True
IsValidForRead True
LogicalName shippingmethodcode
RequiredLevel None
Type Picklist

ShippingMethodCode Choices/Options

Value Label Description
1 Default Value

SIC

Property Value
Description Type the Standard Industrial Classification (SIC) code that indicates the account's primary industry of business, for use in marketing segmentation and demographic analysis.
DisplayName SIC Code
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName sic
MaxLength 20
RequiredLevel None
Type String

SLAId

Property Value
Description Choose the service level agreement (SLA) that you want to apply to the Account record.
DisplayName SLA
IsValidForForm True
IsValidForRead True
LogicalName slaid
RequiredLevel None
Targets sla
Type Lookup

StageId

Property Value
Description Shows the ID of the stage.
DisplayName (Deprecated) Process Stage
IsValidForForm False
IsValidForRead True
LogicalName stageid
RequiredLevel None
Type Uniqueidentifier

StateCode

Property Value
Description Shows whether the account is active or inactive. Inactive accounts are read-only and can't be edited unless they are reactivated.
DisplayName Status
IsValidForCreate False
IsValidForForm True
IsValidForRead True
LogicalName statecode
RequiredLevel SystemRequired
Type State

StateCode Choices/Options

Value Label DefaultStatus InvariantName
0 Active 1 Active
1 Inactive 2 Inactive

StatusCode

Property Value
Description Select the account's status.
DisplayName Status Reason
IsValidForForm True
IsValidForRead True
LogicalName statuscode
RequiredLevel None
Type Status

StatusCode Choices/Options

Value Label State
1 Active 0
2 Inactive 1

StockExchange

Property Value
Description Type the stock exchange at which the account is listed to track their stock and financial performance of the company.
DisplayName Stock Exchange
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName stockexchange
MaxLength 20
RequiredLevel None
Type String

TeamsFollowed

Added by: Sales Patch Solution

Property Value
Description Number of users or conversations followed the record
DisplayName TeamsFollowed
Format None
IsValidForForm False
IsValidForRead True
LogicalName teamsfollowed
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

Telephone1

Property Value
Description Type the main phone number for this account.
DisplayName Main Phone
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName telephone1
MaxLength 50
RequiredLevel None
Type String

Telephone2

Property Value
Description Type a second phone number for this account.
DisplayName Other Phone
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName telephone2
MaxLength 50
RequiredLevel None
Type String

Telephone3

Property Value
Description Type a third phone number for this account.
DisplayName Telephone 3
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName telephone3
MaxLength 50
RequiredLevel None
Type String

TerritoryCode

Property Value
Description Select a region or territory for the account for use in segmentation and analysis.
DisplayName Territory Code
IsValidForForm True
IsValidForRead True
LogicalName territorycode
RequiredLevel None
Type Picklist

TerritoryCode Choices/Options

Value Label Description
1 Default Value

TerritoryId

Added by: Sales Solution

Property Value
Description 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.
DisplayName Territory
IsValidForForm True
IsValidForRead True
LogicalName territoryid
RequiredLevel None
Targets territory
Type Lookup

TickerSymbol

Property Value
Description 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.
DisplayName Ticker Symbol
FormatName TickerSymbol
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName tickersymbol
MaxLength 10
RequiredLevel None
Type String

TimeZoneRuleVersionNumber

Property Value
Description For internal use only.
DisplayName Time Zone Rule Version Number
Format None
IsValidForForm False
IsValidForRead True
LogicalName timezoneruleversionnumber
MaxValue 2147483647
MinValue -1
RequiredLevel None
Type Integer

TransactionCurrencyId

Property Value
Description Choose the local currency for the record to make sure budgets are reported in the correct currency.
DisplayName Currency
IsValidForForm True
IsValidForRead True
LogicalName transactioncurrencyid
RequiredLevel None
Targets transactioncurrency
Type Lookup

TraversedPath

Property Value
Description For internal use only.
DisplayName (Deprecated) Traversed Path
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName traversedpath
MaxLength 1250
RequiredLevel None
Type String

UTCConversionTimeZoneCode

Property Value
Description Time zone code that was in use when the record was created.
DisplayName UTC Conversion Time Zone Code
Format None
IsValidForForm False
IsValidForRead True
LogicalName utcconversiontimezonecode
MaxValue 2147483647
MinValue -1
RequiredLevel None
Type Integer

WebSiteURL

Property Value
Description Type the account's website URL to get quick details about the company profile.
DisplayName Website
FormatName Url
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName websiteurl
MaxLength 200
RequiredLevel None
Type String

YomiName

Property Value
Description 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.
DisplayName Yomi Account Name
FormatName PhoneticGuide
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName yominame
MaxLength 160
RequiredLevel None
Type String

Read-only columns/attributes

These columns/attributes return false for both IsValidForCreate or IsValidForUpdate. Listed by SchemaName.

Address1_Composite

Property Value
Description Shows the complete primary address.
DisplayName Address 1
Format TextArea
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address1_composite
MaxLength 1000
RequiredLevel None
Type Memo

Address2_Composite

Property Value
Description Shows the complete secondary address.
DisplayName Address 2
Format TextArea
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address2_composite
MaxLength 1000
RequiredLevel None
Type Memo

Aging30

Property Value
Description For system use only.
DisplayName Aging 30
IsValidForForm True
IsValidForRead True
LogicalName aging30
MaxValue 100000000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel None
Type Money

Aging30_Base

Property Value
Description The base currency equivalent of the aging 30 field.
DisplayName Aging 30 (Base)
IsValidForForm True
IsValidForRead True
LogicalName aging30_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

Aging60

Property Value
Description For system use only.
DisplayName Aging 60
IsValidForForm True
IsValidForRead True
LogicalName aging60
MaxValue 100000000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel None
Type Money

Aging60_Base

Property Value
Description The base currency equivalent of the aging 60 field.
DisplayName Aging 60 (Base)
IsValidForForm True
IsValidForRead True
LogicalName aging60_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

Aging90

Property Value
Description For system use only.
DisplayName Aging 90
IsValidForForm True
IsValidForRead True
LogicalName aging90
MaxValue 100000000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel None
Type Money

Aging90_Base

Property Value
Description The base currency equivalent of the aging 90 field.
DisplayName Aging 90 (Base)
IsValidForForm True
IsValidForRead True
LogicalName aging90_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

CreatedBy

Property Value
Description Shows who created the record.
DisplayName Created By
IsValidForForm True
IsValidForRead True
LogicalName createdby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedByExternalParty

Property Value
Description Shows the external party who created the record.
DisplayName Created By (External Party)
IsValidForForm True
IsValidForRead True
LogicalName createdbyexternalparty
RequiredLevel None
Targets externalparty
Type Lookup

CreatedByExternalPartyName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyexternalpartyname
MaxLength 100
RequiredLevel None
Type String

CreatedByExternalPartyYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyexternalpartyyominame
MaxLength 100
RequiredLevel None
Type String

CreatedByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyname
MaxLength 100
RequiredLevel None
Type String

CreatedByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdbyyominame
MaxLength 100
RequiredLevel None
Type String

CreatedOn

Property Value
DateTimeBehavior UserLocal
Description 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.
DisplayName Created On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName createdon
RequiredLevel None
Type DateTime

CreatedOnBehalfBy

Property Value
Description Shows who created the record on behalf of another user.
DisplayName Created By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName createdonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

CreatedOnBehalfByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

CreatedOnBehalfByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName createdonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

CreditLimit_Base

Property Value
Description Shows the credit limit converted to the system's default base currency for reporting purposes.
DisplayName Credit Limit (Base)
IsValidForForm True
IsValidForRead True
LogicalName creditlimit_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

DefaultPriceLevelIdName

Added by: Product Management Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName defaultpricelevelidname
MaxLength 100
RequiredLevel SystemRequired
Type String

EntityImage_Timestamp

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead True
LogicalName entityimage_timestamp
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

EntityImage_URL

Property Value
Description
DisplayName
FormatName Url
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName entityimage_url
MaxLength 200
RequiredLevel None
Type String

EntityImageId

Property Value
Description For internal use only.
DisplayName Entity Image Id
IsValidForForm False
IsValidForRead True
LogicalName entityimageid
RequiredLevel None
Type Uniqueidentifier

ExchangeRate

Property Value
Description 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.
DisplayName Exchange Rate
IsValidForForm True
IsValidForRead True
LogicalName exchangerate
MaxValue 100000000000
MinValue 0.000000000001
Precision 12
RequiredLevel None
Type Decimal

IsPrivate

Property Value
Description
DisplayName
IsValidForForm False
IsValidForRead False
LogicalName isprivate
RequiredLevel None
Type Boolean

IsPrivate Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

MarketCap_Base

Property Value
Description Shows the market capitalization converted to the system's default base currency.
DisplayName Market Capitalization (Base)
IsValidForForm True
IsValidForRead True
LogicalName marketcap_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

MasterAccountIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName masteraccountidname
MaxLength 100
RequiredLevel None
Type String

MasterAccountIdYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName masteraccountidyominame
MaxLength 100
RequiredLevel None
Type String

MasterId

Property Value
Description Shows the master account that the account was merged with.
DisplayName Master ID
IsValidForForm False
IsValidForRead True
LogicalName masterid
RequiredLevel None
Targets account
Type Lookup

Merged

Property Value
Description Shows whether the account has been merged with another account.
DisplayName Merged
IsValidForForm False
IsValidForRead True
LogicalName merged
RequiredLevel None
Type Boolean

Merged Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

ModifiedBy

Property Value
Description Shows who last updated the record.
DisplayName Modified By
IsValidForForm True
IsValidForRead True
LogicalName modifiedby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedByExternalParty

Property Value
Description Shows the external party who modified the record.
DisplayName Modified By (External Party)
IsValidForForm True
IsValidForRead True
LogicalName modifiedbyexternalparty
RequiredLevel None
Targets externalparty
Type Lookup

ModifiedByExternalPartyName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyexternalpartyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByExternalPartyYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyexternalpartyyominame
MaxLength 100
RequiredLevel None
Type String

ModifiedByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedbyyominame
MaxLength 100
RequiredLevel None
Type String

ModifiedOn

Property Value
DateTimeBehavior UserLocal
Description 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.
DisplayName Modified On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName modifiedon
RequiredLevel None
Type DateTime

ModifiedOnBehalfBy

Property Value
Description Shows who created the record on behalf of another user.
DisplayName Modified By (Delegate)
IsValidForForm True
IsValidForRead True
LogicalName modifiedonbehalfby
RequiredLevel None
Targets systemuser
Type Lookup

ModifiedOnBehalfByName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyname
MaxLength 100
RequiredLevel None
Type String

ModifiedOnBehalfByYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName modifiedonbehalfbyyominame
MaxLength 100
RequiredLevel None
Type String

msa_managingpartneridName

Added by: Power Pages Runtime Core Dependencies Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msa_managingpartneridname
MaxLength 160
RequiredLevel None
Type String

msa_managingpartneridYomiName

Added by: Power Pages Runtime Core Dependencies Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msa_managingpartneridyominame
MaxLength 160
RequiredLevel None
Type String

msdyn_accountkpiidName

Added by: Relationship analytics Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_accountkpiidname
MaxLength 100
RequiredLevel None
Type String

msdyn_salesaccelerationinsightidName

Added by: Sales Acceleration Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_salesaccelerationinsightidname
MaxLength 100
RequiredLevel None
Type String

OnHoldTime

Property Value
Description Shows how long, in minutes, that the record was on hold.
DisplayName On Hold Time (Minutes)
Format None
IsValidForForm True
IsValidForRead True
LogicalName onholdtime
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

OpenDeals

Added by: Sales Solution

Property Value
Description Number of open opportunities against an account and its child accounts.
DisplayName Open Deals
Format None
IsValidForForm True
IsValidForRead True
LogicalName opendeals
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

OpenDeals_Date

Added by: Sales Solution

Property Value
DateTimeBehavior UserLocal
Description Last Updated time of rollup field Open Deals.
DisplayName Open Deals (Last Updated On)
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName opendeals_date
RequiredLevel None
Type DateTime

OpenDeals_State

Added by: Sales Solution

Property Value
Description State of rollup field Open Deals.
DisplayName Open Deals (State)
Format None
IsValidForForm True
IsValidForRead True
LogicalName opendeals_state
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

OpenRevenue

Added by: Sales Solution

Property Value
Description Sum of open revenue against an account and its child accounts.
DisplayName Open Revenue
IsValidForForm True
IsValidForRead True
LogicalName openrevenue
MaxValue 922337203685477
MinValue -922337203685477
Precision 2
PrecisionSource 2
RequiredLevel None
Type Money

OpenRevenue_Base

Added by: Sales Solution

Property Value
Description Value of the Open Revenue in base currency.
DisplayName Open Revenue (Base)
IsValidForForm True
IsValidForRead True
LogicalName openrevenue_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 2
PrecisionSource 2
RequiredLevel None
Type Money

OpenRevenue_Date

Added by: Sales Solution

Property Value
DateTimeBehavior UserLocal
Description Last Updated time of rollup field Open Revenue.
DisplayName Open Revenue (Last Updated On)
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName openrevenue_date
RequiredLevel None
Type DateTime

OpenRevenue_State

Added by: Sales Solution

Property Value
Description State of rollup field Open Revenue.
DisplayName Open Revenue (State)
Format None
IsValidForForm True
IsValidForRead True
LogicalName openrevenue_state
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

OriginatingLeadIdName

Added by: Lead Management Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName originatingleadidname
MaxLength 100
RequiredLevel None
Type String

OriginatingLeadIdYomiName

Added by: Lead Management Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName originatingleadidyominame
MaxLength 100
RequiredLevel None
Type String

OwnerIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owneridname
MaxLength 100
RequiredLevel SystemRequired
Type String

OwnerIdYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owneridyominame
MaxLength 100
RequiredLevel SystemRequired
Type String

OwningBusinessUnit

Property Value
Description Shows the business unit that the record owner belongs to.
DisplayName Owning Business Unit
IsValidForForm True
IsValidForRead True
LogicalName owningbusinessunit
RequiredLevel None
Targets businessunit
Type Lookup

OwningBusinessUnitName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName owningbusinessunitname
MaxLength 160
RequiredLevel None
Type String

OwningTeam

Property Value
Description Unique identifier of the team who owns the account.
DisplayName Owning Team
IsValidForForm False
IsValidForRead True
LogicalName owningteam
RequiredLevel None
Targets team
Type Lookup

OwningUser

Property Value
Description Unique identifier of the user who owns the account.
DisplayName Owning User
IsValidForForm False
IsValidForRead True
LogicalName owninguser
RequiredLevel None
Targets systemuser
Type Lookup

ParentAccountIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName parentaccountidname
MaxLength 100
RequiredLevel None
Type String

ParentAccountIdYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName parentaccountidyominame
MaxLength 100
RequiredLevel None
Type String

PreferredEquipmentIdName

Added by: Service Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName preferredequipmentidname
MaxLength 100
RequiredLevel SystemRequired
Type String

PreferredServiceIdName

Added by: Service Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName preferredserviceidname
MaxLength 100
RequiredLevel SystemRequired
Type String

PreferredSystemUserIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName preferredsystemuseridname
MaxLength 100
RequiredLevel None
Type String

PreferredSystemUserIdYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName preferredsystemuseridyominame
MaxLength 100
RequiredLevel None
Type String

PrimaryContactIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName primarycontactidname
MaxLength 100
RequiredLevel None
Type String

PrimaryContactIdYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName primarycontactidyominame
MaxLength 100
RequiredLevel None
Type String

Revenue_Base

Property Value
Description Shows the annual revenue converted to the system's default base currency. The calculations use the exchange rate specified in the Currencies area.
DisplayName Annual Revenue (Base)
IsValidForForm True
IsValidForRead True
LogicalName revenue_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

SLAInvokedId

Property Value
Description Last SLA that was applied to this case. This field is for internal use only.
DisplayName Last SLA applied
IsValidForForm False
IsValidForRead True
LogicalName slainvokedid
RequiredLevel None
Targets sla
Type Lookup

SLAInvokedIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName slainvokedidname
MaxLength 100
RequiredLevel None
Type String

SLAName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName slaname
MaxLength 100
RequiredLevel None
Type String

TerritoryIdName

Added by: Sales Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName territoryidname
MaxLength 100
RequiredLevel SystemRequired
Type String

TimeSpentByMeOnEmailAndMeetings

Property Value
Description Total time spent for emails (read and write) and meetings by me in relation to account record.
DisplayName Time Spent by me
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName timespentbymeonemailandmeetings
MaxLength 1250
RequiredLevel None
Type String

TransactionCurrencyIdName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName transactioncurrencyidname
MaxLength 100
RequiredLevel None
Type String

VersionNumber

Property Value
Description Version number of the account.
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

One-To-Many Relationships

Listed by SchemaName.

account_parent_account

Same as the account_parent_account many-to-one relationship for the account table/entity.

Property Value
ReferencingEntity account
ReferencingAttribute parentaccountid
IsHierarchical True
IsCustomizable True
ReferencedEntityNavigationPropertyName account_parent_account
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 40
CascadeConfiguration Assign: Cascade
Delete: RemoveLink
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

contact_customer_accounts

Same as the contact_customer_accounts many-to-one relationship for the contact table/entity.

Property Value
ReferencingEntity contact
ReferencingAttribute parentcustomerid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName contact_customer_accounts
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 50
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

account_master_account

Same as the account_master_account many-to-one relationship for the account table/entity.

Property Value
ReferencingEntity account
ReferencingAttribute masterid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName account_master_account
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msa_account_managingpartner

Added by: Power Pages Runtime Core Dependencies Solution

Same as the msa_account_managingpartner many-to-one relationship for the account table/entity.

Property Value
ReferencingEntity account
ReferencingAttribute msa_managingpartnerid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName msa_account_managingpartner
AssociatedMenuConfiguration Behavior: UseLabel
Group: Details
Label: Managed Accounts
Order: 100400
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: Cascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msa_contact_managingpartner

Added by: Power Pages Runtime Core Dependencies Solution

Same as the msa_contact_managingpartner many-to-one relationship for the contact table/entity.

Property Value
ReferencingEntity contact
ReferencingAttribute msa_managingpartnerid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName msa_contact_managingpartner
AssociatedMenuConfiguration Behavior: UseLabel
Group: Details
Label: Managed Contacts
Order: 100500
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: Cascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

lead_customer_accounts

Added by: Lead Management Solution

Same as the lead_customer_accounts many-to-one relationship for the lead table/entity.

Property Value
ReferencingEntity lead
ReferencingAttribute customerid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName lead_customer_accounts
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

lead_parent_account

Added by: Lead Management Solution

Same as the lead_parent_account many-to-one relationship for the lead table/entity.

Property Value
ReferencingEntity lead
ReferencingAttribute parentaccountid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName lead_parent_account
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Sales
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: Cascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

account_BulkOperations

Added by: Marketing Solution

Same as the account_BulkOperations many-to-one relationship for the bulkoperation table/entity.

Property Value
ReferencingEntity bulkoperation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName account_BulkOperations
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

account_CampaignResponses

Added by: Marketing Solution

Same as the account_CampaignResponses many-to-one relationship for the campaignresponse table/entity.

Property Value
ReferencingEntity campaignresponse
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName account_CampaignResponses
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

CreatedAccount_BulkOperationLogs2

Added by: Marketing Solution

Same as the CreatedAccount_BulkOperationLogs2 many-to-one relationship for the bulkoperationlog table/entity.

Property Value
ReferencingEntity bulkoperationlog
ReferencingAttribute createdobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName CreatedAccount_BulkOperationLogs2
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

SourceAccount_BulkOperationLogs

Added by: Marketing Solution

Same as the SourceAccount_BulkOperationLogs many-to-one relationship for the bulkoperationlog table/entity.

Property Value
ReferencingEntity bulkoperationlog
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName SourceAccount_BulkOperationLogs
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

account_OpportunityCloses

Added by: Sales Solution

Same as the account_OpportunityCloses many-to-one relationship for the opportunityclose table/entity.

Property Value
ReferencingEntity opportunityclose
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName account_OpportunityCloses
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

account_OrderCloses

Added by: Sales Solution

Same as the account_OrderCloses many-to-one relationship for the orderclose table/entity.

Property Value
ReferencingEntity orderclose
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName account_OrderCloses
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

account_QuoteCloses

Added by: Sales Solution

Same as the account_QuoteCloses many-to-one relationship for the quoteclose table/entity.

Property Value
ReferencingEntity quoteclose
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName account_QuoteCloses
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

invoice_customer_accounts

Added by: Sales Solution

Same as the invoice_customer_accounts many-to-one relationship for the invoice table/entity.

Property Value
ReferencingEntity invoice
ReferencingAttribute customerid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName invoice_customer_accounts
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Sales
Label:
Order: 40
CascadeConfiguration Assign: Cascade
Delete: Restrict
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

opportunity_customer_accounts

Added by: Sales Solution

Same as the opportunity_customer_accounts many-to-one relationship for the opportunity table/entity.

Property Value
ReferencingEntity opportunity
ReferencingAttribute customerid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName opportunity_customer_accounts
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Sales
Label:
Order: 10
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

order_customer_accounts

Added by: Sales Solution

Same as the order_customer_accounts many-to-one relationship for the salesorder table/entity.

Property Value
ReferencingEntity salesorder
ReferencingAttribute customerid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName order_customer_accounts
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Sales
Label:
Order: 30
CascadeConfiguration Assign: Cascade
Delete: Restrict
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

quote_customer_accounts

Added by: Sales Solution

Same as the quote_customer_accounts many-to-one relationship for the quote table/entity.

Property Value
ReferencingEntity quote
ReferencingAttribute customerid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName quote_customer_accounts
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Sales
Label:
Order: 20
CascadeConfiguration Assign: Cascade
Delete: Cascade
Merge: Cascade
Reparent: Cascade
Share: Cascade
Unshare: Cascade

opportunity_parent_account

Added by: Sales Solution

Same as the opportunity_parent_account many-to-one relationship for the opportunity table/entity.

Property Value
ReferencingEntity opportunity
ReferencingAttribute parentaccountid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName opportunity_parent_account
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Sales
Label:
Order: 1
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: Cascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

msdyn_msdyn_conversationparticipantinsights_account_msdyn_User

Added by: Conversation Intelligence Solution

Same as the msdyn_msdyn_conversationparticipantinsights_account_msdyn_User many-to-one relationship for the msdyn_conversationparticipantinsights table/entity.

Property Value
ReferencingEntity msdyn_conversationparticipantinsights
ReferencingAttribute msdyn_user
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName msdyn_msdyn_conversationparticipantinsights_account_msdyn_user
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10000
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: Cascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Many-To-One Relationships

Each Many-To-One relationship is defined by a corresponding One-To-Many relationship with the related table. Listed by SchemaName.

account_primary_contact

See the account_primary_contact one-to-many relationship for the contact table/entity.

account_master_account

See the account_master_account one-to-many relationship for the account table/entity.

account_parent_account

See the account_parent_account one-to-many relationship for the account table/entity.

msa_account_managingpartner

See the msa_account_managingpartner one-to-many relationship for the account table/entity.

account_originating_lead

Added by: Lead Management Solution

See the account_originating_lead one-to-many relationship for the lead table/entity.

price_level_accounts

Added by: Product Management Solution

See the price_level_accounts one-to-many relationship for the pricelevel table/entity.

Many-To-Many Relationships

Relationship details provided where the Account table is the first table in the relationship. Listed by SchemaName.

accountleads_association

IntersectEntityName: accountleads

Table 1

Property Value
IntersectAttribute leadid
IsCustomizable False
LogicalName account
NavigationPropertyName accountleads_association
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:

Table 2

Property Value
LogicalName lead
IntersectAttribute accountid
NavigationPropertyName accountleads_association
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:

listaccount_association

See the listaccount_association many-to-many relationship for the list table/entity.

BulkOperation_Accounts

See the BulkOperation_Accounts many-to-many relationship for the bulkoperation table/entity.

CampaignActivity_Accounts

See the CampaignActivity_Accounts many-to-many relationship for the campaignactivity table/entity.

Dataverse table/entity reference
Web API Reference