# Schema Information

<table><thead><tr><th width="125">List of Tables/APIs</th></tr></thead><tbody><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><tr><td><a href="#subscriptions">Subscriptions </a> </td></tr><tr><td><a href="#charges">Charges</a>  </td></tr></tbody></table>

#### 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   |

#### 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**

| 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 |

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


---

# 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://daton-sarasanalytics.gitbook.io/daton/integrations/data-sources/saas-integrations/recharge-payments-v1/schema-information.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.