Note: formatted address vs. unformatted address
The difference between the formatted address formats and the unformatted address formats is that the label line fields are replaced by the individual customer address fields.
dBASE file with formatted address:
Field name |
Width |
Description |
RECNUM |
7 |
Record number |
CUSTNUM |
9 |
Customer number |
CNTRYCODE |
4 |
Country code |
ZIP |
10 |
Zip code or postal code |
ZIP2 |
2 |
Last 2 digits of 12 digit zip |
CARRT |
4 |
Carrier route |
CASSDATE |
8 |
CASS certification date |
ADDR1 |
40 |
Label line 1 |
ADDR2 |
40 |
Label line 2 |
ADDR3 |
40 |
Label line 3 |
ADDR4 |
40 |
Label line 4 |
ADDR5 |
40 |
Label line 5 |
ADDR6 |
40 |
Label line 6 |
ADDR7 |
40 |
Label line 7 |
SALUTATN |
43 |
|
PHONE |
20 |
Phone |
CELLPHONE |
20 |
Cell phone |
FAX |
20 |
Fax |
60 |
Primary e-mail address |
|
EMAIL2 |
60 |
Secondary e-mail address |
USERID |
15 |
User ID |
PASSWORD |
15 |
Password |
TAXABLE |
1 |
Taxable |
RANDOM |
2 |
Random number |
DEMCODEA |
4 |
Demo code A |
DEMCODEB |
4 |
Demo code B |
DEMCODEC |
4 |
Demo code C |
DEMCODED |
4 |
Demo code D |
SELFLAGS |
8 |
Customer selection flags |
TAXJR |
3 |
Tax jurisdiction |
SEX |
1 |
Sex |
RENTPOSTAL |
1 |
Allowed usage for postal correspondence |
RENTEMAIL |
1 |
Allowed usage for e-mail correspondence |
RENTPHONE |
1 |
Allowed usage for telephone correspondence |
RENTFAX |
1 |
Allowed usage for fax correspondence |
BADSEED |
1 |
Bad debt/Seed indicator |
DEMDATA1 |
19 |
Demo data 1 |
DEMDATA2 |
19 |
Demo data 2 |
EXTCUSTID |
12 |
External customer ID |
CREATEDATE |
8 |
Date customer record was created |
POSTALDATE |
8 |
Date of last postal address change |
EMAILDATE |
8 |
Date of last e-mail address change |
PHONEDATE |
8 |
Date of last phone number change |
FAXDATE |
8 |
Date of last fax number change |
dBASE file with unformatted address:
Field name |
Width |
Description |
RECNUM |
7 |
Record number |
CUSTNUM |
9 |
Customer number |
CNTRYCODE |
4 |
Country code |
ZIP |
10 |
Zip code or postal code |
ZIP2 |
2 |
Last 2 digits of 12 digit zip |
CARRT |
4 |
Carrier route |
CASSDATE |
8 |
CASS certification date |
LNAME |
30 |
Last name |
FNAME |
20 |
First name |
PREFIX |
12 |
Prefix |
SUFFIX |
12 |
Suffix |
TITLE |
40 |
Title |
COMPANY |
40 |
Company |
DEPT |
40 |
Department |
STREET1 |
40 |
Street 1 |
STREET2 |
40 |
Street 2 |
CITY |
26 |
City |
STATE |
2 |
State |
COUNTRY |
24 |
Country name |
SALUTATION |
15 |
|
PHONE |
20 |
Phone |
CELLPHONE |
20 |
Cell phone |
FAX |
20 |
Fax |
60 |
Primary e-mail address |
|
EMAIL2 |
60 |
Secondary e-mail address |
USERID |
15 |
User ID |
PASSWORD |
15 |
Password |
TAXABLE |
1 |
Taxable |
RANDOM |
2 |
Random number |
DEMCODEA |
4 |
Demo code A |
DEMCODEB |
4 |
Demo code B |
DEMCODEC |
4 |
Demo code C |
DEMCODED |
4 |
Demo code D |
SELFLAGS |
8 |
Customer selection flags |
TAXJR |
3 |
Tax jurisdiction |
SEX |
1 |
Sex |
RENTPOSTAL |
1 |
Allowed usage for postal correspondence |
RENTEMAIL |
1 |
Allowed usage for e-mail correspondence |
RENTPHONE |
1 |
Allowed usage for telephone correspondence |
RENTFAX |
1 |
Allowed usage for fax correspondence |
BADSEED |
1 |
Bad debt/Seed indicator |
DEMDATA1 |
19 |
Demo data 1 |
DEMDATA2 |
19 |
Demo data 2 |
EXTCUSTID |
12 |
External customer ID |
CREATEDATE |
8 |
Date customer record was created |
POSTALDATE |
8 |
Date of last postal address change |
EMAILDATE |
8 |
Date of last e-mail address change |
PHONEDATE |
8 |
Date of last phone number change |
FAXDATE |
8 |
Date of last fax number change |