----修改总账
--修改启用年份 update t_systemprofile set FValue='2018' where fcategory='GL' and Fkey='startyear'
--修改启用期间 
update t_systemprofile set FValue='1' where fcategory='GL' and Fkey='startperiod'
--修改当前年份 
update t_systemprofile set FValue='2018' where fcategory='GL' and Fkey='CurrentYear'
--修改当前期间 
update t_systemprofile set FValue='1' where fcategory='GL' and Fkey='CurrentPeriod'
----修改供应链--修改启用年份 update t_systemprofile set FValue='2018' where fcategory='IC' and Fkey='startyear'

--修改启用期间 update t_systemprofile set FValue='1' where fcategory='IC' and Fkey='startperiod'

--修改当前年份 update t_systemprofile set FValue='2018' where fcategory='IC' and Fkey='CurrentYear'

--修改当前期间 update t_systemprofile set FValue='1' where fcategory='IC' and Fkey='CurrentPeriod'
--修改固定资产
  --修改启用年份 
  update t_systemprofile set fvalue='2018' where fkey='StartYear' and fcategory='FA' 
  --修改启用期间 
  update t_systemprofile set fvalue='1' where fkey='StartPeriod' and fcategory='FA'
  --修改当前年份 
  update t_systemprofile set fvalue='2018' where fkey='CurrentYear' and fcategory='FA' 
  --修改当前期间 
  update t_systemprofile set fvalue='1' where fkey='CurrentPeriod' and fcategory='FA'
 
 
--应收select * from t_RP_SystemProfile where FKey='FARCurYear'select * from t_RP_SystemProfile where FKey='FARCurPeriod'
 
--应付select * from t_RP_SystemProfile where FKey='FAPCurYear'select * from t_RP_SystemProfile where FKey='FAPCurPeriod'
————————————————
版权声明：本文为CSDN博主「不会游泳的饺子」的原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接及本声明。
原文链接：https://blog.csdn.net/qq_35903121/article/details/108058238