Proposal summary
This proposal describes the HSBC PH EFT Template creation with NetSuite. The Payment file templates are used to generate EFT in different formats.
Requirement
QIMA would like to create 3 EFT File Formats for HSBC PH templates in XML format in NetSuite.
Our Solution
The requirement can be achieved by creating Three 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 templates. 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
PP XML v3 – Cross Border BASIC.xml
<?xml version=”1.0″ encoding=”utf-8″?>
<Document 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,format: 2020-06-25T09:07:22</CreDtTm>
<Authstn>
<Cd>Static Value: “ILEV”</Cd>
</Authstn>
<NbOfTxs>Total number of payments</NbOfTxs>
<CtrlSum>Total amount of payments,Total amount of payments, format eg:0.01</CtrlSum>
<InitgPty>
<Nm>Company bank details.Statement Name</Nm>
<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>
<NbOfTxs>Total number of payments</NbOfTxs>
<CtrlSum>Total amount of payments, format eg:0.01</CtrlSum>
<PmtTpInf>
<InstrPrty>Static Value: “HIGH”</InstrPrty>
<SvcLvl>
<Cd>Static Value: “URGP”</Cd>
</SvcLvl>
</PmtTpInf>
<ReqdExctnDt>Payment file administration. PROCESS DATE, format :2020-06-25</ReqdExctnDt>
<Dbtr>
<Nm>company bank.Statement Name</Nm>
<PstlAdr>
<StrtNm>company bank.Street</StrtNm>
<PstCd>company bank.zip</PstCd>
<TwnNm>company bank.Town</TwnNm>
<CtrySubDvsn>company bank.state code</CtrySubDvsn>
<Ctry>company bank.countrycode</Ctry>
</PstlAdr>
<Id>
<OrgId>
<BICOrBEI>company bank.BIC</BICOrBEI>
</OrgId>
</Id>
</Dbtr>
<DbtrAcct>
<Id>
<Othr>
<Id>company bank.account number</Id>
</Othr>
</Id>
<Ccy>company bank.currency</Ccy>
</DbtrAcct>
<DbtrAgt>
<FinInstnId>
<BIC>company bank.BIC</BIC>
<Nm>company bank. Bank name</Nm>
<PstlAdr>
<Ctry>company bank.countrycode</Ctry>
</PstlAdr>
</FinInstnId>
</DbtrAgt>
<CdtTrfTxInf>
<PmtId>
<InstrId>Payment file administration.ID</InstrId>
<EndToEndId>Payment.tranID</EndToEndId>
</PmtId>
<Amt>
<InstdAmt Ccy=”USD”>payment.amount</InstdAmt>
</Amt>
<ChrgBr>Static value: “DEBT”</ChrgBr>
<CdtrAgt>
<FinInstnId>
<BIC>Entity bank details.BIC</BIC>
<Nm>Entity bank details.Bank name</Nm>
<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>
<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>
<Nm>Entity bank details.name</Nm>
</CdtrAcct>
<RgltryRptg>
<Dtls>
<Inf>reference note of bill</Inf>
</Dtls>
</RgltryRptg>
</CdtTrfTxInf>
</PmtInf>
</CstmrCdtTrfInitn>
</Document>
PP XML v3 – PESONet BASIC.xml
<?xml version=”1.0″ encoding=”utf-8″?>
<Document 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,format: 2020-12-12T09:07:22</CreDtTm>
<Authstn>
<Cd>Static Value: “ILEV”</Cd>
</Authstn>
<NbOfTxs>Total number of payments</NbOfTxs>
<CtrlSum>Total amount of payments,Total amount of payments, format eg:0.01</CtrlSum>
<InitgPty>
<Nm>Company bank details.Statement Name</Nm>
<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: “URNS”</Cd>
</SvcLvl>
</PmtTpInf>
<ReqdExctnDt>Payment file administration. PROCESS DATE, format :2020-12-12</ReqdExctnDt>
<Dbtr>
<Nm>company bank.Statement Name</Nm>
<PstlAdr>
<Ctry>company bank.countrycode</Ctry>
</PstlAdr>
<Id>
<OrgId>
<BICOrBEI>company bank.BIC</BICOrBEI>
</OrgId>
</Id>
</Dbtr>
<DbtrAcct>
<Id>
<Othr>
<Id>company bank.account number</Id>
</Othr>
</Id>
<Ccy>company bank.currency</Ccy>
</DbtrAcct>
<DbtrAgt>
<FinInstnId>
<BIC>company bank.BIC</BIC>
<Nm>company bank. Bank name</Nm>
<PstlAdr>
<Ctry>company bank.countrycode</Ctry>
</PstlAdr>
</FinInstnId>
</DbtrAgt>
<CdtTrfTxInf>
<PmtId>
<InstrId>Payment file administration.ID</InstrId>
<EndToEndId>Payment.tranID</EndToEndId>
</PmtId>
<Amt>
<InstdAmt Ccy=”PHP”>payment.amount,format:0.01</InstdAmt>
</Amt>
<ChrgBr>Static value: “DEBT”</ChrgBr>
<CdtrAgt>
<FinInstnId>
<BIC>Entity bank details.BIC</BIC>
<Nm>Entity bank details.Bank name</Nm>
<PstlAdr>
<Ctry>Entity bank details. country code</Ctry>
</PstlAdr>
</FinInstnId>
</CdtrAgt>
<Cdtr>
<Nm>Entity bank details.name</Nm>
<PstlAdr>
<Ctry>Entity bank details.country code</Ctry>
</PstlAdr>
</Cdtr>
<CdtrAcct>
<Id>
<Othr>
<Id>Entity bank details.account number</Id>
</Othr>
</Id>
<Nm>Entity bank details.name</Nm>
</CdtrAcct>
<RgltryRptg>
<Dtls>
<Inf>reference note of bill</Inf>
</Dtls>
</RgltryRptg>
</CdtTrfTxInf>
</PmtInf>
</CstmrCdtTrfInitn>
</Document>
PP XML v3 – USD Local Transfer.xml
<?xml version=”1.0″ encoding=”utf-8″?>
<Document 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,format: 2018-12-12T09:07:22</CreDtTm>
<Authstn>
<Cd>Static Value: “ILEV”</Cd>
</Authstn>
<NbOfTxs>Total number of payments</NbOfTxs>
<CtrlSum>Total amount of payments,Total amount of payments, format eg:0.01</CtrlSum>
<InitgPty>
<Nm>Company bank details.Statement Name</Nm>
<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: “URNS”</Cd>
</SvcLvl>
</PmtTpInf>
<ReqdExctnDt>Payment file administration. PROCESS DATE, format :2018-12-12</ReqdExctnDt>
<Dbtr>
<Nm>company bank.Statement Name</Nm>
<PstlAdr>
<Ctry>company bank.countrycode</Ctry>
</PstlAdr>
<Id>
<OrgId>
<BICOrBEI>company bank.BIC</BICOrBEI>
</OrgId>
</Id>
</Dbtr>
<DbtrAcct>
<Id>
<Othr>
<Id>company bank.account number</Id>
</Othr>
</Id>
<Ccy>company bank.currency</Ccy>
</DbtrAcct>
<DbtrAgt>
<FinInstnId>
<BIC>company bank.BIC</BIC>
<Nm>company bank. Bank name</Nm>
<PstlAdr>
<Ctry>company bank.countrycode</Ctry>
</PstlAdr>
</FinInstnId>
</DbtrAgt>
<CdtTrfTxInf>
<PmtId>
<InstrId>Payment file administration.ID</InstrId>
<EndToEndId>Payment.tranID</EndToEndId>
</PmtId>
<Amt>
<InstdAmt Ccy=”USD”>payment.amount,format:0.01</InstdAmt>
</Amt>
<ChrgBr>Static value: “DEBT”</ChrgBr>
<CdtrAgt>
<FinInstnId>
<BIC>Entity bank details.BIC</BIC>
<Nm>Entity bank details.Bank name</Nm>
<PstlAdr>
<Ctry>Entity bank details. country code</Ctry>
</PstlAdr>
</FinInstnId>
</CdtrAgt>
<Cdtr>
<Nm>Entity bank details.name</Nm>
<PstlAdr>
<Ctry>Entity bank details.country code</Ctry>
</PstlAdr>
</Cdtr>
<CdtrAcct>
<Id>
<Othr>
<Id>Entity bank details.account number</Id>
</Othr>
</Id>
<Nm>Entity bank details.name</Nm>
</CdtrAcct>
<RgltryRptg>
<Dtls>
<Inf>reference note of bill</Inf>
</Dtls>
</RgltryRptg>
</CdtTrfTxInf>
</PmtInf>
</CstmrCdtTrfInitn>
</Document>
Assumptions
- We have added the field mapping of 3 Payment file templates and highlighted the corresponding NetSuite fields in Green color. We will create the 3 payment templates for all currencies in XML format based on field mapping.
- We will not provide any validation for fields.
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 sample 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.
Note
- The templates PP XML v3 – PESONet BASIC.xml and PP XML v3 – USD Local Transfer.xml are almost same. So, we are creating 2 different templates for PP XML v3 – PESONet BASIC.xml and PP XML v3 – USD by reusing first template.