BookmarkBookmark this page!
Dec 18, 2023

File Descriptions

The data fields for each file are described on the following pages. This is part one of two articles. It covers Item file and Customer file. Click on this link to see File Descriptions (Part 2).

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.
 

Field

Len

Name

Numeric

Decimal

Date

Display

Entry

DB Field Name

Item File

001

16

key

No

No

No

Anyone

Key Counter

KEY

002

30

name

No

No

No

Anyone

Key Counter

NAME

003

2

old loc

No

No

No

No One

No One

LOC

004

8

quantity

Yes

No

No

Anyone

Owner

QTY

005

8

quantity out

Yes

No

No

Anyone

Owner

QYOT

006

8

sell price

Yes

Yes

No

Anyone

Key Counter

SELL

007

6

deposit

Yes

Yes

No

Anyone

Key Counter

DEP

008

4

dmg wavier

Yes

No

No

Anyone

Key Counter

DMG

009

3

msg code

Yes

No

No

Anyone

Key Counter

Msg

010

10

user date

Yes

No

Yes

Anyone

Key Counter

SDATE

011

3

category

Yes

No

No

Anyone

Key Counter

Category

012

1

type

No

No

No

Anyone

Key Counter

TYPE

013

3

tax code

Yes

No

No

Anyone

Owner

Juris

014

15

instr file

No

No

No

Anyone

Key Counter

INST

015

5

fuel

No

No

No

Anyone

Key Counter

FUEL

016

10

link item

No

No

No

Anyone

Key Counter

ADDT

017

4

period hrs1

Yes

No

No

Anyone

Key Counter

PER1

018

4

period hrs2

Yes

No

No

Anyone

Key Counter

PER2

019

4

period hrs3

Yes

No

No

Anyone

Key Counter

PER3

020

4

period hrs4

Yes

No

No

Anyone

Key Counter

PER4

021

4

period hrs5

Yes

No

No

Anyone

Key Counter

PER5

022

4

period hrs6

Yes

No

No

Anyone

Key Counter

PER6

023

4

period hrs7

Yes

No

No

Anyone

Key Counter

PER7

024

4

period hrs8

Yes

No

No

Anyone

Key Counter

PER8

025

4

period hrs9

Yes

No

No

Anyone

Key Counter

PER9

026

4

period hrs10

Yes

No

No

Anyone

Key Counter

PER10

027

7

rate1

Yes

Yes

No

Anyone

Key Counter

RATE1

028

7

rate2

Yes

Yes

No

Anyone

Key Counter

RATE2

029

7

rate3

Yes

Yes

No

Anyone

Key Counter

RATE3

030

7

rate4

Yes

Yes

No

Anyone

Key Counter

RATE4

031

7

rate5

Yes

Yes

No

Anyone

Key Counter

RATE5

032

7

rate6

Yes

Yes

No

Anyone

Key Counter

RATE6

033

7

rate7

Yes

Yes

No

Anyone

Key Counter

RATE7

034

7

rate8

Yes

Yes

No

Anyone

Key Counter

RATE8

035

7

rate9

Yes

Yes

No

Anyone

Key Counter

RATE9

036

7

rate10

Yes

Yes

No

Anyone

Key Counter

RATE10

037

1

rate code

No

No

No

Anyone

Key Counter

RCOD

038

4

subrent

Yes

No

No

Anyone

Key Counter

SUBR

039

16

part number

No

No

No

Anyone

Key Counter

PartNumber

040

6

number

Yes

No

No

Anyone

System

NUM

041

16

manuf

No

No

No

Anyone

Key Counter

MANF

042

20

model #

No

No

No

Anyone

Key Counter

MODN

043

16

distributor

No

No

No

Anyone

Key Counter

DSTN

044

10

distr phone

Yes

No

No

Anyone

Key Counter

DSTP

045

4

reordr min

Yes

No

No

Anyone

Key Counter

RMIN

046

4

reordr max

Yes

No

No

Anyone

Key Counter

RMAX

047

30

user defined 1

No

No

No

Anyone

Key Counter

UserDefined1

048

30

user defined 2

No

No

No

Anyone

Key Counter

UserDefined2

049

6

meter out

Yes

No

No

Anyone

No One

MTOT

050

6

meter in

Yes

No

No

Anyone

No One

MTIN

051

3

miss rental

Yes

No

No

Anyone

No One

CALL

052

1

reservable

No

No

No

Anyone

Key Counter

RESB

053

1

reserved

No

No

No

Anyone

Owner

RESD

054

1

queueable

No

No

No

Anyone

Manager

QUEB

055

1

queued

No

No

No

Anyone

No One

QUED

056

6

prev cust #

Yes

No

No

Anyone

No One

SSN

057

6

