CREATE TABLE msc_adata_147571_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,
    REVENUE                      NUMBER,
    BOOK_FCST                    NUMBER,
    MKTG_FCST                    NUMBER,
    SHIP_FCST                    NUMBER,
    SALES_FCST                   NUMBER,
    ADJ_WTD_FCST                 NUMBER,
    SHIP_HISTORY                 NUMBER,
    ADJ_MKTG_FCST                NUMBER,
    ADJ_SHIP_FCST                NUMBER,
    ADJ_SALES_FCST               NUMBER,
    CONSENSUS_FCST               NUMBER,
    FIN_FCST_VALUE               NUMBER,
    FINAL_BOOK_FCST              NUMBER,
    FINAL_MKTG_FCST              NUMBER,
    FINAL_SHIP_FCST              NUMBER,
    ADJ_SHIP_HISTORY             NUMBER,
    CONSTRAINED_FCST             NUMBER,
    FINAL_SALES_FCST             NUMBER,
    WTD_FCST_CHG_PCT             NUMBER,
    SHIP_HISTORY_VALUE           NUMBER,
    CONSENSUS_FCST_VALUE         NUMBER,
    MKTG_FCST_PCT_CHANGE         NUMBER,
    OPERATING_PLAN_VALUE         NUMBER,
    SHIP_FCST_PCT_CHANGE         NUMBER,
    SALES_FCST_PCT_CHANGE        NUMBER,
    FINAL_MKTG_FCST_PCT_WGHT     NUMBER,
    FINAL_SHIP_FCST_PCT_WGHT     NUMBER,
    FINAL_SALES_FCST_PCT_WGHT    NUMBER,
    ADJUST_PRICE                 NUMBER,
    SHP_FCST_VALUE               NUMBER,
    NPI_REVENUE                  NUMBER,
    UNCON_OPS_PLAN_VALUE         NUMBER,
    SOP_UNMET_REVENUE            NUMBER,
    FINAL_SALES_FCST_VALUE       NUMBER,
    ARCHIVE_ID                   NUMBER,
    LAST_UPDATE_DATE             DATE  ,
    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,
    REVENUE                      NUMBER,
    BOOK_FCST                    NUMBER,
    MKTG_FCST                    NUMBER,
    SHIP_FCST                    NUMBER,
    SALES_FCST                   NUMBER,
    ADJ_WTD_FCST                 NUMBER,
    SHIP_HISTORY                 NUMBER,
    ADJ_MKTG_FCST                NUMBER,
    ADJ_SHIP_FCST                NUMBER,
    ADJ_SALES_FCST               NUMBER,
    CONSENSUS_FCST               NUMBER,
    FIN_FCST_VALUE               NUMBER,
    FINAL_BOOK_FCST              NUMBER,
    FINAL_MKTG_FCST              NUMBER,
    FINAL_SHIP_FCST              NUMBER,
    ADJ_SHIP_HISTORY             NUMBER,
    CONSTRAINED_FCST             NUMBER,
    FINAL_SALES_FCST             NUMBER,
    WTD_FCST_CHG_PCT             NUMBER,
    SHIP_HISTORY_VALUE           NUMBER,
    CONSENSUS_FCST_VALUE         NUMBER,
    MKTG_FCST_PCT_CHANGE         NUMBER,
    OPERATING_PLAN_VALUE         NUMBER,
    SHIP_FCST_PCT_CHANGE         NUMBER,
    SALES_FCST_PCT_CHANGE        NUMBER,
    FINAL_MKTG_FCST_PCT_WGHT     NUMBER,
    FINAL_SHIP_FCST_PCT_WGHT     NUMBER,
    FINAL_SALES_FCST_PCT_WGHT    NUMBER,
    ADJUST_PRICE                 NUMBER,
    SHP_FCST_VALUE               NUMBER,
    NPI_REVENUE                  NUMBER,
    UNCON_OPS_PLAN_VALUE         NUMBER,
    SOP_UNMET_REVENUE            NUMBER,
    FINAL_SALES_FCST_VALUE       NUMBER,
    ARCHIVE_ID                   NUMBER,
    LAST_UPDATE_DATE             DATE  ,
    CONSTRAINT pk_msc_adata_147571_dyd PRIMARY KEY (TIM_LVL_MEMBER_ID, PRD_LVL_MEMBER_ID, DCS_LVL_MEMBER_ID, CUS_LVL_MEMBER_ID, ORG_LVL_MEMBER_ID, ARCHIVE_ID, TIM_LVL_MEMBER_ID, PRD_LVL_MEMBER_ID, DCS_LVL_MEMBER_ID, CUS_LVL_MEMBER_ID, ORG_LVL_MEMBER_ID, ARCHIVE_ID)
);
