invantive documentation
Forum di supporto InvantiveAccedi / Registrati

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

Configura questa piattaforma su Invantive Cloud: https://cloud.invantive.com/chargebee

I confronti tra testi su questa piattaforma tengono conto delle maiuscole e delle minuscole.

Piattaforma

  • Utilizzabile da: Invantive Cloud e dai prodotti Invantive installati sul proprio computer o server.
  • Tipo: un'applicazione accessibile tramite la propria API.
  • I dati sono suddivisi, ad esempio per azienda o per amministrazione.
  • I dati possono essere sia letti che scritti.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.chargebee.com/.

Figure

Figure Count
Tables 114
Columns 1,534

Poster sul modello di dati

Questo modello di dati non dichiara ancora alcuna chiave; le relazioni indicate da punti derivano dai nomi delle colonne.

PDF, 1 foglio A0

Su una tabella del poster: Zoom avanti e indietro, i tasti freccia per spostarsi, 0 per adattare.

Chargebee Modello di dati, Foglio 1 di 1Chargebee Modello di datida utilizzare con Invantive UniversalSQLComunicato 24.1.3-BETA+4689 · 10-06-2024Abbonamento · Fattura · Quote · cliente · Ordinamento · Catastrofe · Coupon · Piano · Transazione · Payment · Altro · Addon · AcquistoFoglio 1 di 1 · documentation.invantive.euAbbonamentoChargebee.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: GiftsGiftsOrdinamentoChargebee.Plans.Plans: PlansPlansPianoFatturaChargebee.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-onsTransactionsTransazioneChargebee.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: InvoicesInvoicesFatturaChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSclienteChargebee.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 AccountsVirtualBankAccountsOrdinamentoChargebee.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: InvoicesInvoicesFatturaChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSCatastrofeChargebee.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: PlansPlansPianoPianoChargebee.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: PlansPlansTransazioneChargebee.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: InvoicesInvoicesFatturaChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSPaymentChargebee.Invoices.PaymentReferenceNumbers: Payment Reference NumbersPaymentReferenceNumbersChargebee.Subscriptions.PaymentSourceMandates: Payment Source MandatesPaymentSourceMandatesChargebee.Subscriptions.SubscriptionsSChargebee.Subscriptions.PaymentSources: Payment SourcesPaymentSourcesChargebee.Customers.CustomersCChargebee.Invoices.Invoices: InvoicesInvoicesFatturaChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSAltroChargebee.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: InvoicesInvoicesFatturaChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSAcquistoChargebee.Subscriptions.PurchaseInvoiceIDs: Purchase Invoice IDsPurchaseInvoiceIDsChargebee.Subscriptions.PurchaseSubscriptionIDs: Purchase Subscription IDsPurchaseSubscriptionIDsChargebee.Subscriptions.Purchases: PurchasesPurchasesChargebee.Customers.CustomersCBusinessChargebee.BusinessEntities.BusinessEntities: Business EntitiesBusinessEntitiesChargebee.BusinessEntities.BusinessEntityTransfers: Business Entity TransfersBusinessEntityTransfersCommentoChargebee.Comments.Comments: CommentsCommentsValutaChargebee.Currencies.Currencies: CurrenciesCurrenciesPersonalizzatoChargebee.CustomFields.CustomFieldConfigurations: Custom Field ConfigsCustomFieldConfigurationsOspitatoChargebee.HostedPages.HostedPageContents: Hosted Page ContentsHostedPageContentsChargebee.HostedPages.HostedPages: Hosted PagesHostedPagesInstallmentChargebee.Invoices.InstallmentConfigurations: Installment ConfigurationsInstallmentConfigurationsArticoloChargebee.Items.ItemFamilies: Item FamiliesItemFamiliesQuoteChargebee.Quotes.QuoteLineGroups: Quote Line GroupsQuoteLineGroupsSitoChargebee.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 connectionNoteQuesto modello di dati non dichiara ancora alcuna chiave; le relazioni indicate da punti derivanodai nomi delle colonne.Dizionario dei datiOgni tabella e colonna di questo modello di dati è descritta nella relativa documentazionedisponibile su documentation.invantive.eu, dove il poster è disponibile anche in altre lingue.NoteLe box sono raggruppate per argomento e contrassegnate da colori diversi a seconda dellacategoria. Nel nodo della tabella che contiene la chiave viene tracciata una relazione; in un altronodo viene definito un Box di colore grigio chiaro.ArgomentiAbbonamento1Acquisto1Addon1Altro1Catastrofe1cliente1Coupon1Fattura1Ordinamento1Payment1Piano1Quote1Transazione1Tabella senza relazioni1LeggendaTransazionaleInstallazioneAspetti tecniciValori hardcodedDescritto in un altro argomentoChiave dichiarataRelazione descritta a paroleCandidato derivato dai nomi delle colonneIn grassetto: una tabella molto diffusa+Bulk, +Read: la tabella è disponibile anche in queste varianti\u00D7n: n chiavi tra le stesse tabelleLettere: si riferisce a una tabella utilizzata nella maggior parte degli argomenti: C = Customers, S =SubscriptionsGenerato dai metadati di Invantive UniversalSQL 24.1.3-BETA+4689 il 10-06-2024. Ogni tabella rimanda allarelativa pagina con le colonne, le chiavi e le Query di esempio.documentation.invantive.eu/it/datamodels/chargebee
Il poster come testo: tabelle per argomento e le loro relazioni

Fattura

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

Abbonamento

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

cliente

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

Catastrofe

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

Coupon

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

Ordinamento

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

Quote

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

Piano

PlanApplicableAddons, PlanAttachedAddons, PlanCustomFieldValues, PlanEventBasedAddons, PlanTiers, Plans

Transazione

NATIVEPLATFORMSCALARREQUESTS, TransactionLinkedCreditNotes, TransactionLinkedInvoices, TransactionLinkedPayments, TransactionLinkedRefunds, Transactions

Altro

EventWebhooks, Events, ItemPrices, Items

Addon

AddonCustomFieldValues, AddonTiers, Addons

Payment

PaymentReferenceNumbers, PaymentSourceMandates, PaymentSources

Acquisto

PurchaseInvoiceIDs, PurchaseSubscriptionIDs, Purchases

Business (senza relazioni)

BusinessEntities, BusinessEntityTransfers

Commento (senza relazioni)

Comments

Valuta (senza relazioni)

Currencies

Personalizzato (senza relazioni)

CustomFieldConfigurations

Ospitato (senza relazioni)

HostedPageContents, HostedPages

Installment (senza relazioni)

InstallmentConfigurations

Articolo (senza relazioni)

ItemFamilies

Quote (senza relazioni)

QuoteLineGroups

Sito (senza relazioni)

SiteMigrationDetails

Unbilled (senza relazioni)

UnbilledChargeTiers

Relazioni

Tabelle

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

Attributi

The attributes of this platform are on the page Attributes.

Note di rilascio

Cosa è cambiato, versione per versione, nelle tabelle, nelle colonne, negli attributi e nelle funzionalità del driver: