Was this article helpful?
File Descriptions (Part 2)
The data fields for each file are described on the following pages. This article covers Transaction, Transaction items, Totals file, Register file, Next Numbers, Zip Code files, Item comments, and Customer Comments.
Click here to see File Descriptions (Part 1) .
The column headings are:
File - The name of the data file.
Field # - The Field # shows the order that the fields are defined within the record.
Length - The number of characters in the field.
Name - The field description that appears on the screen when the record is displayed.
Numeric - Numeric indicator. Yes, means this is a numeric field. Only numbers will be accepted during data entry. No, means that the field can contain any characters, either alphabetic or numeric.
Decimal - Yes is a numeric field and the data is displayed in decimal form.
Date - Yes is a date field.
Display - This column indicates who is allowed to view the data on the screen.
Entry - This column indicates who is allowed to enter data into the field from the keyboard.
DB field name- This column indicates the field name that is used in the database. This name is helpful when creating reports within Crystal Reports.
The codes for Entry and Display shown in the file descriptions are the default settings. These can be changed by the owner by selecting the “Data File Security” program from the Security Menu.
|
Transactions | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Field | Len | Name | Numeric | Decimal | Date | Display | Entry | DB Field Name | ||||
|
001 |
7 |
cntrt no |
Yes |
No |
No |
Anyone |
System |
CNTR | ||||
|
002 |
10 |
date |
Yes |
No |
Yes |
Anyone |
No One |
DATE | ||||
|
003 |
4 |
time |
Yes |
No |
No |
Anyone |
No One |
TIME | ||||
|
004 |
3 |
opr id |
Yes |
No |
No |
Anyone |
No One |
OPID | ||||
|
005 |
1 |
pay meth |
No |
No |
No |
Anyone |
No One |
PYMT | ||||
|
006 |
1 |
dep meth |
No |
No |
No |
Anyone |
No One |
DPMT | ||||
|
007 |
2 |
stat |
No |
No |
No |
Anyone |
No One |
STAT | ||||
|
008 |
6 |
cust # |
Yes |
No |
No |
Anyone |
No One |
CUSN | ||||
|
009 |
2 |
rentdisc |
Yes |
No |
No |
Anyone |
No One |
RDIS | ||||
|
010 |
10 |
dmg wvr |
Yes |
Yes |
No |
Anyone |
No One |
DMG | ||||
|
011 |
10 |
other |
Yes |
Yes |
No |
Anyone |
No One |
OTHR | ||||
|
012 |
10 |
rent amt |
Yes |
Yes |
No |
Anyone |
No One |
RENT | ||||
|
013 |
10 |
sale amt |
Yes |
Yes |
No |
Anyone |
No One |
SALE | ||||
|
014 |
10 |
tax amt |
Yes |
Yes |
No |
Anyone |
No One |
TAX | ||||
|
015 |
10 |
total amt |
Yes |
Yes |
No |
Anyone |
No One |
TOTL | ||||
|
016 |
10 |
amt paid |
Yes |
Yes |
No |
Anyone |
No One |
PAID | ||||
|
017 |
10 |
dep amt |
Yes |
Yes |
No |
Anyone |
No One |
DEPP | ||||
|
018 |
10 |
dep ref |
Yes |
Yes |
No |
Anyone |
No One |
DEPR | ||||
|
019 |
10 |
check no |
No |
No |
No |
Anyone |
No One |
CKN | ||||
|
020 |
10 |
dep ck no |
No |
No |
No |
Anyone |
No One |
DCKN | ||||
|
021 |
50 |
cntr info |
No |
No |
No |
Anyone |
No One |
JOBN | ||||
|
022 |
20 |
po number |
No |
No |
No |
Anyone |
No One |
JBPO | ||||
|
023 |
20 |
job number |
No |
No |
No |
Anyone |
No One |
JBID | ||||
|
024 |
3 |
taxcode |
No |
No |
No |
Anyone |
No One |
TAXC | ||||
|
025 |
3 |
store |
Yes |
No |
No |
Anyone |
Owner |
STR | ||||
|
026 |
2 |
saledisc |
No |
No |
No |
Anyone |
No One |
SDIS | ||||
|
027 |
10 |
mod date |
Yes |
No |
Yes |
Anyone |
No One |
CMDT | ||||
|
028 |
10 |
close date |
Yes |
No |
Yes |
Anyone |
No One |
CLDT | ||||
|
029 |
1 |
continue |
No |
No |
No |
Anyone |
Owner |
CONT | ||||
|
030 |
3 |
hold days |
No |
No |
No |
Anyone |
No One |
DAY | ||||
|
031 |
1 |
delivery |
No |
No |
No |
Anyone |
No One |
Delvr | ||||
|
032 |
10 |
completed date |
Yes |
No |
Yes |
Anyone |
No One |
Completed | ||||
|
033 |
10 |
billed date |
Yes |
No |
Yes |
Anyone |
No One |
Billed | ||||
|
034 |
1 |
Delv Confirmed |
No |
No |
No |
Anyone |
Key Counter |
DeliveryConfirmed | ||||
|
035 |
24 |
Delivery Date |
Yes |
No |
Yes |
Anyone |
Key Counter |
DeliveryDate | ||||
|
036 |
10 |
Delivery Trip |
No |
No |
No |
Anyone |
Key Counter |
DeliveryTrip | ||||
|
037 |
1 |
Pickup |
No |
No |
No |
Anyone |
Key Counter |
Pickup | ||||
|
038 |
1 |
Pickup Confirm |
No |
No |
No |
Anyone |
Key Counter |
PickupConfirmed | ||||
|
039 |
24 |
Pickup Date |
Yes |
No |
Yes |
Anyone |
Key Counter |
PickupDate | ||||
|
040 |
10 |
Pickup Trip |
No |
No |
No |
Anyone |
Key Counter |
PickupTrip | ||||
|
041 |
25 |
Contact |
No |
No |
No |
Anyone |
Key Counter |
Contact | ||||
|
042 |
10 |
Contact Phone |
Yes |
No |
No |
Anyone |
Key Counter |
ContactPhone | ||||
|
043 |
1 |
Same Address |
No |
No |
No |
Anyone |
Key Counter |
SameAddress | ||||
|
044 |
30 |
Delv Address |
No |
No |
No |
Anyone |
Key Counter |
DeliveryAddress | ||||
|
045 |
26 |
Delivery City |
No |
No |
No |
Anyone |
Key Counter |
DeliveryCity | ||||
|
046 |
7 |
Delivery Zip |
No |
No |
No |
Anyone |
Key Counter |
DeliveryZip | ||||
|
047 |
150 |
credit card |
No |
No |
No |
Anyone |
Anyone |
CardSwipe | ||||
|
048 |
1 |
nontaxable |
No |
No |
No |
Anyone |
Anyone |
Nontaxable | ||||
|
049 |
10 |
disc taken |
Yes |
Yes |
No |
Anyone |
Owner |
Discount | ||||
|
050 |
5 |
salesman |
Yes |
No |
No |
Anyone |
Key Counter |
Salesman | ||||
|
051 |
50 |
picked up by |
No |
No |
No |
Anyone |
Anyone |
PickedUpBy | ||||
|
052 |
30 |
picked up dl # |
No |
No |
No |
Anyone |
Anyone |
PickedUpDlNo | ||||
|
053 |
10 |
item percent |
Yes |
Yes |
No |
Anyone |
No One |
ItemPercentage | ||||
|
054 |
12 |
auto license |
No |
No |
No |
Anyone |
Anyone |
AutoLicense | ||||
|
055 |
1 |
dw exempt |
No |
No |
No |
Anyone |
Owner |
DamageWaiverExempt | ||||
|
056 |
1 |
itm prcnt exmt |
No |
No |
No |
Anyone |
Owner |
ItemPercentageExempt | ||||
|
057 |
2 |
price level |
Yes |
No |
No |
Anyone |
Manager |
PriceLevel | ||||
|
058 |
4 |
modification |
Yes |
No |
No |
Anyone |
No One |
Modification | ||||
|
059 |
24 |
event end date |
Yes |
No |
Yes |
Anyone |
No One |
EventEndDate | ||||
|
060 |
3 |
del truck no |
Yes |
No |
No |
Anyone |
Anyone |
DeliveryTruckNumber | ||||
|
061 |
3 |
pkup truck no |
Yes |
No |
No |
Anyone |
Anyone |
PickupTruckNumber | ||||
|
062 |
5 |
jobsite no |
Yes |
No |
No |
Anyone |
No One |
JobSite | ||||
|
063 |
50 |
del to company |
No |
No |
No |
Anyone |
Anyone |
DeliverToCompany | ||||
|
064 |
255 |
delivery notes |
No |
No |
No |
Anyone |
Anyone |
DeliveryNotes | ||||
|
065 |
100 |
verified addr |
No |
No |
No |
Anyone |
Owner |
VerifiedAddress | ||||
|
066 |
8 |
del setup time |
Yes |
No |
No |
Anyone |
Anyone |
DeliverySetupTime | ||||
|
067 |
8 |
pkup load time |
Yes |
No |
No |
Anyone |
Anyone |
PickupLoadTime | ||||
|
068 |
4 |
trans type |
Yes |
No |
No |
Anyone |
Anyone |
TransactionType | ||||
|
069 |
4 |
operation |
Yes |
No |
No |
Anyone |
Anyone |
Operation | ||||
|
070 |
8 |
delivery route |
Yes |
No |
No |
Anyone |
Anyone |
DeliveryRoute | ||||
|
071 |
8 |
pickup route |
Yes |
No |
No |
Anyone |
Anyone |
PickupRoute | ||||
|
072 |
24 |
promised delvr |
Yes |
No |
Yes |
Anyone |
Anyone |
DeliveryDatePromised | ||||
|
073 |
24 |
promised pckup |
Yes |
No |
Yes |
Anyone |
Anyone |
PickupDatePromised | ||||
|
074 |
1 |
last letter |
Yes |
No |
No |
Anyone |
Anyone |
LastLetter | ||||
|
075 |
24 |
letter date |
Yes |
No |
No |
Anyone |
Anyone |
LetterDate | ||||
|
076 |
1 |
posted to cash |
No |
No |
No |
Anyone |
Anyone |
PostedCash | ||||
|
077 |
1 |
posted accrual |
No |
No |
No |
Anyone |
Anyone |
PostedAccrual | ||||
|
078 |
3 |
currency numb |
Yes |
No |
No |
Anyone |
Anyone |
CurrencyNumber | ||||
|
079 |
10 |
exchange rate |
Yes |
No |
No |
Anyone |
Anyone |
ExchangeRate | ||||
|
080 |
3 |
discount table |
Yes |
No |
No |
Anyone |
Anyone |
DiscountTable | ||||
|
081 |
50 |
ordered by |
Yes |
No |
No |
Anyone |
Anyone |
OrderedBy | ||||
|
082 |
3 |
del crew count |
Yes |
No |
No |
Anyone |
Anyone |
DeliveryCrewCount | ||||
|
083 |
3 |
pkp crew count |
Yes |
No |
No |
Anyone |
Anyone |
PickupCrewCount | ||||
|
084 |
8 |
cmpt del setup |
Yes |
No |
No |
Anyone |
Anyone |
DeliverySetupTimeComputed | ||||
|
Transaction Items | ||||||||||||
| Field | Len | Name | Numeric | Decimal | Date | Display | Entry | DB Field Name | ||||
|
001 |
7 |
contract |
No |
No |
No |
Anyone |
No One |
CNTR | ||||
|
002 |
3 |
sub field |
Yes |
No |
No |
Anyone |
No One |
SUBF | ||||
|
003 |
6 |
item |
Yes |
No |
No |
Anyone |
No One |
ITEM | ||||
|
004 |
8 |
qty |
Yes |
No |
No |
Anyone |
No One |
QTY | ||||
|
005 |
4 |
hrs |
Yes |
No |
No |
Anyone |
No One |
HRSC | ||||
|
006 |
10 |
due dt |
Yes |
No |
Yes |
Anyone |
No One |
DDT | ||||
|
007 |
4 |
due tm |
Yes |
No |
No |
Anyone |
No One |
DTM | ||||
|
008 |
2 |
stat |
No |
No |
No |
Anyone |
No One |
TXTY | ||||
|
009 |
10 |
price |
Yes |
Yes |
No |
Anyone |
No One |
PRIC | ||||
|
010 |
30 |
descrip |
No |
No |
No |
Anyone |
No One |
Desc | ||||
|
011 |
100 |
comments |
No |
No |
No |
Anyone |
Anyone |
Comments | ||||
|
012 |
10 |
damage waiver |
Yes |
Yes |
No |
Anyone |
No One |
DmgWvr | ||||
|
013 |
10 |
item percent |
Yes |
Yes |
No |
Anyone |
No One |
ItemPercentage | ||||
|
014 |
10 |
disc % |
Yes |
Yes |
No |
Anyone |
No One |
DiscountPercent | ||||
|
015 |
1 |
nontaxable |
No |
No |
No |
Anyone |
No One |
Nontaxable | ||||
|
016 |
1 |
nondiscount |
No |
No |
No |
Anyone |
No One |
Nondiscount | ||||
|
017 |
1 |
letter sent |
No |
No |
No |
Anyone |
No One |
LetterSent | ||||
|
018 |
13 |
sort order |
No |
No |
No |
Anyone |
Owner |
Sort | ||||
|
019 |
10 |
disc amt |
Yes |
Yes |
No |
Anyone |
No One |
DiscountAmount | ||||
|
020 |
10 |
daily amt |
Yes |
Yes |
No |
Anyone |
No One |
DailyAmount | ||||
|
021 |
10 |
weekly amt |
Yes |
Yes |
No |
Anyone |
No One |
WeeklyAmount | ||||
|
022 |
10 |
monthly amt |
Yes |
Yes |
No |
Anyone |
No One |
MonthlyAmount | ||||
|
023 |
10 |
minimum amt |
Yes |
Yes |
No |
Anyone |
No One |
MinimumAmount | ||||
|
024 |
10 |
reading out |
Yes |
Yes |
No |
Anyone |
No One |
ReadingOut | ||||
|
025 |
10 |
reading in |
Yes |
Yes |
No |
Anyone |
No One |
ReadingIn | ||||
|
026 |
4 |
rain hours |
Yes |
No |
No |
Anyone |
No One |
RainHours | ||||
|
027 |
24 |
mod date |
Yes |
No |
Yes |
Anyone |
No One |
LastModified | ||||
|
028 |
10 |
retail price |
Yes |
Yes |
No |
Anyone |
No One |
RetailPrice | ||||
|
029 |
20 |
kit field |
No |
No |
No |
Anyone |
No One |
KitField | ||||
|
030 |
24 |
confirmed date |
Yes |
No |
Yes |
Anyone |
No One |
ConfirmedDate | ||||
|
031 |
10 |
subrental qty |
Yes |
Yes |
No |
Anyone |
No One |
SubrentalQuantity | ||||
|
032 |
3 |
substatus |
Yes |
No |
No |
Anyone |
No One |
Substatus | ||||
|
033 |
7 |
contract link |
No |
No |
Yes |
Anyone |
Owneer |
ContractLink | ||||
|
Totals File | ||||||||||||
| Field | Len | Name | Numeric | Decimal | Date | Display | Entry | DB Field Name | ||||
|
001 |
3 |
store |
Yes |
No |
No |
Key Counter |
Owner |
Store | ||||
|
002 |
3 |
juris |
Yes |
No |
No |
Key Counter |
Owner |
Juris | ||||
|
003 |
10 |
batch |
Yes |
No |
No |
Key Counter |
Owner |
Batch | ||||
|
004 |
11 |
rent tx |
Yes |
Yes |
No |
Key Counter |
Owner |
RTX | ||||
|
005 |
11 |
sales tx |
Yes |
Yes |
No |
Key Counter |
Owner |
STX | ||||
|
006 |
11 |
dw tx |
Yes |
Yes |
No |
Key Counter |
Owner |
DTX | ||||
|
007 |
11 |
asset tx |
Yes |
Yes |
No |
Key Counter |
Owner |
ATX | ||||
|
008 |
11 |
total tx |
Yes |
Yes |
No |
Key Counter |
No One |
TTX | ||||
|
009 |
11 |
rent nt |
Yes |
Yes |
No |
Key Counter |
Owner |
RUT | ||||
|
010 |
11 |
sales nt |
Yes |
Yes |
No |
Key Counter |
Owner |
SUT | ||||
|
011 |
11 |
dw nt |
Yes |
Yes |
No |
Key Counter |
Owner |
DUT | ||||
|
012 |
11 |
asset nt |
Yes |
Yes |
No |
Key Counter |
Owner |
AUT | ||||
|
013 |
11 |
total nt |
Yes |
Yes |
No |
Key Counter |
No One |
TUT | ||||
|
014 |
11 |
payments |
Yes |
Yes |
No |
Key Counter |
Owner |
PAY | ||||
|
015 |
11 |
charges |
Yes |
Yes |
No |
Key Counter |
Owner |
CHG | ||||
|
016 |
11 |
bank dep |
Yes |
Yes |
No |
Key Counter |
Owner |
BNK | ||||
|
017 |
11 |
total r/s |
Yes |
Yes |
No |
Key Counter |
No One |
TRS | ||||
|
018 |
11 |
total othr |
Yes |
Yes |
No |
Key Counter |
Owner |
TOT | ||||
|
019 |
11 |
total inc |
Yes |
Yes |
No |
Key Counter |
No One |
INC | ||||
|
020 |
11 |
tax collec |
Yes |
Yes |
No |
Key Counter |
Owner |
TAX | ||||
|
021 |
11 |
total w/tx |
Yes |
Yes |
No |
Key Counter |
No One |
ALL | ||||
|
022 |
11 |
disbursmts |
Yes |
Yes |
No |
Key Counter |
Owner |
DISB | ||||
|
023 |
11 |
credit cds |
Yes |
Yes |
No |
Key Counter |
Owner |
CRC | ||||
|
024 |
11 |
over/under |
Yes |
Yes |
No |
Key Counter |
Owner |
OVUN | ||||
|
025 |
11 |
added cash |
Yes |
Yes |
No |
Key Counter |
Owner |
CAD | ||||
|
026 |
11 |
pymts n/ad |
Yes |
Yes |
No |
Key Counter |
Owner |
PNA | ||||
|
027 |
11 |
deposits |
Yes |
Yes |
No |
Key Counter |
No One |
DEPS | ||||
|
028 |
10 |
date |
Yes |
No |
Yes |
Key Counter |
Owner |
Date | ||||
|
029 |
11 |
disc taken |
Yes |
Yes |
No |
Anyone |
Owner |
Discounts | ||||
|
030 |
11 |
debit cards |
Yes |
Yes |
No |
Anyone |
Owner |
DebitCards | ||||
|
031 |
11 |
itm percent tx |
Yes |
Yes |
No |
Key Counter |
Owner |
ItemPercentageTax | ||||
|
032 |
11 |
itm percent nt |
Yes |
Yes |
No |
Key Counter |
Owner |
ItemPercentageNonTax | ||||
|
033 |
11 |
fin chg tax |
Yes |
Yes |
No |
Key Counter |
Owner |
FinanceChargeTax | ||||
|
034 |
11 |
fin chg non |
Yes |
Yes |
No |
Key Counter |
Owner |
FinanceChargeNonTax | ||||
|
Register File | ||||||||||||
| File | Len | Name | Numeric | Decimal | Date | Display | Entry | DB Field Name | ||||
|
001 |
3 |
store |
No |
No |
No |
No One |
No One |
Store | ||||
|
002 |
8 |
begin drwr |
Yes |
Yes |
No |
Key Counter |
Owner |
BeginDrawer | ||||
|
003 |
8 |
cash |
Yes |
Yes |
No |
Key Counter |
Owner |
Cash | ||||
|
004 |
8 |
checks |
Yes |
Yes |
No |
Key Counter |
Owner |
Check | ||||
|
005 |
8 |
cards |
Yes |
Yes |
No |
Key Counter |
Owner |
CreditCard | ||||
|
006 |
8 |
debit cards |
Yes |
Yes |
No |
Anyone |
Owner |
DebitCard | ||||
|
007 |
8 |
curnt drwr |
Yes |
Yes |
No |
Key Counter |
Owner |
CurrentDrawer | ||||
|
008 |
8 |
active dep |
Yes |
Yes |
No |
Key Counter |
Owner |
ActiveDeposits | ||||
|
009 |
8 |
cur - dep |
Yes |
Yes |
No |
Key Counter |
No One |
AdjustedDrawer | ||||
|
010 |
8 |
visa |
Yes |
Yes |
No |
Key Counter |
Owner |
Visa | ||||
|
011 |
8 |
mastercard |
Yes |
Yes |
No |
Key Counter |
Owner |
Mastercard | ||||
|
012 |
8 |
Amex |
Yes |
Yes |
No |
Key Counter |
Owner |
Amex | ||||
|
013 |
8 |
Discover |
Yes |
Yes |
No |
Key Counter |
Owner |
Discover | ||||
|
014 |
8 |
other CC |
Yes |
Yes |
No |
Key Counter |
Owner |
OtherCC | ||||
|
Next Numbers | ||||||||||||
| Field | Len | Name | Numeric | Decimal | Date | Display | Entry | DB Field Name | ||||
|
001 |
6 |
next cntrt |
Yes |
No |
No |
Anyone |
Owner |
NXCT | ||||
|
002 |
6 |
next cust |
Yes |
No |
No |
Anyone |
Owner |
NXCU | ||||
|
003 |
6 |
next item |
Yes |
No |
No |
Anyone |
Owner |
NXIT | ||||
|
004 |
6 |
next repr |
Yes |
No |
No |
Anyone |
Owner |
NXCH | ||||
|
005 |
6 |
next paymt |
Yes |
No |
No |
Anyone |
Owner |
NXPY | ||||
|
006 |
6 |
next quote |
Yes |
No |
No |
Anyone |
Owner |
NXQT | ||||
|
007 |
6 |
next batch |
Yes |
No |
No |
Anyone |
Owner |
Batch | ||||
|
008 |
6 |
next credit |
Yes |
No |
No |
Anyone |
Owner |
Credit | ||||
|
009 |
6 |
next finance |
Yes |
No |
No |
Anyone |
Owner |
Finance | ||||
|
010 |
6 |
next po # |
Yes |
No |
No |
Anyone |
Owner |
PurchaseOrder | ||||
|
011 |
6 |
next work order # |
Yes |
No |
No |
Anyone |
Owner |
WorkOrder | ||||
|
012 |
6 |
next transfer # |
Yes |
No |
No |
Anyone |
Owner |
Transfer | ||||
|
013 |
6 |
next Subrental # |
Yes |
No |
No |
Anyone |
Owner |
Subrental | ||||
|
Zip Code File | ||||||||||||
| Field | Len | Name | Numeric | Decimal | Date | Display | Entry | DB Field Name | ||||
|
001 |
7 |
zip low |
No |
No |
No |
Anyone |
No One |
ZIP | ||||
|
002 |
7 |
zip hi |
No |
No |
No |
Anyone |
No One |
Zip_Hi | ||||
|
003 |
26 |
city state |
No |
No |
No |
Anyone |
No One |
City | ||||
|
Item Comments | ||||||||||||
| Field | Len | Name | Numeric | Decimal | Date | Display Enter | Entry | DB Field Name | ||||
|
001 |
6 |
itm com no |
Yes |
No |
No |
Anyone |
No One |
NUM | ||||
|
002 |
9999 |
Specs |
No |
No |
No |
Anyone |
No One |
Specs | ||||
|
003 |
9999 |
Print out |
No |
No |
No |
Anyone |
No One |
PrintOut | ||||
|
004 |
9999 |
Notes |
No |
No |
No |
Anyone |
No One |
Notes | ||||
|
Customer Comments | ||||||||||||
| Field | Len | Name | Numeric | Decimal | Date | Display | Entry | DB Field Name | ||||
|
001 |
6 |
cst com no |
Yes |
No |
No |
Anyone |
No One |
CNUM | ||||
|
002 |
9999 |
cst com |
No |
No |
No |
Anyone |
No One |
COMMENTS1 | ||||
Related Articles
File Descriptions (Part 1) Number of Views eCommerce | Customer Portal Setup Part 2 Number of Views Item File Number of Views Elite | Item File - Options Tab Number of Views File Management Overview in Elite Number of Views