/*
================================================================================
档案代号:nqe_file
档案名称:预计资金
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nqe_file
(
nqe01       varchar2(10) NOT NULL,   /*营运中心                               */
nqe02       varchar2(4) NOT NULL,    /*营运币别                               */
nqe03       date NOT NULL,           /*日期                                   */
nqe04       varchar2(1),             /*变动分类                               */
nqe05       varchar2(3) NOT NULL,    /*类别                                   */
nqe06       varchar2(255),           /*备注                                   */
nqe07       varchar2(4),             /*交易币别                               */
nqe08       number(20,10),           /*汇率                                   */
nqe09       varchar2(1),             /*异动存提 (1.存 2.提)                   */
nqe10       number(20,6),            /*原币金额                               */
nqe11       number(20,6),            /*营运金额                               */
nqe12       varchar2(1),             /*实现否(y/n)                            */
nqe13       varchar2(11),            /*银行编号                               */
nqe14       varchar2(1),             /*No Use                                 */
nqe15       varchar2(1),             /*No Use                                 */
nqeacti     varchar2(1),             /*资料有效码                             */
nqeuser     varchar2(10),            /*资料所有者                             */
nqegrup     varchar2(10),            /*资料所有群                             */
nqemodu     varchar2(10),            /*资料更改者                             */
nqedate     date                     /*最近修改日                             */
);

create unique index nqe_pk on nqe_file (nqe01,nqe02,nqe03,nqe05);
alter table nqe_file add  constraint nqe_pk primary key  (nqe01,nqe02,nqe03,nqe05) enable validate;
grant select on nqe_file to public;
grant index on nqe_file to public;
grant update on nqe_file to public;
grant delete on nqe_file to public;
grant insert on nqe_file to public;