DW_CXS_SUBSCRIPTION_PRODUCT_EN

This entity 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 Subscription Product Identifier    
SOURCE_RECORD_ID VARCHAR2 64     System    
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_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 Subscription Primary Party DW_PARTY_TYPE_LKP_TL PARTY_TYPE_CODE
SUBSCRIPTION_STATUS_CODE VARCHAR2 32     Subscription Status 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 1024     Subscription Short Description    
SUBSCRIPTION_DESCRIPTION VARCHAR2 2048     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 BUSINESS_UNIT_ID
SUBSCRIPTION_BILL_TO_ACCT_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_ACCT_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. 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 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 2048     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 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 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. 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. DW_CXS_RENEWAL_PROCESS_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. DW_CXS_RENEWAL_PROCESS_D_TL CODE
SUBSCRIPTION_INVOICE_TEXT VARCHAR2 4000     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 timeof 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 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. DW_CXS_BILLING_DATE_CODE_D_TL CODE
BILLING_FREQUENCY_CODE VARCHAR2 32     Frequency in which the subscription product has to be billed 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_USE_ID NUMBER 38 0   Subscription Product bill-to site identifier    
BILL_TO_PARTY_ID NUMBER 38 0   Subscription product bill-to party identifier DW_PARTY_ORGANIZATION_D PARTY_ID
BILL_TO_ACCT_ID NUMBER 38 0   Subscription product bill-to account identifier DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
SHIP_TO_PARTY_ID NUMBER 38 0   Subscription Product ship-to party identifier DW_PARTY_ORGANIZATION_D PARTY_ID
SHIP_TO_ACCT_ID NUMBER 38 0   Subscription product ship-to account identifier DW_CUSTOMER_ACCOUNT_D CUSTOMER_ACCOUNT_ID
SHIP_TO_PARTY_SITE_ID NUMBER 38 0   Subscription Product Ship to site Party Identifier    
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 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. DW_PAYMENT_TERMS_D_TL PAYMENT_TERMS_ID
PRICE_ADJUSTMENT_BASIS_CODE VARCHAR2 32     Product Price Adjustment Basis DW_CXS_RENEWAL_PRICING_METHOD_D_TL CODE
PRICE_ADJUSTMENT_TYPE_CODE VARCHAR2 32     Product Price Adjustment Type 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    
PRICING_TERM_PRICING_METHOD_CODE VARCHAR2 32     PricingTermPricingMethod DW_CXS_PRICING_TERM_D_TL CODE
PRICING_TERM_START_DATE DATE       Pricing Term start Date    
SUSPEND_REASON_CODE VARCHAR2 32     Suspend Reason DW_CXS_CLOSE_REASON_D_TL CODE
SUSPEND_CREDIT_METHOD_CODE VARCHAR2 32     Suspend Credit Method 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. DW_CXS_EXEMPTION_REASON_D_TL CODE
PRODUCT_CHANGE_REASON_CODE VARCHAR2 512     The reason code associated with the product change schedule. 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. 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. 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. 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. DW_CXS_CLOSE_CREDIT_METHOD_D_TL CODE
AMEND_REASON_CODE VARCHAR2 32     Reason for product amendment. DW_CXS_CLOSE_REASON_D_TL CODE
AMEND_DESCRIPTION VARCHAR2 2048     Amendment Description    
AMEND_EFFECTIVE_DATE DATE       Amendment Effective Date    
ITEM_UOM VARCHAR2 16     Unit of measure of the product item. DW_UNIT_OF_MEASURE_D_TL UOM_CODE
CHURN_PROBABILITY NUMBER       Churn probability of Subscription product    
INVENTORY_ITEM_ORG_ID NUMBER 38 0   Inventory organization where Item is defined. DW_INTERNAL_ORG_D ORGANIZATION_ID
SCHEDULED_PRODUCT_NAME VARCHAR2 512     Name of the replacement Inventory Item related to the Subscription Product.    
SCHEDULED_INVENTORY_ITEM_ID NUMBER 38 0   Identifier of the Inventory Item related to the Subscription Product. The subcription product will be replaced with this inventory item during product change schedule. DW_SYSTEM_INVENTORY_ITEM_D_TL INVENTORY_ITEM_ID
SCHEDULED_ITEM_UOM VARCHAR2 16     Unit of measure of the replacement Inventory Item related to the Subscription Product. 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. DW_CXS_TAX_EXEMPTION_CONTROL_D_TL CODE
RENEWAL_TYPE_CODE VARCHAR2 32     The renewal type that is selected for the subscription product DW_CXS_RENEWAL_TYPE_D_TL CODE
RENEWAL_PAYMENT_METHOD_CODE VARCHAR2 32     Renewal subscription product payment method DW_CXS_PAYMENT_METHOD_D_TL CODE
RENEWED_DATE DATE       The date on which the product is renewed.    
SUMMARIZED_BILLING_YN VARCHAR2 16     This attribute indicates if the billing schedule generated is detailed or summarized.    
DROP_ONE_TIME_CHARGE_YN VARCHAR2 16     Flag to determine if one time charges are dropped during product change.    
ENABLE_PRICING_TERM_YN VARCHAR2 16     The enable pricing terms flag which holds the Y and N.    
GENERATE_FULL_PERIOD_YN VARCHAR2 16     Generate Billing Schedules for the Full Period Flag    
CURRENCY_CODE VARCHAR2 16     Product transaction currency    
GLOBAL_CURRENCY_CODE VARCHAR2 16     Global Currency Code    
ESTIMATED_TAX NUMBER       EstimatedTax    
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.    
INVENTORY_ITEM_ID NUMBER 38 0   Inventory Item Identifier DW_SYSTEM_INVENTORY_ITEM_D_TL INVENTORY_ITEM_ID
SALES_PRODUCT_TYPE_CODE VARCHAR2 32     Identifies type of product like Subscription, Coverage and Warranty DW_CXS_SALES_PRODUCT_TYPE_D_TL CODE
START_DATE DATE       Product start date.    
END_DATE DATE       Product end date    
QUANTITY NUMBER       Product item quantity.    
PRICE_ADJUSTMENT_PERCENTAGE NUMBER       Product Price Adjustment Percentage    
PERPETUAL_FLAG VARCHAR2 16     Product is Perpetual if no End Date    
SUBSCRIPTION_PRODUCT_NUMBER VARCHAR2 128     Public Uniquer Identifier of the Subscription Product    
EARLY_TERMINATION_FEE NUMBER       The calculated early termination fee for subscription product.    
GLOBAL_EARLY_TERMINATION_FEE NUMBER       The calculated early termination fee for subscription product converted to Global Currency