Competitor Address (CompetitorAddress) table/entity reference (Microsoft Dynamics 365)

2025-08-29

Additional addresses for a competitor. The first two addresses are stored in the competitor object.

Messages

The following table lists the messages for the Competitor Address (CompetitorAddress) table. Messages represent operations that can be performed on the table. They may also be events.

Name Is Event?	Web API Operation	SDK for .NET
`Associate` Event: True	Associate records	Associate records
`Disassociate` Event: True	Disassociate records	Disassociate records

Properties

The following table lists selected properties for the Competitor Address (CompetitorAddress) table.

Property	Value
DisplayName	Competitor Address
DisplayCollectionName	Competitor Addresses
SchemaName	`CompetitorAddress`
CollectionSchemaName	`CompetitorAddresses`
EntitySetName	`competitoraddresses`
LogicalName	`competitoraddress`
LogicalCollectionName	`competitoraddresses`
PrimaryIdAttribute	`competitoraddressid`
PrimaryNameAttribute	`name`
TableType	`Standard`
OwnershipType	`None`

Writable columns/attributes

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

AddressNumber
AddressTypeCode
City
CompetitorAddressId
Country
County
Fax
ImportSequenceNumber
Latitude
Line1
Line2
Line3
Longitude
Name
OverriddenCreatedOn
ParentId
PostalCode
PostOfficeBox
ShippingMethodCode
StateOrProvince
Telephone1
Telephone2
Telephone3
TimeZoneRuleVersionNumber
UPSZone
UTCConversionTimeZoneCode
UTCOffset

AddressNumber

Property	Value
Description	Information about which competitor address is applicable.
DisplayName	Address Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`addressnumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

AddressTypeCode

Property	Value
Description	Type of address for the competitor, such as primary address.
DisplayName	Address Type
IsValidForForm	False
IsValidForRead	True
LogicalName	`addresstypecode`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`competitoraddress_addresstypecode`

AddressTypeCode Choices/Options

Value	Label

City

Property	Value
Description	City name in the competitor address.
DisplayName	City
IsValidForForm	False
IsValidForRead	True
LogicalName	`city`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	80

CompetitorAddressId

Property	Value
Description	Unique identifier of the competitor address.
DisplayName	Competitor Address
IsValidForForm	False
IsValidForRead	True
LogicalName	`competitoraddressid`
RequiredLevel	SystemRequired
Type	Uniqueidentifier

Country

Property	Value
Description	Country/region name in the competitor address.
DisplayName	Country/Region
IsValidForForm	False
IsValidForRead	True
LogicalName	`country`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	80

County

Property	Value
Description	County name in the competitor address.
DisplayName	County
IsValidForForm	False
IsValidForRead	True
LogicalName	`county`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

Fax

Property	Value
Description	Fax number for the competitor address.
DisplayName	Fax
IsValidForForm	False
IsValidForRead	True
LogicalName	`fax`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

ImportSequenceNumber

Property	Value
Description	Sequence number of the import that created this record.
DisplayName	Import Sequence Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`importsequencenumber`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

Latitude

Property	Value
Description	Latitude for the competitor address.
DisplayName	Latitude
IsValidForForm	False
IsValidForRead	True
LogicalName	`latitude`
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	90
MinValue	-90
Precision	5

Line1

Property	Value
Description	First line for entering address information.
DisplayName	Street 1
IsValidForForm	False
IsValidForRead	True
LogicalName	`line1`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

Line2

Property	Value
Description	Second line for entering address information.
DisplayName	Street 2
IsValidForForm	False
IsValidForRead	True
LogicalName	`line2`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

Line3

Property	Value
Description	Third line for entering address information.
DisplayName	Street 3
IsValidForForm	False
IsValidForRead	True
LogicalName	`line3`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	250

Longitude

Property	Value
Description	Longitude for the address for the competitor.
DisplayName	Longitude
IsValidForForm	False
IsValidForRead	True
LogicalName	`longitude`
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	180
MinValue	-180
Precision	5

Name

Property	Value
Description	Name used to identify the competitor address.
DisplayName	Address Name
IsValidForForm	False
IsValidForRead	True
LogicalName	`name`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

OverriddenCreatedOn

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

ParentId

Property	Value
Description	Unique identifier of the parent object with which the competitor address is associated.
DisplayName	Parent
IsValidForForm	False
IsValidForRead	True
LogicalName	`parentid`
RequiredLevel	SystemRequired
Type	Lookup
Targets	competitor

PostalCode

Property	Value
Description	ZIP Code or postal code in the competitor address.
DisplayName	ZIP/Postal Code
IsValidForForm	False
IsValidForRead	True
LogicalName	`postalcode`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	20

PostOfficeBox

Property	Value
Description	Post office box number in the competitor address.
DisplayName	Post Office Box
IsValidForForm	False
IsValidForRead	True
LogicalName	`postofficebox`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	20

ShippingMethodCode

Property	Value
Description	Method of shipment for the competitor.
DisplayName	Shipping Method
IsValidForForm	False
IsValidForRead	True
LogicalName	`shippingmethodcode`
RequiredLevel	None
Type	Picklist
DefaultFormValue	-1
GlobalChoiceName	`competitoraddress_shippingmethodcode`

ShippingMethodCode Choices/Options

Value	Label

StateOrProvince

Property	Value
Description	State or province in the competitor address.
DisplayName	State/Province
IsValidForForm	False
IsValidForRead	True
LogicalName	`stateorprovince`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

Telephone1

Property	Value
Description	First telephone number for the competitor address.
DisplayName	Main Phone
IsValidForForm	False
IsValidForRead	True
LogicalName	`telephone1`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

Telephone2

Property	Value
Description	Second telephone number for the competitor address.
DisplayName	Phone 2
IsValidForForm	False
IsValidForRead	True
LogicalName	`telephone2`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

Telephone3

Property	Value
Description	Third telephone number for the competitor address.
DisplayName	Phone 3
IsValidForForm	False
IsValidForRead	True
LogicalName	`telephone3`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

TimeZoneRuleVersionNumber

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

UPSZone

Property	Value
Description	United Parcel Service (UPS) zone for the address of the competitor.
DisplayName	UPS Zone
IsValidForForm	False
IsValidForRead	True
LogicalName	`upszone`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	4

UTCConversionTimeZoneCode

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

UTCOffset

Property	Value
Description	UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time.
DisplayName	UTC Offset
IsValidForForm	False
IsValidForRead	True
LogicalName	`utcoffset`
RequiredLevel	None
Type	Integer
MaxValue	2147483647
MinValue	-2147483648

Read-only columns/attributes

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

Composite
CreatedBy
CreatedOn
CreatedOnBehalfBy
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
VersionNumber

Composite

Property	Value
Description	Shows the complete address.
DisplayName	Address
IsValidForForm	True
IsValidForRead	True
LogicalName	`composite`
RequiredLevel	None
Type	Memo
Format	TextArea
FormatName	TextArea
ImeMode	Auto
IsLocalizable	False
MaxLength	1000

CreatedBy

Property	Value
Description	Unique identifier of the user who created the competitor address.
DisplayName	Created By
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

CreatedOn

Property	Value
Description	Date and time when the competitor address was created.
DisplayName	Created On
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

CreatedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who created the competitor address.
DisplayName	Created By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	`createdonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedBy

