편집

다음을 통해 공유


Contact table/entity reference

Note

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

Person with whom a business unit has a relationship, such as customer, supplier, and colleague.

Messages

Message Web API Operation SDK class or method
adx_SendEmailConfirmationToContact Type generated by Power Platform CLI pac modelbuilder build command or use OrganizationRequest setting the required parameters for the message.
adx_SendEmailTwoFactorCodeToContact Type generated by Power Platform CLI pac modelbuilder build command or use OrganizationRequest setting the required parameters for the message.
adx_SendPasswordResetToContact Type generated by Power Platform CLI pac modelbuilder build command or use OrganizationRequest setting the required parameters for the message.
Assign PATCH /contacts(contactid)
Update ownerid property.
AssignRequest
Associate Associate and disassociate entities AssociateRequest or
Associate
Create POST /contacts
See Create
CreateRequest or
Create
CreateMultiple CreateMultiple CreateMultipleRequest
Delete DELETE /contacts(contactid)
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
msdyn_GDPROptoutContact Type generated by Power Platform CLI pac modelbuilder build command or use OrganizationRequest setting the required parameters for the message.
Retrieve GET /contacts(contactid)
See Retrieve
RetrieveRequest or
Retrieve
RetrieveMultiple GET /contacts
See Query Data
RetrieveMultipleRequest or
RetrieveMultiple
RetrievePrincipalAccess RetrievePrincipalAccess RetrievePrincipalAccessRequest
RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccess RetrieveSharedPrincipalsAndAccessRequest
RevokeAccess RevokeAccess RevokeAccessRequest
Rollup Rollup RollupRequest
SetState PATCH /contacts(contactid)
Update statecode and statuscode properties.
SetStateRequest
Update PATCH /contacts(contactid)
See Update
UpdateRequest or
Update
UpdateMultiple UpdateMultiple UpdateMultipleRequest

Properties

Property Value
CollectionSchemaName Contacts
DisplayCollectionName Contacts
DisplayName Contact
EntitySetName contacts
IsBPFEntity False
LogicalCollectionName contacts
LogicalName contact
OwnershipType UserOwned
PrimaryIdAttribute contactid
PrimaryNameAttribute fullname
SchemaName Contact

Writable columns/attributes

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

AccountRoleCode

Property Value
Description Select the contact's role within the company or sales process, such as decision maker, employee, or influencer.
DisplayName Role
IsValidForForm True
IsValidForRead True
LogicalName accountrolecode
RequiredLevel None
Type Picklist

AccountRoleCode Choices/Options

Value Label Description
1 Decision Maker
2 Employee
3 Influencer

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 1: 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 100
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

Address3_AddressId

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

Address3_AddressTypeCode

Property Value
Description Select the third address type.
DisplayName Address 3: Address Type
IsValidForForm True
IsValidForRead True
LogicalName address3_addresstypecode
RequiredLevel None
Type Picklist

Address3_AddressTypeCode Choices/Options

Value Label Description
1 Default Value

Address3_City

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

Address3_Country

Property Value
Description the country or region for the 3rd address.
DisplayName Address3: Country/Region
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address3_country
MaxLength 80
RequiredLevel None
Type String

Address3_County

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

Address3_Fax

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

Address3_FreightTermsCode

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

Address3_FreightTermsCode Choices/Options

Value Label Description
1 Default Value

Address3_Latitude

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

Address3_Line1

Property Value
Description the first line of the 3rd address.
DisplayName Address3: Street 1
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address3_line1
MaxLength 250
RequiredLevel None
Type String

Address3_Line2

Property Value
Description the second line of the 3rd address.
DisplayName Address3: Street 2
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address3_line2
MaxLength 250
RequiredLevel None
Type String

Address3_Line3

Property Value
Description the third line of the 3rd address.
DisplayName Address3: Street 3
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address3_line3
MaxLength 250
RequiredLevel None
Type String

Address3_Longitude

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

Address3_Name

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

Address3_PostalCode

Property Value
Description the ZIP Code or postal code for the 3rd address.
DisplayName Address3: ZIP/Postal Code
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address3_postalcode
MaxLength 20
RequiredLevel None
Type String

Address3_PostOfficeBox

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

Address3_PrimaryContactName

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

Address3_ShippingMethodCode

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

Address3_ShippingMethodCode Choices/Options

Value Label Description
1 Default Value

Address3_StateOrProvince

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

Address3_Telephone1

Property Value
Description Type the main phone number associated with the third address.
DisplayName Address 3: Telephone1
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address3_telephone1
MaxLength 50
RequiredLevel None
Type String

