[Reconciliation-refactor] Add bsl GL Item & Transaction GL Item to Match Statement grid
authorUnai Martirena <unai.martirena@openbravo.com>
Mon, 08 Sep 2014 18:17:24 +0200
changeset 24649 ab2d490395a9
parent 24648 65f8be217a37
child 24650 4c0485df9e93
[Reconciliation-refactor] Add bsl GL Item & Transaction GL Item to Match Statement grid
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml	Mon Sep 08 17:16:31 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml	Mon Sep 08 18:17:24 2014 +0200
@@ -1056,6 +1056,39 @@
 <!--2298A150A1A146FCB0D016E5BE55A607-->  <ENTITY_ALIAS><![CDATA[@salesOrderNo@]]></ENTITY_ALIAS>
 <!--2298A150A1A146FCB0D016E5BE55A607--></AD_COLUMN>
 
+<!--236A1662276B4003A65D00B627269BCC--><AD_COLUMN>
+<!--236A1662276B4003A65D00B627269BCC-->  <AD_COLUMN_ID><![CDATA[236A1662276B4003A65D00B627269BCC]]></AD_COLUMN_ID>
+<!--236A1662276B4003A65D00B627269BCC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--236A1662276B4003A65D00B627269BCC-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--236A1662276B4003A65D00B627269BCC-->  <NAME><![CDATA[GL Item]]></NAME>
+<!--236A1662276B4003A65D00B627269BCC-->  <COLUMNNAME><![CDATA[glitemName]]></COLUMNNAME>
+<!--236A1662276B4003A65D00B627269BCC-->  <AD_TABLE_ID><![CDATA[BC21981DCF0846338D631887BEDFE7FA]]></AD_TABLE_ID>
+<!--236A1662276B4003A65D00B627269BCC-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--236A1662276B4003A65D00B627269BCC-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--236A1662276B4003A65D00B627269BCC-->  <SEQNO><![CDATA[180]]></SEQNO>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--236A1662276B4003A65D00B627269BCC-->  <AD_ELEMENT_ID><![CDATA[84BE5B4B939FBA28E040007F0100040B]]></AD_ELEMENT_ID>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--236A1662276B4003A65D00B627269BCC-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--236A1662276B4003A65D00B627269BCC-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--236A1662276B4003A65D00B627269BCC-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--236A1662276B4003A65D00B627269BCC-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--236A1662276B4003A65D00B627269BCC-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--236A1662276B4003A65D00B627269BCC-->  <ENTITY_ALIAS><![CDATA[glitem.name]]></ENTITY_ALIAS>
+<!--236A1662276B4003A65D00B627269BCC--></AD_COLUMN>
+
 <!--245E331747AE48FD9677042751BB6918--><AD_COLUMN>
 <!--245E331747AE48FD9677042751BB6918-->  <AD_COLUMN_ID><![CDATA[245E331747AE48FD9677042751BB6918]]></AD_COLUMN_ID>
 <!--245E331747AE48FD9677042751BB6918-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -1578,14 +1611,11 @@
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--2F906856D85B4F87B0E9203A2AA25195-->  <NAME><![CDATA[GL Item]]></NAME>
-<!--2F906856D85B4F87B0E9203A2AA25195-->  <DESCRIPTION><![CDATA[G/L Items  added as part of a given payment]]></DESCRIPTION>
-<!--2F906856D85B4F87B0E9203A2AA25195-->  <HELP><![CDATA[G/L Items  added as part of a given payment]]></HELP>
-<!--2F906856D85B4F87B0E9203A2AA25195-->  <COLUMNNAME><![CDATA[gLItem]]></COLUMNNAME>
+<!--2F906856D85B4F87B0E9203A2AA25195-->  <NAME><![CDATA[Transaction GL Item]]></NAME>
+<!--2F906856D85B4F87B0E9203A2AA25195-->  <COLUMNNAME><![CDATA[transactionGLItemName]]></COLUMNNAME>
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <AD_TABLE_ID><![CDATA[BC21981DCF0846338D631887BEDFE7FA]]></AD_TABLE_ID>
-<!--2F906856D85B4F87B0E9203A2AA25195-->  <AD_REFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></AD_REFERENCE_ID>
-<!--2F906856D85B4F87B0E9203A2AA25195-->  <AD_REFERENCE_VALUE_ID><![CDATA[1A6C5E0A5868417786ECCF3C02B17D65]]></AD_REFERENCE_VALUE_ID>
-<!--2F906856D85B4F87B0E9203A2AA25195-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--2F906856D85B4F87B0E9203A2AA25195-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--2F906856D85B4F87B0E9203A2AA25195-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <ISPARENT><![CDATA[N]]></ISPARENT>
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
@@ -1595,7 +1625,7 @@
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--2F906856D85B4F87B0E9203A2AA25195-->  <AD_ELEMENT_ID><![CDATA[DABC92A3E32E4DBFB78068CF6A4FBAC7]]></AD_ELEMENT_ID>
+<!--2F906856D85B4F87B0E9203A2AA25195-->  <AD_ELEMENT_ID><![CDATA[692B61D596B34DD9BB68EAEDBA067BCD]]></AD_ELEMENT_ID>
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
@@ -1606,7 +1636,7 @@
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
 <!--2F906856D85B4F87B0E9203A2AA25195-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
