OrderTransactions
Tracks financial transactions for orders, such as authorizations, captures, refunds, and payment gateway responses.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
A unique numeric identifier for the transaction. | |
| OrderId | Long | False |
Orders.Id |
The unique numeric identifier for the order associated with this transaction. |
| UserId | Long | True |
The unique numeric identifier for the user who processed or created the transaction. | |
| LocationId | Long | True |
The ID of the physical location where the transaction was processed. | |
| Amount | Decimal | False |
The monetary amount associated with the transaction. | |
| AmountRounding | Decimal | True |
The rounding adjustment for cash payments, applied to achieve the rounded transaction total. | |
| Authorization | String | False |
The authorization code returned by the payment provider for this transaction. | |
| Currency | String | False |
The three-letter ISO 4217 currency code used for the payment. | |
| DeviceId | String | True |
The unique identifier of the device used to process the transaction. | |
| Gateway | String | False |
The name of the payment gateway that processed the transaction. | |
| SourceName | String | True |
The origin of the transaction, such as web, POS, or app. | |
| Kind | String | False |
The type of transaction. The allowed values are authorization, capture, sale, void, refund. | |
| Message | String | True |
A message or note associated with the transaction, often provided by the gateway or system. | |
| ErrorCode | String | True |
A standardized error code returned by the payment provider, if applicable. | |
| Status | String | False |
The current status of the transaction (for example, success, pending, failed). | |
| Test | Bool | True |
Indicates whether this transaction is a test transaction. | |
| AVSResultCode | String | True |
The response code returned from the address verification system (AVS). | |
| CreditCardBin | String | True |
The issuer identification number (IIN), formerly known as the bank identification number (BIN). | |
| CVVResultCode | String | True |
The response code returned by the credit card provider for card verification value (CVV) validation. | |
| CreditCardNumber | String | True |
The customer's credit card number with all but the last four digits redacted. | |
| CreditCardCompany | String | True |
The name of the credit card company that issued the customer's card. | |
| CreatedAt | Datetime | True |
The date and time when the transaction record was created. | |
| PaymentsRefundsAttributesStatus | String | True |
The current status of a refund related to this transaction. The allowed values are pending, failure, success, error. | |
| PaymentsRefundsAttributesAcquirerReferenceNumber | String | True |
A unique acquirer reference number (ARN) used to track the refund through the payment network. | |
| PaymentId | String | True |
The unique identifier for the payment associated with the transaction. | |
| ProcessedAt | Datetime | True |
The date and time when the transaction was processed by the payment gateway. | |
| CreditCardName | String | True |
The cardholder's name as it appears on the credit card. | |
| CreditCardWallet | String | True |
The digital wallet used for the payment, if applicable (for example, Apple Pay or Google Pay). | |
| CreditCardExpMonth | Long | True |
The expiration month of the credit card. | |
| CreditCardExpYear | Long | True |
The expiration year of the credit card. | |
| Receipt | String | True |
A JSON aggregate containing receipt details or metadata associated with the transaction. | |
| TotalUnsettledSetShopMoneyAmount | Decimal | True |
The shop currency amount of the unsettled balance for this transaction. | |
| TotalUnsettledSetPresentmentMoneyAmount | Decimal | True |
The presentment currency amount of the unsettled balance for this transaction. |
Pseudo-Columns
Pseudo-columns are fields that can only be used in the types of statements under which they are explicitly listed. They are not standard columns but instead provide additional functionality for specific operations.
| Name | Type | Description |
| TransactionItemAmount | Decimal |
The transaction amount to use when inserting transactions into an order or refund. |
| TransactionItemGateway | String |
The payment gateway to use when inserting transactions into an order or refund. |
| TransActionItemKind | String |
The transaction type to use when inserting transactions into an order or refund. The allowed values are authorization, capture, sale, void, refund. |
| TransactionItemStatus | String |
The transaction status to use when inserting transactions into an order or refund. |
| TransactionItemParentId | String |
The ID of the parent transaction to use when inserting transactions into a refund. |
| TransactionItemSource | String |
The source or origin to associate with the transaction when inserting it into an order or refund. |
| UpdatedAt | Datetime |
The date and time when the transaction record was last updated. |