[RM]Remove not needed qtyRejected column.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Mon, 14 Nov 2011 18:29:20 +0100
changeset 14597 07e87b7dca2a
parent 14596 2017d0e406d7
child 14598 f451caa03a3c
[RM]Remove not needed qtyRejected column.
src-db/database/model/tables/C_ORDERLINE.xml
src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/model/tables/C_ORDERLINE.xml	Mon Nov 14 16:26:23 2011 +0100
+++ b/src-db/database/model/tables/C_ORDERLINE.xml	Mon Nov 14 18:29:20 2011 +0100
@@ -197,10 +197,6 @@
         <default/>
         <onCreateDefault/>
       </column>
-      <column name="QTYREJECTED" primaryKey="false" required="false" type="DECIMAL" autoIncrement="false">
-        <default><![CDATA[0]]></default>
-        <onCreateDefault/>
-      </column>
       <column name="C_RETURN_REASON_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
         <default/>
         <onCreateDefault/>
--- a/src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml	Mon Nov 14 16:26:23 2011 +0100
+++ b/src-db/database/model/views/M_RM_RECEIPT_PICK_EDIT.xml	Mon Nov 14 18:29:20 2011 +0100
@@ -4,7 +4,7 @@
 CASE
 WHEN iol.m_inoutline_id IS NOT NULL THEN 'Y'
 ELSE 'N'
-END AS ob_selected, ol.c_orderline_id, ol.m_product_id, ol.c_uom_id, ol.m_attributesetinstance_id, (-1) * ol.qtyordered AS returned, (-1) * (ol.qtyordered - ol.qtydelivered - COALESCE(ol.qtyrejected, 0)) AS pendingqty, (-1) * iol.movementqty AS receivingqty, iol.m_condition_goods_id, iol.m_locator_id, o.documentno AS returnorderno, o.issotrx, ol.line
+END AS ob_selected, ol.c_orderline_id, ol.m_product_id, ol.c_uom_id, ol.m_attributesetinstance_id, (-1) * ol.qtyordered AS returned, (-1) * (ol.qtyordered - ol.qtydelivered) AS pendingqty, (-1) * iol.movementqty AS receivingqty, iol.m_condition_goods_id, iol.m_locator_id, o.documentno AS returnorderno, o.issotrx, ol.line
 FROM c_orderline ol
 JOIN c_order o ON o.c_order_id = ol.c_order_id
 JOIN m_product p ON ol.m_product_id = p.m_product_id AND p.producttype = 'I'
@@ -13,5 +13,5 @@
 FROM m_inoutline il2
 JOIN m_inout i2 ON il2.m_inout_id = i2.m_inout_id AND i2.processed = 'N') iol ON iol.c_orderline_id = ol.c_orderline_id
 LEFT JOIN m_inout io ON io.m_inout_id = iol.m_inout_id AND io.processed = 'N'
-WHERE (ol.qtyordered - ol.qtydelivered - COALESCE(ol.qtyrejected, 0)) <> 0]]></view>
+WHERE (ol.qtyordered - ol.qtydelivered) <> 0]]></view>
   </database>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Mon Nov 14 16:26:23 2011 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Mon Nov 14 18:29:20 2011 +0100
@@ -268367,41 +268367,6 @@
 <!--AF2B81F2F6CECDB5E040007F01006F02-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
 <!--AF2B81F2F6CECDB5E040007F01006F02--></AD_COLUMN>
 
