[costadj]Add line no to lc cost.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Wed, 03 Sep 2014 13:46:43 +0200
changeset 24856 2462329b5344
parent 24855 9d1d0227e859
child 24857 77ea1cf6f335
[costadj]Add line no to lc cost.
src-db/database/model/tables/M_LC_COST.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_FIELD.xml
src-db/database/sourcedata/AD_TABLE.xml
--- a/src-db/database/model/tables/M_LC_COST.xml	Wed Sep 03 12:56:16 2014 +0200
+++ b/src-db/database/model/tables/M_LC_COST.xml	Wed Sep 03 13:46:43 2014 +0200
@@ -73,6 +73,10 @@
         <default><![CDATA[N]]></default>
         <onCreateDefault/>
       </column>
+      <column name="LINE" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_CLIENT" name="M_LC_COST_CLIENT">
         <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
       </foreign-key>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Wed Sep 03 12:56:16 2014 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Wed Sep 03 13:46:43 2014 +0200
@@ -223729,6 +223729,44 @@
 <!--021B9228AB1B4CDA94CE16426C2ED10B-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--021B9228AB1B4CDA94CE16426C2ED10B--></AD_COLUMN>
 
+<!--0227873A968BE6FBE050007F01005124--><AD_COLUMN>
+<!--0227873A968BE6FBE050007F01005124-->  <AD_COLUMN_ID><![CDATA[0227873A968BE6FBE050007F01005124]]></AD_COLUMN_ID>
+<!--0227873A968BE6FBE050007F01005124-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0227873A968BE6FBE050007F01005124-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0227873A968BE6FBE050007F01005124-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0227873A968BE6FBE050007F01005124-->  <NAME><![CDATA[Line No.]]></NAME>
+<!--0227873A968BE6FBE050007F01005124-->  <DESCRIPTION><![CDATA[A line stating the position of this request in the document.]]></DESCRIPTION>
+<!--0227873A968BE6FBE050007F01005124-->  <HELP><![CDATA[Indicates the unique line for a document.  It will also control the display order of the lines within a document.]]></HELP>
+<!--0227873A968BE6FBE050007F01005124-->  <COLUMNNAME><![CDATA[Line]]></COLUMNNAME>
+<!--0227873A968BE6FBE050007F01005124-->  <AD_TABLE_ID><![CDATA[55A984C314FD4C4FB5E7C32DE36BB07B]]></AD_TABLE_ID>
+<!--0227873A968BE6FBE050007F01005124-->  <AD_REFERENCE_ID><![CDATA[22]]></AD_REFERENCE_ID>
+<!--0227873A968BE6FBE050007F01005124-->  <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--0227873A968BE6FBE050007F01005124-->  <DEFAULTVALUE><![CDATA[@SQL=SELECT COALESCE(MAX(LINE),0)+10 AS DefaultValue FROM M_LC_COST
+ WHERE (m_landedcost_id is not null and m_landedcost_id =@m_landedcost_id@) 
+   or (m_landedcost_id is null and m_inout_id = @m_inout_id@)]]></DEFAULTVALUE>
+<!--0227873A968BE6FBE050007F01005124-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--0227873A968BE6FBE050007F01005124-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--0227873A968BE6FBE050007F01005124-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--0227873A968BE6FBE050007F01005124-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--0227873A968BE6FBE050007F01005124-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--0227873A968BE6FBE050007F01005124-->  <SEQNO><![CDATA[200]]></SEQNO>
+<!--0227873A968BE6FBE050007F01005124-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--0227873A968BE6FBE050007F01005124-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--0227873A968BE6FBE050007F01005124-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--0227873A968BE6FBE050007F01005124-->  <AD_ELEMENT_ID><![CDATA[439]]></AD_ELEMENT_ID>
+<!--0227873A968BE6FBE050007F01005124-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--0227873A968BE6FBE050007F01005124-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--0227873A968BE6FBE050007F01005124-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--0227873A968BE6FBE050007F01005124-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--0227873A968BE6FBE050007F01005124-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--0227873A968BE6FBE050007F01005124-->  <POSITION><![CDATA[19]]></POSITION>
+<!--0227873A968BE6FBE050007F01005124-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--0227873A968BE6FBE050007F01005124-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--0227873A968BE6FBE050007F01005124-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--0227873A968BE6FBE050007F01005124-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--0227873A968BE6FBE050007F01005124-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--0227873A968BE6FBE050007F01005124--></AD_COLUMN>
+
 <!--0228220C3302481EB86E7B9D50DBA20F--><AD_COLUMN>
 <!--0228220C3302481EB86E7B9D50DBA20F-->  <AD_COLUMN_ID><![CDATA[0228220C3302481EB86E7B9D50DBA20F]]></AD_COLUMN_ID>
 <!--0228220C3302481EB86E7B9D50DBA20F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -296119,6 +296157,40 @@
 <!--9397E02890414B43E040007F0100749D-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--9397E02890414B43E040007F0100749D--></AD_COLUMN>
 
