Navigation:  Appendix A - Merge Field Descriptions (Loans) >

Event 14, Loan Payoff Event

Navigation:  Appendix A - Merge Field Descriptions (Loans) >

Event 14, Loan Payoff Event

Previous pageReturn to chapter overviewNext page  Print this Topic

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:

Appendix A

Common Fields (All Events)

CIS Fields

Basic Loan Fields

©2025 FPS GOLD. All rights reserved.