DW_CXS_SUBSCRIPTION_DAILY_SNAPSHOT_F

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 This column is for Oracle Internal use only.
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
EXPIRED_FLAG VARCHAR2 16
CREATION_OPERATION_CODE VARCHAR2 32
SOURCE_SUBSCRIPTION_PRODUCT_ID NUMBER 38 0
SOURCE_SUBSCRIPTION_MRR NUMBER
SOURCE_SUBSCRIPTION_PRODUCT_NET_PRICE NUMBER
GLOBAL_CURRNCY_MONTHLY_RECURRING_REVENUE NUMBER
GLOBAL_CURRENCY_PRODUCT_NET_PRICE NUMBER
GLOBAL_CURRENCY_SOURCE_SUBSCRIPTION_MRR NUMBER
GLOBAL_CURRENCY_SOURCE_SUBSCRIPTION_PRODUCT_NET_PRICE 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