/*
================================================================================
档案代号:oah_file
档案名称:价格条件档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oah_file
(
oah01       varchar2(6) NOT NULL,    /*价格条件编号                           */
                                     /*价格条件编号   Ex:FOB  CIF C与F CIF与C5*/
oah02       varchar2(80),            /*说明                                   */
oah03       varchar2(2),             /*报价取价或订单取价方式                 */
                                     /* 0.人工输入                            */
                                     /* 1.取产品档内的订价                    */
                                     /* 2.取产品价格档内的订价                */
                                     /* 3.取产品客户档内的上次订单单价        */
                                     /* 4.依价格表取价  #No:A036              */
oah04       varchar2(1),             /*(F)运费计算否                          */
                                     /*(F)运费计算否(Y/N)                     */
oah05       varchar2(1),             /*(I)保险费计否                          */
                                     /*(I)保险费计否(Y/N)                     */
oah06       varchar2(1)              /*(C)佣金计算否                          */
                                     /*(C)佣金计算否(Y/N)                     */
);

create unique index oah_pk on oah_file (oah01);
alter table oah_file add  constraint oah_pk primary key  (oah01) enable validate;
grant select on oah_file to public;
grant index on oah_file to public;
grant update on oah_file to public;
grant delete on oah_file to public;
grant insert on oah_file to public;