16. Appendix B - Accounting Entries, Advices and Error Codes

This chapter contains the following section:

• Section 16.1, "Accounting Entries for Loans"
• Section 16.2, "Loans Events "
• Section 16.3, "Amount Tags"
• Section 16.4, "Accounting Roles"
• Section 16.5, "Event-wise Accounting Entries and Advices"
• Section 16.6, "Accounting Entries for Contract Adjustment"
• Section 16.7, "Payable Receivable Liquidation"
• Section 16.8, "Accounting for Discounted Loans"
• Section 16.9, "Accounting Entries for Non-Performing Loans"
• Section 16.10, "Accounting Entries for Reserved and Non-reserved Loans"
• Section 16.11, "Accounting Entries for Cost of Credit Valuation"
• Section 16.12, "Accounting Entries for LC Sublimit Re-classification"
• Section 16.14, "Error Codes"
• Section 16.15, "Examples of Calculating TEAC"

16.1 Accounting Entries for Loans

This section contains details of the suggested accounting entries that can be set up, for the Loans module of Oracle Lending. The details of the suggested accounting entries are given event-wise.

16.2 Loans Events

The following is an exhaustive list of events that can take place during the life cycle of a Loans contract.The accounting entries and advices for each of the events are listed below.

Event Code	Event Description	Remarks
BOOK	Booking a contract Contingent entries are passed at the time of Booking a future val­ued contract. This corresponds to Event - Booking. If a contract with value date as the system date or with a back value date is input these entries are not passed.	All Types
INIT	Contract Initiation The actual take down entries passed on the value date of the con­tract correspond to Initiation.	All Types
LIQD	Liquidation of contract/schedules	All Types
ACCR	Accrual of various components for a contract	All Types
CAMD	Contract Amendment
DLNK	Release of Linkage to Loan	Dis­counted loans
FLIQ	Advance/Arrears Fee Liquidation
FELR	Fee Liquidation
FACR	Fee Accrual
LINK	Linkage to Loan
LIQD	Liquidation of contract/schedules	All Types
NOTC	Billing of Notice
RAMD	Rollover Amendment
REAS	Reassign User
RESD	Reversal of Residual Accrual In case the status of a contract changes to Non Accrual basis, all the accrued amounts are reversed using this Event Code.
REVC	Contract Reversal
REVN	Rate Revision
REVP	Reversal of payments/contract
RFND	Refund of Interest
ROLL	Rollover of Contract	All Types
RCHG	Rate Change (Revision)
RTFX	Rate Fixing
RTAM	Rate Amendment
SPRO	Provisioning
SPWB	Write Back
STCH	Status Change	All Types
VAMB	Value Dated Amendment Booking
VAMI	Value Dated Amendment Initiation
YACR	Yield To Maturity based Discount Accrual
CREB	Contra Rebalance
FREB	FAS114 Rebalance
WREB	Write-off Rebalance
FRSV	Unfunded and Funded FAS114 Reserve Increase/ Decrease
TRCL	Trade Reclassification
RESR	Reserve Decrease
CICR	Contra Increase
CDCR	Contra Decrease
SPWV	Special Penalty Waiver
RSPW	Reversal of Special Penalty Waiver
PNTC	Event to generate Payment Notice and Payoff Notice
INNC	Event to generate Insurance Expiry Notice and 45 Day Flood Notice – Escrow and Non Escrow
RFLR	Reversal of Fee Refund / Liquidation
RFRV	Reversal of FAS114 Reserve for commitment and loan
RVCR	Reversal of Contra Increase/Decrease
REWR	Reversal of Reserve/Write-off

16.3 Amount Tags

The amount tags listed below are hard-coded in Oracle Lending.

Amount Tag	Description
COMMUTIL_DECR	Commitment Amount Reinstated
COMMUTIL_INCR	Commitment Amount Utilized
INT_DISC_ADJ	Discounted Interest Adjusted
PRINCIPAL	Principal Amount
PRINCIPAL_ADDL	Additional Principal
PRINCIPAL_DECR	Decrease in principal on amendment
PRINCIPAL_FWD	Forward takedown amount
PRINCIPAL_INCR	Increase in principal on amendment
PRINCIPAL_LIQD	Principal Amount Liquidated
PRINCIPAL_ROLL	Principal Amount Rolled over
PRINCPAL_XFWD	Principal Amount Reclassified
PRINCPAL_XREV	Principal Amount Unclassified
PRO_AMT	Provision Amount
ROLLOVER_AMT	Rollover Amount
WB_AMT	Write Back Amount
INT_RESINC / INT_LIQD	Restricted Interest Income liquidated / Interest Income Liquidated
UNRLZD-LOSS	LD Unrealized Loss
UNRLZD-PRFT	LD Unrealized Profit
COMPONENT_MCICR	Manual Contra Increase
Deferred Interest _Compo­nent_LIQD	Deferred interest component liquidated
<Fee_Component>_FRFD	Fee Component
<Fee Component>_FRLQ	Fee component liquidation
<Fee Component>_FRRF	Fee component refund

In addition to these you can define amount tags as per your requirements for interest and charges that are attached to your product.

16.4 Accounting Roles

In this section we have provided a list of sample accounting roles.

Accounting Role	Description	Role Type
CHGSINC	Charges on the Loan Product	Income
FEESINC	Liquidation Fees	Income
INTREC	Interest Receivable	Asset
ASSETGL	Asset GL for loans	Asset
INTAQR	Interest on Principal	Asset
INTINC	Interest on Principal	Income
FRTAX1_PAY	Tax Payable role for FRTAX1	Liability
FRTAX1_EXP	Tax Expense role for FRTAX1	Expense
FRTAXS_PAY	Tax Payable role for FRTAXS	Liability
FRTAXS_EXP	Tax Expense role for FRTAXS	Expense
FWDASSETGL	GL for Future Dated Loans	Contingent Asset
FWDASSETOFF	Offset for Future Dated Loans	Contingent Liability
ROLLFEESINC	Rollover Fees	Income
VAMBFEESINC	VAMB Fees	Income
P_PRNINC	Penalty on Overdue Principal	Income
P_PRNREC	Penalty Interest Receivable	Asset
P_INTINC	Penalty Interest Income	Income
P_INTREC	Penalty Interest Receivable	Asset
ASSETGL_REF	Asset GL for Refinance	Asset
LAIBGL_REF	Liability GL for Refinance	Liability
ASSETGL_REF_OFF	Offset GL	Asset
LAIBGL_REF_OFF	Offset GL	Liability
RESINT	Restricted Interest	Income
UNREAL_MTM_INC	Unrealized MTM Income	Asset
UNREAL_MTM_OFF	Unrealized MTM Offset	Asset
UNREAL_MTM_EXP	Unrealized MTM Expense	Asset
<Fee Component>FLR
<Fee Component>FIA

Note

In the accounting roles listed above the prefixes CHGS (charges), FEES (Fees), INT (In­terest), FRTAX1, FRTAXS (Tax), P_PRN (Penalty), ROLLFEES (rollover fees), VAMB­FEES (value dated amendment fees) are ICCF components.

The suffixes stand for:

AQR	Acquired interest receivable
EXP	Expense
INC	Income
PAY	Payable
REC	Receivable

Given below is a possible set of events and the advices that could be generated during the life cycle of a loan:

A payment was liquidated today by the Automatic Contract Update func­tion of LD module	An advice is generated addressed to the cus­tomer intimating him about the payment that was liquidated today.
A back dated loan with a value date as of today was initiated	An advice is generated addressed to the cus­tomer. If any components like discounted inter­est, tax on principal and so on are liquidated on initiation, an advice is generated for each of them.
A change entered through the value dated changes function fell due today and was executed.	An advice is generated notifying the customer about the changed terms of the loan.
A floating rate/periodic rate of a loan has changed.	An advice is generated telling the customer of the new interest rate applicable on the loan.
A loan was rolled over into a new loan.	An advice is generated addressed to the cus­tomer intimating him of the rolling over of the loan and the initiation of a new loan.

16.5 Event-wise Accounting Entries and Advices

In the subsequent sections we have defined suggested accounting entries and advices for each of the events in the life cycle of a Loan deal. Samples of accounting entries, advices, and events have been given for three different types of Loan and Commitment deals. They are:

• Term loan – Bearing
• Demand Loan
• Commitment

Note

Some of the Amount Tag’s linked to the Accounting Roles are user defined.

16.5.1 Term Loan – Bearing

The preferences set for this product are as follows:

• The payment type for this product is of Bearing type
• The schedule type for this product is of Capitalized type
• Forward Dating is allowed for this product

16.5.1.1 INIT: Contract Initiation

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
INTREC	INT_ACQD	Debit
INTAQR	INT_ACQD	Credit
P_PRNREC	P_PRN_ACQD	Debit
P_PRNAQR	P_PRN_ACQD	Credit
ASSETGL	PRINCIPAL	Debit
CUSTOMER	PRINCIPAL	Credit
FWDASSETGL	PRINCIPAL_FWD	Credit
FWDASSETOFF	PRINCIPAL_FWD	Debit

 

