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