Fixed issue 20203.Implement UOM Type, add weight UOM to Product.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Mon, 15 Jul 2013 13:49:08 +0200
changeset 20745 4708a704c192
parent 20744 43aac1aeed77
child 20746 d7795b2b29fe
Fixed issue 20203.Implement UOM Type, add weight UOM to Product.
referencedata/standard/Unit_of_Measure.xml
src-db/database/model/tables/C_UOM.xml
src-db/database/model/tables/M_PRODUCT.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_DATASET.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_FIELD.xml
src-db/database/sourcedata/AD_REFERENCE.xml
src-db/database/sourcedata/AD_REF_LIST.xml
src-db/database/sourcedata/AD_REF_TABLE.xml
--- a/referencedata/standard/Unit_of_Measure.xml	Tue Jul 16 06:13:05 2013 +0200
+++ b/referencedata/standard/Unit_of_Measure.xml	Mon Jul 15 13:49:08 2013 +0200
@@ -11,6 +11,7 @@
     <costingPrecision>4</costingPrecision>
     <default>true</default>
     <breakdown>false</breakdown>
+    <uOMType xsi:nil="true"/>
   </UOM>
   <UOM id="101" identifier="Hour">
     <id>101</id>
@@ -23,6 +24,7 @@
     <costingPrecision>2</costingPrecision>
     <default>false</default>
     <breakdown>false</breakdown>
+    <uOMType>T</uOMType>
   </UOM>
   <UOM id="102" identifier="Day">
     <id>102</id>
@@ -35,6 +37,7 @@
     <costingPrecision>2</costingPrecision>
     <default>false</default>
     <breakdown>false</breakdown>
+    <uOMType>T</uOMType>
   </UOM>
   <UOM id="103" identifier="Minutes">
     <id>103</id>
@@ -47,6 +50,7 @@
     <costingPrecision>0</costingPrecision>
     <default>false</default>
     <breakdown>false</breakdown>
+    <uOMType>T</uOMType>
   </UOM>
   <UOM id="104" identifier="Labour day">
     <id>104</id>
@@ -59,6 +63,7 @@
     <costingPrecision>2</costingPrecision>
     <default>false</default>
     <breakdown>false</breakdown>
+    <uOMType xsi:nil="true"/>
   </UOM>
   <UOM id="105" identifier="Week">
     <id>105</id>
@@ -71,6 +76,7 @@
     <costingPrecision>2</costingPrecision>
     <default>false</default>
     <breakdown>false</breakdown>
+    <uOMType>T</uOMType>
   </UOM>
   <UOM id="106" identifier="Month">
     <id>106</id>
@@ -83,6 +89,7 @@
     <costingPrecision>2</costingPrecision>
     <default>false</default>
     <breakdown>false</breakdown>
+    <uOMType>T</uOMType>
   </UOM>
   <UOM id="107" identifier="Labour month">
     <id>107</id>
@@ -95,6 +102,7 @@
     <costingPrecision>2</costingPrecision>
     <default>false</default>
     <breakdown>false</breakdown>
+    <uOMType xsi:nil="true"/>
   </UOM>
   <UOM id="108" identifier="Year">
     <id>108</id>
@@ -107,6 +115,7 @@
     <costingPrecision>2</costingPrecision>
     <default>false</default>
     <breakdown>false</breakdown>
+    <uOMType>T</uOMType>
   </UOM>
   <UOM id="2EBC93C05D75431E9EEFB29CEC76F244" identifier="Ounce">
     <id>2EBC93C05D75431E9EEFB29CEC76F244</id>
@@ -119,6 +128,7 @@
     <costingPrecision>2</costingPrecision>
     <default>false</default>
     <breakdown>false</breakdown>
+    <uOMType>W</uOMType>
   </UOM>
   <UOM id="6FA87C4EE1FD4C86940A5F2E47C429DA" identifier="Pound">
     <id>6FA87C4EE1FD4C86940A5F2E47C429DA</id>
@@ -131,6 +141,7 @@
     <costingPrecision>2</costingPrecision>
     <default>false</default>
     <breakdown>false</breakdown>
+    <uOMType>W</uOMType>
   </UOM>
   <UOM id="72BA247D31F745F3AF11F74A5E2CCBEF" identifier="Kilogram">
     <id>72BA247D31F745F3AF11F74A5E2CCBEF</id>
@@ -143,5 +154,6 @@
     <costingPrecision>2</costingPrecision>
     <default>false</default>
     <breakdown>false</breakdown>
+    <uOMType>W</uOMType>
   </UOM>
 </ob:Openbravo>
--- a/src-db/database/model/tables/C_UOM.xml	Tue Jul 16 06:13:05 2013 +0200
+++ b/src-db/database/model/tables/C_UOM.xml	Mon Jul 15 13:49:08 2013 +0200
@@ -65,6 +65,10 @@
         <default><![CDATA[N]]></default>
         <onCreateDefault/>
       </column>
+      <column name="UOM_TYPE" primaryKey="false" required="false" type="VARCHAR" size="60" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_CLIENT" name="C_UOMCLIENT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
--- a/src-db/database/model/tables/M_PRODUCT.xml	Tue Jul 16 06:13:05 2013 +0200
+++ b/src-db/database/model/tables/M_PRODUCT.xml	Mon Jul 15 13:49:08 2013 +0200
@@ -321,6 +321,10 @@
         <default><![CDATA[N]]></default>
         <onCreateDefault/>
       </column>
