/*
================================================================================
档案代号:nmi_file
档案名称:应收票据状况异动记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table nmi_file
(
nmi01       varchar2(16) NOT NULL,   /*票号                                   */
                                     /*票号(应收票据)                         */
nmi02       date,                    /*异动日期                               */
nmi03       varchar2(5) NOT NULL,    /*异动序号                               */
nmi04       varchar2(30),            /*承办人                                 */
nmi05       varchar2(1),             /*原票况                                 */
                                     /*原票况 'X':其它系统转入                */
nmi06       varchar2(1),             /*新票况                                 */
nmi07       varchar2(10),            /*客户编号                               */
nmi08       number(20,10),           /*上次异动汇率                           */
nmi09       number(20,10),           /*本次异动汇率                           */
nmi10       varchar2(16),            /*异动单号                               */
                                     /*异动单号 98/08/24                      */
nmi11       date                     /*传票日期                               */
                                     /*no use                                 */
);

create        index nmi_02 on nmi_file (nmi10);
create unique index nmi_pk on nmi_file (nmi01,nmi03);
alter table nmi_file add  constraint nmi_pk primary key  (nmi01,nmi03) enable validate;
grant select on nmi_file to public;
grant index on nmi_file to public;
grant update on nmi_file to public;
grant delete on nmi_file to public;
grant insert on nmi_file to public;