invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

Chargebee Data Model

Authentication Authentication is done using an API key. An API key can be found and/or registered on https://SERVER/apikeys_and_webhooks/api. The API key is valid for a specific site. The Chargebee API key can be configured in settings.xml as the value of defaultPassword attribute of the database element. The site is derived from the connection string attribute 'server'. Beware that after deleting records, Chargebee can still return those records for some time (at least 5 seconds).

Stel dit platform in Invantive Cloud in: https://cloud.invantive.com/chargebee

Bij tekstvergelijkingen op dit platform wordt onderscheid gemaakt tussen hoofdletters en kleine letters.

Platform

  • Te gebruiken vanuit: Invantive Cloud en de Invantive-producten op uw eigen computer of server.
  • Type: een applicatie die via de API toegankelijk is.
  • De gegevens zijn onderverdeeld, bijvoorbeeld per bedrijf of per overheidsinstantie.
  • Gegevens kunnen zowel worden geschreven als gelezen.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.chargebee.com/.

Cijfers

Figure Count
Tables 114
Columns 1,534

Poster met datamodel

In dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties worden afgeleid uit de namen van de kolommen.

PDF, 1 A0-vel

Op een tabel op de poster: in- en uitzoomen, verplaatsen met de pijltjestoetsen, 0 past.

