Navigation: Appendix A - Merge Field Descriptions (Loans) >
This event record is not generated automatically. It must be requested; however, if no payoff record exists the letter will not be created. This letter can also be requested by using the Letter Date and Letter # fields on the Loans > Payoff screen. Only event letter number 14 can be requested from that screen.
Merge Field |
Field Mnemonic/ Calculation |
Description |
Format/ Example |
|---|---|---|---|
ACCOUNT_FIRST_MIDDLE_LAST_NAME_1 |
|
First middle last name of name 1 on account |
John H Doe |
ACCOUNT_FIRST_MIDDLE_LAST_NAME_2 |
|
First middle last name of name 2 on account |
Jane Q Public |
ACCOUNT_FIRST_MIDDLE_LAST_NAME_3 |
|
First middle last name of name 3 on account |
Sam B Adams |
ACCOUNT_FIRST_MIDDLE_LAST_NAME_4 |
|
First middle last name of name 4 on account |
Ann R Jones |
ACCOUNT_FIRST_NAME_1 |
PNFNAM |
First name of name 1 on acct |
John |
ACCOUNT_FIRST_NAME_2 |
PNFNAM |
First name of name 2 on acct |
Jane |
ACCOUNT_FIRST_NAME_3 |
PNFNAM |
First name of name 3 on acct |
Sam |
ACCOUNT_FIRST_NAME_4 |
PNFNAM |
First name of name 4 on acct |
Ann |
ACCOUNT_LAST_NAME_1 |
PNLNAM |
Last name of name 1 on acct |
Doe |
ACCOUNT_LAST_NAME_2 |
PNLNAM |
Last name of name 2 on acct |
Public |
ACCOUNT_LAST_NAME_3 |
PNLNAM |
Last name of name 3 on acct |
Adams |
ACCOUNT_LAST_NAME_4 |
PNLNAM |
Last name of name 4 on acct |
Jones |
ACCOUNT_SUFFIX_1 |
PNSFFX |
Suffix of name 1 on acct |
|
ACCOUNT_SUFFIX_2 |
PNSFFX |
Suffix of name 2 on acct |
|
ACCOUNT_SUFFIX_3 |
PNSFFX |
Suffix of name 3 on acct |
|
ACCOUNT_SUFFIX_4 |
PNSFFX |
Suffix of name 4 on acct |
|
ACCRUED_INTEREST |
LNACIN |
Accrued interest on loan |
2,140.40 |
APPOINTMENT_DATE |
EVACDT |
Date used with action code 210; only for events 23 and 24 |
|
APPOINTMENT_DATE_ALPHA |
|
Date used with action code 210 in alphanumeric format; only for events 23 and 24. |
For example: January 2, 2018 instead of 01-02-18. |
APPOINTMENT_TIME |
EVTIME |
Time used with action code 211; only for events 23 and 24 |
|
APPRAISAL_AMOUNT |
LNAPAM |
Appraisal amount |
8,000,000.00 |
APPRAISAL_DATE |
LNAPSR |
Appraisal date |
08-01-2017 |
APPRAISAL_DATE_ALPHA |
|
Appraisal date in alphanumeric format |
August 01, 2017 |
ARM_1ST_RATE_CHANGE_DATE |
LN1ROL |
Date of 1st rate roll |
09-01-2017 |
ARM_1ST_RATE_CHANGE_DATE_ALPHA |
|
Date of 1st rate roll in alphanumeric format |
September 01, 2017 |
ARM_ACCRUAL_RATE |
LNAMRT |
Accrual rate on loan |
.00000 |
ARM_ACCRUAL_RATE_LIFETIME_MIN |
LNAMLO |
Minimum rate allowed on loan |
.00000 |
ARM_ACCRUAL_RATE_LIFETIME_MAX |
LNAMHI |
Maximum rate allowed on loan |
.00000 |
ARM_ACCRUAL_RATE_MAX_PTS_DOWN |
LNAMRD |
Maximum points per period the rate can decrease |
.00000 |
ARM_ACCRUAL_RATE_MAX_PTS_UP |
LNAMRU |
Maximum points per period the rate can increase |
.00000 |
ARM_ACCRUAL_RATE_OFFSET |
LNAMOF |
Accrual rate offset |
.00000 |
ARM_MAX_PRINCIPAL_BALANCE |
LNAMMX |
Maximum principal balance that the loan is allowed to reach |
.00 |
ARM_NEXT_ACCR_RATE_CHANGE_DATE |
LNAMDT
|
Next rate change date |
09-01-2017 |
ARM_NEXT_ACCR_RATE_CHANGE_DATE_ALPHA |
|
Next rate change date in alphanumeric format |
September 01, 2017 |
ARM_P_I_CONSTANT_CHANGE_DATE |
LNPIEF |
Next P/I change date |
09-01-2017 |
ARM_P_I_CONSTANT_CHANGE_DATE_ ALPHA |
|
Next P/I change date in alphanumeric format |
September 01, 2017 |
ASSET_CLASSIFICATION |
LNACLS |
Asset classification |
0 |
BALLOON_DATE |
|
Date used with action code 1 |
09-01-2017 |
BALLOON_DATE_ALPHA |
|
Date used with action code 1 in alphanumeric format |
September 01, 2017 |
BANK_ROUTING_NUMBER |
LNABNK |
Bank routing/transit number |
0 |
BANK_SOURCE_ACCOUNT_NUMBER |
LNANBR |
Savings or checking that will be debited for loan payment |
|
BRANCH_ADDRESS_LINE_1 |
OBADD1 |
Address line 1 where the office is located |
PO Box 1099 |
BRANCH_ADDRESS_LINE_2 |
OBADD2 |
Address line 2 where the office is located |
850 Cheetah Avenue |
BRANCH_CITY_STATE_ZIP |
OBCITY, OBSTAB, OBZIPC, OBZIP4 |
City, state, ZIP, and ZIP+4 where the office is located |
Provo UT 84601-1234 |
BRANCH_MANAGER_NAME |
LOONAM
|
Adds the name of the Servicing Officer to the event letter |
John Jones |
BRANCH_NAME |
OBFNAM |
Name or description of office |
Provo |
BRANCH_PHONE_NUMBER |
OBPHAC, OBPHPF, OBPHON |
Phone number for the office formatted (xxx) xxx-xxxx |
(555) 469-7723 |
COLLATERAL_DESCRIPTION |
LNCLDS |
Collateral description |
123 Boat Basin Rd., Provo, UT 84601 |
CURRENT_LTV |
LNPBAL + LNBAL2 / LNSELL or / LNAPAM |
Current loan-to-value ratio, which is the principal balance plus the secondary balance divided by the lesser of the selling price or the appraisal amount. If the selling price or appraisal amount fields are zero, the field with a value will be used for the calculation. |
7.881 |
DATE_INTEREST_PAID_TO |
LNPDTO |
Date interest is paid to |
12-01-2016 |
DATE_INTEREST_PAID_TO_ALPHA |
|
Date interest is paid to in alphanumeric format |
December 01, 2016 |
DATE_LAST_ACCRUED |
LNDLAC |
Date of last interest accrual |
12-01-2016 |
DATE_LAST_ACCRUED_ALPHA |
|
Date of last interest accrual in alphanumeric format |
December 01, 2016 |
DATE_LAST_LATE |
LNLTDT |
Date of last late charge assessment |
02-16-2017 |
DATE_LAST_LATE_ALPHA |
|
Date of last late charge assessment in alphanumeric format |
February 16, 2017 |
DATE_OF_LAST_CHECK |
|
Date used with action code 212 |
02-16-2017 |
DATE_OF_LAST_CHECK_ALPHA |
|
Date used with action code 212 in alphanumeric format |
February 16, 2017 |
DATE_OPENED |
LNOPND |
Date the loan was opened |
09-16-1997 |
DATE_OPENED_ALPHA |
|
Date the loan was opened in alphanumeric format |
September 16, 1997 |
DUE_DATE |
LNDUDT |
Loan due date |
01-01-2017 |
DUE_DATE_ALPHA |
|
Loan due date in alphanumeric format |
January 01, 2017 |
EFFECTIVE_RATE_X |
LNAMRT or LNRATE or LNLRAT |
Loan effective rate: interest rate; accrual rate; LIP rate for LIP method code 1 or 101 |
6.75000 |
EVENT_DATE |
LNEVDT |
Date of the event letter |
03-08-2017 |
EVENT_DATE_ALPHA |
|
Date of the event letter in alphanumeric format |
March 08, 2017 |
EVENT_DATE1 |
|
Date of the first event letter |
03-08-2017 |
EVENT_LETTER |
|
Four-digit event number for events with different options |
0000 |
EVENT_NUMBER |
|
System-defined event number |
0014 |
EXTRA_PRINCIPAL |
LNOPMT |
Amount of extra principal to be added to the principal |
.00 |
FIRST_DUE_DATE |
LN1DUE |
Date the first payment is due |
11-01-1997 |
FIRST_DUE_DATE_ALPHA |
|
Date the first payment is due in alphanumeric format |
November 01, 1997 |
FORMATTED_LOAN_NUMBER |
|
Uses XXXX-XXXXXX-XX instead of actual account number |
0001-109641-05 |
FORMATTED_LOAN_NUMBER_NO_LEAD_ZERO |
|
Formats the Loan account number by automatically removing leading zeros. |
1-109641-05 |
FUTURE_LATE_CHARGE |
Calculated late charge |
The late charge is calculated in the GOLD EventLetters program. It is not included in the PO_AMOUNT. You should use the TOTAL_WITH_FUTURE_LATE_CHARGE (see below) to disclose the payoff, including the future late charge.
Note: To include future late charges in the payoff quote, institution option OP06 AFLC must be set. |
.00 |
GRACE_DAYS |
LNLTGR |
Number of days after the due date that are allowed on the loan before the late charge is assessed |
15 |
INSURER_CODE |
LNINSU |
Insurer code |
0 |
INTEREST_CALCULATION_CODE |
LNIBAS |
Base to use to calculate loan interest |
2 |
INTEREST_RATE |
LNRATE |
Annual interest rate or payment rate for payment method 7 loans |
6.75000 |
INVESTOR_GROUP |
LNIGRP |
Investor group number |
0 |
INVESTOR_MASTER |
LNIMST |
Investor master number |
0 |
INVESTOR_NAME |
IMNAM |
Investor name |
|
IRS_OWNER_FIRST_MIDDLE_LAST_NAME |
|
IRS owner’s first middle last name |
John H Doe |
IRS_OWNER_FIRST_NAME |
PNFNAM |
IRS owner’s first name |
John |
IRS_OWNER_LAST_NAME |
MNLNAM |
IRS owner’s last name |
Doe |
IRS_OWNER_SSN |
MNCSSN |
IRS owner’s social security number |
550-39-7079 |
IRS_OWNER_SUFFIX |
MNSFFX |
IRS owner’s suffix |
E.g., Jr., DDS |
IRS_OWNER_TITLE |
MNTITL |
IRS owner’s title |
E.g., Mrs., Dr. |
LABEL_LINE1 |
|
Use Label Lines 1-6 instead of name and address lines to eliminate blank lines from appearing between the borrower names and address lines.
WARNING: If Label Lines are used, then all six must be set up in the letter. Basically, the number of street address lines on the account determines how many name lines will be printed, and up to four names will be printed depending on how many address lines are used. |
Communication Properties |
LABEL_LINE2 |
|
See LABEL_LINE1 description. |
PO Box 2017 |
LABEL_LINE3 |
|
See LABEL_LINE1 description. |
Provo UT 84601 |
LABEL_LINE4 |
|
See LABEL_LINE1 description. |
|
LABEL_LINE5 |
|
See LABEL_LINE1 description. |
|
LABEL_LINE6 |
|
See LABEL_LINE1 description. |
|
LATE_CHARGES |
LNLATE |
Late charges on loan |
637.38 |
LATE_CHARGES_AND_FEES |
LNLATE + LNFEES |
Late charges plus total loan fees |
652.38 |
LATE_CHARGES_PROJECTED |
Calculate LATE |
Projected late charges for current payment |
318.69 |
LATE_RATE |
LNLTRT |
Late rate |
5.00 |
LINE_OF_CREDIT_LIMIT |
LNRLCL |
Line of credit limit |
.00 |
LIP_ACCRUED_INTEREST |
LNLACC |
LIP accrued interest |
.00 |
LIP_CUSTOMER_BALANCE |
LNCBAL |
LIP customer balance |
.00 |
LIP_DISBURSED_BALANCE |
LNPBAL - LNLBAL |
LIP disbursed balance |
380,514.90 |
LIP_INTEREST_RATE |
LNLRAT |
LIP interest rate |
.00000 |
LIP_LIFETIME_MAX |
LNLMAX |
LIP lifetime maximum rate |
.00000 |
LIP_LIFETIME_MIN |
LNLMIN |
LIP lifetime minimum rate |
.00000 |
LIP_RATE_OFFSET |
LNLOFF |
LIP rate offset |
.00000 |
LIP_UNDISBURSED_BALANCE |
LNLBAL |
Amount of funds not yet disbursed |
.00 |
LOAN_FEES |
LNFEES |
Total loan fees |
.00 |
LOAN_OFFICER_NUMBER |
LNOFCR |
Loan officer number |
|
MAIL_ADDRESS_CITY |
MNCITY |
Entity Maintenance to Mailing Label |
Provo |
MAIL_ADDRESS_CITY_STATE_ZIP |
|
Entity Maintenance to Mailing Label |
Provo UT 84601 |
MAIL_ADDRESS_LINE1 |
MNADD1 |
Entity Maintenance to Mailing Label |
PO Box 2017 |
MAIL_ADDRESS_LINE2 |
MNADD2 |
Entity Maintenance to Mailing Label |
|
MAIL_ADDRESS_STATE |
MNSTAB |
Entity Maintenance to Mailing Label |
UT |
MAIL_ADDRESS_ZIP |
MNZIPC |
Entity Maintenance to Mailing Label |
84601 |
MAIL_ADDRESS_ZIP4 |
MNZIP4 |
Entity Maintenance to Mailing Label |
1234 |
MATURITY_DATE |
LNMATD |
Loan maturity date |
12-01-2023 |
MATURITY_DATE_ALPHA |
|
Loan maturity date in alphanumeric format |
December 01, 2023 |
MISCELLANEOUS_FUNDS |
LNMISC |
Loan miscellaneous funds |
.00 |
NEXT_PAYMENT_DUE |
Calculated |
Next payment due on the account |
6,373.77 |
NEXT_PAYMENT_INTEREST_PORTION |
Calculated |
Interest portion of current next payment |
2,140.40 |
NEXT_PAYMENT_PRINCIPAL_PORTION |
Calculated |
Principal portion of current next payment |
4,233.37 |
NEXT_PMT_WITH_EXTRA_PRINCIPAL |
Calculate NEXT PYMT + LNOPMT |
Calculated next payment plus extra principal |
6,473.77 |
NUMBER_DWELLING_UNITS |
LODWEL |
Number of dwelling units on the property securing the loan |
1 |
NUMBER_PAYMENTS_DELINQUENT |
RUN DATE - LNDUDT + 1 / LNFREQ |
Month’s difference between current run date and due date plus one divided by the loan frequency. Bi-weekly loans calculate the number of payments delinquent by taking the days’ difference between the run date and due date divided by 14 plus one. |
3 |
ORIGINAL_PRINCIPAL_BALANCE |
LNOBAL |
Original principal balance |
1,450,000.00 |
ORIGINATION_OFFICER |
LOONAM |
Adds the name of the originating officer to the event letter |
Jeff Hyde |
P_I_CONSTANT |
LNPICN |
Principal/interest payment |
6,373.77 |
PARTIAL_OR_APPLIED_TO_PAYMENTS |
LNPRTL |
Partial or applied to payments |
.00 |
PAYMENT_FREQUENCY |
LNFREQ |
Loan payment frequency |
1 |
PER_DIEM |
LNPBAL + LNRATX / LNIBAS |
One day’s interest calculated by taking the principal balance multiplied by the effective rate divided by the interest base. |
71.35 |
PO_ACCRUED_INTEREST |
POACIN |
Accrued interest applied to payoff |
0.00 |
PO_AMOUNT |
POPOFF |
Payoff amount – includes all amounts applied to payoff. Refer to the TOTAL_WITH_FUTURE_LATE_CHARGE field below for more information regarding the PO_AMOUNT. |
388,072.90 |
PO_CUSTOMER_MESSAGE_LINE_1 |
POMES1 |
First customer message line from payoff record |
|
PO_CUSTOMER_MESSAGE_LINE_2 |
POMES2 |
Second customer message line from payoff record |
|
PO_CUSTOMER_MESSAGE_LINE_3 |
POMES3 |
Third customer message line from payoff record |
|
PO_DATE |
PODATE |
Payoff date |
03-08-2017 |
PO_DATE_ALPHA |
|
Payoff date in alphanumeric format |
March 08, 2017 |
PO_EXPIRATION_DATE |
POEXPD |
Date the payoff expires |
03-09-2017 |
PO_EXPIRATION_DATE_ALPHA |
|
Date the payoff expires, in alphanumeric format |
March 09, 2017 |
PO_FEES |
POFEES |
Loan fees applied to payoff |
.00 |
PO_INTEREST_CALCULATION_CODE |
POIBAS |
Interest calculation method from the payoff record |
2 |
PO_INTEREST_ON_NEGATIVE_RESERVES |
POINRI |
Interest on negative escrow/reserves applied to payoff |
.00 |
PO_LATE_CHARGES |
POLATE |
Late charges applied to payoff |
637.38 |
PO_LIP_ACCRUED_INTEREST |
POLACC |
LIP accrued interest applied to payoff |
.00 |
PO_LIP_CUSTOMER_BALANCE |
POCBAL |
LIP customer balance applied to payoff |
.00 |
PO_LIP_UNDISBURSED_BALANCE |
POLBAL |
LIP undisbursed balance applied to payoff |
.00 |
PO_MISC_ADJUSTMENT_AMT_1 |
POAMT1 |
Payoff miscellaneous adjustment amount 1 |
.00 |
PO_MISC_ADJUSTMENT_AMT_2 |
POAMT2 |
Payoff miscellaneous adjustment amount 2 |
.00 |
PO_MISC_ADJUSTMENT_AMT_3 |
POAMT3 |
Payoff miscellaneous adjustment amount 3 |
.00 |
PO_MISC_ADJUSTMENT_AMT_4 |
POAMT4 |
Payoff miscellaneous adjustment amount 4 |
.00 |
PO_MISC_ADJUSTMENT_AMT_5 |
POAMT5 |
Payoff miscellaneous adjustment amount 5 |
.00 |
PO_MISC_ADJUSTMENT_AMT_6 |
POAMT6 |
Payoff miscellaneous adjustment amount 6 |
.00 |
PO _MISC_ADJUSTMENT_AMT_7 |
POAMT7 |
Payoff miscellaneous adjustment amount 7 |
.00 |
PO_MISC_ADJUSTMENT_AMT_8 |
POAMT8 |
Payoff miscellaneous adjustment amount 8 |
.00 |
PO_MISC_ADJUSTMENT_AMT_9 |
POAMT9 |
Payoff miscellaneous adjustment amount 9 |
.00 |
PO_MISC_ADJUSTMENT_AMT_10 |
POAMT10 |
Payoff miscellaneous adjustment amount 10 |
.00 |
PO_MISC_ADJUSTMENT_AMT_11 |
POAMT11 |
Payoff miscellaneous adjustment amount 11 |
.00 |
PO_MISC_ADJUSTMENT_AMT_12 |
POAMT12 |
Payoff miscellaneous adjustment amount 12 |
.00 |
PO_MISC_DESCRIPTION_1 |
POFLD1 |
Payoff miscellaneous description 1 |
|
PO_MISC_DESCRIPTION_2 |
POFLD2 |
Payoff miscellaneous description 2 |
|
PO_MISC_DESCRIPTION_3 |
POFLD3 |
Payoff miscellaneous description 3 |
|
PO_MISC_DESCRIPTION_4 |
POFLD4 |
Payoff miscellaneous description 4 |
|
PO_MISC_DESCRIPTION_5 |
POFLD5 |
Payoff miscellaneous description 5 |
|
PO_MISC_DESCRIPTION_6 |
POFLD6 |
Payoff miscellaneous description 6 |
|
PO_MISC_DESCRIPTION_7 |
POFLD7 |
Payoff miscellaneous description 7 |
|
PO_MISC_DESCRIPTION_8 |
POFLD8 |
Payoff miscellaneous description 8 |
|
PO_MISC_DESCRIPTION_9 |
POFLD9 |
Payoff miscellaneous description 9 |
|
PO_MISC_DESCRIPTION_10 |
POFLD10 |
Payoff miscellaneous description 10 |
|
PO_MISC_DESCRIPTION_11 |
POFLD11 |
Payoff miscellaneous description 11 |
|
PO_MISC_DESCRIPTION_12 |
POFLD12 |
Payoff miscellaneous description 12 |
|
PO_MISCELLANEOUS_FUNDS |
POMISC |
Miscellaneous funds applied to payoff |
.00 |
PO_NAME_LINE_1 |
PONLN1 |
Name line 1 from the payoff record |
|
PO_NAME_LINE_2 |
PONLN2 |
Name line 2 from the payoff record |
|
PO_NAME_LINE_3 |
PONLN3 |
Name line 3 from the payoff record |
|
PO_NAME_LINE_4 |
PONLN4 |
Name line 4 from the payoff record |
|
PO_PARTIAL_PAYMENTS |
POPRTL |
Partial payments applied to payoff |
.00 |
PO_PER_DIEM |
PODIEM |
One day’s accrued interest of the principal balance plus deferred interest |
71.35 |
PO_PER_DIEM_3_DECIMALS |
|
One day’s accrued interest of the principal balance plus deferred interest, to three decimal places |
71.347 |
PO_PER_DIEM_CALCULATION_CODE |
POPDBS |
Interest method used to figure payoff per diem |
2 |
PO_PRINCIPAL_BALANCE |
POPBAL + PODEFI |
Principal plus deferred interest applied to payoff |
380,514.90 |
PO_RATE |
PORATE |
Payoff rate |
6.75000 |
PO_RSV_1_AND_RSV_2_INTEREST |
POR1AI + POR2AI |
Escrow and Reserve interest subtracted from payoff |
.00 |
PO_RSV_1_AND_RSV_2_BALANCES |
POR1BL + POR2BL |
Escrow and Reserve balances subtracted from payoff |
.00 |
PO_SUBSIDY_BALANCE |
POSBAL |
Subsidy balance subtracted from payoff when applied |
.00 |
PRIME_LOWER_LIMIT |
LNPSLO |
Minimum rate allowed on loan after adding index rate plus margin |
.00000 |
PRIME_UPPER_LIMIT |
LNPSHI |
Maximum rate allowed on loan after adding index rate plus margin |
.00000 |
PRINCIPAL_BALANCE |
LNPBAL |
Principal balance on loan |
380,514.90 |
PROPERTY_ADDRESS_CITY |
MNCITY |
City where the property is located |
Provo |
PROPERTY_ADDRESS_CITY_STATE_ZIP |
|
Property address city, state and ZIP |
Provo UT 84601 |
PROPERTY_ADDRESS_LINE1 |
MNADD1 |
Address line 1 where the property is located |
1608 Boat Basin Rd |
PROPERTY_ADDRESS_LINE2 |
MNADD2 |
Address line 2 where the property is located |
Waterfront Inn |
PROPERTY_ADDRESS_STATE |
MNSTAB |
State where the property is located |
UT |
PROPERTY_ADDRESS_ZIP |
MNZIPC |
ZIP where the property is located |
84045 |
PROPERTY_ADDRESS_ZIP4 |
MNZIP4 |
ZIP plus 4 where the property is located |
1234 |
PROPERTY_COUNTY |
|
|
Fulton |
PROPERTY_DESC_LINE_1 |
|
|
0827WE5139 |
PROPERTY_DESC_LINE_2 |
|
|
|
PROPERTY_DESC_LINE_3 |
|
|
|
PROPERTY_DESC_LINE_4 |
|
|
|
PROPERTY_DESC_LINE_5 |
|
|
|
PROPERTY_DESC_LINE_6 |
|
|
|
PROPERTY_DESC_LINE_7 |
|
|
|
PROPERTY_DESC_LINE_8 |
|
|
|
PROPERTY_DESC_LINE_9 |
|
|
|
PROPERTY_DESC_LINE_10 |
|
|
|
RATE_OFFSET_MARGIN |
LNROFF |
Interest rate offset margin |
.00000 |
RATE_ROUNDING_FACTOR |
LNRRND |
Prints the rounded rate factor, such as 1/4th, 1/8th, 1/10th, 1/16th, or none. This information is pulled from the Round Rate To Nearest field (LNRRND) on the Loans > Account Information > Account Detail screen in CIM GOLD. |
NONE |
REMAIN_PORTION_DUE__ |
LNRPDU |
Remaining unpaid portion of payment |
.00 |
REMAINING_TERM |
LNTERM / LNFREQ - LNINNO |
Remaining term on the loan.
Loan term divided by the loan frequency minus the installment number.
For bi-weekly loans, take the term in months divided by 12 multiplied by 26 to get the number of payments. Subtract the installment from the number of payments to get remaining payments. Take remaining payments divided by 26, then multiply by 12 to get remaining term in months. |
84 |
RESERVE_1_BAL_PLUS_RESERVE_2_BAL |
LNR1BL + LNR2BL |
Sum of Escrow and Reserve balances |
.00 |
RESERVE_1_BALANCE |
LNR1BL |
Escrow balance |
.00 |
RESERVE_1_CON_PLUS_RESERVE_2_CON |
LNR1CN + LNR2C |
Sum of Escrow and Reserve payments |
.00 |
RESERVE_1_CONSTANT |
LNR1CN |
Escrow payment |
.00 |
RESERVE_2_BALANCE |
LNR2BL |
Reserve balance |
.00 |
RESERVE_2_CONSTANT |
LNR2CN |
Reserve payment |
.00 |
SECURED_ACCOUNT_NUMBER |
|
Places X’s in part of the account number, e.g., XX-XX1234-12 |
XX-XX1234-12 |
SECURITY_ACCOUNT |
LNSECX |
Deposit account that secures the loan |
|
SUBSIDY_BALANCE |
LNSBAL |
Subsidy balance |
.00 |
SUBSIDY_CONSTANT |
LNSCON |
Subsidy payment |
.00 |
TERM_OF_LOAN |
LNTERM |
Term of the loan |
314 |
TIMES_30_LATE_LAST_12_MONTHS |
BU12M |
30+ days late in the last 12 months |
2 |
TIMES_60_LATE_LAST_24_MONTHS |
BU24M |
60+ days late in the last 24 months |
1 |
TIMES_LATE |
LNLTNO |
Number of times the loan has been late |
2 |
TIMES_LATE_10_TO_29 |
LNLT10 |
Number of times over life of loan payment has been made 10-29 days after due date |
3 |
TIMES_LATE_30_TO_59 |
LNLT30 |
Number of times over life of loan payment has been made 30-59 days after due date |
1 |
TIMES_LATE_60_TO_89 |
LNLT60 |
Number of times over life of loan payment has been made 60-89 days after due date |
0 |
TIMES_LATE_90_OVER |
LNLT90 |
Number of times over life of loan payment has been made 90+ days after due date |
0 |
TIMES_LATE_LAST_2_YEARS |
LNDELQ |
Times late in past 2 years |
2 |
TOTAL_DUE |
Calculate PMTS + LNLATE + LNFEES - LNPRTL + LNRPDU
For payment method 3 or 6 loans with option OP01 ILF6 set to "Y," the total due is calculated as follows:
PMTS + LNLATE + LNFEES - LNPRTL + LNRPDU + LNPDUE + LNVPRN |
All payments (principal, interest, and escrow/reserves) that are due (all payments where the loan due date is less than or equal to the run date) plus late charges and loan fees minus partial plus remaining portion due; payment method 5 all payments that have been billed (total of all billings on the Billing & Coupons screen) plus late charges and loan fees plus remaining portion due; LIP loans use prior unpaid charges plus late charges and loan fees. |
19,758.69 |
TOTAL_DUE_AFTER_GRACE |
Calculate PMTS + LNLATE + LNFEES - LNPRTL + LNRPDU
For payment method 3 or 6 loans with option OP01 ILF6 set to "Y," the total due is calculated as follows:
PMTS + LNLATE + LNFEES - LNPRTL + LNRPDU + LNPDUE + LNVPRN |
All payments (principal, interest and escrow/reserves) that are due (all payments where the loan due date is less than or equal to the run date) plus late charges and loan fees minus partial plus remaining portion due; payment method 5 all payments that have been billed (total of all billings on the Billing & Coupons screen) plus late charges and loan fees plus remaining portion due; LIP loans use prior unpaid charges plus late charges and loan fees. |
13,384.92 |
TOTAL_DUE_TO_BALLOON_OR_MATURITY |
LNPBAL + Calculate INT + LNLATE + LNFEES - LNR1BL - LNR2BL - LNSBAL - LNR1AI - LNR2A1 - LNMISC + NIR1AC + NIR2AC - LNLBAL - LNCBAL - LNPTRL (excluding method 5 OR 6) |
Total due (includes all charges due) to the lesser of the balloon date or the maturity day. If no balloon date or maturity date, interest will be calculated to the run date. This uses the current principal balance. Also see TOTAL_DUE_AT_MATURITY (LETT01) for events 25, 26, and 27. It amortizes payments to maturity date. When the payments are amortized, the system makes pseudo-payments so the principal balance used is the amortized balance instead of the current principal balance. |
560,945.57 |
TOTAL_INT_TO_BALLOON_OR_MATURITY |
Calculate INT |
Total interest due to the lesser of the balloon date or the maturity date. If no balloon or maturity date, interest will be calculated to the run date. |
793.29 |
TOTAL_PAYMENTS_DUE |
Calculate PMTS |
Total payments due (principal, interest, and escrow/reserves) where the loan due date is less than or equal to the run date |
19,121.31 |
TOTAL_PMTS_W_FEES_AND_LATE_CHGS |
Calculate PMTS + LNLATE + LNFEES |
Total payments due (principal, interest, and escrow/reserves) where the loan due date is less than or equal to the run date plus late charges and loan fees |
19,758.69 |
TOTAL_PMTS_W_FEES_AND_PARTIAL |
Calculate PMTS + LNFEES - LNPRTL |
Total payments due (principal, interest, and escrow/reserves) where the due date is less than or equal to the run date plus loan fees minus partial |
19,121.31 |
TOTAL_PMTS_W_LATE_AND_PARTIAL |
Calculate PMTS + LNLATE - LNPRTL |
Total payments due (principal, interest, and escrow/reserves) where the loan due date is less than or equal to the run date plus late charges minus partial |
19,758.69 |
TOTAL_PMTS_WITH_LATE_CHARGES |
Calculate PMTS + LNLATE |
Total payments due (principal, interest, and escrow/reserves) where the loan due date is less than or equal to the run date plus late charges |
19,758.69 |
TOTAL_PMTS_WITH_LOAN_FEES |
Calculate PMTS + LNFEES |
Total payments due (principal, interest, and escrow/reserve) where the loan due date is less than or equal to the run date plus loan fees |
19,121.31 |
TOTAL_PMTS_WITH_PARTIAL |
Calculate PMTS - LNPRTL |
Total payments due (principal, interest, and escrow/reserve) where the loan due date is less than or equal to the run date minus partial |
19,121.31 |
TOTAL_PRINCIPAL_AND_INTEREST_DUE |
Calculate LC PRIN / INT |
Total principal and interest due where the due date is less than or equal to the run date (does not work for payment method 5) |
19,121.31 |
TOTAL_WITH_FUTURE_LATE_CHARGE |
POPOFF plus calculated late charge |
This is the PO_AMOUNT plus the future late charge. Refer to the PO_AMOUNT field above for more information regarding this field.
Note: To include future late charges in the payoff quote, institution option OP06 AFLC must be set. |
388,072.90 |
TRANSFER_ACCOUNT |
LNXFRX |
Account number of savings or checking account used as the transfer account |
|
TYPE |
LNTYPC |
Type of loan account |
1 |
USER_DEFINED_C17 |
UFC17 |
User-defined field C17 |
|
USER_DEFINED_C34 |
UFC34 |
User-defined field C34 |
|
See also: