--1.查询所有未发出通知单selectdistinctcom.FNUMBER公司编码,pd.FNUMBER期间编码,vch.fnumber凭证编码,vch.FID凭证IDfromT_GL_VouchervchjoinT_BD_VoucherTypesvchTypeonvch.FVoucherTypeID=vchType.FIDjoinT_Org_Companycomonvch.FCompanyId=com.FIDjoinT_BD_Periodpdonvch.FPeriodID=pd.FIDleftjoinT_BKS_AcountSchemeacsonacs.fid=com.FAccountSchemeIDjoinT_GL_VoucherEntryentryonvch.FID=entry.FBillIDjoinT_GL_VoucherAssistRecordrecordonentry.FID=record.FEntryIDjoinT_BD_AccountViewacctonentry.FAccountID=acct.FIDandacct.FACNotice=1joinT_BD_AssistantHGassGrponrecord.FAssGrpID=assGrp.FIDleftjoinT_BD_CustomercustomeronassGrp.FCustomerID=customer.FIDleftjoinT_BD_SuppliersupplieronassGrp.FProviderID=supplier.FIDwherevch.fbizstatus<>0andvch.fsourcetype<>7andvch.FSourceType<>2andvch.FSourceType<>1andrecord.Fbillid=vch.FIDandrecord.FOriginalAmount<>0--andrecord.freqCheckStatus<>2--勾稽状态一般存在异常造成没有发出and(assGrp.FCompanyOrgIDisnotnullorcustomer.FInternalCompanyIDisnotnullorsupplier.FInternalCompanyIDisnotnull)and(acs.fidisnulloracs.FIsMaster=1)--andcom.FNUMBER='001'andpd.FNUMBER='202203'--组织编码和期间andnotexists(select1fromt_csl_RequisitionEntryreqewherereqe.FAssistRecordID=record.fid)---2.应该发送通知单但是未发的情况selectdistinctcom.FNUMBER公司编码,pd.FNUMBER期间编码,vch.fnumber凭证编码,vch.FID凭证IDfromT_GL_VouchervchjoinT_BD_VoucherTypesvchTypeonvch.FVoucherTypeID=vchType.FIDjoinT_Org_Companycomonvch.FCompanyId=com.FIDjoinT_BD_Periodpdonvch.FPeriodID=pd.FIDleftjoinT_BKS_AcountSchemeacsonacs.fid=com.FAccountSchemeIDjoinT_GL_VoucherEntryentryonvch.FID=entry.FBillIDjoinT_GL_VoucherAssistRecordrecordonentry.FID=record.FEntryIDjoinT_BD_AccountViewacctonentry.FAccountID=acct.FIDandacct.FACNotice=1joinT_BD_AssistantHGassGrponrecord.FAssGrpID=assGrp.FIDleftjoinT_BD_CustomercustomeronassGrp.FCustomerID=customer.FIDleftjoinT_BD_SuppliersupplieronassGrp.FProviderID=supplier.FIDwherevch.fbizstatus<>0andvch.fsourcetype<>7andvch.FSourceType<>2andvch.FSourceType<>1andrecord.Fbillid=vch.FIDandrecord.FOriginalAmount<>0--andrecord.freqCheckStatus<>2--勾稽状态一般存在异常造成没有发出and(assGrp.FCompanyOrgIDisnotnulland(assGrp.FCompanyOrgIDin(selectFCompanyIDfromT_BD_SYSTEMSTATUSCTROLwhereFSYSTEMSTATUSID='e45c1988-00fd-1000-e000-33d8c0a8100d02A5514C'andFISSTART=1))or(customer.FInternalCompanyIDisnotnullandcustomer.FINTERNALCOMPANYIDin(selectFCompanyIDfromT_BD_SYSTEMSTATUSCTROLwhereFSYSTEMSTATUSID='e45c1988-00fd-1000-e000-33d8c0a8100d02A5514C'andFISSTART=1))or(supplier.FInternalCompanyIDisnotnullandsupplier.FINTERNALCOMPANYIDin(selectFCompanyIDfromT_BD_SYSTEMSTATUSCTROLwhereFSYSTEMSTATUSID='e45c1988-00fd-1000-e000-33d8c0a8100d02A5514C'andFISSTART=1)))and(acs.fidisnulloracs.FIsMaster=1)--andcom.FNUMBER='001'andpd.FNUMBER='202203'--组织编码和期间andnotexists(select1fromt_csl_RequisitionEntryreqewherereqe.FAssistRecordID=record.fid)orderbycom.fnumber,pd.fnumber--3.对方公司未启用总账，导致未发送通知单的数据selectdistinctcom.FNUMBER公司编码,pd.FNUMBER期间编码,vch.fnumber凭证编码,vch.FID凭证IDfromT_GL_VouchervchjoinT_BD_VoucherTypesvchTypeonvch.FVoucherTypeID=vchType.FIDjoinT_Org_Companycomonvch.FCompanyId=com.FIDjoinT_BD_Periodpdonvch.FPeriodID=pd.FIDleftjoinT_BKS_AcountSchemeacsonacs.fid=com.FAccountSchemeIDjoinT_GL_VoucherEntryentryonvch.FID=entry.FBillIDjoinT_GL_VoucherAssistRecordrecordonentry.FID=record.FEntryIDjoinT_BD_AccountViewacctonentry.FAccountID=acct.FIDandacct.FACNotice=1joinT_BD_AssistantHGassGrponrecord.FAssGrpID=assGrp.FIDleftjoinT_BD_CustomercustomeronassGrp.FCustomerID=customer.FIDleftjoinT_BD_SuppliersupplieronassGrp.FProviderID=supplier.FIDwherevch.fbizstatus<>0andvch.fsourcetype<>7andvch.FSourceType<>2andvch.FSourceType<>1andrecord.Fbillid=vch.FIDandrecord.FOriginalAmount<>0--andrecord.freqCheckStatus<>2--勾稽状态一般存在异常造成没有发出and((assGrp.FCompanyOrgIDin(selectFCompanyIDfromT_BD_SYSTEMSTATUSCTROLwhereFSYSTEMSTATUSID='e45c1988-00fd-1000-e000-33d8c0a8100d02A5514C'andFISSTART=0)orassGrp.FCompanyOrgIDnotin(selectFCompanyIDfromT_BD_SYSTEMSTATUSCTROLwhereFSYSTEMSTATUSID='e45c1988-00fd-1000-e000-33d8c0a8100d02A5514C'))or(customer.FINTERNALCOMPANYIDin(selectFCompanyIDfromT_BD_SYSTEMSTATUSCTROLwhereFSYSTEMSTATUSID='e45c1988-00fd-1000-e000-33d8c0a8100d02A5514C'andFISSTART=0)orcustomer.FINTERNALCOMPANYIDnotin(selectFCompanyIDfromT_BD_SYSTEMSTATUSCTROLwhereFSYSTEMSTATUSID='e45c1988-00fd-1000-e000-33d8c0a8100d02A5514C'))or(supplier.FINTERNALCOMPANYIDin(selectFCompanyIDfromT_BD_SYSTEMSTATUSCTROLwhereFSYSTEMSTATUSID='e45c1988-00fd-1000-e000-33d8c0a8100d02A5514C'andFISSTART=0)orsupplier.FINTERNALCOMPANYIDnotin(selectFCompanyIDfromT_BD_SYSTEMSTATUSCTROLwhereFSYSTEMSTATUSID='e45c1988-00fd-1000-e000-33d8c0a8100d02A5514C')))and(acs.fidisnulloracs.FIsMaster=1)--andcom.FNUMBER='001'andpd.FNUMBER='202203'--组织编码和期间andnotexists(select1fromt_csl_RequisitionEntryreqewherereqe.FAssistRecordID=record.fid)orderbycom.fnumber,pd.fnumber
