/*******************************************************
货币基金——完美日结功能
1.20140710Sp1版本生效
*******************************************************/
delete from tinfomginterface a where a.c_infoname = 'FUNDINFO' and a.c_fieldname = 'C_PAYMENTFREQUENCY' and lower(a.c_queryname) = 'tfundinfo';
insert into tinfomginterface (C_INFONAME, C_FIELDNAME, C_DESCRIBE, C_TYPE, C_VALUEBOUND, C_VALUE, C_SHOWTITLE, C_SHOWSUBTITLE, L_ORDER, C_MODIFY, C_CRYPTFLAG, C_FULLDESCRIBE, C_ISNULL, D_ADDDATE, L_SHOWTITLENO, L_SHOWSUBTITLENO, L_HEADWIDTH, C_SHOWHEAD, L_LEFT, L_CONTROLLEFT, L_CONTROLWIDTH, L_COLCOUNT, C_QUERYNAME, C_ISQUERY, C_CODE, C_BATCHMODIFYFLAG, C_KEYFIELDFLAG, C_DEPENDSYSPARAMETER, C_DEPENDTACODE)
values ('FUNDINFO', 'C_PAYMENTFREQUENCY', '收益结转频率', '1', null, '0', '货币参数', '货币基金参数', 100, '1', '0', '收益结转频率', '1', null, 10, 1001, 80, '1', 10, 170, 160, 1, 'Tfundinfo', null, '2342', '0', null, null, null);
delete from tinfomginterface a where a.c_infoname = 'FUNDINFO' and a.c_fieldname = 'C_REINVESTMODE' and lower(a.c_queryname) = 'tfundinfo';
insert into tinfomginterface (C_INFONAME, C_FIELDNAME, C_DESCRIBE, C_TYPE, C_VALUEBOUND, C_VALUE, C_SHOWTITLE, C_SHOWSUBTITLE, L_ORDER, C_MODIFY, C_CRYPTFLAG, C_FULLDESCRIBE, C_ISNULL, D_ADDDATE, L_SHOWTITLENO, L_SHOWSUBTITLENO, L_HEADWIDTH, C_SHOWHEAD, L_LEFT, L_CONTROLLEFT, L_CONTROLWIDTH, L_COLCOUNT, C_QUERYNAME, C_ISQUERY, C_CODE, C_BATCHMODIFYFLAG, C_KEYFIELDFLAG, C_DEPENDSYSPARAMETER, C_DEPENDTACODE)
values ('FUNDINFO', 'C_REINVESTMODE', '每日结转模式', '1', null, '', '货币参数', '货币基金参数', 110, '1', '0', '每日结转模式', '1', null, 10, 1001, 80, '1', 10, 170, 160, 1, 'Tfundinfo', null, '2336', '0', null, null, null);
DELETE FROM tqueryfieldvalue a WHERE a.c_code = '2336';
insert into tqueryfieldvalue (C_CODE, C_TYPE, C_VALUE, C_FIELDNAME)
values ('2336', '2', '0:每天生成分红份额明细;1:每月一笔分红份额明细;2:始终一笔分红份额明细', '');
COMMIT;
浙公网安备 33010602011771号