COLUMN DATA TYPE DESCRIPTION
BRANCH_CODE VARCHAR2(3) This field Consist of 3 Alphanumeric Characters.
In FLEXCUBE, each branch of your bank is identified by a unique three-character code called the branch code. This field specifies the record belongs to which branch of the bank. It is the code of the branch for which you are maintaining branch parameters.
MTH_DATE DATE This is the last day of the month of the Application Date
CIF_GROUP_INDICATOR VARCHAR2(1) This indicates AML Tracking is on Customer or Customer Group CIF_GROUP_NO VARCHAR2(9) Depending on AML Tracking this has the Customer No: or
Customer Group Code.
PRODUCT_CAT VARCHAR2(15) Indicates the Product Category
LIMIT_CCY VARCHAR2(3) This is the currency in which the limits will be defined. The limit amount will be taken to be in this currency. For foreign currency deals, the mid-rate will be applied to the transaction amount and will be expressed in the limit currency. You can select a valid currency code from the picklist. However, after the record is authorized, you will not be allowed to make changes. This field is updated from Customer Information Maintenance Screen.
DR_COUNT NUMBER(5) If DR_CR_IND in CSTMS_AML_PRODUCT_CAT_MASTER is,
"E" then DR_COUNT =-1 , "D" then DR_COUNT = 1 , "C" then DR_COUNT = 0
DR_AMOUNT NUMBER(24,3) This field indicates the debit amount involved in transaction.It contains 22 numeric digits and Maximum 3 Decimal Places
CR_COUNT NUMBER(5) If DR_CR_IND in CSTMS_AML_PRODUCT_CAT_MASTER is,
"E" then CR_COUNT =-1 , "C" then CR_COUNT = 1 , "D" then CR_COUNT = 0
CR_AMOUNT NUMBER(24,3) This field indicates the Credit amount involved in transaction.It contains 22 numeric digits and Maximum 3 Decimal Places
Primary Key BRANCH_CODE,BOOK_DATE,CUSTOMER_NO,PRODUCT_CAT,CCY
COLUMN DATA TYPE DESCRIPTION
BRANCH_CODE VARCHAR2(3) This field Consist of 3 Alphanumeric Characters.
In FLEXCUBE, each branch of your bank is identified by a unique three-character code called the branch code. This field specifies the record belongs to which branch of the bank. It is the code of the branch for which you are maintaining branch parameters.
BOOK_DATE DATE This is the transaction date
CUSTOMER_NO VARCHAR2(9) Indicates the Customer No:
PRODUCT_CAT VARCHAR2(15) Indicates the Product Category
CCY VARCHAR2(3) This field specifies the currency of the Debit/Credit Amount
DR_COUNT NUMBER(5) If DR_CR_IND in CSTMS_AML_PRODUCT_CAT_MASTER is,
"E" then DR_COUNT =-1 , "D" then DR_COUNT = 1 , "C" then DR_COUNT = 0
DR_AMOUNT NUMBER(24,3) This field indicates the debit amount involved in transaction.It contains 22 numeric digits and Maximum 3 Decimal Places
CR_COUNT NUMBER(5) If DR_CR_IND in CSTMS_AML_PRODUCT_CAT_MASTER is,
"E" then CR_COUNT =-1 , "C" then CR_COUNT = 1 , "D" then CR_COUNT = 0
CR_AMOUNT NUMBER(24,3) This field indicates the Credit amount involved in transaction.It contains 22 numeric digits and Maximum 3 Decimal Places
Primary Key and Foreign Keys -
Column Descriptions -
Primary Key CONTRACT_REF_NO,COMPONENT,EVENT_SEQ_NO,DUE_DATE
COLUMN DATA TYPE DESCRIPTION
CONTRACT_REF_NO VARCHAR2(16) The Reference Number field is consist of 16 Alphanumeric characters which is used to identifies a loan.It is automatically generated by the system for each loan.This field is a combination of the branch code, the product code, the date on which the loan is booked (in Julian format) and a running serial number for the booking date. The format for the System Reference Number is BBBPPPPYYDDDSSSS
BBB - 3 digit Brach code PPPP - 4 digit Product code YYDDD - 5 digit Date in Julian format
SSSS - 4 digit Serial Number for the Booking date in each product.
EVENT_SEQ_NO NUMBER(4) The events is displayed in the sequence which they take place on the contract. This field Consist of Numeric Value. This column is updated only, when an override is confirmed from the user during the time of authorizing the Contract.
COMPONENT VARCHAR2(15) This field specifies the charge component for the
contract.Component is defined at product level.This field is populated from Product Charge Class Maintenance.
DUE_DATE DATE Indicates the Due Date
AMOUNT_DUE NUMBER(22,3) Indicates the Amount Due
CURRENCY_AMT_DUE VARCHAR2(3) This field specifies the Amount in the Account currency which is used to Pay(settle) by the customer for contract + Component combination. It consist of maximum of 3 alphanumeric character. This is system generated field from contact input and transaction. INFLOW_OUTFLOW CHAR(1) This field specifies whether the amount is coming into the bank or going out of the bank. If "I" (Inflow) then bank will be receiving the amount or if "O" (outflow) then bank has to give the money at a schedule date to the customer .It consist of maximum of 1 alphanumeric character. This is system generated field from contact input and transaction.
BASIS_AMOUNT_TAG VARCHAR2(25) This field indicates the type of amount tag which is defined for the tax details of the product.The amount tags are maintained in the amount tag maintenance screen and it is updated from Tax sub screen of the product maintenance screen.
COMPONENT_TYPE CHAR(1) This field specifies the type of component for the contract,It's system generated field from batch/transaction
P - Principal I - Interest S - Special Interest N - Penalty Interest.
DATE_OF_CHANGE DATE Indicates the date of change
EVENT_CODE VARCHAR2(4) This field indicates an event in the life of a transaction. An Input is the only event in the life of a transaction involving a product specific to the Data Entry module. You can specify the accounting entries and the advices that should be generated for each event. If you select the Accounting Entries option, you should define the Accounting Role, Amount Item, Dr/Cr, Txn. Code and whether the accounting entries should be `Netted'. If you select the Advices option, you should specify the advice to be generated at the time of transaction input. This field Consist of 4 Alphanumeric Characters.
AMOUNT_SETTLED NUMBER(22,3) Indicates the Amount Settled
ADJUSTED_AMOUNT NUMBER(22,3) The Amount Adjusted pertains to contracts with prepayment penalty. It is the adjustment in the schedule amount for schedules already paid at the point of prepayment. It consist of maximum of 22 digit and 3 decimal. This is system generated field from contact input and transaction.
FIXED_AMOUNT_FLAG VARCHAR2(1) This field specifies whether the amount due specified is fixed amount or system generated floating amount.
Y-Fixed amount N-Floating amount.
This is system generated field from LD contact input Screen and LD Batch/Transaction.
UNBILLED_CURRENT NUMBER(22,3) Indicates the Unbilled Current UNBILLED_PREV NUMBER(22,3) Indicates the Unbilled Previous
NOTC_AMOUNT NUMBER(22,3) This field indicates the notice amount which is linked to this particular schedule. This amount will always be amount due for this particular schedule. It consist of maximum of 22 digits and 3 decimals. This is system generated field from contact input and transaction.