[hqlpickandexecute] Table, Column and Elements of new HQL Pick and Edit table
authorAugusto Mauch <augusto.mauch@openbravo.com>
Mon, 16 Jun 2014 18:16:52 +0200
changeset 25417 05f152469a6a
parent 25416 7e1f11033175
child 25418 8105c32f6e2b
[hqlpickandexecute] Table, Column and Elements of new HQL Pick and Edit table
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_TABLE.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Mon Jun 16 18:11:52 2014 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Mon Jun 16 18:16:52 2014 +0200
@@ -220197,6 +220197,41 @@
 <!--01C6B5A480064C9B942DE57153E85848-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--01C6B5A480064C9B942DE57153E85848--></AD_COLUMN>
 
+<!--01E433B16791423ABFA9200CD75AD443--><AD_COLUMN>
+<!--01E433B16791423ABFA9200CD75AD443-->  <AD_COLUMN_ID><![CDATA[01E433B16791423ABFA9200CD75AD443]]></AD_COLUMN_ID>
+<!--01E433B16791423ABFA9200CD75AD443-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--01E433B16791423ABFA9200CD75AD443-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--01E433B16791423ABFA9200CD75AD443-->  <NAME><![CDATA[movementDate]]></NAME>
+<!--01E433B16791423ABFA9200CD75AD443-->  <DESCRIPTION><![CDATA[The date that a certain item is moved from one location to another.]]></DESCRIPTION>
+<!--01E433B16791423ABFA9200CD75AD443-->  <HELP><![CDATA[The Movement Date indicates the date that a product moved in or out of inventory.  This is the result of a shipment, receipt or inventory movement.]]></HELP>
+<!--01E433B16791423ABFA9200CD75AD443-->  <COLUMNNAME><![CDATA[movementDate]]></COLUMNNAME>
+<!--01E433B16791423ABFA9200CD75AD443-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--01E433B16791423ABFA9200CD75AD443-->  <AD_REFERENCE_ID><![CDATA[15]]></AD_REFERENCE_ID>
+<!--01E433B16791423ABFA9200CD75AD443-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--01E433B16791423ABFA9200CD75AD443-->  <SEQNO><![CDATA[100]]></SEQNO>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--01E433B16791423ABFA9200CD75AD443-->  <AD_ELEMENT_ID><![CDATA[1037]]></AD_ELEMENT_ID>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--01E433B16791423ABFA9200CD75AD443-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--01E433B16791423ABFA9200CD75AD443-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--01E433B16791423ABFA9200CD75AD443-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--01E433B16791423ABFA9200CD75AD443-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--01E433B16791423ABFA9200CD75AD443-->  <ENTITY_ALIAS><![CDATA[iol.shipmentReceipt.movementDate]]></ENTITY_ALIAS>
+<!--01E433B16791423ABFA9200CD75AD443--></AD_COLUMN>
+
 <!--021B9228AB1B4CDA94CE16426C2ED10B--><AD_COLUMN>
 <!--021B9228AB1B4CDA94CE16426C2ED10B-->  <AD_COLUMN_ID><![CDATA[021B9228AB1B4CDA94CE16426C2ED10B]]></AD_COLUMN_ID>
 <!--021B9228AB1B4CDA94CE16426C2ED10B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -221734,6 +221769,39 @@
 <!--082F9742ADAF4BEF83228C4EAE5D4A8B-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--082F9742ADAF4BEF83228C4EAE5D4A8B--></AD_COLUMN>
 
+<!--0864C7053E98461B92E8832E90BBCC59--><AD_COLUMN>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <AD_COLUMN_ID><![CDATA[0864C7053E98461B92E8832E90BBCC59]]></AD_COLUMN_ID>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <NAME><![CDATA[shipmentNumber]]></NAME>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <COLUMNNAME><![CDATA[shipmentNumber]]></COLUMNNAME>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <FIELDLENGTH><![CDATA[30]]></FIELDLENGTH>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <SEQNO><![CDATA[90]]></SEQNO>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <AD_ELEMENT_ID><![CDATA[B04AF439C0EDCC90E040007F010032CD]]></AD_ELEMENT_ID>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--0864C7053E98461B92E8832E90BBCC59-->  <ENTITY_ALIAS><![CDATA[iol.shipmentReceipt.documentNo]]></ENTITY_ALIAS>
+<!--0864C7053E98461B92E8832E90BBCC59--></AD_COLUMN>
+
 <!--088302F39B3A4605B47AD2E15B5276AD--><AD_COLUMN>
 <!--088302F39B3A4605B47AD2E15B5276AD-->  <AD_COLUMN_ID><![CDATA[088302F39B3A4605B47AD2E15B5276AD]]></AD_COLUMN_ID>
 <!--088302F39B3A4605B47AD2E15B5276AD-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -225396,6 +225464,42 @@
 <!--1B5BAA2A8E6C49D9859945239CB55414-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--1B5BAA2A8E6C49D9859945239CB55414--></AD_COLUMN>
 
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5--><AD_COLUMN>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <AD_COLUMN_ID><![CDATA[1B90F5725A304AB59ACF9A9E5F2BAEC5]]></AD_COLUMN_ID>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <NAME><![CDATA[tax]]></NAME>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <DESCRIPTION><![CDATA[The percentage of money requested by the government for this specified product or transaction.]]></DESCRIPTION>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <HELP><![CDATA[The Tax indicates the type of tax for this document line.]]></HELP>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <COLUMNNAME><![CDATA[tax]]></COLUMNNAME>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <AD_REFERENCE_VALUE_ID><![CDATA[F3455CBD6B69470396BE1FF35EC8CEDA]]></AD_REFERENCE_VALUE_ID>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <SEQNO><![CDATA[150]]></SEQNO>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <AD_ELEMENT_ID><![CDATA[213]]></AD_ELEMENT_ID>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5-->  <ENTITY_ALIAS><![CDATA[taxSubQuery]]></ENTITY_ALIAS>
+<!--1B90F5725A304AB59ACF9A9E5F2BAEC5--></AD_COLUMN>
+
 <!--1BD54BBB36824703BB681F8A88377D62--><AD_COLUMN>
 <!--1BD54BBB36824703BB681F8A88377D62-->  <AD_COLUMN_ID><![CDATA[1BD54BBB36824703BB681F8A88377D62]]></AD_COLUMN_ID>
 <!--1BD54BBB36824703BB681F8A88377D62-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -231332,6 +231436,42 @@
 <!--367DCAA9CF4442ADB9A76F6539102217-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--367DCAA9CF4442ADB9A76F6539102217--></AD_COLUMN>
 
