# Shopify: Transactions

## Description

* Each record represents a transaction in Shopify.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/shopify/resources/shopify.svg" alt="" data-size="line"> 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.                                                                                               |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/shopify-transactions.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.