+<!--93AEBCB99493427F8011F63ED6BF0693--><AD_COLUMN>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <AD_COLUMN_ID><![CDATA[93AEBCB99493427F8011F63ED6BF0693]]></AD_COLUMN_ID>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <NAME><![CDATA[Line No.]]></NAME>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <DESCRIPTION><![CDATA[A line stating the position of this request in the document.]]></DESCRIPTION>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <HELP><![CDATA[Indicates the unique line for a document.  It will also control the display order of the lines within a document.]]></HELP>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <COLUMNNAME><![CDATA[line]]></COLUMNNAME>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <AD_TABLE_ID><![CDATA[B2960E2BDCCD4F7599A2433F2681847F]]></AD_TABLE_ID>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <SEQNO><![CDATA[160]]></SEQNO>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <AD_ELEMENT_ID><![CDATA[439]]></AD_ELEMENT_ID>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--93AEBCB99493427F8011F63ED6BF0693-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--93AEBCB99493427F8011F63ED6BF0693--></AD_COLUMN>
+
 <!--93D24B71B01546FABBE63E0C7F5AC24B--><AD_COLUMN>
 <!--93D24B71B01546FABBE63E0C7F5AC24B-->  <AD_COLUMN_ID><![CDATA[93D24B71B01546FABBE63E0C7F5AC24B]]></AD_COLUMN_ID>
 <!--93D24B71B01546FABBE63E0C7F5AC24B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Wed Sep 03 12:56:16 2014 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Wed Sep 03 13:46:43 2014 +0200
@@ -175792,14 +175792,14 @@
 <!--0056819E5168679FE050007F01000569-->  <AD_TAB_ID><![CDATA[1C05058D61AC4B69A7E550F32F9F2873]]></AD_TAB_ID>
 <!--0056819E5168679FE050007F01000569-->  <AD_COLUMN_ID><![CDATA[00568254CB678733E050007F01000513]]></AD_COLUMN_ID>
 <!--0056819E5168679FE050007F01000569-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
-<!--0056819E5168679FE050007F01000569-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--0056819E5168679FE050007F01000569-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
 <!--0056819E5168679FE050007F01000569-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
 <!--0056819E5168679FE050007F01000569-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--0056819E5168679FE050007F01000569-->  <SEQNO><![CDATA[10]]></SEQNO>
 <!--0056819E5168679FE050007F01000569-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--0056819E5168679FE050007F01000569-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--0056819E5168679FE050007F01000569-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--0056819E5168679FE050007F01000569-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--0056819E5168679FE050007F01000569-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
 <!--0056819E5168679FE050007F01000569-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
 <!--0056819E5168679FE050007F01000569-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--0056819E5168679FE050007F01000569-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
