Competitor table/entity reference (Microsoft Dynamics 365)

2025-08-29

Business competing for the sale represented by a lead or opportunity.

Messages

The following table lists the messages for the Competitor 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
`Create` Event: True	`POST` /competitors See Create	Create records
`CreateMultiple` Event: True	CreateMultiple	CreateMultipleRequest
`Delete` Event: True	`DELETE` /competitors(competitorid) See Delete	Delete records
`Disassociate` Event: True	Disassociate records	Disassociate records
`Retrieve` Event: True	`GET` /competitors(competitorid) See Retrieve	Retrieve records
`RetrieveMultiple` Event: True	`GET` /competitors See Query data	Query data
`Update` Event: True	`PATCH` /competitors(competitorid) See Update	Update records
`UpdateMultiple` Event: True	UpdateMultiple	UpdateMultipleRequest
`Upsert` Event: False	`PATCH` /competitors(competitorid) See Upsert a table row	UpsertRequest
`UpsertMultiple` Event: False	UpsertMultiple	UpsertMultipleRequest

Properties

The following table lists selected properties for the Competitor table.

Property	Value
DisplayName	Competitor
DisplayCollectionName	Competitors
SchemaName	`Competitor`
CollectionSchemaName	`Competitors`
EntitySetName	`competitors`
LogicalName	`competitor`
LogicalCollectionName	`competitors`
PrimaryIdAttribute	`competitorid`
PrimaryNameAttribute	`name`
TableType	`Standard`
OwnershipType	`OrganizationOwned`

Writable columns/attributes

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

Address1_AddressId
Address1_AddressTypeCode
Address1_City
Address1_Country
Address1_County
Address1_Fax
Address1_Latitude
Address1_Line1
Address1_Line2
Address1_Line3
Address1_Longitude
Address1_Name
Address1_PostalCode
Address1_PostOfficeBox
Address1_ShippingMethodCode
Address1_StateOrProvince
Address1_Telephone1
Address1_Telephone2
Address1_Telephone3
Address1_UPSZone
Address1_UTCOffset
Address2_AddressId
Address2_AddressTypeCode
Address2_City
Address2_Country
Address2_County
Address2_Fax
Address2_Latitude
Address2_Line1
Address2_Line2
Address2_Line3
Address2_Longitude
Address2_Name
Address2_PostalCode
Address2_PostOfficeBox
Address2_ShippingMethodCode
Address2_StateOrProvince
Address2_Telephone1
Address2_Telephone2
Address2_Telephone3
Address2_UPSZone
Address2_UTCOffset
CompetitorId
EntityImage
ImportSequenceNumber
KeyProduct
msdyn_gdproptout
Name
Opportunities
OverriddenCreatedOn
Overview
ProcessId
ReferenceInfoUrl
ReportedRevenue
ReportingQuarter
ReportingYear
StageId
StockExchange
Strengths
Threats
TickerSymbol
TimeZoneRuleVersionNumber
TransactionCurrencyId
TraversedPath
UTCConversionTimeZoneCode
Weaknesses
WebSiteUrl
WinPercentage
YomiName

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
DefaultFormValue	1
GlobalChoiceName	`competitor_address1_addresstypecode`

Address1_AddressTypeCode Choices/Options

Value	Label
1	Default Value

Address1_City

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

Address1_Country

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

Address1_County

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

Address1_Fax

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

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`
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	90
MinValue	-90
Precision	5

Address1_Line1

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

Address1_Line2

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

Address1_Line3

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

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`
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	180
MinValue	-180
Precision	5

Address1_Name

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

Address1_PostalCode

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

Address1_PostOfficeBox

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

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
DefaultFormValue	1
GlobalChoiceName	`competitor_address1_shippingmethodcode`

Address1_ShippingMethodCode Choices/Options

Value	Label
1	Default Value

Address1_StateOrProvince

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

Address1_Telephone1

Property	Value
Description	Type the main phone number associated with the primary address.
DisplayName	Address 1: Telephone 1
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_telephone1`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	50

Address1_Telephone2

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

Address1_Telephone3

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

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
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_upszone`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	4

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
IsValidForForm	True
IsValidForRead	True
LogicalName	`address1_utcoffset`
RequiredLevel	None
Type	Integer
MaxValue	1500
MinValue	-1500

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
DefaultFormValue	1
GlobalChoiceName	`competitor_address2_addresstypecode`

