-- 工单汇报单：备注 remark
UPDATE T_POM_MFTORDERREPORT AS T1 SET FREMARK = (SELECT FREMARK FROM T_POM_MFTORDERREPORT_L AS T2 WHERE T1.FID=T2.FID AND T2.FLOCALEID ='zh_CN')
WHERE T1.FID IN (SELECT FID FROM T_POM_MFTORDERREPORT_L WHERE FLOCALEID ='zh_CN');

-- 生产组件清单（组件明细）：备注 childremarks、安装位置 setuplocation
UPDATE T_POM_MANUSTOCKENTRY AS T1 SET FCHILDREMARKS = (SELECT FCHILDREMARKS FROM T_POM_MANUSTOCKENTRY_L AS T2 WHERE T1.FDETAILID=T2.FDETAILID AND T2.FLOCALEID ='zh_CN')
WHERE T1.FDETAILID IN (SELECT FDETAILID FROM T_POM_MANUSTOCKENTRY_L WHERE FLOCALEID ='zh_CN');
UPDATE T_POM_MANUSTOCKENTRY AS T1 SET FSETUPLOCATION = (SELECT FSETUPLOCATION FROM T_POM_MANUSTOCKENTRY_L AS T2 WHERE T1.FDETAILID=T2.FDETAILID AND T2.FLOCALEID ='zh_CN')
WHERE T1.FDETAILID IN (SELECT FDETAILID FROM T_POM_MANUSTOCKENTRY_L WHERE FLOCALEID ='zh_CN');
-- 生产组件清单变更单（组件明细）：备注 childremarks、安装位置 setuplocation
UPDATE T_POM_XMANUSTOCKENTRY AS T1 SET FCHILDREMARKS = (SELECT FCHILDREMARKS FROM T_POM_XMANUSTOCKENTRY_L AS T2 WHERE T1.FDETAILID=T2.FDETAILID AND T2.FLOCALEID ='zh_CN')
WHERE T1.FDETAILID IN (SELECT FDETAILID FROM T_POM_XMANUSTOCKENTRY_L WHERE FLOCALEID ='zh_CN');
UPDATE T_POM_XMANUSTOCKENTRY AS T1 SET FSETUPLOCATION = (SELECT FSETUPLOCATION FROM T_POM_XMANUSTOCKENTRY_L AS T2 WHERE T1.FDETAILID=T2.FDETAILID AND T2.FLOCALEID ='zh_CN')
WHERE T1.FDETAILID IN (SELECT FDETAILID FROM T_POM_XMANUSTOCKENTRY_L WHERE FLOCALEID ='zh_CN');
-- 检修组件清单（组件明细）：备注 childremarks、安装位置 setuplocation
UPDATE T_POM_MROSTOCKENTRY AS T1 SET FCHILDREMARKS = (SELECT FCHILDREMARKS FROM T_POM_MROSTOCKENTRY_L AS T2 WHERE T1.FENTRYID=T2.FENTRYID AND T2.FLOCALEID ='zh_CN')
WHERE T1.FENTRYID IN (SELECT FENTRYID FROM T_POM_MROSTOCKENTRY_L WHERE FLOCALEID ='zh_CN');
UPDATE T_POM_MROSTOCKENTRY AS T1 SET FSETUPLOCATION = (SELECT FSETUPLOCATION FROM T_POM_MROSTOCKENTRY_L AS T2 WHERE T1.FENTRYID=T2.FENTRYID AND T2.FLOCALEID ='zh_CN')
WHERE T1.FENTRYID IN (SELECT FENTRYID FROM T_POM_MROSTOCKENTRY_L WHERE FLOCALEID ='zh_CN');
 
-- 调拨计划方案定义：名称 name
UPDATE T_POM_PLANPROGRAM AS T1 SET FNAME = (SELECT FNAME FROM T_POM_PLANPROGRAM_L AS T2 WHERE T1.FID=T2.FID AND T2.FLOCALEID ='zh_CN')
WHERE T1.FID IN (SELECT FID FROM T_POM_PLANPROGRAM_L WHERE FLOCALEID ='zh_CN');
