1. Tables and Views for Sales and Fusion Service
  2. OSS_RENEWAL_TEMPLATES

OSS_RENEWAL_TEMPLATES

This table is used for Subscription Renewal Templates.

Details

  • Schema: FUSION

  • Object owner: OSS

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

OSS_RENEWAL_TEMPLATES_PK

RENEWAL_TEMPLATE_ID

Columns

Name Datatype Length Precision Not-null Comments
RENEWAL_TEMPLATE_ID NUMBER 18 Yes Primary Key
RENEWAL_TEMPLATE_NAME VARCHAR2 150 Yes RENEWAL_TEMPLATE_NAME
DAYS_BEFORE_EXPIRY NUMBER 18 Yes DAYS_BEFORE_EXPIRY
MIN_RENEWAL_DURATION NUMBER 18 Yes MIN_RENEWAL_DURATION
RENEWAL_DURATION NUMBER 18 Yes RENEWAL_DURATION
RENEWAL_DURATION_PERIOD VARCHAR2 30 Yes RENEWAL_DURATION_PERIOD
RENEWAL_PROCESS VARCHAR2 30 Yes RENEWAL_PROCESS
COMMUNICATION_CHANNEL VARCHAR2 30 Communication Channel
REMINDER_YN VARCHAR2 1 Reminder is enable
RENEW_WARRANTY_YN VARCHAR2 1 Renew Included Warranty
CO_TERMINATE VARCHAR2 30 Yes CO_TERMINATE
RENEWAL_LEVEL VARCHAR2 30 Yes RENEWAL_LEVEL
CONSOLIDATE_YN VARCHAR2 30 Yes CONSOLIDATE_YN
PRICE_ADJUSTMENT_TYPE VARCHAR2 30 PRICE_ADJUSTMENT_TYPE
PRICE_ADJUSTMENT_PERCENT NUMBER PRICE_ADJUSTMENT_PERCENT
PRICE_ADJUSTMENT_BASIS VARCHAR2 30 PRICE_ADJUSTMENT_BASIS
CUSTOMER_ACCEPTANCE VARCHAR2 30 Customer Acceptance
INTERNAL_APPROVAL VARCHAR2 30 Internal Approval
SUBSCRIPTION_PROFILE_ID NUMBER 18 SUBSCRIPTION_PROFILE_ID
BUSINESS_UNIT_YN VARCHAR2 1 Determine if the business unit is part of consolidation rule
LEGAL_ENTITY_YN VARCHAR2 1 Determine if the legal entity is part of consolidation rule
PRIMARY_PARTY_YN VARCHAR2 1 Determine if the primary party is part of consolidation rule
CURRENCY_YN VARCHAR2 1 Determine if the currency is part of consolidation rule
PRICING_SYSTEM_YN VARCHAR2 1 Determine if the pricing system is part of consolidation rule
RENEWAL_PROCESS_YN VARCHAR2 1 Determine if the renewal process is part of consolidation rule
BILLING_ACCOUNT_YN VARCHAR2 1 Determine if the billing account is part of consolidation rule
BILL_TO_SITE_YN VARCHAR2 1 Determine if the bill to site is part of consolidation rule
SHIP_TO_PARTY_YN VARCHAR2 1 Determine if the ship to party is part of consolidation rule
SHIP_TO_SITE_YN VARCHAR2 1 Determine if the ship to site is part of consolidation rule
BILL_TO_PARTY_YN VARCHAR2 1 Determine if the bill to party is part of consolidation rule
ALIGN_BILLING_DATE_FLAG VARCHAR2 1 This flag determines if the align billing date needs to be copied on renewal.
SHIP_TO_ACCT_YN VARCHAR2 1 Determine if the ship to account is part of consolidation rule
PRICE_ADJUSTMENT_TYPE_YN VARCHAR2 1 Determine if the price adjustment type is part of consolidation rule
PAYMENT_METHOD_YN VARCHAR2 1 Determine if the payment method is part of consolidation rule
APPLY_RENEWAL_TERM_YN VARCHAR2 1 Indicates whether the renewal term is used during automatic renewal.
RETAIN_NUMBER_CODE VARCHAR2 30 Retain number code
RETAIN_NUMBER_SEPARATOR VARCHAR2 5 Retain number separator
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
OSS_RENEWAL_TEMPLATES_U1 Unique FUSION_TS_TX_DATA RENEWAL_TEMPLATE_ID