Competitor table/entity reference (Microsoft Dynamics 365)

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

See also

Dataverse table/entity reference
Dataverse Web API Reference