Lease Account Fields

Lease Account Fields

Field
Explanation
[LEACC_ARR+LETFEE]
Arrears and letter fee

This is the current (arrears) balance plus the letter fee generated during the letter run 
[LEACC_ARR+LETFEE+ACRINT]
Total of arrears plus the letter fee and accrued interest (default) 
[LEACC_CST1]
Value of the first other cost item on the Asset details screen – usually the cost price 
[LEACC_CST1_WHOLE]
The value of the sum of the Cost 1 field on all lease assets formatted to print in whole dollars
[LEACC_CST1+2]
LEACC_CST1 plus LEACC_CST2

Where LEACC_CST1 is the gross value of the asset being leased including GST and LEACC_CST2 is the GST credit, this field will give the net value of the asset being leased
[LEACC_CST1+9+10]
This is the Lease Cost Price less the Deposit and Trade In, i.e. the net amount of the goods being financed
[LEACC_CST10]
Value of the Trade In on the Asset Details screen 
[LEACC_CST11]
Value of the Interest content of the lease – also known as cost of credit 
[LEACC_CST15]
Residual Value
[LEACC_CST2]
Value of the second other cost item on the Asset details screen – must be the GST Credit if GST is being deducted
[LEACC_CST-2]
Above field but with sign reversed for printing purposes
[LEACC_CST9]
Value of the Deposit amount on the Asset details screen 
[LEACC_CSTn]
Value of the other cost item n on the Asset details screen (where n  is between 4 and 8 or 12 and 14)
[LEACC_CST-n]
Allows the printing of the amount in LEACC_CSTn  with the opposite sign

For example as LEACC_CST2 is normally the GST credit, this will allow the printing of GST as a positive amount
[LEACC_ENDDTE]
This is the final instalment date plus 1 period less 1 day which is the last day of the lease and is when the asset should be returned
[LEACC_FIRSTPAYMENT]
This is the first payment field either Advance or Arrears
[LEACC_FININSDTE]
Date of posting of the final instalment on a lease account
[LEACC_INSFINAMT]
Final Instalment Amount (Excl Tax)
[LEACC_INSFINTAX1]
Tax 1 on Final Instalment (GST)
[LEACC_INSFINTAX2]
Tax 2 on Final Instalment (Stamp Duty)
[LEACC_INSFINTOT]
Final Instalment Amount (Incl Taxes)
[LEACC_INSFRQ]
Frequency of Instalment postings 
[LEACC_INSLSTDTE]
Date of posting of the last instalment posted to the lease account
[LEACC_INSNXTAMT]
The net amount of the next instalment to be posted 
[LEACC_INSNXTDTE]
Date of the next Lease Instalment posting 
[LEACC_INSNXTTAX1]
The first tax amount attributable to the net instalment
[LEACC_INSNXTTAX2]
The second tax amount attributable to the net instalment
[LEACC_INSNXTTOT]
The gross value of the next instalment, i.e. The instalment amount plus the two tax amounts
[LEACC_INSREM]
Number of Instalments remaining to be posted 
[LEACC_PAYMENT_SCHEDULE]
Prints a list of all instalments making up the lease repayments

These will normally be the repayments as defined in the Asset attached to the lease, but if there is more than one asset with repayments, these will be added together to show the combined repayment schedule, so there is just one repayment due per period. 
[LEACC_STADTE]
The start date of the lease
[LEACC_TOTAL_PAYMENT]
The Total Amount of all assets making up a lease

This includes all amounts financed plus the cost of credit and will equal the total of all instalments due at the start of the lease for all assets that make up the lease
[LEACC_TOTAL_TAX1]
The Total Amount of Tax item one on the asset instalment repayment profile

This will normally be GST
[LEACC_TOTAL_TAX2]
The Total Amount of Tax item two on the asset instalment repayment profile

This will normally be Stamp Duty
[LEACC_TOTAL_TAX3]
The Total Amount of Tax item three on the asset instalment repayment profile

Lease Early Termination Fields

These fields are created when a communication is created from the Lease Early Termination Dialog.

FieldExplanation
[LE_ET_ASSETSALE]The Asset Sale Value calculated or input during the Operating Lease NPV Termination process
[LE_ET_DISCRATE]The discount rate that is used to NPV the future instalments to calculate the NPV Amount

Applies to both Operating and Finance Leases that use the NPV early termination method
[LE_ET_DTE]Date early termination quote was calculated to 
[LE_ET_GST]Amount of GST added to the termination balance when the ‘Include GST’ checkbox is checked on
[LE_ET_GST_ACCBAL2]Amount of GST on ACCBAL2 
[LE_ET_MAINTREF]Refund of Operating Lease Maintenance calculated using the Operating Lease NPV early termination method
[LE_ET_NPV]

The NPV Amount calculated using the Discount Rate applied when either the Operating or Finance Lease NPV early termination method is used

This displays the Rate
[LE_ET_NPV_DISCAMT]The NPV Amount calculated using the Discount Rate applied when either the Operating or Finance Lease NPV early termination method is used

This displays the Amount
[LE_ET_PAYOUT]For Operating Leases this is the Termination Amount plus Asset Sale Value