+      <column name="C_UOM_WEIGHT_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_ORG" name="AD_ORG_MPRODUCT">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
@@ -369,6 +373,9 @@
       <foreign-key foreignTable="S_RESOURCE" name="M_PRODUCT_S_RESOURCE">
         <reference local="S_RESOURCE_ID" foreign="S_RESOURCE_ID"/>
       </foreign-key>
+      <foreign-key foreignTable="C_UOM" name="M_PRODUCT_WEIGHT_UOM">
+        <reference local="C_UOM_WEIGHT_ID" foreign="C_UOM_ID"/>
+      </foreign-key>
       <foreign-key foreignTable="MA_PROCESSPLAN" name="MA_PROCESSPLAN_MPRODUCT">
         <reference local="MA_PROCESSPLAN_ID" foreign="MA_PROCESSPLAN_ID"/>
       </foreign-key>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Tue Jul 16 06:13:05 2013 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Mon Jul 15 13:49:08 2013 +0200
@@ -32841,7 +32841,7 @@
 <!--2347-->  <COLUMNNAME><![CDATA[C_UOM_Volume_ID]]></COLUMNNAME>
 <!--2347-->  <AD_TABLE_ID><![CDATA[227]]></AD_TABLE_ID>
 <!--2347-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
-<!--2347-->  <AD_REFERENCE_VALUE_ID><![CDATA[114]]></AD_REFERENCE_VALUE_ID>
+<!--2347-->  <AD_REFERENCE_VALUE_ID><![CDATA[2FE25E4AF395479EB8BAB0539A829C28]]></AD_REFERENCE_VALUE_ID>
 <!--2347-->  <FIELDLENGTH><![CDATA[22]]></FIELDLENGTH>
 <!--2347-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--2347-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -32876,7 +32876,7 @@
 <!--2348-->  <COLUMNNAME><![CDATA[C_UOM_Weight_ID]]></COLUMNNAME>
 <!--2348-->  <AD_TABLE_ID><![CDATA[227]]></AD_TABLE_ID>
 <!--2348-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
-<!--2348-->  <AD_REFERENCE_VALUE_ID><![CDATA[114]]></AD_REFERENCE_VALUE_ID>
+<!--2348-->  <AD_REFERENCE_VALUE_ID><![CDATA[C3ED971A900A414B8A0A937B442374E1]]></AD_REFERENCE_VALUE_ID>
 <!--2348-->  <FIELDLENGTH><![CDATA[22]]></FIELDLENGTH>
 <!--2348-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--2348-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -32911,7 +32911,7 @@
 <!--2349-->  <COLUMNNAME><![CDATA[C_UOM_Length_ID]]></COLUMNNAME>
 <!--2349-->  <AD_TABLE_ID><![CDATA[227]]></AD_TABLE_ID>
 <!--2349-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
-<!--2349-->  <AD_REFERENCE_VALUE_ID><![CDATA[114]]></AD_REFERENCE_VALUE_ID>
+<!--2349-->  <AD_REFERENCE_VALUE_ID><![CDATA[9413570F6240406385FB633C7A9CC283]]></AD_REFERENCE_VALUE_ID>
 <!--2349-->  <FIELDLENGTH><![CDATA[22]]></FIELDLENGTH>
 <!--2349-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--2349-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -32946,7 +32946,7 @@
 <!--2350-->  <COLUMNNAME><![CDATA[C_UOM_Time_ID]]></COLUMNNAME>
 <!--2350-->  <AD_TABLE_ID><![CDATA[227]]></AD_TABLE_ID>
 <!--2350-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
-<!--2350-->  <AD_REFERENCE_VALUE_ID><![CDATA[114]]></AD_REFERENCE_VALUE_ID>
+<!--2350-->  <AD_REFERENCE_VALUE_ID><![CDATA[AFA80A98B3C6469EA15ECB8A0011A79F]]></AD_REFERENCE_VALUE_ID>
 <!--2350-->  <FIELDLENGTH><![CDATA[22]]></FIELDLENGTH>
 <!--2350-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--2350-->  <ISPARENT><![CDATA[N]]></ISPARENT>
@@ -311959,6 +311959,76 @@
 <!--E16BB81D95984DF08700A8940683A636-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--E16BB81D95984DF08700A8940683A636--></AD_COLUMN>
 
