ECPUser Guide

Download as pdf or txt
Download as pdf or txt
You are on page 1of 31

PB enterprise User Guide

Bulk Payment & Bulk Payroll

PB enterprise
Online Cash Management Service
User Guide

Bulk Payment & Bulk Payroll


(PB ECP)

Version 1.2

Page 1 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

Table of Contents
1. Bulk Payment and Bulk Payroll (also known as PB ECP) ......................................................... 3
1.1. Rules ....................................................................................................................................... 3
1.2. ECP Menu Navigation ............................................................................................................ 3
1.3. Stop Payment Instruction ........................................................................................................ 4
1.4. Standard Processing Fee ......................................................................................................... 4
1.5. ECP Processing Windows and Crediting Times ..................................................................... 4
2. ECP Step by Step Guide ............................................................................................................. 5
2.1. Step 1: Upload the ECP File ................................................................................................... 5
2.2. Step 2: Confirm the Uploaded File ......................................................................................... 6
2.3. Step 3: Submit the Uploaded File ........................................................................................... 7
2.4. Step 4: Maker Checks the ECP File Status ............................................................................. 8
2.5. Step 5 – Submit the Transaction ........................................................................................... 13
2.6. Step 6 – Transaction Approval.............................................................................................. 14
2.7. Step 7 - Print Payment Advice (optional) ............................................................................. 15
2.8. Step 8 – Reports and Beneficiary Email/SMS Notification .................................................. 17
3. Stop Payment ............................................................................................................................ 18
3.1. Step 1 – Find your Transaction in Transaction Approval Status .......................................... 18
3.2. Step 2 – Click on the Stop Payment button within the Reference No. ................................. 19
3.3. Step 3 – Specify the Reason of Stop Payment and proceed .................................................. 19
3.4. Step 4 – Authorize/approve the stop payment instruction .................................................... 20
4. Bulk Payment/Payroll (ECP) Filenames ................................................................................... 21
4.1. Filenames for Bulk Payroll (ECP Payroll) ............................................................................ 21
4.2 Filenames for Bulk Payment (ECP Payment) ....................................................................... 22
5. Bulk Payment/Payroll (ECP) Excel Format .............................................................................. 23
6. Bulk Payment/Payroll (ECP) Text Format ............................................................................... 25
7. Bulk Payment/Payroll (ECP) Feedback File Format ................................................................ 28
8. PB ECP Beneficiary E-mail Notification Template.................................................................. 31
9. PB ECP Beneficiary SMS Notification Template .................................................................... 31

Page 2 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

1. Bulk Payment and Bulk Payroll (also known as PB


ECP)
1.1. Rules
i. PB ECP (Electronic Credit Payment) is a bulk payment service offered by PB
enterprise to cater for fund transfers made in bulk.

ii. PB enterprise offers two types of bulk services, ECP Payment and ECP Payroll.
o ECP Payroll – Generally used by a company’s Human Resource department
for salary payments. Debiting of funds from the Current Account is in lump
sum.
o ECP Payment – Generally used by a company’s Finance department for
supplier payments. Debiting of funds from the Current Account is by
individual transaction.

iii. Customers may request for different users to have access to ECP Payroll and ECP
Payment. This means that ECP Payroll users are not able to see transactions
performed through ECP Payment and vice versa.

iv. Customers are required to upload a file based on the ECP format through PB
enterprise. Refer to Section 5 onwards for the File Formats.

v. Three methods of payment can be combined in a single file (Intrabank, IBG and
RENTAS).

vi. ECP reports can be downloaded under the “Reports” menu of PB enterprise.

vii. Funds must be made available in the debiting account before the approved
processing window.

1.2. ECP Menu Navigation


There are three menus under the ECP service:

a. ECP Payment/Payroll Upload:


Maker will upload the ECP file using this menu. Be aware that this menu is used
for uploading purposes only. Maker is required to navigate to the “ECP File
Status” menu to confirm that all the records are in order

b. ECP Payment/Payroll Status:


After uploading the file, the Maker is required to view/confirm the status of the
file and decide on the next action to be taken

c. Print Payment Advice:


