details:   https://code.openbravo.com/erp/devel/pi/rev/abbf0e7f2325
changeset: 16219:abbf0e7f2325
user:      Naiara Martinez <naiara.martinez <at> openbravo.com>
date:      Thu Apr 26 11:24:42 2012 +0200
summary:   fixed bug 10797 Set sales transaction ='Y' in windows when appropiate

details:   https://code.openbravo.com/erp/devel/pi/rev/9f1665574f35
changeset: 16220:9f1665574f35
user:      Naiara Martinez <naiara.martinez <at> openbravo.com>
date:      Thu Apr 26 10:01:01 2012 +0200
summary:   fixed bug 19016 Calculate the weekends in Insert Maintenances

diffstat:

 
modules/org.openbravo.client.application/src-db/database/sourcedata/AD_WINDOW.xml
 |   2 +-
 modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_FIELD.xml    
   |   8 +-
 modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_WINDOW.xml   
   |   2 +-
 
modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_FIELD.xml
  |   4 +-
 
modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_WINDOW.xml
 |   2 +-
 src-db/database/model/functions/C_GET_ISO_DAYS.xml                             
   |  30 +++++++
 src-db/database/model/functions/C_PAYMENTDUEDATE.xml                           
   |   6 +-
 src-db/database/model/functions/MA_MAINTENANCE_SCHEDULE.xml                    
   |  20 ++--
 src-db/database/sourcedata/AD_FIELD.xml                                        
   |  38 +++++-----
 src-db/database/sourcedata/AD_WINDOW.xml                                       
   |  14 +-
 10 files changed, 78 insertions(+), 48 deletions(-)

diffs (truncated from 430 to 300 lines):

diff -r c88ce1de44de -r 9f1665574f35 
modules/org.openbravo.client.application/src-db/database/sourcedata/AD_WINDOW.xml
--- 
a/modules/org.openbravo.client.application/src-db/database/sourcedata/AD_WINDOW.xml
 Thu Apr 26 12:26:28 2012 +0200
+++ 
b/modules/org.openbravo.client.application/src-db/database/sourcedata/AD_WINDOW.xml
 Thu Apr 26 10:01:01 2012 +0200
@@ -45,7 +45,7 @@
 <!--FF8081813157AED2013157BE93460020-->  <DESCRIPTION><![CDATA[Maintains ui 
personalization records]]></DESCRIPTION>
 <!--FF8081813157AED2013157BE93460020-->  <HELP><![CDATA[Openbravo allows the 
customization of grid and form views. Customize windows and form views are 
stored once saved in the Window Personalization window.]]></HELP>
 <!--FF8081813157AED2013157BE93460020-->  <WINDOWTYPE><![CDATA[M]]></WINDOWTYPE>
-<!--FF8081813157AED2013157BE93460020-->  <ISSOTRX><![CDATA[N]]></ISSOTRX>
+<!--FF8081813157AED2013157BE93460020-->  <ISSOTRX><![CDATA[Y]]></ISSOTRX>
 <!--FF8081813157AED2013157BE93460020-->  <PROCESSING><![CDATA[N]]></PROCESSING>
 <!--FF8081813157AED2013157BE93460020-->  <ISDEFAULT><![CDATA[N]]></ISDEFAULT>
 <!--FF8081813157AED2013157BE93460020-->  
<AD_MODULE_ID><![CDATA[9BA0836A3CD74EE4AB48753A47211BCC]]></AD_MODULE_ID>
diff -r c88ce1de44de -r 9f1665574f35 
modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_FIELD.xml
--- 
a/modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_FIELD.xml   
    Thu Apr 26 12:26:28 2012 +0200
+++ 
b/modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_FIELD.xml   
    Thu Apr 26 10:01:01 2012 +0200
