This table includes Subscription Change Order lines, which are subrecords of Change Orders.
The table's data is available only for accounts with the SuiteBilling feature enabled.
| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| change_order_action_id | VARCHAR2 | 23 | Change order action ID | ||||
| change_order_id | NUMBER | 39 | 0 |
change_order_id |
Subscription_change_orders |
Change Order ID | |
| discount | NUMBER | 39 | 0 | Discount | |||
| is_discount_percentage | VARCHAR2 | 3 | Whether the discount is a percentage | ||||
| plan_item_id | NUMBER | 39 | 0 |
item_id |
Items |
Plan item ID | |
| price_plan_id | NUMBER | 39 | 0 | Price plan ID | |||
| quantity | NUMBER | 18 | 8 | Quantity | |||
| recurring_amount | NUMBER | 20 | 2 | Recurring amount | |||
| status_id | VARCHAR2 | 25 | Status ID | ||||
| subscription_id | NUMBER | 39 | 0 |
subscription_id |
Billing_subscriptions |
Subscription ID | |
| subscription_line_id | NUMBER | 39 | 0 |
subline_id |
Billing_subscription_lines |
Subscription line ID |
| FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
|---|---|---|---|---|
| subscription_co_lines_billing_subscription_lines_fk | subscription_line_id | Billing_subscription_lines | subline_id | 1 |
| subscription_co_lines_billing_subscriptions_fk | subscription_id | Billing_subscriptions | subscription_id | 1 |
| subscription_co_lines_items_fk | plan_item_id | Items | item_id | 1 |
| subscription_co_lines_subscription_change_orders_fk | change_order_id | Subscription_change_orders | change_order_id | 1 |