Export (0) Print
Expand All

Competitor Entity Metadata

[Applies to: Microsoft Dynamics CRM 2011]

The following information is for the competitor entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class name is Competitor.

To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.

In This Topic

Entity Metadata

The following table shows the metadata for the competitor entity.

 

Entity metadata property Value

OTC

123

EntityLogicalName

competitor

DisplayName

Competitor

DisplayCollectionName

Competitors

IsCustomizable

True

OwnershipType

OrganizationOwned

AutoRouteToOwnerQueue

False

CanBeInManyToMany

True

CanBePrimaryEntityInRelationship

True

CanBeRelatedEntityInRelationship

True

CanCreateAttributes

True

CanCreateCharts

True

CanCreateForms

True

CanCreateViews

True

CanModifyAdditionalSettings

True

CanTriggerWorkflow

True

IsActivity

False

IsActivityParty

False

IsAuditEnabled

False

IsAvailableOffline

True

IsChildEntity

False

IsConnectionsEnabled

canmodifyconnectionsettings

IsCustomEntity

False

IsDocumentManagementEnabled

False

IsDuplicateDetectionEnabled

True

IsEnabledForCharts

True

IsImportable

True

IsIntersect

False

IsMailMergeEnabled

False

IsManaged

True

IsMappable

True

IsReadingPaneEnabled

True

IsRenameable

True

IsValidForAdvancedFind

True

IsValidForQueue

False

IsVisibleInMobile

False

PrimaryIdAttribute

competitorid

PrimaryNameAttribute

name

ReportViewName

FilteredCompetitor

Description

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

Privilege Metadata

The following table shows the privilege metadata for the competitor entity.

 

PrivilegeName Id Type CanBeBasic CanBeDeep CanBeGlobal CanBeLocal

prvAppendCompetitor

055485b1-edac-4e48-a646-cb831562c9fd

Append

False

False

True

False

prvAppendToCompetitor

5b0a8dab-0659-4ce1-8442-3e5d078242fd

AppendTo

False

False

True

False

prvCreateCompetitor

8cb63518-5632-4448-9da5-453c0e096170

Create

False

False

True

False

prvDeleteCompetitor

7c6f6d68-70fa-480e-8d17-8d6c3140d191

Delete

False

False

True

False

prvReadCompetitor

36abb6e0-e112-4e60-a5db-d550f9672176

Read

False

False

True

False

prvWriteCompetitor

9797dcf9-f100-4598-b67a-72a061702626

Write

False

False

True

False

Attribute Metadata

The following table shows the attribute metadata for the competitor entity.

 

LogicalName SchemaName Type RequiredLevel IsValidForCreate IsValidForRead IsValidForUpdate CanBeSecuredForCreate CanBeSecuredForRead CanBeSecuredForUpdate IsCustomizable IsAuditEnabled IsManaged IsPrimaryId IsPrimaryName IsRenameable IsSecured IsValidForAdvancedFind DisplayName DeprecatedVersion Description

address1_addressid

Address1_AddressId

Uniqueidentifier

None

True

True

True

False

False

False

False

False

True

True

False

False

False

False

Address 1: ID

Unique identifier for address 1.

address1_addresstypecode

Address1_AddressTypeCode

Picklist

None

True

True

True

False

False

False

True

True

True

False

False

True

False

False

Address 1: Address Type

Type of address for address 1, such as billing, shipping, or primary address.

address1_city

Address1_City

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

City

City name for address 1.

address1_country

Address1_Country

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Country/Region

Country/region name for address 1.

address1_county

Address1_County

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 1: County

County name for address 1.

address1_fax

Address1_Fax

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 1: Fax

Fax number for address 1.

address1_latitude

Address1_Latitude

Double

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 1: Latitude

Latitude for address 1.

address1_line1

Address1_Line1

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Street 1

First line for entering address 1 information.

address1_line2

Address1_Line2

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Street 2

Second line for entering address 1 information.

address1_line3

Address1_Line3

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Street 3

Third line for entering address 1 information.

address1_longitude

Address1_Longitude

Double

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 1: Longitude

Longitude for address 1.

address1_name

Address1_Name

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 1: Name

Name to enter for address 1.

address1_postalcode

Address1_PostalCode

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

ZIP/Postal Code

ZIP Code or postal code for address 1.

address1_postofficebox

Address1_PostOfficeBox

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 1: Post Office Box

Post office box number for address 1.

address1_shippingmethodcode

Address1_ShippingMethodCode

Picklist

None

True

True

True

False

False

False

True

True

True

False

False

True

False

False