Advices

Advice Name	Description
DEAL_SLIP	Contract Advice
CONT_ADV	Contract Advice
PAYMENT_MESSAGE	Payment Message

 

16.5.1.2 BOOK: Booking of Contract

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
CUSTOMER	LIQD	Debit
BOOKCHGINC	LIQD	Credit
FWDASSETGL	PRINCIPAL_FWD	Debit
FWDASSETOFF	PRINCIPAL_FWD	Credit

 

Advices

Advice Name	Description
PAYMENT_MESSAGE	Payment Message

 

 

16.5.1.3 ACCR: Accrual

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
INTINC	INT_ACCR	Credit
INTREC	INT_ACCR	Debit
P_PRNREC	P_PRN_ACCR	Debit
P_PRNINC	P_PRN_ACCR	Credit

 

Advices

No Advices allowed for this Event.

16.5.1.4 LIQD: Liquidation

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
FRTAX1_PAY	FRTAX1_AMT	Credit
FRTAX1_EXP	FRTAX1_AMT	Debit
FRTAXS_PAY	FRTAXS_AMT	Credit
FRTAXS_EXP	FRTAXS_AMT	Debit
CUSTOMER	INT_ADJ	Debit
INTREC	INT_ADJ	Credit
INTREC	INT_CAP	Credit
ASSETGL	INT_CAP	Debit
CUSTOMER	P_INT_LIQD	Debit
P_INTREC	P_INT_LIQD	Credit
CUSTOMER	PRINCIPAL_LIQD	Debit
ASSETGL	PRINCIPAL_LIQD	Credit
CUSTOMER	INT_LIQD	Debit
INTREC	INT_LIQD	Credit
RESINTINC	INT_RESINC	Debit *
INTINC	INT_RESINC	Credit *

 

* - This entry is only for liquidation of interest on overdue loans on cash basis.

Advices

Advice Name	Description
CAP	Capitalization Advice
PAYMENT_MESSAGE	Payment Message

 

16.5.1.5 RFND: Refund of Interest/Fees

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
COMPONENT_REC	COMPONENT_RFND	Debit
CUSTOMER	COMPONENT_RFND	Credit

 

Advices

Advice Name	Description
OVERPAYAMT	Overpayment Advice

 

16.5.1.6 Liquidation of Interest

GL	Amount Tag	Dr/Cr
Customer	INT_LIQD	Dr
INT_REC	INT_LIQD	Cr
ADJ GL	INT_WAIV	Dr
INT_REC	INT_WAIV	Cr

16.5.1.7 ROLL: Rollover of Contract

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
ROLLFEESINC	LIQD	Credit
CUSTOMER	LIQD	Debit
CUSTOMER	INT_LIQD	Debit
INTREC	INT_LIQD	Credit
ASSETGL	INT_ROLL	Debit
INTREC	INT_ROLL	Credit
CUSTOMER	P_INT_LIQD	Debit
P_INTREC	P_INT_LIQD	Credit
CUSTOMER	PPR_LIQD	Debit
PPRREC	PPR_LIQD	Credit
ASSETGL	PRINCIPAL_ADDL	Debit
CUSTOMER	PRINCIPAL_ADDL	Credit

 

Advices

Advice Name	Description
CAP	Capitalization Advice
ROLL_ADV	Rollover Advice
PAYMENT_MESSAGE	Payment Message

 

16.5.1.8 LINK: Linkage to Loan

Accounting Entries

Nil

Advices

No Advices allowed for this Event.

16.5.1.9 STCH: Status Change

Accounting Entries

Nil

Advices

Nil

NOTC: Billing Notice Generation

Accounting Entries

No Accounting Entries allowed for this Event.

Advices

Advice Name	Description
BILNOTC	Billing Notice

 

VAMI: Value Dated Amendment Initiation

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
ASSETGL	PRINCIPAL_INCR	Debit
CUSTOMER	PRINCIPAL_INCR	Credit
VAMBFEESINC	LIQD	Credit
CUSTOMER	LIQD	Debit

 

Advices

Advice Name	Description
PAYMENT_MESSAGE	Payment Message

 

16.5.1.10 STPI:

Accounting Role	Amount Tag	Dr./Cr. Indicator
Reprice Suspense	PRINCIPAL_SPTI	Dr
Asset	PRINCIPAL_SPTI	Cr.
Reprice Suspense	INTERESTFL_SPTI	Dr.
Interest Receivable	INTERESTFL_SPTI	Cr.

16.5.1.11

VAMB: Value Dated Amendment Booking

Accounting Entries

Nil

Advices

Advice Name	Description
AMDADV	Amendment Advice
PAYMENT_MESSAGE	Payment Message

 

CAMD: Contract Amendment

Accounting Entries

Nil

Advices

Advice Name	Description
AMDADV	Amendment Advice

 

16.5.2 Demand Loan

The preferences set for this product are as follows:

• The payment type for this product is of Bearing type
• The schedule type for this product is of Normal type
• Forward Dating is allowed for this product

16.5.2.1 NOTC: Billing Notice Generation

Accounting Entries

No Accounting Entries allowed for this Event.

Advices

Advice Name	Description
BILNOTC	Billing Notice

 

16.5.2.2 ROLL: Rollover of Contract

Accounting Entries

Nil

Advices

Advice Name	Description
PAYMENT_MESSAGE	Payment Message

 

BOOK: Booking of Contract

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
CHGSINC	LIQD	Credit
CUSTOMER	LIQD	Debit

 

Advices

Advice Name	Description
PAYMENT_MESSAGE	Payment Message

 

16.5.2.3 LIQD: Liquidation

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
CUSTOMER	INT_LIQD	Debit
INTREC	INT_LIQD	Credit
CUSTOMER	P_INT_LIQD	Debit
P_INTREC	P_INT_LIQD	Credit
CUSTOMER	P_PRN_LIQD	Debit
P_PRNREC	P_PRN_LIQD	Credit
CUSTOMER	PRINCIPAL_LIQD	Debit
ASSETGL	PRINCIPAL_LIQD	Credit

 

Advices

Advice Name	Description
PAYMENT_MESSAGE	Payment Message

 

16.5.2.4 INIT: Contract Initiation

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
INTAQR	INT_ACQD	Credit
INTREC	INT_ACQD	Debit
CUSTOMER	PRINCIPAL	Credit
ASSETGL	PRINCIPAL	Debit

 

Advices

Advice Name	Description
PAYMENT_MESSAGE	Payment Message
CONT_ADV	Contract Advice

 

16.5.2.5 ACCR: Accrual

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
INTINC	INT_ACCR	Credit
INTREC	INT_ACCR	Debit
P_INTINC	P_INT_ACCR	Credit
P_INTREC	P_INT_ACCR	Debit
P_PRNINC	P_PRN_ACCR	Credit
P_PRNREC	P_PRN_ACCR	Debit

 

Advices

No Advices allowed for this Event.

16.5.2.6 VAMB: Value Dated Amendment Booking

Accounting Entries

Nil

Advices

Nil

16.5.2.7 VAMI: Value Dated Amendment Initiation

Accounting Entries

Nil

Advices

Nil

16.5.3 Commitment

The preferences set for this product are as follows:

• The payment type for this product is of discounted type
• The schedule type for this product is of Normal type
• Forward Dating is allowed for this product

16.5.3.1 BOOK: Booking of Contract

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
CUSTOMER	CHARGES	Debit
CHARGEINC	CHARGES	Credit

 

Advices

Nil

16.5.3.2 INIT: Contract Initiation

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
ASSETGL	PRINCIPAL_FWD	Debit
ASSETOFF	PRINCIPAL_FWD	Credit

 

Advices

Nil

16.5.3.3 LINK: Linkage to Loan

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
ASSETGL	COMMUTIL_INCR	Credit
ASSETOFF	COMMUTIL_INCR	Debit

 

Advices

No Advices allowed for this Event.

16.5.3.4 LIQD: Liquidation

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
ASSETGL	PRINCIPAL_LIQD	Credit
ASSETOFF	PRINCIPAL_LIQD	Debit

 

Advices

Nil

16.5.3.5 VAMI: Value Dated Amendment Initiation

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
ASSETGL	PRINCIPAL_­DECR	Credit
ASSETOFF	PRINCIPAL_­DECR	Debit
ASSETGL	PRINCIPAL_INCR	Debit
ASSETOFF	PRINCIPAL_INCR	Credit

 

Advices

Nil

16.5.3.6 DLNK: Release of linkage to Loan

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
ASSETGL	COMMUTIL_DECR	Debit
ASSETOFF	COMMUTIL_DECR	Credit

 

Advices

No Advices allowed for this Event.

16.5.3.7 EXPY: Expiry of the commitment availability on the Last Availability Date