customer #

Yes

No

No

Anyone

No One

CUSN

058

6

prev cntrt #

Yes

No

No

Anyone

No One

CNTR

059

10

pur date

Yes

No

Yes

Anyone

Key Counter

PURD

060

10

pur price

Yes

Yes

No

Anyone

Key Counter

PURP

061

1

depr meth

No

No

No

Anyone

Key Counter

DEPM

062

2

depr years

Yes

No

No

Anyone

Key Counter

DEPR

063

10

slvg value

Yes

Yes

No

Anyone

No One

SLVG

064

10

dep accrd

Yes

Yes

No

Anyone

No One

DEPA

065

10

cur depr

Yes

Yes

No

Anyone

No One

DEPP

066

10

cur value

Yes

Yes

No

Anyone

No One

CURV

067

10

date sold

Yes

No

Yes

Anyone

No One

SOLD

068

10

sold amt

Yes

Yes

No

Anyone

Owner

SAMT

069

10

income MTD

Yes

Yes

No

Key Counter

No One

INC1

070

10

income YTD

Yes

Yes

No

Key Counter

No One

INC2

071

10

income LTD

Yes

Yes

No

Key Counter

Owner

INC3

072

8

repair cst MTD

Yes

Yes

No

Anyone

Manager

REPC1

073

8

repair cst LTD

Yes

Yes

No

Anyone

Manager

REPC2

074

8

times out MTD

Yes

No

No

Key Counter

No One

TMOT1

075

8

times out YTD

Yes

No

No

Key Counter

No One

TMOT2

076

8

times out LTD

Yes

No

No

Key Counter

No One

TMOT3

077

5

hours out MTD

Yes

No

No

Key Counter

No One

HROT1

078

5

hours out YTD

Yes

No

No

Key Counter

No One

HROT2

079

5

hours out LTD

Yes

No

No

Key Counter

No One

HROT3

080

10

last date

Yes

No

Yes

Anyone

No One

LDATE

081

100

lookup

No

No

No

Anyone

Key Counter

LOOKUP

082

1

asset

No

No

No

Anyone

Key Counter

Asset

083

10

GL account

No

No

No

Anyone

Key Counter

GLAccount

084

10

deprc account

No

No

No

Anyone

Key Counter

DeprecAccount

085

3

home store

Yes

No

No

Anyone

Key Counter

HomeStore

086

3

current store

Yes

No

No

Anyone

Key Counter

CurrentStore

087

10

group

No

No

No

Anyone

Key Counter

Group

088

10

bin location

No

No

No

Anyone

Key Counter

Location

089

25

serial number

No

No

No

Anyone

Key Counter

SerialNumber

090

1

non-taxable

No

No

No

Anyone

Key Counter

Nontaxable

091

16

header

No

No

No

Anyone

Key Counter

Header

092

8

license

No

No

No

Anyone

Key Counter

License

093

6

case qty

Yes

No

No

Anyone

Key Counter

CaseQty

094

5

percentage

Yes

No

No

Anyone

Key Counter

ItemPercentage

095

10

model year

No

No

No

Anyone

Key Counter

ModelYear

096

8

retail price

Yes

Yes

No

Anyone

Manager

RetailPrice

097

8

extra deprec

Yes

Yes

No

Anyone

Manager

ExtraDepreciation

098

1

inactive

No

No

No

Anyone

Manager

Inactive

099

8

extra charges

Yes

Yes

No

Anyone

Manager

ExtraCharges

100

8

sell price A

Yes

No

No

Anyone

Manager

PriceLevelA

101

8

sell price B

Yes

No

No

Anyone

Manager

PriceLevelB

102

8

sell price C

Yes

No

No

Anyone

Manager

PriceLevelC

103

1

nondisc

No

No

No

Anyone

Manager

NonDiscountable

104

6

vendor 1

Yes

No

No

Anyone

Manager

VendorNumber1

105

6

vendor 2

Yes

No

No

Anyone

Manager

VendorNumber2

106

6

vendor 3

Yes

No

No

Anyone

Manager

VendorNumber3

107

8

qty on order

Yes

No

No

Anyone

No One

QuantityOnOrder

108

10

default sort

No

No

No

Anyone

Key Counter

Sort

109

1

no prt on cntr

No

No

No

Anyone

Key Counter

NoPrintOnContract

110

10

markup percent

Yes

Yes

No

Anyone

Manager

MarkupPercentage

111

20

order no 1

No

No

No

Anyone

Key Counter

OrderNumber1

112

20

order no 2

No

No

No

Anyone

Key Counter

OrderNumber2

113

20

order no 3

No

No

No

Anyone

Key Counter

OrderNumber3

114

10

clean delay

Yes

No

No

Anyone

