DW_CXS_SUBSCRIPTION_DAILY_SNAPSHOT_F (Preview)

This table requires activation of Subscription Management Snapshot functional area. DW_CXS_SUBSCRIPTION_DAILY_SNAPSHOT_F

Details

Module: Subscription Management

Key Columns

SUBSCRIPTION_PRODUCT_ID, SNAPSHOT_DATE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SUBSCRIPTION_PRODUCT_ID NUMBER 38 0 True      
SNAPSHOT_DATE DATE     True      
SOURCE_RECORD_ID VARCHAR2 256          
SUBSCRIPTION_ID NUMBER 38 0        
PRIMARY_PARTY_ID NUMBER 38 0        
SALES_ACCOUNT_ID NUMBER 38 0        
STATUS_CODE VARCHAR2 32          
ITEM_UOM VARCHAR2 16          
INVENTORY_ITEM_ID NUMBER 38 0        
INVENTORY_ORGANIZATION_ID NUMBER 38 0        
CURRENCY_CODE VARCHAR2 16          
MONTHLY_RECURRING_REVENUE NUMBER            
PRODUCT_NET_PRICE NUMBER            
BILLING_FREQUENCY_CODE VARCHAR2 32          
BUSINESS_UNIT_ID NUMBER 38 0        
trandate DATE            
START_DATE DATE            
END_DATE DATE            
SALES_PRODUCT_TYPE_CODE VARCHAR2 64          
DUE_RENEWAL_FLAG VARCHAR2 16          
TERMINATED_FLAG VARCHAR2 16          
RENEW_CHURN_LAPSE_FLAG VARCHAR2 16          
RENEW_LAPSE_FLAG VARCHAR2 16          
RENEW_CHURN_FLAG VARCHAR2 16          
PRODUCT_CHURN_FLAG VARCHAR2 16          
CREATION_OPERATION_CODE VARCHAR2 32          
SOURCE_SUBSCRIPTION_PRODUCT_ID NUMBER 38 0        
SOURCE_SUBSCRIPTION_MRR NUMBER            
GLOBAL_CURRNCY_MONTHLY_RECURRING_REVENUE NUMBER            
GLOBAL_CURRENCY_PRODUCT_NET_PRICE NUMBER            
GLOBAL_CURRENCY_SOURCE_SUBSCRIPTION_MRR NUMBER            
SHIP_TO_PARTY_ID NUMBER 38 0        
SHIP_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0        
BILL_TO_PARTY_ID NUMBER 38 0        
BILL_TO_CUSTOMER_ACCOUNT_ID NUMBER 38 0        
CUSTOMER_FIRST_SUBSCRIPTION_START_DATE DATE            
GLOBAL_CURRENCY_CODE VARCHAR2 16          
AGE NUMBER 38 0        

Copyright © 2019, 2023, Oracle and/or its affiliates.