Settlement report | Cybersource field? | Cybersource report |
---|---|---|
payment_service_transaction_reconciliation_id | Yes | Request.MerchantReferenceNumber (only when ics_bill in Application.Name ) |
transaction_id | No | - |
payment_service_transaction_id | Yes | Request.LinkToRequest |
payment_service_id | No | - |
payment_service_definition_id | No | - |
payment_service_display_name | No | - |
journal_type | Yes | Check journal type mapping table below |
raw_journal_type | Yes | Application.Name |
payment_service_transaction_created_at | Yes | Always null |
posted_at | Yes | Batch.BatchDate |
processing_amount_plain | Yes | PaymentData.RequestedAmount |
processing_currency | Yes | PaymentData.RequestedAmountCurrencyCode |
exchange_rate | Yes | Always null |
currency | Yes | PaymentData.CurrencyCode |
gross_credit_plain | Yes | PaymentData.Amount (only when ics_bill in Application.Name ) |
net_credit_plain | Yes | PaymentData.Amount (only when ics_bill in Application.Name ) |
gross_debit_plain | Yes | (-1) * PaymentData.Amount (only when ics_credit in Application.Name ) |
net_debit_plain | Yes | (-1) * PaymentData.Amount (only when ics_credit in Application.Name ) |
fee_markup_plain | Yes | Always null |
fee_interchange_plain | Yes | Always null |
fee_scheme_plain | Yes | Always null |
fee_total_plain | Yes | Always 0 |
method | Yes | Standardized value of raw_method |
raw_method | Yes | PaymentMethod.Type |
scheme | Yes | Standardized value of raw_scheme |
raw_scheme | Yes | PaymentMethod.CardType |
batch | Yes | Batch.BatchID |
report_id | No | - |
raw_report_ids | No | - |
ingested_at | No | - |
description | Yes | Always null |
transaction_external_identifier | No | - |
transaction_metadata | No | - |
report_payment_service_id | No | - |
report_payment_service_definition_id | No | - |
report_payment_service_display_name | No | - |
posted_at
value provided is only an approximation, as the Payment Batch Detail
report does not report this value.Cybersource raw journal type | Our journal type |
---|---|
ics_bill | settlement |
ics_credit | refund |