Key Counter

CleaningDelay

115

1

require clean

No

No

No

Anyone

Key Counter

RequireCleaning

116

15

maint file

No

No

No

Anyone

Key Counter

MaintenanceFile

117

75

web link

No

No

No

Anyone

Key Counter

WebLink

118

8

subrent cost mtd

Yes

Yes

No

Anyone

Owner

SubrentCostMTD

119

8

subrent cost ytd

Yes

Yes

No

Anyone

Owner

SubrentCostYTD

120

8

subrent pending

Yes

No

No

Anyone

No One

SubrentPending

121

1

hide on web

No

No

No

Anyone

Manager

HideOnWebsite

122

20

GPS unit no

No

No

No

Anyone

Manager

GPSUnitNo

123

10

license expire

Yes

No

Yes

Anyone

Asst Manager

LicenseExpire

124

10

replace cost

Yes

Yes

No

Anyone

Manager

ReplacementCost

125

1

require cc

No

No

No

Anyone

Manager

RequireCreditCard

126

10

Warranty date

Yes

No

Yes

Anyone

Manager

WarrantyDate

127

30

vehicle type

No

No

No

Anyone

Anyone

VehicleType

128

20

vehicle EIN

No

No

No

Anyone

Anyone

VehicleEIN

129

100

description

No

No

No

Anyone

Anyone

DescriptionLong

130

8

weight

Yes

No

No

Anyone

Anyone

Weight

131

8

setup time

Yes

No

No

Anyone

Anyone

SetupTime

132

20

web group

No

No

No

Anyone

Anyone

WebGroup

133

3

department

Yes

No

No

Anyone

Anyone

Department

134

1

GL income

Yes

No

No

Anyone

Anyone

GLIncome

135

1

bulk item

Yes

No

No

Anyone

Anyone

BulkItem

136

7

GVWR

Yes

No

No

Anyone

Anyone

GVWR

137

6

critical level

Yes

No

No

Anyone

Key Counter

CriticalLevel

138

6

rental case

Yes

No

No

Anyone

Key Counter

RentalCase

139

1

used

No

No

No

Anyone

Key Counter

BoughtUsed

140

10

income dmg wvr

Yes

Yes

No

Owner

No One

IncomeDmgWvr

141

10

income itmperc

Yes

Yes

No

Owner

No One

IncomeItemPercent

142

7

qty count dif

Yes

No

No

Anyone

Key Counter

QtyCountDifference

143

1

suppress avail

No

No

No

Anyone

Key Counter

SuppressAvailCheck

 

Customer File

001

16

key

No

No

No

Anyone

Anyone

KEY

002

30

name

No

No

No

Anyone

Anyone

NAME

003

30

street

No

No

No

Anyone

Anyone

Address

004

30

address 2

No

No

No

Anyone

Anyone

Address2

005

26

city state

No

No

No

Anyone

Anyone

CITY

006

7

zip

No

No

No

Anyone

Anyone

ZIP

007

4

zip+4

Yes

No

No

Anyone

Anyone

ZIP4

008

16

dl no

No

No

No

Anyone

Anyone

DriversLicense

009

10

birthdate

Yes

No

Yes

Anyone

Anyone

Birthdate

010

25

employer

No

No

No

Anyone

Anyone

Employer

011

10

auto lic

No

No

No

No One

No One

AutoLicense

012

2

auto state

No

No

No

No One

No One

AutoState

013

10

home

Yes

No

No

Anyone

Anyone

Phone

014

10

work

Yes

No

No

Anyone

Anyone

WORK

015

10

mobile

Yes

No

No

Anyone

Anyone

MOBILE

016

10

fax

Yes

No

No

Anyone

Anyone

FAX

017

10

pager

Yes

No

No

Anyone

Anyone

PAGER

018

6

cust #

Yes

No

No

Anyone

No One

CNUM

019

10

opened

Yes

No

Yes

Anyone

No One

OpenDate

020

10

date

Yes

No

Yes

Anyone

No One

LastActive

021

7

prev cntrt

No

No

No

Anyone

No One

LastContract

022

10

crdt limit

Yes

Yes

No

Anyone

Manager

CreditLimit

023

1

status

No

No

No

Anyone

Manager

Status

024

1

restrict

No

No

No

Anyone

Key Counter

Restrictions

025

30

credit crd

No

No

No

Owner

Owner

CreditCard

026

30

other id

No

No

No

Anyone

Anyone

OTHERID

027

10

inc year

Yes

Yes

No

Anyone

No One

IncomeYear

028

10

inc life

Yes

Yes

No

Anyone

No One

IncomeLife

029

10

inc last year

Yes

Yes

No

Anyone

No One

IncomeLastYear

030

5

# of cntr

Yes

