- Contents
Letter Console Help
Subject Customer Letter Merge Fields
The following table lists the customer fields in the Latitude database that you can insert into letter templates.
|
Field Name |
Field Type |
Description |
|
SubjDebtorID |
Numeric |
Unique ID for the customer that is the subject of the letter. |
|
SubjDebtorName |
String |
Customer's name. Stored as last name, first name, and middle name. |
|
SubjDebtorFirstNameFirst |
String |
Debtor's name in proper format (first name and last name). |
|
SubjDebtorLastName |
String |
Customer's last name. |
|
SubjDebtorFirstName |
String |
Customer's first name. |
|
SubjDebtorOther |
String |
Customer's other or alias name. |
|
SubjDebtorStreet1 |
String |
Customer's address, line 1. |
|
SubjDebtorStreet2 |
String |
Customer's address, line 2. |
|
SubjDebtorCity |
String |
Customer's city. |
|
SubjDebtorState |
String |
Customer's state. |
|
SubjDebtorZipcode |
String |
Customer's ZIP Code. |
|
SubDebtorCSZ |
String |
Customer's city, state, and ZIP Code. |
|
SubjDebtorEmail |
String |
Customer's email address. |
|
SubjDebtorFax |
String |
Customer's fax number. |
|
SubjDebtorDriverLicenseNumber |
String |
Customer's driver's license number. |
|
SubjDebtorDOB |
String |
Customer's date of birth. |
|
SubjDebtorHomePhone |
String |
Customer's home phone number. |
|
SubjDebtorWorkPhone |
String |
Customer's work phone number. |
|
SubjDebtorPager |
String |
Customer's pager number. |
|
SubjDebtorJobName |
String |
Name of customer's employer. |
|
SubjDebtorJobAddr1 |
String |
Address line 1 for customer's employer. |
|
SubjDebtorJobAddr2 |
String |
Address line 2 for customer's employer. |
|
SubjDebtorJobCSZ |
String |
City, state, and ZIP Code for customer's employer. |
|
SubjDebtorJobCity |
String |
City for customer's employer. |
|
SubjDebtorJobState |
String |
State for customer's employer. |
|
SubjDebtorJobZipCode |
String |
ZIP Code for customer's employer. |
|
SubjDebtorJobMemo |
String |
Note regarding customer's employer. |
|
SubjDebtorSpouse |
String |
Name of customer's spouse. |
|
SubjDebtorSpouseHomePhone |
String |
Home phone number for customer's spouse. |
|
SubjDebtorSpouseWorkPhone |
String |
Work phone number for customer's spouse. |
|
SubjDebtorSpouseJobName |
String |
Name of debtor's spouse's employer. |
|
SubjDebtorSpouseJobAddr1 |
String |
Address line 1 for spouse's employer. |
|
SubjDebtorSpouseJobAddr2 |
String |
Address line 2 for spouse's employer. |
|
SubjDebtorSpouseJobCSZ |
String |
City, state, and ZIP Code for spouse's employer. |
|
SubjDebtorSpouseJobMemo |
String |
Note regarding spouse's employer. |