@@ -5,7 +5,7 @@
 <!--0F2B0754DC9843D5B3D7EC7D2FF07C8F-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--0F2B0754DC9843D5B3D7EC7D2FF07C8F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--0F2B0754DC9843D5B3D7EC7D2FF07C8F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--0F2B0754DC9843D5B3D7EC7D2FF07C8F-->  <NAME><![CDATA[Depends on Template 
]]></NAME>
+<!--0F2B0754DC9843D5B3D7EC7D2FF07C8F-->  <NAME><![CDATA[Depends On Template 
]]></NAME>
 <!--0F2B0754DC9843D5B3D7EC7D2FF07C8F-->  <DESCRIPTION><![CDATA[The template on 
which the current template depends]]></DESCRIPTION>
 <!--0F2B0754DC9843D5B3D7EC7D2FF07C8F-->  <HELP><![CDATA[Defines the template 
on which the current template depends.]]></HELP>
 <!--0F2B0754DC9843D5B3D7EC7D2FF07C8F-->  
<ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
@@ -33,7 +33,7 @@
 <!--1A23F87E116C443F837BC9C2A8BD7EC2-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--1A23F87E116C443F837BC9C2A8BD7EC2-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--1A23F87E116C443F837BC9C2A8BD7EC2-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--1A23F87E116C443F837BC9C2A8BD7EC2-->  <NAME><![CDATA[ComponentType]]></NAME>
+<!--1A23F87E116C443F837BC9C2A8BD7EC2-->  <NAME><![CDATA[Component 
Type]]></NAME>
 <!--1A23F87E116C443F837BC9C2A8BD7EC2-->  <DESCRIPTION><![CDATA[A type of 
component for which the template operates.]]></DESCRIPTION>
 <!--1A23F87E116C443F837BC9C2A8BD7EC2-->  <HELP><![CDATA[A type of component 
for which the template operates.]]></HELP>
 <!--1A23F87E116C443F837BC9C2A8BD7EC2-->  
<ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
@@ -259,7 +259,7 @@
 <!--5FCB19D79E454B9BB8053995417750EB-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--5FCB19D79E454B9BB8053995417750EB-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--5FCB19D79E454B9BB8053995417750EB-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--5FCB19D79E454B9BB8053995417750EB-->  
<NAME><![CDATA[TemplateClasspathLocation]]></NAME>
+<!--5FCB19D79E454B9BB8053995417750EB-->  <NAME><![CDATA[Template Classpath 
Location]]></NAME>
 <!--5FCB19D79E454B9BB8053995417750EB-->  <DESCRIPTION><![CDATA[Defines the 
location in the classpath of the template file]]></DESCRIPTION>
 <!--5FCB19D79E454B9BB8053995417750EB-->  <HELP><![CDATA[Defines the location 
in the classpath of the template file. The template is loaded using the 
classloader. The path must be an absolute path (so start with a /).]]></HELP>
 <!--5FCB19D79E454B9BB8053995417750EB-->  
<ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
@@ -423,7 +423,7 @@
 <!--8CBD0C02476942F9AD2C9B69FFAEE0FB-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--8CBD0C02476942F9AD2C9B69FFAEE0FB-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--8CBD0C02476942F9AD2C9B69FFAEE0FB-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--8CBD0C02476942F9AD2C9B69FFAEE0FB-->  
<NAME><![CDATA[Obclker_Template_ID]]></NAME>
+<!--8CBD0C02476942F9AD2C9B69FFAEE0FB-->  <NAME><![CDATA[Template]]></NAME>
 <!--8CBD0C02476942F9AD2C9B69FFAEE0FB-->  <DESCRIPTION><![CDATA[The template 
used to generate the visualization of the component.]]></DESCRIPTION>
 <!--8CBD0C02476942F9AD2C9B69FFAEE0FB-->  <HELP><![CDATA[Defines the template 
which is used to generate the (javascript) code to render the 
component.]]></HELP>
 <!--8CBD0C02476942F9AD2C9B69FFAEE0FB-->  
<ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
diff -r c88ce1de44de -r 9f1665574f35 
modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_WINDOW.xml
--- 
a/modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_WINDOW.xml  
    Thu Apr 26 12:26:28 2012 +0200