+<!--36C33001498E49E7BD2514DCD468B983--><AD_COLUMN>
+<!--36C33001498E49E7BD2514DCD468B983-->  <AD_COLUMN_ID><![CDATA[36C33001498E49E7BD2514DCD468B983]]></AD_COLUMN_ID>
+<!--36C33001498E49E7BD2514DCD468B983-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--36C33001498E49E7BD2514DCD468B983-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--36C33001498E49E7BD2514DCD468B983-->  <NAME><![CDATA[organization]]></NAME>
+<!--36C33001498E49E7BD2514DCD468B983-->  <DESCRIPTION><![CDATA[Organizational entity within client]]></DESCRIPTION>
+<!--36C33001498E49E7BD2514DCD468B983-->  <HELP><![CDATA[An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.]]></HELP>
+<!--36C33001498E49E7BD2514DCD468B983-->  <COLUMNNAME><![CDATA[organization]]></COLUMNNAME>
+<!--36C33001498E49E7BD2514DCD468B983-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--36C33001498E49E7BD2514DCD468B983-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--36C33001498E49E7BD2514DCD468B983-->  <AD_REFERENCE_VALUE_ID><![CDATA[276]]></AD_REFERENCE_VALUE_ID>
+<!--36C33001498E49E7BD2514DCD468B983-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--36C33001498E49E7BD2514DCD468B983-->  <SEQNO><![CDATA[10]]></SEQNO>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--36C33001498E49E7BD2514DCD468B983-->  <AD_ELEMENT_ID><![CDATA[113]]></AD_ELEMENT_ID>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--36C33001498E49E7BD2514DCD468B983-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--36C33001498E49E7BD2514DCD468B983-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--36C33001498E49E7BD2514DCD468B983-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--36C33001498E49E7BD2514DCD468B983-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--36C33001498E49E7BD2514DCD468B983-->  <ENTITY_ALIAS><![CDATA[iol.organization]]></ENTITY_ALIAS>
+<!--36C33001498E49E7BD2514DCD468B983--></AD_COLUMN>
+
 <!--36C6498DB6D14DF78BD812D0FE70FC06--><AD_COLUMN>
 <!--36C6498DB6D14DF78BD812D0FE70FC06-->  <AD_COLUMN_ID><![CDATA[36C6498DB6D14DF78BD812D0FE70FC06]]></AD_COLUMN_ID>
 <!--36C6498DB6D14DF78BD812D0FE70FC06-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -232175,6 +232315,40 @@
 <!--3A4BE2C55D4A4A65BAB8CF04D37906C0-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--3A4BE2C55D4A4A65BAB8CF04D37906C0--></AD_COLUMN>
 
+<!--3A6348556B5E493D9BA1CE253A22CBBE--><AD_COLUMN>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <AD_COLUMN_ID><![CDATA[3A6348556B5E493D9BA1CE253A22CBBE]]></AD_COLUMN_ID>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <NAME><![CDATA[attributeSetValue]]></NAME>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <DESCRIPTION><![CDATA[An attribute associated with a product as part of an attribute set.]]></DESCRIPTION>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <HELP><![CDATA[The values of the actual Product Attributes]]></HELP>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <COLUMNNAME><![CDATA[attributeSetValue]]></COLUMNNAME>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <AD_REFERENCE_ID><![CDATA[35]]></AD_REFERENCE_ID>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <FIELDLENGTH><![CDATA[0]]></FIELDLENGTH>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <SEQNO><![CDATA[160]]></SEQNO>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <AD_ELEMENT_ID><![CDATA[2019]]></AD_ELEMENT_ID>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--3A6348556B5E493D9BA1CE253A22CBBE-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--3A6348556B5E493D9BA1CE253A22CBBE--></AD_COLUMN>
+
 <!--3AB58429C705473E879CAC0214062614--><AD_COLUMN>
 <!--3AB58429C705473E879CAC0214062614-->  <AD_COLUMN_ID><![CDATA[3AB58429C705473E879CAC0214062614]]></AD_COLUMN_ID>
 <!--3AB58429C705473E879CAC0214062614-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -236717,6 +236891,41 @@
 <!--5083D0CC53914FCFAAE3489FFB0D0CE6-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--5083D0CC53914FCFAAE3489FFB0D0CE6--></AD_COLUMN>
 
