Payments export
Find out how to export your payment listing from the Connect portal.
Export limit
You can only export a maximum of 15k transactions at one time. If the number of transactions listed in the payment dashboard is more than 15k, continue to refine the search filters until it returns a number of transactions below the maximum limit before you hit the Export button.
You can easily export your payments by selecting the Export button on the Payments page. The following fields will be exported along with the relevant payments.
| Field # | Field Name | Field Description |
|---|---|---|
| 01 | TransactionDate | The date of the payment (in the user's local timezone). |
| 02 | Id | Unique ID of the payment in the Connect portal. |
| 03 | TransactionId | Unique payment identifier. |
| 04 | OrchestrationTransactionId | Unique identifier assigned at the payment orchestration layer. |
| 05 | ConnectorTransactionId | The payment identifier assigned by the payment processor. |
| 06 | SchemeTransactionId | The payment identifier assigned by the scheme. |
| 07 | MerchantRefId | Unique merchant-generated order reference or tracking number for each transaction. |
| 08 | Amount | Total transaction amount. |
| 09 | MerchantId | The merchant identifier. |
| 10 | MerchantName | The merchant name. |
| 11 | PaymentMethod | The payment method. e.g. CardDebit, CardCredit, Paypal, etc. |
| 12 | Status | The payment status e.g. Authorised, Captured, Refunded, Voided, etc. |
| 13 | SubStatus | The payment sub-status provides more details into why it was declined. |
| 14 | Source | The payment source. |
| 15 | Currency | The payment currency. |
| 16 | BuyerId | The buyer identifier (applicable to online only). |
| 17 | BuyerDisplayName | The buyer name (applicable to online only). |
| 18 | CapturedAmount | The captured amount of the payment. |
| 19 | RefundedAmount | The refunded amount of the payment. |
| 20 | Scheme | The card scheme. |
| 21 | Bin | The card issuer Bank Identification Number (BIN). A Bank Identification Number (BIN) is the first six to eight digits of the Primary Account Number (PAN) that identifies the financial institution that issued the card. |
| 22 | CardType | Card type, e.g. credit card, fuel card, etc. |
| 23 | Label | The last 4 digits of Payment Account Number (PAN) or Device Payment Account Number (DPAN) for card payments. For non-card payments, this field is used as the identifier for the buyer account e.g. PayPal buyer's email address. |
| 24 | Last4DigitOrAccountName | The last 4 digits of Payment Account Number (PAN) or Device Payment Account Number (DPAN) for card payments. For non-card payments, this field is used as the identifier for the buyer account e.g. PayPal buyer's email address. |
| 25 | AuthorizedAt | The date the payment was authorised. |
| 26 | ConcurrencyStamp | Internal field used to handle optimistic concurrency scenario. |
| 27 | UpdatedAt | The date the payment was last updated. |
| 28 | CapturedAt | The date the payment was captured. |
| 29 | VoidedAt | The date the payment was voided. |
| 30 | RefundedAtEarliest | The earliest refund date. |
| 31 | RefundedAtLatest | The latest refund date. |
| 32 | TransactionType | The payment type. Possible values are CP for in-store or CNP for ecommerce. |
| 33 | StoreId | The ID of a specific store (applicable to in-store only). |
| 34 | TerminalId | The ID of a payment terminal within a store (applicable to in-store only). |
| 35 | CardAcceptorNameLocation | Identifies the store location or only payment statement descriptor. |
| 36 | LocalDate | The local date and time of the payment at the original store location. |
| 37 | RRN | A Retrieval Reference Number (RRN) is a a numeric key to uniquely identify a card-based payment (applicable to in-store only). |
| 38 | STAN | A System Trace Audit Number (STAN) is a number generated by the cardholder bank that can be used to identify a payment (applicable to in-store only). |
| 39 | CardInputMethod | Identifies the method used to provide card information. e.g. Swipe, Contactless, Insert for in-store and ecommerce, card_on_file for online. |
| 40 | Channel | Payment channel. The values can either be Online or In-store. |
| 41 | ThreeDSecure.Status | 3-D Secure status. |
| 42 | ThreeDSecure.ECI | 3-D Secure ECI code. |
| 43 | ThreeDSecure.AuthResponse | 3-D Secure authorisation response code. |
| 44 | ThreeDSecure.Method | 3-D Secure method (frictionless/challenge). |
| 45 | Metadata | Payment transaction metadata (in JSON format). |
| 46 | ResponseCode | The response code from the card issuer when the payment is declined. |
| 47 | ResponseDescription | The description of the response code. When a payment has been declined or failed this field would provide additional details. |
Updated 7 months ago