Chargebee Datamodel, Pagina 1 van 1Chargebee Datamodelvoor gebruik met Invantive UniversalSQLPersbericht 24.1.3-BETA+4689 · 10-06-2024Abonnement · Factuur · Quote · Klant · Volgorde · Ramp · Coupon · Plan · Transactie · Payment · Overige · Addon · InkoopPagina 1 van 1 · documentation.invantive.euAbonnementChargebee.Entitlements.EntitlementOverrides: Entitlement OverridesEntitlementOverridesChargebee.Entitlements.Entitlements: EntitlementsEntitlementsChargebee.Entitlements.FeatureLevels: Feature LevelsFeatureLevelsChargebee.Entitlements.Features: FeaturesFeaturesChargebee.Entitlements.SubscriptionEntitlements: Subscription EntitlementsSubscriptionEntitlementsChargebee.Subscriptions.SubscriptionAddons: Subscription Add-onsSubscriptionAddonsChargebee.Subscriptions.SubscriptionChargedEventBasedAddons: Subscription-charged Event-based Add-onsSubscriptionChargedEventBasedAdd…Chargebee.Subscriptions.SubscriptionChargedItems: Subscription ItemsSubscriptionChargedItemsChargebee.Subscriptions.SubscriptionCoupons: Subscription CouponsSubscriptionCouponsChargebee.Subscriptions.SubscriptionCustomFieldValues: Subscription Custom FieldsSubscriptionCustomFieldValuesChargebee.Subscriptions.SubscriptionDiscounts: Subscription ItemsSubscriptionDiscountsChargebee.Subscriptions.SubscriptionEventBasedAddons: Subscription Event-based Add-onsSubscriptionEventBasedAddonsChargebee.Subscriptions.SubscriptionItemTiers: Subscription ItemsSubscriptionItemTiersChargebee.Subscriptions.SubscriptionItems: Subscription ItemsSubscriptionItemsChargebee.Subscriptions.Subscriptions: SubscriptionsSubscriptionsChargebee.Customers.CustomersCChargebee.Coupons.Coupons: CouponsCouponsCouponChargebee.Gifts.Gifts: GiftsGiftsVolgordeChargebee.Plans.Plans: PlansPlansPlanFactuurChargebee.Invoices.Installments: Installment ConfigurationsInstallmentsChargebee.Invoices.InvoiceAdjustmentCreditNotes: Invoice Adjustment Credit NotesInvoiceAdjustmentCreditNotesChargebee.Invoices.InvoiceAppliedCredits: Invoice Applied CreditsInvoiceAppliedCreditsChargebee.Invoices.InvoiceCreditNotes: Invoice Credit NotesInvoiceCreditNotesChargebee.Invoices.InvoiceDiscounts: Invoice DiscountsInvoiceDiscountsChargebee.Invoices.InvoiceDunningAttempts: Invoice Dunning AttemptsInvoiceDunningAttemptsChargebee.Invoices.InvoiceLineItemDiscounts: Invoice Line Item DiscountsInvoiceLineItemDiscountsChargebee.Invoices.InvoiceLineItemTaxes: Invoice Line Item TaxesInvoiceLineItemTaxesChargebee.Invoices.InvoiceLineItemTiers: Invoice Line Item TiersInvoiceLineItemTiersChargebee.Invoices.InvoiceLineItems: Invoice Line ItemsInvoiceLineItemsChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSChargebee.Invoices.InvoiceLinkedOrders: Invoice Linked OrdersInvoiceLinkedOrdersChargebee.Invoices.InvoiceLinkedPayments: Invoice Linked PaymentsInvoiceLinkedPaymentsChargebee.Invoices.InvoiceNotes: Invoice NotesInvoiceNotesChargebee.Invoices.InvoiceTaxes: Invoice TaxesInvoiceTaxesChargebee.Invoices.Invoices: InvoicesInvoicesChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSChargebee.Coupons.Coupons: CouponsCouponsCouponChargebee.Transactions.Transactions: Subscription Add-onsTransactionsTransactieChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSQuoteChargebee.Invoices.QuoteLineItemTiers: Quote Line Item TiersQuoteLineItemTiersChargebee.Quotes.QuoteDiscounts: Quote DiscountsQuoteDiscountsChargebee.Quotes.QuoteLineItemDiscounts: Quote Line Item DiscountsQuoteLineItemDiscountsChargebee.Quotes.QuoteLineItemTaxes: Quote Line Item TaxesQuoteLineItemTaxesChargebee.Quotes.QuoteLineItems: Quote Line ItemsQuoteLineItemsChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSChargebee.Quotes.QuoteNotes: Quote NotesQuoteNotesChargebee.Quotes.QuoteTaxes: Quote TaxesQuoteTaxesChargebee.Quotes.Quotes: QuotesQuotesChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSChargebee.Coupons.Coupons: CouponsCouponsCouponChargebee.Invoices.Invoices: InvoicesInvoicesFactuurChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSKlantChargebee.CreditNotes.CreditNotes: Credit NotesCreditNotesChargebee.Subscriptions.SubscriptionsSChargebee.Customers.Cards: CardsCardsChargebee.Customers.CustomerBalances: Customer BalancesCustomerBalancesChargebee.Customers.CustomerContacts: Customer ContactsCustomerContactsChargebee.Customers.CustomerCustomFieldValues: Customer Custom FieldsCustomerCustomFieldValuesChargebee.Customers.CustomerReferralUrls: Customer Referral URLsCustomerReferralUrlsChargebee.Customers.Customers: CustomersCustomersChargebee.PromotionalCredits.PromotionalCredits: Promotional CreditsPromotionalCreditsChargebee.UnbilledCharges.UnbilledCharges: Unbilled ChargesUnbilledChargesChargebee.Subscriptions.SubscriptionsSChargebee.VirtualBankAccounts.VirtualBankAccounts: Virtual Bank AccountsVirtualBankAccountsVolgordeChargebee.Gifts.GiftTimelines: Gift TimelinesGiftTimelinesChargebee.Gifts.Gifts: GiftsGiftsChargebee.Orders.OrderLineItemDiscounts: Order Line Item DiscountsOrderLineItemDiscountsChargebee.Orders.OrderLineItemTaxes: Order Line Item TaxesOrderLineItemTaxesChargebee.Orders.OrderLineItems: Order Line ItemsOrderLineItemsChargebee.Orders.OrderLinkedCreditNotes: Order Linked Credit NotesOrderLinkedCreditNotesChargebee.Orders.OrderResentOrders: Order Resent OrdersOrderResentOrdersChargebee.Orders.Orders: OrdersOrdersChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSChargebee.Coupons.Coupons: CouponsCouponsCouponChargebee.Invoices.Invoices: InvoicesInvoicesFactuurChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSRampChargebee.Subscriptions.RampCouponsToAdd: Ramp Coupons to AddRampCouponsToAddChargebee.Subscriptions.RampCouponsToRemove: Ramp Coupons to RemoveRampCouponsToRemoveChargebee.Subscriptions.RampDiscountsToAdd: Ramp Discounts to AddRampDiscountsToAddChargebee.Subscriptions.RampDiscountsToRemove: Ramp Discounts to RemoveRampDiscountsToRemoveChargebee.Subscriptions.RampItemTiers: Ramp Item TiersRampItemTiersChargebee.Subscriptions.RampItemsToAdd: Ramp Items to AddRampItemsToAddChargebee.Subscriptions.RampItemsToRemove: Ramp Items to RemoveRampItemsToRemoveChargebee.Subscriptions.RampItemsToUpdate: Ramp Items to UpdateRampItemsToUpdateChargebee.Subscriptions.Ramps: RampsRampsChargebee.Subscriptions.SubscriptionsSChargebee.Coupons.Coupons: CouponsCouponsCouponCouponChargebee.Coupons.CouponAddons: Coupon Add-onsCouponAddonsChargebee.Coupons.CouponCodes: Coupon CodesCouponCodesChargebee.Coupons.CouponConstraints: Coupon ConstraintsCouponConstraintsChargebee.Coupons.CouponItemConstraintCriteria: Coupon Item Constraint CriteriaCouponItemConstraintCriteriaChargebee.Coupons.CouponItemConstraints: Coupon Item ConstraintsCouponItemConstraintsChargebee.Coupons.CouponPlans: Coupon PlansCouponPlansChargebee.Coupons.CouponSets: Coupon SetsCouponSetsChargebee.Coupons.Coupons: CouponsCouponsChargebee.Addons.Addons: Add-onsAddonsAddonChargebee.Plans.Plans: PlansPlansPlanPlanChargebee.Plans.PlanApplicableAddons: Plan Applicable Add-onsPlanApplicableAddonsChargebee.Plans.PlanAttachedAddons: Plan Attached Add-onsPlanAttachedAddonsChargebee.Plans.PlanCustomFieldValues: Plan Custom FieldsPlanCustomFieldValuesChargebee.Plans.PlanEventBasedAddons: Plan Event-based Add-onsPlanEventBasedAddonsChargebee.Plans.PlanTiers: Plan TiersPlanTiersChargebee.Plans.Plans: PlansPlansTransactieChargebee.Native.NATIVEPLATFORMSCALARREQUESTS: Native Platform Scalar RequestsNATIVEPLATFORMSCALARREQUESTSChargebee.Transactions.TransactionLinkedCreditNotes: Transaction Linked Credit NotesTransactionLinkedCreditNotesChargebee.Transactions.TransactionLinkedInvoices: Transaction Linked InvoicesTransactionLinkedInvoicesChargebee.Transactions.TransactionLinkedPayments: Transaction Linked PaymentsTransactionLinkedPaymentsChargebee.Transactions.TransactionLinkedRefunds: Transaction Linked RefundsTransactionLinkedRefundsChargebee.Transactions.Transactions: Subscription Add-onsTransactionsChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSChargebee.Invoices.Invoices: InvoicesInvoicesFactuurChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSPaymentChargebee.Invoices.PaymentReferenceNumbers: Payment Reference NumbersPaymentReferenceNumbersChargebee.Subscriptions.PaymentSourceMandates: Payment Source MandatesPaymentSourceMandatesChargebee.Subscriptions.SubscriptionsSChargebee.Subscriptions.PaymentSources: Payment SourcesPaymentSourcesChargebee.Customers.CustomersCChargebee.Invoices.Invoices: InvoicesInvoicesFactuurChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSOverigeChargebee.Events.EventWebhooks: Event WebhooksEventWebhooksChargebee.Events.Events: EventsEventsChargebee.Items.ItemPrices: Item PricesItemPricesChargebee.Items.Items: ItemsItemsAddonChargebee.Addons.AddonCustomFieldValues: Addon Custom FieldsAddonCustomFieldValuesChargebee.Addons.AddonTiers: Add-on TiersAddonTiersChargebee.Addons.Addons: Add-onsAddonsChargebee.Invoices.Invoices: InvoicesInvoicesFactuurChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSInkoopChargebee.Subscriptions.PurchaseInvoiceIDs: Purchase Invoice IDsPurchaseInvoiceIDsChargebee.Subscriptions.PurchaseSubscriptionIDs: Purchase Subscription IDsPurchaseSubscriptionIDsChargebee.Subscriptions.Purchases: PurchasesPurchasesChargebee.Customers.CustomersCBusinessChargebee.BusinessEntities.BusinessEntities: Business EntitiesBusinessEntitiesChargebee.BusinessEntities.BusinessEntityTransfers: Business Entity TransfersBusinessEntityTransfersCommentaarChargebee.Comments.Comments: CommentsCommentsValutaChargebee.Currencies.Currencies: CurrenciesCurrenciesAangepastChargebee.CustomFields.CustomFieldConfigurations: Custom Field ConfigsCustomFieldConfigurationsGehostChargebee.HostedPages.HostedPageContents: Hosted Page ContentsHostedPageContentsChargebee.HostedPages.HostedPages: Hosted PagesHostedPagesInstallmentChargebee.Invoices.InstallmentConfigurations: Installment ConfigurationsInstallmentConfigurationsArtikelChargebee.Items.ItemFamilies: Item FamiliesItemFamiliesQuoteChargebee.Quotes.QuoteLineGroups: Quote Line GroupsQuoteLineGroupsSiteChargebee.SiteMigrationDetails.SiteMigrationDetails: Site Migration DetailsSiteMigrationDetailsUnbilledChargebee.UnbilledCharges.UnbilledChargeTiers: Unbilled Charge TiersUnbilledChargeTiersChargebeeAuthentication Authentication is done using an API key. An APIkey can be found and/or registered onhttps://SERVER/apikeys_and_webhooks/api. The API key is validfor a specific site. The Chargebee API key can be configured insettings.xml as the value of defaultPassword attribute of thedatabase element. The site is derived from the connectionNotitiesIn dit datamodel zijn nog geen sleutels gedefinieerd; de met punten gescheiden relaties wordenafgeleid uit de namen van de kolommen.Data DictionaryElke tabel en kolom van dit datamodel wordt beschreven in de bijbehorende documentatie opdocumentation.invantive.eu, waar de poster ook in andere talen beschikbaar is.NotitiesDe boxen zijn gegroepeerd per onderwerp en gekleurd per categorie. In het onderwerp van detabel waarin de sleutel staat, wordt een relatie aangegeven; in een ander onderwerp wordt eenlichtgrijs box gedefinieerd.OnderwerpenAbonnement1Addon1Coupon1Factuur1Inkoop1Klant1Overige1Payment1Plan1Quote1Ramp1Transactie1Volgorde1Tabeller uden relationen1LegendaTransactioneelInrichtingTechnischVastgelegde waardenUitgelegd in een ander onderwerpVerklaarde sleutelDe relatie in woorden beschrevenKandidaat afgeleid van kolomnamenVetgedrukt: een populaire tabel+Bulk, +Lezen: de tabel bestaat ook in deze varianten\u00D7n: n toetsen tussen dezelfde tabellenBrieven: verwijst naar een tabel die bij de meeste onderwerpen wordt gebruikt: C = Customers, S =SubscriptionsGegenereerd op basis van de metagegevens van Invantive UniversalSQL 24.1.3-BETA+4689 op 10-06-2024. Elketabel bevat een link naar de bijbehorende pagina met kolommen, sleutels en voorbeeldquery's.documentation.invantive.eu/nl/datamodels/chargebee
De poster als tekst: tabellen per onderwerp en hun onderlinge verbanden

