CREATE TABLE msc_data_102141_dyd (
    TIM_LVL_MEMBER_ID            NUMBER      ,
    PRD_LVL_MEMBER_ID            NUMBER      ,
    DCS_LVL_MEMBER_ID            NUMBER      ,
    CUS_LVL_MEMBER_ID            NUMBER      ,
    ORG_LVL_MEMBER_ID            NUMBER      ,
    BOOK_FCST_OTHER              NUMBER      ,
    MKTG_FCST_VALUE              NUMBER      ,
    FIN_FCST_VALUE               NUMBER      ,
    ADJ_SALES_FCST               NUMBER      ,
    APPROVED_FCST                NUMBER      ,
    ADJ_MKTG_FCST                NUMBER      ,
    ADJ_SHIP_FCST                NUMBER      ,
    ADJ_BOOK_FCST                NUMBER      ,
    INDEP_DEM_QTY                NUMBER      ,
    SHELF_PRICE                  NUMBER      ,
    ADJ_WTD_FCST                 NUMBER      ,
    BOOK_FCST_NUMBER_OL          NUMBER      ,
    ADJUST_PRICE                 NUMBER      ,
    SHIP_FCST_NUMBER_OL          NUMBER      ,
    APPROVED_CONSENSUS_FCST      NUMBER      ,
    SO_FCST_RISK_VALUE           NUMBER      ,
    WTD_FCST_CHG_PCT             NUMBER      ,
    SO_BY_SCHED_DATE             NUMBER      ,
    AVG_DMD_FOR_COMB             NUMBER      ,
    CONSTRAINED_FCST             NUMBER      ,
    MANUAL_DM                    NUMBER      ,
    SALES_FCST_VALUE             NUMBER      ,
    SHIP_FCST_COMB_REGIME_CHG    NUMBER      ,
    BOOK_FCST_COMB_REGIME_CHG    NUMBER      ,
    FINAL_SALES_FCST_PCT_WGHT    NUMBER      ,
    FINAL_MKTG_FCST_PCT_WGHT     NUMBER      ,
    FINAL_SHIP_FCST_PCT_WGHT     NUMBER      ,
    FCST_DMD_MET_BY_INCOMING     NUMBER      ,
    FCST_SIM_OUT_MSR_2           NUMBER      ,
    FCST_SIM_OUT_MSR_1           NUMBER      ,
    SO_VALUE_BY_SCHED_DATE       NUMBER      ,
    SALES_FCST_PCT_CHANGE        NUMBER      ,
    FINAL_BOOK_FCST_PCT_WGHT     NUMBER      ,
    SHIP_FCST_PCT_CHANGE         NUMBER      ,
    MKTG_FCST_PCT_CHANGE         NUMBER      ,
    BOOK_FCST_PCT_CHANGE         NUMBER      ,
    SHIP_FCST                    NUMBER      ,
    APPR_FINAL_BOOK_FORECAST     NUMBER      ,
    MKTG_FCST                    NUMBER      ,
    SALES_FCST                   NUMBER      ,
    FILL_QTY                     NUMBER      ,
    NET_FCST                     NUMBER      ,
    REVENUE                      NUMBER      ,
    BOOK_FCST                    NUMBER      ,
    SO_BY_RD                     NUMBER      ,
    LAST_UPDATE_DATE             TIMESTAMP(6),
    IS_FICTIVE                   NUMBER      ,
    TIM_LVL_MEMBER_ID            NUMBER      ,
    PRD_LVL_MEMBER_ID            NUMBER      ,
    DCS_LVL_MEMBER_ID            NUMBER      ,
    CUS_LVL_MEMBER_ID            NUMBER      ,
    ORG_LVL_MEMBER_ID            NUMBER      ,
    BOOK_FCST_OTHER              NUMBER      ,
    MKTG_FCST_VALUE              NUMBER      ,
    FIN_FCST_VALUE               NUMBER      ,
    ADJ_SALES_FCST               NUMBER      ,
    APPROVED_FCST                NUMBER      ,
    ADJ_MKTG_FCST                NUMBER      ,
    ADJ_SHIP_FCST                NUMBER      ,
    ADJ_BOOK_FCST                NUMBER      ,
    INDEP_DEM_QTY                NUMBER      ,
    SHELF_PRICE                  NUMBER      ,
    ADJ_WTD_FCST                 NUMBER      ,
    BOOK_FCST_NUMBER_OL          NUMBER      ,
    ADJUST_PRICE                 NUMBER      ,
    SHIP_FCST_NUMBER_OL          NUMBER      ,
    APPROVED_CONSENSUS_FCST      NUMBER      ,
    SO_FCST_RISK_VALUE           NUMBER      ,
    WTD_FCST_CHG_PCT             NUMBER      ,
    SO_BY_SCHED_DATE             NUMBER      ,
    AVG_DMD_FOR_COMB             NUMBER      ,
    CONSTRAINED_FCST             NUMBER      ,
    MANUAL_DM                    NUMBER      ,
    SALES_FCST_VALUE             NUMBER      ,
    SHIP_FCST_COMB_REGIME_CHG    NUMBER      ,
    BOOK_FCST_COMB_REGIME_CHG    NUMBER      ,
    FINAL_SALES_FCST_PCT_WGHT    NUMBER      ,
    FINAL_MKTG_FCST_PCT_WGHT     NUMBER      ,
    FINAL_SHIP_FCST_PCT_WGHT     NUMBER      ,
    FCST_DMD_MET_BY_INCOMING     NUMBER      ,
    FCST_SIM_OUT_MSR_2           NUMBER      ,
    FCST_SIM_OUT_MSR_1           NUMBER      ,
    SO_VALUE_BY_SCHED_DATE       NUMBER      ,
    SALES_FCST_PCT_CHANGE        NUMBER      ,
    FINAL_BOOK_FCST_PCT_WGHT     NUMBER      ,
    SHIP_FCST_PCT_CHANGE         NUMBER      ,
    MKTG_FCST_PCT_CHANGE         NUMBER      ,
    BOOK_FCST_PCT_CHANGE         NUMBER      ,
    SHIP_FCST                    NUMBER      ,
    APPR_FINAL_BOOK_FORECAST     NUMBER      ,
    MKTG_FCST                    NUMBER      ,
    SALES_FCST                   NUMBER      ,
    FILL_QTY                     NUMBER      ,
    NET_FCST                     NUMBER      ,
    REVENUE                      NUMBER      ,
    BOOK_FCST                    NUMBER      ,
    SO_BY_RD                     NUMBER      ,
    LAST_UPDATE_DATE             TIMESTAMP(6),
    IS_FICTIVE                   NUMBER      ,
    CONSTRAINT pk_msc_data_102141_dyd PRIMARY KEY (TIM_LVL_MEMBER_ID, PRD_LVL_MEMBER_ID, DCS_LVL_MEMBER_ID, CUS_LVL_MEMBER_ID, ORG_LVL_MEMBER_ID, TIM_LVL_MEMBER_ID, PRD_LVL_MEMBER_ID, DCS_LVL_MEMBER_ID, CUS_LVL_MEMBER_ID, ORG_LVL_MEMBER_ID)
);