Address3_Telephone2

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

Address3_Telephone3

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

Address3_UPSZone

Property Value
Description Type the UPS zone of the third address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS.
DisplayName Address 3: UPS Zone
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address3_upszone
MaxLength 4
RequiredLevel None
Type String

Address3_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 3: UTC Offset
Format TimeZone
IsValidForForm True
IsValidForRead True
LogicalName address3_utcoffset
MaxValue 1500
MinValue -1500
RequiredLevel None
Type Integer

adx_ConfirmRemovePassword

Added by: Power Pages Runtime Core Solution

Property Value
Description
DisplayName Confirm Remove Password
IsValidForForm True
IsValidForRead True
LogicalName adx_confirmremovepassword
RequiredLevel None
Type Boolean

adx_ConfirmRemovePassword Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

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 Username
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName adx_createdbyusername
MaxLength 100
RequiredLevel None
Type String

adx_identity_accessfailedcount

Added by: Power Pages Runtime Core Solution

Property Value
Description Shows the current count of failed password attempts for the contact.
DisplayName Access Failed Count
Format None
IsValidForForm True
IsValidForRead True
LogicalName adx_identity_accessfailedcount
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

adx_identity_emailaddress1confirmed

Added by: Power Pages Runtime Core Solution

Property Value
Description Determines if the email is confirmed by the contact.
DisplayName Email Confirmed
IsValidForForm True
IsValidForRead True
LogicalName adx_identity_emailaddress1confirmed
RequiredLevel None
Type Boolean

adx_identity_emailaddress1confirmed Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

adx_identity_lastsuccessfullogin

Added by: Power Pages Runtime Core Solution

Property Value
DateTimeBehavior UserLocal
Description Indicates the last date and time the user successfully signed in to a portal.
DisplayName Last Successful Login
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName adx_identity_lastsuccessfullogin
RequiredLevel None
Type DateTime

adx_identity_locallogindisabled

Added by: Power Pages Runtime Core Solution

Property Value
Description Indicates that the contact can no longer sign in to the portal using the local account.
DisplayName Local Login Disabled
IsValidForForm True
IsValidForRead True
LogicalName adx_identity_locallogindisabled
RequiredLevel None
Type Boolean

adx_identity_locallogindisabled Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

adx_identity_lockoutenabled

Added by: Power Pages Runtime Core Solution

Property Value
Description Determines if this contact will track failed access attempts and become locked after too many failed attempts. To prevent the contact from becoming locked, you can disable this setting.
DisplayName Lockout Enabled
IsValidForForm True
IsValidForRead True
LogicalName adx_identity_lockoutenabled
RequiredLevel None
Type Boolean

adx_identity_lockoutenabled Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

adx_identity_lockoutenddate

Added by: Power Pages Runtime Core Solution

Property Value
DateTimeBehavior UserLocal
Description Shows the moment in time when the locked contact becomes unlocked again.
DisplayName Lockout End Date
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName adx_identity_lockoutenddate
RequiredLevel None
Type DateTime

adx_identity_logonenabled

Added by: Power Pages Runtime Core Solution

Property Value
Description Determines if web authentication is enabled for the contact.
DisplayName Login Enabled
IsValidForForm True
IsValidForRead True
LogicalName adx_identity_logonenabled
RequiredLevel None
Type Boolean

adx_identity_logonenabled Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

adx_identity_mobilephoneconfirmed

Added by: Power Pages Runtime Core Solution

Property Value
Description Determines if the phone number is confirmed by the contact.
DisplayName Mobile Phone Confirmed
IsValidForForm True
IsValidForRead True
LogicalName adx_identity_mobilephoneconfirmed
RequiredLevel None
Type Boolean

adx_identity_mobilephoneconfirmed Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

adx_identity_newpassword

Added by: Power Pages Runtime Core Solution

Property Value
Description
DisplayName New Password Input
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName adx_identity_newpassword
MaxLength 100
RequiredLevel None
Type String

adx_identity_passwordhash

Added by: Power Pages Runtime Core Solution

Property Value
Description
DisplayName Password Hash
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName adx_identity_passwordhash
MaxLength 128
RequiredLevel None
Type String

adx_identity_securitystamp

Added by: Power Pages Runtime Core Solution

Property Value
Description A token used to manage the web authentication session.
DisplayName Security Stamp
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName adx_identity_securitystamp
MaxLength 100
RequiredLevel None
Type String

adx_identity_twofactorenabled

Added by: Power Pages Runtime Core Solution