@@ -176290,7 +176290,7 @@
 <!--00568254CC038733E050007F01000513-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--00568254CC038733E050007F01000513-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
 <!--00568254CC038733E050007F01000513-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--00568254CC038733E050007F01000513-->  <SEQNO><![CDATA[80]]></SEQNO>
+<!--00568254CC038733E050007F01000513-->  <SEQNO><![CDATA[90]]></SEQNO>
 <!--00568254CC038733E050007F01000513-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--00568254CC038733E050007F01000513-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--00568254CC038733E050007F01000513-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -176317,7 +176317,7 @@
 <!--00568254CC048733E050007F01000513-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--00568254CC048733E050007F01000513-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
 <!--00568254CC048733E050007F01000513-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--00568254CC048733E050007F01000513-->  <SEQNO><![CDATA[70]]></SEQNO>
+<!--00568254CC048733E050007F01000513-->  <SEQNO><![CDATA[80]]></SEQNO>
 <!--00568254CC048733E050007F01000513-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--00568254CC048733E050007F01000513-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--00568254CC048733E050007F01000513-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -176372,7 +176372,7 @@
 <!--00568254CC068733E050007F01000513-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--00568254CC068733E050007F01000513-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
 <!--00568254CC068733E050007F01000513-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--00568254CC068733E050007F01000513-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--00568254CC068733E050007F01000513-->  <SEQNO><![CDATA[20]]></SEQNO>
 <!--00568254CC068733E050007F01000513-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--00568254CC068733E050007F01000513-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--00568254CC068733E050007F01000513-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -176398,7 +176398,7 @@
 <!--00568254CC088733E050007F01000513-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--00568254CC088733E050007F01000513-->  <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
 <!--00568254CC088733E050007F01000513-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--00568254CC088733E050007F01000513-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--00568254CC088733E050007F01000513-->  <SEQNO><![CDATA[40]]></SEQNO>
 <!--00568254CC088733E050007F01000513-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--00568254CC088733E050007F01000513-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--00568254CC088733E050007F01000513-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -176425,7 +176425,7 @@
 <!--00568254CC098733E050007F01000513-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--00568254CC098733E050007F01000513-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
 <!--00568254CC098733E050007F01000513-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--00568254CC098733E050007F01000513-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--00568254CC098733E050007F01000513-->  <SEQNO><![CDATA[60]]></SEQNO>
 <!--00568254CC098733E050007F01000513-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--00568254CC098733E050007F01000513-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--00568254CC098733E050007F01000513-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -176453,7 +176453,7 @@
 <!--00568254CC0A8733E050007F01000513-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--00568254CC0A8733E050007F01000513-->  <DISPLAYLENGTH><![CDATA[2000]]></DISPLAYLENGTH>
 <!--00568254CC0A8733E050007F01000513-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--00568254CC0A8733E050007F01000513-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--00568254CC0A8733E050007F01000513-->  <SEQNO><![CDATA[70]]></SEQNO>
 <!--00568254CC0A8733E050007F01000513-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--00568254CC0A8733E050007F01000513-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--00568254CC0A8733E050007F01000513-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -176481,7 +176481,7 @@
 <!--00568254CC0B8733E050007F01000513-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--00568254CC0B8733E050007F01000513-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
 <!--00568254CC0B8733E050007F01000513-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--00568254CC0B8733E050007F01000513-->  <SEQNO><![CDATA[40]]></SEQNO>
+<!--00568254CC0B8733E050007F01000513-->  <SEQNO><![CDATA[50]]></SEQNO>
 <!--00568254CC0B8733E050007F01000513-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--00568254CC0B8733E050007F01000513-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--00568254CC0B8733E050007F01000513-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -177715,11 +177715,11 @@
 <!--01DDF96C83A3E76DE050007F01002DBF-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--01DDF96C83A3E76DE050007F01002DBF-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
 <!--01DDF96C83A3E76DE050007F01002DBF-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--01DDF96C83A3E76DE050007F01002DBF-->  <SEQNO><![CDATA[20]]></SEQNO>
