1.3.1.1 Amount Tag Tab

This topic describes the systematic instructions to process the amount tag details.

1. On Treasury Role and Head Maintenance screen, the Amount Tag tab is displayed by default when you process the screen and specify the fields.
   For more information on fields, refer to the field description table.

   Table 1-11 Treasury Role and Head Maintenance - Field Description

   Field	Description
   Amount Tag	Specify the amount tag.
   Description	Enter the brief description for amount tag.
   Charge	Indicate whether the amount tag pertains to a charge or not by choosing one of the following options: Yes No
   Accounting	Indicate whether accounting entries are required or not by choosing one of the following options: Yes No
   Transaction Tax	Indicate whether transaction tax is applicable or not by choosing one of the following options: Yes No
   Local Currency	Indicate the local currency preference by choosing one of the following options: Average Equivalent
   Local Currency Eq. Tag	Specify the amount tag for the local currency equivalent amount.

2. Click Derivation button to derive the amount and currency for the amount tag.
   Derivation Rule Details screen displays.

   Figure 1-10 Derivation Rule Details

   

   Here you can specify derivation logic for the following:

   • Amount Rule
   • Currency Rule

   Table 1-12 Derivation Rule Details - Field Description

   Field	Description
   Module Code	The system displays module code here.
   Amount Tag	The system displays the amount tag here.
   Amount Rule Type	Check this box if the amount has to be derived based on a specified condition. The amount for a particular tag can be derived based on a condition.

   Derivation Amount Rule: If you have checked against the option Amount Rule Type, the system will derive the amount for the amount tag that is being defined. You can use the following as variables while creating the derivation rule:

   • Account Level UDF
   • SDE

   You can use any of the following SDEs:

   • CUSTOMER_CATEGORY - Category of the customer of the loan
   • CUSTOMER_ID - Customer ID
   • LOAN_STATUS - Status
   • ACCOUNT_CCY - Loan account's currency
   • TODAY - Today
   • NEXT_WORKDAY - Date of next workday
   • PAYMENT_VALUE_DATE - Payment value date
   • LAST_PAYMENT_DATE - Last payment date for the customer
   • DAYS_FOR_NEXT_PMNT - Days for next payment
   • AMOUNT_DISBURSED - Current disbursement amount
   • COMMITMENT_UTILIZED - Utilized part of commitment
   • EMI_AMOUNT - EMI AMOUNT
   • NET_PRINCIPAL - Non-funded amount for which the loan is applied
   • TOTAL_DUE_AMOUNT - Sum of all the Outstanding Balances for the Customer
   • LAST_PAYMENT_AMOUNT - Last Payment Amount for the Customer
   • CURRENT_PAYMENT_AMOUNT - Current Amount which is Due
   • PAID_INTEREST_AMOUNT - Total Interest Amount Paid
   • INTEREST_ACCRUED_AMOUNT - Sum of all the Accrued Amounts for Interest
   • AMOUNT_NOT_DISBURSED - Amount Not Disbursed
   • COMMITMENT_UNUTILIZED - Unutilized part of commitment
   • TOTAL_PRINCIPAL - Amount for which the loan is applied
   • TENOR - Duration for which the loan is applied
   • LOAN_PRINCIPAL - Principal
   • PRINCIPAL - Amount disbursed
   • PRINCIPAL_OUTSTAND – Principal amount outstanding
   • OVERDUE_MONTHS - OverDue Months
   • TOTAL_OVERDUE_AMOUNT - Total Overdue amount for all components
   • INS_TENOR - INSTALLMENT TENOR
   • NO_OF_RPMNT_SCHS - Number of Non-Moratorium repayment schedules
   • MORA_OUTSTANDING - Moratorium Outstanding Amount
   • COMPOUND_VALUE - Amount Compounded
   • TOTAL_MORA_AMOUNT - Total Moratorium Amount
   • _OVR_DAYS - <Component> overdue days
   • _EXPECTED - <Component> expected amount
   • _OUTSTAND - <Component> outstanding amount
   • _CCY - <Component> currency
   • _OVERDUE - <Component> overdue amount
   • _FN_NO_REPAY_SCH - <Component> number of schedules for a component if periodic
   • _NET_PRINCIPAL - <Component> amount financed
   • PROJECTED_AMOUNT - Projected Amount
   • UIDB_DIFFERENTIAL - UIDB Differential
   • BALLOON_AMOUNT - Balloon Amount
   • RESIDUAL_AMOUNT - Residual Amount
   • CAPITAL_AMOUNT - Capital Amount
   • CLOSURE_AMOUNT - Closure Amount
   • NET_MORTGAGE - Net Mortgage Amount.

   Assume that you have an account-level UDF called ‘OSCHGRATE’.

   The derivation rule using the SDEs and UDF may be given as under.

   DECLARE

   l_osprin_amt number;

   rate number;

   BEGIN

   L_osprin_amt:=(@SDE_VAL#PRINCIPAL_OUTSTAND);

   rate: =(@UDF_UD#OSCHGRATE);

   l_amount:=rate * l_osprin_amt;

   END

   Table 1-13 Derivation Rule Details - Field Description

   Field	Description
   Amount Rule Error Description	Enter a brief description about amount rule error that should be displayed in case the derivation fails.

   Currency Rule Derivation: The currency can either be derived from the existing account currency or can be maintained as a UDF field in the account or it can be hard-coded in the Currency Rule Definition screen.

   Table 1-14 Derivation Rule Details - Field Description

   Field	Description
   Currency Rule Type	Check this box if the currency for a particular amount tag has to be derived based on the derivation rule.
   Derivation Currency Rule	Specify the rule based on which the system should derive the currency for the amount tag. You need to assign a value to ‘L_CCY’. For instance, the rule may be given as under. BEGIN SELECT currency INTO l_ccy FROM cltb_account_master WHERE account_number = p_acc_no AND branch_code=p_branch; END;
   Currency Rule Error Description	Enter a brief description about currency rule error that should be displayed in case the derivation fails.

3. Click the Exit button to close the screen.