Account Fields

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

FieldExplanation
[ACC_ARREARS_DAYS]This shows the number of days the account has been in arrears as shown on the Loan Enquiry Screen
[ACC_ACRINTAMT]
Total of all accrued interest to the accrued interest date 
[ACC_ACRINTDTE]
Accrued interest date 
[ACC_ACRINTRTE]
Accrued interest rate (Latest account rate) 
[ACC_ACRINTRTEFUT]
The Future ledger interest rate
[ACC_ALP]
Account code 
[ACC_ANALYSISx_CODE]
The code of the xth Analysis Code for the Account
[ACC_ANALYSISx_DES]
The description of the xth Analysis Code for the Account
[ACC_ARRDUE]
Total of the current balance plus accrued interest on the current balance
[ACC_BAL1]
Current balance – balance of the current ledger  
[ACC_BAL1_PRT]
Current balance – balance of the current ledger, with the correct print sign

i.e. no leading - So a current balance of –2000.00 will print as 2000.00 
[ACC_BAL1+BAL2]
Total of Balance 1 and Balance 2

i.e. the balance to be paid to clear the account excluding accrued interest
[ACC_BAL2]
Future balance – balance of the future ledger
[ACC_BOR_NME]
Borrowers Name, being the description line on the client database
[ACC_CALACRINTDTE]
Date to which interest has been accrued 
[ACC_CALACRINTDTEFUT]
The date to which interest was accrued on the future ledger
[ACC_CALACRINTDUE]
Accrued interest on the current (arrears) ledger (Fixed Loan penalty total) (accrued interest on a call or deposit account) 
[ACC_CALACRINTDUEFUT]
Accrued interest on the future ledger used in the Variable Loan System
[ACC_CERNO]
Unique account certificate number that is generated for each certificate created from the Accounts menu option Create Account Balance Certificates
[ACC_CLI_COTSAL]
Contact salutation of the account client to be printed in overdue letters that are addressed to the second client or guarantor
[ACC_CLI_DES]
Description of the account client to be printed in overdue letters that are addressed to the second client or guarantor
[ACC_CLI_NMEADD]
Name and Address of the account client to be printed in overdue letters that are addressed to the second client or guarantor
[ACC_CLSDTE]
Account closed date 
[ACC_COLn_SECFIN_ALP] 
The Financing Statement Number linked to the collateral on the Variable Loan Account
[ACC_COLn_SECFIN_SECPTY]
The secured party group description selected on the Financing Statement
[ACC_COL1]
Full details of first attached Collateral Item

This is an amalgamation of all fields making up the Collateral details
[ACC_COL2]
Full details of second attached Collateral Item

This is an amalgamation of all fields making up the Collateral details
[ACC_COL3]
Full details of third attached Collateral Item

This is an amalgamation of all fields making up the Collateral details
[ACC_COL4]
Full details of fourth attached Collateral Item

This is an amalgamation of all fields making up the Collateral details
[ACC_DEP_OVRRATE]
The Deposit account override rate
[ACC_DES]
Account description 
[ACC_DL_ADD]
Dealer address from client database 
[ACC_DL_COTNME]
Dealer contact name from client database 
[ACC_DL_COTPOS]
Dealer contact position from client database 
[ACC_DL_COTSAL]
Dealer contact salutation from client database 
[ACC_DL_NME]
Dealer name from client database 
[ACC_DLR_COMM_PCT]
While this is on the Account it is only set on Call Savings Account and is the actual % value of the commission
[ACC_FUTDUE]
Total of the future balance plus interest accrued on the future balance
[ACC_INTACT]
Interest Action
[ACC_INTCHG]
Total of all interest charged (for Fixed Loan system, this is penalty interest)  
[ACC_INTFRQ]
Interest Frequency 
[ACC_INTNXTDTE]
Next Interest Date 
[ACC_INTPD]
Total of all interest paid on the account 
[ACC_LASTLETTERDATE]
Last letter date from the overdue letter process
[ACC_LEND_OVRRATE]
The Lending account override rate
[ACC_NUM]
Account internal number
[ACC_OPNDTE]
Account opened date 
[ACC_OVDAMT]
The Overdraft Amount
[ACC_QUOTE_PROFILE]
This will contain the Source Quote Details text from the Account Details screen
[ACC_RECAMT]
Last receipt amount 
[ACC_RECAMT_PRT]
The last receipt amount with the correct sign for printing

i.e. no leading -  So a receipt of –2000.00 will print as 2000.00 
[ACC_RECDTE]
Last receipt date 
[ACC_REG]
Registration number 
[ACC_SOURCE]
Description from the Account Source selected to the Account
[ACC_TOTDUE]
Total of the current balance plus accrued interest plus the future balance plus accrued interest
[ACC_UNITS]
This is the total number of units held buy a unit holder when the Create Account Balance Certificates routine is run

