/*
================================================================================
档案代号:pmni_file
档案名称:采购单单身档(行业别档)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pmni_file
(
pmni01      varchar2(16) DEFAULT '' NOT NULL, /*采购单号*/
pmni02      number(5) DEFAULT '0' NOT NULL, /*采购项次*/
pmniicd01   varchar2(16),            /*订单单号                               */
pmniicd02   number(5),               /*订单项次                               */
pmniicd03   varchar2(10),            /*Icd作业编号                            */
pmniicd04   varchar2(1),             /*New Code                               */
pmniicd05   varchar2(1),             /*Low Yield                              */
pmniicd06   varchar2(1),             /*Metal Layer                            */
pmniicd07   number(15,3),            /*FST片数                                */
pmniicd08   varchar2(1),             /*Multi Die                              */
pmniicd09   number(15,3),            /*Reference Die                          */
pmniicd10   varchar2(1),             /*已转完采购单否                         */
pmniicd11   varchar2(80),            /*Datecode                               */
pmniicd12   varchar2(10),            /*Wafer Site                             */
pmniicd13   number(15,3),            /*已转Wafer Start采购单数量              */
pmniicd14   varchar2(40),            /*内编母体料号                           */
pmniicd15   varchar2(40),            /*最终料号                               */
                                     /*存放接单料号                           */
pmniicd16   varchar2(24),            /*母批                                   */
pmniicd17   varchar2(10),            /*Wafer厂商                              */
pmniicd18   varchar2(10),            /*下阶厂商                               */
pmnislk01   varchar2(16)             /*制单号                                 */
);

create unique index pmni_pk on pmni_file (pmni01,pmni02);
alter table pmni_file add  constraint pmni_pk primary key  (pmni01,pmni02) enable validate;
grant select on pmni_file to public;
grant index on pmni_file to public;
grant update on pmni_file to public;
grant delete on pmni_file to public;
grant insert on pmni_file to public;