Property Value
Description Determines if two-factor authentication is enabled for the contact.
DisplayName Two Factor Enabled
IsValidForForm True
IsValidForRead True
LogicalName adx_identity_twofactorenabled
RequiredLevel None
Type Boolean

adx_identity_twofactorenabled Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

adx_identity_username

Added by: Power Pages Runtime Core Solution

Property Value
Description Shows the user identity for local web authentication.
DisplayName User Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName adx_identity_username
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 Username
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName adx_modifiedbyusername
MaxLength 100
RequiredLevel None
Type String

Adx_OrganizationName

Added by: Power Pages Runtime Core Dependencies Solution

Property Value
Description
DisplayName Organization Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName adx_organizationname
MaxLength 250
RequiredLevel None
Type String

adx_preferredlcid

Added by: Power Pages Runtime Core Solution

Property Value
Description User’s preferred portal LCID
DisplayName Preferred LCID (Deprecated)
Format None
IsValidForForm True
IsValidForRead True
LogicalName adx_preferredlcid
MaxValue 2147483647
MinValue -2147483648
RequiredLevel None
Type Integer

adx_profilealert

Added by: Power Pages Runtime Core Solution

Property Value
Description
DisplayName Profile Alert
IsValidForForm True
IsValidForRead True
LogicalName adx_profilealert
RequiredLevel None
Type Boolean

adx_profilealert Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

adx_profilealertdate

Added by: Power Pages Runtime Core Solution

Property Value
DateTimeBehavior UserLocal
Description
DisplayName Profile Alert Date
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName adx_profilealertdate
RequiredLevel None
Type DateTime

adx_profilealertinstructions

Added by: Power Pages Runtime Core Solution

Property Value
Description
DisplayName Profile Alert Instructions
Format Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName adx_profilealertinstructions
MaxLength 4096
RequiredLevel None
Type Memo

Adx_ProfileIsAnonymous

Added by: Power Pages Runtime Core Solution

Property Value
Description
DisplayName Profile Is Anonymous
IsValidForForm True
IsValidForRead True
LogicalName adx_profileisanonymous
RequiredLevel None
Type Boolean

Adx_ProfileIsAnonymous Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

Adx_ProfileLastActivity

Added by: Power Pages Runtime Core Solution

Property Value
DateTimeBehavior UserLocal
Description
DisplayName Profile Last Activity
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName adx_profilelastactivity
RequiredLevel None
Type DateTime

adx_profilemodifiedon

Added by: Power Pages Runtime Core Solution

Property Value
DateTimeBehavior UserLocal
Description
DisplayName Profile Modified On
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName adx_profilemodifiedon
RequiredLevel None
Type DateTime

adx_PublicProfileCopy

Added by: Power Pages Runtime Core Solution

Property Value
Description
DisplayName Public Profile Copy
Format Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName adx_publicprofilecopy
MaxLength 64000
RequiredLevel None
Type Memo

Adx_TimeZone

Added by: Power Pages Runtime Core Dependencies Solution

Property Value
Description
DisplayName Time Zone
Format TimeZone
IsValidForForm True
IsValidForRead True
LogicalName adx_timezone
MaxValue 1500
MinValue -1500
RequiredLevel None
Type Integer

Anniversary

Property Value
DateTimeBehavior DateOnly
Description Enter the date of the contact's wedding or service anniversary for use in customer gift programs or other communications.
DisplayName Anniversary
Format DateOnly
IsValidForForm True
IsValidForRead True
LogicalName anniversary
RequiredLevel None
Type DateTime

AnnualIncome

Property Value
Description Type the contact's annual income for use in profiling and financial analysis.
DisplayName Annual Income
IsValidForForm True
IsValidForRead True
LogicalName annualincome
MaxValue 100000000000000
MinValue 0
Precision 2
PrecisionSource 2
RequiredLevel None
Type Money

AssistantName

Property Value
Description Type the name of the contact's assistant.
DisplayName Assistant
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName assistantname
MaxLength 100
RequiredLevel None
Type String

AssistantPhone

Property Value
Description Type the phone number for the contact's assistant.
DisplayName Assistant Phone
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName assistantphone
MaxLength 50
RequiredLevel None
Type String

BirthDate

Property Value
DateTimeBehavior DateOnly
Description Enter the contact's birthday for use in customer gift programs or other communications.
DisplayName Birthday
Format DateOnly
IsValidForForm True
IsValidForRead True
LogicalName birthdate
RequiredLevel None
Type DateTime

Business2

Property Value
Description Type a second business phone number for this contact.
DisplayName Business Phone 2
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName business2
MaxLength 50
RequiredLevel None
Type String

BusinessCard