+<!--E189621A812DE4C5E040007F01004561--><AD_COLUMN>
+<!--E189621A812DE4C5E040007F01004561-->  <AD_COLUMN_ID><![CDATA[E189621A812DE4C5E040007F01004561]]></AD_COLUMN_ID>
+<!--E189621A812DE4C5E040007F01004561-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E189621A812DE4C5E040007F01004561-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E189621A812DE4C5E040007F01004561-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E189621A812DE4C5E040007F01004561-->  <NAME><![CDATA[UOM Type]]></NAME>
+<!--E189621A812DE4C5E040007F01004561-->  <COLUMNNAME><![CDATA[UOM_Type]]></COLUMNNAME>
+<!--E189621A812DE4C5E040007F01004561-->  <AD_TABLE_ID><![CDATA[146]]></AD_TABLE_ID>
+<!--E189621A812DE4C5E040007F01004561-->  <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID>
+<!--E189621A812DE4C5E040007F01004561-->  <AD_REFERENCE_VALUE_ID><![CDATA[FC3E8E2652184032A86BE0F760A97B90]]></AD_REFERENCE_VALUE_ID>
+<!--E189621A812DE4C5E040007F01004561-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--E189621A812DE4C5E040007F01004561-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--E189621A812DE4C5E040007F01004561-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--E189621A812DE4C5E040007F01004561-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--E189621A812DE4C5E040007F01004561-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--E189621A812DE4C5E040007F01004561-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--E189621A812DE4C5E040007F01004561-->  <SEQNO><![CDATA[21]]></SEQNO>
+<!--E189621A812DE4C5E040007F01004561-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--E189621A812DE4C5E040007F01004561-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E189621A812DE4C5E040007F01004561-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--E189621A812DE4C5E040007F01004561-->  <AD_ELEMENT_ID><![CDATA[E189C54FFCD19351E040007F01004C07]]></AD_ELEMENT_ID>
+<!--E189621A812DE4C5E040007F01004561-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--E189621A812DE4C5E040007F01004561-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--E189621A812DE4C5E040007F01004561-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--E189621A812DE4C5E040007F01004561-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--E189621A812DE4C5E040007F01004561-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E189621A812DE4C5E040007F01004561-->  <POSITION><![CDATA[18]]></POSITION>
+<!--E189621A812DE4C5E040007F01004561-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--E189621A812DE4C5E040007F01004561-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--E189621A812DE4C5E040007F01004561-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--E189621A812DE4C5E040007F01004561-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--E189621A812DE4C5E040007F01004561-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--E189621A812DE4C5E040007F01004561--></AD_COLUMN>
+
+<!--E189C54FFCC69351E040007F01004C07--><AD_COLUMN>
+<!--E189C54FFCC69351E040007F01004C07-->  <AD_COLUMN_ID><![CDATA[E189C54FFCC69351E040007F01004C07]]></AD_COLUMN_ID>
+<!--E189C54FFCC69351E040007F01004C07-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E189C54FFCC69351E040007F01004C07-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E189C54FFCC69351E040007F01004C07-->  <NAME><![CDATA[UOM for Weight]]></NAME>
+<!--E189C54FFCC69351E040007F01004C07-->  <DESCRIPTION><![CDATA[Standard Unit of Measure for Weight]]></DESCRIPTION>
+<!--E189C54FFCC69351E040007F01004C07-->  <HELP><![CDATA[The Standard UOM for Weight indicates the UOM to use for products referenced by weight in a document.]]></HELP>
+<!--E189C54FFCC69351E040007F01004C07-->  <COLUMNNAME><![CDATA[C_Uom_Weight_ID]]></COLUMNNAME>
+<!--E189C54FFCC69351E040007F01004C07-->  <AD_TABLE_ID><![CDATA[208]]></AD_TABLE_ID>
+<!--E189C54FFCC69351E040007F01004C07-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--E189C54FFCC69351E040007F01004C07-->  <AD_REFERENCE_VALUE_ID><![CDATA[C3ED971A900A414B8A0A937B442374E1]]></AD_REFERENCE_VALUE_ID>
+<!--E189C54FFCC69351E040007F01004C07-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--E189C54FFCC69351E040007F01004C07-->  <SEQNO><![CDATA[540]]></SEQNO>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--E189C54FFCC69351E040007F01004C07-->  <AD_ELEMENT_ID><![CDATA[221]]></AD_ELEMENT_ID>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--E189C54FFCC69351E040007F01004C07-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--E189C54FFCC69351E040007F01004C07-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E189C54FFCC69351E040007F01004C07-->  <POSITION><![CDATA[82]]></POSITION>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--E189C54FFCC69351E040007F01004C07-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--E189C54FFCC69351E040007F01004C07-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--E189C54FFCC69351E040007F01004C07-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--E189C54FFCC69351E040007F01004C07--></AD_COLUMN>
+
 <!--E1A5DA80AD1E4658ACA1429046243346--><AD_COLUMN>
 <!--E1A5DA80AD1E4658ACA1429046243346-->  <AD_COLUMN_ID><![CDATA[E1A5DA80AD1E4658ACA1429046243346]]></AD_COLUMN_ID>
 <!--E1A5DA80AD1E4658ACA1429046243346-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_DATASET.xml	Tue Jul 16 06:13:05 2013 +0200
+++ b/src-db/database/sourcedata/AD_DATASET.xml	Mon Jul 15 13:49:08 2013 +0200
@@ -86,7 +86,7 @@
 <!--575BE80AA7864187966A3FCFA1B1854D-->  <EXPORT><![CDATA[N]]></EXPORT>
 <!--575BE80AA7864187966A3FCFA1B1854D-->  <ACCESSLEVEL><![CDATA[4]]></ACCESSLEVEL>
 <!--575BE80AA7864187966A3FCFA1B1854D-->  <EXPORTALLOWED><![CDATA[Y]]></EXPORTALLOWED>
-<!--575BE80AA7864187966A3FCFA1B1854D-->  <CHECKSUM><![CDATA[308697733150044261045374981032369053451]]></CHECKSUM>
+<!--575BE80AA7864187966A3FCFA1B1854D-->  <CHECKSUM><![CDATA[49710530986698124763818046900153842955]]></CHECKSUM>
 <!--575BE80AA7864187966A3FCFA1B1854D--></AD_DATASET>
 
 <!--D81C5C810AEF47C690E4F688ABC8AAC8--><AD_DATASET>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Tue Jul 16 06:13:05 2013 +0200
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Mon Jul 15 13:49:08 2013 +0200
@@ -30978,6 +30978,18 @@
 <!--E124977230194F12AF7E99B0097AB3D2-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--E124977230194F12AF7E99B0097AB3D2--></AD_ELEMENT>
 
