Exporting your transactions
You can easily export your transactions by selecting the Export button on the Payments page.
The following fields will be exported along with the relevant transactions.
Field Name | Description |
---|---|
Id | The composite ID of Source+SourceId+TransactionId. |
TransactionId | The unique identifier assigned to this transaction by Wpay. |
OrchestrationTransactionId | The Transaction ID from Orchestrator. |
ConnectorTransactionId | The TransactionID from payment processor. |
SchemeTransactionId | The TransactionID from the scheme. |
TransactionExternalIdentifier | The unique identifier assigned to this payment by the Merchant. |
Amount | The exact monetary amount applicable. This is in cents i.e. a 100 AUD payment would be 10000. |
MerchantId | The ID of the Merchant the payment is associated with. |
MerchantName | Name of the merchant the payment is associated with. |
PaymentMethod | Type of payment method used for payment. |
Status | The payment status or statuses applicable. e.g. Authorised, Captured, Refunded. |
TransactionType | If a payment is a card present (CP) or card not present (CNP) transaction. |
Source | The original transaction source. |
Currency | The currency applicable. e.g. AUD, NZD. |
BuyerId | The ID of the buyer the payment is associated with. |
BuyerDisplayName | Name of the buyer the payment is associated with. |
CapturedAmount | The exact monetary amount that was captured for the payment. |
RefundedAmount | The exact monetary amount that was refunded. |
Scheme | Card scheme used for payment - when a scheme card was used, this field will display the credit card network. |
Bin | A bank identification number (BIN) is the initial set of four to six numbers on a credit card that identifies the institution. |
CardType | The card type e.g. Debit, Credit or other payment method from Alternative Payment Methods (APM). |
Label | The last 4 digits for PAN, DPAN or the identifier for an Alternative Payment Method. |
PaymentMethodLabel | The last 4 digits for PAN, DPAN or the identifier for an Alternative Payment Method. |
CreatedAt | The date the payment was created. |
AuthorizedAt | The date the payment was authorised. |
ConcurrencyStamp | This attribute will be used to handle optimistic concurrency scenario. |
UpdatedAt | The date the payment was updated. |
CapturedAt | The date the payment was captured. |
VoidedAt | The date the payment was voided. |
RefundedAtEarliest | The earliest refund date. |
RefundedAtLatest | The latest refund date. |
Updated 3 months ago