/*
================================================================================
档案代号:oam_file
档案名称:多角贸易转拨单价档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oam_file
(
oam01       varchar2(2) NOT NULL,    /*通路代码                               */
                                     /*通路代码 -> oal01,oai01                */
oam02       date NOT NULL,           /*生效日期                               */
                                     /*生效日期 -> oal02                      */
oam03       varchar2(10) NOT NULL,   /*营运中心编号                           */
                                     /*营运中心编号 -> oai11,oai21,...,oai61  */
oam04       varchar2(4),             /*No Use                                 */
oam05       varchar2(40) NOT NULL,   /*料号条件范围                           */
                                     /*料号条件范围(为QBE格式)                */
oam06       number(20,6),            /*单价                                   */
oamuser     varchar2(10),            /*资料所有者                             */
oamgrup     varchar2(10),            /*资料所有部门                           */
oammodu     varchar2(10),            /*资料修改者                             */
oamdate     date                     /*最近修改日                             */
);

create unique index oam_pk on oam_file (oam01,oam02,oam03,oam05);
alter table oam_file add  constraint oam_pk primary key  (oam01,oam02,oam03,oam05) enable validate;
grant select on oam_file to public;
grant index on oam_file to public;
grant update on oam_file to public;
grant delete on oam_file to public;
grant insert on oam_file to public;