It is calculated as the account balance divided by 1, with the cents truncated to give the total number of units for an account
[ACC_VOU]
Voucher number  (Booklet Number on the Fixed Loan Dialog)
[COMPANY_CODE]
Company Code
[COMPANY_DES]
Company Description

Account Direct Debit Fields

FieldExplanation
[ACC_DD_BNKACC]Bank Account number that is to be Direct Debited
[ACC_DD_FRQ]
The frequency of the Direct Debit transaction created by the system
[ACC_DD_NXTAMT]
The next amount that is due to be posted on the direct debit run
[ACC_DD_NXTDTE]
The date the next amount will post on a direct debit run
[ACC_DD_STDAMT]
The standard amount that is due when the direct debits are run
[ACC_DD_STDNXTDTE]
The date that applies to the selection of the standard direct debit amount

Account Insurance Policy Fields

These fields are created when a communication is created from the ‘Create Insurance Renewal Letters’ in the Insurer System or when a communication is created for a lending account which has Insurance details (loaded to either the [Insurance] or [Insurer] dialogs).

Note: [ACC_INS_PREMFIN], [ACC_INS_INSCOMM] & [ACC_INS_NETPAID] will not be created for [Insurance] policies.
FieldExplanation
[ACC_INS_ADD]Insurer client address
[ACC_INS_COTNME]
Insurer client contact name
[ACC_INS_COTPOS]
Insurer client contact position
[ACC_INS_COTSAL]
Insurer client contact salutation
[ACC_INS_INSCOMM]
The amount of Insurance Commission payable

This is entered via the [Insurer] button in the field 'Insurance Commission' in the screen Edit Account Insurance Policy Details
[ACC_INS_NETPAID]
The net amount of the insurance paid to the insurer
[ACC_INS_NME]
Insurer client name
[ACC_INS_POLAMT]
Insurance policy amount

This is entered via the [Insurer] button in the field 'Cover Amount' in the screen Edit Account Insurance Policy Details
[ACC_INS_POLDES]
Insurance policy description

This is entered via the [Insurer] button in the field 'Additional Information' in the screen Edit Account Insurance Policy Details
[ACC_INS_POLEXPDTE]
Insurance policy expiry date

This is entered via the [Insurer] button in the field 'Expiry Date' in the screen Edit Account Insurance Policy Details
[ACC_INS_POLNO]
Insurance policy number

This is entered via the [Insurer] button in the field 'Policy/Proposal Ref' in the screen Edit Account Insurance Policy Details
[ACC_INS_POLTYPDES]
The description of the Insurance Policy type
[ACC_INS_PREMFIN]
The Gross Amount of the Finance Insurance Premium

As an account can have a number of insurance policies loaded to the [Insurer] dialog, when a communication is created from an account the following fields will be created for each of the policies where n is the number of the policy.  

E.g. For the Second [Insurer] Policy Description, the field would read [ACC_INS2_POLDES]
FieldExplanation
[ACC_INSn_ADD]Insurer client address
[ACC_INSn_COTNME]Insurer client contact name
[ACC_INSn_COTPOS]Insurer client contact position
[ACC_INSn_COTSAL]Insurer client contact salutation
[ACC_INSn_INSCOMM]
The amount of Insurance Commission payable

This is entered via the [Insurer] button in the field 'Insurance Commission' in the screen Edit Account Insurance Policy Details
[ACC_INSn_NETPAID]The net amount of the insurance paid to the insurer
[ACC_INSn_NME]Insurer client name
[ACC_INSn_POLAMT]
Insurance policy amount

This is entered via the [Insurer] button in the field 'Cover Amount' in the screen Edit Account Insurance Policy Details
[ACC_INSn_POLDES]
Insurance policy description

This is entered via the [Insurer] button in the field 'Additional Information' in the screen Edit Account Insurance Policy Details
[ACC_INSn_POLEXPDTE]
Insurance policy expiry date

This is entered via the [Insurer] button in the field 'Expiry Date' in the screen Edit Account Insurance Policy Details
[ACC_INSn_POLNO]Insurance policy number

This is entered via the [Insurer] button in the field 'Policy/Proposal Ref' in the screen Edit Account Insurance Policy Details
[ACC_INSn_POLTYPDES]The description of the Insurance Policy type
[ACC_INSn_PREMFIN]The Gross Amount of the Finance Insurance Premium

Account Repossession Agent Fields

These fields are created when a communication is created from within an account.  

They are the contact details of the client selected into the Repossession Agent field of the Associated Party dialog for an account.

FieldExplanation
[ACC_REPO_ADD]Repossession Agent client address
[ACC_REPO_COTNME]
Repossession Agent client contact name
[ACC_REPO_COTPOS]
Repossession Agent client contact position
[ACC_REPO_COTSAL]
Repossession Agent client contact salutation
[ACC_REPO_NME]
Repossession Agent client name

