[Characteristics]Add ManageVariants button.
authorGorka Ion Damián <gorkaion.damian@openbravo.com>
Fri, 28 Jun 2013 14:58:20 +0200
changeset 20953 39b2ccc4324f
parent 20952 4dae42f37291
child 20954 2ecd6d693565
[Characteristics]Add ManageVariants button.
src-db/database/model/tables/M_PRODUCT.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_REFERENCE.xml
src-db/database/sourcedata/AD_TAB.xml
src-db/database/sourcedata/AD_TABLE.xml
src-db/database/sourcedata/AD_WINDOW.xml
src-db/database/sourcedata/OBSERDS_DATASOURCE.xml
src-db/database/sourcedata/OBUIAPP_PARAMETER.xml
src-db/database/sourcedata/OBUIAPP_PROCESS.xml
src-db/database/sourcedata/OBUIAPP_REF_WINDOW.xml
src/org/openbravo/materialmgmt/ManageVariantsDS.java
src/org/openbravo/materialmgmt/actionhandler/ManageVariants.java
--- a/src-db/database/model/tables/M_PRODUCT.xml	Thu Jun 27 10:28:17 2013 +0200
+++ b/src-db/database/model/tables/M_PRODUCT.xml	Fri Jun 28 14:58:20 2013 +0200
@@ -345,6 +345,10 @@
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="MANAGEVARIANTS" primaryKey="false" required="false" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA[N]]></default>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_ORG" name="AD_ORG_MPRODUCT">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Thu Jun 27 10:28:17 2013 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Fri Jun 28 14:58:20 2013 +0200
@@ -222801,6 +222801,40 @@
 <!--11F755DE7007411FA9D61421815A71E1-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--11F755DE7007411FA9D61421815A71E1--></AD_COLUMN>
 
+<!--123A02634DBA47D3A9250043ADA5BD90--><AD_COLUMN>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <AD_COLUMN_ID><![CDATA[123A02634DBA47D3A9250043ADA5BD90]]></AD_COLUMN_ID>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <NAME><![CDATA[Updated By]]></NAME>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <DESCRIPTION><![CDATA[User who updated this records]]></DESCRIPTION>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <HELP><![CDATA[The Updated By field indicates the user who updated this record.]]></HELP>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <COLUMNNAME><![CDATA[UpdatedBy]]></COLUMNNAME>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <SEQNO><![CDATA[80]]></SEQNO>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <AD_ELEMENT_ID><![CDATA[608]]></AD_ELEMENT_ID>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--123A02634DBA47D3A9250043ADA5BD90-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--123A02634DBA47D3A9250043ADA5BD90--></AD_COLUMN>
+
 <!--123ECC9DA80E47D6BBE8D3C8E9ACC59C--><AD_COLUMN>
 <!--123ECC9DA80E47D6BBE8D3C8E9ACC59C-->  <AD_COLUMN_ID><![CDATA[123ECC9DA80E47D6BBE8D3C8E9ACC59C]]></AD_COLUMN_ID>
 <!--123ECC9DA80E47D6BBE8D3C8E9ACC59C-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -227658,6 +227692,37 @@
 <!--2AA57E9B932549BCB74C9DD283840AD2-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--2AA57E9B932549BCB74C9DD283840AD2--></AD_COLUMN>
 
+<!--2B115DCD9D4E456E971C13184959060B--><AD_COLUMN>
+<!--2B115DCD9D4E456E971C13184959060B-->  <AD_COLUMN_ID><![CDATA[2B115DCD9D4E456E971C13184959060B]]></AD_COLUMN_ID>
+<!--2B115DCD9D4E456E971C13184959060B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2B115DCD9D4E456E971C13184959060B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2B115DCD9D4E456E971C13184959060B-->  <NAME><![CDATA[c_ob_selected]]></NAME>
+<!--2B115DCD9D4E456E971C13184959060B-->  <COLUMNNAME><![CDATA[OB_Selected]]></COLUMNNAME>
+<!--2B115DCD9D4E456E971C13184959060B-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--2B115DCD9D4E456E971C13184959060B-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--2B115DCD9D4E456E971C13184959060B-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--2B115DCD9D4E456E971C13184959060B-->  <SEQNO><![CDATA[120]]></SEQNO>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--2B115DCD9D4E456E971C13184959060B-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--2B115DCD9D4E456E971C13184959060B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--2B115DCD9D4E456E971C13184959060B-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--2B115DCD9D4E456E971C13184959060B-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--2B115DCD9D4E456E971C13184959060B-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--2B115DCD9D4E456E971C13184959060B--></AD_COLUMN>
+
 <!--2B1857B270ED4D5A9AC956BB6AA78F24--><AD_COLUMN>
 <!--2B1857B270ED4D5A9AC956BB6AA78F24-->  <AD_COLUMN_ID><![CDATA[2B1857B270ED4D5A9AC956BB6AA78F24]]></AD_COLUMN_ID>
 <!--2B1857B270ED4D5A9AC956BB6AA78F24-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -228446,6 +228511,40 @@
 <!--2FD790AF217148AE8D7628ECC9F3D7C3-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--2FD790AF217148AE8D7628ECC9F3D7C3--></AD_COLUMN>
 
+<!--2FD8B69C24B94912B1BB4E508C7AC77B--><AD_COLUMN>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <AD_COLUMN_ID><![CDATA[2FD8B69C24B94912B1BB4E508C7AC77B]]></AD_COLUMN_ID>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <NAME><![CDATA[Updated]]></NAME>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <DESCRIPTION><![CDATA[The date that this record was last updated]]></DESCRIPTION>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <HELP><![CDATA[The Updated field indicates the date that this record was updated.]]></HELP>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <COLUMNNAME><![CDATA[Updated]]></COLUMNNAME>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <SEQNO><![CDATA[70]]></SEQNO>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <AD_ELEMENT_ID><![CDATA[607]]></AD_ELEMENT_ID>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--2FD8B69C24B94912B1BB4E508C7AC77B--></AD_COLUMN>
+
 <!--3016237232444E83962F47A938F811CD--><AD_COLUMN>
 <!--3016237232444E83962F47A938F811CD-->  <AD_COLUMN_ID><![CDATA[3016237232444E83962F47A938F811CD]]></AD_COLUMN_ID>
 <!--3016237232444E83962F47A938F811CD-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -230674,6 +230773,40 @@
 <!--3C63F1EC9A9B4DC8ACFBE312A72CDE5A-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--3C63F1EC9A9B4DC8ACFBE312A72CDE5A--></AD_COLUMN>
 
+<!--3C711021198A4818A1C4F5E4CB7A7C9A--><AD_COLUMN>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <AD_COLUMN_ID><![CDATA[3C711021198A4818A1C4F5E4CB7A7C9A]]></AD_COLUMN_ID>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <NAME><![CDATA[Organization]]></NAME>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <DESCRIPTION><![CDATA[Organizational entity within client]]></DESCRIPTION>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <HELP><![CDATA[An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.]]></HELP>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <COLUMNNAME><![CDATA[AD_Org_ID]]></COLUMNNAME>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <AD_ELEMENT_ID><![CDATA[113]]></AD_ELEMENT_ID>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--3C711021198A4818A1C4F5E4CB7A7C9A--></AD_COLUMN>
+
 <!--3C96A94065F14A29B64ACA59226F7AC8--><AD_COLUMN>
 <!--3C96A94065F14A29B64ACA59226F7AC8-->  <AD_COLUMN_ID><![CDATA[3C96A94065F14A29B64ACA59226F7AC8]]></AD_COLUMN_ID>
 <!--3C96A94065F14A29B64ACA59226F7AC8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -231877,6 +232010,42 @@
 <!--43130E70F0A2464CB670B5D48F2D2BA5-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--43130E70F0A2464CB670B5D48F2D2BA5--></AD_COLUMN>
 
