/*
================================================================================
档案代号:oef_file
档案名称:订单费用档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oef_file
(
oef01       varchar2(16) NOT NULL,   /*订单号                                 */
oef03       number(5) NOT NULL,      /*项次                                   */
                                     /*项次 (0 表示单头备注)                  */
oef04       varchar2(10) NOT NULL,   /*费用代号                               */
oef05       number(20,6),            /*费用金额                               */
                                     /*费用金额 (本币)                        */
oef06       varchar2(255)            /*备注                                   */
);

create unique index oef_pk on oef_file (oef01,oef03,oef04);
alter table oef_file add  constraint oef_pk primary key  (oef01,oef03,oef04) enable validate;
grant select on oef_file to public;
grant index on oef_file to public;
grant update on oef_file to public;
grant delete on oef_file to public;
grant insert on oef_file to public;