ئhG%veC g .TStringList<*gTStrings.Append[*cdSysUtilsZkgTrim~ gIntToStrJ 7g UpperCase~ g TimeToStr_tg StrToCurr`bcdMessagesZkcdSysInitZkcdSystemZkf AnsiString8f TDateTime_IfString8fLongint|ofBooleanNcfInteger|ofRealBYrPgDecgLengthg@LStrLen?gTObject.Create݋RgFalse1ogBreakgIncgTruncg TObject.Free݋Rg @LStrAddRefX,Tdg@LStrClrg @LStrLAsgX,Tdg @LStrCatNX,Tdg @LStrCat3X,Tdg@LStrCatX,Tdg@LStrCmpX,Tdg@TRUNCX,Tdg@HandleFinallyX,Tdg @LStrArrayClrX,TdgStrg@Str2ExtX,TdgTrue1ogPosg@LStrPosX,Tdg VarIsNullcg@LStrFromString|g @VarToLStr kg @VarToIntX,Tdg@VarClrX,TdfCurrency,eiceFormsZkgTCustomForm.Createj-gTCustomForm.Showj-gTCustomForm.Hidej-gTCustomForm.Closej-ceComCtrlsZkgTProgressBar.SetPositionceProgress f TProgressForm%g TProgressForm.ProcessWinMessagesg.TProgressForm<ce MyMessage f TMessagesFormcO<*g.TMessagesForm8ce CriticalTests ce FileFunctions ce DateFunctions gYeargMonthgFormattedDateString_tgStandardDateTimeString_tceGenFns g CleanString~ gUpdateBatchStatusz3>g curFormat:jgCurr2Str`bgcurSumPhg DeleteFromDC.ceDataMod ceMain gMainForm.|ceMathZkc*TServiceDetails@*TCallHeaderTypeh .1f" nCountf! nFactorf% frmProgressf)( RidDuplicates$!sBatchIDf !slFieldsf% MAXFIELDS & qryDCf sFieldsf sValuef nField nAllFieldsf slDuplicatesf slResultsf lContinuef nDuplicates nDuppleID nTotalCountf nBlockfc(GetQuetzalFaultsy-$! nBatchNumberb! dStartDate" !dEndDate" !BatchDescription " lReturnCodef dLogDateTimef sBillYearf sBillMonthf sFromDatef sToDatef sBatchf sBatchDescriptionf sListValuesf sListFieldsf FieldStringListf ValueStringListf qryStringList qryDCf qryQuetzal nListValuesf sFaultBillIDf sFaultUnBillIDf nTotalCountf nBlockf Factorf lGSTFlagf sLastNamef nBill sCust_IDf q sGSTRatef a MessageForm c(GetRadioFaultsy-$! nBatchNumberb! dStartDate" !dEndDate" !BatchDescription " lReturnCodef dLogDateTimef sFromDatef sToDatef sBatchf sBatchDescriptionf sListValuesf sListFieldsf FieldStringListf ValueStringListf qryStringList qryDCf qryQuetzal nListValuesf TempDescf sRadioAdminIDf sRadioQuoteIDf sRadioMinCalloutIDf sRadioCalloutIDf sRadioAdviceIDf sRadioAerialIDf sRadioStandardIDf sRadioVRTNoChargeIDf sRadioNoChargeIDf curExGSTfa curGSTfA curIncGSTf! nTotalCountf nBlockf Factorf lGSTFlagf MessageForm c( GetTaxiFaultsy-aj$! nBatchNumberb! dStartDate" !dEndDate" !BatchDescription " lReturnCodef dLogDateTimef sBillYearf sBillMonthf sFromDatef sToDatef sBatchf sBatchDescriptionf sListValuesf sListFieldsf FieldStringListf ValueStringListf qryStringList qryDCf qryQuetzal nListValuesf sTaxiBillIDf nTotalCountf nBlockf Factorf lGSTFlagf nBill sGSTRatef MessageForm c(QuetzalInvoiceյX$!nBatch! dStartDate" !dEndDate" !BatchDescription lContinuef EmptyListc( RadioInvoiceյX$!nBatch! dStartDate" !dEndDate" !BatchDescription lContinuef EmptyListc( TaxiInvoiceյX$!nBatch! dStartDate" !dEndDate" !BatchDescription lContinuef EmptyListc( FinalizationX,Td\! $c(Quetzal!$cMjX,Custno ,ServCode , ServiceID ,RentFrom ,RentTill (,CallFrom 8,CallTill HcM!, SequenceNo(, ServiceID*,TxnDate,4,TxnTime.F,Origin0R,Duration2|,CallCode4!,RateDescription6-, DialledNumber8, ServiceNotes:, AmountExGST, AmountIncGST@,ToDateBcD"@D"?KDFK$HFKJFK LFK*NFKPFKRFKBTFK$VFK.XFKZFK\FK^FK`FDb>BF>Db>Db>Db>Db>Db >Db>Db >Db>Db>Db >Db >Db >Db>D">l[TServiceDetails,USVW3ɉMЉM̉MMUEE3UhTd0d EERE}~E}~fM]|\C3MЋ֋E8W EЍUE~1Eu EUuhluEFKuEUEЋMxUС3?3E3EԲEEE3ɲEEEЋMUЋEQ4EQ4EЋMUЋEQ4EЋMUЋEQ4]|CEQ4Ku3Uhd0d EE]|\C3E@$UЋQXEЍUE~MЋ֋E8W EЋUt3E߀}tFKu}t'(ERTUUЋEQ40]|)C3E@$UЋQXMЋ֋E8W FKuڋEEEԃ}  С3E ,r3 Сh8ŰEuhXEкUСE􀸑_ER؅Kh3]E=,3EER@EQ4EQ4ERK|}C3M̋֋E8W M̍EкMЋE8W E СFKu3ZYYdh$EEEE3ZYYdh[E̺EE_^[], Duplicates in Batch: , iddbPPdataSELECT FROM tDataCollectionWHERE BatchID = ORDER BY  idBChecking (transaction: )...Removing duplicates ...DELETE FROM tDataCollection WHERE ID = UQ0jjIuMSVWMډE3Uh8d0d U܋EuuUuuUhPuuEuh\EhPu uEuh\EE؋݀L <$EE̲EȲغËQ( EĺhE |Q(E3Y@3 3EMܺU3EE?3E3EEEEċQ4EċQ4Eċ(Q4E\EEUt~(EUX\EEU~&EUEEĀ6EEċR@4p 8d,P T4l@d@ @x T $!X!!!!!"8"h"""""(#D####0$d$$@%%h%uh%uEU &H&&`'''(h%uh%uhT(EUh(((@)h%uh%uEU)*|*h%uh%uEU*0+++ӋQ<ËR@jf ,3Ҹ,E5 E̋R@EȋR@Eк8,EԺD,EкX,uhPl,UQXuh\EԺEк,,UQXEUuhPuh,uh\EԺEк,E,uEԺ, EԺ,Eк,uhP-UQXuh\EԺ-RL]Eк,-uhPuuEuh\EԺ@-RTEкP-uuuhl-EԺuuhl-EԺUЋE̋Q4UԋEȋQ4EEE,EEкx-}tEԺ- EԺ-Eк-EԋUEк-EԋUl,u>Eк-uhPl,UQXuh\EԺEк-uhPuuEuh\EԺ-uOEк.uhP-|QX|Uuh\EԺUЋE̋Q4UԋEȋQ4EE.uOEк,.uhP.|QX|Uuh\EԺ<.u>EкL.uhP<.UQXuh\EԺ,u>Eк\.uhP,UQXuh\EԺl.uOEк.uhPl.|QX|Uuh\EԺUЋE̋Q4UԋEȋQ4EE.uOEк.uhP.|QX|Uuh\EԺ.uOEк.uhP.|QX|Uuh\EԺ.ue.UQXEUEк.uhPuh\EԺUEE/u3@-u/Eк /uԍUuhl-EԺEк/uuh0/EԺUЋE̋Q4UԋEȋQ4ËR@ 0 THEN tTrain.TrainOwnerA WHEN LEN(RTRIM(tLocation.LocOwner)) > 0 THEN tLocation.LocOwner ELSE tName.Owner2 END) AS "Assign", tName.*, tTrain.TrainMaintainer+FROM ((SELECT Name2.*, Client.Ref3 AS Owner\FROM (SELECT Call.ClientCode, Call.CallNumber, Call.LastName, Call.Logon, Call.CallSubject3,i Call.SupportGroup, Call.LogDatTim, Name1.LogDate, Name1.ConfigId, Name1.CallSubject1, Name1.CallSubject2qFROM (SELECT CONVERT(Char(10),Call.LogDatTim,103) AS LogDate, Call.ConfigId, Call.CallSubject1, Call.CallSubject2 FROM CallWHERE Year(Call.LogDatTim) =  AND Month(Call.LogDatTim) = AND Call.ConfigID IS NOT NULLAND (Call.CallSubject1 NOT LIKE 'W-%' AND Call.CallSubject1 NOT LIKE 'R-%' AND Call.CallSubject1 NOT LIKE 'C-%' AND Call.CallSubject1 NOT LIKE 'LASP%')lGROUP BY CONVERT(Char(10),Call.LogDatTim,103), Call.ConfigID, Call.CallSubject1, Call.CallSubject2) AS Name1ILEFT JOIN Call ON ((Name1.LogDate = CONVERT(Char(10),Call.LogDatTim,103))$AND (Name1.ConfigID = Call.ConfigID),AND (Name1.CallSubject1 = Call.CallSubject1)-AND (Name1.CallSubject2 = Call.CallSubject2)) ) AS Name2CINNER JOIN Client ON Name2.ClientCode = Client.ClientCode) AS tName9LEFT JOIN (SELECT Logon.Ref3 AS LocOwner, Call.CallNumber?FROM (Call LEFT JOIN Logon ON Call.LogonCode = Logon.LogonCode)ELEFT JOIN Configuration ON Call.ConfigCode = Configuration.ConfigCodemAND (Configuration.ConfigClassificationUnique <> 1)) AS tLocation ON tName.CallNumber = tLocation.CallNumber)jLEFT JOIN (SELECT Configuration.Ref1 AS TrainOwner, Call.CallNumber, Configuration.Ref2 AS TrainMaintainerQFROM (Call LEFT JOIN Configuration ON Call.ConfigCode = Configuration.ConfigCode)LAND (Configuration.Ref1 NOT LIKE 'Z%' AND Configuration.Ref1 NOT LIKE 'E:%')qAND ((Configuration.ConfigClassificationUnique = 1) OR (Configuration.ConfigClassificationUnique = 4))) AS tTrainEON tName.CallNumber = tTrain.CallNumber) AS QuetzalFaults) AS qry_allORDER BY LogDateNo entries found.(VALUES ( SequenceNo, CallNumber ServiceID,Cust_ID ServiceType,VRT'QFV','QFR',TxnDate,LogDate LogDatTimTxnTime,BillTransactionTypeID,,GSTFlag,'Y','N', FromDate,ToDate,Var01,Var02, CallSubject2Var04,ConfigIdVar05,Owner1Var06,Var07, CallSubject1Var08, CallSubject3Var09,LogonVar10,LastNameVar14,HPVar15,BatchID))INSERT INTO tDataCollectionBProcessing (transaction: )...TxnDateVar08Var04Var05Importing Quetzal Faults ...Updating with applied rates ...UPDATE tDataCollection&SET AmountExGST = ChargeRate.AmtExGST, GSTAmount = ChargeRate.GSTAmt,7 AmountIncGST = ChargeRate.AmtExGST + ChargeRate.GSTAmt*FROM (SELECT GSTrate.ID, GSTrate.AmtExGST,0(GSTrate.AmtExGST * GSTrate.GSTFactor) AS GSTAmtRFROM (SELECT tDataCollection.ID, (CASE WHEN tDataCollection.GSTFlag LIKE 'Y' THEN 1 ELSE 0 END) AS GSTFactor, tRate.Cost AS AmtExGSTFROM (tDataCollectionJLEFT JOIN tServiceType ON tDataCollection.ServiceType = tServiceType.Code)8LEFT JOIN tRate ON tServiceType.ID = tRate.ServiceTypeID WHERE tDataCollection.BatchID = AND tDataCollection.Var15 = '1'5AND tRate.Cost IS NOT NULL) AS GSTrate) AS ChargeRate(WHERE tDataCollection.ID = ChargeRate.ID UPDATE tBatch#SET GSTAmount = BatchRate.TotalGST,% TotalPayable = BatchRate.TotalIncGST>FROM (SELECT Sum(tDataCollection.AmountIncGST) AS TotalIncGST,+ Sum(tDataCollection.GSTAmount) AS TotalGSTFROM tDataCollection) AS BatchRateWHERE tBatch.ID = UQjjIuQMSVWMډE3Uhd0d UEhuullhEhu ullhEEEԲEвغËQ( E̺E E3Y@3 3lMl 3DžxDž|?3E3EE E E E E E E E E E̋,Q4E̋dQ4E̋Q4E.EUċQXUĸ~+\E\UUĸ~+\E\UUĸ~+\E\U]Uĸ~+\E\U!Uĸ~+\E\UUĸ(~+\E\UUĸ8~(\E\UpUĸL~(\E\U7Uĸd~&\E\UEÈEE̋R@xËQ4ËQ4ËQ4ËQ4ËQ4XËQ4ËQ4ËQ4ËQ4ËQ4<ËQ4tËQ4ËQ4ËQ4ËQ4ËQ4,ËQ4@ËQ4\ËQ4tËQ4ËQ4ËQ4ËQ4ËQ4@ËQ4dËQ4ËQ4ËQ4ËQ4ËQ4ËQ48ËQ4ËQ4ËQ4ËQ4ËQ4ËQ44 ËQ4t ËQ4 ËQ4 ËQ4 ËQ4D!ËQ4u uXXl|!lËQ4u uXXl!lËQ4!ËQ44"ËQ4h"ËQ4"ËQ4"ËQ4lËQlQ,ËR@jf #3Ҹ #EEԋR@EЋR@Eغ(#Eܺ4#EغH#uh\#lQXlhEܺEغp#\#\u7#XQXXllucuhuh##lQXlh##XQXXhEܺauhuh##lQXlh##XQXXhEܺ#RL]Eغ#uhuullhEܺEغ#uhuullhEܺEغ$#XQXXllUUĸ~uuh$EܺlUĸ~uuh$Eܺ>Eĺ($uuuh$EܺUĸ@$~uuh$EܺUĸ~uuh$EܺEĺP$uuuh$EܺUĸh$~uuh$Eܺ_EĺLuuuh$Eܺ6Eĺduuuh$Eܺ Eܺ|$U؋EԋQ4U܋EЋQ4EE#XQXXll$wEغ$wtEܺ$ Eܺ$Eغ$E܋UEغ$E܋U\\#\uDEغ$uh\#lQXlhEܺ\$\$XQXXll~UEغ %uh$XQXXllhEܺEغ%uhuullh#uuXXEܺ,%RL]uh#uullh#uuXXhEܺU؋EԋQ4U܋EЋQ4EE\@%\uDEغP%uh@%lQXlhEܺ\`%\uUEغx%uh`%XQXXllhEܺ\#\uDEغ%uh#lQXlhEܺ\#\uUEغ%uh#XQXXllhEܺ\%\uUEغ%uh%XQXXllhEܺU؋EԋQ4U܋EЋQ4EE\%\uDEغ%uh%lQXlhEܺ\%\uUEغ&uh%XQXXllhEܺ\#\uUEغ&uh#XQXXllhEܺ\ &\uDEغ8&uh &lQXlhEܺU؋EԋQ4U܋EЋQ4EE\H&\PH&lQXl<$}EغT&uhH&XQXXllhuuXXh$Eܺwt_-h&m}uuuu}Eغ|&uuullh$Eܺ EEEEEغ&uuullh$Eܺ\&\uUEغ&uh&XQXXllhEܺEغ&uuh&EܺU؋EԋQ4U܋EЋQ4ËR@&ËQ4EԋRH|7@pElUȋEԋ8W lËQ4Epu׋EЋRH|7@pElUȋEЋ8W lËQ4Epu׋EӋEEEE} ܍xС3E܍x'r3܍xСh'XEXh8'll=E8+ H'l'ËR@'ËQ4'ËQ4'ËQ4(ËQ4P(ËQ4(ËQ4h(uh(llËQ4lM(lËQ4EӋEE EEEEE3ZYYdhX\lE Eغ_^[]'',dbPPdata dbQuetzalRadio Faults Batch: Reading ...0-SELECT ID, UPPER(Description) AS UDescriptionFROM tTransactionType!WHERE Description LIKE '%Radio %' UDescriptionADMINidQUOTEMINIMUMCALL OUTADVICEAERIAL CORE HOUR VRT NO CHARGE NO CHARGESELECTBISNULL(NULLIF(configuration.Ref1,''), call.orglvlcode) AS "Owner",CASE! WHEN LEN(configuration.ref2) > 3> THEN ISNULL(NULLIF(configuration.ref1, ''), call.orglvlcode)- ELSE ISNULL(NULLIF(configuration.ref2,''), ? ISNULL(NULLIF(configuration.ref1, ''), call.orglvlcode))END AS "Maintainer",9 WHEN configuration.configclassificationunique = 6 THEN 0/ WHEN call.callsubject2 LIKE 'Base Sta%' THEN 0 ELSE 1;END AS "Bill", call.CallNumber, Call.CustomerRef AS "Ref2",logdattim AS "LogDate",8 WHEN FixStatus = 1 THEN call.slt1WarningRespondDateTime ELSE NULLEND AS "FixedDate",call.lastname,!call.configid AS "Configuration",call.logon AS "Location",!call.callsubject1 AS "Equipment",call.callsubject2 AS "System",call.callsubject3 AS "Fault",call.slt1 AS "Priority",%call.supportgroup as "ServiceCentre",< WHEN (call.slt1 LIKE 'NO CHARGE' OR call.slt1 LIKE 'QUOTE') AND isnumeric(call.ref3) = 0 THEN 0 WHEN call.ref3 IS NULL= AND (call.slt1 LIKE 'NO CHARGE' OR call.slt1 LIKE 'QUOTE'): WHEN call.slt1 LIKE 'NO CHARGE' OR call.slt1 LIKE 'QUOTE' THEN CAST(call.ref3 AS REAL)> WHEN CAST(CAST(slt.mincharge AS VARCHAR(32)) AS REAL) IS NULL6 ELSE CAST(CAST(slt.mincharge AS VARCHAR(32)) AS REAL) END AS "Fee" FROM callILEFT OUTER JOIN location ON location.locationunique = call.locationuniqueELEFT OUTER JOIN configuration ON Configuration.ConfigId=Call.ConfigId/INNER JOIN slt on slt.sltunique=call.sltunique1.WHERE Year(call.slt1WarningRespondDateTime) = -AND Month(call.slt1WarningRespondDateTime) = ?AND (call.fixstatus = 1) AND (Call.CallSubject1 NOT LIKE 'C-%')*AND (call.supportgroup LIKE 'RADIO DYNON%'2 OR call.supportgroup LIKE 'RADIO SER. CENT%' 5 OR call.supportgroup LIKE 'RADIO WORKSHOP CTRY')ORDER BY call.CallNumberNo entries found.(VALUES ( SequenceNo, CallNumber ServiceID, Maintainer OwnerPriorityLogDateTxnDate,TxnTime,TransactionTypeID,,MINIMUM CALLOUTCALLOUT AERIAL CHANGESTANDARD0,VRTGSTFlag,'Y','N', FromDate,ToDate,Var01,Ref2Var02,Var03, FixedDateSystemVar04, ConfigurationVar05,Var06,Var07, EquipmentVar08,FaultVar09,LocationVar10,Var11, ServiceCentreVar12,FeeVar13,AmountExGST,? GSTAmount, AmountIncGST,LastNameVar14,BatchID))INSERT INTO tDataCollectionBProcessing (transaction: )...Importing Radio Faults ...Updating with applied rates ... UPDATE tBatch#SET GSTAmount = BatchRate.TotalGST,% TotalPayable = BatchRate.TotalIncGST>FROM (SELECT Sum(tDataCollection.AmountIncGST) AS TotalIncGST,+ Sum(tDataCollection.GSTAmount) AS TotalGSTFROM tDataCollection WHERE tDataCollection.BatchID = ) AS BatchRateWHERE tBatch.ID = UQ.jjIuQMSVWMډE3Uh|d0d U܋EuuUuuUhuuEuhEhu uEuhEE؋݀L <$EE̲EȲƋQ( EĺE غE3Y@3 3EMܺU3EE?3E3EE EċQ4EċPQ4EċpQ4EbEEU~(EUEEĀtEEċR@ƋQ4LƋQ4ƋQ4EMUƋQ4EMUƋQ4ƋQ4TƋQ4֋ƋR@4 jf l3ҸxE/ E̋R@EȋR@EкEԺEкuhUQXuhEԺEкuhuhUQXuhEԺ RTEкEԺ4DRL]EкXuhuuEuhEԺEкluhuuEuhEԺEкuuhEԺUЋE̋Q4UԋEȋQ4EEQXUEEEк}tEԺ EԺEкEԋUEкEԋUu>Eк uhUQXuhEԺEкuhuuEuhuuhEԺ,uOEкDuh,QXUuhEԺUЋE̋Q4UԋEȋQ4EETuOEкhuhTQXUuhEԺxu>EкuhxUQXuhEԺu>EкuhUQXuhEԺuOEкuhQXUuhEԺuOEкuhQXUuhEԺuOEкuhQXUuhEԺUЋE̋Q4UԋEȋQ4EEuOEк,uhQXUuhEԺ<uOEкPuh<QXUuhEԺ u/Eк`uԍUuhEԺEкpuuhEԺUЋE̋Q4UԋEȋQ4ƋR@ƋQ4E̋RH|+@EEMUE̋8W UƋQ4EMuEȋRH|+@EEMUEȋ8W UƋQ4EMuE֋EEEE} MС3EMr3MСhEhEUE8 ƋR@<ƋQ4\ƋQ4ƋQ4ƋQ4ƋQ4(ƋQ4hduhEUƋQ4ƋQ4ƋQ4pƋQ4EMܺUƋQ4ƋQ4(ƋQ4E֋EEƋR@\ƋQ4tƋQ4ƋQ4ƋQ4ƋQ4LƋQ4huhlEUƋQ4EMܺUƋQ4E֋EE EEEEE3ZYYdhEEEEк_^[]'',dbPPdata dbQuetzalTaxi Directorate Batch: Reading ...0-SELECT ID, UPPER(Description) AS UDescriptionFROM tTransactionType*WHERE Description LIKE 'Taxi Directorate%' UDescription COMPLAINTiddSELECT 'DOH' AS Owner1, 'DOH' AS Cust_ID, 1 AS Bill, Call.CallNumber, Call.LogDatTim, Call.LastName,c Call.ConfigId, Call.Logon, Call.ITHelpUser,Call.CallSubject1, Call.CallSubject2, Call.CallSubject3 FROM CallWHERE Year(Call.LogDatTim) = AND Month(Call.LogDatTim) = .AND Call.CallSubject1 LIKE 'TAXI DIRECTORATE%'ORDER BY Call.LogDatTimNo entries found.(VALUES ( SequenceNo, CallNumber ServiceID, Cust_IDBill ServiceType,'TDC', LogDatTimTxnDate,TxnTime,TransactionTypeID,,VRTGSTFlag,'Y','N', FromDate,ToDate,Var01,Var02, CallSubject2Var04,ConfigIdVar05,Owner1Var06,Var07, CallSubject1Var08, CallSubject3Var09,LogonVar10, ITHelpUserVar12,LastNameVar14,Var15,BatchID))INSERT INTO tDataCollectionBProcessing (transaction: )...Importing Taxi Directorate ...Updating with applied rates ...UPDATE tDataCollection&SET AmountExGST = ChargeRate.AmtExGST, GSTAmount = ChargeRate.GSTAmt,7 AmountIncGST = ChargeRate.AmtExGST + ChargeRate.GSTAmt*FROM (SELECT GSTrate.ID, GSTrate.AmtExGST,0(GSTrate.AmtExGST * GSTrate.GSTFactor) AS GSTAmtRFROM (SELECT tDataCollection.ID, (CASE WHEN tDataCollection.GSTFlag LIKE 'Y' THEN 1 ELSE 0 END) AS GSTFactor, tRate.Cost AS AmtExGSTFROM (tDataCollectionILEFT JOIN tServiceID ON tDataCollection.ServiceID = tServiceID.ServiceID)ALEFT JOIN tRate ON tServiceID.ServiceTypeID = tRate.ServiceTypeID WHERE tDataCollection.BatchID = 5AND tRate.Cost IS NOT NULL) AS GSTrate) AS ChargeRate(WHERE tDataCollection.ID = ChargeRate.ID UPDATE tBatch#SET GSTAmount = BatchRate.TotalGST,% TotalPayable = BatchRate.TotalIncGST>FROM (SELECT Sum(tDataCollection.AmountIncGST) AS TotalIncGST,+ Sum(tDataCollection.GSTAmount) AS TotalGSTFROM tDataCollection) AS BatchRateWHERE tBatch.ID = UQSVWEMӋuuu uM׋_^[Y]UQSVWEMӋuuu uM׋_^[Y]UQSVWEMӋuuu uM׋_^[Y]U3Uh%d0d 3ZYYdh,]Ã-m:TTTBpr@bbt vb& x .  0 *: d: d z   x>  x8 x<&@&@b8|@BHB ,  ~     ~ Bv.  P .  0 8&^ x<    ~  "nnn r  D "BBB   v   vt H: d: d: d(      <     2    x .   .  0@  t  t & &      B    B0& <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <  <    v<  <  <  <  <  <  <  <    v<  <  <  <  <    v<  <  <  <    v<  <  <  <  <(:   "" 0  t  t  z     v  z  &D   v  z  |  z  z  z     v  "  z F v    z  v v<rr  |  z  z  z  zz  zz   z     v  z  v   z   2 v<rr   z   2 v   z     v   z     v   z   2 v<rr   z   2 v   z   2 v  &  z  vD  |   zB v  z vD  ,~  ~  B v.  L    &     .  .          v   $  x            v*  x$  nnn    nnnn rr F"B "v "vt: d: d: d(         2   x .  .  0L t t t t t t t t t&&  B B B B B B B B B0&$B" x0B" x$X: "" 0 t t z ,v z8@b , ,v , ,v " z"v z"Fv z 8@D v v |v v v |v v |v |v z<rr 8D | z" z z zz zz z ,v8@b z 8v z""F&v """Fv<rr z ,v z 8v z ,v z 8v z 8v<rr z ,v z 8v z 8v z ,v<rr,H z 8"v4 z(v, z(v z 8v zvD] ,~ ~ B v.  <   . .   v6 x*  nnn    nnnnrr A!F!"BBB !!v !!vt H: d: d: d( !  !      2  ! x . ! .  0@! t!&!&!!! !B(&!!!$! x*! x!! :!! "" 0! t! t! z! ! !v! z!! ! !v !! z! z !"! z!!v! z!F!v! z!v<rr !2D! |! z! z! z! zz! zz!! z! ! !v! z!!"F!v!! z! !2!v<rr!! z! !2!v!! z! ! !v!! z! ! !v!! z! !2!v!! z! !2!v!! z! !2!v<rr!! z! !2!v!! z! !2!v!! zB!v! z!vD! ,~! ~ !B!v.  <   !.! .  !!!!!!!!v!!!$! x!! !!!!!!!!v*! x$  nnn    nnnn!rrrr m,: d$n0 : d$n0: d$n0!  1yjf 020 :$ (  "B&BB0@^   NF F <Fp$6 t*$ &&&$f F$ NuX,,PPn.,  $2$:*$   &&&dPdL   NXNN * $b>Jb*V& 40" BbVBBBbBbBBBB>:8BD000 00  @ (@|$A, $H 4H4*fZ\\., $2$F*$ (  &&&*"V"V"V"V"V"V"P"P"L. Fxx< * $n*bbl":"::":"::"444~0Bn*BnBBnBBBnBBBnJd*\XB06<6< F .F$Q, $T@*FAZ,,PPn., $2$:*$   &&&dL44 * $br&*VV0l*BbBBBbBbBBBBBBD000 00  @ (@|$!, $H4H4*U,000l *A ppr  5  pXQY}!( }%>F qNQOYP pZy)A[  ``mb! p1Z1em9 ,!4 ;eU p 2` p 2` p 2`  a