Address 1: Shipping Method

Method of shipment for address 1.

address1_stateorprovince

Address1_StateOrProvince

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

State/Province

State or province for address 1.

address1_telephone1

Address1_Telephone1

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 1: Telephone 1

First telephone number associated with address 1.

address1_telephone2

Address1_Telephone2

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 1: Telephone 2

Second telephone number associated with address 1.

address1_telephone3

Address1_Telephone3

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 1: Telephone 3

Third telephone number associated with address 1.

address1_upszone

Address1_UPSZone

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 1: UPS Zone

United Parcel Service (UPS) zone for address 1.

address1_utcoffset

Address1_UTCOffset

Integer

None

True

True

True

False

False

False

True

True

True

False

False

True

False

False

Address 1: UTC Offset

UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time.

address2_addressid

Address2_AddressId

Uniqueidentifier

None

True

True

True

False

False

False

False

False

True

True

False

False

False

False

Address 2: ID

Unique identifier for address 2.

address2_addresstypecode

Address2_AddressTypeCode

Picklist

None

True

True

True

False

False

False

True

True

True

False

False

True

False

False

Address 2: Address Type

Type of address for address 2, such as billing, shipping, or primary address.

address2_city

Address2_City

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: City

City name for address 2.

address2_country

Address2_Country

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: Country/Region

Country/region name for address 2.

address2_county

Address2_County

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: County

County name for address 2.

address2_fax

Address2_Fax

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: Fax

Fax number for address 2.

address2_latitude

Address2_Latitude

Double

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: Latitude

Latitude for address 2.

address2_line1

Address2_Line1

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: Street 1

First line for entering address 2 information.

address2_line2

Address2_Line2

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: Street 2

Second line for entering address 2 information.

address2_line3

Address2_Line3

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: Street 3

Third line for entering address 2 information.

address2_longitude

Address2_Longitude

Double

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: Longitude

Longitude for address 2.

address2_name

Address2_Name

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: Name

Name to enter for address 2.

address2_postalcode

Address2_PostalCode

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: ZIP/Postal Code

ZIP Code or postal code for address 2.

address2_postofficebox

Address2_PostOfficeBox

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: Post Office Box

Post office box number for address 2.

address2_shippingmethodcode

Address2_ShippingMethodCode

Picklist

None

True

True

True

False

False

False

True

True

True

False

False

True

False

False

Address 2: Shipping Method

Method of shipment for address 2.

address2_stateorprovince

Address2_StateOrProvince

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: State/Province

State or province for address 2.

address2_telephone1

Address2_Telephone1

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: Telephone 1

First telephone number associated with address 2.

address2_telephone2

Address2_Telephone2

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: Telephone 2

Second telephone number associated with address 2.

address2_telephone3

Address2_Telephone3

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: Telephone 3

Third telephone number associated with address 2.

address2_upszone

Address2_UPSZone

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Address 2: UPS Zone

United Parcel Service (UPS) zone for address 2.

address2_utcoffset

Address2_UTCOffset

Integer

None

True

True

True

False

False

False

True

True

True

False

False

True

False

False

Address 2: UTC Offset

UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time.

competitorid

CompetitorId

Uniqueidentifier

SystemRequired

True

True

False

False

False

False

True

False

True

True

False

True

False

True

Competitor

Unique identifier of the competitor.

createdby

CreatedBy

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Created By

Unique identifier of the user who created the competitor.

createdon

CreatedOn

DateTime

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Created On

Date and time when the competitor was created.

createdonbehalfby

CreatedOnBehalfBy

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Created By (Delegate)

Unique identifier of the delegate user who created the competitor.

exchangerate

ExchangeRate

Decimal

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Exchange Rate

Exchange rate for the currency associated with the competitor with respect to the base currency.

importsequencenumber

ImportSequenceNumber

Integer

None

True

True

False

False

False

False

True

True

True

False

False

True

False

True

Import Sequence Number

Unique identifier of the data import or data migration that created this record.

keyproduct

KeyProduct

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Key Product

Key products of the competitor.

modifiedby

ModifiedBy

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Modified By

Unique identifier of the user who last modified the competitor.

modifiedon

ModifiedOn

DateTime

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Modified On

Date and time when the competitor was last modified.

modifiedonbehalfby

ModifiedOnBehalfBy

Lookup

None

False

True

False

False

False

False

True

False

True

False

False

True

False

True

Modified By (Delegate)

Unique identifier of the delegate user who last modified the competitor.

name

Name

String

SystemRequired

True

True

True

False

False

False

True

True

True

False

True

True

False