Factuur

Installments, InvoiceAdjustmentCreditNotes, InvoiceAppliedCredits, InvoiceCreditNotes, InvoiceDiscounts, InvoiceDunningAttempts, InvoiceLineItemDiscounts, InvoiceLineItemTaxes, InvoiceLineItemTiers, InvoiceLineItems, InvoiceLinkedOrders, InvoiceLinkedPayments, InvoiceNotes, InvoiceTaxes, Invoices

Abonnement

EntitlementOverrides, Entitlements, FeatureLevels, Features, SubscriptionEntitlements, SubscriptionAddons, SubscriptionChargedEventBasedAddons, SubscriptionChargedItems, SubscriptionCoupons, SubscriptionCustomFieldValues, SubscriptionDiscounts, SubscriptionEventBasedAddons, SubscriptionItemTiers, SubscriptionItems, Subscriptions

Klant

CreditNotes, Cards, CustomerBalances, CustomerContacts, CustomerCustomFieldValues, CustomerReferralUrls, Customers, PromotionalCredits, UnbilledCharges, VirtualBankAccounts

Ramp

RampCouponsToAdd, RampCouponsToRemove, RampDiscountsToAdd, RampDiscountsToRemove, RampItemTiers, RampItemsToAdd, RampItemsToRemove, RampItemsToUpdate, Ramps

