| Subject: | New Bank File Format for BRED Bank Online Banking Portal |
| Summary: | New bank file format is required for BRED bank. This file will be used to upload banking transactions to the BRED bank portal. The old formats are used to process transactions manually. Case Reference: L12738
BRED bank customers are required to send a file to the bank containing pay information in the format shown in Table 1 below.
Part A - COLUMN DEFINITIONS and LinkSOFT Mapping - BIC - Required field. Provide BIC code of the receiving bank. BIC code is expected in capital, otherwise it fails. (LinkSOFT: Menu: "Company Administration ~> Bank". Detail: "Number Mapping". "Mapping Number" field.)
- Employee Name - Required field. Provide employee name not exceeding 35 characters. (LinkSOFT: Trim Left to 35 Characters)
- Employee Id - Required field. Provide employee Id of the receiver, not exceeding 25 digits. (LinkSOFT: EmployeeCode)
- Account Number - Required field. Provide account number of the receiver, not exceeding 16 digits. (LinkSOFT: Menu: Employee Profile ~> Employee Pay Setup". Detail: Direct Debit. "Account No" field.)
- Amount - Required field. Transfer amount to employee. Please follow the following numbering format, e.g., 1000.00
- Remarks - Optional field. Remarks will appear in your account. The length of Remarks should not exceed 140 characters.
- Narration - Optional field. This is for your own information. The length of Naration should not exceed 140 characters.
Table 1 - BRED Bank - CSV File format
BIC,Employee Name,Employee Id,Account Number,Amount,Remarks,Narration BREDFJFJ,van votha,1,81954,10.11,Test 1,Narration1 BREDFJFJ,kong bunsoeun,2,81955,20.22,Test 2,Narration2 Part B - BIC Codes - BOSPFJFJ- BSP FINANCIAL GROUP
- ANZBFJFX- ANZ BANK
- HFCLFJFJ- HFC BANK
- WPACFJFX- WESTPAC BANKING CORP
- BREDFJFJ- BRED BANK
- BARBFJFJ- BANK OF BARODA
Table 2 - Bank Output File Design
|
| Audit Notes: | Edited by sanjay on 06/03/24 18:52. Edited by sanjay on 06/03/24 18:50. Edited by sanjay on 06/03/24 11:47. Edited by sanjay on 06/03/24 11:46. Edited by vineshwar on 29/02/24 13:51. |
| 29 Feb 2024 | 01:50PM Comment 1 by Vineshwar Prasad (Edge Business Solutions) Assigned To: Sanjay (Link Technologies) Followup Date: 06-03-2024 05:45 PM Time Taken: 1.00 Notes: ETC extended from: 29/02/2024 to 06/03/2024 |
| Notes;- This is a New Bank File Format that will be used to directly upload on the BRED Bank Banking Portal
- Do Not Remove the Old Format as this will still be used to submit Salary Files to the Bank for it to be manually processed by the Banks
|
|
| 06 Mar 2024 | 11:21AM Comment 2 by Sanjay (Link Technologies) Case L13007 added to project 15.20 |
| 06 Mar 2024 | 11:37AM Comment 3 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 08-03-2024 03:21 PM Time Taken: 6.00 |
| Changed case header to clarify requirements and cleaned up attachments. |
|
| 06 Mar 2024 | 06:13PM Comment 4 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 08-03-2024 03:57 PM Time Taken: 18.00 Notes: ETC extended from: 06/03/2024 to 08/03/2024 |
| PART A - Development work for this case has been completed. 1. The change will be available in version: 15.20 2. The following changes were made (Include Database object names, Program classes, and any other relevant information): - Added Bred Bank Online Portal format as an option in the Bank File Integration
3. Affected Areas: - Bank File Integration
4. The issue was caused by: - New Feature
5. Other Relevant Notes:
6. Next Step (Review and System Test (Developer) -> UAT (Quality) -> Documentation): UAT
|
|
| 07 Mar 2024 | 03:14PM Comment 5 by Sanjay (Link Technologies) Assigned To: Sanjay (Link Technologies) Followup Date: 13-03-2024 07:13 PM Time Taken: 3.00 Notes: Edited by sanjay on 07/03/24 15:14. |
| *** Skype Notes ***
Sitla, 1:36 PM Waiting bank confirmation
Sitla, 1:51 PM Bank confirmed on file format, successfully uploaded to their portal. |
|