③秘密信息严禁泄露说明：8.6版，核算项目是供应商的修改：分为两种情况：1.全集团所有用到此供应商的都凭证修改：2.只用一张凭证的数据供应商修改注意：以下是相关截图和方案以及脚本：一.全集团所有用到此供应商的都凭证修改1/6③秘密信息严禁泄露2/6③秘密信息严禁泄露更换全集团横表引用的供应商select*fromT_BD_AccountViewwherefid='eISaVbNASyqgApfRJW4EUJ2pmCY='select*fromT_BD_Supplierwherefid='c6oAAAAAaho3xn38'select*fromT_BD_AssistantHGwhereFASSTACCOUNTID='c6oAAAAAXnFGWhD4'andFPROVIDERID='c6oAAAAAaho3xn38'---备份横表select*intobak_2021072001fromT_BD_AssistantHGwhereFASSTACCOUNTID='c6oAAAAAXnFGWhD4'andFPROVIDERID='c6oAAAAAaho3xn38'--替换横表供应商idupdateT_BD_AssistantHGsetFPROVIDERID='替换的正确供应商id可以在供应商基础数据里ctrl+shift+c复制'whereFASSTACCOUNTID='c6oAAAAAXnFGWhD4'andFPROVIDERID='c6oAAAAAaho3xn38'--做完后根据辅助账类型修复辅助账名称（ctrl+shift+f8）二.只用一张凭证的数据供应商修改3/6③秘密信息严禁泄露4/6③秘密信息严禁泄露5/6③秘密信息严禁泄露----查出待替换的凭证--凭证头表select*fromT_GL_Voucherwherefid='xqQ6E9XgSIKEpSJJXC9/vSZS4B4='--凭证分录select*fromT_GL_Voucherentrywherefbillid='xqQ6E9XgSIKEpSJJXC9/vSZS4B4='--凭证辅助账select*fromt_gl_voucherassistrecordwhereFENTRYID='cilqQUOFRFWFuC41nPYr5XGqmvQ='--横表select*fromT_BD_AssistantHGwherefid='c6oAAAAAltBBimy7'andFPROVIDERID='c6oAAAAAaho3xn38'---二查出正确的凭证引用idselect*fromT_GL_Voucherwherefid='c6oAAAB9Iv0mUuAe'--凭证分录select*fromT_GL_Voucherentrywherefbillid='c6oAAAB9Iv0mUuAe'--凭证辅助账select*fromt_gl_voucherassistrecordwhereFENTRYID='BBO8YCwbT9ywWmi6mEVv8XGqmvQ='–-正确的横表select*fromT_BD_AssistantHGwherefid='c6oAAAAAlzZBimy7'--备份待更新辅助账select*intobak_202107202fromt_gl_voucherassistrecordwhereFENTRYID='cilqQUOFRFWFuC41nPYr5XGqmvQ='--查询备份表select*frombak_202107202--更新正确的横表fid也就是第二次暂存凭证后查出的FASSGRPIDupdatet_gl_voucherassistrecordsetFASSGRPID=’正确的横表fid’whereFENTRYID='cilqQUOFRFWFuC41nPYr5XGqmvQ='6/6
