/*
================================================================================
档案代号:nnf_file
档案名称:短期融资应付票据资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nnf_file
(
nnf01       varchar2(16) NOT NULL,   /*融资单号                               */
nnf02       number(5) NOT NULL,      /*项次                                   */
nnf03       date,                    /*到期日                                 */
nnf04f      number(20,6),            /*原币票面金额                           */
nnf04       number(20,6),            /*本币票面金额                           */
nnf05       varchar2(11),            /*付款银行                               */
nnf06       varchar2(16),            /*开票单号                               */
nnf07       varchar2(15),            /*支票号码                               */
nnf08       varchar2(1)              /*种类                                   */
                                     /*种类 1.支票 2.CP本票       #5543       */
);

create unique index nnf_pk on nnf_file (nnf01,nnf02);
alter table nnf_file add  constraint nnf_pk primary key  (nnf01,nnf02) enable validate;
grant select on nnf_file to public;
grant index on nnf_file to public;
grant update on nnf_file to public;
grant delete on nnf_file to public;
grant insert on nnf_file to public;