+<!--50A78605F0DE48828AE33CF323581E69--><AD_COLUMN>
+<!--50A78605F0DE48828AE33CF323581E69-->  <AD_COLUMN_ID><![CDATA[50A78605F0DE48828AE33CF323581E69]]></AD_COLUMN_ID>
+<!--50A78605F0DE48828AE33CF323581E69-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--50A78605F0DE48828AE33CF323581E69-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--50A78605F0DE48828AE33CF323581E69-->  <NAME><![CDATA[returned]]></NAME>
+<!--50A78605F0DE48828AE33CF323581E69-->  <DESCRIPTION><![CDATA[Returned]]></DESCRIPTION>
+<!--50A78605F0DE48828AE33CF323581E69-->  <HELP><![CDATA[If it is checked means that the debt/payment has been returned by the bank.]]></HELP>
+<!--50A78605F0DE48828AE33CF323581E69-->  <COLUMNNAME><![CDATA[returned]]></COLUMNNAME>
+<!--50A78605F0DE48828AE33CF323581E69-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--50A78605F0DE48828AE33CF323581E69-->  <AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID>
+<!--50A78605F0DE48828AE33CF323581E69-->  <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--50A78605F0DE48828AE33CF323581E69-->  <SEQNO><![CDATA[130]]></SEQNO>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--50A78605F0DE48828AE33CF323581E69-->  <AD_ELEMENT_ID><![CDATA[800653]]></AD_ELEMENT_ID>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--50A78605F0DE48828AE33CF323581E69-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--50A78605F0DE48828AE33CF323581E69-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--50A78605F0DE48828AE33CF323581E69-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--50A78605F0DE48828AE33CF323581E69-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--50A78605F0DE48828AE33CF323581E69-->  <ENTITY_ALIAS><![CDATA[@returnedLeftClause@]]></ENTITY_ALIAS>
+<!--50A78605F0DE48828AE33CF323581E69--></AD_COLUMN>
+
 <!--50C572BF5B0E46319FC8F32201A8408E--><AD_COLUMN>
 <!--50C572BF5B0E46319FC8F32201A8408E-->  <AD_COLUMN_ID><![CDATA[50C572BF5B0E46319FC8F32201A8408E]]></AD_COLUMN_ID>
 <!--50C572BF5B0E46319FC8F32201A8408E-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -255915,6 +256124,41 @@
 <!--655A8AF2FF4741D6B2C64979D759D58B-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--655A8AF2FF4741D6B2C64979D759D58B--></AD_COLUMN>
 
+<!--65850592B04C49E79DC6090F14820571--><AD_COLUMN>
+<!--65850592B04C49E79DC6090F14820571-->  <AD_COLUMN_ID><![CDATA[65850592B04C49E79DC6090F14820571]]></AD_COLUMN_ID>
+<!--65850592B04C49E79DC6090F14820571-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--65850592B04C49E79DC6090F14820571-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--65850592B04C49E79DC6090F14820571-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--65850592B04C49E79DC6090F14820571-->  <NAME><![CDATA[salesOrderLine]]></NAME>
+<!--65850592B04C49E79DC6090F14820571-->  <DESCRIPTION><![CDATA[A unique and often automatically generated identifier for a sales order line.]]></DESCRIPTION>
+<!--65850592B04C49E79DC6090F14820571-->  <HELP><![CDATA[A unique identifier and a reference to a sales order line (product).]]></HELP>
+<!--65850592B04C49E79DC6090F14820571-->  <COLUMNNAME><![CDATA[salesOrderLine]]></COLUMNNAME>
+<!--65850592B04C49E79DC6090F14820571-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--65850592B04C49E79DC6090F14820571-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--65850592B04C49E79DC6090F14820571-->  <AD_REFERENCE_VALUE_ID><![CDATA[271]]></AD_REFERENCE_VALUE_ID>
+<!--65850592B04C49E79DC6090F14820571-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--65850592B04C49E79DC6090F14820571-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--65850592B04C49E79DC6090F14820571-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--65850592B04C49E79DC6090F14820571-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--65850592B04C49E79DC6090F14820571-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--65850592B04C49E79DC6090F14820571-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--65850592B04C49E79DC6090F14820571-->  <SEQNO><![CDATA[190]]></SEQNO>
+<!--65850592B04C49E79DC6090F14820571-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--65850592B04C49E79DC6090F14820571-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--65850592B04C49E79DC6090F14820571-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--65850592B04C49E79DC6090F14820571-->  <AD_ELEMENT_ID><![CDATA[561]]></AD_ELEMENT_ID>
+<!--65850592B04C49E79DC6090F14820571-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--65850592B04C49E79DC6090F14820571-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--65850592B04C49E79DC6090F14820571-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--65850592B04C49E79DC6090F14820571-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--65850592B04C49E79DC6090F14820571-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--65850592B04C49E79DC6090F14820571-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--65850592B04C49E79DC6090F14820571-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--65850592B04C49E79DC6090F14820571-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--65850592B04C49E79DC6090F14820571-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--65850592B04C49E79DC6090F14820571-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--65850592B04C49E79DC6090F14820571--></AD_COLUMN>
+
 <!--65C07FA2FFF74395A6F704ECFA550DC0--><AD_COLUMN>
 <!--65C07FA2FFF74395A6F704ECFA550DC0-->  <AD_COLUMN_ID><![CDATA[65C07FA2FFF74395A6F704ECFA550DC0]]></AD_COLUMN_ID>
 <!--65C07FA2FFF74395A6F704ECFA550DC0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -259042,6 +259286,41 @@
 <!--6A98306476CA430B985CE6360354E2CF-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--6A98306476CA430B985CE6360354E2CF--></AD_COLUMN>
 
+<!--6AA16843B90C4926A6FDD836A0D55DBC--><AD_COLUMN>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <AD_COLUMN_ID><![CDATA[6AA16843B90C4926A6FDD836A0D55DBC]]></AD_COLUMN_ID>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <NAME><![CDATA[unitPrice]]></NAME>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <DESCRIPTION><![CDATA[The price that will be paid for a specified item.]]></DESCRIPTION>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <HELP><![CDATA[The actual price indicates the price for a product in source currency.]]></HELP>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <COLUMNNAME><![CDATA[unitPrice]]></COLUMNNAME>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <AD_REFERENCE_ID><![CDATA[800008]]></AD_REFERENCE_ID>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <SEQNO><![CDATA[170]]></SEQNO>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <AD_ELEMENT_ID><![CDATA[9F815073C39E4506A1C74BB3667C6B57]]></AD_ELEMENT_ID>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--6AA16843B90C4926A6FDD836A0D55DBC-->  <ENTITY_ALIAS><![CDATA[@unitPriceLeftClause@]]></ENTITY_ALIAS>
+<!--6AA16843B90C4926A6FDD836A0D55DBC--></AD_COLUMN>
+
 <!--6ABF02FADF634959E040007F010125A8--><AD_COLUMN>
 <!--6ABF02FADF634959E040007F010125A8-->  <AD_COLUMN_ID><![CDATA[6ABF02FADF634959E040007F010125A8]]></AD_COLUMN_ID>
 <!--6ABF02FADF634959E040007F010125A8-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -268372,6 +268651,40 @@
 <!--7A708B0E81814B6D918B59FDADD5B2EC-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--7A708B0E81814B6D918B59FDADD5B2EC--></AD_COLUMN>
 
