The Word Records
Note:
Alternate print / routing methods. This section
describes the format of letter extract records that are constructed
by base-package algorithms that are passed to Word, the software that
actually produces the letters. If you require different print formats,
you must create new letter extract algorithms and plug them in on
your letter templates.
Note:
Alternate letter print flat file format. The algorithms
responsible for creating the letter extract records can produce the
output in either Doc1 format (see The
Doc 1 Records) or in Word format (see below). The Doc1 flat
file is created with multiple records of various record types for
every customer contact record processed. The Word flat file is created
with one record for every customer contact record processed. These
algorithms extract the same fields for both formats. However, the
Word flat file has all fields for a letter compressed into one record;
where each field is delimited by a tilde ("~"). You control which
format is used by the parameters you supply to the respective background
processes that call these algorithms. For Doc 1 format, set FIELD-DELIM-SW=N
and CNTL-REC-SW=Y. For Word format, set FIELD-DELIM-SW=Y and CNTL-REC-SW=N.
One record is produced for every letter to be printed. The fields on each record are delimited with a tilde (~).
Field Name | Maximum Size | Source/Value/Description | |
---|---|---|---|
POSTAL | A12 | ||
ENTITY_NAME1 | A64 | CI_PER_NAME1 / Primary name of the person on the Customer Contact record. | |
ENTITY_NAME2 | A64 | CI_PER_NAME2 / Primary name of the person on the Customer Contact record. | |
ENTITY_NAME3 | A64 | CI_PER_NAME3 / Primary name of the person on the Customer Contact record. | |
COUNTRY | A3 | The next group of fields (COUNTRY through IN_CITY_LIMIT) contain the letter's address. | |
ADDRESS1 | A64 | ||
ADDRESS2 | A64 | ||
ADDRESS3 | A64 | ||
ADDRESS4 | A64 | ||
CITY | A30 | ||
NUM1 | A6 | ||
NUM2 | A4 | ||
HOUSE_TYPE | A2 | ||
COUNTY | A30 | ||
STATE | A6 | ||
POSTAL | A12 | ||
GEO_CODE | A11 | ||
IN_CITY_LIMIT | A1 | ||
CC_ID | A10 | CI_CC / System-assigned identifier for a Customer Contact. | |
PER_ID | A10 | CI_CC / System-assigned identifier for the Person who will receive the letter. | |
CC_DT | See Note | CI_CC / The date of the Customer Contact formatted as <month> DD, YYYY. | |
CC_TM | T15 | CI_CC / The time of the Customer Contact. | |
CC_CL_CD | A4 | CI_CC / The category of contact. | |
CC_TYPE_CD | A12 | CI_CC / The type of contact within the category. | |
LTR_TMPL_CD | A12 | CI_CC / The template of the letter. | |
LTR_DT | See Note | From the current system date/time - the date to print on the letter formatted as <month> DD, YYYY. |
Certain types of letters may have additional fields. The topics that follow describe the additional fields that suffix the above fields:
Related Topics:
Parent Topic: Printing Letters