text: -- 2020-01-06T11:42:54.494Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Message (AD_Client_ID,AD_Message_ID,AD_Org_ID,Created,CreatedBy,EntityType,IsActive,MsgText,MsgType,Updated,UpdatedBy,Value) VALUES (0,544952,0,TO_TIMESTAMP('2020-01-06 13:42:54','YYYY-MM-DD HH24:MI:SS'),100,'D','Y','No valid lines found in the selected shipments.
  Possible reason: the shipments were already exported to a customer invoice.','E',TO_TIMESTAMP('2020-01-06 13:42:54','YYYY-MM-DD HH24:MI:SS'),100,'M_InOut_Create_CustomsInvoice_NoValidLines')
  ;
  
  -- 2020-01-06T11:42:54.505Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Message_Trl (AD_Language,AD_Message_ID, MsgText,MsgTip, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Message_ID, t.MsgText,t.MsgTip, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Message t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N') AND t.AD_Message_ID=544952 AND NOT EXISTS (SELECT 1 FROM AD_Message_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Message_ID=t.AD_Message_ID)
  ;
  
  -- 2020-01-06T11:44:38.597Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Message SET MsgText='No valid lines found in the selected shipments.
  Possible reason: the shipments were already exported to a customs invoice.',Updated=TO_TIMESTAMP('2020-01-06 13:44:38','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Message_ID=544952
  ;
  
  -- 2020-01-06T11:54:54.613Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Message_Trl SET IsTranslated='Y', MsgText='Unter den ausgewählten Lieferungen sind keine exportierbaren Zeilen.
  Vermutlich wurden die Zeilen schon in eine Zollrechnung exportiert.',Updated=TO_TIMESTAMP('2020-01-06 13:54:54','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Language='de_CH' AND AD_Message_ID=544952
  ;
  
  -- 2020-01-06T11:55:09.859Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Message SET MsgText='Unter den ausgewählten Lieferungen sind keine exportierbaren Zeilen.
  Vermutlich wurden die Zeilen schon in eine Zollrechnung exportiert.',Updated=TO_TIMESTAMP('2020-01-06 13:55:09','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Message_ID=544952
  ;
  
  -- 2020-01-06T12:51:30.618Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM  AD_Message_Trl WHERE AD_Message_ID=544952
  ;
  
  -- 2020-01-06T12:51:30.628Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Message WHERE AD_Message_ID=544952
  ;
  
  -- 2020-01-06T13:21:09.748Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Table (AccessLevel,ACTriggerLength,AD_Client_ID,AD_Org_ID,AD_Table_ID,CopyColumnsFromTable,Created,CreatedBy,EntityType,ImportTable,IsActive,IsAutocomplete,IsChangeLog,IsDeleteable,IsDLM,IsEnableRemoteCacheInvalidation,IsHighVolume,IsSecurityEnabled,IsView,LoadSeq,Name,PersonalDataCategory,ReplicationType,TableName,Updated,UpdatedBy) VALUES ('4',0,0,0,541451,'N',TO_TIMESTAMP('2020-01-06 15:21:09','YYYY-MM-DD HH24:MI:SS'),100,'U','N','Y','N','N','Y','N','N','N','N','N',0,'M_InOutLine_To_C_Customs_Invoice_Line','NP','L','M_InOutLine_To_C_Customs_Invoice_Line',TO_TIMESTAMP('2020-01-06 15:21:09','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:21:09.753Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Table_Trl (AD_Language,AD_Table_ID, Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Table_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_Table t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N') AND t.AD_Table_ID=541451 AND NOT EXISTS (SELECT 1 FROM AD_Table_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Table_ID=t.AD_Table_ID)
  ;
  
  -- 2020-01-06T13:21:09.906Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Sequence (AD_Client_ID,AD_Org_ID,AD_Sequence_ID,Created,CreatedBy,CurrentNext,CurrentNextSys,Description,IncrementNo,IsActive,IsAudited,IsAutoSequence,IsTableID,Name,StartNewYear,StartNo,Updated,UpdatedBy) VALUES (0,0,555094,TO_TIMESTAMP('2020-01-06 15:21:09','YYYY-MM-DD HH24:MI:SS'),100,1000000,50000,'Table M_InOutLine_To_C_Customs_Invoice_Line',1,'Y','N','Y','Y','M_InOutLine_To_C_Customs_Invoice_Line','N',1000000,TO_TIMESTAMP('2020-01-06 15:21:09','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:21:09.941Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  CREATE SEQUENCE M_INOUTLINE_TO_C_CUSTOMS_INVOICE_LINE_SEQ INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1000000
  ;
  
  -- 2020-01-06T13:22:46.693Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Table SET AccessLevel='3', EntityType='D',Updated=TO_TIMESTAMP('2020-01-06 15:22:46','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Table_ID=541451
  ;
  
  -- 2020-01-06T13:23:01.689Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsCalculated,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569797,102,0,19,541451,'AD_Client_ID',TO_TIMESTAMP('2020-01-06 15:23:01','YYYY-MM-DD HH24:MI:SS'),100,'N','Mandant für diese Installation.','D',10,'Ein Mandant ist eine Firma oder eine juristische Person. Sie können keine Daten über Mandanten hinweg verwenden. .','Y','Y','N','N','N','N','N','N','Y','N','N','Y','N','N','Mandant',0,TO_TIMESTAMP('2020-01-06 15:23:01','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:23:01.697Z
  -- 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=569797 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:23:01.755Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(102) 
  ;
  
  -- 2020-01-06T13:23:02.979Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsCalculated,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569798,113,0,30,541451,'AD_Org_ID',TO_TIMESTAMP('2020-01-06 15:23:02','YYYY-MM-DD HH24:MI:SS'),100,'N','Organisatorische Einheit des Mandanten','D',10,'Eine Organisation ist ein Bereich ihres Mandanten - z.B. Laden oder Abteilung. Sie können Daten über Organisationen hinweg gemeinsam verwenden.','Y','Y','N','N','N','N','N','N','Y','N','Y','Y','N','N','Sektion',0,TO_TIMESTAMP('2020-01-06 15:23:02','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:23:02.983Z
  -- 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=569798 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:23:02.985Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(113) 
  ;
  
  -- 2020-01-06T13:23:03.328Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsCalculated,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569799,245,0,16,541451,'Created',TO_TIMESTAMP('2020-01-06 15:23:03','YYYY-MM-DD HH24:MI:SS'),100,'N','Datum, an dem dieser Eintrag erstellt wurde','D',29,'Das Feld Erstellt zeigt an, zu welchem Datum dieser Eintrag erstellt wurde.','Y','N','N','N','N','N','N','N','Y','N','N','Y','N','N','Erstellt',0,TO_TIMESTAMP('2020-01-06 15:23:03','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:23:03.329Z
  -- 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=569799 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:23:03.330Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(245) 
  ;
  
  -- 2020-01-06T13:23:03.623Z
  -- 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_Reference_Value_ID,AD_Table_ID,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsCalculated,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569800,246,0,18,110,541451,'CreatedBy',TO_TIMESTAMP('2020-01-06 15:23:03','YYYY-MM-DD HH24:MI:SS'),100,'N','Nutzer, der diesen Eintrag erstellt hat','D',10,'Das Feld Erstellt durch zeigt an, welcher Nutzer diesen Eintrag erstellt hat.','Y','N','N','N','N','N','N','N','Y','N','N','Y','N','N','Erstellt durch',0,TO_TIMESTAMP('2020-01-06 15:23:03','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:23:03.626Z
  -- 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=569800 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:23:03.629Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(246) 
  ;
  
  -- 2020-01-06T13:23:03.899Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsCalculated,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569801,348,0,20,541451,'IsActive',TO_TIMESTAMP('2020-01-06 15:23:03','YYYY-MM-DD HH24:MI:SS'),100,'N','Der Eintrag ist im System aktiv','D',1,'Es gibt zwei Möglichkeiten, einen Datensatz nicht mehr verfügbar zu machen: einer ist, ihn zu löschen; der andere, ihn zu deaktivieren. Ein deaktivierter Eintrag ist nicht mehr für eine Auswahl verfügbar, aber verfügbar für die Verwendung in Berichten. Es gibt zwei Gründe, Datensätze zu deaktivieren und nicht zu löschen: (1) Das System braucht den Datensatz für Revisionszwecke. (2) Der Datensatz wird von anderen Datensätzen referenziert. Z.B. können Sie keinen Geschäftspartner löschen, wenn es Rechnungen für diesen Geschäftspartner gibt. Sie deaktivieren den Geschäftspartner und verhindern, dass dieser Eintrag in zukünftigen Vorgängen verwendet wird.','Y','Y','N','N','N','N','N','N','Y','N','N','Y','N','Y','Aktiv',0,TO_TIMESTAMP('2020-01-06 15:23:03','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:23:03.902Z
  -- 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=569801 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:23:03.905Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(348) 
  ;
  
  -- 2020-01-06T13:23:04.206Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsCalculated,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569802,607,0,16,541451,'Updated',TO_TIMESTAMP('2020-01-06 15:23:04','YYYY-MM-DD HH24:MI:SS'),100,'N','Datum, an dem dieser Eintrag aktualisiert wurde','D',29,'Aktualisiert zeigt an, wann dieser Eintrag aktualisiert wurde.','Y','N','N','N','N','N','N','N','Y','N','N','Y','N','N','Aktualisiert',0,TO_TIMESTAMP('2020-01-06 15:23:04','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:23:04.210Z
  -- 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=569802 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:23:04.213Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(607) 
  ;
  
  -- 2020-01-06T13:23:04.420Z
  -- 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_Reference_Value_ID,AD_Table_ID,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsCalculated,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569803,608,0,18,110,541451,'UpdatedBy',TO_TIMESTAMP('2020-01-06 15:23:04','YYYY-MM-DD HH24:MI:SS'),100,'N','Nutzer, der diesen Eintrag aktualisiert hat','D',10,'Aktualisiert durch zeigt an, welcher Nutzer diesen Eintrag aktualisiert hat.','Y','N','N','N','N','N','N','N','Y','N','N','Y','N','N','Aktualisiert durch',0,TO_TIMESTAMP('2020-01-06 15:23:04','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:23:04.423Z
  -- 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=569803 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:23:04.427Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(608) 
  ;
  
  -- 2020-01-06T13:23:04.701Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Element (AD_Client_ID,AD_Element_ID,AD_Org_ID,ColumnName,Created,CreatedBy,EntityType,IsActive,Name,PrintName,Updated,UpdatedBy) VALUES (0,577450,0,'M_InOutLine_To_C_Customs_Invoice_Line_ID',TO_TIMESTAMP('2020-01-06 15:23:04','YYYY-MM-DD HH24:MI:SS'),100,'D','Y','M_InOutLine_To_C_Customs_Invoice_Line','M_InOutLine_To_C_Customs_Invoice_Line',TO_TIMESTAMP('2020-01-06 15:23:04','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:23:04.710Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Element_Trl (AD_Language,AD_Element_ID, CommitWarning,Description,Help,Name,PO_Description,PO_Help,PO_Name,PO_PrintName,PrintName,WEBUI_NameBrowse,WEBUI_NameNew,WEBUI_NameNewBreadcrumb, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Element_ID, t.CommitWarning,t.Description,t.Help,t.Name,t.PO_Description,t.PO_Help,t.PO_Name,t.PO_PrintName,t.PrintName,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_Element t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y' OR l.IsBaseLanguage='Y') AND t.AD_Element_ID=577450 AND NOT EXISTS (SELECT 1 FROM AD_Element_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Element_ID=t.AD_Element_ID)
  ;
  
  -- 2020-01-06T13:23:04.836Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,EntityType,FieldLength,IsActive,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsCalculated,IsEncrypted,IsIdentifier,IsKey,IsMandatory,IsParent,IsSelectionColumn,IsSyncDatabase,IsTranslated,IsUpdateable,Name,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569804,577450,0,13,541451,'M_InOutLine_To_C_Customs_Invoice_Line_ID',TO_TIMESTAMP('2020-01-06 15:23:04','YYYY-MM-DD HH24:MI:SS'),100,'N','D',10,'Y','N','N','N','N','N','Y','Y','N','N','Y','N','N','M_InOutLine_To_C_Customs_Invoice_Line',0,TO_TIMESTAMP('2020-01-06 15:23:04','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:23:04.838Z
  -- 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=569804 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:23:04.840Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(577450) 
  ;
  
  -- 2020-01-06T13:23:31.426Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAdvancedText,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsAutocomplete,IsCalculated,IsDimension,IsDLMPartitionBoundary,IsEncrypted,IsForceIncludeInGeneratedModel,IsGenericZoomKeyColumn,IsGenericZoomOrigin,IsIdentifier,IsKey,IsLazyLoading,IsMandatory,IsParent,IsRangeFilter,IsSelectionColumn,IsShowFilterIncrementButtons,IsStaleable,IsSyncDatabase,IsTranslated,IsUpdateable,IsUseDocSequence,Name,SelectionColumnSeqNo,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569805,1026,0,30,541451,'M_InOutLine_ID',TO_TIMESTAMP('2020-01-06 15:23:31','YYYY-MM-DD HH24:MI:SS'),100,'N','Position auf Versand- oder Wareneingangsbeleg','D',10,'"Versand-/Wareneingangsposition" bezeichnet eine einzelne Zeile/Position auf einem Versand- oder Wareneingangsbeleg.','Y','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','Y','N','Versand-/Wareneingangsposition',0,0,TO_TIMESTAMP('2020-01-06 15:23:31','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:23:31.431Z
  -- 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=569805 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:23:31.435Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(1026) 
  ;
  
  -- 2020-01-06T13:23:44.436Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,EntityType,FieldLength,IsActive,IsAdvancedText,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsAutocomplete,IsCalculated,IsDimension,IsDLMPartitionBoundary,IsEncrypted,IsForceIncludeInGeneratedModel,IsGenericZoomKeyColumn,IsGenericZoomOrigin,IsIdentifier,IsKey,IsLazyLoading,IsMandatory,IsParent,IsRangeFilter,IsSelectionColumn,IsShowFilterIncrementButtons,IsStaleable,IsSyncDatabase,IsTranslated,IsUpdateable,IsUseDocSequence,Name,SelectionColumnSeqNo,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569806,576742,0,30,541451,'C_Customs_Invoice_Line_ID',TO_TIMESTAMP('2020-01-06 15:23:44','YYYY-MM-DD HH24:MI:SS'),100,'N','D',10,'Y','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','Y','N','Customs Invoice Line',0,0,TO_TIMESTAMP('2020-01-06 15:23:44','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:23:44.444Z
  -- 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=569806 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:23:44.448Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(576742) 
  ;
  
  -- 2020-01-06T13:23:56.790Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAdvancedText,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsAutocomplete,IsCalculated,IsDimension,IsDLMPartitionBoundary,IsEncrypted,IsForceIncludeInGeneratedModel,IsGenericZoomKeyColumn,IsGenericZoomOrigin,IsIdentifier,IsKey,IsLazyLoading,IsMandatory,IsParent,IsRangeFilter,IsSelectionColumn,IsShowFilterIncrementButtons,IsStaleable,IsSyncDatabase,IsTranslated,IsUpdateable,IsUseDocSequence,Name,SelectionColumnSeqNo,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569807,1025,0,30,541451,'M_InOut_ID',TO_TIMESTAMP('2020-01-06 15:23:56','YYYY-MM-DD HH24:MI:SS'),100,'N','Material Shipment Document','D',10,'The Material Shipment / Receipt ','Y','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','Y','N','Lieferung/Wareneingang',0,0,TO_TIMESTAMP('2020-01-06 15:23:56','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:23:56.795Z
  -- 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=569807 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:23:56.798Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(1025) 
  ;
  
  -- 2020-01-06T13:24:05.521Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,EntityType,FieldLength,IsActive,IsAdvancedText,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsAutocomplete,IsCalculated,IsDimension,IsDLMPartitionBoundary,IsEncrypted,IsForceIncludeInGeneratedModel,IsGenericZoomKeyColumn,IsGenericZoomOrigin,IsIdentifier,IsKey,IsLazyLoading,IsMandatory,IsParent,IsRangeFilter,IsSelectionColumn,IsShowFilterIncrementButtons,IsStaleable,IsSyncDatabase,IsTranslated,IsUpdateable,IsUseDocSequence,Name,SelectionColumnSeqNo,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569808,576740,0,30,541451,'C_Customs_Invoice_ID',TO_TIMESTAMP('2020-01-06 15:24:05','YYYY-MM-DD HH24:MI:SS'),100,'N','D',10,'Y','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','Y','N','Zollrechnung',0,0,TO_TIMESTAMP('2020-01-06 15:24:05','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:24:05.525Z
  -- 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=569808 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:24:05.543Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(576740) 
  ;
  
  -- 2020-01-06T13:24:22.647Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAdvancedText,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsAutocomplete,IsCalculated,IsDimension,IsDLMPartitionBoundary,IsEncrypted,IsForceIncludeInGeneratedModel,IsGenericZoomKeyColumn,IsGenericZoomOrigin,IsIdentifier,IsKey,IsLazyLoading,IsMandatory,IsParent,IsRangeFilter,IsSelectionColumn,IsShowFilterIncrementButtons,IsStaleable,IsSyncDatabase,IsTranslated,IsUpdateable,IsUseDocSequence,Name,SelectionColumnSeqNo,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569809,454,0,30,541451,'M_Product_ID',TO_TIMESTAMP('2020-01-06 15:24:22','YYYY-MM-DD HH24:MI:SS'),100,'N','Produkt, Leistung, Artikel','D',10,'Bezeichnet eine Einheit, die in dieser Organisation gekauft oder verkauft wird.','Y','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','Y','N','Produkt',0,0,TO_TIMESTAMP('2020-01-06 15:24:22','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:24:22.650Z
  -- 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=569809 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:24:22.670Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(454) 
  ;
  
  -- 2020-01-06T13:27:06.433Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAdvancedText,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsAutocomplete,IsCalculated,IsDimension,IsDLMPartitionBoundary,IsEncrypted,IsForceIncludeInGeneratedModel,IsGenericZoomKeyColumn,IsGenericZoomOrigin,IsIdentifier,IsKey,IsLazyLoading,IsMandatory,IsParent,IsRangeFilter,IsSelectionColumn,IsShowFilterIncrementButtons,IsStaleable,IsSyncDatabase,IsTranslated,IsUpdateable,IsUseDocSequence,Name,SelectionColumnSeqNo,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569810,1038,0,29,541451,'MovementQty',TO_TIMESTAMP('2020-01-06 15:27:06','YYYY-MM-DD HH24:MI:SS'),100,'N','Menge eines bewegten Produktes.','D',10,'Die "Bewegungs-Menge" bezeichnet die Menge einer Ware, die bewegt wurde.','Y','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','Y','N','Bewegungs-Menge',0,0,TO_TIMESTAMP('2020-01-06 15:27:06','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:27:06.435Z
  -- 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=569810 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:27:06.437Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(1038) 
  ;
  
  -- 2020-01-06T13:27:18.020Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAdvancedText,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsAutocomplete,IsCalculated,IsDimension,IsDLMPartitionBoundary,IsEncrypted,IsForceIncludeInGeneratedModel,IsGenericZoomKeyColumn,IsGenericZoomOrigin,IsIdentifier,IsKey,IsLazyLoading,IsMandatory,IsParent,IsRangeFilter,IsSelectionColumn,IsShowFilterIncrementButtons,IsStaleable,IsSyncDatabase,IsTranslated,IsUpdateable,IsUseDocSequence,Name,SelectionColumnSeqNo,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569811,215,0,19,541451,'C_UOM_ID',TO_TIMESTAMP('2020-01-06 15:27:17','YYYY-MM-DD HH24:MI:SS'),100,'N','Maßeinheit','D',10,'Eine eindeutige (nicht monetäre) Maßeinheit','Y','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','Y','N','Maßeinheit',0,0,TO_TIMESTAMP('2020-01-06 15:27:17','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:27:18.025Z
  -- 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=569811 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:27:18.026Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(215) 
  ;
  
  -- 2020-01-06T13:29:45.319Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAdvancedText,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsAutocomplete,IsCalculated,IsDimension,IsDLMPartitionBoundary,IsEncrypted,IsForceIncludeInGeneratedModel,IsGenericZoomKeyColumn,IsGenericZoomOrigin,IsIdentifier,IsKey,IsLazyLoading,IsMandatory,IsParent,IsRangeFilter,IsSelectionColumn,IsShowFilterIncrementButtons,IsStaleable,IsSyncDatabase,IsTranslated,IsUpdateable,IsUseDocSequence,Name,SelectionColumnSeqNo,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569812,519,0,37,541451,'PriceActual',TO_TIMESTAMP('2020-01-06 15:29:45','YYYY-MM-DD HH24:MI:SS'),100,'N','Effektiver Preis','D',14,'Der Einzelpreis oder Effektive Preis bezeichnet den Preis für das Produkt in Ausgangswährung.','Y','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','Y','N','Einzelpreis',0,0,TO_TIMESTAMP('2020-01-06 15:29:45','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:29:45.323Z
  -- 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=569812 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:29:45.327Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(519) 
  ;
  
  -- 2020-01-06T13:30:06.862Z
  -- 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,ColumnName,Created,CreatedBy,DDL_NoForeignKey,Description,EntityType,FieldLength,Help,IsActive,IsAdvancedText,IsAllowLogging,IsAlwaysUpdateable,IsAutoApplyValidationRule,IsAutocomplete,IsCalculated,IsDimension,IsDLMPartitionBoundary,IsEncrypted,IsForceIncludeInGeneratedModel,IsGenericZoomKeyColumn,IsGenericZoomOrigin,IsIdentifier,IsKey,IsLazyLoading,IsMandatory,IsParent,IsRangeFilter,IsSelectionColumn,IsShowFilterIncrementButtons,IsStaleable,IsSyncDatabase,IsTranslated,IsUpdateable,IsUseDocSequence,Name,SelectionColumnSeqNo,SeqNo,Updated,UpdatedBy,Version) VALUES (0,569813,193,0,19,541451,'C_Currency_ID',TO_TIMESTAMP('2020-01-06 15:30:06','YYYY-MM-DD HH24:MI:SS'),100,'N','Die Währung für diesen Eintrag','D',10,'Bezeichnet die auf Dokumenten oder Berichten verwendete Währung','Y','N','Y','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','Y','N','Währung',0,0,TO_TIMESTAMP('2020-01-06 15:30:06','YYYY-MM-DD HH24:MI:SS'),100,0)
  ;
  
  -- 2020-01-06T13:30:06.866Z
  -- 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=569813 AND NOT EXISTS (SELECT 1 FROM AD_Column_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Column_ID=t.AD_Column_ID)
  ;
  
  -- 2020-01-06T13:30:06.869Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(193) 
  ;
  
  -- 2020-01-06T13:30:11.363Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ CREATE TABLE public.M_InOutLine_To_C_Customs_Invoice_Line (AD_Client_ID NUMERIC(10) NOT NULL, AD_Org_ID NUMERIC(10) NOT NULL, C_Currency_ID NUMERIC(10), C_Customs_Invoice_ID NUMERIC(10), C_Customs_Invoice_Line_ID NUMERIC(10), C_UOM_ID NUMERIC(10), Created TIMESTAMP WITH TIME ZONE NOT NULL, CreatedBy NUMERIC(10) NOT NULL, IsActive CHAR(1) CHECK (IsActive IN ('Y','N')) NOT NULL, M_InOut_ID NUMERIC(10), M_InOutLine_ID NUMERIC(10), M_InOutLine_To_C_Customs_Invoice_Line_ID NUMERIC(10) NOT NULL, M_Product_ID NUMERIC(10), MovementQty NUMERIC, PriceActual NUMERIC, Updated TIMESTAMP WITH TIME ZONE NOT NULL, UpdatedBy NUMERIC(10) NOT NULL, CONSTRAINT CCurrency_MInOutLineToCCustomsInvoiceLine FOREIGN KEY (C_Currency_ID) REFERENCES public.C_Currency DEFERRABLE INITIALLY DEFERRED, CONSTRAINT CCustomsInvoice_MInOutLineToCCustomsInvoiceLine FOREIGN KEY (C_Customs_Invoice_ID) REFERENCES public.C_Customs_Invoice DEFERRABLE INITIALLY DEFERRED, CONSTRAINT CCustomsInvoiceLine_MInOutLineToCCustomsInvoiceLine FOREIGN KEY (C_Customs_Invoice_Line_ID) REFERENCES public.C_Customs_Invoice_Line DEFERRABLE INITIALLY DEFERRED, CONSTRAINT CUOM_MInOutLineToCCustomsInvoiceLine FOREIGN KEY (C_UOM_ID) REFERENCES public.C_UOM DEFERRABLE INITIALLY DEFERRED, CONSTRAINT MInOut_MInOutLineToCCustomsInvoiceLine FOREIGN KEY (M_InOut_ID) REFERENCES public.M_InOut DEFERRABLE INITIALLY DEFERRED, CONSTRAINT MInOutLine_MInOutLineToCCustomsInvoiceLine FOREIGN KEY (M_InOutLine_ID) REFERENCES public.M_InOutLine DEFERRABLE INITIALLY DEFERRED, CONSTRAINT M_InOutLine_To_C_Customs_Invoice_Line_Key PRIMARY KEY (M_InOutLine_To_C_Customs_Invoice_Line_ID), CONSTRAINT MProduct_MInOutLineToCCustomsInvoiceLine FOREIGN KEY (M_Product_ID) REFERENCES public.M_Product DEFERRABLE INITIALLY DEFERRED)
  ;
  
  -- 2020-01-06T13:30:51.504Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Window (AD_Client_ID,AD_Element_ID,AD_Org_ID,AD_Window_ID,Created,CreatedBy,EntityType,IsActive,IsBetaFunctionality,IsDefault,IsEnableRemoteCacheInvalidation,IsOneInstanceOnly,IsSOTrx,Name,Processing,Updated,UpdatedBy,WindowType,WinHeight,WinWidth) VALUES (0,577450,0,540833,TO_TIMESTAMP('2020-01-06 15:30:51','YYYY-MM-DD HH24:MI:SS'),100,'U','Y','N','N','N','N','Y','M_InOutLine_To_C_Customs_Invoice_Line','N',TO_TIMESTAMP('2020-01-06 15:30:51','YYYY-MM-DD HH24:MI:SS'),100,'M',0,0)
  ;
  
  -- 2020-01-06T13:30:51.510Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Window_Trl (AD_Language,AD_Window_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Window_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_Window t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N') AND t.AD_Window_ID=540833 AND NOT EXISTS (SELECT 1 FROM AD_Window_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Window_ID=t.AD_Window_ID)
  ;
  
  -- 2020-01-06T13:30:51.514Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_window_translation_from_ad_element(577450) 
  ;
  
  -- 2020-01-06T13:30:51.528Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Window_ID=540833
  ;
  
  -- 2020-01-06T13:30:51.536Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Window(540833)
  ;
  
  -- 2020-01-06T13:31:15.095Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Tab (AD_Client_ID,AD_Element_ID,AD_Org_ID,AD_Tab_ID,AD_Table_ID,AD_Window_ID,AllowQuickInput,Created,CreatedBy,EntityType,HasTree,ImportFields,InternalName,IsActive,IsAdvancedTab,IsCheckParentsChanged,IsGenericZoomTarget,IsGridModeOnly,IsInfoTab,IsInsertRecord,IsQueryOnLoad,IsReadOnly,IsRefreshAllOnActivate,IsRefreshViewOnChangeEvents,IsSearchActive,IsSearchCollapsed,IsSingleRow,IsSortTab,IsTranslationTab,MaxQueryRecords,Name,Processing,SeqNo,TabLevel,Updated,UpdatedBy) VALUES (0,577450,0,542171,541451,540833,'Y',TO_TIMESTAMP('2020-01-06 15:31:14','YYYY-MM-DD HH24:MI:SS'),100,'D','N','N','M_InOutLine_To_C_Customs_Invoice_Line','Y','N','Y','N','N','N','Y','Y','N','N','N','Y','Y','N','N','N',0,'M_InOutLine_To_C_Customs_Invoice_Line','N',10,0,TO_TIMESTAMP('2020-01-06 15:31:14','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:15.102Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Tab_Trl (AD_Language,AD_Tab_ID, CommitWarning,Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Tab_ID, t.CommitWarning,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_Tab t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N') AND t.AD_Tab_ID=542171 AND NOT EXISTS (SELECT 1 FROM AD_Tab_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Tab_ID=t.AD_Tab_ID)
  ;
  
  -- 2020-01-06T13:31:15.108Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_tab_translation_from_ad_element(577450) 
  ;
  
  -- 2020-01-06T13:31:15.110Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Tab(542171)
  ;
  
  -- 2020-01-06T13:31:37.445Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,Help,IsActive,IsDisplayed,IsDisplayedGrid,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,Updated,UpdatedBy) VALUES (0,569797,593828,0,542171,TO_TIMESTAMP('2020-01-06 15:31:37','YYYY-MM-DD HH24:MI:SS'),100,'Mandant für diese Installation.',10,'D','Ein Mandant ist eine Firma oder eine juristische Person. Sie können keine Daten über Mandanten hinweg verwenden. .','Y','N','N','N','N','N','Y','N','Mandant',TO_TIMESTAMP('2020-01-06 15:31:37','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:37.449Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  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=593828 AND NOT EXISTS (SELECT 1 FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
  ;
  
  -- 2020-01-06T13:31:37.455Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(102) 
  ;
  
  -- 2020-01-06T13:31:38.531Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=593828
  ;
  
  -- 2020-01-06T13:31:38.561Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(593828)
  ;
  
  -- 2020-01-06T13:31:38.690Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,Help,IsActive,IsDisplayed,IsDisplayedGrid,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,Updated,UpdatedBy) VALUES (0,569798,593829,0,542171,TO_TIMESTAMP('2020-01-06 15:31:38','YYYY-MM-DD HH24:MI:SS'),100,'Organisatorische Einheit des Mandanten',10,'D','Eine Organisation ist ein Bereich ihres Mandanten - z.B. Laden oder Abteilung. Sie können Daten über Organisationen hinweg gemeinsam verwenden.','Y','N','N','N','N','N','N','N','Sektion',TO_TIMESTAMP('2020-01-06 15:31:38','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:38.691Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  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=593829 AND NOT EXISTS (SELECT 1 FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
  ;
  
  -- 2020-01-06T13:31:38.692Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(113) 
  ;
  
  -- 2020-01-06T13:31:38.985Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=593829
  ;
  
  -- 2020-01-06T13:31:38.986Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(593829)
  ;
  
  -- 2020-01-06T13:31:39.127Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,Help,IsActive,IsDisplayed,IsDisplayedGrid,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,Updated,UpdatedBy) VALUES (0,569801,593830,0,542171,TO_TIMESTAMP('2020-01-06 15:31:38','YYYY-MM-DD HH24:MI:SS'),100,'Der Eintrag ist im System aktiv',1,'D','Es gibt zwei Möglichkeiten, einen Datensatz nicht mehr verfügbar zu machen: einer ist, ihn zu löschen; der andere, ihn zu deaktivieren. Ein deaktivierter Eintrag ist nicht mehr für eine Auswahl verfügbar, aber verfügbar für die Verwendung in Berichten. Es gibt zwei Gründe, Datensätze zu deaktivieren und nicht zu löschen: (1) Das System braucht den Datensatz für Revisionszwecke. (2) Der Datensatz wird von anderen Datensätzen referenziert. Z.B. können Sie keinen Geschäftspartner löschen, wenn es Rechnungen für diesen Geschäftspartner gibt. Sie deaktivieren den Geschäftspartner und verhindern, dass dieser Eintrag in zukünftigen Vorgängen verwendet wird.','Y','N','N','N','N','N','N','N','Aktiv',TO_TIMESTAMP('2020-01-06 15:31:38','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:39.128Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  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=593830 AND NOT EXISTS (SELECT 1 FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
  ;
  
  -- 2020-01-06T13:31:39.129Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(348) 
  ;
  
  -- 2020-01-06T13:31:39.661Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=593830
  ;
  
  -- 2020-01-06T13:31:39.662Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(593830)
  ;
  
  -- 2020-01-06T13:31:39.776Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,DisplayLength,EntityType,IsActive,IsDisplayed,IsDisplayedGrid,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,Updated,UpdatedBy) VALUES (0,569804,593831,0,542171,TO_TIMESTAMP('2020-01-06 15:31:39','YYYY-MM-DD HH24:MI:SS'),100,10,'D','Y','N','N','N','N','N','N','N','M_InOutLine_To_C_Customs_Invoice_Line',TO_TIMESTAMP('2020-01-06 15:31:39','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:39.778Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  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=593831 AND NOT EXISTS (SELECT 1 FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
  ;
  
  -- 2020-01-06T13:31:39.781Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(577450) 
  ;
  
  -- 2020-01-06T13:31:39.787Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=593831
  ;
  
  -- 2020-01-06T13:31:39.788Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(593831)
  ;
  
  -- 2020-01-06T13:31:39.905Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,Help,IsActive,IsDisplayed,IsDisplayedGrid,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,Updated,UpdatedBy) VALUES (0,569805,593832,0,542171,TO_TIMESTAMP('2020-01-06 15:31:39','YYYY-MM-DD HH24:MI:SS'),100,'Position auf Versand- oder Wareneingangsbeleg',10,'D','"Versand-/Wareneingangsposition" bezeichnet eine einzelne Zeile/Position auf einem Versand- oder Wareneingangsbeleg.','Y','N','N','N','N','N','N','N','Versand-/Wareneingangsposition',TO_TIMESTAMP('2020-01-06 15:31:39','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:39.906Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  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=593832 AND NOT EXISTS (SELECT 1 FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
  ;
  
  -- 2020-01-06T13:31:39.908Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(1026) 
  ;
  
  -- 2020-01-06T13:31:39.927Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=593832
  ;
  
  -- 2020-01-06T13:31:39.927Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(593832)
  ;
  
  -- 2020-01-06T13:31:40.031Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,DisplayLength,EntityType,IsActive,IsDisplayed,IsDisplayedGrid,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,Updated,UpdatedBy) VALUES (0,569806,593833,0,542171,TO_TIMESTAMP('2020-01-06 15:31:39','YYYY-MM-DD HH24:MI:SS'),100,10,'D','Y','N','N','N','N','N','N','N','Customs Invoice Line',TO_TIMESTAMP('2020-01-06 15:31:39','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:40.034Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  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=593833 AND NOT EXISTS (SELECT 1 FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
  ;
  
  -- 2020-01-06T13:31:40.038Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(576742) 
  ;
  
  -- 2020-01-06T13:31:40.045Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=593833
  ;
  
  -- 2020-01-06T13:31:40.045Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(593833)
  ;
  
  -- 2020-01-06T13:31:40.156Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,Help,IsActive,IsDisplayed,IsDisplayedGrid,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,Updated,UpdatedBy) VALUES (0,569807,593834,0,542171,TO_TIMESTAMP('2020-01-06 15:31:40','YYYY-MM-DD HH24:MI:SS'),100,'Material Shipment Document',10,'D','The Material Shipment / Receipt ','Y','N','N','N','N','N','N','N','Lieferung/Wareneingang',TO_TIMESTAMP('2020-01-06 15:31:40','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:40.159Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  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=593834 AND NOT EXISTS (SELECT 1 FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
  ;
  
  -- 2020-01-06T13:31:40.162Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(1025) 
  ;
  
  -- 2020-01-06T13:31:40.176Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=593834
  ;
  
  -- 2020-01-06T13:31:40.177Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(593834)
  ;
  
  -- 2020-01-06T13:31:40.285Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,DisplayLength,EntityType,IsActive,IsDisplayed,IsDisplayedGrid,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,Updated,UpdatedBy) VALUES (0,569808,593835,0,542171,TO_TIMESTAMP('2020-01-06 15:31:40','YYYY-MM-DD HH24:MI:SS'),100,10,'D','Y','N','N','N','N','N','N','N','Zollrechnung',TO_TIMESTAMP('2020-01-06 15:31:40','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:40.286Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  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=593835 AND NOT EXISTS (SELECT 1 FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
  ;
  
  -- 2020-01-06T13:31:40.288Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(576740) 
  ;
  
  -- 2020-01-06T13:31:40.290Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=593835
  ;
  
  -- 2020-01-06T13:31:40.290Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(593835)
  ;
  
  -- 2020-01-06T13:31:40.398Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,Help,IsActive,IsDisplayed,IsDisplayedGrid,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,Updated,UpdatedBy) VALUES (0,569809,593836,0,542171,TO_TIMESTAMP('2020-01-06 15:31:40','YYYY-MM-DD HH24:MI:SS'),100,'Produkt, Leistung, Artikel',10,'D','Bezeichnet eine Einheit, die in dieser Organisation gekauft oder verkauft wird.','Y','N','N','N','N','N','N','N','Produkt',TO_TIMESTAMP('2020-01-06 15:31:40','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:40.401Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  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=593836 AND NOT EXISTS (SELECT 1 FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
  ;
  
  -- 2020-01-06T13:31:40.403Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(454) 
  ;
  
  -- 2020-01-06T13:31:40.684Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=593836
  ;
  
  -- 2020-01-06T13:31:40.685Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(593836)
  ;
  
  -- 2020-01-06T13:31:40.794Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,Help,IsActive,IsDisplayed,IsDisplayedGrid,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,Updated,UpdatedBy) VALUES (0,569810,593837,0,542171,TO_TIMESTAMP('2020-01-06 15:31:40','YYYY-MM-DD HH24:MI:SS'),100,'Menge eines bewegten Produktes.',10,'D','Die "Bewegungs-Menge" bezeichnet die Menge einer Ware, die bewegt wurde.','Y','N','N','N','N','N','N','N','Bewegungs-Menge',TO_TIMESTAMP('2020-01-06 15:31:40','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:40.797Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  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=593837 AND NOT EXISTS (SELECT 1 FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
  ;
  
  -- 2020-01-06T13:31:40.800Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(1038) 
  ;
  
  -- 2020-01-06T13:31:40.809Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=593837
  ;
  
  -- 2020-01-06T13:31:40.810Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(593837)
  ;
  
  -- 2020-01-06T13:31:40.917Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,Help,IsActive,IsDisplayed,IsDisplayedGrid,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,Updated,UpdatedBy) VALUES (0,569811,593838,0,542171,TO_TIMESTAMP('2020-01-06 15:31:40','YYYY-MM-DD HH24:MI:SS'),100,'Maßeinheit',10,'D','Eine eindeutige (nicht monetäre) Maßeinheit','Y','N','N','N','N','N','N','N','Maßeinheit',TO_TIMESTAMP('2020-01-06 15:31:40','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:40.920Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  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=593838 AND NOT EXISTS (SELECT 1 FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
  ;
  
  -- 2020-01-06T13:31:40.923Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(215) 
  ;
  
  -- 2020-01-06T13:31:41.041Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=593838
  ;
  
  -- 2020-01-06T13:31:41.042Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(593838)
  ;
  
  -- 2020-01-06T13:31:41.149Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,Help,IsActive,IsDisplayed,IsDisplayedGrid,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,Updated,UpdatedBy) VALUES (0,569812,593839,0,542171,TO_TIMESTAMP('2020-01-06 15:31:41','YYYY-MM-DD HH24:MI:SS'),100,'Effektiver Preis',14,'D','Der Einzelpreis oder Effektive Preis bezeichnet den Preis für das Produkt in Ausgangswährung.','Y','N','N','N','N','N','N','N','Einzelpreis',TO_TIMESTAMP('2020-01-06 15:31:41','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:41.152Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  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=593839 AND NOT EXISTS (SELECT 1 FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
  ;
  
  -- 2020-01-06T13:31:41.155Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(519) 
  ;
  
  -- 2020-01-06T13:31:41.166Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=593839
  ;
  
  -- 2020-01-06T13:31:41.167Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(593839)
  ;
  
  -- 2020-01-06T13:31:41.276Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Client_ID,AD_Column_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,Created,CreatedBy,Description,DisplayLength,EntityType,Help,IsActive,IsDisplayed,IsDisplayedGrid,IsEncrypted,IsFieldOnly,IsHeading,IsReadOnly,IsSameLine,Name,Updated,UpdatedBy) VALUES (0,569813,593840,0,542171,TO_TIMESTAMP('2020-01-06 15:31:41','YYYY-MM-DD HH24:MI:SS'),100,'Die Währung für diesen Eintrag',10,'D','Bezeichnet die auf Dokumenten oder Berichten verwendete Währung','Y','N','N','N','N','N','N','N','Währung',TO_TIMESTAMP('2020-01-06 15:31:41','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:31:41.278Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  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=593840 AND NOT EXISTS (SELECT 1 FROM AD_Field_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Field_ID=t.AD_Field_ID)
  ;
  
  -- 2020-01-06T13:31:41.281Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(193) 
  ;
  
  -- 2020-01-06T13:31:41.451Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=593840
  ;
  
  -- 2020-01-06T13:31:41.452Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(593840)
  ;
  
  -- 2020-01-06T13:32:02.640Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y',Updated=TO_TIMESTAMP('2020-01-06 15:32:02','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=593828
  ;
  
  -- 2020-01-06T13:32:04.009Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y',Updated=TO_TIMESTAMP('2020-01-06 15:32:04','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=593829
  ;
  
  -- 2020-01-06T13:32:07.016Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y',Updated=TO_TIMESTAMP('2020-01-06 15:32:07','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=593830
  ;
  
  -- 2020-01-06T13:32:10.983Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y',Updated=TO_TIMESTAMP('2020-01-06 15:32:10','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=593832
  ;
  
  -- 2020-01-06T13:32:12.071Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y',Updated=TO_TIMESTAMP('2020-01-06 15:32:12','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=593833
  ;
  
  -- 2020-01-06T13:32:12.724Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y',Updated=TO_TIMESTAMP('2020-01-06 15:32:12','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=593834
  ;
  
  -- 2020-01-06T13:32:13.897Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y',Updated=TO_TIMESTAMP('2020-01-06 15:32:13','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=593835
  ;
  
  -- 2020-01-06T13:32:15.015Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y',Updated=TO_TIMESTAMP('2020-01-06 15:32:15','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=593836
  ;
  
  -- 2020-01-06T13:32:16.157Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y',Updated=TO_TIMESTAMP('2020-01-06 15:32:16','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=593837
  ;
  
  -- 2020-01-06T13:32:16.799Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y',Updated=TO_TIMESTAMP('2020-01-06 15:32:16','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=593838
  ;
  
  -- 2020-01-06T13:32:17.655Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y',Updated=TO_TIMESTAMP('2020-01-06 15:32:17','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=593839
  ;
  
  -- 2020-01-06T13:32:19.227Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y',Updated=TO_TIMESTAMP('2020-01-06 15:32:19','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=593840
  ;
  
  -- 2020-01-06T13:32:29.225Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Section (AD_Client_ID,AD_Org_ID,AD_Tab_ID,AD_UI_Section_ID,Created,CreatedBy,IsActive,SeqNo,Updated,UpdatedBy,Value) VALUES (0,0,542171,541698,TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100,'Y',10,TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100,'main')
  ;
  
  -- 2020-01-06T13:32:29.237Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Section_Trl (AD_Language,AD_UI_Section_ID, Description,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_UI_Section_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_UI_Section t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N') AND t.AD_UI_Section_ID=541698 AND NOT EXISTS (SELECT 1 FROM AD_UI_Section_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_UI_Section_ID=t.AD_UI_Section_ID)
  ;
  
  -- 2020-01-06T13:32:29.435Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Column (AD_Client_ID,AD_Org_ID,AD_UI_Column_ID,AD_UI_Section_ID,Created,CreatedBy,IsActive,SeqNo,Updated,UpdatedBy) VALUES (0,0,542165,541698,TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100,'Y',10,TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:29.550Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Column (AD_Client_ID,AD_Org_ID,AD_UI_Column_ID,AD_UI_Section_ID,Created,CreatedBy,IsActive,SeqNo,Updated,UpdatedBy) VALUES (0,0,542166,541698,TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100,'Y',20,TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:29.694Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_ElementGroup (AD_Client_ID,AD_Org_ID,AD_UI_Column_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,IsActive,Name,SeqNo,UIStyle,Updated,UpdatedBy) VALUES (0,0,542165,543293,TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100,'Y','default',10,'primary',TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:29.871Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Element (AD_Client_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,AD_UI_Element_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,Description,Help,IsActive,IsAdvancedField,IsDisplayed,IsDisplayed_SideList,IsDisplayedGrid,Name,SeqNo,SeqNo_SideList,SeqNoGrid,Updated,UpdatedBy) VALUES (0,593828,0,542171,564795,543293,TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100,'Mandant für diese Installation.','Ein Mandant ist eine Firma oder eine juristische Person. Sie können keine Daten über Mandanten hinweg verwenden. .','Y','N','Y','N','N','Mandant',10,0,0,TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:29.985Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Element (AD_Client_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,AD_UI_Element_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,Description,Help,IsActive,IsAdvancedField,IsDisplayed,IsDisplayed_SideList,IsDisplayedGrid,Name,SeqNo,SeqNo_SideList,SeqNoGrid,Updated,UpdatedBy) VALUES (0,593829,0,542171,564796,543293,TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100,'Organisatorische Einheit des Mandanten','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','N','Sektion',20,0,0,TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:30.093Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Element (AD_Client_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,AD_UI_Element_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,Description,Help,IsActive,IsAdvancedField,IsDisplayed,IsDisplayed_SideList,IsDisplayedGrid,Name,SeqNo,SeqNo_SideList,SeqNoGrid,Updated,UpdatedBy) VALUES (0,593830,0,542171,564797,543293,TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100,'Der Eintrag ist im System aktiv','Es gibt zwei Möglichkeiten, einen Datensatz nicht mehr verfügbar zu machen: einer ist, ihn zu löschen; der andere, ihn zu deaktivieren. Ein deaktivierter Eintrag ist nicht mehr für eine Auswahl verfügbar, aber verfügbar für die Verwendung in Berichten. Es gibt zwei Gründe, Datensätze zu deaktivieren und nicht zu löschen: (1) Das System braucht den Datensatz für Revisionszwecke. (2) Der Datensatz wird von anderen Datensätzen referenziert. Z.B. können Sie keinen Geschäftspartner löschen, wenn es Rechnungen für diesen Geschäftspartner gibt. Sie deaktivieren den Geschäftspartner und verhindern, dass dieser Eintrag in zukünftigen Vorgängen verwendet wird.','Y','N','Y','N','N','Aktiv',30,0,0,TO_TIMESTAMP('2020-01-06 15:32:29','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:30.197Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Element (AD_Client_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,AD_UI_Element_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,Description,Help,IsActive,IsAdvancedField,IsDisplayed,IsDisplayed_SideList,IsDisplayedGrid,Name,SeqNo,SeqNo_SideList,SeqNoGrid,Updated,UpdatedBy) VALUES (0,593832,0,542171,564798,543293,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100,'Position auf Versand- oder Wareneingangsbeleg','"Versand-/Wareneingangsposition" bezeichnet eine einzelne Zeile/Position auf einem Versand- oder Wareneingangsbeleg.','Y','N','Y','N','N','Versand-/Wareneingangsposition',40,0,0,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:30.310Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Element (AD_Client_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,AD_UI_Element_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,IsActive,IsAdvancedField,IsDisplayed,IsDisplayed_SideList,IsDisplayedGrid,Name,SeqNo,SeqNo_SideList,SeqNoGrid,Updated,UpdatedBy) VALUES (0,593833,0,542171,564799,543293,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100,'Y','N','Y','N','N','Customs Invoice Line',50,0,0,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:30.422Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Element (AD_Client_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,AD_UI_Element_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,Description,Help,IsActive,IsAdvancedField,IsDisplayed,IsDisplayed_SideList,IsDisplayedGrid,Name,SeqNo,SeqNo_SideList,SeqNoGrid,Updated,UpdatedBy) VALUES (0,593834,0,542171,564800,543293,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100,'Material Shipment Document','The Material Shipment / Receipt ','Y','N','Y','N','N','Lieferung/Wareneingang',60,0,0,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:30.531Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Element (AD_Client_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,AD_UI_Element_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,IsActive,IsAdvancedField,IsDisplayed,IsDisplayed_SideList,IsDisplayedGrid,Name,SeqNo,SeqNo_SideList,SeqNoGrid,Updated,UpdatedBy) VALUES (0,593835,0,542171,564801,543293,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100,'Y','N','Y','N','N','Zollrechnung',70,0,0,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:30.643Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Element (AD_Client_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,AD_UI_Element_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,Description,Help,IsActive,IsAdvancedField,IsDisplayed,IsDisplayed_SideList,IsDisplayedGrid,Name,SeqNo,SeqNo_SideList,SeqNoGrid,Updated,UpdatedBy) VALUES (0,593836,0,542171,564802,543293,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100,'Produkt, Leistung, Artikel','Bezeichnet eine Einheit, die in dieser Organisation gekauft oder verkauft wird.','Y','N','Y','N','N','Produkt',80,0,0,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:30.747Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Element (AD_Client_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,AD_UI_Element_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,Description,Help,IsActive,IsAdvancedField,IsDisplayed,IsDisplayed_SideList,IsDisplayedGrid,Name,SeqNo,SeqNo_SideList,SeqNoGrid,Updated,UpdatedBy) VALUES (0,593837,0,542171,564803,543293,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100,'Menge eines bewegten Produktes.','Die "Bewegungs-Menge" bezeichnet die Menge einer Ware, die bewegt wurde.','Y','N','Y','N','N','Bewegungs-Menge',90,0,0,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:30.854Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Element (AD_Client_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,AD_UI_Element_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,Description,Help,IsActive,IsAdvancedField,IsDisplayed,IsDisplayed_SideList,IsDisplayedGrid,Name,SeqNo,SeqNo_SideList,SeqNoGrid,Updated,UpdatedBy) VALUES (0,593838,0,542171,564804,543293,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100,'Maßeinheit','Eine eindeutige (nicht monetäre) Maßeinheit','Y','N','Y','N','N','Maßeinheit',100,0,0,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:30.962Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Element (AD_Client_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,AD_UI_Element_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,Description,Help,IsActive,IsAdvancedField,IsDisplayed,IsDisplayed_SideList,IsDisplayedGrid,Name,SeqNo,SeqNo_SideList,SeqNoGrid,Updated,UpdatedBy) VALUES (0,593839,0,542171,564805,543293,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100,'Effektiver Preis','Der Einzelpreis oder Effektive Preis bezeichnet den Preis für das Produkt in Ausgangswährung.','Y','N','Y','N','N','Einzelpreis',110,0,0,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:31.071Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_Element (AD_Client_ID,AD_Field_ID,AD_Org_ID,AD_Tab_ID,AD_UI_Element_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,Description,Help,IsActive,IsAdvancedField,IsDisplayed,IsDisplayed_SideList,IsDisplayedGrid,Name,SeqNo,SeqNo_SideList,SeqNoGrid,Updated,UpdatedBy) VALUES (0,593840,0,542171,564806,543293,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100,'Die Währung für diesen Eintrag','Bezeichnet die auf Dokumenten oder Berichten verwendete Währung','Y','N','Y','N','N','Währung',120,0,0,TO_TIMESTAMP('2020-01-06 15:32:30','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:32:56.822Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_ElementGroup (AD_Client_ID,AD_Org_ID,AD_UI_Column_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,IsActive,Name,SeqNo,Updated,UpdatedBy) VALUES (0,0,542166,543294,TO_TIMESTAMP('2020-01-06 15:32:56','YYYY-MM-DD HH24:MI:SS'),100,'Y','flag',10,TO_TIMESTAMP('2020-01-06 15:32:56','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:33:01.976Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_UI_ElementGroup (AD_Client_ID,AD_Org_ID,AD_UI_Column_ID,AD_UI_ElementGroup_ID,Created,CreatedBy,IsActive,Name,SeqNo,Updated,UpdatedBy) VALUES (0,0,542166,543295,TO_TIMESTAMP('2020-01-06 15:33:01','YYYY-MM-DD HH24:MI:SS'),100,'Y','org',20,TO_TIMESTAMP('2020-01-06 15:33:01','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:33:29.125Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET AD_UI_ElementGroup_ID=543295, SeqNo=10,Updated=TO_TIMESTAMP('2020-01-06 15:33:29','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564796
  ;
  
  -- 2020-01-06T13:33:36.551Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET AD_UI_ElementGroup_ID=543294, SeqNo=10,Updated=TO_TIMESTAMP('2020-01-06 15:33:36','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564795
  ;
  
  -- 2020-01-06T13:33:44.354Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET AD_UI_ElementGroup_ID=543294, SeqNo=20,Updated=TO_TIMESTAMP('2020-01-06 15:33:44','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564797
  ;
  
  -- 2020-01-06T13:34:24.719Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Window SET EntityType='D',Updated=TO_TIMESTAMP('2020-01-06 15:34:24','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Window_ID=540833
  ;
  
  -- 2020-01-06T13:35:18.883Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET IsDisplayedGrid='Y', SeqNoGrid=10,Updated=TO_TIMESTAMP('2020-01-06 15:35:18','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564798
  ;
  
  -- 2020-01-06T13:35:18.893Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET IsDisplayedGrid='Y', SeqNoGrid=20,Updated=TO_TIMESTAMP('2020-01-06 15:35:18','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564800
  ;
  
  -- 2020-01-06T13:35:18.898Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET IsDisplayedGrid='Y', SeqNoGrid=30,Updated=TO_TIMESTAMP('2020-01-06 15:35:18','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564799
  ;
  
  -- 2020-01-06T13:35:18.901Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET IsDisplayedGrid='Y', SeqNoGrid=40,Updated=TO_TIMESTAMP('2020-01-06 15:35:18','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564801
  ;
  
  -- 2020-01-06T13:35:18.905Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET IsDisplayedGrid='Y', SeqNoGrid=50,Updated=TO_TIMESTAMP('2020-01-06 15:35:18','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564797
  ;
  
  -- 2020-01-06T13:35:18.908Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET IsDisplayedGrid='Y', SeqNoGrid=60,Updated=TO_TIMESTAMP('2020-01-06 15:35:18','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564802
  ;
  
  -- 2020-01-06T13:35:18.910Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET IsDisplayedGrid='Y', SeqNoGrid=70,Updated=TO_TIMESTAMP('2020-01-06 15:35:18','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564803
  ;
  
  -- 2020-01-06T13:35:18.913Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET IsDisplayedGrid='Y', SeqNoGrid=80,Updated=TO_TIMESTAMP('2020-01-06 15:35:18','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564804
  ;
  
  -- 2020-01-06T13:35:18.917Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET IsDisplayedGrid='Y', SeqNoGrid=90,Updated=TO_TIMESTAMP('2020-01-06 15:35:18','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564805
  ;
  
  -- 2020-01-06T13:35:18.920Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET IsDisplayedGrid='Y', SeqNoGrid=100,Updated=TO_TIMESTAMP('2020-01-06 15:35:18','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564806
  ;
  
  -- 2020-01-06T13:35:18.922Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET IsDisplayedGrid='Y', SeqNoGrid=110,Updated=TO_TIMESTAMP('2020-01-06 15:35:18','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564796
  ;
  
  -- 2020-01-06T13:35:47.546Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Tab SET IsGridModeOnly='Y', IsInsertRecord='N',Updated=TO_TIMESTAMP('2020-01-06 15:35:47','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Tab_ID=542171
  ;
  
  -- 2020-01-06T13:35:58.619Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Tab SET IsGridModeOnly='N',Updated=TO_TIMESTAMP('2020-01-06 15:35:58','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Tab_ID=542171
  ;
  
  -- 2020-01-06T13:36:11.981Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_UI_Element SET AD_UI_ElementGroup_ID=543295, SeqNo=20,Updated=TO_TIMESTAMP('2020-01-06 15:36:11','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_UI_Element_ID=564795
  ;
  
  -- 2020-01-06T13:37:15.929Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Menu (Action,AD_Client_ID,AD_Element_ID,AD_Menu_ID,AD_Org_ID,AD_Window_ID,Created,CreatedBy,EntityType,InternalName,IsActive,IsCreateNew,IsReadOnly,IsSOTrx,IsSummary,Name,Updated,UpdatedBy) VALUES ('W',0,577450,541418,0,540833,TO_TIMESTAMP('2020-01-06 15:37:15','YYYY-MM-DD HH24:MI:SS'),100,'D','M_InOutLine_To_C_Customs_Invoice_Line','Y','N','N','N','N','M_InOutLine_To_C_Customs_Invoice_Line',TO_TIMESTAMP('2020-01-06 15:37:15','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T13:37:15.936Z
  -- 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=541418 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)
  ;
  
  -- 2020-01-06T13:37:15.940Z
  -- 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, 541418, 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=541418)
  ;
  
  -- 2020-01-06T13:37:15.963Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_menu_translation_from_ad_element(577450) 
  ;
  
  -- 2020-01-06T13:37:24.077Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=0, Updated=now(), UpdatedBy=100 WHERE  Node_ID=1000104 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:24.079Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=1, Updated=now(), UpdatedBy=100 WHERE  Node_ID=1000085 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:24.080Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=2, Updated=now(), UpdatedBy=100 WHERE  Node_ID=1000086 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:24.080Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=3, Updated=now(), UpdatedBy=100 WHERE  Node_ID=541271 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:24.081Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=4, Updated=now(), UpdatedBy=100 WHERE  Node_ID=1000059 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:24.081Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=5, Updated=now(), UpdatedBy=100 WHERE  Node_ID=1000067 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:24.082Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=6, Updated=now(), UpdatedBy=100 WHERE  Node_ID=1000077 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:24.083Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=7, Updated=now(), UpdatedBy=100 WHERE  Node_ID=541418 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:28.944Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=0, Updated=now(), UpdatedBy=100 WHERE  Node_ID=1000104 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:28.945Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=1, Updated=now(), UpdatedBy=100 WHERE  Node_ID=1000085 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:28.946Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=2, Updated=now(), UpdatedBy=100 WHERE  Node_ID=1000086 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:28.947Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=3, Updated=now(), UpdatedBy=100 WHERE  Node_ID=541271 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:28.948Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=4, Updated=now(), UpdatedBy=100 WHERE  Node_ID=541418 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:28.948Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=5, Updated=now(), UpdatedBy=100 WHERE  Node_ID=1000059 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:28.949Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=6, Updated=now(), UpdatedBy=100 WHERE  Node_ID=1000067 AND AD_Tree_ID=10
  ;
  
  -- 2020-01-06T13:37:28.949Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_TreeNodeMM SET Parent_ID=1000018, SeqNo=7, Updated=now(), UpdatedBy=100 WHERE  Node_ID=1000077 AND AD_Tree_ID=10
  ;
  
  
  
  
  -- 2020-01-06T14:33:55.193Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Column SET IsGenericZoomOrigin='Y',Updated=TO_TIMESTAMP('2020-01-06 16:33:55','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=569807
  ;
  
  -- 2020-01-06T14:34:34.369Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Column SET IsGenericZoomOrigin='N',Updated=TO_TIMESTAMP('2020-01-06 16:34:34','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=569807
  ;
  
  -- 2020-01-06T14:49:53.399Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_RelationType (AD_Client_ID,AD_Org_ID,AD_Reference_Source_ID,AD_RelationType_ID,Created,CreatedBy,EntityType,IsActive,IsDirected,IsTableRecordIdTarget,Name,Updated,UpdatedBy) VALUES (0,0,540299,540235,TO_TIMESTAMP('2020-01-06 16:49:53','YYYY-MM-DD HH24:MI:SS'),100,'de.metas.swat','Y','N','N','M_InOut -> C_Customs_Invoice',TO_TIMESTAMP('2020-01-06 16:49:53','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T14:50:44.116Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Reference (AD_Client_ID,AD_Org_ID,AD_Reference_ID,Created,CreatedBy,EntityType,IsActive,IsOrderByValue,Name,Updated,UpdatedBy,ValidationType) VALUES (0,0,541093,TO_TIMESTAMP('2020-01-06 16:50:43','YYYY-MM-DD HH24:MI:SS'),100,'D','Y','N','C_Customs_Invoice_Target _For_M_InOut',TO_TIMESTAMP('2020-01-06 16:50:43','YYYY-MM-DD HH24:MI:SS'),100,'T')
  ;
  
  -- 2020-01-06T14:50:44.122Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Reference_Trl (AD_Language,AD_Reference_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Reference_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_Reference t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N') AND t.AD_Reference_ID=541093 AND NOT EXISTS (SELECT 1 FROM AD_Reference_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Reference_ID=t.AD_Reference_ID)
  ;
  
  -- 2020-01-06T14:57:31.965Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Ref_Table (AD_Client_ID,AD_Key,AD_Org_ID,AD_Reference_ID,AD_Table_ID,AD_Window_ID,Created,CreatedBy,EntityType,IsActive,IsValueDisplayed,Updated,UpdatedBy,WhereClause) VALUES (0,569808,0,541093,541451,540643,TO_TIMESTAMP('2020-01-06 16:57:31','YYYY-MM-DD HH24:MI:SS'),100,'D','Y','N',TO_TIMESTAMP('2020-01-06 16:57:31','YYYY-MM-DD HH24:MI:SS'),100,'EXISTS (SELECT 1  from C_Customs_Invoice ci            INNER JOIN M_InOutLine_To_C_Customs_Invoice_Line alloc on ci.C_Customs_Invoice_ID = alloc.C_Customs_Invoice_ID      INNER JOIN M_InOut io on alloc.M_InOut_ID = io.M_InOut_ID and io.M_InOut_ID = @M_InOut_ID / -1@ )')
  ;
  
  
  
  -- 2020-01-06T15:07:24.738Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_RelationType SET AD_Reference_Target_ID=541093,Updated=TO_TIMESTAMP('2020-01-06 17:07:24','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_RelationType_ID=540235
  ;
  
  -- 2020-01-06T15:08:04.819Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_RelationType SET IsActive='N',Updated=TO_TIMESTAMP('2020-01-06 17:08:04','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_RelationType_ID=540235
  ;
  
  -- 2020-01-06T15:09:06.178Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_RelationType SET IsActive='Y', Name='M_InOutLine -> C_Customs_Invoice_Line',Updated=TO_TIMESTAMP('2020-01-06 17:09:06','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_RelationType_ID=540235
  ;
  
  -- 2020-01-06T15:10:04.179Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Reference SET Name='C_Customs_InvoiceLine_Target _For_M_InOutLine',Updated=TO_TIMESTAMP('2020-01-06 17:10:04','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Reference_ID=541093
  ;
  
  -- 2020-01-06T15:11:47.548Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Ref_Table SET AD_Key=568000, AD_Table_ID=541361, WhereClause='EXISTS (SELECT 1  from C_Customs_Invoice_Line ci            INNER JOIN M_InOutLine_To_C_Customs_Invoice_Line alloc on ci.C_Customs_Invoice_Line_ID = alloc.C_Customs_Invoice_Line_ID      INNER JOIN M_InOutLine io on alloc.M_InOutLine_ID = io.M_InOutLine_ID and io.M_InOutLine_ID = @M_InOutLine_ID / -1@ )',Updated=TO_TIMESTAMP('2020-01-06 17:11:47','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Reference_ID=541093
  ;
  
  -- 2020-01-06T15:12:02.715Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_RelationType SET AD_Reference_Source_ID=295,Updated=TO_TIMESTAMP('2020-01-06 17:12:02','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_RelationType_ID=540235
  ;
  
  -- 2020-01-06T15:40:13.245Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Ref_Table SET WhereClause='EXISTS (SELECT 1  from C_Customs_Invoice_Line ci             INNER JOIN M_InOutLine_To_C_Customs_Invoice_Line alloc on ci.C_Customs_Invoice_Line_ID = alloc.C_Customs_Invoice_Line_ID       INNER JOIN M_InOutLine io on alloc.M_InOutLine_ID = io.M_InOutLine_ID and io.M_InOutLine_ID = @M_InOutLine_ID / -1@ )',Updated=TO_TIMESTAMP('2020-01-06 17:40:13','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Reference_ID=541093
  ;
  
  -- 2020-01-06T15:43:39.211Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Ref_Table SET WhereClause='EXISTS (SELECT 1  from C_Customs_Invoice_Line ci             INNER JOIN M_InOutLine_To_C_Customs_Invoice_Line alloc on ci.C_Customs_Invoice_Line_ID = alloc.C_Customs_Invoice_Line_ID        INNER JOIN M_InOutLine io on alloc.M_InOutLine_ID = io.M_InOutLine_ID  where  io.M_InOutLine_ID = @M_InOutLine_ID / -1@ and ci.ci.C_Customs_Invoice_Line_ID = ci.C_Customs_Invoice_Line.ci.C_Customs_Invoice_Line_ID )',Updated=TO_TIMESTAMP('2020-01-06 17:43:39','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Reference_ID=541093
  ;
  
  -- 2020-01-06T15:47:05.776Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Message (AD_Client_ID,AD_Message_ID,AD_Org_ID,Created,CreatedBy,EntityType,IsActive,MsgText,MsgType,Updated,UpdatedBy,Value) VALUES (0,544953,0,TO_TIMESTAMP('2020-01-06 17:47:05','YYYY-MM-DD HH24:MI:SS'),100,'D','Y','Unter den ausgewählten Lieferungen sind keine exportierbaren Zeilen.','E',TO_TIMESTAMP('2020-01-06 17:47:05','YYYY-MM-DD HH24:MI:SS'),100,'M_InOut_Create_CustomsInvoice_NoValidLines')
  ;
  
  -- 2020-01-06T15:47:05.785Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Message_Trl (AD_Language,AD_Message_ID, MsgText,MsgTip, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Message_ID, t.MsgText,t.MsgTip, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Message t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N') AND t.AD_Message_ID=544953 AND NOT EXISTS (SELECT 1 FROM AD_Message_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Message_ID=t.AD_Message_ID)
  ;
  
  -- 2020-01-06T15:47:45.114Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Message_Trl SET IsTranslated='Y', MsgText='No valid lines found in the selected shipments.',Updated=TO_TIMESTAMP('2020-01-06 17:47:45','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Language='en_US' AND AD_Message_ID=544953
  ;
  
  -- 2020-01-06T15:57:37.434Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_RelationType SET IsActive='N',Updated=TO_TIMESTAMP('2020-01-06 17:57:37','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_RelationType_ID=540225
  ;
  
  -- 2020-01-06T16:11:25.499Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_RelationType SET IsActive='N',Updated=TO_TIMESTAMP('2020-01-06 18:11:25','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_RelationType_ID=540235
  ;
  
  -- 2020-01-06T16:13:04.096Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_RelationType SET IsActive='Y',Updated=TO_TIMESTAMP('2020-01-06 18:13:04','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_RelationType_ID=540225
  ;
  
  -- 2020-01-06T16:15:09.173Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Ref_Table SET WhereClause='EXISTS (SELECT 1  from C_Customs_Invoice ci             INNER JOIN M_InOutLine_To_C_Customs_Invoice_Line alloc on ci.C_Customs_Invoice_ID = alloc.C_Customs_Invoice_ID         INNER JOIN M_InOut io on alloc.M_InOut_ID = io.M_InOut_ID  where  io.M_InOut_ID = @M_InOut_ID / -1@ and ci.C_Customs_Invoice_ID = C_Customs_Invoice.C_Customs_Invoice_ID )',Updated=TO_TIMESTAMP('2020-01-06 18:15:09','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Reference_ID=540999
  ;
  
  -- 2020-01-06T16:17:34.818Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Ref_Table SET WhereClause='EXISTS (SELECT 1  from C_Customs_Invoice ci              INNER JOIN M_InOutLine_To_C_Customs_Invoice_Line alloc on ci.C_Customs_Invoice_ID = alloc.C_Customs_Invoice_ID          INNER JOIN M_InOut io on alloc.M_InOut_ID = io.M_InOut_ID   where  io.M_InOut_ID = @M_InOut_ID / -1@ and ci.C_Customs_Invoice_ID = C_Customs_Invoice.C_Customs_Invoice_ID )',Updated=TO_TIMESTAMP('2020-01-06 18:17:34','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Reference_ID=540999
  ;
  
  -- 2020-01-06T16:19:09.208Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Reference (AD_Client_ID,AD_Org_ID,AD_Reference_ID,Created,CreatedBy,EntityType,IsActive,IsOrderByValue,Name,Updated,UpdatedBy,ValidationType) VALUES (0,0,541094,TO_TIMESTAMP('2020-01-06 18:19:08','YYYY-MM-DD HH24:MI:SS'),100,'D','Y','N','C_Customs_Invoice Source',TO_TIMESTAMP('2020-01-06 18:19:08','YYYY-MM-DD HH24:MI:SS'),100,'T')
  ;
  
  -- 2020-01-06T16:19:09.212Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Reference_Trl (AD_Language,AD_Reference_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Reference_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_Reference t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N') AND t.AD_Reference_ID=541094 AND NOT EXISTS (SELECT 1 FROM AD_Reference_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Reference_ID=t.AD_Reference_ID)
  ;
  
  -- 2020-01-06T16:19:25.111Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Ref_Table (AD_Client_ID,AD_Key,AD_Org_ID,AD_Reference_ID,AD_Table_ID,Created,CreatedBy,EntityType,IsActive,IsValueDisplayed,Updated,UpdatedBy) VALUES (0,567982,0,541094,541360,TO_TIMESTAMP('2020-01-06 18:19:25','YYYY-MM-DD HH24:MI:SS'),100,'D','Y','N',TO_TIMESTAMP('2020-01-06 18:19:25','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T16:19:33.466Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Ref_Table SET AD_Window_ID=540643,Updated=TO_TIMESTAMP('2020-01-06 18:19:33','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Reference_ID=541094
  ;
  
  -- 2020-01-06T16:20:08.255Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Reference (AD_Client_ID,AD_Org_ID,AD_Reference_ID,Created,CreatedBy,EntityType,IsActive,IsOrderByValue,Name,Updated,UpdatedBy,ValidationType) VALUES (0,0,541095,TO_TIMESTAMP('2020-01-06 18:20:08','YYYY-MM-DD HH24:MI:SS'),100,'D','Y','N','M_InOut Target for C_Customs_Invoice',TO_TIMESTAMP('2020-01-06 18:20:08','YYYY-MM-DD HH24:MI:SS'),100,'T')
  ;
  
  -- 2020-01-06T16:20:08.258Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Reference_Trl (AD_Language,AD_Reference_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Reference_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_Reference t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N') AND t.AD_Reference_ID=541095 AND NOT EXISTS (SELECT 1 FROM AD_Reference_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Reference_ID=t.AD_Reference_ID)
  ;
  
  -- 2020-01-06T16:21:22.140Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Ref_Table (AD_Client_ID,AD_Key,AD_Org_ID,AD_Reference_ID,AD_Table_ID,AD_Window_ID,Created,CreatedBy,EntityType,IsActive,IsValueDisplayed,Updated,UpdatedBy,WhereClause) VALUES (0,3521,0,541095,319,169,TO_TIMESTAMP('2020-01-06 18:21:22','YYYY-MM-DD HH24:MI:SS'),100,'D','Y','N',TO_TIMESTAMP('2020-01-06 18:21:22','YYYY-MM-DD HH24:MI:SS'),100,'EXISTS (SELECT 1  from C_Customs_Invoice ci              INNER JOIN M_InOutLine_To_C_Customs_Invoice_Line alloc on ci.C_Customs_Invoice_ID = alloc.C_Customs_Invoice_ID          INNER JOIN M_InOut io on alloc.M_InOut_ID = io.M_InOut_ID   where  io.M_InOut_ID = M_InOut.M_InOut_ID and ci.C_Customs_Invoice_ID = @C_Customs_Invoice_ID / -1@ )')
  ;
  
  -- 2020-01-06T16:21:30.596Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_RelationType (AD_Client_ID,AD_Org_ID,AD_Reference_Source_ID,AD_Reference_Target_ID,AD_RelationType_ID,Created,CreatedBy,EntityType,IsActive,IsDirected,IsTableRecordIdTarget,Name,Updated,UpdatedBy) VALUES (0,0,541094,541095,540236,TO_TIMESTAMP('2020-01-06 18:21:30','YYYY-MM-DD HH24:MI:SS'),100,'de.metas.swat','Y','N','N','C_Customs_Invoice -> M_InOut',TO_TIMESTAMP('2020-01-06 18:21:30','YYYY-MM-DD HH24:MI:SS'),100)
  ;
  
  -- 2020-01-06T16:22:13.353Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Ref_Table SET WhereClause='1=1',Updated=TO_TIMESTAMP('2020-01-06 18:22:13','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Reference_ID=541094
  ;
  
  -- 2020-01-06T16:23:03.138Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Ref_Table SET WhereClause='EXISTS (SELECT 1  from C_Customs_Invoice ci              INNER JOIN M_InOutLine_To_C_Customs_Invoice_Line alloc on ci.C_Customs_Invoice_ID = alloc.C_Customs_Invoice_ID          INNER JOIN M_InOut io on alloc.M_InOut_ID = io.M_InOut_ID   where  io.M_InOut_ID = M_InOut.M_InOut_ID and ci.C_Customs_Invoice_ID = @C_Customs_Invoice_ID / -1@  AND io.IsSOTrx = ''Y'')',Updated=TO_TIMESTAMP('2020-01-06 18:23:03','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Reference_ID=541095
  ;
  
  -- 2020-01-06T16:24:03.788Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_RelationType SET IsDirected='Y',Updated=TO_TIMESTAMP('2020-01-06 18:24:03','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_RelationType_ID=540236
  ;
  
  -- 2020-01-06T16:24:34.993Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Ref_Table SET WhereClause='',Updated=TO_TIMESTAMP('2020-01-06 18:24:34','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Reference_ID=541094
  ;
  
  -- 2020-01-06T16:24:40.323Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Ref_Table SET WhereClause='1=1',Updated=TO_TIMESTAMP('2020-01-06 18:24:40','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Reference_ID=541094
  ;
  
  -- 2020-01-06T16:26:28.594Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Ref_Table SET WhereClause='EXISTS (SELECT 1 from m_inout io INNER JOIN M_InOutLine_To_C_Customs_Invoice_Line alloc on alloc.M_InOut_ID = io.M_InOut_ID Inner join  C_Customs_Invoice ci       on ci.C_Customs_Invoice_ID = alloc.C_Customs_Invoice_ID           where  io.M_InOut_ID = M_InOut.M_InOut_ID and ci.C_Customs_Invoice_ID = @C_Customs_Invoice_ID / -1@  AND io.IsSOTrx = ''Y'')',Updated=TO_TIMESTAMP('2020-01-06 18:26:28','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Reference_ID=541095
  ;
  
  -- 2020-01-06T16:28:26.396Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Column SET IsGenericZoomOrigin='Y', IsUpdateable='N',Updated=TO_TIMESTAMP('2020-01-06 18:28:26','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Column_ID=567982
  ;
  
  -- 2020-01-06T17:00:21.848Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_UI_Element WHERE AD_UI_Element_ID=559338
  ;
  
  
  