Coupon

CouponAddons, CouponCodes, CouponConstraints, CouponItemConstraintCriteria, CouponItemConstraints, CouponPlans, CouponSets, Coupons

Volgorde

GiftTimelines, Gifts, OrderLineItemDiscounts, OrderLineItemTaxes, OrderLineItems, OrderLinkedCreditNotes, OrderResentOrders, Orders

Quote

QuoteLineItemTiers, QuoteDiscounts, QuoteLineItemDiscounts, QuoteLineItemTaxes, QuoteLineItems, QuoteNotes, QuoteTaxes, Quotes

Plan

PlanApplicableAddons, PlanAttachedAddons, PlanCustomFieldValues, PlanEventBasedAddons, PlanTiers, Plans

Transactie

NATIVEPLATFORMSCALARREQUESTS, TransactionLinkedCreditNotes, TransactionLinkedInvoices, TransactionLinkedPayments, TransactionLinkedRefunds, Transactions

Overige

EventWebhooks, Events, ItemPrices, Items

Addon

AddonCustomFieldValues, AddonTiers, Addons

Payment

PaymentReferenceNumbers, PaymentSourceMandates, PaymentSources

Inkoop

PurchaseInvoiceIDs, PurchaseSubscriptionIDs, Purchases

Business (zonder relaties)

