AccuZIP6 Field Names and Descriptions
AccuZIP6 creates fields to store data as you process the list. Some of the fields are required. In other words, they must exist to perform certain processes within the program. Others may only be required for certain types of mail processing. For instance, when a Periodical Mailer is trying to track subscribers and non-subscribers, the program requires the user to store this data in a Logical field named subscribe_. Then, when the program presorts the mail, the Postage Statement will display the correct data. Optional Fields also exist for users to store data in. The following table explains the purpose of every field that AccuZIP6 uses to process data.
Field Name |
Field Type |
Width |
Description |
abrev_ |
Character |
4 |
Address Secondary Name Abbreviation (APT, STE, etc.) for parsed address information |
acs_key |
Character |
16 |
ACS Keyline |
acs_part |
Character |
7 |
ACS Participation Number |
address |
Character |
60 |
Mailing Address |
address2 |
Character |
50 |
Second Address Line |
address3 |
Character |
50 |
Third Address Line |
address4 |
Character |
50 |
Fourth Address Line |
address5 |
Character |
50 |
Fifth Address Line |
address6 |
Character |
50 |
Sixth Address Line |
address7 |
Character |
50 |
Seventh Address Line |
address8 |
Character |
50 |
Eighth Address Line |
address9 |
Character |
50 |
Ninth Address Line |
address10 |
Character |
50 |
Tenth Address Line |
area_ |
Character |
3 |
Area Code |
ascdesc_ |
Character |
1 |
Ascending/Descending Code |
barcode |
Character |
14** |
Delivery Point Barcode |
census_bl |
Character |
7 |
Census Block (added with Geocoder module) |
census_tr |
Character |
6 |
Census Tract (added with Geocoder module) |
census_rs |
Character |
2 |
Census Result (00 for 5 digit match, 04 for +4 match) |
chkdg |
Character |
1 |
Check Digit |
city |
Character |
30 |
City Name |
cnt_ |
Numeric |
6 |
Presort Package Count |
company*** |
Character |
50 |
Company Name |
cont_id |
Character |
6 |
Container Number (Presorted Data Only) |
congress_ |
Character |
2 |
Congressional District Code |
copies_ |
Numeric |
3 |
Number of Copies per Record for Periodical Mailers |
country |
Character |
30 |
Country Name |
countynm_ |
Character |
30 |
County Name |
countyno_ |
Character |
3 |
County Number (FIPS) |
crrt |
Character |
4** |
Carrier Route Number |
department |
Character |
50 |
Contact Department |
dp |
Character |
2 |
Delivery Point |
dp_ |
Numeric |
3 |
Delivery Point Number -/+ |
dpc |
Character |
3 |
Delivery Point and Check Digit |
dpv_ |
Character |
6 |
Delivery Point Validation Codes |
dpvnotes_ |
Character |
8 |
Additional Information Pertaining to Delivery Point Validation |
elatitude_ |
Character |
10 |
Latitude calculated by individual ZIP+4 (added by Geocoder module) |
elongitude_ |
Character |
10 |
Longititude calculated by individual ZIP+4 (added by Geocoder module) |
|
Character |
30 |
E-mail Address |
endorse |
Character |
30 |
Endorsement Information (Presorted Data Only) |
entry_date |
Date |
8 |
Date Entered |
errno_ |
Character |
30 |
CASS Certification Codes and Errors |
ffapplied |
Character |
8 |
Contains the Date the Record was Processed Through NCOA Link |
financeno_ |
Character |
6 |
Finance Number |
first*** |
Character |
55 |
First Name |
gpb_id |
Character |
6 |
Group Bundle Number (Presorted Data Only) |
group1 |
Character |
40 |
Group Code 1 |
group2 |
Character |
40 |
Group Code 2 |
group3 |
Character |
40 |
Group Code 3 |
group4 |
Character |
40 |
Group Code 4 |
imbarcode |
Character |
65 |
Contains the Intelligent Mail Barcode Data |
imbdigits |
Character |
20 |
Contains a numeric representation of the data compiled for the IMB. |
key_ |
Character |
1 |
Presort Package Group |
lacs_ |
Character |
1 |
LACS Match Flag |
lacsind_ |
Character |
1 |
LACSLink Indicator Return Code |
lacssrc_ |
Character |
2 |
LACSLink Source |
last |
Character |
30 |
Last Name |
latitude_ |
Character |
8 |
Latitude Degrees of a record's 5 digit ZIP code |
leftout_ |
Character |
30 |
Address Information Not Used |
longitude_ |
Character |
8 |
Longitude Degrees of a record's 5 digit ZIP code |
lot_ |
Character |
4 |
Line of Travel Number |
matchflag_ |
Character |
2 |
Move Status Applied During NCOA Link Processing |
middle |
Character |
20 |
Middle Name |
mod_date |
Date |
8 |
Date Modified |
movedate_ |
Character |
6 |
Date of Move Filed with USPS |
movetype_ |
Character |
1 |
Move Type Returned During NCOA Link Processing |
nxi_ |
Character |
2 |
Status Code Returned During NCOA Link Processing |
oaddress |
Character |
50 |
Original Address Field Data Before Validation |
ocity |
Character |
30 |
Original City Field Data Before Validation |
ocompany |
Character |
50 |
Original Company Field Data Before Validation |
ostate |
Character |
2 |
Original St Field Data Before Validation |
ozipcode |
Character |
10 |
Original Zip Field Data Before Validation |
phone1 |
Character |
20 |
First Phone Number |
phone2 |
Character |
20 |
Second Phone Number |
phone3 |
Character |
20 |
Third Phone Number |
post_ |
Character |
2 |
Address Post Direction (S, NW, etc.) for parsed address information |
pre_ |
Character |
2 |
Address Pre Direction (W, SE, etc.) for parsed address information |
primary_ |
Character |
10 |
Primary Address Number for parsed address information |
sal |
Character |
15 |
Salutation |
secy_ |
Character |
8 |
Address Secondary Number (APT #, STE #, etc.) for parsed address information |
sequence |
Character |
7 |
Presort Sequence Number (Presorted Data Only) |
st |
Character |
2** |
State Abbreviation |
status_ |
Character |
1 |
Record Validation Status |
stelink_ |
Character |
2 |
SuiteLink match field. Will only be populated for SuiteLink matches. |
stno_ |
Character |
2 |
State FIPS Code (added when validating with County Code checked) |
street_ |
Character |
30 |
Street Name for parsed address information |
subscribe_ |
Logical |
1 |
Subscriber Status for Periodical Mailers |
suffix_ |
Character |
4 |
Address Suffix (DR, AVE, BLVD, etc.) for parsed address information |
timezone_ |
Character |
5 |