B.2 Amount Tags

The amount tags listed below are hard-coded in Oracle Banking Treasury Management.

Table B-3 Event Tables

Field Description

CURR_FV

Current Face Value

SEC_DEAL_AMOUNT

Securities Deal Amount

DEAL_DISCNT_AMT

Securities Deal Discount Amount

DEAL_NOMINALAMT

Securities Deal Nominal Amount

DEAL_PREMIUMAMT

Securities Deal Premium Amount

FWD_DEAL_LOSS

Securities Forward Loss

FWD_DEAL_PROFIT

Securities Forward Profit

SEC_ADJDEAL_AMT

Securities Adjusted Deal Amount

SEC_DEAL_AMOUNT

Securities Deal Amount

TBD_WHT_SELL

T Bill Discount Tax - Sell

ACCRUED_RDPREM

Accrued Redemption Premium Amount

CSH_DVDEND

Cash Dividend Amount

CSH_DVDEND_EDIS

Cash Dividend Expense for DIBR

CSH_DVDEND_EINI

Cash Dividend Expense for INIT

CSH_DVDEND_ELIQ

Cash Dividend Expense for LIQD

CSH_DVDEND_ICOL

Cash Dividend Income for COLL

CSH_DVDEND_IINI

Cash Dividend Income for INIT

CSH_DVDEND_ILIQ

Cash Dividend Income for LIQD

DEAL_DISCNT_AMT

Securities Deal Discount Amount

DEAL_NOMINALAMT

Securities Deal Nominal Amount

DEAL_PREMIUMAMT

Securities Deal Premium Amount

FWD_DEALEXP_ACR

Sec. Forward Deal Expense Accr Amt

FWD_DEALINC_ACR

Sec. Forward Deal Income Accr Amt

FWD_DEAL_LOSS

Securities Forward Deal Loss Amount

FWD_DEAL_PROFIT

Securities Forward Deal Profit Amt

HLDG_LO_MTM_EXP

Sec. Long Holdings MTM Reval Expense

HLDG_LO_MTM_INC

Sec. Long Holdings MTM Reval Income

HLDG_MTM_EXP

Sec. Net Holdings MTM Reval Expense

HLDG_MTM_INC

Sec. Net Holdings MTM Reval Income

HLDG_RL_MTM_EXP

Sec. Long Holdings MTM Realized Reval Expense

HLDG_RL_MTM_INC

Sec. Long Holdings MTM Realized Reval Income

HLDG_RS_MTM_EXP

Sec. Short Holdings MTM Realized Reval Expense

HLDG_RS_MTM_INC

Sec. Short Holdings MTM Realized Reval Income

HLDG_R_MTM_EXP

Sec. Net Holdings MTM Realized Reval Expense

HLDG_R_MTM_INC

Sec. Net Holdings MTM Realized Reval Income

HLDG_SH_MTM_EXP

Sec. Short Holdings MTM Reval Expense

HLDG_SH_MTM_INC

Sec. Short Holdings MTM Reval Income

LOCOM_REVAL_EXP

Sec. Positions LOCOM Reval Expense

LOCOM_RREVL_EXP

Sec. Positions LOCOM Realized Reval Expense

LOCOM_REVAL_INC

Profit on LOCOM revaluation if LOCOM basis is ‘Acquisition Cost’

MTM_EXP

Sec. Positions MTM Reval Expense

MTM_INC

Sec. Positions MTM Reval Income

RDMPTN_PREM_AMT

Redemption Premium Amount

REALIZED_LOSS

Securities Realized Trading Loss

REALIZED_PROFIT

Securities Realized Trading Profit

REAL_MTM_EXP

Sec. Positions MTM Realized Reval Expense

REAL_MTM_INC

Sec. Positions MTM Realized Reval Income

RGHT_INTR_VALUE

Rights Intrinsic Value

SEC_ADJDEAL_AMT

Securities Adjusted Deal Amount

SEC_CASH_DIVDND

Securities Cash Dividend Amount

SEC_COST_AMOUNT

Sec. True Asset Cost Amount

SEC_DEAL_AMOUNT

Securities Deal Amount

SEC_DISC_ACCR

Sec. Discount Earned Accrual Amount

SEC_PREM_ACCR

Sec. Premium Paid Accrual Amount

SEC_RDPREM_ACCR

Sec. Redemption Premium Accrual Amt

SEC_REVL_LOSS

Securities Revaluation Loss Amount

