OrderTransactions
Create and query transactions.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
A unique numeric identifier for the transaction. | |
| OrderId | Long | False |
Orders.Id |
A unique numeric identifier for the order. |
| UserId | Long | True |
The unique identifier for the user. | |
| LocationId | Long | True |
The ID of the physical location where the transaction was processed. | |
| Amount | Decimal | False |
The amount of money that the transaction was for. | |
| AmountRounding | Decimal | True |
The rounding adjustment for cash payments, to be applied on the amount to get a rounded amount. | |
| Authorization | String | False |
The authorization code associated with the transaction. | |
| Currency | String | False |
The three letter code (ISO 4217) for the currency used for the payment. | |
| DeviceId | String | True |
The unique identifier for the device. | |
| Gateway | String | False |
The name of the gateway the transaction was issued through. | |
| SourceName | String | True |
The origin of the transaction. | |
| Kind | String | False |
The kind of transaction. Can be any of the following: Authorization, Capture, Sale, Void, Refund. The allowed values are authorization, capture, sale, void, refund. | |
| Message | String | True |
The message associated with this transaction. | |
| ErrorCode | String | True |
A standardized error code, independent of the payment provider. | |
| Status | String | False |
The status of the transaction. | |
| Test | Bool | True |
The option to use the transaction for testing purposes. | |
| AVSResultCode | String | True |
The Response code from the address verification system. | |
| CreditCardBin | String | True |
The issuer identification number (IIN). | |
| CVVResultCode | String | True |
The Response code from the credit card company. | |
| CreditCardNumber | String | True |
The customer's credit card number, with most of the leading digits redacted with Xs. | |
| CreditCardCompany | String | True |
The name of the company who issued the customer's credit card. | |
| CreatedAt | Datetime | True |
The date and time when the customer was created. | |
| PaymentsRefundsAttributesStatus | String | True |
The current status of the refund The allowed values are pending, failure, success, error. | |
| PaymentsRefundsAttributesAcquirerReferenceNumber | String | True |
A unique number associated with the transaction that can be used to track the refund. | |
| PaymentId | String | True |
The unique identifier for the payment. | |
| ProcessedAt | Datetime | True |
The date and time when the transaction was processed. | |
| CreditCardName | String | True |
The name on the customer's credit card. | |
| CreditCardWallet | String | True |
The wallet of the customer's credit card. | |
| CreditCardExpMonth | Long | True |
The expiration month of the customer's credit card. | |
| CreditCardExpYear | Long | True |
The expiration year of the customer's credit card. | |
| Receipt | String | True |
A JSON aggregate of the order receipt. | |
| TotalUnsettledSetShopMoneyAmount | Decimal | True |
The amount of the shop money in the total unsettled set. | |
| TotalUnsettledSetPresentmentMoneyAmount | Decimal | True |
The amount of the presentment money in the total unsettled set. |
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 amount of money that the transaction was for. Use this when inserting transactions into an order or refund. |
| TransactionItemGateway | String |
The name of the gateway the transaction was issued through. Use this when inserting transactions into an order or refund. |
| TransActionItemKind | String |
The kind of transaction. Can be any of the following: Authorization, Capture, Sale, Void, Refund. Use this when inserting transactions into an order or refund. The allowed values are authorization, capture, sale, void, refund. |
| TransactionItemStatus | String |
The status of the transaction. Use this when inserting transactions into an order or refund. |
| TransactionItemParentId | String |
The parent id of the transaction. Use this when inserting transactions into a refund. |
| TransactionItemSource | String |
The status of the transaction. |
| UpdatedAt | Datetime |
The last time the order is updated. |