After the file has been successfully processed, the Maker has an option to
generate a payment advice for their beneficiaries based on the records in the
file. Upon clicking on the request button, the advice will be generated on the
next calendar day in a PDF format to be downloaded. Payment advices expire
after 90 days from the payment date.

Page 3 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

1.3. Stop Payment Instruction


a. Customers may initiate a Stop Payment instruction on an ECP file even after it has
been approved as long as the Stop Payment instruction is approved 30 minutes
before the processing window

b. To access the Stop Payment function, navigate to the Transaction Approval Status
screen, locate your transaction and click on the Stop Payment button.

c. Ensure that the Stop Payment instruction is fully approved within the required time.
If this is not done within the required time, there is no other way for the Bank
to stop your payment

1.4. Standard Processing Fee


Per Transaction (upon successful debiting) Amount (MYR)
Intrabank (within Public Bank) 0.10
Interbank GIRO (IBG)* 0.10
RENTAS* 2.00
Beneficiary SMS Notification (per number keyed in)* 0.20
Email Notification Free
*Charges are applicable for both successful and failed transactions. Service fees for
unsuccessful transactions will not be refunded

1.5. ECP Processing Windows and Crediting Times


Funds Estimated Estimated Stop
PB ECP PB ECP Received By Funds Funds Payment
Processing Processing Beneficiary Received By Received By Instruction
Day Time via Beneficiary Beneficiary Cut-Off
Intrabank via IBG Via Rentas Time
Business Window 1 By 6:00am By 11:00am By 11:30am Must be
Days (5:00am) same day same day same day approved 30
(Mon to Fri) Window 2 By 9:00am By 2:00pm By 11:30am minutes
(8:00am) same day same day same day before the
Window 3 By 12:00pm By 5:00pm By 1:30pm processing
(11:00am) same day same day same day date & time
Window 4 By 3:00pm By 8:20pm By 4:30pm
(2:00pm) same day same day same day
Window 5 By 6:00pm By 11:00pm By 11:30am
(5:00pm) same day same day on next
business day
Non- Window 1 By 6:00am By 11:00am By 11:30am Must be
Business (5:00am) same day on the next on next approved 30
Days (Sat, Window 2 By 9:00am business day business day minutes
Sun & (8:00am) same day before the
Federal Window 3 By 12:00pm processing
Territory (11:00am) same day date & time
Public Window 4 By 3:00pm
Holidays) (2:00pm) same day
Window 5 By 6:00pm
(5:00pm) same day

Page 4 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

2. ECP Step by Step Guide


2.1. Step 1: Upload the ECP File

 Navigation: File Upload > ECP Payment/ECP Payroll > ECP Payment/Payroll
Upload > Initiate

Step Field Explanation


1 From Account Select an account to debit from
2 Select File Select an ECP file to be uploaded
3 Processing Today - Select an ECP processing window.
Window *The processing window will change according to the time of day.
(cut-off time) After 5:00pm daily, only future dated processing windows can be
selected

Future Dated - Select a future dated ECP processing window


*All processing windows are available for future dated files
4 Beneficiary Required - Beneficiary bank will check the ID of the selected
ID Checking account. If the ID stored at the beneficiary bank does not match the
(Intrabank and ID provided in the file, the ID matching will fail and the transaction
IBG) will be marked as rejected due to mismatched ID

Not Required - Beneficiary bank will not check the ID of the selected
account
*ID Checking is mandatory for all RENTAS transactions at all times
even if “Not Required” is selected
5 Payment The payment purpose will be displayed to the approver(s) of the
Purpose transaction and in the Current Account statement
6 Next Upon clicking “Next”, if the general format of the file is invalid, an
error message will be prompted to the Maker indicating the reason
the upload failed. If there are no issues, the screen will navigate to
the Confirmation page

Page 5 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

2.2. Step 2: Confirm the Uploaded File

 Navigation: File Upload > ECP Payment/ECP Payroll > ECP Payment/Payroll
Upload > Initiate > Confirmation

a. If the file uploaded meets the ECP format requirements, the confirmation page will
display the information provided by the customer from the previous step.

b. Click “Back” to change any details or “Submit” to proceed.

Page 6 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

