Commits

hengsin committed c67ce9d Merge

Merge with 226388bdba1e6652da9bad68680987523fc10267 ( iDempiere Head )

Comments (0)

Files changed (124)

migration/360lts-release/oracle/835_IDEMPIERE-195_MenuAutoExpand.sql

+-- Apr 12, 2012 11:08:20 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Element (AD_Client_ID,AD_Element_ID,AD_Org_ID,ColumnName,Created,CreatedBy,Description,EntityType,IsActive,Name,PrintName,Updated,UpdatedBy) VALUES (0,200023,0,'IsMenuAutoExpand',TO_DATE('2012-04-12 11:08:19','YYYY-MM-DD HH24:MI:SS'),100,'If ticked, the menu is automatically expanded','D','Y','Auto expand menu','Auto expand menu',TO_DATE('2012-04-12 11:08:19','YYYY-MM-DD HH24:MI:SS'),100)
+;
+
+-- Apr 12, 2012 11:08:21 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Element_Trl (AD_Language,AD_Element_ID, Description,Help,Name,PO_Description,PO_Help,PO_Name,PO_PrintName,PrintName, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Element_ID, t.Description,t.Help,t.Name,t.PO_Description,t.PO_Help,t.PO_Name,t.PO_PrintName,t.PrintName, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Element t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Element_ID=200023 AND NOT EXISTS (SELECT * FROM AD_Element_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Element_ID=t.AD_Element_ID)
+;
+
+-- Apr 12, 2012 11:09:31 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Column (AD_Client_ID,AD_Column_ID,AD_Element_ID,AD_Org_ID,AD_Reference_ID,AD_Table_ID,ColumnName,Created,CreatedBy,DefaultValue,Description,EntityType,FieldLength,IsActive,IsAllowCopy,IsAllowLogging,IsAlwaysUpdateable,IsAutocomplete,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,200112,200023,0,20,156,'IsMenuAutoExpand',TO_DATE('2012-04-12 11:09:31','YYYY-MM-DD HH24:MI:SS'),100,'N','If ticked, the menu is automatically expanded','D',1,'Y','Y','Y','N','N','N','N','N','Y','N','N','N','N','Y','Auto expand menu',0,TO_DATE('2012-04-12 11:09:31','YYYY-MM-DD HH24:MI:SS'),100,0)
+;
+
+-- Apr 12, 2012 11:09:31 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Column_Trl (AD_Language,AD_Column_ID, Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Column_ID, t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Column t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Column_ID=200112 AND NOT EXISTS (SELECT * FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
+;
+
+-- Apr 12, 2012 11:09:41 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+ALTER TABLE AD_Role ADD IsMenuAutoExpand CHAR(1) DEFAULT 'N' CHECK (IsMenuAutoExpand IN ('Y','N')) NOT NULL
+;
+
+-- Apr 12, 2012 11:10:42 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,IsActive,IsCentrallyMaintained,IsDisplayed,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,SeqNo,SortNo,Updated,UpdatedBy) VALUES (0,200112,200071,0,119,TO_DATE('2012-04-12 11:10:41','YYYY-MM-DD HH24:MI:SS'),100,'If ticked, the menu is automatically expanded',0,'D','Y','Y','Y','N','N','N','N','N','Auto expand menu',430,0,TO_DATE('2012-04-12 11:10:41','YYYY-MM-DD HH24:MI:SS'),100)
+;
+
+-- Apr 12, 2012 11:10:42 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Field_Trl (AD_Language,AD_Field_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Field_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Field t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Field_ID=200071 AND NOT EXISTS (SELECT * FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=300,IsDisplayed='Y' WHERE AD_Field_ID=200071
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=310,IsDisplayed='Y' WHERE AD_Field_ID=50168
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=320,IsDisplayed='Y' WHERE AD_Field_ID=50169
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=330,IsDisplayed='Y' WHERE AD_Field_ID=50170
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=340,IsDisplayed='Y' WHERE AD_Field_ID=50171
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=350,IsDisplayed='Y' WHERE AD_Field_ID=50172
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=360,IsDisplayed='Y' WHERE AD_Field_ID=50173
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=370,IsDisplayed='Y' WHERE AD_Field_ID=50174
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=380,IsDisplayed='Y' WHERE AD_Field_ID=50175
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=390,IsDisplayed='Y' WHERE AD_Field_ID=50176
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=400,IsDisplayed='Y' WHERE AD_Field_ID=50177
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=410,IsDisplayed='Y' WHERE AD_Field_ID=50178
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=420,IsDisplayed='Y' WHERE AD_Field_ID=55432
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=430,IsDisplayed='Y' WHERE AD_Field_ID=55433
+;
+
+-- Apr 12, 2012 11:12:28 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Column (AD_Client_ID,AD_Column_ID,AD_Element_ID,AD_Org_ID,AD_Reference_ID,AD_Table_ID,ColumnName,Created,CreatedBy,DefaultValue,Description,EntityType,FieldLength,IsActive,IsAllowCopy,IsAllowLogging,IsAlwaysUpdateable,IsAutocomplete,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,200113,200023,0,20,114,'IsMenuAutoExpand',TO_DATE('2012-04-12 11:12:27','YYYY-MM-DD HH24:MI:SS'),100,'N','If ticked, the menu is automatically expanded','D',1,'Y','Y','Y','N','N','N','N','N','Y','N','N','N','N','Y','Auto expand menu',0,TO_DATE('2012-04-12 11:12:27','YYYY-MM-DD HH24:MI:SS'),100,0)
+;
+
+-- Apr 12, 2012 11:12:28 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Column_Trl (AD_Language,AD_Column_ID, Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Column_ID, t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Column t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Column_ID=200113 AND NOT EXISTS (SELECT * FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
+;
+
+-- Apr 12, 2012 11:12:29 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+ALTER TABLE AD_User ADD IsMenuAutoExpand CHAR(1) DEFAULT 'N' CHECK (IsMenuAutoExpand IN ('Y','N')) NOT NULL
+;
+
+-- Apr 12, 2012 11:13:08 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,IsActive,IsCentrallyMaintained,IsDisplayed,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,SeqNo,SortNo,Updated,UpdatedBy) VALUES (0,200113,200072,0,118,TO_DATE('2012-04-12 11:13:07','YYYY-MM-DD HH24:MI:SS'),100,'If ticked, the menu is automatically expanded',0,'D','Y','Y','Y','N','N','N','N','N','Auto expand menu',310,0,TO_DATE('2012-04-12 11:13:07','YYYY-MM-DD HH24:MI:SS'),100)
+;
+
+-- Apr 12, 2012 11:13:08 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Field_Trl (AD_Language,AD_Field_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Field_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Field t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Field_ID=200072 AND NOT EXISTS (SELECT * FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=130,IsDisplayed='Y' WHERE AD_Field_ID=52010
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=140,IsDisplayed='Y' WHERE AD_Field_ID=6515
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=150,IsDisplayed='Y' WHERE AD_Field_ID=6517
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=160,IsDisplayed='Y' WHERE AD_Field_ID=6514
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=170,IsDisplayed='Y' WHERE AD_Field_ID=6518
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=180,IsDisplayed='Y' WHERE AD_Field_ID=11679
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=190,IsDisplayed='Y' WHERE AD_Field_ID=12324
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=200,IsDisplayed='Y' WHERE AD_Field_ID=12323
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=210,IsDisplayed='Y' WHERE AD_Field_ID=5883
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=220,IsDisplayed='Y' WHERE AD_Field_ID=5884
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=230,IsDisplayed='Y' WHERE AD_Field_ID=4261
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=240,IsDisplayed='Y' WHERE AD_Field_ID=10491
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=250,IsDisplayed='Y' WHERE AD_Field_ID=6511
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=260,IsDisplayed='Y' WHERE AD_Field_ID=12640
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=270,IsDisplayed='Y' WHERE AD_Field_ID=200072
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=280,IsDisplayed='Y' WHERE AD_Field_ID=6513
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=290,IsDisplayed='Y' WHERE AD_Field_ID=11525
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=300,IsDisplayed='Y' WHERE AD_Field_ID=6520
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=310,IsDisplayed='Y' WHERE AD_Field_ID=8342
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=320,IsDisplayed='Y' WHERE AD_Field_ID=6519
+;
+
+-- Apr 12, 2012 11:13:47 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,IsActive,IsCentrallyMaintained,IsDisplayed,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,SeqNo,SortNo,Updated,UpdatedBy) VALUES (0,200113,200073,0,53282,TO_DATE('2012-04-12 11:13:46','YYYY-MM-DD HH24:MI:SS'),100,'If ticked, the menu is automatically expanded',0,'D','Y','Y','Y','N','N','N','N','N','Auto expand menu',310,0,TO_DATE('2012-04-12 11:13:46','YYYY-MM-DD HH24:MI:SS'),100)
+;
+
+-- Apr 12, 2012 11:13:47 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Field_Trl (AD_Language,AD_Field_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Field_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Field t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Field_ID=200073 AND NOT EXISTS (SELECT * FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=130,IsDisplayed='Y' WHERE AD_Field_ID=57995
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=140,IsDisplayed='Y' WHERE AD_Field_ID=57997
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=150,IsDisplayed='Y' WHERE AD_Field_ID=57998
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=160,IsDisplayed='Y' WHERE AD_Field_ID=57999
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=170,IsDisplayed='Y' WHERE AD_Field_ID=58000
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=180,IsDisplayed='Y' WHERE AD_Field_ID=58001
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=190,IsDisplayed='Y' WHERE AD_Field_ID=58002
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=200,IsDisplayed='Y' WHERE AD_Field_ID=58003
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=210,IsDisplayed='Y' WHERE AD_Field_ID=58004
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=220,IsDisplayed='Y' WHERE AD_Field_ID=58005
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=230,IsDisplayed='Y' WHERE AD_Field_ID=58006
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=240,IsDisplayed='Y' WHERE AD_Field_ID=58007
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=250,IsDisplayed='Y' WHERE AD_Field_ID=58008
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=260,IsDisplayed='Y' WHERE AD_Field_ID=58009
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=270,IsDisplayed='Y' WHERE AD_Field_ID=200073
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=280,IsDisplayed='Y' WHERE AD_Field_ID=58010
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=290,IsDisplayed='Y' WHERE AD_Field_ID=58011
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=300,IsDisplayed='Y' WHERE AD_Field_ID=58012
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=310,IsDisplayed='Y' WHERE AD_Field_ID=58013
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=320,IsDisplayed='Y' WHERE AD_Field_ID=58014
+;
+
+UPDATE AD_System
+  SET LastMigrationScriptApplied='835_IDEMPIERE-195_MenuAutoExpand.sql'
+WHERE LastMigrationScriptApplied<'835_IDEMPIERE-195_MenuAutoExpand.sql'
+   OR LastMigrationScriptApplied IS NULL
+;

migration/360lts-release/oracle/836_IDEMPIERE-156.sql

+-- 12/04/2012 09:40:45 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Column (AD_Column_ID,AD_Table_ID,EntityType,Version,IsMandatory,IsTranslated,IsIdentifier,SeqNo,Help,IsParent,Description,Name,FieldLength,IsSelectionColumn,AD_Reference_ID,IsSyncDatabase,IsKey,AD_Element_ID,IsAutocomplete,IsAllowLogging,ColumnName,IsEncrypted,IsUpdateable,IsAlwaysUpdateable,IsAllowCopy,CreatedBy,Updated,AD_Client_ID,AD_Org_ID,IsActive,Created,UpdatedBy) VALUES (62513,297,'U',0,'N','N','N',0,'The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.','N','Alphanumeric identifier of the entity','Name',60,'N',10,'N','N',469,'N','Y','Name','N','Y','N','Y',0,TO_DATE('2012-04-12 09:40:44','YYYY-MM-DD HH24:MI:SS'),0,0,'Y',TO_DATE('2012-04-12 09:40:44','YYYY-MM-DD HH24:MI:SS'),0)
+;
+
+-- 12/04/2012 09:40:45 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Column_Trl (AD_Language,AD_Column_ID, Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Column_ID, t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Column t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Column_ID=62513 AND NOT EXISTS (SELECT * FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
+;
+
+-- 12/04/2012 09:43:11 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+ALTER TABLE C_BankAccount ADD Name NVARCHAR2(60) DEFAULT NULL 
+;
+
+-- 12/04/2012 09:44:29 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Column (AD_Column_ID,AD_Table_ID,EntityType,Version,IsMandatory,IsTranslated,IsIdentifier,SeqNo,Help,IsParent,Description,Name,FieldLength,IsSelectionColumn,AD_Reference_ID,IsSyncDatabase,IsKey,AD_Element_ID,IsAutocomplete,IsAllowLogging,ColumnName,IsEncrypted,IsUpdateable,IsAlwaysUpdateable,IsAllowCopy,CreatedBy,Updated,AD_Client_ID,AD_Org_ID,IsActive,Created,UpdatedBy) VALUES (62512,297,'U',0,'N','N','N',0,'A search key allows you a fast method of finding a particular record.
+If you leave the search key empty, the system automatically creates a numeric number.  The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).','N','Search key for the record in the format required - must be unique','Search Key',40,'N',10,'N','N',620,'N','Y','Value','N','Y','N','Y',0,TO_DATE('2012-04-12 09:44:29','YYYY-MM-DD HH24:MI:SS'),0,0,'Y',TO_DATE('2012-04-12 09:44:29','YYYY-MM-DD HH24:MI:SS'),0)
+;
+
+-- 12/04/2012 09:44:29 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Column_Trl (AD_Language,AD_Column_ID, Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Column_ID, t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Column t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Column_ID=62512 AND NOT EXISTS (SELECT * FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
+;
+
+-- 12/04/2012 09:44:58 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+ALTER TABLE C_BankAccount ADD Value NVARCHAR2(40) DEFAULT NULL 
+;
+
+-- 12/04/2012 09:49:26 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Field (IsEncrypted,Description,DisplayLength,Name,IsDisplayed,IsSameLine,IsHeading,AD_Column_ID,IsFieldOnly,IsCentrallyMaintained,AD_Tab_ID,AD_Field_ID,IsReadOnly,Help,EntityType,UpdatedBy,AD_Org_ID,IsActive,Created,AD_Client_ID,CreatedBy,Updated) VALUES ('N','Alphanumeric identifier of the entity',60,'Name','Y','N','N',62513,'N','Y',228,63003,'N','The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.','U',0,0,'Y',TO_DATE('2012-04-12 09:49:26','YYYY-MM-DD HH24:MI:SS'),0,0,TO_DATE('2012-04-12 09:49:26','YYYY-MM-DD HH24:MI:SS'))
+;
+
+-- 12/04/2012 09:49:26 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Field_Trl (AD_Language,AD_Field_ID, Description,Name,Help, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Field_ID, t.Description,t.Name,t.Help, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Field t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Field_ID=63003 AND NOT EXISTS (SELECT * FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
+;
+
+-- 12/04/2012 09:49:26 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Field (IsEncrypted,Description,DisplayLength,Name,IsDisplayed,IsSameLine,IsHeading,AD_Column_ID,IsFieldOnly,IsCentrallyMaintained,AD_Tab_ID,AD_Field_ID,IsReadOnly,Help,EntityType,UpdatedBy,AD_Org_ID,IsActive,Created,AD_Client_ID,CreatedBy,Updated) VALUES ('N','Search key for the record in the format required - must be unique',40,'Search Key','Y','N','N',62512,'N','Y',228,63002,'N','A search key allows you a fast method of finding a particular record.
+If you leave the search key empty, the system automatically creates a numeric number.  The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).','U',0,0,'Y',TO_DATE('2012-04-12 09:49:26','YYYY-MM-DD HH24:MI:SS'),0,0,TO_DATE('2012-04-12 09:49:26','YYYY-MM-DD HH24:MI:SS'))
+;
+
+-- 12/04/2012 09:49:26 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Field_Trl (AD_Language,AD_Field_ID, Description,Name,Help, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Field_ID, t.Description,t.Name,t.Help, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Field t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Field_ID=63002 AND NOT EXISTS (SELECT * FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=30,IsDisplayed='Y' WHERE AD_Field_ID=63002
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=40,IsDisplayed='Y' WHERE AD_Field_ID=63003
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=50,IsDisplayed='Y' WHERE AD_Field_ID=2217
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=60,IsDisplayed='Y' WHERE AD_Field_ID=2214
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=70,IsDisplayed='Y' WHERE AD_Field_ID=11201
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=80,IsDisplayed='Y' WHERE AD_Field_ID=11017
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=90,IsDisplayed='Y' WHERE AD_Field_ID=11016
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=100,IsDisplayed='Y' WHERE AD_Field_ID=2222
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=110,IsDisplayed='Y' WHERE AD_Field_ID=3220
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=120,IsDisplayed='Y' WHERE AD_Field_ID=2219
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=130,IsDisplayed='Y' WHERE AD_Field_ID=4114
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=140,IsDisplayed='Y' WHERE AD_Field_ID=2220
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=150,IsDisplayed='Y' WHERE AD_Field_ID=2221
+;
+
+-- 12/04/2012 09:51:08 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET IsIdentifier='N',Updated=TO_DATE('2012-04-12 09:51:08','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=3074
+;
+
+-- 12/04/2012 09:51:23 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET IsIdentifier='Y',Updated=TO_DATE('2012-04-12 09:51:23','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62513
+;
+
+-- 12/04/2012 09:51:34 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET IsIdentifier='Y', SeqNo=3,Updated=TO_DATE('2012-04-12 09:51:34','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62512
+;
+
+update c_bankaccount set name=accountno,value=accountno;
+
+-- 12/04/2012 11:46:17 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET SeqNo=0,Updated=TO_DATE('2012-04-12 11:46:17','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=3074
+;
+
+-- 12/04/2012 11:46:49 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET IsIdentifier='N', SeqNo=0,Updated=TO_DATE('2012-04-12 11:46:49','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62512
+;
+
+-- 12/04/2012 11:47:00 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET SeqNo=2, IsUpdateable='N',Updated=TO_DATE('2012-04-12 11:47:00','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=3072
+;
+
+-- 12/04/2012 11:47:07 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET SeqNo=1,Updated=TO_DATE('2012-04-12 11:47:07','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62513
+;
+
+-- 12/04/2012 11:50:38 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET IsMandatory='Y',Updated=TO_DATE('2012-04-12 11:50:38','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62513
+;
+
+-- 12/04/2012 11:50:43 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+ALTER TABLE C_BankAccount MODIFY Name NVARCHAR2(60)
+;
+
+-- 12/04/2012 11:50:43 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+ALTER TABLE C_BankAccount MODIFY Name NOT NULL
+;
+
+-- 12/04/2012 11:50:58 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET IsMandatory='Y',Updated=TO_DATE('2012-04-12 11:50:58','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62512
+;
+
+-- 12/04/2012 11:51:01 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+ALTER TABLE C_BankAccount MODIFY Value NVARCHAR2(40)
+;
+
+-- 12/04/2012 11:51:01 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+ALTER TABLE C_BankAccount MODIFY Value NOT NULL
+;
+
+-- 12/04/2012 11:51:29 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET EntityType='D',Updated=TO_DATE('2012-04-12 11:51:29','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62512
+;
+
+
+-- 12/04/2012 11:51:46 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET EntityType='D',Updated=TO_DATE('2012-04-12 11:51:46','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62513
+;
+
+-- 12/04/2012 11:53:28 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Ref_Table SET AD_Display=62513,Updated=TO_DATE('2012-04-12 11:53:28','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Reference_ID=53283
+;
+
+UPDATE AD_System
+  SET LastMigrationScriptApplied='836_IDEMPIERE-156.sql'
+WHERE LastMigrationScriptApplied<'836_IDEMPIERE-156.sql'
+   OR LastMigrationScriptApplied IS NULL
+;

migration/360lts-release/oracle/837_IDEMPIERE-195.sql

+-- Apr 18, 2012 10:41:39 AM COT
+-- IDEMPIERE-195 Expand menu automatically
+UPDATE AD_Column SET AD_Reference_ID=17, AD_Reference_Value_ID=319, DefaultValue=NULL, IsMandatory='N',Updated=TO_DATE('2012-04-18 10:41:39','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=200113
+;
+
+-- Apr 18, 2012 10:41:41 AM COT
+-- IDEMPIERE-195 Expand menu automatically
+ALTER TABLE AD_User MODIFY IsMenuAutoExpand CHAR(1) DEFAULT NULL 
+;
+
+-- Apr 18, 2012 10:41:44 AM COT
+-- IDEMPIERE-195 Expand menu automatically
+ALTER TABLE AD_User MODIFY IsMenuAutoExpand NULL
+;
+
+UPDATE AD_User SET IsMenuAutoExpand=NULL;
+
+UPDATE AD_System
+  SET LastMigrationScriptApplied='837_IDEMPIERE-195.sql'
+WHERE LastMigrationScriptApplied<'837_IDEMPIERE-195.sql'
+   OR LastMigrationScriptApplied IS NULL
+;

migration/360lts-release/postgresql/835_IDEMPIERE-195_MenuAutoExpand.sql

+-- Apr 12, 2012 11:08:21 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Element (AD_Client_ID,AD_Element_ID,AD_Org_ID,ColumnName,Created,CreatedBy,Description,EntityType,IsActive,Name,PrintName,Updated,UpdatedBy) VALUES (0,200023,0,'IsMenuAutoExpand',TO_TIMESTAMP('2012-04-12 11:08:19','YYYY-MM-DD HH24:MI:SS'),100,'If ticked, the menu is automatically expanded','D','Y','Auto expand menu','Auto expand menu',TO_TIMESTAMP('2012-04-12 11:08:19','YYYY-MM-DD HH24:MI:SS'),100)
+;
+
+-- Apr 12, 2012 11:08:21 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Element_Trl (AD_Language,AD_Element_ID, Description,Help,Name,PO_Description,PO_Help,PO_Name,PO_PrintName,PrintName, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Element_ID, t.Description,t.Help,t.Name,t.PO_Description,t.PO_Help,t.PO_Name,t.PO_PrintName,t.PrintName, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Element t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Element_ID=200023 AND NOT EXISTS (SELECT * FROM AD_Element_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Element_ID=t.AD_Element_ID)
+;
+
+-- Apr 12, 2012 11:09:31 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Column (AD_Client_ID,AD_Column_ID,AD_Element_ID,AD_Org_ID,AD_Reference_ID,AD_Table_ID,ColumnName,Created,CreatedBy,DefaultValue,Description,EntityType,FieldLength,IsActive,IsAllowCopy,IsAllowLogging,IsAlwaysUpdateable,IsAutocomplete,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,200112,200023,0,20,156,'IsMenuAutoExpand',TO_TIMESTAMP('2012-04-12 11:09:31','YYYY-MM-DD HH24:MI:SS'),100,'N','If ticked, the menu is automatically expanded','D',1,'Y','Y','Y','N','N','N','N','N','Y','N','N','N','N','Y','Auto expand menu',0,TO_TIMESTAMP('2012-04-12 11:09:31','YYYY-MM-DD HH24:MI:SS'),100,0)
+;
+
+-- Apr 12, 2012 11:09:31 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Column_Trl (AD_Language,AD_Column_ID, Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Column_ID, t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Column t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Column_ID=200112 AND NOT EXISTS (SELECT * FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
+;
+
+-- Apr 12, 2012 11:09:41 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+ALTER TABLE AD_Role ADD COLUMN IsMenuAutoExpand CHAR(1) DEFAULT 'N' CHECK (IsMenuAutoExpand IN ('Y','N')) NOT NULL
+;
+
+-- Apr 12, 2012 11:10:42 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,IsActive,IsCentrallyMaintained,IsDisplayed,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,SeqNo,SortNo,Updated,UpdatedBy) VALUES (0,200112,200071,0,119,TO_TIMESTAMP('2012-04-12 11:10:41','YYYY-MM-DD HH24:MI:SS'),100,'If ticked, the menu is automatically expanded',0,'D','Y','Y','Y','N','N','N','N','N','Auto expand menu',430,0,TO_TIMESTAMP('2012-04-12 11:10:41','YYYY-MM-DD HH24:MI:SS'),100)
+;
+
+-- Apr 12, 2012 11:10:42 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Field_Trl (AD_Language,AD_Field_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Field_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Field t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Field_ID=200071 AND NOT EXISTS (SELECT * FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=300,IsDisplayed='Y' WHERE AD_Field_ID=200071
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=310,IsDisplayed='Y' WHERE AD_Field_ID=50168
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=320,IsDisplayed='Y' WHERE AD_Field_ID=50169
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=330,IsDisplayed='Y' WHERE AD_Field_ID=50170
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=340,IsDisplayed='Y' WHERE AD_Field_ID=50171
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=350,IsDisplayed='Y' WHERE AD_Field_ID=50172
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=360,IsDisplayed='Y' WHERE AD_Field_ID=50173
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=370,IsDisplayed='Y' WHERE AD_Field_ID=50174
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=380,IsDisplayed='Y' WHERE AD_Field_ID=50175
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=390,IsDisplayed='Y' WHERE AD_Field_ID=50176
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=400,IsDisplayed='Y' WHERE AD_Field_ID=50177
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=410,IsDisplayed='Y' WHERE AD_Field_ID=50178
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=420,IsDisplayed='Y' WHERE AD_Field_ID=55432
+;
+
+-- Apr 12, 2012 11:11:23 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=430,IsDisplayed='Y' WHERE AD_Field_ID=55433
+;
+
+-- Apr 12, 2012 11:12:28 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Column (AD_Client_ID,AD_Column_ID,AD_Element_ID,AD_Org_ID,AD_Reference_ID,AD_Table_ID,ColumnName,Created,CreatedBy,DefaultValue,Description,EntityType,FieldLength,IsActive,IsAllowCopy,IsAllowLogging,IsAlwaysUpdateable,IsAutocomplete,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,200113,200023,0,20,114,'IsMenuAutoExpand',TO_TIMESTAMP('2012-04-12 11:12:27','YYYY-MM-DD HH24:MI:SS'),100,'N','If ticked, the menu is automatically expanded','D',1,'Y','Y','Y','N','N','N','N','N','Y','N','N','N','N','Y','Auto expand menu',0,TO_TIMESTAMP('2012-04-12 11:12:27','YYYY-MM-DD HH24:MI:SS'),100,0)
+;
+
+-- Apr 12, 2012 11:12:28 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Column_Trl (AD_Language,AD_Column_ID, Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Column_ID, t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Column t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Column_ID=200113 AND NOT EXISTS (SELECT * FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
+;
+
+-- Apr 12, 2012 11:12:29 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+ALTER TABLE AD_User ADD COLUMN IsMenuAutoExpand CHAR(1) DEFAULT 'N' CHECK (IsMenuAutoExpand IN ('Y','N')) NOT NULL
+;
+
+-- Apr 12, 2012 11:13:08 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,IsActive,IsCentrallyMaintained,IsDisplayed,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,SeqNo,SortNo,Updated,UpdatedBy) VALUES (0,200113,200072,0,118,TO_TIMESTAMP('2012-04-12 11:13:07','YYYY-MM-DD HH24:MI:SS'),100,'If ticked, the menu is automatically expanded',0,'D','Y','Y','Y','N','N','N','N','N','Auto expand menu',310,0,TO_TIMESTAMP('2012-04-12 11:13:07','YYYY-MM-DD HH24:MI:SS'),100)
+;
+
+-- Apr 12, 2012 11:13:08 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Field_Trl (AD_Language,AD_Field_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Field_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Field t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Field_ID=200072 AND NOT EXISTS (SELECT * FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=130,IsDisplayed='Y' WHERE AD_Field_ID=52010
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=140,IsDisplayed='Y' WHERE AD_Field_ID=6515
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=150,IsDisplayed='Y' WHERE AD_Field_ID=6517
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=160,IsDisplayed='Y' WHERE AD_Field_ID=6514
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=170,IsDisplayed='Y' WHERE AD_Field_ID=6518
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=180,IsDisplayed='Y' WHERE AD_Field_ID=11679
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=190,IsDisplayed='Y' WHERE AD_Field_ID=12324
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=200,IsDisplayed='Y' WHERE AD_Field_ID=12323
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=210,IsDisplayed='Y' WHERE AD_Field_ID=5883
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=220,IsDisplayed='Y' WHERE AD_Field_ID=5884
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=230,IsDisplayed='Y' WHERE AD_Field_ID=4261
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=240,IsDisplayed='Y' WHERE AD_Field_ID=10491
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=250,IsDisplayed='Y' WHERE AD_Field_ID=6511
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=260,IsDisplayed='Y' WHERE AD_Field_ID=12640
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=270,IsDisplayed='Y' WHERE AD_Field_ID=200072
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=280,IsDisplayed='Y' WHERE AD_Field_ID=6513
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=290,IsDisplayed='Y' WHERE AD_Field_ID=11525
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=300,IsDisplayed='Y' WHERE AD_Field_ID=6520
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=310,IsDisplayed='Y' WHERE AD_Field_ID=8342
+;
+
+-- Apr 12, 2012 11:13:25 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=320,IsDisplayed='Y' WHERE AD_Field_ID=6519
+;
+
+-- Apr 12, 2012 11:13:47 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,IsActive,IsCentrallyMaintained,IsDisplayed,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,SeqNo,SortNo,Updated,UpdatedBy) VALUES (0,200113,200073,0,53282,TO_TIMESTAMP('2012-04-12 11:13:46','YYYY-MM-DD HH24:MI:SS'),100,'If ticked, the menu is automatically expanded',0,'D','Y','Y','Y','N','N','N','N','N','Auto expand menu',310,0,TO_TIMESTAMP('2012-04-12 11:13:46','YYYY-MM-DD HH24:MI:SS'),100)
+;
+
+-- Apr 12, 2012 11:13:47 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+INSERT INTO AD_Field_Trl (AD_Language,AD_Field_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Field_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Field t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Field_ID=200073 AND NOT EXISTS (SELECT * FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=130,IsDisplayed='Y' WHERE AD_Field_ID=57995
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=140,IsDisplayed='Y' WHERE AD_Field_ID=57997
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=150,IsDisplayed='Y' WHERE AD_Field_ID=57998
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=160,IsDisplayed='Y' WHERE AD_Field_ID=57999
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=170,IsDisplayed='Y' WHERE AD_Field_ID=58000
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=180,IsDisplayed='Y' WHERE AD_Field_ID=58001
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=190,IsDisplayed='Y' WHERE AD_Field_ID=58002
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=200,IsDisplayed='Y' WHERE AD_Field_ID=58003
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=210,IsDisplayed='Y' WHERE AD_Field_ID=58004
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=220,IsDisplayed='Y' WHERE AD_Field_ID=58005
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=230,IsDisplayed='Y' WHERE AD_Field_ID=58006
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=240,IsDisplayed='Y' WHERE AD_Field_ID=58007
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=250,IsDisplayed='Y' WHERE AD_Field_ID=58008
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=260,IsDisplayed='Y' WHERE AD_Field_ID=58009
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=270,IsDisplayed='Y' WHERE AD_Field_ID=200073
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=280,IsDisplayed='Y' WHERE AD_Field_ID=58010
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=290,IsDisplayed='Y' WHERE AD_Field_ID=58011
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=300,IsDisplayed='Y' WHERE AD_Field_ID=58012
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=310,IsDisplayed='Y' WHERE AD_Field_ID=58013
+;
+
+-- Apr 12, 2012 11:13:58 AM CEST
+-- IDEMPIERE-129 Expand menu automatically
+UPDATE AD_Field SET SeqNo=320,IsDisplayed='Y' WHERE AD_Field_ID=58014
+;
+
+UPDATE AD_System
+  SET LastMigrationScriptApplied='835_IDEMPIERE-195_MenuAutoExpand.sql'
+WHERE LastMigrationScriptApplied<'835_IDEMPIERE-195_MenuAutoExpand.sql'
+   OR LastMigrationScriptApplied IS NULL
+;

migration/360lts-release/postgresql/836_IDEMPIERE-156.sql

+-- 12/04/2012 09:40:45 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Column (AD_Column_ID,AD_Table_ID,EntityType,Version,IsMandatory,IsTranslated,IsIdentifier,SeqNo,Help,IsParent,Description,Name,FieldLength,IsSelectionColumn,AD_Reference_ID,IsSyncDatabase,IsKey,AD_Element_ID,IsAutocomplete,IsAllowLogging,ColumnName,IsEncrypted,IsUpdateable,IsAlwaysUpdateable,IsAllowCopy,CreatedBy,Updated,AD_Client_ID,AD_Org_ID,IsActive,Created,UpdatedBy) VALUES (62513,297,'U',0,'N','N','N',0,'The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.','N','Alphanumeric identifier of the entity','Name',60,'N',10,'N','N',469,'N','Y','Name','N','Y','N','Y',0,TO_TIMESTAMP('2012-04-12 09:40:44','YYYY-MM-DD HH24:MI:SS'),0,0,'Y',TO_TIMESTAMP('2012-04-12 09:40:44','YYYY-MM-DD HH24:MI:SS'),0)
+;
+
+-- 12/04/2012 09:40:45 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Column_Trl (AD_Language,AD_Column_ID, Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Column_ID, t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Column t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Column_ID=62513 AND NOT EXISTS (SELECT * FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
+;
+
+-- 12/04/2012 09:43:11 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+ALTER TABLE C_BankAccount ADD COLUMN Name VARCHAR(60) DEFAULT NULL 
+;
+
+-- 12/04/2012 09:44:29 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Column (AD_Column_ID,AD_Table_ID,EntityType,Version,IsMandatory,IsTranslated,IsIdentifier,SeqNo,Help,IsParent,Description,Name,FieldLength,IsSelectionColumn,AD_Reference_ID,IsSyncDatabase,IsKey,AD_Element_ID,IsAutocomplete,IsAllowLogging,ColumnName,IsEncrypted,IsUpdateable,IsAlwaysUpdateable,IsAllowCopy,CreatedBy,Updated,AD_Client_ID,AD_Org_ID,IsActive,Created,UpdatedBy) VALUES (62512,297,'U',0,'N','N','N',0,'A search key allows you a fast method of finding a particular record.
+If you leave the search key empty, the system automatically creates a numeric number.  The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).','N','Search key for the record in the format required - must be unique','Search Key',40,'N',10,'N','N',620,'N','Y','Value','N','Y','N','Y',0,TO_TIMESTAMP('2012-04-12 09:44:29','YYYY-MM-DD HH24:MI:SS'),0,0,'Y',TO_TIMESTAMP('2012-04-12 09:44:29','YYYY-MM-DD HH24:MI:SS'),0)
+;
+
+-- 12/04/2012 09:44:29 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Column_Trl (AD_Language,AD_Column_ID, Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Column_ID, t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Column t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Column_ID=62512 AND NOT EXISTS (SELECT * FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
+;
+
+-- 12/04/2012 09:44:58 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+ALTER TABLE C_BankAccount ADD COLUMN Value VARCHAR(40) DEFAULT NULL 
+;
+
+-- 12/04/2012 09:49:26 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Field (IsEncrypted,Description,DisplayLength,Name,IsDisplayed,IsSameLine,IsHeading,AD_Column_ID,IsFieldOnly,IsCentrallyMaintained,AD_Tab_ID,AD_Field_ID,IsReadOnly,Help,EntityType,UpdatedBy,AD_Org_ID,IsActive,Created,AD_Client_ID,CreatedBy,Updated) VALUES ('N','Alphanumeric identifier of the entity',60,'Name','Y','N','N',62513,'N','Y',228,63003,'N','The name of an entity (record) is used as an default search option in addition to the search key. The name is up to 60 characters in length.','U',0,0,'Y',TO_TIMESTAMP('2012-04-12 09:49:26','YYYY-MM-DD HH24:MI:SS'),0,0,TO_TIMESTAMP('2012-04-12 09:49:26','YYYY-MM-DD HH24:MI:SS'))
+;
+
+-- 12/04/2012 09:49:26 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Field_Trl (AD_Language,AD_Field_ID, Description,Name,Help, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Field_ID, t.Description,t.Name,t.Help, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Field t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Field_ID=63003 AND NOT EXISTS (SELECT * FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
+;
+
+-- 12/04/2012 09:49:26 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Field (IsEncrypted,Description,DisplayLength,Name,IsDisplayed,IsSameLine,IsHeading,AD_Column_ID,IsFieldOnly,IsCentrallyMaintained,AD_Tab_ID,AD_Field_ID,IsReadOnly,Help,EntityType,UpdatedBy,AD_Org_ID,IsActive,Created,AD_Client_ID,CreatedBy,Updated) VALUES ('N','Search key for the record in the format required - must be unique',40,'Search Key','Y','N','N',62512,'N','Y',228,63002,'N','A search key allows you a fast method of finding a particular record.
+If you leave the search key empty, the system automatically creates a numeric number.  The document sequence used for this fallback number is defined in the "Maintain Sequence" window with the name "DocumentNo_<TableName>", where TableName is the actual name of the table (e.g. C_Order).','U',0,0,'Y',TO_TIMESTAMP('2012-04-12 09:49:26','YYYY-MM-DD HH24:MI:SS'),0,0,TO_TIMESTAMP('2012-04-12 09:49:26','YYYY-MM-DD HH24:MI:SS'))
+;
+
+-- 12/04/2012 09:49:26 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Field_Trl (AD_Language,AD_Field_ID, Description,Name,Help, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Field_ID, t.Description,t.Name,t.Help, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Field t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Field_ID=63002 AND NOT EXISTS (SELECT * FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=30,IsDisplayed='Y' WHERE AD_Field_ID=63002
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=40,IsDisplayed='Y' WHERE AD_Field_ID=63003
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=50,IsDisplayed='Y' WHERE AD_Field_ID=2217
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=60,IsDisplayed='Y' WHERE AD_Field_ID=2214
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=70,IsDisplayed='Y' WHERE AD_Field_ID=11201
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=80,IsDisplayed='Y' WHERE AD_Field_ID=11017
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=90,IsDisplayed='Y' WHERE AD_Field_ID=11016
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=100,IsDisplayed='Y' WHERE AD_Field_ID=2222
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=110,IsDisplayed='Y' WHERE AD_Field_ID=3220
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=120,IsDisplayed='Y' WHERE AD_Field_ID=2219
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=130,IsDisplayed='Y' WHERE AD_Field_ID=4114
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=140,IsDisplayed='Y' WHERE AD_Field_ID=2220
+;
+
+-- 12/04/2012 09:50:39 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Field SET SeqNo=150,IsDisplayed='Y' WHERE AD_Field_ID=2221
+;
+
+-- 12/04/2012 09:51:08 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET IsIdentifier='N',Updated=TO_TIMESTAMP('2012-04-12 09:51:08','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=3074
+;
+
+-- 12/04/2012 09:51:23 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET IsIdentifier='Y',Updated=TO_TIMESTAMP('2012-04-12 09:51:23','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62513
+;
+
+-- 12/04/2012 09:51:34 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET IsIdentifier='Y', SeqNo=3,Updated=TO_TIMESTAMP('2012-04-12 09:51:34','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62512
+;
+
+update c_bankaccount set name=accountno,value=accountno;
+
+
+-- 12/04/2012 11:46:17 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET SeqNo=0,Updated=TO_TIMESTAMP('2012-04-12 11:46:17','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=3074
+;
+
+-- 12/04/2012 11:46:49 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET IsIdentifier='N', SeqNo=0,Updated=TO_TIMESTAMP('2012-04-12 11:46:49','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62512
+;
+
+-- 12/04/2012 11:47:00 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET SeqNo=2, IsUpdateable='N',Updated=TO_TIMESTAMP('2012-04-12 11:47:00','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=3072
+;
+
+-- 12/04/2012 11:47:07 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET SeqNo=1,Updated=TO_TIMESTAMP('2012-04-12 11:47:07','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62513
+;
+
+-- 12/04/2012 11:50:38 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET IsMandatory='Y',Updated=TO_TIMESTAMP('2012-04-12 11:50:38','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62513
+;
+
+-- 12/04/2012 11:50:43 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO t_alter_column values('c_bankaccount','Name','VARCHAR(60)',null,null)
+;
+
+-- 12/04/2012 11:50:43 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO t_alter_column values('c_bankaccount','Name',null,'NOT NULL',null)
+;
+
+-- 12/04/2012 11:50:58 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET IsMandatory='Y',Updated=TO_TIMESTAMP('2012-04-12 11:50:58','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62512
+;
+
+-- 12/04/2012 11:51:01 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO t_alter_column values('c_bankaccount','Value','VARCHAR(40)',null,null)
+;
+
+-- 12/04/2012 11:51:01 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO t_alter_column values('c_bankaccount','Value',null,'NOT NULL',null)
+;
+
+-- 12/04/2012 11:51:29 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET EntityType='D',Updated=TO_TIMESTAMP('2012-04-12 11:51:29','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62512
+;
+
+
+
+-- 12/04/2012 11:51:46 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Column SET EntityType='D',Updated=TO_TIMESTAMP('2012-04-12 11:51:46','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Column_ID=62513
+;
+
+-- 12/04/2012 11:53:28 AM COT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+UPDATE AD_Ref_Table SET AD_Display=62513,Updated=TO_TIMESTAMP('2012-04-12 11:53:28','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=0 WHERE AD_Reference_ID=53283
+;
+
+UPDATE AD_System
+  SET LastMigrationScriptApplied='836_IDEMPIERE-156.sql'
+WHERE LastMigrationScriptApplied<'836_IDEMPIERE-156.sql'
+   OR LastMigrationScriptApplied IS NULL
+;

migration/360lts-release/postgresql/837_IDEMPIERE-195.sql

+-- Apr 18, 2012 10:41:39 AM COT
+-- IDEMPIERE-195 Expand menu automatically
+UPDATE AD_Column SET AD_Reference_ID=17, AD_Reference_Value_ID=319, DefaultValue=NULL, IsMandatory='N',Updated=TO_TIMESTAMP('2012-04-18 10:41:39','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=200113
+;
+
+-- Apr 18, 2012 10:41:41 AM COT
+-- IDEMPIERE-195 Expand menu automatically
+INSERT INTO t_alter_column values('ad_user','IsMenuAutoExpand','CHAR(1)',null,'NULL')
+;
+
+-- Apr 18, 2012 10:41:44 AM COT
+-- IDEMPIERE-195 Expand menu automatically
+INSERT INTO t_alter_column values('ad_user','IsMenuAutoExpand',null,'NULL',null)
+;
+
+UPDATE AD_User SET IsMenuAutoExpand=NULL;
+
+UPDATE AD_System
+  SET LastMigrationScriptApplied='837_IDEMPIERE-195.sql'
+WHERE LastMigrationScriptApplied<'837_IDEMPIERE-195.sql'
+   OR LastMigrationScriptApplied IS NULL
+;

org.adempiere.base.process/src/org/adempiere/process/ImmediateBankTransfer.java

 					"Cash Processing failed: " + cash + " - "
 							+ cash.getProcessMsg()
 							+ " / please complete it manually");
+	        throw new  IllegalStateException("Cash Processing failed: " + cash + " - " + cash.getProcessMsg());
 	    }
 		if (!cash.save())
 		{

org.adempiere.base.process/src/org/adempiere/process/InOutGenerateRMA.java

         {
             processMsg.append(" (NOT Processed)");
             log.warning("Shipment Processing failed: " + shipment + " - " + shipment.getProcessMsg());
+            throw new IllegalStateException("Shipment Processing failed: " + shipment + " - " + shipment.getProcessMsg());
         }
         
         if (!shipment.save())

org.adempiere.base.process/src/org/adempiere/process/InvoiceGenerateRMA.java

         {
             processMsg.append(" (NOT Processed)");
             log.warning("Invoice Processing failed: " + invoice + " - " + invoice.getProcessMsg());
+            throw new IllegalStateException("Invoice Processing failed: " + invoice + " - " + invoice.getProcessMsg());
         }
         
         if (!invoice.save())

org.adempiere.base.process/src/org/compiere/process/AllocationAuto.java

 		if (m_allocation == null)
 			return true;
 		boolean success = m_allocation.processIt(MAllocationHdr.DOCACTION_Complete);
-		if (success)
-			success = m_allocation.save();
+		if (!success)
+			throw new IllegalStateException("Allocation Process Failed "+ m_allocation.getDocumentNo() +
+					" " + m_allocation.getProcessMsg());
 		else
 			m_allocation.saveEx();
 		addLog(0, m_allocation.getDateAcct(), null, m_allocation.getDescription());

org.adempiere.base.process/src/org/compiere/process/BankStatementPayment.java

 			return null;
 		payment.saveEx();
 		//
-		payment.processIt(MPayment.DOCACTION_Complete);
+		if (!payment.processIt(MPayment.DOCACTION_Complete)) {
+			log.warning("Payment Process Failed: " + payment.getDocumentNo() + " " + payment.getProcessMsg());
+			throw new IllegalStateException("Payment Process Failed: " + payment.getDocumentNo() + " " + payment.getProcessMsg());
+			
+		}
 		payment.saveEx();
 		return payment;		
 	}	//	createPayment

org.adempiere.base.process/src/org/compiere/process/CopyOrder.java

 		{
 			MOrder original = new MOrder (getCtx(), p_C_Order_ID, get_TrxName());
 			original.setDocAction(MOrder.DOCACTION_Complete);
-			original.processIt(MOrder.DOCACTION_Complete);
+			if (!original.processIt(MOrder.DOCACTION_Complete)) {
+				log.warning("Order Process Failed: " + original.getDocumentNo() + " " + original.getProcessMsg());
+				throw new IllegalStateException("Order Process Failed: " + original.getDocumentNo() + " " + original.getProcessMsg());
+				
+			}
 			original.saveEx();
 			original.setDocAction(MOrder.DOCACTION_Close);
-			original.processIt(MOrder.DOCACTION_Close);
+			if (!original.processIt(MOrder.DOCACTION_Close)) {
+				log.warning("Order Process Failed: " + original.getDocumentNo() + " " + original.getProcessMsg());
+				throw new IllegalStateException("Order Process Failed: " + original.getDocumentNo() + " " + original.getProcessMsg());
+				
+			}
+			
 			original.saveEx();
 		}
 		//

org.adempiere.base.process/src/org/compiere/process/ExpenseAPInvoice.java

 		if (invoice == null)
 			return;
 		invoice.setDocAction(DocAction.ACTION_Prepare);
-		invoice.processIt(DocAction.ACTION_Prepare);
+		if (!invoice.processIt(DocAction.ACTION_Prepare)) {
+			log.warning("Invoice Process Failed: " + invoice + " - " + invoice.getProcessMsg());
+			throw new IllegalStateException("Invoice Process Failed: " + invoice + " - " + invoice.getProcessMsg());
+			
+		}
 		if (!invoice.save())
 			new IllegalStateException("Cannot save Invoice");
 		//

org.adempiere.base.process/src/org/compiere/process/ExpenseSOrder.java

 		if (m_order == null)
 			return;
 		m_order.setDocAction(DocAction.ACTION_Prepare);
-		m_order.processIt(DocAction.ACTION_Prepare);
+		if (!m_order.processIt(DocAction.ACTION_Prepare)) {
+			log.warning("Order Process Failed: " + m_order + " - " + m_order.getProcessMsg());
+			throw new IllegalStateException("Order Process Failed: " + m_order + " - " + m_order.getProcessMsg());
+		}
 		if (!m_order.save())
 			throw new IllegalStateException("Cannot save Order");
 		m_noOrders++;

org.adempiere.base.process/src/org/compiere/process/ImportInvoice.java

 				{
 					if (invoice != null)
 					{
-						invoice.processIt(m_docAction);
+						if (!invoice.processIt(m_docAction)) {
+							log.warning("Invoice Process Failed: " + invoice + " - " + invoice.getProcessMsg());
+							throw new IllegalStateException("Invoice Process Failed: " + invoice + " - " + invoice.getProcessMsg());
+							
+						}
 						invoice.saveEx();
 					}
 					//	Group Change
 			}
 			if (invoice != null)
 			{
-				invoice.processIt (m_docAction);
+				if(!invoice.processIt (m_docAction)) {
+					log.warning("Invoice Process Failed: " + invoice + " - " + invoice.getProcessMsg());
+					throw new IllegalStateException("Invoice Process Failed: " + invoice + " - " + invoice.getProcessMsg());
+					
+				}
 				invoice.saveEx();
 			}
 			rs.close();

org.adempiere.base.process/src/org/compiere/process/ImportOrder.java

 						if (m_docAction != null && m_docAction.length() > 0)
 						{
 							order.setDocAction(m_docAction);
-							order.processIt (m_docAction);
+							if(!order.processIt (m_docAction)) {
+								log.warning("Order Process Failed: " + order + " - " + order.getProcessMsg());
+								throw new IllegalStateException("Order Process Failed: " + order + " - " + order.getProcessMsg());
+								
+							}
 						}
 						order.saveEx();
 					}
 				if (m_docAction != null && m_docAction.length() > 0)
 				{
 					order.setDocAction(m_docAction);
-					order.processIt (m_docAction);
+					if(!order.processIt (m_docAction)) {
+						log.warning("Order Process Failed: " + order + " - " + order.getProcessMsg());
+						throw new IllegalStateException("Order Process Failed: " + order + " - " + order.getProcessMsg());
+						
+					}
 				}
 				order.saveEx();
 			}

org.adempiere.base.process/src/org/compiere/process/ImportPayment.java

 					if (payment != null && m_docAction != null && m_docAction.length() > 0)
 					{
 						payment.setDocAction(m_docAction);
-						payment.processIt (m_docAction);
+						if(!payment.processIt (m_docAction)) {
+							log.warning("Payment Process Failed: " + payment + " - " + payment.getProcessMsg());
+							throw new IllegalStateException("Payment Process Failed: " + payment + " - " + payment.getProcessMsg());
+							
+						}
 						payment.saveEx();
 					}
 				}

org.adempiere.base.process/src/org/compiere/process/InOutGenerate.java

 		if (m_shipment != null)
 		{
 			//	Fails if there is a confirmation
-			if (!m_shipment.processIt(p_docAction))
+			if (!m_shipment.processIt(p_docAction)) {
 				log.warning("Failed: " + m_shipment);
+				throw new IllegalStateException("Shipment Process Failed: " + m_shipment + " - " + m_shipment.getProcessMsg());
+				
+			}
 			m_shipment.saveEx();
 			//
 			addLog(m_shipment.getM_InOut_ID(), m_shipment.getMovementDate(), null, m_shipment.getDocumentNo());

org.adempiere.base.process/src/org/compiere/process/InvoiceBatchProcess.java

 			return;
 		
 		m_invoice.setDocAction(p_DocAction);
-		m_invoice.processIt(p_DocAction);
+		if(!m_invoice.processIt(p_DocAction)) {
+			log.warning("Invoice Process Failed: " + m_invoice + " - " + m_invoice.getProcessMsg());
+			throw new IllegalStateException("Invoice Process Failed: " + m_invoice + " - " + m_invoice.getProcessMsg());
+			
+		}
 		m_invoice.saveEx();
 		
 		addLog(0, m_invoice.getDateInvoiced(), m_invoice.getGrandTotal(), m_invoice.getDocumentNo());

org.adempiere.base.process/src/org/compiere/process/InvoiceGenerate.java

 			{
 				log.warning("completeInvoice - failed: " + m_invoice);
 				addLog("completeInvoice - failed: " + m_invoice); // Elaine 2008/11/25
+				throw new IllegalStateException("Invoice Process Failed: " + m_invoice + " - " + m_invoice.getProcessMsg());
+				
 			}
 			m_invoice.saveEx();
 

org.adempiere.base.process/src/org/compiere/process/InvoiceWriteOff.java

 			return true;
 		processPayment();
 		//	Process It
-		if (m_alloc.processIt(DocAction.ACTION_Complete) &&  m_alloc.save())
-		{
+		if (!m_alloc.processIt(DocAction.ACTION_Complete)) {
+			log.warning("Allocation Process Failed: " + m_alloc + " - " + m_alloc.getProcessMsg());
+			throw new IllegalStateException("Allocation Process Failed: " + m_alloc + " - " + m_alloc.getProcessMsg());
+				
+		}
+		if (m_alloc.save()) {
 			m_alloc = null;
 			return true;
 		}
 		if (m_payment == null)
 			return true;
 		//	Process It
-		if (m_payment.processIt(DocAction.ACTION_Complete) &&  m_payment.save())
-		{
+		if (!m_payment.processIt(DocAction.ACTION_Complete)) {
+			log.warning("Payment Process Failed: " + m_payment + " - " + m_payment.getProcessMsg());
+			throw new IllegalStateException("Payment Process Failed: " + m_payment + " - " + m_payment.getProcessMsg());
+		}		
+			
+		if (m_payment.save()) {
 			m_payment = null;
 			return true;
 		}

org.adempiere.base.process/src/org/compiere/process/OrderBatchProcess.java

 			order.saveEx();
 			addLog(0, null, null, order.getDocumentNo() + ": OK");
 			return true;
+		} else {
+			log.warning("Order Process Failed: " + order + " - " + order.getProcessMsg());
+			throw new IllegalStateException("Order Process Failed: " + order + " - " + order.getProcessMsg());
+			
 		}
-		addLog (0, null, null, order.getDocumentNo() + ": Error " + order.getProcessMsg());
-		return false;
+		// commented by zuhri - unreachable code
+		//addLog (0, null, null, order.getDocumentNo() + ": Error " + order.getProcessMsg());
+		//return false;
+		// end commented out by zuhri
 	}	//	process
 	
 }	//	OrderBatchProcess

org.adempiere.base.process/src/org/compiere/process/RequestInvoice.java

 				m_invoice.delete(false);
 			else
 			{
-				m_invoice.processIt(MInvoice.ACTION_Prepare);
+				if(!m_invoice.processIt(MInvoice.ACTION_Prepare)) {
+					log.warning("Invoice Process Failed: " + m_invoice + " - " + m_invoice.getProcessMsg());
+					throw new IllegalStateException("Invoice Process Failed: " + m_invoice + " - " + m_invoice.getProcessMsg());
+					
+				}
 				m_invoice.saveEx();
 				addLog(0, null, m_invoice.getGrandTotal(), m_invoice.getDocumentNo());
 			}

org.adempiere.base.process/src/org/compiere/process/StorageCleanup.java

 		}	//	for all movements
 		
 		//	Process
-		mh.processIt(MMovement.ACTION_Complete);
+		if (!mh.processIt(MMovement.ACTION_Complete)) {
+			log.warning("Movement Process Failed: " + mh + " - " + mh.getProcessMsg());
+			throw new IllegalStateException("Movement Process Failed: " + mh + " - " + mh.getProcessMsg());
+			
+		}
 		mh.saveEx();
 		
 		addLog(0, null, new BigDecimal(lines), "@M_Movement_ID@ " + mh.getDocumentNo() + " (" 

org.adempiere.base.process/src/org/compiere/process/SynchronizeTerminology.java

 			rs.close();
 			trx.commit(true);
 			// Create Elements for Process Parameters which are centrally maintained
+			/* IDEMPIERE 109 - this create unwanted Element
 			sql="SELECT DISTINCT ColumnName, Name, Description, Help, EntityType "
 				+" FROM	AD_PROCESS_PARA p "
 				+" WHERE NOT EXISTS "
 			}
 			pstmt.close();
 			rs.close();
-			trx.commit(true);
+			trx.commit(true);*/
 			log.info("Adding missing Element Translations");
 			sql="INSERT INTO AD_ELEMENT_TRL (AD_Element_ID, AD_LANGUAGE, AD_Client_ID, AD_Org_ID,"
 				+" IsActive, Created, CreatedBy, Updated, UpdatedBy,"

org.adempiere.base/src/org/compiere/Base.java

 import org.compiere.model.GridWindowVO;
 import org.compiere.model.MConversionRate;
 import org.compiere.model.MUOMConversion;
+import org.compiere.model.SystemIDs;
 import org.compiere.util.Env;
 import org.compiere.util.Login;
 
  *  @author Jorg Janke
  *  @version $Id: Base.java,v 1.5 2006/09/21 20:44:54 jjanke Exp $
  */
-class Base
+class Base implements SystemIDs
 {
 	/**
 	 *  Base Test
 		//  *******************************************************************
 
 		//  Table=100, Shipper=142, Window=102, Reference=101
-		int AD_Window_ID = 102;
+		int AD_Window_ID = WINDOW_WINDOW_TAB_FIELD;
 		long startTime = System.currentTimeMillis();
 		GridWindowVO vo = GridWindowVO.create(Env.getCtx(), 1, AD_Window_ID);
 		GridWindow w = new GridWindow(vo);

org.adempiere.base/src/org/compiere/acct/Doc.java

 		{
 			log.log(Level.SEVERE, "Resubmit - Cannot lock " + get_TableName() + "_ID="
 				+ get_ID() + ", Force=" + force + ",RePost=" + repost);
+			if (!p_po.isActive())
+				return "Cannot post inactive document";
 			if (force)
 				return "Cannot Lock - ReSubmit";
 			return "Cannot Lock - ReSubmit or RePost with Force";

org.adempiere.base/src/org/compiere/impexp/ImpFormat.java

 import java.util.logging.Level;
 
 import org.compiere.model.I_AD_ImpFormat;
+import org.compiere.model.SystemIDs;
 import org.compiere.model.X_AD_ImpFormat;
 import org.compiere.model.X_I_GLJournal;
 import org.compiere.util.CLogger;
 
  *  @version $Id: ImpFormat.java,v 1.3 2006/07/30 00:51:05 jjanke Exp $
  */
-public final class ImpFormat
+public final class ImpFormat implements SystemIDs
 {
 	/**
 	 *	Format
 			m_tableUniqueChild = "H_Commodity1";		//	Vendor No may not be unique !
 			m_tableUniqueParent = "H_PartnrID";			//			Makes it unique
 		}
-		else if (m_AD_Table_ID == 532)		//	I_Product
+		else if (m_AD_Table_ID == TABLE_I_PRODUCT)		//	I_Product
 		{
 			m_tableUnique1 = "UPC";						//	UPC = unique
 			m_tableUnique2 = "Value";
 			m_tableUniqueChild = "VendorProductNo";		//	Vendor No may not be unique !
 			m_tableUniqueParent = "BPartner_Value";		//			Makes it unique
 		}
-		else if (m_AD_Table_ID == 533)		//	I_BPartner
+		else if (m_AD_Table_ID == TABLE_I_BPARTNER)		//	I_BPartner
 		{
 			// gody: 20070113 to allow multiple contacts per BP			
 			// m_tableUnique1 = "Value";				//	the key
 		}
-		else if (m_AD_Table_ID == 534)		//	I_ElementValue
+		else if (m_AD_Table_ID == TABLE_I_ELEMENTVALUE)		//	I_ElementValue
 		{
 			m_tableUniqueParent = "ElementName";			//	the parent key
 			m_tableUniqueChild = "Value";					//	the key
 		}
-		else if (m_AD_Table_ID == 535)		//	I_ReportLine
+		else if (m_AD_Table_ID == TABLE_I_REPORTLINE)		//	I_ReportLine
 		{