Please enable JavaScript to view this site.

Chargebee API Data Model

Navigation: Schema: Subscriptions > Tables

Subscriptions: Chargebee Subscriptions

Contents Previous Home Next More

Catalog: Chargebee

Schema: Subscriptions

Primary Keys: id

Label: Subscriptions

Can retrieve data and change data using insert, update and delete.

Select Chargebee API URL: /subscriptions

Insert Chargebee API URL: /subscriptions

Update Chargebee API URL: /subscriptions

Delete Chargebee API URL: /subscriptions

Field Selection Method: NotRequired

Base Path: list[*].subscription

Table Columns

The columns of the table Subscriptions are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert or update.

Name

Data Type

Label

Required

Documentation

activated_at

datetime

Activated at

 

affiliate_token

string

Affiliate Token

 

auto_collection

string

Auto Collection

 

base_currency_code

string

Base Currency Code

 

billing_period

int16

Billing Period

 

billing_period_unit

string

Billing Period Unit

 

cancel_reason

string

Cancel Reason

 

cancel_reason_code

string

Cancel Reason Code

 

cancelled_at

datetime

Cancelled at

 

cf_main_subscription

string

 

 

cf_nonrenewing

boolean

 

 

cf_renewal_date

datetime

 

 

contract_term_action_at_term_end

string

Contract Term Action at Term End

 

contract_term_billing_cycle

int32

Contract Term Billing Cycle

 

contract_term_billing_cycle_on_renewal

int32

Contract Term Billing Cycle on Renewal

 

contract_term_cancellation_cutoff_period

int32

Contract Term Cancellation Cut-off Period

 

contract_term_contract_end

datetime

Contract Term Contract End

 

contract_term_contract_start

datetime

Contract Term Contract Start

 

contract_term_created_at

datetime

Contract Term Created at

 

contract_term_id

string

Contract Term ID

 

contract_term_remaining_billing_cycles

int32

Contract Term Remaining Billing Cycles

 

contract_term_status

string

Contract Term Status

 

contract_term_subscription_id

string

Contract Term Subscription ID

 

contract_term_total_contract_value

decimal

Contract Term Total Contract Value

 

created_at

datetime

Created at

 

created_from_ip

string

Created From IP

 

currency_code

string

Currency Code

 

current_term_end

datetime

Current Term End

 

current_term_start

datetime

Current Term Start

 

customer_id

string

Customer ID

 

deleted

boolean

Deleted

 

due_invoices_count

int32

Due Invoices Count

 

due_since

datetime

Due Since

 

exchange_rate

decimal

Exchange Rate

 

free_period

int32

Free Period

 

free_period_unit

string

Free Period Unit

 

gift_id

string

Gift ID

 

has_scheduled_changes

boolean

Has Scheduled Changes

 

id

string

ID

 

invoice_notes

string

Invoice Notes

 

meta_data

string

Meta Data

 

mrr

int32

MRR

 

next_billing_at

datetime

Next Billing at

 

offline_payment_method

string

Offline Payment Method

 

override_relationship

boolean

Override Relationship

 

pause_date

datetime

Pause Date

 

payment_source_id

string

Payment Source ID

 

plan_amount

decimal

Plan Amount

 

plan_amount_in_decimal

string

Plan Amount in Decimal

 

plan_free_quantity

int32

Plan Free Quantity

 

plan_free_quantity_in_decimal

string

Plan Free Quantity in Decimal

 

plan_id

string

Plan ID

 

plan_quantity

int32

Plan Quantity

 

plan_quantity_in_decimal

string

Plan Quantity in Decimal

 

plan_unit_price

decimal

Plan Unit Price

 

plan_unit_price_in_decimal

string

Plan Unit Price in Decimal

 

po_number

string

PO Number

 

referral_info_account_id

string

Referral Info Account ID

 

referral_info_campaign_id

string

Referral Info Campaign ID

 

referral_info_coupon_code

string

Referral Info Coupon Code

 

referral_info_destination_url

string

Referral Info Destination URL

 

referral_info_external_campaign_id

string

Referral Info External Campaign ID

 

referral_info_external_reference_id

string

Referral Info External Reference ID

 

referral_info_friend_offer_type

string

Referral Info Friend Offer Type

 

referral_info_notify_referral_system

string

Referral Info Notify Referral System

 

referral_info_post_purchase_widget_enabled

boolean

Referral Info Post Purchase Widget Enabled

 

referral_info_referral_code

string

Referral Info Referral Code

 

referral_info_referral_system

string

Referral Info Referral System

 

referral_info_referrer_id

string

Referral Info Referrer ID

 

referral_info_referrer_reward_type

string

Referral Info Referrer Reward Type

 

referral_info_reward_status

string

Referral Info Reward Status

 

remaining_billing_cycles

int32

Remaining Billing Cycles

 

resource_version

int64

Resource Version

 

resume_date

datetime

Resume Date

 

setup_fee

decimal

Setup Fee

 

shipping_address_city

string

Shipping Address City

 

shipping_address_company

string

Shipping Address Company

 

shipping_address_country

string

Shipping Address Country

 

shipping_address_email

string

Shipping Address Email

 

shipping_address_first_name

string

Shipping Address First Name

 

shipping_address_last_name

string

Shipping Address Last Name

 

shipping_address_line1

string

Shipping Address Line 1

 

shipping_address_line2

string

Shipping Address Line 2

 

shipping_address_phone

string

Shipping Address Phone

 

shipping_address_state

string

Shipping Address State

 

shipping_address_validation_status

string

Shipping Address Validation Status

 

shipping_address_zip

string

Shipping Address ZIP Code

 

start_date

datetime

Start Date

 

started_at

datetime

Started at

 

status

string

Status

 

total_dues

int32

Total Dues

 

trial_end

datetime

Trial End

 

trial_start

datetime

Trial Start

 

updated_at

datetime

Updated at

 

 

12-12-2020 18:45 Version 20.1.301-BETA+3023