This fact 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 | 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 | 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_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 | 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. 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 | 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 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 | 2048 | 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. |