JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

CustomerAddress

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the customer address.

AddressNumber Integer False

Specifies which customer address is applicable.

AddressTypeCode String False

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

City String False

City name in the customer address.

Country String False

Country/region name in the customer address.

County String False

County name in the customer address.

CreatedBy_Id String True

Unique identifier of the user who created the customer address.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the customer address was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the customeraddress.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

CustomerAddressId String False

Unique identifier of the customer address.

ExchangeRate Double True

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

Fax String False

Fax number for the customer address.

FreightTermsCode String False

Freight terms for the customer address.

ImportSequenceNumber Integer False

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

Latitude Double False

Latitude for the customer 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 customer address.

ModifiedBy_Id String True

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

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the customer address was last modified.

ModifiedOnBehalfBy_Id String True

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

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String False

Name used to identify the customer address.

ObjectTypeCode String False

Type of entity with which the customer address is associated.

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

OwnerId_Id String True

Unique identifier of the user or team who owns the customer address.

OwnerId_LogicalName String True

OwnerId_Name String True

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the customer address.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the customer address.

OwningUser_LogicalName String True

OwningUser_Name String True

ParentId_Id String False

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

ParentId_LogicalName String False

ParentId_Name String False

PostalCode String False

ZIP Code or postal code in the customer address.

PostOfficeBox String False

Post office box number in the customer address.

PrimaryContactName String False

Name of the primary contact at the customer address.

ShippingMethodCode String False

Method of shipment for the customer address.

StateOrProvince String False

State or province in the customer address.

Telephone1 String False

First telephone number for the customer address.

Telephone2 String False

Second telephone number for the customer address.

Telephone3 String False

Third telephone number for the customer address.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the customeraddress.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UPSZone String False

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

UTCConversionTimeZoneCode Integer False

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

UTCOffset Integer False

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

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