Column Descriptions -
2.181. CSTB_EVENT
Description - This table has all the contract events
Primary Key and Foreign Keys -
Column Descriptions -
Primary Key AMOUNT_TAG,MODULE,BASIS_TAG,PRODUCT
COLUMN DATA TYPE DESCRIPTION
AMOUNT_TAG VARCHAR2(25) Indicates the Amount Tag
MODULE VARCHAR2(2) Indicates the Module
BASIS_TAG VARCHAR2(25) Indicates the Basis tag.
PRODUCT VARCHAR2(4) Indicates the Product
OPERATION1 VARCHAR2(10) Indicates the Operation1
OPERATION2 VARCHAR2(10) Indicates the Operation2
VALUE1 VARCHAR2(100) Indicates value1
VALUE2 VARCHAR2(100) Indicates value2
VALUE3 VARCHAR2(100) Indicates value3
Primary Key AMOUNT_TAG,MODULE,PRODUCT
COLUMN DATA TYPE DESCRIPTION
AMOUNT_TAG VARCHAR2(25) Indicates the amount tag
DESCR VARCHAR2(105) This field specfies the description for rule.This field is updated from interest statement maintenance screen.This field consists of 35 alphanumeric characters.
MODULE VARCHAR2(2) Indicates the module
PRODUCT VARCHAR2(4) This field specifies the product for which the contract is created. this is a unique code to identify the product.
this field consist of 4 alphanumeric characters, one of the characters of the code should necessarily be a letter of the english alphabet.
TAG_CCY VARCHAR2(3) This is the currency in which the component is represented. The currency of the account involved in the debit and credit legs of the accounting entry for the transaction amount will be displayed. Its consist of 3 alphanumeric characters. This field is updates from loan contract settlement screen.
Primary Key MODULE,EVENT_CODE
COLUMN DATA TYPE DESCRIPTION
MODULE VARCHAR2(2) This field specifies the Module for the specific record which is getting maintained. The available Modules are pre-shipped with Flexcube installation.
For example-
MM indicates the Money Market module, SM the Security Management module of Core, etc. This field Consist of 2 Alphanumeric Characters and it contains factory shipped date. EVENT_CODE VARCHAR2(4) This field indicates an event in the life of a transaction. This is the
Transaction Code involved in the accounting entry. This field consists of 4 alphanumeric characters.
This field contains factory shipped date.
EVENT_DESCR VARCHAR2(105) It is the description of the event occurred in the contract. This field consist of 105 alphanumeric character and this field contains factory shipped date.
SYS_INITIATED CHAR(1) It Indicates whether the particular event is to be system initiated or manually initiated.
"Y" to indicate that it is system initiated "N" to indicate that it is manually initiated. This field contains factory shipped date.
USER_INITIATED CHAR(1) If it is specified in the field that the particular event is to be system initiated then the entry in this field will be "N", else indicate that we need to initiate the event manually by selecting "Y" in this field. This field contains factory shipped date.
ACCT_ENTRY_DEFN CHAR(1) This field indicates that whether accounting entries should be passed for the particular event or not.
"Y" for Accounting entries should be pass for the particular event else `"N".
This field contains factory shipped date.
ADVICES_DEFN CHAR(1) It Indicates whether advices should be generated for the particular event.
"Y" to indicate that advices should be generated for the event "N" to indicate that advices should not be generated for the event This field contains factory shipped date.
INTEREST_ALLOWED CHAR(1) It Indicates whether interest is applicable for the particular event. "Y" to indicate that interest is applicable for the particular event, else "N".
This field contains factory shipped date.
COMMISSION_ALLOWED CHAR(1) It Indicates whether commission should be calculated for the particular event.
"Y" to indicate that commission should be collected for the particular amount ,else "N".
This field contains factory shipped date.
CHARGE_ALLOWED CHAR(1) It Indicates whether charges should be collected for the particular event.
"Y" to indicate that charges should be collected for the particular amount, else "N".
This field contains factory shipped date.
TAX_ALLOWED CHAR(1) It Indicates whether application of Tax is allowed or not allowed for the particular event.
"Y" to indicate that Tax is allowed for the particular event "N" to indicate that Tax is not allowed for the particular event. This field contains factory shipped date.
OCCURRENCE_ONCE_IN _A_LIFETIME
CHAR(1) It Indicates whether the particular event will occur only once in the lifetime of the contract. For instance an event like Book (Booking of a contract) will occur only once in its lifetime.
"Y" to Indicate that the event occurs only once in the lifetime of the contract else indicate "N". This field contains factory shipped date. ALLOW_ASSOCIATION_O
F_INTEREST
CHAR(1) The interest component maintained in the ICCF Product screen will not be associated with the event.
"Y" to indicate that you want to associate the interest component with the event, else "N".
This field contains factory shipped date. ALLOW_ASSOCIATION_O
F_CHARGE
CHAR(1) The charge component maintained in the ICCF Product screen will not be associated with the event.
"Y" to indicate that you want to associate the charge component with the event, else "N"
This field contains factory shipped date. ALLOW_APPLICATION_O
F_CHARGE
CHAR(1) It Indicate whether application of charge is to be according to what has been defined in the ICCF Product screen. You can opt to stop the application of the charge component for the event you are defining by selecting NO.
"Y" to indicate that application of charge is necessary "N" to indicate that application of charge is necessary This field contain factory shipped date.
ALLOW_LIQUIDATION_O F_CHARGE
CHAR(1) The interest component maintained in the ICCF Product screen will not be associated with the event.
"Y" to indicate that you want to associate the interest component with the event, else "N".
This field contains factory shipped date. ALLOW_ASSOCIATION_O
F_TRAN_TAX
CHAR(1) The interest component maintained in the ICCF Product screen will not be associated with the event.
"Y" to indicate that you want to associate the interest component with the event, else "N".
This field contains factory shipped date. ALLOW_APPLICATION_O
F_TRAN_TAX
CHAR(1) Indicate whether transaction tax should be applied for the particular event.
"`Y" to indicate that transaction tax should be applied for the event "N" to indicate that transaction tax should not be applied for the event
This field contain factory shipped date. ALLOW_LIQUIDATION_O
F_TRAN_TAX
CHAR(1) The interest component maintained in the ICCF Product screen will not be associated with the event.
"Y" to indicate that you want to associate the interest component with the event, else "N".