+++ 
b/modules/org.openbravo.client.kernel/src-db/database/sourcedata/AD_WINDOW.xml  
    Thu Apr 26 10:01:01 2012 +0200
@@ -9,7 +9,7 @@
 <!--CB53174675F84DCEAA13D2BED48F820C-->  <DESCRIPTION><![CDATA[Maintain 
component templates]]></DESCRIPTION>
 <!--CB53174675F84DCEAA13D2BED48F820C-->  <HELP><![CDATA[Templates are used to 
convert server side components into client side representations, to javascript. 
Templates are called to process requests from the browser for user interface 
components. Templates can depend on eachother, a template can use 
functions/methods provided by another template. This is handled through 
template dependencies.]]></HELP>
 <!--CB53174675F84DCEAA13D2BED48F820C-->  <WINDOWTYPE><![CDATA[M]]></WINDOWTYPE>
-<!--CB53174675F84DCEAA13D2BED48F820C-->  <ISSOTRX><![CDATA[N]]></ISSOTRX>
+<!--CB53174675F84DCEAA13D2BED48F820C-->  <ISSOTRX><![CDATA[Y]]></ISSOTRX>
 <!--CB53174675F84DCEAA13D2BED48F820C-->  <PROCESSING><![CDATA[N]]></PROCESSING>
 <!--CB53174675F84DCEAA13D2BED48F820C-->  <ISDEFAULT><![CDATA[N]]></ISDEFAULT>
 <!--CB53174675F84DCEAA13D2BED48F820C-->  
<AD_MODULE_ID><![CDATA[4B828F4D03264080AA1D2057B13F613C]]></AD_MODULE_ID>
diff -r c88ce1de44de -r 9f1665574f35 
modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_FIELD.xml
--- 
a/modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_FIELD.xml
  Thu Apr 26 12:26:28 2012 +0200
+++ 
b/modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_FIELD.xml
  Thu Apr 26 10:01:01 2012 +0200
@@ -87,7 +87,7 @@
 <!--23272B81BEF74DC3BA922D205C604DFD-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--23272B81BEF74DC3BA922D205C604DFD-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--23272B81BEF74DC3BA922D205C604DFD-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--23272B81BEF74DC3BA922D205C604DFD-->  
<NAME><![CDATA[Obserds_Datasource_ID]]></NAME>
+<!--23272B81BEF74DC3BA922D205C604DFD-->  <NAME><![CDATA[Datasource]]></NAME>
 <!--23272B81BEF74DC3BA922D205C604DFD-->  <DESCRIPTION><![CDATA[The datasource 
]]></DESCRIPTION>
 <!--23272B81BEF74DC3BA922D205C604DFD-->  <HELP><![CDATA[The datasource 
provides data from the database or from in-memory data.]]></HELP>
 <!--23272B81BEF74DC3BA922D205C604DFD-->  
<ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
@@ -279,7 +279,7 @@
 <!--77780C7AD4BB45DEAE510AAF6CFDCED5-->  
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--77780C7AD4BB45DEAE510AAF6CFDCED5-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--77780C7AD4BB45DEAE510AAF6CFDCED5-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--77780C7AD4BB45DEAE510AAF6CFDCED5-->  
<NAME><![CDATA[Obserds_Datasource_Field_ID]]></NAME>
+<!--77780C7AD4BB45DEAE510AAF6CFDCED5-->  <NAME><![CDATA[Datasource 
Field]]></NAME>
 <!--77780C7AD4BB45DEAE510AAF6CFDCED5-->  <DESCRIPTION><![CDATA[The datasource 
field is part of the datasource definition.]]></DESCRIPTION>
 <!--77780C7AD4BB45DEAE510AAF6CFDCED5-->  <HELP><![CDATA[The datasource field 
is part of the datasource definition.]]></HELP>
 <!--77780C7AD4BB45DEAE510AAF6CFDCED5-->  
<ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
diff -r c88ce1de44de -r 9f1665574f35 
modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_WINDOW.xml
--- 
a/modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_WINDOW.xml
 Thu Apr 26 12:26:28 2012 +0200