The End of Day Batch Function marks the Expiry of the commitment availability on the Last Availability Date. The event “EXPY” is activated to mark the expiry of the commitment. The contingent accounting entries maintained for EXPY Event are as follows:

Accounting Entries

Accounting Role	Amount Tag	Dr./Cr. Indicator
CONASSETOFF	PRINCIPAL	Debit
CONASSETGL	PRINCIPAL	Credit

 

16.5.3.8 MRVL: Post Accounting Entries for Revaluation on Commitment

EOD batch posts reversal entries for past revaluation entry on commitment, if the market price is maintained for the CUSIP.

Accounting Role	Amount Tag	Dr./Cr. Indicator
UNREAL_MT­M_OFF	UNRLZD-LOSS	Credit
UNREAL_MTM_­EXP	UNRLZD-LOSS	Debit
UNREAL_MT­M_OFF	UNRLZD-PRFT	Debit
UNREAL_MTM_INC	UNRLZD-PRFT	Credit

16.5.3.9 FELR: Fee Liquidation

If the Commitment Level Net Funded Carrying Value (CLNFCV) goes negative, refund will have to be triggered proportionally at the commitment contract to release each of the FAS91 amortization fee components, including Asset Transfer Marks and Deferred Interest Components, associated with the commitment. You need to set up the following entries for such unamortized refund:

Accounting Role	Amount Tag	Dr./Cr. Indicator
<Fee Compo­nent>FIA	<Fee Compo­nent>_FRFD	Debit
AMORTFEE-PNL	<Fee Compo­nent>_FRFD	Credit

If the value of backend parameter ‘ALLOW_REPERFORMING_LOAN_FUNC’ is set to ‘Y’, amortization fee liquidation will be done on deferred fee interest component for the memo interest amount that is moved to Real GL. The effective date for this movement will be as of the status change date.

The following entries need to be set up for liquidating deferred interest fees:

Accounting Role	Amount Tag	Dr./Cr. Indicator
<Deferred Interest Component>INC	<Deferred Interest_ Component> _LIQD	Debit
<Deferred Interest Component>FIA	<Deferred Interest_ Component> _LIQD	Credit

 

Note that the Accounting Head for Accounting Role <Deferred Int_component>INC should be the same as Income GL mapped to the Accounting Role ‘INTERESTINC_GL’ so that the GL balance will be zero after processing memo interest transfer. Alternately, a Wash GL can be mapped to the accounting role ‘<Deferred Int_component> INC’ in which case the balance in this GL will mirror the balance in the interest Income GL.

The following entries need to be set up for manual liquidation and refund for amortization fees:

Liquidation

Accounting Role	Amount Tag	Dr./Cr. Indicator
Customer	<Fee Component>_LIQD	Debit
<Fee Component>FIA	<Fee Component>_LIQD	Credit

 

Refund

Accounting Role	Amount Tag	Dr./Cr. Indicator
<Fee Component>FIA	<Fee Compo­nent>_DECR	Debit
Customer	<Fee Compo­nent>_DECR	Credit

 

The following entries need to be set up for systematic liquidation and refund for amortization fees:

Liquidation

Accounting Role	Amount Tag	Dr./Cr. Indicator
<Fee Compo­nent>FLR	<Fee Compo­nent>_FRLQ	Debit
<Fee Component>FIA	<Fee Compo­nent>_FRLQ	Credit

 

Refund

Accounting Role	Amount Tag	Dr./Cr. Indicator
<Fee Component>FIA	<Fee Compo­nent>_FRRF	Debit
<Fee Compo­nent>FLR	<Fee Compo­nent>_FRRF	Credit

 

16.5.3.10 FRSV: Unfunded and Funded FAS114 Reserve Increase/ Decrease

The following accounting entries need to be maintained for release of FAS114 Reserve Funded balance when the commitment status changes from ‘Non-performing’ to ‘Performing’:

Accounting Role	Amount Tag	Dr./Cr. Indicator
FASFNDEDRSV	FUND_FASDEC	Debit
FASFUNDEDREL	FUND_FASDEC	Credit

 

The following accounting entries need to be maintained for release of FAS114 Reserve Unfunded balance when the commitment status changes from ‘Non-performing’ to ‘Performing’:

Accounting Role	Amount Tag	Dr./Cr. Indicator
FASUNFNDEDRSV	UNFUND_FASDEC	Debit
FASUNFUNDRLS	UNFUND_FASDEC	Credit

 

Note that these accounting entries will be posted only if ‘Cost of Credit’ box is checked for the loan.

16.5.4 Late Payment Charges

The following accounting entries need to be maintained for ‘LIQD’ and ‘SPWV’ events at loan product level to process late payment charges.

16.5.4.1 LIQD: Liquidation

Accounting Role	Amount Tag	Dr./Cr. Indicator
CUSTOMER	<Special Penalty Compo­nent>_LIQD	Debit
<Special Penalty Compo­nent>INC	<Special Penalty Compo­nent>_LIQD	Credit

16.5.4.2 SPWV: Special Penalty Waiver

Accounting Role	Amount Tag	Dr./Cr. Indicator
ADJMNT_GL	<Special Penalty Component>_WAIV	Debit
ADJMNT_GL_OFF	<Special Penalty Component>_WAIV	Credit

16.5.4.3 PRLQ: Partial Liquidation

Accounting Role	Amount Tag	Dr./Cr. Indicator
CUSTOMER	<Special Penalty Compo­nent>_PAY	Credit
<Special Penalty Compo­nent>PAY	<Special Penalty Compo­nent>_PAY	Debit
CUSTOMER	<Special Penalty Compo­nent>_REC	Debit
<Special Penalty Compo­nent>REC	<Special Penalty Compo­nent>_REC	Credit

16.5.4.4 RSPW: Reversal of Special Penalty Waiver

Accounting entries for RSPW event will be derived by the system from the entries defined for SPWV.

Accounting Role	Amount Tag	Dr./Cr. Indicator
ADJMNT_GL	<Special Penalty Component>_WAIV	Credit
ADJMNT_GL_OFF	<Special Penalty Component>_WAIV	Debit

16.5.5 Advices in Oracle Lending module

16.5.5.1 LD_CR_ADV

ADVICE TAGS	DESCRIPTION	Tab/Button-FIELD NAME
_TDATE_	Event Date	Contract Input Screen - Events Tab
_REF_	Reference Number	Contract Input Screen-Header
_CUSTOMER_	Counterparty Name	Contract Input Screen-Contract Tab
_NEWAMT_	New amount	Contract Input Screen- Con­tract Tab
_VALDT_	Value Date	Contract Input Screen- Con­tract Tab
_MDATE_	Maturity Date	Contract Input Screen- Con­tract Tab
_BDATE_	Book Date	Contract Input Screen- Con­tract Tab
_ICCFACC_	ICCF Account Number	Contract Input Screen - Settle­ment Tab

16.5.5.2 OL_CONT_ADV

ADVICE TAGS	DESCRIPTION	Tab/Button-FIELD NAME
_TDATE_	Event Date	Contract Input Screen - Events Tab
_REF_	Reference Number	Contract Input Screen-Header
_CUSTOMER_	Counterparty Name	Contract Input Screen-Contract Tab
_NEWAMT_	New amount	Contract Input Screen- Con­tract Tab
_VALDT_	Value Date	Contract Input Screen- Con­tract Tab
_MDATE_	Maturity Date	Contract Input Screen- Con­tract Tab
_BDATE_	Book Date	Contract Input Screen- Con­tract Tab
_ICCFACC_	ICCF Account Number	Contract Input Screen - Settle­ment Tab

16.5.5.3 OL_INIT_ADV

ADVICE TAGS	DESCRIPTION	Tab/Button-FIELD NAME
_CUSTOMER_	Counterparty Name	Contract Input Screen-Contract Tab
_CONTRACTREFNO_	Contract Reference Num­ber	Contract Input Screen - Header
_BRNAME_	Branch name	Contract Input Screen - Header
_PROD_	Loan Product Code	Contract Input Screen - Header
_PRODCAT_	Product Category	Contract Input Screen - Header
_CCY_	Currency	Contract Input Screen-Contract Tab
_CUST_	Customer ID	Contract Input Screen- Over­write SI Details
_AMT_	Amount financed	Contract Input Screen-Contract Tab
_AMTDSBR_	Amount Disbursed	Contract Input Screen-Contract Tab
_VALDT_	Value Date	Contract Input Screen-Contract Tab
_MDATE_	Maturity Date	Contract Input Screen-Contract Tab
_BDATE_	Book Date	Contract Input Screen-Contract Tab
_RATE_	Interest Rate	Contract Input Screen - ICCF Details Tab
_SECOMP_	Component	Contract Input Screen - ICCF Details Tab
_ACCOUNT_	Settlement Account	Contract Input Screen - Settle­ment Tab
_SECCY_	Account Currency	Contract Input Screen - Settle­ment Tab
_SEBR_	Account Branch	Contract Input Screen - Settle­ment Tab
_SECOMPDESC_	Component Description	Contract Input Screen - ICCF Details Tab
_MCMP_	Component description	Contract Input Screen - ICCF Details Tab
_SCHDATE_	Schedule Date	Contract Input Screen >Sched­ule Tab > Payment Details
_MCCY_	Component Currency	Contract Input Screen - ICCF Details Tab
_MAMT_	Schedule Amount	Contract Input Screen >Sched­ule Tab
_NETICCF_	Net ICCF amount	Contract Input Screen >Sched­ule Tab
_NETINT_	Net Interest amount	Contract Input Screen - ICCF Details Tab

