Navigation:  Accounts Receivable > Technical References > ErrorIDs   Customer Import table

Fields marked * may NOT be left blank. All other fields may be left blank.
Fields marked (d) that are left blank will use the default values in the Customer Default table. Note that some default values in Customer Default such as City may also be blank.

 

CustomerID*

Identifies the Customer.

 

Name*

 

Address1

 

Address2

 

City(d)

 

State(d)

State or Province code.

 

Zip

Postal mail code.

 

CountryID(d)

 

Phone

 

Fax

 

Email

E-mail address.

 

Website

URL for their website.

 

CustomerGroupID(d)

 

ArSubledgerAccountID(d)

Accounts Receivable Subledger Control Account.

 

IsChargeInterest(d)

Specifies the initial default interest charge status for Customer transactions.
1 means charge interest. 0 means do not charge interest.

 

IsArStatementOpenItem(d)

1 means this Customer may be selected for Print Customer Statements.
0 means this Customer could not be selected for Print Customer Statements.

 

IsArStatementBalanceForward(d)

This field is currently unused.

 

Terms(d)

Specifies the standard Terms for this Customer’s transactions. A Terms entry here refers to the Terms table which specifies the Due Date for each Terms entry.

 

CreditLimit(d)

Sales module. This specifies the maximum Credit available to this Customer.

 

PriceClass(d)

Sales module. Specifies the price class for this Customer.

 

SalesDiscountCode(d)

Sales module. Specifies the line item sales discount code for this Customer.

 

TheirSupplierID

This is available to specify the SupplierID used by our Customer in referring to our account with them.

 

Notes

This Memo field is used for any supplementary information about this Customer.

 

OriginUserID

This field may be any UserID. When specified the OriginUserID of the imported Customer will be the specified value. When blank the OriginUserID of the imported Customer will be the UserID of the User running the Import task.

 

OriginTaskID

This field may be any TaskID value. When specified the OriginTaskID of the imported Customer will be the specified value. When blank the OriginTaskID of the imported Customer will be the TaskID of the Import task.

 

ErrorID

This field is used internally by the Import task. Do not insert any value into this field. Any value in this field will be ignored and written over.