2.3. Step 3: Submit the Uploaded File

 Navigation: File Upload > ECP Payment/ECP Payroll > ECP Payment/Payroll
Upload > Initiate > Confirmation > Acknowledgement

a. The file is accepted by the system for validation therefore, the Status is “Pending
Validation”

b. The Maker is required to view the status of the validation and decide the next
course of action at the “ECP File Status” page.

c. The Maker can also choose to print the page or upload another file

Page 7 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

2.4. Step 4: Maker Checks the ECP File Status


 Navigation: File Upload > ECP Payment/ECP Payroll > ECP File Status

a. The ECP File Status screen will display the status of all the ECP files that have been
uploaded

b. Maker is required to click on the Reference No. to view the file and confirm the details
that they have uploaded before the transaction can be approved.

c. The explanation of the status is as follows:

ECP File Explanation


Status
Pending Maker The file has successfully passed the first round of verification and is
Confirmation pending the Maker to confirm the details and take action on the
transaction
File Validation The file contains errors. There can be two scenarios:
Error i. If the file is not provided in the stipulated format/file is
duplicated the reason will be displayed upfront
ii. If there are no issues with the file, there could be issues with the
records. The Maker is required to click on the Reference No. to
view the details of the file and view the reason of the records that
are causing errors
Expired The file has expired because it has not been fully approved within 14
days from the creation date
Success The file has been successfully processed and the financials have been
debited and credited
Rejected The file has been rejected by one of the approvers
Withdrawn The file has been withdrawn by the Maker
Pending The file has been successfully approved and is pending processing on
Windows Time the selected ECP windows time.

Page 8 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

Example 1: ECP File Status – All records contain errors

a. In this scenario, all the records are invalid. As such, the only option for the Maker is to
take no further action or to Remove File.

b. Remove File is used if the Maker wants to upload the same filename and unique record
id again else, a new filename and unique record ID needs to be provided

c. Maker is able to “Download Error Report” to view the details and explanation of the
records with errors

d. The filename of the PDF file is as follows: VER<Uploaded Filename>.PDF

e. The acronym of VER is Validation Error Report

Page 9 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

Sample of the PB ECP File Validation Error Report

Page 10 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

Example 2: ECP File Status – All records are good

a. In this scenario, all the records are good.

b. As such, there are four options for the Maker:


1. To send the file to the Approver(s) by clicking on “Submit”
2. To remove the file and upload a new file with the same filename and unique record
ID
3. To upload a new file with a different filename and contents and ignore this file
4. To not take any action – If no action is taken on the file, it will be expired within
14 days of creation

Page 11 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

Example 3: ECP File Status – Records are mixed with both valid and invalid results

a. In this scenario, the results are mixed

b. As such, there are four options for the Maker:


1. To send the file to the Approver(s)
2. To remove the file and upload a new file with the same filename
3. To upload a new file with a different filename
4. To not take any action – If no action is taken on the file, it will be expired within
14 days of creation

Page 12 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

2.5. Step 5 – Submit the Transaction

a. After the Maker confirms that they want to submit the file for approval, click on
“Submit” and the Maker will be presented with an acknowledgement page.

b. The approver can then proceed to approve the ECP transaction

Page 13 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

2.6. Step 6 – Transaction Approval

a. Approver is required to navigate to “Transaction Approval” > “Pending Transaction”


and approve the transaction based on their approval matrix

b. There is a special approval rule for PB ECP whereby the file can be approved even after
the selected payment date has lapsed. The system will prompt the user that the payment
date has lapsed and if the user would like to change the payment date to the next
available date. To illustrate this, refer to the screenshots below.

i. Payment Date Lapsed Screen 1: The Effective Date is 03-Jan-2018 but today’s
date is 17-Jan-2018. It is already past the date originally selected by the Maker

ii. Payment Date Lapsed Screen 2: After clicking Approve, the following message
will appear.

Page 14 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

iii. Payment Date Lapsed Screen 3: If the approver clicks on “OK”, notice that the
payment date has changed from 03-Jan-2017 to 17-Jan-2017

2.7. Step 7 - Print Payment Advice (optional)

a. Print Payment Advice will generate a PDF file containing payment advices based on
the file uploaded by the customer upon request

