/*
================================================================================
档案代号:oqx_file
档案名称:报价单费用档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oqx_file
(
oqx01       varchar2(16) NOT NULL,   /*报价单号                               */
oqx03       number(5) NOT NULL,      /*项次                                   */
                                     /*项次 (0 表示单头备注)                  */
oqx04       varchar2(10) NOT NULL,   /*费用代号                               */
oqx041      varchar2(4),             /*币别代号                               */
oqx05       number(20,6),            /*费用金额                               */
                                     /*费用金额(原币)                         */
oqx06       varchar2(255)            /*备注                                   */
);

create unique index oqx_pk on oqx_file (oqx01,oqx03,oqx04);
alter table oqx_file add  constraint oqx_pk primary key  (oqx01,oqx03,oqx04) enable validate;
grant select on oqx_file to public;
grant index on oqx_file to public;
grant update on oqx_file to public;
grant delete on oqx_file to public;
grant insert on oqx_file to public;