Price_plans

The table stores Price Plan records. To see these records, the SuiteBilling feature must be enabled.

Columns

Name Type Length Precision Scale References In Description
currency VARCHAR2 4 Type of currency for charges for an item. For example, USD
date_created TIMESTAMP Date when the price plan was created
included_quantity NUMBER 18 8 Amount of units included in the pricing before additional charges are created
price_plan_extid VARCHAR2 255 ID assigned by the user for the price plan to associate these records with other systems the user is using
price_plan_id NUMBER 39 0 ID assigned by NetSuite for the price plan that defines how other NetSuite records, such as a price book, subscription pricing, or subscription change orders, associate with the price plan
price_plan_type VARCHAR2 50 Tiered or Volume pricing. Determines whether all quantity is evaluated at the tier where it fits (volume) or quantities flow down the tiers as they are filled (tiered).

Primary key

PK Column Name
price_plan_id

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Price_book_line_intervals_price_plans_fk price_plan_id Price_book_line_intervals price_plan_id 1
Price_book_line_intervals_price_plans_fk_2 price_plan_id Price_book_line_intervals overage_price_plan_id 1
Price_tiers_price_plans_fk price_plan_id Price_tiers price_plan_id 1
Subscript_line_price_intervals_price_plans_fk price_plan_id Subscript_line_price_intervals price_plan_id 1
Subscription_line_revisions_price_plans_fk price_plan_id Subscription_line_revisions price_plan_id 1
Subscription_line_revisions_price_plans_fk_2 price_plan_id Subscription_line_revisions overage_price_plan_id 1