Template: Customer Address
- Emma Greenwood
Analytics
Note: When the ‘Include Data’ checkbox is checked, the template is created with the existing customer address data. Otherwise the system creates a blank template to enter new customer addresses.
| Column Name | Required | Note |
|---|---|---|
CustomerID | X | This is not editable when editing existing customers. Must be unique when importing new customers. |
AddressName | X | |
AddressID | X | |
CustomerClass | X | |
AddressType | X | |
Address1 | ||
Address2 | ||
Address3 | ||
City | ||
State | ||
Zip | ||
Country | ||
Phone | ||
Fax | ||
AddressAttributeClass | (X) | This is required if attribute values are being imported. Attribute values cannot be imported without the Attribute Class property. |
SalesOrderSiteID | ||
SalesOrderCarrier | ||
SalesPersonID | ||
InsideSalesPersonID | ||
ItemAccess | X | |
AddressTaxClass | ||
FreightTerms | ||
SalesOrderFreightPrograms | X | |
CustomerAddressAttributes | Each customer address attribute is displayed as a column. If the customer address attribute is a list type, users can import new values, and these are added to the attribute list. Note that the Attribute Class must be provided when importing attribute values. |