+++ 
b/modules/org.openbravo.service.datasource/src-db/database/sourcedata/AD_WINDOW.xml
 Thu Apr 26 10:01:01 2012 +0200
@@ -9,7 +9,7 @@
 <!--67AD3A287B7F4577A1534C8430E9DB2E-->  <DESCRIPTION><![CDATA[Maintain 
datasources which are used to provide data to the user 
interface]]></DESCRIPTION>
 <!--67AD3A287B7F4577A1534C8430E9DB2E-->  <HELP><![CDATA[A datasource is used 
to provide data to user interface components running on the client. The data 
can be read from the database or can be computed at runtime in memory. Data 
consists mostly of records with fields which are displayed on the client in 
forms and grids.]]></HELP>
 <!--67AD3A287B7F4577A1534C8430E9DB2E-->  <WINDOWTYPE><![CDATA[M]]></WINDOWTYPE>
-<!--67AD3A287B7F4577A1534C8430E9DB2E-->  <ISSOTRX><![CDATA[N]]></ISSOTRX>
+<!--67AD3A287B7F4577A1534C8430E9DB2E-->  <ISSOTRX><![CDATA[Y]]></ISSOTRX>
 <!--67AD3A287B7F4577A1534C8430E9DB2E-->  <PROCESSING><![CDATA[N]]></PROCESSING>
 <!--67AD3A287B7F4577A1534C8430E9DB2E-->  <ISDEFAULT><![CDATA[N]]></ISDEFAULT>
 <!--67AD3A287B7F4577A1534C8430E9DB2E-->  
<AD_MODULE_ID><![CDATA[A44B9BA75C354D8FB2E3F7D6EB6BFDC4]]></AD_MODULE_ID>
diff -r c88ce1de44de -r 9f1665574f35 
src-db/database/model/functions/C_GET_ISO_DAYS.xml
--- /dev/null   Thu Jan 01 00:00:00 1970 +0000
+++ b/src-db/database/model/functions/C_GET_ISO_DAYS.xml        Thu Apr 26 
10:01:01 2012 +0200
@@ -0,0 +1,30 @@
+<?xml version="1.0"?>
+  <database name="FUNCTION C_GET_ISO_DAYS">
+    <function name="C_GET_ISO_DAYS" type="NUMERIC">
+      <parameter name="p_date" type="TIMESTAMP" mode="in">
+        <default/>
+      </parameter>
+      
<body><![CDATA[/*************************************************************************
+ * The contents of this file are subject to the Openbravo  Public  License
+ * Version  1.1  (the  "License"),  being   the  Mozilla   Public  License
+ * Version 1.1  with a permitted attribution clause; you may not  use this
+ * file except in compliance with the License. You  may  obtain  a copy of
+ * the License at http://www.openbravo.com/legal/license.html
+ * Software distributed under the License  is  distributed  on  an "AS IS"
+ * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+ * License for the specific  language  governing  rights  and  limitations
+ * under the License.
+ * The Original Code is Openbravo ERP.
+ * The Initial Developer of the Original Code is Openbravo SLU
+ * All portions are Copyright (C) 2012 Openbravo SLU
+ * All Rights Reserved.
+*************************************************************************/
+BEGIN
+  --The first day of the week depends on the database configuration for oracle
+  --It is used the Julian day to ensure that saturday and sunday are always
+  --the days 6 and 7 of the week in both oracle and postgresql databases.
+  RETURN (MOD(to_number(to_char(p_date, 'J')), 7) + 1);
+END C_GET_ISO_DAYS
+]]></body>
+    </function>
+  </database>
diff -r c88ce1de44de -r 9f1665574f35 
src-db/database/model/functions/C_PAYMENTDUEDATE.xml
--- a/src-db/database/model/functions/C_PAYMENTDUEDATE.xml      Thu Apr 26 
12:26:28 2012 +0200
+++ b/src-db/database/model/functions/C_PAYMENTDUEDATE.xml      Thu Apr 26 
10:01:01 2012 +0200
@@ -43,7 +43,7 @@
 * under the License.
 * The Original Code is Openbravo ERP.
 * The Initial Developer of the Original Code is Openbravo SLU
