/*
================================================================================
档案代号:pnc_file
档案名称:收货替代群组档
档案目的:收货替代群组档 假双档
上游档案:
下游档案:
============.========================.==========================================
*/
create table pnc_file
(
pnc01       varchar2(40) DEFAULT '' NOT NULL, /*料号,放单头*/
pnc02       varchar2(10) DEFAULT '' NOT NULL, /*供应商,*号代表不区分供应商, */
pnc03       varchar2(40) DEFAULT '' NOT NULL, /*可替代料号,放单身*/
pnc04       date DEFAULT sysdate NOT NULL, /*生效日期,放单身*/
pnc05       date                     /*失效日期,放单身                        */
);

create unique index pnc_pk on pnc_file (pnc01,pnc02,pnc03,pnc04);
alter table pnc_file add  constraint pnc_pk primary key  (pnc01,pnc02,pnc03,pnc04) enable validate;
grant select on pnc_file to public;
grant index on pnc_file to public;
grant update on pnc_file to public;
grant delete on pnc_file to public;
grant insert on pnc_file to public;