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