/*
================================================================================
档案代号:nnp_file
档案名称:合约借款额度单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nnp_file
(
nnp01       varchar2(10) NOT NULL,   /*合约号码                               */
nnp02       number(5) NOT NULL,      /*项次                                   */
nnp03       varchar2(10),            /*融资种类                               */
nnp04       varchar2(1),             /*综合                                   */
nnp05       number(9,4),             /*利率                                   */
                                     /*利率              #No:7354             */
nnp06       number(9,4),             /*费率                                   */
nnp07       varchar2(4),             /*币别                                   */
nnp08       number(20,10),           /*额汇                                   */
                                     /*额汇 No.B254 原为汇率010430改成额汇    */
nnp09       number(20,6),            /*授信额度                               */
nnp10       varchar2(1),             /*No Use                                 */
nnp11       varchar2(1),             /*No Use                                 */
nnp12       varchar2(1),             /*No Use                                 */
nnp13       varchar2(1),             /*No Use                                 */
nnpud01     varchar2(255),           /*自订栏位-Textedit                      */
nnpud02     varchar2(40),            /*自订栏位-文字                          */
nnpud03     varchar2(40),            /*自订栏位-文字                          */
nnpud04     varchar2(40),            /*自订栏位-文字                          */
nnpud05     varchar2(40),            /*自订栏位-文字                          */
nnpud06     varchar2(40),            /*自订栏位-文字                          */
nnpud07     number(15,3),            /*自订栏位-数值                          */
nnpud08     number(15,3),            /*自订栏位-数值                          */
nnpud09     number(15,3),            /*自订栏位-数值                          */
nnpud10     number(10),              /*自订栏位-整数                          */
nnpud11     number(10),              /*自订栏位-整数                          */
nnpud12     number(10),              /*自订栏位-整数                          */
nnpud13     date,                    /*自订栏位-日期                          */
nnpud14     date,                    /*自订栏位-日期                          */
nnpud15     date                     /*自订栏位-日期                          */
);

create unique index nnp_pk on nnp_file (nnp01,nnp02);
alter table nnp_file add  constraint nnp_pk primary key  (nnp01,nnp02) enable validate;
grant select on nnp_file to public;
grant index on nnp_file to public;
grant update on nnp_file to public;
grant delete on nnp_file to public;
grant insert on nnp_file to public;