DW_CXS_SUBSCRIPTION_PRODUCT_CF

This fact table stores the subscription product details

Details

Module: Subscription Management

Key Columns

SUBSCRIPTION_PRODUCT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SUBSCRIPTION_PRODUCT_ID NUMBER 38 0 True Primary key
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System Generated Unique Identifier
SUBSCRIPTION_ID NUMBER 38 0 Subscription Identifier
SUBSCRIPTION_NUMBER VARCHAR2 128 Subscription Number
SUBSCRIPTION_PRIMARY_PARTY_ID NUMBER 38 0 Primary Party of the Subscription DW_PARTY_ORGANIZATION_D PARTY_ID
SUBSCRIPTION_SALES_ACCOUNT_ID NUMBER 38 0 Subscription Sales Account Id DW_CXS_SALES_ACCOUNT_D SALES_ACCOUNT_ID
SUBSCRIPTION_CUSTOMER_PARTY_TYPE_CODE VARCHAR2 32 Party Type of the Customer (Subscription Primary Party). Stores values such as Person, Organization. DW_PARTY_TYPE_LKP_TL PARTY_TYPE_CODE
SUBSCRIPTION_STATUS_CODE VARCHAR2 32 Subscription Status. Stores values such as Active, Draft, Expired, Canceled, Pending approval, On Hold, Suspended, Closed, Under amendment. DW_CXS_SUBSCRIPTION_STATUS_D_TL CODE
SUBSCRIPTION_START_DATE DATE Subscription Start Date
SUBSCRIPTION_END_DATE DATE Subscription End Date
SUBSCRIPTION_APPROVED_DATE DATE The date on which the subscription is approved.
SUBSCRIPTION_SHORT_DESCRIPTION VARCHAR2 999 Subscription Short Description
SUBSCRIPTION_DESCRIPTION VARCHAR2 999 Subscription Description
SUBSCRIPTION_LEGAL_ENTITY_ID NUMBER 38 0 Legal entity identifier of the subscription. DW_LEGAL_ENTITY_D LEGAL_ENTITY_ID
SUBSCRIPTION_BUSINESS_UNIT_ID NUMBER 38 0 Business Unit Identifier of the subscription. DW_BUSINESS_UNIT_D_TL BUSINESS_UNIT_ID
SUBSCRIPTION_BILL_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0 Subscription bill-to account identifier DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
SUBSCRIPTION_BILL_TO_PARTY_ID NUMBER 38 0 Subscription bill-to party identifier DW_PARTY_ORGANIZATION_D PARTY_ID
SUBSCRIPTION_SHIP_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0 Subscription ship-to account identifier DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
SUBSCRIPTION_SHIP_TO_PARTY_ID NUMBER 38 0 Subscription ship-to party identifier DW_PARTY_ORGANIZATION_D PARTY_ID
SUBSCRIPTION_BILLING_DATE_CODE VARCHAR2 32 Code that identifies if the subscription has to be billed on period start, period end, on a specific day, or certain days before or after period start or end. Stores values such as Period start, Period end, Day, Offset . DW_CXS_BILLING_DATE_CODE_D_TL CODE
SUBSCRIPTION_BILL_SERVICE_CODE VARCHAR2 32 Code that identifies if the subscription has to be billed, not billed, or if only the subscription renewed from this subscription has to be billed. Stores values such as Bill, Do not bill, Bill on renewal. DW_CXS_BILL_SERVICE_D_TL CODE
SUBSCRIPTION_QUOTE_TO_CONTACT_ID NUMBER 38 0 The quote-to contact identifier. DW_CONTACT_D CONTACT_ID
SUBSCRIPTION_QUOTE_TO_CC_EMAIL VARCHAR2 999 Carbon copy email addresses to which subscription negotiation and renewal related communication mails will be sent.
SUBSCRIPTION_DAYS_BEFORE_EXPIRY NUMBER 38 0 The number of days before the expiry of the subscription that the subscription will be renewed
SUBSCRIPTION_PARTIAL_PERIOD_START_CODE VARCHAR2 32 The period start to be used when prorating price for partial periods. Stores values such as Calendar month, Service Start. DW_CXS_PERIOD_START_D_TL CODE
SUBSCRIPTION_PARTIAL_PERIOD_TYPE_CODE VARCHAR2 32 The period type to be used when prorating price for partial periods. Stores values such as Fixed, Actual. DW_CXS_PERIOD_TYPE_D_TL CODE
SUB_RENEWAL_PRICING_METHOD_USED_CODE VARCHAR2 32 The pricing method used during the renewal of the subscription. This attribute is applicable only for renewed subscriptions. Stores values such as Net price, List price. DW_CXS_RENEWAL_PRICING_METHOD_D_TL CODE
SUBSCRIPTION_RENEWAL_PROCESS_CODE VARCHAR2 32 The renewal process that will be used to renew the subscription. Stores values such as Net price, List price. DW_CXS_RENEWAL_TYPE_D_TL CODE
SUBSCRIPTION_RENEWAL_PROCESS_USED_CODE VARCHAR2 32 The renewal process used for the renewal of the subscription. This attribute is applicable only for renewed subscriptions. Stores values such as Net price, List price. DW_CXS_RENEWAL_TYPE_D_TL CODE
SUBSCRIPTION_INVOICE_TEXT VARCHAR2 999 Invoice text for subscription products.
SUBSCRIPTION_CREATION_DATE DATE Who column: indicates the date of the creation of the subscription.
SUBSCRIPTION_CREATION_TIMESTAMP TIMESTAMP Who column: indicates the date and time of the creation of the subscription.
SUBSCRIPTION_CREATED_BY VARCHAR2 128 Who column: indicates the user who created the subscription.
SUBSCRIPTION_LAST_UPDATE_DATE DATE Who column: indicates the date of the last update of the subscription.
SUBSCRIPTION_LAST_UPDATE_TIMESTAMP TIMESTAMP Who column: indicates the date and time of the last update of the subscription.
PRODUCT_NUMBER VARCHAR2 512 Subscription product number
PRODUCT_NAME VARCHAR2 512 The name of the subscription item and coverage item for subscription products and coverage products respectively.
STATUS_CODE VARCHAR2 32 Subscription Product Status. Stores values such as Active, Draft, Expired, Canceled, Pending approval, On Hold, Suspended, Closed, Under amendment. DW_CXS_SUBSCRIPTION_STATUS_D_TL CODE
BILLING_DATE_CODE VARCHAR2 32 Code that identifies if the subscription product has to be billed on period start, period end, on a specific day, or certain days before or after period start or end. Stores values such as Period start, Period end, Day, Offset . DW_CXS_BILLING_DATE_CODE_D_TL CODE
BILLING_FREQUENCY_CODE VARCHAR2 32 Frequency in which the subscription product has to be billed. Stores values such as DAY, MONTH, QUARTER, WEEK, YEAR. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
BILLING_OFFSET_DAYS NUMBER 38 0 The number of days offset from the bill-from date for advance invoice or the number of days offset from the bill-to date+1 for arrears invoice.
BILL_TO_SITE VARCHAR2 256 Subscription Product bill-to site
BILL_TO_LOCATION_ID NUMBER 38 0 Subscription Product bill-to site location Identifier DW_LOCATION_D LOCATION_ID
BILL_ON_DAY NUMBER The day of the month on which the subscription has to be billed.
PAYMENT_METHOD_CODE VARCHAR2 32 Subscription product payment method. Stores values such as Wire, Purchase order, Credit card. DW_CXS_PAYMENT_METHOD_D_TL CODE
PURCHASE_ORDER_NUMBER VARCHAR2 64 Purchase order number specified for subscription product payments
WIRE_NUMBER VARCHAR2 32 Wire number specified for subscription product payments
PAYMENT_TERM_ID NUMBER 38 0 Payment term identifier of the subscription product. Stores values such as Credit Card, Purchase Order, Wire. DW_PAYMENT_TERMS_D_TL PAYMENT_TERMS_ID
PRICE_ADJUSTMENT_BASIS_CODE VARCHAR2 32 Product Price Adjustment Basis. Stores values such as List price, Net price. DW_CXS_RENEWAL_PRICING_METHOD_D_TL CODE
PRICE_ADJUSTMENT_TYPE_CODE VARCHAR2 32 Product Price Adjustment Type. Stores values such as Discount percent, Markup amount, Price override, Markup percent, Discount amount. DW_CXS_PRICING_TERM_D_TL CODE
PRICE_LIST_NAME VARCHAR2 128 Price List Name
PRICE_AS_OF_DATE DATE The date that is used to determine the price list that applies to the product item.
PRICING_TERM_ADJUSTMENT_PERCENTAGE NUMBER Pricing Term Adjustment Percentage
PRICING_TERM_DURATION NUMBER Pricing Term Duration
PRICING_TERM_PERIOD_CODE VARCHAR2 16 Pricing Term Period. Stores values such as DAY, MONTH, QUARTER, WEEK, YEAR. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
PRICING_TERM_PRICING_METHOD_CODE VARCHAR2 32 Pricing Term Pricing Method. Store values such as Markup, Markdown, Reprice. DW_CXS_PRICING_TERM_D_TL CODE
PRICING_TERM_START_DATE DATE Pricing Term start Date
SUSPEND_REASON_CODE VARCHAR2 32 Suspend Reason. Stores values such as Breach, Quantity change, Product downgrade, Noncompliance, Product term change, Product upgrade. DW_CXS_CLOSE_REASON_D_TL CODE
SUSPEND_CREDIT_METHOD_CODE VARCHAR2 32 Suspend Credit Method. Store values such as Full, None, Prorate with credit, Prorate without credit. DW_CXS_SUSPEND_CREDIT_METHOD_D_TL CODE
SUSPENDED_DATE DATE Suspended Date
TAX_EXEMPT_REASON_CODE VARCHAR2 32 Tax exemption reason code associated with the Tax exemption number. Stores values such as Exempt, Override exemption, Required, Standard. DW_CXS_EXEMPTION_REASON_D_TL CODE
PRODUCT_CHANGE_REASON_CODE VARCHAR2 512 The reason code associated with the product change schedule. Stores values such as Breach, Quantity change, Product downgrade, Noncompliance, Product term change, Product upgrade. DW_CXS_CLOSE_REASON_D_TL CODE
PRODUCT_CHANGE_SCHEDULE VARCHAR2 32 Defines when the product change schedule is applicable.
PRODUCT_CHANGE_SCHEDULE_FROM_DATE DATE The date on which product change schedule is applicable.
CANCEL_REASON_CODE VARCHAR2 32 Reason for product cancellation. Stores values such as Pricing. DW_CXS_CANCEL_REASON_D_TL CODE
CANCELED_DATE DATE The date on which the subscription is cancelled
CLOSE_REASON_CODE VARCHAR2 32 Reason for product termination. Stores values such as Breach, Quantity change, Product downgrade, Noncompliance, Product term change, Product upgrade. DW_CXS_CLOSE_REASON_D_TL CODE
CLOSED_DATE DATE The date on which the subscription is terminated
CLOSE_CREDIT_METHOD_CODE VARCHAR2 32 The method that determines the credit that has to be offered to the customer at the time of product termination. Stores values such as Full, Prorate without credit, Prorate with credit. DW_CXS_CLOSE_CREDIT_METHOD_D_TL CODE
AMEND_CREDIT_METHOD_CODE VARCHAR2 32 The method that determines the credit that has to be offered to the customer at the time of product amendment. Stores values such as Full, Prorate without credit, Prorate with credit. DW_CXS_CLOSE_CREDIT_METHOD_D_TL CODE
AMEND_REASON_CODE VARCHAR2 32 Reason for product amendment. Stores values such as Breach, Quantity change, Product downgrade, Noncompliance, Product term change, Product upgrade. DW_CXS_CLOSE_REASON_D_TL CODE
AMEND_DESCRIPTION VARCHAR2 999 Amendment Description
AMEND_EFFECTIVE_DATE DATE Amendment Effective Date
ITEM_UOM VARCHAR2 16 Unit of measure of the product item. Stores value such as YEAR, MONTH, Each. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
CHURN_PROBABILITY NUMBER Churn probability of Subscription product
SHIP_TO_LOCATION_ID NUMBER 38 0 Subscription Product Ship to location Identifier DW_LOCATION_D LOCATION_ID
SHIP_TO_LOCATION VARCHAR2 256 Subscription Product Ship to Location
SHIP_TO_PARTY_ID NUMBER 38 0 Subscription Product ship-to party identifier DW_PARTY_ORGANIZATION_D PARTY_ID
SHIP_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0 Subscription Product ship-to account identifier DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
COVERAGE_SCHEDULE_ID NUMBER 38 0 Subscription coverage schedule identifier DW_CXSR_COVERAGE_HEADERS_D
INVENTORY_ITEM_ID NUMBER 38 0 Inventory Item Identifier DW_SYSTEM_INVENTORY_ITEM_D_TL INVENTORY_ITEM_ID
INVENTORY_ORGANIZATION_ID NUMBER 38 0 Inventory organization identifier where Item is defined. DW_INTERNAL_ORG_D_TL ORGANIZATION_ID
SCHEDULED_INVENTORY_ITEM_ID NUMBER 38 0 Identifier of the Inventory Item related to the Subscription Product. The subscription product will be replaced with this inventory item during product change schedule. DW_SYSTEM_INVENTORY_ITEM_D_TL INVENTORY_ITEM_ID
SCHEDULED_INVENTORY_ORGANIZATION_ID NUMBER 38 0 Inventory organization identifier where Scheduled Item is defined. DW_INTERNAL_ORG_D_TL ORGANIZATION_ID
SCHEDULED_PRODUCT_NAME VARCHAR2 512 Name of the replacement Inventory Item related to the Subscription Product.
SCHEDULED_ITEM_UOM VARCHAR2 16 Unit of measure of the replacement Inventory Item related to the Subscription Product. Stores value such as YEAR, MONTH, Each. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
TAX_EXEMPTION_CONTROL_CODE VARCHAR2 32 Tax exemption control specified on the subscription product for tax calculation. Stores values such as Exempt, Override exemption, Required, Standard. DW_CXS_TAX_EXEMPTION_CONTROL_D_TL CODE
RENEWAL_TYPE_CODE VARCHAR2 32 The renewal type that is selected for the subscription product. Stores values such as Renew, Do not renew. DW_CXS_RENEWAL_ACTION_D_TL CODE
RENEWAL_PAYMENT_METHOD_CODE VARCHAR2 32 Renewal subscription product payment method. Stores values such as Credit card, Wire, Purchase order. DW_CXS_PAYMENT_METHOD_D_TL CODE
RENEWED_DATE DATE The date on which the product is renewed.
SUMMARIZED_BILLING_FLAG VARCHAR2 16 This attribute indicates if the billing schedule generated is detailed or summarized.
DROP_ONE_TIME_CHARGE_FLAG VARCHAR2 16 Flag to determine if one time charges are dropped during product change.
ENABLE_PRICING_TERM_FLAG VARCHAR2 16 The enable pricing terms flag which holds the Y and N.
GENERATE_FULL_PERIOD_FLAG VARCHAR2 16 Generate Billing Schedules for the Full Period Flag
CURRENCY_CODE VARCHAR2 16 Product transaction currency. Stores values such as DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
GLOBAL_CURRENCY_CODE VARCHAR2 16 Global Currency Code DW_CURRENCY_DETAILS_D_TL CURRENCY_CODE
ESTIMATED_TAX NUMBER Estimated Tax
GLOBAL_ESTIMATED_TAX NUMBER Estimated tax converted to Global Currency
MONTHLY_RECURRING_REVENUE NUMBER Monthly Recurring Revenue
GLOBAL_MONTHLY_RECURRING_REVENUE NUMBER Monthly Recurring Revenue converted to Global Currency
PRODUCT_NET_PRICE NUMBER Total fixed value of the product exclusive of estimated tax. Fixed value excludes usage charges.
GLOBAL_PRODUCT_NET_PRICE NUMBER Total fixed value of the product exclusive of estimated tax converted to Global Currency. Fixed value excludes usage charges.
INVOICED_AMOUNT NUMBER The total fixed value of product that is invoiced. Fixed value excludes usage charges.
GLOBAL_INVOICED_AMOUNT NUMBER The total fixed value of product that is invoiced converted to Global Currency. Fixed value excludes usage charges.
CREDITED_AMOUNT NUMBER The total fixed value of product that is credited back to customer due to product termination. Fixed value excludes usage charges.
GLOBAL_CREDITED_AMOUNT NUMBER The total fixed value of product that is credited back to customer due to product termination converted to Global Currency. Fixed value excludes usage charges.
CLOSED_AMOUNT NUMBER The total fixed value of product that was lost due to termination. Fixed value excludes usage charges.
GLOBAL_CLOSED_AMOUNT NUMBER The total fixed value of product that was lost due to termination converted to Global Currency. Fixed value excludes usage charges.
CANCELED_AMOUNT NUMBER The total fixed value of products that was lost due to cancelation. Fixed value excludes usage charges.
GLOBAL_CANCELED_AMOUNT NUMBER The total fixed value of products that was lost due to cancelation converted to Global Currency. Fixed value excludes usage charges.
CREATION_DATE DATE Who column: indicates the date of the creation of the subscription product.
CREATION_TIMESTAMP TIMESTAMP Who column: indicates the date and timeof the creation of the subscription product.
CREATED_BY VARCHAR2 128 Who column: indicates the user who created the subscription product.
LAST_UPDATE_DATE DATE Who column: indicates the date of the last update of the subscription product.
LAST_UPDATE_TIMESTAMP TIMESTAMP Who column: indicates the date and time of the last update of the subscription product.
SALES_PRODUCT_TYPE_CODE VARCHAR2 32 Identifies type of product. Stores values such as Software Maintenance, Subscription, Included Warranty, and Extended Warranty. DW_CXS_SALES_PRODUCT_TYPE_D_TL CODE
START_DATE DATE Product start date.
END_DATE DATE Product end date
BILL_TO_PARTY_ID NUMBER 38 0 Subscription product bill-to party identifier DW_PARTY_ORGANIZATION_D PARTY_ID
BILL_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0 Subscription product bill-to account identifier DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
QUANTITY NUMBER Product item quantity.
PRICE_ADJUSTMENT_PERCENTAGE NUMBER Product Price Adjustment Percentage
PERPETUAL_FLAG VARCHAR2 16 Product is Perpetual if no End Date
NEW_SUBSCRIPTION_FLAG VARCHAR2 16 A Flag indicating if the current Subscription Product line is a New Subscription.
RENEWED_SUBSCRIPTION_FLAG VARCHAR2 16 A Flag for the Subscription Product lines that exist as Targets of a Renewal Relationship.
MRR_EXPANSION_FLAG VARCHAR2 16 A Flag for the Subscription Product lines which are targets of an AMEND relationship and target MRR > source MRR.
MRR_CONTRACTION_FLAG VARCHAR2 16 A Flag for the Subscription Product lines which are targets of an AMEND relationship and target MRR < source MRR.
EXPANSION_CONTRACTION_MRR NUMBER A Signed Amount column for the Subscription Product lines which are targets of an AMEND relationship and target MRR <> source MRR Calculated as (Target MRR - Source MRR).
RENEWAL_LAPSE_FLAG VARCHAR2 16 A Flag for the Subscription Product lines, which meet the below conditions Not Renewed and are let to be Expired Or Renewed and currently Renewal-Target is in Cancelled status.
SUBSCRIPTION_PRODUCT_NUMBER VARCHAR2 128 Public Uniquer Identifier of the Subscription Product.
GLOBAL_EXPANSION_CONTRACTION_MRR NUMBER A Signed Amount column for the Subscription Product lines which are targets of an AMEND relationship and target MRR <> source MRR Calculated as (Target MRR - Source MRR).
EARLY_TERMINATION_FEE NUMBER The early termination fee for subscription product.
GLOBAL_EARLY_TERMINATION_FEE NUMBER The early termination fee for subscription product converted to Global Currency.