+<!--442764EA454D4BDBB5B96EA324AC70A5--><AD_COLUMN>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <AD_COLUMN_ID><![CDATA[442764EA454D4BDBB5B96EA324AC70A5]]></AD_COLUMN_ID>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <NAME><![CDATA[Active]]></NAME>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <DESCRIPTION><![CDATA[A flag indicating whether this record is available for use or de-activated.]]></DESCRIPTION>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <HELP><![CDATA[There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records: 
+(1) The system requires the record for auditing purposes.
+(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.]]></HELP>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <COLUMNNAME><![CDATA[IsActive]]></COLUMNNAME>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <SEQNO><![CDATA[40]]></SEQNO>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <AD_ELEMENT_ID><![CDATA[348]]></AD_ELEMENT_ID>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--442764EA454D4BDBB5B96EA324AC70A5-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--442764EA454D4BDBB5B96EA324AC70A5--></AD_COLUMN>
+
 <!--44639EB55C5F4D899889466C9B6A3463--><AD_COLUMN>
 <!--44639EB55C5F4D899889466C9B6A3463-->  <AD_COLUMN_ID><![CDATA[44639EB55C5F4D899889466C9B6A3463]]></AD_COLUMN_ID>
 <!--44639EB55C5F4D899889466C9B6A3463-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -233450,6 +233619,40 @@
 <!--4BDAB25F4E75423DBF487DA8533282BD-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--4BDAB25F4E75423DBF487DA8533282BD--></AD_COLUMN>
 
+<!--4C217290DD1F40EAAD2265B4CE72EDED--><AD_COLUMN>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <AD_COLUMN_ID><![CDATA[4C217290DD1F40EAAD2265B4CE72EDED]]></AD_COLUMN_ID>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <NAME><![CDATA[Client]]></NAME>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <DESCRIPTION><![CDATA[Client for this installation.]]></DESCRIPTION>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <HELP><![CDATA[A Client is a company or a legal entity. You cannot share data between Clients.]]></HELP>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <COLUMNNAME><![CDATA[AD_Client_ID]]></COLUMNNAME>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <SEQNO><![CDATA[20]]></SEQNO>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <AD_ELEMENT_ID><![CDATA[102]]></AD_ELEMENT_ID>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--4C217290DD1F40EAAD2265B4CE72EDED-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--4C217290DD1F40EAAD2265B4CE72EDED--></AD_COLUMN>
+
 <!--4C34FD5CD5F947049A55B6CCEFA15960--><AD_COLUMN>
 <!--4C34FD5CD5F947049A55B6CCEFA15960-->  <AD_COLUMN_ID><![CDATA[4C34FD5CD5F947049A55B6CCEFA15960]]></AD_COLUMN_ID>
 <!--4C34FD5CD5F947049A55B6CCEFA15960-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -233946,6 +234149,42 @@
 <!--505825A28B744B71A0E2FE85C814F3A5-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--505825A28B744B71A0E2FE85C814F3A5--></AD_COLUMN>
 
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6--><AD_COLUMN>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <AD_COLUMN_ID><![CDATA[5083D0CC53914FCFAAE3489FFB0D0CE6]]></AD_COLUMN_ID>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <NAME><![CDATA[Search Key]]></NAME>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <DESCRIPTION><![CDATA[A fast method for finding a particular record.]]></DESCRIPTION>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <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>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <COLUMNNAME><![CDATA[value]]></COLUMNNAME>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <FIELDLENGTH><![CDATA[60]]></FIELDLENGTH>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <SEQNO><![CDATA[90]]></SEQNO>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <AD_ELEMENT_ID><![CDATA[620]]></AD_ELEMENT_ID>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--5083D0CC53914FCFAAE3489FFB0D0CE6--></AD_COLUMN>
+
 <!--50C572BF5B0E46319FC8F32201A8408E--><AD_COLUMN>
 <!--50C572BF5B0E46319FC8F32201A8408E-->  <AD_COLUMN_ID><![CDATA[50C572BF5B0E46319FC8F32201A8408E]]></AD_COLUMN_ID>
 <!--50C572BF5B0E46319FC8F32201A8408E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -236656,6 +236895,40 @@
 <!--5614E4E936C2456586AD9C7F3247283F-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--5614E4E936C2456586AD9C7F3247283F--></AD_COLUMN>
 
+<!--562EC839781F44709457CFC501748DC2--><AD_COLUMN>
+<!--562EC839781F44709457CFC501748DC2-->  <AD_COLUMN_ID><![CDATA[562EC839781F44709457CFC501748DC2]]></AD_COLUMN_ID>
+<!--562EC839781F44709457CFC501748DC2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--562EC839781F44709457CFC501748DC2-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--562EC839781F44709457CFC501748DC2-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--562EC839781F44709457CFC501748DC2-->  <NAME><![CDATA[Created By]]></NAME>
+<!--562EC839781F44709457CFC501748DC2-->  <DESCRIPTION><![CDATA[User who created this records]]></DESCRIPTION>
+<!--562EC839781F44709457CFC501748DC2-->  <HELP><![CDATA[The Created By field indicates the user who created this record.]]></HELP>
+<!--562EC839781F44709457CFC501748DC2-->  <COLUMNNAME><![CDATA[CreatedBy]]></COLUMNNAME>
+<!--562EC839781F44709457CFC501748DC2-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--562EC839781F44709457CFC501748DC2-->  <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
+<!--562EC839781F44709457CFC501748DC2-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--562EC839781F44709457CFC501748DC2-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--562EC839781F44709457CFC501748DC2-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--562EC839781F44709457CFC501748DC2-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--562EC839781F44709457CFC501748DC2-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--562EC839781F44709457CFC501748DC2-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--562EC839781F44709457CFC501748DC2-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--562EC839781F44709457CFC501748DC2-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--562EC839781F44709457CFC501748DC2-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--562EC839781F44709457CFC501748DC2-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--562EC839781F44709457CFC501748DC2-->  <AD_ELEMENT_ID><![CDATA[246]]></AD_ELEMENT_ID>
+<!--562EC839781F44709457CFC501748DC2-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--562EC839781F44709457CFC501748DC2-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--562EC839781F44709457CFC501748DC2-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--562EC839781F44709457CFC501748DC2-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--562EC839781F44709457CFC501748DC2-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--562EC839781F44709457CFC501748DC2-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--562EC839781F44709457CFC501748DC2-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--562EC839781F44709457CFC501748DC2-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--562EC839781F44709457CFC501748DC2-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--562EC839781F44709457CFC501748DC2-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--562EC839781F44709457CFC501748DC2--></AD_COLUMN>
+
 <!--565E56DF64D99042E040007F01002829--><AD_COLUMN>
 <!--565E56DF64D99042E040007F01002829-->  <AD_COLUMN_ID><![CDATA[565E56DF64D99042E040007F01002829]]></AD_COLUMN_ID>
 <!--565E56DF64D99042E040007F01002829-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -257286,6 +257559,40 @@
 <!--6F61A8993BCC5E52E040007F01005AF5-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--6F61A8993BCC5E52E040007F01005AF5--></AD_COLUMN>
 
+<!--6F8BC2231616458999E3DFE7414E41F5--><AD_COLUMN>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <AD_COLUMN_ID><![CDATA[6F8BC2231616458999E3DFE7414E41F5]]></AD_COLUMN_ID>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <NAME><![CDATA[Creation Date]]></NAME>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <DESCRIPTION><![CDATA[The date that this record is completed.]]></DESCRIPTION>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <HELP><![CDATA[The Created field indicates the date that this record was created.]]></HELP>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <COLUMNNAME><![CDATA[Created]]></COLUMNNAME>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <AD_ELEMENT_ID><![CDATA[245]]></AD_ELEMENT_ID>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--6F8BC2231616458999E3DFE7414E41F5-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--6F8BC2231616458999E3DFE7414E41F5--></AD_COLUMN>
+
 <!--6F8E1F092B774401A63F331EFEE83496--><AD_COLUMN>
 <!--6F8E1F092B774401A63F331EFEE83496-->  <AD_COLUMN_ID><![CDATA[6F8E1F092B774401A63F331EFEE83496]]></AD_COLUMN_ID>
 <!--6F8E1F092B774401A63F331EFEE83496-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -285116,6 +285423,37 @@
 <!--93050F02630B4CB08F1D48FF71C1D2BD-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--93050F02630B4CB08F1D48FF71C1D2BD--></AD_COLUMN>
 
+<!--937E801D62F2425F91A90372901FB189--><AD_COLUMN>
+<!--937E801D62F2425F91A90372901FB189-->  <AD_COLUMN_ID><![CDATA[937E801D62F2425F91A90372901FB189]]></AD_COLUMN_ID>
+<!--937E801D62F2425F91A90372901FB189-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--937E801D62F2425F91A90372901FB189-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--937E801D62F2425F91A90372901FB189-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--937E801D62F2425F91A90372901FB189-->  <NAME><![CDATA[Variant Created]]></NAME>
+<!--937E801D62F2425F91A90372901FB189-->  <COLUMNNAME><![CDATA[isVariantCreated]]></COLUMNNAME>
+<!--937E801D62F2425F91A90372901FB189-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--937E801D62F2425F91A90372901FB189-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--937E801D62F2425F91A90372901FB189-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--937E801D62F2425F91A90372901FB189-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--937E801D62F2425F91A90372901FB189-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--937E801D62F2425F91A90372901FB189-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--937E801D62F2425F91A90372901FB189-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--937E801D62F2425F91A90372901FB189-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--937E801D62F2425F91A90372901FB189-->  <SEQNO><![CDATA[130]]></SEQNO>
+<!--937E801D62F2425F91A90372901FB189-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--937E801D62F2425F91A90372901FB189-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--937E801D62F2425F91A90372901FB189-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--937E801D62F2425F91A90372901FB189-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--937E801D62F2425F91A90372901FB189-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--937E801D62F2425F91A90372901FB189-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--937E801D62F2425F91A90372901FB189-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--937E801D62F2425F91A90372901FB189-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--937E801D62F2425F91A90372901FB189-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--937E801D62F2425F91A90372901FB189-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--937E801D62F2425F91A90372901FB189-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--937E801D62F2425F91A90372901FB189-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--937E801D62F2425F91A90372901FB189-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--937E801D62F2425F91A90372901FB189--></AD_COLUMN>
+
 <!--9382FCA58F4EAF36E040A8C021013A93--><AD_COLUMN>
 <!--9382FCA58F4EAF36E040A8C021013A93-->  <AD_COLUMN_ID><![CDATA[9382FCA58F4EAF36E040A8C021013A93]]></AD_COLUMN_ID>
 <!--9382FCA58F4EAF36E040A8C021013A93-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -296991,6 +297329,38 @@
 <!--B46323A21354425EAA2FB28EA4D86B37-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--B46323A21354425EAA2FB28EA4D86B37--></AD_COLUMN>
 
+<!--B4CB4875970144F9B42C357DC1129576--><AD_COLUMN>
+<!--B4CB4875970144F9B42C357DC1129576-->  <AD_COLUMN_ID><![CDATA[B4CB4875970144F9B42C357DC1129576]]></AD_COLUMN_ID>
+<!--B4CB4875970144F9B42C357DC1129576-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B4CB4875970144F9B42C357DC1129576-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B4CB4875970144F9B42C357DC1129576-->  <NAME><![CDATA[id]]></NAME>
+<!--B4CB4875970144F9B42C357DC1129576-->  <COLUMNNAME><![CDATA[id]]></COLUMNNAME>
+<!--B4CB4875970144F9B42C357DC1129576-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--B4CB4875970144F9B42C357DC1129576-->  <AD_REFERENCE_ID><![CDATA[13]]></AD_REFERENCE_ID>
+<!--B4CB4875970144F9B42C357DC1129576-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISKEY><![CDATA[Y]]></ISKEY>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--B4CB4875970144F9B42C357DC1129576-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--B4CB4875970144F9B42C357DC1129576-->  <AD_ELEMENT_ID><![CDATA[E01FC8107518BAEFE040007F010005CC]]></AD_ELEMENT_ID>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--B4CB4875970144F9B42C357DC1129576-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--B4CB4875970144F9B42C357DC1129576-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--B4CB4875970144F9B42C357DC1129576-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--B4CB4875970144F9B42C357DC1129576-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--B4CB4875970144F9B42C357DC1129576-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--B4CB4875970144F9B42C357DC1129576--></AD_COLUMN>
+
 <!--B515858C2040417D9BC41BA12F936B78--><AD_COLUMN>
 <!--B515858C2040417D9BC41BA12F936B78-->  <AD_COLUMN_ID><![CDATA[B515858C2040417D9BC41BA12F936B78]]></AD_COLUMN_ID>
 <!--B515858C2040417D9BC41BA12F936B78-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -315170,6 +315540,40 @@
 <!--DFE34CED8F06273BE040007F0100319F-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--DFE34CED8F06273BE040007F0100319F--></AD_COLUMN>
 
+<!--E01FCAF529B5F265E040007F01000597--><AD_COLUMN>
+<!--E01FCAF529B5F265E040007F01000597-->  <AD_COLUMN_ID><![CDATA[E01FCAF529B5F265E040007F01000597]]></AD_COLUMN_ID>
+<!--E01FCAF529B5F265E040007F01000597-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E01FCAF529B5F265E040007F01000597-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E01FCAF529B5F265E040007F01000597-->  <NAME><![CDATA[Manage Variants]]></NAME>
+<!--E01FCAF529B5F265E040007F01000597-->  <COLUMNNAME><![CDATA[ManageVariants]]></COLUMNNAME>
+<!--E01FCAF529B5F265E040007F01000597-->  <AD_TABLE_ID><![CDATA[208]]></AD_TABLE_ID>
+<!--E01FCAF529B5F265E040007F01000597-->  <AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID>
+<!--E01FCAF529B5F265E040007F01000597-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--E01FCAF529B5F265E040007F01000597-->  <DEFAULTVALUE><![CDATA[N]]></DEFAULTVALUE>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--E01FCAF529B5F265E040007F01000597-->  <SEQNO><![CDATA[530]]></SEQNO>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--E01FCAF529B5F265E040007F01000597-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--E01FCAF529B5F265E040007F01000597-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E01FCAF529B5F265E040007F01000597-->  <POSITION><![CDATA[94]]></POSITION>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--E01FCAF529B5F265E040007F01000597-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--E01FCAF529B5F265E040007F01000597-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--E01FCAF529B5F265E040007F01000597-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--E01FCAF529B5F265E040007F01000597-->  <EM_OBUIAPP_PROCESS_ID><![CDATA[FE3A8C134D41488DB3A69837BD54B56A]]></EM_OBUIAPP_PROCESS_ID>
+<!--E01FCAF529B5F265E040007F01000597--></AD_COLUMN>
+
 <!--E0386DBA300149B88800B0FF94AB44C3--><AD_COLUMN>
 <!--E0386DBA300149B88800B0FF94AB44C3-->  <AD_COLUMN_ID><![CDATA[E0386DBA300149B88800B0FF94AB44C3]]></AD_COLUMN_ID>
 <!--E0386DBA300149B88800B0FF94AB44C3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -315778,6 +316182,40 @@
 <!--E33846D308F641369E45B3FE1E5F5B2F-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--E33846D308F641369E45B3FE1E5F5B2F--></AD_COLUMN>
 
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16--><AD_COLUMN>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <AD_COLUMN_ID><![CDATA[E3A4DF5BA9C246CA9C4A26EC2B998F16]]></AD_COLUMN_ID>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <NAME><![CDATA[Name]]></NAME>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <DESCRIPTION><![CDATA[A non-unique identifier for a record/document often used as a search tool.]]></DESCRIPTION>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <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>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <COLUMNNAME><![CDATA[Name]]></COLUMNNAME>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <FIELDLENGTH><![CDATA[90]]></FIELDLENGTH>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <SEQNO><![CDATA[100]]></SEQNO>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <AD_ELEMENT_ID><![CDATA[469]]></AD_ELEMENT_ID>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--E3A4DF5BA9C246CA9C4A26EC2B998F16--></AD_COLUMN>
+
 <!--E3BA2D1447264DA88D24EEB40B199C4F--><AD_COLUMN>
 <!--E3BA2D1447264DA88D24EEB40B199C4F-->  <AD_COLUMN_ID><![CDATA[E3BA2D1447264DA88D24EEB40B199C4F]]></AD_COLUMN_ID>
 <!--E3BA2D1447264DA88D24EEB40B199C4F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -316838,6 +317276,39 @@
 <!--EAA0128F7AF34632AB9215AF7EACE95E-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--EAA0128F7AF34632AB9215AF7EACE95E--></AD_COLUMN>
 
+<!--EACD73D12ACB4B32B8DA8E015C59205A--><AD_COLUMN>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <AD_COLUMN_ID><![CDATA[EACD73D12ACB4B32B8DA8E015C59205A]]></AD_COLUMN_ID>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <NAME><![CDATA[Characteristic Description]]></NAME>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <HELP><![CDATA[Text with the concatenation of the characteristics and its values assigned to the product.]]></HELP>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <COLUMNNAME><![CDATA[Characteristic_Desc]]></COLUMNNAME>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <AD_REFERENCE_ID><![CDATA[C632F1CFF5A1453EB28BDF44A70478F8]]></AD_REFERENCE_ID>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <FIELDLENGTH><![CDATA[120]]></FIELDLENGTH>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <SEQNO><![CDATA[110]]></SEQNO>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <AD_ELEMENT_ID><![CDATA[DA9043B34A024B13E040007F010048FD]]></AD_ELEMENT_ID>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--EACD73D12ACB4B32B8DA8E015C59205A-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--EACD73D12ACB4B32B8DA8E015C59205A--></AD_COLUMN>
+
 <!--EAEDB737C7AD4AE8B656B3EE9E7673A1--><AD_COLUMN>
 <!--EAEDB737C7AD4AE8B656B3EE9E7673A1-->  <AD_COLUMN_ID><![CDATA[EAEDB737C7AD4AE8B656B3EE9E7673A1]]></AD_COLUMN_ID>
 <!--EAEDB737C7AD4AE8B656B3EE9E7673A1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Thu Jun 27 10:28:17 2013 +0200
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Fri Jun 28 14:58:20 2013 +0200
@@ -31138,6 +31138,18 @@
 <!--DFE819133DAB4FC3881A08D7489B1E76-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--DFE819133DAB4FC3881A08D7489B1E76--></AD_ELEMENT>
 
+<!--E01FC8107518BAEFE040007F010005CC--><AD_ELEMENT>
+<!--E01FC8107518BAEFE040007F010005CC-->  <AD_ELEMENT_ID><![CDATA[E01FC8107518BAEFE040007F010005CC]]></AD_ELEMENT_ID>
+<!--E01FC8107518BAEFE040007F010005CC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E01FC8107518BAEFE040007F010005CC-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E01FC8107518BAEFE040007F010005CC-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E01FC8107518BAEFE040007F010005CC-->  <COLUMNNAME><![CDATA[M_ManageVariants_ID]]></COLUMNNAME>
+<!--E01FC8107518BAEFE040007F010005CC-->  <NAME><![CDATA[Manage Variants]]></NAME>
+<!--E01FC8107518BAEFE040007F010005CC-->  <PRINTNAME><![CDATA[Manage Variants]]></PRINTNAME>
+<!--E01FC8107518BAEFE040007F010005CC-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E01FC8107518BAEFE040007F010005CC-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--E01FC8107518BAEFE040007F010005CC--></AD_ELEMENT>
+
 <!--E0AAAEDD15444468A96DDAF14AF227F2--><AD_ELEMENT>
 <!--E0AAAEDD15444468A96DDAF14AF227F2-->  <AD_ELEMENT_ID><![CDATA[E0AAAEDD15444468A96DDAF14AF227F2]]></AD_ELEMENT_ID>
 <!--E0AAAEDD15444468A96DDAF14AF227F2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Thu Jun 27 10:28:17 2013 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Fri Jun 28 14:58:20 2013 +0200
@@ -186117,6 +186117,34 @@
 <!--2994A25901A44EFBB69D86B3341B9A74-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--2994A25901A44EFBB69D86B3341B9A74--></AD_FIELD>
 
+<!--2999A4E0F8294157A874789D70AA1F46--><AD_FIELD>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <AD_FIELD_ID><![CDATA[2999A4E0F8294157A874789D70AA1F46]]></AD_FIELD_ID>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <NAME><![CDATA[Manage Variants]]></NAME>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <AD_TAB_ID><![CDATA[180]]></AD_TAB_ID>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <AD_COLUMN_ID><![CDATA[E01FCAF529B5F265E040007F01000597]]></AD_COLUMN_ID>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <DISPLAYLOGIC><![CDATA[@isGeneric@='Y' & @HideManageVariantsButton@!'Y']]></DISPLAYLOGIC>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <DISPLAYLENGTH><![CDATA[0]]></DISPLAYLENGTH>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <GRID_SEQNO><![CDATA[150]]></GRID_SEQNO>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--2999A4E0F8294157A874789D70AA1F46-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--2999A4E0F8294157A874789D70AA1F46--></AD_FIELD>
+
 <!--299BD32E44C44A51AACC70B1F2866E6B--><AD_FIELD>
 <!--299BD32E44C44A51AACC70B1F2866E6B-->  <AD_FIELD_ID><![CDATA[299BD32E44C44A51AACC70B1F2866E6B]]></AD_FIELD_ID>
 <!--299BD32E44C44A51AACC70B1F2866E6B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -270284,7 +270312,7 @@
 <!--DA25E4835891E0B5E040007F01001FA0-->  <AD_COLUMN_ID><![CDATA[DA19506EAA6BF8C9E040007F010076AB]]></AD_COLUMN_ID>
 <!--DA25E4835891E0B5E040007F01001FA0-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
 <!--DA25E4835891E0B5E040007F01001FA0-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--DA25E4835891E0B5E040007F01001FA0-->  <DISPLAYLOGIC><![CDATA[@isGeneric@='Y']]></DISPLAYLOGIC>
+<!--DA25E4835891E0B5E040007F01001FA0-->  <DISPLAYLOGIC><![CDATA[@isGeneric@='Y' & @HideCreateVariantsButton@!'Y']]></DISPLAYLOGIC>
 <!--DA25E4835891E0B5E040007F01001FA0-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
 <!--DA25E4835891E0B5E040007F01001FA0-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
 <!--DA25E4835891E0B5E040007F01001FA0-->  <SEQNO><![CDATA[950]]></SEQNO>
@@ -272163,6 +272191,252 @@
 <!--DFE35093F77C8609E040007F01003195-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--DFE35093F77C8609E040007F01003195--></AD_FIELD>
 
+<!--E01FC44E2864FFBCE040007F01000332--><AD_FIELD>
+<!--E01FC44E2864FFBCE040007F01000332-->  <AD_FIELD_ID><![CDATA[E01FC44E2864FFBCE040007F01000332]]></AD_FIELD_ID>
+<!--E01FC44E2864FFBCE040007F01000332-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E01FC44E2864FFBCE040007F01000332-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E01FC44E2864FFBCE040007F01000332-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E01FC44E2864FFBCE040007F01000332-->  <NAME><![CDATA[Client]]></NAME>
+<!--E01FC44E2864FFBCE040007F01000332-->  <DESCRIPTION><![CDATA[Client for this installation.]]></DESCRIPTION>
+<!--E01FC44E2864FFBCE040007F01000332-->  <HELP><![CDATA[A Client is a company or a legal entity. You cannot share data between Clients.]]></HELP>
+<!--E01FC44E2864FFBCE040007F01000332-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E01FC44E2864FFBCE040007F01000332-->  <AD_TAB_ID><![CDATA[A6BA61CF899D457B9E8AA1C83BB79C5B]]></AD_TAB_ID>
+<!--E01FC44E2864FFBCE040007F01000332-->  <AD_COLUMN_ID><![CDATA[4C217290DD1F40EAAD2265B4CE72EDED]]></AD_COLUMN_ID>
+<!--E01FC44E2864FFBCE040007F01000332-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--E01FC44E2864FFBCE040007F01000332-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--E01FC44E2864FFBCE040007F01000332-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--E01FC44E2864FFBCE040007F01000332-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--E01FC44E2864FFBCE040007F01000332-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--E01FC44E2864FFBCE040007F01000332-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--E01FC44E2864FFBCE040007F01000332-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E01FC44E2864FFBCE040007F01000332-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--E01FC44E2864FFBCE040007F01000332-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--E01FC44E2864FFBCE040007F01000332-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E01FC44E2864FFBCE040007F01000332-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--E01FC44E2864FFBCE040007F01000332-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--E01FC44E2864FFBCE040007F01000332-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--E01FC44E2864FFBCE040007F01000332-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--E01FC44E2864FFBCE040007F01000332--></AD_FIELD>
+
+<!--E01FC44E2866FFBCE040007F01000332--><AD_FIELD>
+<!--E01FC44E2866FFBCE040007F01000332-->  <AD_FIELD_ID><![CDATA[E01FC44E2866FFBCE040007F01000332]]></AD_FIELD_ID>
+<!--E01FC44E2866FFBCE040007F01000332-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E01FC44E2866FFBCE040007F01000332-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E01FC44E2866FFBCE040007F01000332-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E01FC44E2866FFBCE040007F01000332-->  <NAME><![CDATA[Organization]]></NAME>
+<!--E01FC44E2866FFBCE040007F01000332-->  <DESCRIPTION><![CDATA[Organizational entity within client]]></DESCRIPTION>
+<!--E01FC44E2866FFBCE040007F01000332-->  <HELP><![CDATA[An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.]]></HELP>
+<!--E01FC44E2866FFBCE040007F01000332-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E01FC44E2866FFBCE040007F01000332-->  <AD_TAB_ID><![CDATA[A6BA61CF899D457B9E8AA1C83BB79C5B]]></AD_TAB_ID>
+<!--E01FC44E2866FFBCE040007F01000332-->  <AD_COLUMN_ID><![CDATA[3C711021198A4818A1C4F5E4CB7A7C9A]]></AD_COLUMN_ID>
+<!--E01FC44E2866FFBCE040007F01000332-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--E01FC44E2866FFBCE040007F01000332-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--E01FC44E2866FFBCE040007F01000332-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--E01FC44E2866FFBCE040007F01000332-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--E01FC44E2866FFBCE040007F01000332-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--E01FC44E2866FFBCE040007F01000332-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--E01FC44E2866FFBCE040007F01000332-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E01FC44E2866FFBCE040007F01000332-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--E01FC44E2866FFBCE040007F01000332-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--E01FC44E2866FFBCE040007F01000332-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E01FC44E2866FFBCE040007F01000332-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--E01FC44E2866FFBCE040007F01000332-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--E01FC44E2866FFBCE040007F01000332-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--E01FC44E2866FFBCE040007F01000332-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--E01FC44E2866FFBCE040007F01000332--></AD_FIELD>
+
+<!--E01FC44E2868FFBCE040007F01000332--><AD_FIELD>
+<!--E01FC44E2868FFBCE040007F01000332-->  <AD_FIELD_ID><![CDATA[E01FC44E2868FFBCE040007F01000332]]></AD_FIELD_ID>
+<!--E01FC44E2868FFBCE040007F01000332-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E01FC44E2868FFBCE040007F01000332-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E01FC44E2868FFBCE040007F01000332-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E01FC44E2868FFBCE040007F01000332-->  <NAME><![CDATA[Characteristic Description]]></NAME>
+<!--E01FC44E2868FFBCE040007F01000332-->  <HELP><![CDATA[Text with the concatenation of the characteristics and its values assigned to the product.]]></HELP>
+<!--E01FC44E2868FFBCE040007F01000332-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E01FC44E2868FFBCE040007F01000332-->  <AD_TAB_ID><![CDATA[A6BA61CF899D457B9E8AA1C83BB79C5B]]></AD_TAB_ID>
+<!--E01FC44E2868FFBCE040007F01000332-->  <AD_COLUMN_ID><![CDATA[EACD73D12ACB4B32B8DA8E015C59205A]]></AD_COLUMN_ID>
+<!--E01FC44E2868FFBCE040007F01000332-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--E01FC44E2868FFBCE040007F01000332-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--E01FC44E2868FFBCE040007F01000332-->  <DISPLAYLENGTH><![CDATA[120]]></DISPLAYLENGTH>
+<!--E01FC44E2868FFBCE040007F01000332-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
+<!--E01FC44E2868FFBCE040007F01000332-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--E01FC44E2868FFBCE040007F01000332-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--E01FC44E2868FFBCE040007F01000332-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--E01FC44E2868FFBCE040007F01000332-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E01FC44E2868FFBCE040007F01000332-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--E01FC44E2868FFBCE040007F01000332-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--E01FC44E2868FFBCE040007F01000332-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E01FC44E2868FFBCE040007F01000332-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--E01FC44E2868FFBCE040007F01000332-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--E01FC44E2868FFBCE040007F01000332-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--E01FC44E2868FFBCE040007F01000332-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--E01FC44E2868FFBCE040007F01000332--></AD_FIELD>
+
+<!--E01FC44E286AFFBCE040007F01000332--><AD_FIELD>
+<!--E01FC44E286AFFBCE040007F01000332-->  <AD_FIELD_ID><![CDATA[E01FC44E286AFFBCE040007F01000332]]></AD_FIELD_ID>
+<!--E01FC44E286AFFBCE040007F01000332-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E01FC44E286AFFBCE040007F01000332-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E01FC44E286AFFBCE040007F01000332-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E01FC44E286AFFBCE040007F01000332-->  <NAME><![CDATA[Active]]></NAME>
+<!--E01FC44E286AFFBCE040007F01000332-->  <DESCRIPTION><![CDATA[A flag indicating whether this record is available for use or de-activated.]]></DESCRIPTION>
+<!--E01FC44E286AFFBCE040007F01000332-->  <HELP><![CDATA[There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records: 
+(1) The system requires the record for auditing purposes.
+(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.]]></HELP>
+<!--E01FC44E286AFFBCE040007F01000332-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E01FC44E286AFFBCE040007F01000332-->  <AD_TAB_ID><![CDATA[A6BA61CF899D457B9E8AA1C83BB79C5B]]></AD_TAB_ID>
+<!--E01FC44E286AFFBCE040007F01000332-->  <AD_COLUMN_ID><![CDATA[442764EA454D4BDBB5B96EA324AC70A5]]></AD_COLUMN_ID>
+<!--E01FC44E286AFFBCE040007F01000332-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--E01FC44E286AFFBCE040007F01000332-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--E01FC44E286AFFBCE040007F01000332-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--E01FC44E286AFFBCE040007F01000332-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--E01FC44E286AFFBCE040007F01000332-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--E01FC44E286AFFBCE040007F01000332-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--E01FC44E286AFFBCE040007F01000332-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E01FC44E286AFFBCE040007F01000332-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--E01FC44E286AFFBCE040007F01000332-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--E01FC44E286AFFBCE040007F01000332-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E01FC44E286AFFBCE040007F01000332-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--E01FC44E286AFFBCE040007F01000332-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--E01FC44E286AFFBCE040007F01000332-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--E01FC44E286AFFBCE040007F01000332-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--E01FC44E286AFFBCE040007F01000332--></AD_FIELD>
+
+<!--E01FC44E286CFFBCE040007F01000332--><AD_FIELD>
+<!--E01FC44E286CFFBCE040007F01000332-->  <AD_FIELD_ID><![CDATA[E01FC44E286CFFBCE040007F01000332]]></AD_FIELD_ID>
+<!--E01FC44E286CFFBCE040007F01000332-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E01FC44E286CFFBCE040007F01000332-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E01FC44E286CFFBCE040007F01000332-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E01FC44E286CFFBCE040007F01000332-->  <NAME><![CDATA[Search Key]]></NAME>
+<!--E01FC44E286CFFBCE040007F01000332-->  <DESCRIPTION><![CDATA[A fast method for finding a particular record.]]></DESCRIPTION>
+<!--E01FC44E286CFFBCE040007F01000332-->  <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>
+<!--E01FC44E286CFFBCE040007F01000332-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E01FC44E286CFFBCE040007F01000332-->  <AD_TAB_ID><![CDATA[A6BA61CF899D457B9E8AA1C83BB79C5B]]></AD_TAB_ID>
+<!--E01FC44E286CFFBCE040007F01000332-->  <AD_COLUMN_ID><![CDATA[5083D0CC53914FCFAAE3489FFB0D0CE6]]></AD_COLUMN_ID>
+<!--E01FC44E286CFFBCE040007F01000332-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--E01FC44E286CFFBCE040007F01000332-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--E01FC44E286CFFBCE040007F01000332-->  <DISPLAYLENGTH><![CDATA[20]]></DISPLAYLENGTH>
+<!--E01FC44E286CFFBCE040007F01000332-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--E01FC44E286CFFBCE040007F01000332-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--E01FC44E286CFFBCE040007F01000332-->  <SORTNO><![CDATA[1]]></SORTNO>
+<!--E01FC44E286CFFBCE040007F01000332-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--E01FC44E286CFFBCE040007F01000332-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--E01FC44E286CFFBCE040007F01000332-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E01FC44E286CFFBCE040007F01000332-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--E01FC44E286CFFBCE040007F01000332-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--E01FC44E286CFFBCE040007F01000332-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E01FC44E286CFFBCE040007F01000332-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--E01FC44E286CFFBCE040007F01000332-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--E01FC44E286CFFBCE040007F01000332-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--E01FC44E286CFFBCE040007F01000332-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--E01FC44E286CFFBCE040007F01000332--></AD_FIELD>
+
+<!--E01FC44E286EFFBCE040007F01000332--><AD_FIELD>
+<!--E01FC44E286EFFBCE040007F01000332-->  <AD_FIELD_ID><![CDATA[E01FC44E286EFFBCE040007F01000332]]></AD_FIELD_ID>
+<!--E01FC44E286EFFBCE040007F01000332-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E01FC44E286EFFBCE040007F01000332-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E01FC44E286EFFBCE040007F01000332-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E01FC44E286EFFBCE040007F01000332-->  <NAME><![CDATA[Name]]></NAME>
+<!--E01FC44E286EFFBCE040007F01000332-->  <DESCRIPTION><![CDATA[A non-unique identifier for a record/document often used as a search tool.]]></DESCRIPTION>
+<!--E01FC44E286EFFBCE040007F01000332-->  <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>
+<!--E01FC44E286EFFBCE040007F01000332-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E01FC44E286EFFBCE040007F01000332-->  <AD_TAB_ID><![CDATA[A6BA61CF899D457B9E8AA1C83BB79C5B]]></AD_TAB_ID>
+<!--E01FC44E286EFFBCE040007F01000332-->  <AD_COLUMN_ID><![CDATA[E3A4DF5BA9C246CA9C4A26EC2B998F16]]></AD_COLUMN_ID>
+<!--E01FC44E286EFFBCE040007F01000332-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--E01FC44E286EFFBCE040007F01000332-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--E01FC44E286EFFBCE040007F01000332-->  <DISPLAYLENGTH><![CDATA[90]]></DISPLAYLENGTH>
+<!--E01FC44E286EFFBCE040007F01000332-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--E01FC44E286EFFBCE040007F01000332-->  <SEQNO><![CDATA[20]]></SEQNO>
+<!--E01FC44E286EFFBCE040007F01000332-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--E01FC44E286EFFBCE040007F01000332-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--E01FC44E286EFFBCE040007F01000332-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E01FC44E286EFFBCE040007F01000332-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--E01FC44E286EFFBCE040007F01000332-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--E01FC44E286EFFBCE040007F01000332-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E01FC44E286EFFBCE040007F01000332-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--E01FC44E286EFFBCE040007F01000332-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--E01FC44E286EFFBCE040007F01000332-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--E01FC44E286EFFBCE040007F01000332-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--E01FC44E286EFFBCE040007F01000332--></AD_FIELD>
+
+<!--E01FC44E2870FFBCE040007F01000332--><AD_FIELD>
+<!--E01FC44E2870FFBCE040007F01000332-->  <AD_FIELD_ID><![CDATA[E01FC44E2870FFBCE040007F01000332]]></AD_FIELD_ID>
+<!--E01FC44E2870FFBCE040007F01000332-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E01FC44E2870FFBCE040007F01000332-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E01FC44E2870FFBCE040007F01000332-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E01FC44E2870FFBCE040007F01000332-->  <NAME><![CDATA[c_ob_selected]]></NAME>
+<!--E01FC44E2870FFBCE040007F01000332-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E01FC44E2870FFBCE040007F01000332-->  <AD_TAB_ID><![CDATA[A6BA61CF899D457B9E8AA1C83BB79C5B]]></AD_TAB_ID>
+<!--E01FC44E2870FFBCE040007F01000332-->  <AD_COLUMN_ID><![CDATA[2B115DCD9D4E456E971C13184959060B]]></AD_COLUMN_ID>
+<!--E01FC44E2870FFBCE040007F01000332-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--E01FC44E2870FFBCE040007F01000332-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--E01FC44E2870FFBCE040007F01000332-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--E01FC44E2870FFBCE040007F01000332-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--E01FC44E2870FFBCE040007F01000332-->  <SEQNO><![CDATA[0]]></SEQNO>
+<!--E01FC44E2870FFBCE040007F01000332-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--E01FC44E2870FFBCE040007F01000332-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--E01FC44E2870FFBCE040007F01000332-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E01FC44E2870FFBCE040007F01000332-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--E01FC44E2870FFBCE040007F01000332-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--E01FC44E2870FFBCE040007F01000332-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E01FC44E2870FFBCE040007F01000332-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--E01FC44E2870FFBCE040007F01000332-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--E01FC44E2870FFBCE040007F01000332-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--E01FC44E2870FFBCE040007F01000332-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--E01FC44E2870FFBCE040007F01000332--></AD_FIELD>
+
+<!--E01FC44E2872FFBCE040007F01000332--><AD_FIELD>
+<!--E01FC44E2872FFBCE040007F01000332-->  <AD_FIELD_ID><![CDATA[E01FC44E2872FFBCE040007F01000332]]></AD_FIELD_ID>
+<!--E01FC44E2872FFBCE040007F01000332-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E01FC44E2872FFBCE040007F01000332-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E01FC44E2872FFBCE040007F01000332-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E01FC44E2872FFBCE040007F01000332-->  <NAME><![CDATA[Variant Created]]></NAME>
+<!--E01FC44E2872FFBCE040007F01000332-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E01FC44E2872FFBCE040007F01000332-->  <AD_TAB_ID><![CDATA[A6BA61CF899D457B9E8AA1C83BB79C5B]]></AD_TAB_ID>
+<!--E01FC44E2872FFBCE040007F01000332-->  <AD_COLUMN_ID><![CDATA[937E801D62F2425F91A90372901FB189]]></AD_COLUMN_ID>
+<!--E01FC44E2872FFBCE040007F01000332-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--E01FC44E2872FFBCE040007F01000332-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--E01FC44E2872FFBCE040007F01000332-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--E01FC44E2872FFBCE040007F01000332-->  <ISREADONLY><![CDATA[Y]]></ISREADONLY>
+<!--E01FC44E2872FFBCE040007F01000332-->  <SEQNO><![CDATA[40]]></SEQNO>
+<!--E01FC44E2872FFBCE040007F01000332-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--E01FC44E2872FFBCE040007F01000332-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--E01FC44E2872FFBCE040007F01000332-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E01FC44E2872FFBCE040007F01000332-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--E01FC44E2872FFBCE040007F01000332-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--E01FC44E2872FFBCE040007F01000332-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E01FC44E2872FFBCE040007F01000332-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--E01FC44E2872FFBCE040007F01000332-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--E01FC44E2872FFBCE040007F01000332-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--E01FC44E2872FFBCE040007F01000332-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--E01FC44E2872FFBCE040007F01000332--></AD_FIELD>
+
+<!--E01FC44E2874FFBCE040007F01000332--><AD_FIELD>
+<!--E01FC44E2874FFBCE040007F01000332-->  <AD_FIELD_ID><![CDATA[E01FC44E2874FFBCE040007F01000332]]></AD_FIELD_ID>
+<!--E01FC44E2874FFBCE040007F01000332-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E01FC44E2874FFBCE040007F01000332-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E01FC44E2874FFBCE040007F01000332-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E01FC44E2874FFBCE040007F01000332-->  <NAME><![CDATA[id]]></NAME>
+<!--E01FC44E2874FFBCE040007F01000332-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E01FC44E2874FFBCE040007F01000332-->  <AD_TAB_ID><![CDATA[A6BA61CF899D457B9E8AA1C83BB79C5B]]></AD_TAB_ID>
+<!--E01FC44E2874FFBCE040007F01000332-->  <AD_COLUMN_ID><![CDATA[B4CB4875970144F9B42C357DC1129576]]></AD_COLUMN_ID>
+<!--E01FC44E2874FFBCE040007F01000332-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--E01FC44E2874FFBCE040007F01000332-->  <ISDISPLAYED><![CDATA[N]]></ISDISPLAYED>
+<!--E01FC44E2874FFBCE040007F01000332-->  <DISPLAYLENGTH><![CDATA[32]]></DISPLAYLENGTH>
+<!--E01FC44E2874FFBCE040007F01000332-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--E01FC44E2874FFBCE040007F01000332-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--E01FC44E2874FFBCE040007F01000332-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--E01FC44E2874FFBCE040007F01000332-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E01FC44E2874FFBCE040007F01000332-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--E01FC44E2874FFBCE040007F01000332-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--E01FC44E2874FFBCE040007F01000332-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E01FC44E2874FFBCE040007F01000332-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--E01FC44E2874FFBCE040007F01000332-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--E01FC44E2874FFBCE040007F01000332-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--E01FC44E2874FFBCE040007F01000332-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--E01FC44E2874FFBCE040007F01000332--></AD_FIELD>
+
 <!--E0757BAE4BC64E79811F27CA69078E3E--><AD_FIELD>
 <!--E0757BAE4BC64E79811F27CA69078E3E-->  <AD_FIELD_ID><![CDATA[E0757BAE4BC64E79811F27CA69078E3E]]></AD_FIELD_ID>
 <!--E0757BAE4BC64E79811F27CA69078E3E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_REFERENCE.xml	Thu Jun 27 10:28:17 2013 +0200
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml	Fri Jun 28 14:58:20 2013 +0200
@@ -5694,6 +5694,18 @@
 <!--C632F1CFF5A1453EB28BDF44A70478F8-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
 <!--C632F1CFF5A1453EB28BDF44A70478F8--></AD_REFERENCE>
 
+<!--C9252925E607456A9BE935B3B8F1BC9F--><AD_REFERENCE>
+<!--C9252925E607456A9BE935B3B8F1BC9F-->  <AD_REFERENCE_ID><![CDATA[C9252925E607456A9BE935B3B8F1BC9F]]></AD_REFERENCE_ID>
+<!--C9252925E607456A9BE935B3B8F1BC9F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C9252925E607456A9BE935B3B8F1BC9F-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C9252925E607456A9BE935B3B8F1BC9F-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C9252925E607456A9BE935B3B8F1BC9F-->  <NAME><![CDATA[ManageVariants Pick and Execute]]></NAME>
+<!--C9252925E607456A9BE935B3B8F1BC9F-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--C9252925E607456A9BE935B3B8F1BC9F-->  <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--C9252925E607456A9BE935B3B8F1BC9F-->  <PARENTREFERENCE_ID><![CDATA[FF80818132D8F0F30132D9BC395D0038]]></PARENTREFERENCE_ID>
+<!--C9252925E607456A9BE935B3B8F1BC9F-->  <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--C9252925E607456A9BE935B3B8F1BC9F--></AD_REFERENCE>
+
 <!--CBF00FA9F3744F1A86025AD16F2AF86A--><AD_REFERENCE>
 <!--CBF00FA9F3744F1A86025AD16F2AF86A-->  <AD_REFERENCE_ID><![CDATA[CBF00FA9F3744F1A86025AD16F2AF86A]]></AD_REFERENCE_ID>
 <!--CBF00FA9F3744F1A86025AD16F2AF86A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_TAB.xml	Thu Jun 27 10:28:17 2013 +0200
+++ b/src-db/database/sourcedata/AD_TAB.xml	Fri Jun 28 14:58:20 2013 +0200
@@ -14771,6 +14771,33 @@
 <!--A661A0A05DCD4650BCB14B010C87F0AA-->  <EM_OBUIAPP_SHOW_SELECT><![CDATA[Y]]></EM_OBUIAPP_SHOW_SELECT>
 <!--A661A0A05DCD4650BCB14B010C87F0AA--></AD_TAB>
 
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B--><AD_TAB>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <AD_TAB_ID><![CDATA[A6BA61CF899D457B9E8AA1C83BB79C5B]]></AD_TAB_ID>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <NAME><![CDATA[Variants]]></NAME>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <AD_WINDOW_ID><![CDATA[F00A1A57E3894121A8FC1957497423F7]]></AD_WINDOW_ID>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <TABLEVEL><![CDATA[0]]></TABLEVEL>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <ISSINGLEROW><![CDATA[N]]></ISSINGLEROW>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <ISINFOTAB><![CDATA[N]]></ISINFOTAB>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <ISTRANSLATIONTAB><![CDATA[N]]></ISTRANSLATIONTAB>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <HASTREE><![CDATA[N]]></HASTREE>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <PROCESSING><![CDATA[N]]></PROCESSING>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <IMPORTFIELDS><![CDATA[N]]></IMPORTFIELDS>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <ISSORTTAB><![CDATA[N]]></ISSORTTAB>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <UIPATTERN><![CDATA[STD]]></UIPATTERN>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <HQLORDERBYCLAUSE><![CDATA[obSelected DESC]]></HQLORDERBYCLAUSE>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <SHOWPARENTBUTTONS><![CDATA[Y]]></SHOWPARENTBUTTONS>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <EM_OBUIAPP_CAN_ADD><![CDATA[N]]></EM_OBUIAPP_CAN_ADD>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <EM_OBUIAPP_CAN_DELETE><![CDATA[N]]></EM_OBUIAPP_CAN_DELETE>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B-->  <EM_OBUIAPP_SHOW_SELECT><![CDATA[Y]]></EM_OBUIAPP_SHOW_SELECT>
+<!--A6BA61CF899D457B9E8AA1C83BB79C5B--></AD_TAB>
+
 <!--A9F3CB2CCAA0406AB97E73274DF60B93--><AD_TAB>
 <!--A9F3CB2CCAA0406AB97E73274DF60B93-->  <AD_TAB_ID><![CDATA[A9F3CB2CCAA0406AB97E73274DF60B93]]></AD_TAB_ID>
 <!--A9F3CB2CCAA0406AB97E73274DF60B93-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_TABLE.xml	Thu Jun 27 10:28:17 2013 +0200
+++ b/src-db/database/sourcedata/AD_TABLE.xml	Fri Jun 28 14:58:20 2013 +0200
@@ -8505,6 +8505,7 @@
 <!--0455C3C718354E8891C14FA50E4D0161-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--0455C3C718354E8891C14FA50E4D0161-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--0455C3C718354E8891C14FA50E4D0161-->  <AD_PACKAGE_ID><![CDATA[5A3ED54AB1DA4B84E040007F01006125]]></AD_PACKAGE_ID>
+<!--0455C3C718354E8891C14FA50E4D0161-->  <DATAORIGINTYPE><![CDATA[Table]]></DATAORIGINTYPE>
 <!--0455C3C718354E8891C14FA50E4D0161--></AD_TABLE>
 
 <!--07707D29DBEF4248A954825E6E26FE66--><AD_TABLE>
@@ -8526,6 +8527,7 @@
 <!--07707D29DBEF4248A954825E6E26FE66-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--07707D29DBEF4248A954825E6E26FE66-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--07707D29DBEF4248A954825E6E26FE66-->  <AD_PACKAGE_ID><![CDATA[5A3ED54AB1DA4B84E040007F01006125]]></AD_PACKAGE_ID>
+<!--07707D29DBEF4248A954825E6E26FE66-->  <DATAORIGINTYPE><![CDATA[Table]]></DATAORIGINTYPE>
 <!--07707D29DBEF4248A954825E6E26FE66--></AD_TABLE>
 
 <!--07A7EA77984146968DDA3C74B92039B5--><AD_TABLE>
@@ -8687,6 +8689,27 @@
 <!--0EA05A734BA74DDB873CE8DA4BB52473-->  <DATAORIGINTYPE><![CDATA[Table]]></DATAORIGINTYPE>
 <!--0EA05A734BA74DDB873CE8DA4BB52473--></AD_TABLE>
 
+<!--147D4D709FAC4AF0B611ABFED328FA12--><AD_TABLE>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <AD_TABLE_ID><![CDATA[147D4D709FAC4AF0B611ABFED328FA12]]></AD_TABLE_ID>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <NAME><![CDATA[ManageVariants]]></NAME>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <TABLENAME><![CDATA[ManageVariants]]></TABLENAME>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <ISVIEW><![CDATA[N]]></ISVIEW>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <ACCESSLEVEL><![CDATA[3]]></ACCESSLEVEL>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <ISSECURITYENABLED><![CDATA[N]]></ISSECURITYENABLED>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <ISDELETEABLE><![CDATA[Y]]></ISDELETEABLE>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <ISHIGHVOLUME><![CDATA[N]]></ISHIGHVOLUME>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <IMPORTTABLE><![CDATA[N]]></IMPORTTABLE>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <ISCHANGELOG><![CDATA[N]]></ISCHANGELOG>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <AD_PACKAGE_ID><![CDATA[5A3ED54AB1DA4B84E040007F01006125]]></AD_PACKAGE_ID>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <DATAORIGINTYPE><![CDATA[Datasource]]></DATAORIGINTYPE>
+<!--147D4D709FAC4AF0B611ABFED328FA12-->  <OBSERDS_DATASOURCE_ID><![CDATA[6654D607F650425A9DFF7B6961D54920]]></OBSERDS_DATASOURCE_ID>
+<!--147D4D709FAC4AF0B611ABFED328FA12--></AD_TABLE>
+
 <!--16D0C2D87F744A508861CD957C4D3793--><AD_TABLE>
 <!--16D0C2D87F744A508861CD957C4D3793-->  <AD_TABLE_ID><![CDATA[16D0C2D87F744A508861CD957C4D3793]]></AD_TABLE_ID>
 <!--16D0C2D87F744A508861CD957C4D3793-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -8797,6 +8820,7 @@
 <!--1FFDAE010D7842378ED9B400D6C3E216-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--1FFDAE010D7842378ED9B400D6C3E216-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--1FFDAE010D7842378ED9B400D6C3E216-->  <AD_PACKAGE_ID><![CDATA[5A3ED54AB1C84B84E040007F01006125]]></AD_PACKAGE_ID>
+<!--1FFDAE010D7842378ED9B400D6C3E216-->  <DATAORIGINTYPE><![CDATA[Table]]></DATAORIGINTYPE>
 <!--1FFDAE010D7842378ED9B400D6C3E216--></AD_TABLE>
 
 <!--21E98AE4A7D94935A32D17B6EFC81AAC--><AD_TABLE>
@@ -9609,6 +9633,7 @@
 <!--610C84B81180457FAD4D63DB5F92EC6F-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--610C84B81180457FAD4D63DB5F92EC6F-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--610C84B81180457FAD4D63DB5F92EC6F-->  <AD_PACKAGE_ID><![CDATA[5A3ED54AB1DA4B84E040007F01006125]]></AD_PACKAGE_ID>
+<!--610C84B81180457FAD4D63DB5F92EC6F-->  <DATAORIGINTYPE><![CDATA[Table]]></DATAORIGINTYPE>
 <!--610C84B81180457FAD4D63DB5F92EC6F--></AD_TABLE>
 
 <!--61F97E1F887D4167A7795FF67A921D91--><AD_TABLE>
@@ -10135,6 +10160,7 @@
 <!--8E4A6598CA2747B6B0E7257C6F3DEB19-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--8E4A6598CA2747B6B0E7257C6F3DEB19-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--8E4A6598CA2747B6B0E7257C6F3DEB19-->  <AD_PACKAGE_ID><![CDATA[5A3ED54AB1DA4B84E040007F01006125]]></AD_PACKAGE_ID>
+<!--8E4A6598CA2747B6B0E7257C6F3DEB19-->  <DATAORIGINTYPE><![CDATA[Table]]></DATAORIGINTYPE>
 <!--8E4A6598CA2747B6B0E7257C6F3DEB19--></AD_TABLE>
 
 <!--8EABE4230116400FA30CAF1A57BBC579--><AD_TABLE>
@@ -10226,6 +10252,7 @@
 <!--91C26DEA4B3D4C05B4F277D009220872-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--91C26DEA4B3D4C05B4F277D009220872-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--91C26DEA4B3D4C05B4F277D009220872-->  <AD_PACKAGE_ID><![CDATA[5A3ED54AB1DA4B84E040007F01006125]]></AD_PACKAGE_ID>
+<!--91C26DEA4B3D4C05B4F277D009220872-->  <DATAORIGINTYPE><![CDATA[Table]]></DATAORIGINTYPE>
 <!--91C26DEA4B3D4C05B4F277D009220872--></AD_TABLE>
 
 <!--93F49C7968574D99B18085A6DD3C5CC6--><AD_TABLE>
@@ -10977,6 +11004,7 @@
 <!--D8CF681853BB41B491AF000A54352A56-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--D8CF681853BB41B491AF000A54352A56-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--D8CF681853BB41B491AF000A54352A56-->  <AD_PACKAGE_ID><![CDATA[5A3ED54AB1DA4B84E040007F01006125]]></AD_PACKAGE_ID>
+<!--D8CF681853BB41B491AF000A54352A56-->  <DATAORIGINTYPE><![CDATA[Table]]></DATAORIGINTYPE>
 <!--D8CF681853BB41B491AF000A54352A56--></AD_TABLE>
 
 <!--DC63963AB3F1489BAAB5A9A7EFD1B407--><AD_TABLE>
@@ -11113,6 +11141,7 @@
 <!--E913D17C9B3847CF92235082DBE2EC44-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
 <!--E913D17C9B3847CF92235082DBE2EC44-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
 <!--E913D17C9B3847CF92235082DBE2EC44-->  <AD_PACKAGE_ID><![CDATA[5A3ED54AB1DA4B84E040007F01006125]]></AD_PACKAGE_ID>
+<!--E913D17C9B3847CF92235082DBE2EC44-->  <DATAORIGINTYPE><![CDATA[Table]]></DATAORIGINTYPE>
 <!--E913D17C9B3847CF92235082DBE2EC44--></AD_TABLE>
 
 <!--EADDFEC95B5841D881BBA81A8D942CD2--><AD_TABLE>
--- a/src-db/database/sourcedata/AD_WINDOW.xml	Thu Jun 27 10:28:17 2013 +0200
+++ b/src-db/database/sourcedata/AD_WINDOW.xml	Fri Jun 28 14:58:20 2013 +0200
@@ -3298,6 +3298,21 @@
 <!--EF3E837705944F4DBF398D683D36ACE0-->  <ISADVANCEDFEATURE><![CDATA[N]]></ISADVANCEDFEATURE>
 <!--EF3E837705944F4DBF398D683D36ACE0--></AD_WINDOW>
 
+<!--F00A1A57E3894121A8FC1957497423F7--><AD_WINDOW>
+<!--F00A1A57E3894121A8FC1957497423F7-->  <AD_WINDOW_ID><![CDATA[F00A1A57E3894121A8FC1957497423F7]]></AD_WINDOW_ID>
+<!--F00A1A57E3894121A8FC1957497423F7-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F00A1A57E3894121A8FC1957497423F7-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F00A1A57E3894121A8FC1957497423F7-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F00A1A57E3894121A8FC1957497423F7-->  <NAME><![CDATA[Manage Variants Pick and Execute]]></NAME>
+<!--F00A1A57E3894121A8FC1957497423F7-->  <WINDOWTYPE><![CDATA[OBUIAPP_PickAndExecute]]></WINDOWTYPE>
+<!--F00A1A57E3894121A8FC1957497423F7-->  <ISSOTRX><![CDATA[Y]]></ISSOTRX>
+<!--F00A1A57E3894121A8FC1957497423F7-->  <PROCESSING><![CDATA[N]]></PROCESSING>
+<!--F00A1A57E3894121A8FC1957497423F7-->  <ISDEFAULT><![CDATA[N]]></ISDEFAULT>
+<!--F00A1A57E3894121A8FC1957497423F7-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--F00A1A57E3894121A8FC1957497423F7-->  <ISTHREADSAFE><![CDATA[N]]></ISTHREADSAFE>
+<!--F00A1A57E3894121A8FC1957497423F7-->  <ISADVANCEDFEATURE><![CDATA[N]]></ISADVANCEDFEATURE>
+<!--F00A1A57E3894121A8FC1957497423F7--></AD_WINDOW>
+
 <!--FC404D2406A9491CBD905D0D38F04846--><AD_WINDOW>
 <!--FC404D2406A9491CBD905D0D38F04846-->  <AD_WINDOW_ID><![CDATA[FC404D2406A9491CBD905D0D38F04846]]></AD_WINDOW_ID>
 <!--FC404D2406A9491CBD905D0D38F04846-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/OBSERDS_DATASOURCE.xml	Thu Jun 27 10:28:17 2013 +0200
+++ b/src-db/database/sourcedata/OBSERDS_DATASOURCE.xml	Fri Jun 28 14:58:20 2013 +0200
@@ -1,5 +1,18 @@
 <?xml version='1.0' encoding='UTF-8'?>
 <data>
+<!--6654D607F650425A9DFF7B6961D54920--><OBSERDS_DATASOURCE>
+<!--6654D607F650425A9DFF7B6961D54920-->  <OBSERDS_DATASOURCE_ID><![CDATA[6654D607F650425A9DFF7B6961D54920]]></OBSERDS_DATASOURCE_ID>
+<!--6654D607F650425A9DFF7B6961D54920-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--6654D607F650425A9DFF7B6961D54920-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--6654D607F650425A9DFF7B6961D54920-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--6654D607F650425A9DFF7B6961D54920-->  <NAME><![CDATA[Manage Variants DataSource]]></NAME>
+<!--6654D607F650425A9DFF7B6961D54920-->  <DESCRIPTION><![CDATA[Datasource to be used in the Manage Variants Pick and Execute]]></DESCRIPTION>
+<!--6654D607F650425A9DFF7B6961D54920-->  <CLASSNAME><![CDATA[org.openbravo.materialmgmt.ManageVariantsDS]]></CLASSNAME>
+<!--6654D607F650425A9DFF7B6961D54920-->  <OBCLKER_TEMPLATE_ID><![CDATA[2BAD445C2A0343C58E455F9BD379C690]]></OBCLKER_TEMPLATE_ID>
+<!--6654D607F650425A9DFF7B6961D54920-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--6654D607F650425A9DFF7B6961D54920-->  <USEASTABLEDATAORIGIN><![CDATA[Y]]></USEASTABLEDATAORIGIN>
+<!--6654D607F650425A9DFF7B6961D54920--></OBSERDS_DATASOURCE>
+
 <!--BE2735798ECC4EF88D131F16F1C4EC72--><OBSERDS_DATASOURCE>
 <!--BE2735798ECC4EF88D131F16F1C4EC72-->  <OBSERDS_DATASOURCE_ID><![CDATA[BE2735798ECC4EF88D131F16F1C4EC72]]></OBSERDS_DATASOURCE_ID>
 <!--BE2735798ECC4EF88D131F16F1C4EC72-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -10,6 +23,7 @@
 <!--BE2735798ECC4EF88D131F16F1C4EC72-->  <CLASSNAME><![CDATA[org.openbravo.materialmgmt.ProductCharacteristicsDS]]></CLASSNAME>
 <!--BE2735798ECC4EF88D131F16F1C4EC72-->  <OBCLKER_TEMPLATE_ID><![CDATA[2BAD445C2A0343C58E455F9BD379C690]]></OBCLKER_TEMPLATE_ID>
 <!--BE2735798ECC4EF88D131F16F1C4EC72-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--BE2735798ECC4EF88D131F16F1C4EC72-->  <USEASTABLEDATAORIGIN><![CDATA[N]]></USEASTABLEDATAORIGIN>
 <!--BE2735798ECC4EF88D131F16F1C4EC72--></OBSERDS_DATASOURCE>
 
 </data>
--- a/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml	Thu Jun 27 10:28:17 2013 +0200
+++ b/src-db/database/sourcedata/OBUIAPP_PARAMETER.xml	Fri Jun 28 14:58:20 2013 +0200
@@ -106,6 +106,27 @@
 <!--608B149396C04375B78B0B28681AA53E-->  <EM_OBKMO_WIDGET_CLASS_ID><![CDATA[7EE694CFF8B94B4C9B9CE69C9D292CC4]]></EM_OBKMO_WIDGET_CLASS_ID>
 <!--608B149396C04375B78B0B28681AA53E--></OBUIAPP_PARAMETER>
 
+<!--6B15654D49A4408DBC25E63836D02199--><OBUIAPP_PARAMETER>
+<!--6B15654D49A4408DBC25E63836D02199-->  <OBUIAPP_PARAMETER_ID><![CDATA[6B15654D49A4408DBC25E63836D02199]]></OBUIAPP_PARAMETER_ID>
+<!--6B15654D49A4408DBC25E63836D02199-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--6B15654D49A4408DBC25E63836D02199-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--6B15654D49A4408DBC25E63836D02199-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--6B15654D49A4408DBC25E63836D02199-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--6B15654D49A4408DBC25E63836D02199-->  <NAME><![CDATA[Pick/Edit Lines]]></NAME>
+<!--6B15654D49A4408DBC25E63836D02199-->  <SEQNO><![CDATA[0]]></SEQNO>
+<!--6B15654D49A4408DBC25E63836D02199-->  <AD_REFERENCE_ID><![CDATA[FF80818132D8F0F30132D9BC395D0038]]></AD_REFERENCE_ID>
+<!--6B15654D49A4408DBC25E63836D02199-->  <AD_REFERENCE_VALUE_ID><![CDATA[C9252925E607456A9BE935B3B8F1BC9F]]></AD_REFERENCE_VALUE_ID>
+<!--6B15654D49A4408DBC25E63836D02199-->  <COLUMNNAME><![CDATA[grid]]></COLUMNNAME>
+<!--6B15654D49A4408DBC25E63836D02199-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--6B15654D49A4408DBC25E63836D02199-->  <FIELDLENGTH><![CDATA[0]]></FIELDLENGTH>
+<!--6B15654D49A4408DBC25E63836D02199-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--6B15654D49A4408DBC25E63836D02199-->  <AD_ELEMENT_ID><![CDATA[B27C7AF72FEFEC33E040007F0100076A]]></AD_ELEMENT_ID>
+<!--6B15654D49A4408DBC25E63836D02199-->  <ISFIXED><![CDATA[N]]></ISFIXED>
+<!--6B15654D49A4408DBC25E63836D02199-->  <EVALUATEFIXEDVALUE><![CDATA[N]]></EVALUATEFIXEDVALUE>
+<!--6B15654D49A4408DBC25E63836D02199-->  <OBUIAPP_PROCESS_ID><![CDATA[FE3A8C134D41488DB3A69837BD54B56A]]></OBUIAPP_PROCESS_ID>
+<!--6B15654D49A4408DBC25E63836D02199-->  <STARTINNEWLINE><![CDATA[N]]></STARTINNEWLINE>
+<!--6B15654D49A4408DBC25E63836D02199--></OBUIAPP_PARAMETER>
+
 <!--7ADC57778917472EA9B7A433197B47BF--><OBUIAPP_PARAMETER>
 <!--7ADC57778917472EA9B7A433197B47BF-->  <OBUIAPP_PARAMETER_ID><![CDATA[7ADC57778917472EA9B7A433197B47BF]]></OBUIAPP_PARAMETER_ID>
 <!--7ADC57778917472EA9B7A433197B47BF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/OBUIAPP_PROCESS.xml	Thu Jun 27 10:28:17 2013 +0200
+++ b/src-db/database/sourcedata/OBUIAPP_PROCESS.xml	Fri Jun 28 14:58:20 2013 +0200
@@ -153,4 +153,19 @@
 <!--C79A2D191BBD48AC8456DBD1AAF89E04-->  <ISMULTIRECORD><![CDATA[N]]></ISMULTIRECORD>
 <!--C79A2D191BBD48AC8456DBD1AAF89E04--></OBUIAPP_PROCESS>
 
+<!--FE3A8C134D41488DB3A69837BD54B56A--><OBUIAPP_PROCESS>
+<!--FE3A8C134D41488DB3A69837BD54B56A-->  <OBUIAPP_PROCESS_ID><![CDATA[FE3A8C134D41488DB3A69837BD54B56A]]></OBUIAPP_PROCESS_ID>
+<!--FE3A8C134D41488DB3A69837BD54B56A-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--FE3A8C134D41488DB3A69837BD54B56A-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--FE3A8C134D41488DB3A69837BD54B56A-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--FE3A8C134D41488DB3A69837BD54B56A-->  <VALUE><![CDATA[ManageVariants]]></VALUE>
+<!--FE3A8C134D41488DB3A69837BD54B56A-->  <NAME><![CDATA[Manage Variants]]></NAME>
+<!--FE3A8C134D41488DB3A69837BD54B56A-->  <ACCESSLEVEL><![CDATA[3]]></ACCESSLEVEL>
+<!--FE3A8C134D41488DB3A69837BD54B56A-->  <CLASSNAME><![CDATA[org.openbravo.materialmgmt.actionhandler.ManageVariants]]></CLASSNAME>
+<!--FE3A8C134D41488DB3A69837BD54B56A-->  <ISBACKGROUND><![CDATA[N]]></ISBACKGROUND>
+<!--FE3A8C134D41488DB3A69837BD54B56A-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--FE3A8C134D41488DB3A69837BD54B56A-->  <UIPATTERN><![CDATA[OBUIAPP_PickAndExecute]]></UIPATTERN>
+<!--FE3A8C134D41488DB3A69837BD54B56A-->  <ISMULTIRECORD><![CDATA[N]]></ISMULTIRECORD>
+<!--FE3A8C134D41488DB3A69837BD54B56A--></OBUIAPP_PROCESS>
+
 </data>
--- a/src-db/database/sourcedata/OBUIAPP_REF_WINDOW.xml	Thu Jun 27 10:28:17 2013 +0200
+++ b/src-db/database/sourcedata/OBUIAPP_REF_WINDOW.xml	Fri Jun 28 14:58:20 2013 +0200
@@ -45,6 +45,15 @@
 <!--93EBCF30B14F4ECC867EF8B87E8372CB-->  <AD_WINDOW_ID><![CDATA[6AA84F4BDAA44477808F0E7A86AB4961]]></AD_WINDOW_ID>
 <!--93EBCF30B14F4ECC867EF8B87E8372CB--></OBUIAPP_REF_WINDOW>
 
+<!--C3A5F61A58074AAE83067967A418623E--><OBUIAPP_REF_WINDOW>
+<!--C3A5F61A58074AAE83067967A418623E-->  <OBUIAPP_REF_WINDOW_ID><![CDATA[C3A5F61A58074AAE83067967A418623E]]></OBUIAPP_REF_WINDOW_ID>
+<!--C3A5F61A58074AAE83067967A418623E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C3A5F61A58074AAE83067967A418623E-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C3A5F61A58074AAE83067967A418623E-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C3A5F61A58074AAE83067967A418623E-->  <AD_REFERENCE_ID><![CDATA[C9252925E607456A9BE935B3B8F1BC9F]]></AD_REFERENCE_ID>
+<!--C3A5F61A58074AAE83067967A418623E-->  <AD_WINDOW_ID><![CDATA[F00A1A57E3894121A8FC1957497423F7]]></AD_WINDOW_ID>
+<!--C3A5F61A58074AAE83067967A418623E--></OBUIAPP_REF_WINDOW>
+
 <!--F92179A1D974489DBAFEAF52B8F910A9--><OBUIAPP_REF_WINDOW>
 <!--F92179A1D974489DBAFEAF52B8F910A9-->  <OBUIAPP_REF_WINDOW_ID><![CDATA[F92179A1D974489DBAFEAF52B8F910A9]]></OBUIAPP_REF_WINDOW_ID>
 <!--F92179A1D974489DBAFEAF52B8F910A9-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/org/openbravo/materialmgmt/ManageVariantsDS.java	Fri Jun 28 14:58:20 2013 +0200
@@ -0,0 +1,352 @@
+/*
+ *************************************************************************
+ * The contents of this file are subject to the Openbravo  Public  License
+ * Version  1.0  (the  "License"),  being   the  Mozilla   Public  License
+ * Version 1.1  with a permitted attribution clause; you may not  use this
+ * file except in compliance with the License. You  may  obtain  a copy of
+ * the License at http://www.openbravo.com/legal/license.html
+ * Software distributed under the License  is  distributed  on  an "AS IS"
+ * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+ * License for the specific  language  governing  rights  and  limitations
+ * under the License.
+ * The Original Code is Openbravo ERP.
+ * The Initial Developer of the Original Code is Openbravo SLU
+ * All portions are Copyright (C) 2013 Openbravo SLU
+ * All Rights Reserved.
+ * Contributor(s):  ______________________________________.
+ *************************************************************************
+ */
+package org.openbravo.materialmgmt;
+
+import java.util.ArrayList;
+import java.util.Date;
+import java.util.HashMap;
+import java.util.Iterator;
+import java.util.List;
+import java.util.Map;
+
+import org.apache.commons.lang.StringUtils;
+import org.codehaus.jettison.json.JSONArray;
+import org.codehaus.jettison.json.JSONException;
+import org.codehaus.jettison.json.JSONObject;
+import org.hibernate.criterion.Restrictions;
+import org.openbravo.base.model.Entity;
+import org.openbravo.base.model.ModelProvider;
+import org.openbravo.base.model.Property;
+import org.openbravo.dal.core.DalUtil;
+import org.openbravo.dal.core.OBContext;
+import org.openbravo.dal.service.OBCriteria;
+import org.openbravo.dal.service.OBDal;
+import org.openbravo.dal.service.OBQuery;
+import org.openbravo.model.common.plm.Characteristic;
+import org.openbravo.model.common.plm.CharacteristicValue;
+import org.openbravo.model.common.plm.Product;
+import org.openbravo.model.common.plm.ProductCharacteristic;
+import org.openbravo.model.common.plm.ProductCharacteristicConf;
+import org.openbravo.model.common.plm.ProductCharacteristicValue;
+import org.openbravo.service.datasource.ReadOnlyDataSourceService;
+import org.openbravo.service.json.JsonUtils;
+
+public class ManageVariantsDS extends ReadOnlyDataSourceService {
+  private static final int searchKeyLength = getSearchKeyColumnLength();
+  private List<String> selectedIds = new ArrayList<String>();
+  private HashMap<String, List<CharacteristicValue>> selectedChValues = new HashMap<String, List<CharacteristicValue>>();
+  private String nameFilter;
+  private String searchKeyFilter;
+  private Boolean variantCreated;
+
+  @Override
+  protected int getCount(Map<String, String> parameters) {
+    return getData(parameters, 0, Integer.MAX_VALUE).size();
+  }
+
+  @Override
+  protected List<Map<String, Object>> getData(Map<String, String> parameters, int startRow,
+      int endRow) {
+    OBContext.setAdminMode();
+    final List<Map<String, Object>> result = new ArrayList<Map<String, Object>>();
+    try {
+      readCriteria(parameters);
+      final String strProductId = parameters.get("@Product.id@");
+      final Product product = OBDal.getInstance().get(Product.class, strProductId);
+
+      int totalMaxLength = product.getSearchKey().length();
+      long variantNumber = 1;
+      Map<ProductCharacteristic, ProductCharacteristicAux> prChUseCode = new HashMap<ProductCharacteristic, ProductCharacteristicAux>();
+
+      OBCriteria<ProductCharacteristic> prChCrit = OBDal.getInstance().createCriteria(
+          ProductCharacteristic.class);
+      prChCrit.add(Restrictions.eq(ProductCharacteristic.PROPERTY_PRODUCT, product));
+      prChCrit.add(Restrictions.eq(ProductCharacteristic.PROPERTY_VARIANT, true));
+      prChCrit.addOrderBy(ProductCharacteristic.PROPERTY_SEQUENCENUMBER, true);
+      List<ProductCharacteristic> prChs = prChCrit.list();
+      int chNumber = prChs.size();
+      ProductCharacteristicConf[] currentValues = new ProductCharacteristicConf[chNumber];
+      boolean includeInResult = true;
+
+      int i = 0;
+      for (ProductCharacteristic prCh : prChs) {
+        OBCriteria<ProductCharacteristicConf> prChConfCrit = OBDal.getInstance().createCriteria(
+            ProductCharacteristicConf.class);
+        prChConfCrit.add(Restrictions.eq(
+            ProductCharacteristicConf.PROPERTY_CHARACTERISTICOFPRODUCT, prCh));
+        prChConfCrit.add(Restrictions.eq(ProductCharacteristicConf.PROPERTY_ACTIVE, true));
+        List<ProductCharacteristicConf> prChConfs = prChConfCrit.list();
+        long valuesCount = prChConfs.size();
+
+        boolean useCode = true;
+        int maxLength = 0;
+        for (ProductCharacteristicConf prChConf : prChConfs) {
+          if (StringUtils.isBlank(prChConf.getCode())) {
+            useCode = false;
+            break;
+          }
+          if (prChConf.getCode().length() > maxLength) {
+            maxLength = prChConf.getCode().length();
+          }
+        }
+
+        variantNumber = variantNumber * valuesCount;
+        if (useCode) {
+          totalMaxLength += maxLength;
+        }
+        List<CharacteristicValue> filteredValues = selectedChValues.get(prCh.getCharacteristic()
+            .getId());
+        ProductCharacteristicAux prChAux = new ProductCharacteristicAux(useCode, prChConfs,
+            filteredValues);
+        currentValues[i] = prChAux.getNextValue();
+        if (filteredValues != null) {
+          includeInResult = includeInResult
+              && filteredValues.contains(currentValues[i].getCharacteristicValue());
+        }
+
+        prChUseCode.put(prCh, prChAux);
+        i++;
+      }
+      totalMaxLength += Long.toString(variantNumber).length();
+      boolean useCodes = totalMaxLength <= searchKeyLength;
+
+      boolean hasNext = true;
+      int productNo = 0;
+      do {
+        // reset boolean value.
+        includeInResult = true;
+        // Create variant product
+        Map<String, Object> variantMap = new HashMap<String, Object>();
+        variantMap.put("Client", product.getClient());
+        variantMap.put("Organization", product.getOrganization());
+        variantMap.put("Active", "Y");
+        variantMap.put("creationDate", new Date());
+        variantMap.put("createdBy", OBContext.getOBContext().getUser());
+        variantMap.put("updated", new Date());
+        variantMap.put("updatedBy", OBContext.getOBContext().getUser());
+        variantMap.put("name", product.getName());
+        variantMap.put("variantCreated", false);
+        variantMap.put("obSelected", false);
+
+        String searchKey = product.getSearchKey();
+        for (i = 0; i < chNumber; i++) {
+          ProductCharacteristicConf prChConf = currentValues[i];
+          ProductCharacteristicAux prChConfAux = prChUseCode.get(prChs.get(i));
+          List<CharacteristicValue> filteredValues = prChConfAux.getFilteredValues();
+          if (filteredValues != null) {
+            includeInResult = includeInResult
+                && filteredValues.contains(currentValues[i].getCharacteristicValue());
+          }
+
+          if (useCodes && prChConfAux.isUseCode()) {
+            searchKey += prChConf.getCode();
+          }
+        }
+        for (int j = 0; j < (Long.toString(variantNumber).length() - Integer.toString(productNo)
+            .length()); j++) {
+          searchKey += "0";
+        }
+        searchKey += productNo;
+        variantMap.put("searchKey", searchKey);
+
+        StringBuffer where = new StringBuffer();
+        where.append(" as p ");
+        where.append(" where p." + Product.PROPERTY_GENERICPRODUCT + " = :product");
+
+        String strChDesc = "";
+        String strKeyId = "";
+        JSONArray valuesArray = new JSONArray();
+        for (i = 0; i < chNumber; i++) {
+          ProductCharacteristicConf prChConf = currentValues[i];
+          Characteristic characteristic = prChConf.getCharacteristicOfProduct().getCharacteristic();
+          where.append(buildExistsClause(characteristic.getId(), prChConf.getCharacteristicValue()
+              .getId()));
+          if (StringUtils.isNotBlank(strChDesc)) {
+            strChDesc += ", ";
+          }
+          strChDesc += characteristic.getName() + ":";
+          strChDesc += " " + prChConf.getCharacteristicValue().getName();
+          strKeyId += prChConf.getCharacteristicValue().getId();
+          JSONObject value = new JSONObject();
+          value.put("characteristic", characteristic.getId());
+          value.put("characteristicValue", prChConf.getCharacteristicValue().getId());
+          value.put("characteristicConf", prChConf.getId());
+          valuesArray.put(value);
+        }
+        variantMap.put("characteristicArray", valuesArray);
+        variantMap.put("characteristicDescription", strChDesc);
+        variantMap.put("id", strKeyId);
+
+        OBQuery<Product> variantQry = OBDal.getInstance().createQuery(Product.class,
+            where.toString());
+        variantQry.setNamedParameter("product", product);
+        Product existingProduct = variantQry.uniqueResult();
+        if (existingProduct != null) {
+          variantMap.put("name", existingProduct.getName());
+          variantMap.put("searchKey", existingProduct.getSearchKey());
+          variantMap.put("variantCreated", true);
+          variantMap.put("variantId", existingProduct.getId());
+          variantMap.put("id", existingProduct.getId());
+        }
+        if (StringUtils.isNotEmpty(searchKeyFilter)) {
+          includeInResult = includeInResult
+              && StringUtils.contains((String) variantMap.get("searchKey"), searchKeyFilter);
+        }
+        if (StringUtils.isNotEmpty(nameFilter)) {
+          includeInResult = includeInResult
+              && StringUtils.contains((String) variantMap.get("name"), nameFilter);
+        }
+        if (variantCreated != null) {
+          includeInResult = includeInResult && variantCreated == (existingProduct != null);
+        }
+        if (!selectedIds.isEmpty()) {
+          includeInResult = includeInResult || selectedIds.contains(variantMap.get("id"));
+        }
+
+        if (includeInResult) {
+          result.add(variantMap);
+        }
+
+        for (i = 0; i < chNumber; i++) {
+          ProductCharacteristicAux prChConfAux = prChUseCode.get(prChs.get(i));
+          List<CharacteristicValue> filteredValues = prChConfAux.getFilteredValues();
+          currentValues[i] = prChConfAux.getNextValue();
+          if (!prChConfAux.isIteratorReset()) {
+            break;
+          } else if (i + 1 == chNumber) {
+            hasNext = false;
+          }
+        }
+        productNo++;
+      } while (hasNext);
+    } catch (JSONException e) {
+      // Do nothing
+    } finally {
+      OBContext.restorePreviousMode();
+    }
+    return result;
+  }
+
+  private void readCriteria(Map<String, String> parameters) throws JSONException {
+    JSONArray criteriaArray = (JSONArray) JsonUtils.buildCriteria(parameters).get("criteria");
+    selectedIds = new ArrayList<String>();
+    selectedChValues = new HashMap<String, List<CharacteristicValue>>();
+    nameFilter = null;
+    searchKeyFilter = null;
+    variantCreated = null;
+
+    for (int i = 0; i < criteriaArray.length(); i++) {
+      JSONObject criteria = criteriaArray.getJSONObject(i);
+      // Basic advanced criteria handling
+      if (criteria.has("_constructor")
+          && "AdvancedCriteria".equals(criteria.getString("_constructor"))
+          && criteria.has("criteria")) {
+        JSONArray innerCriteriaArray = new JSONArray(criteria.getString("criteria"));
+        criteria = innerCriteriaArray.getJSONObject(0);
+      }
+      String fieldName = criteria.getString("fieldName");
+      // String operatorName = criteria.getString("operator");
+      String value = criteria.getString("value");
+      if (fieldName.equals("name")) {
+        nameFilter = value;
+      } else if (fieldName.equals("searchKey")) {
+        searchKeyFilter = value;
+      } else if (fieldName.equals("id")) {
+        selectedIds.add(value);
+      } else if (fieldName.equals("variantCreated")) {
+        variantCreated = criteria.getBoolean("value");
+      } else if (fieldName.equals("characteristicDescription")) {
+        JSONArray values = new JSONArray(value);
+        // All values belong to the same characteristicId, get the first one.
+        String strCharacteristicId = null;
+        List<CharacteristicValue> chValueIds = new ArrayList<CharacteristicValue>();
+        for (int j = 0; j < values.length(); j++) {
+          CharacteristicValue chValue = OBDal.getInstance().get(CharacteristicValue.class,
+              values.getString(j));
+          chValueIds.add(chValue);
+          if (strCharacteristicId == null) {
+            strCharacteristicId = (String) DalUtil.getId(chValue.getCharacteristic());
+          }
+        }
+        selectedChValues.put(strCharacteristicId, chValueIds);
+      }
+
+    }
+  }
+
+  private String buildExistsClause(String strChId, String strChValueId) {
+    StringBuffer clause = new StringBuffer();
+    clause.append(" and exists (select 1 from " + ProductCharacteristicValue.ENTITY_NAME
+        + " as pcv");
+    clause.append("    where pcv." + ProductCharacteristicValue.PROPERTY_PRODUCT + " = p");
+    clause.append("      and pcv." + ProductCharacteristicValue.PROPERTY_CHARACTERISTIC + ".id = '"
+        + strChId + "'");
+    clause.append("      and pcv." + ProductCharacteristicValue.PROPERTY_CHARACTERISTICVALUE
+        + ".id = '" + strChValueId + "'");
+    clause.append("     )");
+    return clause.toString();
+  }
+
+  private static int getSearchKeyColumnLength() {
+    final Entity prodEntity = ModelProvider.getInstance().getEntity(Product.ENTITY_NAME);
+
+    final Property searchKeyProperty = prodEntity.getProperty(Product.PROPERTY_SEARCHKEY);
+    return searchKeyProperty.getFieldLength();
+  }
+
+  private class ProductCharacteristicAux {
+    private boolean useCode;
+    private boolean isIteratorReset;
+    private List<ProductCharacteristicConf> values;
+    private List<CharacteristicValue> filteredValues;
+    private Iterator<ProductCharacteristicConf> iterator;
+
+    ProductCharacteristicAux(boolean _useCode, List<ProductCharacteristicConf> _values,
+        List<CharacteristicValue> _filteredValues) {
+      useCode = _useCode;
+      values = _values;
+      filteredValues = _filteredValues;
+    }
+
+    public boolean isUseCode() {
+      return useCode;
+    }
+
+    public boolean isIteratorReset() {
+      return isIteratorReset;
+    }
+
+    public List<CharacteristicValue> getFilteredValues() {
+      return filteredValues;
+    }
+
+    public ProductCharacteristicConf getNextValue() {
+      ProductCharacteristicConf prChConf;
+      if (iterator == null || !iterator.hasNext()) {
+        iterator = values.iterator();
+        isIteratorReset = true;
+      } else {
+        isIteratorReset = false;
+      }
+      prChConf = iterator.next();
+      return prChConf;
+    }
+  }
+
+}
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/src/org/openbravo/materialmgmt/actionhandler/ManageVariants.java	Fri Jun 28 14:58:20 2013 +0200
@@ -0,0 +1,160 @@
+/*
+ *************************************************************************
+ * The contents of this file are subject to the Openbravo  Public  License
+ * Version  1.0  (the  "License"),  being   the  Mozilla   Public  License
+ * Version 1.1  with a permitted attribution clause; you may not  use this
+ * file except in compliance with the License. You  may  obtain  a copy of
+ * the License at http://www.openbravo.com/legal/license.html
+ * Software distributed under the License  is  distributed  on  an "AS IS"
+ * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
+ * License for the specific  language  governing  rights  and  limitations
+ * under the License.
+ * The Original Code is Openbravo ERP.
+ * The Initial Developer of the Original Code is Openbravo SLU
+ * All portions are Copyright (C) 2013 Openbravo SLU
+ * All Rights Reserved.
+ * Contributor(s):  ______________________________________.
+ *************************************************************************
+ */
+package org.openbravo.materialmgmt.actionhandler;
+
+import java.math.BigDecimal;
+import java.util.Collections;
+import java.util.Date;
+import java.util.HashMap;
+import java.util.Map;
+
+import org.codehaus.jettison.json.JSONArray;
+import org.codehaus.jettison.json.JSONException;
+import org.codehaus.jettison.json.JSONObject;
+import org.openbravo.base.exception.OBException;
+import org.openbravo.base.provider.OBProvider;
+import org.openbravo.client.application.process.BaseProcessActionHandler;
+import org.openbravo.dal.core.DalUtil;
+import org.openbravo.dal.core.OBContext;
+import org.openbravo.dal.service.OBDal;
+import org.openbravo.erpCommon.utility.OBMessageUtils;
+import org.openbravo.financial.FinancialUtils;
+import org.openbravo.materialmgmt.VariantChDescUpdateProcess;
+import org.openbravo.model.common.plm.Characteristic;
+import org.openbravo.model.common.plm.CharacteristicValue;
+import org.openbravo.model.common.plm.Product;
+import org.openbravo.model.common.plm.ProductAccounts;
+import org.openbravo.model.common.plm.ProductCharacteristic;
+import org.openbravo.model.common.plm.ProductCharacteristicConf;
+import org.openbravo.model.common.plm.ProductCharacteristicValue;
+import org.openbravo.model.pricing.pricelist.ProductPrice;
+import org.openbravo.service.db.DbUtility;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+
+public class ManageVariants extends BaseProcessActionHandler {
+  final static Logger log = LoggerFactory.getLogger(ManageVariants.class);
+
+  @Override
+  protected JSONObject doExecute(Map<String, Object> parameters, String content) {
+    JSONObject jsonRequest = null;
+    OBContext.setAdminMode(true);
+    try {
+      jsonRequest = new JSONObject(content);
+      JSONArray selection = jsonRequest.getJSONArray("_selection");
+      String strProductId = jsonRequest.getString("M_Product_ID");
+      final Product generic = OBDal.getInstance().get(Product.class, strProductId);
+      log.debug("{}", jsonRequest);
+
+      for (int i = 0; i < selection.length(); i++) {
+        JSONObject row = selection.getJSONObject(i);
+        boolean isVariantCreated = row.getBoolean("variantCreated");
+        if (!isVariantCreated) {
+          createVariant(row, generic);
+        } else {
+          updateVariant(row);
+        }
+      }
+
+      Map<String, String> map = new HashMap<String, String>();
+      map.put("productNumer", Integer.toString(0));
+
+      String messageText = OBMessageUtils.messageBD("Success");
+      JSONObject msg = new JSONObject();
+      msg.put("severity", "success");
+      msg.put("text", OBMessageUtils.parseTranslation(messageText, map));
+      jsonRequest.put("message", msg);
+
+    } catch (Exception e) {
+      log.error("Error in Manage Variants Action Handler", e);
+
+      try {
+        jsonRequest = new JSONObject();
+        Throwable ex = DbUtility.getUnderlyingSQLException(e);
+        String message = OBMessageUtils.translateError(ex.getMessage()).getMessage();
+        JSONObject errorMessage = new JSONObject();
+        errorMessage.put("severity", "error");
+        errorMessage.put("text", message);
+        jsonRequest.put("message", errorMessage);
+      } catch (Exception e2) {
+        log.error(e.getMessage(), e2);
+        // do nothing, give up
+      }
+    } finally {
+      OBContext.restorePreviousMode();
+    }
+    return jsonRequest;
+  }
+
+  private void createVariant(JSONObject variantProperties, Product generic) throws JSONException {
+    Product variant = (Product) DalUtil.copy(generic);
+
+    variant.setGenericProduct(generic);
+    variant.setProductAccountsList(Collections.<ProductAccounts> emptyList());
+    variant.setGeneric(false);
+    for (ProductCharacteristic prCh : variant.getProductCharacteristicList()) {
+      prCh.setProductCharacteristicConfList(Collections.<ProductCharacteristicConf> emptyList());
+    }
+    variant.setName(variantProperties.getString("name"));
+    variant.setSearchKey(variantProperties.getString("searchKey"));
+
+    JSONArray variantValues = variantProperties.getJSONArray("characteristicArray");
+    OBDal.getInstance().save(variant);
+    OBDal.getInstance().flush();
+    for (int i = 0; i < variantValues.length(); i++) {
+      JSONObject chValue = variantValues.getJSONObject(i);
+      ProductCharacteristicValue newPrChValue = OBProvider.getInstance().get(
+          ProductCharacteristicValue.class);
+      newPrChValue.setCharacteristic((Characteristic) OBDal.getInstance().getProxy(
+          Characteristic.ENTITY_NAME, chValue.getString("characteristic")));
+      newPrChValue.setCharacteristicValue((CharacteristicValue) OBDal.getInstance().getProxy(
+          CharacteristicValue.ENTITY_NAME, chValue.getString("characteristicValue")));
+      newPrChValue.setProduct(variant);
+      OBDal.getInstance().save(newPrChValue);
+      ProductCharacteristicConf prChConf = OBDal.getInstance().get(ProductCharacteristicConf.class,
+          chValue.getString("characteristicConf"));
+      if (prChConf.getCharacteristicOfProduct().isDefinesPrice()
+          && prChConf.getNetUnitPrice() != null) {
+        setPrice(variant, prChConf.getNetUnitPrice());
+      }
+    }
+    OBDal.getInstance().flush();
+    new VariantChDescUpdateProcess().update(variant.getId(), null);
+
+  }
+
+  private void updateVariant(JSONObject variantProperties) throws JSONException {
+    final String strProductId = variantProperties.getString("variantId");
+    Product variant = OBDal.getInstance().get(Product.class, strProductId);
+    variant.setName(variantProperties.getString("name"));
+    variant.setSearchKey(variantProperties.getString("searchKey"));
+    OBDal.getInstance().save(variant);
+  }
+
+  private void setPrice(Product variant, BigDecimal price) {
+    ProductPrice prodPrice = FinancialUtils.getProductPrice(variant, new Date(), true, null, false);
+    if (prodPrice == null) {
+      throw new OBException(OBMessageUtils.parseTranslation("@GenericMustHavePriceDefined@"));
+    }
+    prodPrice.setStandardPrice(price);
+    prodPrice.setListPrice(price);
+    prodPrice.setPriceLimit(price);
+    OBDal.getInstance().save(prodPrice);
+  }
+}