Issue 11513 Added 'Attribute Set Value Required' check-box field to Product window.
authorRafa Roda Palacios <rafael.roda@openbravo.com>
Thu, 28 Jan 2010 00:55:50 +0100
changeset 6080 82a53e088c45
parent 5890 ad62f64f097e
child 6081 8c8099881972
Issue 11513 Added 'Attribute Set Value Required' check-box field to Product window.
src-db/database/model/tables/M_PRODUCT.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_ELEMENT.xml
src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/model/tables/M_PRODUCT.xml	Sun Jan 17 18:53:10 2010 +0100
+++ b/src-db/database/model/tables/M_PRODUCT.xml	Thu Jan 28 00:55:50 2010 +0100
@@ -277,6 +277,10 @@
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="ISATTRSETVALUEREQUIRED" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA[Y]]></default>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_ORG" name="AD_ORG_MPRODUCT">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
@@ -353,6 +357,7 @@
       <check name="M_PRODUCT_DISCONTINUED_CHECK"><![CDATA[DISCONTINUED IN ('Y', 'N')]]></check>
       <check name="M_PRODUCT_ENFORCE_ATTRIBUT_CHK"><![CDATA[ENFORCE_ATTRIBUTE IN ('Y', 'N')]]></check>
       <check name="M_PRODUCT_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
+      <check name="M_PRODUCT_ISATTRSETVALREQ_CHK"><![CDATA[ISATTRSETVALUEREQUIRED IN ('Y', 'N')]]></check>
       <check name="M_PRODUCT_ISBOM_CHECK"><![CDATA[ISBOM IN ('Y', 'N')]]></check>
       <check name="M_PRODUCT_ISINVOICEPRINTDE_CHK"><![CDATA[ISINVOICEPRINTDETAILS IN ('Y', 'N')]]></check>
       <check name="M_PRODUCT_ISPICKLISTPRINTD_CHK"><![CDATA[ISPICKLISTPRINTDETAILS IN ('Y', 'N')]]></check>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Sun Jan 17 18:53:10 2010 +0100
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Thu Jan 28 00:55:50 2010 +0100
@@ -122708,7 +122708,7 @@
 <!--8417-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
 <!--8417-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
 <!--8417-->  <AD_ELEMENT_ID><![CDATA[2017]]></AD_ELEMENT_ID>
-<!--8417-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--8417-->  <ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
 <!--8417-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
 <!--8417-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
 <!--8417-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
@@ -267306,6 +267306,38 @@
 <!--7AD1D1A49C5D11DD9476001B388C05F0-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
 <!--7AD1D1A49C5D11DD9476001B388C05F0--></AD_COLUMN>
 
+<!--7DCE0AE47CCC4ADCE040007F01010472--><AD_COLUMN>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <AD_COLUMN_ID><![CDATA[7DCE0AE47CCC4ADCE040007F01010472]]></AD_COLUMN_ID>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <NAME><![CDATA[Attribute Set Value Required]]></NAME>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <DESCRIPTION><![CDATA[A flag indicating whether the attribute set value will be required in the transactions or not.]]></DESCRIPTION>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <HELP><![CDATA[Transactions which require an attribute set value to be completed base this check in the Attribute Set Value Required field value. ]]></HELP>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <COLUMNNAME><![CDATA[Isattrsetvaluerequired]]></COLUMNNAME>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <AD_TABLE_ID><![CDATA[208]]></AD_TABLE_ID>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <DEFAULTVALUE><![CDATA[Y]]></DEFAULTVALUE>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <SEQNO><![CDATA[310]]></SEQNO>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <AD_ELEMENT_ID><![CDATA[7DCE1D3E70E58BBEE040007F01010456]]></AD_ELEMENT_ID>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <POSITION><![CDATA[70]]></POSITION>
+<!--7DCE0AE47CCC4ADCE040007F01010472-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--7DCE0AE47CCC4ADCE040007F01010472--></AD_COLUMN>
+
 <!--7E32BAEA996311DDA0B6001D09C4A2FE--><AD_COLUMN>
 <!--7E32BAEA996311DDA0B6001D09C4A2FE-->  <AD_COLUMN_ID><![CDATA[7E32BAEA996311DDA0B6001D09C4A2FE]]></AD_COLUMN_ID>
 <!--7E32BAEA996311DDA0B6001D09C4A2FE-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Sun Jan 17 18:53:10 2010 +0100
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Thu Jan 28 00:55:50 2010 +0100
@@ -24867,6 +24867,19 @@
 <!--7C152B5C9EBC4E74B75C469A8A473D34-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--7C152B5C9EBC4E74B75C469A8A473D34--></AD_ELEMENT>
 
