This integration is in beta

Below is the mapping of Adyen’s settlement report to Gr4vy’s. This data is pulled from the Adyen settlement_detail_report report.

Gr4vy settlement reportGr4vy field?Adyen report
payment_service_transaction_reconciliation_id NoMerchant Reference or Metadata[gr4vy_tx_sid]
transaction_idYesCalculated from Metadata[gr4vy_tx_sid] or Merchant Reference
payment_service_transaction_idNoPsp Reference
payment_service_idYes-
payment_service_definition_idYes-
payment_service_display_nameYes-
journal_typeNoCheck journal type mapping table below
raw_journal_typeNoType
payment_service_transaction_created_atNoCreation Date with Time Zone UTC offset applied
posted_atNoBooking Date, with Booking Date Time Zone UTC offset applied
processing_amount_plainNoGross Credit (GC) if Settled Type, Gross Debit (GC) if Refunded Type
processing_currencyNoGross Currency
exchange_rateNoExchange Rate
currency NoNet Currency
gross_credit_plainNoGross Credit (GC) * Exchange Rate or Net Credit (NC) for non-customer facing journal types
net_credit_plainNoNet Credit (NC)
gross_debit_plainNoGross Debit (GC) * Exchange Rate or Net Debit (NC) for non-customer facing journal types
net_debit_plainNoNet Debit (NC)
fee_markup_plainNoMarkup (NC)
fee_interchange_plainNoInterchange (NC)
fee_scheme_plainNoScheme Fees (NC)
fee_total_plainNoCommission (NC) or Gross Credit (GC) * Exchange Rate - Net Credit (NC) if Settled Type or Net Debit (NC) - Gross Debit (GC) * Exchange Rate if Refunded Type
methodNoCalculated from Payment Method or Payment Method Variant
raw_methodNoPayment Method or Payment Method Variant depending on which was used to calculate method
schemeNoCalculated from Payment Method or Payment Method Variant
raw_schemeNoPayment Method or Payment Method Variant depending on which was used to calculate scheme
batchNoBatch Number
report_idYes-
raw_report_idsYes-
ingested_atYes-
descriptionNoContains raw Time Zone and Booking Date Time Zone values

Notes:

  • payment_service_transaction_created_at and posted_at have been converted to UTC using Time Zone and Booking Date Time Zone respectively, which are time zone abbreviations. As these time zone abbreviations can be ambiguous, the applied UTC offset to these timestamp columns may not be accurate. Please refer to the description for the raw values used.
  • Non-customer facing journal types may have columns defaulting to 0 or empty strings.

Journal type mapping:

Adyen raw journal typeGr4vy journal type
Chargebackchargeback
ChargebackReversedchargeback_reversal
Refundedrefund
SecondChargebackchargeback
Settledsettlement
any other valueother

Fields marked as Gr4vy field are populated from our internal data and not from the ingested payment service report.

Was this page helpful?

SpecificationBraintree