JSON Report
This page's content:
Schema
A JSON object with the following structure:
- header: An object containing all settlement data summarized;
- payments: A list of Payment objects;
- refunds: A list of Refund objects;
- chargebacks: A list of Chargeback objects;
- chargebacks_reversal: A list of Reversal objects;
- payout_transfers: A list of PayoutTransfer objects.
Example:
{
"header":{
"settlement_code":"14-2008",
"settlement_currency":"EUR",
"merchant_id":20,
"merchant_name":"Demonstration Merchant",
"generate_date":"2015-06-24 14:52:49",
"settlement_date":"2015-06-24",
"transfer_date":"2015-06-24",
"receive_period_from":"2015-06-24",
"receive_period_to":"2015-06-24",
"nr_payments":9,
"nr_refunds":3,
"nr_chargebacks":3,
"gross_total":658.98,
"net_total":294.06,
"chargeback_cost":-219.66,
"refund_cost":-43.93,
"refund_fee":-5.52,
"anticipation_fee":-3.96,
"boleto_fixed_fee":-4.14,
"boleto_variable_fee":-14.27,
"cc_fixed_fee":-8.28,
"cc_variable_fee":-35.16,
"eft_fixed_fee":null,
"eft_variable_fee":null,
"dd_fixed_fee":null,
"dd_variable_fee":null,
"return_mdr":null,
"amount_others":-30
},
"payments":[
{
"hash":"5519551778d407b3a14a10f35de784a5b64d5b624540bbec",
"merchant_payment_code":1427723522,
"order_number":null,
"open_date":"2015-03-30 13:52:22",
"confirm_date":"2015-03-30 13:57:24",
"receive_date":"2015-03-30 13:57:24",
"payment_type":"boleto",
"customer":"JOAO GUILHERME DEL VALLE",
"original_payment_currency":"USD",
"original_payment_amount":100,
"settlement_currency":"EUR",
"fx_rate":1.0861,
"amount_gross":92.07,
"amount_net":84.71,
"fee_percentual":5.98,
"fee_anticipation":0,
"fee_fixed":1.38,
"instalments":1
},
{
"hash":"551955207bad52fd57dc668254d94f7f05e675ddcd2dcd66",
"merchant_payment_code":1427723546,
"order_number":null,
"open_date":"2015-03-30 13:52:31",
"confirm_date":"2015-03-30 13:57:30",
"receive_date":"2015-03-30 13:57:30",
"payment_type":"boleto",
"customer":"JOAO GUILHERME DEL VALLE",
"original_payment_currency":"BRL",
"original_payment_amount":100,
"settlement_currency":"EUR",
"fx_rate":3.6241,
"amount_gross":27.59,
"amount_net":24.42,
"fee_percentual":1.79,
"fee_anticipation":0,
"fee_fixed":1.38,
"instalments":1
},
{
"hash":"5519552611c1ce025172f15504c93195581d3a11afef3e16",
"merchant_payment_code":1427723554,
"order_number":null,
"open_date":"2015-03-30 13:52:38",
"confirm_date":"2015-03-30 13:57:35",
"receive_date":"2015-03-30 13:57:35",
"payment_type":"boleto",
"customer":"JOAO GUILHERME DEL VALLE",
"original_payment_currency":"EUR",
"original_payment_amount":100,
"settlement_currency":"EUR",
"fx_rate":1,
"amount_gross":100,
"amount_net":92.12,
"fee_percentual":6.5,
"fee_anticipation":0,
"fee_fixed":1.38,
"instalments":1
},
{
"hash":"5519558b88b86eb95980ed5baf6d22f983bfd5f42d5065e4",
"merchant_payment_code":1427723650,
"order_number":null,
"open_date":"2015-03-30 13:54:18",
"confirm_date":"2015-03-30 13:57:57",
"receive_date":"2015-04-02 02:59:59",
"payment_type":"visa",
"customer":"JOAO GUILHERME DEL VALLE",
"original_payment_currency":"BRL",
"original_payment_amount":100,
"settlement_currency":"EUR",
"fx_rate":3.6241,
"amount_gross":27.59,
"amount_net":23.75,
"fee_percentual":2.21,
"fee_anticipation":0.25,
"fee_fixed":1.38,
"instalments":1
},
{
"hash":"55195595d8ad9878881465f2e5806eb762840b6de85e93ce",
"merchant_payment_code":1427723665,
"order_number":null,
"open_date":"2015-03-30 13:54:28",
"confirm_date":"2015-03-30 13:58:07",
"receive_date":"2015-04-02 02:59:59",
"payment_type":"visa",
"customer":"JOAO GUILHERME DEL VALLE",
"original_payment_currency":"USD",
"original_payment_amount":100,
"settlement_currency":"EUR",
"fx_rate":1.0861,
"amount_gross":92.07,
"amount_net":82.49,
"fee_percentual":7.37,
"fee_anticipation":0.83,
"fee_fixed":1.38,
"instalments":1
},
{
"hash":"5519559baa67832df5b1f93753df15d4c4ffd7078e3619fa",
"merchant_payment_code":1427723670,
"order_number":null,
"open_date":"2015-03-30 13:54:34",
"confirm_date":"2015-03-30 13:58:15",
"receive_date":"2015-04-02 02:59:59",
"payment_type":"visa",
"customer":"JOAO GUILHERME DEL VALLE",
"original_payment_currency":"EUR",
"original_payment_amount":100,
"settlement_currency":"EUR",
"fx_rate":1,
"amount_gross":100,
"amount_net":89.72,
"fee_percentual":8,
"fee_anticipation":0.9,
"fee_fixed":1.38,
"instalments":1
},
{
"hash":"551955a2371fad7f750d2bf5057be9bcdfb367a383bd07ad",
"merchant_payment_code":1427723676,
"order_number":null,
"open_date":"2015-03-30 13:54:42",
"confirm_date":"2015-03-30 13:58:26",
"receive_date":"2015-04-15 00:00:01",
"payment_type":"visa",
"customer":"JOAO GUILHERME DEL VALLE",
"original_payment_currency":"BRL",
"original_payment_amount":100,
"settlement_currency":"EUR",
"fx_rate":3.6241,
"amount_gross":27.59,
"amount_net":23.75,
"fee_percentual":2.21,
"fee_anticipation":0.25,
"fee_fixed":1.38,
"instalments":1
},
{
"hash":"551955a86e0bddf90455e7abb66fe5eddaaae137faae7e2a",
"merchant_payment_code":1427723684,
"order_number":null,
"open_date":"2015-03-30 13:54:47",
"confirm_date":"2015-03-30 13:58:40",
"receive_date":"2015-04-15 00:00:01",
"payment_type":"visa",
"customer":"JOAO GUILHERME DEL VALLE",
"original_payment_currency":"USD",
"original_payment_amount":100,
"settlement_currency":"EUR",
"fx_rate":1.0861,
"amount_gross":92.07,
"amount_net":82.49,
"fee_percentual":7.37,
"fee_anticipation":0.83,
"fee_fixed":1.38,
"instalments":1
},
{
"hash":"551955ae52776b1055e556b2683b400ac3a4620109a8072b",
"merchant_payment_code":1427723689,
"order_number":null,
"open_date":"2015-03-30 13:54:53",
"confirm_date":"2015-03-30 13:58:47",
"receive_date":"2015-04-15 00:00:01",
"payment_type":"visa",
"customer":"JOAO GUILHERME DEL VALLE",
"original_payment_currency":"EUR",
"original_payment_amount":100,
"settlement_currency":"EUR",
"fx_rate":1,
"amount_gross":100,
"amount_net":89.72,
"fee_percentual":8,
"fee_anticipation":0.9,
"fee_fixed":1.38,
"instalments":1
}
],
"refunds":[
{
"refund_id":4,
"request_date":"2015-03-30 14:06:57",
"confirm_date":"2015-03-30 14:10:15",
"description":"Order did not arrive",
"payment_hash":"5519551778d407b3a14a10f35de784a5b64d5b624540bbec",
"payment_merchant_payment_code":1427723522,
"payment_order_number":null,
"payment_type":"boleto",
"payment_customer":"JOAO GUILHERME DEL VALLE",
"payment_open_date":"2015-03-30 13:52:22",
"payment_confirm_date":"2015-03-30 13:57:24",
"payment_receive_date":"2015-03-30 13:57:24",
"original_refund_currency":"BRL",
"original_refund_amount":52.6,
"settlement_currency":"EUR",
"fx_rate":2.8571,
"amount_gross":18.41,
"amount_net":20.25,
"fee":1.84,
"return_mdr":null
},
{
"refund_id":5,
"request_date":"2015-03-30 14:07:18",
"confirm_date":"2015-03-30 14:09:46",
"description":"Order did not arrive",
"payment_hash":"551955207bad52fd57dc668254d94f7f05e675ddcd2dcd66",
"payment_merchant_payment_code":1427723546,
"payment_order_number":null,
"payment_type":"boleto",
"payment_customer":"JOAO GUILHERME DEL VALLE",
"payment_open_date":"2015-03-30 13:52:31",
"payment_confirm_date":"2015-03-30 13:57:30",
"payment_receive_date":"2015-03-30 13:57:30",
"original_refund_currency":"BRL",
"original_refund_amount":20,
"settlement_currency":"EUR",
"fx_rate":3.6232,
"amount_gross":5.52,
"amount_net":7.36,
"fee":1.84,
"return_mdr":null
},
{
"refund_id":6,
"request_date":"2015-03-30 14:07:28",
"confirm_date":"2015-03-30 14:09:15",
"description":"Order did not arrive",
"payment_hash":"5519552611c1ce025172f15504c93195581d3a11afef3e16",
"payment_merchant_payment_code":1427723554,
"payment_order_number":null,
"payment_type":"boleto",
"payment_customer":"JOAO GUILHERME DEL VALLE",
"payment_open_date":"2015-03-30 13:52:38",
"payment_confirm_date":"2015-03-30 13:57:35",
"payment_receive_date":"2015-03-30 13:57:35",
"original_refund_currency":"BRL",
"original_refund_amount":65.08,
"settlement_currency":"EUR",
"fx_rate":3.254,
"amount_gross":20,
"amount_net":21.84,
"fee":1.84,
"return_mdr":null
}
],
"chargebacks":[
{
"chargeback_id":1,
"chargeback_date":"2015-03-30",
"description":1,
"reason_code":991,
"acquirer":"rede",
"nsu_doc":null,
"payment_hash":"551955a2371fad7f750d2bf5057be9bcdfb367a383bd07ad",
"payment_merchant_payment_code":1427723676,
"payment_order_number":null,
"payment_type":"visa",
"payment_customer":"JOAO GUILHERME DEL VALLE",
"payment_open_date":"2015-03-30 13:54:42",
"payment_confirm_date":"2015-03-30 13:58:26",
"payment_receive_date":"2015-04-15 00:00:01",
"original_payment_currency":"BRL",
"original_payment_amount":100,
"settlement_currency":"EUR",
"fx_rate":3.6245,
"amount_gross":27.59,
"amount_net":27.59
},
{
"chargeback_id":2,
"chargeback_date":"2015-03-30",
"description":1,
"reason_code":992,
"acquirer":"rede",
"nsu_doc":null,
"payment_hash":"551955a86e0bddf90455e7abb66fe5eddaaae137faae7e2a",
"payment_merchant_payment_code":1427723684,
"payment_order_number":null,
"payment_type":"visa",
"payment_customer":"JOAO GUILHERME DEL VALLE",
"payment_open_date":"2015-03-30 13:54:47",
"payment_confirm_date":"2015-03-30 13:58:40",
"payment_receive_date":"2015-04-15 00:00:01",
"original_payment_currency":"USD",
"original_payment_amount":100,
"settlement_currency":"EUR",
"fx_rate":1.0861,
"amount_gross":92.07,
"amount_net":92.07
},
{
"chargeback_id":3,
"chargeback_date":"2015-03-30",
"description":1,
"reason_code":993,
"acquirer":"rede",
"nsu_doc":null,
"payment_hash":"551955ae52776b1055e556b2683b400ac3a4620109a8072b",
"payment_merchant_payment_code":1427723689,
"payment_order_number":null,
"payment_type":"visa",
"payment_customer":"JOAO GUILHERME DEL VALLE",
"payment_open_date":"2015-03-30 13:54:53",
"payment_confirm_date":"2015-03-30 13:58:47",
"payment_receive_date":"2015-04-15 00:00:01",
"original_payment_currency":"EUR",
"original_payment_amount":100,
"settlement_currency":"EUR",
"fx_rate":1,
"amount_gross":100,
"amount_net":100
}
],
"chargebacks_reversal": [
],
"payout_transfers": [
]
}
