Actions
Feature #157
closedColumbia Bank File
Start date:
08/22/2012
Due date:
10/17/2012
% Done:
100%
Estimated time:
Resolution:
Fixed
Description
Columbia Bank file generation:
Requirement: CR details - Refer to src:\ALL CR\Colombia Site\Change Request\CL-CR-0005 - Colombia Bank File.doc
File Format: ASCIIFiles
Updated by Chooi-Mey over 12 years ago
- Status changed from New to Feedback
Feedback on generated test bank file of 22-08-2012:
- Bank File name - change to COYYMMDD.txt
- Report File name - use "CO" as prefix
- [Motion Record] Identification number of the Account Holder (pos 3-13) - right justified with zero pad in front.
- [Motion Record] Beneficiary Account Number (pos 56-72)- Left Justified with space pad at the back.
- [Motion Record] CODE OF COMPENSATION OF THE BANK WHERE THE BENEFICIARY HAS THE ACCOUNT (pos 95-97)- 3 digits, right justified with zero pad in front.
- [Motion Record] VALUE FEE WARRANT (pos 202-219) - Leave it to blank space.
Updated by Chooi-Mey about 12 years ago
CHANGES:
- Group By Ic And Account No
Total remittance amounts for BOs who have more than 1 profit centre shall be paid once in the bank file to reduce bank commission.
- Minimum Checking
Any total remittance amount which is below e$15.00 (net of withholding taxes) shall be thrown into the exception report
Updated by Chooi-Mey about 12 years ago
- File form_2.pdf form_2.pdf added
- Due date changed from 08/30/2012 to 10/17/2012
[CHANGES]
- Remittance amount less than e$15 (net of WHT) shall be thrown into the exception report.
- Calculation of WHT shall be based on e$ and rounded to 2 decimal points.
- Amount in COP shown in the finance reference file and exception report shall have NO decimal point
See attached file for the example.
Updated by Soh Keong about 12 years ago
- % Done changed from 0 to 100
- Resolution set to Fixed
Actions