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
dim_discount_campaign_scope.rate_bundle_term_id erp_v2_dim_discount_campaign_scope_rate_bundle_term_id__erp_v2_dim_rate_bundle_term_rate_bundle_term_id_fkey_460c2f074767 R
fct_contract.rate_bundle_term_id erp_v2_fct_contract_rate_bundle_term_id__erp_v2_dim_rate_bundle_term_rate_bundle_term_id_fkey_4651a84a9af7 R
fct_rate_bundle_term_availability.rate_bundle_term_id erp_v2_fct_rate_bundle_term_availability_rate_bundle_term_id__erp_v2_dim_rate_bundle_term_rate_bundle_term_id__63dbe9cd5551 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 erp_v2_dim_rate_bundle_term_rate_bundle_id__erp_v2_dim_rate_bundle_rate_bundle_id_fkey_cfaee6d7ef31 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 erp_v2_dim_rate_bundle_term_rate_term_payment_frequency_id__erp_v2_dim_rate_term_payment_frequency_rate_term_p_47bf3f42eb8b 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).
data_landing_time timestamptz 35 getdate()

System column. UTC timestamp assigned when a table batch is applied on Redshift. It represents warehouse landing order at table-batch granularity, not source event order. Usable to filter for incremental extractions.

Relationships

Close relationships within degrees of separation