+<!--7A8B53D5518B4E0882F86631A8B67A62--><AD_COLUMN>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <AD_COLUMN_ID><![CDATA[7A8B53D5518B4E0882F86631A8B67A62]]></AD_COLUMN_ID>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <NAME><![CDATA[returnReason]]></NAME>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <COLUMNNAME><![CDATA[returnReason]]></COLUMNNAME>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <AD_REFERENCE_VALUE_ID><![CDATA[0230ECA4E893450C87913E8A6031BE54]]></AD_REFERENCE_VALUE_ID>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <SEQNO><![CDATA[140]]></SEQNO>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <AD_ELEMENT_ID><![CDATA[44CBD6E9427241D1B8052EC48012FC6C]]></AD_ELEMENT_ID>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--7A8B53D5518B4E0882F86631A8B67A62-->  <ENTITY_ALIAS><![CDATA[@returnReasonLeftClause@]]></ENTITY_ALIAS>
+<!--7A8B53D5518B4E0882F86631A8B67A62--></AD_COLUMN>
+
 <!--7AD1D1A49C5D11DD9476001B388C05F0--><AD_COLUMN>
 <!--7AD1D1A49C5D11DD9476001B388C05F0-->  <AD_COLUMN_ID><![CDATA[7AD1D1A49C5D11DD9476001B388C05F0]]></AD_COLUMN_ID>
 <!--7AD1D1A49C5D11DD9476001B388C05F0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -281292,6 +281605,40 @@
 <!--868ED7F486244CBBA580FD4536E740D1-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--868ED7F486244CBBA580FD4536E740D1--></AD_COLUMN>
 
+<!--86A49F4CBE2C42B7A1508536F031D2D5--><AD_COLUMN>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <AD_COLUMN_ID><![CDATA[86A49F4CBE2C42B7A1508536F031D2D5]]></AD_COLUMN_ID>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <NAME><![CDATA[returnQtyOtherRM]]></NAME>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <HELP><![CDATA[Returned Quantity in other Return Material Orders]]></HELP>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <COLUMNNAME><![CDATA[returnQtyOtherRM]]></COLUMNNAME>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <SEQNO><![CDATA[110]]></SEQNO>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <AD_ELEMENT_ID><![CDATA[B241E19041029C74E040007F01005C18]]></AD_ELEMENT_ID>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--86A49F4CBE2C42B7A1508536F031D2D5-->  <ENTITY_ALIAS><![CDATA[@returnedOthersLeftClause@]]></ENTITY_ALIAS>
+<!--86A49F4CBE2C42B7A1508536F031D2D5--></AD_COLUMN>
+
 <!--86DF0DF2E002BFFEE040007F010175A6--><AD_COLUMN>
 <!--86DF0DF2E002BFFEE040007F010175A6-->  <AD_COLUMN_ID><![CDATA[86DF0DF2E002BFFEE040007F010175A6]]></AD_COLUMN_ID>
 <!--86DF0DF2E002BFFEE040007F010175A6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -288973,6 +289320,40 @@
 <!--919249865C132A93E040007F01004B67-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--919249865C132A93E040007F01004B67--></AD_COLUMN>
 
+<!--91A58CF045A8429881ECFFB7CE2FF099--><AD_COLUMN>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <AD_COLUMN_ID><![CDATA[91A58CF045A8429881ECFFB7CE2FF099]]></AD_COLUMN_ID>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <NAME><![CDATA[orderNo]]></NAME>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <DESCRIPTION><![CDATA[Order Number]]></DESCRIPTION>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <COLUMNNAME><![CDATA[orderNo]]></COLUMNNAME>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <AD_REFERENCE_ID><![CDATA[10]]></AD_REFERENCE_ID>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <FIELDLENGTH><![CDATA[30]]></FIELDLENGTH>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <SEQNO><![CDATA[180]]></SEQNO>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <AD_ELEMENT_ID><![CDATA[7FF22347490C844FE040007F01003861]]></AD_ELEMENT_ID>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--91A58CF045A8429881ECFFB7CE2FF099-->  <ENTITY_ALIAS><![CDATA[@orderNoLeftClause@]]></ENTITY_ALIAS>
+<!--91A58CF045A8429881ECFFB7CE2FF099--></AD_COLUMN>
+
 <!--91C0717136BB400AAA09F8ECE76409BF--><AD_COLUMN>
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <AD_COLUMN_ID><![CDATA[91C0717136BB400AAA09F8ECE76409BF]]></AD_COLUMN_ID>
 <!--91C0717136BB400AAA09F8ECE76409BF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -292323,6 +292704,41 @@
 <!--9AFE960A44A147ECAADB875D96399AA2-->  <SQLLOGIC><![CDATA[(select C_GETINVOICESTATUSFROMSHIPMENT(m_inout_id) from dual)]]></SQLLOGIC>
 <!--9AFE960A44A147ECAADB875D96399AA2--></AD_COLUMN>
 
