|
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. |
|
|
