1. Tables and Views for Sales, Fusion Service, and Field Service
  2. ZCA_BI_PRODUCT_DENORM

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_N1 Non Unique Default INVENTORY_ITEM_ID, INV_ORG_ID, USAGE_CODE, LAST_PROD_GRP_ID
ZCA_BI_PRODUCT_DENORM_U1 Unique Default PRODUCT_ID, USAGE_CODE