Search...
Log inGet started
Airwallex logo
Home
Core API
Payments
Transactional FX
Payouts
Issuing
Back to home
OverviewChoose your payments solutionGet started with payments
Online payments
Invoice integrations
Manage payments
Place a hold on a payment methodCancellationsRefundsDisputes
Risk managementReporting
Payment activity export
Settlement reportPayments rounding logic
Payment acceptance rate

Payment activity export

The payment activity export allows you to view itemized transactions alongside financial information and other payment details for your analysis and reconciliation based on the original transaction date.

The payment activity export can be accessed via your web app. To download, select the appropriate date range and click the Export button on the top right. Upon clicking the Export button, you can customize the data columns you wish to obtain.

Do note that there is a maximum limit of 10,000 transactions in a single download.

transactionlist

FIELD NAMEDESCRIPTION
Time zoneTime zone defined in Coordinated Universal Time (UTC)
Payment created timeTime at which the payment intent was created
Payment IDUnique identifier for the payment intent
Payment attempt IDUnique identifier for payment attempts associated with this payment. There could be multiple IDs if there were multiple attempts
Order IDUnique identifier from your order system tagged to a payment intent
Request IDUnique identifier from your system tagged to your request to Airwallex
DescriptorDescriptor that you have specified for display to the shopper
Payment statusStatus of the payment intent
Payment currencyThree-letter ISO code for the currency of the payment
Payment amountAmount of the payment
Refunded amountAmount of the total successful refunds made
Latest payment attempt statusThe status of the latest payment attempt
Authorisation response codeAuthorisation response code from payment method provider. For more information, refer to https://www.airwallex.com/docs/paymentsresponse-codesissuer-response-codes
Authorisation code descriptionAuthorisation code description from payment method provider. For more information, refer to https://www.airwallex.com/docs/paymentsresponse-codesissuer-response-codes
Acquirer reference numberA unique number assigned to a card transaction as it moves through the payment flow. It can be used by banks to help trace a transaction if it appears to be missing. An ARN will be available for Visa and Mastercard charges
Payment methodThe payment method used by the shopper for this transaction
Payer or billing nameName of the person or entity associated with the payment method
Consent IDUnique identifier of a payment consent used for this transaction, if applicable
Risk scoreScore assigned by risk engine
Rule actionAction assigned by risk engine
Rule reasonReasons applicable for the rule action, if available
CVC checkResults of card verification code checks. https://www.airwallex.com/docs/paymentsresponse-codescvc2cvv2-codes
AVS checkResults of address verification service checks, if applicable https://www.airwallex.com/docs/paymentsresponse-codesavs-codes
3DS triggeredWhether 3DS has been triggered for this transaction https://www.airwallex.com/docs/paymentsnative-api3d-secure-authentication
3DS enrolledWhether card supports 3DS
3DS frictionlessWhether this transaction has undergone step up authentication requiring additional input from the shopper
3DS authenticatedWhether this transaction has been successfully authenticated via 3DS
Liability shiftWhether there was a liability shift to your customer
Payment method number or IDUnique identifier for the payment method used, such as card BIN and last 4 digits or Alipay and WeChat Pay IDs
Payment method typeIf applicable, type to help you identify the payment method, for example, a card brand when ApplePay or GooglePay are used: Visa, Mastercard, etc. or product type for Klarna: Pay Now, Pay Later, etc.
Card issuing or shopper countryCountry the shopper’s payment method was issued in, if applicable
Issuing or originating bankName of financial institution that the shopper’s payment method was issued from, if applicable
Card fundingCard funding type, such as credit, debit, prepaid, if applicable
Card categoryCard category, such as consumer, commercial, if applicable
Card expirationMonth and year of the card expiration
Charge typeWhether the transaction is a recurring or-one off payment
Billing phone numberPhone number of the payment method holder associated with this transaction, if applicable
Billing addressFirst line of the address of the payment method holder associated with this transaction, if applicable
Billing cityCity of the payment method holder associated with this transaction, if applicable
Billing stateState of the payment method holder associated with this transaction, if applicable
Billing postal codePostal code of the payment method holder associated with this transaction, if applicable
Billing countryCountry of the payment method holder associated with this transaction, if applicable
Customer IDUnique identifier of the customer in Airwallex, if applicable
Merchant customer IDUnique identifier of the customer provided by you, if applicable
Customer nameName of the customer, if applicable
Customer phonePhone number of the customer, if applicable
Customer emailEmail of the customer, if applicable
Shipping nameName on the shipping address associated with this transaction, if applicable
Shipping phone numberShipping phone number associated with this transaction, if applicable
Shipping methodShipping method associated with this transaction, if applicable
Shipping addressFirst line of the shipping address associated with this transaction, if applicable
Shipping cityCity of the shipping address associated with this transaction, if applicable
Shipping stateState of the shipping address associated with this transaction, if applicable
Shipping postal codePostal code of the shipping address associated with this transaction, if applicable
Shipping countryCountry of the shipping address associated with this transaction, if applicable
Channel typeFor Wechat, identifies the channel the shopper paid from
Operating systemOperating system of the shopper, if available
BrowserBrowser of the shopper, if available
DeviceDevice of the shopper, if available
Device IP addressIP address of the shopper, if available
Payment link referenceReference for the payment link input by your customer, if applicable
Payment link messageMessage for the payment link input by your customer, if applicable
Original payment currencyThree-letter ISO code for the currency of the original payment amount submitted by you on the payment intent
Original payment amountAmount of the payment submitted by you on the payment intent
Product descriptionProduct description provided by you, if applicable
Product nameProduct name provided by you, if applicable
Product quantityProduct quantity provided by you, if applicable
Product unit priceProduct unit price provided by you, if applicable
MetadataMetadata associated with the payment intent provided by you, if applicable