+<!--E189C54FFCD19351E040007F01004C07--><AD_ELEMENT>
+<!--E189C54FFCD19351E040007F01004C07-->  <AD_ELEMENT_ID><![CDATA[E189C54FFCD19351E040007F01004C07]]></AD_ELEMENT_ID>
+<!--E189C54FFCD19351E040007F01004C07-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E189C54FFCD19351E040007F01004C07-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E189C54FFCD19351E040007F01004C07-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E189C54FFCD19351E040007F01004C07-->  <COLUMNNAME><![CDATA[UOM_Type]]></COLUMNNAME>
+<!--E189C54FFCD19351E040007F01004C07-->  <NAME><![CDATA[UOM Type]]></NAME>
+<!--E189C54FFCD19351E040007F01004C07-->  <PRINTNAME><![CDATA[UOM Type]]></PRINTNAME>
+<!--E189C54FFCD19351E040007F01004C07-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E189C54FFCD19351E040007F01004C07-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--E189C54FFCD19351E040007F01004C07--></AD_ELEMENT>
+
 <!--E38B247A2EEF426C9908594598D1559B--><AD_ELEMENT>
 <!--E38B247A2EEF426C9908594598D1559B-->  <AD_ELEMENT_ID><![CDATA[E38B247A2EEF426C9908594598D1559B]]></AD_ELEMENT_ID>
 <!--E38B247A2EEF426C9908594598D1559B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Tue Jul 16 06:13:05 2013 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Mon Jul 15 13:49:08 2013 +0200
@@ -270498,6 +270498,61 @@
 <!--E156213A6A2A465DB1380AC7AFA234E8-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--E156213A6A2A465DB1380AC7AFA234E8--></AD_FIELD>
 
+<!--E189C6868046E770E040007F01004C0E--><AD_FIELD>
+<!--E189C6868046E770E040007F01004C0E-->  <AD_FIELD_ID><![CDATA[E189C6868046E770E040007F01004C0E]]></AD_FIELD_ID>
+<!--E189C6868046E770E040007F01004C0E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E189C6868046E770E040007F01004C0E-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E189C6868046E770E040007F01004C0E-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E189C6868046E770E040007F01004C0E-->  <NAME><![CDATA[UOM for Weight]]></NAME>
+<!--E189C6868046E770E040007F01004C0E-->  <DESCRIPTION><![CDATA[Standard Unit of Measure for Weight]]></DESCRIPTION>
+<!--E189C6868046E770E040007F01004C0E-->  <HELP><![CDATA[The Standard UOM for Weight indicates the UOM to use for products referenced by weight in a document.]]></HELP>
+<!--E189C6868046E770E040007F01004C0E-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E189C6868046E770E040007F01004C0E-->  <AD_TAB_ID><![CDATA[180]]></AD_TAB_ID>
+<!--E189C6868046E770E040007F01004C0E-->  <AD_COLUMN_ID><![CDATA[E189C54FFCC69351E040007F01004C07]]></AD_COLUMN_ID>
+<!--E189C6868046E770E040007F01004C0E-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--E189C6868046E770E040007F01004C0E-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--E189C6868046E770E040007F01004C0E-->  <DISPLAYLOGIC><![CDATA[@IsSummary@='N' & @ProductType@='I']]></DISPLAYLOGIC>
+<!--E189C6868046E770E040007F01004C0E-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--E189C6868046E770E040007F01004C0E-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--E189C6868046E770E040007F01004C0E-->  <SEQNO><![CDATA[132]]></SEQNO>
+<!--E189C6868046E770E040007F01004C0E-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--E189C6868046E770E040007F01004C0E-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--E189C6868046E770E040007F01004C0E-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E189C6868046E770E040007F01004C0E-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--E189C6868046E770E040007F01004C0E-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--E189C6868046E770E040007F01004C0E-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E189C6868046E770E040007F01004C0E-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--E189C6868046E770E040007F01004C0E-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--E189C6868046E770E040007F01004C0E-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--E189C6868046E770E040007F01004C0E-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--E189C6868046E770E040007F01004C0E--></AD_FIELD>
+
+<!--E18B2EB9858CBD4AE040007F0100567F--><AD_FIELD>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <AD_FIELD_ID><![CDATA[E18B2EB9858CBD4AE040007F0100567F]]></AD_FIELD_ID>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <NAME><![CDATA[UOM Type]]></NAME>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <AD_TAB_ID><![CDATA[133]]></AD_TAB_ID>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <AD_COLUMN_ID><![CDATA[E189621A812DE4C5E040007F01004561]]></AD_COLUMN_ID>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <SEQNO><![CDATA[65]]></SEQNO>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--E18B2EB9858CBD4AE040007F0100567F-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--E18B2EB9858CBD4AE040007F0100567F--></AD_FIELD>
+
 <!--E18E37825048408EB756DC24D30A48C5--><AD_FIELD>
 <!--E18E37825048408EB756DC24D30A48C5-->  <AD_FIELD_ID><![CDATA[E18E37825048408EB756DC24D30A48C5]]></AD_FIELD_ID>
 <!--E18E37825048408EB756DC24D30A48C5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REFERENCE.xml	Tue Jul 16 06:13:05 2013 +0200
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml	Mon Jul 15 13:49:08 2013 +0200
@@ -4555,6 +4555,18 @@
 <!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--2F57E5B5EBF44E0A9D45492DECBD3CC1--></AD_REFERENCE>
 