16.5.5.4 OL_REVN_ADV

ADVICE TAGS	DESCRIPTION	Tab/Button-FIELD NAME
_CUSTOMER_	Counterparty Name	Contract Input Screen-Contract Tab
_ADVICE-DATE_	Advice Date	Contract Input Screen - Events > Events Date
_ORIG-CONTRAC­TREF-NO_	Contract reference Num­ber	Contract Input Screen - Header
_BRANCHNAME_	Branch name	Contract Input Screen - Header
_CREDIT-LINE_	Linked Ref No	Contract Input Screen- Link­ages tab
_BORR-CUSTNAME_	Counter party name	Contract Input Screen- Con­tract Tab
_BRANCHDATE_	Branch Date	Application Header
_VALUEDATE_	Value Date	Contract Input Screen-Contract Tab
_MATDATE_	Maturity Date	Contract Input Screen-Contract Tab
_LOANCCY_	Loan Currency	Contract Input Screen- Con­tract Tab
_LOANAMT_	Loan Amount	Contract Input Screen- Con­tract Tab
_REVISION-DATE_	Revision Date	Contract Input Screen-Sched­ules tab- Revision Details but­ton
_COMPONENT_	Component	Contract Input Screen-Sched­ules tab- Revision Details but­ton
_CURRENT-RATE_	Net Rate	Contract Input Screen - ICCF Details

16.5.5.5 OL_BILNOTC_ADV

ADVICE TAGS	DESCRIPTION	Tab/Button-FIELD NAME
_TDATE_	Event Date	Contract Input Screen - Events Tab
_CACUST_	Counterparty Name	Contract Input Screen-Contract Tab
_REF_	Reference Number	Contract Input Screen - Header
_COMPCCY_	Component Currency	Contract Input Screen - ICCF Details tab
_OUTBAL_	Outstanding Amount	Contract Input Screen - Header
_MDATE_	Maturity Date	Contract Input Screen - Con­tract Tab
_CASTDATE_	Starting date for ICCF cal­culation	Contract Input Screen - Sched­ules Tab
_CAENDT_	End date for ICCF calcula­tion	Contract Input Screen - Sched­ules Tab
_CALCBAMT_	Amount Funded	Contract Input Screen - Con­tract Tab
_CALCRT_	Interest Rate	Contract Input Screen - ICCF Details Tab
_INTBASIS_	Interest Day Basis	Contract Input Screen - ICCF Details Tab
_CASTDT_	Starting date for ICCF cal­culation	Contract Input Screen - Sched­ules Tab
_CAENDDT_	End date for ICCF calcula­tion	Contract Input Screen - Sched­ules Tab
_CALCAMT_	Calculated amount	Contract Input Screen - Sched­ules Tab
_COMPCCY_	Currency Amount Due	Contract Input Screen - ICCF Tab
_CALINT_	Calculated amount	Contract Input Screen - Sched­ules Tab
_CATOTAMT_	Total amount	Contract Input Screen - Sched­ules Tab
_COMPDESC_	Component Description	Contract Input Screen- ICCF Details Tab
_COMPCCY_	Remittance Currency	Contract Input Screen - Con­tract Tab
_BACCOUNT_	Settlement Account Num­ber	Contract Input Screen - Settle­ments Tab

16.5.5.6 OLAMDADV

ADVICE TAGS	DESCRIPTION	Tab/Button-FIELD NAME
_CUSTNAME_	Counter Party Name	Amendment screen header
_TDATE_	Start Date	Amendment screen header
_CUSTOMER_	Customer ID	Amendment screen header
_REF_	Contract Reference Number	Amendment screen header
_DIFFAMT_	Change in Principal Check	NA
_OLDAMT_	Old Contract Amount	Amendment screen – Amend­ments Tab
_NEWAMT_	New Contract Amount	Amendment screen – Amend­ments Tab
_CCY_	Contract Currency	Amendment screen header
_MATDT_	Maturity Date Change Check	NA
_OLDMATDT_	Old Maturity date	Amendment screen – Amend­ments Tab
_OLDMATDT_	Old Maturity date	Amendment screen – Amend­ments Tab
_NEWMATDT_	New Maturity date	Amendment screen – Amend­ments Tab
_FIXED_	Fixed Interest Change Check	NA
_XCOMP_	Fixed interest Component name	Amendment screen – Interest Call­form
_OLDRATE_	Old Interest rate	Amendment screen – Interest Call­form
_NEWRATE_	New Interest rate	Amendment screen – Interest Call­form
_FLOATING_	Floating Interest Change Check	NA
_FCOMP_	Floating interest Component name	Amendment screen – Interest Call­form
_OLDRTCODE_	Old floating rate code	Amendment screen – Interest Call­form
_NEWRTCODE_	New floating rate code	Amendment screen – Interest Call­form
_OLDSPRD_	Old Spread Value	Amendment screen – Interest Call­form
_NEWSPRD_	New Spread Value	Amendment screen – Interest Call­form
_SPECIAL_	Special Interest change Check	NA
_SCOMP_	Component name	Amendment screen – Interest Call­form
_E__NEWAMT_	Special New amount	Amendment screen – Interest Call­form
_SIM_	Simulation Check	NA
_SDUEDT_	Due Date	Amendment screen – Payment Details Callform
_SIM_	Simulation Check	NA
_OUTST_	Amount Due	Amendment screen – Payment Details Callform
_AVDATE_	Amendment Date	Amendment screen header
_PG_	Page Number	NA
_ORGVAMB_	Original Amendment check	NA

16.5.5.7 OL_SIM_ADV

ADVICE TAGS	DESCRIPTION	Tab/Button-FIELD NAME
_CUSTOMER_	Counterparty Name	Simulation Input Screen-Contract Tab
_ADD1_	Address line 1	NA
_ADD2_	Address line 2	NA
_ADD3_	Address line 3	NA
_CONTRACTREF­NO_	Contract Reference Number	Simulation Input Screen-Contract Tab
_BRNAME_	Branch name	Simulation Input Screen-Contract Tab
_PROD_	Loan Product Code	Simulation Input Screen-Contract Tab
_PRODCAT_	Product Category	Simulation Input Screen-Contract Tab
_CCY_	Currency	Simulation Input Screen-Contract Tab
_CUST_	Customer ID	Simulation Input Screen-Contract Tab
_AMT_	Amount financed	Simulation Input Screen-Contract Tab
_AMTDSBR_	Amount Disbursed	Simulation Input Screen-Contract Tab
_VALDT_	Value Date	Simulation Input Screen-Contract
_MDATE_	Maturity Date	Simulation Input Screen-Contract Tab
_BDATE_	Book Date	Simulation Input Screen-Contract Tab
_TENOR_	Duration	NA
_RATE_	Interest Rate	Simulation Input Screen - ICCF Details Tab
_CMPSIM_	Component name	Simulation screen – Schedule Tab > Payment Details
_DATSIM_	Due Date	Simulation screen – Schedule Tab > Payment Details
_AMTSIM_	Amount Due	Simulation screen – Schedule Tab > Payment Details
_CCYSIM_	Currency	Simulation screen – Schedule Tab > Payment Details

16.5.5.8 DRADV

