Navigation:  Key Concepts > Marketing Tools > Export Customers >

Fields Available for Queries

Previous pageReturn to chapter overviewNext page

Account Number

Amount Owed

AR - Current Due Amount

AR - Over 30 Due Amount

AR - Over 60 Due Amount

AR - Over 90 Due Amount

Billing Address 1

Billing Address 2

Cashier ID

Cell Phone

City

Company

Country

Credit Amount

Credit Limit

Customer Category

Customer Type

Department Code (inventory)

Department Descriptions (inventory)

E-Mail Address

First Name

First Purchase Date

Invoice Cost

Invoice Date

Invoice Sales ID

Invoice Station Number

Invoice Total

Item Category

Item Date Sold

Item Description

Item SKU

Last Name

Last Purchase Date

Lookup Code

Message Code

Phone 1

Phone 2

Price Level

Sales ID

State

Tax Rate ID #

Total Purchases (Sales)

UD Field 1

UD Field 2

UD Field 3

UD Field 4

UD Field 5

UD Field 6

Zip