ئhGִ.Q 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)( RidDuplicatesA$!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-a$! 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">lTServiceDetails,USVW3ɉMЉM̉MMUEE3Uhld0d EERE}~E}~fM]|\C3MЋ֋E8W EЍUE~1Eu EUuhuEFKuEmEЋMUС3?3E3EԲEEE3ɲEEEЋMUЋEQ4EQ4EЋMUЋEQ4EЋM UЋEQ4]|C4EQ4Ku3Uh5d0d EE]|\C3E@$UЋQXEЍUE~MЋ֋E8W EЋUt3E߀}tFKu}t'@ERTUUЋEQ40]|)C3E@$UЋQXMЋ֋E8W FKuڋEEEԃ}  С3E Dr3 СhPŰEuhpEкUСE􀸑_ER؅2K3~]E=D3Y@3EER@EQ4EQ4ERK|}C3M̋֋E8W M̍EкMЋE8W E СFKu3ZYYdh<EEEE3ZYYdhsE̺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ډE3Uh#d0d UEh<uullhHEh<u ullhHEEEԲEвغËQ( E̺TE hE3Y@3 3lM|l3DžxDž|?3E3EEEEEEEEEEE̋Q4E̋Q4E̋Q4E.@EUċQXUĸX~+\hE\UUĸt~+\hE\UUĸ~+\hE\U]Uĸ~+\hE\U!Uĸ~+\hE\UUĸ~+\hE\UUĸ~(\hE\UpUĸ~(\hE\U7Uĸ~&\hE\UEÈEE̋R@ËQ4ËQ4dËQ4tËQ4ËQ4ËQ4 ËQ4hËQ4dËQ4ËQ4ËQ4ËQ4ËQ4PËQ4dËQ4tËQ4ËQ4ËQ4ËQ4ËQ4,ËQ4LËQ4tËQ4ËQ4ËQ4dËQ4ËQ4ËQ4$ËQ4lËQ4ËQ4ËQ4ËQ4ËQ4ËQ4@ËQ4hËQ4ËQ4ËQ4ËQ4 ËQ4 ËQ4T ËQ4 ËQ4u uXXl lËQ4u uXXl0!lËQ4h!ËQ4!ËQ4!ËQ4lËQlQ,ËR@qjf "3Ҹ"EEԋR@EЋR@Eغ,"Eܺ8"EغL"uh<`"lQXlhHEܺEغt"\"\u7"XQXXllucuh<uh""lQXlh""XQXXhHEܺauh<uh""lQXlh""XQXXhHEܺ"RL]Eغ"uh<uullhHEܺEغ"uh<uullhHEܺEغ#"XQXXllUUĸX~uuh #EܺlUĸt~uuh #Eܺ>Eĺ,#uuuh #EܺUĸD#~uuh #EܺUĸ~uuh #EܺEĺT#uuuh #EܺUĸl#~uuh #Eܺ_Eĺuuuh #Eܺ6Eĺuuuh #Eܺ Eܺ#U؋EԋQ4U܋EЋQ4EE"XQXXll#wEغ#wtEܺ# Eܺ#Eغ#E܋UEغ#E܋U\`"\uDEغ#uh<`"lQXlhHEܺ\$\$XQXXll~UEغ$uh<$XQXXllhHEܺEغ $uh<uullh"uuXXEܺ0$RL]uh"uullh"uuXXhHEܺU؋EԋQ4U܋EЋQ4EE\D$\uDEغT$uh<D$lQXlhHEܺ\d$\uUEغ|$uh<d$XQXXllhHEܺ\"\uDEغ$uh<"lQXlhHEܺ\"\uUEغ$uh<"XQXXllhHEܺ\$\uUEغ$uh<$XQXXllhHEܺU؋EԋQ4U܋EЋQ4EE\$\uDEغ$uh<$lQXlhHEܺ\$\uUEغ%uh<$XQXXllhHEܺ\"\uUEغ%uh<"XQXXllhHEܺU؋EԋQ4U܋EЋQ4EE\$%\P$%lQXl<$}Eغ0%uh<$%XQXXllhHuuXXh #Eܺwt_-D%m}uuuu}EغX%uuullh #Eܺ EEEEEغl%uuullh #Eܺ\%\uUEغ%uh<%XQXXllhHEܺ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%XEXh&llE8+ $&H&ËR@p&ËQ4&ËQ4&ËQ4&ËQ4,'ËQ4`'ËQ4h'uh'llËQ4lM'lËQ4EӋEE EEEEE3ZYYdh*X\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 CHARGESELECT@ISNULL(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 17END AS Bill, Call.CallNumber, Call.CustomerRef AS Ref2,Call.LogDatTim AS LogDate,= WHEN Call.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.JobTracking AS Priority, WHEN Call.Slt1 LIKE 'QUOTE' THEN 0< WHEN (Call.Slt1 LIKE 'NO CHARGE' OR Call.Slt1 LIKE 'QUOTE') AND isnumeric(Call.Ref3) = 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 Call0INNER JOIN Slt on Call.JobTracking = Slt.SltNameILEFT OUTER JOIN Location ON Location.LocationUnique = Call.LocationUniqueGLEFT OUTER JOIN Configuration ON Configuration.ConfigId = Call.ConfigId.WHERE Year(Call.Slt1WarningRespondDateTime) = -AND Month(Call.Slt1WarningRespondDateTime) = DAND (Call.Fixstatus = 1) AND (Call.CallSubject1 LIKE 'RADIO DYNON%')$AND (Call.CallSubject2 LIKE 'LOCO%')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,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<rr,H z 8"v4 z(v, z(v z 8v zvD] ,~ ~ B v.  <   . .   v6 x*  nnn    nnnnrr >!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!  )yjf 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*^Z\\., $2$F*$ (  &&&*"V"V"V"V"V"V"P"P"L, xx< * $n*bbl":"::":"::"444~0Bn*BnBBnBBBnBBJd*\XB06<6< F .F$ , $T@*F>Z,,PPn., $2$:*$   &&&dL44 * $br&*VV0l*BbBBBbBbBBBBBBD000 00  @ (@|$!, $H4H4*U,000ly *5 tppr  55Q  pXQY}!( }%>F qNQOYP pZy)AZ E^^`! p1Z1em9 ,!4 ;eU p 2` p 2` p 2`  a