/* ================================================================================ 档案代号:pod_file 档案名称:代采买多角贸易参数设定作业 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pod_file ( pod00 varchar2(1) NOT NULL, /*Key Value = '0' */ pod01 varchar2(1), /*代采买三角贸易使用汇率 */ /*是否允许采购单价为零 */ pod02 varchar2(1), /*是否允许采购单价为零 */ /*入库抛转时单价是否重新计算 */ pod03 varchar2(1), /*入库抛转时单价是否重新计算 */ /*no use */ pod04 varchar2(1), /*一单到底 */ pod05 varchar2(1), /*是否于单据确认时自动抛转 */ pod06 varchar2(1), /*No Use */ pod07 varchar2(1) /*No Use */ ); create unique index pod_pk on pod_file (pod00); alter table pod_file add constraint pod_pk primary key (pod00) enable validate; grant select on pod_file to public; grant index on pod_file to public; grant update on pod_file to public; grant delete on pod_file to public; grant insert on pod_file to public; |