SSIS Components for Microsoft Dynamics CRM

Build 24.0.9060

CompetitorAddress

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the competitor address.

AddressNumber Integer False

Information about which competitor address is applicable.

AddressTypeCode String False

Type of address for the competitor, such as primary address.

City String False

City name in the competitor address.

CompetitorAddressId String False

Unique identifier of the competitor address.

Country String False

Country/region name in the competitor address.

County String False

County name in the competitor address.

CreatedBy_Id String True

Unique identifier of the user who created the competitor address.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the competitor address was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the competitor address.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

Fax String False

Fax number for the competitor address.

Latitude Double False

Latitude for the competitor address.

Line1 String False

First line for entering address information.

Line2 String False

Second line for entering address information.

Line3 String False

Third line for entering address information.

Longitude Double False

Longitude for the address for the competitor.

ModifiedBy_Id String True

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

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the competitor address was last modified.

ModifiedOnBehalfBy_Id String True

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

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String False

Name used to identify the competitor address.

ParentId_Id String False

Unique identifier of the parent object with which the competitor address is associated.

ParentId_LogicalName String False

ParentId_Name String False

PostalCode String False

ZIP Code or postal code in the competitor address.

PostOfficeBox String False

Post office box number in the competitor address.

ShippingMethodCode String False

Method of shipment for the competitor.

StateOrProvince String False

State or province in the competitor address.

Telephone1 String False

First telephone number for the competitor address.

Telephone2 String False

Second telephone number for the competitor address.

Telephone3 String False

Third telephone number for the competitor address.

UPSZone String False

United Parcel Service (UPS) zone for the address of the competitor.

UTCOffset Integer False

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060