invantive documentation
Foros de Soporte de InvantiveIniciar Sesión / Registrarse

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 esta plataforma en Invantive Cloud: https://cloud.invantive.com/chargebee

Las comparaciones de texto en esta plataforma distinguen entre mayúsculas y minúsculas.

Plataforma

  • Se utiliza desde: Invantive Cloud y los productos de Invantive instalados en tu propio ordenador o servidor.
  • Tipo: una aplicación a la que se accede a través de su API.
  • Los datos se agrupan por categorías, como por empresa o por administración.
  • Los datos se pueden leer y escribir.
  • Invantive Cloud plans: Office for Entrepreneurs, Office for Accountants, Premium Finance, OEM.
  • Status of the platform: https://status.chargebee.com/.

Cifras

Figure Count
Tables 114
Columns 1,534

Póster del Modelo de Datos

Este modelo de datos aún no declara ninguna clave; las relaciones con puntos se derivan de los nombres de las columnas.

PDF, hoja A0 1

En una tabla del póster: Zoom para ampliar y reducir; las teclas de flecha sirven para desplazarse; el 0 ajusta la imagen.

Chargebee Modelo de Datos, Hoja 1 de 1Chargebee Modelo de Datospara su uso con Invantive UniversalSQLComunicado 24.1.3-BETA+4689 · 10-06-2024Suscripción · Factura · Quote · Cliente · Orden · Desastre · Coupon · Plan · Transacción · Payment · Otro · Addon · CompraHoja 1 de 1 · documentation.invantive.euSuscripciónChargebee.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: GiftsGiftsOrdenChargebee.Plans.Plans: PlansPlansPlanFacturaChargebee.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-onsTransactionsTransacciónChargebee.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: InvoicesInvoicesFacturaChargebee.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 AccountsVirtualBankAccountsOrdenChargebee.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: InvoicesInvoicesFacturaChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSDesastreChargebee.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: PlansPlansTransacciónChargebee.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: InvoicesInvoicesFacturaChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSPaymentChargebee.Invoices.PaymentReferenceNumbers: Payment Reference NumbersPaymentReferenceNumbersChargebee.Subscriptions.PaymentSourceMandates: Payment Source MandatesPaymentSourceMandatesChargebee.Subscriptions.SubscriptionsSChargebee.Subscriptions.PaymentSources: Payment SourcesPaymentSourcesChargebee.Customers.CustomersCChargebee.Invoices.Invoices: InvoicesInvoicesFacturaChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSOtroChargebee.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: InvoicesInvoicesFacturaChargebee.Customers.CustomersCChargebee.Subscriptions.SubscriptionsSCompraChargebee.Subscriptions.PurchaseInvoiceIDs: Purchase Invoice IDsPurchaseInvoiceIDsChargebee.Subscriptions.PurchaseSubscriptionIDs: Purchase Subscription IDsPurchaseSubscriptionIDsChargebee.Subscriptions.Purchases: PurchasesPurchasesChargebee.Customers.CustomersCBusinessChargebee.BusinessEntities.BusinessEntities: Business EntitiesBusinessEntitiesChargebee.BusinessEntities.BusinessEntityTransfers: Business Entity TransfersBusinessEntityTransfersComentarioChargebee.Comments.Comments: CommentsCommentsMonedaChargebee.Currencies.Currencies: CurrenciesCurrenciesPersonalizarChargebee.CustomFields.CustomFieldConfigurations: Custom Field ConfigsCustomFieldConfigurationsAlojadoChargebee.HostedPages.HostedPageContents: Hosted Page ContentsHostedPageContentsChargebee.HostedPages.HostedPages: Hosted PagesHostedPagesInstallmentChargebee.Invoices.InstallmentConfigurations: Installment ConfigurationsInstallmentConfigurationsArtículoChargebee.Items.ItemFamilies: Item FamiliesItemFamiliesQuoteChargebee.Quotes.QuoteLineGroups: Quote Line GroupsQuoteLineGroupsSitioChargebee.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 connectionNotasEste modelo de datos aún no declara ninguna clave; las relaciones con puntos se derivan de losnombres de las columnas.Diccionario de datosCada tabla y columna de este Modelo de Datos se describe en su documentación, disponible endocumentation.invantive.eu, donde el documento también está disponible en otros idiomas.NotasLas cajas están agrupadas por tema y se distinguen por colores según la categoría. Se estableceuna relación en el tema de la tabla que contiene la clave; en otro tema se define un Box de colorgris pálido.TemasAddon1Cliente1Compra1Coupon1Desastre1Factura1Orden1Otro1Payment1Plan1Quote1Suscripción1Transacción1Tablas sin relaciones1LeyendaTransaccionalConfiguraciónTécnicoValores fijosSe explica en otro temaClave declaradaRelación descrita con palabrasCandidato derivado de los nombres de las columnasNegrita: una tabla muy popular+Bulk, +Read: la tabla también existe en estas variantes\u00D7n: n claves entre las mismas tablasLetras: se refiere a una tabla que se utiliza en la mayoría de los temas: C = Customers, S = SubscriptionsGenerado a partir de los metadatos de Invantive UniversalSQL 24.1.3-BETA+4689 el 10-06-2024. Cada tablaincluye un enlace a su página, donde se muestran las columnas, las claves y ejemplos de queries.documentation.invantive.eu/es/datamodels/chargebee
El póster en forma de texto: tablas por tema y sus relaciones

Factura

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

Suscripción

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

Desastre

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

Coupon

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

Orden

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

Quote

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

Plan

PlanApplicableAddons, PlanAttachedAddons, PlanCustomFieldValues, PlanEventBasedAddons, PlanTiers, Plans

Transacción

NATIVEPLATFORMSCALARREQUESTS, TransactionLinkedCreditNotes, TransactionLinkedInvoices, TransactionLinkedPayments, TransactionLinkedRefunds, Transactions

Otro

EventWebhooks, Events, ItemPrices, Items

Addon

AddonCustomFieldValues, AddonTiers, Addons

Payment

PaymentReferenceNumbers, PaymentSourceMandates, PaymentSources

Compra

PurchaseInvoiceIDs, PurchaseSubscriptionIDs, Purchases

Business (sin relaciones)

BusinessEntities, BusinessEntityTransfers

Comentario (sin relaciones)

Comments

Moneda (sin relaciones)

Currencies

Personalizar (sin relaciones)

CustomFieldConfigurations

Alojado (sin relaciones)

HostedPageContents, HostedPages

Installment (sin relaciones)

InstallmentConfigurations

Artículo (sin relaciones)

ItemFamilies

Quote (sin relaciones)

QuoteLineGroups

Sitio (sin relaciones)

SiteMigrationDetails

Unbilled (sin relaciones)

UnbilledChargeTiers

Relaciones

Tablas

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

Atributos

The attributes of this platform are on the page Attributes.

Notas de la Versión

Cambios introducidos en cada versión en las tablas, columnas, atributos y capacidades del controlador: