text: ﻿
  -- 2017-09-26T15:53:16.322
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Process (AccessLevel,AD_Client_ID,AD_Org_ID,AD_Process_ID,AllowProcessReRun,Classname,Created,CreatedBy,EntityType,IsActive,IsApplySecuritySettings,IsBetaFunctionality,IsDirectPrint,IsOneInstanceOnly,IsReport,IsServerProcess,IsUseBPartnerLanguage,JasperReport,Name,RefreshAllAfterExecution,ShowHelp,Type,Updated,UpdatedBy,Value) VALUES ('3',0,0,540854,'N','org.compiere.report.ReportStarter',TO_TIMESTAMP('2017-09-26 15:53:16','YYYY-MM-DD HH24:MI:SS'),100,'de.metas.fresh','Y','N','N','Y','N','Y','N','Y','@PREFIX@de/metas/docs/sales/picking/report.jasper','Picking Terminal (Jasper)','N','N','Java',TO_TIMESTAMP('2017-09-26 15:53:16','YYYY-MM-DD HH24:MI:SS'),100,'Picking Terminal (Jasper)')
  ;
  
  -- 2017-09-26T15:53:16.325
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Process_Trl (AD_Language,AD_Process_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Process_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_Process t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Process_ID=540854 AND NOT EXISTS (SELECT 1 FROM AD_Process_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Process_ID=t.AD_Process_ID)
  ;
  
  -- 2017-09-26T15:53:45.539
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Process_Para (AD_Client_ID,AD_Element_ID,AD_Org_ID,AD_Process_ID,AD_Process_Para_ID,AD_Reference_ID,ColumnName,Created,CreatedBy,Description,EntityType,FieldLength,Help,IsActive,IsAutocomplete,IsCentrallyMaintained,IsEncrypted,IsMandatory,IsRange,Name,SeqNo,Updated,UpdatedBy) VALUES (0,558,0,540854,541218,30,'C_Order_ID',TO_TIMESTAMP('2017-09-26 15:53:45','YYYY-MM-DD HH24:MI:SS'),100,'Auftrag','de.metas.fresh',0,'The Order is a control document.  The  Order is complete when the quantity ordered is the same as the quantity shipped and invoiced.  When you cloase an order, unshipped (backordered) quantities are cancelled.','Y','N','Y','N','N','N','Auftrag',10,TO_TIMESTAMP('2017-09-26 15:53:45','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2017-09-26T15:53:45.542
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Process_Para_Trl (AD_Language,AD_Process_Para_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Process_Para_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_Process_Para t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Process_Para_ID=541218 AND NOT EXISTS (SELECT 1 FROM AD_Process_Para_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Process_Para_ID=t.AD_Process_Para_ID)
  ;
  
  -- 2017-09-26T15:54:31.552
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Process_Para (AD_Client_ID,AD_Org_ID,AD_Process_ID,AD_Process_Para_ID,AD_Reference_ID,ColumnName,Created,CreatedBy,EntityType,FieldLength,IsActive,IsAutocomplete,IsCentrallyMaintained,IsEncrypted,IsMandatory,IsRange,Name,SeqNo,Updated,UpdatedBy) VALUES (0,0,540854,541219,15,'preparationdate_st',TO_TIMESTAMP('2017-09-26 15:54:31','YYYY-MM-DD HH24:MI:SS'),100,'de.metas.fresh',0,'Y','N','Y','N','N','N','Preparationdate Start',20,TO_TIMESTAMP('2017-09-26 15:54:31','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2017-09-26T15:54:31.553
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Process_Para_Trl (AD_Language,AD_Process_Para_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Process_Para_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_Process_Para t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Process_Para_ID=541219 AND NOT EXISTS (SELECT 1 FROM AD_Process_Para_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Process_Para_ID=t.AD_Process_Para_ID)
  ;
  
  -- 2017-09-26T15:54:52.140
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Process_Para (AD_Client_ID,AD_Org_ID,AD_Process_ID,AD_Process_Para_ID,AD_Reference_ID,ColumnName,Created,CreatedBy,EntityType,FieldLength,IsActive,IsAutocomplete,IsCentrallyMaintained,IsEncrypted,IsMandatory,IsRange,Name,SeqNo,Updated,UpdatedBy) VALUES (0,0,540854,541221,15,'preparationdate_end',TO_TIMESTAMP('2017-09-26 15:54:52','YYYY-MM-DD HH24:MI:SS'),100,'de.metas.fresh',0,'Y','N','Y','N','N','N','Preparationdate End',30,TO_TIMESTAMP('2017-09-26 15:54:52','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2017-09-26T15:54:52.142
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Process_Para_Trl (AD_Language,AD_Process_Para_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Process_Para_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_Process_Para t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Process_Para_ID=541221 AND NOT EXISTS (SELECT 1 FROM AD_Process_Para_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Process_Para_ID=t.AD_Process_Para_ID)
  ;
  
  -- 2017-09-26T15:55:21.947
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Process_Para (AD_Client_ID,AD_Element_ID,AD_Org_ID,AD_Process_ID,AD_Process_Para_ID,AD_Reference_ID,ColumnName,Created,CreatedBy,DefaultValue,Description,EntityType,FieldLength,Help,IsActive,IsAutocomplete,IsCentrallyMaintained,IsEncrypted,IsMandatory,IsRange,Name,ReadOnlyLogic,SeqNo,Updated,UpdatedBy) VALUES (0,113,0,540854,541222,19,'AD_Org_ID',TO_TIMESTAMP('2017-09-26 15:55:21','YYYY-MM-DD HH24:MI:SS'),100,'@AD_Org_ID@','Organisatorische Einheit des Mandanten','de.metas.fresh',0,'Eine Organisation ist ein Bereich ihres Mandanten - z.B. Laden oder Abteilung. Sie können Daten über Organisationen hinweg gemeinsam verwenden.','Y','N','Y','N','Y','N','Sektion','1=1',40,TO_TIMESTAMP('2017-09-26 15:55:21','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2017-09-26T15:55:21.949
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Process_Para_Trl (AD_Language,AD_Process_Para_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Process_Para_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_Process_Para t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Process_Para_ID=541222 AND NOT EXISTS (SELECT 1 FROM AD_Process_Para_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Process_Para_ID=t.AD_Process_Para_ID)
  ;
  
  
  
  
  
  -- 2017-09-26T15:59:43.985
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Menu (Action,AD_Client_ID,AD_Menu_ID,AD_Org_ID,AD_Process_ID,Created,CreatedBy,EntityType,InternalName,IsActive,IsCreateNew,IsReadOnly,IsSOTrx,IsSummary,Name,Updated,UpdatedBy) VALUES ('R',0,540968,0,540854,TO_TIMESTAMP('2017-09-26 15:59:43','YYYY-MM-DD HH24:MI:SS'),100,'de.metas.fresh','Picking Terminal (Jasper)','Y','N','N','N','N','Picking Terminal (Jasper)',TO_TIMESTAMP('2017-09-26 15:59:43','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2017-09-26T15:59:43.989
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Menu_Trl (AD_Language,AD_Menu_ID, Description,Name,WEBUI_NameBrowse,WEBUI_NameNew,WEBUI_NameNewBreadcrumb, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Menu_ID, t.Description,t.Name,t.WEBUI_NameBrowse,t.WEBUI_NameNew,t.WEBUI_NameNewBreadcrumb, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Menu t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Menu_ID=540968 AND NOT EXISTS (SELECT 1 FROM AD_Menu_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Menu_ID=t.AD_Menu_ID)
  ;
  
  -- 2017-09-26T15:59:43.993
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT  INTO AD_TreeNodeMM (AD_Client_ID,AD_Org_ID, IsActive,Created,CreatedBy,Updated,UpdatedBy, AD_Tree_ID, Node_ID, Parent_ID, SeqNo) SELECT t.AD_Client_ID,0, 'Y', now(), 100, now(), 100,t.AD_Tree_ID, 540968, 0, 999 FROM AD_Tree t WHERE t.AD_Client_ID=0 AND t.IsActive='Y' AND t.IsAllNodes='Y' AND t.AD_Table_ID=116 AND NOT EXISTS (SELECT * FROM AD_TreeNodeMM e WHERE e.AD_Tree_ID=t.AD_Tree_ID AND Node_ID=540968)
  ;
  
  -- 2017-09-26T15:59:44.567
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=0, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540614 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.571
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=1, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540750 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.572
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=2, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540616 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.573
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=3, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540681 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.573
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=4, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540617 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.574
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=5, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540742 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.575
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=6, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540618 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.575
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=7, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540619 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.576
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=8, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540632 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.576
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=9, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540635 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.577
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=10, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540698 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.578
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=11, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540637 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.578
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=12, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540638 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.579
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=13, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540648 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.580
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=14, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540674 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.581
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=15, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540709 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.582
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=16, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540708 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.583
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=17, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540679 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.583
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=18, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540678 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.584
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=19, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540684 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.584
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=20, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540686 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.585
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=21, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540706 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.586
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=22, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540701 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.586
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=23, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540712 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.587
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=24, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540722 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.587
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=25, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540723 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.588
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=26, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540725 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.590
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=27, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540739 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.591
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=28, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540740 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.591
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=29, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540741 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.592
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=30, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540885 AND AD_Tree_ID=10
  ;
  
  -- 2017-09-26T15:59:44.593
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=540613, SeqNo=31, Updated=now(), UpdatedBy=100 WHERE  Node_ID=540968 AND AD_Tree_ID=10
  ;
  