details: /erp/devel/pi/rev/8b43579700c5
changeset: 10292:8b43579700c5
user: David Alsasua <david.alsasua <at> openbravo.com>
date: Tue Feb 01 16:17:18 2011 +0100
summary: Issue 15833: DB Inconsistency in Sample Data. Step 1.
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
details: /erp/devel/pi/rev/d8e596990146
changeset: 10293:d8e596990146
user: David Alsasua <david.alsasua <at> openbravo.com>
date: Wed Feb 02 01:14:21 2011 +0100
summary: Issue 15833: DB Inconsistency in Sample Data. Step 2.
- Created new regions, no present in core, but in Spanish Regions modules
- Removed passwords from users of the client
details: /erp/devel/pi/rev/fe93148fa4a7
changeset: 10294:fe93148fa4a7
user: David Alsasua <david.alsasua <at> openbravo.com>
date: Wed Feb 02 01:35:22 2011 +0100
summary: Issue 15833: DB Inconsistency in Sample Data. Step 3.
- Posted the not-posted documents
details: /erp/devel/pi/rev/99f6fa0c1059
changeset: 10295:99f6fa0c1059
user: David Alsasua <david.alsasua <at> openbravo.com>
date: Wed Feb 02 01:39:09 2011 +0100
summary: Issue 15833: DB Inconsistency in Sample Data. Step 4.
- Added the AdClientModule entry for core dataset.
diffstat:
referencedata/sampledata/F_B_International_Group.xml | 5306 +++++++++++++++--
src-db/database/sourcedata/AD_DATASET_TABLE.xml | 335 +-
2 files changed, 4963 insertions(+), 678 deletions(-)
diffs (truncated from 8976 to 300 lines):
diff -r cd2222d2b80b -r 99f6fa0c1059
referencedata/sampledata/F_B_International_Group.xml
--- a/referencedata/sampledata/F_B_International_Group.xml Tue Feb 01
17:19:07 2011 +0100
+++ b/referencedata/sampledata/F_B_International_Group.xml Wed Feb 02
01:39:09 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>
------------------------------------------------------------------------------
Special Offer-- Download ArcSight Logger for FREE (a $49 USD value)!
Finally, a world-class log management solution at an even better price-free!
Download using promo code Free_Logger_4_Dev2Dev. Offer expires
February 28th, so secure your free ArcSight Logger TODAY!
http://p.sf.net/sfu/arcsight-sfd2d
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
