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     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
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.    

Copyright © 2019, 2023, Oracle and/or its affiliates.