/*
================================================================================
档案代号:pmo_file
档案名称:请购/采购单特殊说明档(列印用)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pmo_file
(
pmo01       varchar2(16) NOT NULL,   /*请购/采购单编号                        */
pmo02       varchar2(1) NOT NULL,    /*资料性质                               */
                                     /*资料性质 (0.PR 1.PO 2.Blank PO)        */
pmo03       number(5) NOT NULL,      /*请购/采购项次                          */
                                     /*单头的编号为:0                         */
                                     /*Line Item                              */
pmo04       varchar2(1) NOT NULL,    /*列印位置                               */
                                     /*列印位置 (0/1)                         */
                                     /*0: 在前, 1:在后(Default)               */
                                     /*Print Flag                             */
pmo05       number(5) NOT NULL,      /*行序                                   */
                                     /*Line Sequence                          */
pmo06       varchar2(255)            /*说明                                   */
                                     /*Special Note                           */
);

create unique index pmo_pk on pmo_file (pmo01,pmo02,pmo03,pmo05,pmo04);
alter table pmo_file add  constraint pmo_pk primary key  (pmo01,pmo02,pmo03,pmo05,pmo04) enable validate;
grant select on pmo_file to public;
grant index on pmo_file to public;
grant update on pmo_file to public;
grant delete on pmo_file to public;
grant insert on pmo_file to public;