Fixed database consistency issues.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Fri, 22 Jun 2012 12:17:34 +0200
changeset 17368 63f3b7655ff5
parent 17367 f11a7f08ac98
child 17369 1962e0e60567
Fixed database consistency issues.
src-db/database/sourcedata/AD_FIELD.xml
src-db/database/sourcedata/AD_PROCESS_PARA.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml	Sun Jun 24 17:54:47 2012 +0530
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Fri Jun 22 12:17:34 2012 +0200
@@ -175611,6 +175611,7 @@
 <!--0BDCD34070C249D0BE6FF9667BCF58FB-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--0BDCD34070C249D0BE6FF9667BCF58FB-->  <AD_TAB_ID><![CDATA[270]]></AD_TAB_ID>
 <!--0BDCD34070C249D0BE6FF9667BCF58FB-->  <AD_COLUMN_ID><![CDATA[D497AE1E0F9948519C7E82464AD6A114]]></AD_COLUMN_ID>
+<!--0BDCD34070C249D0BE6FF9667BCF58FB-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--0BDCD34070C249D0BE6FF9667BCF58FB-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--0BDCD34070C249D0BE6FF9667BCF58FB-->  <DISPLAYLOGIC><![CDATA[@GROSSPRICE@='Y']]></DISPLAYLOGIC>
 <!--0BDCD34070C249D0BE6FF9667BCF58FB-->  <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
@@ -181390,6 +181391,7 @@
 <!--37B6D63D1F604009AA3E59DB7FA81D01-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--37B6D63D1F604009AA3E59DB7FA81D01-->  <AD_TAB_ID><![CDATA[270]]></AD_TAB_ID>
 <!--37B6D63D1F604009AA3E59DB7FA81D01-->  <AD_COLUMN_ID><![CDATA[7B0E6024A8EC4EF29BF18AEDC92D4E2C]]></AD_COLUMN_ID>
+<!--37B6D63D1F604009AA3E59DB7FA81D01-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--37B6D63D1F604009AA3E59DB7FA81D01-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--37B6D63D1F604009AA3E59DB7FA81D01-->  <DISPLAYLOGIC><![CDATA[@GROSSPRICE@='Y']]></DISPLAYLOGIC>
 <!--37B6D63D1F604009AA3E59DB7FA81D01-->  <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
@@ -182868,6 +182870,7 @@
 <!--44023AE71D154D9DBE06532EDA193069-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--44023AE71D154D9DBE06532EDA193069-->  <AD_TAB_ID><![CDATA[293]]></AD_TAB_ID>
 <!--44023AE71D154D9DBE06532EDA193069-->  <AD_COLUMN_ID><![CDATA[025E1896618449A4B30FE9CC729CC615]]></AD_COLUMN_ID>
+<!--44023AE71D154D9DBE06532EDA193069-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--44023AE71D154D9DBE06532EDA193069-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--44023AE71D154D9DBE06532EDA193069-->  <DISPLAYLOGIC><![CDATA[@GROSSPRICE@='Y']]></DISPLAYLOGIC>
 <!--44023AE71D154D9DBE06532EDA193069-->  <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
@@ -183011,6 +183014,7 @@
 <!--453A06D8F77F487A86A1A2238C7F575B-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--453A06D8F77F487A86A1A2238C7F575B-->  <AD_TAB_ID><![CDATA[187]]></AD_TAB_ID>
 <!--453A06D8F77F487A86A1A2238C7F575B-->  <AD_COLUMN_ID><![CDATA[025E1896618449A4B30FE9CC729CC615]]></AD_COLUMN_ID>
+<!--453A06D8F77F487A86A1A2238C7F575B-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--453A06D8F77F487A86A1A2238C7F575B-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--453A06D8F77F487A86A1A2238C7F575B-->  <DISPLAYLOGIC><![CDATA[@GROSSPRICE@='Y']]></DISPLAYLOGIC>
 <!--453A06D8F77F487A86A1A2238C7F575B-->  <DISPLAYLENGTH><![CDATA[2]]></DISPLAYLENGTH>
@@ -198308,6 +198312,7 @@
 <!--71F61AF7C4FC4710904B117D18F56109-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--71F61AF7C4FC4710904B117D18F56109-->  <AD_TAB_ID><![CDATA[187]]></AD_TAB_ID>
 <!--71F61AF7C4FC4710904B117D18F56109-->  <AD_COLUMN_ID><![CDATA[EB0B8E4554EF4A9CA512B9C5FF4FFABF]]></AD_COLUMN_ID>
+<!--71F61AF7C4FC4710904B117D18F56109-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--71F61AF7C4FC4710904B117D18F56109-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--71F61AF7C4FC4710904B117D18F56109-->  <DISPLAYLOGIC><![CDATA[@GROSSPRICE@='Y']]></DISPLAYLOGIC>
 <!--71F61AF7C4FC4710904B117D18F56109-->  <DISPLAYLENGTH><![CDATA[2]]></DISPLAYLENGTH>
