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. 使用できる値は次のとおりです。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. 使用できる値は次のとおりです。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
疑似カラムは、明示的にリストされているタイプのステートメントでのみ使用できるフィールドです。これらは標準的なカラムではなく、特定の操作のための追加機能を提供するものです。
| 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. 使用できる値は次のとおりです。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. |