Feature #157
closed
Added by Chooi-Mey over 12 years ago.
Updated over 11 years ago.
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: ASCII
Files
- 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.
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
[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.
- % Done changed from 0 to 100
- Resolution set to Fixed
- Status changed from Feedback to Closed
Also available in: Atom
PDF