DW_CXS_SUBSCRIPTION_YEARLY_SNAPSHOT_F (Preview)

This table requires activation of Subscription Management Snapshot functional area. This fact table stores the subscription aggregate monthly data

Details

Module: Subscription Management

Key Columns

SUBSCRIPTION_PRODUCT_ID, SNAPSHOT_PERIOD_ID

Columns

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