[Production-Development] Implement Sepecial Attributes on Copy From Attribute
authorrafaeldemiguel <rdm@openbravo.com>
Fri, 02 Sep 2011 11:12:55 +0200
changeset 14974 0fe2752f062e
parent 14973 8241f96bdfad
child 14975 96edbba179a8
[Production-Development] Implement Sepecial Attributes on Copy From Attribute
src-db/database/model/tables/MA_SEQUENCEPRODUCTATT.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_FIELD.xml
src-db/database/sourcedata/AD_PROCESS_PARA.xml
src-db/database/sourcedata/AD_REFERENCE.xml
src-db/database/sourcedata/AD_REF_LIST.xml
src/org/openbravo/erpCommon/ad_callouts/SL_SequenceProduct_Product_Attribute.java
--- a/src-db/database/model/tables/MA_SEQUENCEPRODUCTATT.xml	Thu Sep 01 12:44:07 2011 +0200
+++ b/src-db/database/model/tables/MA_SEQUENCEPRODUCTATT.xml	Fri Sep 02 11:12:55 2011 +0200
@@ -49,6 +49,14 @@
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="ISSPECIALATT" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA[N]]></default>
+        <onCreateDefault/>
+      </column>
+      <column name="SPECIALATT" primaryKey="false" required="false" type="VARCHAR" size="60" autoIncrement="false">
+        <default/>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_ORG" name="AD_ORG_MASEQUENCEATTPRODUCT">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Thu Sep 01 12:44:07 2011 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Fri Sep 02 11:12:55 2011 +0200
@@ -232585,6 +232585,40 @@
 <!--70181D3207204C5981E08CDABFF14FE3-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--70181D3207204C5981E08CDABFF14FE3--></AD_COLUMN>
 
+<!--707904071AC942C290006915BAE7EEE2--><AD_COLUMN>
+<!--707904071AC942C290006915BAE7EEE2-->  <AD_COLUMN_ID><![CDATA[707904071AC942C290006915BAE7EEE2]]></AD_COLUMN_ID>
+<!--707904071AC942C290006915BAE7EEE2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--707904071AC942C290006915BAE7EEE2-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--707904071AC942C290006915BAE7EEE2-->  <NAME><![CDATA[Isspecialatt]]></NAME>
+<!--707904071AC942C290006915BAE7EEE2-->  <DESCRIPTION><![CDATA[Is special attribute]]></DESCRIPTION>
+<!--707904071AC942C290006915BAE7EEE2-->  <HELP><![CDATA[Is special attribute]]></HELP>
+<!--707904071AC942C290006915BAE7EEE2-->  <COLUMNNAME><![CDATA[Isspecialatt]]></COLUMNNAME>
+<!--707904071AC942C290006915BAE7EEE2-->  <AD_TABLE_ID><![CDATA[FF80818132144FDB01321456E8AC000E]]></AD_TABLE_ID>
+<!--707904071AC942C290006915BAE7EEE2-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--707904071AC942C290006915BAE7EEE2-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--707904071AC942C290006915BAE7EEE2-->  <DEFAULTVALUE><![CDATA[N]]></DEFAULTVALUE>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--707904071AC942C290006915BAE7EEE2-->  <SEQNO><![CDATA[140]]></SEQNO>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--707904071AC942C290006915BAE7EEE2-->  <AD_ELEMENT_ID><![CDATA[D3E4B412F90E4D13A290F5EAA0278261]]></AD_ELEMENT_ID>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--707904071AC942C290006915BAE7EEE2-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--707904071AC942C290006915BAE7EEE2-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--707904071AC942C290006915BAE7EEE2-->  <POSITION><![CDATA[15]]></POSITION>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--707904071AC942C290006915BAE7EEE2-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--707904071AC942C290006915BAE7EEE2-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--707904071AC942C290006915BAE7EEE2--></AD_COLUMN>
+
 <!--7079E2FD4AA7799EE040007F010104AD--><AD_COLUMN>
 <!--7079E2FD4AA7799EE040007F010104AD-->  <AD_COLUMN_ID><![CDATA[7079E2FD4AA7799EE040007F010104AD]]></AD_COLUMN_ID>
 <!--7079E2FD4AA7799EE040007F010104AD-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -248233,6 +248267,40 @@
 <!--84BE5A55A365CEFEE040007F01000402-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--84BE5A55A365CEFEE040007F01000402--></AD_COLUMN>
 
