[Product Locked/Discontinued] Addig new field 'isLocked'
authorOsmany Garcia Machado <osmany.machado@peoplewalking.com>
Thu, 17 Mar 2016 15:02:29 -0600
changeset 29008 1d2e7309671b
parent 28951 8f4273ae4ccd
child 29009 3fe2f543bb38
[Product Locked/Discontinued] Addig new field 'isLocked'
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 09:53:43 2016 +0000
+++ b/src-db/database/model/tables/M_PRODUCT.xml	Thu Mar 17 15:02:29 2016 -0600
@@ -405,6 +405,10 @@
         <default/>
         <onCreateDefault/>
       </column>
+      <column name="ISLOCKED" 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 09:53:43 2016 +0000
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Thu Mar 17 15:02:29 2016 -0600
@@ -241683,6 +241683,42 @@
 <!--141F54DBCEDE4F18BC55A8B30220745E-->  <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING>
 <!--141F54DBCEDE4F18BC55A8B30220745E--></AD_COLUMN>
 
+<!--144504467AAF4239AE435F3D867341AB--><AD_COLUMN>
+<!--144504467AAF4239AE435F3D867341AB-->  <AD_COLUMN_ID><![CDATA[144504467AAF4239AE435F3D867341AB]]></AD_COLUMN_ID>
+<!--144504467AAF4239AE435F3D867341AB-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--144504467AAF4239AE435F3D867341AB-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--144504467AAF4239AE435F3D867341AB-->  <NAME><![CDATA[Islocked]]></NAME>
+<!--144504467AAF4239AE435F3D867341AB-->  <COLUMNNAME><![CDATA[Islocked]]></COLUMNNAME>
+<!--144504467AAF4239AE435F3D867341AB-->  <AD_TABLE_ID><![CDATA[208]]></AD_TABLE_ID>
+<!--144504467AAF4239AE435F3D867341AB-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
+<!--144504467AAF4239AE435F3D867341AB-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
+<!--144504467AAF4239AE435F3D867341AB-->  <DEFAULTVALUE><![CDATA[N]]></DEFAULTVALUE>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--144504467AAF4239AE435F3D867341AB-->  <SEQNO><![CDATA[830]]></SEQNO>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--144504467AAF4239AE435F3D867341AB-->  <AD_ELEMENT_ID><![CDATA[0DC2A64ABEB34DA5A7180687B56197F4]]></AD_ELEMENT_ID>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--144504467AAF4239AE435F3D867341AB-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--144504467AAF4239AE435F3D867341AB-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--144504467AAF4239AE435F3D867341AB-->  <POSITION><![CDATA[126]]></POSITION>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--144504467AAF4239AE435F3D867341AB-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--144504467AAF4239AE435F3D867341AB-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--144504467AAF4239AE435F3D867341AB-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--144504467AAF4239AE435F3D867341AB-->  <ALLOWSORTING><![CDATA[Y]]></ALLOWSORTING>
+<!--144504467AAF4239AE435F3D867341AB-->  <ALLOWFILTERING><![CDATA[Y]]></ALLOWFILTERING>
+<!--144504467AAF4239AE435F3D867341AB--></AD_COLUMN>
+
 <!--14561DD2B91C4C2191931AC7C8C49579--><AD_COLUMN>
 <!--14561DD2B91C4C2191931AC7C8C49579-->  <AD_COLUMN_ID><![CDATA[14561DD2B91C4C2191931AC7C8C49579]]></AD_COLUMN_ID>
 <!--14561DD2B91C4C2191931AC7C8C49579-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_ELEMENT.xml	Thu Mar 17 09:53:43 2016 +0000
+++ b/src-db/database/sourcedata/AD_ELEMENT.xml	Thu Mar 17 15:02:29 2016 -0600
@@ -21282,6 +21282,18 @@
 <!--0D1F9C2D797C49A7AA476A3047DC075A-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
 <!--0D1F9C2D797C49A7AA476A3047DC075A--></AD_ELEMENT>
 
+<!--0DC2A64ABEB34DA5A7180687B56197F4--><AD_ELEMENT>
+<!--0DC2A64ABEB34DA5A7180687B56197F4-->  <AD_ELEMENT_ID><![CDATA[0DC2A64ABEB34DA5A7180687B56197F4]]></AD_ELEMENT_ID>
+<!--0DC2A64ABEB34DA5A7180687B56197F4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--0DC2A64ABEB34DA5A7180687B56197F4-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--0DC2A64ABEB34DA5A7180687B56197F4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--0DC2A64ABEB34DA5A7180687B56197F4-->  <COLUMNNAME><![CDATA[Islocked]]></COLUMNNAME>
+<!--0DC2A64ABEB34DA5A7180687B56197F4-->  <NAME><![CDATA[Is Locked]]></NAME>
+<!--0DC2A64ABEB34DA5A7180687B56197F4-->  <PRINTNAME><![CDATA[Is Locked]]></PRINTNAME>
+<!--0DC2A64ABEB34DA5A7180687B56197F4-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--0DC2A64ABEB34DA5A7180687B56197F4-->  <ISGLOSSARY><![CDATA[N]]></ISGLOSSARY>
+<!--0DC2A64ABEB34DA5A7180687B56197F4--></AD_ELEMENT>
+
 <!--0DCA4840773E45198061B6F1E5F22841--><AD_ELEMENT>
 <!--0DCA4840773E45198061B6F1E5F22841-->  <AD_ELEMENT_ID><![CDATA[0DCA4840773E45198061B6F1E5F22841]]></AD_ELEMENT_ID>
 <!--0DCA4840773E45198061B6F1E5F22841-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_FIELD.xml	Thu Mar 17 09:53:43 2016 +0000
+++ b/src-db/database/sourcedata/AD_FIELD.xml	Thu Mar 17 15:02:29 2016 -0600
@@ -292249,6 +292249,32 @@
 <!--D165BBBE0F3E4EE9BDE264D5E8FE6903-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--D165BBBE0F3E4EE9BDE264D5E8FE6903--></AD_FIELD>
 
+<!--D16604DCA24A428C9C40F67BD116B234--><AD_FIELD>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <AD_FIELD_ID><![CDATA[D16604DCA24A428C9C40F67BD116B234]]></AD_FIELD_ID>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <NAME><![CDATA[Is Locked]]></NAME>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <AD_TAB_ID><![CDATA[180]]></AD_TAB_ID>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <AD_COLUMN_ID><![CDATA[144504467AAF4239AE435F3D867341AB]]></AD_COLUMN_ID>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <IGNOREINWAD><![CDATA[N]]></IGNOREINWAD>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <SEQNO><![CDATA[1410]]></SEQNO>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <SHOWINRELATION><![CDATA[N]]></SHOWINRELATION>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--D16604DCA24A428C9C40F67BD116B234-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--D16604DCA24A428C9C40F67BD116B234--></AD_FIELD>
+
 <!--D16BDA21D4824DF7BC9760FD5B24455B--><AD_FIELD>
 <!--D16BDA21D4824DF7BC9760FD5B24455B-->  <AD_FIELD_ID><![CDATA[D16BDA21D4824DF7BC9760FD5B24455B]]></AD_FIELD_ID>
 <!--D16BDA21D4824DF7BC9760FD5B24455B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>