b. For example, if there are 150 transactions contained in the ECP file, a Payment advice
with 150 pages will be generated.

c. Payment advices is only generated for successfully debited transactions. All payment
advices can only be requested/downloaded for up to 90 calendar days from the payment
date. After 90 calendar days, there is no way to retrieve/download any payment
advise.

Page 15 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

d. The payment advice filename is “<Uploaded filename>.PDF”

e. There are 3 statuses for Print Payment Advice:


Status Explanation
Request Payment Advice Click this link to request for a payment advice to be generated on
t+1 calendar day. The status will change to “Payment Advice
Requested”

Eg. Request on 1 January 2018, the status will change to


“Payment Advice Requested”. On 2 January 2018, the status will
change to “Download Payment Advice”
Payment Advice This status is seen after the “Request Payment Advice” button is
Requested clicked. The status will be changed to “Download Payment
Advice” on t+1 calendar day
Download Payment Click this link to download the payment advice in PDF format.
Advice The payment advice filename is “<Uploaded filename>.PDF”

f. Sample of the payment advice PDF file is illustrated below. This example shows that
the payment advice has 6 pages meaning the file contain 6 successful transactions.

Page 16 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

2.8. Step 8 – Reports and Beneficiary Email/SMS Notification

a. Reports will be made available approximately within 30 minutes of the processing


window subject to the Bank’s processing time. The reports can be downloaded from
the Reports screen as illustrated below.

b. The beneficiary email and SMS notification will be sent to the beneficiaries
approximately within 30 minutes after the processing window. The receipt of the email
and SMS is subject to the beneficiary’s network/mobile/internet service provider.

c. The difference between the Status Report and the T+2 status report is that the T+2 status
report will incorporate any IBG rejection items that have been returned into the status
instead of displaying the returned item as “Processed”. T+2 reports are always
generated 2 days after the payment date.

Page 17 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

3. Stop Payment
a. It is possible to stop a file that has already been approved as long as it has not been
processed yet

b. The Stop Payment instruction can only be executed through PB enterprise 30 minutes
before the selected processing window.

c. If the stop payment instruction is received and not fully approved within 30 minutes
before the selected processing window, the transaction will be processed and the stop
payment instruction will be considered as expired. In this scenario, there is no other
way for the Bank to stop your payment

d. The Stop Payment button can be located under the Transaction Approval Status page.
Any role has the function to initiate the Stop Payment instruction.

e. All Stop Payment must be approved by the authorized signatories

3.1. Step 1 – Find your Transaction in Transaction Approval Status


 Navigation: Transaction Approval > Transaction Approval Status > Reference
No of ECP Transaction
a. Locate the approved transaction that you want to stop and click on the reference
no.

Page 18 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

3.2. Step 2 – Click on the Stop Payment button within the Reference No.
a. A pop-up screen will show with the Stop Payment button. If the button is not
displayed, it means that the allowed time to Stop Payment has lapsed.

3.3. Step 3 – Specify the Reason of Stop Payment and proceed


a. The system will prompt the requester to key-in the reason of why the Stop
Payment is performed. After clicking OK, the transaction will be sent to the
approver to be approved.

Page 19 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

3.4. Step 4 – Authorize/approve the stop payment instruction


Authorizer must approve the Stop Payment instruction before the processing window. If
the Stop Payment instruction is Withdrawn or Rejected, the transaction will continue to
be processed as per the initial instruction

Page 20 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

4. Bulk Payment/Payroll (ECP) Filenames


4.1. Filenames for Bulk Payroll (ECP Payroll)

PB enterprise Bulk Payroll (HR) File Name Format Sample File Name
Upload Payroll File (Excel) <10 digit Account No.><PR><DDMMYY><Serial No starting 3111111111PR17111701.xls
with 01>.xls or
or 3111111111PR17111701.xlsx
<10 digit Account No.><PR><DDMMYY><Serial No starting
with 01>.xlsx
*DDMMYY is the actual payment date
Upload Payment File (Text) <10 digit Account No.><PM><DDMMYY><Serial No starting 3111111111PM17111701.txt
with 01>.txt
*DDMMYY is the actual payment date
PB ECP Payroll Status Feedback File (PRSFF) PRSFF<uploaded filename>.txt PRSFF3111111111PR17111701.txt