+<!--84C7E863AB434889869F33EE966008E0--><AD_COLUMN>
+<!--84C7E863AB434889869F33EE966008E0-->  <AD_COLUMN_ID><![CDATA[84C7E863AB434889869F33EE966008E0]]></AD_COLUMN_ID>
+<!--84C7E863AB434889869F33EE966008E0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--84C7E863AB434889869F33EE966008E0-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--84C7E863AB434889869F33EE966008E0-->  <NAME><![CDATA[Specialatt]]></NAME>
+<!--84C7E863AB434889869F33EE966008E0-->  <DESCRIPTION><![CDATA[Special Attribute]]></DESCRIPTION>
+<!--84C7E863AB434889869F33EE966008E0-->  <HELP><![CDATA[Special Attribute]]></HELP>
+<!--84C7E863AB434889869F33EE966008E0-->  <COLUMNNAME><![CDATA[Specialatt]]></COLUMNNAME>
+<!--84C7E863AB434889869F33EE966008E0-->  <AD_TABLE_ID><![CDATA[FF80818132144FDB01321456E8AC000E]]></AD_TABLE_ID>
+<!--84C7E863AB434889869F33EE966008E0-->  <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID>
+<!--84C7E863AB434889869F33EE966008E0-->  <AD_REFERENCE_VALUE_ID><![CDATA[FF808181322476640132249E3417002F]]></AD_REFERENCE_VALUE_ID>
+<!--84C7E863AB434889869F33EE966008E0-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--84C7E863AB434889869F33EE966008E0-->  <SEQNO><![CDATA[150]]></SEQNO>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--84C7E863AB434889869F33EE966008E0-->  <AD_ELEMENT_ID><![CDATA[EFEA4EEE05CD434DB4B4363C8B498DF6]]></AD_ELEMENT_ID>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--84C7E863AB434889869F33EE966008E0-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--84C7E863AB434889869F33EE966008E0-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--84C7E863AB434889869F33EE966008E0-->  <POSITION><![CDATA[16]]></POSITION>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--84C7E863AB434889869F33EE966008E0-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--84C7E863AB434889869F33EE966008E0-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--84C7E863AB434889869F33EE966008E0--></AD_COLUMN>
+
 <!--85072D35A21C4487A9B16A210878D3C8--><AD_COLUMN>
 <!--85072D35A21C4487A9B16A210878D3C8-->  <AD_COLUMN_ID><![CDATA[85072D35A21C4487A9B16A210878D3C8]]></AD_COLUMN_ID>
 <!--85072D35A21C4487A9B16A210878D3C8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -254462,7 +254530,7 @@
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <ISKEY><![CDATA[N]]></ISKEY>
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <ISPARENT><![CDATA[Y]]></ISPARENT>
-<!--91C0717136BB400AAA09F8ECE76409BF-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--91C0717136BB400AAA09F8ECE76409BF-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <SEQNO><![CDATA[90]]></SEQNO>
@@ -254470,7 +254538,7 @@
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <AD_ELEMENT_ID><![CDATA[800344]]></AD_ELEMENT_ID>
-<!--91C0717136BB400AAA09F8ECE76409BF-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--91C0717136BB400AAA09F8ECE76409BF-->  <ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
@@ -259740,8 +259808,8 @@
 <!--BBF2C9B6AA3B4989980411CAFB374A69-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--BBF2C9B6AA3B4989980411CAFB374A69-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--BBF2C9B6AA3B4989980411CAFB374A69-->  <NAME><![CDATA[Copyproduct]]></NAME>
-<!--BBF2C9B6AA3B4989980411CAFB374A69-->  <DESCRIPTION><![CDATA[Create a product copied from the line product and insert a new line in the sequence using this new product created]]></DESCRIPTION>
-<!--BBF2C9B6AA3B4989980411CAFB374A69-->  <HELP><![CDATA[Create a product copied from the line product and insert a new line in the sequence using this new product created]]></HELP>
+<!--BBF2C9B6AA3B4989980411CAFB374A69-->  <DESCRIPTION><![CDATA[Create a product copied from the P - and insert a new line in the sequence using this new product created]]></DESCRIPTION>
+<!--BBF2C9B6AA3B4989980411CAFB374A69-->  <HELP><![CDATA[Create a product copied from the P - and insert a new line in the sequence using this new product created]]></HELP>
 <!--BBF2C9B6AA3B4989980411CAFB374A69-->  <COLUMNNAME><![CDATA[Copyproduct]]></COLUMNNAME>
 <!--BBF2C9B6AA3B4989980411CAFB374A69-->  <AD_TABLE_ID><![CDATA[800097]]></AD_TABLE_ID>
 <!--BBF2C9B6AA3B4989980411CAFB374A69-->  <AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Thu Sep 01 12:44:07 2011 +0200
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Fri Sep 02 11:12:55 2011 +0200
@@ -25278,6 +25278,19 @@
 <!--D190BE6617E04A41BF66468665BA145E-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--D190BE6617E04A41BF66468665BA145E--></AD_ELEMENT>
 
