# Chargify Chargify is a recurring billing and revenue management platform built specifically for B2B SaaS companies. Chargify integration replicates data using the [Chargify API](https://reference.chargify.com/v1/basics/introduction). See the [Schema](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#Schema) section for a list of objects available for replication. ## Preparing for authentication To access your data, you need to authenticate the connection with your account credentials. Information noteMake sure that the account you use has read access to the tables you want to fetch. Chargify is part of Maxio, providing subscription billing solutions within Maxio’s unified financial operations platform. API keys can only be managed by admin users. To retrieve your API key: 1. Log into your [Chargify](https://www.maxio.com/login) account. 2. Go to Config > Integrations > API Keys > New API Key. 3. Copy and paste your API key into a secured file. ## Creating the connection For more information, see [Connecting to SaaS applications](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/Landing/connecting-web-applications.htm). 1. Fill in the required connection properties. 2. Provide a name for the connection in Connection name. 3. Select Open connection metadata to define metadata for the connection when it has been created. 4. Click Create. Connection settings | Setting | Description | | --- | --- | | Data gateway | Select a Data Movement gateway if required by your use case.

Information note

This field is not available with the Qlik Talend Cloud Starter subscription, as it does not support Data Movement gateway. If you have another subscription tier and do not want to use Data Movement gateway, select None.

