/*
================================================================================
档案代号:nqc_file
档案名称:资金模拟汇率设定
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nqc_file
(
nqc01       varchar2(4) NOT NULL,    /*集团币别                               */
nqc02       varchar2(4) NOT NULL,    /*营运币别                               */
nqc03       number(5) NOT NULL,      /*年度                                   */
nqc04       number(5) NOT NULL,      /*期别                                   */
nqc05       number(20,10),           /*预计汇率                               */
nqcacti     varchar2(1),             /*资料有效码                             */
nqcuser     varchar2(10),            /*资料所有者                             */
nqcgrup     varchar2(10),            /*资料所有群                             */
nqcmodu     varchar2(10),            /*资料更改者                             */
nqcdate     date                     /*最近修改日                             */
);

create unique index nqc_pk on nqc_file (nqc01,nqc02,nqc03,nqc04);
alter table nqc_file add  constraint nqc_pk primary key  (nqc01,nqc02,nqc03,nqc04) enable validate;
grant select on nqc_file to public;
grant index on nqc_file to public;
grant update on nqc_file to public;
grant delete on nqc_file to public;
grant insert on nqc_file to public;