/* ================================================================================ 档案代号:oax_file 档案名称:多角贸易参数设定档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oax_file ( oax00 varchar2(1) NOT NULL, /*key value */ oax01 varchar2(1), /*多角贸易使用汇率 s/b/c/d */ oax02 varchar2(1), /*是否允许订单单价为0 */ oax03 varchar2(1), /*出货时单价是否重新计算 */ oax04 varchar2(1), /*是否抛转 invoice */ oax05 varchar2(1), /*是否抛转 packing list */ oax06 varchar2(1), /*一单到底 */ oax07 varchar2(1), /*是否于单据确认时 自动抛转 */ oax08 varchar2(1) /*订单取价方式 */ ); create unique index oax_pk on oax_file (oax00); alter table oax_file add constraint oax_pk primary key (oax00) enable validate; grant select on oax_file to public; grant index on oax_file to public; grant update on oax_file to public; grant delete on oax_file to public; grant insert on oax_file to public; |