SEC_REVL_PROFIT

Securities Revaluation Profit Amt

SEC_RRVL_LOSS

Sec. Revaluation Reversal Loss Amt

SEC_RRVL_PROFIT

Sec. Revaluation Profit Reversal Amt

STK_TO_CSH

Stock To Cash Amount

STK_TO_CSH_EDIS

Stock To Cash Expense for DIBR

STK_TO_CSH_EINI

Stock To Cash Expense for INIT

STK_TO_CSH_ELIQ

Stock To Cash Expense for LIQD

STK_TO_CSH_ICOL

Stock To Cash Income for COLL

STK_TO_CSH_IINI

Stock To Cash Income for INIT

STK_TO_CSH_ILIQ

Stock To Cash Income for LIQD

TBD_WHT_ACCRA

T Bill Discount Tax - Arrears Accrued

TBD_WHT_ACCRD

T Bill Discount Tax - Advance Accrued

TBD_WHT_ADV

T Bill Discount Tax - Paid in Advance

TBD_WHT_PAY

T Bill Discount Tax - Payable

TBD_WHT_SELL

T Bill Discount Tax - Sell

TBD_WHT_UNACCRB

T Bill Disc. Tax-Unaccrued-Sell Disc > Buy Disc

TBD_WHT_UNACCRS

T Bill Disc. Tax-Unaccrued-Sell Disc <= Buy Disc

UNACCRD_DISCNT

Unaccrued Discount Amount

UNACCRD_PREMIUM

Unaccrued Premium Amount

UNSD_BY_MTM_EXP

Unstld Buy Deals MTM Reval Expense

UNSD_BY_MTM_INC

Unstld Buy Deals MTM Reval Income

UNSD_MTM_EXP

Securities Un utilized Deals MTM Revaluation Expense

UNSD_MTM_INC

Securities Unutilized Deals MTM Revaluation Income

UNSD_R_MTM_EXP

Securities Un utilized Deals MTM Realized Reval Expense

UNSD_R_MTM_INC

Securities Un utilized Deals MTM Realized Reval Income

UNSD_SE_MTM_EXP

Un utilized Sell Deals MTM Revaluation Expense

UNSD_SE_MTM_INC

Un utilized Sell Deals MTM Revaluation Income

UNSR_BY_MTM_EXP

Un utilized Buy Deals MTM Realized Revaluation Expense

UNSR_BY_MTM_INC

Un utilized Buy Deals MTM Realized Revaluation Income

UNSR_SE_MTM_EXP

Un utilized Sell Deals MTM Realized Revaluation Expense

UNSR_SE_MTM_INC

Un utilized Sell Deals MTM Realized Revaluation Income

WARR_INTR_VALUE

Warrants Intrinsic Value

INTCOMP_PUCMA

This Amount tag represents the value of the Bought Interest if any (at the time of Purchase) for the sold securities. If there were more than one purchase, this tag will be a sum of all the bought interest in FIFO order. During sale these tags have value only if the sold units are bought in the current coupon period

TOTALINT_TIAC

This amount tag represents the total interest accrued for the eligible units (total interest - Bought interest).

SEC_PREM_TOTALACCR

This amount tag represents the total Premium accrued for the Sold units

SEC_DISC_TOTALACCR

This amount tag represents the total Discount accrued for the Sold units

SEC_BRIDGE_TFR

This amount tag can be used to move the balance between the bridge-buy and bridge-sell GL’s, (if different GL’s are used for Bridge-buy and bridge-sell). This amount tag will only be populated for the sell leg in the case of BBBS and CBCS kind of deals.

SEC_PREM_ACCR

Premium Paid Accrual Amount

SEC_PREM_ACCR_I

Income on Premium Paid accrual

SEC_PREM_ACCR_E

Expense on Premium Paid accrual

SEC_INTADJ_ACCR

Interest Adjustment Accrual Amount

SEC_DISC_ACCR

Discount Earned Accrual Amount

SEC_DISC_ACCR_I

Income on Discount Earned Accrual

SEC_DISC_ACCR_E

Expense on Discount Earned Accrual

ACCRUED_INT_ADJ

Accrued Interest Adjustment Amount

BROK_DISC

Brokerage Discount Amount

BROK_PREM

Brokerage Premium Amount

DR_CHG_DISC

Consolidated Debit charges for the deal

CR_CHG_PREM

Consolidated Credit charges for the deal