Customers

 

 

Documentation for C:\H2OS\CL\H2OS\REALCUS.DBF

 

 

Table: C:\H2OS\CL\H2OS\REALCUS.DBF

Field Listing:

Name

Description

Type

Length

Dec

FILENO

FILE NUMBER. A UNIQUE NUMBER ASSIGNED TO EVERY CUSTOMER WHEN CUSTOMER REC IS CREATED

N

10

0

MATCHCODE

MATCH CODE IS USED FOR DUPLICATE DETECTION AND SORTING

C

15

0

RGC

RECORD GROUP CODE

C

1

0

ZIP

ZIP CODE

N

5

0

RTE

CARRIER ROUTE

N

4

0

RTEPREF

INTERNAL USE - USPS ASSIGNED CARRIER ROUTE NUMBER'S PREFIX

C

1

0

EXPDATE

NOT USED

D

8

0

CUSTKEY

LIST CODE. A 2 CHR CODE USED TO GROUP CUSTOMERS INTO "SUB-LISTS"

C

8

0

LTC

LABEL TITLE CODE, B = Business, 1 = Mr, 2 = Mrs, 3 = Miss, 4 = Mr & Mrs

C

1

0

LINE1

NAME - LINE 1, FORMATTED AS YOU WOULD WRITE IT.

C

35

0

LINE2

ADDRESS LINE 2

C

35

0

LINE3

ADDRESS LINE 3 (IF USED)

C

35

0

LINE4

ADDRESS LINE 4 (IF USED)

C

35

0

TOWN

TOWN NAME

C

19

0

STATE

STATE 2 CHARACTER CODE

C

2

0

OPERID

THE H2OS OPERATOR'S ID OF THE PERSON WHO LAST CHANGED THIS RECORD (SEE LUPDATE/LUPTIME)

C

4

0

AUDITCDE

CODE INDICATES TYPE OF CHANGE MADE TO CUSTOMER RECORD

N

2

0

LUPDATE

LAST UPDATE DATE

D

8

0

LUPTIME

TIME OF DAY THIS RECORD WAS LAST SAVED (SEE LUPDATE)

C

5

0

PAIDDATE

DATE SUBSCRIPTION PAID FROM

D

8

0

ONE

INTERNAL USE

N

5

0

ZIP4

ZIP+4 CODE

C

4

0

COUNTRY

COUNTRY CODE

C

3

0

PIECES

# PIECES TO BE SENT TO THIS SUBSCRIBER

N

3

0

MAILSW

YES MEANS A MAILING LABEL WILL BE PRINTED

L

1

0

VERSION

INTERNAL USE

N

4

0

DP

USED INTERNALLY FOR USPS DELIVERY POINT DATA

C

2

0

DPCK

USED INTERNALLY FOR USPS DELIVERY POINT CHECK DIGIT DATA

C

1

0

TERMCODE

INTERNAL USE

C

4

0

TYPECODE

TYPE OF RECORD FOR CASS

C

1

0

DELAD

INTERNAL USE FOR FORMATTING A DELIVERY ADDRESS

C

64

0

FIRMNAME

USED INTERNALLY TO STORE FIRM NAME, IF RECIPIENT NAME IS A FIRM

C

40

0

COUNTY

COUNTY

C

3

0

ENTDATE

DATE CUSTOMER RECORD ADDED TO H2OS

D

8

0

MARK

INTERNAL USE FOR MARKING SELECTED RECORDS

L

1

0

USEFORWARD

INTERNAL USE

L

1

0

ORIGADRL

INTERNAL USE BY CASS

C

64

0

NOTES

NOTES MEMO FIELD

M

4

0

INSTDATE

CUSTOMER INSTALLATION DATE

D

8

0

AM_PM

CUSTOMER AM OR PM SCHEDULING PREFERENCE

C

2

0

BRIEFDIR

BRIEF DIRECTIONS TO WORK SITE LOCATION

C

80

0

NUMZONES

NUMBER OF SPRINKLER ZONES AT THIS CUSTOMER'S LOCATION

C

4

0

BOCONNLOC

LOCATION OF BLOW OUT CONNECTION

C

80

0

BOMAKE

BACKFLOW DEVICE MANUFACTURER NAME

C

80

0

BOMODEL

BACKFLOW DEVICE MODEL

C

80

0

BOSERIAL

BACKFLOW DEVICE SERIAL NUMBER

C

80

0

BOSIZE

BACKFLOW DEVICE SIZE

C

80

0

BOLOC

BACKFLOW DEVICE LOCATION

C

80

0

LASTINSP

LAST INSPECTION SERVICE DATE

D

8

0

LARGECOMP

IF TRUE, LARGE COMPRESSOR IS REQUIRED FOR BLOW-OUTS