-<!--2F906856D85B4F87B0E9203A2AA25195-->  <ENTITY_ALIAS><![CDATA[bsl.gLItem]]></ENTITY_ALIAS>
+<!--2F906856D85B4F87B0E9203A2AA25195-->  <ENTITY_ALIAS><![CDATA[transactionGLItem.name]]></ENTITY_ALIAS>
 <!--2F906856D85B4F87B0E9203A2AA25195--></AD_COLUMN>
 
 <!--2FB2ED6DC8BD45D8881E50F5ABB122F2--><AD_COLUMN>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml	Mon Sep 08 17:16:31 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_ELEMENT.xml	Mon Sep 08 18:17:24 2014 +0200
@@ -440,6 +440,18 @@
 <!--6548FAC738E2475F866F132AF5CF5532-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--6548FAC738E2475F866F132AF5CF5532--></AD_ELEMENT>
 
+<!--692B61D596B34DD9BB68EAEDBA067BCD--><AD_ELEMENT>
+<!--692B61D596B34DD9BB68EAEDBA067BCD-->  <AD_ELEMENT_ID><![CDATA[692B61D596B34DD9BB68EAEDBA067BCD]]></AD_ELEMENT_ID>
+<!--692B61D596B34DD9BB68EAEDBA067BCD-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--692B61D596B34DD9BB68EAEDBA067BCD-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--692B61D596B34DD9BB68EAEDBA067BCD-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--692B61D596B34DD9BB68EAEDBA067BCD-->  <COLUMNNAME><![CDATA[transactionGLItemName]]></COLUMNNAME>
+<!--692B61D596B34DD9BB68EAEDBA067BCD-->  <NAME><![CDATA[Transaction GL Item]]></NAME>
+<!--692B61D596B34DD9BB68EAEDBA067BCD-->  <PRINTNAME><![CDATA[Transaction GL Item]]></PRINTNAME>
+<!--692B61D596B34DD9BB68EAEDBA067BCD-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--692B61D596B34DD9BB68EAEDBA067BCD-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--692B61D596B34DD9BB68EAEDBA067BCD--></AD_ELEMENT>
+
 <!--6BC644F4DC3248E2998DE88C055826B2--><AD_ELEMENT>
 <!--6BC644F4DC3248E2998DE88C055826B2-->  <AD_ELEMENT_ID><![CDATA[6BC644F4DC3248E2998DE88C055826B2]]></AD_ELEMENT_ID>
 <!--6BC644F4DC3248E2998DE88C055826B2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml	Mon Sep 08 17:16:31 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml	Mon Sep 08 18:17:24 2014 +0200
@@ -12504,7 +12504,7 @@
 <!--932527125A7947FE8C0610955B9EA997-->  <PROPERTY><![CDATA[matchedDocument]]></PROPERTY>
 <!--932527125A7947FE8C0610955B9EA997-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--932527125A7947FE8C0610955B9EA997-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--932527125A7947FE8C0610955B9EA997-->  <DISPLAYLENGTH><![CDATA[0]]></DISPLAYLENGTH>
+<!--932527125A7947FE8C0610955B9EA997-->  <DISPLAYLENGTH><![CDATA[30]]></DISPLAYLENGTH>
 <!--932527125A7947FE8C0610955B9EA997-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
 <!--932527125A7947FE8C0610955B9EA997-->  <SEQNO><![CDATA[65]]></SEQNO>
 <!--932527125A7947FE8C0610955B9EA997-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
@@ -16263,14 +16263,12 @@
 <!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <NAME><![CDATA[GL Item]]></NAME>
-<!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <DESCRIPTION><![CDATA[G/L Items  added as part of a given payment]]></DESCRIPTION>
-<!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <HELP><![CDATA[G/L Items  added as part of a given payment]]></HELP>
 <!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
 <!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <AD_TAB_ID><![CDATA[ED54A4E24196476596955286D403461E]]></AD_TAB_ID>
-<!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <AD_COLUMN_ID><![CDATA[2F906856D85B4F87B0E9203A2AA25195]]></AD_COLUMN_ID>
+<!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <AD_COLUMN_ID><![CDATA[236A1662276B4003A65D00B627269BCC]]></AD_COLUMN_ID>
 <!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
 <!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <SEQNO><![CDATA[33]]></SEQNO>
 <!--B183A6C4D62D49568BD1044FC4B0C2B6-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