+<!--D3E4B412F90E4D13A290F5EAA0278261--><AD_ELEMENT>
+<!--D3E4B412F90E4D13A290F5EAA0278261-->  <AD_ELEMENT_ID><![CDATA[D3E4B412F90E4D13A290F5EAA0278261]]></AD_ELEMENT_ID>
+<!--D3E4B412F90E4D13A290F5EAA0278261-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D3E4B412F90E4D13A290F5EAA0278261-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D3E4B412F90E4D13A290F5EAA0278261-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D3E4B412F90E4D13A290F5EAA0278261-->  <COLUMNNAME><![CDATA[Isspecialatt]]></COLUMNNAME>
+<!--D3E4B412F90E4D13A290F5EAA0278261-->  <NAME><![CDATA[Is special attribute]]></NAME>
+<!--D3E4B412F90E4D13A290F5EAA0278261-->  <PRINTNAME><![CDATA[Is special attribute]]></PRINTNAME>
+<!--D3E4B412F90E4D13A290F5EAA0278261-->  <DESCRIPTION><![CDATA[Is special attribute]]></DESCRIPTION>
+<!--D3E4B412F90E4D13A290F5EAA0278261-->  <HELP><![CDATA[Is special attribute]]></HELP>
+<!--D3E4B412F90E4D13A290F5EAA0278261-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D3E4B412F90E4D13A290F5EAA0278261--></AD_ELEMENT>
+
 <!--D498E8A6CB6711DDBAC06BA41F5FDE11--><AD_ELEMENT>
 <!--D498E8A6CB6711DDBAC06BA41F5FDE11-->  <AD_ELEMENT_ID><![CDATA[D498E8A6CB6711DDBAC06BA41F5FDE11]]></AD_ELEMENT_ID>
 <!--D498E8A6CB6711DDBAC06BA41F5FDE11-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -25521,6 +25534,19 @@
 <!--EFCDB5D6E2BD4E5C906C43D2839B1573-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--EFCDB5D6E2BD4E5C906C43D2839B1573--></AD_ELEMENT>
 
+<!--EFEA4EEE05CD434DB4B4363C8B498DF6--><AD_ELEMENT>
+<!--EFEA4EEE05CD434DB4B4363C8B498DF6-->  <AD_ELEMENT_ID><![CDATA[EFEA4EEE05CD434DB4B4363C8B498DF6]]></AD_ELEMENT_ID>
+<!--EFEA4EEE05CD434DB4B4363C8B498DF6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--EFEA4EEE05CD434DB4B4363C8B498DF6-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--EFEA4EEE05CD434DB4B4363C8B498DF6-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--EFEA4EEE05CD434DB4B4363C8B498DF6-->  <COLUMNNAME><![CDATA[Specialatt]]></COLUMNNAME>
+<!--EFEA4EEE05CD434DB4B4363C8B498DF6-->  <NAME><![CDATA[Special Attribute]]></NAME>
+<!--EFEA4EEE05CD434DB4B4363C8B498DF6-->  <PRINTNAME><![CDATA[Special Attribute]]></PRINTNAME>
+<!--EFEA4EEE05CD434DB4B4363C8B498DF6-->  <DESCRIPTION><![CDATA[Special Attribute]]></DESCRIPTION>
+<!--EFEA4EEE05CD434DB4B4363C8B498DF6-->  <HELP><![CDATA[Special Attribute]]></HELP>
+<!--EFEA4EEE05CD434DB4B4363C8B498DF6-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--EFEA4EEE05CD434DB4B4363C8B498DF6--></AD_ELEMENT>
+
 <!--F197B6D6CCCE4C2F8EB42C34B560428E--><AD_ELEMENT>
 <!--F197B6D6CCCE4C2F8EB42C34B560428E-->  <AD_ELEMENT_ID><![CDATA[F197B6D6CCCE4C2F8EB42C34B560428E]]></AD_ELEMENT_ID>
 <!--F197B6D6CCCE4C2F8EB42C34B560428E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Thu Sep 01 12:44:07 2011 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Fri Sep 02 11:12:55 2011 +0200
@@ -162487,15 +162487,17 @@
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <AD_TAB_ID><![CDATA[FF80818132144FDB0132146AAFCA0042]]></AD_TAB_ID>
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <AD_COLUMN_ID><![CDATA[AD58859226F648569B51EA63B05DE83D]]></AD_COLUMN_ID>
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--06119ABE11644B2B8CD67F7DC4C96891-->  <DISPLAYLOGIC><![CDATA[@Isspecialatt@='N']]></DISPLAYLOGIC>
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--06119ABE11644B2B8CD67F7DC4C96891-->  <SEQNO><![CDATA[70]]></SEQNO>
+<!--06119ABE11644B2B8CD67F7DC4C96891-->  <SEQNO><![CDATA[90]]></SEQNO>
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--06119ABE11644B2B8CD67F7DC4C96891-->  <GRID_SEQNO><![CDATA[90]]></GRID_SEQNO>
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
 <!--06119ABE11644B2B8CD67F7DC4C96891-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
