text: -- 19.02.2016 15:14
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Column (AD_Client_ID,AD_Column_ID,AD_Element_ID,AD_Org_ID,AD_Reference_ID,AD_Table_ID,AllowZoomTo,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,IsActive,IsAdvancedText,IsAllowLogging,IsAlwaysUpdateable,IsAutocomplete,IsCalculated,IsDimension,IsEncrypted,IsGenericZoomKeyColumn,IsGenericZoomOrigin,IsIdentifier,IsKey,IsLazyLoading,IsMandatory,IsParent,IsSelectionColumn,IsStaleable,IsSyncDatabase,IsTranslated,IsUpdateable,IsUseDocSequence,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,553175,1842,0,36,319,'N','DocumentTypeNote',TO_TIMESTAMP('2016-02-19 15:14:10','YYYY-MM-DD HH24:MI:SS'),100,'N','Optional note of a document type','D',100,'Y','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','Y','N','Document Type Note',0,TO_TIMESTAMP('2016-02-19 15:14:10','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 19.02.2016 15:14
  -- 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=553175 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)
  ;
  
  -- 19.02.2016 15:26
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Ref_List (AD_Client_ID,AD_Org_ID,AD_Reference_ID,AD_Ref_List_ID,Created,CreatedBy,EntityType,IsActive,Name,Updated,UpdatedBy,Value,ValueName) VALUES (0,0,148,541182,TO_TIMESTAMP('2016-02-19 15:26:23','YYYY-MM-DD HH24:MI:SS'),100,'U','Y','Saldokorektur',TO_TIMESTAMP('2016-02-19 15:26:23','YYYY-MM-DD HH24:MI:SS'),100,'EC','Saldokorektur')
  ;
  
  -- 19.02.2016 15:26
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Ref_List_Trl (AD_Language,AD_Ref_List_ID, Description,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Ref_List_ID, t.Description,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Ref_List t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Ref_List_ID=541182 AND NOT EXISTS (SELECT * FROM AD_Ref_List_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Ref_List_ID=t.AD_Ref_List_ID)
  ;
  
  -- 19.02.2016 15:26
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Ref_List SET EntityType='de.metas.handlingunits',Updated=TO_TIMESTAMP('2016-02-19 15:26:35','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Ref_List_ID=541182
  ;
  
  
  
  -- 19.02.2016 16:28
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Column SET IsLazyLoading='Y',Updated=TO_TIMESTAMP('2016-02-19 16:28:34','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=553175
  ;
  
  
  -- 23.02.2016 11:53
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Column SET ColumnSQL='(case when M_InOut.C_DocType_ID = (select C_DocType_ID from C_DocType where docbasetype =''MMR'' AND docsubtype = ''EC'') then (select msgtext from ad_message where value=''de.metas.handlingunits.EmptyKorrectSO'') when M_InOut.C_DocType_ID = (select C_DocType_ID from C_DocType where docbasetype =''MMS'' AND docsubtype = ''EC'') then (select msgtext from ad_message where value=''de.metas.handlingunits.EmptyKorrectPO'') end)',Updated=TO_TIMESTAMP('2016-02-23 11:53:46','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=553175
  ;
  
  