+<!--9B55D1FE53254F48BB71C80B04E4C785--><AD_COLUMN>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <AD_COLUMN_ID><![CDATA[9B55D1FE53254F48BB71C80B04E4C785]]></AD_COLUMN_ID>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <NAME><![CDATA[movementQuantity]]></NAME>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <DESCRIPTION><![CDATA[The number of items being moved from one location to another.]]></DESCRIPTION>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <HELP><![CDATA[The Movement Quantity indicates the quantity of a product that has been moved.]]></HELP>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <COLUMNNAME><![CDATA[movementQuantity]]></COLUMNNAME>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <FIELDLENGTH><![CDATA[12]]></FIELDLENGTH>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <SEQNO><![CDATA[70]]></SEQNO>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <AD_ELEMENT_ID><![CDATA[1038]]></AD_ELEMENT_ID>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--9B55D1FE53254F48BB71C80B04E4C785-->  <ENTITY_ALIAS><![CDATA[iol.movementQuantity]]></ENTITY_ALIAS>
+<!--9B55D1FE53254F48BB71C80B04E4C785--></AD_COLUMN>
+
 <!--9BAEEE4845E238D8E040007F01002420--><AD_COLUMN>
 <!--9BAEEE4845E238D8E040007F01002420-->  <AD_COLUMN_ID><![CDATA[9BAEEE4845E238D8E040007F01002420]]></AD_COLUMN_ID>
 <!--9BAEEE4845E238D8E040007F01002420-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -305401,6 +305817,39 @@
 <!--BA4CE0755A044CF9A0651F4CD3814ACC-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--BA4CE0755A044CF9A0651F4CD3814ACC--></AD_COLUMN>
 
+<!--BA88F4C071A14224A28F7A3354DBD6D0--><AD_COLUMN>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <AD_COLUMN_ID><![CDATA[BA88F4C071A14224A28F7A3354DBD6D0]]></AD_COLUMN_ID>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <NAME><![CDATA[id]]></NAME>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <COLUMNNAME><![CDATA[id]]></COLUMNNAME>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <AD_REFERENCE_ID><![CDATA[13]]></AD_REFERENCE_ID>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISKEY><![CDATA[Y]]></ISKEY>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <SEQNO><![CDATA[20]]></SEQNO>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <AD_ELEMENT_ID><![CDATA[C581AB086E0141EEAA2EEAA8605BD8F0]]></AD_ELEMENT_ID>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--BA88F4C071A14224A28F7A3354DBD6D0-->  <ENTITY_ALIAS><![CDATA[iol.id]]></ENTITY_ALIAS>
+<!--BA88F4C071A14224A28F7A3354DBD6D0--></AD_COLUMN>
+
 <!--BA915B3017874242B4782DB58F280D5F--><AD_COLUMN>
 <!--BA915B3017874242B4782DB58F280D5F-->  <AD_COLUMN_ID><![CDATA[BA915B3017874242B4782DB58F280D5F]]></AD_COLUMN_ID>
 <!--BA915B3017874242B4782DB58F280D5F-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -306735,6 +307184,42 @@
 <!--BB367F44E4854CBDAAB25CC57E82B464-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--BB367F44E4854CBDAAB25CC57E82B464--></AD_COLUMN>
 
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0--><AD_COLUMN>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <AD_COLUMN_ID><![CDATA[BB3C1D2CBB32495DA7EAE8BBC44864A0]]></AD_COLUMN_ID>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <NAME><![CDATA[product]]></NAME>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <DESCRIPTION><![CDATA[An item produced by a process.]]></DESCRIPTION>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <HELP><![CDATA[Identifies an item which is either purchased or sold in this organization.]]></HELP>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <COLUMNNAME><![CDATA[product]]></COLUMNNAME>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <AD_REFERENCE_VALUE_ID><![CDATA[1F603F334B704F53928B8DB908611657]]></AD_REFERENCE_VALUE_ID>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <SEQNO><![CDATA[40]]></SEQNO>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <AD_ELEMENT_ID><![CDATA[454]]></AD_ELEMENT_ID>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0-->  <ENTITY_ALIAS><![CDATA[iol.product]]></ENTITY_ALIAS>
+<!--BB3C1D2CBB32495DA7EAE8BBC44864A0--></AD_COLUMN>
+
 <!--BB403BFE8561486BB3B12F188C8256CE--><AD_COLUMN>
 <!--BB403BFE8561486BB3B12F188C8256CE-->  <AD_COLUMN_ID><![CDATA[BB403BFE8561486BB3B12F188C8256CE]]></AD_COLUMN_ID>
 <!--BB403BFE8561486BB3B12F188C8256CE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -309419,6 +309904,40 @@
 <!--C66674DA045E47D1A50B3C5805326AB9-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--C66674DA045E47D1A50B3C5805326AB9--></AD_COLUMN>
 
+<!--C66B2DE7A2D747169D9DFA9332FF98CF--><AD_COLUMN>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <AD_COLUMN_ID><![CDATA[C66B2DE7A2D747169D9DFA9332FF98CF]]></AD_COLUMN_ID>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <NAME><![CDATA[RM_Pickfromreceipthql]]></NAME>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <COLUMNNAME><![CDATA[RM_Pickfromreceipthql]]></COLUMNNAME>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <AD_TABLE_ID><![CDATA[259]]></AD_TABLE_ID>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <AD_REFERENCE_ID><![CDATA[28]]></AD_REFERENCE_ID>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <SEQNO><![CDATA[700]]></SEQNO>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <AD_ELEMENT_ID><![CDATA[7E4BD5AAA3A1469FB75A57067824D05C]]></AD_ELEMENT_ID>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <POSITION><![CDATA[87]]></POSITION>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF-->  <EM_OBUIAPP_PROCESS_ID><![CDATA[8B70EC7800D147DC9B2BF5F051768BDC]]></EM_OBUIAPP_PROCESS_ID>
+<!--C66B2DE7A2D747169D9DFA9332FF98CF--></AD_COLUMN>
+
 <!--C674B13C5D9146D2A835EF715E268574--><AD_COLUMN>
 <!--C674B13C5D9146D2A835EF715E268574-->  <AD_COLUMN_ID><![CDATA[C674B13C5D9146D2A835EF715E268574]]></AD_COLUMN_ID>
 <!--C674B13C5D9146D2A835EF715E268574-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -309953,6 +310472,42 @@
 <!--C850E75FC2C640B59B4FEC12423F4251-->  <EM_OBUIAPP_PROCESS_ID><![CDATA[7DC2C8DC186B4C1DB18E147911950861]]></EM_OBUIAPP_PROCESS_ID>
 <!--C850E75FC2C640B59B4FEC12423F4251--></AD_COLUMN>
 