For information on the benefits of Data Movement gateway and use cases that require it, see [Qlik Data Gateway - Data Movement](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Gateways/replication-gateway.htm). | | Start Date | Enter the date, in the format `MM/DD/YYYY`, from which the data must be replicated from your source to your target. | | API Key | API key. | | Subdomain | You can find your subdomain in the URL of your account homepage. If the URL is my-chargify-site.chargify.com, the subdomain is my-chargify-site. | ## Schema Information note Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing. Depending on your destination, table and column names may not appear as they are outlined below. ### components The `components` table contains info about components associated with a product family in Chargify. | **Replication Method** | Full Table | | --- | --- | | **Primary Key** | id | | **Useful links** | [Chargify API method](https://reference.chargify.com/v1/components/list-components-for-a-product-family "Opens in new tab: Chargify API method") | components table foreign keys | Join components with | on | | --- | --- | | [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#invoices) | ```
components.id = invoices.charges.component_id
```

```
components.prices.id = invoices.charges.component_id
```

```
components.id = invoices.payments_and_credits.component_id
```

```
components.prices.id = invoices.payments_and_credits.component_id
``` | | [price_points](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#price-points) | ```
components.id = price_points.component_id
```

```
components.prices.id = price_points.component_id
```

```
components.id = price_points.prices.component_id
```

```
components.prices.id = price_points.prices.component_id
```

```
components.default_price_point_id = price_points.id
```

```
components.prices.price_point_id = price_points.id
``` | | [statements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#statements) | ```
components.id = statements.transactions.component_id
```

```
components.prices.id = statements.transactions.component_id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#transactions) | ```
components.id = transactions.component_id
```

```
components.prices.id = transactions.component_id
``` | | [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#coupons) | ```
components.product_family_id = coupons.product_family_id
``` | | [product_families](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#product-families) | ```
components.product_family_id = product_families.id
``` | | [products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#products) | ```
components.product_family_id = products.product_family.id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#subscriptions) | ```
components.product_family_id = subscriptions.product.product_family.id
``` | components table schema | **archived**

BOOLEAN | | --- | | **created\_at**

DATE-TIME | | **default\_price\_point\_id**

NUMBER | | **default\_price\_point\_name**

STRING | | **description**

STRING | | **downgrade\_credit**

STRING | | **handle**

STRING | | **id**

INTEGER | | **kind**

STRING | | **name**

STRING | | **price\_per\_unit\_in\_cents**

INTEGER | | **price\_point\_count**

NUMBER | | **price\_points\_url**

STRING | | **prices**

ARRAY

This is a nested data structure:

component_id: INTEGER
ending_quantity: INTEGER
formatted_unit_price: STRING
id: INTEGER
price_point_id: INTEGER
starting_quantity: INTEGER
unit_price: STRING

| | **pricing\_scheme**

STRING | | **product\_family\_id**

INTEGER | | **product\_family\_name**

STRING | | **recurring**

BOOLEAN | | **tax\_code**

STRING | | **taxable**

BOOLEAN | | **unit\_name**

STRING | | **unit\_price**

STRING | | **upgrade\_charge**

STRING | ### coupons The `coupons` table contains info about coupons associated with a product family in Chargify. | **Replication Method** | Full Table | | --- | --- | | **Primary Key** | id | | **Useful links** | [Chargify API method](https://reference.chargify.com/v1/coupons-editing/list-product-family-coupons "Opens in new tab: Chargify API method") | coupons table foreign keys | Join coupons with | on | | --- | --- | | [components](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#components) | ```
coupons.product_family_id = components.product_family_id
``` | | [product_families](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#product-families) | ```
coupons.product_family_id = product_families.id
``` | | [products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#products) | ```
coupons.product_family_id = products.product_family.id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#subscriptions) | ```
coupons.product_family_id = subscriptions.product.product_family.id
``` | coupons table schema | **allow\_negative\_balance**

BOOLEAN | | --- | | **amount\_in\_cents**

INTEGER | | **archived\_at**

DATE-TIME | | **code**

STRING | | **compounding\_strategy**

STRING | | **conversion\_limit**

INTEGER | | **coupon\_restrictions**

ARRAY

This is a nested data structure:

handle: STRING
id: INTEGER
item_id: INTEGER
item_type: STRING
name: STRING

| | **created\_at**

DATE-TIME | | **description**

STRING | | **duration\_interval**

INTEGER | | **duration\_interval\_unit**

STRING | | **duration\_period\_count**

NUMBER | | **end\_date**

DATE-TIME | | **id**

INTEGER | | **name**

STRING | | **percentage**

NUMBER | | **product\_family\_id**

INTEGER | | **recurring**

BOOLEAN | | **stackable**

BOOLEAN | | **start\_date**

DATE-TIME | | **updated\_at**

DATE-TIME | ### customers The `customers` table contains info about customers associated with your Chargify site. | **Replication Method** | Full Table | | --- | --- | | **Primary Key** | id | | **Useful links** | [Chargify API method](https://reference.chargify.com/v1/customers/list-customers-for-a-site "Opens in new tab: Chargify API method") | customers table foreign keys | Join customers with | on | | --- | --- | | [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#invoices) | ```
customers.id = invoices.charges.customer_id
```

```
customers.parent_id = invoices.charges.customer_id
```

```
customers.id = invoices.payments_and_credits.customer_id
```

```
customers.parent_id = invoices.payments_and_credits.customer_id
``` | | [statements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#statements) | ```
customers.id = statements.transactions.customer_id
```

```
customers.parent_id = statements.transactions.customer_id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#subscriptions) | ```
customers.id = subscriptions.credit_card.customer_id
```

```
customers.parent_id = subscriptions.credit_card.customer_id
```

```
customers.id = subscriptions.customer.id
```

```
customers.parent_id = subscriptions.customer.id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#transactions) | ```
customers.id = transactions.customer_id
```

```
customers.parent_id = transactions.customer_id
``` | customers table schema | **address**

STRING | | --- | | **address\_2**

STRING | | **cc\_emails**

STRING | | **city**

STRING | | **country**

STRING | | **created\_at**

DATE-TIME | | **first\_name**

STRING | | **id**

INTEGER | | **last\_name**

STRING | | **organization**

STRING | | **parent\_id**

INTEGER | | **phone**

STRING | | **portal\_customer\_created\_at**

DATE-TIME | | **portal\_invite\_last\_accepted\_at**

DATE-TIME | | **portal\_invite\_last\_sent\_at**

DATE-TIME | | **reference**

STRING | | **state**

STRING | | **tax\_exempt**

BOOLEAN | | **updated\_at**

DATE-TIME | | **vat\_number**

STRING | | **verified**

BOOLEAN | | **zip**

STRING | ### events The `events` table contains info about activity on your Chargify site. | **Replication Method** | Full Table | | --- | --- | | **Primary Key** | id | | **Useful links** | [Chargify API method](https://reference.chargify.com/v1/events/list-events-for-a-site "Opens in new tab: Chargify API method") | events table foreign keys | Join events with | on | | --- | --- | | [statements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#statements) | ```
events.id = statements.events.event.id
```

```
events.event_specific_data.product_id = statements.events.event.event_specific_data.product_id
```

```
events.event_specific_data.product_id = statements.transactions.product_id
```

```
events.subscription_id = statements.events.event.subscription_id
```

```
events.subscription_id = statements.subscription_id
```

```
events.subscription_id = statements.transactions.subscription_id
```

```
events.event_specific_data.account_transaction_id = statements.transactions.id
``` | | [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#invoices) | ```
events.event_specific_data.product_id = invoices.charges.product_id
```

```
events.event_specific_data.product_id = invoices.payments_and_credits.product_id
```

```
events.subscription_id = invoices.charges.subscription_id
```

```
events.subscription_id = invoices.payments_and_credits.subscription_id
```

```
events.subscription_id = invoices.subscription_id
```

```
events.event_specific_data.account_transaction_id = invoices.charges.payment_id
```

```
events.event_specific_data.account_transaction_id = invoices.payments_and_credits.payment_id
``` | | [products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#products) | ```
events.event_specific_data.product_id = products.id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#subscriptions) | ```
events.event_specific_data.product_id = subscriptions.next_product_id
```

```
events.event_specific_data.product_id = subscriptions.product.id
```

```
events.subscription_id = subscriptions.id
```

```
events.event_specific_data.account_transaction_id = subscriptions.signup_payment_id
```

```
events.event_specific_data.account_transaction_id = subscriptions.stored_credential_transaction_id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#transactions) | ```
events.event_specific_data.product_id = transactions.product_id
```

```
events.subscription_id = transactions.subscription_id
```

```
events.event_specific_data.account_transaction_id = transactions.id
```

```
events.event_specific_data.account_transaction_id = transactions.parent_id
```

```
events.event_specific_data.account_transaction_id = transactions.payment_id
``` | events table schema | **created\_at**

DATE-TIME | | --- | | **event\_specific\_data**

OBJECT

This is a nested data structure:

account_transaction_id: INTEGER
current_step: OBJECT, which is also a nested data structure.
- action: STRING
- day_threshold: INTEGER
- email_body: STRING
- email_subject: STRING
- send_bcc_email: BOOLEAN
- send_email: BOOLEAN
- send_sms: BOOLEAN
- sms_body: STRING
dunner: OBJECT, which is also a nested data structure.
- attempts: INTEGER
- created_at: STRING
- last_attempted_at: STRING
- revenue_at_risk_in_cents: INTEGER
- state: STRING
- subscription_id: INTEGER
new_product_id: INTEGER
new_subscription_state: STRING
next_step: OBJECT, which is also a nested data structure.
- action: STRING
- day_threshold: INTEGER
- email_body: STRING
- email_subject: STRING
- send_bcc_email: BOOLEAN
- send_email: BOOLEAN
- send_sms: BOOLEAN
- sms_body: STRING
previous_product_id: INTEGER
previous_subscription_state: STRING
product_id: INTEGER

| | **id**

INTEGER | | **key**

STRING | | **message**

STRING | | **subscription\_id**

INTEGER | ### invoices The `invoices` table contains info about invoices in your Chargify instance. | **Replication Method** | CDC | | --- | --- | | **Primary Key** | id | | **Useful links** | [Chargify API method](https://reference.chargify.com/v1/invoices-legacy/list-all-invoices-by-subscription "Opens in new tab: Chargify API method") | invoices table foreign keys | Join invoices with | on | | --- | --- | | [components](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#components) | ```
invoices.charges.component_id = components.id
```

```
invoices.payments_and_credits.component_id = components.id
```

```
invoices.charges.component_id = components.prices.id
```

```
invoices.payments_and_credits.component_id = components.prices.id
``` | | [price_points](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#price-points) | ```
invoices.charges.component_id = price_points.component_id
```

```
invoices.payments_and_credits.component_id = price_points.component_id
```

```
invoices.charges.component_id = price_points.prices.component_id
```

```
invoices.payments_and_credits.component_id = price_points.prices.component_id
``` | | [statements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#statements) | ```
invoices.charges.component_id = statements.transactions.component_id
```

```
invoices.payments_and_credits.component_id = statements.transactions.component_id
```

```
invoices.charges.customer_id = statements.transactions.customer_id
```

```
invoices.payments_and_credits.customer_id = statements.transactions.customer_id
```

```
invoices.charges.product_id = statements.events.event.event_specific_data.product_id
```

```
invoices.payments_and_credits.product_id = statements.events.event.event_specific_data.product_id
```

```
invoices.charges.product_id = statements.transactions.product_id
```

```
invoices.payments_and_credits.product_id = statements.transactions.product_id
```

```
invoices.statement_id = statements.id
```

```
invoices.statement_id = statements.transactions.statement_id
```

```
invoices.charges.subscription_id = statements.events.event.subscription_id
```

```
invoices.payments_and_credits.subscription_id = statements.events.event.subscription_id
```

```
invoices.subscription_id = statements.events.event.subscription_id
```

```
invoices.charges.subscription_id = statements.subscription_id
```

```
invoices.payments_and_credits.subscription_id = statements.subscription_id
```

```
invoices.subscription_id = statements.subscription_id
```

```
invoices.charges.subscription_id = statements.transactions.subscription_id
```

```
invoices.payments_and_credits.subscription_id = statements.transactions.subscription_id
```

```
invoices.subscription_id = statements.transactions.subscription_id
```

```
invoices.charges.payment_id = statements.transactions.id
```

```
invoices.payments_and_credits.payment_id = statements.transactions.id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#transactions) | ```
invoices.charges.component_id = transactions.component_id
```

```
invoices.payments_and_credits.component_id = transactions.component_id
```

```
invoices.charges.customer_id = transactions.customer_id
```

```
invoices.payments_and_credits.customer_id = transactions.customer_id
```

```
invoices.charges.product_id = transactions.product_id
```

```
invoices.payments_and_credits.product_id = transactions.product_id
```

```
invoices.statement_id = transactions.statement_id
```

```
invoices.charges.subscription_id = transactions.subscription_id
```

```
invoices.payments_and_credits.subscription_id = transactions.subscription_id
```

```
invoices.subscription_id = transactions.subscription_id
```

```
invoices.charges.payment_id = transactions.id
```

```
invoices.payments_and_credits.payment_id = transactions.id
```

```
invoices.charges.payment_id = transactions.parent_id
```

```
invoices.payments_and_credits.payment_id = transactions.parent_id
```

```
invoices.charges.payment_id = transactions.payment_id
```

```
invoices.payments_and_credits.payment_id = transactions.payment_id
``` | | [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#customers) | ```
invoices.charges.customer_id = customers.id
```

```
invoices.payments_and_credits.customer_id = customers.id
```

```
invoices.charges.customer_id = customers.parent_id
```

```
invoices.payments_and_credits.customer_id = customers.parent_id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#subscriptions) | ```
invoices.charges.customer_id = subscriptions.credit_card.customer_id
```

```
invoices.payments_and_credits.customer_id = subscriptions.credit_card.customer_id
```

```
invoices.charges.customer_id = subscriptions.customer.id
```

```
invoices.payments_and_credits.customer_id = subscriptions.customer.id
```

```
invoices.charges.product_id = subscriptions.next_product_id
```

```
invoices.payments_and_credits.product_id = subscriptions.next_product_id
```

```
invoices.charges.product_id = subscriptions.product.id
```

```
invoices.payments_and_credits.product_id = subscriptions.product.id
```

```
invoices.charges.subscription_id = subscriptions.id
```

```
invoices.payments_and_credits.subscription_id = subscriptions.id
```

```
invoices.subscription_id = subscriptions.id
```

```
invoices.charges.payment_id = subscriptions.signup_payment_id
```

```
invoices.payments_and_credits.payment_id = subscriptions.signup_payment_id
```

```
invoices.charges.payment_id = subscriptions.stored_credential_transaction_id
```

```
invoices.payments_and_credits.payment_id = subscriptions.stored_credential_transaction_id
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#events) | ```
invoices.charges.product_id = events.event_specific_data.product_id
```

```
invoices.payments_and_credits.product_id = events.event_specific_data.product_id
```

```
invoices.charges.subscription_id = events.subscription_id
```

```
invoices.payments_and_credits.subscription_id = events.subscription_id
```

```
invoices.subscription_id = events.subscription_id
```

```
invoices.charges.payment_id = events.event_specific_data.account_transaction_id
```

```
invoices.payments_and_credits.payment_id = events.event_specific_data.account_transaction_id
``` | | [products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#products) | ```
invoices.charges.product_id = products.id
```

```
invoices.payments_and_credits.product_id = products.id
``` | invoices table schema | **amount\_due\_in\_cents**

INTEGER | | --- | | **charges**

ARRAY

This is a nested data structure:

amount_in_cents: INTEGER
component_id: INTEGER
created_at: DATE-TIME
customer_id: INTEGER
ending_balance_in_cents: INTEGER
gateway_order_id: STRING
gateway_transaction_id: STRING
id: INTEGER
kind: STRING
memo: STRING
payment_id: INTEGER
product_id: INTEGER
starting_balance_in_cents: INTEGER
subscription_id: INTEGER
success: BOOLEAN
tax_id: INTEGER
transaction_type: STRING
type: STRING

amount_in_cents: INTEGER
card_expiration: STRING
card_number: STRING
card_type: STRING
component_id: INTEGER
created_at: DATE-TIME
customer_id: INTEGER
ending_balance_in_cents: INTEGER
gateway_order_id: STRING
gateway_transaction_id: STRING
id: INTEGER
kind: STRING
memo: STRING
payment_id: INTEGER
product_id: INTEGER
starting_balance_in_cents: INTEGER
subscription_id: INTEGER
success: BOOLEAN
tax_id: INTEGER
transaction_type: STRING
type: STRING

| | **site\_id**

INTEGER | | **state**

STRING | | **statement\_id**

INTEGER | | **subscription\_id**

INTEGER | | **total\_amount\_in\_cents**

INTEGER | | **updated\_at**

DATE-TIME | ### price\_points The `price_points` table contains info about product price points in your Chargify instance. | **Replication Method** | Full Table | | --- | --- | | **Primary Key** | id | | **Useful links** | [Chargify API method](https://reference.chargify.com/v1/products-price-points/read-product-price-points "Opens in new tab: Chargify API method") | price\_points table foreign keys | Join price\_points with | on | | --- | --- | | [components](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#components) | ```
price_points.component_id = components.id
```

```
price_points.prices.component_id = components.id
```

```
price_points.component_id = components.prices.id
```

```
price_points.prices.component_id = components.prices.id
```

```
price_points.id = components.default_price_point_id
```

```
price_points.id = components.prices.price_point_id
``` | | [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#invoices) | ```
price_points.component_id = invoices.charges.component_id
```

```
price_points.prices.component_id = invoices.charges.component_id
```

```
price_points.component_id = invoices.payments_and_credits.component_id
```

```
price_points.prices.component_id = invoices.payments_and_credits.component_id
``` | | [statements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#statements) | ```
price_points.component_id = statements.transactions.component_id
```

```
price_points.prices.component_id = statements.transactions.component_id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#transactions) | ```
price_points.component_id = transactions.component_id
```

```
price_points.prices.component_id = transactions.component_id
``` | price\_points table schema | **archived\_at**

DATE-TIME | | --- | | **component\_id**

INTEGER | | **created\_at**

DATE-TIME | | **default**

BOOLEAN | | **handle**

STRING | | **id**

INTEGER | | **name**

STRING | | **prices**

ARRAY

This is a nested data structure:

component_id: INTEGER
ending_quantity: INTEGER
id: INTEGER
starting_quantity: INTEGER
unit_price: STRING

| | **pricing\_scheme**

STRING | | **updated\_at**

DATE-TIME | ### product\_families The `product_families` table contains info about product families in your Chargify instance. Product families house your products, components, and coupons and are used to categorize products, product levels, or service offerings to your subscribers. | **Replication Method** | Full Table | | --- | --- | | **Primary Key** | id | | **Useful links** | [Chargify API method](https://reference.chargify.com/v1/product-families/list-product-family-via-site "Opens in new tab: Chargify API method") | product\_families table foreign keys | Join product\_families with | on | | --- | --- | | [components](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#components) | ```
product_families.id = components.product_family_id
``` | | [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#coupons) | ```
product_families.id = coupons.product_family_id
``` | | [products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#products) | ```
product_families.id = products.product_family.id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#subscriptions) | ```
product_families.id = subscriptions.product.product_family.id
``` | product\_families table schema | **accounting\_code**

STRING | | --- | | **description**

STRING | | **handle**

STRING | | **id**

INTEGER | | **name**

STRING | ### products The `products` table contains info about the prodcts in your Chargify instance. | **Replication Method** | Full Table | | --- | --- | | **Primary Key** | id | | **Useful links** | [Chargify API method](https://reference.chargify.com/v1/products/list-products "Opens in new tab: Chargify API method") | products table foreign keys | Join products with | on | | --- | --- | | [components](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#components) | ```
products.product_family.id = components.product_family_id
``` | | [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#coupons) | ```
products.product_family.id = coupons.product_family_id
``` | | [product_families](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#product-families) | ```
products.product_family.id = product_families.id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#subscriptions) | ```
products.product_family.id = subscriptions.product.product_family.id
```

```
products.id = subscriptions.next_product_id
```

```
products.id = subscriptions.product.id
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#events) | ```
products.id = events.event_specific_data.product_id
``` | | [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#invoices) | ```
products.id = invoices.charges.product_id
```

```
products.id = invoices.payments_and_credits.product_id
``` | | [statements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#statements) | ```
products.id = statements.events.event.event_specific_data.product_id
```

```
products.id = statements.transactions.product_id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#transactions) | ```
products.id = transactions.product_id
``` | products table schema | **accounting\_code**

STRING | | --- | | **archived\_at**

DATE-TIME | | **created\_at**

DATE-TIME | | **description**

STRING | | **expiration\_interval**

STRING | | **expiration\_interval\_unit**

STRING | | **handle**

STRING | | **id**

INTEGER | | **initial\_charge\_after\_trial**

BOOLEAN | | **initial\_charge\_in\_cents**

INTEGER | | **interval**

INTEGER | | **interval\_unit**

STRING | | **name**

STRING | | **price\_in\_cents**

INTEGER | | **product\_family**

OBJECT

This is a nested data structure:

accounting_code: STRING
description: STRING
handle:
id: INTEGER
name: STRING

| | **public\_signup\_pages**

ARRAY

This is a nested data structure:

id: INTEGER
return_params: STRING
return_url: STRING
url: STRING

| | **request\_credit\_card**

BOOLEAN | | **require\_credit\_card**

BOOLEAN | | **return\_params**

STRING | | **tax\_code**

STRING | | **taxable**

BOOLEAN | | **trial\_interval**

INTEGER | | **trial\_interval\_unit**

STRING | | **trial\_price\_in\_cents**

INTEGER | | **update\_return\_params**

STRING | | **update\_return\_url**

STRING | | **updated\_at**

DATE-TIME | | **version\_number**

INTEGER | ### statements The `statements` table contains info about the statements in your Chargify instance. Statements show all account activity for a specific usage period and are similar to invoices, as they can be marked as currently paid or unpaid. | **Replication Method** | Full Table | | --- | --- | | **Primary Key** | id | | **Useful links** | [Chargify API method](https://reference.chargify.com/v1/statements/list-statements-for-a-site "Opens in new tab: Chargify API method") | statements table foreign keys | Join statements with | on | | --- | --- | | [components](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#components) | ```
statements.transactions.component_id = components.id
```

```
statements.transactions.component_id = components.prices.id
``` | | [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#invoices) | ```
statements.transactions.component_id = invoices.charges.component_id
```

```
statements.transactions.component_id = invoices.payments_and_credits.component_id
```

```
statements.transactions.customer_id = invoices.charges.customer_id
```

```
statements.transactions.customer_id = invoices.payments_and_credits.customer_id
```

```
statements.events.event.event_specific_data.product_id = invoices.charges.product_id
```

```
statements.transactions.product_id = invoices.charges.product_id
```

```
statements.events.event.event_specific_data.product_id = invoices.payments_and_credits.product_id
```

```
statements.transactions.product_id = invoices.payments_and_credits.product_id
```

```
statements.id = invoices.statement_id
```

```
statements.transactions.statement_id = invoices.statement_id
```

```
statements.events.event.subscription_id = invoices.charges.subscription_id
```

```
statements.subscription_id = invoices.charges.subscription_id
```

```
statements.transactions.subscription_id = invoices.charges.subscription_id
```

```
statements.events.event.subscription_id = invoices.payments_and_credits.subscription_id
```

```
statements.subscription_id = invoices.payments_and_credits.subscription_id
```

```
statements.transactions.subscription_id = invoices.payments_and_credits.subscription_id
```

```
statements.events.event.subscription_id = invoices.subscription_id
```

```
statements.subscription_id = invoices.subscription_id
```

```
statements.transactions.subscription_id = invoices.subscription_id
```

```
statements.transactions.id = invoices.charges.payment_id
```

```
statements.transactions.id = invoices.payments_and_credits.payment_id
``` | | [price_points](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#price-points) | ```
statements.transactions.component_id = price_points.component_id
```

```
statements.transactions.component_id = price_points.prices.component_id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#transactions) | ```
statements.transactions.component_id = transactions.component_id
```

```
statements.transactions.customer_id = transactions.customer_id
```

```
statements.events.event.event_specific_data.product_id = transactions.product_id
```

```
statements.transactions.product_id = transactions.product_id
```

```
statements.id = transactions.statement_id
```

```
statements.transactions.statement_id = transactions.statement_id
```

```
statements.events.event.subscription_id = transactions.subscription_id
```

```
statements.subscription_id = transactions.subscription_id
```

```
statements.transactions.subscription_id = transactions.subscription_id
```

```
statements.transactions.id = transactions.id
```

```
statements.transactions.id = transactions.parent_id
```

```
statements.transactions.id = transactions.payment_id
``` | | [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#customers) | ```
statements.transactions.customer_id = customers.id
```

```
statements.transactions.customer_id = customers.parent_id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#subscriptions) | ```
statements.transactions.customer_id = subscriptions.credit_card.customer_id
```

```
statements.transactions.customer_id = subscriptions.customer.id
```

```
statements.events.event.event_specific_data.product_id = subscriptions.next_product_id
```

```
statements.transactions.product_id = subscriptions.next_product_id
```

```
statements.events.event.event_specific_data.product_id = subscriptions.product.id
```

```
statements.transactions.product_id = subscriptions.product.id
```

```
statements.events.event.subscription_id = subscriptions.id
```

```
statements.subscription_id = subscriptions.id
```

```
statements.transactions.subscription_id = subscriptions.id
```

```
statements.transactions.id = subscriptions.signup_payment_id
```

```
statements.transactions.id = subscriptions.stored_credential_transaction_id
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#events) | ```
statements.events.event.id = events.id
```

```
statements.events.event.event_specific_data.product_id = events.event_specific_data.product_id
```

```
statements.transactions.product_id = events.event_specific_data.product_id
```

```
statements.events.event.subscription_id = events.subscription_id
```

```
statements.subscription_id = events.subscription_id
```

```
statements.transactions.subscription_id = events.subscription_id
```

```
statements.transactions.id = events.event_specific_data.account_transaction_id
``` | | [products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#products) | ```
statements.events.event.event_specific_data.product_id = products.id
```

```
statements.transactions.product_id = products.id
``` | statements table schema | **basic\_html\_view**

STRING | | --- | | **closed\_at**

DATE-TIME | | **created\_at**

DATE-TIME | | **customer\_billing\_address**

STRING | | **customer\_billing\_address\_2**

STRING | | **customer\_billing\_city**

STRING | | **customer\_billing\_country**

STRING | | **customer\_billing\_state**

STRING | | **customer\_billing\_zip**

STRING | | **customer\_first\_name**

STRING | | **customer\_last\_name**

STRING | | **customer\_organization**

STRING | | **customer\_shipping\_address**

STRING | | **customer\_shipping\_address\_2**

STRING | | **customer\_shipping\_city**

STRING | | **customer\_shipping\_country**

STRING | | **customer\_shipping\_state**

STRING | | **customer\_shipping\_zip**

STRING | | **ending\_balance\_in\_cents**

INTEGER | | **events**

ARRAY

This is a nested data structure:

event: OBJECT, which is also a nested data structure.
- created_at: DATE-TIME
- event_specific_data: OBJECT, which is also a nested data structure.
  - account_transaction_id: INTEGER
  - current_step: OBJECT, which is also a nested data structure.
    - action: STRING
    - day_threshold: INTEGER
    - email_body: STRING
    - email_subject: STRING
    - send_bcc_email: BOOLEAN
    - send_email: BOOLEAN
    - send_sms: BOOLEAN
    - sms_body: STRING
  - dunner: OBJECT, which is also a nested data structure.
    - attempts: INTEGER
    - created_at: STRING
    - last_attempted_at: STRING
    - revenue_at_risk_in_cents: INTEGER
    - state: STRING
    - subscription_id: INTEGER
  - new_product_id: INTEGER
  - new_subscription_state: STRING
  - next_step: OBJECT, which is also a nested data structure.
    - action: STRING
    - day_threshold: INTEGER
    - email_body: STRING
    - email_subject: STRING
    - send_bcc_email: BOOLEAN
    - send_email: BOOLEAN
    - send_sms: BOOLEAN
    - sms_body: STRING
  - previous_product_id: INTEGER
  - previous_subscription_state: STRING
  - product_id: INTEGER
- id: INTEGER
- key: STRING
- message: STRING
- subscription_id: INTEGER

| | **future\_payments**

ARRAY

This is a nested data structure:

id: INTEGER

amount_in_cents: INTEGER
component_id: INTEGER
created_at: DATE-TIME
customer_id: INTEGER
discount_amount_in_cents: INTEGER
ending_balance_in_cents: INTEGER
gateway_order_id: STRING
gateway_transaction_id: STRING
gateway_used: STRING
id: INTEGER
item_name: STRING
kind: STRING
memo: STRING
original_amount_in_cents: INTEGER
payment_id: INTEGER
product_id: INTEGER
starting_balance_in_cents: INTEGER
statement_id: INTEGER
subscription_id: INTEGER
success: BOOLEAN
tax_id: INTEGER
taxable_amount_in_cents: INTEGER
taxations: ARRAY, which is also a nested data structure.
- id: INTEGER
transaction_type: STRING
type: STRING

| | **updated\_at**

DATE-TIME | ### subscriptions The `subscriptions` table contains info about the subscriptions in your Chargify instance. | **Replication Method** | Full Table | | --- | --- | | **Primary Key** | id | | **Useful links** | [Chargify API method](https://reference.chargify.com/v1/subscriptions/list-subscriptions "Opens in new tab: Chargify API method") | subscriptions table foreign keys | Join subscriptions with | on | | --- | --- | | [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#customers) | ```
subscriptions.credit_card.customer_id = customers.id
```

```
subscriptions.customer.id = customers.id
```

```
subscriptions.credit_card.customer_id = customers.parent_id
```

```
subscriptions.customer.id = customers.parent_id
``` | | [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#invoices) | ```
subscriptions.credit_card.customer_id = invoices.charges.customer_id
```

```
subscriptions.customer.id = invoices.charges.customer_id
```

```
subscriptions.credit_card.customer_id = invoices.payments_and_credits.customer_id
```

```
subscriptions.customer.id = invoices.payments_and_credits.customer_id
```

```
subscriptions.next_product_id = invoices.charges.product_id
```

```
subscriptions.product.id = invoices.charges.product_id
```

```
subscriptions.next_product_id = invoices.payments_and_credits.product_id
```

```
subscriptions.product.id = invoices.payments_and_credits.product_id
```

```
subscriptions.id = invoices.charges.subscription_id
```

```
subscriptions.id = invoices.payments_and_credits.subscription_id
```

```
subscriptions.id = invoices.subscription_id
```

```
subscriptions.signup_payment_id = invoices.charges.payment_id
```

```
subscriptions.stored_credential_transaction_id = invoices.charges.payment_id
```

```
subscriptions.signup_payment_id = invoices.payments_and_credits.payment_id
```

```
subscriptions.stored_credential_transaction_id = invoices.payments_and_credits.payment_id
``` | | [statements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#statements) | ```
subscriptions.credit_card.customer_id = statements.transactions.customer_id
```

```
subscriptions.customer.id = statements.transactions.customer_id
```

```
subscriptions.next_product_id = statements.events.event.event_specific_data.product_id
```

```
subscriptions.product.id = statements.events.event.event_specific_data.product_id
```

```
subscriptions.next_product_id = statements.transactions.product_id
```

```
subscriptions.product.id = statements.transactions.product_id
```

```
subscriptions.id = statements.events.event.subscription_id
```

```
subscriptions.id = statements.subscription_id
```

```
subscriptions.id = statements.transactions.subscription_id
```

```
subscriptions.signup_payment_id = statements.transactions.id
```

```
subscriptions.stored_credential_transaction_id = statements.transactions.id
``` | | [transactions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#transactions) | ```
subscriptions.credit_card.customer_id = transactions.customer_id
```

```
subscriptions.customer.id = transactions.customer_id
```

```
subscriptions.next_product_id = transactions.product_id
```

```
subscriptions.product.id = transactions.product_id
```

```
subscriptions.id = transactions.subscription_id
```

```
subscriptions.signup_payment_id = transactions.id
```

```
subscriptions.stored_credential_transaction_id = transactions.id
```

```
subscriptions.signup_payment_id = transactions.parent_id
```

```
subscriptions.stored_credential_transaction_id = transactions.parent_id
```

```
subscriptions.signup_payment_id = transactions.payment_id
```

```
subscriptions.stored_credential_transaction_id = transactions.payment_id
``` | | [components](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#components) | ```
subscriptions.product.product_family.id = components.product_family_id
``` | | [coupons](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#coupons) | ```
subscriptions.product.product_family.id = coupons.product_family_id
``` | | [product_families](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#product-families) | ```
subscriptions.product.product_family.id = product_families.id
``` | | [products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#products) | ```
subscriptions.product.product_family.id = products.product_family.id
```

```
subscriptions.next_product_id = products.id
```

```
subscriptions.product.id = products.id
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#events) | ```
subscriptions.next_product_id = events.event_specific_data.product_id
```

```
subscriptions.product.id = events.event_specific_data.product_id
```

```
subscriptions.id = events.subscription_id
```

```
subscriptions.signup_payment_id = events.event_specific_data.account_transaction_id
```

```
subscriptions.stored_credential_transaction_id = events.event_specific_data.account_transaction_id
``` | subscriptions table schema | **activated\_at**

DATE-TIME | | --- | | **balance\_in\_cents**

INTEGER | | **cancel\_at\_end\_of\_period**

BOOLEAN | | **canceled\_at**

DATE-TIME | | **cancellation\_message**

STRING | | **cancellation\_method**

STRING | | **coupon\_codes**

STRING | | **created\_at**

DATE-TIME | | **credit\_card**

OBJECT

This is a nested data structure:

billing_address: STRING
billing_address_2: STRING
billing_city: STRING
billing_country: STRING
billing_state: STRING
billing_zip: STRING
card_type: STRING
current_vault: STRING
customer_id: INTEGER
customer_vault_token: STRING
expiration_month: NUMBER
expiration_year: NUMBER
first_name: STRING
id: INTEGER
last_name: STRING
masked_card_number: STRING
payment_type: STRING
vault_token: STRING

| | **current\_period\_ends\_at**

DATE-TIME | | **current\_period\_started\_at**

DATE-TIME | | **customer**

OBJECT

This is a nested data structure:

address: STRING
address_2: STRING
cc_emails: STRING
city: STRING
country: STRING
created_at: DATE-TIME
email: STRING
first_name: STRING
id: INTEGER
last_name: STRING
organization: STRING
phone: STRING
portal_customer_created_at: DATE-TIME
portal_invite_last_accepted_at: DATE-TIME
portal_invite_last_sent_at: DATE-TIME
reference: STRING
state: STRING
tax_exempt: BOOLEAN
updated_at: DATE-TIME
vat_number: STRING
verified: BOOLEAN
zip: STRING

accounting_code: STRING
archived_at: DATE-TIME
created_at: DATE-TIME
description: STRING
expiration_interval: INTEGER
expiration_interval_unit: STRING
handle: STRING
id: INTEGER
initial_charge_after_trial: BOOLEAN
initial_charge_in_cents: INTEGER
interval: INTEGER
interval_unit: STRING
name: STRING
price_in_cents: INTEGER
product_family: OBJECT, which is also a nested data structure.
- accounting_code: STRING
- description: STRING
- handle: STRING
- id: INTEGER
- name: STRING
public_signup_pages: ARRAY, which is also a nested data structure.
- id: INTEGER
- url: STRING
request_credit_card: BOOLEAN
require_credit_card: BOOLEAN
return_params: STRING
taxable: BOOLEAN
trial_interval: INTEGER
trial_interval_unit: STRING
trial_price_in_cents: INTEGER
update_return_params: STRING
update_return_url: STRING
updated_at: DATE-TIME
version_number: NUMBER

| | **product\_price\_in\_cents**

INTEGER | | **product\_version\_number**

INTEGER | | **reason\_code**

STRING | | **receives\_invoice\_emails**

BOOLEAN | | **referral\_code**

STRING | | **signup\_payment\_id**

NUMBER | | **signup\_revenue**

STRING | | **snap\_day**

STRING | | **state**

STRING | | **stored\_credential\_transaction\_id**

INTEGER | | **total\_revenue\_in\_cents**

INTEGER | | **trial\_ended\_at**

DATE-TIME | | **trial\_started\_at**

DATE-TIME | | **updated\_at**

DATE-TIME | ### transactions The `transactions` table contains info about the transactions for your Chargify site. | **Replication Method** | CDC | | --- | --- | | **Loading Behavior** | Append-Only | | **Primary Key** | id | | **Replication Key** | created\_at | | **Useful links** | [Chargify API method](https://reference.chargify.com/v1/transactions/list-transactions-for-the-site "Opens in new tab: Chargify API method") | transactions table foreign keys | Join transactions with | on | | --- | --- | | [components](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#components) | ```
transactions.component_id = components.id
```

```
transactions.component_id = components.prices.id
``` | | [invoices](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#invoices) | ```
transactions.component_id = invoices.charges.component_id
```

```
transactions.component_id = invoices.payments_and_credits.component_id
```

```
transactions.customer_id = invoices.charges.customer_id
```

```
transactions.customer_id = invoices.payments_and_credits.customer_id
```

```
transactions.product_id = invoices.charges.product_id
```

```
transactions.product_id = invoices.payments_and_credits.product_id
```

```
transactions.statement_id = invoices.statement_id
```

```
transactions.subscription_id = invoices.charges.subscription_id
```

```
transactions.subscription_id = invoices.payments_and_credits.subscription_id
```

```
transactions.subscription_id = invoices.subscription_id
```

```
transactions.id = invoices.charges.payment_id
```

```
transactions.parent_id = invoices.charges.payment_id
```

```
transactions.payment_id = invoices.charges.payment_id
```

```
transactions.id = invoices.payments_and_credits.payment_id
```

```
transactions.parent_id = invoices.payments_and_credits.payment_id
```

```
transactions.payment_id = invoices.payments_and_credits.payment_id
``` | | [price_points](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#price-points) | ```
transactions.component_id = price_points.component_id
```

```
transactions.component_id = price_points.prices.component_id
``` | | [statements](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#statements) | ```
transactions.component_id = statements.transactions.component_id
```

```
transactions.customer_id = statements.transactions.customer_id
```

```
transactions.product_id = statements.events.event.event_specific_data.product_id
```

```
transactions.product_id = statements.transactions.product_id
```

```
transactions.statement_id = statements.id
```

```
transactions.statement_id = statements.transactions.statement_id
```

```
transactions.subscription_id = statements.events.event.subscription_id
```

```
transactions.subscription_id = statements.subscription_id
```

```
transactions.subscription_id = statements.transactions.subscription_id
```

```
transactions.id = statements.transactions.id
```

```
transactions.parent_id = statements.transactions.id
```

```
transactions.payment_id = statements.transactions.id
``` | | [customers](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#customers) | ```
transactions.customer_id = customers.id
```

```
transactions.customer_id = customers.parent_id
``` | | [subscriptions](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#subscriptions) | ```
transactions.customer_id = subscriptions.credit_card.customer_id
```

```
transactions.customer_id = subscriptions.customer.id
```

```
transactions.product_id = subscriptions.next_product_id
```

```
transactions.product_id = subscriptions.product.id
```

```
transactions.subscription_id = subscriptions.id
```

```
transactions.id = subscriptions.signup_payment_id
```

```
transactions.parent_id = subscriptions.signup_payment_id
```

```
transactions.payment_id = subscriptions.signup_payment_id
```

```
transactions.id = subscriptions.stored_credential_transaction_id
```

```
transactions.parent_id = subscriptions.stored_credential_transaction_id
```

```
transactions.payment_id = subscriptions.stored_credential_transaction_id
``` | | [events](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#events) | ```
transactions.product_id = events.event_specific_data.product_id
```

```
transactions.subscription_id = events.subscription_id
```

```
transactions.id = events.event_specific_data.account_transaction_id
```

```
transactions.parent_id = events.event_specific_data.account_transaction_id
```

```
transactions.payment_id = events.event_specific_data.account_transaction_id
``` | | [products](https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/WebApplications/Connecting-Chargify.htm#products) | ```
transactions.product_id = products.id
``` | transactions table schema | **amount\_in\_cents**

INTEGER | | --- | | **card\_expiration**

STRING | | **card\_number**

STRING | | **card\_type**

STRING | | **component\_handle**

STRING | | **component\_id**

INTEGER | | **component\_price\_point\_handle**

STRING | | **component\_price\_point\_id**

INTEGER | | **created\_at**

DATE-TIME | | **customer\_id**

INTEGER | | **ending\_balance\_in\_cents**

INTEGER | | **gateway\_order\_id**

NUMBER | | **gateway\_transaction\_id**

STRING | | **gateway\_used**

STRING | | **id**

INTEGER | | **item\_name**

STRING | | **kind**

STRING | | **memo**

STRING | | **parent\_id**

INTEGER | | **payment\_id**

INTEGER | | **period\_range\_end**

STRING | | **period\_range\_start**

STRING | | **price\_point\_handle**

STRING | | **price\_point\_id**

INTEGER | | **product\_id**

INTEGER | | **refunded\_amount\_in\_cents**

INTEGER | | **role**

STRING | | **starting\_balance\_in\_cents**

INTEGER | | **statement\_id**

INTEGER | | **subscription\_id**

INTEGER | | **success**

BOOLEAN | | **tax\_id**

INTEGER | | **transaction\_type**

STRING | | **type**

STRING |