/*
================================================================================
档案代号:nnl_file
档案名称:信贷还本付款单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nnl_file
(
nnl01       varchar2(16) NOT NULL,   /*付款单号                               */
nnl02       number(5) NOT NULL,      /*序号                                   */
nnl03       varchar2(1),             /*1.融资 2.中长贷合约                    */
nnl04       varchar2(16),            /*融资/合约号码                          */
nnl11       number(20,6),            /*应还原币                               */
nnl12       number(20,6),            /*实付原币                               */
nnl13       number(20,6),            /*应还本币                               */
nnl14       number(20,6),            /*实付本币                               */
nnl15       number(20,6),            /*应付利息原币                           */
nnl16       number(20,6),            /*汇差损失                               */
nnl17       number(20,6),            /*应付利息本币                           */
nnl18       number(20,10),           /*额度汇率                               */
                                     /*额度汇率(转换信贷额度)                 */
nnl19       varchar2(1),             /*No Use                                 */
nnl20       varchar2(1),             /*No Use                                 */
nnlud01     varchar2(255),           /*自订栏位-Textedit                      */
nnlud02     varchar2(40),            /*自订栏位-文字                          */
nnlud03     varchar2(40),            /*自订栏位-文字                          */
nnlud04     varchar2(40),            /*自订栏位-文字                          */
nnlud05     varchar2(40),            /*自订栏位-文字                          */
nnlud06     varchar2(40),            /*自订栏位-文字                          */
nnlud07     number(15,3),            /*自订栏位-数值                          */
nnlud08     number(15,3),            /*自订栏位-数值                          */
nnlud09     number(15,3),            /*自订栏位-数值                          */
nnlud10     number(10),              /*自订栏位-整数                          */
nnlud11     number(10),              /*自订栏位-整数                          */
nnlud12     number(10),              /*自订栏位-整数                          */
nnlud13     date,                    /*自订栏位-日期                          */
nnlud14     date,                    /*自订栏位-日期                          */
nnlud15     date                     /*自订栏位-日期                          */
);

create        index nnl_02 on nnl_file (nnl03);
create unique index nnl_pk on nnl_file (nnl01,nnl02);
alter table nnl_file add  constraint nnl_pk primary key  (nnl01,nnl02) enable validate;
grant select on nnl_file to public;
grant index on nnl_file to public;
grant update on nnl_file to public;
grant delete on nnl_file to public;
grant insert on nnl_file to public;