Proposal summary
This proposal describes the HSBC Mexican EFT Template creation with NetSuite. The Payment file templates are used to generate EFT in different formats.
Requirement
QIMA would like to create 2 EFT File Formats for HSBC Mexican bank in TXT format in NetSuite.
Our Solution
The requirement can be achieved by creating two EFT template using the TXT format for all currencies based on the client’s requirement. Also need to create company bank details and entity bank details for the new Payment file templates for the testing purpose. Then that templates needs to be tested by creating the vendor bills for the test vendor and need to do the bill processing for verification.
Field Mapping
TEF Interbank Payments
| Index | Field | NetSuite Field | Validation |
| 1 to 10 | Charge Account | company bank details. Account number | Maximum length – 10 |
| 11 to 18 | Value Date | Payment file administrator. TIMESTAMP +1 (DDMMYYYY) | |
| 19 to 36 | Ordering Party Tax ID | Company bank details. Tax id | Minimum length – 1 Maximum length -18 |
| 37 to 39 | Currency | Company bank details. currency | |
| 40 to 79 | Batch Number | Payment file administration. Refernce note | |
| 1 to 3 | Account Type | Vendor bank details. Account type (CLA / TDD / CTA) | Minimum length – 3 Maximum length -3 |
| 4 to 6 | Bank Code | Vendor bank details. Bank code | Maximum length – 3 |
| 7 to 26 | Beneficiary Account | Vendor bank details. Account number If Account type is CLA, append bank code in beginning of account number. | Maximum length – 20 |
| 27 to 66 | Beneficiary Name | Vendor’s name | |
| 67 to 80 | Amount | Payment amount | |
| 81 to 87 | Numeric Reference | Vendor bank details. Numeric reference | Maximum length – 7 |
| 88 to 127 | Alphanumeric Reference | Vendor bank details. Alphanumeric reference | Maximum length – 40 |
| 128 to 145 | Beneficiary RFC* | Vendor bank details. RFC | Minimum length – 1 Maximum length – 18 |
| 146 to 159 | IVA* | Vendor bank details. IVA | Maximum length – 14 |
Interbank Payment SPEI
| Cell | Field | NetSuite Field | Validation |
| 1 to 10 | Ordering Account | Company bank details. account number | Maximum length – 10 |
| 11 to 28 | Ordering Taxpayer ID (RFC) | Company bank details. RFC | Minimum length – 1 Maximum length – 18 |
| 29 to 48 | Beneficiary Account | Vendor bank details. Account number If Account type is CLABE, append bank code in beginning of account number. | |
| 49 to 51 | Beneficiary Bank | Vendor bank details. Bank code | Maximum length – 3 minimum length – 3 |
| 52 to 85 | Beneficiary Name | Vendor’s name | |
| 86 to 103 | Amount | Payment amount | |
| 104 to 110 | Numeric Reference | Vendor bank details. Numeric reference | Maximum length – 7 |
| 111 to 150 | Payment Concept | Vendor bank details. Payment concept | Maximum length – 40 |
| 151 to 166 | Ordering Reference | Company bank details. reference | Maximum length – 16 |
Assumptions
- We have added the field mapping of both Payment file templates. We will create the two payment templates for all currencies in TXT format based on field mapping.
- We will not provide any validation for fields other than the mentioned validations.
Risk
- J&J will not create the actual company bank details and vendor bank details in this scope. QIMA has to create company bank details and vendor bank details with Actual details.
- J&J created the field mapping on assumption based on bank file. If the bank reject this template due to incorrect field mapping after the development, J&J might have to revise the template. That is not considered in this scope. So that additional effort will be billed as support hours.