Chargify
Chargify is a recurring billing and revenue management platform built specifically for B2B SaaS companies.
Chargify integration replicates data using the Chargify API.
See the Schema section for a list of objects available for replication.复制任务： 应用更改 存储更改 在数据湖任务中登陆数据： 更改数据捕获 (CDC) 必填字段。这就是目标与源的更改保持同步的方式。 有关复制任务，请参阅计划任务 有关湖登陆任务，请参阅为湖登陆任务调度 CDC 部分支持 仅 CDC，因为满负载与此连接器无关。特性/功能 支持详情 支持的 Qlik Talend Data Integration 项目 仅 Replication 项目。不支持数据管道项目。 无需手动生成元数据。 只支持更改列数据类型操作。 复制 LOB 列（NCLOB、CLOB 和 BLOB） 不支持 已计划 CDC 通知 监视 JSON 列有效载荷的自动解密 不支持不会自动在目标上删除源数据集中的 JSON 列有效负载。
Preparing for authentication
To access your data, you need to authenticate the connection with your account credentials.
Creating the connection
有关更多信息，请参阅连接到 SaaS 应用程序。
- 填写所需的连接属性。
在连接名称中提供连接的名称。
选择打开连接元数据以定义创建连接时的元数据。
单击创建。
| Setting | Description |
|---|---|
| Data gateway | 如果您的用例需要，请选择一个 数据移动网关。 信息注释 此字段不适用于 Qlik Talend Cloud Starter 订阅，因为它不支持 数据移动网关。如果您有另一个订阅层并且不想使用 数据移动网关，请选择无。 有关 数据移动网关 的优势和需要它的用例的信息，请参阅Qlik 数据网关 - 数据移动。 |
| Start Date | 按格式 |
| 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
Schemas and naming conventions can change from version to version. It is recommended to verify your version before continuing.
The schema and info displayed below is for version 1.
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 |
| Join components with | on |
|---|---|
| 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 | 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 | components.id = statements.transactions.component_id components.prices.id = statements.transactions.component_id |
| transactions | components.id = transactions.component_id components.prices.id = transactions.component_id |
| coupons | components.product_family_id = coupons.product_family_id |
| product_families | components.product_family_id = product_families.id |
| products | components.product_family_id = products.product_family.id |
| subscriptions | components.product_family_id = subscriptions.product.product_family.id |
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:
|
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 |
| Join coupons with | on |
|---|---|
| components | coupons.product_family_id = components.product_family_id |
| product_families | coupons.product_family_id = product_families.id |
| products | coupons.product_family_id = products.product_family.id |
| subscriptions | coupons.product_family_id = subscriptions.product.product_family.id |
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:
|
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 |
| Join customers with | on |
|---|---|
| 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 | customers.id = statements.transactions.customer_id customers.parent_id = statements.transactions.customer_id |
| 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 | customers.id = transactions.customer_id customers.parent_id = transactions.customer_id |
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 |
| Join events with | on |
|---|---|
| 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 | 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 | events.event_specific_data.product_id = products.id |
| 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 | 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 |
created_at DATE-TIME |
event_specific_data OBJECT This is a nested data structure:
|
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 |
| Join invoices with | on |
|---|---|
| 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 | 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 | 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 | 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 | 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 | 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 | 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 | invoices.charges.product_id = products.id invoices.payments_and_credits.product_id = products.id |
amount_due_in_cents INTEGER |
charges ARRAY This is a nested data structure:
|
created_at DATE-TIME |
id INTEGER |
number STRING |
paid_at DATE-TIME |
payments_and_credits ARRAY This is a nested data structure:
|
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 |
| Join price_points with | on |
|---|---|
| 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 | 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 | price_points.component_id = statements.transactions.component_id price_points.prices.component_id = statements.transactions.component_id |
| transactions | price_points.component_id = transactions.component_id price_points.prices.component_id = transactions.component_id |
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:
|
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 |
| Join product_families with | on |
|---|---|
| components | product_families.id = components.product_family_id |
| coupons | product_families.id = coupons.product_family_id |
| products | product_families.id = products.product_family.id |
| subscriptions | product_families.id = subscriptions.product.product_family.id |
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 |
| Join products with | on |
|---|---|
| components | products.product_family.id = components.product_family_id |
| coupons | products.product_family.id = coupons.product_family_id |
| product_families | products.product_family.id = product_families.id |
| subscriptions | products.product_family.id = subscriptions.product.product_family.id products.id = subscriptions.next_product_id products.id = subscriptions.product.id |
| events | products.id = events.event_specific_data.product_id |
| invoices | products.id = invoices.charges.product_id products.id = invoices.payments_and_credits.product_id |
| statements | products.id = statements.events.event.event_specific_data.product_id products.id = statements.transactions.product_id |
| transactions | products.id = transactions.product_id |
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:
|
public_signup_pages ARRAY This is a nested data structure:
|
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 |
| Join statements with | on |
|---|---|
| components | statements.transactions.component_id = components.id statements.transactions.component_id = components.prices.id |
| 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 | statements.transactions.component_id = price_points.component_id statements.transactions.component_id = price_points.prices.component_id |
| 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 | statements.transactions.customer_id = customers.id statements.transactions.customer_id = customers.parent_id |
| 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 | 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 | statements.events.event.event_specific_data.product_id = products.id statements.transactions.product_id = products.id |
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:
|
future_payments ARRAY This is a nested data structure:
|
html_view STRING |
id INTEGER |
memo STRING |
opened_at DATE-TIME |
settled_at DATE-TIME |
starting_balance_in_cents INTEGER |
subscription_id INTEGER |
text_view STRING |
total_in_cents INTEGER |
transactions ARRAY This is a nested data structure:
|
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 |
| Join subscriptions with | on |
|---|---|
| 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 | 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 | 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 | 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 | subscriptions.product.product_family.id = components.product_family_id |
| coupons | subscriptions.product.product_family.id = coupons.product_family_id |
| product_families | subscriptions.product.product_family.id = product_families.id |
| products | subscriptions.product.product_family.id = products.product_family.id subscriptions.next_product_id = products.id subscriptions.product.id = products.id |
| 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 |
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:
|
current_period_ends_at DATE-TIME |
current_period_started_at DATE-TIME |
customer OBJECT This is a nested data structure:
|
delayed_cancel_at DATE-TIME |
expires_at DATE-TIME |
id INTEGER |
net_terms INTEGER |
next_assessment_at DATE-TIME |
next_product_id INTEGER |
payment_collection_method STRING |
payment_type STRING |
previous_state STRING |
product OBJECT This is a nested data structure:
|
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 |
| Join transactions with | on |
|---|---|
| components | transactions.component_id = components.id transactions.component_id = components.prices.id |
| 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 | transactions.component_id = price_points.component_id transactions.component_id = price_points.prices.component_id |
| 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 | transactions.customer_id = customers.id transactions.customer_id = customers.parent_id |
| 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 | 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 | transactions.product_id = products.id |
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 |