PB ECP Payroll Status Report (PRSR) PRSR<uploaded filename>.pdf PRSR3111111111PR17111701.pdf


or or
PRSR<uploaded filename>.csv PRSR3111111111PR17111701.csv
Payroll IBG Return Feedback File IBG<uploaded filename>.txt IBG3111111111PR14081701.txt
Payroll IBG Return Report IBR<uploaded filename>.pdf IBR3111111111PR14081701.pdf
or or
IBR<uploaded filename>.csv IBR3111111111PR14081701.csv
PB ECP Payroll Status Report (T+2) PRSR<uploaded filename>T2.pdf PRSR31111111PR14081701T2.pdf
or or
PRSR<uploaded filename>T2.csv PRSR31111111PR14081701T2.csv
or or
PRSR<uploaded filename>T2.txt PRSR31111111PR14081701T2.txt

Page 21 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

4.2 Filenames for Bulk Payment (ECP Payment)

PB enterprise Bulk Payment (non-HR) File Name Format Sample File Name
Upload Payment File (Excel) <10 digit Account No.><PM><DDMMYY><Serial No starting 3111111111PM17111701.xls
with 01>.xls or
or 3111111111PM17111701.xlsx
<10 digit Account No.><PM><DDMMYY><Serial No starting
with 01>.xlsx
*DDMMYY is the actual payment date
Upload Payment File (Text) <10 digit Account No.><PM><DDMMYY><Serial No starting 3111111111PM17111701.txt
with 01>.txt
*DDMMYY is the actual payment date
PB ECP Payment Status Feedback File (PSF) PSF<uploaded filename>.txt PSF3111111111PM17111701.txt
PB ECP Payment Status Report (PSR) PSR<uploaded filename>.pdf PSR3111111111PM17111701.pdf
or or
PSR<uploaded filename>.csv PSR3111111111PM17111701.csv
Payment IBG Return Feedback File (IBG) IBG<uploaded filename>.txt IBG3111111111PM14081701.txt
Payment IBG Return Report (IBR) IBR<uploaded filename>.pdf IBR3111111111PM14081701.pdf
or or
IBR<uploaded filename>.csv IBR3111111111PM14081701.csv
PB ECP Payment Status Report (T+2) PSR<uploaded filename>T2.pdf PSR31111111PR14081701T2.pdf
or or
PSR<uploaded filename>T2.csv PSR31111111PR14081701T2.csv
or or
PSR<uploaded filename>T2.txt PSR31111111PR14081701T2.txt

Page 22 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

5. Bulk Payment/Payroll (ECP) Excel Format


Filename: <10 digit Account No.><PM/PR><DDMMYY><Serial No starting with 01>.xls or .xlsx
PM = ECP Payment
PR = ECP Payroll
DDMMYY = The actual payment date

Page 23 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

Page 24 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

6. Bulk Payment/Payroll (ECP) Text Format


Filename: <10 digit Account No.><PM/PR><DDMMYY><Serial No starting with 01-99 or
001-999>.txt
PM = ECP Payment
PR = ECP Payroll
DDMMYY = The actual payment date
Format & Length: A = Alphabet, N = Numeric, AN=Alphanumeric
M/O: M = Mandatory, O = Optional
Header – 19 bytes
No. Header Field Format & Position M/O Remark
Length

1 Header Identifier A (1) 1 M Default: H


2 Debiting Account No. N (10) 2-11 M Payor Corporation's (10 numeric digit) Debiting Account
Number with PBB, e.g. xxxxxxxxxx
3 Payment Date N (8) 12-19 M YYYYMMDD e.g. 20040910

Detail - 781 bytes


No. Detail Field Format Position M/O Remark

1 Detail Identifier A (1) 1 M Default: D


