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