@@ -162834,6 +162836,34 @@
 <!--0E991F98D0FC41CD85ACA88C9C787D91-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--0E991F98D0FC41CD85ACA88C9C787D91--></AD_FIELD>
 
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4--><AD_FIELD>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <AD_FIELD_ID><![CDATA[0E9BF5ED8C1C42ABB4E239B3950CB8E4]]></AD_FIELD_ID>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <NAME><![CDATA[Special Attribute]]></NAME>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <DESCRIPTION><![CDATA[Special Attribute]]></DESCRIPTION>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <HELP><![CDATA[Special Attribute]]></HELP>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <AD_TAB_ID><![CDATA[FF80818132144FDB0132146AAFCA0042]]></AD_TAB_ID>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <AD_COLUMN_ID><![CDATA[84C7E863AB434889869F33EE966008E0]]></AD_COLUMN_ID>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <DISPLAYLOGIC><![CDATA[@Isspecialatt@='Y']]></DISPLAYLOGIC>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <SEQNO><![CDATA[70]]></SEQNO>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <GRID_SEQNO><![CDATA[70]]></GRID_SEQNO>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--0E9BF5ED8C1C42ABB4E239B3950CB8E4--></AD_FIELD>
+
 <!--0F0091F0389846EE963C718466A81230--><AD_FIELD>
 <!--0F0091F0389846EE963C718466A81230-->  <AD_FIELD_ID><![CDATA[0F0091F0389846EE963C718466A81230]]></AD_FIELD_ID>
 <!--0F0091F0389846EE963C718466A81230-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -176535,7 +176565,7 @@
 <!--639A3B8F69E644DAB62B6D07ACE77DDB-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--639A3B8F69E644DAB62B6D07ACE77DDB-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--639A3B8F69E644DAB62B6D07ACE77DDB-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--639A3B8F69E644DAB62B6D07ACE77DDB-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--639A3B8F69E644DAB62B6D07ACE77DDB-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
 <!--639A3B8F69E644DAB62B6D07ACE77DDB-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
 <!--639A3B8F69E644DAB62B6D07ACE77DDB-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--639A3B8F69E644DAB62B6D07ACE77DDB-->  <GRID_SEQNO><![CDATA[0]]></GRID_SEQNO>
@@ -184531,6 +184561,7 @@
 <!--857AA18B73D64E4C861BC00A0D1FFC08-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
 <!--857AA18B73D64E4C861BC00A0D1FFC08-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
 <!--857AA18B73D64E4C861BC00A0D1FFC08-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--857AA18B73D64E4C861BC00A0D1FFC08-->  <GRID_SEQNO><![CDATA[40]]></GRID_SEQNO>
 <!--857AA18B73D64E4C861BC00A0D1FFC08-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
 <!--857AA18B73D64E4C861BC00A0D1FFC08-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
 <!--857AA18B73D64E4C861BC00A0D1FFC08-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
@@ -190833,6 +190864,33 @@
 <!--BE6F3373766744648039EAE64DBFCABA-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--BE6F3373766744648039EAE64DBFCABA--></AD_FIELD>
 
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24--><AD_FIELD>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <AD_FIELD_ID><![CDATA[BF5BFA09FD5B4433BBD8629BDE7D1E24]]></AD_FIELD_ID>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <NAME><![CDATA[Is special attribute]]></NAME>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <DESCRIPTION><![CDATA[Is special attribute]]></DESCRIPTION>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <HELP><![CDATA[Is special attribute]]></HELP>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <AD_TAB_ID><![CDATA[FF80818132144FDB0132146AAFCA0042]]></AD_TAB_ID>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <AD_COLUMN_ID><![CDATA[707904071AC942C290006915BAE7EEE2]]></AD_COLUMN_ID>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <GRID_SEQNO><![CDATA[60]]></GRID_SEQNO>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--BF5BFA09FD5B4433BBD8629BDE7D1E24--></AD_FIELD>
+
 <!--C1C3F60280D611DDA899AF0F4F5119E1--><AD_FIELD>
 <!--C1C3F60280D611DDA899AF0F4F5119E1-->  <AD_FIELD_ID><![CDATA[C1C3F60280D611DDA899AF0F4F5119E1]]></AD_FIELD_ID>
 <!--C1C3F60280D611DDA899AF0F4F5119E1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -191553,6 +191611,7 @@
 <!--CE9FB50EFF9847FDB68243EADFE01453-->  <AD_TAB_ID><![CDATA[FF80818132144FDB0132146AAFCA0042]]></AD_TAB_ID>
 <!--CE9FB50EFF9847FDB68243EADFE01453-->  <AD_COLUMN_ID><![CDATA[F5EFB4DD7D7F455AB88D41F78FB1C5D0]]></AD_COLUMN_ID>
 <!--CE9FB50EFF9847FDB68243EADFE01453-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--CE9FB50EFF9847FDB68243EADFE01453-->  <DISPLAYLOGIC><![CDATA[@Isspecialatt@='N']]></DISPLAYLOGIC>
 <!--CE9FB50EFF9847FDB68243EADFE01453-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
 <!--CE9FB50EFF9847FDB68243EADFE01453-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--CE9FB50EFF9847FDB68243EADFE01453-->  <SEQNO><![CDATA[50]]></SEQNO>
@@ -191562,8 +191621,9 @@
 <!--CE9FB50EFF9847FDB68243EADFE01453-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
 <!--CE9FB50EFF9847FDB68243EADFE01453-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
 <!--CE9FB50EFF9847FDB68243EADFE01453-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--CE9FB50EFF9847FDB68243EADFE01453-->  <GRID_SEQNO><![CDATA[50]]></GRID_SEQNO>
 <!--CE9FB50EFF9847FDB68243EADFE01453-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