Property	Value
Description	Unique identifier of the user who last modified the competitor address.
DisplayName	Modified By
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

ModifiedOn

Property	Value
Description	Date and time when the competitor address was last modified.
DisplayName	Modified On
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedon`
RequiredLevel	None
Type	DateTime
CanChangeDateTimeBehavior	False
DateTimeBehavior	UserLocal
Format	DateAndTime
ImeMode	Inactive
SourceTypeMask	0

ModifiedOnBehalfBy

Property	Value
Description	Unique identifier of the delegate user who last modified the competitor address.
DisplayName	Modified By (Delegate)
IsValidForForm	False
IsValidForRead	True
LogicalName	`modifiedonbehalfby`
RequiredLevel	None
Type	Lookup
Targets	systemuser

VersionNumber

Property	Value
Description	Version Number
DisplayName	Version Number
IsValidForForm	False
IsValidForRead	True
LogicalName	`versionnumber`
RequiredLevel	None
Type	BigInt
MaxValue	9223372036854775807
MinValue	-9223372036854775808

Many-to-One relationships

These relationships are many-to-one. Listed by SchemaName.

competitor_addresses
lk_competitoraddress_createdonbehalfby
lk_competitoraddress_modifiedonbehalfby
lk_competitoraddressbase_createdby
lk_competitoraddressbase_modifiedby

competitor_addresses

One-To-Many Relationship: competitor competitor_addresses

Property	Value
ReferencedEntity	`competitor`
ReferencedAttribute	`competitorid`
ReferencingAttribute	`parentid`
ReferencingEntityNavigationPropertyName	`parentid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `Cascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_competitoraddress_createdonbehalfby

One-To-Many Relationship: systemuser lk_competitoraddress_createdonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdonbehalfby`
ReferencingEntityNavigationPropertyName	`createdonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_competitoraddress_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_competitoraddress_modifiedonbehalfby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedonbehalfby`
ReferencingEntityNavigationPropertyName	`modifiedonbehalfby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_competitoraddressbase_createdby

One-To-Many Relationship: systemuser lk_competitoraddressbase_createdby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`createdby`
ReferencingEntityNavigationPropertyName	`createdby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

lk_competitoraddressbase_modifiedby

One-To-Many Relationship: systemuser lk_competitoraddressbase_modifiedby

Property	Value
ReferencedEntity	`systemuser`
ReferencedAttribute	`systemuserid`
ReferencingAttribute	`modifiedby`
ReferencingEntityNavigationPropertyName	`modifiedby`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

These relationships are one-to-many. Listed by SchemaName.

competitoraddress_AsyncOperations
competitoraddress_BulkDeleteFailures
competitoraddress_MailboxTrackingFolders
competitoraddress_PrincipalObjectAttributeAccesses
CompetitorAddress_SyncErrors

competitoraddress_AsyncOperations

Many-To-One Relationship: asyncoperation competitoraddress_AsyncOperations

Property	Value
ReferencingEntity	`asyncoperation`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`competitoraddress_AsyncOperations`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

competitoraddress_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure competitoraddress_BulkDeleteFailures

Property	Value
ReferencingEntity	`bulkdeletefailure`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`competitoraddress_BulkDeleteFailures`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

competitoraddress_MailboxTrackingFolders

Many-To-One Relationship: mailboxtrackingfolder competitoraddress_MailboxTrackingFolders

Property	Value
ReferencingEntity	`mailboxtrackingfolder`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`competitoraddress_MailboxTrackingFolders`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

competitoraddress_PrincipalObjectAttributeAccesses

Many-To-One Relationship: principalobjectattributeaccess competitoraddress_PrincipalObjectAttributeAccesses

Property	Value
ReferencingEntity	`principalobjectattributeaccess`
ReferencingAttribute	`objectid`
ReferencedEntityNavigationPropertyName	`competitoraddress_PrincipalObjectAttributeAccesses`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

CompetitorAddress_SyncErrors

Many-To-One Relationship: syncerror CompetitorAddress_SyncErrors

Property	Value
ReferencingEntity	`syncerror`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`CompetitorAddress_SyncErrors`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Feedback

Was this page helpful?