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
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 |