-<!--CE9FB50EFF9847FDB68243EADFE01453-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--CE9FB50EFF9847FDB68243EADFE01453-->  <STARTNEWLINE><![CDATA[Y]]></STARTNEWLINE>
 <!--CE9FB50EFF9847FDB68243EADFE01453-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--CE9FB50EFF9847FDB68243EADFE01453--></AD_FIELD>
 
@@ -192072,24 +192132,25 @@
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--DB94175C6E6E4408BC29758B1F578A83-->  <NAME><![CDATA[Product]]></NAME>
+<!--DB94175C6E6E4408BC29758B1F578A83-->  <NAME><![CDATA[Product From]]></NAME>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <DESCRIPTION><![CDATA[An item produced by a process.]]></DESCRIPTION>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <HELP><![CDATA[Identifies an item which is either purchased or sold in this organization.]]></HELP>
-<!--DB94175C6E6E4408BC29758B1F578A83-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--DB94175C6E6E4408BC29758B1F578A83-->  <ISCENTRALLYMAINTAINED><![CDATA[N]]></ISCENTRALLYMAINTAINED>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <AD_TAB_ID><![CDATA[FF80818132144FDB0132146AAFCA0042]]></AD_TAB_ID>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <AD_COLUMN_ID><![CDATA[1395BD95B14149C29B10B1B455A154DC]]></AD_COLUMN_ID>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--DB94175C6E6E4408BC29758B1F578A83-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--DB94175C6E6E4408BC29758B1F578A83-->  <SEQNO><![CDATA[80]]></SEQNO>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--DB94175C6E6E4408BC29758B1F578A83-->  <GRID_SEQNO><![CDATA[80]]></GRID_SEQNO>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
-<!--DB94175C6E6E4408BC29758B1F578A83-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--DB94175C6E6E4408BC29758B1F578A83-->  <STARTNEWLINE><![CDATA[Y]]></STARTNEWLINE>
 <!--DB94175C6E6E4408BC29758B1F578A83-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
 <!--DB94175C6E6E4408BC29758B1F578A83--></AD_FIELD>
 
--- a/src-db/database/sourcedata/AD_PROCESS_PARA.xml	Thu Sep 01 12:44:07 2011 +0200
+++ b/src-db/database/sourcedata/AD_PROCESS_PARA.xml	Fri Sep 02 11:12:55 2011 +0200
@@ -4395,7 +4395,11 @@
 <!--FF80818132200CAA0132200F00B80007-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
 <!--FF80818132200CAA0132200F00B80007-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--FF80818132200CAA0132200F00B80007-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--FF80818132200CAA0132200F00B80007-->  <NAME><![CDATA[SearchKey]]></NAME>