ADVICE TAGS	DESCRIPTION	Tab/Button-FIELD NAME
_BRANCHDATE_	Branch Date	Payment Simulation Screen Header
_CUSTOMER-NAME_	Customer Name	NA
_ADDRESS1_	Customer Address Line1	NA
_ADDRESS2_	Customer Address Line2	NA
_ADDRESS3_	Customer Address Line3	NA
_ADDRESS4_	Customer Address Line4	NA
_CUSTOMER_	Customer ID	Payment Simulation Screen Header
_ACCOUNT_	Account Number	Payment Simulation Screen-Accounting Entries Call Form
_ACC-DESC_	Account Description	Payment Simulation Screen-Accounting Entries Call Form
_VALUE-DATE_	Value Date	Payment Simulation Screen Header
_CCY_	Currency	Payment Simulation Screen Header
_SETTLEMENT-AMT_	Amount Settled	Payment Simulation Screen Header
_AMOUNTIN­WORDS_	Amount Settled in Words	NA
_CONTRACTREF­NO_	Contract Reference No	Payment Simulation Screen Header
_USERREFNO_	Reference Number	NA
_SIM_	Simulation Check	NA
_SCOMP_	Component name	Payment Simulation Screen-Schedule Details Button
_SDUEDT_	Due Date	Payment Simulation Screen-Schedule Details Button
_OUTST_	Amount Due	Payment Simulation Screen-Schedule Details Button
_PAYMNT-DETAILS1_	Payment details	Payment Simulation Screen-Settle­ments Call Form
_PAYMNT-DETAILS2_	Payment details	Payment Simulation Screen-Settle­ments Call Form
_PAYMNT-DETAILS3_	Payment details	Payment Simulation Screen-Settle­ments Call Form
_PAYMNT-DETAILS4_	Payment details	Payment Simulation Screen-Settle­ments Call Form
_SNDR-RECV-INFO1_	Sender Receiver Details	Payment Simulation Screen-Settle­ments Call Form
_SNDR-RECV-INFO2_	Sender Receiver Details	Payment Simulation Screen-Settle­ments Call Form
_SNDR-RECV-INFO3_	Sender Receiver Details	Payment Simulation Screen-Settle­ments Call Form
_SNDR-RECV-INFO4_	Sender Receiver Details	Payment Simulation Screen-Settle­ments Call Form
_SNDR-RECV-INFO5_	Sender Receiver Details	Payment Simulation Screen-Settle­ments Call Form
_SNDR-RECV-INFO6_	Sender Receiver Details	Payment Simulation Screen-Settle­ments Call Form
_SLOGAN_	Product Slogan	NA
_BRANCHNAME_	Branch Name	NA
_PG_	Page Number	NA
_PAMT_	Total Paid Amount	NA
_VDATE_	Value date	NA

16.6 Accounting Entries for Contract Adjustment

Contract Ref No	Account	Amount Tag	EVENT	DrCr	FCY Amt	LCY Amt
CIPL­BN105118F3V4	160100501	PRINCIPAL_­ADJ	CADJ	Cr		2,000,000.00
CIPL­BN105118F3V4	330850401	PRINCIPAL_­ADJ	CADJ	Dr		2,000,000.00
CIPL­BN105118F3V4	0701000511	CONTRA-INT-ADJ	CADJ	Cr		1,000,000.00
Contract Ref No	Account	Amount Tag	EVENT	DrCr	FCY Amt	LCY Amt
CIPL­BN105118F3V4	0702000921	CONTRA-INT-ADJ	CADJ	Dr		1,000,000.00

Note

• The contract Adjustment entries are authorized when the Adjustment Activity is authorized.
• The Adjustment entry process flow is similar to journal entry process with respect to the GL updates and the handoff to the down stream systems
• The adjustment entries are always passed in the contract currency
• Payment messages are not applicable for the adjustment entries
• The Adjustment entry account balance is stored in Value dated and Monthly turnover table.

 

16.7 Payable Receivable Liquidation

PRLQ: - Liquidation of the Payables/Receivables

RVPR: - Reversal of the Payable/Receivable Payment

Accounting Role	Account	Dr/Cr Indicator
Expense	COMPONENT_PAY	Dr
Customer	COMPONENT_PAY	Cr
Asset	PRINCIPAL_PAY	Dr
Customer	PRINCIPAL_PAY	Cr
Customer	COMPO­NENT_REC	Dr
Accounting Role	Account	Dr/Cr Indicator
Income	COMP_REC	Cr
Customer	PRINCIPAL_REC	Dr
Asset	PRINCIPAL_REC	Cr

16.8 Accounting for Discounted Loans

In this section, we shall discuss the manner in which you can define attributes and pass accounting entries specific to a Discounted Loan product.

A discounted loan is one for which the interest is collected upfront.

Example

On Jan 01, 2002, you lend USD 100 to customer ABC for a tenor of 1 year at a rate of interest of 10% per year. On Dec 31, 2002, he would pay you back USD 110 – repayment of principal amount of USD 100 and payment of interest of USD 10.

Instead, in a Discounted Loan, you collect the interest of USD 10 upfront.

Therefore, you book a loan of USD 100 while disbursing USD 100 – USD 10 = USD 90.

For each event (INIT, ACCR, LIQD), the Product Event Accounting Entries Maintenance Screen allows you to select the Accounting Roles, the corresponding Amount Tags and the Debit/Credit Indicator.

Event INIT

For the above example, the following accounting entries will be passed on INIT:

Accounting Role	Amount Tag	Dr/Cr Indicator	Amount
ASSETGL	PRINCIPAL	Dr	100.00
CUSTOMER	PRINCIPAL	Cr	100.00
LDDL-INTRIA	LDDL-INT_LIQD	Cr	10.00
CUSTOMER	LDDL-INT_LIQD	Dr	10.00

 

Event: ACCR

Accrued interest is pro-rated over the life of the loan. Accrual entries passed are as follows:

Accounting Role	Amount Tag	Dr/Cr Indicator
LDDL-INTREC	LDDL-INT_ACCR	Dr
LDDL-INTINC	LDDL-INT_ACCR	Cr

Event: LIQD

For the above example, let us assume that the principal amount of USD 100 is liquidated in equal installments as shown in the graph above, i.e., USD 20 is liquidated in each of five tranches. Entries for liquidation of accrued interest are passed along with the installment liquidation entries.

Note

During each liquidation, the entire interest accrued till that date will be liquidated, irrespec­tive of the whether the customer is repaying the full installment or not.

For the above example, the entries passed during each of the five liquidations are:

Accounting Role	Amount Tag	Dr/Cr Indicator	Amount
ASSETGL	PRINCIPAL_LIQD	Cr	20.00
CUSTOMER	PRINCIPAL_LIQD	Dr	20.00
LDDL-INTRIA	LDDL-INT_LIQD	Dr	2.00
LDDL-INTREC	LDDL-INT_LIQD	Cr	2.00

 

16.9 Accounting Entries for Non-Performing Loans

The following entries are applicable when interest payment is done for non-performing loans:

LIQD: Interest Payment

Account	Amount	Dr/Cr Indicator
CUSTOMER	INTEREST	Dr
RECEIVABLE	INTEREST	Cr

 

ACCR: Memo To Real Movement

Account	Amount	Dr/Cr Indicator
MEMO INCOME	INTEREST	Dr
MEMO RECEIVABLE	INTEREST	Cr
RECEIVABLE	INTEREST	DR
INCOME	INTEREST	CR

 

CICR: Contra Increase

Account	Amount	Dr/Cr Indicator
INCOME	INTEREST	Dr
CONTRA	INTEREST	Cr

 

The following entries are passed when interest payment for non-performing loans is reversed:

REVP: Interest Payment Reversal

Account	Amount	Dr/Cr Indicator
RECEIVABLE	INTEREST	Dr
CUSTOMER	INTEREST	Cr

 

ACCR: Memo To Real Movement

Account	Amount	Dr/Cr Indicator
MEMO RECEIVABLE	INTEREST	Dr
MEMO INCOME	INTEREST	Cr
INCOME	INTEREST	DR
RECEIVABLE	INTEREST	CR

 

CICR: Contra Increase

Account	Amount	Dr/Cr Indicator
CONTRA	INTEREST	Dr
INCOME	INTEREST	Cr

 

The following are the entries for interest payment for non-performing loans which are partially or fully reserved:

LIQD: Interest Payment

Account	Amount	Dr/Cr Indicator
CUSTOMER	INTEREST	Dr
RECEIVABLE	INTEREST	Cr

 

ACCR: Memo To Real Movement

Account	Amount	Dr/Cr Indicator
MEMO INCOME	INTEREST	Dr
MEMO RECEIVABLE	INTEREST	Cr
RECEIVABLE	INTEREST	DR
INCOME	INTEREST	CR

 

CICR: Contra Increase

Account	Amount	Dr/Cr Indicator
INCOME	INTEREST	Dr
CONTRA	INTEREST	Cr

 

FRSV: FAS114 Reserve Decrease

Account	Amount	Dr/Cr Indicator
FAS114 FUNDED RESERVE	Least of (Reserve Decrease Amt, Existing FAS 114 Reserve)	Dr
FAS114 FUNDED RELEASE	Least of (Reserve Decrease Amt, Existing FAS 114 Reserve)	Cr

 

RESR: Reserve Decrease

Account	Amount	Dr/Cr Indicator
RESERVE	Least of (Residual of Reserve Decrease Amt after FRSV, Existing Reserve)	Dr
RECOV­ERY	Least of (Residual of Reserve Decrease Amt after FRSV, Existing Reserve)	Cr

 

 

16.10 Accounting Entries for Reserved and Non-reserved Loans

The following entry is posted when a manual contra increase is performed for an Non-reserved Loan:

CICR: Contra Increase

Account	Amount	Dr/Cr Indicator
CUS­TOMER	INTER­EST	Dr
CONTRA	INTER­EST	Cr

 

The following entries are posted when a manual contra increase is performed for a reserved Loan:

CICR: Contra Increase