+<!--C88A17FC49EF43EEA9D8711431DC3B84--><AD_COLUMN>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <AD_COLUMN_ID><![CDATA[C88A17FC49EF43EEA9D8711431DC3B84]]></AD_COLUMN_ID>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <NAME><![CDATA[goodsShipmentLine]]></NAME>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <DESCRIPTION><![CDATA[A statement displaying one item, charge, or movement in a shipment.]]></DESCRIPTION>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <HELP><![CDATA[The Goods Shipment Line indicates a unique line in a Shipment document]]></HELP>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <COLUMNNAME><![CDATA[goodsShipmentLine]]></COLUMNNAME>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <AD_REFERENCE_VALUE_ID><![CDATA[54AC2749F26440F3AEA33378858569E4]]></AD_REFERENCE_VALUE_ID>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <SEQNO><![CDATA[60]]></SEQNO>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <AD_ELEMENT_ID><![CDATA[1026]]></AD_ELEMENT_ID>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--C88A17FC49EF43EEA9D8711431DC3B84-->  <ENTITY_ALIAS><![CDATA[iol.id]]></ENTITY_ALIAS>
+<!--C88A17FC49EF43EEA9D8711431DC3B84--></AD_COLUMN>
+
 <!--C8AE5CAA0579450D801E70F9BF497D46--><AD_COLUMN>
 <!--C8AE5CAA0579450D801E70F9BF497D46-->  <AD_COLUMN_ID><![CDATA[C8AE5CAA0579450D801E70F9BF497D46]]></AD_COLUMN_ID>
 <!--C8AE5CAA0579450D801E70F9BF497D46-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -315270,6 +315825,42 @@
 <!--D010ED8083334E3CB4294827AF15C564-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--D010ED8083334E3CB4294827AF15C564--></AD_COLUMN>
 
+<!--D0886771B2B843478613AAE863552638--><AD_COLUMN>
+<!--D0886771B2B843478613AAE863552638-->  <AD_COLUMN_ID><![CDATA[D0886771B2B843478613AAE863552638]]></AD_COLUMN_ID>
+<!--D0886771B2B843478613AAE863552638-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D0886771B2B843478613AAE863552638-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D0886771B2B843478613AAE863552638-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D0886771B2B843478613AAE863552638-->  <NAME><![CDATA[uOM]]></NAME>
+<!--D0886771B2B843478613AAE863552638-->  <DESCRIPTION><![CDATA[A non monetary unit of measure.]]></DESCRIPTION>
+<!--D0886771B2B843478613AAE863552638-->  <HELP><![CDATA[The UOM defines a unique non monetary unit of measure]]></HELP>
+<!--D0886771B2B843478613AAE863552638-->  <COLUMNNAME><![CDATA[uOM]]></COLUMNNAME>
+<!--D0886771B2B843478613AAE863552638-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--D0886771B2B843478613AAE863552638-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--D0886771B2B843478613AAE863552638-->  <AD_REFERENCE_VALUE_ID><![CDATA[114]]></AD_REFERENCE_VALUE_ID>
+<!--D0886771B2B843478613AAE863552638-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--D0886771B2B843478613AAE863552638-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--D0886771B2B843478613AAE863552638-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--D0886771B2B843478613AAE863552638-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--D0886771B2B843478613AAE863552638-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--D0886771B2B843478613AAE863552638-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--D0886771B2B843478613AAE863552638-->  <SEQNO><![CDATA[50]]></SEQNO>
+<!--D0886771B2B843478613AAE863552638-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--D0886771B2B843478613AAE863552638-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--D0886771B2B843478613AAE863552638-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--D0886771B2B843478613AAE863552638-->  <AD_ELEMENT_ID><![CDATA[215]]></AD_ELEMENT_ID>
+<!--D0886771B2B843478613AAE863552638-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--D0886771B2B843478613AAE863552638-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--D0886771B2B843478613AAE863552638-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--D0886771B2B843478613AAE863552638-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--D0886771B2B843478613AAE863552638-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D0886771B2B843478613AAE863552638-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--D0886771B2B843478613AAE863552638-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--D0886771B2B843478613AAE863552638-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--D0886771B2B843478613AAE863552638-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--D0886771B2B843478613AAE863552638-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--D0886771B2B843478613AAE863552638-->  <ENTITY_ALIAS><![CDATA[iol.uOM]]></ENTITY_ALIAS>
+<!--D0886771B2B843478613AAE863552638--></AD_COLUMN>
+
 <!--D0C775ACDFFE43E0B9ECE73CEBE31D4B--><AD_COLUMN>
 <!--D0C775ACDFFE43E0B9ECE73CEBE31D4B-->  <AD_COLUMN_ID><![CDATA[D0C775ACDFFE43E0B9ECE73CEBE31D4B]]></AD_COLUMN_ID>
 <!--D0C775ACDFFE43E0B9ECE73CEBE31D4B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -315590,6 +316181,42 @@
 <!--D1FA35E7BC7442A5BF3E44E8C3170F70-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--D1FA35E7BC7442A5BF3E44E8C3170F70--></AD_COLUMN>
 
