金蝶云星空-过滤符号-sqlserver.txt

IFEXISTS(SELECT1FROM(SELECTNAMEASTABLE_NAME,XTYPEASTABLE_XTYPEFROMsysobjectsWHEREXTYPE='U'ORXTYPE='V')ASKSQL_USERTABLESWHERETABLE_NAME='T_MDL_FILTERCONDITION_L')BEGINDELETEFROMT_MDL_FILTERCONDITION_LWHERE(flocaleid=1033AND(fpkid<100000))END;IFEXISTS(SELECT1FROM(SELECTNAMEASTABLE_NAME,XTYPEASTABLE_XTYPEFROMsysobjectsWHEREXTYPE='U'ORXTYPE='V')ASKSQL_USERTABLESWHERETABLE_NAME='T_MDL_FILTERCONDITION_L')BEGINSELECTFPKID,ROW_NUMBER()OVER(ORDERBYFPKIDASC)idINTOtmp_T_MDL_FILTERCONDITION_LFROMT_MDL_FILTERCONDITION_LWHERE(FPKID<100000)UPDATEUTSETFPKID=(SELECTIDFROMtmp_T_MDL_FILTERCONDITION_LWHEREFPKID=UT.FPKID)FROMT_MDL_FILTERCONDITION_LUTWHERE(UT.FPKID<100000)DROPTABLEtmp_T_MDL_FILTERCONDITION_LEND;IFEXISTS(SELECT1FROM(SELECTNAMEASTABLE_NAME,XTYPEASTABLE_XTYPEFROMsysobjectsWHEREXTYPE='U'ORXTYPE='V')ASKSQL_USERTABLESWHERETABLE_NAME='T_MDL_FILTERCONDITION_L')BEGINDELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=1ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),1,1033,N'Me',N'',N'CorrespondingEmployee')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=2ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),2,1033,N'Lessthanorequalto(Field)',N'',N'DynamicDataAccess')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=3ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),3,1033,N'Beforetoday(Day)',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=4ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),4,1033,N'Notequalto',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=5ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),5,1033,N'Notequalto',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=6ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),6,1033,N'Equalto',N'selectFName,FCurrencyIDfromt_CurrencyWHEREFCurrencyID<>0',N'SelectCurrency')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=7ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),7,1033,N'Notequalto(Field)',N'',N'DynamicDataAccess')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=8ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),8,1033,N'NextMonth',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=9ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),9,1033,N'Notnull',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=10ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),10,1033,N'CurrentWeek',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=11ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),11,1033,N'Yesterday',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=12ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),12,1033,N'Leftinclude',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=13ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),13,1033,N'Today',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=14ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),14,1033,N'Equalto',N'selectFName_CHS,FIDfromICClassLinkInnerJoinICClassTypeonICClassLink.FSourClassTypeID=ICClassType.FIDWHEREFDestClassTypeID=@FCLASSTYPEID',N'DynamicDataAccess')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=15ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),15,1033,N'Lessthanorequalto',N'',N'Indicateaspecificdate,like12/31/1999')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=16ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),16,1033,N'Lessthanorequalto',N'',N'Indicateaspecificdate,like12/31/1999')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=17ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),17,1033,N'Include',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=18ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),18,1033,N'Lessthanorequalto',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=19ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),19,1033,N'Lessthanorequalto',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=20ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),20,1033,N'Greaterthan',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=21ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),21,1033,N'Greaterthan',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=22ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),22,1033,N'Aftertoday(Day)',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=23ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),23,1033,N'Lessthan(Field)',N'',N'DynamicDataAccess')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=24ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),24,1033,N'Equalto(Field)',N'',N'DynamicDataAccess')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=25ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),25,1033,N'Tomorrow',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=27ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),27,1033,N'Notequalto',N'selectFName_CHS,FIDfromICClassLinkInnerJoinICClassTypeonICClassLink.FSourClassTypeID=ICClassType.FIDWHEREFDestClassTypeID=@FCLASSTYPEID',N'DynamicDataAccess')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=28ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),28,1033,N'Equalto',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=29ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),29,1033,N'Equalto',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=30ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),30,1033,N'Null',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=31ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),31,1033,N'Greaterthanorequalto(Field)',N'',N'DynamicDataAccess')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=32ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),32,1033,N'Lessthan',N'',N'Indicateaspecificdate,like12/31/1999')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=33ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),33,1033,N'Lessthan',N'',N'Indicateaspecificdate,like12/31/1999')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=34ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),34,1033,N'Exclude',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=35ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),35,1033,N'Lessthan',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=36ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),36,1033,N'Lessthan',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=37ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),37,1033,N'Null',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=38ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),38,1033,N'Greaterthanorequalto',N'',N'Indicateaspecificdate,like12/31/1999')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=39ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),39,1033,N'Greaterthanorequalto',N'',N'Indicateaspecificdate,like12/31/1999')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=40ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),40,1033,N'SingleDate',N'',N'Indicateaspecificdate,like12/31/1999')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=41ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),41,1033,N'Greaterthanorequalto',N'',N'Allowinputting:001')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=42ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),42,1033,N'Greaterthanorequalto',N'',N'Allowinputting:001')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=43ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),43,1033,N'Lessthan',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=44ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),44,1033,N'Lessthan',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=45ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),45,1033,N'Null',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=46ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),46,1033,N'Notnull',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=47ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),47,1033,N'Notnull',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=48ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),48,1033,N'MyDept',N'',N'MyDept')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=49ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),49,1033,N'Y(Accurate)',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=50ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),50,1033,N'Notnull',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=51ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),51,1033,N'Notnull',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=52ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),52,1033,N'Notnull',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=53ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),53,1033,N'Notnull',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=54ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),54,1033,N'Notnull',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=55ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),55,1033,N'Notnull',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=56ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),56,1033,N'Lessthanorequalto',N'',N'Allowinputting:001')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=57ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),57,1033,N'Lessthanorequalto',N'',N'Allowinputting:001')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=58ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),58,1033,N'SpecifiedDept',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=59ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),59,1033,N'Include',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=60ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),60,1033,N'Leftinclude',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=61ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),61,1033,N'LastWeek',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=62ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),62,1033,N'Exclude',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=63ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),63,1033,N'CurrentMonth',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=64ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),64,1033,N'Greaterthanorequalto',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=65ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),65,1033,N'Greaterthanorequalto',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=66ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),66,1033,N'Equalto',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=67ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),67,1033,N'Equalto',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=68ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),68,1033,N'Equalto',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=69ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),69,1033,N'Notequalto',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=70ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),70,1033,N'Notequalto',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=71ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),71,1033,N'Greaterthan',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=72ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),72,1033,N'Greaterthan',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=73ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),73,1033,N'NextWeek',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=74ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),74,1033,N'Equalto',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=75ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),75,1033,N'Equalto',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=76ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),76,1033,N'Equalto',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=77ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),77,1033,N'Equalto',N'',N'Allowinputtingasinglenumber,like1or123')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=78ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),78,1033,N'Y(Accurate)',N'Start,1,Succeeded,2,Failed,3,End,4,Info,5',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=79ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),79,1033,N'Greaterthan(Field)',N'',N'DynamicDataAccess')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=80ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),80,1033,N'Like',N'',N'Allowusing"%"(morethanonecharacters)and"_"(onecharacter)forfuzzysearch')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=81ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),81,1033,N'Like',N'',N'Allowusing"%"(morethanonecharacters)and"_"(onecharacter)forfuzzysearch')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=82ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),82,1033,N'Notequalto',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=83ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),83,1033,N'Notequalto',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=84ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),84,1033,N'Notequalto',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=85ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),85,1033,N'Equalto',N'SELECTFName,FGroupIDFROMt_VouchergroupORDERBYFGroupID',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=86ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),86,1033,N'Y(Accurate)',N'Male,1,Female,2',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=87ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),87,1033,N'Greaterthan',N'',N'Indicateaspecificdate,like12/31/1999')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=88ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),88,1033,N'Greaterthan',N'',N'Indicateaspecificdate,like12/31/1999')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=89ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),89,1033,N'Notequalto',N'',N'Indicateaspecificdate,like12/31/1999')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=90ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),90,1033,N'Notequalto',N'',N'Indicateaspecificdate,like12/31/1999')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=91ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),91,1033,N'Notequalto',N'selectFName,FCurrencyIDfromt_CurrencyWHEREFCurrencyID<>0',N'SelectCurrency')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=92ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),92,1033,N'LastMonth',N'',N'')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=93ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,flocaleid,FNAME,FDATASOURCE,FTOOLTIP)VALUES((SELECTISNULL(max(fpkid),0)+1FROMT_MDL_FILTERCONDITION_LWHERE(fpkid<100000)),93,1033,N'Equalto',N'',N'Indicateaspecificdate,like12/31/1999')DELETEFROMT_MDL_FILTERCONDITION_LWHERE(FID=94ANDflocaleid=1033)INSERTINTOT_MDL_FILTERCONDITION_L(FPKID,FID,...