This table requires activation of Subscription Management Snapshot functional area. This fact table stores the subscription aggregate monthly data
Module: Subscription Management
SUBSCRIPTION_PRODUCT_ID, SNAPSHOT_PERIOD_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
SUBSCRIPTION_PRODUCT_ID | NUMBER | 38 | 0 | True | Subscription product identifier | ||
SNAPSHOT_PERIOD_ID | NUMBER | 38 | 0 | True | Snapshot Period Identifier | DW_CXS_SUBSCRIPTION_SNAPSHOT_D | SNAPSHOT_PERIOD_ID |
SOURCE_RECORD_ID | VARCHAR2 | 128 | Unique Key | ||||
STATUS_CODE | VARCHAR2 | 32 | Status | DW_CXS_SUBSCRIPTION_STATUS_D_TL | CODE | ||
START_DATE | DATE | Subscription Start Date | |||||
END_DATE | DATE | Subscription End Date | |||||
CREATION_OPERATION_CODE | VARCHAR2 | 32 | Derived. It will hold the action due to which subscription is created. Such as RENEW, AMEND, SUSPEND | DW_CXS_SUBSCRIPTION_OPERATION_D_TL | CODE | ||
INVENTORY_ORGANIZATION_ID | NUMBER | 38 | 0 | Definition Org Identifier | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |
INVENTORY_ITEM_ID | NUMBER | 38 | 0 | Inventory Item Identifier | DW_SYSTEM_INVENTORY_ITEM_D_TL | INVENTORY_ITEM_ID | |
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 | ||
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 | ||
CURRENCY_CODE | VARCHAR2 | 16 | Product transaction currency | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
BUSINESS_UNIT_ID | NUMBER | 38 | 0 | Business Unit Identifier of the subscription | DW_BUSINESS_UNIT_D_TL | BUSINESS_UNIT_ID | |
PRIMARY_PARTY_ID | NUMBER | 38 | 0 | Customer Party Identifier | DW_PARTY_ORGANIZATION_D | PARTY_ID | |
SALES_ACCOUNT_ID | NUMBER | 38 | 0 | Sales account identifier for the subscription primary party where party has a sales account associated to it | DW_CXS_SALES_ACCOUNT_D | SALES_ACCOUNT_ID | |
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 | |
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 | |
SALES_PRODUCT_TYPE_CODE | VARCHAR2 | 64 | Sales Product Type | DW_CXS_SALES_PRODUCT_TYPE_D_TL | CODE | ||
CUSTOMER_PARTY_TYPE_CODE | VARCHAR2 | 64 | Customer Party Type | DW_CXS_CUSTOMER_PARTY_TYPE_D_TL | CODE | ||
CUSTOMER_FIRST_SUBSCRIPTION_START_DATE | DATE | First subscription start date of customer | |||||
GLOBAL_CURRENCY_CODE | VARCHAR2 | 16 | Global currency code | DW_CURRENCY_DETAILS_D_TL | CURRENCY_CODE | ||
PRODUCT_NET_PRICE | NUMBER | The sum of Product Net Price of active subscriptions at the end of a particular period and the subscriptions that got closed or expired during that period | |||||
GLOBAL_CURRENCY_PRODUCT_NET_PRICE | NUMBER | The sum of Product Net Price of active subscriptions at the end of a particular period and the subscriptions that got closed or expired during that period converted to Global Currency | |||||
MONTHLY_RECURRING_REVENUE | NUMBER | The sum of Monthly Recurring Revenue of active subscriptions at the end of a particular period and the subscriptions that got closed or expired during that period | |||||
GLOBAL_CURRNCY_MONTHLY_RECURRING_REVENUE | NUMBER | The sum of Monthly Recurring Revenue of active subscriptions at the end of a particular period and the subscriptions that got closed or expired during that period converted to Global Currency | |||||
DUE_RENEWAL_FLAG | VARCHAR2 | 16 | Flag to be used for calculating Due renewal metrics | ||||
TERMINATED_FLAG | VARCHAR2 | 16 | Flag to be used for calculating Closed subscription metrics | ||||
RENEW_CHURN_LAPSE_FLAG | VARCHAR2 | 16 | Flag to be used for calculating renew churn lapse metrics | ||||
RENEW_LAPSE_FLAG | VARCHAR2 | 16 | Flag to be used for calculating renew lapse metrics | ||||
RENEW_CHURN_FLAG | VARCHAR2 | 16 | Flag to be used for calculating renew churn metrics | ||||
PRODUCT_CHURN_FLAG | VARCHAR2 | 16 | Flag to be used for calculating product churn metrics | ||||
SOURCE_SUBSCRIPTION_PRODUCT_ID | NUMBER | 38 | 0 | Source subscription product identifier for subscription created due to Renewal, Amend or Suspend | |||
SOURCE_SUBSCRIPTION_MRR | NUMBER | MRR for the Source subscription product for subscription created due to Renewal, Amend or Suspend | |||||
GLOBAL_CURRENCY_SOURCE_SUBSCRIPTION_MRR | NUMBER | MRR in global currency for the Source subscription product for subscription created due to Renewal, Amend or Suspend |
Copyright © 2019, 2023, Oracle and/or its affiliates.