+<!--7DCE1D3E70E58BBEE040007F01010456--><AD_ELEMENT>
+<!--7DCE1D3E70E58BBEE040007F01010456-->  <AD_ELEMENT_ID><![CDATA[7DCE1D3E70E58BBEE040007F01010456]]></AD_ELEMENT_ID>
+<!--7DCE1D3E70E58BBEE040007F01010456-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7DCE1D3E70E58BBEE040007F01010456-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7DCE1D3E70E58BBEE040007F01010456-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7DCE1D3E70E58BBEE040007F01010456-->  <COLUMNNAME><![CDATA[Isattrsetvaluerequired]]></COLUMNNAME>
+<!--7DCE1D3E70E58BBEE040007F01010456-->  <NAME><![CDATA[Attribute Set Value Required]]></NAME>
+<!--7DCE1D3E70E58BBEE040007F01010456-->  <PRINTNAME><![CDATA[Attribute Set Value Required]]></PRINTNAME>
+<!--7DCE1D3E70E58BBEE040007F01010456-->  <DESCRIPTION><![CDATA[A flag indicating whether the attribute set value will be required in the transactions or not.]]></DESCRIPTION>
+<!--7DCE1D3E70E58BBEE040007F01010456-->  <HELP><![CDATA[Transactions which require an attribute set value to be completed base this check in the Attribute Set Value Required field value. ]]></HELP>
+<!--7DCE1D3E70E58BBEE040007F01010456-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--7DCE1D3E70E58BBEE040007F01010456--></AD_ELEMENT>
+
 <!--80044AA0505611DEBC12001CC0B8EF99--><AD_ELEMENT>
 <!--80044AA0505611DEBC12001CC0B8EF99-->  <AD_ELEMENT_ID><![CDATA[80044AA0505611DEBC12001CC0B8EF99]]></AD_ELEMENT_ID>
 <!--80044AA0505611DEBC12001CC0B8EF99-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Sun Jan 17 18:53:10 2010 +0100
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Thu Jan 28 00:55:50 2010 +0100
@@ -126828,7 +126828,7 @@
 <!--801030-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--801030-->  <DISPLAYLENGTH><![CDATA[21]]></DISPLAYLENGTH>
 <!--801030-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--801030-->  <SEQNO><![CDATA[410]]></SEQNO>
+<!--801030-->  <SEQNO><![CDATA[420]]></SEQNO>
 <!--801030-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
 <!--801030-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--801030-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -126849,7 +126849,7 @@
 <!--801031-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
 <!--801031-->  <DISPLAYLENGTH><![CDATA[6]]></DISPLAYLENGTH>
 <!--801031-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
-<!--801031-->  <SEQNO><![CDATA[420]]></SEQNO>
+<!--801031-->  <SEQNO><![CDATA[430]]></SEQNO>
 <!--801031-->  <ISSAMELINE><![CDATA[Y]]></ISSAMELINE>
 <!--801031-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
 <!--801031-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
@@ -192614,6 +192614,30 @@
 <!--7CB8CB38E8A911DDAD520016D4EE9DB3-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--7CB8CB38E8A911DDAD520016D4EE9DB3--></AD_FIELD>
 
+<!--7DCE1D3E70E98BBEE040007F01010456--><AD_FIELD>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <AD_FIELD_ID><![CDATA[7DCE1D3E70E98BBEE040007F01010456]]></AD_FIELD_ID>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <NAME><![CDATA[Attribute Set Value Required]]></NAME>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <DESCRIPTION><![CDATA[A flag indicating whether the attribute set value will be required in the transactions or not.]]></DESCRIPTION>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <HELP><![CDATA[Transactions which require an attribute set value to be completed base this check in the Attribute Set Value Required field value. ]]></HELP>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <AD_TAB_ID><![CDATA[180]]></AD_TAB_ID>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <AD_COLUMN_ID><![CDATA[7DCE0AE47CCC4ADCE040007F01010472]]></AD_COLUMN_ID>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <DISPLAYLOGIC><![CDATA[@M_AttributeSet_ID@!'']]></DISPLAYLOGIC>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <SEQNO><![CDATA[410]]></SEQNO>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--7DCE1D3E70E98BBEE040007F01010456-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--7DCE1D3E70E98BBEE040007F01010456--></AD_FIELD>
+
 <!--80C65FD7819B43638FB4A0413A91A65D--><AD_FIELD>
 <!--80C65FD7819B43638FB4A0413A91A65D-->  <AD_FIELD_ID><![CDATA[80C65FD7819B43638FB4A0413A91A65D]]></AD_FIELD_ID>
 <!--80C65FD7819B43638FB4A0413A91A65D-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>