Attached Files | FixesIssue38596.diff [^] (34,890 bytes) 2018-06-04 13:20 [Show Content] [Hide Content]diff --git a/src-db/database/model/tables/OBDO_DISTORDERLINE.xml b/src-db/database/model/tables/OBDO_DISTORDERLINE.xml
--- a/src-db/database/model/tables/OBDO_DISTORDERLINE.xml
+++ b/src-db/database/model/tables/OBDO_DISTORDERLINE.xml
@@ -37,7 +37,7 @@
<default/>
<onCreateDefault/>
</column>
- <column name="M_PRODUCT_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
+ <column name="M_PRODUCT_ID" primaryKey="false" required="true" type="VARCHAR" size="64" autoIncrement="false">
<default/>
<onCreateDefault/>
</column>
diff --git a/src-db/database/sourcedata/AD_COLUMN.xml b/src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml
+++ b/src-db/database/sourcedata/AD_COLUMN.xml
@@ -2741,7 +2741,7 @@
<!--EB7C8B668C85450092DD3D37A44704D6--> <COLUMNNAME><![CDATA[M_Product_ID]]></COLUMNNAME>
<!--EB7C8B668C85450092DD3D37A44704D6--> <AD_TABLE_ID><![CDATA[852D14BE2D8D42178E823FB834270565]]></AD_TABLE_ID>
<!--EB7C8B668C85450092DD3D37A44704D6--> <AD_REFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></AD_REFERENCE_ID>
-<!--EB7C8B668C85450092DD3D37A44704D6--> <AD_REFERENCE_VALUE_ID><![CDATA[D920A7ED46C542629D2A1054560EBF14]]></AD_REFERENCE_VALUE_ID>
+<!--EB7C8B668C85450092DD3D37A44704D6--> <AD_REFERENCE_VALUE_ID><![CDATA[5DE98FE9933242D7AB8608BE769490C8]]></AD_REFERENCE_VALUE_ID>
<!--EB7C8B668C85450092DD3D37A44704D6--> <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
<!--EB7C8B668C85450092DD3D37A44704D6--> <ISKEY><![CDATA[N]]></ISKEY>
<!--EB7C8B668C85450092DD3D37A44704D6--> <ISPARENT><![CDATA[N]]></ISPARENT>
diff --git a/src-db/database/sourcedata/AD_REFERENCE.xml b/src-db/database/sourcedata/AD_REFERENCE.xml
--- a/src-db/database/sourcedata/AD_REFERENCE.xml
+++ b/src-db/database/sourcedata/AD_REFERENCE.xml
@@ -68,6 +68,20 @@
<!--5202290F241F4855B934DED272156FAD--> <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
<!--5202290F241F4855B934DED272156FAD--></AD_REFERENCE>
+<!--5DE98FE9933242D7AB8608BE769490C8--><AD_REFERENCE>
+<!--5DE98FE9933242D7AB8608BE769490C8--> <AD_REFERENCE_ID><![CDATA[5DE98FE9933242D7AB8608BE769490C8]]></AD_REFERENCE_ID>
+<!--5DE98FE9933242D7AB8608BE769490C8--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--5DE98FE9933242D7AB8608BE769490C8--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--5DE98FE9933242D7AB8608BE769490C8--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--5DE98FE9933242D7AB8608BE769490C8--> <NAME><![CDATA[Item Stocked Products and available quanitity]]></NAME>
+<!--5DE98FE9933242D7AB8608BE769490C8--> <DESCRIPTION><![CDATA[Products defined as item and stockable and information about available quantity]]></DESCRIPTION>
+<!--5DE98FE9933242D7AB8608BE769490C8--> <HELP><![CDATA[Selector to pick a Product from a list of Products that are defined as Item and Stockable. Also has information about the available quantity]]></HELP>
+<!--5DE98FE9933242D7AB8608BE769490C8--> <AD_MODULE_ID><![CDATA[8542A34B0C6B4724A1D5C9B16B0BE028]]></AD_MODULE_ID>
+<!--5DE98FE9933242D7AB8608BE769490C8--> <ISBASEREFERENCE><![CDATA[N]]></ISBASEREFERENCE>
+<!--5DE98FE9933242D7AB8608BE769490C8--> <PARENTREFERENCE_ID><![CDATA[95E2A8B50A254B2AAE6774B8C2F28120]]></PARENTREFERENCE_ID>
+<!--5DE98FE9933242D7AB8608BE769490C8--> <ISVALUEDISPLAYED><![CDATA[N]]></ISVALUEDISPLAYED>
+<!--5DE98FE9933242D7AB8608BE769490C8--></AD_REFERENCE>
+
<!--6FB956CAA7D7494FA38CEFC2789D7484--><AD_REFERENCE>
<!--6FB956CAA7D7494FA38CEFC2789D7484--> <AD_REFERENCE_ID><![CDATA[6FB956CAA7D7494FA38CEFC2789D7484]]></AD_REFERENCE_ID>
<!--6FB956CAA7D7494FA38CEFC2789D7484--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff --git a/src-db/database/sourcedata/AD_REF_SEARCH.xml b/src-db/database/sourcedata/AD_REF_SEARCH.xml
--- a/src-db/database/sourcedata/AD_REF_SEARCH.xml
+++ b/src-db/database/sourcedata/AD_REF_SEARCH.xml
@@ -1,5 +1,15 @@
<?xml version='1.0' encoding='UTF-8'?>
<data>
+<!--0B5BE2360B854B42AF6D285701951EE5--><AD_REF_SEARCH>
+<!--0B5BE2360B854B42AF6D285701951EE5--> <AD_REF_SEARCH_ID><![CDATA[0B5BE2360B854B42AF6D285701951EE5]]></AD_REF_SEARCH_ID>
+<!--0B5BE2360B854B42AF6D285701951EE5--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0B5BE2360B854B42AF6D285701951EE5--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0B5BE2360B854B42AF6D285701951EE5--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0B5BE2360B854B42AF6D285701951EE5--> <AD_REFERENCE_ID><![CDATA[5DE98FE9933242D7AB8608BE769490C8]]></AD_REFERENCE_ID>
+<!--0B5BE2360B854B42AF6D285701951EE5--> <AD_TABLE_ID><![CDATA[208]]></AD_TABLE_ID>
+<!--0B5BE2360B854B42AF6D285701951EE5--> <AD_COLUMN_ID><![CDATA[1402]]></AD_COLUMN_ID>
+<!--0B5BE2360B854B42AF6D285701951EE5--></AD_REF_SEARCH>
+
<!--E4F2EF957C0546429076DE9789754FD6--><AD_REF_SEARCH>
<!--E4F2EF957C0546429076DE9789754FD6--> <AD_REF_SEARCH_ID><![CDATA[E4F2EF957C0546429076DE9789754FD6]]></AD_REF_SEARCH_ID>
<!--E4F2EF957C0546429076DE9789754FD6--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff --git a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR.xml
@@ -1,5 +1,26 @@
<?xml version='1.0' encoding='UTF-8'?>
<data>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--><OBUISEL_SELECTOR>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <OBUISEL_SELECTOR_ID><![CDATA[0612DB85D07A46A8B0D34E2BCA8083B8]]></OBUISEL_SELECTOR_ID>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <AD_MODULE_ID><![CDATA[8542A34B0C6B4724A1D5C9B16B0BE028]]></AD_MODULE_ID>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <NAME><![CDATA[Item Stocked Products and available quanitity]]></NAME>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <DESCRIPTION><![CDATA[Products defined as item and stockable and information about available quantity]]></DESCRIPTION>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <HELP><![CDATA[Selector to pick a Product from a list of Products that are defined as Item and Stockable. Also has information about the available quantity]]></HELP>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <AD_REFERENCE_ID><![CDATA[5DE98FE9933242D7AB8608BE769490C8]]></AD_REFERENCE_ID>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <AD_TABLE_ID><![CDATA[FF8080812E381D1E012E3898C5DD0010]]></AD_TABLE_ID>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <AD_COLUMN_ID><![CDATA[9C8C523F49EABD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <FILTER_EXPRESSION><![CDATA[OB.getFilterExpression("org.openbravo.distributionorder.info.ProductWithStockSelectorFilterExpression")]]></FILTER_EXPRESSION>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <OBCLKER_TEMPLATE_ID><![CDATA[9314DE8599AD44E7BFC4CC50699042AB]]></OBCLKER_TEMPLATE_ID>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <VALUEFIELD_ID><![CDATA[9AD20E75511B48EDB02D876352CB7391]]></VALUEFIELD_ID>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <DISPLAYFIELD_ID><![CDATA[4CC3D5635D214439B6A3AD0CB93A36DF]]></DISPLAYFIELD_ID>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <SUGGESTIONTEXTMATCHSTYLE><![CDATA[substring]]></SUGGESTIONTEXTMATCHSTYLE>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <POPUPTEXTMATCHSTYLE><![CDATA[substring]]></POPUPTEXTMATCHSTYLE>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--> <CUSTOM_QUERY><![CDATA[N]]></CUSTOM_QUERY>
+<!--0612DB85D07A46A8B0D34E2BCA8083B8--></OBUISEL_SELECTOR>
+
<!--0DD3FED00F354EBF96D1E59F10FE55E0--><OBUISEL_SELECTOR>
<!--0DD3FED00F354EBF96D1E59F10FE55E0--> <OBUISEL_SELECTOR_ID><![CDATA[0DD3FED00F354EBF96D1E59F10FE55E0]]></OBUISEL_SELECTOR_ID>
<!--0DD3FED00F354EBF96D1E59F10FE55E0--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff --git a/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml b/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
--- a/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
+++ b/src-db/database/sourcedata/OBUISEL_SELECTOR_FIELD.xml
@@ -22,6 +22,30 @@
<!--128614C1D5A74933B3BABA36DAF96050--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
<!--128614C1D5A74933B3BABA36DAF96050--></OBUISEL_SELECTOR_FIELD>
+<!--1B0E5E12E181452F83237E09F42DACA7--><OBUISEL_SELECTOR_FIELD>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[1B0E5E12E181452F83237E09F42DACA7]]></OBUISEL_SELECTOR_FIELD_ID>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <OBUISEL_SELECTOR_ID><![CDATA[0612DB85D07A46A8B0D34E2BCA8083B8]]></OBUISEL_SELECTOR_ID>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <AD_MODULE_ID><![CDATA[8542A34B0C6B4724A1D5C9B16B0BE028]]></AD_MODULE_ID>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <AD_COLUMN_ID><![CDATA[2011]]></AD_COLUMN_ID>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <NAME><![CDATA[Search Key]]></NAME>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <DESCRIPTION><![CDATA[A fast method for finding a particular record.]]></DESCRIPTION>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <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>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <PROPERTY><![CDATA[product.searchKey]]></PROPERTY>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <SORT><![CDATA[Y]]></SORT>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <FILTER><![CDATA[Y]]></FILTER>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <SEARCHINSUGGESTIONBOX><![CDATA[Y]]></SEARCHINSUGGESTIONBOX>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <SORTNO><![CDATA[10]]></SORTNO>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD>
+<!--1B0E5E12E181452F83237E09F42DACA7--> <SHOWINPICKLIST><![CDATA[Y]]></SHOWINPICKLIST>
+<!--1B0E5E12E181452F83237E09F42DACA7--></OBUISEL_SELECTOR_FIELD>
+
<!--1C1E9B74E1EB46AD996EB3E3CB00D321--><OBUISEL_SELECTOR_FIELD>
<!--1C1E9B74E1EB46AD996EB3E3CB00D321--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[1C1E9B74E1EB46AD996EB3E3CB00D321]]></OBUISEL_SELECTOR_FIELD_ID>
<!--1C1E9B74E1EB46AD996EB3E3CB00D321--> <OBUISEL_SELECTOR_ID><![CDATA[A1367535DC8C405792697195EC8F4294]]></OBUISEL_SELECTOR_ID>
@@ -66,6 +90,49 @@
<!--3D8B0710AA2B4B9F87B2E141F3C1690F--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
<!--3D8B0710AA2B4B9F87B2E141F3C1690F--></OBUISEL_SELECTOR_FIELD>
+<!--494B7EB900F34687AADB77308049A104--><OBUISEL_SELECTOR_FIELD>
+<!--494B7EB900F34687AADB77308049A104--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[494B7EB900F34687AADB77308049A104]]></OBUISEL_SELECTOR_FIELD_ID>
+<!--494B7EB900F34687AADB77308049A104--> <OBUISEL_SELECTOR_ID><![CDATA[0612DB85D07A46A8B0D34E2BCA8083B8]]></OBUISEL_SELECTOR_ID>
+<!--494B7EB900F34687AADB77308049A104--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--494B7EB900F34687AADB77308049A104--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--494B7EB900F34687AADB77308049A104--> <AD_MODULE_ID><![CDATA[8542A34B0C6B4724A1D5C9B16B0BE028]]></AD_MODULE_ID>
+<!--494B7EB900F34687AADB77308049A104--> <AD_COLUMN_ID><![CDATA[DA77D45513798AC2E040007F010002E3]]></AD_COLUMN_ID>
+<!--494B7EB900F34687AADB77308049A104--> <NAME><![CDATA[Characteristic Description]]></NAME>
+<!--494B7EB900F34687AADB77308049A104--> <HELP><![CDATA[Text with the concatenation of the characteristics and its values assigned to the product.]]></HELP>
+<!--494B7EB900F34687AADB77308049A104--> <PROPERTY><![CDATA[product.characteristicDescription]]></PROPERTY>
+<!--494B7EB900F34687AADB77308049A104--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--494B7EB900F34687AADB77308049A104--> <SORT><![CDATA[Y]]></SORT>
+<!--494B7EB900F34687AADB77308049A104--> <FILTER><![CDATA[Y]]></FILTER>
+<!--494B7EB900F34687AADB77308049A104--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX>
+<!--494B7EB900F34687AADB77308049A104--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID>
+<!--494B7EB900F34687AADB77308049A104--> <SORTNO><![CDATA[25]]></SORTNO>
+<!--494B7EB900F34687AADB77308049A104--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--494B7EB900F34687AADB77308049A104--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD>
+<!--494B7EB900F34687AADB77308049A104--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
+<!--494B7EB900F34687AADB77308049A104--></OBUISEL_SELECTOR_FIELD>
+
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--><OBUISEL_SELECTOR_FIELD>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[4CC3D5635D214439B6A3AD0CB93A36DF]]></OBUISEL_SELECTOR_FIELD_ID>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <OBUISEL_SELECTOR_ID><![CDATA[0612DB85D07A46A8B0D34E2BCA8083B8]]></OBUISEL_SELECTOR_ID>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <AD_MODULE_ID><![CDATA[8542A34B0C6B4724A1D5C9B16B0BE028]]></AD_MODULE_ID>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <AD_COLUMN_ID><![CDATA[9C8C523F49EABD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <NAME><![CDATA[Product]]></NAME>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <DESCRIPTION><![CDATA[An item produced by a process.]]></DESCRIPTION>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <HELP><![CDATA[Identifies an item which is either purchased or sold in this organization.]]></HELP>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <PROPERTY><![CDATA[product.name]]></PROPERTY>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <SORT><![CDATA[Y]]></SORT>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <FILTER><![CDATA[Y]]></FILTER>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <SEARCHINSUGGESTIONBOX><![CDATA[Y]]></SEARCHINSUGGESTIONBOX>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <SORTNO><![CDATA[20]]></SORTNO>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--> <SHOWINPICKLIST><![CDATA[Y]]></SHOWINPICKLIST>
+<!--4CC3D5635D214439B6A3AD0CB93A36DF--></OBUISEL_SELECTOR_FIELD>
+
<!--668A9647C724491FBF03829D0DC8CFB8--><OBUISEL_SELECTOR_FIELD>
<!--668A9647C724491FBF03829D0DC8CFB8--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[668A9647C724491FBF03829D0DC8CFB8]]></OBUISEL_SELECTOR_FIELD_ID>
<!--668A9647C724491FBF03829D0DC8CFB8--> <OBUISEL_SELECTOR_ID><![CDATA[A1367535DC8C405792697195EC8F4294]]></OBUISEL_SELECTOR_ID>
@@ -107,6 +174,49 @@
<!--738CAB10C5E047F0872C3F4EE7B221EC--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
<!--738CAB10C5E047F0872C3F4EE7B221EC--></OBUISEL_SELECTOR_FIELD>
+<!--800393DABC5A4883BEBF9B23DBA97D87--><OBUISEL_SELECTOR_FIELD>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[800393DABC5A4883BEBF9B23DBA97D87]]></OBUISEL_SELECTOR_FIELD_ID>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <OBUISEL_SELECTOR_ID><![CDATA[0612DB85D07A46A8B0D34E2BCA8083B8]]></OBUISEL_SELECTOR_ID>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <AD_MODULE_ID><![CDATA[8542A34B0C6B4724A1D5C9B16B0BE028]]></AD_MODULE_ID>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <AD_COLUMN_ID><![CDATA[9C8C523F49EDBD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <NAME><![CDATA[Quantity in draft transactions]]></NAME>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <HELP><![CDATA[The quantity that we have already purchased but are not still in the warehouse]]></HELP>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <PROPERTY><![CDATA[quantityInDraftTransactions]]></PROPERTY>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <SORT><![CDATA[Y]]></SORT>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <FILTER><![CDATA[Y]]></FILTER>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <SORTNO><![CDATA[50]]></SORTNO>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD>
+<!--800393DABC5A4883BEBF9B23DBA97D87--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
+<!--800393DABC5A4883BEBF9B23DBA97D87--></OBUISEL_SELECTOR_FIELD>
+
+<!--849F770DA2F64800B082A44F0FFACE75--><OBUISEL_SELECTOR_FIELD>
+<!--849F770DA2F64800B082A44F0FFACE75--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[849F770DA2F64800B082A44F0FFACE75]]></OBUISEL_SELECTOR_FIELD_ID>
+<!--849F770DA2F64800B082A44F0FFACE75--> <OBUISEL_SELECTOR_ID><![CDATA[0612DB85D07A46A8B0D34E2BCA8083B8]]></OBUISEL_SELECTOR_ID>
+<!--849F770DA2F64800B082A44F0FFACE75--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--849F770DA2F64800B082A44F0FFACE75--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--849F770DA2F64800B082A44F0FFACE75--> <AD_MODULE_ID><![CDATA[8542A34B0C6B4724A1D5C9B16B0BE028]]></AD_MODULE_ID>
+<!--849F770DA2F64800B082A44F0FFACE75--> <AD_COLUMN_ID><![CDATA[9C8C523F49EBBD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--849F770DA2F64800B082A44F0FFACE75--> <NAME><![CDATA[Quantity on Hand]]></NAME>
+<!--849F770DA2F64800B082A44F0FFACE75--> <DESCRIPTION><![CDATA[On Hand Quantity]]></DESCRIPTION>
+<!--849F770DA2F64800B082A44F0FFACE75--> <HELP><![CDATA[The On Hand Quantity indicates the quantity of a product that is on hand in a warehouse.]]></HELP>
+<!--849F770DA2F64800B082A44F0FFACE75--> <PROPERTY><![CDATA[quantityOnHand]]></PROPERTY>
+<!--849F770DA2F64800B082A44F0FFACE75--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--849F770DA2F64800B082A44F0FFACE75--> <SORT><![CDATA[Y]]></SORT>
+<!--849F770DA2F64800B082A44F0FFACE75--> <FILTER><![CDATA[Y]]></FILTER>
+<!--849F770DA2F64800B082A44F0FFACE75--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX>
+<!--849F770DA2F64800B082A44F0FFACE75--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID>
+<!--849F770DA2F64800B082A44F0FFACE75--> <SORTNO><![CDATA[40]]></SORTNO>
+<!--849F770DA2F64800B082A44F0FFACE75--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--849F770DA2F64800B082A44F0FFACE75--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD>
+<!--849F770DA2F64800B082A44F0FFACE75--> <SHOWINPICKLIST><![CDATA[Y]]></SHOWINPICKLIST>
+<!--849F770DA2F64800B082A44F0FFACE75--></OBUISEL_SELECTOR_FIELD>
+
<!--8B5C1045FF484936AAAADC28C41432E2--><OBUISEL_SELECTOR_FIELD>
<!--8B5C1045FF484936AAAADC28C41432E2--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[8B5C1045FF484936AAAADC28C41432E2]]></OBUISEL_SELECTOR_FIELD_ID>
<!--8B5C1045FF484936AAAADC28C41432E2--> <OBUISEL_SELECTOR_ID><![CDATA[26BFCF47357E48C482CDE5B152F086BD]]></OBUISEL_SELECTOR_ID>
@@ -173,6 +283,28 @@
<!--95BCF3C4507244B5AFD76E840B0EAAF3--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
<!--95BCF3C4507244B5AFD76E840B0EAAF3--></OBUISEL_SELECTOR_FIELD>
+<!--9AD20E75511B48EDB02D876352CB7391--><OBUISEL_SELECTOR_FIELD>
+<!--9AD20E75511B48EDB02D876352CB7391--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[9AD20E75511B48EDB02D876352CB7391]]></OBUISEL_SELECTOR_FIELD_ID>
+<!--9AD20E75511B48EDB02D876352CB7391--> <OBUISEL_SELECTOR_ID><![CDATA[0612DB85D07A46A8B0D34E2BCA8083B8]]></OBUISEL_SELECTOR_ID>
+<!--9AD20E75511B48EDB02D876352CB7391--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9AD20E75511B48EDB02D876352CB7391--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9AD20E75511B48EDB02D876352CB7391--> <AD_MODULE_ID><![CDATA[8542A34B0C6B4724A1D5C9B16B0BE028]]></AD_MODULE_ID>
+<!--9AD20E75511B48EDB02D876352CB7391--> <AD_COLUMN_ID><![CDATA[9C8C523F49EABD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--9AD20E75511B48EDB02D876352CB7391--> <NAME><![CDATA[Product id]]></NAME>
+<!--9AD20E75511B48EDB02D876352CB7391--> <DESCRIPTION><![CDATA[An item produced by a process.]]></DESCRIPTION>
+<!--9AD20E75511B48EDB02D876352CB7391--> <HELP><![CDATA[Identifies an item which is either purchased or sold in this organization.]]></HELP>
+<!--9AD20E75511B48EDB02D876352CB7391--> <PROPERTY><![CDATA[product.id]]></PROPERTY>
+<!--9AD20E75511B48EDB02D876352CB7391--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--9AD20E75511B48EDB02D876352CB7391--> <SORT><![CDATA[Y]]></SORT>
+<!--9AD20E75511B48EDB02D876352CB7391--> <FILTER><![CDATA[Y]]></FILTER>
+<!--9AD20E75511B48EDB02D876352CB7391--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX>
+<!--9AD20E75511B48EDB02D876352CB7391--> <SHOWINGRID><![CDATA[N]]></SHOWINGRID>
+<!--9AD20E75511B48EDB02D876352CB7391--> <SORTNO><![CDATA[0]]></SORTNO>
+<!--9AD20E75511B48EDB02D876352CB7391--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9AD20E75511B48EDB02D876352CB7391--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD>
+<!--9AD20E75511B48EDB02D876352CB7391--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
+<!--9AD20E75511B48EDB02D876352CB7391--></OBUISEL_SELECTOR_FIELD>
+
<!--AE4AA8FA412E4322BF7456A802113B17--><OBUISEL_SELECTOR_FIELD>
<!--AE4AA8FA412E4322BF7456A802113B17--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[AE4AA8FA412E4322BF7456A802113B17]]></OBUISEL_SELECTOR_FIELD_ID>
<!--AE4AA8FA412E4322BF7456A802113B17--> <OBUISEL_SELECTOR_ID><![CDATA[0DD3FED00F354EBF96D1E59F10FE55E0]]></OBUISEL_SELECTOR_ID>
@@ -219,6 +351,28 @@
<!--B8980B6E08F14C60BDAEEA6B5CCB00B0--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
<!--B8980B6E08F14C60BDAEEA6B5CCB00B0--></OBUISEL_SELECTOR_FIELD>
+<!--B8B7D31F526E4D558720C8E730F9D17A--><OBUISEL_SELECTOR_FIELD>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[B8B7D31F526E4D558720C8E730F9D17A]]></OBUISEL_SELECTOR_FIELD_ID>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <OBUISEL_SELECTOR_ID><![CDATA[0612DB85D07A46A8B0D34E2BCA8083B8]]></OBUISEL_SELECTOR_ID>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <AD_MODULE_ID><![CDATA[8542A34B0C6B4724A1D5C9B16B0BE028]]></AD_MODULE_ID>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <AD_COLUMN_ID><![CDATA[9C8C523F49EFBD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <NAME><![CDATA[UOM]]></NAME>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <DESCRIPTION><![CDATA[A non monetary unit of measure.]]></DESCRIPTION>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <HELP><![CDATA[The UOM defines a unique non monetary unit of measure]]></HELP>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <PROPERTY><![CDATA[uOM]]></PROPERTY>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <SORT><![CDATA[Y]]></SORT>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <FILTER><![CDATA[Y]]></FILTER>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <SORTNO><![CDATA[60]]></SORTNO>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD>
+<!--B8B7D31F526E4D558720C8E730F9D17A--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
+<!--B8B7D31F526E4D558720C8E730F9D17A--></OBUISEL_SELECTOR_FIELD>
+
<!--B951FE831F1B4F839A521A22CE2A93B1--><OBUISEL_SELECTOR_FIELD>
<!--B951FE831F1B4F839A521A22CE2A93B1--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[B951FE831F1B4F839A521A22CE2A93B1]]></OBUISEL_SELECTOR_FIELD_ID>
<!--B951FE831F1B4F839A521A22CE2A93B1--> <OBUISEL_SELECTOR_ID><![CDATA[26BFCF47357E48C482CDE5B152F086BD]]></OBUISEL_SELECTOR_ID>
@@ -263,6 +417,28 @@
<!--CC993E93460940B28A11BE04D531A96B--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
<!--CC993E93460940B28A11BE04D531A96B--></OBUISEL_SELECTOR_FIELD>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--><OBUISEL_SELECTOR_FIELD>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[CD1D5B94C6EC42F7BFDC8D6F59CF1269]]></OBUISEL_SELECTOR_FIELD_ID>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <OBUISEL_SELECTOR_ID><![CDATA[0612DB85D07A46A8B0D34E2BCA8083B8]]></OBUISEL_SELECTOR_ID>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <AD_MODULE_ID><![CDATA[8542A34B0C6B4724A1D5C9B16B0BE028]]></AD_MODULE_ID>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <AD_COLUMN_ID><![CDATA[9C8C523F49F1BD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <NAME><![CDATA[Attribute Set Value]]></NAME>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <DESCRIPTION><![CDATA[An attribute associated with a product as part of an attribute set.]]></DESCRIPTION>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <HELP><![CDATA[The values of the actual Product Attributes]]></HELP>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <PROPERTY><![CDATA[attributeSetValue]]></PROPERTY>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <SORT><![CDATA[Y]]></SORT>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <FILTER><![CDATA[Y]]></FILTER>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <SORTNO><![CDATA[30]]></SORTNO>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--> <SHOWINPICKLIST><![CDATA[Y]]></SHOWINPICKLIST>
+<!--CD1D5B94C6EC42F7BFDC8D6F59CF1269--></OBUISEL_SELECTOR_FIELD>
+
<!--D846DD15F42D47D1B4C15789A23BF2B9--><OBUISEL_SELECTOR_FIELD>
<!--D846DD15F42D47D1B4C15789A23BF2B9--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[D846DD15F42D47D1B4C15789A23BF2B9]]></OBUISEL_SELECTOR_FIELD_ID>
<!--D846DD15F42D47D1B4C15789A23BF2B9--> <OBUISEL_SELECTOR_ID><![CDATA[0DD3FED00F354EBF96D1E59F10FE55E0]]></OBUISEL_SELECTOR_ID>
@@ -307,6 +483,28 @@
<!--E143951448534B61ACE1BDC17B24657B--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
<!--E143951448534B61ACE1BDC17B24657B--></OBUISEL_SELECTOR_FIELD>
+<!--E9364305D2554D149D1564DF1BCBC85F--><OBUISEL_SELECTOR_FIELD>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[E9364305D2554D149D1564DF1BCBC85F]]></OBUISEL_SELECTOR_FIELD_ID>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <OBUISEL_SELECTOR_ID><![CDATA[0612DB85D07A46A8B0D34E2BCA8083B8]]></OBUISEL_SELECTOR_ID>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <AD_MODULE_ID><![CDATA[8542A34B0C6B4724A1D5C9B16B0BE028]]></AD_MODULE_ID>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <AD_COLUMN_ID><![CDATA[9C8C523F49F2BD9DE040007F0100646F]]></AD_COLUMN_ID>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <NAME><![CDATA[Storage Bin]]></NAME>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <DESCRIPTION><![CDATA[A set of coordinates (x, y, z) which help locate an item in a warehouse.]]></DESCRIPTION>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <HELP><![CDATA[The Locator ID indicates where in a Warehouse a product is located.]]></HELP>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <PROPERTY><![CDATA[storageBin]]></PROPERTY>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <SORT><![CDATA[Y]]></SORT>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <FILTER><![CDATA[Y]]></FILTER>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <SORTNO><![CDATA[70]]></SORTNO>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD>
+<!--E9364305D2554D149D1564DF1BCBC85F--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
+<!--E9364305D2554D149D1564DF1BCBC85F--></OBUISEL_SELECTOR_FIELD>
+
<!--E9815827DCD142798F0394406669EC62--><OBUISEL_SELECTOR_FIELD>
<!--E9815827DCD142798F0394406669EC62--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[E9815827DCD142798F0394406669EC62]]></OBUISEL_SELECTOR_FIELD_ID>
<!--E9815827DCD142798F0394406669EC62--> <OBUISEL_SELECTOR_ID><![CDATA[26BFCF47357E48C482CDE5B152F086BD]]></OBUISEL_SELECTOR_ID>
@@ -329,6 +527,27 @@
<!--E9815827DCD142798F0394406669EC62--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
<!--E9815827DCD142798F0394406669EC62--></OBUISEL_SELECTOR_FIELD>
+<!--F689CA13280D487B843B75AD316AB1D3--><OBUISEL_SELECTOR_FIELD>
+<!--F689CA13280D487B843B75AD316AB1D3--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[F689CA13280D487B843B75AD316AB1D3]]></OBUISEL_SELECTOR_FIELD_ID>
+<!--F689CA13280D487B843B75AD316AB1D3--> <OBUISEL_SELECTOR_ID><![CDATA[0612DB85D07A46A8B0D34E2BCA8083B8]]></OBUISEL_SELECTOR_ID>
+<!--F689CA13280D487B843B75AD316AB1D3--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--F689CA13280D487B843B75AD316AB1D3--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--F689CA13280D487B843B75AD316AB1D3--> <AD_MODULE_ID><![CDATA[8542A34B0C6B4724A1D5C9B16B0BE028]]></AD_MODULE_ID>
+<!--F689CA13280D487B843B75AD316AB1D3--> <AD_COLUMN_ID><![CDATA[B24838F17F1F46CCA7091E97A1A92E19]]></AD_COLUMN_ID>
+<!--F689CA13280D487B843B75AD316AB1D3--> <NAME><![CDATA[Referenced Inventory]]></NAME>
+<!--F689CA13280D487B843B75AD316AB1D3--> <HELP><![CDATA[ID for a Referenced Inventory]]></HELP>
+<!--F689CA13280D487B843B75AD316AB1D3--> <PROPERTY><![CDATA[referencedInventory]]></PROPERTY>
+<!--F689CA13280D487B843B75AD316AB1D3--> <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--F689CA13280D487B843B75AD316AB1D3--> <SORT><![CDATA[Y]]></SORT>
+<!--F689CA13280D487B843B75AD316AB1D3--> <FILTER><![CDATA[Y]]></FILTER>
+<!--F689CA13280D487B843B75AD316AB1D3--> <SEARCHINSUGGESTIONBOX><![CDATA[N]]></SEARCHINSUGGESTIONBOX>
+<!--F689CA13280D487B843B75AD316AB1D3--> <SHOWINGRID><![CDATA[Y]]></SHOWINGRID>
+<!--F689CA13280D487B843B75AD316AB1D3--> <SORTNO><![CDATA[80]]></SORTNO>
+<!--F689CA13280D487B843B75AD316AB1D3--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--F689CA13280D487B843B75AD316AB1D3--> <ISOUTFIELD><![CDATA[N]]></ISOUTFIELD>
+<!--F689CA13280D487B843B75AD316AB1D3--> <SHOWINPICKLIST><![CDATA[N]]></SHOWINPICKLIST>
+<!--F689CA13280D487B843B75AD316AB1D3--></OBUISEL_SELECTOR_FIELD>
+
<!--F9190C7A0EE64F0BB07DE06A8556117E--><OBUISEL_SELECTOR_FIELD>
<!--F9190C7A0EE64F0BB07DE06A8556117E--> <OBUISEL_SELECTOR_FIELD_ID><![CDATA[F9190C7A0EE64F0BB07DE06A8556117E]]></OBUISEL_SELECTOR_FIELD_ID>
<!--F9190C7A0EE64F0BB07DE06A8556117E--> <OBUISEL_SELECTOR_ID><![CDATA[A1367535DC8C405792697195EC8F4294]]></OBUISEL_SELECTOR_ID>
diff --git a/src/org/openbravo/distributionorder/info/ProductWithStockSelectorFilterExpression.java b/src/org/openbravo/distributionorder/info/ProductWithStockSelectorFilterExpression.java
new file mode 100644
--- /dev/null
+++ b/src/org/openbravo/distributionorder/info/ProductWithStockSelectorFilterExpression.java
@@ -0,0 +1,54 @@
+/*
+ *************************************************************************
+ * 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) 2018 Openbravo SLU
+ * All Rights Reserved.
+ * Contributor(s): ______________________________________.
+ *************************************************************************
+ */
+
+package org.openbravo.distributionorder.info;
+
+import java.util.Map;
+
+import org.openbravo.client.application.FilterExpression;
+import org.openbravo.dal.core.OBContext;
+
+public class ProductWithStockSelectorFilterExpression implements FilterExpression {
+
+ @Override
+ public String getExpression(Map<String, String> requestMap) {
+ String warehouseReceiptID = requestMap.get("inpmWarehouseReceiptId");
+ boolean isSalesTransaction = Boolean.parseBoolean(requestMap.get("inpissotrx"));
+ String warehouseIssueID = requestMap.get("inpmWarehouseIssueId");
+
+ StringBuilder filter = getFilterByClientAndItemAndStockedNotGenericProducts();
+ if (isSalesTransaction) {
+ filter.append(" and (e.warehouse is null or e.warehouse.id ='" + warehouseIssueID + "')");
+ } else {
+ filter.append(" and (e.warehouse is null or e.warehouse.id ='" + warehouseReceiptID + "')");
+ }
+ return filter.toString();
+ }
+
+ private StringBuilder getFilterByClientAndItemAndStockedNotGenericProducts() {
+ StringBuilder filter = new StringBuilder("");
+ filter.append(" e.product.active = 'Y' ");
+ filter.append(" and e.product.isGeneric = 'N'");
+ filter.append(" and e.product.productType = 'I' ");
+ filter.append(" and e.product.stocked = 'Y'");
+ filter.append(" and e.product.client.id = '"
+ + OBContext.getOBContext().getCurrentClient().getId() + "'");
+ return filter;
+ }
+}
|