/* ================================================================================ 档案代号:nnl_file 档案名称:信贷还本付款单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table nnl_file ( nnl01 varchar2(16) NOT NULL, /*付款单号 */ nnl02 number(5) NOT NULL, /*序号 */ nnl03 varchar2(1), /*1.融资 2.中长贷合约 */ nnl04 varchar2(16), /*融资/合约号码 */ nnl11 number(20,6), /*应还原币 */ nnl12 number(20,6), /*实付原币 */ nnl13 number(20,6), /*应还本币 */ nnl14 number(20,6), /*实付本币 */ nnl15 number(20,6), /*应付利息原币 */ nnl16 number(20,6), /*汇差损失 */ nnl17 number(20,6), /*应付利息本币 */ nnl18 number(20,10), /*额度汇率 */ /*额度汇率(转换信贷额度) */ nnl19 varchar2(1), /*No Use */ nnl20 varchar2(1), /*No Use */ nnlud01 varchar2(255), /*自订栏位-Textedit */ nnlud02 varchar2(40), /*自订栏位-文字 */ nnlud03 varchar2(40), /*自订栏位-文字 */ nnlud04 varchar2(40), /*自订栏位-文字 */ nnlud05 varchar2(40), /*自订栏位-文字 */ nnlud06 varchar2(40), /*自订栏位-文字 */ nnlud07 number(15,3), /*自订栏位-数值 */ nnlud08 number(15,3), /*自订栏位-数值 */ nnlud09 number(15,3), /*自订栏位-数值 */ nnlud10 number(10), /*自订栏位-整数 */ nnlud11 number(10), /*自订栏位-整数 */ nnlud12 number(10), /*自订栏位-整数 */ nnlud13 date, /*自订栏位-日期 */ nnlud14 date, /*自订栏位-日期 */ nnlud15 date /*自订栏位-日期 */ ); create index nnl_02 on nnl_file (nnl03); create unique index nnl_pk on nnl_file (nnl01,nnl02); alter table nnl_file add constraint nnl_pk primary key (nnl01,nnl02) enable validate; grant select on nnl_file to public; grant index on nnl_file to public; grant update on nnl_file to public; grant delete on nnl_file to public; grant insert on nnl_file to public; |