+<!--2FE25E4AF395479EB8BAB0539A829C28--><AD_REFERENCE>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <AD_REFERENCE_ID><![CDATA[2FE25E4AF395479EB8BAB0539A829C28]]></AD_REFERENCE_ID>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <NAME><![CDATA[UOM Volume]]></NAME>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <PARENTREFERENCE_ID><![CDATA[18]]></PARENTREFERENCE_ID>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--2FE25E4AF395479EB8BAB0539A829C28--></AD_REFERENCE>
+
 <!--368E5F32B443454093D14D4E0AD44E13--><AD_REFERENCE>
 <!--368E5F32B443454093D14D4E0AD44E13-->  <AD_REFERENCE_ID><![CDATA[368E5F32B443454093D14D4E0AD44E13]]></AD_REFERENCE_ID>
 <!--368E5F32B443454093D14D4E0AD44E13-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -5398,6 +5410,18 @@
 <!--8FAA2F7B2F67456780B3551099E13917-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--8FAA2F7B2F67456780B3551099E13917--></AD_REFERENCE>
 
+<!--9413570F6240406385FB633C7A9CC283--><AD_REFERENCE>
+<!--9413570F6240406385FB633C7A9CC283-->  <AD_REFERENCE_ID><![CDATA[9413570F6240406385FB633C7A9CC283]]></AD_REFERENCE_ID>
+<!--9413570F6240406385FB633C7A9CC283-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9413570F6240406385FB633C7A9CC283-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9413570F6240406385FB633C7A9CC283-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9413570F6240406385FB633C7A9CC283-->  <NAME><![CDATA[UOM Length]]></NAME>
+<!--9413570F6240406385FB633C7A9CC283-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9413570F6240406385FB633C7A9CC283-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--9413570F6240406385FB633C7A9CC283-->  <PARENTREFERENCE_ID><![CDATA[18]]></PARENTREFERENCE_ID>
+<!--9413570F6240406385FB633C7A9CC283-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--9413570F6240406385FB633C7A9CC283--></AD_REFERENCE>
+
 <!--956E8F5C98A345AFBCCDD12E49A9074D--><AD_REFERENCE>
 <!--956E8F5C98A345AFBCCDD12E49A9074D-->  <AD_REFERENCE_ID><![CDATA[956E8F5C98A345AFBCCDD12E49A9074D]]></AD_REFERENCE_ID>
 <!--956E8F5C98A345AFBCCDD12E49A9074D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -5578,6 +5602,18 @@
 <!--AE201981DDC0467FB59F64CA978C749F-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--AE201981DDC0467FB59F64CA978C749F--></AD_REFERENCE>
 
+<!--AFA80A98B3C6469EA15ECB8A0011A79F--><AD_REFERENCE>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <AD_REFERENCE_ID><![CDATA[AFA80A98B3C6469EA15ECB8A0011A79F]]></AD_REFERENCE_ID>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <NAME><![CDATA[UOM Time]]></NAME>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <PARENTREFERENCE_ID><![CDATA[18]]></PARENTREFERENCE_ID>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F--></AD_REFERENCE>
+
 <!--B7E66794F4BA46C3ADB2CBD013252AA6--><AD_REFERENCE>
 <!--B7E66794F4BA46C3ADB2CBD013252AA6-->  <AD_REFERENCE_ID><![CDATA[B7E66794F4BA46C3ADB2CBD013252AA6]]></AD_REFERENCE_ID>
 <!--B7E66794F4BA46C3ADB2CBD013252AA6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -5664,6 +5700,18 @@
 <!--C3C19DE8AB3B42E78748E20D986FBBC9-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--C3C19DE8AB3B42E78748E20D986FBBC9--></AD_REFERENCE>
 
+<!--C3ED971A900A414B8A0A937B442374E1--><AD_REFERENCE>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <AD_REFERENCE_ID><![CDATA[C3ED971A900A414B8A0A937B442374E1]]></AD_REFERENCE_ID>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <NAME><![CDATA[UOM Weight]]></NAME>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <PARENTREFERENCE_ID><![CDATA[18]]></PARENTREFERENCE_ID>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--C3ED971A900A414B8A0A937B442374E1--></AD_REFERENCE>
+
 <!--C5C21C28B39E4683A91779F16C112E40--><AD_REFERENCE>
 <!--C5C21C28B39E4683A91779F16C112E40-->  <AD_REFERENCE_ID><![CDATA[C5C21C28B39E4683A91779F16C112E40]]></AD_REFERENCE_ID>
 <!--C5C21C28B39E4683A91779F16C112E40-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -6015,6 +6063,18 @@
 <!--FBC599C796664DD49AD002C61DAFF813-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--FBC599C796664DD49AD002C61DAFF813--></AD_REFERENCE>
 
+<!--FC3E8E2652184032A86BE0F760A97B90--><AD_REFERENCE>
+<!--FC3E8E2652184032A86BE0F760A97B90-->  <AD_REFERENCE_ID><![CDATA[FC3E8E2652184032A86BE0F760A97B90]]></AD_REFERENCE_ID>
+<!--FC3E8E2652184032A86BE0F760A97B90-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FC3E8E2652184032A86BE0F760A97B90-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FC3E8E2652184032A86BE0F760A97B90-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FC3E8E2652184032A86BE0F760A97B90-->  <NAME><![CDATA[UOM Types]]></NAME>
+<!--FC3E8E2652184032A86BE0F760A97B90-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FC3E8E2652184032A86BE0F760A97B90-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--FC3E8E2652184032A86BE0F760A97B90-->  <PARENTREFERENCE_ID><![CDATA[17]]></PARENTREFERENCE_ID>
+<!--FC3E8E2652184032A86BE0F760A97B90-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--FC3E8E2652184032A86BE0F760A97B90--></AD_REFERENCE>
+
 <!--FC98D43996374909B1AAC0197BBE95BA--><AD_REFERENCE>
 <!--FC98D43996374909B1AAC0197BBE95BA-->  <AD_REFERENCE_ID><![CDATA[FC98D43996374909B1AAC0197BBE95BA]]></AD_REFERENCE_ID>
 <!--FC98D43996374909B1AAC0197BBE95BA-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REF_LIST.xml	Tue Jul 16 06:13:05 2013 +0200