True

Name

Name of the competitor.

opportunities

Opportunities

Memo

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Opportunity

Competitive opportunities against the competitor.

organizationid

OrganizationId

Lookup

SystemRequired

False

True

False

False

False

False

False

False

True

False

False

False

False

False

Organization

Unique identifier of the associated organization.

overriddencreatedon

OverriddenCreatedOn

DateTime

None

True

True

False

False

False

False

True

True

True

False

False

True

False

True

Record Created On

Date and time that the record was migrated.

overview

Overview

Memo

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Overview

Summary description of the competitor.

referenceinfourl

ReferenceInfoUrl

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Reference Info URL

URL for the website where reference information about the competitor is located.

reportedrevenue

ReportedRevenue

Money

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Reported Revenue

Reported revenue for the competitor.

reportedrevenue_base

ReportedRevenue_Base

Money

None

False

True

False

False

False

False

True

True

True

False

False

True

False

True

Reported Revenue (Base)

Base currency equivalent of the reported revenue for the competitor.

reportingquarter

ReportingQuarter

Integer

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Reporting Quarter

Fiscal year quarter for the competitor's business.

reportingyear

ReportingYear

Integer

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Reporting Year

Fiscal year for the competitor's business.

stockexchange

StockExchange

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Stock Exchange

Stock exchange on which the competitor is listed.

strengths

Strengths

Memo

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Strength

Strengths of the competitor.

threats

Threats

Memo

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Threat

Competitive threats posed by the competitor.

tickersymbol

TickerSymbol

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Ticker Symbol

Stock exchange ticker symbol for the competitor.

timezoneruleversionnumber

TimeZoneRuleVersionNumber

Integer

None

True

True

True

False

False

False

True

False

True

False

False

False

False

False

Time Zone Rule Version Number

For internal use only.

transactioncurrencyid

TransactionCurrencyId

Lookup

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Currency

Unique identifier of the currency associated with the competitor.

utcconversiontimezonecode

UTCConversionTimeZoneCode

Integer

None

True

True

True

False

False

False

True

False

True

False

False

False

False

False

UTC Conversion Time Zone Code

Time zone code that was in use when the record was created.

versionnumber

VersionNumber

BigInt

None

False

True

False

False

False

False

False

False

True

False

False

False

False

False

Version Number

Version number of the competitor.

weaknesses

Weaknesses

Memo

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Weakness

Competitive weaknesses of the competitor.

websiteurl

WebSiteUrl

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Web Site

Website URL for the competitor.

winpercentage

WinPercentage

Double

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Win Percentage

Percentage of opportunities that the competitor wins.

yominame

YomiName

String

None

True

True

True

False

False

False

True

True

True

False

False

True

False

True

Yomi Name

Pronunciation of the competitor name, written in phonetic hiragana or katakana characters.

One-to-Many Relationships

The following table shows the entities that are the referencing entity in a one-to-many relationship with the competitor entity.

 

Relationship schema name Referencing entity

Competitor_Annotation

annotation

Competitor_AsyncOperations

asyncoperation

Competitor_BulkDeleteFailures

bulkdeletefailure

competitor_addresses

competitoraddress

competitor_connections2

connection

competitor_connections1

connection

Competitor_DuplicateMatchingRecord

duplicaterecord

Competitor_DuplicateBaseRecord

duplicaterecord

competitor_opportunity_activities

opportunityclose

competitor_principalobjectattributeaccess

principalobjectattributeaccess

Competitor_ProcessSessions

processsession

userentityinstancedata_competitor

userentityinstancedata

Many-to-Many Relationships

The following table shows the many-to-many relationships for the competitor entity.

 

Relationship schema name Entity 1 Entity 2 Intersect entity name Early bound entity

competitorproduct_association

competitor

product

competitorproduct

CompetitorProduct

leadcompetitors_association

lead

competitor

leadcompetitors

LeadCompetitors

opportunitycompetitors_association

opportunity

competitor

opportunitycompetitors

OpportunityCompetitors

competitorsalesliterature_association

salesliterature

competitor

competitorsalesliterature

CompetitorSalesLiterature

For information about using intersect entities, see Retrieve Records for Many-To-Many Relationships Using Intersect Entities.

Many-to-One Relationships

The following table shows the entities that are the referenced entity in a many-to-one relationship with the competitor entity.

 

Relationship schema name Referenced entity

competitor

organization

competitor

systemuser

competitor

systemuser

competitor

systemuser

competitor

systemuser

competitor

transactioncurrency

See Also

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.

Community Additions

Show:
© 2014 Microsoft