/* 组织业务职能.名称 */
UPDATE t_org_bizlist set FNAME = ISNULL((select max(tl.FNAME) from t_org_bizlist_l tl where t_org_bizlist.FID = tl.FID AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';
/* 组织视图方案.名称 */
UPDATE t_org_viewschema set FNAME = ISNULL((select max(tl.FNAME) from t_org_viewschema_l tl where t_org_viewschema.FID = tl.FID AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';
/* 业务单元.名称 */
UPDATE t_org_org set FNAME = ISNULL((select max(tl.FNAME) from t_org_org_l tl where t_org_org.FID = tl.FID AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';
/* 业务单元历史.名称 */
UPDATE t_org_org_h set FNAME = ISNULL((select max(tl.FNAME) from t_org_org_h_l tl where t_org_org_h.FID = tl.FID AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';
/* 组织结构.长名称 */
UPDATE t_org_structure set FFULLNAME = ISNULL((select max(tl.FFULLNAME) from t_org_structure_l tl where t_org_structure.FID = tl.FID AND flocaleid = 'zh_CN'), ' ') where FFULLNAME is null or FFULLNAME = ' ';
/* 组织结构历史.长名称 */
UPDATE t_org_structure_h set FFULLNAME = ISNULL((select max(tl.FFULLNAME) from t_org_structure_h_l tl where t_org_structure_h.FID = tl.FID AND flocaleid = 'zh_CN'), ' ') where FFULLNAME is null or FFULLNAME = ' ';
/* 部门属性分组.名称 */
UPDATE t_org_dutygroup set FNAME = ISNULL((select max(tl.FNAME) from t_org_dutygroup_l tl where t_org_dutygroup.FID = tl.FID AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';
/* 部门属性.名称 */
UPDATE t_org_duty set FNAME = ISNULL((select max(tl.FNAME) from t_org_duty_l tl where t_org_duty.FID = tl.FID AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';
/* 组织形态.名称 */
UPDATE t_org_pattern set FNAME = ISNULL((select max(tl.FNAME) from t_org_pattern_l tl where t_org_pattern.FID = tl.FID AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';
/* 业务协作关系.名称 */
UPDATE t_org_typerelation set FNAME = ISNULL((select max(tl.FNAME) from t_org_typerelation_l tl where t_org_typerelation.FID = tl.FID AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';

/* 人员.姓名 */
UPDATE t_sec_user set FTRUENAME = ISNULL((select max(tl.FTRUENAME) from t_sec_user_l tl where t_sec_user.FID = tl.FID AND flocaleid = 'zh_CN'), ' ') where FTRUENAME is null or FTRUENAME = ' ';
/* 单据体.职位 */
UPDATE t_sec_userposition set FPOSITION = ISNULL((select max(tl.FPOSITION) from t_sec_userposition_l tl where t_sec_userposition.FENTRYID = tl.FENTRYID AND flocaleid = 'zh_CN'), ' ') where FPOSITION is null or FPOSITION = ' ';
/* 人员历史.姓名 */
UPDATE t_sec_user_h set FTRUENAME = ISNULL((select max(tl.FTRUENAME) from t_sec_user_h_l tl where t_sec_user_h.FID = tl.FID AND flocaleid = 'zh_CN'), ' ') where FTRUENAME is null or FTRUENAME = ' ';
/* 单据体.职位 */
UPDATE t_sec_userposition_h set FPOSITION = ISNULL((select max(tl.FPOSITION) from t_sec_userposition_h_l tl where t_sec_userposition_h.FENTRYID = tl.FENTRYID AND flocaleid = 'zh_CN'), ' ') where FPOSITION is null or FPOSITION = ' ';
/* 人员类型.名称 */
UPDATE t_sec_usertype set FNAME = ISNULL((select max(tl.FNAME) from t_sec_usertype_l tl where t_sec_usertype.FID = tl.FID AND flocaleid = 'zh_CN'), ' ') where FNAME is null or FNAME = ' ';