Account	Amount	Dr/Cr Indicator
CUSTOMER	INTEREST	Dr
CONTRA	INTEREST	Cr

 

FRSV: FAS114 Reserve Decrease

Account	Amount	Dr/Cr Indicator
FAS114 FUNDED RESERVE	Least of (Reserve Decrease Amt, Existing FAS 114 Reserve)	Dr
FAS114 FUNDED RELEASE	Least of (Reserve Decrease Amt, Existing FAS 114 Reserve)	Cr

 

RESR: Reserve Decrease

Account	Amount	Dr/Cr Indicator
RESERVE	Least of (Residual of Reserve Decrease Amt after FRSV, Existing Reserve)	Dr
RECOV­ERY	Least of (Residual of Reserve Decrease Amt after FRSV, Existing Reserve)	Cr

 

16.11 Accounting Entries for Cost of Credit Valuation

The following entries are posted for cost of credit valuation:

FELR: Fee Liquidation

The entries posted for fee liquidation are listed below:

Accounting Role	Amount Tag	Dr/Cr Indicator
COMPONENT_FIA	COMPONENT_DECR	D
MARKWOOFFSET	COMPONENT_DECR	C
CUSTOMER	COMPONENT_LIQD	D
COMPONENT_FIA	COMPONENT_LIQD	C
COMPONENT_FIA	COMPONENT_DECR	D
CUSTOMER	COMPONENT_DECR	C
COMPONENT_FIA	COMPONENT_LIQD	C
CUSTOMER	COMPONENT_LIQD	D

 

FACR: Fee Accrual

The entries for fee accrual are listed below:

Accounting Role	Amount Tag	Dr/Cr Indicator
COMPONENT_­FIN	COMPO­NENT_ACCR	C
COMPONENT_­FIA	COMPO­NENT_ACCR	D

 

FRSV: Unfunded and Funded FAS114 Reserve Increase/ Decrease

The entries for unfunded FAS114 reserve decrease are listed below:

Accounting Role	Amount Tag	Dr/Cr Indicator
FASUNFND­EDRSV	UNFUND_FAS­DEC	Dr
FASUNFUNDRLS	UNFUND_FAS­DEC	Cr

The entries for unfunded FAS114 reserve increase are listed below:

Accounting Role	Amount Tag	Dr/Cr Indicator
FASUNFUNDBLD	UNFUND_­FASINC	Dr
FASUNFND­EDRSV	UNFUND_­FASINC	Cr

The entries for funded FAS114 reserve increase are listed below:

Accounting Role	Amount Tag	Dr/Cr Indicator
FASFUNDEDBUILD	FUND_FASINC	D
FASFNDEDRSV	FUND_FASINC	C

 

The entries for funded FAS114 reserve decrease are listed below:

Accounting Role	Amount Tag	Dr/Cr Indicator
FASFNDEDRSV	FUND_FASDEC	D
FASFUNDEDREL	FUND_FASDEC	C

TRCL: Trade Reclassification

The entries posted for trade reclassification are listed below:

Accounting Role	Amount Tag	Dr/Cr Indicator
CONASSETGL	PRINC_HFS_DECR	D
CONASSETGLHFS	PRINC_HFS_DECR	C
CONASSETGLHFS	PRINC_HFS_INCR	D
CONASSETGL	PRINC_HFS_INCR	C
ASSETGL	PRINC_HFS_DECR	D
ASSETGLHFS	PRINC_HFS_DECR	C
ASSETGLHFS	PRINC_HFS_INCR	D
ASSETGL	PRINC_HFS_INCR	C

CREB: Contra Rebalance

The entries posted for contra rebalancing are listed below:

Accounting Role	Amount Tag	Dr/Cr Indicator
CONTRAGL	LD-FX-INT_CDCR	D
WASHACC	LD-FX-INT_CDCR	C
WASHACC	LD-FX-INT_CICR	D
CONTRAGL	LD-FX-INT_CICR	C

FREB: FAS114 Rebalance

The entries posted for FAS114 rebalancing are listed below:

Accounting Role	Amount Tag	Dr/Cr Indicator
FASFNDEDRSV	FUND_FASDEC	D
WASHACC	FUND_FASDEC	C
WASHACC	FUND_FASINC	D
FASFNDEDRSV	FUND_FASINC	C

WREB: Write-off Rebalance

The entries posted for write-off rebalancing are listed below:

Accounting Role	Amount Tag	Dr/Cr Indicator
RESERVEGL	PRINCIPAL_RDEC	D
WASHACC	PRINCIPAL_RDEC	C
WASHACC	PRINCIPAL_RINC	D
RESERVEGL	PRINCIPAL_RINC	C

RESR: Reserve Decrease

The entries posted for reserve decrease are listed below:

Accounting Role	Amount Tag	Dr/Cr Indicator
RESERVEGL	PRINCIPAL_RDEC	D
URECOVERY_GL	PRINCIPAL_RDEC	C
WRITEOFFEXP	PRINCIPAL_RINC	D
RESERVEGL	PRINCIPAL_RINC	C

 

CDCR: Contra Decrease

The entries posted for contra decrease are listed below:

Accounting Role	Amount Tag	Dr/Cr Indicator
CONTRAGL	COMPONENT_CDCR	D
CUSTOMER	COMPONENT _CDCR	C

CICR: Contra Increase

The entries posted for contra increase are listed below:

Accounting Role	Amount Tag	Dr/Cr Indicator
COMPONENTINC	COMPONENT_CICR	D
CONTRAGL	COMPONENT_CICR	C
CUSTOMER	COMPONENT_MCICR	D
CONTRAGL	COMPONENT_MCICR	C

16.12 Accounting Entries for LC Sublimit Re-classification

The possible accounting entries for the event TRCL are given below:

Event	Amount Tag	Accounting Role	Dr/Cr
TRCL	LCLMT_HFS_INCR	LCSUBLIMITHFS	Dr
TRCL	LCLMT_HFS_INCR	LCSUBLIMIT	Cr
TRCL	LCLMT_HFS_DECR	LCSUBLIMIT	Dr
TRCL	LCLMT_HFS_DECR	LCSUBLIMITHFS	Cr

16.13 Accounting Entries for Rollover Contingent

RAMD: Rollover Amendment

Accounting Role	Amount Tags	Dr/Cr. Indicator
CONASSETGL	PRIN_CONT_DECR	Credit
CONASSETGL	PRIN_CONT_INCR	Debit
CONASSETOFF	PRIN_CONT_INCR	Credit
CONASSETOFF	PRIN_CONT_DECR	Debit

16.14 Error Codes

16.14.1 Amortized Exchange Details

The following error codes are available for exchange details:

Error_Code	Description
CF-NRTE01	Amort Exch Rate cannot be less than equal to Zero

 

16.14.2 Effective Date of Exchange Rate Amendment

The following error codes are available for effective date:

Error Code	Message	Type
LD-EXAMD102	Effective date cannot be earlier than the last com­mitment fee liquidation date	E
LD-EXAMD101	Effective date cannot be earlier or equal to VAMI date. + code change	E

16.14.3 Adjustment Reversal Details

The following error codes are available for adjustment reversal details:

Error_Code	Description
LD-ADJ-022	Invalid Debit GL Account.
LD-ADJ-023	Invalid Credit GL Account.
LD-ADJ-026	Accounting entries not found for the Debit account type
LD-ADJ-025	Accounting entries not found for the Credit account type
LD-ADJ-027	Adjustments Reversal Processing Failed
LD-ADJ-028	Value Date cannot be less than today for Operation Adjustments
LD-ADJ-029	Auto reversal is not allowed for Operation Adjustments

 

16.14.4 Cost of Credit Valuation

The following error codes are available for the cost of credit valuation process:

Error_Code	Description
LD-COC-01	COC Revaluation failed
LD-COC-02	Failed in COC balances population
LD-COC-03	Failed in commitment COC population
LD-COC-04	Failed in commitment COC balances population
LD-COC-05	Failed in loan balances population for a commitment
LD-COC-06	Failed in populating loan balance
LD-COC-07	Error in loan COC balance population
LD-COC-08	Error in updating commitment COC balance
LD-COC-09	Error in updating loan COC balance
LD-COC-10	Net carry value for a loan cannot be negative
LD-COC-11	Failed in updating loan COC rebalance values
LD-COC-12	Failed in Transfer Asset Marks processing
LD-COC-13	Failed in populating Transfer Asset Marks
LD-COC-14	Failed in FAS114/ Write-off processing
LD-COC-15	Failed in populating FAS114/ Write-off amounts
LD-COC-16	Failed in Recovery processing
LD-COC-17	Failed in Rebalance processing
LD-COC-18	Failed in Cost of Credit Validation
LD-COC-19	Error in populating Cost of Credit details
LD-COC-20	Error in setting Cost of Credit valuation required flag
LD-COC-21	Failed in Cost of Credit valuation status update
LD-COC-22	Cannot set Cost of Credit Valuation, as Product is not checked for Cost Of Credit Valuation
LD-COC-23	Failed in computing FAS114 Reserve Release values
LD-COC-24	Failed in CoC balances archiving
LD-COC-26	FAS91 Fee Refund / Liquidation population failed
LD-COC-27	FAS91 Fee Refund / Liquidation process failed
LD-COC-28	At least one event should be chosen for reversal
LD-COC-29	Only one event at a time can be reversed
LD-COC-30	Failed in Deferred interest component processing on commitments
LD-COC-31	Failed in Negative carrying value processing on com­mitments
LD-COC-33	Failed in Amort fee accrual restart
LD-COC-39	Contra/Writeoff/Fas114 Reserve balance will be in negative after reversal. Do you want to continue?
LD-COC-34	COC Valuation required flag will be defaulted from product as contract is in Non-Performing Status. Do you want to proceed?
LD-COC-40	COC balance is negative after rebalancing
CF-AC005	Only one component is allowed to check as Deferred interest component