Added by: Sales Patch Version 2 Solution

Property Value
Description Stores Image of the Business Card
DisplayName Business Card
Format TextArea
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName businesscard
MaxLength 1073741823
RequiredLevel None
Type Memo

BusinessCardAttributes

Added by: Sales Patch Version 2 Solution

Property Value
Description Stores Business Card Control Properties.
DisplayName BusinessCardAttributes
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName businesscardattributes
MaxLength 4000
RequiredLevel None
Type String

Callback

Property Value
Description Type a callback phone number for this contact.
DisplayName Callback Number
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName callback
MaxLength 50
RequiredLevel None
Type String

ChildrensNames

Property Value
Description Type the names of the contact's children for reference in communications and client programs.
DisplayName Children's Names
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName childrensnames
MaxLength 255
RequiredLevel None
Type String

Company

Property Value
Description Type the company phone of the contact.
DisplayName Company Phone
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName company
MaxLength 50
RequiredLevel None
Type String

ContactId

Property Value
Description Unique identifier of the contact.
DisplayName Contact
IsValidForForm False
IsValidForRead True
IsValidForUpdate False
LogicalName contactid
RequiredLevel SystemRequired
Type Uniqueidentifier

CreditLimit

Property Value
Description Type the credit limit of the contact for 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 contact is on a credit hold, for reference when addressing invoice and accounting issues.
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 of the contact's company 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 contact and your organization.
DisplayName Relationship Type
IsValidForForm True
IsValidForRead True
LogicalName customertypecode
RequiredLevel None
Type Picklist

CustomerTypeCode Choices/Options

Value Label Description
1 Default Value

DefaultPriceLevelId

Added by: Product Management Solution

Property Value
Description Choose the default price list associated with the contact to make sure the correct product prices for this customer are applied in sales opportunities, quotes, and orders.
DisplayName Price List
IsValidForForm True
IsValidForRead True
LogicalName defaultpricelevelid
RequiredLevel None
Targets pricelevel
Type Lookup

Department

Property Value
Description Type the department or business unit where the contact works in the parent company or business.
DisplayName Department
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName department
MaxLength 100
RequiredLevel None
Type String

Description

Property Value
Description Type additional information to describe the contact, 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 contact accepts bulk email sent through marketing campaigns or quick campaigns. If Do Not Allow is selected, the contact can be added to marketing lists, but will be excluded from the email.
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 contact accepts bulk postal mail sent through marketing campaigns or quick campaigns. If Do Not Allow is selected, the contact can be added to marketing lists, but will be excluded from the letters.
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 contact allows direct email sent from Microsoft Dynamics 365. If Do Not Allow is selected, Microsoft Dynamics 365 will not send the email.
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 contact allows faxes. If Do Not Allow is selected, the contact will be excluded from any 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 contact accepts phone calls. If Do Not Allow is selected, the contact will be excluded from any 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 contact allows direct mail. If Do Not Allow is selected, the contact 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 contact accepts marketing materials, such as brochures or catalogs. Contacts that opt out can be excluded from marketing initiatives.
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

EducationCode

Property Value
Description Select the contact's highest level of education for use in segmentation and analysis.
DisplayName Education
IsValidForForm True
IsValidForRead True
LogicalName educationcode
RequiredLevel None
Type Picklist

EducationCode Choices/Options

Value Label Description
1 Default Value

EMailAddress1

Property Value
Description Type the primary email address for the contact.
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 contact.
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 contact.
DisplayName Email Address 3
FormatName Email
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName emailaddress3
MaxLength 100
RequiredLevel None
Type String

EmployeeId

Property Value
Description Type the employee ID or number for the contact for reference in orders, service cases, or other communications with the contact's organization.
DisplayName Employee
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName employeeid
MaxLength 50
RequiredLevel None
Type String

EntityImage

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

ExternalUserIdentifier

Property Value
Description Identifier for an external user.
DisplayName External User Identifier
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName externaluseridentifier
MaxLength 50
RequiredLevel None
Type String

FamilyStatusCode

Property Value
Description Select the marital status of the contact for reference in follow-up phone calls and other communications.
DisplayName Marital Status
IsValidForForm True
IsValidForRead True
LogicalName familystatuscode
RequiredLevel None
Type Picklist

FamilyStatusCode Choices/Options

Value Label Description
1 Single
2 Married
3 Divorced
4 Widowed

Fax

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

FirstName

Property Value
Description Type the contact's first name to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns.
DisplayName First Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName firstname
MaxLength 50
RequiredLevel Recommended
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 contact.
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 contact'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

