④内部公开请勿外传-------1、检查新期间是否有旧科目日记账业务发生---------SELECTdistinctc.fnumber组织编码,p.fnumber新期间编码,at.fnumber旧科目表编码,bk.fnumber银行账户编码FROMT_CAS_JOURNALjinnerjoinT_BD_PERIODpONJ.FPERIODID=P.FIDinnerjoinT_ORG_COMPANYcONJ.FCOMPANYID=C.FIDinnerjoinT_BD_ACCOUNTVIEWavONJ.FACCOUNTVIEWID=AV.FIDinnerjoinT_BD_ACCOUNTTABLEatonav.FACCOUNTTABLEID=at.fidinnerjoint_bd_accountbanksbkONJ.FACCOUNTBANKID=BK.FIDwhere1=1andbk.fnumber='银行账户编码'andc.fnumber='组织编码'andp.fnumber>'科目对照期间编码'andat.fnumber='旧科目表编码'-------2、检查新期间是否有旧科目对账单业务发生---------SELECTdistinctc.fnumber组织编码,p.fnumber新期间编码,at.fnumber旧科目表编码,bk.fnumber银行账户编码FROMT_CAS_BANKSTATEMENTjinnerjoinT_BD_PERIODpONJ.FPERIODID=P.FIDinnerjoinT_ORG_COMPANYcONJ.FCOMPANYID=C.FIDinnerjoinT_BD_ACCOUNTVIEWavONJ.FACCOUNTVIEWID=AV.FIDinnerjoinT_BD_ACCOUNTTABLEatonav.FACCOUNTTABLEID=at.fidinnerjoint_bd_accountbanksbkONJ.FACCOUNTBANKID=BK.FIDwhere1=1andbk.fnumber='银行账户编码'andc.fnumber='组织编码'andp.fnumber>'科目对照期间编码'andat.fnumber='旧科目表编码'-------3、检查新期间是否有旧科目日记账对账单余额---------SELECTdistinctc.fnumber组织编码,p.fnumber新期间编码,at.fnumber旧科目表编码,bk.fnumber银行账户编码FROMT_CAS_JOURNALbalancejinnerjoinT_BD_PERIODpONJ.FPERIODID=P.FIDinnerjoinT_ORG_COMPANYcONJ.FCOMPANYID=C.FIDinnerjoinT_BD_ACCOUNTVIEWavONJ.FACCOUNTVIEWID=AV.FIDinnerjoinT_BD_ACCOUNTTABLEatonav.FACCOUNTTABLEID=at.fidinnerjoint_bd_accountbanksbkONJ.FACCOUNTBANKID=BK.FIDwhere1=1andbk.fnumber='银行账户编码'andc.fnumber='组织编码'andp.fnumber>'科目对照期间编码'andat.fnumber='旧科目表编码'1/1
