/*
================================================================================
档案代号:oebi_file
档案名称:订单单身档(行业别档)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oebi_file
(
oebi01      varchar2(16) DEFAULT '' NOT NULL, /*订单单号*/
oebi03      number(5) DEFAULT '0' NOT NULL, /*项次*/
oebiicd01   varchar2(40),            /*内编母体料号                           */
oebiicd02   varchar2(10),            /*业务员                                 */
oebiicd03   number(9,4),             /*备品比率                               */
oebiicd04   varchar2(1),             /*样品否                                 */
oebiicd05   varchar2(1),             /*Multi Die                              */
oebiicd06   number(15,3),            /*已转片数                               */
oebiicd07   varchar2(10),            /*End User                               */
oebiicd08   varchar2(1),             /*已转完采购单否                         */
oebiicd09   varchar2(10),            /*单身送货地址码                         */
oebislk01   varchar2(16)             /*制单号                                 */
);

create unique index oebi_pk on oebi_file (oebi01,oebi03);
alter table oebi_file add  constraint oebi_pk primary key  (oebi01,oebi03) enable validate;
grant select on oebi_file to public;
grant index on oebi_file to public;
grant update on oebi_file to public;
grant delete on oebi_file to public;
grant insert on oebi_file to public;