2 Unique Record ID AN (16) 2-17 M This “Unique Record ID” is a serial number which identifies
a
record which MUST not be reused and should not be
identical
to the previous ID used for the last payment. It is at the
discretion
of the Payor Corporation to provide these numbers for their
own
verification purposes.
3 Payment Type/Mode A (3) 18-20 M PBB: Public Bank Account, IBG: Interbank GIRO, REN:
RENTAS
4 Beneficiary Account N (20) 21-40 M Beneficiary account to be credited
No.
5 Receiving AN (11) 41-51 M The receiving Financial Institution (FI) identification or
Bank/Beneficiary BIC Bank
Code Identifier Code (BIC) where the beneficiary maintains an
account. This information is mandatory for all types of
instrument
used. Example: PBBEMYKL -Public Bank as the Receiving
Financial Institution.
NOTE: Refer to the list in the Bank’s website at
www.pbebank.com > Business Banking > Cash
Management.
6 Beneficiary Name AN (120) 52-171 M Beneficiary Name (No validation)

Page 25 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

7 ID Type A (2) 172-173 O Applicable for Intrabank and IBG:


NI-New IC No.
OI-Old IC No.
BR-Business Registration No.
PL-Police ID.
ML-Military ID.
PP-Passport No.

Applicable for Rentas:


NI-New IC No.
OI-Old IC No.
BR-Business Registration No.
OT-Others (for other types of ID apart from NI, OI and BR
such as police ID, army ID and passport no.)
8 Beneficiary AN (29) 174-202 O Beneficiary ID Number. Can be left blank if not required.
Identification No. RENTAS must always be filled in with value
9 Payment Amount N (16) 203-218 M Amount to be credited. Last two digits represents cents
10 Recipient Reference AN (20) 219-238 M Recipient Reference will be displayed in the sender and
beneficiary's statement
11 Other Payment Details AN (20) 239-258 O Other Payment Details will be displayed in the sender and
beneficiary's statement
12 Email Address 1 AN (70) 259-328 O Send an e-mail notification to beneficiary

13 Email Address 2 AN (70) 329-398 O Send an e-mail notification to beneficiary


14 Mobile Number 1 N (16) 399-414 O Send a SMS notification to beneficiary at RM0.21 per SMS.
SMS will send if any number valid/invalid is keyed in
15 Mobile Number 2 N (16) 415-430 O Send a SMS notification to beneficiary at RM0.21 per SMS.
SMS will send if any number valid/invalid is keyed in
16 Joint Bene Name A (120) 431-550 O For RENTAS with joint account only: Joint beneficiary
name
17 Joint ID Type A (2) 551-552 O For RENTAS with joint account only:
NI-New IC No.
OI-Old IC No.
BR-Business Registration No.
OT-Others (for other types of ID apart from NI, OI and BR
such as
police ID, army ID and passport no.)
18 Joint Bene ID No AN (29) 553-581 O For RENTAS with joint account only: Joint bene ID number
19 E-mail Payment AN (40) 582-621 O Payment description that will appear in the beneficiary e-
Description Line 1 mail notification payment advice and print payment advice
20 E-mail Payment AN (40) 622-661 O Payment description that will appear in the beneficiary e-
Description Line 2 mail notification payment advice and print payment advice
21 E-mail Payment AN (40) 662-701 O Payment description that will appear in the beneficiary e-
Description Line 3 mail notification payment advice and print payment advice
22 E-mail Payment AN (40) 702-741 O Payment description that will appear in the beneficiary e-
Description Line 4 mail notification payment advice and print payment advice
23 E-mail Payment AN (40) 742-781 O Payment description that will appear in the beneficiary e-
Description Line 5 mail notification payment advice and print payment advice

Page 26 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

Footer - 51 bytes
No. Trailer Field Format From M/O Remark
Position

1 Footer Identifier A (1) 1 M Default : F


2 Total Record Count N (10) 2-11 M Total number of records
3 Total Amount N (20) 12-31 M Total amount of all transactions
4 Hash Total** N (20) 32-51 M Total Amount + Total of first 4 digits of all Beneficiary
Account Numbers

Page 27 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

7. Bulk Payment/Payroll (ECP) Feedback File Format


Filename for Bulk Payment:
PSF<10 digit Account No.><PM><DDMMYY>< Serial No starting with 01-99 or 001-
999>.txt
Filename for Bulk Payroll:
PRSFF<10 digit Account No.><PR><DDMMYY>< Serial No starting with 01-99 or 001-
999>.txt
Format & Length: A = Alphabet, N = Numeric, AN=Alphanumeric
M/O: M = Mandatory, O = Optional

