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