--删除多余的固定资产菜单
DELETE FROM SMENU WHERE LEFT(EXE_NM,6) = 'ACE007' OR LEFT(EXE_NM,4) = 'ACE2'
DELETE SECURITY WHERE LEFT(MENU_CD,6) = 'ACE007' OR LEFT(MENU_CD,4) = 'ACE2'


--凭证年度结转 出现科目错误，管理项目多一个勾。 
--SELECT * FROM SACCT WHERE CO_CD='1000'
UPDATE SACCT SET NORM_CD1 ='0', NORM_CD2='0' WHERE CO_CD='1000'


--固定资产年度结转 出现错误
SELECT * FROM ASSET WHERE CO_CD='2000' AND DIV_CD='1000'
SELECT * FROM ASSET WHERE GET_AM='0'					 --查看资产原值=0项
SELECT * FROM ASSET WHERE DUMMY1<>'0' DUMMY1 AND		 -- 有0.00 或空值
--计提方法－DPRE_FG= N'1',  折旧年限－DPRE_CNT= 6, 净残值率－SLACK_AM，  折旧状态－ DPRE_ST 
SELECT * FROM ASSET WHERE DUMMY1='' or DUMMY1 IS NULL 
-- UPDATE ASSET SET DUMMY1='0' WHERE DUMMY1='' or DUMMY1 IS NULL  
SELECT * FROM ASSET WHERE GET_AM='0' OR  DUMMY1<>'0' OR DUMMY1='' or DUMMY1 IS NULL   --全部，不行查新资产折旧状态错误，
SELECT * FROM ADPREY WHERE GISU='11'
-- DELETE  FROM ADPREY WHERE GISU='11' AND CO_CD='2000'
--ADPREY- 固定资产折旧数据表，查看哪个资产没有数据。 
SELECT ASSET_CD FROM ASSET WHERE  ASSET_CD NOT IN ( SELECT ASSET_CD FROM ADPREY WHERE GISU='11' ) AND CO_CD='1000'
-- 再不行把[SPA_DEPREM_C]存储过程的TANSACTION注释掉结帐后查看哪个资产没有结转过去。



--ERPX升级到ICUBE资产减少不对
--0.
select * from asset_d where chg_fg = '2'
--1.
update adprey set drop_am = pre_am,drop_dam = pre_dam+cur_dam where asset_cd='50007' and gisu = 15--资产减少年度
--2.
update adprey set pre_am = 0,drop_am = 0,pre_dam=0,cur_dam=0,drop_dam = 0 where asset_cd='50007' and gisu > 15



找出-结算资料录入-固定资产折旧-累计折旧科目为空的项目
--INSERT INTO AFSCLSD_CFG_ASSET (CO_CD,GR_CD,CTRL_VL)
SELECT '1000',A.GR_CD,A.CT_DEPT
FROM ASSET A
LEFT OUTER JOIN AFSCLSD_CFG_ASSET B ON A.GR_CD = B.GR_CD AND A.CT_DEPT = B.CTRL_VL
WHERE B.CTRL_VL IS NULL
GROUP BY A.GR_CD,A.CT_DEPT,B.CTRL_VL

--INSERT INTO AFSCLSD_CFG_ASSET (CO_CD,GR_CD,CTRL_VL)
SELECT A.GR_CD as GR_CD资产类别,A.CT_DEPT as CT_DEPT部门, a.co_cd, a.div_cd
FROM ASSET A
LEFT OUTER JOIN AFSCLSD_CFG_ASSET B ON A.GR_CD = B.GR_CD AND A.CT_DEPT = B.CTRL_VL
WHERE B.CTRL_VL IS NULL and a.co_cd='1000'
GROUP BY A.GR_CD,A.CT_DEPT,B.CTRL_VL,a.co_cd, a.div_cd


--查找 "固定资产登记" 里没有录入部门的资产
SELECT * FROM ASSET 
where co_cd='1000' and ct_dept is null 
   or co_cd='1000' and ct_dept=''