/* ================================================================================ 档案代号:pmb_file 档案名称:多帐期付款条件关联设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pmb_file ( pmb01 varchar2(10) NOT NULL, /*请购单号 */ pmb02 varchar2(1), /*项次 */ /*1-依比率 2-自定义 */ pmb03 number(5) NOT NULL, /*供应厂商 */ pmb04 varchar2(10), /*厂牌 */ pmb05 number(9,4), /*采购单位 */ pmb06 varchar2(15), /*币别 */ pmb07 varchar2(8), /*单价 */ pmbacti varchar2(1), /*资料有效码 */ pmbuser varchar2(10), /*资料业主 */ pmbgrup varchar2(10), /*资料所有部门 */ pmbmodu varchar2(10), /*资料修改者 */ pmbdate date /*最后修改日期 */ ); create unique index pmb_pk on pmb_file (pmb01,pmb03); alter table pmb_file add constraint pmb_pk primary key (pmb01,pmb03) enable validate; grant select on pmb_file to public; grant index on pmb_file to public; grant update on pmb_file to public; grant delete on pmb_file to public; grant insert on pmb_file to public; |