The following file format is produced by any of the following:
The QuickFill Label Splitter, when you choose the "dBase" output type.
The Issue Label update when you check one or more of the 'Presort' boxes on the 'Shipping' tab of the publication definition screen.
The Customer Data export when you choose the "Postware/ArcList postal presort" output format.
A file(s) with the following format is produced when the QuickFill Label Splitter is run using the 'dBase' output type. The name assigned to the dBase label files created is in the format QFLABnnn.DBF, where nnn is a number. QuickFill saves the dBase files it produces in the mail-merge directory. The "About QuickFill" screen displays the exact location of this directory.
|
Field name |
Width |
Type |
Note |
Description |
|
RECNUM |
7 |
Numeric |
|
Record number |
|
BILLREN |
18 |
Character |
1 |
Indicates if a bill or renewal was produced and what kind |
|
PUB |
6 |
Character |
1 |
Publication code |
|
FORM |
4 |
Character |
1 |
Form ID for a corresponding bill or renewal |
|
PACKAGE |
6 |
Character |
1 |
Package code for a corresponding bill or renewal |
|
ISSUE |
4 |
Numeric |
1 |
Issue number being served |
|
PREMIUM |
6 |
Character |
1 |
Premium code to be served with the issue |
|
SPLIT |
6 |
Character |
1 |
Label split code |
|
SERVICE |
2 |
Character |
1 |
Service code |
|
SHIPCLASS |
1 |
Character |
1 |
Shipping class |
|
COPIES |
4 |
Numeric |
1 |
Number of copies |
|
TOPLINE |
40 |
Character |
|
Top line of label |
|
LABEL2 - 7 |
40 |
Character |
|
Label image lines 2 -7 |
|
PREFIX |
12 |
Character |
|
Prefix |
|
FNAME |
20 |
Character |
|
First name |
|
LNAME |
30 |
Character |
|
Last name |
|
SUFFIX |
5 |
Character |
|
Suffix |
|
NAME |
40 |
Character |
|
Customer name |
|
TITLE |
40 |
Character |
|
Title |
|
DEPT |
40 |
Character |
|
Department |
|
COMPANY |
40 |
Character |
|
Company |
|
STREET1 |
40 |
Character |
|
Street address 1 |
|
STREET2 |
40 |
Character |
|
Street address 2 |
|
CITY |
26 |
Character |
|
City |
|
STATE |
2 |
Character |
|
State |
|
ZIP |
10 |
Character |
|
Zip code |
|
ZIP2 |
2 |
Character |
|
+2 portion of Zip+4+2 |
|
CARRT |
4 |
Character |
|
Carrier route |
|
CNTRYCODE |
4 |
Character |
|
Country code |
|
COUNTRY |
24 |
Character |
|
Country name |
|
PHONE |
20 |
Character |
|
Telephone number |
|
FAX |
20 |
Character |
|
Fax number |
|
|
60 |
Character |
|
E-mail address |
|
USERID |
15 |
Character |
|
User ID |
|
PASSWORD |
15 |
Character |
|
Password |
|
SALUTATION |
15 |
Character |
|
Salutation |
|
SEX |
1 |
Character |
|
Sex |
|
DEMCODEA |
4 |
Numeric |
|
Demographic code A |
|
DEMCODEB |
4 |
Numeric |
|
Demographic code B |
|
DEMCODEC |
4 |
Numeric |
|
Demographic code C |
|
DEMCODED |
4 |
Numeric |
|
Demographic code D |
|
DEMDATA1 |
19 |
Character |
|
Demographic data 1 |
|
DEMDATA2 |
19 |
Character |
|
Demographic data 2 |
|
CASSDATE |
8 |
Date |
|
CASS certification date |
|
21 |
Character |
3 |
ACS (Address Correction Service) key line | |
|
CUSTNUM |
9 |
Character |
|
Customer number |
|
ORDERNUM |
9 |
Character |
1 |
Order number |
|
EXPDATE |
20 |
Character |
1 |
Expiration date |
|
TRACK |
6 |
Character |
1 |
Tracking code of subscription |
|
SOURCE |
6 |
Character |
1 |
Source from the order the issue was served from |
|
SUBSCRIBER |
1 |
Logical |
1 |
T=Paid (or Request) F=Free (or Non-request) |
|
SUBCLASS |
3 |
Character |
2 |
Subscription class when issue was served |
|
REQTYPE |
3 |
Character |
2 |
Request type when issue was served |
|
QDATE |
8 |
Date |
2 |
Qualification date |
|
QBATCHDATE |
8 |
Date |
2 |
Batch date when qualification data was entered |
|
QBATCHNUM |
4 |
Numeric |
2 |
Batch number when qualification data was entered |
|
PERSID |
20 |
Character |
2 |
Personal ID data used to verify qualification |
|
Q1-Qnnn |
varies |
Character |
2 |
Responses to qualification questions. The field names match the question numbers on the publication's qualification form. |
Note 1: the fields BILLREN through COPIES and ORDERNUM through SUBSCRIBER are not present in the files created by the Customer Data export, nor for files created by the Label Splitter from promotional, agency, group, and one-shot labels.
Note 2: these fields are only present for issue label files created for audited publications.
Note 3: There are two available formats for the ACSKEY field: all numeric or alphanumeric. You make your choice of formats on the Preferences screen. You must use the alphanumeric format if you have or expect to have more than 10 million customer or order records in your database.
The format of the numeric ACSKEY field is #1111 1111 2222 2223# where the 1's represent the QuickFill customer number (including check digit and left padded with zeros), the 2's represent the related QuickFill order number (without the check digit and left padded with zeros), and the 3 represents the USPS check digit.
The format of the alphanumeric ACSKEY field is #ACCC CCCC OOOO OOOX# where the A is literally the letter 'A', the C's are the customer number encoded in hexadecimal, the O's are the order number, also encoded in hexadecimal and the X is the USPS check digit.