Billing_subscription_lines

This table includes data related to the Subscription Line record, which represents an individual item on a Subscription. All Subscription Lines require a parent Subscription.
The table's data is available only for accounts with the SuiteBilling feature enabled.

Columns

Name	Type	Length	Precision	Scale	References	In	Description
billing_mode_id	VARCHAR2	32					Billing mode ID
catalog_type	VARCHAR2	10					Catalog type
class_id	NUMBER		39	0	class_id	Classes	Class ID
date_created	TIMESTAMP						Date created
date_end	TIMESTAMP						End date
date_last_modified	TIMESTAMP						Date last modified
date_recurrence_start	TIMESTAMP						Recurring start date
date_start	TIMESTAMP						Start date
date_termination	TIMESTAMP						Termination date
department_id	NUMBER		39	0	department_id	Departments	Department ID
discount	NUMBER		18	8			Discount
is_discount_percentage	VARCHAR2	3					Whether the discount is a percentage
is_include_in_renewal	VARCHAR2	3					Whether the line is included in renewal
is_prorate_end_date	VARCHAR2	3					Whether the end date is prorated
is_prorate_start_date	VARCHAR2	3					Whether the start date is prorated
item_id	NUMBER		39	0	item_id	Items	Item ID
line_type	VARCHAR2	50					Line type
location_id	NUMBER		39	0	location_id	Locations	Location ID
period_amount	NUMBER		20	2			Period amount
price_interval_group_id	NUMBER		39	0			Price interval group ID
purchase_order_id	VARCHAR2	138			transaction_id	Transactions	Purchase order ID
quantity	NUMBER		18	8			Quantity
recurring_amount	NUMBER		20	2			Recurring revenue amount over the subscription term
sales_order_id	NUMBER		39	0	transaction_id	Transactions	Sales order ID
sales_order_line_number	NUMBER		39	0			Sales order line number
status_id	VARCHAR2	25					Status ID
subline_extid	VARCHAR2	255					Subline external ID
subline_id	NUMBER		39	0			Subline ID
subline_number	NUMBER		39	0			Subline number
subscription_id	NUMBER		39	0	subscription_id	Billing_subscriptions	Subscription ID
subscription_plan_line_id	NUMBER		39	0	plan_line_id	Subscription_plan_lines	Subscription plan line ID
total	NUMBER		35	15			Total
usage_multiplier_line_id	NUMBER		39	0	subline_id	Billing_subscription_lines	Usage multiplier line ID

Primary key

PK Column Name
subline_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
billing_subscription_lines_billing_subscription_lines_fk	usage_multiplier_line_id	Billing_subscription_lines	subline_id	1
billing_subscription_lines_billing_subscriptions_fk	subscription_id	Billing_subscriptions	subscription_id	1
billing_subscription_lines_classes_fk	class_id	Classes	class_id	1
billing_subscription_lines_departments_fk	department_id	Departments	department_id	1
billing_subscription_lines_items_fk	item_id	Items	item_id	1
billing_subscription_lines_locations_fk	location_id	Locations	location_id	1
billing_subscription_lines_subscription_plan_lines_fk	subscription_plan_line_id	Subscription_plan_lines	plan_line_id	1
billing_subscription_lines_transactions_fk	purchase_order_id	Transactions	transaction_id	1
billing_subscription_lines_transactions_fk_2	sales_order_id	Transactions	transaction_id	1

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Billing_subscription_lines_billing_subscription_lines_fk	subline_id	Billing_subscription_lines	usage_multiplier_line_id	1
Subscript_line_price_intervals_billing_subscription_lines_fk	subline_id	Subscript_line_price_intervals	subscription_line_id	1
Subscription_co_lines_billing_subscription_lines_fk	subline_id	Subscription_co_lines	subscription_line_id	1
Subscription_line_revisions_billing_subscription_lines_fk	subline_id	Subscription_line_revisions	subscription_line_id	1