No

No

Anyone

No One

NumberContracts

031

3

tax code

No

No

No

Anyone

Anyone

TaxJuris

032

2

disc code

Yes

No

No

Anyone

Key Counter

Discount

033

4

type

Yes

No

No

Anyone

Anyone

Type

034

4

message

Yes

No

No

Anyone

Key Counter

Message

035

3

qty out

Yes

No

No

Anyone

No One

QtyOut

036

1

info

No

No

No

Anyone

Key Counter

ForceInfo

037

1

job po

No

No

No

Anyone

Key Counter

ForcePO

038

1

job id

No

No

No

Anyone

Key Counter

ForceJobId

039

1

dw

No

No

No

Anyone

Key Counter

DeleteDmgWvr

040

1

finance ch

No

No

No

Anyone

Key Counter

DeleteFinanceCharge

041

1

statement

No

No

No

Anyone

Key Counter

DeleteStatement

042

10

last pay

Yes

Yes

No

Anyone

No One

LastPayAmount

043

10

lst pay dt

Yes

No

Yes

Anyone

No One

LastPayDate

044

10

high bal

Yes

Yes

No

Anyone

No One

HighBalance

045

10

cur bal

Yes

Yes

No

Anyone

Owner

CurrentBalance

046

50

email

No

No

No

Anyone

Anyone

Email

047

5

salesman

Yes

No

No

Anyone

Manager

Salesman

048

1

item percent

No

No

No

Anyone

Key Counter

DeleteItemPercentage

049

1

force pickedup

No

No

No

Anyone

Anyone

ForcePickedUp

050

1

only authorize

No

No

No

Anyone

Anyone

OnlyAllowAuthorized

051

10

dl expire

Yes

No

Yes

Anyone

Anyone

DLExpire

052

30

contact

No

No

No

Anyone

Anyone

BillContact

053

10

bill phone

Yes

No

No

Anyone

Anyone

BillPhone

054

30

bill address

No

No

No

Anyone

Anyone

BillAddress1

055

30

bill address 2

No

No

No

Anyone

Anyone

BillAddress2

056

30

bill city, st

No

No

No

Anyone

Anyone

BillCityState

057

7

bill zip

No

No

No

Anyone

Anyone

BillZip

058

4

bill zip+4

Yes

No

No

Anyone

Anyone

BillZip4

059

20

tax id

No

No

No

Anyone

Key Counter

TaxId

060

20

tax exempt #

No

No

No

Anyone

Key Counter

TaxExemptNumber

061

10

tax # expire

Yes

No

Yes

Anyone

Key Counter

TaxExemptExpire

062

30

insurance #

No

No

No

Anyone

Key Counter

InsuranceNumber

063

10

insuran expire

Yes

No

Yes

Anyone

Key Counter

InsuranceExpire

064

1

statement fmt

Yes

No

No

Anyone

Key Counter

StatementFormat

065

1

statement prt

Yes

No

No

Anyone

Owner

StatementPrintTo

066

15

terms

No

No

No

Anyone

Key Counter

Terms

067

4

fc days

Yes

No

No

Anyone

Key Counter

FinanceChargeDays

068

14

SS#

No

No

No

Anyone

Key Counter

SocialSecurity

069

14

federal id

No

No

No

Anyone

Key Counter

FederalId

070

20

user defined 1

No

No

No

Anyone

Key Counter

UserDefined1

071

20

user defined 2

No

No

No

Anyone

Key Counter

UserDefined2

072

2

price level

Yes

No

No

Anyone

Store Mgr

PriceLevel

073

3

contr format

Yes

No

No

Anyone

Store Mgr

ContractFormat

074

10

age date

Yes

No

Yes

Anyone

Key Counter

AgeDate

075

1

no update cc

No

No

No

Anyone

Key Counter

NoUpdateCreditCard

076

3

heard about us

Yes

No

No

Anyone

Anyone

HeardAboutUs

077

1

Contract prt

Yes

No

No

Anyone

Anyone

ContractPrintTo

078

1

do not email

No

No

No

Anyone

Anyone

NoEmail

079

20

contractor no

No

No

No

Anyone

Key Counter

ContractorLicense

080

10

contractor exp

Yes

No

Yes

Anyone

Key Counter

ContractorExpire

081

1

website portal

No

No

No

Anyone

Store Mgr

WebsitePortal

082

1

month to month

No

No

No

Anyone

Store Mgr

MonthToMonth

083

4

pricing type

Yes

No

No

Anyone

Anyone

PricingType

084

4

group

No

No

No

Anyone

Key Counter

Group

085

200

cntr printout

No

No

No

Anyone

Key Counter

CustomerPrintOut



 

Related Articles

Was this article helpful?
Upload Files