Previous Next JavaScript must be enabled to correctly display this content

## 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 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