---
title: "Plans (Chargebee)"
description: "Plans"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/chargebee/Chargebee.Plans.Plans
original: https://documentation.invantive.eu/en/datamodels/chargebee/Chargebee.Plans.Plans
updated: 2024-06-10T18:44:26Z
license: https://documentation.invantive.eu/en/
---

# Plans: Chargebee Plans

`insert` `update` `delete` `REST`

- Catalog: `Chargebee`
- Schema: `Plans`
- Primary Keys: `id`
- Label: Plans

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

## API Source

- Endpoint: `/plans`

## 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 | Marks | Documentation |
|---|---|---|:---:|---|---|
| `accounting_category1` | `varchar2` | Accounting Category 1 | [ ] |  |  |
| `accounting_category2` | `varchar2` | Accounting Category 2 | [ ] |  |  |
| `accounting_code` | `varchar2` | Accounting Code | [ ] |  |  |
| `addon_applicability` | `varchar2` | Add-on Applicability | [ ] |  |  |
| `archived_at` | `datetime` | Archived at | [ ] |  |  |
| `avalara_sale_type` | `varchar2` | Avalara Sale Type | [ ] |  |  |
| `avalara_service_type` | `int32` | Avalara Service Type | [ ] |  |  |
| `avalara_transaction_type` | `int32` | Avalara Transaction Type | [ ] |  |  |
| `billing_cycles` | `int32` | Billing Cycles | [ ] |  |  |
| `claim_url` | `varchar2` | Claim URL | [ ] |  |  |
| `currency_code` | `varchar2` | Currency Code | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `enabled_in_hosted_pages` | `char` | Enabled in Hosted Pages | [ ] |  |  |
| `enabled_in_portal` | `char` | Enabled in Portal | [ ] |  |  |
| `free_quantity` | `int32` | Free Quantity | [ ] |  |  |
| `free_quantity_in_decimal` | `varchar2` | Free Quantity in Decimal | [ ] |  |  |
| `giftable` | `char` | Giftable | [ ] |  |  |
| `id` | `varchar2` | ID | [x] |  |  |
| `invoice_name` | `varchar2` | Invoice Name | [ ] |  |  |
| `invoice_notes` | `varchar2` | Invoice Notes | [ ] |  |  |
| `is_shippable` | `char` | Is Shippable | [ ] |  |  |
| `name` | `varchar2` | Name | [ ] |  |  |
| `period` | `int32` | Period | [ ] |  |  |
| `period_unit` | `varchar2` | Period Unit | [ ] |  |  |
| `price` | `decimal` | Price | [ ] |  |  |
| `price_in_decimal` | `varchar2` | Price in Decimal | [ ] |  |  |
| `pricing_model` | `varchar2` | Pricing Model | [ ] |  |  |
| `redirect_url` | `varchar2` | Redirect URL | [ ] |  |  |
| `resource_version` | `int64` | Resource Version | [ ] |  |  |
| `setup_cost` | `decimal` | Setup Cost | [ ] |  |  |
| `shipping_frequency_period` | `int32` | Shipping Frequency Period | [ ] |  |  |
| `shipping_frequency_period_unit` | `varchar2` | Shipping Frequency Period Unit | [ ] |  |  |
| `show_description_in_invoices` | `char` | Show Description in Invoices | [ ] |  |  |
| `show_description_in_quotes` | `char` | Show Description in Quotes | [ ] |  |  |
| `sku` | `varchar2` | SKU | [ ] |  |  |
| `status` | `varchar2` | Status | [ ] |  |  |
| `tax_code` | `varchar2` | Tax Code | [ ] |  |  |
| `tax_profile_id` | `varchar2` | Tax Profile ID | [ ] |  |  |
| `taxable` | `char` | Taxable | [ ] |  |  |
| `taxjar_product_code` | `varchar2` | Taxjar Product Code | [ ] |  |  |
| `trial_period` | `int32` | Trial Period | [ ] |  |  |
| `trial_period_unit` | `varchar2` | Trial Period Unit | [ ] |  |  |
| `updated_at` | `datetime` | Updated at | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Chargebee](/en/release-notes/drivers?driver=chargebee)

