3.9 Cashflow Transaction - Recurring

This topics describes the information to perform the bulk upload for the Cashflow Transaction in Oracle Banking Cash Management.

Table 3-11 Cashflow Transaction File Upload

S.No	Attribute Name	Type	Character	Mandatory/Optional	Description
1	EXTERNAL_REFERENCE_NO	VARCHAR2	50	Y	External Reference Number
2	CASHFLOW_INDICATOR	VARCHAR2	1	Y	Cashflow Indicator
3	CORPORATE_ID	VARCHAR2	50	Y	Corporate Id
4	CODE	VARCHAR2	10	Y	Cashflow Code
5	DESCRIPTION	VARCHAR2	50	N	Description
6	BANK_ACCOUNT_NUMBER	VARCHAR2	50	N	Bank Account Number
7	VIRTUAL_ACCOUNT_NUMBER	VARCHAR2	35	N	Virtual Account Number
8	AMOUNT	NUMBER	(28,4)	Y	Amount
9	CCY	VARCHAR2	3	Y	Ccy
10	CASHFLOW_START_DATE	DATE	YYYY-MM-DD	Y	Cashflow Start Date
11	FREQUENCY	VARCHAR2	50	Y	Frequency
12	COUNT OF CASHFLOWS	NUMBER	(28,4)	Y	Count of Cashflows
13	CHANNEL	VARCHAR2	10	N	Channel
14	APPLICATION_NAME	VARCHAR2	50	Y	Application Name
15	PARTY_NAME	VARCHAR2	50	N	Party Name
16	PARTY_ID	VARCHAR2	30	N	Party Id
17	STATUS	VARCHAR2	30	N	Status
18	NARRATION	VARCHAR2	50	N	Narration
19	T_UDF_TXT_1	VARCHAR2	100	N	User Defined Field 1
20	T_UDF_TXT_2	VARCHAR2	100	N	User Defined Field 2
21	T_UDF_TXT_3	VARCHAR2	100	N	User Defined Field 3
22	T_UDF_TXT_4	VARCHAR2	100	N	User Defined Field 4
23	T_UDF_TXT_5	VARCHAR2	100	N	User Defined Field 5
24	T_UDF_TXT_6	VARCHAR2	100	N	User Defined Field 6
25	T_UDF_TXT_7	VARCHAR2	100	N	User Defined Field 7
26	T_UDF_TXT_8	VARCHAR2	100	N	User Defined Field 8
27	T_UDF_TXT_9	VARCHAR2	100	N	User Defined Field 9
28	T_UDF_TXT_10	VARCHAR2	100	N	User Defined Field 10
29	BIC_CODE	VARCHAR2	15	N	BIC Code
30	OWN_BANK_YN	VARCHAR2	1	N	Own Bank Flag
31	EXISTING_CODE_YN	VARCHAR2	1	N	Existing Code
32	EXISTING_PARTY_YN	VARCHAR2	1	N	Existing Party
33	CUSTOMER_REF_NO	VARCHAR2	50	N	Customer Reference Number