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

OSS_ENT_PLAN_ESTIMATES

Following table is used to capture entitlement plan estimates.

Details

  • Schema: FUSION

  • Object owner: OSS

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

OSS_ENT_PLAN_ESTIMATES_PK

ENT_PLAN_ESTIMATE_ID

Columns

Name Datatype Length Precision Not-null Comments
ENT_PLAN_ESTIMATE_ID NUMBER 18 Yes Unique identifier of entitlement plan estimates.
ENT_PLAN_ESTIMATE_NUMBER VARCHAR2 120 Alternate key for entitlement plan estimates.
ENTITLEMENT_PLAN_ID NUMBER 18 Field used to capture entitlement plan id.
SUBSCRIPTION_PRODUCT_ID NUMBER 18 Field used to capture subscription product id.
PRODUCT_ENTITLEMENT_PLAN_ID NUMBER 18 Field used to capture product entitlement plan id.
BALANCE_CODE_ID NUMBER 18 Field used to capture balance code id.
BALANCE_CODE_TYPE VARCHAR2 30 Field used to capture balance code type.
BALANCE_PROFILE_ID NUMBER 18 Field used to capture balance profile id.
CHARGE_DEFINITION_ID NUMBER 18 Field used to capture charge definition id.
CHARGE_PRICE_TYPE VARCHAR2 30 Tracks the charge type for the given charge.
PERIOD VARCHAR2 30 Field used to capture estimate period.
PERIOD_BASE_UOM VARCHAR2 30 Field used to capture estimate period base uom.
CONVERSION_RATE NUMBER Field used to capture estimate conversion rate.
RELATED_CHARGE_DEFINITION_ID NUMBER 18 Field used to capture related charge definition identifier of entitlement plan estimates.
RELATED_CHARGE_PRICE_TYPE VARCHAR2 30 Tracks the charge type for the given related charge.
RELATED_CHARGE_PERIOD VARCHAR2 30 Tracks the period for the given related charge.
RELATED_CHARGE_BASE_UOM VARCHAR2 30 Tracks the base uom for the given related charge.
RELATED_CHARGE_CONVERSION_RATE NUMBER Tracks the conversion rate for the given related charge.
BALANCE_PROFILE_CHARGE_ID NUMBER 18 Field used to capture profile charge identifier of entitlement plan estimates.
PROFILE_BALANCE_CODE_ID NUMBER 18 Field used to capture profile balance code identifier of entitlement plan estimates.
QUANTITY NUMBER Field used to capture estimate quantity.
ROUNDED_QUANTITY NUMBER Field used to capture estimate rounded quantity.
UOM VARCHAR2 3 Field used to capture estimate unit of measure.
AMOUNT NUMBER Field used to capture estimate amount.
CURRENCY_CODE VARCHAR2 15 Field used to capture estimate currency code.
TRUEUP_SHORTAGE_FLAG VARCHAR2 1 Field used to captur true-up shortage flag.
TRUEUP_OVERAGE_FLAG VARCHAR2 1 Field used to capture true-up overage flag.
ENABLE_ROLLOVER_FLAG VARCHAR2 1 Tracks the enable rollover flag for the given entitlement plan estimates.
ROLLOVER_PERIOD NUMBER Tracks the rollover period for the given entitlement plan estimates.
ROLLOVER_PERIOD_UOM VARCHAR2 3 Tracks the rollover period unit of measure for the given entitlement plan estimates.
ROLLOVER_PERIOD_BASE_UOM VARCHAR2 30 Tracks the rollover period base unit of measure for the given entitlement plan estimates.
ROLLOVER_CONVERSION_RATE NUMBER Tracks the rollover conversion rate for the given entitlement plan estimates.
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_ENT_PLAN_ESTIMATES_PK Unique Default ENT_PLAN_ESTIMATE_ID
OSS_ENT_PLAN_ESTIMATES_U1 Unique Default ENT_PLAN_ESTIMATE_NUMBER