> ## 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. |
| `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. |
| `purchase_uid` | `string` | The unique identifier for the purchase in Thanx APIs. |
| `synced_at` | `timestamp` | Timestamp indicating the last update time for the record. |
| `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. |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.