details:   https://code.openbravo.com/erp/devel/pi/rev/7f16a6a46998
changeset: 17567:7f16a6a46998
user:      Martin Taal <martin.taal <at> openbravo.com>
date:      Fri Jul 27 16:53:37 2012 +0200
summary:   Fixes issue 21230: Pick & Execute Windows:Change reference of read 
only fields to not do combo value computation by FIC
Changed the reference of the storage bin to a selector and of several other 
columns to search: m_inout_id column, order line column

diffstat:

 src-db/database/sourcedata/AD_COLUMN.xml |  27 ++++++++++++++++-----------
 1 files changed, 16 insertions(+), 11 deletions(-)

diffs (100 lines):

diff -r a0496efc26eb -r 7f16a6a46998 src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml  Fri Jul 27 15:37:08 2012 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml  Fri Jul 27 16:53:37 2012 +0200
@@ -225745,7 +225745,7 @@
 <!--398019882EF04B089E5AEB86B314DD73-->  <HELP><![CDATA[The Tax indicates the 
type of tax for this document line.]]></HELP>
 <!--398019882EF04B089E5AEB86B314DD73-->  
<COLUMNNAME><![CDATA[C_Tax_ID]]></COLUMNNAME>
 <!--398019882EF04B089E5AEB86B314DD73-->  
<AD_TABLE_ID><![CDATA[38A7A1273EA34C93A0EA49CE77B6FB14]]></AD_TABLE_ID>
-<!--398019882EF04B089E5AEB86B314DD73-->  
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--398019882EF04B089E5AEB86B314DD73-->  
<AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
 <!--398019882EF04B089E5AEB86B314DD73-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--398019882EF04B089E5AEB86B314DD73-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--398019882EF04B089E5AEB86B314DD73-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -281080,7 +281080,8 @@
 <!--B04AF439C0E0CC90E040007F010032CD-->  <HELP><![CDATA[The Goods Shipment 
Line indicates a unique line in a Shipment document]]></HELP>
 <!--B04AF439C0E0CC90E040007F010032CD-->  
<COLUMNNAME><![CDATA[M_Inoutline_ID]]></COLUMNNAME>
 <!--B04AF439C0E0CC90E040007F010032CD-->  
<AD_TABLE_ID><![CDATA[38A7A1273EA34C93A0EA49CE77B6FB14]]></AD_TABLE_ID>
-<!--B04AF439C0E0CC90E040007F010032CD-->  
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--B04AF439C0E0CC90E040007F010032CD-->  
<AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--B04AF439C0E0CC90E040007F010032CD-->  
<AD_REFERENCE_VALUE_ID><![CDATA[800064]]></AD_REFERENCE_VALUE_ID>
 <!--B04AF439C0E0CC90E040007F010032CD-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--B04AF439C0E0CC90E040007F010032CD-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--B04AF439C0E0CC90E040007F010032CD-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -281323,7 +281324,7 @@
 <!--B04AF439C0E7CC90E040007F010032CD-->  <HELP><![CDATA[The UOM defines a 
unique non monetary unit of measure]]></HELP>
 <!--B04AF439C0E7CC90E040007F010032CD-->  
<COLUMNNAME><![CDATA[C_Uom_ID]]></COLUMNNAME>
 <!--B04AF439C0E7CC90E040007F010032CD-->  
<AD_TABLE_ID><![CDATA[38A7A1273EA34C93A0EA49CE77B6FB14]]></AD_TABLE_ID>
-<!--B04AF439C0E7CC90E040007F010032CD-->  
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--B04AF439C0E7CC90E040007F010032CD-->  
<AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
 <!--B04AF439C0E7CC90E040007F010032CD-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--B04AF439C0E7CC90E040007F010032CD-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--B04AF439C0E7CC90E040007F010032CD-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -282166,7 +282167,8 @@
 <!--B0D44F14A9EC533DE040007F01004FD0-->  <HELP><![CDATA[The Shipment ID 
indicates the unique document for this shipment.]]></HELP>
 <!--B0D44F14A9EC533DE040007F01004FD0-->  
<COLUMNNAME><![CDATA[M_Inout_ID]]></COLUMNNAME>
 <!--B0D44F14A9EC533DE040007F01004FD0-->  
<AD_TABLE_ID><![CDATA[09C5EA393D0D41CEBB522DEC67534574]]></AD_TABLE_ID>
-<!--B0D44F14A9EC533DE040007F01004FD0-->  
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--B0D44F14A9EC533DE040007F01004FD0-->  
<AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--B0D44F14A9EC533DE040007F01004FD0-->  
<AD_REFERENCE_VALUE_ID><![CDATA[800095]]></AD_REFERENCE_VALUE_ID>
 <!--B0D44F14A9EC533DE040007F01004FD0-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--B0D44F14A9EC533DE040007F01004FD0-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--B0D44F14A9EC533DE040007F01004FD0-->  <ISPARENT><![CDATA[Y]]></ISPARENT>
@@ -282237,7 +282239,7 @@
 <!--B0D44F14A9EE533DE040007F01004FD0-->  <HELP><![CDATA[The UOM defines a 
unique non monetary unit of measure]]></HELP>
 <!--B0D44F14A9EE533DE040007F01004FD0-->  
<COLUMNNAME><![CDATA[C_Uom_ID]]></COLUMNNAME>
 <!--B0D44F14A9EE533DE040007F01004FD0-->  
