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. |