Label file format

The following file format is produced by any of the following:

When you use the QuickFill Label Splitter to create 'dBase' output files the name assigned to the dBase label files is in the format Lnnnnnnn.DBF or Snnnnnnn.DBF, where nnnnnnn is a number. Similarly, if you use the label splitter to create comma delimited (CSV) output files the name is in the format Lnnnnnn.CSV or Snnnnnnn.CSV. QuickFill saves the both dBase and CSV files it produces in the mail-merge directory. The "About QuickFill" screen displays the exact location of this directory.  If the file format selected (dBase or CSV) is one of the 'SN' formats then the file will be named beginning with an 'S' (see Note 6 below).  

 

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

12

Character

1

Publication code

FORM

12

Character

1

Form ID for a corresponding bill or renewal

PACKAGE

12

Character

1

Package code for a corresponding bill or renewal

ISSUE

4

Numeric

1

Issue number being served

PREMIUM

12

Character

1

Premium code to be served with the issue

SPLIT

12

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

12

Character

 

Suffix

NAME

40

Character

 

Customer name
(including prefix and suffix)

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

CELLPHONE

20

Character

 

Cell phone number

FAX

20

Character

 

Fax number

EMAIL

60

Character

 

E-mail address

EMAIL2

60

Character

 

E-mail address

USERID

15

Character

 

User ID

PASSWORD

15

Character

 

Password

EXTCUSTID

12

Character

 

External customer ID

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

SELFLAGS

8

Character

 

Customer selection flags

CASSDATE

8

Date

 

CASS certification date

ACSKEY

21

Character

3

ACS (Address Correction Service) key line

ONECODE9

9

Character

4

9 digit mail piece ID for OneCode ACS

ONECODE6

6

Character

5

6 digit mail piece ID for OneCode ACS

CUSTNUM

9

Character

 

Customer number

ORDERNUM

9

Character

1

Order number

EXPDATE

20

Character

1

Expiration date

TRACK

12

Character

1

Tracking code of subscription

SOURCE

12

Character

1

Source from the order the issue was served from

MISC

12

Character

1

Misc field from order the issue was served from

PONUM

20

Character

1

Purchase order number

EXTORDERID

12

Character

1

External order ID

SUBSCRIBER

1

Logical

1

T=Paid (or Request) F=Free (or Non-request)

SUBCLASS

3

Character

2

Subscription class when issue was served

TIMESTAMP

25

Character

6

Timestamp used to age the serial number

MAILERID

6 or 9

Character

6

Value supplied by the Label Splitter when creating this file.

SERIALNUM

9 or 6

Character

6

Value assigned to this record by the Label Splitter.  If the MAILERID is of length 6 this will be of length 9...if the MAILERID is of length 9 this will be of length 6.

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.

Note 4: The ONECODE9 field consists of a prefix digit of 1, 2 or 3 followed by the customer number, zero filled and without a check digit. The prefix digit is based on the current month, where 1 is January, April, July and October, 2 is February, May, August and November and 3 is March, June, September and December. The intent is that the same mail piece identifier number will not reoccur within any 45 day period, provided the publication is published no more than once a month. USPS specifications state that the mail piece ID should be unique within any 45 day period. 

Note 5: The ONECODE6 field is constructed from the customer number by dropping the last digit (the check digit) and the top one or two digits if the resulting number is longer than six digits. The resulting number should be unique for databases with less than one million customers. If you frequently import and then subsequently purge lists of prospects, your customer numbers may be too long and the ONECODE6 field will not contain a unique number. The ACS importer attempts to resolve ambiguous OneCode mail piece ID numbers by checking the zip codes associated with all of the possible matching customer numbers.

Note 6: These three fields, TIMESTAMP, MAILERID and SERIALNUM will only be present if the file was created by the Label Splitter and the output format was one of the following: dBase SN, dbase Audit SN, CSV SN or CSV Audit SN.  The MAILERID and SERIALNUM are meant to be used when creating Intelligent Mail barcodes.  The TIMESTAMP is used internally by QuickFill when determining what serial numbers the Label Splitter should assign. These "SN" type files will be named as Snnnnnnn.DBF or Snnnnnnn.CSV.