GenderCode

Property Value
Description Select the contact's gender to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns.
DisplayName Gender
IsValidForForm True
IsValidForRead True
LogicalName gendercode
RequiredLevel None
Type Picklist

GenderCode Choices/Options

Value Label Description
1 Male
2 Female

GovernmentId

Property Value
Description Type the passport number or other government ID for the contact for use in documents or reports.
DisplayName Government
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName governmentid
MaxLength 50
RequiredLevel None
Type String

HasChildrenCode

Property Value
Description Select whether the contact has any children for reference in follow-up phone calls and other communications.
DisplayName Has Children
IsValidForForm True
IsValidForRead True
LogicalName haschildrencode
RequiredLevel None
Type Picklist

HasChildrenCode Choices/Options

Value Label Description
1 Default Value

Home2

Property Value
Description Type a second home phone number for this contact.
DisplayName Home Phone 2
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName home2
MaxLength 50
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

IsBackofficeCustomer

Property Value
Description Select whether the contact exists in a separate accounting or other system, such as Microsoft Dynamics GP or another ERP database, for use in integration processes.
DisplayName Back Office Customer
IsValidForForm True
IsValidForRead True
LogicalName isbackofficecustomer
RequiredLevel None
Type Boolean

IsBackofficeCustomer Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

JobTitle

Property Value
Description Type the job title of the contact to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns.
DisplayName Job Title
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName jobtitle
MaxLength 100
RequiredLevel None
Type String

LastName

Property Value
Description Type the contact's last name to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns.
DisplayName Last Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName lastname
MaxLength 50
RequiredLevel ApplicationRequired
Type String

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 contact 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

LeadSourceCode

Property Value
Description Select the primary marketing source that directed the contact to your organization.
DisplayName Lead Source
IsValidForForm True
IsValidForRead True
LogicalName leadsourcecode
RequiredLevel None
Type Picklist

LeadSourceCode Choices/Options

Value Label Description
1 Default Value

ManagerName

Property Value
Description Type the name of the contact's manager for use in escalating issues or other follow-up communications with the contact.
DisplayName Manager
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName managername
MaxLength 100
RequiredLevel None
Type String

ManagerPhone

Property Value
Description Type the phone number for the contact's manager.
DisplayName Manager Phone
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName managerphone
MaxLength 50
RequiredLevel None
Type String

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

MiddleName

Property Value
Description Type the contact's middle name or initial to make sure the contact is addressed correctly.
DisplayName Middle Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName middlename
MaxLength 50
RequiredLevel None
Type String

MobilePhone

Property Value
Description Type the mobile phone number for the contact.
DisplayName Mobile Phone
FormatName Phone
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName mobilephone
MaxLength 50
RequiredLevel None
Type String

msa_managingpartnerid

Added by: Power Pages Runtime Core Dependencies Solution

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

msdyn_contactkpiid

Added by: Relationship analytics Solution

Property Value
Description Maps to contact KPI records
DisplayName KPI
IsValidForForm True
IsValidForRead True
LogicalName msdyn_contactkpiid
RequiredLevel None
Targets msdyn_contactkpiitem
Type Lookup

msdyn_decisioninfluencetag

Added by: LinkedInExtensions Solution

Property Value
Description Indicate buying influence using labels
DisplayName Decision influence labels
IsValidForForm True
IsValidForRead True
LogicalName msdyn_decisioninfluencetag
RequiredLevel None
Type Picklist

msdyn_decisioninfluencetag Choices/Options

Value Label Description
0 Decision maker
1 Influencer
2 Blocker
3 Unknown

msdyn_disablewebtracking

Added by: Portal Privacy Extensions Solution

Property Value
Description Indicates that the contact has opted out of web tracking.
DisplayName Disable Web Tracking
IsValidForForm True
IsValidForRead True
LogicalName msdyn_disablewebtracking
RequiredLevel None
Type Boolean

msdyn_disablewebtracking Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

msdyn_gdproptout

Added by: SI Common Solution

Property Value
Description Describes whether contact 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_isassistantinorgchart

Added by: LinkedInExtensions Solution

Property Value
Description Describes if the contact is an assistant in org chart
DisplayName Is Assistant
IsValidForForm True
IsValidForRead True
LogicalName msdyn_isassistantinorgchart
RequiredLevel None
Type Boolean

msdyn_isassistantinorgchart Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

msdyn_isminor

Added by: Portal Privacy Extensions Solution

Property Value
Description Indicates that the contact is considered a minor in their jurisdiction.
DisplayName Is Minor
IsValidForForm True
IsValidForRead True
LogicalName msdyn_isminor
RequiredLevel None
Type Boolean

