Competitor table/entity reference

Note

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

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

Added by: Sales Solution

Messages

Message	Web API Operation	SDK class or method
Associate	Associate and disassociate entities	AssociateRequest or Associate
Create	POST /competitors See Create	CreateRequest or Create
CreateMultiple	CreateMultiple	CreateMultipleRequest
Delete	DELETE /competitors(competitorid) See Delete	DeleteRequest or Delete
Disassociate	Associate and disassociate entities	DisassociateRequest or Disassociate
Retrieve	GET /competitors(competitorid) See Retrieve	RetrieveRequest or Retrieve
RetrieveMultiple	GET /competitors See Query Data	RetrieveMultipleRequest or RetrieveMultiple
Update	PATCH /competitors(competitorid) See Update	UpdateRequest or Update
UpdateMultiple	UpdateMultiple	UpdateMultipleRequest

Properties

Property	Value
CollectionSchemaName	Competitors
DisplayCollectionName	Competitors
DisplayName	Competitor
EntitySetName	competitors
IsBPFEntity	False
LogicalCollectionName	competitors
LogicalName	competitor
OwnershipType	OrganizationOwned
PrimaryIdAttribute	competitorid
PrimaryNameAttribute	name
SchemaName	Competitor

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

Address1_AddressTypeCode Choices/Options

Value	Label	Description
1	Default Value

Address1_City

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

Address1_Country

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

Address1_County

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

Address1_Fax

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

Address1_Latitude

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

Address1_Line1

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

Address1_Line2

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

Address1_Line3

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

Address1_Longitude

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

Address1_Name

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

Address1_PostalCode

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

Address1_PostOfficeBox

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

Address1_ShippingMethodCode

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

Address1_ShippingMethodCode Choices/Options

Value	Label	Description
1	Default Value

Address1_StateOrProvince

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

Address1_Telephone1

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

Address1_Telephone2

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

Address1_Telephone3

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

Address1_UPSZone

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

Address1_UTCOffset

Property	Value
Description	Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address.
DisplayName	Address 1: UTC Offset
Format	TimeZone
IsValidForForm	True
IsValidForRead	True
LogicalName	address1_utcoffset
MaxValue	1500
MinValue	-1500
RequiredLevel	None
Type	Integer

Address2_AddressId

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

Address2_AddressTypeCode

Property	Value
Description	Select the secondary address type.
DisplayName	Address 2: Address Type
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_addresstypecode
RequiredLevel	None
Type	Picklist

Address2_AddressTypeCode Choices/Options

Value	Label	Description
1	Default Value

Address2_City

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

Address2_Country

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

Address2_County

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

Address2_Fax

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

Address2_Latitude

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

Address2_Line1

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

Address2_Line2

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

Address2_Line3

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

Address2_Longitude

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

Address2_Name

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

Address2_PostalCode

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

Address2_PostOfficeBox

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

Address2_ShippingMethodCode

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

Address2_ShippingMethodCode Choices/Options

Value	Label	Description
1	Default Value

Address2_StateOrProvince

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

Address2_Telephone1

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

Address2_Telephone2

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

Address2_Telephone3

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

Address2_UPSZone

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

Address2_UTCOffset

Property	Value
Description	Select the time zone, or UTC offset, for this address so that other people can reference it when they contact someone at this address.
DisplayName	Address 2: UTC Offset
Format	TimeZone
IsValidForForm	True
IsValidForRead	True
LogicalName	address2_utcoffset
MaxValue	1500
MinValue	-1500
RequiredLevel	None
Type	Integer

CompetitorId

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

EntityImage

Added by: Active Solution Solution

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

ImportSequenceNumber

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

KeyProduct

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

msdyn_gdproptout

Added by: Predictive Opportunity Scoring Solution

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

msdyn_gdproptout Choices/Options

Value	Label	Description
1	Yes
0	No

DefaultValue: 0

Name

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

Opportunities

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

OverriddenCreatedOn

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

Overview

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

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
FormatName	Url
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	referenceinfourl
MaxLength	200
RequiredLevel	None
Type	String

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
MaxValue	100000000000000
MinValue	0
Precision	2
PrecisionSource	2
RequiredLevel	None
Type	Money

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
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	reportingquarter
MaxValue	1000000000
MinValue	0
RequiredLevel	None
Type	Integer

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
Format	None
IsValidForForm	True
IsValidForRead	True
LogicalName	reportingyear
MaxValue	1000000000
MinValue	0
RequiredLevel	None
Type	Integer

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
FormatName	TickerSymbol
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	stockexchange
MaxLength	20
RequiredLevel	None
Type	String

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
Format	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	strengths
MaxLength	2000
RequiredLevel	None
Type	Memo

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
Format	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	threats
MaxLength	2000
RequiredLevel	None
Type	Memo

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
FormatName	TickerSymbol
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	tickersymbol
MaxLength	10
RequiredLevel	None
Type	String

