# Schema Information
List of Tables/APIs
Subscriptions
Charges
Customers
Discounts
Onetimes
Orders
Address
Products
Collections
#### 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. 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. 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. 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. 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. 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** | 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 |
Contact Usmailto:support@sarasanalytics.com
Main Menu#v2this-section-includes
Back to Top#subscriptions