/*
================================================================================
档案代号:pnni_file
档案名称:采购分配底稿档
档案目的:采购分配底稿档(行业别架构)
上游档案:
下游档案:
============.========================.==========================================
*/
create table pnni_file
(
pnni01      varchar2(16) DEFAULT '' NOT NULL, /*请购单号*/
pnni02      number(10) DEFAULT '0' NOT NULL, /*请购项次*/
pnni03      varchar2(40) DEFAULT '' NOT NULL, /*料件编号*/
pnni05      varchar2(10) DEFAULT '' NOT NULL, /*厂商编号*/
pnni06      varchar2(4) DEFAULT '' NOT NULL, /*币别*/
pnnislk01   varchar2(16)             /*制单号                                 */
);

create unique index pnni_pk on pnni_file (pnni01,pnni02,pnni03,pnni05,pnni06);
alter table pnni_file add  constraint pnni_pk primary key  (pnni01,pnni02,pnni03,pnni05,pnni06) enable 
validate;
grant select on pnni_file to public;
grant index on pnni_file to public;
grant update on pnni_file to public;
grant delete on pnni_file to public;
grant insert on pnni_file to public;