Merge Fields for Word Reports
These are the NLS fields you can use to merge into a Word generated report. Create a Word document (not a mail merge document) and enter the fields by typing CTRL-F9 (this enters the curly brackets) and then entering the merge field command and the appropriate field name (exactly as listed below). Word limits you to a maximum of 63 unique fields per document. Refer to the NLS User Guide, Word Help, and the Microsoft web site for more information on merging and adding Word reports to NLS.
Example
{ MERGEFIELD city } will insert the contact’s city into your document.See the section on Mail Merge Switches for more information on formatting your output using switches.
Contact (CIF) Merge Fields
cifno
|
home1_phone
|
all_cif_detail_udf
|
cifnumber
|
home2_phone
|
all_cif_demo_udf
|
setupdate
|
home_fax_phone
|
all_cif_financial_udf
|
cif_shortname
|
business1_phone
|
company
|
lastname1
|
business2_phone
|
salutation1
|
firstname1
|
mobile_phone
|
salutation2
|
middlename1
|
pager_phone
|
suffix1
|
lastname2
|
other_phone
|
suffix2
|
firstname2
|
all_phones
|
title1
|
middlename2
|
email
|
title2
|
mail_name1
|
cif_tin
|
email1
|
mail_name2
|
cif_entity
|
email2
|
street_address1
|
cif_officer
|
cif_tin1
|
street_address2
|
|
cif_tin2
|
city
|
cif_demographics_56 – cif_demographics_805.19+ |
web_address
|
state
|
cif_financial_56 – cif_financial_805.19+ |
|
zip
|
||
country
|
Loan Merge Fields
loan_number
|
current_payoff_balance
|
mobile_phone
|
acctrefno
|
current_perdiem
|
pager_phone
|
loan_shortname
|
current_suspense
|
other_phone
|
loan_name
|
total_current_due_balance
|
all_phones
|
loan_entity
|
total_past_due_balance
|
email
|
loan_tin
|
addonint_total
|
cif_tin
|
loan_type
|
addonint_remaining
|
cif_entity
|
loan_group
|
cifnumber
|
cif_officer
|
loan_class1
|
cif_setupdate
|
company
|
loan_class2
|
cif_shortname
|
salutation1
|
input_date
|
lastname1
|
salutation2
|
status_code
|
firstname1
|
suffix1
|
loan_officer
|
middlename1
|
suffix2
|
collection_officer
|
lastname2
|
title1
|
starting_interest_rate
|
firstname2
|
title2
|
current_interest_rate
|
middlename2
|
email1
|
next_rate_change_date
|
mail_name1
|
email2
|
curr_date
|
mail_name2
|
cif_tin1
|
curr_maturity_date
|
street_address1
|
cif_tin2
|
payoff_date
|
street_address2
|
web_address
|
last_activity_date
|
city
|
mailname_and_address
|
interest_paid_thru_date
|
state
|
name_and_address
|
principal_paid_thru_date
|
zip
|
amortized_payment_amount
|
interest_accrued_thru_date
|
country
|
all_loan_detail1_udf
|
original_note_amount
|
home1_phone
|
all_loan_detail2_udf
|
current_note_amount
|
home2_phone
|
loan_detail1_01 – loan_detail1_50 |
current_principal_balance
|
home_fax_phone
|
loan_detail2_01 – loan_detail2_50 |
current_interest_balance
|
business1_phone
|
|
current_fees_balance
|
business2_phone
|
|
current_late_charge_balance
|
Statement Merge Fields
mailname_and_address
|
suffix2
|
payment_description
|
name_and_address
|
title1
|
payment_amount
|
cifno
|
title2
|
payment_paid
|
cifnumber
|
cif_tin1
|
payment_remaining
|
cif_shortname
|
cif_tin2
|
maturity_date
|
lastname1
|
loan_officer
|
minimum_payment_amount
|
firstname1
|
loan_number
|
credit_line_limit
|
middlename1
|
loan_tin
|
balloon_payment_amount
|
lastname2
|
statement_date
|
balloon_payment_date
|
firstname2
|
statement_due_date
|
amortized_payment_amount
|
middlename2
|
current_rate
|
last_payment_amount
|
mail_name1
|
total_past_due_bal
|
last_payment_date
|
mail_name2
|
total_current_due_bal
|
extra_line_if_duedate_changed
|
street_address1
|
original_note_amt
|
skip_tot_payment
|
street_address2
|
current_note_amt
|
this_period_advances
|
city
|
current_principal_bal
|
this_period_payments
|
state
|
current_interest_bal
|
this_period_interest
|
zip
|
current_fees_bal
|
this_period_fees
|
country
|
current_late_charge_bal
|
this_period_late_charges
|
entity_type
|
current_payoff_bal
|
this_period_debit
|
company
|
current_perdiem
|
this_period_credit
|
salutation1
|
addonint_total
|
this_period_udf_1 – this_period_udf_10 |
salutation2
|
addonint_remaining
|
this_period_number_of_days
|
suffix1
|
date_due
|
item_date_order_descending
|