16.14.5 LC Sublimit Balance (HFI) Update

The following error codes are available for LC Sublimit Balance (HFI) Update:

Error_Code	Description
LD-STP-LC06	LC Sublimit HFI Balance Update failed

 

16.14.6 Late Payment Charges

The following error codes are available for late payment charges:

Error_Code	Description	Error Type
LD-CON-310	Grace days for the Loan is defaulted from the commitment contract	O
LD-CON-311	Grace period is defaulted from loan product	O
LD-VAM-61	For special rate type Amount/Rate change should be current dated	E
CS-WVR-001	Penalty Waiver Details need to be captured	E
CS-WVR-002	Amendment is not allowed on the Reversed Transactions	E
CS-WVR-003	Transaction did not happen from here, amend it from appropriate screen	E
CS-WVR-004	Transactions can be saved only with waive flag checked	E
CS-WVR-005	Prior schedules are unpaid for this compo­nent. Please pay/waive all such schedules before proceeding	E
CF-CL0021	For the given amount category, Accrual Required flag should be set to N	E
CS-WVR-006	Reversal of Waiver not allowed as nothing is due on the given due date	E
CS-WVR-007	Reversal not allowed, Latest due date should be reversed first.	E
CS-WVR-008	Later schedules are waived for this compo­nent. Please reverse waiver for all such schedules before proceeding	E

 

16.14.7 All-In Rate Floor/Ceiling for Loans

Error Code	Description	Error Type
LD-FLR-001	Rate for $1 component is lesser than the Floor defined at Commitment Level. Do you want to override?	O
LD-FLR-002	Rate for $1 component is greater than the Ceiling defined at Commitment Level. Do you want to override?	O
LD-FLR-003	Failed in getting the floor and ceiling rate	E
LD-FLR-004	Rate for $1 component is lesser than the Floor defined at Commitment Level. Do you want to Continue?	O
LD-FLR-005	Rate for $1 component is greater than the Ceiling defined at Commitment Level. Do you want to Continue?	O
LD-FLR-006	Maintenance was not done from here, so authorize it from appropriate screen.	E
LD-FLR-007	Maintenance was not done from here, so delete it from appropriate screen	E

 

16.14.8 Pool Funds

The following error codes are available for Pool Funds:

Error Code	Description
LD-POOL-01	Pool Amount cannot be Blank or zero or negative
LD-POOL-02	Cannot Copy Unauthorized Record
LD-POOL-05	Pool funding ref no cannot be null.
LD-POOL-06	Master funding ref no cannot be null.
LD-POOL-07	Contract Amount is not maintained.
LD-POOL-08	Contract currency is not maintained
LD-POOL-09	Unable to compute available amount for the pool $1.
LD-POOL-10	Insufficient balance in the Pool $1, booking not allowed.
LD-POOL-11	Failed in validating funding pool details.
LD-POOL-12	Pool $1 is either unauthorized or locked by another process. Cannot proceed.
LD-POOL-16	Loan and Commitment currency should be same for Commit­ments linked to a Pool.
LD-POOL-17	This Commitment is linked to loans in a different currency; hence Pool cannot be attached.

 

16.14.9 Chinese Characters in Payment

The following error code is available for Chinese Characters in payment:

Error Code	Description
LD-BR103	Do you want to disable Chinese characters in Payment ?

 

16.14.10 UCC Processing

The following error codes are available for UCC processing of disclosure codes and contract disclosure schedule:

Error Code	Description
LS-DSC-017	Expiry Date cannot be less than Application Date
LS-DSC-018	Expiry Date is Mandatory if UCC code is selected
LS-DSC-019	Expiry Date will be propagated to UCC linked contracts upon authoriza­tion, do you want to continue?
LS-DSC-022	Contract Disclosure schedule for $1 is being amended by another user; expiry date will not be propagated
LS-DSC-028	Expiry Date will not be propagated to contracts, do you want to con­tinue?
LS-DSC-031	Multiple schedules are not allowed for UCC disclosure codes
LS-DSC-032	End date cannot be lesser than Start date
LS-DSC-033	Cannot delete the schedule for UCC disclosure codes

16.14.11 Marking Contracts as Liquidated

The following error codes are available for marking the status of a loan or commitment contract from ‘Active’ to ‘Liquidated’.

Err Code	Error Message
LD-PMT304	Active Loans exist for the commitment. Liquidation not allowed.
LD-PMT306	Contract will be liquidated. Proceed?
LD-PMT307	Maturity date is greater than application date. Liquidation not allowed.
LD-PMT308	Validation for marking the liquidation is failed.
LD-PMT309	Principal Outstanding/amount due balance still exists. Liquidation not allowed.
LD-PMT310	Active STP contract exists. Liquidation not allowed.
LD-PMT311	The escrow balances linked to this contract is not zero. Liquidation not allowed.
LD-PMT313	Pending STP contract yet to be processed. Liquidation not Allowed

 

16.14.12 Clearing Line Validation

The following error codes are available for clearing line and credit line validation on Tranche and Drawdown contracts.

Err Code	Error Message
LD-C0802	Approved Clearing Line is Not Specified.
LD-C0812	Origination self participant $1 of the tranche is not linked to credit line.
LD-C0813	Self Participant $1''s amount $2 is more than credit limit amount $3.
LD-C0814	Clearing line limit check for tranche is failing .Tranche non HFI amount $1 is more than limit amount $2
LD-C0815	Tranche is linked to an unavailable clearing line.
LD-C0816	Origination self participant $1 is linked to an unavailable credit line.
LD-C0817	The Credit line GFRN value cannot change to clearing line GFRN.
LD-C0818	The Clearing line GFRN value cannot change to credit line GFRN.

 

16.14.13 Participant Margin Maintenance

The following error codes are available for participant level margin maintenance on Tranche and Drawdown contracts.

Err Code	Error Message
LN-PMAR-001	Lender margin maintenance is not allowed as this functionality is not enabled at Loan parameter maintenance level
LN-PMAR-002	Margin maintenance for lenders is not applicable for LOR type of con­tracts
LN-PMAR-003	NPVAMI is already performed on $1 hence participant margin can not be changed
LN-PMAR-005	Lender margin can be maintained only for main interest margin compo­nents
LN-PMAR-006	Floor/Ceiling is already maintained. Do you want to override it?
LN-PMAR-007	Total margin rate of all the participants is not same with borrower margin rate
LN-PMAR-010	Participant margin is not allowed on the tranche $1 having non prorata payment captured on underlying drawdowns
LN-PMAR-011	Lender margin can not be maintained for non-cascade participation types of tranche
LN-PMAR-016	Please visit the participant margin screen to correct the margin there
LN-PMAR-015	Participant margin maintained for effective date $1 will also be cleared. Do you want to proceed.

 

16.14.14 CUSIP Reclass

The following error codes are available for CUSIP reclass.

Error Code	Error Description
LD-RCLS-001	Batch No/No of job for CUSIP no reclass is not available could not pro­ceed with reclass processing
LD-RCLS-002	Cusip No Reclass has happened for this contract. Do you want to pro­ceed?.
LD-RCLS-003	CUSIP Reclass reprocessed successfully
LD-PMT317	Marking the tranche as Inactive is failed

 

16.15 Examples of Calculating TEAC

16.15.1 Example I – Simple Bearing loan

The Loan details are as follows:

