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