/
Template: Customer

Template: Customer

Note: When the ‘Include Data’ checkbox is checked, the template is created with the existing customer data. Otherwise the system creates a blank template to enter new customers. 

Column Name

Required

Note

CustomerID

X

This is not editable when editing existing customers. Must be unique when importing new customers.

CustomerName

X


StatementName



CustomerClass

X


AttributeClass

 (X)

This is required if attribute values are being imported. Attribute values cannot be imported without the Attribute Class property.

InvoiceDeliveryMethod



Checkbook

X


Currency


The value defaults from the Customer Class if not provided.

Payment Terms

X


DiscountGracePeriod



DueDateGracePeriod



FullItemAccess



UseFavoritesFor



CreditLimitOption



CreditAmount



FinanceChargeOption



TaxClass



TradeDiscountMethod



TradeDiscountAmount



ParentCustomerID



Hold



Inactive



CustomerAttributes


Each customer attribute is displayed as a column. If the customer 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. 

Related content

Customer and Customer Address Import (UG)
Customer and Customer Address Import (UG)
More like this
File Import Templates
File Import Templates
Read with this
Template: Customer Address
Template: Customer Address
More like this
Template: Vendor
Template: Vendor
More like this
Customers List View
Customers List View
More like this
Template: Inventory Item
Template: Inventory Item
More like this