/* ================================================================================ 档案代号: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; |