+++ b/src-db/database/sourcedata/AD_REF_LIST.xml	Mon Jul 15 13:49:08 2013 +0200
@@ -9065,6 +9065,17 @@
 <!--4B320699808A4088930E96843DCBAF6D-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--4B320699808A4088930E96843DCBAF6D--></AD_REF_LIST>
 
+<!--4B3227BC63584401911AB9208DDB7978--><AD_REF_LIST>
+<!--4B3227BC63584401911AB9208DDB7978-->  <AD_REF_LIST_ID><![CDATA[4B3227BC63584401911AB9208DDB7978]]></AD_REF_LIST_ID>
+<!--4B3227BC63584401911AB9208DDB7978-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--4B3227BC63584401911AB9208DDB7978-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--4B3227BC63584401911AB9208DDB7978-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--4B3227BC63584401911AB9208DDB7978-->  <VALUE><![CDATA[W]]></VALUE>
+<!--4B3227BC63584401911AB9208DDB7978-->  <NAME><![CDATA[Weight]]></NAME>
+<!--4B3227BC63584401911AB9208DDB7978-->  <AD_REFERENCE_ID><![CDATA[FC3E8E2652184032A86BE0F760A97B90]]></AD_REFERENCE_ID>
+<!--4B3227BC63584401911AB9208DDB7978-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--4B3227BC63584401911AB9208DDB7978--></AD_REF_LIST>
+
 <!--4BED47D608B841EC8016441CFA05F2FA--><AD_REF_LIST>
 <!--4BED47D608B841EC8016441CFA05F2FA-->  <AD_REF_LIST_ID><![CDATA[4BED47D608B841EC8016441CFA05F2FA]]></AD_REF_LIST_ID>
 <!--4BED47D608B841EC8016441CFA05F2FA-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -9634,6 +9645,17 @@
 <!--748DF1663F76484993DE25043E4D0F04-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--748DF1663F76484993DE25043E4D0F04--></AD_REF_LIST>
 
+<!--74E2E8E4959342CAB71C5C59C3AEC4AC--><AD_REF_LIST>
+<!--74E2E8E4959342CAB71C5C59C3AEC4AC-->  <AD_REF_LIST_ID><![CDATA[74E2E8E4959342CAB71C5C59C3AEC4AC]]></AD_REF_LIST_ID>
+<!--74E2E8E4959342CAB71C5C59C3AEC4AC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--74E2E8E4959342CAB71C5C59C3AEC4AC-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--74E2E8E4959342CAB71C5C59C3AEC4AC-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--74E2E8E4959342CAB71C5C59C3AEC4AC-->  <VALUE><![CDATA[V]]></VALUE>
+<!--74E2E8E4959342CAB71C5C59C3AEC4AC-->  <NAME><![CDATA[Volume]]></NAME>
+<!--74E2E8E4959342CAB71C5C59C3AEC4AC-->  <AD_REFERENCE_ID><![CDATA[FC3E8E2652184032A86BE0F760A97B90]]></AD_REFERENCE_ID>
+<!--74E2E8E4959342CAB71C5C59C3AEC4AC-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--74E2E8E4959342CAB71C5C59C3AEC4AC--></AD_REF_LIST>
+
 <!--7574AC93C7DA4C068DAED8221325F76C--><AD_REF_LIST>
 <!--7574AC93C7DA4C068DAED8221325F76C-->  <AD_REF_LIST_ID><![CDATA[7574AC93C7DA4C068DAED8221325F76C]]></AD_REF_LIST_ID>
 <!--7574AC93C7DA4C068DAED8221325F76C-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -11296,6 +11318,17 @@
 <!--C498ACCF3EC1456E9B7F3223A951C6C9-->  <SEQNO><![CDATA[30]]></SEQNO>
 <!--C498ACCF3EC1456E9B7F3223A951C6C9--></AD_REF_LIST>
 
+<!--C51B76C267CA4E098F5558F3E0BAC2C2--><AD_REF_LIST>
+<!--C51B76C267CA4E098F5558F3E0BAC2C2-->  <AD_REF_LIST_ID><![CDATA[C51B76C267CA4E098F5558F3E0BAC2C2]]></AD_REF_LIST_ID>
+<!--C51B76C267CA4E098F5558F3E0BAC2C2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C51B76C267CA4E098F5558F3E0BAC2C2-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C51B76C267CA4E098F5558F3E0BAC2C2-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C51B76C267CA4E098F5558F3E0BAC2C2-->  <VALUE><![CDATA[L]]></VALUE>
+<!--C51B76C267CA4E098F5558F3E0BAC2C2-->  <NAME><![CDATA[Length]]></NAME>
+<!--C51B76C267CA4E098F5558F3E0BAC2C2-->  <AD_REFERENCE_ID><![CDATA[FC3E8E2652184032A86BE0F760A97B90]]></AD_REFERENCE_ID>
+<!--C51B76C267CA4E098F5558F3E0BAC2C2-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--C51B76C267CA4E098F5558F3E0BAC2C2--></AD_REF_LIST>
+
 <!--C6756C85CF3F4AFBB78DFB994952548A--><AD_REF_LIST>
 <!--C6756C85CF3F4AFBB78DFB994952548A-->  <AD_REF_LIST_ID><![CDATA[C6756C85CF3F4AFBB78DFB994952548A]]></AD_REF_LIST_ID>
 <!--C6756C85CF3F4AFBB78DFB994952548A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -11763,6 +11796,17 @@
 <!--DD0F27071A3645A687431A4669A9AE86-->  <SEQNO><![CDATA[50]]></SEQNO>
 <!--DD0F27071A3645A687431A4669A9AE86--></AD_REF_LIST>
 
