Price_book_line_intervals

This table includes the price intervals associated with the Price Book record. It represents the pricing-related data of subscription plan lines in a given time period.
The table's data is available only for accounts with the SuiteBilling feature enabled.

Columns

Name Type Length Precision Scale References In Description
charge_frequency_id VARCHAR2 20 Charge frequency ID
discount NUMBER 39 0 Discount
is_discount_percentage VARCHAR2 3 Whether the discount is a percentage
is_overage_discount_percentage VARCHAR2 3
overage_charge_frequency_id VARCHAR2 20
overage_discount NUMBER 39 0
overage_price_plan_id NUMBER 39 0 price_plan_id
Price_plans
overage_repeat_every NUMBER 39 0
pbli_id NUMBER 39 0 Price book line interval ID
plan_line_id NUMBER 39 0 plan_line_id
Subscription_plan_lines
Plan line ID
plan_line_number NUMBER 39 0 Plan line number
price_book_id NUMBER 39 0 price_book_id
Price_books
Price book ID
price_plan_id NUMBER 39 0 price_plan_id
Price_plans
Price plan ID
prorate_by VARCHAR2 10
repeat_every NUMBER 39 0 Repeat every
start_offset VARCHAR2 70 Start offset
usage_multiplier_line_id NUMBER 39 0 plan_line_id
Subscription_plan_lines
Usage multiplier line ID

Primary key

PK Column Name
pbli_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
price_book_line_intervals_price_books_fk price_book_id Price_books price_book_id 1
price_book_line_intervals_price_plans_fk price_plan_id Price_plans price_plan_id 1
price_book_line_intervals_price_plans_fk_2 overage_price_plan_id Price_plans price_plan_id 1
price_book_line_intervals_subscription_plan_lines_fk plan_line_id Subscription_plan_lines plan_line_id 1
price_book_line_intervals_subscription_plan_lines_fk_2 usage_multiplier_line_id Subscription_plan_lines plan_line_id 1