+<!--01DDF96C83A3E76DE050007F01002DBF-->  <SEQNO><![CDATA[30]]></SEQNO>
 <!--01DDF96C83A3E76DE050007F01002DBF-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--01DDF96C83A3E76DE050007F01002DBF-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--01DDF96C83A3E76DE050007F01002DBF-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--01DDF96C83A3E76DE050007F01002DBF-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--01DDF96C83A3E76DE050007F01002DBF-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
 <!--01DDF96C83A3E76DE050007F01002DBF-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
 <!--01DDF96C83A3E76DE050007F01002DBF-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--01DDF96C83A3E76DE050007F01002DBF-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
@@ -177904,7 +177904,7 @@
 <!--0203C2BF22362AE9E050007F01002C80-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--0203C2BF22362AE9E050007F01002C80-->  <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH>
 <!--0203C2BF22362AE9E050007F01002C80-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--0203C2BF22362AE9E050007F01002C80-->  <SEQNO><![CDATA[80]]></SEQNO>
+<!--0203C2BF22362AE9E050007F01002C80-->  <SEQNO><![CDATA[90]]></SEQNO>
 <!--0203C2BF22362AE9E050007F01002C80-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--0203C2BF22362AE9E050007F01002C80-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--0203C2BF22362AE9E050007F01002C80-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -177931,7 +177931,7 @@
 <!--0203C2BF22372AE9E050007F01002C80-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--0203C2BF22372AE9E050007F01002C80-->  <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH>
 <!--0203C2BF22372AE9E050007F01002C80-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
-<!--0203C2BF22372AE9E050007F01002C80-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--0203C2BF22372AE9E050007F01002C80-->  <SEQNO><![CDATA[60]]></SEQNO>
 <!--0203C2BF22372AE9E050007F01002C80-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--0203C2BF22372AE9E050007F01002C80-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--0203C2BF22372AE9E050007F01002C80-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -177955,9 +177955,9 @@
 <!--0203C2BF22382AE9E050007F01002C80-->  <AD_COLUMN_ID><![CDATA[9F43BAAC73824C0F81ACDD813AF7BB31]]></AD_COLUMN_ID>
 <!--0203C2BF22382AE9E050007F01002C80-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--0203C2BF22382AE9E050007F01002C80-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--0203C2BF22382AE9E050007F01002C80-->  <DISPLAYLENGTH><![CDATA[2000]]></DISPLAYLENGTH>
+<!--0203C2BF22382AE9E050007F01002C80-->  <DISPLAYLENGTH><![CDATA[200]]></DISPLAYLENGTH>
 <!--0203C2BF22382AE9E050007F01002C80-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
-<!--0203C2BF22382AE9E050007F01002C80-->  <SEQNO><![CDATA[70]]></SEQNO>
+<!--0203C2BF22382AE9E050007F01002C80-->  <SEQNO><![CDATA[80]]></SEQNO>
 <!--0203C2BF22382AE9E050007F01002C80-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--0203C2BF22382AE9E050007F01002C80-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--0203C2BF22382AE9E050007F01002C80-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -177981,9 +177981,9 @@
 <!--0203C2BF22392AE9E050007F01002C80-->  <AD_COLUMN_ID><![CDATA[4F7C1C08EE95455B9FAF27E87AF53ED7]]></AD_COLUMN_ID>
 <!--0203C2BF22392AE9E050007F01002C80-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--0203C2BF22392AE9E050007F01002C80-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--0203C2BF22392AE9E050007F01002C80-->  <DISPLAYLENGTH><![CDATA[2000]]></DISPLAYLENGTH>
+<!--0203C2BF22392AE9E050007F01002C80-->  <DISPLAYLENGTH><![CDATA[200]]></DISPLAYLENGTH>
 <!--0203C2BF22392AE9E050007F01002C80-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
