成本核算速度优化

select FDATETIME,FDESCRIPTION from T_BAS_OPERATELOG where FOBJECTTYPEID = N'核算代码跟踪日志' and FDATETIME>'2022-04-11'  and   FDESCRIPTION  like '%分公司（事业部）%'     ORDER BY FDATETIME DESC

select *　from T_HS_OUTACCTG where facctgstartdate is not null order by facctgstartdate desc
--101063

 select d.FNAME ,facctgid ,fbillfromid,count(1) from T_HS_STOCKSEQ_101063 a
inner join T_HS_OUTACCTG b on a.facctgid = b.fid
inner join T_HS_CALDIMENSIONS c on b.fdimensionid = c.fdimensionid
inner join T_ORG_ORGANIZATIONS_L d on c.ffinorgid =d.forgid and d.flocaleid = 2052
where fisgenforios = '1'   group by facctgid ,fbillfromid,d.FNAME
order by count(1) desc

select *From T_HS_STOCKSEQ_101063

select *from T_BAS_SYSTEMPROFILE WHERE FKEY = 'OVERORGREVERTTYPE' and FCATEGORY='HS';


INSERT INTO T_BAS_SYSTEMPROFILE(FCATEGORY,FORGID,FACCOUNTBOOKID,FKEY,FVALUE,FACCTPOLICYID,FACCTSYSTEMID)
VALUES('HS',0,0,'OVERORGREVERTTYPE','1',0,0);

select *From T_HS_SPLITTABLE

--------------