修改模块启用日期

---------查询公司pk

select  pk_corp from bd_corp where unitcode='公司编码'

---------模块启用表

update sm_createcorp set accountmonth='正确的会计期间10' where pk_corp='公司pk'

---------修改总账模块启用时间

update bd_glorgbook set pk_startaccperiod=(select pk_accperiodmonth from bd_accperiod a,bd_accperiodmonth b where a.pk_accperiod=b.pk_accperiod and a.periodyear='正确的年2012' and b.month='正确的会计期间10' 

and a.pk_accperiodscheme=(select pk_accperiodscheme from bd_accperiodscheme  where accperiodschemecode='期间方案编码一般默认0001'))

where glorgbookcode='账簿编码102-0001'

---------修改固定资产模块启用时间

update bd_glorgbook set pk_startperiod_fa=(select pk_accperiodmonth from bd_accperiod a,bd_accperiodmonth b where a.pk_accperiod=b.pk_accperiod and a.periodyear='正确的年2012' and b.month='正确的会计期间10' 

and a.pk_accperiodscheme=(select pk_accperiodscheme from bd_accperiodscheme  where accperiodschemecode='期间方案编码一般默认0001'))

where glorgbookcode='账簿编码102-0001'