TimeZoneRuleVersionNumber

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

TransactionCurrencyId

Property	Value
Description	Choose the local currency for the record to make sure budgets are reported in the correct currency.
DisplayName	Currency
IsValidForForm	True
IsValidForRead	True
LogicalName	transactioncurrencyid
RequiredLevel	None
Targets	transactioncurrency
Type	Lookup

TraversedPath

Property	Value
Description	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
FormatName	Text
IsLocalizable	False
IsValidForForm	False
IsValidForRead	True
LogicalName	traversedpath
MaxLength	1250
RequiredLevel	None
Type	String

UTCConversionTimeZoneCode

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

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
Format	Text
IsLocalizable	False
IsValidForForm	True
IsValidForRead	True
LogicalName	weaknesses
MaxLength	2000
RequiredLevel	None
Type	Memo

WebSiteUrl

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

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
MaxValue	1000000000
MinValue	0
Precision	2
RequiredLevel	None
Type	Double

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

Read-only columns/attributes

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

• Address1_Composite
• Address2_Composite
• CreatedBy
• CreatedByName
• CreatedByYomiName
• CreatedOn
• CreatedOnBehalfBy
• CreatedOnBehalfByName
• CreatedOnBehalfByYomiName
• EntityImage_Timestamp
• EntityImage_URL
• EntityImageId
• ExchangeRate
• ModifiedBy
• ModifiedByName
• ModifiedByYomiName
• ModifiedOn
• ModifiedOnBehalfBy
• ModifiedOnBehalfByName
• ModifiedOnBehalfByYomiName
• OrganizationId
• OrganizationIdName
• ReportedRevenue_Base
• TransactionCurrencyIdName
• VersionNumber

Address1_Composite

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

Address2_Composite

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

CreatedBy

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

CreatedByName

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

CreatedByYomiName

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

CreatedOn

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

CreatedOnBehalfBy

Property	Value
Description	Shows who created the record on behalf of another user.
DisplayName	Created By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	createdonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

CreatedOnBehalfByName

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

CreatedOnBehalfByYomiName

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

EntityImage_Timestamp

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

EntityImage_URL

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

EntityImageId

Property	Value
Description
DisplayName
IsValidForForm	False
IsValidForRead	True
LogicalName	entityimageid
RequiredLevel	None
Type	Uniqueidentifier

ExchangeRate

Added by: Active Solution Solution

Property	Value
Description	Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
DisplayName	Exchange Rate
IsValidForForm	True
IsValidForRead	True
LogicalName	exchangerate
MaxValue	100000000000
MinValue	0.000000000001
Precision	12
RequiredLevel	None
Type	Decimal

ModifiedBy

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

ModifiedByName

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

ModifiedByYomiName

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

ModifiedOn

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

ModifiedOnBehalfBy

Property	Value
Description	Shows who last updated the record on behalf of another user.
DisplayName	Modified By (Delegate)
IsValidForForm	True
IsValidForRead	True
LogicalName	modifiedonbehalfby
RequiredLevel	None
Targets	systemuser
Type	Lookup

ModifiedOnBehalfByName

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

ModifiedOnBehalfByYomiName

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

OrganizationId

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

OrganizationIdName

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

ReportedRevenue_Base

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

TransactionCurrencyIdName

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

VersionNumber

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

One-To-Many Relationships

Listed by SchemaName.

competitor_opportunity_activities

Same as the competitor_opportunity_activities many-to-one relationship for the opportunityclose table/entity.

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

Many-To-Many Relationships

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

• opportunitycompetitors_association
• leadcompetitors_association
• competitorproduct_association
• competitorsalesliterature_association

opportunitycompetitors_association

See the opportunitycompetitors_association many-to-many relationship for the opportunity table/entity.

leadcompetitors_association

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

competitorproduct_association

IntersectEntityName: competitorproduct

Table 1

Property	Value
IntersectAttribute	competitorid
IsCustomizable	False
LogicalName	competitor
NavigationPropertyName	competitorproduct_association
AssociatedMenuConfiguration	Behavior: UseCollectionName Group: Sales Label: Order:

Table 2

Property	Value
LogicalName	product
IntersectAttribute	productid
NavigationPropertyName	competitorproduct_association
AssociatedMenuConfiguration	Behavior: UseCollectionName Group: Details Label: Order:

competitorsalesliterature_association

See the competitorsalesliterature_association many-to-many relationship for the salesliterature table/entity.

Related information

Dataverse table/entity reference
Web API Reference