Navigation:  Accounts Receivable > Technical References >   Customer table

Field names below are the typical field names shown on forms.
Some of these are slightly different than the actual field names in the underlying table. In particular, actual field names do not have embedded spaces and field names of logical fields such as IsActive are prefixed by ‘Is’.

 

Fields marked (d) will initially be set to the default values in the Customer Default table when a new Customer is inserted. Note that some default values in Customer Default such as City may also be blank.

 

CustomerID

Identifies the Customer.

 

CustomerSID

The surrogate key assigned by the system for this Customer. Usually not shown on forms.

 

Name

 

Address1

 

Address2

 

City(d)

 

State(d)

State or Province code. You can select it from the drop-down list of States/Provinces for this Country.

 

Zip/Postal

Postal mail code.

 

CountryID(d)

Specifies the Country. You can select it from the drop-down list of active Countries.

 

Country

This shows the Country name.

 

Phone

 

Fax

 

Email

E-mail address.

 

Website

URL for their website.

 

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.

 

Credit Limit(d)

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

 

Charge Interest(d)

This field determines the default interest charge status for Customer transactions.
Checked means charge interest.

Unchecked means do not charge interest.

 

Statement(d)

Checked means this Customer may be selected for Print Customer Statements.
Unchecked means this Customer could not be selected for Print Customer Statements.

 

Customer GroupID(d)

 

Their SupplierID

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

 

Price Class(d)

Sales module. Specifies the price class for this Customer.

 

Discount Code(d)

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

 

Preferred ShipToID

Sales module. Specifies the default ShipToID for new Sales Orders for this Customer.

 

ArSubledger AccountID(d)

Accounts Receivable Subledger Control Account.

 

CurrencyID

Determined by the CurrencyID of the Accounts Receivable Subledger Control Account. Visible when Currency Manager is installed.

 

ArBalance

Shows the current Accounts Receivable balance for this Customer.

 

Active

Checked means this Customer is Active.
Unchecked means this Customer is not Active.
Only Active Customers are presented in data entry lookup lists or available for Customer List maintenance.

 

Notes

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

 

OriginDate

The date when this Customer record was created.

 

OriginUserID

The UserID of the user who created this Customer record.

 

OriginTaskID

The TaskID of the task that created this Customer record.