-<!--0203C2BF22392AE9E050007F01002C80-->  <SEQNO><![CDATA[100]]></SEQNO>
+<!--0203C2BF22392AE9E050007F01002C80-->  <SEQNO><![CDATA[110]]></SEQNO>
 <!--0203C2BF22392AE9E050007F01002C80-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--0203C2BF22392AE9E050007F01002C80-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--0203C2BF22392AE9E050007F01002C80-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -178007,9 +178007,9 @@
 <!--0203C2BF223A2AE9E050007F01002C80-->  <AD_COLUMN_ID><![CDATA[B2B7084BA8D54DB584DE426B355B0C95]]></AD_COLUMN_ID>
 <!--0203C2BF223A2AE9E050007F01002C80-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--0203C2BF223A2AE9E050007F01002C80-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--0203C2BF223A2AE9E050007F01002C80-->  <DISPLAYLENGTH><![CDATA[2000]]></DISPLAYLENGTH>
+<!--0203C2BF223A2AE9E050007F01002C80-->  <DISPLAYLENGTH><![CDATA[200]]></DISPLAYLENGTH>
 <!--0203C2BF223A2AE9E050007F01002C80-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
-<!--0203C2BF223A2AE9E050007F01002C80-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--0203C2BF223A2AE9E050007F01002C80-->  <SEQNO><![CDATA[70]]></SEQNO>
 <!--0203C2BF223A2AE9E050007F01002C80-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--0203C2BF223A2AE9E050007F01002C80-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--0203C2BF223A2AE9E050007F01002C80-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -178035,7 +178035,7 @@
 <!--0203C2BF223B2AE9E050007F01002C80-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--0203C2BF223B2AE9E050007F01002C80-->  <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH>
 <!--0203C2BF223B2AE9E050007F01002C80-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
-<!--0203C2BF223B2AE9E050007F01002C80-->  <SEQNO><![CDATA[90]]></SEQNO>
+<!--0203C2BF223B2AE9E050007F01002C80-->  <SEQNO><![CDATA[100]]></SEQNO>
 <!--0203C2BF223B2AE9E050007F01002C80-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--0203C2BF223B2AE9E050007F01002C80-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--0203C2BF223B2AE9E050007F01002C80-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -178138,9 +178138,9 @@
 <!--02138BD028B3719BE050007F01001709-->  <AD_COLUMN_ID><![CDATA[8A718B77477545B99732A6DEBDD3333B]]></AD_COLUMN_ID>
 <!--02138BD028B3719BE050007F01001709-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--02138BD028B3719BE050007F01001709-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--02138BD028B3719BE050007F01001709-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--02138BD028B3719BE050007F01001709-->  <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH>
 <!--02138BD028B3719BE050007F01001709-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
-<!--02138BD028B3719BE050007F01001709-->  <SEQNO><![CDATA[110]]></SEQNO>
+<!--02138BD028B3719BE050007F01001709-->  <SEQNO><![CDATA[120]]></SEQNO>
 <!--02138BD028B3719BE050007F01001709-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--02138BD028B3719BE050007F01001709-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--02138BD028B3719BE050007F01001709-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -178165,9 +178165,9 @@
 <!--02138BD7992C668FE050007F01007E3C-->  <AD_COLUMN_ID><![CDATA[DA008DA6FEB4414792C4DACE4FE66766]]></AD_COLUMN_ID>
 <!--02138BD7992C668FE050007F01007E3C-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--02138BD7992C668FE050007F01007E3C-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--02138BD7992C668FE050007F01007E3C-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--02138BD7992C668FE050007F01007E3C-->  <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH>
 <!--02138BD7992C668FE050007F01007E3C-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--02138BD7992C668FE050007F01007E3C-->  <SEQNO><![CDATA[120]]></SEQNO>
