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 NameDescription
IdThe composite ID of Source+SourceId+TransactionId.
TransactionIdThe unique identifier assigned to this transaction by Wpay.
OrchestrationTransactionIdThe Transaction ID from Orchestrator.
ConnectorTransactionIdThe TransactionID from payment processor.
SchemeTransactionIdThe TransactionID from the scheme.
TransactionExternalIdentifierThe unique identifier assigned to this payment by the Merchant.
AmountThe exact monetary amount applicable. This is in cents i.e. a 100 AUD payment would be 10000.
MerchantIdThe ID of the Merchant the payment is associated with.
MerchantNameName of the merchant the payment is associated with.
PaymentMethodType of payment method used for payment.
StatusThe payment status or statuses applicable. e.g. Authorised, Captured, Refunded.
TransactionTypeIf a payment is a card present (CP) or card not present (CNP) transaction.
SourceThe original transaction source.
CurrencyThe currency applicable. e.g. AUD, NZD.
BuyerIdThe ID of the buyer the payment is associated with.
BuyerDisplayNameName of the buyer the payment is associated with.
CapturedAmountThe exact monetary amount that was captured for the payment.
RefundedAmountThe exact monetary amount that was refunded.
SchemeCard scheme used for payment - when a scheme card was used, this field will display the credit card network.
BinA bank identification number (BIN) is the initial set of four to six numbers on a credit card that identifies the institution.
CardTypeThe card type e.g. Debit, Credit or other payment method from Alternative Payment Methods (APM).
LabelThe last 4 digits for PAN, DPAN or the identifier for an Alternative Payment Method.
PaymentMethodLabelThe last 4 digits for PAN, DPAN or the identifier for an Alternative Payment Method.
CreatedAtThe date the payment was created.
AuthorizedAtThe date the payment was authorised.
ConcurrencyStampThis attribute will be used to handle optimistic concurrency scenario.
UpdatedAtThe date the payment was updated.
CapturedAtThe date the payment was captured.
VoidedAtThe date the payment was voided.
RefundedAtEarliestThe earliest refund date.
RefundedAtLatestThe latest refund date.