> ## Documentation Index
> Fetch the complete documentation index at: https://docs.thanx.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Purchases

The purchases made by your customers that have been detected by the Thanx platform.

<CardGroup cols={2}>
  <Card title="SFTP Exports" href="https://drive.google.com/file/d/1fKGtsvrJnU1ASIiXYT8acOCfaB-SJAzW/view?usp=drive_link">
    Sample `purchases.csv`
  </Card>

  <Card title="Thanx Connex">
    Table name: `purchases`
  </Card>
</CardGroup>

### Attributes

| Column                 | Data Type   | Description                                                                                                                                                |
| ---------------------- | ----------- | ---------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `purchase_id`          | `string`    | The unique identifier for the purchase is Thanx.                                                                                                           |
| `purchase_uid`         | `string`    | The unique identifier for the purchase in Thanx APIs.                                                                                                      |
| `merchant_id`          | `string`    | The unique identifier of the merchant in Thanx.                                                                                                            |
| `user_id`              | `string`    | The unique identifier of the customer in Thanx.                                                                                                            |
| `card_id`              | `string`    | The unique identifier for the card used to place a purchase in Thanx.                                                                                      |
| `order_id`             | `string`    | The ordering provider's unique identifier for the order associated with the purchase.                                                                      |
| `location_id`          | `string`    | The unique identifier for the location associated with the purchase. A location may not always be available.                                               |
| `location_name`        | `string`    | The name of the location associated with the purchase. This value is defined by the merchant.                                                              |
| `location_street`      | `string`    | The street address of the location where the purchase is made. This value is defined by the merchant.                                                      |
| `location_zip`         | `number`    | The zip code of the location where the purchase is made. This value is defined by the merchant.                                                            |
| `location_category`    | `string`    | The category of the location where the purchase is made. This value is defined by the merchant and is relevant to Malls.                                   |
| `authorization_amount` | `number`    | The purchase amount a merchant summits to the customer's issuing bank for approval.                                                                        |
| `settlement_amount`    | `number`    | The purchase amount the issuing bank transfers from the cardholder’s account to the payment processor, who then transfers the money to the acquiring bank. |
| `channel`              | `string`    | The channel through which this purchase was made. (`digital`, `instore`)                                                                                   |
| `purchased_at`         | `timestamp` | The time and date that the customer made the purchase. This is in UTC.                                                                                     |
| `pos_id`               | `string`    | POS ID of the order. Only present when a purchase is created via an in-store check-in for brands using POS check-in loyalty.                               |
| `pos_provider`         | `string`    | POS provider of the order. Only present when a purchase is created via an in-store check-in for brands using POS check-in loyalty.                         |