+<!--02138BD7992C668FE050007F01007E3C-->  <SEQNO><![CDATA[130]]></SEQNO>
 <!--02138BD7992C668FE050007F01007E3C-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--02138BD7992C668FE050007F01007E3C-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--02138BD7992C668FE050007F01007E3C-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -178290,6 +178290,90 @@
 <!--0225887EA009405889C9308DA08E7B64-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--0225887EA009405889C9308DA08E7B64--></AD_FIELD>
 
+<!--0227A74434844625E050007F0100514D--><AD_FIELD>
+<!--0227A74434844625E050007F0100514D-->  <AD_FIELD_ID><![CDATA[0227A74434844625E050007F0100514D]]></AD_FIELD_ID>
+<!--0227A74434844625E050007F0100514D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0227A74434844625E050007F0100514D-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0227A74434844625E050007F0100514D-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0227A74434844625E050007F0100514D-->  <NAME><![CDATA[Line No.]]></NAME>
+<!--0227A74434844625E050007F0100514D-->  <DESCRIPTION><![CDATA[A line stating the position of this request in the document.]]></DESCRIPTION>
+<!--0227A74434844625E050007F0100514D-->  <HELP><![CDATA[Indicates the unique line for a document.  It will also control the display order of the lines within a document.]]></HELP>
+<!--0227A74434844625E050007F0100514D-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--0227A74434844625E050007F0100514D-->  <AD_TAB_ID><![CDATA[1C05058D61AC4B69A7E550F32F9F2873]]></AD_TAB_ID>
+<!--0227A74434844625E050007F0100514D-->  <AD_COLUMN_ID><![CDATA[0227873A968BE6FBE050007F01005124]]></AD_COLUMN_ID>
+<!--0227A74434844625E050007F0100514D-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--0227A74434844625E050007F0100514D-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--0227A74434844625E050007F0100514D-->  <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
+<!--0227A74434844625E050007F0100514D-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--0227A74434844625E050007F0100514D-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--0227A74434844625E050007F0100514D-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--0227A74434844625E050007F0100514D-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--0227A74434844625E050007F0100514D-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--0227A74434844625E050007F0100514D-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--0227A74434844625E050007F0100514D-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--0227A74434844625E050007F0100514D-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--0227A74434844625E050007F0100514D-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--0227A74434844625E050007F0100514D-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--0227A74434844625E050007F0100514D-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--0227A74434844625E050007F0100514D-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--0227A74434844625E050007F0100514D--></AD_FIELD>
+
+<!--0227C68D22616610E050007F010062E7--><AD_FIELD>
+<!--0227C68D22616610E050007F010062E7-->  <AD_FIELD_ID><![CDATA[0227C68D22616610E050007F010062E7]]></AD_FIELD_ID>
+<!--0227C68D22616610E050007F010062E7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0227C68D22616610E050007F010062E7-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0227C68D22616610E050007F010062E7-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0227C68D22616610E050007F010062E7-->  <NAME><![CDATA[Line No.]]></NAME>
+<!--0227C68D22616610E050007F010062E7-->  <DESCRIPTION><![CDATA[A line stating the position of this request in the document.]]></DESCRIPTION>
+<!--0227C68D22616610E050007F010062E7-->  <HELP><![CDATA[Indicates the unique line for a document.  It will also control the display order of the lines within a document.]]></HELP>
+<!--0227C68D22616610E050007F010062E7-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--0227C68D22616610E050007F010062E7-->  <AD_TAB_ID><![CDATA[217EB72E1AA44DD5955AF03386A48660]]></AD_TAB_ID>
+<!--0227C68D22616610E050007F010062E7-->  <AD_COLUMN_ID><![CDATA[93AEBCB99493427F8011F63ED6BF0693]]></AD_COLUMN_ID>
+<!--0227C68D22616610E050007F010062E7-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--0227C68D22616610E050007F010062E7-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--0227C68D22616610E050007F010062E7-->  <DISPLAYLENGTH><![CDATA[10]]></DISPLAYLENGTH>
+<!--0227C68D22616610E050007F010062E7-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
+<!--0227C68D22616610E050007F010062E7-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--0227C68D22616610E050007F010062E7-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--0227C68D22616610E050007F010062E7-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--0227C68D22616610E050007F010062E7-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--0227C68D22616610E050007F010062E7-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--0227C68D22616610E050007F010062E7-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--0227C68D22616610E050007F010062E7-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--0227C68D22616610E050007F010062E7-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--0227C68D22616610E050007F010062E7-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--0227C68D22616610E050007F010062E7-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--0227C68D22616610E050007F010062E7-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--0227C68D22616610E050007F010062E7--></AD_FIELD>
+
+<!--0228A56E2ED0993CE050007F01001FB5--><AD_FIELD>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <AD_FIELD_ID><![CDATA[0228A56E2ED0993CE050007F01001FB5]]></AD_FIELD_ID>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <NAME><![CDATA[Line No.]]></NAME>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <DESCRIPTION><![CDATA[A line stating the position of this request in the document.]]></DESCRIPTION>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <HELP><![CDATA[Indicates the unique line for a document.  It will also control the display order of the lines within a document.]]></HELP>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <AD_TAB_ID><![CDATA[0F76B56EB2874C729ABE1665D5853E9D]]></AD_TAB_ID>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <AD_COLUMN_ID><![CDATA[0227873A968BE6FBE050007F01005124]]></AD_COLUMN_ID>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <DISPLAYLENGTH><![CDATA[12]]></DISPLAYLENGTH>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--0228A56E2ED0993CE050007F01001FB5-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--0228A56E2ED0993CE050007F01001FB5--></AD_FIELD>
+
 <!--0267FE152A9843E3B65B9F07F434ACA6--><AD_FIELD>
 <!--0267FE152A9843E3B65B9F07F434ACA6-->  <AD_FIELD_ID><![CDATA[0267FE152A9843E3B65B9F07F434ACA6]]></AD_FIELD_ID>
 <!--0267FE152A9843E3B65B9F07F434ACA6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_TABLE.xml	Wed Sep 03 12:56:16 2014 +0200
