---
title: "Subscriptions (Chargebee)"
description: "Subscriptions"
language: nl
source_language: en
translation_state: pending
canonical: https://documentation.invantive.eu/nl/datamodels/chargebee/Chargebee.Subscriptions.Subscriptions
original: https://documentation.invantive.eu/en/datamodels/chargebee/Chargebee.Subscriptions.Subscriptions
updated: 2026-11-16T20:40:33Z
license: https://documentation.invantive.eu/nl/
---

# Subscriptions: Chargebee Subscriptions

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

- Catalogus: `Chargebee`
- Schema: `Subscriptions`
- Primaire sleutels: `id`
- Label: Subscriptions

Je kunt gegevens ophalen en wijzigen met `insert`, `update` en `delete`.

## API-bron

- Eindpunt: `/subscriptions`

## Tabelkolommen

De kolommen van de tabel `Subscriptions` worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

| Name | Datatype | Label | Required | Marks | Documentation |
|---|---|---|:---:|---|---|
| `activated_at` | `datetime` | Geactiveerd om | [ ] |  |  |
| `active_id` | `varchar2(50)` | itgen_cbe_active_id | [ ] |  | Represents the id of the active version of the customer resource. |
| `affiliate_token` | `varchar2` | Affiliate Token | [ ] |  |  |
| `auto_close_invoices` | `char` | itgen_cbe_auto_close_invoices | [ ] |  |  |
| `auto_collection` | `varchar2` | Automatische Verzameling | [ ] |  |  |
| `base_currency_code` | `varchar2` | Basisvalutacode | [ ] |  |  |
| `billing_period` | `int16` | Factuurperiode | [ ] |  |  |
| `billing_period_unit` | `varchar2` | Factureringsperiode Eenheid | [ ] |  |  |
| `business_entity_id` | `varchar2` | itgen_cbe_business_entity_id | [ ] |  |  |
| `cancel_reason` | `varchar2` | Annuleringsreden | [ ] |  |  |
| `cancel_reason_code` | `varchar2` | Annuleringsredencode | [ ] |  |  |
| `cancel_schedule_created_at` | `datetime` | itgen_cbe_cancel_schedule_created_at | [ ] |  |  |
| `cancelled_at` | `datetime` | Geannuleerd om | [ ] |  |  |
| `changes_scheduled_at` | `datetime` | itgen_cbe_changes_scheduled_at | [ ] |  |  |
| `channel` | `varchar2(30)` | itgen_cbe_channel | [ ] |  | The subscription channel this object originated from and is maintained in.Possible values are: web, app_store or play_store. |
| `contract_term_action_at_term_end` | `varchar2` | Contractduur Actie aan Einde Looptijd | [ ] |  |  |
| `contract_term_billing_cycle` | `int32` | Factureringscyclus Contracttermijn | [ ] |  |  |
| `contract_term_billing_cycle_on_renewal` | `int32` | Factureringscyclus voor Contracttermijn bij Verlenging | [ ] |  |  |
| `contract_term_cancellation_cutoff_period` | `int32` | Contracttermijn Annulering Uiterste Periode | [ ] |  |  |
| `contract_term_contract_end` | `datetime` | Contractduur Contracteinde | [ ] |  |  |
| `contract_term_contract_start` | `datetime` | Contractduur Contractbegin | [ ] |  |  |
| `contract_term_created_at` | `datetime` | Contracttermijn Gemaakt op | [ ] |  |  |
| `contract_term_id` | `varchar2` | Contracttermijn ID | [ ] |  |  |
| `contract_term_remaining_billing_cycles` | `int32` | Contractduur Resterende Factureringscycli | [ ] |  |  |
| `contract_term_status` | `varchar2` | Status Contracttermijn | [ ] |  |  |
| `contract_term_subscription_id` | `varchar2` | Contractduur Abonnements ID Termijn | [ ] |  |  |
| `contract_term_total_contract_value` | `decimal` | Contractduur Totale Contractwaarde | [ ] |  |  |
| `contract_term_total_contract_value_before_tax` | `decimal` | itgen_cbe_contract_term_total_contract_value_before_tax | [ ] |  |  |
| `create_pending_invoices` | `char` | itgen_cbe_create_pending_invoices | [ ] |  |  |
| `created_at` | `datetime` | Aangemaakt op | [ ] |  |  |
| `created_from_ip` | `varchar2` | Gemaakt van IP | [ ] |  |  |
| `currency_code` | `varchar2` | Valuta Code | [ ] |  |  |
| `current_term_end` | `datetime` | Einde Huidige Termijn | [ ] |  |  |
| `current_term_start` | `datetime` | Start Huidige Termijn | [ ] |  |  |
| `customer_id` | `varchar2` | Klant ID | [ ] |  |  |
| `deleted` | `char` | Deleted | [ ] |  |  |
| `due_invoices_count` | `int32` | Vervallen Facturen Aantal | [ ] |  |  |
| `due_since` | `datetime` | Vervallen sinds | [ ] |  |  |
| `exchange_rate` | `decimal` | Wisselkoers | [ ] |  |  |
| `free_period` | `int32` | Gratis Periode | [ ] |  |  |
| `free_period_unit` | `varchar2` | Gratis Periode-eenheid | [ ] |  |  |
| `gift_id` | `varchar2` | Cadeau ID | [ ] |  |  |
| `has_scheduled_advance_invoices` | `char` | itgen_cbe_has_scheduled_advance_invoices | [ ] |  |  |
| `has_scheduled_changes` | `char` | Heeft Geplande Wijzigingen | [ ] |  |  |
| `id` | `varchar2` | ID | [x] |  |  |
| `invoice_notes` | `varchar2` | Factuurnotities | [ ] |  |  |
| `meta_data` | `varchar2` | Metagegevens | [ ] |  |  |
| `mrr` | `int32` | MRR | [ ] |  |  |
| `net_term_days` | `int32` | Netto Termijn Dagen | [ ] |  |  |
| `next_billing_at` | `datetime` | Volgende Factuur op | [ ] |  |  |
| `offline_payment_method` | `varchar2` | Offline Betaalmethode | [ ] |  |  |
| `override_relationship` | `char` | Relatie Neger | [ ] |  |  |
| `pause_date` | `datetime` | Pauzedatum | [ ] |  |  |
| `payment_source_id` | `varchar2` | Betalingsbron ID | [ ] |  |  |
| `plan_amount` | `decimal` | Planbedrag | [ ] |  |  |
| `plan_amount_in_decimal` | `varchar2` | Planbedrag in Decimaal | [ ] |  |  |
| `plan_free_quantity` | `int32` | Plan Gratis Hoeveelheid | [ ] |  |  |
| `plan_free_quantity_in_decimal` | `varchar2` | Gratis Planhoeveelheid in Decimalen | [ ] |  |  |
| `plan_id` | `varchar2` | Plan ID | [ ] |  |  |
| `plan_quantity` | `int32` | Planhoeveelheid | [ ] |  |  |
| `plan_quantity_in_decimal` | `varchar2` | Planhoeveelheid in Decimalen | [ ] |  |  |
| `plan_unit_price` | `decimal` | Plan Eenheidsprijs | [ ] |  |  |
| `plan_unit_price_in_decimal` | `varchar2` | Eenheidsprijs Plannen in Decimalen | [ ] |  |  |
| `po_number` | `varchar2` | PO Nummer | [ ] |  |  |
| `referral_info_account_id` | `varchar2` | Verwijzingsinfo Account ID | [ ] |  |  |
| `referral_info_campaign_id` | `varchar2` | Campagne ID voor Verwijzingsgegevens | [ ] |  |  |
| `referral_info_coupon_code` | `varchar2` | Verwijzingsinfo Couponcode | [ ] |  |  |
| `referral_info_destination_url` | `varchar2` | Verwijzingsinfo Bestemmings-URL | [ ] |  |  |
| `referral_info_external_campaign_id` | `varchar2` | Verwijzingsinformatie Externe Campagne ID | [ ] |  |  |
| `referral_info_external_reference_id` | `varchar2` | Verwijzingsinfo Externe referentie-ID | [ ] |  |  |
| `referral_info_friend_offer_type` | `varchar2` | Verwijzingsinfo Vriendaanbiedingsoort | [ ] |  |  |
| `referral_info_notify_referral_system` | `varchar2` | Verwijzingsinfo Verwijzingssysteem Informeren | [ ] |  |  |
| `referral_info_post_purchase_widget_enabled` | `char` | Verwijzingsinfo Widget na Aankoop Ingeschakeld | [ ] |  |  |
| `referral_info_referral_code` | `varchar2` | Verwijzingsinformatie Verwijzingscode | [ ] |  |  |
| `referral_info_referral_system` | `varchar2` | Verwijzingsinformatie Verwijzingssysteem | [ ] |  |  |
| `referral_info_referrer_id` | `varchar2` | Verwijzingsinformatie Verwijzings ID | [ ] |  |  |
| `referral_info_referrer_reward_type` | `varchar2` | Verwijzingsinformatie Verwijzer Beloningssoort | [ ] |  |  |
| `referral_info_reward_status` | `varchar2` | Verwijzingsinformatie Beloningsstatus | [ ] |  |  |
| `remaining_billing_cycles` | `int32` | Resterende Factureringscycli | [ ] |  |  |
| `resource_version` | `int64` | Bronversie | [ ] |  |  |
| `resume_date` | `datetime` | Hervattingsdatum | [ ] |  |  |
| `setup_fee` | `decimal` | Installatiekosten | [ ] |  |  |
| `shipping_address_city` | `varchar2` | Verzendadres Stad | [ ] |  |  |
| `shipping_address_company` | `varchar2` | Verzendadres Bedrijf | [ ] |  |  |
| `shipping_address_country` | `varchar2` | Verzendadres Land | [ ] |  |  |
| `shipping_address_email` | `varchar2` | Verzendadres E-mail | [ ] |  |  |
| `shipping_address_first_name` | `varchar2` | Verzendadres Voornaam | [ ] |  |  |
| `shipping_address_last_name` | `varchar2` | Verzendadres Achternaam | [ ] |  |  |
| `shipping_address_line1` | `varchar2` | Verzendadresregel 1 | [ ] |  |  |
| `shipping_address_line2` | `varchar2` | Verzendadresregel 2 | [ ] |  |  |
| `shipping_address_phone` | `varchar2` | Verzendadres Telefoon | [ ] |  |  |
| `shipping_address_state` | `varchar2` | Verzendadres Staat | [ ] |  |  |
| `shipping_address_state_code` | `varchar2` | itgen_cbe_shipping_address_state_code | [ ] |  |  |
| `shipping_address_validation_status` | `varchar2` | Verzendadres Validatiestatus | [ ] |  |  |
| `shipping_address_zip` | `varchar2` | Verzendadres Postcode | [ ] |  |  |
| `start_date` | `datetime` | Startdatum | [ ] |  |  |
| `started_at` | `datetime` | Begint om | [ ] |  |  |
| `status` | `varchar2` | Status | [ ] |  |  |
| `total_dues` | `int32` | Totale Contributie | [ ] |  |  |
| `trial_end` | `datetime` | Einde Proef | [ ] |  |  |
| `trial_end_action` | `varchar2(30)` | itgen_cbe_trial_end_action | [ ] |  | Applicable only when End-of-trial Action has been enabled for the site.Specifies the operation to be carried out for the subscription once the trial ends.Whenever the item.type is plan and a trial period is defined for this item price, this attribute (parameter) is returned (required).This can be overridden at the subscription-level.Possible values are: site_default, activate_subscription or cancel_subscription. |
| `trial_start` | `datetime` | Start Proef | [ ] |  |  |
| `updated_at` | `datetime` | Bijgewerkt op | [ ] |  |  |


## Release Notes

Wat is er per release veranderd in de tabellen, kolommen, attributen en mogelijkheden van de driver:

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