JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

Competitor

This is a table representing the Competitor entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the competitor.

Address1_AddressId String False

Unique identifier for address 1.

Address1_AddressTypeCode String False

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

Address1_City String False

City name for address 1.

Address1_Country String False

Country/region name for address 1.

Address1_County String False

County name for address 1.

Address1_Fax String False

Fax number for address 1.

Address1_Latitude Double False

Latitude for address 1.

Address1_Line1 String False

First line for entering address 1 information.

Address1_Line2 String False

Second line for entering address 1 information.

Address1_Line3 String False

Third line for entering address 1 information.

Address1_Longitude Double False

Longitude for address 1.

Address1_Name String False

Name to enter for address 1.

Address1_PostalCode String False

ZIP Code or postal code for address 1.

Address1_PostOfficeBox String False

Post office box number for address 1.

Address1_ShippingMethodCode String False

Method of shipment for address 1.

Address1_StateOrProvince String False

State or province for address 1.

Address1_Telephone1 String False

First telephone number associated with address 1.

Address1_Telephone2 String False

Second telephone number associated with address 1.

Address1_Telephone3 String False

Third telephone number associated with address 1.

Address1_UPSZone String False

United Parcel Service (UPS) zone for address 1.

Address1_UTCOffset Integer False

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

Address2_AddressId String False

Unique identifier for address 2.

Address2_AddressTypeCode String False

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

Address2_City String False

City name for address 2.

Address2_Country String False

Country/region name for address 2.

Address2_County String False

County name for address 2.

Address2_Fax String False

Fax number for address 2.

Address2_Latitude Double False

Latitude for address 2.

Address2_Line1 String False

First line for entering address 2 information.

Address2_Line2 String False

Second line for entering address 2 information.

Address2_Line3 String False

Third line for entering address 2 information.

Address2_Longitude Double False

Longitude for address 2.

Address2_Name String False

Name to enter for address 2.

Address2_PostalCode String False

ZIP Code or postal code for address 2.

Address2_PostOfficeBox String False

Post office box number for address 2.

Address2_ShippingMethodCode String False

Method of shipment for address 2.

Address2_StateOrProvince String False

State or province for address 2.

Address2_Telephone1 String False

First telephone number associated with address 2.

Address2_Telephone2 String False

Second telephone number associated with address 2.

Address2_Telephone3 String False

Third telephone number associated with address 2.

Address2_UPSZone String False

United Parcel Service (UPS) zone for address 2.

Address2_UTCOffset Integer False

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

CompetitorId String False

Unique identifier of the competitor.

CreatedBy_Id String True

Unique identifier of the user who created the competitor.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the competitor was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the competitor.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

ExchangeRate Double True

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

ImportSequenceNumber Integer False

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

KeyProduct String False

Key products of the competitor.

ModifiedBy_Id String True

Unique identifier of the user who last modified the competitor.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the competitor was last modified.

ModifiedOnBehalfBy_Id String True

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

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String False

Name of the competitor.

Opportunities String False

Competitive opportunities against the competitor.

OrganizationId_Id String True

Unique identifier of the associated organization.

OrganizationId_LogicalName String True

OrganizationId_Name String True

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

Overview String False

Summary description of the competitor.

ReferenceInfoUrl String False

URL for the Web site where reference information about the competitor is located.

ReportedRevenue Double False

Reported revenue for the competitor.

ReportedRevenue_Base Double True

Base currency equivalent of the reported revenue for the competitor.

ReportingQuarter Integer False

Fiscal year quarter for the competitor's business.

ReportingYear Integer False

Fiscal year for the competitor's business.

StockExchange String False

Stock exchange on which the competitor is listed.

Strengths String False

Strengths of the competitor.

Threats String False

Competitive threats posed by the competitor.

TickerSymbol String False

Stock exchange ticker symbol for the competitor.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the competitor.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UTCConversionTimeZoneCode Integer False

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

Weaknesses String False

Competitive weaknesses of the competitor.

WebSiteUrl String False

Web site URL for the competitor.

WinPercentage Double False

Percentage of opportunities that the competitor wins.

YomiName String False

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462