dim_rate_term_payment_frequency_term_to_price


Description

Price definitions for payment frequencies based on term length.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
term_to_price_configuration_id varchar 256 null

Primary key of the term-to-price configuration.

payment_frequency_id varchar 256 null

The payment frequency this term pricing applies to.

term_value varchar 256 null

Duration of the term used for pricing.

term_unit varchar 256 null

Unit of time for the term. Possible values: DAY, WEEK, MONTH, YEAR.

term_price varchar 256 null

Price charged for the specified term length.

last_updated timestamptz 35 null

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

Relationships