Skip to content

Latest commit

 

History

History
79 lines (75 loc) · 1.98 KB

report_csv.md

File metadata and controls

79 lines (75 loc) · 1.98 KB

CSV report

A report file is generated daily with all successful transactions from the day before. The file has no header row and the fields are separated with semicolon.

Please note that the number of fields in the file depends on how many variables you provide in your request. Be aware that if you create batches with different number of variables, this report will contain lines with various number of variables.

Field number Name Description
1 batchReference Input parameter
2 clientReference Input parameter
3 msisdn Input parameter
4 amount Input parameter
5 currency Input parameter
6 paymentProvider Which payment provider the end user selected (Current values are Direct Pay, PCGW, Mobile Banking, SMS, Apple Pay, PayPal)
7 paymentSucceeded Will always be 1 as only successful transactions are included in this report.
8 timestamp Timestamp when the payment was made
9 externalReference A reference from the payment provider.
10, 12, etc (even numbers) Name of a variable Input parameter
11, 13, etc (odd numbers) Value of corresponding variable in previous field Input parameter

Example of a file

1234-1;100001;+4799999990;162800;NOK;PCGW;1;29.05.2017 10:20:20;755;firstname;Steven;amount;1.628,00
1234-1;100002;+4799999991;51300;NOK;PCGW;1;29.05.2017 09:08:43;754;firstname;Jamie;amount;513,00
1234-1;100003;+4799999992;103700;NOK;PCGW;1;29.05.2017 07:50:51;753;firstname;Kenny;amount;1.037,00
1234-1;100004;+4799999993;123200;NOK;PCGW;1;29.05.2017 17:33:36;756;firstname;Robbie;amount;1.232,00