19TSY

UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品名称要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.001';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品名称过长。' WHERE RULE_CODE ='LCZX.A.033.004';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '行内标识码要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.006';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '行内标识码过长。' WHERE RULE_CODE ='LCZX.A.033.009';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.010';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码必须与银行代码相同;发行机构代码要素格式不对。正确的格式:6位英文或数字。' WHERE RULE_CODE ='LCZX.A.033.011';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品审批人身份证号要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.014';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品审批人身份证号过长。' WHERE RULE_CODE ='LCZX.A.033.015';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '审批人身份证记录信息已被注销或不存在' WHERE RULE_CODE ='LCZX.A.033.016';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品设计人身份证号要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.019';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品设计人身份证号过长。' WHERE RULE_CODE ='LCZX.A.033.020';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品设计人身份证记录信息已被注销或不存在.' WHERE RULE_CODE ='LCZX.A.033.021';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资经理身份证号要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.024';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资经理身份证号过长。' WHERE RULE_CODE ='LCZX.A.033.025';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资经理身份证记录信息已被注销或不存在.' WHERE RULE_CODE ='LCZX.A.033.026';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务联络人姓名要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.027';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务联络人姓名过长。' WHERE RULE_CODE ='LCZX.A.033.028';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务联络人座机不合法,合法的模式:XXXX(3或4位)-XXXXXXXX(7或8位)-XXXXX(小于等于8位)分机号码可以不填。' WHERE RULE_CODE ='LCZX.A.033.029';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务联络人座机过长。' WHERE RULE_CODE ='LCZX.A.033.030';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务联络人座机要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.031';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务联络人手机要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.032';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务联络人手机不合法,合法的模式:13488996666(11位)。' WHERE RULE_CODE ='LCZX.A.033.033';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务联络人邮箱要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.034';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务联络人邮箱地址不合法,合法email格式如:John@163.com。' WHERE RULE_CODE ='LCZX.A.033.035';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务联络人邮箱过长。' WHERE RULE_CODE ='LCZX.A.033.036';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '理财子公司产品的新老产品标记要素不可填。' WHERE RULE_CODE ='LCZX.A.033.039';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '新老产品标识不在值域范围内。' WHERE RULE_CODE ='LCZX.A.033.040';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当资金投向地区为境外时,产品投资国家或地区不能填写中国。' WHERE RULE_CODE ='LCZX.A.033.045';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品投资国家或地区的多选选项不可重复。' WHERE RULE_CODE ='LCZX.A.033.046';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '理财业务服务模式不在值域范围内。' WHERE RULE_CODE ='LCZX.A.033.048';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '实际管理人名称过长。' WHERE RULE_CODE ='LCZX.A.033.054';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业绩比较基准必须大于等于0。' WHERE RULE_CODE ='LCZX.A.033.057';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '是否设置最短持有期限不在值域范围内。' WHERE RULE_CODE ='LCZX.A.033.059';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '最短持有期限(天)必须大于0。' WHERE RULE_CODE ='LCZX.A.033.062';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '最短持有期限(天)必须为n..5格式。' WHERE RULE_CODE ='LCZX.A.033.063';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当产品运作模式为封闭式净值型时,最短持有期限(天)要素必须为空。' WHERE RULE_CODE ='LCZX.A.033.064';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '最短持有期后是否自由赎回不在值域范围内。' WHERE RULE_CODE ='LCZX.A.033.066';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当产品运作模式为封闭式净值型时,最短持有期后是否自由赎回要素必须为空。' WHERE RULE_CODE ='LCZX.A.033.067';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '是否现金管理类不在值域范围内。' WHERE RULE_CODE ='LCZX.A.033.069';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品销售区域的多选选项不可重复。' WHERE RULE_CODE ='LCZX.A.033.071';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '起点销售金额要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.072';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '起点销售金额必须大于0。' WHERE RULE_CODE ='LCZX.A.033.073';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集币种要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.075';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集币种不在值域范围内。' WHERE RULE_CODE ='LCZX.A.033.076';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集币种的多选选项不可重复。' WHERE RULE_CODE ='LCZX.A.033.077';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付本金币种要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.078';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付本金币种不在值域范围内。' WHERE RULE_CODE ='LCZX.A.033.079';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付本金币种的多选选项不可重复。' WHERE RULE_CODE ='LCZX.A.033.080';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付收益币种要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.081';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付收益币种不在值域范围内。' WHERE RULE_CODE ='LCZX.A.033.082';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付收益币种的多选选项不可重复。' WHERE RULE_CODE ='LCZX.A.033.083';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '销售手续费率%要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.084';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '销售手续费率%必须大于等于0。' WHERE RULE_CODE ='LCZX.A.033.085';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '托管费率%要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.087';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '托管费率%必须大于等于0。' WHERE RULE_CODE ='LCZX.A.033.088';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集起始日期(到)要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.092';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集起始日期(到)必须大于等于募集起始日期(从)。' WHERE RULE_CODE ='LCZX.A.033.093';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '计划募集金额(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.095';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '计划募集金额(元)必须大于0。' WHERE RULE_CODE ='LCZX.A.033.096';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '境内托管机构名称(公募私募)不在值域范围内。' WHERE RULE_CODE ='LCZX.A.033.098';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当资金投向地区为境外时,境内托管机构代码要素必须为空。' WHERE RULE_CODE ='LCZX.A.033.099';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '境外托管机构国别不在值域范围内。' WHERE RULE_CODE ='LCZX.A.033.102';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '境外托管机构国别的多选选项不可重复。' WHERE RULE_CODE ='LCZX.A.033.103';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当资金投向地区为境外时,境外托管机构国别不能填写中国。' WHERE RULE_CODE ='LCZX.A.033.104';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当资金投向地区为境外时,境外托管机构名称要素不可为空;当资金投向地区为境内时,境外托管机构名称要素必须为空。' WHERE RULE_CODE ='LCZX.A.033.105';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '境外托管机构名称过长。' WHERE RULE_CODE ='LCZX.A.033.106';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资者风险偏好的多选选项不可重复。' WHERE RULE_CODE ='LCZX.A.033.108';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品品牌过长。' WHERE RULE_CODE ='LCZX.A.033.112';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品期次要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.113';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品期次必须为n..6格式。' WHERE RULE_CODE ='LCZX.A.033.114';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品特殊属性不在值域范围内。' WHERE RULE_CODE ='LCZX.A.033.115';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资管理费率%要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.116';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资管理费率%必须大于等于0。' WHERE RULE_CODE ='LCZX.A.033.117';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '合作机构名称过长。' WHERE RULE_CODE ='LCZX.A.033.121';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品增信机构类型不在值域范围内。' WHERE RULE_CODE ='LCZX.A.033.126';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品增信机构类型的多选选项不可重复。' WHERE RULE_CODE ='LCZX.A.033.127';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品增信形式不在值域范围内。' WHERE RULE_CODE ='LCZX.A.033.129';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资资产种类及比例要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.130';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资资产种类及比例要素格式不对。正确的格式:数字%:文字;数字%-数字%:文字(其中,百分号、冒号、分号、连字号均应为英文标点,文字和数字部分均不得含有英文百分号、冒号、分号、连字号)。其中,数字格式为n..(5,2),且需大于等于0、小于等于100。' WHERE RULE_CODE ='LCZX.A.033.131';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品收益类型不在值域范围内;产品收益类型要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.037';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品期限(公募私募)不在值域范围内;产品期限(公募私募)要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.041';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '是否金融同业专属不在值域范围内;是否金融同业专属要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.042';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '资金投向地区不在值域范围内;资金投向地区要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.043';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当资金投向地区为境内时,产品投资国家或地区要素必须为空;当资金投向地区为境外时,产品投资国家或地区要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.044';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当资金投向地区为境内和境外时,理财业务服务模式要素不可为空;当资金投向地区为境外时,理财业务服务模式要素必须为空。' WHERE RULE_CODE ='LCZX.A.033.047';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品运作模式不在值域范围内;产品运作模式要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.049';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品募集方式不在值域范围内;产品募集方式要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.050';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品资产配置方式不在值域范围内;产品资产配置方式要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.051';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品管理模式不在值域范围内;产品管理模式要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.052';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当产品管理模式为银行为实际管理人时,实际管理人名称要素必须为空;当产品管理模式为资产管理公司时,实际管理人名称要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.053';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品定价方式不在值域范围内;产品定价方式要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.055';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品投资性质不在值域范围内;产品投资性质要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.056';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当产品运作模式为封闭式净值型时,是否设置最短持有期限要素必须为空;当产品运作模式为开放式净值型时,是否设置最短持有期限要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.060';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当是否设置最短持有期限为否时,最短持有期限(天)要素必须为空;当是否设置最短持有期限为是时,最短持有期限(天)要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.061';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当是否设置最短持有期限为否时,最短持有期后是否自由赎回要素必须为空;当是否设置最短持有期限为是时,最短持有期后是否自由赎回要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.065';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当产品运作模式为封闭式净值型时,是否现金管理类要素必须为空;当产品运作模式为开放式净值型时,是否现金管理类要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.068';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品销售区域不在值域范围内;产品销售区域要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.070';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集起始日期(从)必须为日期格式(YYYY-MM-DD);募集起始日期(从)必须为正确日期。' WHERE RULE_CODE ='LCZX.A.033.090';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集起始日期(从)应在当前日期10个工作日以后募集起始日期(从)应在当前日期2个工作日以后' WHERE RULE_CODE ='LCZX.A.033.091';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集起始日期(到)必须为日期格式(YYYY-MM-DD);募集起始日期(到)必须为正确日期。' WHERE RULE_CODE ='LCZX.A.033.094';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当资金投向地区为境内时,境内托管机构名称(公募私募)要素不可为空;当资金投向地区为境外时,境内托管机构名称(公募私募)要素必须为空。' WHERE RULE_CODE ='LCZX.A.033.097';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当资金投向地区为境内时,境外托管机构国别要素必须为空;当资金投向地区为境外时,境外托管机构国别要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.101';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资者风险偏好不在值域范围内;投资者风险偏好要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.107';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品风险等级不在值域范围内;产品风险等级要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.109';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构提前终止权标识不在值域范围内;发行机构提前终止权标识要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.110';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '客户赎回权标识不在值域范围内;客户赎回权标识要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.111';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '合作模式不在值域范围内;合作模式要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.119';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当合作模式不为独立运作时,合作机构名称要素不可为空;当合作模式为独立运作时,合作机构名称要素必须为空。' WHERE RULE_CODE ='LCZX.A.033.120';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资本金到账日不在值域范围内;投资本金到账日要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.122';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资收益到账日不在值域范围内;投资收益到账日要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.123';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品增信标识不在值域范围内;产品增信标识要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.124';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当产品增信标识为无时,产品增信机构类型要素必须为空;当产品增信标识为有时,产品增信机构类型要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.125';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当产品增信标识为无时,产品增信形式要素必须为空;当产品增信标识为有时,产品增信形式要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.128';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当境内托管机构名称(公募私募)为其他时,备注要素不可为空;当最短持有期后是否自由赎回为其他时,备注要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.132';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '行内标识码不能重复!' WHERE RULE_CODE ='LCZX.A.033.008';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码要素格式不对。正确的格式:6位英文或数字。' WHERE RULE_CODE ='LCZX.A.034.005';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当产品收益类型为非保本浮动收益时,新老产品标记要素必填。' WHERE RULE_CODE ='LCZX.A.033.135';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当产品收益类型为非“非保本浮动收益”时,新老产品标记元素不可填!' WHERE RULE_CODE ='LCZX.A.033.136';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集起始日期(从)要素不可为空。' WHERE RULE_CODE ='LCZX.A.033.137';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '境内托管机构代码过长。' WHERE RULE_CODE ='LCZX.A.033.138';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资者风险偏好的选项与产品风险等级的选项不匹配。' WHERE RULE_CODE ='LCZX.A.033.139';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品期次和产品名称在报文内不可同时重复。' WHERE RULE_CODE ='LCZX.A.033.003';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品名称和产品期次不能同时重复!' WHERE RULE_CODE ='LCZX.A.033.140';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品特殊属性的多选选项不可重复。' WHERE RULE_CODE ='LCZX.A.033.141';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资资产种类及比例过长。' WHERE RULE_CODE ='LCZX.A.033.142';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '备注过长。' WHERE RULE_CODE ='LCZX.A.033.143';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码要素不可为空。' WHERE RULE_CODE ='LCZX.A.034.001';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码要素格式不对。正确的格式:14或15位英文或数字。' WHERE RULE_CODE ='LCZX.A.034.003';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码报文内不可重复。' WHERE RULE_CODE ='LCZX.A.034.002';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该产品不存在。' WHERE RULE_CODE ='LCZX.A.034.004';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码要素不可为空。' WHERE RULE_CODE ='LCZX.A.034.006';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '理财产品代码要素不可为空。' WHERE RULE_CODE ='LCZX.A.034.007';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '理财产品代码过长。' WHERE RULE_CODE ='LCZX.A.034.009';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集起始日期要素不可为空。' WHERE RULE_CODE ='LCZX.A.034.010';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集起始日期应落在申报登记要素中募集起始日期(从)/(到)的区间内.' WHERE RULE_CODE ='LCZX.A.034.011';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集结束日期要素不可为空。' WHERE RULE_CODE ='LCZX.A.034.013';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集结束日期必须大于等于募集起始日期。' WHERE RULE_CODE ='LCZX.A.034.014';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品起始日期要素不可为空。' WHERE RULE_CODE ='LCZX.A.034.016';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品起始日期必须大于等于募集结束日期。' WHERE RULE_CODE ='LCZX.A.034.017';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品终止日期要素不可为空。' WHERE RULE_CODE ='LCZX.A.034.019';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品终止日期必须大于产品起始日期。' WHERE RULE_CODE ='LCZX.A.034.020';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业绩比较基准上限必须大于等于业绩比较基准下限。' WHERE RULE_CODE ='LCZX.A.034.029';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业绩比较基准说明过长。' WHERE RULE_CODE ='LCZX.A.034.031';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品运作模式选择“封闭式净值型”和“封闭式非净值型”的产品,开放模式不能有值;
产品运作模式选择“开放式净值型”和“开放式非净值型”的产品,开放模式不能为空。' WHERE RULE_CODE ='LCZX.A.034.032';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '开放模式不在值域范围内。' WHERE RULE_CODE ='LCZX.A.034.033';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '规律开放周期不在值域范围内。' WHERE RULE_CODE ='LCZX.A.034.036';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品运作模式选择“封闭式净值型”和“封闭式非净值型”的产品,规律开放周期不能有值;' WHERE RULE_CODE ='LCZX.A.034.035';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品运作模式选择“封闭式净值型”和“封闭式非净值型”的产品,其他规律开放周期(天)不能有值!' WHERE RULE_CODE ='LCZX.A.034.040';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他规律开放周期(天)必须为n..4格式。' WHERE RULE_CODE ='LCZX.A.034.039';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他规律开放周期(天)必须大于0。' WHERE RULE_CODE ='LCZX.A.034.038';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品运作模式选择“封闭式净值型”和“封闭式非净值型”的产品,无规律开放说明不能有值。' WHERE RULE_CODE ='LCZX.A.034.042';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '无规律开放说明过长。' WHERE RULE_CODE ='LCZX.A.034.043';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品运作模式选择“封闭式净值型”和“封闭式非净值型”的产品,首次开放周期起始日不能有值;
产品运作模式选择“开放式净值型”和“开放式非净值型”的产品,首次开放周期起始日不能为空。' WHERE RULE_CODE ='LCZX.A.034.044';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品运作模式选择“封闭式净值型”和“封闭式非净值型”的产品,节假日是否开放不能有值;
产品运作模式选择“开放式净值型”和“开放式非净值型”的产品,节假日是否开放不能为空。' WHERE RULE_CODE ='LCZX.A.034.046';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '节假日是否开放不在值域范围内。' WHERE RULE_CODE ='LCZX.A.034.047';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品运作模式选择“封闭式净值型”和“封闭式非净值型”的产品,平均开放次数(年化)不能有值;
产品运作模式选择“开放式净值型”和“开放式非净值型”的产品,平均开放次数(年化)不能为空。' WHERE RULE_CODE ='LCZX.A.034.048';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '平均开放次数(年化)必须为n(5,2)格式。' WHERE RULE_CODE ='LCZX.A.034.050';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '平均开放次数(年化)必须大于0且不能超过366。' WHERE RULE_CODE ='LCZX.A.034.049';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品运作模式选择“封闭式净值型”和“封闭式非净值型”的产品,开放期业务不能有值;
产品运作模式选择“开放式净值型”和“开放式非净值型”的产品,开放期业务不能为空。' WHERE RULE_CODE ='LCZX.A.034.051';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '开放期业务不在值域范围内。' WHERE RULE_CODE ='LCZX.A.034.052';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当开放期业务为其他时,开放期业务说明要素不可为空。' WHERE RULE_CODE ='LCZX.A.034.053';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '开放期业务说明过长。' WHERE RULE_CODE ='LCZX.A.034.055';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品运作模式选择“封闭式净值型”和“封闭式非净值型”的产品,开放期业务说明不能有值;' WHERE RULE_CODE ='LCZX.A.034.054';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集起始日期必须为日期格式(YYYY-MM-DD);募集起始日期必须为正确日期。' WHERE RULE_CODE ='LCZX.A.034.012';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集结束日期必须为日期格式(YYYY-MM-DD);募集结束日期必须为正确日期。' WHERE RULE_CODE ='LCZX.A.034.015';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品起始日期必须为日期格式(YYYY-MM-DD);产品起始日期必须为正确日期。' WHERE RULE_CODE ='LCZX.A.034.018';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品终止日期必须为日期格式(YYYY-MM-DD);产品终止日期必须为正确日期。' WHERE RULE_CODE ='LCZX.A.034.021';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行登记管理方式不在值域范围内;发行登记管理方式要素不可为空。' WHERE RULE_CODE ='LCZX.A.034.022';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '是否为结构化(分级)产品不在值域范围内;是否为结构化(分级)产品要素不可为空。' WHERE RULE_CODE ='LCZX.A.034.023';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当是否为结构化(分级)产品为否时,分级比例要素必须为空;当是否为结构化(分级)产品为是时,分级比例要素不可为空。' WHERE RULE_CODE ='LCZX.A.034.024';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当开放模式为有规律开放时,规律开放周期要素不可为空;当开放模式为无规律开放时,规律开放周期要素必须为空。' WHERE RULE_CODE ='LCZX.A.034.034';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当开放模式为有规律开放、规律开放周期为其他规律开放周期时,其他规律开放周期(天)要素不可为空;当开放模式为无规律开放时,其他规律开放周期(天)要素必须为空。' WHERE RULE_CODE ='LCZX.A.034.037';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当开放模式为有规律开放时,无规律开放说明要素必须为空;当开放模式为无规律开放时,无规律开放说明要素不可为空。' WHERE RULE_CODE ='LCZX.A.034.041';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '首次开放周期起始日必须为正确日期;首次开放周期起始日必须为日期格式(YYYY-MM-DD)。' WHERE RULE_CODE ='LCZX.A.034.045';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码要素格式不对。正确的格式:6位英文或数字。' WHERE RULE_CODE ='LCZX.A.034.005';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该产品在系统已存在发行信息。' WHERE RULE_CODE ='LCZX.A.034.056';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码要素不可为空。' WHERE RULE_CODE ='LCZX.A.001.001';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码必须与银行代码相同。' WHERE RULE_CODE ='LCZX.A.001.002';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码要素不可为空。' WHERE RULE_CODE ='LCZX.A.001.003';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码报文内不可重复。' WHERE RULE_CODE ='LCZX.A.001.005';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该产品不存在。' WHERE RULE_CODE ='LCZX.A.001.006';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该发行机构下已存在该产品的募集总量信息。' WHERE RULE_CODE ='LCZX.A.001.004';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '资金托管账号要素不可为空。' WHERE RULE_CODE ='LCZX.A.001.011';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '资金托管账号过长。' WHERE RULE_CODE ='LCZX.A.001.009';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '资金托管账号要素格式不对。正确的格式:大小写字母或数字、以及“-”。' WHERE RULE_CODE ='LCZX.A.001.010';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '资金托管账户要素不可为空。' WHERE RULE_CODE ='LCZX.A.001.012';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '资金托管账户过长。' WHERE RULE_CODE ='LCZX.A.001.013';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '个人投资者总数要素不可为空。' WHERE RULE_CODE ='LCZX.A.001.014';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '个人投资者总数必须为n..9格式。' WHERE RULE_CODE ='LCZX.A.001.016';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '个人投资者总数必须大于等于0。' WHERE RULE_CODE ='LCZX.A.001.015';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '法人投资者总数要素不可为空。' WHERE RULE_CODE ='LCZX.A.001.017';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '法人投资者总数必须为n..9格式。' WHERE RULE_CODE ='LCZX.A.001.019';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '法人投资者总数必须大于等于0。' WHERE RULE_CODE ='LCZX.A.001.018';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '非法人投资者总数要素不可为空。' WHERE RULE_CODE ='LCZX.A.001.020';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '非法人投资者总数必须为n..9格式。' WHERE RULE_CODE ='LCZX.A.001.022';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '非法人投资者总数必须大于等于0。' WHERE RULE_CODE ='LCZX.A.001.021';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '认购金额要素不可为空。' WHERE RULE_CODE ='LCZX.A.001.027';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '认购金额必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.001.028';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '认购金额必须大于等于0。' WHERE RULE_CODE ='LCZX.A.001.029';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币金额要素不可为空。' WHERE RULE_CODE ='LCZX.A.001.030';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币金额必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.001.032';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币金额必须大于等于0。' WHERE RULE_CODE ='LCZX.A.001.031';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当认购金额的币种为人民币(CNY)时,折算人民币金额与认购金额必须相等。' WHERE RULE_CODE ='LCZX.A.001.033';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品销售区域的多选选项不可重复。' WHERE RULE_CODE ='LCZX.A.001.035';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '区域募集金额要素不可为空。' WHERE RULE_CODE ='LCZX.A.001.038';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '区域募集金额必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.001.040';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '区域募集金额必须大于等于0。' WHERE RULE_CODE ='LCZX.A.001.039';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '实际募集金额(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.001.041';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '实际募集金额(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.001.042';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '实际募集金额(元)必须大于等于0。' WHERE RULE_CODE ='LCZX.A.001.043';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '实际募集金额(元)≠∑各区域募集金额(元)≠∑各币种折算人民币金额(元),请检查这三个元素的值,重新填写。' WHERE RULE_CODE ='LCZX.A.001.044';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集总份额要素不可为空。' WHERE RULE_CODE ='LCZX.A.001.045';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集总份额必须为n(18,5)格式。' WHERE RULE_CODE ='LCZX.A.001.046';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '募集总份额必须大于等于0。' WHERE RULE_CODE ='LCZX.A.001.047';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '代销总金额必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.001.054';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '代销总金额必须大于0。' WHERE RULE_CODE ='LCZX.A.001.053';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '代销总金额必须小于等于实际募集金额。' WHERE RULE_CODE ='LCZX.A.001.055';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品销售区域超出产品申报登记选择的区域,备注必填。' WHERE RULE_CODE ='LCZX.A.001.056';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品销售区域要素不可为空;产品销售区域不在值域范围内。' WHERE RULE_CODE ='LCZX.A.001.034';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '是否有其他机构代销要素不可为空;是否有其他机构代销不在值域范围内。' WHERE RULE_CODE ='LCZX.A.001.049';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当是否有其他机构代销为是时,代销总金额要素不可为空;当是否有其他机构代销为否时,代销总金额要素必须为空。' WHERE RULE_CODE ='LCZX.A.001.052';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码要素格式不对。正确的格式:6位英文或数字。' WHERE RULE_CODE ='LCZX.A.001.002';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码要素格式不对。正确的格式:14或15位英文或数字。' WHERE RULE_CODE ='LCZX.A.001.007';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '认购金额的币种的多选选项不可重复。' WHERE RULE_CODE ='LCZX.A.001.024';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '-' WHERE RULE_CODE ='LCZX.A.001.025';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '备注过长。' WHERE RULE_CODE ='LCZX.A.001.059';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码要素不可为空。' WHERE RULE_CODE ='LCZX.A.002.001';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码必须与银行代码相同。' WHERE RULE_CODE ='LCZX.A.002.003';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码要素格式不对。正确的格式:6位英文或数字。' WHERE RULE_CODE ='LCZX.A.002.002';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码要素不可为空。' WHERE RULE_CODE ='LCZX.A.002.007';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码要素格式不对。正确的格式:14或15位英文或数字。' WHERE RULE_CODE ='LCZX.A.002.008';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该产品不存在。' WHERE RULE_CODE ='LCZX.A.002.009';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '只有产品状态应该为“已募集登记”、“已终止登记”的才可以进行存续期登记。' WHERE RULE_CODE ='LCZX.A.002.013';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,初始净值不能为空。' WHERE RULE_CODE ='LCZX.A.002.017';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '初始净值必须为n(10,5)格式。' WHERE RULE_CODE ='LCZX.A.002.020';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '初始净值必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.016';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,产品净值不能为空。' WHERE RULE_CODE ='LCZX.A.002.022';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品净值必须为n(10,5)格式。' WHERE RULE_CODE ='LCZX.A.002.023';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品净值必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.021';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,累计净值不能为空。' WHERE RULE_CODE ='LCZX.A.002.025';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计净值必须为n(10,5)格式。' WHERE RULE_CODE ='LCZX.A.002.027';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计净值必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.024';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,折算人民币初始净值不能为空。' WHERE RULE_CODE ='LCZX.A.002.033';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币初始净值必须为n(10,5)格式。' WHERE RULE_CODE ='LCZX.A.002.036';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币初始净值必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.032';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当初始净值的币种为人民币(CNY)时,折算人民币初始净值与初始净值必须相等。' WHERE RULE_CODE ='LCZX.A.002.034';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,折算人民币净值不能为空。' WHERE RULE_CODE ='LCZX.A.002.038';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币净值必须为n(10,5)格式。' WHERE RULE_CODE ='LCZX.A.002.040';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币净值必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.037';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当产品净值的币种为人民币(CNY)时,折算人民币净值与产品净值必须相等。' WHERE RULE_CODE ='LCZX.A.002.039';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,折算人民币累计净值不能为空。' WHERE RULE_CODE ='LCZX.A.002.042';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币累计净值必须为n(10,5)格式。' WHERE RULE_CODE ='LCZX.A.002.044';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币累计净值必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.041';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当累计净值的币种为人民币(CNY)时,折算人民币累计净值与累计净值必须相等。' WHERE RULE_CODE ='LCZX.A.002.043';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,净值日期不能为空。' WHERE RULE_CODE ='LCZX.A.002.045';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于非净值型产品,实现收益率不能为空。' WHERE RULE_CODE ='LCZX.A.002.047';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '实现收益率%以百分数形式表示时必须为n(8,5)格式。' WHERE RULE_CODE ='LCZX.A.002.050';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '最新预期收益率以百分数形式表示时必须为n(8,5)格式。' WHERE RULE_CODE ='LCZX.A.002.053';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '银行实现收益(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.002.054';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '银行实现收益(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.002.057';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务起始日要素不可为空。' WHERE RULE_CODE ='LCZX.A.002.058';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务结束日要素不可为空。' WHERE RULE_CODE ='LCZX.A.002.061';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务结束日必须大于等于业务起始日。' WHERE RULE_CODE ='LCZX.A.002.063';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码和业务结束日在报文内不可同时重复。' WHERE RULE_CODE ='LCZX.A.002.064';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '币种要素不可为空。' WHERE RULE_CODE ='LCZX.A.002.065';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '币种不在值域范围内。' WHERE RULE_CODE ='LCZX.A.002.067';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '币种的多选选项不可重复。' WHERE RULE_CODE ='LCZX.A.002.066';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计申购金额(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.002.071';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计申购金额(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.002.073';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计申购金额(元)必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.072';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计兑付金额(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.002.074';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计兑付金额(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.002.076';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计兑付金额(元)必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.075';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计兑付收益金额(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.002.077';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计兑付收益金额(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.002.079';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计兑付收益金额(元)必须小于等于该币种累计兑付金额(元)。' WHERE RULE_CODE ='LCZX.A.002.078';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计申购份额要素不可为空。' WHERE RULE_CODE ='LCZX.A.002.080';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计申购份额必须为n(18,5)格式。' WHERE RULE_CODE ='LCZX.A.002.083';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计申购份额必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.081';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计赎回份额要素不可为空。' WHERE RULE_CODE ='LCZX.A.002.084';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计赎回份额必须为n(18,5)格式。' WHERE RULE_CODE ='LCZX.A.002.087';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计赎回份额必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.085';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '每万份份额分红必须为n(18,5)格式。' WHERE RULE_CODE ='LCZX.A.002.089';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '每万份份额分红必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.088';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '每万份现金分红必须为n(18,5)格式。' WHERE RULE_CODE ='LCZX.A.002.091';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '每万份现金分红必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.090';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于非净值型产品,产品余额不能为空。' WHERE RULE_CODE ='LCZX.A.002.095';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品余额必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.002.096';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品余额必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.092';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品份额要素不可为空。' WHERE RULE_CODE ='LCZX.A.002.097';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品份额必须为n(18,5)格式。' WHERE RULE_CODE ='LCZX.A.002.100';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品份额必须大于等于0。' WHERE RULE_CODE ='LCZX.A.002.098';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '备注过长。' WHERE RULE_CODE ='LCZX.A.002.101';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.001';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码必须与银行代码相同。' WHERE RULE_CODE ='LCZX_BANK.A.002.003';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码要素格式不对。正确的格式:6位英文或数字。' WHERE RULE_CODE ='LCZX_BANK.A.002.002';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.007';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码要素格式不对。正确的格式:14或15位英文或数字。' WHERE RULE_CODE ='LCZX_BANK.A.002.008';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该产品不存在。' WHERE RULE_CODE ='LCZX_BANK.A.002.009';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '只有产品状态应该为“已募集登记”、“已终止登记”的才可以进行存续期登记。' WHERE RULE_CODE ='LCZX_BANK.A.002.013';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,初始净值不能为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.017';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '初始净值必须为n(10,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.020';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '初始净值必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.016';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,产品净值不能为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.022';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品净值必须为n(10,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.023';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品净值必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.021';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,累计净值不能为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.025';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计净值必须为n(10,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.027';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计净值必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.024';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,折算人民币初始净值不能为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.033';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币初始净值必须为n(10,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.036';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币初始净值必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.032';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当初始净值的币种为人民币(CNY)时,折算人民币初始净值与初始净值必须相等。' WHERE RULE_CODE ='LCZX_BANK.A.002.034';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,折算人民币净值不能为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.038';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币净值必须为n(10,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.040';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币净值必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.037';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当产品净值的币种为人民币(CNY)时,折算人民币净值与产品净值必须相等。' WHERE RULE_CODE ='LCZX_BANK.A.002.039';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,折算人民币累计净值不能为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.042';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币累计净值必须为n(10,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.044';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '折算人民币累计净值必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.041';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '当累计净值的币种为人民币(CNY)时,折算人民币累计净值与累计净值必须相等。' WHERE RULE_CODE ='LCZX_BANK.A.002.043';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于净值型产品,净值日期不能为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.045';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于非净值型产品,实现收益率不能为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.047';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '实现收益率%以百分数形式表示时必须为n(8,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.050';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '最新预期收益率以百分数形式表示时必须为n(8,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.053';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '银行实现收益(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.054';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '银行实现收益(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.057';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务起始日要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.058';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务结束日要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.061';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务结束日必须大于等于业务起始日。' WHERE RULE_CODE ='LCZX_BANK.A.002.063';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码和业务结束日在报文内不可同时重复。' WHERE RULE_CODE ='LCZX_BANK.A.002.064';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '币种要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.065';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '币种不在值域范围内。' WHERE RULE_CODE ='LCZX_BANK.A.002.067';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '币种的多选选项不可重复。' WHERE RULE_CODE ='LCZX_BANK.A.002.066';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计申购金额(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.071';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计申购金额(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.073';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计申购金额(元)必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.072';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计兑付金额(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.074';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计兑付金额(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.076';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计兑付金额(元)必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.075';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计兑付收益金额(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.077';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计兑付收益金额(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.079';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该币种累计兑付收益金额(元)必须小于等于该币种累计兑付金额(元)。' WHERE RULE_CODE ='LCZX_BANK.A.002.078';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计申购份额要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.080';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计申购份额必须为n(18,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.083';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计申购份额必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.081';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计赎回份额要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.084';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计赎回份额必须为n(18,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.087';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '累计赎回份额必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.085';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '每万份份额分红必须为n(18,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.089';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '每万份份额分红必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.088';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '每万份现金分红必须为n(18,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.091';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '每万份现金分红必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.090';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '对于非净值型产品,产品余额不能为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.095';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品余额必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.096';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品余额必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.092';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品份额要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.002.097';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品份额必须为n(18,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.002.100';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品份额必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.002.098';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '备注过长。' WHERE RULE_CODE ='LCZX_BANK.A.002.101';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '净值日期必须为日期格式(YYYY-MM-DD);净值日期必须为正确日期。' WHERE RULE_CODE ='LCZX.A.002.046';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务起始日必须为日期格式(YYYY-MM-DD);业务起始日必须为正确日期。' WHERE RULE_CODE ='LCZX.A.002.059';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务结束日必须为日期格式(YYYY-MM-DD);业务结束日必须为正确日期。' WHERE RULE_CODE ='LCZX.A.002.062';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '净值日期必须为日期格式(YYYY-MM-DD);净值日期必须为正确日期。' WHERE RULE_CODE ='LCZX_BANK.A.002.046';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务起始日必须为日期格式(YYYY-MM-DD);业务起始日必须为正确日期。' WHERE RULE_CODE ='LCZX_BANK.A.002.059';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '业务结束日必须为日期格式(YYYY-MM-DD);业务结束日必须为正确日期。' WHERE RULE_CODE ='LCZX_BANK.A.002.062';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '初始净值,产品净值,累计净值的币种必须是相同的。' WHERE RULE_CODE ='LCZX_BANK.A.002.104';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该发行机构下已存在该产品的存续期信息。' WHERE RULE_CODE ='LCZX_BANK.A.002.103';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.001';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码要素格式不对。正确的格式:14或15位英文或数字。' WHERE RULE_CODE ='LCZX.A.003.003';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码报文内不可重复。' WHERE RULE_CODE ='LCZX.A.003.005';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该产品不存在' WHERE RULE_CODE ='LCZX.A.003.002';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.006';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '理财产品实际终止日期要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.008';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '理财产品实际终止日期应大于发行登记中的“产品起始日期”' WHERE RULE_CODE ='LCZX.A.003.009';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '银行实际实现收入(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.011';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '银行实际实现收入(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.003.013';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '银行实际实现收入≠本机构管理费+本机构托管费+本机构销售手续费+本机构其他产品费用,请检查这五个元素的值,重新填写。' WHERE RULE_CODE ='LCZX.A.003.012';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付客户收益(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.014';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付客户收益(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.003.015';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付客户总金额(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.017';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付客户总金额(元)必须为n(16,2)格式。' WHERE RULE_CODE ='LCZX.A.003.018';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付客户总金额(元)必须大于等于0。' WHERE RULE_CODE ='LCZX.A.003.019';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付总份额要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.020';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付总份额必须为n(18,5)格式。' WHERE RULE_CODE ='LCZX.A.003.022';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付总份额必须大于等于0。' WHERE RULE_CODE ='LCZX.A.003.021';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构托管费(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.024';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构托管费(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.003.026';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构托管费(元)必须大于等于0。' WHERE RULE_CODE ='LCZX.A.003.025';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构管理费(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.028';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构管理费(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.003.030';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构管理费(元)必须大于等于0。' WHERE RULE_CODE ='LCZX.A.003.029';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构销售手续费(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.032';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构销售手续费(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.003.034';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构销售手续费(元)必须大于等于0。' WHERE RULE_CODE ='LCZX.A.003.033';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构其他产品费用(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.036';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构其他产品费用(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.003.037';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构托管费(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.038';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构托管费(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.003.040';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构托管费(元)必须大于等于0。' WHERE RULE_CODE ='LCZX.A.003.039';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构管理费(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.042';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构管理费(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.003.044';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构管理费(元)必须大于等于0。' WHERE RULE_CODE ='LCZX.A.003.043';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构销售手续费(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.046';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构销售手续费(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.003.048';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构销售手续费(元)必须大于等于0。' WHERE RULE_CODE ='LCZX.A.003.047';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资顾问费用(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.050';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资顾问费用(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.003.052';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资顾问费用(元)必须大于等于0。' WHERE RULE_CODE ='LCZX.A.003.051';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构其他产品费用(元)要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.054';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构其他产品费用(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX.A.003.055';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '客户实际年化收益率%要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.056';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品实际年化收益率%要素不可为空。' WHERE RULE_CODE ='LCZX.A.003.060';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.001';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码要素格式不对。正确的格式:14或15位英文或数字。' WHERE RULE_CODE ='LCZX_BANK.A.003.003';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品登记编码报文内不可重复。' WHERE RULE_CODE ='LCZX_BANK.A.003.005';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '该产品不存在' WHERE RULE_CODE ='LCZX_BANK.A.003.002';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.006';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '理财产品实际终止日期要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.008';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '理财产品实际终止日期应大于发行登记中的“产品起始日期”' WHERE RULE_CODE ='LCZX_BANK.A.003.009';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '银行实际实现收入(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.011';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '银行实际实现收入(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.003.013';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '银行实际实现收入≠本机构管理费+本机构托管费+本机构销售手续费+本机构其他产品费用,请检查这五个元素的值,重新填写。' WHERE RULE_CODE ='LCZX_BANK.A.003.012';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付客户收益(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.014';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付客户收益(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.003.015';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付客户总金额(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.017';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付客户总金额(元)必须为n(16,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.003.018';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付客户总金额(元)必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.003.019';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付总份额要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.020';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付总份额必须为n(18,5)格式。' WHERE RULE_CODE ='LCZX_BANK.A.003.022';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '兑付总份额必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.003.021';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构托管费(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.024';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构托管费(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.003.026';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构托管费(元)必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.003.025';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构管理费(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.028';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构管理费(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.003.030';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构管理费(元)必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.003.029';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构销售手续费(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.032';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构销售手续费(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.003.034';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构销售手续费(元)必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.003.033';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构其他产品费用(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.036';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '本机构其他产品费用(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.003.037';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构托管费(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.038';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构托管费(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.003.040';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构托管费(元)必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.003.039';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构管理费(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.042';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构管理费(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.003.044';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构管理费(元)必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.003.043';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构销售手续费(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.046';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构销售手续费(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.003.048';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构销售手续费(元)必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.003.047';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资顾问费用(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.050';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资顾问费用(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.003.052';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '投资顾问费用(元)必须大于等于0。' WHERE RULE_CODE ='LCZX_BANK.A.003.051';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构其他产品费用(元)要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.054';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '其他机构其他产品费用(元)必须为n(15,2)格式。' WHERE RULE_CODE ='LCZX_BANK.A.003.055';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '客户实际年化收益率%要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.056';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '产品实际年化收益率%要素不可为空。' WHERE RULE_CODE ='LCZX_BANK.A.003.060';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码必须与银行代码相同;发行机构代码要素格式不对。正确的格式:6位英文或数字。' WHERE RULE_CODE ='LCZX.A.003.007';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '理财产品实际终止日期必须为日期格式(YYYY-MM-DD);理财产品实际终止日期必须为正确日期。' WHERE RULE_CODE ='LCZX.A.003.010';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '发行机构代码必须与银行代码相同;发行机构代码要素格式不对。正确的格式:6位英文或数字。' WHERE RULE_CODE ='LCZX_BANK.A.003.007';
UPDATE pawmrpcs.data_check_rule_set SET RULE_DESC =  '理财产品实际终止日期必须为日期格式(YYYY-MM-DD);理财产品实际终止日期必须为正确日期。' WHERE RULE_CODE ='LCZX_BANK.A.003.010';

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值