msdyn_isminor Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

msdyn_isminorwithparentalconsent

Added by: Portal Privacy Extensions Solution

Property Value
Description Indicates that the contact is considered a minor in their jurisdiction and has parental consent.
DisplayName Is Minor with Parental Consent
IsValidForForm True
IsValidForRead True
LogicalName msdyn_isminorwithparentalconsent
RequiredLevel None
Type Boolean

msdyn_isminorwithparentalconsent Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

msdyn_orgchangestatus

Added by: LinkedInExtensions Solution

Property Value
Description Whether or not the contact belongs to the associated account
DisplayName Not at Company Flag
IsValidForForm True
IsValidForRead True
LogicalName msdyn_orgchangestatus
RequiredLevel None
Type Picklist

msdyn_orgchangestatus Choices/Options

Value Label Description
0 No Feedback
1 Not at Company
2 Ignore

msdyn_portaltermsagreementdate

Added by: Portal Privacy Extensions Solution

Property Value
DateTimeBehavior UserLocal
Description Indicates the date and time that the person agreed to the portal terms and conditions.
DisplayName Portal Terms Agreement Date
Format DateAndTime
IsValidForForm True
IsValidForRead True
LogicalName msdyn_portaltermsagreementdate
RequiredLevel None
Type DateTime

mspp_userpreferredlcid

Added by: Power Pages Runtime Extensions Solution

Property Value
Description User’s preferred portal language
DisplayName Preferred Language
IsValidForForm True
IsValidForRead True
LogicalName mspp_userpreferredlcid
RequiredLevel None
Type Picklist

mspp_userpreferredlcid Choices/Options

Value Label Description
1025 Arabic
1026 Bulgarian - Bulgaria
1027 Catalan - Catalan
1028 Chinese - Traditional
1029 Czech - Czech Republic
1030 Danish - Denmark
1031 German - Germany
1032 Greek - Greece
1033 English
1035 Finnish - Finland
1036 French - France
1037 Hebrew
1038 Hungarian - Hungary
1040 Italian - Italy
1041 Japanese - Japan
1042 Korean - Korea
1043 Dutch - Netherlands
1044 Norwegian (Bokmål) - Norway
1045 Polish - Poland
1046 Portuguese - Brazil
1048 Romanian - Romania
1049 Russian - Russia
1050 Croatian - Croatia
1051 Slovak - Slovakia
1053 Swedish - Sweden
1054 Thai - Thailand
1055 Turkish - Türkiye
1057 Indonesian - Indonesia
1058 Ukrainian - Ukraine
1060 Slovenian - Slovenia
1061 Estonian - Estonia
1062 Latvian - Latvia
1063 Lithuanian - Lithuania
1066 Vietnamese - Vietnam
1069 Basque - Basque
1081 Hindi - India
1086 Malay - Malaysia
1087 Kazakh - Kazakhstan
1110 Galician - Spain
2052 Chinese - China
2070 Portuguese - Portugal
2074 Serbian (Latin) - Serbia
3076 Chinese - Hong Kong SAR
3082 Spanish (Traditional Sort) - Spain
3098 Serbian (Cyrillic) - Serbia

NickName

Property Value
Description Type the contact's nickname.
DisplayName Nickname
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName nickname
MaxLength 100
RequiredLevel None
Type String

NumberOfChildren

Property Value
Description Type the number of children the contact has for reference in follow-up phone calls and other communications.
DisplayName No. of Children
Format None
IsValidForForm True
IsValidForRead True
LogicalName numberofchildren
MaxValue 1000000000
MinValue 0
RequiredLevel None
Type Integer

OriginatingLeadId

Added by: Lead Management Solution

Property Value
Description Shows the lead that the contact was created if the contact was created by converting a lead in Microsoft Dynamics 365. This is used to relate the contact to the data on the originating lead for use in reporting and analytics.
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

Pager

Property Value
Description Type the pager number for the contact.
DisplayName Pager
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName pager
MaxLength 50
RequiredLevel None
Type String

ParentCustomerId

Property Value
Description Select the parent account or parent contact for the contact to provide a quick link to additional details, such as financial information, activities, and opportunities.
DisplayName Company Name
IsValidForForm True
IsValidForRead True
LogicalName parentcustomerid
RequiredLevel None
Targets account,contact
Type Customer

ParentCustomerIdType

Property Value
Description
DisplayName Parent Customer Type
IsValidForForm False
IsValidForRead True
LogicalName parentcustomeridtype
RequiredLevel None
Type EntityName

