Fivetran documentation

Search the docs

/

ChargeDesk

Explore the interactive ERD

Table & Field Reference

agent_activity_log

Column	Type	Keys
`id`	Unknown	PK
`action_params`	Unknown
`action_reason`	Unknown
`action_type`	Unknown
`company`	Unknown
`context`	Unknown
`description`	Unknown
`event`	Unknown
`ip`	Unknown
`object_type`	Unknown
`occurred`	Instant
`params`	Unknown
`source`	Unknown
`sub_description`	Unknown

product

Column	Type	Keys
`id`	Unknown	PK
`amount`	Unknown
`amount_formatted`	Unknown
`amount_symbol`	Unknown
`billing_cycles_total`	Unknown
`chargeable`	Unknown
`charges`	Unknown
`company`	Unknown
`currency`	Unknown
`description`	Unknown
`first_seen`	Instant
`gateway_id`	Unknown
`has_agent_log`	Unknown
`interval`	Unknown
`interval_count`	Unknown
`logs`	Json
`name`	Unknown
`quantity`	Unknown
`readable_interval`	Unknown
`setup_amount`	Unknown
`status`	Unknown
`support_url`	Unknown
`taxable`	Unknown
`trial_period_days`	Unknown
`url`	Unknown

subscrption_cancellation_log

Column	Type	Keys
`customer_id`	Unknown	PKFK
`subscription_id`	Unknown	PKFK
`action`	Unknown
`email`	Unknown
`ip`	Unknown
`method`	Unknown
`occurred`	Instant
`reason`	Unknown

item

Column	Type	Keys
`id`	Unknown	PK
`subscription_id`	Unknown	FK
`amount`	Unknown
`amount_formatted`	Unknown
`currency`	Unknown
`description`	Unknown
`percents`	Unknown
`quantity`	Unknown

subscription

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`product_id`	Unknown	FK
`accurate_at`	Instant
`amount`	Unknown
`amount_formatted`	Unknown
`amount_symbol`	Unknown
`billing_cycles_current`	Unknown
`billing_cycles_total`	Unknown
`canceled_at`	Instant
`charges`	Unknown
`company`	Unknown
`currency`	Unknown
`current_period_end`	Instant
`current_period_start`	Instant
`ended_at`	Instant
`first_seen`	Instant
`gateway_id`	Unknown
`gateway_url`	Unknown
`has_items`	Unknown
`has_meta`	Unknown
`interval`	Unknown
`interval_count`	Unknown
`last_email`	Instant
`logs`	Json
`manage_url`	Unknown
`metadata`	Json
`methods_active`	Json
`methods_supported`	Json
`object`	Unknown
`product_desc`	Unknown
`quantity`	Unknown
`readable_interval`	Unknown
`setup_amount`	Unknown
`status`	Unknown
`status_text`	Unknown
`trial_end`	Instant
`trial_period_days`	Unknown
`trial_start`	Instant

customer

Column	Type	Keys
`id`	Unknown	PK
`accurate_at`	Instant
`billing_address`	Unknown
`card_on_file`	Unknown
`charges`	Unknown
`company`	Unknown
`country`	Unknown
`customer_company`	Unknown
`delinquent`	Unknown
`description`	Unknown
`edited`	Unknown
`email`	Unknown
`email_domain`	Unknown
`fax`	Unknown
`first_name`	Unknown
`first_seen`	Instant
`gateway_id`	Unknown
`gateway_url`	Unknown
`has_items`	Unknown
`invoice_details`	Unknown
`items`	Json
`last_charge_id`	Unknown
`last_paid_charge`	Unknown
`logs`	Json
`manage_url`	Unknown
`metadata`	Json
`methods_active`	Json
`methods_supported`	Json
`name`	Unknown
`object`	Unknown
`phone`	Unknown
`readable_country`	Unknown
`send_email_to`	Unknown
`shipping_address`	Unknown
`tax_number`	Unknown
`tax_number_abr`	Unknown
`tickets`	Unknown
`unsubscribe_authorize`	Unknown
`unsubscribe_receipts`	Unknown
`unsubscribe_refunds`	Unknown
`unsubscribe_void`	Unknown
`username`	Unknown
`website`	Unknown

charge_preview_tax_rate

Column	Type	Keys
`name`	Unknown	PK
`product_id`	Unknown	PKFK
`amount`	Unknown
`amount_formatted`	Unknown
`rate`	Unknown
`type`	Unknown

charge_preview

Column	Type	Keys
`_fivetran_id`	String	PK
`product_id`	Unknown	PKFK
`subtotal_amount`	Unknown
`subtotal_amount_formatted`	Unknown
`total_amount`	Unknown
`total_amount_formatted`	Unknown

charge

Column	Type	Keys
`id`	Unknown	PK
`customer_id`	Unknown	FK
`product_id`	Unknown	FK
`subscription_id`	Unknown	FK
`accurate_at`	Instant
`added_tax`	Unknown
`amount`	Unknown
`amount_formatted`	Unknown
`amount_refunded`	Unknown
`amount_refunded_formatted`	Unknown
`amount_symbol`	Unknown
`amount_with_commas`	Unknown
`audited_job`	Unknown
`company`	Unknown
`currency`	Unknown
`customer_country`	Unknown
`customer_email`	Unknown
`customer_email_domain`	Unknown
`customer_name`	Unknown
`customer_phone`	Unknown
`customer_username`	Unknown
`description`	Unknown
`email_last_sent`	Instant
`failure_reason`	Unknown
`gateway_id`	Unknown
`gateway_url`	Unknown
`invoice_company`	Unknown
`invoice_download_url`	Unknown
`invoice_url`	Unknown
`is_paid`	Unknown
`last_4_digits`	Unknown
`logs`	Json
`manage_url`	Unknown
`metadata`	Json
`methods_active`	Json
`methods_supported`	Json
`name_email`	Unknown
`name_send_email`	Unknown
`object`	Unknown
`occurred`	Instant
`occurred_formatted`	Unknown
`occurred_relative`	Unknown
`payment_method`	Unknown
`payment_method_bank`	Unknown
`payment_method_brand`	Unknown
`payment_method_describe`	Unknown
`product_desc`	Unknown
`refunded_at`	Instant
`refunded_at_formatted`	Unknown
`sent_authorize`	Unknown
`sent_dunning`	Unknown
`sent_invoice`	Unknown
`sent_invoice_reminder`	Unknown
`sent_receipt`	Unknown
`sent_refund_receipt`	Unknown
`sent_void`	Unknown
`statement_description`	Unknown
`status`	Unknown
`status_text`	Unknown
`support_email`	Unknown
`support_url`	Unknown
`transaction_id`	Unknown