Address2_AddressTypeCode Choices/Options

Value	Label
1	Default Value

Address2_City

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

Address2_Country

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

Address2_County

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

Address2_Fax

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

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`
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	90
MinValue	-90
Precision	5

Address2_Line1

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

Address2_Line2

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

Address2_Line3

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

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`
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	180
MinValue	-180
Precision	5

Address2_Name

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

Address2_PostalCode

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

Address2_PostOfficeBox

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

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
DefaultFormValue	1
GlobalChoiceName	`competitor_address2_shippingmethodcode`

Address2_ShippingMethodCode Choices/Options

Value	Label
1	Default Value

Address2_StateOrProvince

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

Address2_Telephone1

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

Address2_Telephone2

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

Address2_Telephone3

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

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
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_upszone`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	4

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
IsValidForForm	True
IsValidForRead	True
LogicalName	`address2_utcoffset`
RequiredLevel	None
Type	Integer
MaxValue	1500
MinValue	-1500

CompetitorId

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

EntityImage

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

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

KeyProduct

Property	Value
Description	Type the competitor's primary product, service, or specialty.
DisplayName	Key Product
IsValidForForm	True
IsValidForRead	True
LogicalName	`keyproduct`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	200

msdyn_gdproptout

Property	Value
Description	Describes whether competitor is opted out or not
DisplayName	GDPR Optout
IsValidForForm	True
IsValidForRead	True
LogicalName	`msdyn_gdproptout`
RequiredLevel	None
Type	Boolean
GlobalChoiceName	`msdyn_competitor_msdyn_gdproptout`
DefaultValue	False
True Label	Yes
False Label	No

Name

Property	Value
Description	Type the company or business name used to identify the competitor in data views and related records.
DisplayName	Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`name`
RequiredLevel	SystemRequired
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	100

Opportunities

Property	Value
Description	Type notes or other information about the competitive opportunities or selling points you can make.
DisplayName	Opportunity
IsValidForForm	True
IsValidForRead	True
LogicalName	`opportunities`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

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

Overview

Property	Value
Description	Type notes or other information about the competitor's business, such as location, revenue, or distribution channel.
DisplayName	Overview
IsValidForForm	True
IsValidForRead	True
LogicalName	`overview`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

ProcessId

Property	Value
Description	Contains the id of the process associated with the entity.
DisplayName	Process Id
IsValidForForm	False
IsValidForRead	True
LogicalName	`processid`
RequiredLevel	None
Type	Uniqueidentifier

ReferenceInfoUrl

Property	Value
Description	Type the URL for the website used to obtain reference information about the competitor.
DisplayName	Reference Info URL
IsValidForForm	True
IsValidForRead	True
LogicalName	`referenceinfourl`
RequiredLevel	None
Type	String
Format	Url
FormatName	Url
ImeMode	Auto
IsLocalizable	False
MaxLength	200

ReportedRevenue

Property	Value
Description	Type the amount of revenue reported in the competitor's annual report or other source.
DisplayName	Reported Revenue
IsValidForForm	True
IsValidForRead	True
LogicalName	`reportedrevenue`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	False
MaxValue	100000000000000
MinValue	0
Precision	2
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

ReportingQuarter

Property	Value
Description	Type the quarter number during which the competitor's reported revenue was recorded or announced for use in reporting and analysis.
DisplayName	Reporting Quarter
IsValidForForm	True
IsValidForRead	True
LogicalName	`reportingquarter`
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

ReportingYear

Property	Value
Description	Type the fiscal year during which the competitor's reported revenue was announced for use in reporting and analysis.
DisplayName	Reporting Year
IsValidForForm	True
IsValidForRead	True
LogicalName	`reportingyear`
RequiredLevel	None
Type	Integer
MaxValue	1000000000
MinValue	0

StageId

Property	Value
Description	Contains the id of the stage where the entity is located.
DisplayName	(Deprecated) Stage Id
IsValidForForm	False
IsValidForRead	True
LogicalName	`stageid`
RequiredLevel	None
Type	Uniqueidentifier

StockExchange

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

Strengths

Property	Value
Description	Type notes or other information about the competitor's strengths, such as top-selling products and targeted industries or markets.
DisplayName	Strength
IsValidForForm	True
IsValidForRead	True
LogicalName	`strengths`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

Threats

Property	Value
Description	Type notes or other information about the competitor's threats to your organization when you sell to the same prospect or customer.
DisplayName	Threat
IsValidForForm	True
IsValidForRead	True
LogicalName	`threats`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

TickerSymbol

Property	Value
Description	Type the stock exchange symbol for the competitor to track financial performance of the company. You can click the code entered in this field to access the latest trading information from MSN Money.
DisplayName	Ticker Symbol
IsValidForForm	True
IsValidForRead	True
LogicalName	`tickersymbol`
RequiredLevel	None
Type	String
Format	TickerSymbol
FormatName	TickerSymbol
ImeMode	Auto
IsLocalizable	False
MaxLength	10

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

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
Type	Lookup
Targets	transactioncurrency

TraversedPath

Property	Value
Description	A comma separated list of string values representing the unique identifiers of stages in a Business Process Flow Instance in the order that they occur.
DisplayName	(Deprecated) Traversed Path
IsValidForForm	False
IsValidForRead	True
LogicalName	`traversedpath`
RequiredLevel	None
Type	String
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	1250

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

Weaknesses

Property	Value
Description	Type notes or other information about the competitor's weaknesses or areas in which your organization outperforms the competitor.
DisplayName	Weakness
IsValidForForm	True
IsValidForRead	True
LogicalName	`weaknesses`
RequiredLevel	None
Type	Memo
Format	Text
FormatName	Text
ImeMode	Auto
IsLocalizable	False
MaxLength	2000

WebSiteUrl

Property	Value
Description	Type the website URL for the competitor.
DisplayName	Website
IsValidForForm	True
IsValidForRead	True
LogicalName	`websiteurl`
RequiredLevel	None
Type	String
Format	Url
FormatName	Url
ImeMode	Auto
IsLocalizable	False
MaxLength	200

WinPercentage

Property	Value
Description	Type the percentage of your organization's lost opportunities that are won by the competitor to identify your strongest competitors.
DisplayName	Win Percentage
IsValidForForm	True
IsValidForRead	True
LogicalName	`winpercentage`
RequiredLevel	None
Type	Double
ImeMode	Disabled
MaxValue	1000000000
MinValue	0
Precision	2

YomiName

Property	Value
Description	Type the phonetic spelling of the competitor's name, if specified in Japanese, to make sure the name is pronounced correctly in phone calls and other communications.
DisplayName	Yomi Name
IsValidForForm	True
IsValidForRead	True
LogicalName	`yominame`
RequiredLevel	None
Type	String
Format	PhoneticGuide
FormatName	PhoneticGuide
ImeMode	Auto
IsLocalizable	False
MaxLength	100

Read-only columns/attributes

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

Address1_Composite
Address2_Composite
CreatedBy
CreatedOn
CreatedOnBehalfBy
EntityImage_Timestamp
EntityImage_URL
EntityImageId
ExchangeRate
ModifiedBy
ModifiedOn
ModifiedOnBehalfBy
OrganizationId
ReportedRevenue_Base
VersionNumber

Address1_Composite

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

Address2_Composite

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

CreatedBy

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

CreatedOn

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

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
Type	Lookup
Targets	systemuser

EntityImage_Timestamp

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

EntityImage_URL

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

EntityImageId

Property	Value
Description
DisplayName
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`
RequiredLevel	None
Type	Decimal
ImeMode	Disabled
MaxValue	100000000000
MinValue	1E-12
Precision	12
SourceTypeMask	0