-<!--AF914EB900557B0DE040007F0100322B--><AD_COLUMN>
-<!--AF914EB900557B0DE040007F0100322B-->  <AD_COLUMN_ID><![CDATA[AF914EB900557B0DE040007F0100322B]]></AD_COLUMN_ID>
-<!--AF914EB900557B0DE040007F0100322B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--AF914EB900557B0DE040007F0100322B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--AF914EB900557B0DE040007F0100322B-->  <NAME><![CDATA[Rejected Quantity]]></NAME>
-<!--AF914EB900557B0DE040007F0100322B-->  <DESCRIPTION><![CDATA[Rejected Quantity]]></DESCRIPTION>
-<!--AF914EB900557B0DE040007F0100322B-->  <HELP><![CDATA[The Rejected Quantity indicates the quantity of a product that have been rejected.]]></HELP>
-<!--AF914EB900557B0DE040007F0100322B-->  <COLUMNNAME><![CDATA[QtyRejected]]></COLUMNNAME>
-<!--AF914EB900557B0DE040007F0100322B-->  <AD_TABLE_ID><![CDATA[260]]></AD_TABLE_ID>
-<!--AF914EB900557B0DE040007F0100322B-->  <AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID>
-<!--AF914EB900557B0DE040007F0100322B-->  <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
-<!--AF914EB900557B0DE040007F0100322B-->  <DEFAULTVALUE><![CDATA[0]]></DEFAULTVALUE>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--AF914EB900557B0DE040007F0100322B-->  <SEQNO><![CDATA[94]]></SEQNO>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--AF914EB900557B0DE040007F0100322B-->  <AD_ELEMENT_ID><![CDATA[AF914E8D5EEE01F0E040007F01006C13]]></AD_ELEMENT_ID>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--AF914EB900557B0DE040007F0100322B-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--AF914EB900557B0DE040007F0100322B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--AF914EB900557B0DE040007F0100322B-->  <POSITION><![CDATA[51]]></POSITION>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--AF914EB900557B0DE040007F0100322B-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--AF914EB900557B0DE040007F0100322B-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--AF914EB900557B0DE040007F0100322B-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
-<!--AF914EB900557B0DE040007F0100322B--></AD_COLUMN>
-
 <!--B03312E5CE4446EABE1179DC075FA773--><AD_COLUMN>
 <!--B03312E5CE4446EABE1179DC075FA773-->  <AD_COLUMN_ID><![CDATA[B03312E5CE4446EABE1179DC075FA773]]></AD_COLUMN_ID>
 <!--B03312E5CE4446EABE1179DC075FA773-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -270676,7 +270641,9 @@
 <!--B162AE35D42C552DE040007F01001883-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--B162AE35D42C552DE040007F01001883-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--B162AE35D42C552DE040007F01001883-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--B162AE35D42C552DE040007F01001883-->  <NAME><![CDATA[Line]]></NAME>
+<!--B162AE35D42C552DE040007F01001883-->  <NAME><![CDATA[Line No.]]></NAME>
+<!--B162AE35D42C552DE040007F01001883-->  <DESCRIPTION><![CDATA[A line stating the position of this request in the document.]]></DESCRIPTION>
+<!--B162AE35D42C552DE040007F01001883-->  <HELP><![CDATA[Indicates the unique line for a document.  It will also control the display order of the lines within a document.]]></HELP>
 <!--B162AE35D42C552DE040007F01001883-->  <COLUMNNAME><![CDATA[Line]]></COLUMNNAME>
 <!--B162AE35D42C552DE040007F01001883-->  <AD_TABLE_ID><![CDATA[09C5EA393D0D41CEBB522DEC67534574]]></AD_TABLE_ID>
 <!--B162AE35D42C552DE040007F01001883-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
@@ -270690,6 +270657,7 @@
 <!--B162AE35D42C552DE040007F01001883-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--B162AE35D42C552DE040007F01001883-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--B162AE35D42C552DE040007F01001883-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--B162AE35D42C552DE040007F01001883-->  <AD_ELEMENT_ID><![CDATA[439]]></AD_ELEMENT_ID>
 <!--B162AE35D42C552DE040007F01001883-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
 <!--B162AE35D42C552DE040007F01001883-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
 <!--B162AE35D42C552DE040007F01001883-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
@@ -270707,7 +270675,9 @@
 <!--B162AE35D42D552DE040007F01001883-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--B162AE35D42D552DE040007F01001883-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--B162AE35D42D552DE040007F01001883-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--B162AE35D42D552DE040007F01001883-->  <NAME><![CDATA[Line]]></NAME>
+<!--B162AE35D42D552DE040007F01001883-->  <NAME><![CDATA[Line No.]]></NAME>
+<!--B162AE35D42D552DE040007F01001883-->  <DESCRIPTION><![CDATA[A line stating the position of this request in the document.]]></DESCRIPTION>
+<!--B162AE35D42D552DE040007F01001883-->  <HELP><![CDATA[Indicates the unique line for a document.  It will also control the display order of the lines within a document.]]></HELP>
 <!--B162AE35D42D552DE040007F01001883-->  <COLUMNNAME><![CDATA[Line]]></COLUMNNAME>
 <!--B162AE35D42D552DE040007F01001883-->  <AD_TABLE_ID><![CDATA[347B0AA5C3CD4D18910D2FE4990B790E]]></AD_TABLE_ID>
 <!--B162AE35D42D552DE040007F01001883-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
