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.
Fixed length .SDF file with formatted address:
|
Length |
Description |
|
7 |
Record number |
|
9 |
Customer number |
|
4 |
Country code |
|
10 |
Zip code or postal code |
|
2 |
Last 2 digits of 12 digit zip code |
|
4 |
Carrier route |
|
8 |
CASS certification date |
|
40 |
Label line 1 |
|
40 |
Label line 2 |
|
40 |
Label line 3 |
|
40 |
Label line 4 |
|
40 |
Label line 5 |
|
40 |
Label line 6 |
|
40 |
Label line 7 |
|
43 |
|
|
20 |
Phone |
|
20 |
Fax |
|
60 |
E-mail address |
|
15 |
User ID |
|
15 |
Password |
|
1 |
Taxable |
|
2 |
Random number |
|
4 |
Demo code A |
|
4 |
Demo code B |
|
4 |
Demo code C |
|
4 |
Demo code D |
|
3 |
Tax jurisdiction |
|
1 |
Sex |
|
1 |
Allowed usage for postal correspondence |
|
1 |
Allowed usage for E-mail correspondence |
|
1 |
Allowed usage for telephone correspondence |
|
1 |
Allowed usage for fax correspondence |
|
1 |
Bad debt/Seed indicator |
|
19 |
Demo data 1 |
|
19 |
Demo data 2 |
|
8 |
Date customer record was created |
|
8 |
Date of last postal address change |
|
8 |
Date of last e-mail address change |
|
8 |
Date of last phone number change |
|
8 |
Date of last fax number change |
|
2 |
Carriage return/line feed |
|
605 |
Total length |
Fixed length .SDF file with unformatted address:
|
Length |
Description |
|
7 |
Record number |
|
9 |
Customer number |
|
4 |
Country code |
|
10 |
Zip code or postal code |
|
2 |
Last 2 digits of 12 digit zip code |
|
4 |
Carrier route |
|
8 |
CASS certification date |
|
30 |
Last name |
|
20 |
First name |
|
12 |
Prefix |
|
5 |
Suffix |
|
40 |
Title |
|
40 |
Company |
|
40 |
Department |
|
40 |
Street 1 |
|
40 |
Street 2 |
|
26 |
City |
|
2 |
State |
|
24 |
Country name |
|
15 |
|
|
20 |
Phone |
|
20 |
Fax |
|
60 |
E-mail address |
|
15 |
User ID |
|
15 |
Password |
|
1 |
Taxable |
|
2 |
Random number |
|
4 |
Demo code A |
|
4 |
Demo code B |
|
4 |
Demo code C |
|
4 |
Demo code D |
|
3 |
Tax jurisdiction |
|
1 |
Sex |
|
1 |
Allowed usage for postal correspondence |
|
1 |
Allowed usage for E-mail correspondence |
|
1 |
Allowed usage for telephone correspondence |
|
1 |
Allowed usage for fax correspondence |
|
1 |
Bad debt/Seed indicator |
|
19 |
Demo data 1 |
|
19 |
Demo data 2 |
|
8 |
Date customer record was created |
|
8 |
Date of last postal address change |
|
8 |
Date of last e-mail address change |
|
8 |
Date of last phone number change |
|
8 |
Date of last fax number change |
|
2 |
Carriage return/line feed |
|
616 |
Total length |