3.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.

Table 3-1 Supported Files and Fields

File Fields
Cashflow Code file
  • CASHFLOW_TYPE SOURCE_APPLICATION
  • CODE
  • CHANNEL
  • DESCRIPTION
  • CORPORATE_ID
  • PARE
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
  • CUSTOMER_REF_NO
  • 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
Specify User ID and Password, and login to Home screen.
  1. On Home screen, click File Management. Under File Management, click File Upload.
    The File Upload screen displays.
  2. 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.
  3. In the Enter Source Code field, specify the source code of the application to associate the file records to.
  4. 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.