- Contents
Letter Console Help
Basic Letter Merge Fields
The following table lists the basic fields in the Latitude database that you can insert into letter templates.
Field Name |
Field Type |
Description |
LetterCode |
String |
Five-digit letter code assigned in the Letter Console program. Used for internal reference purposes. |
DebtorID |
Numeric |
Unique customer ID for the primary customer on the account. |
Name |
String |
Primary customer's name as stored in Latitude. Stored in last name, first name middle name format. |
FirstNameFirst |
String |
Primary customer's name in proper format (first name last name). |
LastName |
String |
Primary customer's last name. |
FirstName |
String |
Primary customer's first name (only). |
Prefix |
String |
Customer's name prefix. |
Middle Name |
String |
Customer's middle name. |
Middle Initial |
String |
Customer's middle initial. |
Suffix |
String |
Customer's name suffix. |
BusinessName |
String |
If the customer is a business, the business name on the account. |
FormattedName |
String |
Customer's name in proper format (first name, middle initial, and last name with appropriate prefix and suffix). |
Other |
String |
Primary customer's other or alias name. |
Street1 |
String |
Primary customer's address line 1. |
Street2 |
String |
Primary customer's address line 2. |
City |
String |
Primary customer's city. |
State |
String |
Primary customer's state. |
Zipcode |
String |
Primary customer's ZIP Code. |
CSZ |
String |
Primary customer's city, state, and ZIP Code (combined). |
|
String |
Primary customer's email address. |
Fax |
String |
Primary customer's fax number. |
DriverLicenseNumber |
String |
Primary customer's driver's license number. |
WebPayLogin |
String |
N/A |
Number |
Numeric |
Unique account number that Latitude assigned to the account. |
Desk |
String |
Desk of the user requesting the letter. |
DeskName |
String |
Desk assigned to the account. |
DeskAlias |
String |
Alias field of desk table, which currently does not have a user interface to populate the information. |
DeskExtension |
String |
Desk phone extension. |
DeskEmail |
String |
Desk email setting. |
DeskSpecial1 |
String |
Special1 field in desk table. |
DeskSpecial2 |
String |
Special2 field in desk table. |
DeskSpecial3 |
String |
Special3 field in desk table. |
Account |
String |
Your client's (external) account number for the account. |
Received |
Date |
Date your agency received the account. |
Lastpaid |
Date |
Date of last payment (since your organization added the account to Latitude). |
LastPaidAmount |
Money |
Amount of payment last received on the account. |
InterestRate |
Number |
Interest rate percent set for the account. |
UserDate1 |
Date |
Agency customized date information 1. |
UserDate2 |
Date |
Agency customized date information 2. |
UserDate3 |
Date |
Agency customized date information 3. |
SSN |
String |
Primary customer's social security number. |