+<!--FF80818132200CAA0132200F00B80007-->  <NAME><![CDATA[Search Key]]></NAME>
+<!--FF80818132200CAA0132200F00B80007-->  <DESCRIPTION><![CDATA[A fast method for finding a particular record.]]></DESCRIPTION>
+<!--FF80818132200CAA0132200F00B80007-->  <HELP><![CDATA[A search key allows for a fast method of finding a particular record. If you leave the search key empty, the system automatically creates a numeric number originating from a document sequence defined in the  "Document Sequence" window. The sequence naming convention follows a rule "DocumentNo_TableName", where TableName is the actual name of the database table (e.g. C_Order).
+
+Usually, company's internal identifiers for various records (products, customers, etc) are stored here.]]></HELP>
 <!--FF80818132200CAA0132200F00B80007-->  <AD_PROCESS_ID><![CDATA[FF8081813219E68E013219ECFE930004]]></AD_PROCESS_ID>
 <!--FF80818132200CAA0132200F00B80007-->  <SEQNO><![CDATA[10]]></SEQNO>
 <!--FF80818132200CAA0132200F00B80007-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
@@ -4405,6 +4409,7 @@
 <!--FF80818132200CAA0132200F00B80007-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--FF80818132200CAA0132200F00B80007-->  <ISRANGE><![CDATA[N]]></ISRANGE>
 <!--FF80818132200CAA0132200F00B80007-->  <DEFAULTVALUE><![CDATA[Value]]></DEFAULTVALUE>
+<!--FF80818132200CAA0132200F00B80007-->  <AD_ELEMENT_ID><![CDATA[620]]></AD_ELEMENT_ID>
 <!--FF80818132200CAA0132200F00B80007--></AD_PROCESS_PARA>
 
 <!--FF80818132202C17013223D76B72002C--><AD_PROCESS_PARA>
@@ -4413,6 +4418,8 @@
 <!--FF80818132202C17013223D76B72002C-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--FF80818132202C17013223D76B72002C-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--FF80818132202C17013223D76B72002C-->  <NAME><![CDATA[Name]]></NAME>
+<!--FF80818132202C17013223D76B72002C-->  <DESCRIPTION><![CDATA[A non-unique identifier for a record/document often used as a search tool.]]></DESCRIPTION>
+<!--FF80818132202C17013223D76B72002C-->  <HELP><![CDATA[A more descriptive identifier (that does need to be unique) of a record/document that is used as a default search option along with the search key (that is unique and mostly shorter). It is up to 60 characters in length.]]></HELP>
 <!--FF80818132202C17013223D76B72002C-->  <AD_PROCESS_ID><![CDATA[FF8081813219E68E013219ECFE930004]]></AD_PROCESS_ID>
 <!--FF80818132202C17013223D76B72002C-->  <SEQNO><![CDATA[20]]></SEQNO>
 <!--FF80818132202C17013223D76B72002C-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
@@ -4422,6 +4429,7 @@
 <!--FF80818132202C17013223D76B72002C-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--FF80818132202C17013223D76B72002C-->  <ISRANGE><![CDATA[N]]></ISRANGE>
 <!--FF80818132202C17013223D76B72002C-->  <DEFAULTVALUE><![CDATA[Name]]></DEFAULTVALUE>
+<!--FF80818132202C17013223D76B72002C-->  <AD_ELEMENT_ID><![CDATA[469]]></AD_ELEMENT_ID>
 <!--FF80818132202C17013223D76B72002C--></AD_PROCESS_PARA>
 
 <!--FF80818132202C17013223D8B5BE0030--><AD_PROCESS_PARA>
@@ -4430,6 +4438,8 @@
 <!--FF80818132202C17013223D8B5BE0030-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--FF80818132202C17013223D8B5BE0030-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--FF80818132202C17013223D8B5BE0030-->  <NAME><![CDATA[Production Type]]></NAME>
+<!--FF80818132202C17013223D8B5BE0030-->  <DESCRIPTION><![CDATA[A classification stating whether something has been created or used in the sequence.]]></DESCRIPTION>
+<!--FF80818132202C17013223D8B5BE0030-->  <HELP><![CDATA[Indicates if the product is used in the sequence or is generated. A positive production means that is an output product. So&nbsp;a negative productions refers to an input product.]]></HELP>
 <!--FF80818132202C17013223D8B5BE0030-->  <AD_PROCESS_ID><![CDATA[FF8081813219E68E013219ECFE930004]]></AD_PROCESS_ID>
 <!--FF80818132202C17013223D8B5BE0030-->  <SEQNO><![CDATA[30]]></SEQNO>
 <!--FF80818132202C17013223D8B5BE0030-->  <AD_REFERENCE_ID><![CDATA[17]]></AD_REFERENCE_ID>
@@ -4440,6 +4450,7 @@
 <!--FF80818132202C17013223D8B5BE0030-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--FF80818132202C17013223D8B5BE0030-->  <ISRANGE><![CDATA[N]]></ISRANGE>
 <!--FF80818132202C17013223D8B5BE0030-->  <DEFAULTVALUE><![CDATA[+]]></DEFAULTVALUE>
+<!--FF80818132202C17013223D8B5BE0030-->  <AD_ELEMENT_ID><![CDATA[800345]]></AD_ELEMENT_ID>
 <!--FF80818132202C17013223D8B5BE0030--></AD_PROCESS_PARA>
 
 <!--FF8081813224247D0132246112F90130--><AD_PROCESS_PARA>
@@ -4448,6 +4459,8 @@
 <!--FF8081813224247D0132246112F90130-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
 <!--FF8081813224247D0132246112F90130-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
 <!--FF8081813224247D0132246112F90130-->  <NAME><![CDATA[Quantity]]></NAME>
+<!--FF8081813224247D0132246112F90130-->  <DESCRIPTION><![CDATA[The number of a certain item.]]></DESCRIPTION>
+<!--FF8081813224247D0132246112F90130-->  <HELP><![CDATA[The Quantity indicates the number of a specific product or item for this document.]]></HELP>
 <!--FF8081813224247D0132246112F90130-->  <AD_PROCESS_ID><![CDATA[FF8081813219E68E013219ECFE930004]]></AD_PROCESS_ID>
 <!--FF8081813224247D0132246112F90130-->  <SEQNO><![CDATA[40]]></SEQNO>
 <!--FF8081813224247D0132246112F90130-->  <AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID>
@@ -4457,6 +4470,7 @@
 <!--FF8081813224247D0132246112F90130-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
 <!--FF8081813224247D0132246112F90130-->  <ISRANGE><![CDATA[N]]></ISRANGE>
 <!--FF8081813224247D0132246112F90130-->  <DEFAULTVALUE><![CDATA[0]]></DEFAULTVALUE>
+<!--FF8081813224247D0132246112F90130-->  <AD_ELEMENT_ID><![CDATA[526]]></AD_ELEMENT_ID>
 <!--FF8081813224247D0132246112F90130--></AD_PROCESS_PARA>
 
 </data>
--- a/src-db/database/sourcedata/AD_REFERENCE.xml	Thu Sep 01 12:44:07 2011 +0200
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml	Fri Sep 02 11:12:55 2011 +0200
@@ -5133,4 +5133,18 @@
 <!--FF808181321576F301321587CBB4004A-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--FF808181321576F301321587CBB4004A--></AD_REFERENCE>
 
+<!--FF808181322476640132249E3417002F--><AD_REFERENCE>
+<!--FF808181322476640132249E3417002F-->  <AD_REFERENCE_ID><![CDATA[FF808181322476640132249E3417002F]]></AD_REFERENCE_ID>
+<!--FF808181322476640132249E3417002F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808181322476640132249E3417002F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808181322476640132249E3417002F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808181322476640132249E3417002F-->  <NAME><![CDATA[Special Product Attributes]]></NAME>
+<!--FF808181322476640132249E3417002F-->  <DESCRIPTION><![CDATA[List of special product attributes (Lot, Serial Number and Expiration Date)]]></DESCRIPTION>
+<!--FF808181322476640132249E3417002F-->  <HELP><![CDATA[List of special product attributes (Lot, Serial Number and Expiration Date)]]></HELP>
+<!--FF808181322476640132249E3417002F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF808181322476640132249E3417002F-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--FF808181322476640132249E3417002F-->  <PARENTREFERENCE_ID><![CDATA[17]]></PARENTREFERENCE_ID>
+<!--FF808181322476640132249E3417002F-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--FF808181322476640132249E3417002F--></AD_REFERENCE>
+
 </data>
--- a/src-db/database/sourcedata/AD_REF_LIST.xml	Thu Sep 01 12:44:07 2011 +0200
+++ b/src-db/database/sourcedata/AD_REF_LIST.xml	Fri Sep 02 11:12:55 2011 +0200
@@ -10852,4 +10852,40 @@
 <!--FF8081813205318F01320555E4FD005F-->  <SEQNO><![CDATA[3]]></SEQNO>
 <!--FF8081813205318F01320555E4FD005F--></AD_REF_LIST>
 
+<!--FF808181322476640132249F0AD90033--><AD_REF_LIST>
+<!--FF808181322476640132249F0AD90033-->  <AD_REF_LIST_ID><![CDATA[FF808181322476640132249F0AD90033]]></AD_REF_LIST_ID>
+<!--FF808181322476640132249F0AD90033-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808181322476640132249F0AD90033-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808181322476640132249F0AD90033-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808181322476640132249F0AD90033-->  <VALUE><![CDATA[LOT]]></VALUE>
+<!--FF808181322476640132249F0AD90033-->  <NAME><![CDATA[Lot]]></NAME>
+<!--FF808181322476640132249F0AD90033-->  <AD_REFERENCE_ID><![CDATA[FF808181322476640132249E3417002F]]></AD_REFERENCE_ID>
+<!--FF808181322476640132249F0AD90033-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF808181322476640132249F0AD90033-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--FF808181322476640132249F0AD90033--></AD_REF_LIST>
+
+<!--FF808181322476640132249F344E0037--><AD_REF_LIST>
+<!--FF808181322476640132249F344E0037-->  <AD_REF_LIST_ID><![CDATA[FF808181322476640132249F344E0037]]></AD_REF_LIST_ID>
+<!--FF808181322476640132249F344E0037-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808181322476640132249F344E0037-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808181322476640132249F344E0037-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808181322476640132249F344E0037-->  <VALUE><![CDATA[SNO]]></VALUE>
+<!--FF808181322476640132249F344E0037-->  <NAME><![CDATA[Serial No.]]></NAME>
+<!--FF808181322476640132249F344E0037-->  <AD_REFERENCE_ID><![CDATA[FF808181322476640132249E3417002F]]></AD_REFERENCE_ID>
+<!--FF808181322476640132249F344E0037-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF808181322476640132249F344E0037-->  <SEQNO><![CDATA[20]]></SEQNO>
+<!--FF808181322476640132249F344E0037--></AD_REF_LIST>
+
+<!--FF808181322476640132249F5FB9003B--><AD_REF_LIST>
+<!--FF808181322476640132249F5FB9003B-->  <AD_REF_LIST_ID><![CDATA[FF808181322476640132249F5FB9003B]]></AD_REF_LIST_ID>
+<!--FF808181322476640132249F5FB9003B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FF808181322476640132249F5FB9003B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FF808181322476640132249F5FB9003B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FF808181322476640132249F5FB9003B-->  <VALUE><![CDATA[EXD]]></VALUE>
+<!--FF808181322476640132249F5FB9003B-->  <NAME><![CDATA[Expiration Date]]></NAME>
+<!--FF808181322476640132249F5FB9003B-->  <AD_REFERENCE_ID><![CDATA[FF808181322476640132249E3417002F]]></AD_REFERENCE_ID>
+<!--FF808181322476640132249F5FB9003B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FF808181322476640132249F5FB9003B-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--FF808181322476640132249F5FB9003B--></AD_REF_LIST>
+
 </data>
--- a/src/org/openbravo/erpCommon/ad_callouts/SL_SequenceProduct_Product_Attribute.java	Thu Sep 01 12:44:07 2011 +0200
+++ b/src/org/openbravo/erpCommon/ad_callouts/SL_SequenceProduct_Product_Attribute.java	Fri Sep 02 11:12:55 2011 +0200
@@ -18,39 +18,94 @@
  */
 package org.openbravo.erpCommon.ad_callouts;
 
-import java.util.List;
-
 import javax.servlet.ServletException;
 
 import org.hibernate.criterion.Expression;
 import org.openbravo.base.filter.IsIDFilter;
 import org.openbravo.dal.service.OBCriteria;
 import org.openbravo.dal.service.OBDal;
+import org.openbravo.model.ad.domain.Reference;
 import org.openbravo.model.common.plm.AttributeUse;
 import org.openbravo.model.common.plm.Product;
+import org.openbravo.model.manufacturing.processplan.OperationProduct;
 
 public class SL_SequenceProduct_Product_Attribute extends SimpleCallout {
 
   private static final long serialVersionUID = 1L;
   private static final IsIDFilter idFilter = new IsIDFilter();
+  private static final String specialAttListId = "FF808181322476640132249E3417002F";
+  private static final String LotSearchKey = "LOT";
+  private static final String SerialNoSearchKey = "SNO";
+  private static final String ExpirationDateearchKey = "EXD";
 
   @Override
   protected void execute(CalloutInfo info) throws ServletException {
 
+    // String strLastFieldChanged = info.getLastFieldChanged();
     String strmProductId = info.getStringParameter("inpmProductId", idFilter);
+    String strmProductSequenceId = info.getStringParameter("inpmaSequenceproductId", idFilter);
+
+    // Fill Normal Attributes
     Product product = OBDal.getInstance().get(Product.class, strmProductId);
+    OperationProduct opProduct = OBDal.getInstance().get(OperationProduct.class,
+        strmProductSequenceId);
+
     OBCriteria AttributeUseCriteria = OBDal.getInstance().createCriteria(AttributeUse.class);
     AttributeUseCriteria.add(Expression.eq(AttributeUse.PROPERTY_ATTRIBUTESET,
         product.getAttributeSet()));
     AttributeUseCriteria.addOrderBy(AttributeUse.PROPERTY_SEQUENCENUMBER, true);
-    List<AttributeUse> AttUseList = AttributeUseCriteria.list();
+    java.util.List<AttributeUse> AttUseList = AttributeUseCriteria.list();
 
     info.addSelect("inpmAttributeuseId");
-
     for (AttributeUse AttUse : AttUseList) {
       info.addSelectResult(AttUse.getId(), AttUse.getAttribute().getIdentifier());
     }
+    info.endSelect();
 
+    // Fill Special Attributes
+
+    info.addSelect("inpspecialatt");
+    // Lot
+    if (product.getAttributeSet().isLot() && opProduct.getProduct().getAttributeSet().isLot()) {
+      org.openbravo.model.ad.domain.List Lot = SpecialAttListValue(LotSearchKey);
+      if (Lot != null)
+        info.addSelectResult(Lot.getSearchKey(), Lot.getName());
+    }
+
+    // Serial No.
+    if (product.getAttributeSet().isSerialNo()
+        && opProduct.getProduct().getAttributeSet().isSerialNo()) {
+      org.openbravo.model.ad.domain.List Lot = SpecialAttListValue(SerialNoSearchKey);
+      if (Lot != null)
+        info.addSelectResult(Lot.getSearchKey(), Lot.getName());
+    }
+
+    // ExpirationDate
+    if (product.getAttributeSet().isExpirationDate()
+        && opProduct.getProduct().getAttributeSet().isExpirationDate()) {
+      org.openbravo.model.ad.domain.List Lot = SpecialAttListValue(ExpirationDateearchKey);
+      if (Lot != null)
+        info.addSelectResult(Lot.getSearchKey(), Lot.getName());
+    }
     info.endSelect();
+
+  }
+
+  private org.openbravo.model.ad.domain.List SpecialAttListValue(String Value)
+      throws ServletException {
+    Reference SpecialAttList = OBDal.getInstance().get(Reference.class, specialAttListId);
+    OBCriteria SpecialAttListValuesCriteria = OBDal.getInstance().createCriteria(
+        org.openbravo.model.ad.domain.List.class);
+    SpecialAttListValuesCriteria.add(Expression.eq(
+        org.openbravo.model.ad.domain.List.PROPERTY_REFERENCE, SpecialAttList));
+    SpecialAttListValuesCriteria.add(Expression.eq(
+        org.openbravo.model.ad.domain.List.PROPERTY_SEARCHKEY, Value));
+    java.util.List<org.openbravo.model.ad.domain.List> SpecialAttListValues = (java.util.List) SpecialAttListValuesCriteria
+        .list();
+    if (SpecialAttListValues.isEmpty()) {
+      return null;
+    } else {
+      return SpecialAttListValues.get(0);
+    }
   }
 }