浪潮软件ps91科目变更操作

浪潮软件ps91科目变更操作

/*假设浪潮科目结构原来是 422222,某个二级科目增加到 99 个的时候(二级编号 01-99),客户希望二级科目改为 3 位编码*/

/*这样二级科目就可以使用 999 个,所以需要修改 LSCONF 中科目编码结构值和调整所有使用到科目编号的表。*/

UPDATE LSCONF SET F_VAL=’432222′ WHERE F_VKEY=’ZW_KMSTRU’ UPDATE GDHSKM set GDHSKM_KMBH=substring(GDHSKM_KMBH,1,4)+’0′+substring(GDHSKM_KMBH,5,30) UPDATE GDMXKM set GDMXKM_KMBH=substring(GDMXKM_KMBH,1,4)+’0′+substring(GDMXKM_KMBH,5,30) UPDATE GZHSKM set GZHSKM_KMBH=substring(GZHSKM_KMBH,1,4)+’0′+substring(GZHSKM_KMBH,5,30) UPDATE GZMXKM set GZMXKM_KMBH=substring(GZMXKM_KMBH,1,4)+’0′+substring(GZMXKM_KMBH,5,30) UPDATE LSKMLB set LSKMLB_KMBH=substring(LSKMLB_KMBH,1,4)+’0′+substring(LSKMLB_KMBH,5,30) UPDATE LSMXKM set LSMXKM_KMBH=substring(LSMXKM_KMBH,1,4)+’0′+substring(LSMXKM_KMBH,5,30) UPDATE ZWCNQZ set ZWCNQZ_KMBH=substring(ZWCNQZ_KMBH,1,4)+’0′+substring(ZWCNQZ_KMBH,5,30) UPDATE ZWDLCS set ZWDLCS_KMBH=substring(ZWDLCS_KMBH,1,4)+’0′+substring(ZWDLCS_KMBH,5,30) UPDATE ZWDZQC set ZWDZQC_KMBH=substring(ZWDZQC_KMBH,1,4)+’0′+substring(ZWDZQC_KMBH,5,30) UPDATE ZWDZZH set ZWDZZH_KMBH=substring(ZWDZZH_KMBH,1,4)+’0′+substring(ZWDZZH_KMBH,5,30) UPDATE ZWFYMB set ZWFYMB_KMBH=substring(ZWFYMB_KMBH,1,4)+’0′+substring(ZWFYMB_KMBH,5,30) UPDATE ZWFZJE set ZWFZJE_KMBH=substring(ZWFZJE_KMBH,1,4)+’0′+substring(ZWFZJE_KMBH,5,30) UPDATE ZWFZLJ set ZWFZLJ_KMBH=substring(ZWFZLJ_KMBH,1,4)+’0′+substring(ZWFZLJ_KMBH,5,30) UPDATE ZWFZSL set ZWFZSL_KMBH=substring(ZWFZSL_KMBH,1,4)+’0′+substring(ZWFZSL_KMBH,5,30) UPDATE ZWFZWB set ZWFZWB_KMBH=substring(ZWFZWB_KMBH,1,4)+’0′+substring(ZWFZWB_KMBH,5,30) UPDATE ZWFZYS set ZWFZYS_KMBH=substring(ZWFZYS_KMBH,1,4)+’0′+substring(ZWFZYS_KMBH,5,30) UPDATE ZWFZZY set ZWFZZY_KMBH=substring(ZWFZZY_KMBH,1,4)+’0′+substring(ZWFZZY_KMBH,5,30) UPDATE ZWHXJL set ZWHXJL_KMBH=substring(ZWHXJL_KMBH,1,4)+’0′+substring(ZWHXJL_KMBH,5,30) UPDATE ZWHXYJ set ZWHXYJ_KMBH=substring(ZWHXYJ_KMBH,1,4)+’0′+substring(ZWHXYJ_KMBH,5,30) UPDATE ZWKMFC set ZWKMFC_KMBH=substring(ZWKMFC_KMBH,1,4)+’0′+substring(ZWKMFC_KMBH,5,30) UPDATE ZWKMJE set ZWKMJE_KMBH=substring(ZWKMJE_KMBH,1,4)+’0′+substring(ZWKMJE_KMBH,5,30) UPDATE ZWKMQX set ZWKMQX_KMBH=substring(ZWKMQX_KMBH,1,4)+’0′+substring(ZWKMQX_KMBH,5,30) UPDATE ZWKMSC set ZWKMSC_KMBH=substring(ZWKMSC_KMBH,1,4)+’0′+substring(ZWKMSC_KMBH,5,30) UPDATE ZWKMSL set ZWKMSL_KMBH=substring(ZWKMSL_KMBH,1,4)+’0′+substring(ZWKMSL_KMBH,5,30) UPDATE ZWKMWB set ZWKMWB_KMBH=substring(ZWKMWB_KMBH,1,4)+’0′+substring(ZWKMWB_KMBH,5,30) UPDATE ZWKMWL set ZWKMWL_KMBH=substring(ZWKMWL_KMBH,1,4)+’0′+substring(ZWKMWL_KMBH,5,30) UPDATE ZWKMZD set ZWKMZD_KMBH=substring(ZWKMZD_KMBH,1,4)+’0′+substring(ZWKMZD_KMBH,5,30) UPDATE ZWKMZX set ZWKMZX_KMBH=substring(ZWKMZX_KMBH,1,4)+’0′+substring(ZWKMZX_KMBH,5,30) UPDATE ZWPZFL set ZWPZFL_KMBH=substring(ZWPZFL_KMBH,1,4)+’0′+substring(ZWPZFL_KMBH,5,30) UPDATE ZWPZMB set ZWPZMB_KMBH=substring(ZWPZMB_KMBH,1,4)+’0′+substring(ZWPZMB_KMBH,5,30) UPDATE ZWRJQC set ZWRJQC_KMBH=substring(ZWRJQC_KMBH,1,4)+’0′+substring(ZWRJQC_KMBH,5,30) UPDATE ZWRJYM set ZWRJYM_KMBH=substring(ZWRJYM_KMBH,1,4)+’0′+substring(ZWRJYM_KMBH,5,30) UPDATE ZWRJZD set ZWRJZD_KMBH=substring(ZWRJZD_KMBH,1,4)+’0′+substring(ZWRJZD_KMBH,5,30) UPDATE ZWWLDJ set ZWWLDJ_KMBH=substring(ZWWLDJ_KMBH,1,4)+’0′+substring(ZWWLDJ_KMBH,5,30) UPDATE ZWWLQY set ZWWLQY_KMBH=substring(ZWWLQY_KMBH,1,4)+’0′+substring(ZWWLQY_KMBH,5,30) UPDATE ZWXGKM set ZWXGKM_KMBH=substring(ZWXGKM_KMBH,1,4)+’0′+substring(ZWXGKM_KMBH,5,30) UPDATE ZWYHZD set ZWYHZD_KMBH=substring(ZWYHZD_KMBH,1,4)+’0′+substring(ZWYHZD_KMBH,5,30) UPDATE ZWZDFL set ZWZDFL_KMBH=substring(ZWZDFL_KMBH,1,4)+’0′+substring(ZWZDFL_KMBH,5,30) UPDATE ZWZGDJ set ZWZGDJ_KMBH=substring(ZWZGDJ_KMBH,1,4)+’0′+substring(ZWZGDJ_KMBH,5,30) UPDATE ZWZGHX set ZWZGHX_KMBH=substring(ZWZGHX_KMBH,1,4)+’0′+substring(ZWZGHX_KMBH,5,30) UPDATE ZWZGQY set ZWZGQY_KMBH=substring(ZWZGQY_KMBH,1,4)+’0′+substring(ZWZGQY_KMBH,5,30)

原创文章,转载请注明: 转载自浪潮888博客

本文链接地址: 浪潮软件ps91科目变更操作

文章的脚注信息由WordPress的wp-posturl插件自动生成



This entry was posted in 浪潮文档. Bookmark the permalink.

发表评论

电子邮件地址不会被公开。 必填项已用 * 标注

*

您可以使用这些 HTML 标签和属性: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>