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
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
GrantAccess GrantAccess GrantAccessRequest
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

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

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

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

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

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

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

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

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

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

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

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_principalobjectattributeaccess

Same as the account_principalobjectattributeaccess many-to-one relationship for the principalobjectattributeaccess table/entity.

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

Account_Faxes

Same as the Account_Faxes many-to-one relationship for the fax table/entity.

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

slakpiinstance_account

Same as the slakpiinstance_account many-to-one relationship for the slakpiinstance table/entity.

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

account_PostFollows

Same as the account_PostFollows many-to-one relationship for the postfollow table/entity.

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

Account_Tasks

Same as the Account_Tasks many-to-one relationship for the task table/entity.

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

account_connections1

Same as the account_connections1 many-to-one relationship for the connection table/entity.

Property Value
ReferencingEntity connection
ReferencingAttribute record1id
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName account_connections1
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 100
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: Cascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

SocialActivity_PostAuthorAccount_accounts

Same as the SocialActivity_PostAuthorAccount_accounts many-to-one relationship for the socialactivity table/entity.

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

Account_DuplicateBaseRecord

Same as the Account_DuplicateBaseRecord many-to-one relationship for the duplicaterecord table/entity.

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

SocialActivity_PostAuthor_accounts

Same as the SocialActivity_PostAuthor_accounts many-to-one relationship for the socialactivity table/entity.

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

Account_SyncErrors

Same as the Account_SyncErrors many-to-one relationship for the syncerror table/entity.

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

Account_MailboxTrackingFolder

Same as the Account_MailboxTrackingFolder many-to-one relationship for the mailboxtrackingfolder table/entity.

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

Account_BulkDeleteFailures

Same as the Account_BulkDeleteFailures many-to-one relationship for the bulkdeletefailure table/entity.

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

Account_ActivityPointers

Same as the Account_ActivityPointers many-to-one relationship for the activitypointer table/entity.

Property Value
ReferencingEntity activitypointer
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Account_ActivityPointers
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 20
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Account_Email_SendersAccount

Same as the Account_Email_SendersAccount many-to-one relationship for the email table/entity.

Property Value
ReferencingEntity email
ReferencingAttribute sendersaccount
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Account_Email_SendersAccount
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Account_Appointments

Same as the Account_Appointments many-to-one relationship for the appointment table/entity.

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

Socialprofile_customer_accounts

Same as the Socialprofile_customer_accounts many-to-one relationship for the socialprofile table/entity.

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

Account_Emails

Same as the Account_Emails many-to-one relationship for the email table/entity.

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

account_activity_parties

Same as the account_activity_parties many-to-one relationship for the activityparty table/entity.

Property Value
ReferencingEntity activityparty
ReferencingAttribute partyid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName account_activity_parties
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Account_Phonecalls

Same as the Account_Phonecalls many-to-one relationship for the phonecall table/entity.

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

Account_SocialActivities

Same as the Account_SocialActivities many-to-one relationship for the socialactivity table/entity.

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

Account_DuplicateMatchingRecord

Same as the Account_DuplicateMatchingRecord many-to-one relationship for the duplicaterecord table/entity.

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

account_actioncard

Same as the account_actioncard many-to-one relationship for the actioncard table/entity.

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

Account_AsyncOperations

Same as the Account_AsyncOperations many-to-one relationship for the asyncoperation table/entity.

Property Value
ReferencingEntity asyncoperation
ReferencingAttribute regardingobjectid
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Account_AsyncOperations
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: NoCascade
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Account_CustomerAddress

Same as the Account_CustomerAddress many-to-one relationship for the customeraddress table/entity.

Property Value
ReferencingEntity customeraddress
ReferencingAttribute parentid
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName Account_CustomerAddress
AssociatedMenuConfiguration Behavior: UseCollectionName
Group: Details
Label:
Order: 10
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: Cascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Account_Annotation

Same as the Account_Annotation many-to-one relationship for the annotation table/entity.

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

Account_Letters

Same as the Account_Letters many-to-one relationship for the letter table/entity.

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

Account_RecurringAppointmentMasters

Same as the Account_RecurringAppointmentMasters many-to-one relationship for the recurringappointmentmaster table/entity.

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

Account_Email_EmailSender

Same as the Account_Email_EmailSender many-to-one relationship for the email table/entity.

Property Value
ReferencingEntity email
ReferencingAttribute emailsender
IsHierarchical False
IsCustomizable False
ReferencedEntityNavigationPropertyName Account_Email_EmailSender
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:
CascadeConfiguration Assign: NoCascade
Delete: RemoveLink
Merge: NoCascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

Account_ProcessSessions

Same as the Account_ProcessSessions many-to-one relationship for the processsession table/entity.

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

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

Account_SharepointDocumentLocation

Same as the Account_SharepointDocumentLocation many-to-one relationship for the sharepointdocumentlocation table/entity.

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

account_connections2

Same as the account_connections2 many-to-one relationship for the connection table/entity.

Property Value
ReferencingEntity connection
ReferencingAttribute record2id
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName account_connections2
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order: 100
CascadeConfiguration Assign: NoCascade
Delete: Cascade
Merge: Cascade
Reparent: NoCascade
Share: NoCascade
Unshare: NoCascade

account_chats

Added by: Activities Patch Solution

Same as the account_chats many-to-one relationship for the chat table/entity.

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

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

account_adx_inviteredemptions

Added by: Active Solution Solution

Same as the account_adx_inviteredemptions many-to-one relationship for the adx_inviteredemption table/entity.

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

account_adx_portalcomments

Added by: Active Solution Solution

Same as the account_adx_portalcomments many-to-one relationship for the adx_portalcomment table/entity.

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

adx_invitation_assigntoaccount

Added by: Power Pages Runtime Core Solution

Same as the adx_invitation_assigntoaccount many-to-one relationship for the adx_invitation table/entity.

Property Value
ReferencingEntity adx_invitation
ReferencingAttribute adx_assigntoaccount
IsHierarchical False
IsCustomizable True
ReferencedEntityNavigationPropertyName adx_invitation_assigntoaccount
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.

system_user_accounts

See the system_user_accounts one-to-many relationship for the systemuser table/entity.

lk_accountbase_modifiedby

See the lk_accountbase_modifiedby one-to-many relationship for the systemuser table/entity.

account_parent_account

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

business_unit_accounts

See the business_unit_accounts one-to-many relationship for the businessunit table/entity.

transactioncurrency_account

See the transactioncurrency_account one-to-many relationship for the transactioncurrency table/entity.

user_accounts

See the user_accounts one-to-many relationship for the systemuser table/entity.

lk_accountbase_createdonbehalfby

See the lk_accountbase_createdonbehalfby one-to-many relationship for the systemuser table/entity.

processstage_account

See the processstage_account one-to-many relationship for the processstage table/entity.

manualsla_account

See the manualsla_account one-to-many relationship for the sla table/entity.

lk_accountbase_createdby

See the lk_accountbase_createdby one-to-many relationship for the systemuser table/entity.

sla_account

See the sla_account one-to-many relationship for the sla table/entity.

lk_accountbase_modifiedonbehalfby

See the lk_accountbase_modifiedonbehalfby one-to-many relationship for the systemuser table/entity.

team_accounts

See the team_accounts one-to-many relationship for the team table/entity.

msa_account_managingpartner

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

Many-To-Many Relationships

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

powerpagecomponent_mspp_webrole_account

See the powerpagecomponent_mspp_webrole_account many-to-many relationship for the powerpagecomponent table/entity.

See also

Dataverse table/entity reference
Web API Reference
account EntityType