/*
================================================================================
档案代号:nnr_file
档案名称:应收帐款质押贷款
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nnr_file
(
nnr01       varchar2(16) NOT NULL,   /*相关单号                               */
nnr02       number(5) NOT NULL,      /*行序                                   */
nnr03       varchar2(16) NOT NULL,   /*帐单号码                               */
nnr04       varchar2(10),            /*客户编号                               */
nnr041      varchar2(40),            /*客户简称                               */
nnr05       date,                    /*帐单日期                               */
nnr06       date,                    /*货款期限                               */
nnr07       varchar2(16),            /*INVOICE                                */
nnr08       number(20,6),            /*INVOICE 金额                           */
nnr09       varchar2(20),            /*LC No                                  */
nnr10       varchar2(4),             /*币别                                   */
nnr11       number(20,10),           /*汇率                                   */
nnr12       number(20,6),            /*原币应收金额                           */
nnr13       number(20,6),            /*本币应收金额                           */
nnr14       varchar2(1),             /*No Use                                 */
nnr15       varchar2(1),             /*No Use                                 */
nnr16       varchar2(1),             /*No Use                                 */
nnr17       varchar2(1)              /*No Use                                 */
);

create unique index nnr_pk on nnr_file (nnr01,nnr02,nnr03);
alter table nnr_file add  constraint nnr_pk primary key  (nnr01,nnr02,nnr03) enable validate;
grant select on nnr_file to public;
grant index on nnr_file to public;
grant update on nnr_file to public;
grant delete on nnr_file to public;
grant insert on nnr_file to public;