ModifiedBy

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

ModifiedOn

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

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
Type	Lookup
Targets	systemuser

OrganizationId

Property	Value
Description	Unique identifier for the organization
DisplayName	Organization Id
IsValidForForm	False
IsValidForRead	True
LogicalName	`organizationid`
RequiredLevel	SystemRequired
Type	Lookup
Targets	organization

ReportedRevenue_Base

Property	Value
Description	Value of the Reported Revenue in base currency.
DisplayName	Reported Revenue (Base)
IsValidForForm	True
IsValidForRead	True
LogicalName	`reportedrevenue_base`
RequiredLevel	None
Type	Money
ImeMode	Disabled
IsBaseCurrency	True
MaxValue	922337203685477
MinValue	-922337203685477
Precision	4
PrecisionSource	2 (TransactionCurrency.CurrencyPrecision)

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.

lk_competitor_createdonbehalfby
lk_competitor_modifiedonbehalfby
lk_competitorbase_createdby
lk_competitorbase_modifiedby
organization_competitors
processstage_competitors
transactioncurrency_competitor

lk_competitor_createdonbehalfby

One-To-Many Relationship: systemuser lk_competitor_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_competitor_modifiedonbehalfby

One-To-Many Relationship: systemuser lk_competitor_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_competitorbase_createdby

