/*
================================================================================
档案代号:bnh_file
档案名称:销售预测资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bnh_file
(
bnh01       varchar2(1),             /*销售区分                               */
                                     /*0.全部  1.内销                         */
bnh02       date,                    /*销售日期                               */
                                     /*销售日期from                           */
bnh03       varchar2(40),            /*料件编号                               */
bnh04       number(15,3),            /*数量                                   */
bnh05       date                     /*销售日期                               */
                                     /*销售日期to                             */
);

create        index bnh_01 on bnh_file (bnh01,bnh02,bnh03);
grant select on bnh_file to public;
grant index on bnh_file to public;
grant update on bnh_file to public;
grant delete on bnh_file to public;
grant insert on bnh_file to public;