8.1 Upload Files

This topic describes the systematic instruction to upload a file for entering the instrument collection data into the 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 8-1 Instrument Collection File - Supported Fields

Field Column 1 Field Column 2 Field Column 3 Field Column 4
Indicator Corporate UDF7 Instrument Number
Branch Division Code UDF8 Instrument Date
Deposit Channel Credit Account Number UDF9 Instrument Type
Courier Code Account Type UDF10 Instrument Amount
Consignment No Deposit Slip Date MISC 1 Routing Number
Consignment Date Pick Up Location MISC 2 Drawee Bank
Consignment Receipt Time Pick Up Point MISC 3 Drawee Branch
Financial Posting Pick Up Date TS MISC 4 Drawer Name
Processing Date UDF 1 MISC 5 Drawer A/c No
Acknowledgment Receipt Number UDF 2 MISC 6 Drawer Account Name
Bag Weight UDF 3 MISC 7 Credit Account No
Initiator Reference Number UDF 4 MISC 8 Division Code
Batch Currency UDF 5 MISC 9 Instrument Status
Deposit Slip number UDF 6 MISC 10 -
  1. On Home screen, click File Management. Under File Management, click File Upload.
    The File Upload screen displays.

    Figure 8-1 File Upload


    Description of Figure 8-1 follows
    Description of "Figure 8-1 File Upload"

  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.

    Note:

    Instrument records through file upload are created even if certain mandatory fields are not added in the file while uploading. Whenever such records are edited and saved by the bank user, a validation is performed to ensure that all mandatory fields are updated.

Parent topic: File Management