details:   /erp/devel/pi/rev/3ec8fa8b6742
changeset: 10393:3ec8fa8b6742
user:      David Alsasua <david.alsasua <at> openbravo.com>
date:      Sun Feb 06 17:34:56 2011 +0100
summary:   Fixes issue 15833. DB Inconsistency in Sample Data
Dataset Definition changed, so exported tables are the same than in the 
original environment -the one where F&B client was created-, and in the same 
order.
Added changes to F&B Client xml file for:
- New Table FIN_Finacc_Transaction
- New Window Payment Priority
- New Process Update Payment Plan
- fINPaymentPriority and updatePaymentPlan new columns in FIN_Payment_Schedule 
table
- fINPaymentPriority column in Order and Invoice tables
- createdByAlgorithm column in FIN_Payment and FIN_Finacc_Transaction tables
- Created new regions, no present in core, but in Spanish Regions modules
- Removed passwords from users of the client
- Posted the not-posted documents
- Added the AdClientModule entry for core dataset.
Also fixed some jUnit tests that relay it's successful execution on demo data 
content
Also src/build.xml fixed, so QA_Testing client can be exported.

details:   /erp/devel/pi/rev/2f2b3b6434c5
changeset: 10394:2f2b3b6434c5
user:      David Alsasua <david.alsasua <at> openbravo.com>
date:      Mon Feb 07 08:43:43 2011 +0100
summary:   DB Sync: F&B client, new position for editLineAmount flag

diffstat:

 referencedata/sampledata/F_B_International_Group.xml              |  5884 
++++++++-
 src-db/database/sourcedata/AD_DATASET_TABLE.xml                   |   307 +
 src-test/org/openbravo/test/base/BaseTest.java                    |     6 +-
 src-test/org/openbravo/test/xml/EntityXMLImportTestReference.java |     8 +-
 src-test/org/openbravo/test/xml/EntityXMLImportTestSingle.java    |   136 +-
 src-test/org/openbravo/test/xml/EntityXMLImportTestWarning.java   |    93 +-
 src-test/org/openbravo/test/xml/XMLBaseTest.java                  |    18 +-
 src/build.xml                                                     |     2 +-
 8 files changed, 5292 insertions(+), 1162 deletions(-)

diffs (truncated from 11734 to 300 lines):

diff -r 8043cc3be7b1 -r 2f2b3b6434c5 
referencedata/sampledata/F_B_International_Group.xml
--- a/referencedata/sampledata/F_B_International_Group.xml      Mon Feb 07 
09:08:03 2011 +0100
+++ b/referencedata/sampledata/F_B_International_Group.xml      Mon Feb 07 
08:43:43 2011 +0100
@@ -3381,6 +3381,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>991.26</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="0360300C54A549B7916E3F13A65E564E">
     <id>0360300C54A549B7916E3F13A65E564E</id>
@@ -3395,6 +3397,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>486.75</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="04240AE21F404CAFA006EC9F1E2C7729">
     <id>04240AE21F404CAFA006EC9F1E2C7729</id>
@@ -3409,6 +3413,8 @@
     <paidAmount>97.94</paidAmount>
     <outstandingAmount>491.77</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="075A19F10EAB4078BB035497FE715BEA">
     <id>075A19F10EAB4078BB035497FE715BEA</id>
@@ -3423,6 +3429,8 @@
     <paidAmount>235.17</paidAmount>
     <outstandingAmount>0.00</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="14F9E6E00C714AAD94066121346BA33A">
     <id>14F9E6E00C714AAD94066121346BA33A</id>
@@ -3437,6 +3445,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>221.25</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="172653A73C914F799F91796F46C28EC8">
     <id>172653A73C914F799F91796F46C28EC8</id>
@@ -3451,6 +3461,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>59.13</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="18EA13E435644D1F834CB6B78CB485F9">
     <id>18EA13E435644D1F834CB6B78CB485F9</id>
@@ -3465,6 +3477,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>132.75</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="1D856704ACA449B9ACC495219749A296">
     <id>1D856704ACA449B9ACC495219749A296</id>
@@ -3479,6 +3493,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>197.02</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="21F54639FDBE4BE4842DC5DC98EF18C4">
     <id>21F54639FDBE4BE4842DC5DC98EF18C4</id>
@@ -3493,6 +3509,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>277.66</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="23BB3806DC8C4A64868AEF9D68965E59">
     <id>23BB3806DC8C4A64868AEF9D68965E59</id>
@@ -3507,6 +3525,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>93.30</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="246BF88292B74DA19D492A4AE22E36F8">
     <id>246BF88292B74DA19D492A4AE22E36F8</id>
@@ -3521,6 +3541,8 @@
     <paidAmount>0.31</paidAmount>
     <outstandingAmount>368.37</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="282EBB821BED4B95BF5F704FA69667EA">
     <id>282EBB821BED4B95BF5F704FA69667EA</id>
@@ -3535,6 +3557,8 @@
     <paidAmount>49.53</paidAmount>
     <outstandingAmount>708.84</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="285C706A9A1348BFA0FA2F838BFCFC75">
     <id>285C706A9A1348BFA0FA2F838BFCFC75</id>
