dim_rate_bundle_term


Description

Payment-term options for a rate bundle, such as monthly or term-based variants, including the payment frequency used to charge customers.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
rate_bundle_term_id int8 19 null
fct_rate_bundle_term_availability.rate_bundle_term_id fct_rate_bundle_term_availability_rate_bundle_term_id_fkey R

The primary key of this table. System column calculated by the source System.
rate_bundle_id int8 19 √ null
dim_rate_bundle.rate_bundle_id dim_rate_bundle_term_rate_bundle_id_fkey R

The rate bundle that owns the term.
rate_term_payment_frequency_id int8 19 √ null
dim_rate_term_payment_frequency.rate_term_payment_frequency_id dim_rate_bundle_term_rate_term_payment_frequency_id_fkey R

The payment frequency configuration used by the bundle term.
rate_term_configuration_id int8 19 √ null
dim_rate_term_configuration.rate_term_configuration_id Implied Constraint R

The rate term configuration associated with the bundle term.
is_archived bool 1 √ null

Whether the bundle term is archived.
last_updated timestamptz 35 √ null

System column. UTC Timestamp at which entry was calculated (lags shortly behind source system).

Relationships

Close relationships within degrees of separation