L

1

0

PICTBOX1

NOT USED

M

4

0

MAPFROMADR

THE MAP FROM ADDRESS ON THE MAPPING PAGE

C

70

0

MAPTOADR

THE MAP TO ADDRESS ON THE MAPPING PAGE

C

70

0

TELNO

TELEPHONE NUMBER

C

24

0

HOMETEL

PERSONS TELEPHONE NUMBER AT HOME

C

40

0

HOMETELN

CUSTOMER'S HOME TELEPHONE NUMBER NOTES

C

40

0

HOMEALT

CUSTOMER'S HOME ALTERNATE TELEPHONE NUMBER

C

24

0

HOMEALTN

CUSTOMER'S HOME ALTERNATE TELEPHONE NUMBER NOTES

C

40

0

WORKTEL

WORK TELEPHONE NUMBER

C

24

0

WORKTELN

WORK TELEPHONE NUMBER NOTES

C

40

0

WORKALT

WORK ALTERNATE TELEPHONE NUMBER

C

24

0

WORKALTN

WORK ALTERNATE TELEPHONE NUMBER NOTES

C

40

0

CELLTEL

CELL PHONE #

C

24

0

CELLTELN

CELL PHONE NOTES

C

40

0

CELLALT

CELL PHONE ALTERNATE #

C

24

0

CELLALTN

CELL PHONE ALTERNATE NOTES

C

40

0

FAXTEL

FAX TELEPHONE NUMBER

C

24

0

FAXTELN

FAX TELEPHONE NUMBER NOTES

C

40

0

FAXALT

ALTERNATE FAX TELEPHONE NUMBER

C

24

0

FAXALTN

ALTERNATE FAX TELEPHONE NUMBER NOTES

C

40

0

OTHERTEL1

OTHER TELEPHONE NUMBER #1

C

24

0

OTHERTELD

NOT USED

C

40

0

OTHERTEL2

OTHER TELEPHONE NUMBER #2

C

24

0

OTHERTELD2

NOT USED

C

40

0

EMAILW1

EMAIL WORK ADDRESS # 1

C

60

0

EMAILH1

EMAIL ADDRESS, AT HOME, #1

C

60

0

EMAILO1

EMAIL "OTHER" ADDRESS, #1

C

60

0

DEAR

WORDS TO FOLLOW DEAR IN PERSONALIZED LETTERS

C

35

0

VALVE1

LOCATION OF SATELLITE VALVE BOXES

C

254

0

INCLMAP

IF TRUE, INCLUDE A PRINT OF THE STORED MAP FOR THIS CUSTOMER WITH JOB TICKETS

L

1

0

INCLPIC1

IF TRUE, INCLUDE PHOTO #1 STORED FOR THIS CUSTOMER WITH PRINTED JOB TICKETS

L

1

0

PASS_FAIL

IF TRUE, BLOW OUT TEST PASSED, OTHERWISE FAILED

N

1

0

BONOTES

BACKFLOW TEST GENERAL NOTES

M

4

0

LOTSEQ

INTERNAL USE FOR USPS LOT DATA

C

4

0

LOTAD

INTERNAL USE FOR USPS LOT DATA

C

1

0

ORIGZIP

INTERNAL USE BY CASS

N

5

0

OTYPECODE

INTERNAL USE

C

1

0

ORIGTOWN

INTERNAL USE BY CASS

C

19

0

ORIGSTATE

INTERNAL USE BY CASS

C

2

0

DONTPRINT

IF TRUE, DON'T PRINT ADDRESS LABELS FOR THIS CUSTOMER

N

1

0

EMAILPR

EMAIL PREFERENCE

 

Home, work or don't ask

 

N

1

0

GENNOTES

GENERAL NOTES

M

4

0

INSTNOTES

CUSTOMER INSTALLATION NOTES

M

4

0

PREFTELNO

PREFERRED TELEPHONE NUMBER

C

40

0

TELPREFN

TELEPHONE PREFERRED NUMBER

C

10

0

BOWATERCO

WATER SERVICE COMPANY

C

35

0

BOMETERSN

WATER METER SERIAL NUMBER

C

40

0

BOLASTPSI

BACKFLOW DEVICE TEST - LAST PSI READING

C

20

0

BOINSPECTR

BACKFLOW DEVICE TEST - LAST INSPECTOR NAME

C

35

0

BOLASTMETR

BACKFLOW DEVICE TEST - LAST METER READING

C

35

0

MP1PAGE

GIW SWITCH TO PRINT 2 GRAPHICS ON 1 PAGE FOR THIS CUSTOMER

N

1

0

ALTADDR1

ALTERNATE (WORK SITE) ADDRESS LINE 1

C

26

0

ALTADDR2

