Deposit Account Fields

Deposit Account Fields

Deposit Process Fields

These fields are created on all maturity / interest action combinations. These fields are created when either the Create Certificates or Create Maturity Notices processes are run:

Field
Explanation
[ACC_BAL1_AFT_INT]
Balance of the current ledger after the interest posting, net of any payout or transfer
[ACC_BAL_B4_INT]
Balance of the current ledger prior to the interest posting
[ACC_DEP_OVRRATE]
Interest Rate on the Account
[ACC_INT_FREQ_NOUN_LC]
Interest Frequency in lower case noun form (i.e month, quarter, year)
[ACC_INT_DATE]
This is the date the Interest is calculated up to, used when interest advice communications are created in advance
[ACC_OPNDTE]
Open Date
[ACTION]
This is the action that has been nominated for the interest as set up on the Interest screen posting action

Examples are:
  1. “Transferred to Account Number 1234” where the interest is to be transferred to a Call Account
  2. “Payment made by Direct Credited 0801 7895 986755” where the interest is to be direct credited to a nominated bank account
  3. “Payment Enclosed” for a cheque payment
  4. “Reinvested” if automatic reinvestment is nominated
[CLI_IRDNO]
Clients  IRD Number
[CLI_WTH_RTE]
Client Withholding Tax Rate
[DPACC_FREQ]
Frequency of the Maturity Term – When used together they provide details of the Term
[DPACC_INTPD_YTD]
Calculates the YTD interest paid on a Deposit Account 
[DPACC_MATDTE]
Maturity Date
[DPACC_TERM]
Term of the deposit
[DPACC_WHT_YTD]
Calculates the Withholding Tax deducted YTD on a Deposit Account
[INTEREST]
This is the gross amount of the interest posting at the Interest posting date
[NETAMT]
This is the net amount of the interest posting at the Interest posting date
[WITHHOLD]
This is the withholding tax deducted from the gross interest at the Interest posting date

There are also some special fields that have been set up to allow certain descriptions to print when Interest or Principal matures in the Deposit System.  These are:

On Interest Posting at Interest rests during the life of the Deposit

These fields are created when the Next Interest Communication process is run

FieldExplanation
[ACC_BAL1_AFT_INT]Balance of the current ledger after the interest posting, net of any payout or transfer
[ACC_BAL_B4_INT]Balance of the current ledger prior to the interest posting
[ACC_DEP_OVRRATE]Interest Rate on the Account
[ACC_INT_FREQ_NOUN_LC]Interest Frequency in lower case noun form (i.e month, quarter, year)
[ACC_INT_DATE]This is the date the Interest is calculated up to, used when interest advice communications are created in advance
[ACC_OPNDTE]Open Date
[ACTION]This is the action that has been nominated for the interest as set up on the Interest screen posting action

Examples are:
  1. “Transferred to Account Number 1234” where the interest is to be transferred to a Call Account
  2. “Payment made by Direct Credited 0801 7895 986755” where the interest is to be direct credited to a nominated bank account
  3. “Payment Enclosed” for a cheque payment
  4. “Reinvested” if automatic reinvestment is nominated
[CLI_IRDNO]Client IRD Number
[CLI_WTH_RTE]Client Withholding Tax Rate
[DPACC_FREQ]Frequency of the Maturity Term – When used together they provide details of the Term
[DPACC_INTPD_YTD]Calculates the YTD interest paid on a Deposit Account 
[DPACC_MATDTE]Maturity Date
[DPACC_TERM]Term of the Deposit
[DPACC_WHT_YTD]Calculates the Withholding Tax deducted YTD on a Deposit Account
[INTEREST]This is the gross amount of the interest posting at the Interest posting date
[NETAMT]This is the net amount of the interest posting at the Interest posting date
[WITHHOLD]This is the withholding tax deducted from the gross interest at the Interest posting date

On Reinvestment of a Matured Deposit

These fields relate to the new account created as the result of the reinvestment.

FieldExplanation
[INTERESTPROFILE]Details the description of the Interest Profile that is being used for the new deposit
[REINV_AMT]Amount being reinvested incl Interest and RWT
[REINV_AMTB4INT]Amount being reinvested ex net interest
[REINV_CODE]This is the deposit code of the new investment
[REINV_FREQ]This is the frequency of the new investment. (i.e days, months, years)
[REINV_INT]This is the amount of interest that will be charged to the original account at the time of maturity
[REINV_MATDTE]This is the maturity date of the new account, in DD/MM/YY format (eg. 10/03/2014)
[REINV_MATDTE_LONG]This is the maturity date of the new account in DD Month YYYY format (eg. 10 March 2014)
[REINV_NET]This is the amount of interest to be charged, to the original account, at the time of maturity, less RWT to be deducted
[REINV_RATE]The rate of interest that will be applied to the reinvested amount on the new account created
[REINV_TERM]This is the term of the new account
[REINV_WTH]This is the amount of Resident Withholding Tax that will be deducted from the reinvestment interest calculated at the time of maturity for the original account
[AMOUNT]The amount of the matured investment
[DPACC_TRFACC]The account code that the deposit has been transferred to on maturity

On Early Maturity of an Investment

FieldExplanation
[DPACC_EARLY_TERM_FEE]Early Term Fee Amount
[DPACC_BROKER_CLAWBACK]Brokerage Clawback Amount

Deposit Brokerage Fields

These fields are only generated from the menu option Deposit/Calculate Post Dealer Brokerage

FieldExplanation
[START_DATE]Start date for brokerage calculations 
[END_DATE] End date for brokerage calculations 
[TOTAL_COMMISSION] Total brokerage calculated for a dealer for the payout range specified above
[PAYMENT]Amount to be paid to the Dealer/Broker

    • Related Articles

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

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

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

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

    • 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, ...