CUST_SERV_LETTERS

Description:

Extracts list of letters and envelopes attached to Customer Service (NCS) communication.

Primary Key

Column Name	Ordinal Position
COMM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	COMM_ID	NUMERIC	No
	The unique identifier for the customer service communication.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	LTR_HNO_ID	VARCHAR	No
	The ID of the note record that stores the text of the letter or envelope.
4	LTR_ETX_ID	VARCHAR	No
	The ID of the SmartText template record for the letter or envelope.
5	LTR_ETX_ID_SMARTTEXT_NAME	VARCHAR	No
	The name of the SmartText record.
6	LTR_SUMMARY	VARCHAR	No
	This column contains the first 254 characters of the letter or envelope associated with the customer service communication.
7	LTR_NAME	VARCHAR	No
	The name of the letter or envelope template.
8	LTR_CREATE_DATE	DATETIME	No
	The date the letter or envelope was added to the customer service communication.
9	LTR_CREATE_TIME	DATETIME (Local)	No
	The time the letter or envelope was added to the customer service communication.
10	LTR_USER_ID	VARCHAR	No
	The ID of the user who created the letter or envelope in the customer service communication.
11	LTR_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.