<AD_TABLE_ID><![CDATA[09C5EA393D0D41CEBB522DEC67534574]]></AD_TABLE_ID>
-<!--B0D44F14A9EE533DE040007F01004FD0-->  
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--B0D44F14A9EE533DE040007F01004FD0-->  
<AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
 <!--B0D44F14A9EE533DE040007F01004FD0-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--B0D44F14A9EE533DE040007F01004FD0-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--B0D44F14A9EE533DE040007F01004FD0-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -283926,7 +283928,8 @@
 <!--B0D8409002CCC4F5E040007F01001E9D-->  <HELP><![CDATA[A unique identifier 
and a reference to a sales order line (product).]]></HELP>
 <!--B0D8409002CCC4F5E040007F01001E9D-->  
<COLUMNNAME><![CDATA[C_Orderline_ID]]></COLUMNNAME>
 <!--B0D8409002CCC4F5E040007F01001E9D-->  
<AD_TABLE_ID><![CDATA[09C5EA393D0D41CEBB522DEC67534574]]></AD_TABLE_ID>
-<!--B0D8409002CCC4F5E040007F01001E9D-->  
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--B0D8409002CCC4F5E040007F01001E9D-->  
<AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--B0D8409002CCC4F5E040007F01001E9D-->  
<AD_REFERENCE_VALUE_ID><![CDATA[800063]]></AD_REFERENCE_VALUE_ID>
 <!--B0D8409002CCC4F5E040007F01001E9D-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--B0D8409002CCC4F5E040007F01001E9D-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--B0D8409002CCC4F5E040007F01001E9D-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -284451,7 +284454,7 @@
 <!--B151560F62673082E040007F01002081-->  <HELP><![CDATA[The UOM defines a 
unique non monetary unit of measure]]></HELP>
 <!--B151560F62673082E040007F01002081-->  
<COLUMNNAME><![CDATA[C_Uom_ID]]></COLUMNNAME>
 <!--B151560F62673082E040007F01002081-->  
<AD_TABLE_ID><![CDATA[347B0AA5C3CD4D18910D2FE4990B790E]]></AD_TABLE_ID>
-<!--B151560F62673082E040007F01002081-->  
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--B151560F62673082E040007F01002081-->  
<AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
 <!--B151560F62673082E040007F01002081-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--B151560F62673082E040007F01002081-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--B151560F62673082E040007F01002081-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -284556,8 +284559,8 @@
 <!--B151560F626A3082E040007F01002081-->  <HELP><![CDATA[The Locator ID 
indicates where in a Warehouse a product is located.]]></HELP>
 <!--B151560F626A3082E040007F01002081-->  
<COLUMNNAME><![CDATA[M_Locator_ID]]></COLUMNNAME>
 <!--B151560F626A3082E040007F01002081-->  
<AD_TABLE_ID><![CDATA[347B0AA5C3CD4D18910D2FE4990B790E]]></AD_TABLE_ID>
-<!--B151560F626A3082E040007F01002081-->  
<AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
-<!--B151560F626A3082E040007F01002081-->  
<AD_REFERENCE_VALUE_ID><![CDATA[31]]></AD_REFERENCE_VALUE_ID>
+<!--B151560F626A3082E040007F01002081-->  
<AD_REFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></AD_REFERENCE_ID>
+<!--B151560F626A3082E040007F01002081-->  
<AD_REFERENCE_VALUE_ID><![CDATA[0537E1156A064FDE8EF0CFBC97577E5F]]></AD_REFERENCE_VALUE_ID>
 <!--B151560F626A3082E040007F01002081-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--B151560F626A3082E040007F01002081-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--B151560F626A3082E040007F01002081-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -284659,7 +284662,8 @@
 <!--B151560F626D3082E040007F01002081-->  <HELP><![CDATA[The Shipment ID 
indicates the unique document for this shipment.]]></HELP>
 <!--B151560F626D3082E040007F01002081-->  
<COLUMNNAME><![CDATA[M_Inout_ID]]></COLUMNNAME>
 <!--B151560F626D3082E040007F01002081-->  
<AD_TABLE_ID><![CDATA[347B0AA5C3CD4D18910D2FE4990B790E]]></AD_TABLE_ID>
-<!--B151560F626D3082E040007F01002081-->  
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--B151560F626D3082E040007F01002081-->  
<AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--B151560F626D3082E040007F01002081-->  
<AD_REFERENCE_VALUE_ID><![CDATA[800095]]></AD_REFERENCE_VALUE_ID>
 <!--B151560F626D3082E040007F01002081-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--B151560F626D3082E040007F01002081-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--B151560F626D3082E040007F01002081-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -284761,7 +284765,8 @@
 <!--B15197FA9BC1D9E0E040007F010033F7-->  <HELP><![CDATA[A unique identifier 
and a reference to a sales order line (product).]]></HELP>
 <!--B15197FA9BC1D9E0E040007F010033F7-->  
<COLUMNNAME><![CDATA[C_Orderline_ID]]></COLUMNNAME>
 <!--B15197FA9BC1D9E0E040007F010033F7-->  
<AD_TABLE_ID><![CDATA[347B0AA5C3CD4D18910D2FE4990B790E]]></AD_TABLE_ID>
-<!--B15197FA9BC1D9E0E040007F010033F7-->  
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--B15197FA9BC1D9E0E040007F010033F7-->  
<AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--B15197FA9BC1D9E0E040007F010033F7-->  
<AD_REFERENCE_VALUE_ID><![CDATA[800063]]></AD_REFERENCE_VALUE_ID>
 <!--B15197FA9BC1D9E0E040007F010033F7-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--B15197FA9BC1D9E0E040007F010033F7-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--B15197FA9BC1D9E0E040007F010033F7-->  <ISPARENT><![CDATA[N]]></ISPARENT>

------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to