-* All portions are Copyright (C) 2001-2007 Openbravo SLU
+* All portions are Copyright (C) 2001-2012 Openbravo SLU
 * All Rights Reserved.
 * Contributor(s):  ______________________________________.
 ************************************************************************/
@@ -109,11 +109,11 @@
     --The first day of the week depends on the database configuration for 
oracle
     --It is used the Julian day to ensure that saturday and sunday are always
     --the days 6 and 7 of the week in both oracle and postgresql databases.
-    SELECT MOD(to_number(to_char(v_DueDate, 'J')), 7) + 1 INTO v_Aux from DUAL;
+    SELECT C_GET_ISO_DAYS(v_DueDate) INTO v_Aux from DUAL;
     WHILE(v_Aux IN('6', '7'))
     LOOP
       v_DueDate := v_DueDate + 1;
-      SELECT MOD(to_number(to_char(v_DueDate, 'J')), 7) + 1 INTO v_Aux from 
DUAL;
+      SELECT C_GET_ISO_DAYS(v_DueDate) INTO v_Aux from DUAL;
     END LOOP;
   END IF;
   RETURN COALESCE(v_DueDate, TRUNC(p_DocDate)) ;
diff -r c88ce1de44de -r 9f1665574f35 
src-db/database/model/functions/MA_MAINTENANCE_SCHEDULE.xml
--- a/src-db/database/model/functions/MA_MAINTENANCE_SCHEDULE.xml       Thu Apr 
26 12:26:28 2012 +0200
+++ b/src-db/database/model/functions/MA_MAINTENANCE_SCHEDULE.xml       Thu Apr 
26 10:01:01 2012 +0200
@@ -34,7 +34,7 @@
 * under the License.
 * The Original Code is Openbravo ERP.
 * The Initial Developer of the Original Code is Openbravo SLU
-* All portions are Copyright (C) 2001-2006 Openbravo SLU
+* All portions are Copyright (C) 2001-2012 Openbravo SLU
 * All Rights Reserved.
 * Contributor(s):  ______________________________________.
 ************************************************************************/
@@ -137,7 +137,7 @@
           FROM MA_Maint_Scheduled
           WHERE MA_Maintenance_ID=Cur_Periodicity.MA_Maintenance_ID
             AND SCHEDULEDDATE=v_Date;
-          IF NOT(v_Count!=0 OR(Cur_Periodicity.ExcludeWeekend='Y' 
AND(TO_CHAR(v_Date, 'd')='6' OR TO_CHAR(v_Date, 'd')='7'))) THEN
+          IF NOT(v_Count!=0 OR(Cur_Periodicity.ExcludeWeekend='Y' 
AND(C_GET_ISO_DAYS(v_Date)=6 OR C_GET_ISO_DAYS(v_Date)=7))) THEN
             IF(v_Maint.MA_Machine_Type_ID IS NOT NULL AND v_Maint.Explode='Y') 
