/*
================================================================================
档案代号:pmli_file
档案名称:请购单单身(行业别架构)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pmli_file
(
pmli01      varchar2(16) DEFAULT '' NOT NULL, /*请购单号  pmk01*/
pmli02      number(10) DEFAULT '0' NOT NULL, /*项次, 请购单所含盖的项目编  */
pmlislk01   varchar2(16)             /*制单号                                 */
);

create unique index pmli_pk on pmli_file (pmli01,pmli02);
alter table pmli_file add  constraint pmli_pk primary key  (pmli01,pmli02) enable validate;
grant select on pmli_file to public;
grant index on pmli_file to public;
grant update on pmli_file to public;
grant delete on pmli_file to public;
grant insert on pmli_file to public;