Field Summary for prospect import

Field Name

Type

Length

ID1

String

6

ID2

String

8

ID3

String

15 

PREFIX

String

12 

FNAME

String

20 

LNAME

String

30 

SUFFIX

String

5

SALUTATION

String

15 

SEX

Code

1

TITLE

String

40 

COMPANY

String

40 

DEPT

String

40 

STREET1

String

40 

STREET2

String

40 

CITY

String

26 

STATE

Code

2

ZIP

String

10 

ZIP2

String

2

CARRT

String

4

CNTRYCODE

String

4

COUNTRY

String

24 

TAXJR

Code

3

PHONE

String

20 

FAX

String

20 

EMAIL

String

60 

USERID

String

15

PASSWORD

String

15

TAXABLE

Code

1

RENTPOSTAL

Code

1

RENTEMAIL

Code

1

RENTPHONE

Code

1

RENTFAX

Code

1

BADSEED

Code

1

DEMCODEA

Numeric

4

DEMCODEB

Numeric

4

DEMCODEC

Numeric

4

DEMCODED

Numeric

4

DEMDATA1

String

19 

DEMDATA2

String

19 

CASSDATE

Date

8

LIST

Code

10 

PROSPDATE

Date

8

PROSRQTYPE

Code

3

PUB

Code

6

QDATE or QUALDATE

Date

8

QBATCHDATE

Date

8

QBATCHNUM

Numeric

4

PERSID

String

20

Qual. Data

String

Qual. Data

String

Qual. Data

String

Qual. Data

String