THEN
               FOR Cur_Machine IN
                 (SELECT MA_Machine_ID
@@ -260,9 +260,9 @@
         WHILE(v_Date<v_EndDate)
         LOOP
           v_DateInt:=v_Date;
-          IF(Cur_Periodicity.ExcludeWeekend='Y' AND TO_CHAR(v_Date, 'd')='6') 
THEN
+          IF(Cur_Periodicity.ExcludeWeekend='Y' AND C_GET_ISO_DAYS(v_Date)=6) 
THEN
             v_DateInt:=v_Date +2;
-          ELSIF(Cur_Periodicity.ExcludeWeekend='Y' AND TO_CHAR(v_Date, 
'd')='7') THEN
+          ELSIF(Cur_Periodicity.ExcludeWeekend='Y' AND 
C_GET_ISO_DAYS(v_Date)=7) THEN
             v_DateInt:=v_Date +1;
           END IF;
           SELECT count(*)
@@ -332,9 +332,9 @@
         WHILE(v_Date<v_EndDate)
         LOOP
           v_DateInt:=v_Date;
-          IF(Cur_Periodicity.ExcludeWeekend='Y' AND TO_CHAR(v_Date, 'd')='6') 
THEN
+          IF(Cur_Periodicity.ExcludeWeekend='Y' AND C_GET_ISO_DAYS(v_Date)=6) 
THEN
             v_DateInt:=v_Date +2;
-          ELSIF(Cur_Periodicity.ExcludeWeekend='Y' AND TO_CHAR(v_Date, 
'd')='7') THEN
+          ELSIF(Cur_Periodicity.ExcludeWeekend='Y' AND 
C_GET_ISO_DAYS(v_Date)=7) THEN
             v_DateInt:=v_Date +1;
           END IF;
           SELECT count(*)
@@ -403,9 +403,9 @@
         WHILE(v_Date<v_EndDate)
         LOOP
           v_DateInt:=v_Date;
-          IF(Cur_Periodicity.ExcludeWeekend='Y' AND TO_CHAR(v_Date, 'd')='6') 
THEN
+          IF(Cur_Periodicity.ExcludeWeekend='Y' AND C_GET_ISO_DAYS(v_Date)=6) 
THEN
             v_DateInt:=v_Date +2;
-          ELSIF(Cur_Periodicity.ExcludeWeekend='Y' AND TO_CHAR(v_Date, 
'd')='7') THEN
+          ELSIF(Cur_Periodicity.ExcludeWeekend='Y' AND 
C_GET_ISO_DAYS(v_Date)=7) THEN
             v_DateInt:=v_Date +1;
           END IF;
           SELECT count(*)
@@ -474,9 +474,9 @@
         WHILE(v_Date<v_EndDate)
         LOOP
           v_DateInt:=v_Date;
-          IF(Cur_Periodicity.ExcludeWeekend='Y' AND TO_CHAR(v_Date, 'd')='6') 
THEN
+          IF(Cur_Periodicity.ExcludeWeekend='Y' AND C_GET_ISO_DAYS(v_Date)=6) 
THEN
             v_DateInt:=v_Date +2;
-          ELSIF(Cur_Periodicity.ExcludeWeekend='Y' AND TO_CHAR(v_Date, 
'd')='7') THEN
+          ELSIF(Cur_Periodicity.ExcludeWeekend='Y' AND 
C_GET_ISO_DAYS(v_Date)=7) THEN
             v_DateInt:=v_Date +1;
           END IF;
           SELECT count(*)
diff -r c88ce1de44de -r 9f1665574f35 src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml   Thu Apr 26 12:26:28 2012 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml   Thu Apr 26 10:01:01 2012 +0200
@@ -26982,7 +26982,7 @@
 <!--2301-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--2301-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--2301-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--2301-->  <NAME><![CDATA[Valid from Date]]></NAME>
+<!--2301-->  <NAME><![CDATA[Valid From Date]]></NAME>
 <!--2301-->  <DESCRIPTION><![CDATA[A parameter stating the starting time of a 
specified request.]]></DESCRIPTION>
 <!--2301-->  <HELP><![CDATA[The Valid From date indicates the first day of a 
date range]]></HELP>
 <!--2301-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
@@ -30587,9 +30587,9 @@
 <!--2587-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--2587-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--2587-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--2587-->  <NAME><![CDATA[Company Agent]]></NAME>
-<!--2587-->  <DESCRIPTION><![CDATA[Purchase or Company Agent]]></DESCRIPTION>
-<!--2587-->  <HELP><![CDATA[Purchase agent for the document. Any Sales Rep 
must be a valid internal user.]]></HELP>
+<!--2587-->  <NAME><![CDATA[Sales Representative]]></NAME>
+<!--2587-->  <DESCRIPTION><![CDATA[The person in charge of a 
document.]]></DESCRIPTION>
+<!--2587-->  <HELP><![CDATA[Indicates the sales representative responsible for 
the transaction that  the document specifies . A valid sales representative is 
a business partner marked as an employee and a sales representative.]]></HELP>
 <!--2587-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--2587-->  <AD_TAB_ID><![CDATA[180]]></AD_TAB_ID>
 <!--2587-->  <AD_COLUMN_ID><![CDATA[3391]]></AD_COLUMN_ID>
@@ -39684,10 +39684,10 @@
 <!--3305-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--3305-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--3305-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--3305-->  <NAME><![CDATA[Goods Receipt Line]]></NAME>
-<!--3305-->  <DESCRIPTION><![CDATA[A statement displaying one item, charge, or 
movement in a receipt.]]></DESCRIPTION>
-<!--3305-->  <HELP><![CDATA[The Goods Receipt Line indicates a unique line in 
a Receipt document]]></HELP>
-<!--3305-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--3305-->  <NAME><![CDATA[Goods Shipment/Receipt Line]]></NAME>
+<!--3305-->  <DESCRIPTION><![CDATA[A statement displaying one item, charge, or 
movement in a shipment or receipt]]></DESCRIPTION>
+<!--3305-->  <HELP><![CDATA[The Shipment/Receipt indicates a unique line in a 
Shipment/Receipt document]]></HELP>
+<!--3305-->  <ISCENTRALLYMAINTAINED><![CDATA[N]]></ISCENTRALLYMAINTAINED>
 <!--3305-->  <AD_TAB_ID><![CDATA[289]]></AD_TAB_ID>
 <!--3305-->  <AD_COLUMN_ID><![CDATA[3673]]></AD_COLUMN_ID>
 <!--3305-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
@@ -110169,7 +110169,7 @@
 <!--801001-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--801001-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--801001-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--801001-->  <NAME><![CDATA[M_Product_Customer_ID]]></NAME>
+<!--801001-->  <NAME><![CDATA[Product Customer]]></NAME>
 <!--801001-->  <DESCRIPTION><![CDATA[Product assignation to 
customer]]></DESCRIPTION>
 <!--801001-->  <HELP><![CDATA[Product assignation to customer]]></HELP>
 <!--801001-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
@@ -110728,7 +110728,7 @@
 <!--801022-->  <NAME><![CDATA[Goods Receipt Line]]></NAME>
 <!--801022-->  <DESCRIPTION><![CDATA[A statement displaying one item, charge, 
or movement in a receipt.]]></DESCRIPTION>
 <!--801022-->  <HELP><![CDATA[The Goods Receipt Line indicates a unique line 
in a Receipt document]]></HELP>
-<!--801022-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--801022-->  <ISCENTRALLYMAINTAINED><![CDATA[N]]></ISCENTRALLYMAINTAINED>
 <!--801022-->  <AD_TAB_ID><![CDATA[800057]]></AD_TAB_ID>
 <!--801022-->  <AD_COLUMN_ID><![CDATA[800761]]></AD_COLUMN_ID>
 <!--801022-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
@@ -149863,7 +149863,7 @@
 <!--803734-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--803734-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--803734-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--803734-->  <NAME><![CDATA[Reinvoicing]]></NAME>
+<!--803734-->  <NAME><![CDATA[Re-invoice]]></NAME>
 <!--803734-->  <DESCRIPTION><![CDATA[An indication that a transaction may be 
invoiced to a business partner.]]></DESCRIPTION>
 <!--803734-->  <HELP><![CDATA[Indicator if invoiced]]></HELP>
 <!--803734-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
@@ -150318,7 +150318,7 @@
 <!--803751-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--803751-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--803751-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--803751-->  <NAME><![CDATA[M_Product_Org_ID]]></NAME>
+<!--803751-->  <NAME><![CDATA[Product Organization]]></NAME>
 <!--803751-->  <DESCRIPTION><![CDATA[Details for a product in different 
organizations.]]></DESCRIPTION>
 <!--803751-->  <HELP><![CDATA[Details for a product in different 
organizations.]]></HELP>

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

Reply via email to