Field summary for mail-merge bills and order acknowledgements

The following is a summary of the fields included in mail-merge bill and order acknowledgement files. Depending on the definitions in your database as well as the customer records, some of the fields listed may be blank. Click here for a list with detailed descriptions of the field contents for mail-merge bills.

MMERG1 format:

Description	Field name	Maximum field length
Record number	RECNUM	7
Company address	COMADDR1-COMADDR5	40
Company phone	COMPHONE	20
Credit card info	CCBLOCK1-CCBLOCK3	31
Customer address	ADDRESS1-ADDRESS6	40
Publication code	PUBCODE	6
Publication name	PUBNAME1-PUBNAME2	30
Date	DATE	8
Order number	ORDERNUM	9
Effort number	EFFORT	1
Purchase order text	PONUMTEXT	16
Purchase order number	PONUM	20
Term description	TERMDESC	26
Price	PRICE	12
Shipping description	SHIPDESC	26
Shipping amount	SHIPCHARGE	12
Tax text	TAXDESC	26
Tax amount	TAX	12
Subtotal amount	SUBTOTAL	12
Credit text	CREDITTEXT	26
Credit amount	CREDIT	12
Total amount	TOTAL	12
Message block one	MESSAGE1A-MESSSAGE1D	40
Message block two	MESSAGE2A-MESSAGE2D	40
Expiration date	EXPDATE	20
Quantity	QUANTITY	4
Ship-to address	SHIPADDR1-SHIPADDR6	30
Payable to text	PAYABLETXT	18
Publication payable	PUBPAYABLE	30
Federal tax ID text	FEDTAXTXT	11
Company federal tax ID number	FEDTAXID	10
Customer telephone number	PHONE	20
Customer salutation	SALUTATN	43

MMERG2 format:

If you select the MMERG2 format code in your billing package definitions, each record in your mail-merge file will include all of the MMERG1 fields plus the following ones:

Description	Field name	Maximum field length
Addressee street1	STREET	40
Addressee city	CITY	26
Addressee state	STATE	2
Addressee zip or postal code	ZIP	10
Addressee zip+2	ZIP2	2
Addressee carrier route	CARRT	4
Addressee country code	CNTRYCODE	4
Addressee CASS certification date	CASSDATE	8
Addressee fax number	FAX	20
Addressee e-mail address	EMAIL	60
Addressee customer number	CUSAGENCY	9
Billing series code	SERIES	6
Billing package code	PACKAGE	6

MMERG3 format:

If you select the MMERG3 format code in your billing package definitions, each record in your mail-merge file will include all of the MMERG1 and MMERG2 fields plus the following ones:

Description	Field name	Maximum field length
Addressee company	COMPANY	40
Addressee department	DEPT	40
Addressee prefix	PREFIX	12
Addressee first name	FNAME	20
Addressee last name	LNAME	30
Addressee suffix	SUFFIX	5
Addressee title	TITLE	40
Addressee street2	STREET2	40
Addressee country	COUNTRY	24
Addressee postal code position	ZIPLOCATE	1
Addressee sex	SEX	1
Addressee demographic codes	DEMOCODEA-DEMOCODED DEMODATA1-DEMODATA2	4 19
Addressee user ID	USERID	15
Addressee password	PASSWORD	15

MMERG4 format:

Description	Field name	Maximum field length
Record number	RECNUM	7
Publication code	PUBCODE	6
Billing series code	SERIES	6
Billing package code	PACKAGE	6
Customer address	ADDRESS1-ADDRESS6	40
Publication name	PUBNAME1-PUBNAME2	30
Date	DATE	8
Order number	ORDERNUM	9
Effort number	EFFORT	1
Type code 1	TYPE1	1
Description 1	DESCR1	26
Amount 1	AMOUNT1	12
Type code 2	TYPE2	1
Description 2	DESCR2	26
Amount 2	AMOUNT2	12
Type code 3	TYPE3	1
Description 3	DESCR3	26
Amount 3	AMOUNT3	12
Type code 4	TYPE4	1
Description 4	DESCR4	26
Amount 4	AMOUNT4	12
Type code 5	TYPE5	1
Description 5	DESCR5	26
Amount 5	AMOUNT5	12
Type code 6	TYPE6	1
Description 6	DESCR6	26
Amount 6	AMOUNT6	12
Type code 7	TYPE7	1
Description 7	DESCR7	26
Amount 7	AMOUNT7	12
Type code 8	TYPE8	1
Description 8	DESCR8	26
Amount 8	AMOUNT8	12
Type code 9	TYPE9	1
Description 9	DESCR9	26
Amount 9	AMOUNT9	12
Amount due	AMOUNTDUE	12
Term	TERM	4
Quantity	QUANTITY	4
Shipping method	SHIPMETHOD	20
Subscription type	SUBTYPE	1
Payment amount	PAYAMOUNT	12
Payment date	PAYDATE	8
Payment description	PAYDESC	16
Credit card number	CCNUM	19
Last 4 digits of credit card number	CCLAST4	4
Credit card expiration date	CCEXP	5
Document descriptors	DOCDESC1-DOCDESC2	18
Message block one	MESSAGE1A-MESSAGE1D	40
Message block two	MESSAGE2A-MESSAGE2D	40
Expiration date	EXPDATE	20
Customer address	SHIPADDR1-SHIPADDR6	40
Company address	COMADDR1-COMADDR5	40
Company phone	COMPHONE	20
Publication payable	PUBPAYABLE	30
Credit card info	CCARDS	31
Company federal tax ID number	FEDTAXID	10
Purchase order number	PONUM	20
Addressee	ADDRESSEE	9
Customer number for bill-to customer	BILLTONUM	9
Customer number for Ship-to customer	SHIPTONUM	9
Agency	AGENCY	6
Customer salutation	SALUTATN	43
Addressee prefix	PREFIX	12
Addressee first name	FNAME	20
Addressee last name	LNAME	30
Addressee suffix	SUFFIX	5
Addressee title	TITLE	40
Addressee company	COMPANY	40
Addressee department	DEPT	40
Addressee street1	STREET1	40
Addressee street2	STREET2	40
Addressee city	CITY	26
Addressee state	STATE	2
Addressee zip or postal code	ZIP	10
Addressee zip+2	ZIP2	2
Addressee country code	CNTRYCODE	4
Addressee country	COUNTRY	24
Addressee carrier route	CARRT	4
Addressee CASS certification date	CASSDATE	8
Addressee postal code position	ZIPLOCATE	1
Addressee sex	SEX	1
Addressee demographic codes	DEMOCODEA-DEMOCODED DEMODATA1-DEMODATA2	4 19
Customer telephone number	PHONE	20
Addressee fax number	FAX	20
Addressee e-mail address	EMAIL	60
Addressee user ID	USERID	15
Addressee password	PASSWORD	15