Proposal summary
This proposal describes the HSBC EFT Template creation with Netsuite. The Payment file templates are used to generate EFT in different formats.
Requirement
QIMA would like to create EFT File Formats for HSBC US bank using XML format in Netsuite.
Our Solution
The requirement can be achieved by creating an EFT template using the XML 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 template. Then that template needs to be tested by creating the vendor bills for the test vendor and need to do the bill processing for verification.
Field Mapping
<?xml version=”1.0″ encoding=”utf-8″?>
<Document xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns=”urn:iso:std:iso:20022:tech:xsd:pain.001.001.03″>
<CstmrCdtTrfInitn>
<GrpHdr>
<MsgId>Payment file administration.ID</MsgId>
<CreDtTm>Payment file administration.TIMESTAMP</CreDtTm>
<Authstn>
<Cd>static value “AUTH”</Cd>
</Authstn>
<NbOfTxs>Total number of payments</NbOfTxs>
<InitgPty>
<Id>
<OrgId>
<Othr>
<Id>Company Bank details. HSBC CUSTOMER CONNECT ID</Id>
</Othr>
</OrgId>
</Id>
</InitgPty>
</GrpHdr>
<PmtInf>
<PmtInfId>Payment file administration. REFERENCE NOTE</PmtInfId>
<PmtMtd>Static Value: “TRF”</PmtMtd>
<PmtTpInf>
<SvcLvl>
<Cd>Static value: “NURG”</Cd>
</SvcLvl>
</PmtTpInf>
<ReqdExctnDt>Payment file administration. PROCESS DATE</ReqdExctnDt>
<Dbtr>
<Nm>company bank.LEGAL NAME</Nm>
<PstlAdr>
<StrtNm>company bank.Street</StrtNm>
<BldgNb>company bank.Building number</BldgNb>
<PstCd>company bank.zip</PstCd>
<TwnNm>company bank.Town</TwnNm>
<CtrySubDvsn>company bank.state code</CtrySubDvsn>
<Ctry>company bank.countrycode</Ctry>
</PstlAdr>
</Dbtr>
<DbtrAcct>
<Id>
<Othr>
<Id>company bank details.ACCOUNT NUMBER</Id>
</Othr>
</Id>
</DbtrAcct>
<DbtrAgt>
<FinInstnId>
<BIC>company bank details.BIC</BIC>
<ClrSysMmbId>
<MmbId>company bank details.Issuer Number</MmbId>
</ClrSysMmbId>
<Nm>company bank.bank name</Nm>
<PstlAdr>
<Ctry>company bank.countrycode</Ctry>
</PstlAdr>
</FinInstnId>
</DbtrAgt>
<ChrgBr>Static value: “DEBT”</ChrgBr>
<CdtTrfTxInf>
<PmtId>
<InstrId>Payment file administration.ID</InstrId>
<EndToEndId>Payment.tranID</EndToEndId>
</PmtId>
<Amt>
<InstdAmt Ccy=”USD”>payment.amount</InstdAmt>
</Amt>
<CdtrAgt>
<FinInstnId>
<BIC>Entity bank details.BIC</BIC>
<PstlAdr>
<Ctry>Entity bank details. country code</Ctry>
</PstlAdr>
</FinInstnId>
</CdtrAgt>
<Cdtr>
<Nm>Entity bank details.name</Nm>
<PstlAdr>
<StrtNm>Entity bank details.Street</StrtNm>
<BldgNb>Entity bank details.Building number</BldgNb>
<PstCd>Entity bank details.zip</PstCd>
<TwnNm>Entity bank details.Town</TwnNm>
<CtrySubDvsn>Entity bank details.state code</CtrySubDvsn>
<Ctry>Entity bank details.country code</Ctry>
</PstlAdr>
</Cdtr>
<CdtrAcct>
<Id>
<Othr>
<Id>Entity bank details.Account number</Id>
</Othr>
</Id>
</CdtrAcct>
</CdtTrfTxInf>
</PmtInf>
</CstmrCdtTrfInitn>
</Document>
Validation
| Field | Minimum Length | Maximum Length |
| company bank. Street | 1 | 70 |
| company bank. Building number | 1 | 16 |
| company bank.zip | 1 | 16 |
| company bank. Town | 1 | 35 |
| company bank. state code | 1 | 35 |
| company bank. Country code | 2 | 2 |
| company bank details. ACCOUNT NUMBER | 1 | 34 |
| company bank details. BIC | 6 | |
| company bank details. Issuer Number | 1 | 9 |
| company bank. bank name | 1 | 140 |
| Entity bank details. BIC | 6 | |
| Entity bank details.name | 1 | 140 |
| Entity bank details. Street | 1 | 70 |
| Entity bank details. Building number | 1 | 16 |
| Entity bank details.zip | 1 | 16 |
| Entity bank details. Town | 1 | 35 |
| Entity bank details. state code | 1 | 35 |
| Entity bank details. country code | 2 | 2 |
| Entity bank details. Account number | 1 | 35 |
Assumptions
- We have added the corresponding Netsuite field in green colour. We will create the payment template for all currencies in XML 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.