@@ -270721,6 +270691,7 @@
 <!--B162AE35D42D552DE040007F01001883-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--B162AE35D42D552DE040007F01001883-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--B162AE35D42D552DE040007F01001883-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--B162AE35D42D552DE040007F01001883-->  <AD_ELEMENT_ID><![CDATA[439]]></AD_ELEMENT_ID>
 <!--B162AE35D42D552DE040007F01001883-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
 <!--B162AE35D42D552DE040007F01001883-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
 <!--B162AE35D42D552DE040007F01001883-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Mon Nov 14 16:26:23 2011 +0100
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Mon Nov 14 18:29:20 2011 +0100
@@ -25219,19 +25219,6 @@
 <!--AF7A8ABE9B6711DDA4130016D4C601F7-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--AF7A8ABE9B6711DDA4130016D4C601F7--></AD_ELEMENT>
 
-<!--AF914E8D5EEE01F0E040007F01006C13--><AD_ELEMENT>
-<!--AF914E8D5EEE01F0E040007F01006C13-->  <AD_ELEMENT_ID><![CDATA[AF914E8D5EEE01F0E040007F01006C13]]></AD_ELEMENT_ID>
-<!--AF914E8D5EEE01F0E040007F01006C13-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--AF914E8D5EEE01F0E040007F01006C13-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--AF914E8D5EEE01F0E040007F01006C13-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--AF914E8D5EEE01F0E040007F01006C13-->  <COLUMNNAME><![CDATA[QtyRejected]]></COLUMNNAME>
-<!--AF914E8D5EEE01F0E040007F01006C13-->  <NAME><![CDATA[Rejected Quantity]]></NAME>
-<!--AF914E8D5EEE01F0E040007F01006C13-->  <PRINTNAME><![CDATA[Rejected Quantity]]></PRINTNAME>
-<!--AF914E8D5EEE01F0E040007F01006C13-->  <DESCRIPTION><![CDATA[Rejected Quantity]]></DESCRIPTION>
-<!--AF914E8D5EEE01F0E040007F01006C13-->  <HELP><![CDATA[The Rejected Quantity indicates the quantity of a product that have been rejected.]]></HELP>
-<!--AF914E8D5EEE01F0E040007F01006C13-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--AF914E8D5EEE01F0E040007F01006C13--></AD_ELEMENT>
-
 <!--B04AF439C0EBCC90E040007F010032CD--><AD_ELEMENT>
 <!--B04AF439C0EBCC90E040007F010032CD-->  <AD_ELEMENT_ID><![CDATA[B04AF439C0EBCC90E040007F010032CD]]></AD_ELEMENT_ID>
 <!--B04AF439C0EBCC90E040007F010032CD-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Mon Nov 14 16:26:23 2011 +0100
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Mon Nov 14 18:29:20 2011 +0100
@@ -164979,33 +164979,6 @@
 <!--1D25469C9C2341D3B284032C1D37D9AA-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--1D25469C9C2341D3B284032C1D37D9AA--></AD_FIELD>
 
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2--><AD_FIELD>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <AD_FIELD_ID><![CDATA[1D4D7CF80CB34D30A974BD251A4FB7C2]]></AD_FIELD_ID>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <ISACTIVE><![CDATA[N]]></ISACTIVE>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <NAME><![CDATA[Rejected Quantity]]></NAME>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <DESCRIPTION><![CDATA[Rejected Quantity]]></DESCRIPTION>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <HELP><![CDATA[The Rejected Quantity indicates the quantity of a product that have been rejected.]]></HELP>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <AD_TAB_ID><![CDATA[293]]></AD_TAB_ID>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <AD_COLUMN_ID><![CDATA[AF914EB900557B0DE040007F0100322B]]></AD_COLUMN_ID>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <SEQNO><![CDATA[40]]></SEQNO>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <GRID_SEQNO><![CDATA[0]]></GRID_SEQNO>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
-<!--1D4D7CF80CB34D30A974BD251A4FB7C2--></AD_FIELD>
-
 <!--1D534D626BB1488DBEBDB4B6E0C70A8B--><AD_FIELD>
 <!--1D534D626BB1488DBEBDB4B6E0C70A8B-->  <AD_FIELD_ID><![CDATA[1D534D626BB1488DBEBDB4B6E0C70A8B]]></AD_FIELD_ID>
 <!--1D534D626BB1488DBEBDB4B6E0C70A8B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -182195,33 +182168,6 @@
 <!--7272A1520A9E4E14A4E67EF38A9B895C-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--7272A1520A9E4E14A4E67EF38A9B895C--></AD_FIELD>
 
