getinvdetail6: ++++++++++ reportgroupid=2 sp=spRptNotSet++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=3 sp=spRptLabour++++++++++ sql=[sp_helptext "spRptLabour" ] CREATE PROCEDURE spRptLabour| | @InvNo varchar(50) = NULL AS| | SET NOCOUNT ON| | SELECT tInvoice.CustomerID,| ltrim(rtrim(substring(tInvoiceReportTransaction.Var03,7,2))) + '/' +| ltrim(rtrim(substring(tInvoiceReportTransaction.Var03,5,2))) + '/' +| ltrim(rtrim(substring(tInvoiceReportTransaction.Var03,1,4))) AS LogDatTime,| tInvoiceReportTransaction.Var01 AS CallNumber,| tInvoiceReportTransaction.Var04 AS Reference,| ltrim(isnull(tInvoiceReportTransaction.Var10, ' ') + ' ' + isnull(tInvoiceReportTransaction.Var05,' ') + ' ' + isnull(tInvoiceReportTransaction.Var13,' ')) AS Descr,| tInvoiceReportTransaction.Var14 AS LastName,| tInvoiceReportTransaction.amountexGST,| tInvoiceReportTransaction.BatchID,| tInvoiceDetail.Description as InvDetailDesc,| tBatchType.SupplierDisplayedName,| tInvoiceDetail.Period| | FROM tInvoice (NOLOCK)| INNER JOIN tInvoiceDetail (NOLOCK) ON tInvoice.ID = tInvoiceDetail.InvoiceID| INNER JOIN tInvoiceReportTransaction (NOLOCK) ON tInvoiceReportTransaction.InvoiceDetailID = tInvoiceDetail.ID| INNER JOIN tBatchType (NOLOCK) ON tBatchType.ID = tInvoiceDetail.BatchTypeID| | | WHERE tInvoice.PlatinumInvoiceNo = @InvNo| AND tBatchType.ReportGroupID = 3| | ORDER BY tInvoiceDetail.Description,tInvoiceReportTransaction.BatchID, tInvoiceReportTransaction.Var01| | | | | ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=4 sp=spRptNotSet++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=5 sp=spRptPurchasing++++++++++ sql=[sp_helptext "spRptPurchasing" ] CREATE PROCEDURE spRptPurchasing| | @InvNo varchar(50) = NULL AS| | SET NOCOUNT ON| | SELECT tInvoice.CustomerID,| tInvoiceReportTransaction.Var01 AS CallNumber,| tInvoiceReportTransaction.Var02 AS Contractor,| tInvoiceReportTransaction.Var10 AS Location,| tInvoiceReportTransaction.Var04 AS Reference,| tInvoiceReportTransaction.Var05 AS Descr,| | tInvoiceReportTransaction.amountexGST,| tInvoiceReportTransaction.BatchID,| tInvoiceDetail.Description as InvDetailDesc,| tInvoiceDetail.Period,| tBatchType.SupplierDisplayedName| | FROM tInvoice (NOLOCK)| INNER JOIN tInvoiceDetail (NOLOCK) ON tInvoice.ID = tInvoiceDetail.InvoiceID| INNER JOIN tInvoiceReportTransaction (NOLOCK) ON tInvoiceReportTransaction.InvoiceDetailID = tInvoiceDetail.ID| INNER JOIN tBatchType (NOLOCK) ON tBatchType.ID = tInvoiceDetail.BatchTypeID| | | WHERE tInvoice.PlatinumInvoiceNo = @InvNo| AND tBatchType.ReportGroupID = 5| | ORDER BY tInvoiceDetail.Description,tInvoiceReportTransaction.BatchID| | | | | | ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=6 sp=spRptNotSet++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=7 sp=spRptSecurityData++++++++++ sql=[sp_helptext "spRptSecurityData" ] CREATE PROCEDURE spRptSecurityData| @InvNo varchar(50) = NULL| AS| | SET NOCOUNT ON| | SELECT tCustomer.ShipTo,| tInvoiceReportTransaction.Var02 AS Ref,| TypeCode = Case tElement.ElementCode WHEN 1034 THEN 'POL' Else 'D/U' END,| tElement.Description,| tInvoiceReportTransaction.AmountExGST as TariffAmount,| tInvoiceReportTransaction.Var03 AS Location,| tCustomer.FullName,| tInvoiceDetail.Period AS Period,| POLcount = Case tElement.ElementCode WHEN 1034 THEN 1 Else 0 END,| DUcount = Case tElement.ElementCode WHEN 1033 THEN 1 Else 0 END,| tInvoiceReportTransaction.BatchID,| tInvoiceDetail.Description as InvDetailDesc,| tInvoiceDetail.Period,| tBatchType.SupplierDisplayedName| | FROM tInvoice (NOLOCK)| INNER JOIN tInvoiceDetail (NOLOCK) ON tInvoiceDetail.InvoiceID = tInvoice.ID| INNER JOIN tInvoiceReportTransaction (NOLOCK) ON tInvoiceDetail.ID = tInvoiceReportTransaction.InvoiceDetailID| INNER JOIN tElement (NOLOCK) ON tElement.ID = tInvoiceDetail.ElementID| /*LEFT OUTER JOIN tblSEMapping (NOLOCK) ON tblInvoiceDetail.ServiceElementID = tblSEMapping.ServiceElementID*/| INNER JOIN tBatchType (NOLOCK) ON tInvoiceDetail.BatchTypeID = tBatchType.ID| LEFT OUTER JOIN tCustomer (NOLOCK) ON tInvoice.CustomerID = tCustomer.ID| | | WHERE tInvoice.PlatinumInvoiceNo = @InvNo| AND tInvoiceReportTransaction.AmountExGST <> 0| AND tBatchType.ReportGroupID = 7| | ORDER BY tInvoiceDetail.Description,tInvoiceReportTransaction.BatchID, tElement.ElementCode, cast(tInvoiceReportTransaction.Var02 as int)| | | | | ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=8 sp=spRptNotSet++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=9 sp=spRptNotSet++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=10 sp=spRptTASRentCallsOther++++++++++ sql=[sp_helptext "spRptTASRentCallsOther" ] CREATE PROCEDURE spRptTASRentCallsOther| | @InvNo varchar(50) = NULL| | AS| | SET NOCOUNT ON| | SELECT| tInvoiceReportTransaction.BatchID,| tInvoiceDetail.Description As InvDetailDesc,| tServiceID.ServiceID,| tLocation.Description as Location,| tPerson.Person as UserData,| IsNull(cc.Description,'') + ' ' + IsNull(ca.Description,'') + ' ' + IsNull(ce.ElementCode,'') + ' ' + Isnull(tSubledger.Description,'') + ' ' + Isnull(tInvoiceReportTransaction.PayType,'') as CostCentreRef,| Rent = SUM(CASE| WHEN tTransactionGroup.Description = 'RENT' THEN tInvoiceReportTransaction.AmountExGST| ELSE 0| END),| Calls = SUM(CASE| WHEN tTransactionGroup.Description = 'CALL' THEN tInvoiceReportTransaction.AmountExGST| ELSE 0| END),| Other = SUM(CASE| WHEN tTransactionGroup.Description = 'OTHER' THEN tInvoiceReportTransaction.AmountExGST| ELSE 0| END),| Admin = SUM(CASE| WHEN tTransactionGroup.Description = 'ADMIN' THEN tInvoiceReportTransaction.AmountExGST| ELSE 0| END),| Total = SUM( tInvoiceReportTransaction.AmountExGST),| tBatch.CallsStartDate,| tBatch.CallsEndDate,| tBatch.RentStartDate,| tBatch.RentEndDate,| tBatchType.SupplierDisplayedName| | | FROM tInvoiceReportTransaction (NOLOCK)| INNER JOIN tBatch (NOLOCK) ON tInvoiceReportTransaction.BatchID = tBatch.ID| INNER JOIN tInvoiceDetail (NOLOCK) ON tInvoiceReportTransaction.InvoiceDetailID = tInvoiceDetail.ID| INNER JOIN tInvoice (NOLOCK) ON tInvoiceDetail.InvoiceID = tInvoice.ID| INNER JOIN tElement (NOLOCK) ON tInvoiceReportTransaction.ElementID = tElement.ID| INNER JOIN tBatchType (NOLOCK) ON tInvoiceDetail.BatchTypeID = tBatchType.ID| LEFT OUTER JOIN tServiceID (NOLOCK) ON tInvoiceReportTransaction.ServiceID = tServiceID.ID| LEFT OUTER JOIN tLocation (NOLOCK) ON tInvoiceReportTransaction.LocationID = tLocation.ID| LEFT OUTER JOIN tPerson (NOLOCK) ON tInvoiceReportTransaction.PersonID = tPerson.ID| LEFT OUTER JOIN tCentre cc (NOLOCK) ON tInvoiceReportTransaction.CustomerCentreID = cc.ID| LEFT OUTER JOIN tActivity ca (NOLOCK) ON tInvoiceReportTransaction.CustomerActivityID = ca.ID| LEFT OUTER JOIN tElement ce (NOLOCK) ON tInvoiceReportTransaction.CustomerElementID = ce.ID| LEFT OUTER JOIN tSubLedger (NOLOCK) ON tInvoiceReportTransaction.CustomerSubledgerID = tSubledger.ID| LEFT OUTER JOIN tTransactionType (NOLOCK) ON tInvoiceReportTransaction.TransactionTypeID = tTransactionType.ID| LEFT OUTER JOIN tTransactionGroup (NOLOCK) ON tTransactionType.TransactionGroupID = tTransactionGroup.ID| | /*LEFT OUTER JOIN tCustomer (NOLOCK) ON tInvoice.CustomerID = tCustomer.ID*/| | WHERE tInvoice.PlatinumInvoiceNo = @InvNo| AND (tBatchType.ReportGroupID = 10 OR tBatchType.ReportGroupID = 11)| GROUP BY tInvoiceReportTransaction.BatchID, tServiceID.ServiceID, tInvoiceDetail.Description, tBatchType.SupplierDisplayedName,| tLocation.Description, tPerson.Person, cc.Description, ca.Description, ce.ElementCode, tSubledger.Description,| tInvoiceReportTransaction.PayType,tBatch.CallsStartDate,| tBatch.CallsEndDate,| tBatch.RentStartDate,| tBatch.RentEndDate| | ORDER BY tInvoiceDetail.Description, tInvoiceReportTransaction.BatchID, tServiceID.ServiceID, tLocation.Description, tPerson.Person| | | | ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=11 sp=spRptTASCableTotal++++++++++ sql=[sp_helptext "spRptTASCableTotal" ] CREATE PROCEDURE spRptTASCableTotal| @InvDate varchar(30),| @CustomerList varchar(4096) = NULL,| @InvNo varchar(50) = NULL| AS| | SET NOCOUNT ON| | | SELECT Sum((CONVERT(Money, tFinalisedTransaction.AmountExGST)) * 12) AS Annual| | FROM tFinalisedTransaction (NOLOCK)| INNER JOIN tInvoiceDetail (NOLOCK) ON tFinalisedTransaction.InvoiceDetailID = tInvoiceDetail.ID| INNER JOIN tInvoice (NOLOCK) ON tInvoiceDetail.InvoiceID = tInvoice.ID| INNER JOIN tElement (NOLOCK) ON tFinalisedTransaction.ElementID = tElement.ID| | WHERE tInvoice.PlatinumInvoiceNo = @InvNo| AND tInvoice.CustomerID = @CustomerList| AND tFinalisedTransaction.AmountExGST <> 0| AND tElement.ReportGroupID = 11| AND Upper(tFinalisedTransaction.Var13) = 'EX SERVICE'| | | | | | | | | | | | | | | | | | | | ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=12 sp=spRptNotSet++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=13 sp=spRptNotSet++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=14 sp=spRptSmartbusFixed++++++++++ sql=[sp_helptext "spRptSmartbusFixed" ] CREATE PROCEDURE spRptSmartbusFixed| | @InvNo varchar(50) = NULL| | AS| | SET NOCOUNT ON| | SELECT| tInvoiceReportTransaction.BatchID,| tInvoiceDetail.Description As InvDetailDesc,| tServiceID.ServiceID,| tLocation.Description as Location,| tApplication.Description As ApplicationDesc,| tServiceType.Description As Speed,| /*PARental = SUM(CONVERT(numeric(16,2),tRate.Description)),*/| PARental = tRate.Cost,| Total = SUM( tInvoiceReportTransaction.AmountExGST),| tBatch.RentStartDate,| tBatch.RentEndDate,| tBatchType.SupplierDisplayedName| | | FROM tInvoiceReportTransaction (NOLOCK)| INNER JOIN tBatch (NOLOCK) ON tInvoiceReportTransaction.BatchID = tBatch.ID| INNER JOIN tInvoiceDetail (NOLOCK) ON tInvoiceReportTransaction.InvoiceDetailID = tInvoiceDetail.ID| INNER JOIN tInvoice (NOLOCK) ON tInvoiceDetail.InvoiceID = tInvoice.ID| INNER JOIN tBatchType (NOLOCK) ON tInvoiceDetail.BatchTypeID = tBatchType.ID| INNER JOIN tServiceID (NOLOCK) ON tInvoiceReportTransaction.ServiceID = tServiceID.ID| INNER JOIN tServiceType (NOLOCK) ON tServiceID.ServiceTypeID = tServiceType.ID| LEFT OUTER JOIN tLocation (NOLOCK) ON tInvoiceReportTransaction.LocationID = tLocation.ID| LEFT OUTER JOIN tApplication (NOLOCK) ON tServiceID.ApplicationID = tApplication.ID| INNER JOIN tRate (NOLOCK) ON tRate.ServiceTypeID = tServiceType.ID| | WHERE tInvoice.PlatinumInvoiceNo = @InvNo| AND tBatchType.ReportGroupID = 14| GROUP BY tBatchType.SupplierDisplayedName, tInvoiceReportTransaction.BatchID, tServiceID.ServiceID, tInvoiceDetail.Description,| tLocation.Description,| tBatch.RentStartDate,| tBatch.RentEndDate,| tApplication.Description,| tServiceType.Description,| tRate.Cost| | ORDER BY tInvoiceDetail.Description, tInvoiceReportTransaction.BatchID, tServiceID.ServiceID| | | | | ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=15 sp=spRptSmartbusGPRSMobile++++++++++ sql=[sp_helptext "spRptSmartbusGPRSMobile" ] CREATE PROCEDURE spRptSmartbusGPRSMobile| | @InvNo varchar(50) = NULL| | AS| | SET NOCOUNT ON| | SELECT| tInvoiceReportTransaction.BatchID,| tInvoiceDetail.Description As InvDetailDesc,| tServiceID.ServiceID,| tLocation.Description as Location,| tApplication.Description As ApplicationDesc,| Usage = SUM(CONVERT(int,tInvoiceReportTransaction.Var01)),| tBatch.CallsStartDate,| tBatch.CallsEndDate,| tBatch.RequisitionNumber,| tBatch.OrderNumber,| tBatch.TotalCredits,| tBatch.TotalRevenue,| tBatch.InvoiceNo,| tBatchType.SupplierDisplayedName| | | FROM tInvoiceReportTransaction (NOLOCK)| INNER JOIN tBatch (NOLOCK) ON tInvoiceReportTransaction.BatchID = tBatch.ID| INNER JOIN tInvoiceDetail (NOLOCK) ON tInvoiceReportTransaction.InvoiceDetailID = tInvoiceDetail.ID| INNER JOIN tInvoice (NOLOCK) ON tInvoiceDetail.InvoiceID = tInvoice.ID| INNER JOIN tBatchType (NOLOCK) ON tInvoiceDetail.BatchTypeID = tBatchType.ID| INNER JOIN tServiceID (NOLOCK) ON tInvoiceReportTransaction.ServiceID = tServiceID.ID| LEFT OUTER JOIN tLocation (NOLOCK) ON tInvoiceReportTransaction.LocationID = tLocation.ID| LEFT OUTER JOIN tApplication (NOLOCK) ON tServiceID.ApplicationID = tApplication.ID| | | WHERE tInvoice.PlatinumInvoiceNo = @InvNo| AND tBatchType.ReportGroupID = 15| GROUP BY tBatchType.SupplierDisplayedName, tInvoiceReportTransaction.BatchID, tServiceID.ServiceID, tInvoiceDetail.Description,| tLocation.Description,| tBatch.CallsStartDate,| tBatch.CallsEndDate,| tApplication.Description,| tBatch.RequisitionNumber,| tBatch.OrderNumber,| tBatch.TotalCredits,| tBatch.TotalRevenue,| tBatch.InvoiceNo| | | ORDER BY tInvoiceDetail.Description, tInvoiceReportTransaction.BatchID,tApplication.Description, tServiceID.ServiceID| ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=16 sp=spRptKamcoFixed++++++++++ sql=[sp_helptext "spRptKamcoFixed" ] CREATE PROCEDURE spRptKamcoFixed| | @InvNo varchar(50) = NULL| | AS| | SET NOCOUNT ON| | SELECT| tInvoiceReportTransaction.BatchID,| tInvoiceDetail.Description As InvDetailDesc,| tServiceID.ServiceID,| tLocation.Description as Location,| tApplication.Description As ApplicationDesc,| tServiceType.Description As Speed,| /*PARental = SUM(CONVERT(numeric(16,2),tRate.Description)),*/| PARental = tRate.Cost,| Total = SUM( tInvoiceReportTransaction.AmountExGST),| tBatch.RentStartDate,| tBatch.RentEndDate,| tBatchType.SupplierDisplayedName,| Var01,| Var02| | FROM tInvoiceReportTransaction (NOLOCK)| INNER JOIN tBatch (NOLOCK) ON tInvoiceReportTransaction.BatchID = tBatch.ID| INNER JOIN tInvoiceDetail (NOLOCK) ON tInvoiceReportTransaction.InvoiceDetailID = tInvoiceDetail.ID| INNER JOIN tInvoice (NOLOCK) ON tInvoiceDetail.InvoiceID = tInvoice.ID| INNER JOIN tBatchType (NOLOCK) ON tInvoiceDetail.BatchTypeID = tBatchType.ID| INNER JOIN tServiceID (NOLOCK) ON tInvoiceReportTransaction.ServiceID = tServiceID.ID| INNER JOIN tServiceType (NOLOCK) ON tServiceID.ServiceTypeID = tServiceType.ID| LEFT OUTER JOIN tLocation (NOLOCK) ON tInvoiceReportTransaction.LocationID = tLocation.ID| LEFT OUTER JOIN tApplication (NOLOCK) ON tServiceID.ApplicationID = tApplication.ID| INNER JOIN tRate (NOLOCK) ON tRate.ServiceTypeID = tServiceType.ID| | WHERE tInvoice.PlatinumInvoiceNo = @InvNo| AND tBatchType.ReportGroupID = 16| GROUP BY tBatchType.SupplierDisplayedName, tInvoiceReportTransaction.BatchID, tServiceID.ServiceID, tInvoiceDetail.Description,| tLocation.Description,| tBatch.RentStartDate,| tBatch.RentEndDate,| tApplication.Description,| tServiceType.Description,| tRate.Cost,| Var01,| Var02| | ORDER BY tInvoiceDetail.Description, tInvoiceReportTransaction.BatchID, tServiceID.ServiceID| | | | ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=17 sp=spRptNotSet++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=18 sp=spRptYarraGPRSMobile++++++++++ sql=[sp_helptext "spRptYarraGPRSMobile" ] CREATE PROCEDURE spRptYarraGPRSMobile| | @InvNo varchar(50) = NULL| | AS| | SET NOCOUNT ON| | SELECT| tInvoiceReportTransaction.BatchID,| tInvoiceDetail.Description As InvDetailDesc,| tServiceID.ServiceID,| tLocation.Description as Location,| tApplication.Description As ApplicationDesc,| Usage = SUM(CONVERT(int,tInvoiceReportTransaction.Var01)),| tBatch.RentStartDate,| tBatch.RentEndDate,| tBatch.RequisitionNumber,| tBatch.PaymentsReceived,| tBatch.OrderNumber,| tBatch.TotalCredits,| tBatch.TotalRevenue,| tBatch.OpeningBalance,| tBatch.InvoiceNo,| tBatchType.SupplierDisplayedName| | | FROM tInvoiceReportTransaction (NOLOCK)| INNER JOIN tBatch (NOLOCK) ON tInvoiceReportTransaction.BatchID = tBatch.ID| INNER JOIN tInvoiceDetail (NOLOCK) ON tInvoiceReportTransaction.InvoiceDetailID = tInvoiceDetail.ID| INNER JOIN tInvoice (NOLOCK) ON tInvoiceDetail.InvoiceID = tInvoice.ID| INNER JOIN tBatchType (NOLOCK) ON tInvoiceDetail.BatchTypeID = tBatchType.ID| INNER JOIN tServiceID (NOLOCK) ON tInvoiceReportTransaction.ServiceID = tServiceID.ID| LEFT OUTER JOIN tLocation (NOLOCK) ON tInvoiceReportTransaction.LocationID = tLocation.ID| LEFT OUTER JOIN tApplication (NOLOCK) ON tServiceID.ApplicationID = tApplication.ID| | | WHERE tInvoice.PlatinumInvoiceNo = @InvNo| AND tBatchType.ReportGroupID = 18| GROUP BY tBatchType.SupplierDisplayedName, tInvoiceReportTransaction.BatchID, tServiceID.ServiceID, tInvoiceDetail.Description,| tLocation.Description,| tBatch.RentStartDate,| tBatch.RentEndDate,| tApplication.Description,| tBatch.RequisitionNumber,| tBatch.PaymentsReceived,| tBatch.OrderNumber,| tBatch.TotalCredits,| tBatch.TotalRevenue,| tBatch.OpeningBalance,| tBatch.InvoiceNo| | | ORDER BY tInvoiceDetail.Description, tInvoiceReportTransaction.BatchID,tApplication.Description, tServiceID.ServiceID| | | | | ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=19 sp=spRptAggregateSmartbusGPRSMobile++++++++++ sql=[sp_helptext "spRptAggregateSmartbusGPRSMobile" ] CREATE PROCEDURE spRptAggregateSmartbusGPRSMobile| | @InvNo varchar(50) = NULL| | AS| | SET NOCOUNT ON| | SELECT| tInvoiceReportTransaction.BatchID,| tInvoiceDetail.Description As InvDetailDesc,| tServiceID.ServiceID,| tLocation.Description as Location,| tApplication.Description As ApplicationDesc,| Usage = SUM(CONVERT(int,tInvoiceReportTransaction.Var01)),| RentalAmountExGST = SUM(CASE tTransactionType.TransactionGroupID WHEN 1 THEN tInvoiceReportTransaction.AmountExGST ELSE 0 END),| CallAmountExGST = SUM(CASE tTransactionType.TransactionGroupID WHEN 2 THEN tInvoiceReportTransaction.AmountExGST ELSE 0 END),| tBatch.CallsStartDate,| tBatch.CallsEndDate,| tBatch.RequisitionNumber,| tBatch.OrderNumber,| tBatch.TotalCredits,| tBatch.TotalRevenue,| tBatch.InvoiceNo,| tBatchType.SupplierDisplayedName| | FROM tInvoiceReportTransaction (NOLOCK)| INNER JOIN tBatch (NOLOCK) ON tInvoiceReportTransaction.BatchID = tBatch.ID| INNER JOIN tInvoiceDetail (NOLOCK) ON tInvoiceReportTransaction.InvoiceDetailID = tInvoiceDetail.ID| INNER JOIN tInvoice (NOLOCK) ON tInvoiceDetail.InvoiceID = tInvoice.ID| INNER JOIN tBatchType (NOLOCK) ON tInvoiceDetail.BatchTypeID = tBatchType.ID| INNER JOIN tServiceID (NOLOCK) ON tInvoiceReportTransaction.ServiceID = tServiceID.ID| INNER JOIN tTransactionType (NOLOCK) ON tInvoiceReportTransaction.TransactionTypeID = tTransactionType.ID| LEFT OUTER JOIN tLocation (NOLOCK) ON tInvoiceReportTransaction.LocationID = tLocation.ID| LEFT OUTER JOIN tApplication (NOLOCK) ON tServiceID.ApplicationID = tApplication.ID| | WHERE tInvoice.PlatinumInvoiceNo = @InvNo| AND tBatchType.ReportGroupID = 19| AND tTransactionType.TransactionGroupID IN (1, 2)| GROUP BY tBatchType.SupplierDisplayedName, tInvoiceReportTransaction.BatchID, tServiceID.ServiceID, tInvoiceDetail.Description,| tLocation.Description,| tBatch.CallsStartDate,| tBatch.CallsEndDate,| tApplication.Description,| tBatch.RequisitionNumber,| tBatch.OrderNumber,| tBatch.TotalCredits,| tBatch.TotalRevenue,| tBatch.InvoiceNo| | ORDER BY tInvoiceDetail.Description, tInvoiceReportTransaction.BatchID,tApplication.Description, tServiceID.ServiceID| | ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++ reportgroupid=1 sp=spRptFaultReportData++++++++++ sql=[sp_helptext "spRptFaultReportData" ] CREATE PROCEDURE spRptFaultReportData| | @InvNo varchar(50) = NULL AS| | SET NOCOUNT ON| | SELECT tInvoice.CustomerID,| tInvoiceReportTransaction.Var02 AS LogDatTime,| tInvoiceReportTransaction.Var08 AS CallSubject1,| | [Location/Configuration] =| CASE| WHEN tInvoiceReportTransaction.Var10 = tInvoiceReportTransaction.Var05 THEN tInvoiceReportTransaction.Var10| ELSE tInvoiceReportTransaction.Var10 + ' ' + tInvoiceReportTransaction.Var05| END,| | tInvoiceReportTransaction.Var10 AS Location,| tInvoiceReportTransaction.Var05 AS Configuration,| tInvoiceReportTransaction.Var14 AS LastName,| tInvoiceReportTransaction.Var01 AS CallNumber,| tInvoiceDetail.Period AS Period,| tInvoiceReportTransaction.amountexGST As TariffAmount,| Billed = CASE tInvoiceReportTransaction.AmountExGST WHEN 0 THEN '' ELSE 'Y' END,| BilledCount = CASE tInvoiceReportTransaction.AmountExGST WHEN 0 Then 0 ELSE 1 END,| tCustomer.FullName,| tInvoiceReportTransaction.BatchID,| tInvoiceDetail.Description as InvDetailDesc,| tInvoiceDetail.Period,| tBatchType.SupplierDisplayedName| FROM tInvoice (NOLOCK)| INNER JOIN tInvoiceDetail (NOLOCK) ON tInvoice.ID = tInvoiceDetail.InvoiceID| INNER JOIN tInvoiceReportTransaction (NOLOCK) ON tInvoiceReportTransaction.InvoiceDetailID = tInvoiceDetail.ID| INNER JOIN tBatchType (NOLOCK) ON tBatchType.ID = tInvoiceDetail.BatchTypeID| /*INNER JOIN tReportGroup (NOLOCK) ON tElement.ReportGroupID = tReportGroup.ID*/| LEFT OUTER JOIN tCustomer (NOLOCK) ON tInvoice.CustomerID = tCustomer.ID| WHERE tBatchType.ReportGroupID = 1| AND tInvoice.PlatinumInvoiceNo = @InvNo| ORDER BY tInvoiceDetail.Description,tInvoiceReportTransaction.BatchID, tInvoiceReportTransaction.Var01| | | | | | ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003230] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003230" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003231] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003231" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003232] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003232" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003233] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003233" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003234] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003234" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003235] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003235" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003236] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003236" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003237] reportgroupid=[6] sp=[spRptNotSet] ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003238] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003238" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003239] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003239" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003239] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003239" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003239] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003239" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003239] reportgroupid=[5] sp=[spRptPurchasing] sql=[spRptPurchasing "INV003239" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ | CustomerID | CallNumber | Contractor | Location | Reference | Descr | amountexGST | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003240] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003240" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003240] reportgroupid=[12] sp=[spRptNotSet] ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003241] reportgroupid=[6] sp=[spRptNotSet] ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003242] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003242" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003243] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003243" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003244] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003244" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003245] reportgroupid=[6] sp=[spRptNotSet] ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003246] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003246" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003247] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003247" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003247] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003247" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003247] reportgroupid=[7] sp=[spRptSecurityData] sql=[spRptSecurityData "INV003247" ] +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ | ShipTo | Ref | TypeCode | Description | TariffAmount | Location | FullName | Period | POLcount | DUcount | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003248] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003248" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003249] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003249" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003250] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003250" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003250] reportgroupid=[6] sp=[spRptNotSet] ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003251] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003251" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003252] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003252" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003253] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003253" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003254] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003254" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003255] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003255" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003256] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003256" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003256] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003256" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003256] reportgroupid=[6] sp=[spRptNotSet] ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003257] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003257" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003258] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003258" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003259] reportgroupid=[6] sp=[spRptNotSet] ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003260] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003260" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003261] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003261" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003262] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003262" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003263] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003263" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003264] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003264" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003264] reportgroupid=[5] sp=[spRptPurchasing] sql=[spRptPurchasing "INV003264" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ | CustomerID | CallNumber | Contractor | Location | Reference | Descr | amountexGST | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003265] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003265" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003265] reportgroupid=[5] sp=[spRptPurchasing] sql=[spRptPurchasing "INV003265" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ | CustomerID | CallNumber | Contractor | Location | Reference | Descr | amountexGST | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003266] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003266" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003267] reportgroupid=[5] sp=[spRptPurchasing] sql=[spRptPurchasing "INV003267" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ | CustomerID | CallNumber | Contractor | Location | Reference | Descr | amountexGST | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003268] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003268" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003269] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003269" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003270] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003270" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003271] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003271" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003272] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003272" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003272] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003272" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003273] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003273" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003274] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003274" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003274] reportgroupid=[7] sp=[spRptSecurityData] sql=[spRptSecurityData "INV003274" ] +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ | ShipTo | Ref | TypeCode | Description | TariffAmount | Location | FullName | Period | POLcount | DUcount | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003275] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003275" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003276] reportgroupid=[6] sp=[spRptNotSet] ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003277] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003277" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003278] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003278" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003279] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003279" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003280] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003280" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003281] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003281" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003282] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003282" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003283] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003283" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003284] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003284" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003284] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003284" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003284] reportgroupid=[6] sp=[spRptNotSet] ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003284] reportgroupid=[] sp=[] sql=[ "INV003284" ] Msg 2812, Level 16, State 62 Server 'BLT02-TBS', Line 1 Could not find stored procedure 'INV003284'. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003285] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003285" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003286] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003286" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003287] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003287" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003288] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003288" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003289] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003289" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003290] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003290" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003291] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003291" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003292] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003292" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003293] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003293" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003294] reportgroupid=[] sp=[] sql=[ "INV003294" ] Msg 2812, Level 16, State 62 Server 'BLT02-TBS', Line 1 Could not find stored procedure 'INV003294'. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003295] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003295" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003296] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003296" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003297] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003297" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003298] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003298" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003298] reportgroupid=[7] sp=[spRptSecurityData] sql=[spRptSecurityData "INV003298" ] +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ | ShipTo | Ref | TypeCode | Description | TariffAmount | Location | FullName | Period | POLcount | DUcount | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003299] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003299" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003299] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003299" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003299] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003299" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003299] reportgroupid=[6] sp=[spRptNotSet] ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003300] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003300" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003301] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003301" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003302] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003302" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003303] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003303" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003304] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003304" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003304] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003304" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003304] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003304" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003305] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003305" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003306] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003306" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003307] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003307" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003307] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003307" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003307] reportgroupid=[5] sp=[spRptPurchasing] sql=[spRptPurchasing "INV003307" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ | CustomerID | CallNumber | Contractor | Location | Reference | Descr | amountexGST | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003308] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003308" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003309] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003309" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003310] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003310" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003311] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003311" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003312] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003312" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003313] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003313" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003313] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003313" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003314] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003314" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003314] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003314" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003314] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003314" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003314] reportgroupid=[6] sp=[spRptNotSet] ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003314] reportgroupid=[7] sp=[spRptSecurityData] sql=[spRptSecurityData "INV003314" ] +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ | ShipTo | Ref | TypeCode | Description | TariffAmount | Location | FullName | Period | POLcount | DUcount | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003315] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003315" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003316] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003316" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003317] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003317" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003318] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003318" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003319] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003319" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003320] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003320" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003321] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003321" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003322] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003322" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003323] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003323" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003323] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003323" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003323] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003323" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003323] reportgroupid=[5] sp=[spRptPurchasing] sql=[spRptPurchasing "INV003323" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ | CustomerID | CallNumber | Contractor | Location | Reference | Descr | amountexGST | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003323] reportgroupid=[] sp=[] sql=[ "INV003323" ] Msg 2812, Level 16, State 62 Server 'BLT02-TBS', Line 1 Could not find stored procedure 'INV003323'. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003324] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003324" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003325] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003325" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003326] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003326" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003327] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003327" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003328] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003328" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003329] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003329" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003330] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003330" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003331] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003331" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003332] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003332" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003332] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003332" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003332] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003332" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003332] reportgroupid=[5] sp=[spRptPurchasing] sql=[spRptPurchasing "INV003332" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ | CustomerID | CallNumber | Contractor | Location | Reference | Descr | amountexGST | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003333] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003333" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003334] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003334" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003335] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003335" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003335] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003335" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003335] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003335" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003336] reportgroupid=[7] sp=[spRptSecurityData] sql=[spRptSecurityData "INV003336" ] +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ | ShipTo | Ref | TypeCode | Description | TariffAmount | Location | FullName | Period | POLcount | DUcount | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003337] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003337" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003338] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003338" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003338] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003338" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003338] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003338" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003338] reportgroupid=[7] sp=[spRptSecurityData] sql=[spRptSecurityData "INV003338" ] +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ | ShipTo | Ref | TypeCode | Description | TariffAmount | Location | FullName | Period | POLcount | DUcount | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003339] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003339" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003340] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003340" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003341] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003341" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003342] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003342" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003343] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003343" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003344] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003344" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003345] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003345" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003345] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003345" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003346] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003346" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003347] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003347" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003348] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003348" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003349] reportgroupid=[7] sp=[spRptSecurityData] sql=[spRptSecurityData "INV003349" ] +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ | ShipTo | Ref | TypeCode | Description | TariffAmount | Location | FullName | Period | POLcount | DUcount | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003350] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003350" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003350] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003350" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003350] reportgroupid=[5] sp=[spRptPurchasing] sql=[spRptPurchasing "INV003350" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ | CustomerID | CallNumber | Contractor | Location | Reference | Descr | amountexGST | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003351] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003351" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003352] reportgroupid=[7] sp=[spRptSecurityData] sql=[spRptSecurityData "INV003352" ] +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ | ShipTo | Ref | TypeCode | Description | TariffAmount | Location | FullName | Period | POLcount | DUcount | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003353] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003353" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003354] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003354" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003355] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003355" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003356] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003356" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003357] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003357" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003357] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003357" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003357] reportgroupid=[5] sp=[spRptPurchasing] sql=[spRptPurchasing "INV003357" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ | CustomerID | CallNumber | Contractor | Location | Reference | Descr | amountexGST | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003358] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003358" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003359] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003359" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003360] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003360" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003361] reportgroupid=[7] sp=[spRptSecurityData] sql=[spRptSecurityData "INV003361" ] +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ | ShipTo | Ref | TypeCode | Description | TariffAmount | Location | FullName | Period | POLcount | DUcount | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +========+==================================+==========+==================================+=======================+==================================+==================================+=========+=============+=============+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003362] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003362" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003363] reportgroupid=[1] sp=[spRptFaultReportData] sql=[spRptFaultReportData "INV003363" ] +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ | CustomerID | LogDatTime | CallSubject1 | Location/Configuration | Location | Configuration | LastName | CallNumber | Period | TariffAmount | Billed | BilledCount | FullName | BatchID | InvDetailDesc | Period | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+==================================+==================================+=========+=======================+========+=============+==================================+=============+==================================+=========+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003366] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003366" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003366] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003366" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003386] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003386" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003386] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003386" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003387] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003387" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003388] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003388" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003389] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003389" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003390] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003390" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003391] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003391" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003392] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003392" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003410] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003410" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003489] reportgroupid=[10] sp=[spRptTASRentCallsOther] sql=[spRptTASRentCallsOther "INV003489" ] +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ | BatchID | InvDetailDesc | ServiceID | Location | UserData | CostCentreRef | Rent | Calls | Other | Admin | Total | CallsStartDate | CallsEndDate | RentStartDate | RentEndDate | SupplierDisplayedName | +=============+==================================+==================================+==================================+==================================+==================================+=======================+=======================+=======================+=======================+=======================+=====================+=====================+=====================+=====================+==================================+ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ invoiceno=[INV003489] reportgroupid=[3] sp=[spRptLabour] sql=[spRptLabour "INV003489" ] +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+ | CustomerID | LogDatTime | CallNumber | Reference | Descr | LastName | amountexGST | BatchID | InvDetailDesc | SupplierDisplayedName | Period | +=============+============+==================================+==================================+==================================+==================================+=======================+=============+==================================+==================================+=========+