Feedback

  • Contents
 

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

Email

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.

Related Topics

Letter Pool

Letter Merge Fields

Modify a Letter Template