• Loan Amount – 10,000
• Tenor 12 Months
• Nominal Rate – 12.0%
• Start Date – 1st Jan 2002
• End Date – 1st Jan 2003
• Loan Type – Bearing
• Number of Periods– 12
• Unit Period – Monthly
• Sub-period 30 days
• TEAC = 11.8372461257062%

  Date (Outflow)	Period	Outflow Amount	Sub Periods Fraction	Discounted Outflow	Date (Receipts)	Periods	Total Pay	Sub Period Fraction	Discounted Value of Receipts
  1/1/2002	0	10000	0.0000	10000	1/1/2002	0		0.0000	0.00
  2/1/2002	1.00		0.0333		2/1/2002	1.00	100	0.0333	98.99
  3/1/2002	1.00		0.9667		3/1/2002	1.00	100	0.9667	98.09
  4/1/2002	3.00		0.0000		4/1/2002	3.00	100	0.0000	97.10
  5/1/2002	4.00		0.0000		5/1/2002	4.00	100	0.0000	96.15
  6/1/2002	5.00		0.0333		6/1/2002	5.00	100	0.0333	95.18
  7/1/2002	6.00		0.0333		7/1/2002	6.00	100	0.0333	94.25
  8/1/2002	7.00		0.0667		8/1/2002	7.00	100	0.0667	93.30
  9/1/2002	8.00		0.1000		9/1/2002	8.00	100	0.1000	92.36
  10/1/2002	9.00		0.1000		10/1/2002	9.00	100	0.1000	91.45
  11/1/2002	10.00		0.1333		11/1/2002	10.00	100	0.1333	90.53
  12/1/2002	11.00		0.1333		12/1/2002	11.00	100	0.1333	89.65
  1/1/2003	12.00		0.1667		1/1/2003	12.00	10100	0.1667	8,962.96

•  

16.15.2 Example II –True Discounted Loan

The Loan details are as follows:

• Loan Amount – 10,000
• Tenor 12 Months
• Start Date – 1st Jan 2002
• End Date – 1st Jan 2003
• Nominal Rate – 12.0%
• Number of Periods– 1
• Sub-period - 360 days
• TEAC = 10.55227%

• Date (Outflow)	Period	Outflow Amount	Sub Periods Fraction	Discounted Outflow	Date (Receipts)	Periods	Total Pay	Sub Period Fraction	Discounted Value of Receipts
  1/1/2002	0	10000	0.0000	10000	1/1/2002	0	$0.00	0.0000	0.00
  2/1/2002	0.00		0.0861		2/1/2002	0.00	0	0.0861	0.00
  3/1/2002	0.00		0.1639		3/1/2002	0.00	0	0.1639	0.00
  4/1/2002	0.00		0.2500		4/1/2002	0.00	0	0.2500	0.00
  5/1/2002	0.00		0.3333		5/1/2002	0.00	0	0.3333	0.00
  6/1/2002	0.00		0.4194		6/1/2002	0.00	0	0.4194	0.00
  7/1/2002	0.00		0.5028		7/1/2002	0.00	0	0.5028	0.00
  8/1/2002	0.00		0.5889		8/1/2002	0.00	0	0.5889	0.00
  9/1/2002	0.00		0.6750		9/1/2002	0.00	0	0.6750	0.00
  10/1/2002	0.00		0.7583		10/1/2002	0.00	0	0.7583	0.00
  11/1/2002	0.00		0.8444		11/1/2002	0.00	0	0.8444	0.00
  12/1/2002	0.00		0.9278		12/1/2002	0.00	0	0.9278	0.00
  1/1/2003	1.00		0.0139		1/1/2003	1.00	11071.43	0.0139	10,000.00

16.15.3 Example III – Bearing Loan (Irregular Interest periodicity)

The Loan details are as follows:

• Loan Amount – 10,000
• Tenor 12 Months
• Start Date – 1st Jan 2002
• End Date – 1st Jan 2003
• Nominal Rate – 12.0%
• Loan Type – Bearing (Irregular Interest periods).
• Number of Periods – 15
• Sub-period 24 days
• TEAC = 11.82894%

  Date (Outflow)	Period	Outflow Amount	Sub Periods Fraction	Discounted Outflow	Date (Receipts)	Periods	Total Pay	Sub Period Fraction	Discounted Value of Receipts
  1/1/2002	0	10000	0.0000	10000	1/1/2002	0	$0.00	0.0000	0.00
  2/1/2002	1.00		0.2917		2/1/2002	1.00	100	0.2917	98.99
  3/1/2002	2.00		0.4583		3/1/2002	2.00	100	0.4583	98.09
  4/1/2002	3.00		0.7500		4/1/2002	3.00	100	0.7500	97.10
  5/1/2002	5.00		0.0000		5/1/2002	5.00	100	0.0000	96.15
  6/1/2002	6.00		0.2917		6/1/2002	6.00	100	0.2917	95.18
  7/1/2002	7.00		0.5417		7/1/2002	7.00	100	0.5417	94.25
  8/1/2002	8.00		0.8333		8/1/2002	8.00	100	0.8333	93.30
  9/1/2002	10.00		0.1250		9/1/2002	10.00	100	0.1250	92.35
  10/1/2002	11.00		0.3750		10/1/2002	11.00	100	0.3750	91.45
  11/1/2002	12.00		0.6667		11/1/2002	12.00	100	0.6667	90.53
  12/1/2002	13.00		0.9167		12/1/2002	13.00	100	0.9167	89.64
  12/5/2002	14		.0833		12/5/2002	14.00	13.33	0.0833	11.93
  12/12/2002	14		.3750		12/12/2002	14.00	23.33	0.3750	20.84
  12/27/2002	14		.0000		12/27/2002	15.00	50	0.0000	44.44
  1/1/2003	15.00		0.2083		1/1/2003	15.00	10013.33	0.2083	8,885.76

16.15.3.1 Example IV – Bearing loan (with Rate Changes)

The Loan details are as follows:

• Loan Amount – 10,000
• Tenor 12 Months
• Nominal Rate – 12.0%
• Rate Change – 18% (on 1st March 2002)
• Loan Type – Bearing
• Number of Periods – 12
• Sub Period – 30 days
• TEAC - 16.7001012606821%

  Date (Outflow)	Period	Outflow Amount	Sub Periods Fraction	Discounted Outflow	Date (Receipts)	Periods	Total Pay	Sub Period Fraction	Discounted Value of Receipts
  1/1/2002	0	10000	0.0000	10000	1/1/2002	0	$0.00	0.0000	0.00
  2/1/2002	1.00		0.0333		2/1/2002	1.00	100	0.0333	98.58
  3/1/2002	1.00		0.9667		3/1/2002	1.00	100	0.9667	97.32
  4/1/2002	3.00		0.0000		4/1/2002	3.00	150	0.0000	143.91
  5/1/2002	4.00		0.0000		5/1/2002	4.00	150	0.0000	141.93
  6/1/2002	5.00		0.0333		6/1/2002	5.00	150	0.0333	139.92
  7/1/2002	6.00		0.0333		7/1/2002	6.00	150	0.0333	138.00
  8/1/2002	7.00		0.0667		8/1/2002	7.00	150	0.0667	136.04
  9/1/2002	8.00		0.1000		9/1/2002	8.00	150	0.1000	134.11
  10/1/2002	9.00		0.1000		10/1/2002	9.00	150	0.1000	132.27
  11/1/2002	10.00		0.1333		11/1/2002	10.00	150	0.1333	130.40
  12/1/2002	11.00		0.1333		12/1/2002	11.00	150	0.1333	128.61
  1/1/2003	12.00		0.1667		1/1/2003	12.00	10150	0.1667	8,578.91

16.15.4 Example V – Premature Liquidation

The Loan details are as follows:

• Loan Amount – USD 10000
• Tenor - 12 Months
• Start Date – 1st Jan 2002
• End Date – 1st Jan 2002
• Prepayment Date – 1st March 2002
• Nominal Rate – 12.0%
• Number of Periods in a Year – 12
• Sub-period - 30 days
• TEAC = 12.2003939724179%

  Date (Outflow)	Period	Outflow Amount	Sub Periods Fraction	VP Outflow	Date (Receipts)	Periods	Total Pay	Sub Period Fraction	Discounted Value of Receipts
  1/1/2002	0	10000	0.0000	10000	1/1/2002	0	$0.00	0.0000	0.00
  1/31/2002	1.00		0.0333		1/31/2002	1.00	96.67	0.0000	95.70
  3/1/2002	1.00		0.9667		3/1/2002	1.00	10103.33	0.9667	9,904.30
  4/1/2002	3.00		0.0000		4/1/2002	3.00	0	0.0000	0.00
  5/1/2002	4.00		0.0000		5/1/2002	4.00	0	0.0000	0.00
  6/1/2002	5.00		0.0333		6/1/2002	5.00	0	0.0333	0.00
  7/1/2002	6.00		0.0333		7/1/2002	6.00	0	0.0333	0.00
  8/1/2002	7.00		0.0667		8/1/2002	7.00	0	0.0667	0.00
  9/1/2002	8.00		0.1000		9/1/2002	8.00	0	0.1000	0.00
  10/1/2002	9.00		0.1000		10/1/2002	9.00	0	0.1000	0.00
  11/1/2002	10.00		0.1333		11/1/2002	10.00	0	0.1333	0.00
  12/1/2002	11.00		0.1333		12/1/2002	11.00	0	0.1333	0.00
  1/1/2003	12.00		0.1667		1/1/2003	12.00	0	0.1667	0.00