ParticipatesInWorkflow

Property Value
Description Shows whether the contact participates in workflow rules.
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 contact'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 contact's preferred service to make sure services are scheduled correctly for the customer.
DisplayName Preferred Service
IsValidForForm True
IsValidForRead True
LogicalName preferredserviceid
RequiredLevel None
Targets service
Type Lookup

PreferredSystemUserId

Property Value
Description Choose the regular or preferred customer service representative for reference when scheduling service activities for the contact.
DisplayName Preferred User
IsValidForForm True
IsValidForRead True
LogicalName preferredsystemuserid
RequiredLevel None
Targets systemuser
Type Lookup

ProcessId

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

Salutation

Property Value
Description Type the salutation of the contact to make sure the contact is addressed correctly in sales calls, email messages, and marketing campaigns.
DisplayName Salutation
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName salutation
MaxLength 100
RequiredLevel None
Type String

ShippingMethodCode

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

ShippingMethodCode Choices/Options

Value Label Description
1 Default Value

SLAId

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

SpousesName

Property Value
Description Type the name of the contact's spouse or partner for reference during calls, events, or other communications with the contact.
DisplayName Spouse/Partner Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName spousesname
MaxLength 100
RequiredLevel None
Type String

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 contact is active or inactive. Inactive contacts 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 contact'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

SubscriptionId

Property Value
Description For internal use only.
DisplayName Subscription
IsValidForForm False
IsValidForRead False
IsValidForUpdate False
LogicalName subscriptionid
RequiredLevel None
Type Uniqueidentifier

Suffix

Property Value
Description Type the suffix used in the contact's name, such as Jr. or Sr. to make sure the contact is addressed correctly in sales calls, email, and marketing campaigns.
DisplayName Suffix
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName suffix
MaxLength 10
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 contact.
DisplayName Business 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 contact.
DisplayName Home 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 contact.
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 contact for use in segmentation and analysis.
DisplayName Territory
IsValidForForm True
IsValidForRead True
LogicalName territorycode
RequiredLevel None
Type Picklist

TerritoryCode Choices/Options

Value Label Description
1 Default Value

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 contact's professional or personal website or blog URL.
DisplayName Website
FormatName Url
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName websiteurl
MaxLength 200
RequiredLevel None
Type String

YomiFirstName

Property Value
Description Type the phonetic spelling of the contact's first name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the contact.
DisplayName Yomi First Name
FormatName PhoneticGuide
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName yomifirstname
MaxLength 150
RequiredLevel None
Type String

YomiLastName

Property Value
Description Type the phonetic spelling of the contact's last name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the contact.
DisplayName Yomi Last Name
FormatName PhoneticGuide
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName yomilastname
MaxLength 150
RequiredLevel None
Type String

YomiMiddleName

Property Value
Description Type the phonetic spelling of the contact's middle name, if the name is specified in Japanese, to make sure the name is pronounced correctly in phone calls with the contact.
DisplayName Yomi Middle Name
FormatName PhoneticGuide
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName yomimiddlename
MaxLength 150
RequiredLevel None
Type String

Read-only columns/attributes

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

AccountId

Property Value
Description Unique identifier of the account with which the contact is associated.
DisplayName Account
IsValidForForm False
IsValidForRead True
LogicalName accountid
RequiredLevel None
Targets account
Type Lookup

AccountIdName

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

AccountIdYomiName

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

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

Address3_Composite

Property Value
Description Shows the complete third address.
DisplayName Address 3
Format TextArea
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName address3_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 Shows the Aging 30 field converted to the system's default base currency. The calculations use the exchange rate specified in the Currencies area.
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 Shows the Aging 60 field converted to the system's default base currency. The calculations use the exchange rate specified in the Currencies area.
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 Shows the Aging 90 field converted to the system's default base currency. The calculations use the exchange rate specified in the Currencies area.
DisplayName Aging 90 (Base)
IsValidForForm True
IsValidForRead True
LogicalName aging90_base
MaxValue 922337203685477
MinValue -922337203685477
Precision 4
PrecisionSource 2
RequiredLevel None
Type Money

AnnualIncome_Base

Property Value
Description Shows the Annual Income field converted to the system's default base currency. The calculations use the exchange rate specified in the Currencies area.
DisplayName Annual Income (Base)
IsValidForForm True
IsValidForRead True
LogicalName annualincome_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 field converted to the system's default base currency for reporting purposes. The calculations use the exchange rate specified in the Currencies area.
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

FullName

