Fields Available for Queries |
  
|
Fields Available for Queries |
|
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