details:   https://code.openbravo.com/erp/devel/pi/rev/1655f1ccceb1
changeset: 30450:1655f1ccceb1
user:      Atul Gaware <atul.gaware <at> openbravo.com>
date:      Wed Oct 05 17:15:27 2016 +0530
summary:   Fixes issue 34014: Simple Stock By Warehouse Widget

Added new widget with name Simple Stock By Warehouse
New view with subquery to get qtyonhand from storage detail and joins with 
Product, Category, Uom, Warehouse

details:   https://code.openbravo.com/erp/devel/pi/rev/ab62853b9b6c
changeset: 30451:ab62853b9b6c
user:      Alvaro Ferraz <alvaro.ferraz <at> openbravo.com>
date:      Mon Oct 10 17:12:47 2016 +0200
summary:   Related to issue 34014: Code review improvements

Change retrieved columns order in OBWCL_STOCK_BY_WAREHOUSE_V view.
Change Obwcl_Stock_By_Warehouse_V_ID column length.
Change Widgets Collection module package name.
Change OBWCL_StockByWarehouseView table java class name.

diffstat:

 
modules/org.openbravo.client.widgets/src-db/database/model/views/OBWCL_STOCK_BY_WAREHOUSE_V.xml
 |    4 +
 modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_COLUMN.xml  
                 |  719 ++++++++++
 modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_ELEMENT.xml 
                 |   72 +
 
modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_MODULE_DBPREFIX.xml
          |   12 +
 modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_PACKAGE.xml 
                 |   13 +
 modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_TABLE.xml   
                 |   25 +
 
modules/org.openbravo.client.widgets/src-db/database/sourcedata/OBCQL_QUERY_COLUMN.xml
          |  108 +
 
modules/org.openbravo.client.widgets/src-db/database/sourcedata/OBCQL_WIDGET_QUERY.xml
          |   15 +
 
modules/org.openbravo.client.widgets/src-db/database/sourcedata/OBKMO_WIDGET_CLASS.xml
          |   17 +
 
modules/org.openbravo.client.widgets/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
           |   93 +
 10 files changed, 1078 insertions(+), 0 deletions(-)

diffs (truncated from 1193 to 300 lines):

diff -r bbfa7b5fc9dc -r ab62853b9b6c 
modules/org.openbravo.client.widgets/src-db/database/model/views/OBWCL_STOCK_BY_WAREHOUSE_V.xml
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ 
b/modules/org.openbravo.client.widgets/src-db/database/model/views/OBWCL_STOCK_BY_WAREHOUSE_V.xml
   Mon Oct 10 17:12:47 2016 +0200
@@ -0,0 +1,4 @@
+<?xml version="1.0"?>
+  <database name="VIEW OBWCL_STOCK_BY_WAREHOUSE_V">
+    <view name="OBWCL_STOCK_BY_WAREHOUSE_V"><![CDATA[SELECT sd.m_product_id || 
sd.m_storage_detail_id AS obwcl_stock_by_warehouse_v_id, p.ad_client_id, 
p.isactive, p.created, p.createdby, p.updated, p.updatedby, o.ad_org_id, o.name 
AS orgname, w.m_warehouse_id, w.name AS warehousename, p.m_product_id, p.value, 
p.name AS productname, pc.m_product_category_id, pc.name AS categoryname, 
u.name AS uomname, sd.description, sd.qtyonhand FROM (SELECT 
max(sd_1.m_storage_detail_id) AS m_storage_detail_id, sd_1.m_product_id, 
sd_1.c_uom_id, l.m_warehouse_id, a.description, sum(sd_1.qtyonhand) AS 
qtyonhand FROM m_storage_detail sd_1 JOIN m_locator l ON sd_1.m_locator_id = 
l.m_locator_id JOIN m_attributesetinstance a ON sd_1.m_attributesetinstance_id 
= a.m_attributesetinstance_id WHERE COALESCE(sd_1.qtyonhand, 0) <> 0 OR 
COALESCE(sd_1.qtyorderonhand, 0) <> 0 GROUP BY sd_1.m_product_id, 
sd_1.c_uom_id, l.m_warehouse_id, a.description HAVING sum(sd_1.qtyonhand) <> 0 
OR sum(sd_1.qtyorderonhand) <> 0)
  sd JOIN m_product p ON sd.m_product_id = p.m_product_id JOIN 
m_product_category pc ON p.m_product_category_id = pc.m_product_category_id 
JOIN m_warehouse w ON sd.m_warehouse_id = w.m_warehouse_id JOIN ad_org o ON 
w.ad_org_id = o.ad_org_id JOIN c_uom u ON sd.c_uom_id = u.c_uom_id WHERE 
p.isactive = 'Y' AND p.isstocked = 'Y']]></view>
+  </database>
diff -r bbfa7b5fc9dc -r ab62853b9b6c 
modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_COLUMN.xml
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ 
b/modules/org.openbravo.client.widgets/src-db/database/sourcedata/AD_COLUMN.xml 
    Mon Oct 10 17:12:47 2016 +0200
