[Product Locked/Discontinued] Addig new field 'isDiscontinued'
authorOsmany Garcia Machado <osmany.machado@peoplewalking.com>
Tue, 22 Mar 2016 14:54:32 -0600
changeset 29009 3fe2f543bb38
parent 29008 1d2e7309671b
child 29010 49b5c066860d
[Product Locked/Discontinued] Addig new field 'isDiscontinued'
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	Thu Mar 17 15:02:29 2016 -0600
+++ b/src-db/database/model/tables/M_PRODUCT.xml	Tue Mar 22 14:54:32 2016 -0600
@@ -409,6 +409,10 @@
         <default><![CDATA[N]]></default>
         <onCreateDefault/>
       </column>
+      <column name="ISSALEDISCONTINUED" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
+        <default><![CDATA[N]]></default>
+        <onCreateDefault/>
+      </column>
       <foreign-key foreignTable="AD_ORG" name="AD_ORG_MPRODUCT">
         <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
       </foreign-key>
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Thu Mar 17 15:02:29 2016 -0600
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Tue Mar 22 14:54:32 2016 -0600
@@ -324916,6 +324916,42 @@
 <!--A07A72989B5011DDBDC300014A62838F-->  <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING>
 <!--A07A72989B5011DDBDC300014A62838F--></AD_COLUMN>
 
+<!--A07BE141EA8F449C8BE288276E0D6D56--><AD_COLUMN>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <AD_COLUMN_ID><![CDATA[A07BE141EA8F449C8BE288276E0D6D56]]></AD_COLUMN_ID>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <NAME><![CDATA[Issalediscontinued]]></NAME>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <COLUMNNAME><![CDATA[Issalediscontinued]]></COLUMNNAME>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <AD_TABLE_ID><![CDATA[208]]></AD_TABLE_ID>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <DEFAULTVALUE><![CDATA[N]]></DEFAULTVALUE>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <SEQNO><![CDATA[840]]></SEQNO>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <AD_ELEMENT_ID><![CDATA[ED2C3271AF604A288963A04AB5BB078C]]></AD_ELEMENT_ID>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <POSITION><![CDATA[111]]></POSITION>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING>
+<!--A07BE141EA8F449C8BE288276E0D6D56-->  <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING>
+<!--A07BE141EA8F449C8BE288276E0D6D56--></AD_COLUMN>
+
 <!--A0895BE15FC84F7CA2BD4D6B51D8BFD1--><AD_COLUMN>
 <!--A0895BE15FC84F7CA2BD4D6B51D8BFD1-->  <AD_COLUMN_ID><![CDATA[A0895BE15FC84F7CA2BD4D6B51D8BFD1]]></AD_COLUMN_ID>
 <!--A0895BE15FC84F7CA2BD4D6B51D8BFD1-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Thu Mar 17 15:02:29 2016 -0600
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Tue Mar 22 14:54:32 2016 -0600
@@ -34030,6 +34030,20 @@
 <!--ECAC136184A746C39804BD71BC3C78DB-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--ECAC136184A746C39804BD71BC3C78DB--></AD_ELEMENT>
 
+<!--ED2C3271AF604A288963A04AB5BB078C--><AD_ELEMENT>
+<!--ED2C3271AF604A288963A04AB5BB078C-->  <AD_ELEMENT_ID><![CDATA[ED2C3271AF604A288963A04AB5BB078C]]></AD_ELEMENT_ID>
+<!--ED2C3271AF604A288963A04AB5BB078C-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--ED2C3271AF604A288963A04AB5BB078C-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--ED2C3271AF604A288963A04AB5BB078C-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--ED2C3271AF604A288963A04AB5BB078C-->  <COLUMNNAME><![CDATA[Issalediscontinued]]></COLUMNNAME>
+<!--ED2C3271AF604A288963A04AB5BB078C-->  <NAME><![CDATA[Is Discontinued]]></NAME>
+<!--ED2C3271AF604A288963A04AB5BB078C-->  <PRINTNAME><![CDATA[Is Discontinued]]></PRINTNAME>
+<!--ED2C3271AF604A288963A04AB5BB078C-->  <DESCRIPTION><![CDATA[A statement mentioning that this product will no longer be available on the market.]]></DESCRIPTION>
+<!--ED2C3271AF604A288963A04AB5BB078C-->  <HELP><![CDATA[The Discontinued check box indicates a product that has been discontinued.]]></HELP>
+<!--ED2C3271AF604A288963A04AB5BB078C-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--ED2C3271AF604A288963A04AB5BB078C-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--ED2C3271AF604A288963A04AB5BB078C--></AD_ELEMENT>
+
 <!--ED51BE55711947E18F566818EC704CAB--><AD_ELEMENT>
 <!--ED51BE55711947E18F566818EC704CAB-->  <AD_ELEMENT_ID><![CDATA[ED51BE55711947E18F566818EC704CAB]]></AD_ELEMENT_ID>
 <!--ED51BE55711947E18F566818EC704CAB-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Thu Mar 17 15:02:29 2016 -0600
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Tue Mar 22 14:54:32 2016 -0600
@@ -259314,6 +259314,32 @@
 <!--9BAC7BA6402349F8A61278B294455995-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--9BAC7BA6402349F8A61278B294455995--></AD_FIELD>
 
+<!--9BB870215141401B985071094B6E1F44--><AD_FIELD>
+<!--9BB870215141401B985071094B6E1F44-->  <AD_FIELD_ID><![CDATA[9BB870215141401B985071094B6E1F44]]></AD_FIELD_ID>
+<!--9BB870215141401B985071094B6E1F44-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--9BB870215141401B985071094B6E1F44-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--9BB870215141401B985071094B6E1F44-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--9BB870215141401B985071094B6E1F44-->  <NAME><![CDATA[Is Discontinued]]></NAME>
+<!--9BB870215141401B985071094B6E1F44-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--9BB870215141401B985071094B6E1F44-->  <AD_TAB_ID><![CDATA[180]]></AD_TAB_ID>
+<!--9BB870215141401B985071094B6E1F44-->  <AD_COLUMN_ID><![CDATA[A07BE141EA8F449C8BE288276E0D6D56]]></AD_COLUMN_ID>
+<!--9BB870215141401B985071094B6E1F44-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--9BB870215141401B985071094B6E1F44-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--9BB870215141401B985071094B6E1F44-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--9BB870215141401B985071094B6E1F44-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--9BB870215141401B985071094B6E1F44-->  <SEQNO><![CDATA[1420]]></SEQNO>
+<!--9BB870215141401B985071094B6E1F44-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--9BB870215141401B985071094B6E1F44-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--9BB870215141401B985071094B6E1F44-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--9BB870215141401B985071094B6E1F44-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--9BB870215141401B985071094B6E1F44-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--9BB870215141401B985071094B6E1F44-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--9BB870215141401B985071094B6E1F44-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--9BB870215141401B985071094B6E1F44-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--9BB870215141401B985071094B6E1F44-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--9BB870215141401B985071094B6E1F44-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--9BB870215141401B985071094B6E1F44--></AD_FIELD>
+
 <!--9BD9B98ED54E43F7B357097799E9A2C6--><AD_FIELD>
 <!--9BD9B98ED54E43F7B357097799E9A2C6-->  <AD_FIELD_ID><![CDATA[9BD9B98ED54E43F7B357097799E9A2C6]]></AD_FIELD_ID>
 <!--9BD9B98ED54E43F7B357097799E9A2C6-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>