Previous Next JavaScript must be enabled to correctly display this content

## 6.1 Upload Files

This topic describes the systematic instruction to upload a file for auto-processing the cashflow code/transaction data into system.

The Upload Files screen enables the user to upload files for auto-processing the cashflow code/transaction data into system. The uploaded files are not processed until it is approved. The file can contain data records of cashflow codes and cashflow transactions etc. The file format accepted by the system includes “.csv” files.

Note:

All transactions which are marked as Deleted ('D') will be purged at a pre defined frequency thus reducing volume in Cashflow transaction table. These transactions are available in Deleted status for over a month.

Table 6-1 Supported Files and Fields

File | Fields
--- | ---
Cashflow Code file | CASHFLOW_TYPE SOURCE_APPLICATION CODE CHANNEL DESCRIPTION CORPORATE_ID PARENT_ID
Cashflow Transaction file | EXTERNAL_REFERENCE_NO CASHFLOW_INDICATOR CORPORATE_ID CODE DESCRIPTION BANK_ACCOUNT_NUMBER VIRTUAL_ACCOUNT_NUMBER AMOUNT ACTUAL_AMOUNT CCY EXPECTED_DATE REVISED_EXPECTED_DATE ACTUAL_DATE CHANNEL APPLICATION_NAME PARTY_NAME PARTY_ID STATUS NARRATION T_UDF_TXT_1 T_UDF_TXT_2 T_UDF_TXT_3 T_UDF_TXT_4 T_UDF_TXT_5 T_UDF_TXT_6 T_UDF_TXT_7 T_UDF_TXT_8 T_UDF_TXT_9 T_UDF_TXT_10 CUSTOMER_REF_NO EXCLUDE_RECON CORPORATE_REF_NO SOURCE DUMMY_BIC_CODE DUMMY_ACC_NO. EXISTING_CODE_YN EXISTING_PARTY_YN RECURRING_COUNTER
Recurring Cashflow Master file | EXTERNAL_REFERENCE_NO CASHFLOW_INDICATOR CORPORATE_ID EXISTING_CODE_YN CODE DESCRIPTION BANK_ACCOUNT_NUMBER VIRTUAL_ACCOUNT_NUMBER AMOUNT CCY CASHFLOW_START_DATE FREQUENCY COUNT_OF_CASHFLOWS CHANNEL APPLICATION_NAME EXISTING_PARTY_YN PARTY_NAME PARTY_ID STATUS NARRATION BIC_CODE OWN_BANK_YN T_UDF_TXT_1 T_UDF_TXT_2 T_UDF_TXT_3 T_UDF_TXT_4 T_UDF_TXT_5 T_UDF_TXT_6 T_UDF_TXT_7 T_UDF_TXT_8 T_UDF_TXT_9 T_UDF_TXT_10 CUSTOMER_REF_NO EXCLUDE_RECON CORPORATE_REF_NO SOURCE BIC_CODE OWN_BANK_YN

1. On Home screen, click File Management. Under File Management, click File Upload.
   The File Upload screen displays.

   Figure 6-1 File Upload

   Description of "Figure 6-1 File Upload"
2. Specify the fields on File Upload screen.

   Note:

   The fields marked as Required are mandatory.
   For more information on fields, refer to the field description table.

   Table 6-2 File Upload - Field Description

   Field | Description
   --- | ---
   Drag and Drop | Click to browse and select the file to be uploaded or drag and drop the file to be uploaded.
   Enter Source Code | Specify the source code or click the Search icon to select a specific source code of the application to upload the file.

3. Drag and drop the file to be uploaded in the highlighted box. or, Click inside the highlighted box to select the file to be uploaded.
4. In the Enter Source Code field, specify the source code of the application to associate the file records to.
5. Click Upload to upload the records from the file. Once the file is uploaded, it cannot be deleted.
   A message appears stating that the file has been uploaded successfully.

Parent topic: File Management