One-To-Many Relationship: systemuser lk_competitorbase_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_competitorbase_modifiedby

One-To-Many Relationship: systemuser lk_competitorbase_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`

organization_competitors

One-To-Many Relationship: organization organization_competitors

Property	Value
ReferencedEntity	`organization`
ReferencedAttribute	`organizationid`
ReferencingAttribute	`organizationid`
ReferencingEntityNavigationPropertyName	`organizationid`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

processstage_competitors

One-To-Many Relationship: processstage processstage_competitors

Property	Value
ReferencedEntity	`processstage`
ReferencedAttribute	`processstageid`
ReferencingAttribute	`stageid`
ReferencingEntityNavigationPropertyName	`stageid_processstage`
IsHierarchical
CascadeConfiguration	Archive: `NoCascade` Assign: `NoCascade` Delete: `NoCascade` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

transactioncurrency_competitor

One-To-Many Relationship: transactioncurrency transactioncurrency_competitor

Property	Value
ReferencedEntity	`transactioncurrency`
ReferencedAttribute	`transactioncurrencyid`
ReferencingAttribute	`transactioncurrencyid`
ReferencingEntityNavigationPropertyName	`transactioncurrencyid`
IsHierarchical
CascadeConfiguration	Archive: `Restrict` Assign: `NoCascade` Delete: `Restrict` Merge: `NoCascade` Reparent: `NoCascade` RollupView: `NoCascade` Share: `NoCascade` Unshare: `NoCascade`

One-to-Many relationships

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

competitor_addresses
Competitor_Annotation
Competitor_AsyncOperations
Competitor_BulkDeleteFailures
competitor_connections1
competitor_connections2
Competitor_DuplicateBaseRecord
Competitor_DuplicateMatchingRecord
competitor_MailboxTrackingFolders
competitor_opportunity_activities
competitor_PostFollows
competitor_PostRegardings
competitor_Posts
competitor_principalobjectattributeaccess
Competitor_ProcessSessions
Competitor_SyncErrors

competitor_addresses

Many-To-One Relationship: competitoraddress competitor_addresses

Property	Value
ReferencingEntity	`competitoraddress`
ReferencingAttribute	`parentid`
ReferencedEntityNavigationPropertyName	`competitor_addresses`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Competitor_Annotation

Many-To-One Relationship: annotation Competitor_Annotation

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

Competitor_AsyncOperations

Many-To-One Relationship: asyncoperation Competitor_AsyncOperations

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

Competitor_BulkDeleteFailures

Many-To-One Relationship: bulkdeletefailure Competitor_BulkDeleteFailures

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

competitor_connections1

Many-To-One Relationship: connection competitor_connections1

Property	Value
ReferencingEntity	`connection`
ReferencingAttribute	`record1id`
ReferencedEntityNavigationPropertyName	`competitor_connections1`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 100 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

competitor_connections2

Many-To-One Relationship: connection competitor_connections2

Property	Value
ReferencingEntity	`connection`
ReferencingAttribute	`record2id`
ReferencedEntityNavigationPropertyName	`competitor_connections2`
IsCustomizable	`True`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: 100 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Competitor_DuplicateBaseRecord

Many-To-One Relationship: duplicaterecord Competitor_DuplicateBaseRecord

Property	Value
ReferencingEntity	`duplicaterecord`
ReferencingAttribute	`baserecordid`
ReferencedEntityNavigationPropertyName	`Competitor_DuplicateBaseRecord`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Competitor_DuplicateMatchingRecord

Many-To-One Relationship: duplicaterecord Competitor_DuplicateMatchingRecord

Property	Value
ReferencingEntity	`duplicaterecord`
ReferencingAttribute	`duplicaterecordid`
ReferencedEntityNavigationPropertyName	`Competitor_DuplicateMatchingRecord`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

competitor_MailboxTrackingFolders

Many-To-One Relationship: mailboxtrackingfolder competitor_MailboxTrackingFolders

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

competitor_opportunity_activities

Many-To-One Relationship: opportunityclose competitor_opportunity_activities

Property	Value
ReferencingEntity	`opportunityclose`
ReferencingAttribute	`competitorid`
ReferencedEntityNavigationPropertyName	`competitor_opportunity_activities`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

competitor_PostFollows

Many-To-One Relationship: postfollow competitor_PostFollows

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

competitor_PostRegardings

Many-To-One Relationship: postregarding competitor_PostRegardings

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

competitor_Posts

Many-To-One Relationship: post competitor_Posts

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

competitor_principalobjectattributeaccess

Many-To-One Relationship: principalobjectattributeaccess competitor_principalobjectattributeaccess

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

Competitor_ProcessSessions

Many-To-One Relationship: processsession Competitor_ProcessSessions

Property	Value
ReferencingEntity	`processsession`
ReferencingAttribute	`regardingobjectid`
ReferencedEntityNavigationPropertyName	`Competitor_ProcessSessions`
IsCustomizable	`False`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Details` Label: MenuId: null Order: 110 QueryApi: null ViewId: `00000000-0000-0000-0000-000000000000`