Header - 365 bytes


From To
No Header Field Format Length Remark
Position Position
1 Header Identifier A 1 1 1 Default: H
Report Generation
2 N 8 2 9 YYYYMMDD e.g. 20040910
Date
3 Uploaded File AN 23 10 32 Filename of the uploaded file
Display in the Debiting Account
4 Payment Purpose AN 50 33 82 Statement (Lump sum/ Line by
Line). Eg. Salary Apr 2016
5 Uploaded Date N 8 83 90 YYYYMMDD e.g. 20040910
6 Payment Date N 8 91 98 YYYYMMDD e.g. 20040910
Payor Corporation's (10 numeric
Debiting Account
7 N 10 99 108 digit) Debiting Account Number
Number
with PBB, e.g. xxxxx
Debiting Account Payor Corporation's Account
8 AN 40 109 148
Name Name
9 Company ID AN 15 149 163 Payor Corporation's Company ID
Payor Corporation's Company
10 Company Name AN 40 164 203
Name
Total Successful
11 N 6 204 209 Total Successful Records
Records
Total Successful
12 N 18 210 227 Total Successful Amount
Amount
Total Rejected
13 N 6 228 233 Total Rejected Records
Records
Total Rejected
14 N 18 234 251 Total Rejected Amount
Amount
Total Processed - Total Processed Records for
15 N 6 252 257
Intrabank Intrabank
Service Fee –
16 N 12 258 269 Service Fee for Intrabank
Intrabank
SMS Fee –
17 N 8 270 277 SMS Fee for Intrabank
Intrabank

Page 28 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

18
Total Fee –
N 12 278 289 Total Fee for Intrabank
Intrabank
Total Processed -
19 N 6 290 295 Total Processed Records for IBG
IBG
20 Service Fee – IBG N 12 296 307 Service Fee for IBG
21 SMS Fee – IBG N 8 308 315 SMS Fee for IBG
22 Total Fee – IBG N 12 316 327 Total Fee for IBG
Total Processed - Total Processed Records for
23 N 6 328 333
RENTAS RENTAS
Service Fee –
24 N 12 334 345 Service Fee for RENTAS
RENTAS
SMS Fee –
25 N 8 346 353 SMS Fee for RENTAS
RENTAS
Total Fee –
26 N 12 354 365 Total Fee for RENTAS
RENTAS

Detail - 300 bytes


From To
No Detail Field Format Length Remark
Position Position
1 Detail Identifier A 1 1 1 Default: D
2 Unique Record ID AN 16 2 17 Unique record ID of the payment
3 Payment Type A 3 18 20 PBB/IBG/REN
Bene Account
4 N 20 21 40 Beneficiary Account Number
Number
Bene Bank BIC
5 AN 11 41 51 The bene bank BIC Code
Code
6 Bene Name AN 120 52 171 Beneficiary Name
7 Bene ID AN 29 172 200 Beneficiary ID
Paid amount with (last 2 digits are
8 Amount N 18 201 218
decimals)
Recipient The value keyed in by the Payor
9 AN 20 219 238
Reference Corporation
Other Payment The value keyed in by the Payor
10 AN 20 239 258
Details Corporation
Status of the payment
11 Status N 2 259 260 01 - Successful
02 - Failed
The rejected reason for the
12 Error Reason AN 40 261 300
“Failed” payment

Footer - 51 bytes
From To
No Trailer Field Format Length Remark
Position Position
1 Footer Identifier A 1 1 1 Default : F
Total Record
2 N 10 2 11 Total number of records
Count

Page 29 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

3 Total Amount N 20 12 31 Total amount of all transactions


Total Amount + Total of first 4
4 Hash Total** N 20 32 51 digits of all Beneficiary Account
Numbers

Page 30 of 31
PB enterprise User Guide
Bulk Payment & Bulk Payroll

8. PB ECP Beneficiary E-mail Notification Template

9. PB ECP Beneficiary SMS Notification Template

Page 31 of 31

You might also like