+<!--DD3B45F6E92E41458FBFFEF977EEE480--><AD_REF_LIST>
+<!--DD3B45F6E92E41458FBFFEF977EEE480-->  <AD_REF_LIST_ID><![CDATA[DD3B45F6E92E41458FBFFEF977EEE480]]></AD_REF_LIST_ID>
+<!--DD3B45F6E92E41458FBFFEF977EEE480-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--DD3B45F6E92E41458FBFFEF977EEE480-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--DD3B45F6E92E41458FBFFEF977EEE480-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--DD3B45F6E92E41458FBFFEF977EEE480-->  <VALUE><![CDATA[A]]></VALUE>
+<!--DD3B45F6E92E41458FBFFEF977EEE480-->  <NAME><![CDATA[Area]]></NAME>
+<!--DD3B45F6E92E41458FBFFEF977EEE480-->  <AD_REFERENCE_ID><![CDATA[FC3E8E2652184032A86BE0F760A97B90]]></AD_REFERENCE_ID>
+<!--DD3B45F6E92E41458FBFFEF977EEE480-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--DD3B45F6E92E41458FBFFEF977EEE480--></AD_REF_LIST>
+
 <!--DDB179FA9EDE41E0B30BBF8AD59ADA16--><AD_REF_LIST>
 <!--DDB179FA9EDE41E0B30BBF8AD59ADA16-->  <AD_REF_LIST_ID><![CDATA[DDB179FA9EDE41E0B30BBF8AD59ADA16]]></AD_REF_LIST_ID>
 <!--DDB179FA9EDE41E0B30BBF8AD59ADA16-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -12234,6 +12278,17 @@
 <!--FB8F6159444446D59B9238B9EA680ED3-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--FB8F6159444446D59B9238B9EA680ED3--></AD_REF_LIST>
 
+<!--FBCE5CC9E77A43ED8ABBE27FC48F2C06--><AD_REF_LIST>
+<!--FBCE5CC9E77A43ED8ABBE27FC48F2C06-->  <AD_REF_LIST_ID><![CDATA[FBCE5CC9E77A43ED8ABBE27FC48F2C06]]></AD_REF_LIST_ID>
+<!--FBCE5CC9E77A43ED8ABBE27FC48F2C06-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FBCE5CC9E77A43ED8ABBE27FC48F2C06-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FBCE5CC9E77A43ED8ABBE27FC48F2C06-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FBCE5CC9E77A43ED8ABBE27FC48F2C06-->  <VALUE><![CDATA[T]]></VALUE>
+<!--FBCE5CC9E77A43ED8ABBE27FC48F2C06-->  <NAME><![CDATA[Time]]></NAME>
+<!--FBCE5CC9E77A43ED8ABBE27FC48F2C06-->  <AD_REFERENCE_ID><![CDATA[FC3E8E2652184032A86BE0F760A97B90]]></AD_REFERENCE_ID>
+<!--FBCE5CC9E77A43ED8ABBE27FC48F2C06-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FBCE5CC9E77A43ED8ABBE27FC48F2C06--></AD_REF_LIST>
+
 <!--FD374D3374054128A14530F1A71A72D8--><AD_REF_LIST>
 <!--FD374D3374054128A14530F1A71A72D8-->  <AD_REF_LIST_ID><![CDATA[FD374D3374054128A14530F1A71A72D8]]></AD_REF_LIST_ID>
 <!--FD374D3374054128A14530F1A71A72D8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REF_TABLE.xml	Tue Jul 16 06:13:05 2013 +0200
+++ b/src-db/database/sourcedata/AD_REF_TABLE.xml	Mon Jul 15 13:49:08 2013 +0200
@@ -1167,6 +1167,19 @@
 <!--2F57E5B5EBF44E0A9D45492DECBD3CC1-->  <ORDERBYCLAUSE><![CDATA[Name, CASE WHEN (AD_Org_ID = @AD_Org_ID@) THEN 1 ELSE 0 END DESC]]></ORDERBYCLAUSE>
 <!--2F57E5B5EBF44E0A9D45492DECBD3CC1--></AD_REF_TABLE>
 