Competitor_SyncErrors

Many-To-One Relationship: syncerror Competitor_SyncErrors

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

Many-to-Many relationships

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

competitorproduct_association
competitorsalesliterature_association
leadcompetitors_association
opportunitycompetitors_association

competitorproduct_association

See product competitorproduct_association Many-To-Many Relationship

Property	Value
IntersectEntityName	`competitorproduct`
IsCustomizable	False
SchemaName	`competitorproduct_association`
IntersectAttribute	`competitorid`
NavigationPropertyName	`competitorproduct_association`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Sales` Label: MenuId: null Order: QueryApi: `CRMCompetitor.RetrieveByObject` ViewId: `00000000-0000-0000-00aa-000010001206`

competitorsalesliterature_association

See salesliterature competitorsalesliterature_association Many-To-Many Relationship

Property	Value
IntersectEntityName	`competitorsalesliterature`
IsCustomizable	False
SchemaName	`competitorsalesliterature_association`
IntersectAttribute	`competitorid`
NavigationPropertyName	`competitorsalesliterature_association`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `DoNotDisplay` Group: `Details` Label: MenuId: null Order: QueryApi: `CRMCompetitor.RetrieveByObject` ViewId: `00000000-0000-0000-00aa-000010001206`

leadcompetitors_association

See lead leadcompetitors_association Many-To-Many Relationship

Property	Value
IntersectEntityName	`leadcompetitors`
IsCustomizable	False
SchemaName	`leadcompetitors_association`
IntersectAttribute	`competitorid`
NavigationPropertyName	`leadcompetitors_association`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Sales` Label: MenuId: null Order: 40 QueryApi: `CRMCompetitor.RetrieveByObject` ViewId: `00000000-0000-0000-00aa-000010001206`

opportunitycompetitors_association

See opportunity opportunitycompetitors_association Many-To-Many Relationship

Property	Value
IntersectEntityName	`opportunitycompetitors`
IsCustomizable	False
SchemaName	`opportunitycompetitors_association`
IntersectAttribute	`competitorid`
NavigationPropertyName	`opportunitycompetitors_association`
AssociatedMenuConfiguration	AvailableOffline: True Behavior: `UseCollectionName` Group: `Sales` Label: MenuId: null Order: 40 QueryApi: `CRMCompetitor.RetrieveByObject` ViewId: `00000000-0000-0000-00aa-000010001206`

Feedback

Was this page helpful?