This entity table stores the subscription product details
Module: Subscription Management
SUBSCRIPTION_PRODUCT_ID
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 |