/* ================================================================================ 档案代号: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; |