Variable Loan Account Fields

Variable Loan Account Fields

Variable Loan Account Fields

Field
Explanation
[LOACC_ARR+LETFEE] 
Arrears and letter fee

This is the current (arrears) balance plus the letter fee generated during the letter run 
[LOACC_ARR+LETFEE+ACRINT] 
Total of arrears plus the letter fee and accrued interest (penalty) 
[LOACC_CST1]
Value of the other charges item cost 1 on the Financial details screen – usually the cost price 
[LOACC_CST11]
Value of the Interest content of the loan 
[LOACC_CSTn]
Value of the other charges item cost n on the Financial details screen (Where n is between 2 -10 or 12-15)
[LOACC_INSAMT]
Variable Loan Instalment amount
[LOACC_INSFRQ] 
Variable Loan Instalment Frequency
[LOACC_INSNXTDTE]
Variable Loan next instalment posting date
[LOACC_MATDTE]
Variable Loan Maturity date
[LOACC_MORTGAGE_REF]
Variable Loan Mortgage Reference entered to the Variable Loan details dialog
[LOACC_NXTINTAMT] 
This is the next expected interest amount
[LOACC_TOTLON]
Total amount of the loan as entered through the [Finance] button at any time during the life of the loan

Variable Loan Early Termination Fields

FieldExplanation
[LO_ET_CURDAILY_INT]This is the daily interest on the current ledger per day up to the next interest date
[LO_ET_DAILY_INT]This is the amount of interest per day up to the next interest date

This is the sum of the daily interest for the current and future ledgers
[LO_ET_DTE] Date of the early termination quote 
[LO_ET_FACFEE]The Accrued Facility Fee as at the date of the Termination 
[LO_ET_FUTDAILY_INT]
This is the daily interest on the future ledger per day up to the next interest date
[LO_ET_FUTDAILY_INT2]
Principal Outstanding + Interest Accrued to the Next Interest Posting date then be calculated at a Daily Rate
[LO_ET_INSCOMMREB]
This is the Insurance Commission Rebate on the day of the termination
[LO_ET_INSPREMREB]
This is the Insurance Premium Rebate on the day of the termination
[LO_ET_INSTOTREB]
This is the net value of the Commission Rebate + Premium Rebate as a total rebate
[LO_ET_SET_FUT]
Early Termination Enquiry Only

This the total of the future balance only
[LO_ET_SETAMT]
Balance required to be paid to early terminate the account

This is the total of the future ledger balance plus accrued interest on the future ledger plus the current ledger balance plus accrued interest on the current ledger
[LO_ET_UNEINT]
Accrued interest due to the date of early termination

This is the total of accrued interest on the future and current ledgers
[LO_ET_WRTOFF_DFLT_INT]
The amount of the default interest write off specified as part of the early termination quote
[LO_ET_WRTOFF_FACFEE]
Write off facility fee entered as part of the early termination quote
[LO_ET_WRTOFF_INT]
Write off interest entered as part of the early termination quote
[LO_ET_WRTOFF_PCP]
Write off principal entered as part of the early termination quote
[LO_ET_x_AMT]

This is the Fee amount.  One is created for each Early Term Fee set up on the account type

Note the x value should be replaced with the code used for the fee type
[LO_ET_x_DESC]

This is the Fee description.  One is created for each Early Term Fee set up on the account type

Note the x value should be replaced with the code used for the fee type

Create & Maintain Pending Interest Rate Change Fields

These fields will only be created when the [Create Communication] process wizard is used from within the Planned Rate Change Browse.

FieldExplanation
[LOACC_INT_RATE_NEW]New Interest Rate that will be applied  
[LOACC_INT_AMT_NEW]Projected new instalment amount
[LOACC_INSNXTDTE_AFTRC]The first instalment due date that the new instalment amount will be payable
[LOACC_INTRTE_EFFECTIVEDATE]The date the new interest rate will be effective from
[INCREASED_TERM]Number of extra payments required to pay off loan between old maturity date and new projected maturity date
[LOACC_MAT_DTE_NEW]New Maturity Date

Create Direct Debit Communication Fields

These fields will only be created when the Create Direct Debit Communications process wizard is run.

FieldExplanation
[LOACC_DDNXTAMT_PROJECTED]Projected next direct debit amount
[LOACC_DDNXTDTE_PROJECTED]Projected next direct debit date

Create & Maintain Interest Rate Notification Fields

These fields will only be created when the [Post Rate Changes] process wizard is used from within the Interest Rate Notifications Browse.

FieldExplanation
[LOACC_INT_CALC_DATE]
Calculation Date

The date will display as the Long date format i.e. Wednesday, 28 May 2025
[LOACC_UNPAIDBALANCE]
The Unpaid Balance as at the Calculation Date
[LOACC_PROJ_INTRATE]
The New Annual Interest Rate to be applied to the Future Ledger
[LOACC_PROJ_INSTAL_NUMBER]
For a P&I Loan this is the Number of Payments from the Projected Instalment Number field

For IO loans this is the total of the two Projected Instalment Number fields.
[LOACC_PROJ_DD_FREQUENCY]The Projected Direct Debit Frequency
[LOACC_PROJ_DD_STD_DATE]The Projected Direct Debit Date
[LOACC_PROJ_DD_STD_AMOUNT_1]For a P&I Loan this is the amount for the first calculated Direct Debit Amount

For IO loans this is the Calculated value of monthly interest.
[LOACC_PROJ_DD_STD_AMOUNT_2]Only for Interest Only Loans

This is the amount for the first calculated Direct Debit Amount
[LOACC_DDSTD_AMOUNT_CHANGE]Difference between the existing Direct Debit Standard amount and the Repayment Amount 1
[OCR_

[OCR_CHANGE]Interest Rate Change % , will display as a positive number
[OCR_DATE]Date of the OCR Rate Change

The date will display as the Long date format i.e. Wednesday, 28 May 2025
[LOACC_PROJ_DD_STD_COUNT_1]Interest Only Instalment Count 1
[LOACC_PROJ_DD_STD_COUNT_2]Principal & Interest Instalment Count 2 
    • Related Articles

    • Communication Fields - Overview

      The significance of Word Embed Fields It is possible to create any type of Communications to go out to clients. To make this as effective and efficient as possible, there is a list of fields that can be used to embed information directly into a ...
    • Account Fields

      Account Type Fields Field Explanation [ACCTYPE_DES] The description of the account type selected to the account at the time the Communication is created Generic Account Fields Field Explanation [ACC_ARREARS_DAYS] This shows the number of days the ...
    • Manual Communication Replacement Fields

      Concept These are an alternative to creating Copy Communications Manual replacement fields allow the input of user defined Communication Replacement fields to Master documents This method can be useful when: The Master Document is heavily formatted, ...
    • Fixed Loan Account Fields

      Field Explanation [HPACC_ARR+LETFEE] Arrears and letter fee This is the current (arrears) balance plus the letter fee generated during the letter run [HPACC_ARR+LETFEE+ACRINT] Total of arrears plus the letter fee and accrued interest (penalty) ...
    • Communications

      Purpose A Communication is a record of the external dealings you have with your clients. This may be in the form of letters, documentation, records of conversations, or attachments of relevant external files. Concepts Template Document Documents used ...