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.
| Field name | Description |
|---|---|
| Account | Account name |
| Time zone | Time zone defined in Coordinated Universal Time (UTC) |
| Payment created time | Time at which the payment intent was created |
| Payment ID | Unique identifier for the payment intent |
| Payment attempt ID | Unique identifier for payment attempts associated with this payment. There could be multiple IDs if there were multiple attempts |
| Order ID | Unique identifier from your order system tagged to a payment intent |
| Request ID | Unique identifier from your system tagged to your request to Airwallex |
| Descriptor | Descriptor that you have specified for display to the shopper |
| Payment status | Status of the payment intent |
| Payment currency | Three-letter ISO code for the currency of the payment |
| Payment amount | Amount of the payment |
| Refunded amount | Amount of the total successful refunds made |
| Latest payment attempt status | The status of the latest payment attempt |
| Authorization response code | Authorisation response code from payment method provider. For more information, refer to https://www.airwallex.com/docs/payments__response-codes__issuer-response-codes |
| Authorization code description | Authorisation code description from payment method provider. For more information, refer to https://www.airwallex.com/docs/payments__response-codes__issuer-response-codes |
| Acquirer reference number | A 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 method | The payment method used by the shopper for this transaction |
| Payer or billing name | Name of the person or entity associated with the payment method |
| Consent ID | Unique identifier of a payment consent used for this transaction, if applicable |
| Risk score | Score assigned by risk engine |
| Rule action | Action assigned by risk engine |
| Rule reason | Reasons applicable for the rule action, if available |
| CVC check | Results of card verification code checks. https://www.airwallex.com/docs/payments__response-codes__cvc2cvv2-codes |
| AVS check | Results of address verification service checks, if applicable https://www.airwallex.com/docs/payments__response-codes__avs-codes |
| 3DS triggered | Whether 3DS has been triggered for this transaction https://www.airwallex.com/docs/payments__native-api__3d-secure-authentication |
| 3DS enrolled | Whether card supports 3DS |
| 3DS frictionless | Whether this transaction has undergone step up authentication requiring additional input from the shopper |
| 3DS authenticated | Whether this transaction has been successfully authenticated via 3DS |
| Payment method number or ID | Unique identifier for the payment method used, such as card BIN and last 4 digits or Alipay and WeChat Pay IDs |
| Payment method type | If applicable, type to help you identify the payment method, for example: Card brand when ApplePay or GooglePay are used: Visa, Mastercard, etc. Klarna: Pay Now, Pay Later, etc. |
| Card issuing or shopper country | Country the shopper’s payment method was issued in, if applicable |
| Issuing or originating bank | Name of financial institution that the shopper’s payment method was issued from, if applicable |
| Card funding | Card funding type, such as credit, debit, prepaid, if applicable |
| Card category | Card category, such as consumer, commercial, if applicable |
| Card expiration | Month and year of the card expiration |
| Charge type | Whether the transaction is a recurring or-one off payment |
| Billing phone number | Phone number of the payment method holder associated with this transaction, if applicable |
| Billing address | First line of the address of the payment method holder associated with this transaction, if applicable |
| Billing city | City of the payment method holder associated with this transaction, if applicable |
| Billing state | State of the payment method holder associated with this transaction, if applicable |
| Billing postal code | Postal code of the payment method holder associated with this transaction, if applicable |
| Billing country | Country of the payment method holder associated with this transaction, if applicable |
| Customer ID | Unique identifier of the customer in Airwallex, if applicable |
| Merchant customer ID | Unique identifier of the customer provided by you, if applicable |
| Customer name | Name of the customer, if applicable |
| Customer phone | Phone number of the customer, if applicable |
| Customer email | Email of the customer, if applicable |
| Shipping name | Name on the shipping address associated with this transaction, if applicable |
| Shipping phone number | Shipping phone number associated with this transaction, if applicable |
| Shipping method | Shipping method associated with this transaction, if applicable |
| Shipping address | First line of the shipping address associated with this transaction, if applicable |
| Shipping city | City of the shipping address associated with this transaction, if applicable |
| Shipping state | State of the shipping address associated with this transaction, if applicable |
| Shipping postal code | Postal code of the shipping address associated with this transaction, if applicable |
| Shipping country | Country of the shipping address associated with this transaction, if applicable |
| Channel type | For Wechat, identifies the channel the shopper paid from |
| Operating system | Operating system of the shopper, if available |
| Browser | Browser of the shopper, if available |
| Device | Device of the shopper, if available |
| Device IP address | IP address of the shopper, if available |
| Payment link reference | Reference for the payment link input by your customer, if applicable |
| Payment link message | Message for the payment link input by your customer, if applicable |
| Original payment currency | Three-letter ISO code for the currency of the original payment amount submitted by you on the payment intent |
| Original payment amount | Amount of the payment submitted by you on the payment intent |
| Product description | Product description provided by you, if applicable |
| Product name | Product name provided by you, if applicable |
| Product quantity | Product quantity provided by you, if applicable |
| Product unit price | Product unit price provided by you, if applicable |