@@ -225984,6 +225989,7 @@
 <!--B3F4F8BB5D964059BC0708F37D378A1D-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--B3F4F8BB5D964059BC0708F37D378A1D-->  <AD_TAB_ID><![CDATA[293]]></AD_TAB_ID>
 <!--B3F4F8BB5D964059BC0708F37D378A1D-->  <AD_COLUMN_ID><![CDATA[EB0B8E4554EF4A9CA512B9C5FF4FFABF]]></AD_COLUMN_ID>
+<!--B3F4F8BB5D964059BC0708F37D378A1D-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--B3F4F8BB5D964059BC0708F37D378A1D-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--B3F4F8BB5D964059BC0708F37D378A1D-->  <DISPLAYLOGIC><![CDATA[@GROSSPRICE@='Y']]></DISPLAYLOGIC>
 <!--B3F4F8BB5D964059BC0708F37D378A1D-->  <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
@@ -230649,6 +230655,7 @@
 <!--D675A1322C8543CEB95A6D9E39813E38-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--D675A1322C8543CEB95A6D9E39813E38-->  <AD_TAB_ID><![CDATA[291]]></AD_TAB_ID>
 <!--D675A1322C8543CEB95A6D9E39813E38-->  <AD_COLUMN_ID><![CDATA[D497AE1E0F9948519C7E82464AD6A114]]></AD_COLUMN_ID>
+<!--D675A1322C8543CEB95A6D9E39813E38-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--D675A1322C8543CEB95A6D9E39813E38-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--D675A1322C8543CEB95A6D9E39813E38-->  <DISPLAYLOGIC><![CDATA[@GROSSPRICE@='Y']]></DISPLAYLOGIC>
 <!--D675A1322C8543CEB95A6D9E39813E38-->  <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
@@ -234358,6 +234365,7 @@
 <!--F8F7E13646FE4C6283B40E0C0CF46AA2-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--F8F7E13646FE4C6283B40E0C0CF46AA2-->  <AD_TAB_ID><![CDATA[291]]></AD_TAB_ID>
 <!--F8F7E13646FE4C6283B40E0C0CF46AA2-->  <AD_COLUMN_ID><![CDATA[7B0E6024A8EC4EF29BF18AEDC92D4E2C]]></AD_COLUMN_ID>
+<!--F8F7E13646FE4C6283B40E0C0CF46AA2-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--F8F7E13646FE4C6283B40E0C0CF46AA2-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--F8F7E13646FE4C6283B40E0C0CF46AA2-->  <DISPLAYLOGIC><![CDATA[@GROSSPRICE@='Y']]></DISPLAYLOGIC>
 <!--F8F7E13646FE4C6283B40E0C0CF46AA2-->  <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
--- a/src-db/database/sourcedata/AD_PROCESS_PARA.xml	Sun Jun 24 17:54:47 2012 +0530
+++ b/src-db/database/sourcedata/AD_PROCESS_PARA.xml	Fri Jun 22 12:17:34 2012 +0200
@@ -4262,9 +4262,9 @@
 <!--97266E0DF6A24EC0BC6845B9E305F307-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--97266E0DF6A24EC0BC6845B9E305F307-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--97266E0DF6A24EC0BC6845B9E305F307-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--97266E0DF6A24EC0BC6845B9E305F307-->  <NAME><![CDATA[Net Unit Price]]></NAME>
+<!--97266E0DF6A24EC0BC6845B9E305F307-->  <NAME><![CDATA[Unit Price]]></NAME>
 <!--97266E0DF6A24EC0BC6845B9E305F307-->  <DESCRIPTION><![CDATA[The regular or normal price of a product in the respective price list.]]></DESCRIPTION>
-<!--97266E0DF6A24EC0BC6845B9E305F307-->  <HELP><![CDATA[The Standard Price indicates the standard or normal price for a product on this price list]]></HELP>
+<!--97266E0DF6A24EC0BC6845B9E305F307-->  <HELP><![CDATA[The Standard Price indicates the standard or normal price for a product on this price list. This price might be net or gross depending on its price list configuration.]]></HELP>
 <!--97266E0DF6A24EC0BC6845B9E305F307-->  <AD_PROCESS_ID><![CDATA[23D1B163EC0B41F790CE39BF01DA320E]]></AD_PROCESS_ID>
 <!--97266E0DF6A24EC0BC6845B9E305F307-->  <SEQNO><![CDATA[40]]></SEQNO>
 <!--97266E0DF6A24EC0BC6845B9E305F307-->  <AD_REFERENCE_ID><![CDATA[800008]]></AD_REFERENCE_ID>