OrderTransactions

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Long	True	A unique numeric identifier for the transaction.
OrderId	Long	False	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.
Authorization	String	True	The authorization code associated with the transaction.
Currency	String	True	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	Boolean	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, faliure, success, error.
PaymentsRefundsAttributesAcquirerReferenceNumber	String	True	A unique number associated with the transaction that can be used to track the refund.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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.
UpdatedAt	Datetime	The last time the order is updated.