File Descriptions

 

The data fields for each file are described on the following pages.  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

12

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

 

 

 

 

 

 

 

 

 

Transactions

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

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

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

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

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

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

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

001

6

cst com no

Yes

No

No

Anyone

No One

CNUM

002

9999

cst com

No

No

No

Anyone

No One

COMMENTS1