Please enable JavaScript to view this site.

Chargebee Forums

Navigation: Schema: Plans > Tables

Plans: Chargebee Plans

Catalog: Chargebee

Schema: Plans

Primary Keys: id

Label: Plans

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

Table Columns

The columns of the table Plans 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 and update.

Name

Data Type

Label

Required

Documentation

accounting_category1

string

Accounting Category 1

 

accounting_category2

string

Accounting Category 2

 

accounting_code

string

Accounting Code

 

addon_applicability

string

Add-on Applicability

 

archived_at

datetime

Archived at

 

avalara_sale_type

string

Avalara Sale Type

 

avalara_service_type

int32

Avalara Service Type

 

avalara_transaction_type

int32

Avalara Transaction Type

 

billing_cycles

int32

Billing Cycles

 

claim_url

string

Claim URL

 

currency_code

string

Currency Code

 

description

string

Description

 

enabled_in_hosted_pages

boolean

Enabled in Hosted Pages

 

enabled_in_portal

boolean

Enabled in Portal

 

free_quantity_in_decimal

string

Free Quantity in Decimal

 

free_quantity

int32

Free Quantity

 

giftable

boolean

Giftable

 

id

string

ID

 

invoice_name

string

Invoice Name

 

invoice_notes

string

Invoice Notes

 

is_shippable

boolean

Is Shippable

 

name

string

Name

 

period_unit

string

Period Unit

 

period

int32

Period

 

price_in_decimal

string

Price in Decimal

 

price

decimal

Price

 

pricing_model

string

Pricing Model

 

redirect_url

string

Redirect URL

 

resource_version

int64

Resource Version

 

setup_cost

decimal

Setup Cost

 

shipping_frequency_period_unit

string

Shipping Frequency Period Unit

 

shipping_frequency_period

int32

Shipping Frequency Period

 

show_description_in_invoices

boolean

Show Description in Invoices

 

show_description_in_quotes

boolean

Show Description in Quotes

 

sku

string

SKU

 

status

string

Status

 

tax_code

string

Tax Code

 

tax_profile_id

string

Tax Profile ID

 

taxable

boolean

Taxable

 

taxjar_product_code

string

Taxjar Product Code

 

trial_period_unit

string

Trial Period Unit

 

trial_period

int32

Trial Period

 

updated_at

datetime

Updated at

 

 

10-06-2024 18:44 Version 24.1.3-BETA+4689

X

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

  • Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
  • Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
  • Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
  • Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
  • Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
  • Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
  • Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
  • Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

  
Disclaimer