@@ -3549,6 +3573,8 @@
     <paidAmount>1383.20</paidAmount>
     <outstandingAmount>825.23</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="28B93921F4294DDFAC383CAD931C6285">
     <id>28B93921F4294DDFAC383CAD931C6285</id>
@@ -3563,6 +3589,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>70.98</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="29F55DB553E54A05802BE1AA0D5D27B5">
     <id>29F55DB553E54A05802BE1AA0D5D27B5</id>
@@ -3577,6 +3605,8 @@
     <paidAmount>262.55</paidAmount>
     <outstandingAmount>0.00</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="2A7E43AF578D4E379E99B0C605498305">
     <id>2A7E43AF578D4E379E99B0C605498305</id>
@@ -3591,6 +3621,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>654.90</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="2AB6A499FC9F425A8C1AF1F598820681">
     <id>2AB6A499FC9F425A8C1AF1F598820681</id>
@@ -3605,6 +3637,8 @@
     <paidAmount>149.65</paidAmount>
     <outstandingAmount>189.25</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="2E7ABC8B0DCA4E3F85FC8489A76A2676">
     <id>2E7ABC8B0DCA4E3F85FC8489A76A2676</id>
@@ -3619,6 +3653,8 @@
     <paidAmount>846.06</paidAmount>
     <outstandingAmount>0.00</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="2F4289E31F62448C9E97E69726421EC6">
     <id>2F4289E31F62448C9E97E69726421EC6</id>
@@ -3633,6 +3669,8 @@
     <paidAmount>1307.23</paidAmount>
     <outstandingAmount>39.60</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="3469E345EDCB47918A8E8A18366EF6BB">
     <id>3469E345EDCB47918A8E8A18366EF6BB</id>
@@ -3647,6 +3685,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>83.15</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="3B3B76B74A3D4AC49D42C6641EFE4311">
     <id>3B3B76B74A3D4AC49D42C6641EFE4311</id>
@@ -3661,6 +3701,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>1642.10</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="3D635ECFF7CF4E3DA100BC530FB4138C">
     <id>3D635ECFF7CF4E3DA100BC530FB4138C</id>
@@ -3675,6 +3717,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>286.73</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="41C471B86CDB43A19215917090351CAB">
     <id>41C471B86CDB43A19215917090351CAB</id>
@@ -3689,6 +3733,8 @@
     <paidAmount>1175.28</paidAmount>
     <outstandingAmount>0.00</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="44237D8FFEFD4768B06F468D3D1DD020">
     <id>44237D8FFEFD4768B06F468D3D1DD020</id>
@@ -3703,6 +3749,8 @@
     <paidAmount>110.14</paidAmount>
     <outstandingAmount>0.00</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="461490FB74F1461DA31A7A83DF016D4D">
     <id>461490FB74F1461DA31A7A83DF016D4D</id>
@@ -3717,6 +3765,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>215.92</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="4715416EC599408BA6666A7A187FA2F0">
     <id>4715416EC599408BA6666A7A187FA2F0</id>
@@ -3731,6 +3781,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>132.75</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="473AE21E8ADA4F9C9B0FFF446A23B14B">
     <id>473AE21E8ADA4F9C9B0FFF446A23B14B</id>
@@ -3745,6 +3797,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>168.03</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="49D88E8E216B4D7AB6A16D793E9E3D7A">
     <id>49D88E8E216B4D7AB6A16D793E9E3D7A</id>
@@ -3759,6 +3813,8 @@
     <paidAmount>110.63</paidAmount>
     <outstandingAmount>0.00</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="4BD8464362384ECF962B2D4F53098DCC">
     <id>4BD8464362384ECF962B2D4F53098DCC</id>
@@ -3773,6 +3829,8 @@
     <paidAmount>1383.20</paidAmount>
     <outstandingAmount>0.00</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="4E87368458D746C48B02903614E66C4F">
     <id>4E87368458D746C48B02903614E66C4F</id>
@@ -3787,6 +3845,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>142.66</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="4FAC352379AC4F9792CCCCEE1938E023">
     <id>4FAC352379AC4F9792CCCCEE1938E023</id>
@@ -3801,6 +3861,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>513.01</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="509C2FF931C44677AF20CFA7C92722C7">
     <id>509C2FF931C44677AF20CFA7C92722C7</id>
@@ -3815,6 +3877,8 @@
     <paidAmount>0</paidAmount>
     <outstandingAmount>146.91</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="51F896DE9C964403A51DA9D3D85F22FD">
     <id>51F896DE9C964403A51DA9D3D85F22FD</id>
@@ -3829,6 +3893,8 @@
     <paidAmount>628.79</paidAmount>
     <outstandingAmount>0.00</outstandingAmount>
     <active>true</active>
+    <fINPaymentPriority xsi:nil="true"/>
+    <updatePaymentPlan>true</updatePaymentPlan>
   </FIN_Payment_Schedule>
   <FIN_Payment_Schedule id="522C9D04D9214222AFEB730726FF5E4C">
     <id>522C9D04D9214222AFEB730726FF5E4C</id>

------------------------------------------------------------------------------
The modern datacenter depends on network connectivity to access resources
and provide services. The best practices for maximizing a physical server's
connectivity to a physical network are well understood - see how these
rules translate into the virtual world? 
http://p.sf.net/sfu/oracle-sfdevnlfb
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits

Reply via email to