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