# HG changeset patch
# User Alvaro Ferraz <alvaro.ferraz@openbravo.com>
# Date 1462275053 -7200
#      Tue May 03 13:30:53 2016 +0200
# Node ID 2425fde034ebf3ee015b439242f77a9d08211241
# Parent  2bcf5c3e1da66ebae6a14d2c75d5627ac9e36ccd
Fixes issue 32829: Set C_Order DeliveryStatus column as Amount with 2 decimals

diff --git a/src-db/database/sourcedata/AD_COLUMN.xml b/src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml
+++ b/src-db/database/sourcedata/AD_COLUMN.xml
@@ -333156,8 +333156,8 @@
 <!--9E82E728716246B393C40D2CDCA0133A-->  <DESCRIPTION><![CDATA[Delivery Status]]></DESCRIPTION>
 <!--9E82E728716246B393C40D2CDCA0133A-->  <COLUMNNAME><![CDATA[DeliveryStatus]]></COLUMNNAME>
 <!--9E82E728716246B393C40D2CDCA0133A-->  <AD_TABLE_ID><![CDATA[259]]></AD_TABLE_ID>
-<!--9E82E728716246B393C40D2CDCA0133A-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
-<!--9E82E728716246B393C40D2CDCA0133A-->  <FIELDLENGTH><![CDATA[4]]></FIELDLENGTH>
+<!--9E82E728716246B393C40D2CDCA0133A-->  <AD_REFERENCE_ID><![CDATA[12]]></AD_REFERENCE_ID>
+<!--9E82E728716246B393C40D2CDCA0133A-->  <FIELDLENGTH><![CDATA[7]]></FIELDLENGTH>
 <!--9E82E728716246B393C40D2CDCA0133A-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--9E82E728716246B393C40D2CDCA0133A-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--9E82E728716246B393C40D2CDCA0133A-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
@@ -333179,7 +333179,7 @@
 <!--9E82E728716246B393C40D2CDCA0133A-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
 <!--9E82E728716246B393C40D2CDCA0133A-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--9E82E728716246B393C40D2CDCA0133A-->  <SQLLOGIC><![CDATA[(coalesce((select case when sum(abs(ol.qtyordered))  = 0 then 0 else 
-round(coalesce(sum(abs(ol.qtydelivered)), 0)/sum(abs(ol.qtyordered)) * 100, 0)  end 
+round(coalesce(sum(abs(ol.qtydelivered)), 0)/sum(abs(ol.qtyordered)) * 100, 2)  end 
  from c_orderline ol where ol.c_order_id=c_order_id and ol.c_order_discount_id is null
  ),0))]]></SQLLOGIC>
 <!--9E82E728716246B393C40D2CDCA0133A-->  <ALLOWSORTING><![CDATA[N]]></ALLOWSORTING>