ZCA_BI_PRODUCT_DENORM
This is a denormalized Product table used for BI
Details
-
Schema: FUSION
-
Object owner: ZCA
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
Name | Columns |
---|---|
ZCA_BI_PRODUCT_DENORM_PK |
PRODUCT_ID, USAGE_CODE |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
PRODUCT_ID | NUMBER | 18 | Yes | PRODUCT_ID | Active | |
INVENTORY_ITEM_ID | NUMBER | INVENTORY_ITEM_ID | Active | |||
INV_ORG_ID | NUMBER | INV_ORG_ID | Active | |||
ITEM_OR_PRODGRP | VARCHAR2 | 13 | ITEM_OR_PRODGRP | Active | ||
FIRST_PROD_GRP_ID | NUMBER | 18 | FIRST_PROD_GRP_ID | Active | ||
LAST_PROD_GRP_ID | NUMBER | 18 | LAST_PROD_GRP_ID | Active | ||
DENORM_DISTANCE_NUM | NUMBER | 18 | DENORM_DISTANCE_NUM | Active | ||
PGLEVEL0TOTOP | VARCHAR2 | 500 | PGLEVEL0TOTOP | Active | ||
PGLEVEL1TOTOP | VARCHAR2 | 500 | PGLEVEL1TOTOP | Active | ||
PGLEVEL2TOTOP | VARCHAR2 | 500 | PGLEVEL2TOTOP | Active | ||
PGLEVEL3TOTOP | VARCHAR2 | 500 | PGLEVEL3TOTOP | Active | ||
PGLEVEL4TOTOP | VARCHAR2 | 500 | PGLEVEL4TOTOP | Active | ||
PGLEVEL5TOTOP | VARCHAR2 | 500 | PGLEVEL5TOTOP | Active | ||
PGLEVEL6TOTOP | VARCHAR2 | 500 | PGLEVEL6TOTOP | Active | ||
PGLEVEL7TOTOP | VARCHAR2 | 500 | PGLEVEL7TOTOP | Active | ||
PGLEVEL8TOTOP | VARCHAR2 | 500 | PGLEVEL8TOTOP | Active | ||
PGLEVEL9TOTOP | VARCHAR2 | 500 | PGLEVEL9TOTOP | Active | ||
PGLEVEL10TOTOP | VARCHAR2 | 500 | PGLEVEL10TOTOP | Active | ||
PGLEVEL11TOTOP | VARCHAR2 | 500 | PGLEVEL11TOTOP | Active | ||
PGLEVEL12TOTOP | VARCHAR2 | 500 | PGLEVEL12TOTOP | Active | ||
PGLEVEL13TOTOP | VARCHAR2 | 500 | PGLEVEL13TOTOP | Active | ||
PGLEVEL14TOTOP | VARCHAR2 | 500 | PGLEVEL14TOTOP | Active | ||
USAGE_CODE | VARCHAR2 | 30 | Yes | USAGE_CODE | Active | |
REL_ACTIVE_FLAG | VARCHAR2 | 1 | REL_ACTIVE_FLAG | |||
REL_START_DATE | TIMESTAMP | REL_START_DATE | ||||
REL_END_DATE | TIMESTAMP | REL_END_DATE | ||||
AGGREG_REL_START_DATE | TIMESTAMP | AGGREG_REL_START_DATE | ||||
AGGREG_REL_END_DATE | TIMESTAMP | AGGREG_REL_END_DATE | ||||
BASEPG_ACTIVE_FLAG | VARCHAR2 | 1 | BASEPG_ACTIVE_FLAG | |||
BASEPG_START_DATE | TIMESTAMP | BASEPG_START_DATE | ||||
BASEPG_END_DATE | TIMESTAMP | BASEPG_END_DATE | ||||
INVITEMEXPMEMFLAG | VARCHAR2 | 1 | INVITEMEXPMEMFLAG | Active | ||
BASELEVELEXPMEMFLAG | VARCHAR2 | 1 | BASELEVELEXPMEMFLAG | Active | ||
PGLEVEL1EXPMEMFLAG | VARCHAR2 | 1 | PGLEVEL1EXPMEMFLAG | Active | ||
PGLEVEL2EXPMEMFLAG | VARCHAR2 | 1 | PGLEVEL2EXPMEMFLAG | Active | ||
PGLEVEL3EXPMEMFLAG | VARCHAR2 | 1 | PGLEVEL3EXPMEMFLAG | Active | ||
PGLEVEL4EXPMEMFLAG | VARCHAR2 | 1 | PGLEVEL4EXPMEMFLAG | Active | ||
PGLEVEL5EXPMEMFLAG | VARCHAR2 | 1 | PGLEVEL5EXPMEMFLAG | Active | ||
PGLEVEL6EXPMEMFLAG | VARCHAR2 | 1 | PGLEVEL6EXPMEMFLAG | Active | ||
PGLEVEL7EXPMEMFLAG | VARCHAR2 | 1 | PGLEVEL7EXPMEMFLAG | Active | ||
PGLEVEL8EXPMEMFLAG | VARCHAR2 | 1 | PGLEVEL8EXPMEMFLAG | Active | ||
TOPLEVELEXPMEMFLAG | VARCHAR2 | 1 | TOPLEVELEXPMEMFLAG | Active | ||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | ||
PRPD_GRP_REF_NUMBER | VARCHAR2 | 50 | Identifier used for integration with external systems. source: QSC_PROD_GRP_DETAILS.REF_NUMBER |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
ZCA_BI_PRODUCT_DENORM_U1 | Unique | Default | PRODUCT_ID, USAGE_CODE |