text: -- 2021-01-27T20:51:05.048Z
  -- 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,541251,TO_TIMESTAMP('2021-01-27 22:51:04','YYYY-MM-DD HH24:MI:SS'),100,'de.metas.servicerepair','Y','N','C_Project_Repair_CostCollector_Type',TO_TIMESTAMP('2021-01-27 22:51:04','YYYY-MM-DD HH24:MI:SS'),100,'L')
  ;
  
  -- 2021-01-27T20:51:05.049Z
  -- 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 t.AD_Reference_ID=541251 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)
  ;
  
  -- 2021-01-27T20:52:31.653Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Ref_List (AD_Client_ID,AD_Org_ID,AD_Ref_List_ID,AD_Reference_ID,Created,CreatedBy,EntityType,IsActive,Name,Updated,UpdatedBy,Value,ValueName) VALUES (0,0,542254,541251,TO_TIMESTAMP('2021-01-27 22:52:31','YYYY-MM-DD HH24:MI:SS'),100,'de.metas.servicerepair','Y','Spare Parts To Be Invoiced',TO_TIMESTAMP('2021-01-27 22:52:31','YYYY-MM-DD HH24:MI:SS'),100,'SP+','SparePartsToBeInvoiced')
  ;
  
  -- 2021-01-27T20:52:31.655Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Ref_List_Trl (AD_Language,AD_Ref_List_ID, Description,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Ref_List_ID, t.Description,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Ref_List t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y') AND t.AD_Ref_List_ID=542254 AND NOT EXISTS (SELECT 1 FROM AD_Ref_List_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Ref_List_ID=t.AD_Ref_List_ID)
  ;
  
  -- 2021-01-27T20:53:28.919Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Ref_List (AD_Client_ID,AD_Org_ID,AD_Ref_List_ID,AD_Reference_ID,Created,CreatedBy,EntityType,IsActive,Name,Updated,UpdatedBy,Value,ValueName) VALUES (0,0,542255,541251,TO_TIMESTAMP('2021-01-27 22:53:28','YYYY-MM-DD HH24:MI:SS'),100,'de.metas.servicerepair','Y','Spare Parts Owned By Customer',TO_TIMESTAMP('2021-01-27 22:53:28','YYYY-MM-DD HH24:MI:SS'),100,'SPC','SparePartsOwnedByCustomer')
  ;
  
  -- 2021-01-27T20:53:28.920Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Ref_List_Trl (AD_Language,AD_Ref_List_ID, Description,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Ref_List_ID, t.Description,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Ref_List t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y') AND t.AD_Ref_List_ID=542255 AND NOT EXISTS (SELECT 1 FROM AD_Ref_List_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Ref_List_ID=t.AD_Ref_List_ID)
  ;
  
  -- 2021-01-27T20:54:23.158Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Ref_List (AD_Client_ID,AD_Org_ID,AD_Ref_List_ID,AD_Reference_ID,Created,CreatedBy,EntityType,IsActive,Name,Updated,UpdatedBy,Value,ValueName) VALUES (0,0,542256,541251,TO_TIMESTAMP('2021-01-27 22:54:22','YYYY-MM-DD HH24:MI:SS'),100,'de.metas.servicerepair','Y','Repair Product To Return',TO_TIMESTAMP('2021-01-27 22:54:22','YYYY-MM-DD HH24:MI:SS'),100,'RPC','RepairProductToReturn')
  ;
  
  -- 2021-01-27T20:54:23.160Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Ref_List_Trl (AD_Language,AD_Ref_List_ID, Description,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Ref_List_ID, t.Description,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Ref_List t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y') AND t.AD_Ref_List_ID=542256 AND NOT EXISTS (SELECT 1 FROM AD_Ref_List_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Ref_List_ID=t.AD_Ref_List_ID)
  ;
  
  -- 2021-01-27T20:55:25.573Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Ref_List (AD_Client_ID,AD_Org_ID,AD_Ref_List_ID,AD_Reference_ID,Created,CreatedBy,EntityType,IsActive,Name,Updated,UpdatedBy,Value,ValueName) VALUES (0,0,542257,541251,TO_TIMESTAMP('2021-01-27 22:55:25','YYYY-MM-DD HH24:MI:SS'),100,'de.metas.servicerepair','Y','Repairing Consumption',TO_TIMESTAMP('2021-01-27 22:55:25','YYYY-MM-DD HH24:MI:SS'),100,'RP+','RepairingConsumption')
  ;
  
  -- 2021-01-27T20:55:25.573Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Ref_List_Trl (AD_Language,AD_Ref_List_ID, Description,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Ref_List_ID, t.Description,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Ref_List t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y') AND t.AD_Ref_List_ID=542257 AND NOT EXISTS (SELECT 1 FROM AD_Ref_List_Trl tt WHERE tt.AD_Language=l.AD_Language AND tt.AD_Ref_List_ID=t.AD_Ref_List_ID)
  ;
  
  -- 2021-01-27T20:55:53.823Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Column (AD_Reference_ID,FieldLength,Version,IsKey,IsParent,IsTranslated,IsIdentifier,SeqNo,AD_Client_ID,IsActive,Created,CreatedBy,IsUpdateable,DDL_NoForeignKey,IsSelectionColumn,IsSyncDatabase,IsAlwaysUpdateable,IsAutocomplete,IsAllowLogging,IsEncrypted,Updated,UpdatedBy,IsAdvancedText,IsLazyLoading,AD_Table_ID,IsCalculated,Help,AD_Reference_Value_ID,AD_Column_ID,IsDimension,IsMandatory,IsStaleable,IsUseDocSequence,IsShowFilterIncrementButtons,IsDLMPartitionBoundary,IsGenericZoomKeyColumn,IsShowFilterInline,SelectionColumnSeqNo,IsForceIncludeInGeneratedModel,IsGenericZoomOrigin,ColumnName,IsAutoApplyValidationRule,Description,IsFacetFilter,MaxFacetsToFetch,FacetFilterSeqNo,AD_Element_ID,EntityType,Name,AD_Org_ID) VALUES (17,3,0,'N','N','N','N',0,0,'Y',TO_TIMESTAMP('2021-01-27 22:55:53','YYYY-MM-DD HH24:MI:SS'),100,'Y','N','N','N','N','N','Y','N',TO_TIMESTAMP('2021-01-27 22:55:53','YYYY-MM-DD HH24:MI:SS'),100,'N','N',541564,'N','',541251,572555,'N','N','N','N','N','N','N','N',0,'N','N','Type','N','','N',0,0,600,'de.metas.servicerepair','Art',0)
  ;
  
  -- 2021-01-27T20:55:53.828Z
  -- 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 t.AD_Column_ID=572555 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)
  ;
  
  -- 2021-01-27T20:55:53.834Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_Column_Translation_From_AD_Element(600) 
  ;
  
  -- 2021-01-27T20:55:54.031Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ SELECT public.db_alter_table('C_Project_Repair_CostCollector','ALTER TABLE public.C_Project_Repair_CostCollector ADD COLUMN Type VARCHAR(3)')
  ;
  
  -- 2021-01-27T20:56:20.631Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field (AD_Tab_ID,IsDisplayed,DisplayLength,IsSameLine,IsHeading,IsFieldOnly,IsEncrypted,AD_Client_ID,IsActive,Created,CreatedBy,IsReadOnly,Updated,UpdatedBy,Help,AD_Field_ID,IsDisplayedGrid,AD_Column_ID,Description,EntityType,Name,AD_Org_ID) VALUES (543310,'N',3,'N','N','N','N',0,'Y',TO_TIMESTAMP('2021-01-27 22:56:20','YYYY-MM-DD HH24:MI:SS'),100,'N',TO_TIMESTAMP('2021-01-27 22:56:20','YYYY-MM-DD HH24:MI:SS'),100,'',628658,'N',572555,'','de.metas.servicerepair','Art',0)
  ;
  
  -- 2021-01-27T20:56:20.640Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  INSERT INTO AD_Field_Trl (AD_Language,AD_Field_ID, Help,Description,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language, t.AD_Field_ID, t.Help,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_Field t WHERE l.IsActive='Y'AND (l.IsSystemLanguage='Y') AND t.AD_Field_ID=628658 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)
  ;
  
  -- 2021-01-27T20:56:20.650Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */  select update_FieldTranslation_From_AD_Name_Element(600) 
  ;
  
  -- 2021-01-27T20:56:20.672Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  DELETE FROM AD_Element_Link WHERE AD_Field_ID=628658
  ;
  
  -- 2021-01-27T20:56:20.686Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  /* DDL */ select AD_Element_Link_Create_Missing_Field(628658)
  ;
  
  -- 2021-01-27T20:56:43.318Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y', SeqNo=20,Updated=TO_TIMESTAMP('2021-01-27 22:56:43','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628658
  ;
  
  -- 2021-01-27T20:56:43.322Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y', SeqNo=30,Updated=TO_TIMESTAMP('2021-01-27 22:56:43','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628607
  ;
  
  -- 2021-01-27T20:56:43.323Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y', SeqNo=40,Updated=TO_TIMESTAMP('2021-01-27 22:56:43','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628608
  ;
  
  -- 2021-01-27T20:56:43.324Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y', SeqNo=50,Updated=TO_TIMESTAMP('2021-01-27 22:56:43','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628609
  ;
  
  -- 2021-01-27T20:56:43.325Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y', SeqNo=60,Updated=TO_TIMESTAMP('2021-01-27 22:56:43','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628610
  ;
  
  -- 2021-01-27T20:56:43.326Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y', SeqNo=70,Updated=TO_TIMESTAMP('2021-01-27 22:56:43','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628615
  ;
  
  -- 2021-01-27T20:56:43.327Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y', SeqNo=80,Updated=TO_TIMESTAMP('2021-01-27 22:56:43','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628645
  ;
  
  -- 2021-01-27T20:56:43.328Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y', SeqNo=90,Updated=TO_TIMESTAMP('2021-01-27 22:56:43','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628630
  ;
  
  -- 2021-01-27T20:56:43.329Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayed='Y', SeqNo=100,Updated=TO_TIMESTAMP('2021-01-27 22:56:43','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628612
  ;
  
  -- 2021-01-27T20:56:48.576Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayedGrid='Y', SeqNoGrid=20,Updated=TO_TIMESTAMP('2021-01-27 22:56:48','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628658
  ;
  
  -- 2021-01-27T20:56:48.577Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayedGrid='Y', SeqNoGrid=30,Updated=TO_TIMESTAMP('2021-01-27 22:56:48','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628607
  ;
  
  -- 2021-01-27T20:56:48.577Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayedGrid='Y', SeqNoGrid=40,Updated=TO_TIMESTAMP('2021-01-27 22:56:48','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628608
  ;
  
  -- 2021-01-27T20:56:48.578Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayedGrid='Y', SeqNoGrid=50,Updated=TO_TIMESTAMP('2021-01-27 22:56:48','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628609
  ;
  
  -- 2021-01-27T20:56:48.579Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayedGrid='Y', SeqNoGrid=60,Updated=TO_TIMESTAMP('2021-01-27 22:56:48','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628610
  ;
  
  -- 2021-01-27T20:56:48.580Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayedGrid='Y', SeqNoGrid=70,Updated=TO_TIMESTAMP('2021-01-27 22:56:48','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628615
  ;
  
  -- 2021-01-27T20:56:48.581Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayedGrid='Y', SeqNoGrid=80,Updated=TO_TIMESTAMP('2021-01-27 22:56:48','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628645
  ;
  
  -- 2021-01-27T20:56:48.582Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayedGrid='Y', SeqNoGrid=90,Updated=TO_TIMESTAMP('2021-01-27 22:56:48','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628630
  ;
  
  -- 2021-01-27T20:56:48.583Z
  -- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
  UPDATE AD_Field SET IsDisplayedGrid='Y', SeqNoGrid=100,Updated=TO_TIMESTAMP('2021-01-27 22:56:48','YYYY-MM-DD HH24:MI:SS'),UpdatedBy=100 WHERE AD_Field_ID=628612
  ;
  
  