Account Recurring Charge Fields

FieldExplanation
[ACC_AP_AMT]Amount of the Recurring Charge
[ACC_AP_DES]
Description of the Recurring Charge
[ACC_AP_FRQ]
Frequency of the Recurring Charge
[ACC_AP_NXTDTE]
Next posting date for the Recurring Charge

Note that this is the same as the start date when a new recurring charge is set up
[ACC_AP_REF]
Reference for the Recurring Charge
[ACC_AP_REMCNT]
Number of Recurring Charges still to be posted on that account

Not that this will be the number that have to be posted when the Recurring Charge is initially setup
[ACC_AP_STADTE]
The start date of the Recurring Charge

This will be the same as the next date when the Recurring Charge is first set up
[ACC_AP_TAX]
Tax on the amount of the Recurring Charge if the "Add Taxes" tick box is ticked on
[ACC_AP_TIME]
The frequency of the Recurring Charge as a noun (week, month etc)

Account Payout Fields

Some account systems have the ability to payout balances of those accounts.  The most common examples are Dealers and Insurers.  These are creditors that need to be paid from time to time.  Payment can be made by either Direct Credit or Cheque. 

FieldExplanation
[ACC_CBSTM_DTE]The date the direct credit or cheque payment was created from the payout routine
[ACC_CHQ_NO]
Unique cheque number for each cheque created within the system that posts to the cashbook
[ACC_CHQ_WRD_x]
The amount in words that is being paid by cheque

WRD_0 = cents, WRD_1 = single dollars, WRD_2 = tens of dollars etc
[ACC_DUE_AMT]
This is the total of the cheque or direct credit that will be paid to on an account this payment run

Account Transaction Fields

These fields are used when there are communications automatically created when particular transaction types are used.

For Example, it is common to send letters when a payment is dishonoured by the bank. The Unpaid Item Transaction Type would have a communication type associated with it, to automatically generate a letter when the transaction is posted to the account.
FieldExplanation
[ACCTRN_AMT]Value amount of each transaction
[ACCTRN_DES]
Description of each transaction
[ACCTRN_INPDTE]
Input date of each transaction
[ACCTRN_NET_AMT]
The transaction value amount les any taxes
[ACCTRN_NET_AMT_PRT]
The absolute value of a transaction ensuring there is no leading negative value
[ACCTRN_NUM]
Unique internal number of this transaction - can be used as a reference on the communications e.g. Tax Invoice Number
[ACCTRN_REF]
Reference of each transaction
[ACCTRN_TAX1]
The value of the first tax amount deducted from the transaction amount
[ACCTRN_TAX2]
The value of the second tax amount deducted from the transaction amount
[ACCTRN_TAX3]
The value of the third tax amount deducted from the transaction amount
[ACCTRN_TOT_TAX]
The total tax deducted from the transaction value amount being the total of Tax 1 + Tax 2 + Tax 3
[ACCTRN_VALDTE]
Value date of each transaction

Account Portfolio Fields

These are set up on the Account [Portfolio] dialog, and can be used in any account or quotation communications.

The portfolio item number must be entered where the n value is shown.  

E.g. For the Address of the first Portfolio item the field would read [ACCPORT1_ADD]
FieldExplanation
[ACCPORTn_ADD]Address
[ACCPORTn_ADD_SL]
Address on a single line
[ACCPORTn_CT]
CT
[ACCPORTn_DP]
DP
[ACCPORTn_LOT]
Lot
[ACCPORTn_NOTES]
Security Notes
[ACCPORTn_OWNER]
Owner
[ACCPORTn_PRIOR_CHGS]
Prior Charges
[ACCPORTn_PROP_SECTYPE]
Property Security Type
[ACCPORTn_PROV]
Provision
[ACCPORTn_REG]
Register
[ACCPORTn_SECTYPE]
Security Type
[ACCPORTn_VAL]
Valuation
[ACCPORTn_VAL_DATE]
Valuation Date
[ACCPORTn_VALUER]
Valuer Name

Account Statement, Projection and Summary Fields

When creating an Account Summary, Statement or Projection report as a communication the following communication replacement fields are created

FieldExplanation
[CLI_SEC_FSTNME]First Name entered on the Sec Reg dialog
[CLI_SEC_lSTNME]
Last Name entered on the Sec Reg dialog

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

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

    • Bailment Fields

      Common Bailment Fields The following communication replacement fields are created from any bailment communication process: Field Explanation [BMTDLR_CODE] Bailment Dealer Code [BMTDLR_DES] Bailment Dealer Description [BMTDLR_OPENDATE] Bailment Dealer ...

    • Call Savings Account Fields

      On [Add] in the Communications Browse Field Explanation [CSACC_SHARES] Number of Qualifying Shares: Current Account Balance prior to dividend calculation Dealer Commission The following fields will be created on interest posting if Call Savings ...

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