/*
================================================================================
档案代号:oeo_file
档案名称:订单产品的选择配件(Options)/备品档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oeo_file
(
oeo01       varchar2(16) NOT NULL,   /*订单单号                               */
oeo03       number(5) NOT NULL,      /*项次                                   */
oeo04       varchar2(40) NOT NULL,   /*选择配件料号                           */
oeo05       varchar2(4),             /*发料单位                               */
oeo06       number(20,8) NOT NULL,   /*QPA                                    */
                                     /*QPA                #No:6102            */
oeo07       varchar2(1),             /*必需否                                 */
                                     /*必需否 (0.必需件 1.选择配件)           */
oeo08       varchar2(1),             /*属性                                   */
                                     /*属性 1.选配件  2.备品 #by payton       */
oeo09       number(15,3)             /*数量                                   */
                                     /*数量                  #by payton       */
);

create unique index oeo_pk on oeo_file (oeo01,oeo03,oeo04);
alter table oeo_file add  constraint oeo_pk primary key  (oeo01,oeo03,oeo04) enable validate;
grant select on oeo_file to public;
grant index on oeo_file to public;
grant update on oeo_file to public;
grant delete on oeo_file to public;
grant insert on oeo_file to public;