Business entities - Chargebee Data Catalog

The business_entities table represents a business unit or brand under your organization. Key data entities in Chargebee Billing (such as customer, subscriptions, invoices, and transactions), along with the associated site configurations, are associated with a business entity. Each Chargebee Billing site has one business entity by default. You may observe multiple business entities in the following scenarios:

Multiple Business Units: Your business may operate across different regional units with distinct "invoice-from" addresses, usually for tax and bookkeeping purposes. In this case, each unit is represented by a separate business entity.
Multiple Brands: Your organization may include multiple brands, such as those acquired through mergers or acquisitions. Each brand may be listed as a separate business entity.

Maintaining multiple business entities allows for separation of configurations and data for each business unit or brand, helping you manage billing and revenue data independently.

UPSERT KEY

Each row is uniquely identified by this column. Use it as the upsert key when applying incremental datasets to your warehouse.

Related Tables

Tables referencing business_entities.id

invoices quotes credit_notes payment_sources orders customers transactions subscriptions

Columns

id string, not null

Primary Key

A unique, system-generated identifier for the business entity. This identifier does not change.

change_type string

The column indicates the type of change [create, update, delete, read] and can be used to load data into the warehouse accordingly.

created_at timestamp, not null

The timestamp when the business entity record was created.

name string, not null

A human-readable name for the business entity.

record_exported_at timestamp

The column represents the timestamp when the data was exported to the configured destination.

record_extracted_at timestamp

The column represents the timestamp when the updated data became available in Chargebee's data lakehouse.

resource_version long, null

The version number of the record. The resource_version updates with a new timestamp (in milliseconds) when the record is modified. This value is applicable only for updates made after September 28, 2016.

status string, not null

The current status of the business entity. Possible values are:

active: The business entity is active and available for use.
inactive: The business entity is inactive and not available for use.

updated_at timestamp, null

The timestamp when the business entity record was last updated.