details: /erp/devel/pi/rev/2503a22e795d
changeset: 9423:2503a22e795d
user: David Alsasua <david.alsasua <at> openbravo.com>
date: Mon Dec 27 16:47:41 2010 +0100
summary: Fixes issue 15165. Prefix and suffix also removed
diffstat:
referencedata/standard/Initial_Setup.xml | 56 ------------------------
src-db/database/sourcedata/AD_DATASET.xml | 1 +
src-db/database/sourcedata/AD_DATASET_COLUMN.xml | 22 +++++++++
3 files changed, 23 insertions(+), 56 deletions(-)
diffs (truncated from 305 to 300 lines):
diff -r 078aeeead4a4 -r 2503a22e795d referencedata/standard/Initial_Setup.xml
--- a/referencedata/standard/Initial_Setup.xml Mon Dec 27 16:38:07 2010 +0100
+++ b/referencedata/standard/Initial_Setup.xml Mon Dec 27 16:47:41 2010 +0100
@@ -1028,8 +1028,6 @@
<incrementBy>1</incrementBy>
<startingNo>600000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="0FBF9530BC584A6E9415F7AD01A23201" identifier="Standard
Order">
@@ -1042,8 +1040,6 @@
<incrementBy>1</incrementBy>
<startingNo>50000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="267B166C6F4B49E893CF6276EE396E7D" identifier="Production">
@@ -1056,8 +1052,6 @@
<incrementBy>1</incrementBy>
<startingNo>1000000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="2D47C580583242259DF1FFEA4D914A94" identifier="MM Shipment">
@@ -1070,8 +1064,6 @@
<incrementBy>1</incrementBy>
<startingNo>500000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="4D72691638A24A0194882A302FCF9494" identifier="AP Payment">
@@ -1084,8 +1076,6 @@
<incrementBy>1</incrementBy>
<startingNo>700000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="6D3C7477332F47CD8A0F6A5C4805EBD4" identifier="Prepay Order">
@@ -1098,8 +1088,6 @@
<incrementBy>1</incrementBy>
<startingNo>30000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="74C3CC2BCDDA45F5BBFE8DF603728749" identifier="Purchase
Requisition">
@@ -1112,8 +1100,6 @@
<incrementBy>1</incrementBy>
<startingNo>900000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="7C2F74C43970423E890C8892C43673E9" identifier="Settlement">
@@ -1126,8 +1112,6 @@
<incrementBy>1</incrementBy>
<startingNo>10000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="81EEB6FAFE5D4E6B9389CAAC6297495B" identifier="Physical
Inventory">
@@ -1140,8 +1124,6 @@
<incrementBy>1</incrementBy>
<startingNo>1000000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="81F0991C4D884F82AF34E6CD72C0BFEC" identifier="Quotation">
@@ -1154,8 +1136,6 @@
<incrementBy>1</incrementBy>
<startingNo>10000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="8547DE01C56D4C67A28F37AA5E72046D" identifier="Proposal">
@@ -1168,8 +1148,6 @@
<incrementBy>1</incrementBy>
<startingNo>20000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="8CA21B8285CC4C4E8DCAD896DB03213E" identifier="Cash Journal">
@@ -1182,8 +1160,6 @@
<incrementBy>1</incrementBy>
<startingNo>1000000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="949C664EE54A4AA5B23CE288E1677916" identifier="Bank
Statement">
@@ -1196,8 +1172,6 @@
<incrementBy>1</incrementBy>
<startingNo>1000000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="A55E308B07EF453B87ED12516E3C9F7D" identifier="Matched
Invoices">
@@ -1210,8 +1184,6 @@
<incrementBy>1</incrementBy>
<startingNo>1000000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="A6A631F13B004AB8AD39573E95EE992E" identifier="Return
Material">
@@ -1224,8 +1196,6 @@
<incrementBy>1</incrementBy>
<startingNo>40000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="A7C5B67A2BB244A19F475160A5AFCE5E" identifier="Inventory
Move">
@@ -1238,8 +1208,6 @@
<incrementBy>1</incrementBy>
<startingNo>1000000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="AE79ADF07A5E4E6E9C5367505C1C3463" identifier="Purchase
Order">
@@ -1252,8 +1220,6 @@
<incrementBy>1</incrementBy>
<startingNo>800000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="B380E35582BD4D1A930146F1BA72C03F" identifier="GL Journal">
@@ -1266,8 +1232,6 @@
<incrementBy>1</incrementBy>
<startingNo>1000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="B74E4F916A4B4A67BA572CAE835B4049" identifier="AR Credit
Memo">
@@ -1280,8 +1244,6 @@
<incrementBy>1</incrementBy>
<startingNo>300000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="BCF68C60AFAE45358B7D78FCAB3EB783" identifier="Matched
Purchase Orders">
@@ -1294,8 +1256,6 @@
<incrementBy>1</incrementBy>
<startingNo>1000000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="C114BA11CB23468B86887B3619AA52CC" identifier="Depreciation">
@@ -1308,8 +1268,6 @@
<incrementBy>1</incrementBy>
<startingNo>10000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="CF53CE0FBB6B4FBB89C4939E191AFFD4" identifier="Manual
Settlement">
@@ -1322,8 +1280,6 @@
<incrementBy>1</incrementBy>
<startingNo>10000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="EC5B218F09F44618B98FA0D233E3DC70" identifier="AR Invoice">
@@ -1336,8 +1292,6 @@
<incrementBy>1</incrementBy>
<startingNo>100000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="F3659AAEFC2741F788BB474159616023" identifier="AR Receipt">
@@ -1350,8 +1304,6 @@
<incrementBy>1</incrementBy>
<startingNo>400000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="F4F629F131124F198601A47F5FEDF53A" identifier="Credit Order">
@@ -1364,8 +1316,6 @@
<incrementBy>1</incrementBy>
<startingNo>60000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="F6907986413D46C4BE3E27174895CC48" identifier="Warehouse
Order">
@@ -1378,8 +1328,6 @@
<incrementBy>1</incrementBy>
<startingNo>70000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="FE1DFB9999224BE7B1B84B9E5D4CDA0B" identifier="Debt Payment
Management">
@@ -1392,8 +1340,6 @@
<incrementBy>1</incrementBy>
<startingNo>10000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<ADSequence id="FFB42B38D6A34634B534AB499B13644C" identifier="POS Order">
@@ -1406,8 +1352,6 @@
<incrementBy>1</incrementBy>
<startingNo>80000</startingNo>
<usedForRecordID>false</usedForRecordID>
- <prefix xsi:nil="true"/>
- <suffix xsi:nil="true"/>
<restartSequenceEveryYear>false</restartSequenceEveryYear>
</ADSequence>
<DocumentTemplate id="02376C41DA824413A9BE649443924C03" identifier="Purchase
Order Report template">
diff -r 078aeeead4a4 -r 2503a22e795d src-db/database/sourcedata/AD_DATASET.xml
--- a/src-db/database/sourcedata/AD_DATASET.xml Mon Dec 27 16:38:07 2010 +0100
+++ b/src-db/database/sourcedata/AD_DATASET.xml Mon Dec 27 16:47:41 2010 +0100
@@ -40,6 +40,7 @@
<!--10C9DA9D9A6345DC9080E0102492FF1B--> <EXPORT><![CDATA[N]]></EXPORT>
<!--10C9DA9D9A6345DC9080E0102492FF1B-->
<ACCESSLEVEL><![CDATA[3]]></ACCESSLEVEL>
<!--10C9DA9D9A6345DC9080E0102492FF1B-->
<EXPORTALLOWED><![CDATA[Y]]></EXPORTALLOWED>
+<!--10C9DA9D9A6345DC9080E0102492FF1B-->
<CHECKSUM><![CDATA[204303149172035464319244074964864775026]]></CHECKSUM>
<!--10C9DA9D9A6345DC9080E0102492FF1B--></AD_DATASET>
<!--A6A16A6324E0457BA19A13FDD553AD79--><AD_DATASET>
diff -r 078aeeead4a4 -r 2503a22e795d
src-db/database/sourcedata/AD_DATASET_COLUMN.xml
--- a/src-db/database/sourcedata/AD_DATASET_COLUMN.xml Mon Dec 27 16:38:07
2010 +0100
+++ b/src-db/database/sourcedata/AD_DATASET_COLUMN.xml Mon Dec 27 16:47:41
2010 +0100
@@ -88,6 +88,17 @@
<!--3E8948C52363433A855DFE62FEDD4D10-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--3E8948C52363433A855DFE62FEDD4D10--></AD_DATASET_COLUMN>
+<!--4293AE326FEC4B008B2435238C8DEEAC--><AD_DATASET_COLUMN>
+<!--4293AE326FEC4B008B2435238C8DEEAC-->
<AD_DATASET_COLUMN_ID><![CDATA[4293AE326FEC4B008B2435238C8DEEAC]]></AD_DATASET_COLUMN_ID>
+<!--4293AE326FEC4B008B2435238C8DEEAC-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--4293AE326FEC4B008B2435238C8DEEAC--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--4293AE326FEC4B008B2435238C8DEEAC--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--4293AE326FEC4B008B2435238C8DEEAC-->
<AD_DATASET_TABLE_ID><![CDATA[9C778F02DE2A4E10B8449257A460E985]]></AD_DATASET_TABLE_ID>
+<!--4293AE326FEC4B008B2435238C8DEEAC-->
<AD_COLUMN_ID><![CDATA[224]]></AD_COLUMN_ID>
+<!--4293AE326FEC4B008B2435238C8DEEAC--> <ISEXCLUDED><![CDATA[Y]]></ISEXCLUDED>
+<!--4293AE326FEC4B008B2435238C8DEEAC-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--4293AE326FEC4B008B2435238C8DEEAC--></AD_DATASET_COLUMN>
+
<!--4C388E5C3B974A4682C1A860B38DDE44--><AD_DATASET_COLUMN>
<!--4C388E5C3B974A4682C1A860B38DDE44-->
<AD_DATASET_COLUMN_ID><![CDATA[4C388E5C3B974A4682C1A860B38DDE44]]></AD_DATASET_COLUMN_ID>
<!--4C388E5C3B974A4682C1A860B38DDE44-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -220,6 +231,17 @@
<!--A74ADF208CD745488BFC14AB28A110A8-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--A74ADF208CD745488BFC14AB28A110A8--></AD_DATASET_COLUMN>
+<!--D0B4435AE837474F8FC8EFF65AF5DE0E--><AD_DATASET_COLUMN>
+<!--D0B4435AE837474F8FC8EFF65AF5DE0E-->
<AD_DATASET_COLUMN_ID><![CDATA[D0B4435AE837474F8FC8EFF65AF5DE0E]]></AD_DATASET_COLUMN_ID>
+<!--D0B4435AE837474F8FC8EFF65AF5DE0E-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D0B4435AE837474F8FC8EFF65AF5DE0E--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D0B4435AE837474F8FC8EFF65AF5DE0E--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D0B4435AE837474F8FC8EFF65AF5DE0E-->
<AD_DATASET_TABLE_ID><![CDATA[9C778F02DE2A4E10B8449257A460E985]]></AD_DATASET_TABLE_ID>
+<!--D0B4435AE837474F8FC8EFF65AF5DE0E-->
<AD_COLUMN_ID><![CDATA[223]]></AD_COLUMN_ID>
+<!--D0B4435AE837474F8FC8EFF65AF5DE0E--> <ISEXCLUDED><![CDATA[Y]]></ISEXCLUDED>
+<!--D0B4435AE837474F8FC8EFF65AF5DE0E-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
------------------------------------------------------------------------------
Learn how Oracle Real Application Clusters (RAC) One Node allows customers
to consolidate database storage, standardize their database environment, and,
should the need arise, upgrade to a full multi-node Oracle RAC database
without downtime or disruption
http://p.sf.net/sfu/oracle-sfdevnl
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
