Transactions
Lists all transactions.
Columns
| Name | Type | References | Description |
| Id [KEY] | Integer | Unique identifier for the transaction. | |
| OrderId | String | Identifier for the BigCommerce Order with which this transaction is associated. | |
| Event | String | Store event that created the transaction. | |
| Method | String | The payment method. | |
| Amount | Decimal | Amount of money in the transaction. | |
| Currency | String | Currency used for the transaction. | |
| Gateway | String | The payment gateway. | |
| Status | String | Status of the transaction. | |
| GatewayTransactionId | String | The transaction ID returned by the payment gateway for this transaction item. | |
| DateCreated | Datetime | The datetime of the transaction. | |
| Test | Boolean | True if the transaction performed was a test, or if the gateway is in test mode. | |
| FraudReview | Boolean | Result of gateway fraud review, if any. | |
| ReferenceTransactionId | Integer | Identifier for an existing transaction upon which this transaction acts. | |
| OfflineDisplayName | String | Display name for the offline payment. | |
| CustomPaymentMethod | String | Custom payment from manual order. | |
| PaymentMethodId | String | The payment method ID used for this transaction. | |
| PaymentInstrumentToken | String | Internal BigPay token for stored card. | |
| AVSResultCode | String | AVS code from the payment gateway. | |
| AVSResultMessage | String | AVS message from the payment gateway. | |
| AVSResultStreetMatch | String | AVS Code for street matching result. | |
| AVSResultPostalMatch | String | AVS Code for postal matching result. | |
| CVVResultCode | String | CVV Code from the payment Gateway. | |
| CVVResultMessage | String | CVV Message from the payment Gateway. | |
| CreditCardType | String | Type of credit-card. | |
| CreditCardIIN | String | The IIN of a credit-card number. | |
| CreditCardLast4 | String | The last 4 digits of a credit-card number. | |
| CreditCardExpiryMonth | Integer | The expiry month of a credit-card. | |
| CreditCardExpiryYear | Integer | The expiry year of a credit-card. | |
| GiftCertificateCode | String | The gift-certificate code. | |
| GiftCertificateOriginalBalance | Decimal | The balance on a gift certificate when it was purchased. | |
| GiftCertificateStartingBalance | Decimal | The balance on a gift certificate at the time of this purchase. | |
| GiftCertificateRemainingBalance | Decimal | The remaining balance on a gift certificate. | |
| GiftCertificateStatus | String | The status of a gift certificate. | |
| StoreCreditRemainingBalance | Decimal | Remaining balance of shopper's store credit. |