invantive documentation
Forums d'Invantive SupportConnectez-vous/inscrivez-vous

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).

Configurez cette plateforme dans Invantive Cloud : https://cloud.invantive.com/chargebee

Les comparaisons de texte sur cette plateforme tiennent compte de la casse.

Plate-forme

  • Utilisable depuis : Invantive Cloud et les produits Invantive installés sur votre ordinateur ou votre serveur.
  • Type : une application accessible via son API.
  • Les données sont regroupées par catégorie, par exemple par entreprise ou par administration.
  • Les données peuvent être aussi bien écrites que lues.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.chargebee.com/.

Chiffres

Figure Count
Tables 114
Columns 1,534

Affiche sur le modèle de données

Ce modèle de données ne déclare pour l'instant aucune clé ; les relations indiquées par des points sont dérivées des noms de colonnes.

PDF, 1 feuille A0

Sur une table de l'affiche : Zoom avant et arrière, les touches fléchées permettent de se déplacer, la touche 0 permet de revenir à la taille normale.

Chargebee Modèle de données, Page 1 sur 1Chargebee Modèle de donnéesà utiliser avec Invantive UniversalSQLCommuniqué 24.1.3-BETA+4689 · 10-06-2024Abonnement · Facture · Quote · Client · Commande · Désastre · Coupon · Plan · Transaction · Payment · Autre · Addon · AchatPage 1 sur 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: GiftsGiftsCommandeChargebee.Plans.Plans: PlansPlansPlanFactureChargebee.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-onsTransactionsTransactionChargebee.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: InvoicesInvoicesFactureChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSClientChargebee.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 AccountsVirtualBankAccountsCommandeChargebee.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: InvoicesInvoicesFactureChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSDésastreChargebee.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: PlansPlansTransactionChargebee.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: InvoicesInvoicesFactureChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSPaymentChargebee.Invoices.PaymentReferenceNumbers: Payment Reference NumbersPaymentReferenceNumbersChargebee.Subscriptions.PaymentSourceMandates: Payment Source MandatesPaymentSourceMandatesChargebee.Subscriptions.SubscriptionsSChargebee.Subscriptions.PaymentSources: Payment SourcesPaymentSourcesChargebee.Customers.CustomersCChargebee.Invoices.Invoices: InvoicesInvoicesFactureChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSAutreChargebee.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: InvoicesInvoicesFactureChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSAchatChargebee.Subscriptions.PurchaseInvoiceIDs: Purchase Invoice IDsPurchaseInvoiceIDsChargebee.Subscriptions.PurchaseSubscriptionIDs: Purchase Subscription IDsPurchaseSubscriptionIDsChargebee.Subscriptions.Purchases: PurchasesPurchasesChargebee.Customers.CustomersCBusinessChargebee.BusinessEntities.BusinessEntities: Business EntitiesBusinessEntitiesChargebee.BusinessEntities.BusinessEntityTransfers: Business Entity TransfersBusinessEntityTransfersCommentaireChargebee.Comments.Comments: CommentsCommentsDeviseChargebee.Currencies.Currencies: CurrenciesCurrenciesPersonnaliséChargebee.CustomFields.CustomFieldConfigurations: Custom Field ConfigsCustomFieldConfigurationsHébergéChargebee.HostedPages.HostedPageContents: Hosted Page ContentsHostedPageContentsChargebee.HostedPages.HostedPages: Hosted PagesHostedPagesInstallmentChargebee.Invoices.InstallmentConfigurations: Installment ConfigurationsInstallmentConfigurationsArticleChargebee.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 connectionNotesCe modèle de données ne déclare pour l'instant aucune clé ; les relations indiquées par des pointssont dérivées des noms de colonnes.Dictionnaire de donnéesChaque table et chaque colonne de ce Modèle de données sont décrites dans la documentationdisponible sur documentation.invantive.eu, où cette documentation est également accessibledans d'autres langues.NotesLes boîtes sont regroupées par thème et identifiées par une couleur selon leur catégorie. Unerelation est établie dans la rubrique du tableau contenant la clé ; une Box de couleur gris pâle estdéfinie dans une autre rubrique.SujetsAbonnement1Achat1Addon1Autre1Client1Commande1Coupon1Désastre1Facture1Payment1Plan1Quote1Transaction1Tables sans relations1LégendeTransactionnelSetupTechniqueValeurs codées en durDéfini dans une autre rubriqueClé déclaréeRelation décrite avec des motsCandidat dérivé des noms de colonnesEn gras : une table très appréciée+Bulk, +Read : la Table existe également sous ces variantes: n clés entre les mêmes tablesLettres : désigne une table utilisée dans la plupart des rubriques: C = Customers, S = SubscriptionsGénéré à partir des métadonnées d'Invantive UniversalSQL 24.1.3-BETA+4689 le 10-06-2024. Chaque tablerenvoie vers sa page présentant les colonnes, les clés et des exemples de requêtes.documentation.invantive.eu/fr/datamodels/chargebee
L'affiche sous forme de texte : tableaux par thème et leurs relations

Facture

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

Client

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

Désastre

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

Coupon

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

Commande

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

Quote

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

Plan

PlanApplicableAddons, PlanAttachedAddons, PlanCustomFieldValues, PlanEventBasedAddons, PlanTiers, Plans

Transaction

NATIVEPLATFORMSCALARREQUESTS, TransactionLinkedCreditNotes, TransactionLinkedInvoices, TransactionLinkedPayments, TransactionLinkedRefunds, Transactions

Autre

EventWebhooks, Events, ItemPrices, Items

Addon

AddonCustomFieldValues, AddonTiers, Addons

Payment

PaymentReferenceNumbers, PaymentSourceMandates, PaymentSources

Achat

PurchaseInvoiceIDs, PurchaseSubscriptionIDs, Purchases

Business (sans relations)

BusinessEntities, BusinessEntityTransfers

Commentaire (sans relations)

Comments

Devise (sans relations)

Currencies

Personnalisé (sans relations)

CustomFieldConfigurations

Hébergé (sans relations)

HostedPageContents, HostedPages

Installment (sans relations)

InstallmentConfigurations

Article (sans relations)

ItemFamilies

Quote (sans relations)

QuoteLineGroups

Site (sans relations)

SiteMigrationDetails

Unbilled (sans relations)

UnbilledChargeTiers

Relations

Tableaux

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

Attributs

The attributes of this platform are on the page Attributes.

Notes de Version

Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :