This table has the line level details of the available subscription plans i.e. items and their attributes like billing mode, renewal option, revenue recognition details.
Module:
id
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| id | NUMBER | 38 | 0 | True | |||
| SOURCE_RECORD_ID | VARCHAR2 | 128 | This column is for Oracle Internal use only. This is source record id column. | ||||
| billingmode | VARCHAR2 | 64 | Billing Mode | DW_NS_Chargebillingmodetype_D | key | ||
| isrequired | VARCHAR2 | 16 | Required | ||||
| item | NUMBER | 38 | 0 | Item | DW_NS_item_D | id | |
| linenumber | NUMBER | 38 | 0 | Line Number | |||
| prorateenddate | VARCHAR2 | 16 | Prorate End Date | ||||
| proratestartdate | VARCHAR2 | 16 | Prorate Start Date | ||||
| renewaloption | VARCHAR2 | 32 | Include In Renewal Subscription | ||||
| revrecoption | VARCHAR2 | 64 | Revenue Recognition Option | DW_NS_subscriptionRevRecOption_D | key | ||
| subscriptionlinetype | NUMBER | 38 | 0 | Type | DW_NS_SubscriptionLineType_D | key | |
| subscriptionplan | NUMBER | 38 | 0 | Subscription Plan | DW_NS_subscriptionPlan_D | id |
Copyright © 2019, 2026, Oracle and/or its affiliates.