Proposal Summary
This proposal summarizes the functionality for creating ACH file templates for Royal Bank of Canada.
Requirement
Consule solutions wants to create an ACH file template for Royal Bank of Canada.
Deliverables
• We will create ACH file template for Royal Bank of Canada.
• We will use the CPA-005 File format for this template.
FIELD MAPPING
CPA 005
| Position | Field | NetSuite field | Field validation |
| 1 | Record Type | Static value “A” | |
| 2-10 | Record Count | Record count increment by 1 | |
| 11-20 | Client Number | 10 digit client number as follows: 6 digit client number assigned by RBC Royal Bank & 4 digit Operating subsidiary number assigned by the client or 0000. | |
| 21-24 | File Creation Number | Calculation based on sequence id | Max 4 digits |
| 25-30 | File Creation Date | Today’s Date(MM/DD/YYYY) | |
| 31-35 | Royal Bank Processing Centre | CompanyBank details.processor code | Max 5 digits |
| 36-55 | Reserved | Leave Blank | |
| 56-58 | Destination Currency Code Identifier | “USD” = if destination currency is US Dollars. OR “CAD” = if destination currency is CAD Dollars If “Blank”= defaults to to the Currency of Service. | |
| 59-1464 | Filler | Leave Blank |
| Position | Field | NetSuite field | Field validation |
| 01-01 | Record Type | Static value “C” | |
| 02-10 | Record Count | Recordcount increment by 1 | |
| 11-20 | Customer Number | Company bank details.issuer number | |
| 21-24 | File Creation Number | Calculation based on sequence id | |
| 25-27 | Transaction Type | Three digit transaction code as defined by the CPA. If no transaction code is entered, it will default to the transaction code on the profile. | |
| 28-37 | Amount | Payment.amount | |
| 38-43 | Payment Date | Payment file administration. Process date | |
| 44-52 | CAD Financial Institution and Branch Transit # | Company bank details.transit number | |
| 53-64 | Account Number | Entity Bank details.account number | |
| 65-86 | Reserved | Blank spaces | |
| 87-89 | Reserved | Blank spaces | |
| 90-104 | Client Short Name | Company bank details. Statement name | |
| 105-134 | Customer Name | Legal name of the Receiver of the transaction | |
| 135-164 | Client Name | Client Long Name. Legal name of the Originator of the transaction. | |
| 165-174 | Client Number | company bank details.issuer number | |
| 175-193 | Customer Number | Vendor or customer.internalid | |
| 194-202 | Reserved | Zero fill | |
| 203-214 | Reserved | Blank | |
| 215-229 | Client Sundry Information | Payment.tranid | |
| 230- 264 | Reserved | Blank |
| Position | Fields | NetSuite Fields | Validation |
| 1 | Record Type | Static vale ”Z” | |
| 2-10 | Record count | Record count increment by 1 | |
| 11-20 | Client Number | company bank details.issuer number | |
| 21-24 | File Creation Number | Calculation based on sequence id | |
| 25-38 | Reserved | Zero Fill | |
| 39-46 | Reserved | Zero Fill | |
| 47-60 | Total Amount of Credit Payment Transactions | Total payment amount | |
| 61-68 | Total Number of Credit Payment Transactions | Total payment count | |
| 69-1464 | Filler | Zero Fill |
Assumptions
• The output file format will be text and all characters in the text file will be capital letters
• We will restrict Special characters in NetSuite fields
• J&J will not create the actual company bank details and vendor bank details in this scope.Consule solutions has to create company bank details and vendor bank details with Actual details.
• J&J created the field mapping on assumption based on sample file. If the bank rejects this template due to incorrect field mapping after the development, J&J might have to revise the template.