Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Address and shipping information. Used to store additional addresses for an account or contact.
The following table lists the messages for the Address (CustomerAddress) table. Messages represent operations that can be performed on the table. They may also be events.
Name Is Event? |
Web API Operation | SDK for .NET |
---|---|---|
Associate Event: True |
Associate records | Associate records |
Create Event: True |
POST /customeraddressesSee Create |
Create records |
Delete Event: True |
DELETE /customeraddresses(customeraddressid)See Delete |
Delete records |
Disassociate Event: True |
Disassociate records | Disassociate records |
Retrieve Event: True |
GET /customeraddresses(customeraddressid)See Retrieve |
Retrieve records |
RetrieveMultiple Event: True |
GET /customeraddressesSee Query data |
Query data |
Update Event: True |
PATCH /customeraddresses(customeraddressid)See Update |
Update records |
Upsert Event: False |
PATCH /customeraddresses(customeraddressid)See Upsert a table row |
UpsertRequest |
The following table lists selected properties for the Address (CustomerAddress) table.
Property | Value |
---|---|
DisplayName | Address |
DisplayCollectionName | Addresses |
SchemaName | CustomerAddress |
CollectionSchemaName | CustomerAddresses |
EntitySetName | customeraddresses |
LogicalName | customeraddress |
LogicalCollectionName | customeraddresses |
PrimaryIdAttribute | customeraddressid |
PrimaryNameAttribute | name |
TableType | Standard |
OwnershipType | None |
These columns/attributes return true for either IsValidForCreate or IsValidForUpdate (usually both). Listed by SchemaName.
Property | Value |
---|---|
Description | Shows the number of the address, to indicate whether the address is the primary, secondary, or other address for the customer. |
DisplayName | Address Number |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | addressnumber |
RequiredLevel | None |
Type | Integer |
MaxValue | 1000000000 |
MinValue | 0 |
Property | Value |
---|---|
Description | Select the address type, such as primary or billing. |
DisplayName | Address Type |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | addresstypecode |
RequiredLevel | None |
Type | Picklist |
DefaultFormValue | -1 |
GlobalChoiceName | customeraddress_addresstypecode |
Value | Label |
---|---|
1 | Bill To |
2 | Ship To |
3 | Primary |
4 | Other |
Property | Value |
---|---|
Description | Type the city for the customer's address to help identify the location. |
DisplayName | City |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | city |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Active |
IsLocalizable | False |
MaxLength | 80 |
Property | Value |
---|---|
Description | Type the country or region for the customer's address. |
DisplayName | Country/Region |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | country |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Active |
IsLocalizable | False |
MaxLength | 80 |
Property | Value |
---|---|
Description | Type the county for the customer's address. |
DisplayName | County |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | county |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Active |
IsLocalizable | False |
MaxLength | 50 |
Property | Value |
---|---|
Description | Unique identifier of the customer address. |
DisplayName | Address |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | customeraddressid |
RequiredLevel | SystemRequired |
Type | Uniqueidentifier |
Property | Value |
---|---|
Description | Type the fax number associated with the customer's address. |
DisplayName | Fax |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | fax |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Inactive |
IsLocalizable | False |
MaxLength | 50 |
Property | Value |
---|---|
Description | Select the freight terms to make sure shipping charges are processed correctly. |
DisplayName | Freight Terms |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | freighttermscode |
RequiredLevel | None |
Type | Picklist |
DefaultFormValue | -1 |
GlobalChoiceName | customeraddress_freighttermscode |
Value | Label |
---|---|
1 | FOB |
2 | No Charge |
Property | Value |
---|---|
Description | Unique identifier of the data import or data migration that created this record. |
DisplayName | Import Sequence Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | importsequencenumber |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -2147483648 |
Property | Value |
---|---|
Description | Type the latitude value for the customer's address, for use in mapping and other applications. |
DisplayName | Latitude |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | latitude |
RequiredLevel | None |
Type | Double |
ImeMode | Disabled |
MaxValue | 90 |
MinValue | -90 |
Precision | 5 |
Property | Value |
---|---|
Description | Type the first line of the customer's address to help identify the location. |
DisplayName | Street 1 |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | line1 |
RequiredLevel | ApplicationRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Active |
IsLocalizable | False |
MaxLength | 250 |
Property | Value |
---|---|
Description | Type the second line of the customer's address. |
DisplayName | Street 2 |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | line2 |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Active |
IsLocalizable | False |
MaxLength | 250 |
Property | Value |
---|---|
Description | Type the third line of the customer's address. |
DisplayName | Street 3 |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | line3 |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Active |
IsLocalizable | False |
MaxLength | 250 |
Property | Value |
---|---|
Description | Type the longitude value for the customer's address, for use in mapping and other applications. |
DisplayName | Longitude |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | longitude |
RequiredLevel | None |
Type | Double |
ImeMode | Disabled |
MaxValue | 180 |
MinValue | -180 |
Precision | 5 |
Property | Value |
---|---|
Description | Type a descriptive name for the customer's address, such as Corporate Headquarters. |
DisplayName | Address Name |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | name |
RequiredLevel | ApplicationRequired |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 200 |
Property | Value |
---|---|
Description | Shows the type code of the customer record to indicate whether the address belongs to a customer account or contact. |
DisplayName | Object Type |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | objecttypecode |
RequiredLevel | SystemRequired |
Type | EntityName |
Property | Value |
---|---|
Description | Date and time that the record was migrated. |
DisplayName | Record Created On |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | overriddencreatedon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateOnly |
ImeMode | Inactive |
SourceTypeMask | 0 |
Property | Value |
---|---|
Description | Choose the customer's address. |
DisplayName | Parent |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | parentid |
RequiredLevel | SystemRequired |
Type | Lookup |
Targets | account, contact |
Property | Value |
---|---|
Description | |
DisplayName | Parent Object Type |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | parentidtypecode |
RequiredLevel | None |
Type | EntityName |
Property | Value |
---|---|
Description | Type the ZIP Code or postal code for the address. |
DisplayName | ZIP/Postal Code |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | postalcode |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Inactive |
IsLocalizable | False |
MaxLength | 20 |
Property | Value |
---|---|
Description | Type the post office box number of the customer's address. |
DisplayName | Post Office Box |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | postofficebox |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 20 |
Property | Value |
---|---|
Description | Type the name of the primary contact person for the customer's address. |
DisplayName | Address Contact |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | primarycontactname |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 150 |
Property | Value |
---|---|
Description | Select a shipping method for deliveries sent to this address. |
DisplayName | Shipping Method |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | shippingmethodcode |
RequiredLevel | None |
Type | Picklist |
DefaultFormValue | -1 |
GlobalChoiceName | customeraddress_shippingmethodcode |
Value | Label |
---|---|
1 | Airborne |
2 | DHL |
3 | FedEx |
4 | UPS |
5 | Postal Mail |
6 | Full Load |
7 | Will Call |
Property | Value |
---|---|
Description | Type the state or province of the customer's address. |
DisplayName | State/Province |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | stateorprovince |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Active |
IsLocalizable | False |
MaxLength | 50 |
Property | Value |
---|---|
Description | Type the primary phone number for the customer's address. |
DisplayName | Main Phone |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | telephone1 |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Inactive |
IsLocalizable | False |
MaxLength | 50 |
Property | Value |
---|---|
Description | Type a second phone number for the customer's address. |
DisplayName | Phone 2 |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | telephone2 |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Inactive |
IsLocalizable | False |
MaxLength | 50 |
Property | Value |
---|---|
Description | Type a third phone number for the customer's address. |
DisplayName | Telephone 3 |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | telephone3 |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Inactive |
IsLocalizable | False |
MaxLength | 50 |
Property | Value |
---|---|
Description | For internal use only. |
DisplayName | Time Zone Rule Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | timezoneruleversionnumber |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -1 |
Property | Value |
---|---|
Description | Choose the local currency for the record to make sure budgets are reported in the correct currency. |
DisplayName | Currency |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | transactioncurrencyid |
RequiredLevel | None |
Type | Lookup |
Targets | transactioncurrency |
Property | Value |
---|---|
Description | Type the UPS zone of the customer's address to make sure shipping charges are calculated correctly and deliveries are made promptly, if shipped by UPS. |
DisplayName | UPS Zone |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | upszone |
RequiredLevel | None |
Type | String |
Format | Text |
FormatName | Text |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 4 |
Property | Value |
---|---|
Description | Time zone code that was in use when the record was created. |
DisplayName | UTC Conversion Time Zone Code |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | utcconversiontimezonecode |
RequiredLevel | None |
Type | Integer |
MaxValue | 2147483647 |
MinValue | -1 |
Property | Value |
---|---|
Description | Select the time zone for the address. |
DisplayName | UTC Offset |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | utcoffset |
RequiredLevel | None |
Type | Integer |
MaxValue | 1500 |
MinValue | -1500 |
These columns/attributes return false for both IsValidForCreate and IsValidForUpdate. Listed by SchemaName.
Property | Value |
---|---|
Description | Shows the complete address. |
DisplayName | Address |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | composite |
RequiredLevel | None |
Type | Memo |
Format | TextArea |
FormatName | TextArea |
ImeMode | Auto |
IsLocalizable | False |
MaxLength | 1000 |
Property | Value |
---|---|
Description | Shows who created the record. |
DisplayName | Created By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
DisplayName | Created On |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
Property | Value |
---|---|
Description | Shows who created the record on behalf of another user. |
DisplayName | Created By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | createdonbehalfby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency. |
DisplayName | Exchange Rate |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | exchangerate |
RequiredLevel | None |
Type | Decimal |
ImeMode | Disabled |
MaxValue | 100000000000 |
MinValue | 1E-12 |
Precision | 12 |
SourceTypeMask | 0 |
Property | Value |
---|---|
Description | Shows who last updated the record. |
DisplayName | Modified By |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics 365 options. |
DisplayName | Modified On |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedon |
RequiredLevel | None |
Type | DateTime |
CanChangeDateTimeBehavior | False |
DateTimeBehavior | UserLocal |
Format | DateAndTime |
ImeMode | Inactive |
SourceTypeMask | 0 |
Property | Value |
---|---|
Description | Shows who last updated the record on behalf of another user. |
DisplayName | Modified By (Delegate) |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | modifiedonbehalfby |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. |
DisplayName | Owner |
IsValidForForm | True |
IsValidForRead | True |
LogicalName | ownerid |
RequiredLevel | ApplicationRequired |
Type | Owner |
Targets | systemuser, team |
Property | Value |
---|---|
Description | |
DisplayName | |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owneridtype |
RequiredLevel | SystemRequired |
Type | EntityName |
Property | Value |
---|---|
Description | Shows the business unit that the record owner belongs to. |
DisplayName | Owning Business Unit |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owningbusinessunit |
RequiredLevel | None |
Type | Lookup |
Targets | businessunit |
Property | Value |
---|---|
Description | Unique identifier of the user who owns the customer address. |
DisplayName | Owner |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | owninguser |
RequiredLevel | None |
Type | Lookup |
Targets | systemuser |
Property | Value |
---|---|
Description | Version number of the customer address. |
DisplayName | Version Number |
IsValidForForm | False |
IsValidForRead | True |
LogicalName | versionnumber |
RequiredLevel | None |
Type | BigInt |
MaxValue | 9223372036854775807 |
MinValue | -9223372036854775808 |
These relationships are many-to-one. Listed by SchemaName.
One-To-Many Relationship: account Account_CustomerAddress
Property | Value |
---|---|
ReferencedEntity | account |
ReferencedAttribute | accountid |
ReferencingAttribute | parentid |
ReferencingEntityNavigationPropertyName | parentid_account |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: Cascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: contact Contact_CustomerAddress
Property | Value |
---|---|
ReferencedEntity | contact |
ReferencedAttribute | contactid |
ReferencingAttribute | parentid |
ReferencingEntityNavigationPropertyName | parentid_contact |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: Cascade Merge: Cascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: systemuser lk_customeraddress_createdonbehalfby
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | createdonbehalfby |
ReferencingEntityNavigationPropertyName | createdonbehalfby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: systemuser lk_customeraddress_modifiedonbehalfby
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | modifiedonbehalfby |
ReferencingEntityNavigationPropertyName | modifiedonbehalfby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: systemuser lk_customeraddressbase_createdby
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | createdby |
ReferencingEntityNavigationPropertyName | createdby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: systemuser lk_customeraddressbase_modifiedby
Property | Value |
---|---|
ReferencedEntity | systemuser |
ReferencedAttribute | systemuserid |
ReferencingAttribute | modifiedby |
ReferencingEntityNavigationPropertyName | modifiedby |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: NoCascade Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
One-To-Many Relationship: transactioncurrency TransactionCurrency_CustomerAddress
Property | Value |
---|---|
ReferencedEntity | transactioncurrency |
ReferencedAttribute | transactioncurrencyid |
ReferencingAttribute | transactioncurrencyid |
ReferencingEntityNavigationPropertyName | transactioncurrencyid |
IsHierarchical | |
CascadeConfiguration | Archive: NoCascade Assign: NoCascade Delete: Restrict Merge: NoCascade Reparent: NoCascade RollupView: NoCascade Share: NoCascade Unshare: NoCascade |
These relationships are one-to-many. Listed by SchemaName.
Many-To-One Relationship: asyncoperation CustomerAddress_AsyncOperations
Property | Value |
---|---|
ReferencingEntity | asyncoperation |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | CustomerAddress_AsyncOperations |
IsCustomizable | False |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-To-One Relationship: bulkdeletefailure CustomerAddress_BulkDeleteFailures
Property | Value |
---|---|
ReferencingEntity | bulkdeletefailure |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | CustomerAddress_BulkDeleteFailures |
IsCustomizable | False |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-To-One Relationship: principalobjectattributeaccess customeraddress_principalobjectattributeaccess
Property | Value |
---|---|
ReferencingEntity | principalobjectattributeaccess |
ReferencingAttribute | objectid |
ReferencedEntityNavigationPropertyName | customeraddress_principalobjectattributeaccess |
IsCustomizable | False |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-To-One Relationship: processsession CustomerAddress_ProcessSessions
Property | Value |
---|---|
ReferencingEntity | processsession |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | CustomerAddress_ProcessSessions |
IsCustomizable | False |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: UseCollectionName Group: Details Label: MenuId: null Order: 110 QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Many-To-One Relationship: syncerror CustomerAddress_SyncErrors
Property | Value |
---|---|
ReferencingEntity | syncerror |
ReferencingAttribute | regardingobjectid |
ReferencedEntityNavigationPropertyName | CustomerAddress_SyncErrors |
IsCustomizable | True |
AssociatedMenuConfiguration | AvailableOffline: True Behavior: DoNotDisplay Group: Details Label: MenuId: null Order: QueryApi: null ViewId: 00000000-0000-0000-0000-000000000000 |
Dataverse table/entity reference
Dataverse Web API Reference
customeraddress
Events
Power BI DataViz World Championships
Feb 14, 4 PM - Mar 31, 4 PM
With 4 chances to enter, you could win a conference package and make it to the LIVE Grand Finale in Las Vegas
Learn moreTraining
Learning path
Use advance techniques in canvas apps to perform custom updates and optimization - Training
Use advance techniques in canvas apps to perform custom updates and optimization
Documentation
Contact table/entity reference (Microsoft Dataverse) - Power Apps
Includes schema information and supported messages for the Contact table/entity with Microsoft Dataverse.
Customer tables (account, contact, and customeraddress) (Microsoft Dataverse) - Power Apps
The account and contact tables are essential for identifying and managing customers, selling products and services, and providing superior service to the customers. A customer address table is used to store address and shipping information for a customer.
Account table/entity reference (Microsoft Dataverse) - Power Apps
Includes schema information and supported messages for the Account table/entity with Microsoft Dataverse.