Keystroke Point of Sale Help


Customer Database Fields

Name - Type

Created - Double
LastChanged - Double
Number - Long - Indexed
Code - String * 20 - Indexed
Class - String * 20 - Indexed
WebID - String * 52 - Indexed
CompanyName - String * 40 - Indexed
LastName - String * 20 - Indexed
FirstName - String * 20
LookupName - String * 40 - Indexed
Salutation - String * 8
Title - String * 16
TaxNumber - String * 24
CustCategory - String * 8
Note - String * 40
Comment - Long
Phone - String * 24 - Indexed
Phone2 - String * 20
HomePhone - String * 16
CellPhone - String * 16
Fax - String * 16
eMail - String * 52
eMailAlt - String * 52
AltAddress - String * 32
Address - String * 32
City - String * 32
State - String * 4
Zip - String * 16 - Indexed
County - String * 24
Country - String * 24
TaxTable - String * 4
PriceTable - String * 4
Discount - Single
LastOpenInvoice - Double
AmountDue - Currency
BirthDay - Long
BirthDate - Long
ExpDate - Long
Age - Single
CreditLimit - Currency
PaymentNum - Long
SalesPerson - Long
Store - Long
SecurityLevel - Long
LastPurchase - Double
TotalPurchased - Currency
NumPurchases - Long
AvgPurchase - Currency
AvgProfit - Currency
LastPayment - Double
AvgPayDate - Long
OldFinanceDue - Currency
CurrentFinanceDue - Currency
OldFinanceDate - Double
GracePeriod - Long
StatementMethod - Long
- 0 = None
- 1 = Mail
- 2 = eMail
- 4 = Fax
Flags - Long
- 1 = Order # Required
- 2 = Online Customer
- 4 = Preferred Customer
UserLongInfo1 - String * 40
UserLongInfo2 - String * 40
UserDate1 - Long
UserDate2 - Long
UserNumber1 - Currency
UserNumber2 - Currency
UserShortInfo1 - String * 4
UserShortInfo2 - String * 4
UserInfo1 - String * 20
UserInfo2 - String * 20
UserFlags - Long
Reserved - String * 48

Keystroke Help Table Of Contents