Property Value
Description Combines and shows the contact's first and last names so that the full name can be displayed in views and reports.
DisplayName Full Name
FormatName Text
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName fullname
MaxLength 160
RequiredLevel None
Type String

IsAutoCreate

Property Value
Description Information about whether the contact was auto-created when promoting an email or an appointment.
DisplayName Auto-created
IsValidForForm False
IsValidForRead False
LogicalName isautocreate
RequiredLevel None
Type Boolean

IsAutoCreate Choices/Options

Value Label Description
1 Yes
0 No

DefaultValue: 0

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

MasterContactIdName

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

MasterContactIdYomiName

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

MasterId

Property Value
Description Unique identifier of the master contact for merge.
DisplayName Master ID
IsValidForForm False
IsValidForRead True
LogicalName masterid
RequiredLevel None
Targets contact
Type Lookup

Merged

Property Value
Description Shows whether the account has been merged with a master contact.
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 last updated 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_contactkpiidName

Added by: Relationship analytics Solution

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName msdyn_contactkpiidname
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

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 Unique identifier of the business unit that owns the contact.
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 contact.
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 contact.
DisplayName Owning User
IsValidForForm False
IsValidForRead True
LogicalName owninguser
RequiredLevel None
Targets systemuser
Type Lookup

ParentContactId

Property Value
Description Unique identifier of the parent contact.
DisplayName Parent Contact
IsValidForForm False
IsValidForRead True
LogicalName parentcontactid
RequiredLevel None
Targets contact
Type Lookup

ParentContactIdName

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

ParentContactIdYomiName

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

ParentCustomerIdName

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

ParentCustomerIdYomiName

Property Value
Description
DisplayName
FormatName Text
IsLocalizable False
IsValidForForm False
IsValidForRead True
LogicalName parentcustomeridyominame
MaxLength 450
RequiredLevel ApplicationRequired
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

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 the contact 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 contact.
DisplayName Version Number
IsValidForForm False
IsValidForRead True
LogicalName versionnumber
MaxValue 9223372036854775807
MinValue -9223372036854775808
RequiredLevel None
Type BigInt

YomiFullName

Property Value
Description Shows the combined Yomi first and last names of the contact so that the full phonetic name can be displayed in views and reports.
DisplayName Yomi Full Name
FormatName PhoneticGuide
IsLocalizable False
IsValidForForm True
IsValidForRead True
LogicalName yomifullname
MaxLength 450
RequiredLevel None
Type String

One-To-Many Relationships

Listed by SchemaName.

contact_master_contact

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

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

account_primary_contact

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

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

contact_customer_contacts

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

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

lead_customer_contacts

Added by: Lead Management Solution

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

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

lead_parent_contact

Added by: Lead Management Solution

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

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

contact_BulkOperations

Added by: Marketing Solution

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

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

contact_CampaignResponses

Added by: Marketing Solution

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

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

CreatedContact_BulkOperationLogs

Added by: Marketing Solution

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

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

SourceContact_BulkOperationLogs

Added by: Marketing Solution

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

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

invoice_customer_contacts

Added by: Sales Solution

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

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

opportunity_customer_contacts

Added by: Sales Solution

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

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

order_customer_contacts

Added by: Sales Solution

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

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

quote_customer_contacts

Added by: Sales Solution

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

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

opportunity_parent_contact

Added by: Sales Solution

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

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

msdyn_msdyn_conversationparticipantinsights_contact_msdyn_User

Added by: Conversation Intelligence Solution

Same as the msdyn_msdyn_conversationparticipantinsights_contact_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_contact_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.

contact_master_contact

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

contact_customer_accounts

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

contact_customer_contacts

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

msa_contact_managingpartner

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

contact_originating_lead

Added by: Lead Management Solution

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

price_level_contacts

Added by: Product Management Solution

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

Many-To-Many Relationships

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

contactleads_association

IntersectEntityName: contactleads

Table 1

Property Value
IntersectAttribute contactid
IsCustomizable False
LogicalName contact
NavigationPropertyName contactleads_association
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:

Table 2

Property Value
LogicalName lead
IntersectAttribute leadid
NavigationPropertyName contactleads_association
AssociatedMenuConfiguration Behavior: DoNotDisplay
Group: Details
Label:
Order:

listcontact_association

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

BulkOperation_Contacts

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

CampaignActivity_Contacts

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

contactinvoices_association

See the contactinvoices_association many-to-many relationship for the invoice table/entity.

contactorders_association

See the contactorders_association many-to-many relationship for the salesorder table/entity.

contactquotes_association

See the contactquotes_association many-to-many relationship for the quote table/entity.

Dataverse table/entity reference
Web API Reference