Keystroke Point of Sale Help


Vendor Database Fields

Name - Type

Created - Double
LastChanged - Double
Number - Long - Indexed
Code - String * 20 - Indexed
Class - String * 20 - Indexed
Rating - Long
CompanyName - String * 40 - Indexed
RepLastName - String * 20 - Indexed
RepFirstName - String * 20
LookupName - String * 40 - Indexed
CustomerNum - String * 20
VendCategory - String * 8
CustCategory - String * 8
Note - String * 40
Comment - Long
Phone - String * 24 - Indexed
Phone2 - String * 20
Fax - String * 16
eMail - String * 52
eMail2 - String * 52
WebSite - String * 40
AltAddress - String * 32
Address - String * 32
City - String * 32
State - String * 4
Zip - String * 16 - Indexed
County - String * 24
Country - String * 24
ShipAddress - String * 32
ShipCity - String * 32
ShipState - String * 4
ShipZip - String * 16
ShipCounty - String * 32
ShipCountry - String * 32
TaxTable - String * 4
TaxNumber - String * 24
AmountDue - Currency
CreditLimit - Currency
PaymentNum - Long
Terms - String * 20
Store - Long
SecurityLevel - Long
LastPurchase - Double
TotalPurchased - Currency
LastOpenOrder - Integer
AvgFillDate - Long
AvgFillRatioByItem - Long
AvgFillRatioByAmount - Long
Flags - Long
- 1 = No Open Orders
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