CREATE TABLE msc_data_102154_dyd (
    PRD_LVL_MEMBER_ID              NUMBER        ,
    DCS_LVL_MEMBER_ID              NUMBER        ,
    CUS_LVL_MEMBER_ID              NUMBER        ,
    ORG_LVL_MEMBER_ID              NUMBER        ,
    BOOK_FCST_BIAS                 NUMBER        ,
    BOOK_FCST_MAPE                 NUMBER        ,
    MEASURE_300000154512874        NUMBER        ,
    SHIP_FCST_BIAS                 NUMBER        ,
    SHIP_FCST_MAPE                 NUMBER        ,
    MKTG_FCST_BIAS                 NUMBER        ,
    SALES_FCST_MAD                 NUMBER        ,
    BOOK_FCST_MAD                  NUMBER        ,
    SHIP_FCST_MAD                  NUMBER        ,
    MKTG_FCST_MAD                  NUMBER        ,
    FIN_FCST_MAPE                  NUMBER        ,
    FIN_FCST_MAD                   NUMBER        ,
    ADJ_BOOK_FORECAST_STATUS       NUMBER        ,
    ADJ_SHIP_FORECAST_STATUS       NUMBER        ,
    BOOK_FORECAST_ITERMITTENT      NUMBER        ,
    CONSENSUS_FCST_BIAS            NUMBER        ,
    SHIP_FORECAST_ITERMITTENT      NUMBER        ,
    BOOK_FCST_INTERARRIVAL_TIME    NUMBER        ,
    SHIP_FCST_INTERARRIVAL_TIME    NUMBER        ,
    BOOK_FORECAST_LOT_SIZE         NUMBER        ,
    SHIP_FORECAST_LOT_SIZE         NUMBER        ,
    SHIP_FCST_AVG_ARRIVAL_TIME     NUMBER        ,
    BOOK_FCST_AVG_ARRIVAL_TIME     NUMBER        ,
    SHIP_FORECAST_STATUS           NUMBER        ,
    BOOK_FORECAST_STATUS           NUMBER        ,
    CONSENSUS_FCST_MAD             NUMBER        ,
    SHIPMENT_FCST_CMPLXTY          NUMBER        ,
    BOOKINGS_FCST_CMPLXTY          NUMBER        ,
    BOOK_FCST_COMB_OL              NUMBER        ,
    SHIP_FCST_COMB_OL              NUMBER        ,
    BOOK_FCST_LEVELS               NUMBER        ,
    BOOK_HISTORY_AVG               NUMBER        ,
    SHIP_FCST_LEVELS               NUMBER        ,
    SHIP_HISTORY_AVG               NUMBER        ,
    FCST_SIM_OUT_LEVEL_1           NUMBER        ,
    SIM_FORE_LEVEL_2               NUMBER        ,
    FCST_SIM_OUT_METHODS_2         VARCHAR2(1020),
    FCST_SIM_OUT_METHODS_1         VARCHAR2(1020),
    SHIP_FCSTING_METHODS           VARCHAR2(1020),
    BOOK_FCSTING_METHODS           VARCHAR2(1020),
    SHIP_COMB                      NUMBER        ,
    BOOK_COMB                      NUMBER        ,
    LAST_UPDATE_DATE               TIMESTAMP(6)  ,
    IS_FICTIVE                     NUMBER        ,
    PRD_LVL_MEMBER_ID              NUMBER        ,
    DCS_LVL_MEMBER_ID              NUMBER        ,
    CUS_LVL_MEMBER_ID              NUMBER        ,
    ORG_LVL_MEMBER_ID              NUMBER        ,
    BOOK_FCST_BIAS                 NUMBER        ,
    BOOK_FCST_MAPE                 NUMBER        ,
    MEASURE_300000154512874        NUMBER        ,
    SHIP_FCST_BIAS                 NUMBER        ,
    SHIP_FCST_MAPE                 NUMBER        ,
    MKTG_FCST_BIAS                 NUMBER        ,
    SALES_FCST_MAD                 NUMBER        ,
    BOOK_FCST_MAD                  NUMBER        ,
    SHIP_FCST_MAD                  NUMBER        ,
    MKTG_FCST_MAD                  NUMBER        ,
    FIN_FCST_MAPE                  NUMBER        ,
    FIN_FCST_MAD                   NUMBER        ,
    ADJ_BOOK_FORECAST_STATUS       NUMBER        ,
    ADJ_SHIP_FORECAST_STATUS       NUMBER        ,
    BOOK_FORECAST_ITERMITTENT      NUMBER        ,
    CONSENSUS_FCST_BIAS            NUMBER        ,
    SHIP_FORECAST_ITERMITTENT      NUMBER        ,
    BOOK_FCST_INTERARRIVAL_TIME    NUMBER        ,
    SHIP_FCST_INTERARRIVAL_TIME    NUMBER        ,
    BOOK_FORECAST_LOT_SIZE         NUMBER        ,
    SHIP_FORECAST_LOT_SIZE         NUMBER        ,
    SHIP_FCST_AVG_ARRIVAL_TIME     NUMBER        ,
    BOOK_FCST_AVG_ARRIVAL_TIME     NUMBER        ,
    SHIP_FORECAST_STATUS           NUMBER        ,
    BOOK_FORECAST_STATUS           NUMBER        ,
    CONSENSUS_FCST_MAD             NUMBER        ,
    SHIPMENT_FCST_CMPLXTY          NUMBER        ,
    BOOKINGS_FCST_CMPLXTY          NUMBER        ,
    BOOK_FCST_COMB_OL              NUMBER        ,
    SHIP_FCST_COMB_OL              NUMBER        ,
    BOOK_FCST_LEVELS               NUMBER        ,
    BOOK_HISTORY_AVG               NUMBER        ,
    SHIP_FCST_LEVELS               NUMBER        ,
    SHIP_HISTORY_AVG               NUMBER        ,
    FCST_SIM_OUT_LEVEL_1           NUMBER        ,
    SIM_FORE_LEVEL_2               NUMBER        ,
    FCST_SIM_OUT_METHODS_2         VARCHAR2(1020),
    FCST_SIM_OUT_METHODS_1         VARCHAR2(1020),
    SHIP_FCSTING_METHODS           VARCHAR2(1020),
    BOOK_FCSTING_METHODS           VARCHAR2(1020),
    SHIP_COMB                      NUMBER        ,
    BOOK_COMB                      NUMBER        ,
    LAST_UPDATE_DATE               TIMESTAMP(6)  ,
    IS_FICTIVE                     NUMBER        ,
    CONSTRAINT pk_msc_data_102154_dyd PRIMARY KEY (PRD_LVL_MEMBER_ID, DCS_LVL_MEMBER_ID, CUS_LVL_MEMBER_ID, ORG_LVL_MEMBER_ID, PRD_LVL_MEMBER_ID, DCS_LVL_MEMBER_ID, CUS_LVL_MEMBER_ID, ORG_LVL_MEMBER_ID)
);
