Index: CSPimpl/Vhisie4/WinkelkarTotOrderVerwerker/OfferteService.cls.xml
===================================================================
diff -u -r53345 -r53635
--- CSPimpl/Vhisie4/WinkelkarTotOrderVerwerker/OfferteService.cls.xml	(.../OfferteService.cls.xml)	(revision 53345)
+++ CSPimpl/Vhisie4/WinkelkarTotOrderVerwerker/OfferteService.cls.xml	(.../OfferteService.cls.xml)	(revision 53635)
@@ -37,14 +37,14 @@
 <Implementation><![CDATA[
 	Set:(Datum="") Datum = ##class(TECH.DateTime).%New().CurrentDateVoorQueries()
 
-	#dim SqlStatement As TECH.String = "SELECT ID, OrderID, ExterneId, BestelStatus, Bestelopmerking, AangemaaktOp, KlantID, WinkelkarId, WensLeverDatum FROM APPS_VKP_impl.Offerte Where AangemaaktOp %StartsWith ? order by ID DESC"
+	#dim SqlStatement As TECH.String = "SELECT ID, OrderID, ExterneId, BestelStatus, Bestelopmerking, AangemaaktOp, KlantID, WinkelkarId, WensLeverDatum, KlantBestellingId FROM APPS_VKP_impl.Offerte Where AangemaaktOp %StartsWith ? order by ID DESC"
 
 	#dim ResultSet As TECH.ResultSet = ..QueryAPI.GetResultSet(##class(TECH.DynamicQuery).%New(SqlStatement,$Lb(Datum)))
 
 	Set Offertes = ##class(%ListOfDataTypes).%New()
 
 	While ResultSet.Next() {
-		Do Offertes.Insert($listbuild(ResultSet.GetData(1),ResultSet.GetData(2),ResultSet.GetData(3),ResultSet.GetData(4),$Extract(ResultSet.GetData(5),1,50),ResultSet.GetData(6),ResultSet.GetData(7),ResultSet.GetData(8),ResultSet.GetData(9)))
+		Do Offertes.Insert($listbuild(ResultSet.GetData(1),ResultSet.GetData(2),ResultSet.GetData(3),ResultSet.GetData(4),$Extract(ResultSet.GetData(5),1,50),ResultSet.GetData(6),ResultSet.GetData(7),ResultSet.GetData(8),ResultSet.GetData(9),ResultSet.GetData(10)))
 	}
 	
 	Quit ##class(TECH.ListIterator).%New(Offertes)