OrderTransactions

Create and query transactions.

Table-Specific Information

Select

The adapter uses the Shopify API to process search criteria that refer to the OrderId column. The adapter processes other filters client-side within the adapter.

The Shopify APIs requires the search criteria to contain OrderId. For example, the following query is processed server side.

SELECT * FROM OrderTransactions WHERE OrderId = '123'

When performing a query without a filter or a filter other then the OrderId column, the adapter will retrieve the entire list of transactions and perform the filters client-side. The Shopify API requires that an OrderId be specified when retrieving transactions. Therefore to retrieve all the transactions, the adapter will first retrieve all the OrderIds from the Orders table (essentially performing the query: SELECT Id FROM Orders). Once the OrderId values have been retrieved, the adapter will issue individual requests to the Shopify API to retrieve all the transactions for each OrderId to build the result set.

SELECT * FROM OrderTransactions

SELECT * FROM OrderTransactions WHERE Kind='Capture'

Insert

You must specify the OrderId and Kind when inserting a transaction.

Capture a specified amount on a previously authorized order.

INSERT INTO OrderTransactions(OrderId, Amount, Kind) VALUES('123', 10.25, 'Capture')

Capture a previously authorized order for the full amount.

INSERT INTO OrderTransactions(OrderId, Kind) VALUES('123', 'Capture')

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.
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.