BusinessEntities, BusinessEntityTransfers

Commentaar (zonder relaties)

Comments

Valuta (zonder relaties)

Currencies

Aangepast (zonder relaties)

CustomFieldConfigurations

Gehost (zonder relaties)

HostedPageContents, HostedPages

Installment (zonder relaties)

InstallmentConfigurations

Artikel (zonder relaties)

ItemFamilies

Quote (zonder relaties)

QuoteLineGroups

Site (zonder relaties)

SiteMigrationDetails

Unbilled (zonder relaties)

UnbilledChargeTiers

Relaties

Tabellen

Chargebee.Addons

Chargebee.Addresses

Chargebee.BusinessEntities

Chargebee.Comments

Chargebee.Coupons

Chargebee.CreditNotes

Chargebee.Currencies

Chargebee.CustomFields

Chargebee.Customers

Chargebee.Entitlements

Chargebee.Events

Chargebee.Gifts

Chargebee.HostedPages

Chargebee.InAppPurchases

Chargebee.Invoices

Chargebee.Items

Chargebee.Native

Chargebee.Orders

Chargebee.Plans

Chargebee.PromotionalCredits

Chargebee.Quotes

Chargebee.SiteMigrationDetails

Chargebee.Subscriptions

Chargebee.Transactions

Chargebee.UnbilledCharges

Chargebee.VirtualBankAccounts

Attributen

The attributes of this platform are on the page Attributes.

Release Notes

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