@@ -0,0 +1,719 @@
+<?xml version='1.0' encoding='UTF-8'?>
+<data>
+<!--06D974D658C2455FB61B719781A2B637--><AD_COLUMN>
+<!--06D974D658C2455FB61B719781A2B637-->  
<AD_COLUMN_ID><![CDATA[06D974D658C2455FB61B719781A2B637]]></AD_COLUMN_ID>
+<!--06D974D658C2455FB61B719781A2B637-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--06D974D658C2455FB61B719781A2B637-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--06D974D658C2455FB61B719781A2B637-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--06D974D658C2455FB61B719781A2B637-->  <NAME><![CDATA[Client]]></NAME>
+<!--06D974D658C2455FB61B719781A2B637-->  <DESCRIPTION><![CDATA[Client for this 
installation.]]></DESCRIPTION>
+<!--06D974D658C2455FB61B719781A2B637-->  <HELP><![CDATA[A Client is a company 
or a legal entity. You cannot share data between Clients.]]></HELP>
+<!--06D974D658C2455FB61B719781A2B637-->  
<COLUMNNAME><![CDATA[AD_Client_ID]]></COLUMNNAME>
+<!--06D974D658C2455FB61B719781A2B637-->  
<AD_TABLE_ID><![CDATA[8729F059389F45EAA096F2CB9C36CC65]]></AD_TABLE_ID>
+<!--06D974D658C2455FB61B719781A2B637-->  
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--06D974D658C2455FB61B719781A2B637-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--06D974D658C2455FB61B719781A2B637-->  
<DEFAULTVALUE><![CDATA[@AD_CLIENT_ID@]]></DEFAULTVALUE>
+<!--06D974D658C2455FB61B719781A2B637-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--06D974D658C2455FB61B719781A2B637-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--06D974D658C2455FB61B719781A2B637-->  <SEQNO><![CDATA[140]]></SEQNO>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--06D974D658C2455FB61B719781A2B637-->  
<AD_ELEMENT_ID><![CDATA[102]]></AD_ELEMENT_ID>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--06D974D658C2455FB61B719781A2B637-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--06D974D658C2455FB61B719781A2B637-->  
<AD_MODULE_ID><![CDATA[FF8080812D842086012D844F3CC0003E]]></AD_MODULE_ID>
+<!--06D974D658C2455FB61B719781A2B637-->  <POSITION><![CDATA[14]]></POSITION>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--06D974D658C2455FB61B719781A2B637-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--06D974D658C2455FB61B719781A2B637-->  
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--06D974D658C2455FB61B719781A2B637-->  
<IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING>
+<!--06D974D658C2455FB61B719781A2B637-->  
<ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK>
+<!--06D974D658C2455FB61B719781A2B637--></AD_COLUMN>
+
+<!--06DDA74009444320B5CB67B3DE99E1FE--><AD_COLUMN>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<AD_COLUMN_ID><![CDATA[06DDA74009444320B5CB67B3DE99E1FE]]></AD_COLUMN_ID>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  <NAME><![CDATA[Product 
Category]]></NAME>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  <DESCRIPTION><![CDATA[A 
classification of items based on similar characteristics or 
attributes.]]></DESCRIPTION>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  <HELP><![CDATA[Identifies the 
category which this product belongs to.  Product categories are used for 
pricing.]]></HELP>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<COLUMNNAME><![CDATA[M_Product_Category_ID]]></COLUMNNAME>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<AD_TABLE_ID><![CDATA[8729F059389F45EAA096F2CB9C36CC65]]></AD_TABLE_ID>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  <SEQNO><![CDATA[90]]></SEQNO>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<AD_ELEMENT_ID><![CDATA[453]]></AD_ELEMENT_ID>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<AD_MODULE_ID><![CDATA[FF8080812D842086012D844F3CC0003E]]></AD_MODULE_ID>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  <POSITION><![CDATA[9]]></POSITION>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING>
+<!--06DDA74009444320B5CB67B3DE99E1FE-->  
<ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK>
+<!--06DDA74009444320B5CB67B3DE99E1FE--></AD_COLUMN>
+
+<!--0FE9B55261314ACEB7235297818D5B41--><AD_COLUMN>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<AD_COLUMN_ID><![CDATA[0FE9B55261314ACEB7235297818D5B41]]></AD_COLUMN_ID>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0FE9B55261314ACEB7235297818D5B41-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0FE9B55261314ACEB7235297818D5B41-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0FE9B55261314ACEB7235297818D5B41-->  <NAME><![CDATA[Search Key]]></NAME>
+<!--0FE9B55261314ACEB7235297818D5B41-->  <DESCRIPTION><![CDATA[A fast method 
for finding a particular record.]]></DESCRIPTION>
+<!--0FE9B55261314ACEB7235297818D5B41-->  <HELP><![CDATA[A search key allows 
for a fast method of finding a particular record. If you leave the search key 
empty, the system automatically creates a numeric number originating from a 
document sequence defined in the  "Document Sequence" window. The sequence 
naming convention follows a rule "DocumentNo_TableName", where TableName is the 
actual name of the database table (e.g. C_Order).
+
+Usually, company's internal identifiers for various records (products, 
customers, etc) are stored here.]]></HELP>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<COLUMNNAME><![CDATA[Value]]></COLUMNNAME>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<AD_TABLE_ID><![CDATA[8729F059389F45EAA096F2CB9C36CC65]]></AD_TABLE_ID>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<FIELDLENGTH><![CDATA[40]]></FIELDLENGTH>
+<!--0FE9B55261314ACEB7235297818D5B41-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--0FE9B55261314ACEB7235297818D5B41-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--0FE9B55261314ACEB7235297818D5B41-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<AD_ELEMENT_ID><![CDATA[620]]></AD_ELEMENT_ID>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<AD_MODULE_ID><![CDATA[FF8080812D842086012D844F3CC0003E]]></AD_MODULE_ID>
+<!--0FE9B55261314ACEB7235297818D5B41-->  <POSITION><![CDATA[5]]></POSITION>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--0FE9B55261314ACEB7235297818D5B41-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING>
+<!--0FE9B55261314ACEB7235297818D5B41-->  
<ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK>
+<!--0FE9B55261314ACEB7235297818D5B41--></AD_COLUMN>
+
+<!--13D633E6F18B4240B912581876AAF521--><AD_COLUMN>
+<!--13D633E6F18B4240B912581876AAF521-->  
<AD_COLUMN_ID><![CDATA[13D633E6F18B4240B912581876AAF521]]></AD_COLUMN_ID>
+<!--13D633E6F18B4240B912581876AAF521-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--13D633E6F18B4240B912581876AAF521-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--13D633E6F18B4240B912581876AAF521-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--13D633E6F18B4240B912581876AAF521-->  <NAME><![CDATA[Updated By]]></NAME>
+<!--13D633E6F18B4240B912581876AAF521-->  <DESCRIPTION><![CDATA[User who 
updated this records]]></DESCRIPTION>
+<!--13D633E6F18B4240B912581876AAF521-->  <HELP><![CDATA[The Updated By field 
indicates the user who updated this record.]]></HELP>
+<!--13D633E6F18B4240B912581876AAF521-->  
<COLUMNNAME><![CDATA[Updatedby]]></COLUMNNAME>
+<!--13D633E6F18B4240B912581876AAF521-->  
<AD_TABLE_ID><![CDATA[8729F059389F45EAA096F2CB9C36CC65]]></AD_TABLE_ID>
+<!--13D633E6F18B4240B912581876AAF521-->  
<AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--13D633E6F18B4240B912581876AAF521-->  
<FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--13D633E6F18B4240B912581876AAF521-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--13D633E6F18B4240B912581876AAF521-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--13D633E6F18B4240B912581876AAF521-->  <SEQNO><![CDATA[190]]></SEQNO>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--13D633E6F18B4240B912581876AAF521-->  
<AD_ELEMENT_ID><![CDATA[608]]></AD_ELEMENT_ID>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--13D633E6F18B4240B912581876AAF521-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--13D633E6F18B4240B912581876AAF521-->  
<AD_MODULE_ID><![CDATA[FF8080812D842086012D844F3CC0003E]]></AD_MODULE_ID>
+<!--13D633E6F18B4240B912581876AAF521-->  <POSITION><![CDATA[19]]></POSITION>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--13D633E6F18B4240B912581876AAF521-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--13D633E6F18B4240B912581876AAF521-->  
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--13D633E6F18B4240B912581876AAF521-->  
<IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING>
+<!--13D633E6F18B4240B912581876AAF521-->  
<ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK>
+<!--13D633E6F18B4240B912581876AAF521--></AD_COLUMN>
+
+<!--21B675B173D34598B4E21FFC80531EF7--><AD_COLUMN>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<AD_COLUMN_ID><![CDATA[21B675B173D34598B4E21FFC80531EF7]]></AD_COLUMN_ID>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--21B675B173D34598B4E21FFC80531EF7-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--21B675B173D34598B4E21FFC80531EF7-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--21B675B173D34598B4E21FFC80531EF7-->  <NAME><![CDATA[Quantity on 
Hand]]></NAME>
+<!--21B675B173D34598B4E21FFC80531EF7-->  <DESCRIPTION><![CDATA[On Hand 
Quantity]]></DESCRIPTION>
+<!--21B675B173D34598B4E21FFC80531EF7-->  <HELP><![CDATA[The On Hand Quantity 
indicates the quantity of a product that is on hand in a warehouse.]]></HELP>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<COLUMNNAME><![CDATA[Qtyonhand]]></COLUMNNAME>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<AD_TABLE_ID><![CDATA[8729F059389F45EAA096F2CB9C36CC65]]></AD_TABLE_ID>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--21B675B173D34598B4E21FFC80531EF7-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--21B675B173D34598B4E21FFC80531EF7-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--21B675B173D34598B4E21FFC80531EF7-->  <SEQNO><![CDATA[110]]></SEQNO>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<AD_ELEMENT_ID><![CDATA[530]]></AD_ELEMENT_ID>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<AD_MODULE_ID><![CDATA[FF8080812D842086012D844F3CC0003E]]></AD_MODULE_ID>
+<!--21B675B173D34598B4E21FFC80531EF7-->  <POSITION><![CDATA[11]]></POSITION>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--21B675B173D34598B4E21FFC80531EF7-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING>
+<!--21B675B173D34598B4E21FFC80531EF7-->  
<ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK>
+<!--21B675B173D34598B4E21FFC80531EF7--></AD_COLUMN>
+
+<!--2A299D4DCE1043529CFBFC933DA2A4FD--><AD_COLUMN>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<AD_COLUMN_ID><![CDATA[2A299D4DCE1043529CFBFC933DA2A4FD]]></AD_COLUMN_ID>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  <NAME><![CDATA[Warehouse 
Name]]></NAME>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<COLUMNNAME><![CDATA[Warehousename]]></COLUMNNAME>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<AD_TABLE_ID><![CDATA[8729F059389F45EAA096F2CB9C36CC65]]></AD_TABLE_ID>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<AD_ELEMENT_ID><![CDATA[83F192931C7142E7872BFE1428EE5C66]]></AD_ELEMENT_ID>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<AD_MODULE_ID><![CDATA[FF8080812D842086012D844F3CC0003E]]></AD_MODULE_ID>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  <POSITION><![CDATA[3]]></POSITION>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD-->  
<ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK>
+<!--2A299D4DCE1043529CFBFC933DA2A4FD--></AD_COLUMN>
+
+<!--39C7E523BBED43C5846CCE4F5AB02739--><AD_COLUMN>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<AD_COLUMN_ID><![CDATA[39C7E523BBED43C5846CCE4F5AB02739]]></AD_COLUMN_ID>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  <NAME><![CDATA[Product Name]]></NAME>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<COLUMNNAME><![CDATA[Productname]]></COLUMNNAME>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<AD_TABLE_ID><![CDATA[8729F059389F45EAA096F2CB9C36CC65]]></AD_TABLE_ID>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<AD_ELEMENT_ID><![CDATA[C30C07EF67E648AB9DDCA74E8449B866]]></AD_ELEMENT_ID>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<AD_MODULE_ID><![CDATA[FF8080812D842086012D844F3CC0003E]]></AD_MODULE_ID>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  <POSITION><![CDATA[6]]></POSITION>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING>
+<!--39C7E523BBED43C5846CCE4F5AB02739-->  
<ALLOWED_CROSS_ORG_LINK><![CDATA[N]]></ALLOWED_CROSS_ORG_LINK>
+<!--39C7E523BBED43C5846CCE4F5AB02739--></AD_COLUMN>
+
+<!--54916FD9A1EC4090B2E6877E1A78B968--><AD_COLUMN>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  
<AD_COLUMN_ID><![CDATA[54916FD9A1EC4090B2E6877E1A78B968]]></AD_COLUMN_ID>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  <NAME><![CDATA[Description]]></NAME>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  <DESCRIPTION><![CDATA[A space to 
write additional related information.]]></DESCRIPTION>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  <HELP><![CDATA[A description is 
limited to 255 characters.]]></HELP>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  
<COLUMNNAME><![CDATA[Description]]></COLUMNNAME>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  
<AD_TABLE_ID><![CDATA[8729F059389F45EAA096F2CB9C36CC65]]></AD_TABLE_ID>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  
<AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  
<FIELDLENGTH><![CDATA[255]]></FIELDLENGTH>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  
<ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  
<ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  
<ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  <SEQNO><![CDATA[120]]></SEQNO>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  
<ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  
<ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--54916FD9A1EC4090B2E6877E1A78B968-->  
<ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most 
engaging tech sites, SlashDot.org! http://sdm.link/slashdot
_______________________________________________
Openbravo-commits mailing list
Openbravo-commits@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to