+<!--D21ED5336ED84C2180F0F19353B669EC--><AD_COLUMN>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <AD_COLUMN_ID><![CDATA[D21ED5336ED84C2180F0F19353B669EC]]></AD_COLUMN_ID>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <NAME><![CDATA[businessPartner]]></NAME>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <DESCRIPTION><![CDATA[Anyone who takes part in daily business operations by acting as a customer, employee, etc.]]></DESCRIPTION>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <HELP><![CDATA[A Business Partner is anyone with whom you transact.  This can include a customer, vendor, employee or any combination of these.]]></HELP>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <COLUMNNAME><![CDATA[businessPartner]]></COLUMNNAME>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <AD_REFERENCE_VALUE_ID><![CDATA[138]]></AD_REFERENCE_VALUE_ID>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <SEQNO><![CDATA[80]]></SEQNO>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <AD_ELEMENT_ID><![CDATA[187]]></AD_ELEMENT_ID>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--D21ED5336ED84C2180F0F19353B669EC-->  <ENTITY_ALIAS><![CDATA[iol.shipmentReceipt.businessPartner]]></ENTITY_ALIAS>
+<!--D21ED5336ED84C2180F0F19353B669EC--></AD_COLUMN>
+
 <!--D243A6CF3B804A92A59633006740DE1D--><AD_COLUMN>
 <!--D243A6CF3B804A92A59633006740DE1D-->  <AD_COLUMN_ID><![CDATA[D243A6CF3B804A92A59633006740DE1D]]></AD_COLUMN_ID>
 <!--D243A6CF3B804A92A59633006740DE1D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -315660,6 +316287,39 @@
 <!--D270E0FBA1074C439DC12CF8939EB830-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--D270E0FBA1074C439DC12CF8939EB830--></AD_COLUMN>
 
+<!--D28A3BDC6C1240F88B98A48ADA27F53B--><AD_COLUMN>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <AD_COLUMN_ID><![CDATA[D28A3BDC6C1240F88B98A48ADA27F53B]]></AD_COLUMN_ID>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <NAME><![CDATA[obSelected]]></NAME>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <COLUMNNAME><![CDATA[obSelected]]></COLUMNNAME>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <SEQNO><![CDATA[120]]></SEQNO>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <AD_ELEMENT_ID><![CDATA[B13BBED95C5B262CE040007F01005E70]]></AD_ELEMENT_ID>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B-->  <ENTITY_ALIAS><![CDATA[obSelectedSubQuery]]></ENTITY_ALIAS>
+<!--D28A3BDC6C1240F88B98A48ADA27F53B--></AD_COLUMN>
+
 <!--D2A9D48448C24EAA847A52E607072C7B--><AD_COLUMN>
 <!--D2A9D48448C24EAA847A52E607072C7B-->  <AD_COLUMN_ID><![CDATA[D2A9D48448C24EAA847A52E607072C7B]]></AD_COLUMN_ID>
 <!--D2A9D48448C24EAA847A52E607072C7B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -321859,6 +322519,42 @@
 <!--E01FCAF529B5F265E040007F01000597-->  <EM_OBUIAPP_PROCESS_ID><![CDATA[FE3A8C134D41488DB3A69837BD54B56A]]></EM_OBUIAPP_PROCESS_ID>
 <!--E01FCAF529B5F265E040007F01000597--></AD_COLUMN>
 
+<!--E0208FA3C87A4114BE7F75A0A5244A40--><AD_COLUMN>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <AD_COLUMN_ID><![CDATA[E0208FA3C87A4114BE7F75A0A5244A40]]></AD_COLUMN_ID>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <NAME><![CDATA[client]]></NAME>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <DESCRIPTION><![CDATA[Client for this installation.]]></DESCRIPTION>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <HELP><![CDATA[A Client is a company or a legal entity. You cannot share data between Clients.]]></HELP>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <COLUMNNAME><![CDATA[client]]></COLUMNNAME>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <AD_REFERENCE_VALUE_ID><![CDATA[129]]></AD_REFERENCE_VALUE_ID>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <SEQNO><![CDATA[30]]></SEQNO>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <AD_ELEMENT_ID><![CDATA[102]]></AD_ELEMENT_ID>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--E0208FA3C87A4114BE7F75A0A5244A40-->  <ENTITY_ALIAS><![CDATA[iol.client]]></ENTITY_ALIAS>
+<!--E0208FA3C87A4114BE7F75A0A5244A40--></AD_COLUMN>
+
 <!--E0386DBA300149B88800B0FF94AB44C3--><AD_COLUMN>
 <!--E0386DBA300149B88800B0FF94AB44C3-->  <AD_COLUMN_ID><![CDATA[E0386DBA300149B88800B0FF94AB44C3]]></AD_COLUMN_ID>
 <!--E0386DBA300149B88800B0FF94AB44C3-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Mon Jun 16 18:11:52 2014 +0200
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Mon Jun 16 18:16:52 2014 +0200
@@ -26461,6 +26461,18 @@
 <!--7E3C2453261B31A7E040007F0100680C-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--7E3C2453261B31A7E040007F0100680C--></AD_ELEMENT>
 
+<!--7E4BD5AAA3A1469FB75A57067824D05C--><AD_ELEMENT>
+<!--7E4BD5AAA3A1469FB75A57067824D05C-->  <AD_ELEMENT_ID><![CDATA[7E4BD5AAA3A1469FB75A57067824D05C]]></AD_ELEMENT_ID>
+<!--7E4BD5AAA3A1469FB75A57067824D05C-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7E4BD5AAA3A1469FB75A57067824D05C-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7E4BD5AAA3A1469FB75A57067824D05C-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7E4BD5AAA3A1469FB75A57067824D05C-->  <COLUMNNAME><![CDATA[RM_Pickfromreceipthql]]></COLUMNNAME>
+<!--7E4BD5AAA3A1469FB75A57067824D05C-->  <NAME><![CDATA[RM_Pickfromreceipthql]]></NAME>
+<!--7E4BD5AAA3A1469FB75A57067824D05C-->  <PRINTNAME><![CDATA[RM_Pickfromreceipthql]]></PRINTNAME>
+<!--7E4BD5AAA3A1469FB75A57067824D05C-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--7E4BD5AAA3A1469FB75A57067824D05C-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--7E4BD5AAA3A1469FB75A57067824D05C--></AD_ELEMENT>
+
 <!--7E562C34A0566EB2E040007F01001D67--><AD_ELEMENT>
 <!--7E562C34A0566EB2E040007F01001D67-->  <AD_ELEMENT_ID><![CDATA[7E562C34A0566EB2E040007F01001D67]]></AD_ELEMENT_ID>
 <!--7E562C34A0566EB2E040007F01001D67-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_TABLE.xml	Mon Jun 16 18:11:52 2014 +0200
