OSS_RENEWAL_PROD_GT
Global temporary table for procession Product or Product Asset of Subscription
Details
-
Schema: FUSION
-
Object owner: OSS
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
OSS_RENEWAL_PROD_GT_PK |
SUBSCRIPTION_PRODUCT_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
SUBSCRIPTION_PRODUCT_ID | NUMBER | 18 | Yes | Primary Key Source Product Id for Subcription Product and Coverage Id for Coverage Product | |
SUBSCRIPTION_ID | NUMBER | 18 | Source Subscription Id | ||
ALTERNATE_SUBSCRIPTION_ID | NUMBER | 18 | Source Alternate Subscription Id | ||
SUBSCRIPTION_START_DATE | DATE | Source Subscription Start Date | |||
SUBSCRIPTION_END_DATE | DATE | Source Subscription End Date | |||
PARENT_PRODUCT_ID | NUMBER | 18 | Parent Product Id for Product Association | ||
PARENT_PRODUCT_PUID | VARCHAR2 | 120 | Parent Product PUID | ||
PARENT_PRODUCT_ASSOC_ID | NUMBER | 18 | Parent Product Association Id | ||
SALES_PRODUCT_TYPE | VARCHAR2 | 30 | Product type like Subcription or Coverage | ||
PRODUCT_START_DATE | DATE | Product start date | |||
PRODUCT_END_DATE | DATE | Product end date | |||
PRICE_DURING_BILLING_YN | VARCHAR2 | 1 | Price During Billing Flag | ||
INVENTORY_ITEM_ID | NUMBER | 18 | Inventory Item Id | ||
DEFINITION_ORG_ID | NUMBER | Defination Org Id | |||
BILL_TO_ACCT_ID | NUMBER | 18 | Bill to Account Id | ||
BILL_TO_SITE_USE_ID | NUMBER | 18 | Bill to Site use Id | ||
SHIP_TO_PARTY_ID | NUMBER | 18 | Ship to Party ID | ||
SHIP_TO_PARTY_SITE_ID | NUMBER | 18 | Ship to Party Site ID | ||
PRODUCT_RENEWAL_TYPE | VARCHAR2 | 20 | Product renewal type | ||
PRICE_ADJUSTMENT_TYPE | VARCHAR2 | 30 | price adjustment type | ||
PRICE_ADJUSTMENT_BASIS | VARCHAR2 | 30 | Price Adjustment Basis | ||
PRICE_ADJUSTMENT_PERCENT | NUMBER | Price Adjustment Percentage | |||
TARGET_SUBSCRIPTION_ID | NUMBER | 18 | Target Subscription Id | ||
TARGET_MAJOR_VERSION | NUMBER | 18 | Target Subscription Major Version | ||
TARGET_ALT_SUBSCRIPTION_ID | NUMBER | 18 | Target Alternate Subscription Id | ||
TARGET_SUBSCRIPTION_YN | VARCHAR2 | 1 | Determine new Subscription for Y or merge to existing Subscription for N | ||
TARGET_SUBSCRIPTION_NUMBER | VARCHAR2 | 120 | Target Subscription Number | ||
TARGET_SUBSCRIPTION_PRODUCT_ID | NUMBER | Taget Product Primary Key | |||
TARGET_PARENT_PRODUCT_ID | NUMBER | 18 | Target Parent Product Id for Product Association | ||
TARGET_PRODUCT_START_DATE | DATE | Target Product start date | |||
TARGET_PRODUCT_END_DATE | DATE | Target Product end date | |||
TARGET_PRODUCT_NUMBER | VARCHAR2 | 300 | Target Product Number | ||
TARGET_PRODUCT_PUID | VARCHAR2 | 120 | Target Product PUID | ||
TARGET_PARENT_PRODUCT_YN | VARCHAR2 | 1 | Determine new Product for Y or merge to existing Product for N | ||
TARGET_PARENT_PRODUCT_PUID | VARCHAR2 | 120 | Target Parent Product PUID | ||
TARGET_PARENT_PRODUCT_NUMBER | VARCHAR2 | 300 | Target Parent Product Number | ||
TARGET_PARENT_PRODUCT_ASSOC_ID | NUMBER | 18 | Target Parent Product Association Id | ||
RENEWAL_TEMPLATE_ID | NUMBER | 18 | Renewal template id | ||
CONSOLIDATE_YN | VARCHAR2 | 1 | Consolidation Flag | ||
CO_TERMINATE | VARCHAR2 | 30 | Coterminate | ||
RENEWAL_PROCESS | VARCHAR2 | 30 | Renewal Type | ||
SUBSCRIPTION_PROFILE_ID | NUMBER | 18 | Subscription Profile Id | ||
CONSOLIDATE_GROUP | NUMBER | Rank of Consolidation Group | |||
LANGUAGE_CODE | VARCHAR2 | 4 | Language Code | ||
CONS_SRC_SUBSCRIPTION_ID | NUMBER | 18 | Source Subscription ID for consolidation flow | ||
CONS_SRC_PRODUCT_ID | NUMBER | 18 | Source product ID for consolidation flow | ||
SOURCE_ASSET_KEY | VARCHAR2 | 120 | Source Asset Key | ||
SOURCE_ROOT_ASSET_KEY | VARCHAR2 | 120 | Source root asset key | ||
PAYMENT_METHOD | VARCHAR2 | 30 | Product payment method | ||
PRIMARY_PARTY_ID | NUMBER | 18 | Primary party id | ||
PRODUCT_CHANGE_YN | VARCHAR2 | 1 | Flag to determine if the product is eligible for replacement on Renewal. | ||
WARRANTY_RELATED_ITEM_ID | NUMBER | 18 | The extended warranty inventory item Id defined in related item. | ||
WARRANTY_RELATED_ITEM_NAME | VARCHAR2 | 300 | The extended warranty inventory item name defined in related item. | ||
WARRANTY_RELATED_ITEM_UOM | VARCHAR2 | 15 | The extended warranty inventory item uom defined in related item. | ||
WARRANTY_RELATED_COVERAGE_ID | NUMBER | 18 | The coverage schedule id associated to the extended warranty inventory item in related item. | ||
WARRANTY_RELATED_PROD_TYPE | VARCHAR2 | 30 | The extended warranty sales product type defined in related item. | ||
DEFAULT_REVENUE_ACTION | VARCHAR2 | 30 | Default revenue action for renewd subscriptions | ||
REVENUE_OPTION | VARCHAR2 | 30 | Revenue option to capture accounting information if its prospective or retrospective for renewed subscriptions. | ||
FREEZE_PRICE_FLAG | VARCHAR2 | 1 | Determine if it is Pricing flow or Commerce flow. | ||
REQUESTED_RATE_PLAN_ID | NUMBER | 18 | The identifier to capture requested rateplan id. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
OSS_RENEWAL_PROD_GT_U1 | Unique | SUBSCRIPTION_PRODUCT_ID |
OSS_RENEWAL_PROD_GT_N1 | Non Unique | TARGET_SUBSCRIPTION_PRODUCT_ID |