This integration is currently in beta and the exact mapping of fields might still change.
Below is the mapping of Cybersource’s report to ours. This data is pulled from the Cybersource’s Payment Batch Detail report.
Cybersource’s reconciliation is done via Payment Batch Detail reports which lack fee information and chargeback reporting. It’s therefore not possible to use our settlement report for full end to end reconciliation between Cybersource and your bank statement. It does allow for insights in which transactions have been sent for settlement or refunded.
Settlement reportCybersource field?Cybersource report
payment_service_transaction_reconciliation_idYesRequest.MerchantReferenceNumber (only when ics_bill in Application.Name)
transaction_idNo-
payment_service_transaction_idYesRequest.LinkToRequest
payment_service_idNo-
payment_service_definition_idNo-
payment_service_display_nameNo-
journal_typeYesCheck journal type mapping table below
raw_journal_typeYesApplication.Name
payment_service_transaction_created_atYesAlways null
posted_atYesBatch.BatchDate
processing_amount_plainYesPaymentData.RequestedAmount
processing_currencyYesPaymentData.RequestedAmountCurrencyCode
exchange_rateYesAlways null
currencyYesPaymentData.CurrencyCode
gross_credit_plainYesPaymentData.Amount (only when ics_bill in Application.Name)
net_credit_plainYesPaymentData.Amount (only when ics_bill in Application.Name)
gross_debit_plainYes(-1) * PaymentData.Amount (only when ics_credit in Application.Name)
net_debit_plainYes(-1) * PaymentData.Amount (only when ics_credit in Application.Name)
fee_markup_plainYesAlways null
fee_interchange_plainYesAlways null
fee_scheme_plainYesAlways null
fee_total_plainYesAlways 0
methodYesStandardized value of raw_method
raw_methodYesPaymentMethod.Type
schemeYesStandardized value of raw_scheme
raw_schemeYesPaymentMethod.CardType
batchYesBatch.BatchID
report_idNo-
raw_report_idsNo-
ingested_atNo-
descriptionYesAlways null
transaction_external_identifierNo-
transaction_metadataNo-
report_payment_service_idNo-
report_payment_service_definition_idNo-
report_payment_service_display_nameNo-

Notes

  • The posted_at value provided is only an approximation, as the Payment Batch Detail report does not report this value.

Journal type mapping

Cybersource raw journal typeOur journal type
ics_billsettlement
ics_creditrefund
Fields marked as not a Cybersource field are populated from our internal data and not from the ingested payment service report.