+<!--2FE25E4AF395479EB8BAB0539A829C28--><AD_REF_TABLE>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <AD_REFERENCE_ID><![CDATA[2FE25E4AF395479EB8BAB0539A829C28]]></AD_REFERENCE_ID>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <AD_TABLE_ID><![CDATA[146]]></AD_TABLE_ID>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <AD_KEY><![CDATA[485]]></AD_KEY>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <AD_DISPLAY><![CDATA[486]]></AD_DISPLAY>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <WHERECLAUSE><![CDATA[UOM_Type = 'V']]></WHERECLAUSE>
+<!--2FE25E4AF395479EB8BAB0539A829C28-->  <HQLWHERECLAUSE><![CDATA[uOMType = 'V']]></HQLWHERECLAUSE>
+<!--2FE25E4AF395479EB8BAB0539A829C28--></AD_REF_TABLE>
+
 <!--3AE2B2C5C5F640EC83A5E77B0484C316--><AD_REF_TABLE>
 <!--3AE2B2C5C5F640EC83A5E77B0484C316-->  <AD_REFERENCE_ID><![CDATA[3AE2B2C5C5F640EC83A5E77B0484C316]]></AD_REFERENCE_ID>
 <!--3AE2B2C5C5F640EC83A5E77B0484C316-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -1246,6 +1259,19 @@
 <!--66E310A87A844A51B8BAD2884E996CD6-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--66E310A87A844A51B8BAD2884E996CD6--></AD_REF_TABLE>
 
+<!--9413570F6240406385FB633C7A9CC283--><AD_REF_TABLE>
+<!--9413570F6240406385FB633C7A9CC283-->  <AD_REFERENCE_ID><![CDATA[9413570F6240406385FB633C7A9CC283]]></AD_REFERENCE_ID>
+<!--9413570F6240406385FB633C7A9CC283-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9413570F6240406385FB633C7A9CC283-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9413570F6240406385FB633C7A9CC283-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9413570F6240406385FB633C7A9CC283-->  <AD_TABLE_ID><![CDATA[146]]></AD_TABLE_ID>
+<!--9413570F6240406385FB633C7A9CC283-->  <AD_KEY><![CDATA[485]]></AD_KEY>
+<!--9413570F6240406385FB633C7A9CC283-->  <AD_DISPLAY><![CDATA[486]]></AD_DISPLAY>
+<!--9413570F6240406385FB633C7A9CC283-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--9413570F6240406385FB633C7A9CC283-->  <WHERECLAUSE><![CDATA[UOM_Type = 'L']]></WHERECLAUSE>
+<!--9413570F6240406385FB633C7A9CC283-->  <HQLWHERECLAUSE><![CDATA[uOMType = 'L']]></HQLWHERECLAUSE>
+<!--9413570F6240406385FB633C7A9CC283--></AD_REF_TABLE>
+
 <!--99EC3A7013654794BB52975DAA3B80E6--><AD_REF_TABLE>
 <!--99EC3A7013654794BB52975DAA3B80E6-->  <AD_REFERENCE_ID><![CDATA[99EC3A7013654794BB52975DAA3B80E6]]></AD_REFERENCE_ID>
 <!--99EC3A7013654794BB52975DAA3B80E6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -1269,6 +1295,19 @@
 <!--A19872A5A16149ECAD01E5E37CC0843A-->  <WHERECLAUSE><![CDATA[FIN_Payment_Schedule.C_Order_ID is not null]]></WHERECLAUSE>
 <!--A19872A5A16149ECAD01E5E37CC0843A--></AD_REF_TABLE>
 
+<!--AFA80A98B3C6469EA15ECB8A0011A79F--><AD_REF_TABLE>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <AD_REFERENCE_ID><![CDATA[AFA80A98B3C6469EA15ECB8A0011A79F]]></AD_REFERENCE_ID>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <AD_TABLE_ID><![CDATA[146]]></AD_TABLE_ID>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <AD_KEY><![CDATA[485]]></AD_KEY>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <AD_DISPLAY><![CDATA[486]]></AD_DISPLAY>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <WHERECLAUSE><![CDATA[UOM_Type = 'T']]></WHERECLAUSE>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F-->  <HQLWHERECLAUSE><![CDATA[uOMType = 'T']]></HQLWHERECLAUSE>
+<!--AFA80A98B3C6469EA15ECB8A0011A79F--></AD_REF_TABLE>
+
 <!--B7E66794F4BA46C3ADB2CBD013252AA6--><AD_REF_TABLE>
 <!--B7E66794F4BA46C3ADB2CBD013252AA6-->  <AD_REFERENCE_ID><![CDATA[B7E66794F4BA46C3ADB2CBD013252AA6]]></AD_REFERENCE_ID>
 <!--B7E66794F4BA46C3ADB2CBD013252AA6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -1280,6 +1319,19 @@
 <!--B7E66794F4BA46C3ADB2CBD013252AA6-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--B7E66794F4BA46C3ADB2CBD013252AA6--></AD_REF_TABLE>
 
+<!--C3ED971A900A414B8A0A937B442374E1--><AD_REF_TABLE>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <AD_REFERENCE_ID><![CDATA[C3ED971A900A414B8A0A937B442374E1]]></AD_REFERENCE_ID>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <AD_TABLE_ID><![CDATA[146]]></AD_TABLE_ID>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <AD_KEY><![CDATA[485]]></AD_KEY>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <AD_DISPLAY><![CDATA[486]]></AD_DISPLAY>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <WHERECLAUSE><![CDATA[UOM_Type = 'W']]></WHERECLAUSE>
+<!--C3ED971A900A414B8A0A937B442374E1-->  <HQLWHERECLAUSE><![CDATA[uOMType = 'W']]></HQLWHERECLAUSE>
+<!--C3ED971A900A414B8A0A937B442374E1--></AD_REF_TABLE>
+
 <!--D2D4CC1F12434BB69733166A9423F2C6--><AD_REF_TABLE>
 <!--D2D4CC1F12434BB69733166A9423F2C6-->  <AD_REFERENCE_ID><![CDATA[D2D4CC1F12434BB69733166A9423F2C6]]></AD_REFERENCE_ID>
 <!--D2D4CC1F12434BB69733166A9423F2C6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>