Shopify: Transactions

Description

• Each record represents a transaction in Shopify.

Supported Data Sources

• Shopify

Columns

Type	Name	Description
	transaction_id	The ID for the transaction.
	order_id	The ID for the order that the transaction is associated with.
	refund_id	The ID associated with a refund in the refund table.
	amount	The amount of money included in the transaction in shop currency.
	authorization	The authorization code associated with the transaction.
	created_timestamp	The date and time when the transaction was created.
	processed_timestamp	The date and time when a transaction was processed.
	device_id	The ID for the device.
	gateway	The name of the gateway the transaction was issued through.
	source_name	The origin of the transaction.
	message	A string generated by the payment provider with additional information about why the transaction succeeded or failed.
	currency	The three-letter code (ISO 4217 format) for the currency used for the payment.
	location_id	The ID of the physical location where the transaction was processed.
	parent_id	The ID of an associated transaction.
	payment_avs_result_code	The response code from the address verification system.
	payment_credit_card_bin	The issuer identification number (IIN), formerly known as bank identification number (BIN) of the customer's credit card.
	payment_cvv_result_code	The response code from the credit card company indicating whether the customer entered the card security code, or card verification value, correctly.
	payment_credit_card_number	The customer's credit card number, with most of the leading digits redacted.
	payment_credit_card_company	The name of the company that issued the customer's credit card.
	kind	The transaction's type.
	receipt	A transaction receipt attached to the transaction by the gateway.
	currency_exchange_id	The ID of the adjustment.
	currency_exchange_adjustment	The difference between the amounts on the associated transaction and the parent transaction.
	currency_exchange_original_amount	The amount of the parent transaction in the shop currency.
	currency_exchange_final_amount	The amount of the associated transaction in the shop currency.
	currency_exchange_currency	The shop currency.
	error_code	A standardized error code, independent of the payment provider.
	status	The status of the transaction.
	user_id	The ID for the user who was logged into the Shopify POS device when the order was processed, if applicable.
	_fivetran_synced	Timestamp of the date the record was synced by Fivetran.
	exchange_rate	The exchange rate between the home currency and the currency of sale at the time of the transaction.
	currency_exchange_calculated_amount	The total amount of the transaction with the currency exchange rate applied.
	source_relation	The schema or database this record came from, if you are unioning multiple connectors. Null if not.
	payment_method	Method of payment.
	parent_created_timestamp	Created on timestamp of the parent transaction.
	parent_kind	Kind of the parent transaction.
	parent_amount	Amount of the parent transaction.
	parent_status	Status of the parent transaction.
	authorization_expires_at	Timestamp when the authorization expires.
	authorization_code	The authorization code associated with the transaction.