-<!--7299AD66E4E84758BD147E0C3D975ADA--><AD_FIELD>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <AD_FIELD_ID><![CDATA[7299AD66E4E84758BD147E0C3D975ADA]]></AD_FIELD_ID>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <ISACTIVE><![CDATA[N]]></ISACTIVE>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <NAME><![CDATA[Rejected Quantity]]></NAME>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <DESCRIPTION><![CDATA[Rejected Quantity]]></DESCRIPTION>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <HELP><![CDATA[The Rejected Quantity indicates the quantity of a product that have been rejected.]]></HELP>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <AD_TAB_ID><![CDATA[187]]></AD_TAB_ID>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <AD_COLUMN_ID><![CDATA[AF914EB900557B0DE040007F0100322B]]></AD_COLUMN_ID>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <SEQNO><![CDATA[40]]></SEQNO>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <GRID_SEQNO><![CDATA[0]]></GRID_SEQNO>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
-<!--7299AD66E4E84758BD147E0C3D975ADA-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
-<!--7299AD66E4E84758BD147E0C3D975ADA--></AD_FIELD>
-
 <!--729C53E68ECF429CB3EC782316BA3182--><AD_FIELD>
 <!--729C53E68ECF429CB3EC782316BA3182-->  <AD_FIELD_ID><![CDATA[729C53E68ECF429CB3EC782316BA3182]]></AD_FIELD_ID>
 <!--729C53E68ECF429CB3EC782316BA3182-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -202908,33 +202854,6 @@
 <!--AF914E8D5EF501F0E040007F01006C13-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--AF914E8D5EF501F0E040007F01006C13--></AD_FIELD>
 
-<!--AF914E8D5EF601F0E040007F01006C13--><AD_FIELD>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <AD_FIELD_ID><![CDATA[AF914E8D5EF601F0E040007F01006C13]]></AD_FIELD_ID>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <NAME><![CDATA[Rejected Quantity]]></NAME>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <DESCRIPTION><![CDATA[Rejected Quantity]]></DESCRIPTION>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <HELP><![CDATA[The Rejected Quantity indicates the quantity of a product that have been rejected.]]></HELP>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <AD_TAB_ID><![CDATA[AF4090093D471431E040007F010048A5]]></AD_TAB_ID>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <AD_COLUMN_ID><![CDATA[AF914EB900557B0DE040007F0100322B]]></AD_COLUMN_ID>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <SEQNO><![CDATA[60]]></SEQNO>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <GRID_SEQNO><![CDATA[50]]></GRID_SEQNO>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
-<!--AF914E8D5EF601F0E040007F01006C13-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
-<!--AF914E8D5EF601F0E040007F01006C13--></AD_FIELD>
-
 <!--AF9C3E2724F742E38D4069EB9045B0AE--><AD_FIELD>
 <!--AF9C3E2724F742E38D4069EB9045B0AE-->  <AD_FIELD_ID><![CDATA[AF9C3E2724F742E38D4069EB9045B0AE]]></AD_FIELD_ID>
 <!--AF9C3E2724F742E38D4069EB9045B0AE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -205580,33 +205499,6 @@
 <!--BC62A32A3F014F7AB645399D8EE77DA5-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--BC62A32A3F014F7AB645399D8EE77DA5--></AD_FIELD>
 
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D--><AD_FIELD>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <AD_FIELD_ID><![CDATA[BCB94D2FC7EE49DB821B6FFCF7A1806D]]></AD_FIELD_ID>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <ISACTIVE><![CDATA[N]]></ISACTIVE>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <NAME><![CDATA[Rejected Quantity]]></NAME>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <DESCRIPTION><![CDATA[Rejected Quantity]]></DESCRIPTION>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <HELP><![CDATA[The Rejected Quantity indicates the quantity of a product that have been rejected.]]></HELP>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <AD_TAB_ID><![CDATA[387B6179438D4C4CB40769A77F4C304C]]></AD_TAB_ID>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <AD_COLUMN_ID><![CDATA[AF914EB900557B0DE040007F0100322B]]></AD_COLUMN_ID>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <SEQNO><![CDATA[30]]></SEQNO>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <GRID_SEQNO><![CDATA[0]]></GRID_SEQNO>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
-<!--BCB94D2FC7EE49DB821B6FFCF7A1806D--></AD_FIELD>
-
 <!--BCCEE38BDD11461581351F4097A34B62--><AD_FIELD>
 <!--BCCEE38BDD11461581351F4097A34B62-->  <AD_FIELD_ID><![CDATA[BCCEE38BDD11461581351F4097A34B62]]></AD_FIELD_ID>
 <!--BCCEE38BDD11461581351F4097A34B62-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>