Index: AXimpl/Controle/Order/OrderLijn.cls.xml
===================================================================
diff -u -r43042 -r44118
--- AXimpl/Controle/Order/OrderLijn.cls.xml (.../OrderLijn.cls.xml) (revision 43042)
+++ AXimpl/Controle/Order/OrderLijn.cls.xml (.../OrderLijn.cls.xml) (revision 44118)
@@ -7,18 +7,50 @@
AXimpl.Controle.Order.Admin.OrderLijn
+
+%String
+
+
+
+%String
+
+
%String
+
+%String
+
+
%String
+
+%String
+
+
+
+%String
+
+
%String
+
+%String
+
+
+
+%String
+
+
+
+%String
+
+
%String
Index: AXimpl/Controle/Order/Ax/AxOrderLijnConverter.cls.xml
===================================================================
diff -u -r43052 -r44118
--- AXimpl/Controle/Order/Ax/AxOrderLijnConverter.cls.xml (.../AxOrderLijnConverter.cls.xml) (revision 43052)
+++ AXimpl/Controle/Order/Ax/AxOrderLijnConverter.cls.xml (.../AxOrderLijnConverter.cls.xml) (revision 44118)
@@ -9,13 +9,24 @@
Index: AXimpl/Controle/Order/Ax/AxOrderLijnIterator.cls.xml
===================================================================
diff -u -r44104 -r44118
--- AXimpl/Controle/Order/Ax/AxOrderLijnIterator.cls.xml (.../AxOrderLijnIterator.cls.xml) (revision 44104)
+++ AXimpl/Controle/Order/Ax/AxOrderLijnIterator.cls.xml (.../AxOrderLijnIterator.cls.xml) (revision 44118)
@@ -37,31 +37,38 @@
1
= 1 and salesline.SALESQTY >= 0 "
_"and salesLine.DATAAREAID = 'VHBE' and salesline.PARTITION = '5637144576'"
-
- /*
+ */
+
// Iteratie 2:
- Set SqlStatement = "select salesLine.SalesId,salesLine.CustAccount,salesline.inventtransid,salesline.itemid,salesline.CONFIRMEDDLV,salesline.QtyOrdered,"
- _"isnull(( select -sum(qty) from inventtrans where INVENTTRANSORIGIN.RECID = inventtrans.INVENTTRANSORIGIN and INVENTTRANS.STATUSISSUE = 3 and "
- _"inventtrans.STATUSRECEIPT = 0 and inventtrans.DATAAREAID = INVENTTRANSORIGIN.DATAAREAID and inventtrans.PARTITION = INVENTTRANSORIGIN.PARTITION),0) as gepickteHoeveelheid,"
- _"salesline.REMAINSALESPHYSICAL as openstaandeHoeveelheid,CONFIGID,inventtransorigin.ADUSOPRContractId,isnull(LogisticsPostalAddress.CountryRegionId,''),"
- _"isnull(LogisticsPostalAddress.City,''),isnull(LogisticsPostalAddress.Street,''),isnull(LogisticsPostalAddress.Zipcode,'') from SALESLINE "
- _"join inventdim on inventdim.INVENTDIMID = salesline.INVENTDIMID and inventdim.DATAAREAID = SALESLINE.DATAAREAID and inventdim.PARTITION = salesline.PARTITION "
+ Set SqlStatement = "select salesLine.SalesId,salesLine.CustAccount,salesline.inventtransid,salesline.itemid,salesline.CONFIRMEDDLV,salesline.QtyOrdered"
+ // Toevoeging velden iteratie 2...
+ _",isnull(( select -sum(qty) from inventtrans where INVENTTRANSORIGIN.RECID = inventtrans.INVENTTRANSORIGIN and INVENTTRANS.STATUSISSUE = 3 and "
+ _"inventtrans.STATUSRECEIPT = 0 and inventtrans.DATAAREAID = INVENTTRANSORIGIN.DATAAREAID and inventtrans.PARTITION = INVENTTRANSORIGIN.PARTITION),0) as GepickteHoeveelheid"
+ _",salesline.REMAINSALESPHYSICAL as OpenstaandeHoeveelheid"
+ _",CONFIGID"
+ _",inventtransorigin.ADUSOPRContractId"
+ _",isnull(LogisticsPostalAddress.CountryRegionId,'') as CountryRegionId"
+ _",isnull(LogisticsPostalAddress.City,'') as City"
+ _",isnull(LogisticsPostalAddress.Street,'') as Street"
+ _",isnull(LogisticsPostalAddress.Zipcode,'') as Zipcode"
+ // Einde toevoeging velden iteratie 2, rest van iteratie 1...
+ _" from SALESLINE join inventdim on inventdim.INVENTDIMID = salesline.INVENTDIMID and inventdim.DATAAREAID = SALESLINE.DATAAREAID and inventdim.PARTITION = salesline.PARTITION "
_"join SALESTABLE on SALESTABLE.SALESID = salesline.SALESID and SALESTABLE.DATAAREAID = salesline.DATAAREAID and salestable.PARTITION = salesline.PARTITION "
_"left outer join LOGISTICSPOSTALADDRESS on LOGISTICSPOSTALADDRESS.RECID = salesline.DELIVERYPOSTALADDRESS and LOGISTICSPOSTALADDRESS.PARTITION = salesline.PARTITION "
_"join INVENTTRANSORIGIN on INVENTTRANSORIGIN.INVENTTRANSID = salesline.INVENTTRANSID and INVENTTRANSORIGIN.DATAAREAID = salesline.DATAAREAID and "
_"INVENTTRANSORIGIN.PARTITION = salesline.PARTITION where salestable.SALESSTATUS = 1 and salestable.DOCUMENTSTATUS >= 1 and salesline.SALESQTY >= 0 "
_"and salesLine.DATAAREAID = 'VHBE' and salesline.PARTITION = '5637144576'"
- */
+
Set ..ResultSet = ..SqlQueryConnection.GetResultSet(SqlStatement)
]]>
Index: AXimpl/Controle/Order/Admin/AdminOrderLijnConverter.cls.xml
===================================================================
diff -u -r43664 -r44118
--- AXimpl/Controle/Order/Admin/AdminOrderLijnConverter.cls.xml (.../AdminOrderLijnConverter.cls.xml) (revision 43664)
+++ AXimpl/Controle/Order/Admin/AdminOrderLijnConverter.cls.xml (.../AdminOrderLijnConverter.cls.xml) (revision 44118)
@@ -39,13 +39,24 @@
Index: vhUnitTest/AXimpl/Controle/Order/Admin/AdminOrderLijnConverter/Test.cls.xml
===================================================================
diff -u -r43664 -r44118
--- vhUnitTest/AXimpl/Controle/Order/Admin/AdminOrderLijnConverter/Test.cls.xml (.../Test.cls.xml) (revision 43664)
+++ vhUnitTest/AXimpl/Controle/Order/Admin/AdminOrderLijnConverter/Test.cls.xml (.../Test.cls.xml) (revision 44118)
@@ -54,6 +54,13 @@
]]>
+
+
+
+
+
+
+
+
1
DOM.PM.impl.ProductImpl
Index: AXimpl/Controle/Order/OrderLijnControleGenerator.cls.xml
===================================================================
diff -u -r43699 -r44118
--- AXimpl/Controle/Order/OrderLijnControleGenerator.cls.xml (.../OrderLijnControleGenerator.cls.xml) (revision 43699)
+++ AXimpl/Controle/Order/OrderLijnControleGenerator.cls.xml (.../OrderLijnControleGenerator.cls.xml) (revision 44118)
@@ -70,13 +70,25 @@