+++ b/src-db/database/sourcedata/AD_TABLE.xml	Mon Jun 16 18:16:52 2014 +0200
@@ -11449,6 +11449,60 @@
 <!--CBF045D2539A4249B091CCE4B1F5EEDB-->  <ISTREE><![CDATA[N]]></ISTREE>
 <!--CBF045D2539A4249B091CCE4B1F5EEDB--></AD_TABLE>
 
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390--><AD_TABLE>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <AD_TABLE_ID><![CDATA[CDB9DC9655F24DF8AB41AA0ADBD04390]]></AD_TABLE_ID>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <NAME><![CDATA[C_RM_ReturnToVendorHQL]]></NAME>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <TABLENAME><![CDATA[C_RM_ReturnToVendorHQL]]></TABLENAME>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <ISVIEW><![CDATA[N]]></ISVIEW>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <ACCESSLEVEL><![CDATA[1]]></ACCESSLEVEL>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <AD_WINDOW_ID><![CDATA[C50A8AEE6F044825B5EF54FAAE76826F]]></AD_WINDOW_ID>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <ISSECURITYENABLED><![CDATA[N]]></ISSECURITYENABLED>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <ISDELETEABLE><![CDATA[Y]]></ISDELETEABLE>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <ISHIGHVOLUME><![CDATA[N]]></ISHIGHVOLUME>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <IMPORTTABLE><![CDATA[N]]></IMPORTTABLE>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <ISCHANGELOG><![CDATA[N]]></ISCHANGELOG>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <AD_PACKAGE_ID><![CDATA[5A3ED54AB1D94B84E040007F01006125]]></AD_PACKAGE_ID>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <DATAORIGINTYPE><![CDATA[HQL]]></DATAORIGINTYPE>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <ISTREE><![CDATA[N]]></ISTREE>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <HQLQUERY><![CDATA[select iol.id as id, iol.organization as organization, iol.client as client,  iol.product as product,  
+iol.uOM as uOM, iol.id as goodsShipmentLine, iol.movementQuantity as movementQuantity,
+iol.shipmentReceipt.businessPartner as businessPartner, iol.shipmentReceipt.documentNo as shipmentNumber,
+iol.shipmentReceipt.movementDate as movementDate,  attributeSetValue as attributeSetValue,
+coalesce((select sum(ol.orderedQuantity)
+from OrderLine as ol
+left join ol.salesOrder as o
+where ol.goodsShipmentLine = iol
+and o.processed = true
+and o.documentStatus <> 'VO'), 0) as returnQtyOtherRM,
+(case when (select ('Y') from OrderLine as ol where ol.salesOrder.id = :salesOrderId and ol.goodsShipmentLine = iol) is null then false else true end) as obSelected,
+coalesce((select ol.orderedQuantity from OrderLine as ol where ol.salesOrder.id = :salesOrderId and ol.goodsShipmentLine = iol),0) as returned,
+(select ol.returnReason from OrderLine as ol where ol.salesOrder.id = :salesOrderId and ol.goodsShipmentLine = iol) as returnReason,
+coalesce((select ol.tax from OrderLine as ol where ol.salesOrder.id = :salesOrderId and ol.goodsShipmentLine = iol) ,
+(select e.salesOrderLine.tax from ProcurementPOInvoiceMatch as e where e.goodsShipmentLine = iol)) as tax,
+(case when (select e.salesOrderLine.salesOrder.priceList.priceIncludesTax from ProcurementPOInvoiceMatch as e where e.goodsShipmentLine = iol) = true then
+ coalesce((select ol.unitPrice from OrderLine as ol where ol.salesOrder.id = :salesOrderId and ol.goodsShipmentLine = iol), 
+          (select e.salesOrderLine.grossUnitPrice from ProcurementPOInvoiceMatch as e where e.goodsShipmentLine = iol))
+else 
+ coalesce((select ol.unitPrice from OrderLine as ol where ol.salesOrder.id = :salesOrderId and ol.goodsShipmentLine = iol), 
+          (select e.salesOrderLine.unitPrice from ProcurementPOInvoiceMatch as e where e.goodsShipmentLine = iol))
+end) as unitPrice,
+(select e.salesOrderLine.salesOrder.documentNo from ProcurementPOInvoiceMatch as e where e.goodsShipmentLine = iol) as orderNo
+MAINFROM MaterialMgmtShipmentInOutLine as iol 
+left join  iol.attributeSetValue as attributeSetValue
+join iol.shipmentReceipt as io 
+where io.businessPartner.id = :businessPartnerId 
+and io.processed = true and io.documentStatus <> 'VO' 
+and io.salesTransaction = false 
+and iol.organization in ('E443A31992CB4635AFCAEABE7183CE85') 
+and @additional_filters@]]></HQLQUERY>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390-->  <ENTITY_ALIAS><![CDATA[iol]]></ENTITY_ALIAS>
+<!--CDB9DC9655F24DF8AB41AA0ADBD04390--></AD_TABLE>
+
 <!--CE9AFF5F51B846AEAB0B6CBF829092CD--><AD_TABLE>
 <!--CE9AFF5F51B846AEAB0B6CBF829092CD-->  <AD_TABLE_ID><![CDATA[CE9AFF5F51B846AEAB0B6CBF829092CD]]></AD_TABLE_ID>
 <!--CE9AFF5F51B846AEAB0B6CBF829092CD-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>