Fix database inconsistency 2.50MP1
authorJuan Pablo Aroztegi <juanpablo.aroztegi@openbravo.com>
Wed, 13 May 2009 18:14:08 +0200
changeset 3917 2697b580d266
parent 3916 3c0316a863a3
child 3918 b3f5aa9d80a9
Fix database inconsistency
src-db/database/model/functions/MRP_PROCESSPLAN_PLAN.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_FIELD.xml
src-db/database/sourcedata/AD_TEXTINTERFACES.xml
--- a/src-db/database/model/functions/MRP_PROCESSPLAN_PLAN.xml	Wed May 13 17:00:55 2009 +0200
+++ b/src-db/database/model/functions/MRP_PROCESSPLAN_PLAN.xml	Wed May 13 18:14:08 2009 +0200
@@ -41,7 +41,7 @@
   v_Result NUMBER:=1; -- 0=failure
 
   v_Stock NUMBER:= 0;
-  v_AvailableStock NUMBER := 0;
+  v_AvailableStock NUMBER:= 0;
   v_Qty_New NUMBER;
   v_NeededQty_New NUMBER;
   v_PlannedOrderDate_New DATE;
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Wed May 13 17:00:55 2009 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Wed May 13 18:14:08 2009 +0200
@@ -265815,8 +265815,8 @@
 <!--B956EBF22FD411DE9A5F001D09C4A2FE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--B956EBF22FD411DE9A5F001D09C4A2FE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--B956EBF22FD411DE9A5F001D09C4A2FE-->  <NAME><![CDATA[TreeType]]></NAME>
-<!--B956EBF22FD411DE9A5F001D09C4A2FE-->  <DESCRIPTION><![CDATA[Defines the type of tree which can hold records of this Table]]></DESCRIPTION>
-<!--B956EBF22FD411DE9A5F001D09C4A2FE-->  <HELP><![CDATA[Defines the type of tree which can hold records of this Table]]></HELP>
+<!--B956EBF22FD411DE9A5F001D09C4A2FE-->  <DESCRIPTION><![CDATA[Element this tree is built on (i.e Product, Business Partner)]]></DESCRIPTION>
+<!--B956EBF22FD411DE9A5F001D09C4A2FE-->  <HELP><![CDATA[The Tree Type / Area field determines the type of tree this is.  For example, you may define one tree for your Products and another tree for your Business Partners.]]></HELP>
 <!--B956EBF22FD411DE9A5F001D09C4A2FE-->  <COLUMNNAME><![CDATA[Treetype]]></COLUMNNAME>
 <!--B956EBF22FD411DE9A5F001D09C4A2FE-->  <AD_TABLE_ID><![CDATA[100]]></AD_TABLE_ID>
 <!--B956EBF22FD411DE9A5F001D09C4A2FE-->  <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Wed May 13 17:00:55 2009 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Wed May 13 18:14:08 2009 +0200
@@ -190797,9 +190797,9 @@
 <!--781A06642FD511DE882C001D09C4A2FE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--781A06642FD511DE882C001D09C4A2FE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--781A06642FD511DE882C001D09C4A2FE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--781A06642FD511DE882C001D09C4A2FE-->  <NAME><![CDATA[TreeType]]></NAME>
-<!--781A06642FD511DE882C001D09C4A2FE-->  <DESCRIPTION><![CDATA[Defines the type of tree which can hold records of this Table]]></DESCRIPTION>
-<!--781A06642FD511DE882C001D09C4A2FE-->  <HELP><![CDATA[Defines the type of tree which can hold records of this Table]]></HELP>
+<!--781A06642FD511DE882C001D09C4A2FE-->  <NAME><![CDATA[Type  Area]]></NAME>
+<!--781A06642FD511DE882C001D09C4A2FE-->  <DESCRIPTION><![CDATA[Element this tree is built on (i.e Product, Business Partner)]]></DESCRIPTION>
+<!--781A06642FD511DE882C001D09C4A2FE-->  <HELP><![CDATA[The Tree Type / Area field determines the type of tree this is.  For example, you may define one tree for your Products and another tree for your Business Partners.]]></HELP>
 <!--781A06642FD511DE882C001D09C4A2FE-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--781A06642FD511DE882C001D09C4A2FE-->  <AD_TAB_ID><![CDATA[100]]></AD_TAB_ID>
 <!--781A06642FD511DE882C001D09C4A2FE-->  <AD_COLUMN_ID><![CDATA[B956EBF22FD411DE9A5F001D09C4A2FE]]></AD_COLUMN_ID>
--- a/src-db/database/sourcedata/AD_TEXTINTERFACES.xml	Wed May 13 17:00:55 2009 +0200
+++ b/src-db/database/sourcedata/AD_TEXTINTERFACES.xml	Wed May 13 18:14:08 2009 +0200
@@ -1058,7 +1058,7 @@
 <!--800579-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--800579-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--800579-->  <TEXT><![CDATA[Anal.]]></TEXT>
-<!--800579-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--800579-->  <ISUSED><![CDATA[N]]></ISUSED>
 <!--800579-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--800579--></AD_TEXTINTERFACES>
 
@@ -12365,7 +12365,7 @@
 <!--807513-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--807513-->  <TEXT><![CDATA[ANAL.]]></TEXT>
 <!--807513-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportTrialBalance.html]]></FILENAME>
-<!--807513-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--807513-->  <ISUSED><![CDATA[N]]></ISUSED>
 <!--807513-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--807513--></AD_TEXTINTERFACES>
 
@@ -22248,7 +22248,7 @@
 <!--2817A5882E6611DEB369EB51B72082F4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--2817A5882E6611DEB369EB51B72082F4-->  <TEXT><![CDATA[Sales Rep.]]></TEXT>
 <!--2817A5882E6611DEB369EB51B72082F4-->  <FILENAME><![CDATA[/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.html]]></FILENAME>
-<!--2817A5882E6611DEB369EB51B72082F4-->  <ISUSED><![CDATA[Y]]></ISUSED>
+<!--2817A5882E6611DEB369EB51B72082F4-->  <ISUSED><![CDATA[N]]></ISUSED>
 <!--2817A5882E6611DEB369EB51B72082F4-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--2817A5882E6611DEB369EB51B72082F4--></AD_TEXTINTERFACES>