alter table T_BD_MATERIAL alter column FMNEMONICCODE nvarchar(1000)--修改单据字段长度
SELECT b.* FROM T_BAS_BILLGLOBALPARAMETER a LEFT JOIN t_BAS_BillGlobalParamSearch b ON a.FID=b.FID WHERE a.FFORMID LIKE '%BD_MATERIAL%'--基础资料物料表
update t_BAS_BillGlobalParamSearch set FISTAKEPARTSEARCH=1 where FID='61d3ee31d2b28e' and FFIELDKEY in ('F_LDP_Remark','F_LDP_Text','F_LDP_Remark1')
update t_BAS_BillGlobalParamSearch set FVISIBLEINSEARCH=1 where FID='61d3ee31d2b28e' and FFIELDKEY in ('F_LDP_Remark','F_LDP_Text','F_LDP_Remark1')--模糊搜索增加超过5个字段
3.科目初始数据替换核算维度
SELECT * FROM T_BD_ACCOUNTBOOK WHERE FNUMBER = '004' --185844 004 100120
SELECT * FROM T_BD_ACCOUNT WHERE FNUMBER = '1221.02' AND FUSEORGID = 100120
SELECT * FROM T_BD_ACCOUNT WHERE FNUMBER = '1221' AND FUSEORGID = 100120
--180946
SELECT * FROM T_GL_BALANCE WHERE FACCOUNTBOOKID = 185844 AND FACCOUNTID IN (180946) AND FDETAILID = 103990
SELECT * FROM T_GL_BALANCE WHERE FACCOUNTBOOKID = 185844 AND FACCOUNTID IN (180946) AND FDETAILID = 120388
SELECT * FROM T_BD_FLEXITEMDETAILV WHERE FID IN (103990,120388)--
--SELECT * INTO T_GL_BALANCE_20220615BAK FROM T_GL_BALANCE
--UPDATE T_GL_BALANCE SET FDETAILID = 120388 WHERE FACCOUNTBOOKID = 185844 AND FACCOUNTID IN (180946) AND FDETAILID = 103990
SELECT * FROM T_Gl_Balance_IniBak WHERE FACCOUNTBOOKID = 185844 AND FACCOUNTID IN (180946) AND FDETAILID = 103990
--UPDATE T_Gl_Balance_IniBak SET FDETAILID = 120388 WHERE FACCOUNTBOOKID = 185844 AND FACCOUNTID IN (180946) AND FDETAILID = 103990
select c.FDETAILID,a.FSUPPLIERID from T_BD_SUPPLIER a
inner join T_BD_SUPPLIER_L b on b.FSUPPLIERID=a.FSUPPLIERID and b.FLOCALEID=2052
inner join T_BD_FLEXITEM c on c.FITEMID=a.FMASTERID
where b.FNAME='北京翔鸿伟业商贸有限公司' and a.FUSEORGID=100120
select c.FDETAILID,a.FSUPPLIERID from T_BD_SUPPLIER a
inner join T_BD_SUPPLIER_L b on b.FSUPPLIERID=a.FSUPPLIERID and b.FLOCALEID=2052
inner join T_BD_FLEXITEM c on c.FITEMID=a.FMASTERID
where b.FNAME='北京翔鸿伟业环保科技有限公司' and a.FUSEORGID=100120
推荐阅读