KIS标准版升级专业版固定资产调整

1、检查卡片新增当期，固定资产卡片期初原值不为 0 的卡片
SELECT fabal.* FROM FABal INNER JOIN FAVch ON (FABal.FAssetID = FAVch.FAssetID) AND
(FABal.FPeriod = FAVch.FPeriod)
where favch.falterid<=7 and fabal.forgval<>0 and fabal.FService=-1

2、在卡片新增当期，卡片不应该有期初余额
UPDATE FABal INNER JOIN FAVch ON (FABal.FPeriod = FAVch.FPeriod) AND (FABal.FAssetID =
FAVch.FAssetID) SET FABal.FOrgVal=0 ,FABal.FOrgValA=0
WHERE FAVch.FAlterID<=7 AND FABal.FOrgVal<>0 and fabal.FService=-1

update glvch set fgroup='记'

update favch set fgroup='记'

ypbwkfyjhyhgzj