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

Browser not supported