DW_CXS_SUBSCRIPTION_DAILY_SNAPSHOT_F
Module: Subscription Management
SNAPSHOT_DATE, SUBSCRIPTION_PRODUCT_ID
| 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 |
Copyright © 2019, 2025, Oracle and/or its affiliates.