For Finance Leases this is the Termination Amount plus Residual Value
[LE_ET_PENDUE]The penalty/default interest due at early termination
[LE_ET_PENWRTOFF]The penalty/default interest to be written off at early termination
[LE_ET_REASON]Lease early termination reason
[LE_ET_RVTOT]The Residual Value calculated or input during the Finance Lease NPV Termination process
[LE_ET_SETAMT]Lease settlement amount – amount in the future ledger required to early terminate the lease as calculated from the lease early termination process

If the rebate is altered in the early terminate process, it will be adjusted against this figure
[LE_ET_SETCURAMT]Lease current amount for settlement – amount in the current ledger required to early terminate the lease as calculated from the lease early termination process
[LE_ET_SETTOTAMT]Total lease settlement amount – total of future and current ledger amounts required to early terminate the lease as calculated from the lease early termination process

This is the total amount payable on termination, after adjusting for rebated interest
[LE_ET_UNEINT]Unearned interest that can be rebated on the early termination of a Lease
[LE_ET_WRTOFF]This is the write off amount entered in the Lease Early termination dialog

Lease Asset Fields

(where n = the number of the asset for the Lease Account)

Notes: n will be used to represent the number of each lease asset attached to a lease account.  Often this will be just one, but where there are multiple assets per lease, then this number will identify each of those assets uniquely.

Each lease asset can have one collateral record associated with it.  The x will identify the collateral item associated with a specific lease asset.

FieldExplanation
[LEASSn_CONTERM]This is the number of instalments and the term

If the quote was 36 instalments and the term monthly, this would print as 36 Months
[LEASSn_INSFREQ]This is the instalment frequency from the Lease such as weekly, monthly etc
[LEASSn_ACTUAL_MAINT]Lease Asset Actual Maintenance Expended 
[LEASSn_BOOK_VALUE]Lease Asset Book Value

Calculated as (Initial Cost – Prior Depn – Depn)
[LEASSn_COLx_BODY_STYLE]Collateral Body Style
[LEASSn_COLx_CHASSIS_NO]Collateral Chassis/Serial No.
[LEASSn_COLx_COLOUR]Collateral Colour
[LEASSn_COLx_ENG_SIZE]Collateral Engine Size
[LEASSn_COLx_FUEL_TYPE]Collateral Fuel Type
[LEASSn_COLx_ITM_DES]The item description of the xth collateral on the nth lease asset
[LEASSn_COLx_ITM_MAKE]The make of the xth collateral on the nth lease asset 
[LEASSn_COLx_ITM_MODEL]The model of the xth collateral on the nth lease asset 
[LEASSn_COLx_ITM_REGNO]The registration number of the xth collateral on the nth lease asset
[LEASSn_COLx_ITM_YER]The year of the xth collateral on the nth lease
[LEASSn_COLx_NEW_DATE]Collateral New Date
[LEASSn_COLx_TRANS_TYPE]Collateral Transmission Type
[LEASSn_COLx_VIN_HIN]Collateral VIN/HIN
[LEASSn_CSTn]The value of the Cost 1 field for the nth lease asset 
[LEASSn_CST1_WHOLE]The value of the Cost 1 field for the nth lease asset rounded to whole dollars
[LEASSn_ITEM_DESCRIPTIONS]This is a single string that is built up with all the descriptions of the cost items under the xth Cost field on the nth Lease Asset associated with an account

The description will appear in the string only if there is a value for the item

Each description is separated with a comma
[LEASSn_DEPN]Lease Asset Depreciation
[LEASSn_ERV]Estimated residual value for the nth lease asset
[LEASSn_ERV_SHARE]The % Sales proceeds over and above the ERV to be rebated to the client for the nth lease asset
[LEASSn_FINAL_USAGE]Final usage value for the nth lease asset
[LEASSn_INSFREQ]The Lease Account Instalment frequency 
[LEASSn_MAINT_PROV]Lease Asset Maintenance Provision
[LEASSn_MAINT_UNDEROVER]Lease Asset Maintenance +/-
[LEASSn_MKT_VALUE]The Market Value of the nth lease asset
[LEASSn_NXT_REGO_DATE]Next Registration Date
[LEASSn_NXT_SRVC_DATE]Next Service Date
[LEASSn_NXT_WOF_DATE]Next WOF Date
[LEASSn_OVERUSE]Overuse unit charge amount for the nth lease asset
[LEASSn_PRIOR_DEPN]Lease Asset Prior Depreciation
[LEASSn_REGO_STATUS]Status of the registration – either “Expired” or “Current” based on the Next Rego Date and the date at the time the communication is created
[LEASSn_RETURN_DATE]
The Return Date of the nth lease asset
[LEASSn_RUC_KM]
RUC Kilometres
[LEASSn_TERM_CNT]
Total number of instalments for the nth lease asset
[LEASSn_UNDERUSE]
Under use unit rebate amount for the nth lease asset
[LEASSn_USAGE_ALLOWANCE]
The usage allowance for the nth lease asset

As an example, usage allowance may for kilometres for vehicles, or copies for photocopiers
[LEASSn_USAGE_AT_START]
The Usage units at the start of the lease for the nth lease asset
[LEASSn_USAGEUSED]
Usage units used for the nth lease asset

    • 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 ...
    • Quote Fields

      Collateral Fields The following group of fields store the collateral details as entered on the Collateral Details screen. A Quote may have a number n of collateral details. The Max Collateral field must be entered on the quote. This is the maximum ...
    • 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, ...
    • 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 ...
    • 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 ...