+++ b/src-db/database/sourcedata/AD_TABLE.xml	Wed Sep 03 13:46:43 2014 +0200
@@ -11293,7 +11293,8 @@
   lcc.isMatchingAdjusted as isMatchingAdjusted,
   lcm.id as m_lc_matched_id,
   lcc.id as m_lc_cost_id,
-  lc.documentNo as documentNo
+  lc.documentNo as documentNo,
+  lcc.lineNo as line
 from LandedCostCost as lcc
   join lcc.landedCost as lc
   join lcc.landedCostType as lct
@@ -11302,7 +11303,7 @@
 where (lcc.isMatchingAdjusted = false or lcm is not null)
   and @additional_filters@
   and @insertion_point_0@
-group by  coalesce(lcm.id, lcc.id), lcc, lct.name, lcc.amount, lcm.amount, case when lcm is not null then true else false end, lc.referenceDate, lcc.matched, lcc.isMatchingAdjusted, lcm.id, lcc.id, il, lc.documentNo]]></HQLQUERY>
+group by  coalesce(lcm.id, lcc.id), lcc, lct.name, lcc.amount, lcm.amount, case when lcm is not null then true else false end, lc.referenceDate, lcc.matched, lcc.isMatchingAdjusted, lcm.id, lcc.id, il, lc.documentNo, lcc.lineNo]]></HQLQUERY>
 <!--B2960E2BDCCD4F7599A2433F2681847F-->  <ENTITY_ALIAS><![CDATA[lcc]]></ENTITY_ALIAS>
 <!--B2960E2BDCCD4F7599A2433F2681847F--></AD_TABLE>