跳到主要内容

《合并报表_整合任务参数循环》

表1：《整合任务-基础数据同步循环参数档案-T+13.0》​

更新日期：2022-05-29

    select distinct dbname, iyear 
    from (select dbname  from CO_JC_Account where dbtype like '用友T+%13.0%' and qiyong='是') as a
    cross join (select distinct iyear  from TZ_JC_Fypeirod where iyear>=$(财务模块_数据同步年度范围) and iyear<=year(getdate())) as b

表2：《整合任务-基础数据同步循环参数档案-T+Cloud》​

更新日期：2022-05-29

    select distinct dbname, iyear 
    from (select dbname  from CO_JC_Account where dbtype like '用友T+Cloud%' and qiyong='是') as a
    cross join (select distinct iyear  from TZ_JC_Fypeirod where iyear>=$(财务模块_数据同步年度范围) and iyear<=year(getdate())) as b

表3：《整合任务-基础数据同步循环参数档案-用友U8》​

更新日期：2022-05-29

    select distinct dbname, iyear 
    from (select dbname  from CO_JC_Account where dbtype like '用友U8%' and qiyong='是') as a
    cross join (select distinct iyear  from TZ_JC_Fypeirod where iyear>=$(财务模块_数据同步年度范围) and iyear<=year(getdate())) as b

表4：《整合任务-合并报表-报表数据更新循环参数》​

更新日期：2022-05-29

    select distinct '报表数据' as itype,accidname, iyear 
    from (select accidname  from CO_JC_Account where qiyong='是') as a
    cross join (select distinct iyear  from TZ_JC_Fypeirod where iyear>=$(合并报表_数据更新年度范围) and iyear<=year(getdate())) as b

导入文件​

《电子表格-整合任务参循环.data》