ALTERNATE (WORK SITE) ADDRESS LINE 2

C

26

0

ALTADDR3

ALTERNATE (WORK SITE) ADDRESS LINE 3

C

26

0

ALTADDR4

ALTERNATE (WORK SITE) ADDRESS LINE 4

C

26

0

ALTTOWN

ALTERNATE (WORK SITE) ADDRESS, TOWN

C

19

0

ALTSTATE

ALTERNATE (WORK SITE) ADDRESS, STATE

C

2

0

ALTZIP

ALTERNATE (WORK SITE) ADDRESS, ZIP CODE

N

5

0

ALTZIP4

ALTERNATE (WORK SITE) ADDRESS, ZIP4

C

4

0

ACCT

CREDIT CARD ACCOUNT NAME

C

16

0

CARDTYPE

CREDIT CARD TYPE

C

16

0

ACCTNUMBER

CREDIT CARD ACCOUNT NUMBER

C

19

0

EXP_DATE

NOT USED

D

8

0

NAMEONCARD

CUSTOMER'S NAME AS IT APPEARS ON CREDIT CARD

C

31

0

BO_CHGE

BLOW OUT SERVICE CHARGE

N

6

2

TO_CHGE

TURN ON CHARGE (FOR ESTIMATES AND CONTACTS FOR THIS CUSTOMER)

N

6

2

BF_CHGE

BACKFLOW SERVICE CHARGE

N

6

2

INCL_BLO

IF TRUE, SERVICE CONTRACT INCLUDES BLOWOUTS

L

1

0

INCL_TURN

IF TYPE, SERVICE CONTRACT INCLUDES TURN-ONS

L

1

0

INCL_BACK

IT TRUE, SERVICE CONTRACT INCLUDES BACKFLOW TEST

L

1

0

END_DATE

CONTRACT EXPIRATION DATE IF CONTRACT EXISTS

D

8

0

CTYPE

NOT USED

C

30

0

GRID

MAP GRID REFERENCE TO THIS CUSTOMER'S ADDRESS

C

11

0

SVCE_DATE

NOT USED

D

8

0

BALANCE

CUSTOMER'S ACCOUNT BALANCE, IF ANY, MANUALLY POSTED FROM ACCOUNTING SYSTEM

N

8

2

AUTO_SVCE

NOT USED

D

8

0

BDATE

OUTSTANDING BALANCE OWED - FROM DATE

D

8

0

COMMERCIAL

TRUE (T) IF COMMERCIAL ACCOUNT

L

1

0

INV_NUMBER

INVOICE NUMBER RELATED TO BALANCE DUE, IF ANY

C

8

0

STRT_DATE

NOT USED

D

8

0

INCL_OTHER

IF TRUE, SERVICE CONTRACT INCLUDES OTHER TASKS

L

1

0

OTHER_DESC

 ...

C

120

0

CONT_OTHER

NOT USED

C

80

0

SEC_CODE

NOT USED

C

4

0

CONNOTES

GENERAL NOTES RE: BLOW OUT

M

4

0

CCNOTES

CREDIT CARD NOTES

M

4

0

SPECNOTES

SPECIAL NOTES PERTAINING TO THIS CUSTOMER

C

250

0

PICTBOX1_2

 ...

M

4

0

ADDRLINE

USED INTERNALLY TO STORE THE ADDRESS LINE FOR MULTI-LINE ADDRESSES

C

40

0

LASTSVC

LAST SERVICE DATE

D

8

0

TIMER

INFORMATION REGARDING TIMER DEVICE

C

100

0

RAINSENSOR

LOCATION OF RAIN SENSOR DEVICE

C

50

0

REFERRED

NAME OF PERSON WHO REFERRED THIS CUSTOMER TO US

C

30

0

NOSERVICE

THIS CUSTOMER IS IN NO SERVICE STATUS

L

1

0

VALVEACC

IF TRUE , VALVES ARE ACCESSABLE IN VALVE BOX

L

1

0

LASTTO

LAST TURN-ON DATE

D

8

0

LASTBO

LAST BLOW-OUT SERVICE DATE

D

8

0

DONTCASS

DO NOT ADDRESS CHECK THIS ADDRESS

N

1

0

CARRYFWD

NOTES ON WORK YET TO BE SCHEDULED

C

120

0

BOSUBDATE

 ...

D

8

0

QBCUSTID

Quickbooks customer ID. Must be unique in QuickBooks.

C

45

0

 

PREFMOC

customers preferred method of contact

can be text msg, e-mail, telephone, letter or blank

C

20

0

 

 

 

151 fields

 

As of 01/27/2009 10:25:08 PM

 


 

 

A sample customer audit trail record for newly added customer follows.

The audit trail's fields match the customer records, and is kept in sync by a check during startup.