---
updatedAt: 2026-07-06T08:52:17.000Z
agentTools:
  projectIndex: https://partner-dwh.readme.io/llms.txt
---

# Charge Pricings

Table name: `charge_pricings`

Contains pricing and payment information for charging sessions. This model
combines charge pricing data with related financial attributes like costs,
payment methods, and pricing details.

**SQL:** `charge_pricings`

## Schema

| Column Name                | Data Type      | Description                                                                                                                    |
| :------------------------- | :------------- | :----------------------------------------------------------------------------------------------------------------------------- |
| **Primary ID**             |                |                                                                                                                                |
| id                         | INTEGER        | Primary key                                                                                                                    |
| **Other IDs**              |                |                                                                                                                                |
| charge\_id                 | INTEGER        | References the associated charging session                                                                                     |
| tariff\_id                 | INTEGER        | References the applied pricing tariff                                                                                          |
| currency\_id               | INTEGER        | References the currency for the charge price                                                                                   |
| cost\_price\_group\_id     | INTEGER        | References the cost price group configuration                                                                                  |
| paying\_team\_id           | INTEGER        | References the team responsible for payment                                                                                    |
| paying\_operator\_id       | INTEGER        | References the operator responsible for payment                                                                                |
| sponsor\_team\_id          | INTEGER        | References the team sponsoring or subsidizing the charge                                                                       |
| promotion\_code\_id        | INTEGER        | References any applied promotional discount code                                                                               |
| price\_group\_id           | INTEGER        | References the price group determining the rate structure                                                                      |
| **Timestamps**             |                |                                                                                                                                |
| created\_at                | TIMESTAMP\_NTZ | Timestamp when the pricing record was created                                                                                  |
| updated\_at                | TIMESTAMP\_NTZ | Timestamp when the pricing record was last modified                                                                            |
| paying\_at                 | TIMESTAMP\_NTZ | Timestamp when payment was processed                                                                                           |
| **Attributes**             |                |                                                                                                                                |
| price                      | NUMBER         | Final price charged for the session                                                                                            |
| reservation\_price         | NUMBER         | Price allocated for the charging reservation                                                                                   |
| estimated\_price           | NUMBER         | Projected cost before charging session completion                                                                              |
| original\_price            | NUMBER         | Base price before any adjustments or discounts                                                                                 |
| cost                       | NUMBER         | Actual cost incurred for providing the charging service                                                                        |
| payment\_method            | VARCHAR        | Method used for payment (e.g., 'free', 'team\_has\_funds', 'team\_has\_auto\_refill', or 'payment')                            |
| payment\_method\_type      | VARCHAR        | Further categorization of the payment method (e.g., 'team\_wallet', 'free', 'card', 'google\_pay', 'apple\_pay', 'adyen', etc) |
| payment\_type              | VARCHAR        | Further classification of payment types if applicable (e.g., stripe charge, wallet payment, adyen payment, etc.)               |
| estimated\_charge\_minutes | INTEGER        | Projected duration of charging session in minutes                                                                              |
| payment\_failed            | BOOLEAN        | Indicates whether the payment transaction failed                                                                               |
| price\_limit               | NUMBER         | Maximum price threshold set for the charging session                                                                           |
| source\_failed             | BOOLEAN        | Indicates whether the payment source encountered an error                                                                      |
| source\_type               | VARCHAR        | Classification of the payment source or origin (e.g., stripe source)                                                           |

## Inclusion Criteria

\-- requires that `charge_id`is among ids in `charges`

```sql
where charge_id in select (id from charges)
```

## Data Flow

| Upstream tables | Upstream tables |
| :-------------- | :-------------- |
| `charges`       | none            |