@@ -18888,6 +18886,32 @@
 <!--D1B72C2B0B8B4B948E4FFC0165512895-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--D1B72C2B0B8B4B948E4FFC0165512895--></AD_FIELD>
 
+<!--D1CAE328642A4FF0A743EF630BDDE471--><AD_FIELD>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <AD_FIELD_ID><![CDATA[D1CAE328642A4FF0A743EF630BDDE471]]></AD_FIELD_ID>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <NAME><![CDATA[Transaction GL Item]]></NAME>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <AD_TAB_ID><![CDATA[ED54A4E24196476596955286D403461E]]></AD_TAB_ID>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <AD_COLUMN_ID><![CDATA[2F906856D85B4F87B0E9203A2AA25195]]></AD_COLUMN_ID>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <DISPLAYLENGTH><![CDATA[60]]></DISPLAYLENGTH>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <SEQNO><![CDATA[105]]></SEQNO>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <AD_MODULE_ID><![CDATA[A918E3331C404B889D69AA9BFAFB23AC]]></AD_MODULE_ID>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--D1CAE328642A4FF0A743EF630BDDE471-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--D1CAE328642A4FF0A743EF630BDDE471--></AD_FIELD>
+
 <!--D24E8C7FEF654C23B14B83A108F17CEC--><AD_FIELD>
 <!--D24E8C7FEF654C23B14B83A108F17CEC-->  <AD_FIELD_ID><![CDATA[D24E8C7FEF654C23B14B83A108F17CEC]]></AD_FIELD_ID>
 <!--D24E8C7FEF654C23B14B83A108F17CEC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -20458,7 +20482,7 @@
 <!--E8482D06BA554D0486BE853CFDE9462C-->  <PROPERTY><![CDATA[transaction.finPayment.referenceNo]]></PROPERTY>
 <!--E8482D06BA554D0486BE853CFDE9462C-->  <IGNOREINWAD><![CDATA[Y]]></IGNOREINWAD>
 <!--E8482D06BA554D0486BE853CFDE9462C-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--E8482D06BA554D0486BE853CFDE9462C-->  <DISPLAYLENGTH><![CDATA[0]]></DISPLAYLENGTH>
+<!--E8482D06BA554D0486BE853CFDE9462C-->  <DISPLAYLENGTH><![CDATA[30]]></DISPLAYLENGTH>
 <!--E8482D06BA554D0486BE853CFDE9462C-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--E8482D06BA554D0486BE853CFDE9462C-->  <SEQNO><![CDATA[95]]></SEQNO>
 <!--E8482D06BA554D0486BE853CFDE9462C-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
--- a/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml	Mon Sep 08 17:16:31 2014 +0200
+++ b/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_TABLE.xml	Mon Sep 08 18:17:24 2014 +0200
@@ -204,13 +204,15 @@
 <!--BC21981DCF0846338D631887BEDFE7FA-->  <HQLQUERY><![CDATA[select bsl.transactionDate as banklineDate, case when bp is null then bsl.bpartnername  else bp.name end AS businessPartner, bsl.referenceNo as referenceNo, bsl.cramount - bsl.dramount as amount, bsl.id as match, bsl.matchingtype as affinity, 
 case when fat is null then false else true end AS cleared,
 bsl.matchingtype as matchingtype, bsl.id as id, 
-fat.transactionDate as transactionDate, transactionBP.name as transactionBPName, fat.depositAmount - fat.paymentAmount as transactionAmount, bsl.lineNo as lineNo, fat as fin_finacc_transaction_id, bsl.description, case when bsl.cramount - bsl.dramount >0 then 'D' else 'P' end as type, bsl.matchedDocument, bsl.gLItem
+fat.transactionDate as transactionDate, transactionBP.name as transactionBPName, fat.depositAmount - fat.paymentAmount as transactionAmount, bsl.lineNo as lineNo, fat as fin_finacc_transaction_id, bsl.description, case when bsl.cramount - bsl.dramount >0 then 'D' else 'P' end as type, bsl.matchedDocument, transactionGLItem.name as transactionGLItemName, glitem.name as glitemName
  @selectClause@
 from FIN_BankStatementLine as bsl
  join bsl.bankStatement as bs
 left outer join bsl.financialAccountTransaction as fat
 left outer join bsl.businessPartner AS bp
 left outer join fat.businessPartner as transactionBP
+left outer join fat.gLItem as transactionGLItem
+left outer join bsl.gLItem as glitem
 @joinClause@
 where @additional_filters@
 and bs.processed = 'Y'