---
description: >-
  Structured details and metadata about the Recharge Payments v2 connector and
  its corresponding tables and fields.
---

# Schema Information

<table><thead><tr><th width="64">List of Tables/APIs</th></tr></thead><tbody><tr><td><a href="#subscriptions">Subscriptions</a></td></tr><tr><td><a href="#charges">Charges</a>  </td></tr><tr><td><a href="#customers">Customers</a>  </td></tr><tr><td><a href="#discounts">Discounts</a>  </td></tr><tr><td><a href="#onetimes">Onetimes</a>  </td></tr><tr><td><a href="#orders">Orders</a>  </td></tr><tr><td><a href="#address">Address</a>  </td></tr><tr><td><a href="#products">Products</a>  </td></tr><tr><td><a href="#collections">Collections</a></td></tr></tbody></table>

#### Subscriptions

Purpose: This API call will display a list of all the individual items that a customer receives on a recurring basis from your Recharge account.

Source API Documentation: [Recharge Payments v2- Subscriptions](https://developer.rechargepayments.com/2021-11/subscriptions)

**FIELDS**

| Field Name                                   | Data Type |
| -------------------------------------------- | --------- |
| id                                           | NUMERIC   |
| address\_id                                  | NUMERIC   |
| customer\_id                                 | NUMERIC   |
| cancellation\_reason                         | STRING    |
| cancellation\_reason\_comments               | STRING    |
| cancelled\_at                                | TIMESTAMP |
| analytics\_data                              | RECORD    |
| charge\_interval\_frequency                  | NUMERIC   |
| created\_at                                  | TIMESTAMP |
| external\_product\_id                        | RECORD    |
| external\_variant\_id                        | RECORD    |
| has\_queued\_charges                         | BOOLEAN   |
| is\_prepaid                                  | BOOLEAN   |
| is\_skippable                                | BOOLEAN   |
| is\_swappable                                | BOOLEAN   |
| max\_retries\_reached                        | BOOLEAN   |
| next\_charge\_scheduled\_at                  | DATE      |
| order\_interval\_frequency                   | NUMERIC   |
| order\_interval\_unit                        | STRING    |
| price                                        | STRING    |
| product\_title                               | STRING    |
| properties                                   | RECORD    |
| quantity                                     | NUMERIC   |
| sku                                          | STRING    |
| sku\_override                                | BOOLEAN   |
| status                                       | STRING    |
| updated\_at                                  | TIMESTAMP |
| variant\_title                               | STRING    |
| \_daton\_user\_id                            | NUMERIC   |
| \_daton\_batch\_runtime                      | NUMERIC   |
| \_daton\_batch\_id                           | NUMERIC   |
| presentment\_currency                        | STRING    |
| expire\_after\_specific\_number\_of\_charges | NUMERIC   |
| order\_day\_of\_month                        | NUMERIC   |

#### Charges

Purpose: A charge is a transaction that was processed already or the representation of an upcoming transaction. This API call will display a list of all the financial transactions linked to the purchase of any item (past or future) on your Recharge account.&#x20;

Source API Documentation: [Recharge Payments v2- Charges](https://developer.rechargepayments.com/2021-11/charges)

**FIELDS**

| Field Name                | Data Type |
| ------------------------- | --------- |
| id                        | NUMERIC   |
| address\_id               | NUMERIC   |
| billing\_address          | RECORD    |
| client\_details           | RECORD    |
| created\_at               | TIMESTAMP |
| currency                  | STRING    |
| customer                  | RECORD    |
| external\_order\_id       | RECORD    |
| external\_transaction\_id | RECORD    |
| has\_uncommitted\_changes | BOOLEAN   |
| line\_items               | RECORD    |
| note                      | STRING    |
| order\_attributes         | RECORD    |
| orders\_count             | NUMERIC   |
| payment\_processor        | STRING    |
| processed\_at             | TIMESTAMP |
| scheduled\_at             | DATE      |
| shipping\_address         | RECORD    |
| shipping\_lines           | RECORD    |
| status                    | STRING    |
| subtotal\_price           | STRING    |
| tags                      | STRING    |
| taxable                   | BOOLEAN   |
| total\_discounts          | STRING    |
| total\_line\_items\_price | STRING    |
| total\_price              | STRING    |
| total\_refunds            | STRING    |
| total\_tax                | STRING    |
| total\_weight\_grams      | NUMERIC   |
| type                      | STRING    |
| updated\_at               | TIMESTAMP |
| \_daton\_user\_id         | NUMERIC   |
| \_daton\_batch\_runtime   | NUMERIC   |
| \_daton\_batch\_id        | NUMERIC   |
| tax\_lines                | RECORD    |
| taxes\_included           | BOOLEAN   |
| discounts                 | RECORD    |
| error                     | STRING    |
| error\_type               | STRING    |
| retry\_date               | TIMESTAMP |

#### Customers

Purpose: This API call will display a list of account information of all the customers in your Recharge account.&#x20;

Source API Documentation: [Recharge Payments v2- Customers](https://developer.rechargepayments.com/2021-11/customers/customers_object)

**FIELDS**

| Field Name                        | Data Type |
| --------------------------------- | --------- |
| id                                | NUMERIC   |
| created\_at                       | TIMESTAMP |
| email                             | STRING    |
| external\_customer\_id            | RECORD    |
| first\_charge\_processed\_at      | TIMESTAMP |
| first\_name                       | STRING    |
| has\_payment\_method\_in\_dunning | BOOLEAN   |
| has\_valid\_payment\_method       | BOOLEAN   |
| hash                              | STRING    |
| last\_name                        | STRING    |
| subscriptions\_active\_count      | NUMERIC   |
| subscriptions\_total\_count       | NUMERIC   |
| updated\_at                       | TIMESTAMP |
| \_daton\_user\_id                 | NUMERIC   |
| \_daton\_batch\_runtime           | NUMERIC   |
| \_daton\_batch\_id                | NUMERIC   |
| phone                             | STRING    |
| tax\_exempt                       | BOOLEAN   |

#### Discounts

Purpose: This API calls the data-related product discounts that can be applied to orders for customers on your Recharge account.

Source API Documentation: [Recharge Payments v2- Discounts](https://developer.rechargepayments.com/2021-11/discounts)

**FIELDS**

| Field Name                  | Data Type |
| --------------------------- | --------- |
| id                          | NUMERIC   |
| applies\_to                 | RECORD    |
| channel\_settings           | RECORD    |
| code                        | STRING    |
| created\_at                 | TIMESTAMP |
| status                      | STRING    |
| updated\_at                 | TIMESTAMP |
| usage\_limits               | RECORD    |
| value                       | STRING    |
| value\_type                 | STRING    |
| \_daton\_user\_id           | NUMERIC   |
| \_daton\_batch\_runtime     | NUMERIC   |
| \_daton\_batch\_id          | NUMERIC   |
| external\_discount\_id      | RECORD    |
| external\_discount\_source  | STRING    |
| starts\_at                  | TIMESTAMP |
| ends\_at                    | TIMESTAMP |
| prerequisite\_subtotal\_min | STRING    |

#### Onetimes

Purpose: This API call will display a list of non-recurring line items on a queued charge on your Recharge account.&#x20;

Source API Documentation:[ Recharge Payments v2- Onetimes](https://developer.rechargepayments.com/2021-11/onetimes)

**FIELDS**

| Field Name                  | Data Type |
| --------------------------- | --------- |
| id                          | NUMERIC   |
| address\_id                 | NUMERIC   |
| customer\_id                | NUMERIC   |
| created\_at                 | TIMESTAMP |
| external\_product\_id       | RECORD    |
| external\_variant\_id       | RECORD    |
| next\_charge\_scheduled\_at | DATE      |
| price                       | STRING    |
| product\_title              | STRING    |
| quantity                    | NUMERIC   |
| sku\_override               | BOOLEAN   |
| updated\_at                 | TIMESTAMP |
| variant\_title              | STRING    |
| \_daton\_user\_id           | NUMERIC   |
| \_daton\_batch\_runtime     | NUMERIC   |
| \_daton\_batch\_id          | NUMERIC   |
| is\_cancelled               | BOOLEAN   |
| presentment\_currency       | STRING    |
| properties                  | RECORD    |
| sku                         | STRING    |

#### Orders

Purpose: This API call will display all the data in accordance with a charge on your Recharge account.&#x20;

Source API Documentation: [Recharge Payments v2- Orders](https://developer.rechargepayments.com/2021-11/orders)

**FIELDS**

| Field Name                | Data Type |
| ------------------------- | --------- |
| id                        | NUMERIC   |
| address\_id               | NUMERIC   |
| billing\_address          | RECORD    |
| charge                    | RECORD    |
| client\_details           | RECORD    |
| created\_at               | TIMESTAMP |
| currency                  | STRING    |
| customer                  | RECORD    |
| external\_order\_id       | RECORD    |
| external\_order\_name     | RECORD    |
| external\_order\_number   | RECORD    |
| is\_prepaid               | BOOLEAN   |
| line\_items               | RECORD    |
| note                      | STRING    |
| processed\_at             | TIMESTAMP |
| scheduled\_at             | TIMESTAMP |
| shipping\_address         | RECORD    |
| shipping\_lines           | RECORD    |
| status                    | STRING    |
| subtotal\_price           | STRING    |
| tags                      | STRING    |
| taxable                   | BOOLEAN   |
| total\_discounts          | STRING    |
| total\_line\_items\_price | STRING    |
| total\_price              | STRING    |
| total\_refunds            | STRING    |
| total\_tax                | STRING    |
| total\_weight\_grams      | NUMERIC   |
| type                      | STRING    |
| updated\_at               | TIMESTAMP |
| \_daton\_user\_id         | NUMERIC   |
| \_daton\_batch\_runtime   | NUMERIC   |
| \_daton\_batch\_id        | NUMERIC   |

#### Address

Purpose: This API call will display the shipping addresses of available orders on your Recharge account.

Source API Documentation: [Recharge Payments v2- Address](https://developer.rechargepayments.com/2021-11/addresses)

**FIELDS**

| Field Name                 | Data Type |
| -------------------------- | --------- |
| id                         | NUMERIC   |
| customer\_id               | NUMERIC   |
| payment\_method\_id        | NUMERIC   |
| address1                   | STRING    |
| address2                   | STRING    |
| city                       | STRING    |
| company                    | STRING    |
| country\_code              | STRING    |
| created\_at                | TIMESTAMP |
| first\_name                | STRING    |
| last\_name                 | STRING    |
| phone                      | STRING    |
| province                   | STRING    |
| updated\_at                | TIMESTAMP |
| zip                        | STRING    |
| \_daton\_user\_id          | NUMERIC   |
| \_daton\_batch\_runtime    | NUMERIC   |
| \_daton\_batch\_id         | NUMERIC   |
| order\_attributes          | RECORD    |
| shipping\_lines\_conserved | RECORD    |
| presentment\_currency      | STRING    |
| discounts                  | RECORD    |
| order\_note                | STRING    |

#### Products

Purpose: This API call will display a list of all the products from the catalog on your Recharge account.&#x20;

Source API Documentation:[ Recharge Payments v2- Products](https://developer.rechargepayments.com/2021-11/products)

**FIELDS**

| Field Name              | Data Type |
| ----------------------- | --------- |
| created\_at             | DATETIME  |
| discount\_amount        | NUMERIC   |
| discount\_type          | STRING    |
| handle                  | STRING    |
| id                      | NUMERIC   |
| images                  | RECORD    |
| product\_id             | NUMERIC   |
| shopify\_product\_id    | NUMERIC   |
| subscription\_defaults  | RECORD    |
| title                   | STRING    |
| updated\_at             | DATETIME  |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

#### Collections

Purpose: This API call will display a logical list of products aka collections in your Recharge account.

Source API Documentation: [Recharge Payments v2- Collections](https://developer.rechargepayments.com/2021-11/collections)

**FIELDS**&#x20;

| Field Name              | Data Type |
| ----------------------- | --------- |
| id                      | NUMERIC   |
| created\_at             | DATETIME  |
| description             | STRING    |
| sort\_order             | STRING    |
| title                   | STRING    |
| type                    | STRING    |
| updated\_at             | DATETIME  |
| \_daton\_user\_id       | NUMERIC   |
| \_daton\_batch\_runtime | NUMERIC   |
| \_daton\_batch\_id      | NUMERIC   |

<table data-view="cards"><thead><tr><th align="center"></th><th data-hidden data-card-target data-type="content-ref"></th></tr></thead><tbody><tr><td align="center"><mark style="color:blue;"><strong>Contact Us</strong></mark></td><td><a href="mailto:support@sarasanalytics.com">mailto:support@sarasanalytics.com</a></td></tr><tr><td align="center"><mark style="color:blue;"><strong>Main Menu</strong></mark></td><td><a href="..#v2this-section-includes">#v2this-section-includes</a></td></tr><tr><td align="center"><mark style="color:blue;"><strong>Back to Top</strong></mark></td><td><a href="#subscriptions">#subscriptions</a></td></tr></tbody></table>
