Menu
▾
▴
[Adempiere-cvslog] SF.net SVN: adempiere:[13556] branches/thailand/ISEC/adempiere354a/ migration/354a-trunk
|
From: <i-z...@us...> - 2010-08-10 09:11:26
|
Revision: 13556
http://adempiere.svn.sourceforge.net/adempiere/?rev=13556&view=rev
Author: i-zugizo
Date: 2010-08-10 09:11:20 +0000 (Tue, 10 Aug 2010)
Log Message:
-----------
aneak.t
* rename files
Added Paths:
-----------
branches/thailand/ISEC/adempiere354a/migration/354a-trunk/oracle/FR[Z26]_Petty_Cash_PrePrinted_Form_oracle.sql
branches/thailand/ISEC/adempiere354a/migration/354a-trunk/postgresql/FR[Z26]_Petty_Cash_PrePrinted_Form_postgresql.sql
Removed Paths:
-------------
branches/thailand/ISEC/adempiere354a/migration/354a-trunk/oracle/FR[Z26]_Pretty_Cash_PrePrinted_Form_oracle.sql
branches/thailand/ISEC/adempiere354a/migration/354a-trunk/postgresql/FR[Z26]_Pretty_Cash_PrePrinted_Form_postgresql.sql
Copied: branches/thailand/ISEC/adempiere354a/migration/354a-trunk/oracle/FR[Z26]_Petty_Cash_PrePrinted_Form_oracle.sql (from rev 13554, branches/thailand/ISEC/adempiere354a/migration/354a-trunk/oracle/FR[Z26]_Pretty_Cash_PrePrinted_Form_oracle.sql)
===================================================================
--- branches/thailand/ISEC/adempiere354a/migration/354a-trunk/oracle/FR[Z26]_Petty_Cash_PrePrinted_Form_oracle.sql (rev 0)
+++ branches/thailand/ISEC/adempiere354a/migration/354a-trunk/oracle/FR[Z26]_Petty_Cash_PrePrinted_Form_oracle.sql 2010-08-10 09:11:20 UTC (rev 13556)
@@ -0,0 +1,41 @@
+-- Aug 9, 2010 6:20:02 PM ICT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Process (AD_Org_ID,AD_Process_ID,AccessLevel,CopyFromProcess,Created,CreatedBy,Description,EntityType,IsActive,IsBetaFunctionality,IsDirectPrint,IsReport,IsServerProcess,JasperReport,Name,ShowHelp,Statistic_Count,Statistic_Seconds,Updated,UpdatedBy,Value,AD_Client_ID) VALUES (0,93102,'1','N',TO_DATE('2010-08-09 18:20:02','YYYY-MM-DD HH24:MI:SS'),100,'Petty Cash Pre-Printed Form','U','Y','N','N','Y','N','http://<SERVER>:<PORT>/shw/pretty_cash_report.jrxml','Petty Cash Pre-Printed Form','Y',0,0,TO_DATE('2010-08-09 18:20:02','YYYY-MM-DD HH24:MI:SS'),100,'Petty Cash Pre-Printed Form',0)
+;
+
+-- Aug 9, 2010 6:20:02 PM ICT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Process_Trl (AD_Language,AD_Process_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Process_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Process t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Process_ID=93102 AND EXISTS (SELECT * FROM AD_Process_Trl tt WHERE tt.AD_Language!=l.AD_Language OR tt.AD_Process_ID!=t.AD_Process_ID)
+;
+
+-- Aug 9, 2010 6:21:47 PM ICT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Process_Para (AD_Org_ID,AD_Process_ID,AD_Process_Para_ID,AD_Reference_ID,ColumnName,Created,CreatedBy,DefaultValue,Description,DisplayLogic,EntityType,FieldLength,IsActive,IsCentrallyMaintained,IsMandatory,IsRange,Name,ReadOnlyLogic,SeqNo,Updated,UpdatedBy,AD_Client_ID) VALUES (0,93102,93106,15,'DateTrx',TO_DATE('2010-08-09 18:21:47','YYYY-MM-DD HH24:MI:SS'),100,NULL,'Transaction Date',NULL,'U',0,'Y','Y','N','Y','Transaction Date',NULL,10,TO_DATE('2010-08-09 18:21:47','YYYY-MM-DD HH24:MI:SS'),100,0)
+;
+
+-- Aug 9, 2010 6:21:47 PM ICT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Process_Para_Trl (AD_Language,AD_Process_Para_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Process_Para_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Process_Para t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Process_Para_ID=93106 AND EXISTS (SELECT * FROM AD_Process_Para_Trl tt WHERE tt.AD_Language!=l.AD_Language OR tt.AD_Process_Para_ID!=t.AD_Process_Para_ID)
+;
+
+-- Aug 9, 2010 6:22:58 PM ICT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Menu (AD_Org_ID,AD_Menu_ID,AD_Process_ID,Action,Created,CreatedBy,Description,EntityType,IsActive,IsReadOnly,IsSOTrx,IsSummary,Name,Updated,AD_Client_ID,UpdatedBy) VALUES (0,93102,93102,'R',TO_DATE('2010-08-09 18:22:58','YYYY-MM-DD HH24:MI:SS'),100,'Petty Cash Pre-Printed Form','U','Y','N','N','N','Petty Cash Pre-Printed Form',TO_DATE('2010-08-09 18:22:58','YYYY-MM-DD HH24:MI:SS'),0,100)
+;
+
+-- Aug 9, 2010 6:22:58 PM ICT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Menu_Trl (AD_Language,AD_Menu_ID, Description,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Menu_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_Menu t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Menu_ID=93102 AND EXISTS (SELECT * FROM AD_Menu_Trl tt WHERE tt.AD_Language!=l.AD_Language OR tt.AD_Menu_ID!=t.AD_Menu_ID)
+;
+
+-- Aug 9, 2010 6:22:58 PM ICT
+-- 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', SysDate, 0, SysDate, 0,t.AD_Tree_ID, 93102, 0, 999 FROM AD_Tree t WHERE t.AD_Client_ID=0 AND t.IsActive='Y' AND t.IsAllNodes='Y' AND t.TreeType='MM' AND NOT EXISTS (SELECT * FROM AD_TreeNodeMM e WHERE e.AD_Tree_ID=t.AD_Tree_ID AND Node_ID=93102)
+;
+
+--insert process access
+INSERT INTO ad_process_access(ad_process_id, ad_role_id, ad_client_id, ad_org_id, isactive, created,createdby, updated, updatedby, isreadwrite)
+VALUES (93102, 102, 0, 0, 'Y', TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, 'Y');
+--insert process access
+INSERT INTO ad_process_access(ad_process_id, ad_role_id, ad_client_id, ad_org_id, isactive, created,createdby, updated, updatedby, isreadwrite)
+VALUES (93102, 103, 0, 0, 'Y', TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, 'Y');
\ No newline at end of file
Deleted: branches/thailand/ISEC/adempiere354a/migration/354a-trunk/oracle/FR[Z26]_Pretty_Cash_PrePrinted_Form_oracle.sql
===================================================================
--- branches/thailand/ISEC/adempiere354a/migration/354a-trunk/oracle/FR[Z26]_Pretty_Cash_PrePrinted_Form_oracle.sql 2010-08-10 09:10:51 UTC (rev 13555)
+++ branches/thailand/ISEC/adempiere354a/migration/354a-trunk/oracle/FR[Z26]_Pretty_Cash_PrePrinted_Form_oracle.sql 2010-08-10 09:11:20 UTC (rev 13556)
@@ -1,41 +0,0 @@
--- Aug 9, 2010 6:20:02 PM ICT
--- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
-INSERT INTO AD_Process (AD_Org_ID,AD_Process_ID,AccessLevel,CopyFromProcess,Created,CreatedBy,Description,EntityType,IsActive,IsBetaFunctionality,IsDirectPrint,IsReport,IsServerProcess,JasperReport,Name,ShowHelp,Statistic_Count,Statistic_Seconds,Updated,UpdatedBy,Value,AD_Client_ID) VALUES (0,93102,'1','N',TO_DATE('2010-08-09 18:20:02','YYYY-MM-DD HH24:MI:SS'),100,'Pretty Cash Pre-Printed Form','U','Y','N','N','Y','N','http://<SERVER>:<PORT>/shw/pretty_cash_report.jrxml','Pretty Cash Pre-Printed Form','Y',0,0,TO_DATE('2010-08-09 18:20:02','YYYY-MM-DD HH24:MI:SS'),100,'Pretty Cash Pre-Printed Form',0)
-;
-
--- Aug 9, 2010 6:20:02 PM ICT
--- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
-INSERT INTO AD_Process_Trl (AD_Language,AD_Process_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Process_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Process t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Process_ID=93102 AND EXISTS (SELECT * FROM AD_Process_Trl tt WHERE tt.AD_Language!=l.AD_Language OR tt.AD_Process_ID!=t.AD_Process_ID)
-;
-
--- Aug 9, 2010 6:21:47 PM ICT
--- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
-INSERT INTO AD_Process_Para (AD_Org_ID,AD_Process_ID,AD_Process_Para_ID,AD_Reference_ID,ColumnName,Created,CreatedBy,DefaultValue,Description,DisplayLogic,EntityType,FieldLength,IsActive,IsCentrallyMaintained,IsMandatory,IsRange,Name,ReadOnlyLogic,SeqNo,Updated,UpdatedBy,AD_Client_ID) VALUES (0,93102,93106,15,'DateTrx',TO_DATE('2010-08-09 18:21:47','YYYY-MM-DD HH24:MI:SS'),100,NULL,'Transaction Date',NULL,'U',0,'Y','Y','N','Y','Transaction Date',NULL,10,TO_DATE('2010-08-09 18:21:47','YYYY-MM-DD HH24:MI:SS'),100,0)
-;
-
--- Aug 9, 2010 6:21:47 PM ICT
--- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
-INSERT INTO AD_Process_Para_Trl (AD_Language,AD_Process_Para_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Process_Para_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Process_Para t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Process_Para_ID=93106 AND EXISTS (SELECT * FROM AD_Process_Para_Trl tt WHERE tt.AD_Language!=l.AD_Language OR tt.AD_Process_Para_ID!=t.AD_Process_Para_ID)
-;
-
--- Aug 9, 2010 6:22:58 PM ICT
--- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
-INSERT INTO AD_Menu (AD_Org_ID,AD_Menu_ID,AD_Process_ID,Action,Created,CreatedBy,Description,EntityType,IsActive,IsReadOnly,IsSOTrx,IsSummary,Name,Updated,AD_Client_ID,UpdatedBy) VALUES (0,93102,93102,'R',TO_DATE('2010-08-09 18:22:58','YYYY-MM-DD HH24:MI:SS'),100,'Pretty Cash Pre-Printed Form','U','Y','N','N','N','Pretty Cash Pre-Printed Form',TO_DATE('2010-08-09 18:22:58','YYYY-MM-DD HH24:MI:SS'),0,100)
-;
-
--- Aug 9, 2010 6:22:58 PM ICT
--- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
-INSERT INTO AD_Menu_Trl (AD_Language,AD_Menu_ID, Description,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Menu_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_Menu t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Menu_ID=93102 AND EXISTS (SELECT * FROM AD_Menu_Trl tt WHERE tt.AD_Language!=l.AD_Language OR tt.AD_Menu_ID!=t.AD_Menu_ID)
-;
-
--- Aug 9, 2010 6:22:58 PM ICT
--- 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', SysDate, 0, SysDate, 0,t.AD_Tree_ID, 93102, 0, 999 FROM AD_Tree t WHERE t.AD_Client_ID=0 AND t.IsActive='Y' AND t.IsAllNodes='Y' AND t.TreeType='MM' AND NOT EXISTS (SELECT * FROM AD_TreeNodeMM e WHERE e.AD_Tree_ID=t.AD_Tree_ID AND Node_ID=93102)
-;
-
---insert process access
-INSERT INTO ad_process_access(ad_process_id, ad_role_id, ad_client_id, ad_org_id, isactive, created,createdby, updated, updatedby, isreadwrite)
-VALUES (93102, 102, 0, 0, 'Y', TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, 'Y');
---insert process access
-INSERT INTO ad_process_access(ad_process_id, ad_role_id, ad_client_id, ad_org_id, isactive, created,createdby, updated, updatedby, isreadwrite)
-VALUES (93102, 103, 0, 0, 'Y', TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, 'Y');
\ No newline at end of file
Copied: branches/thailand/ISEC/adempiere354a/migration/354a-trunk/postgresql/FR[Z26]_Petty_Cash_PrePrinted_Form_postgresql.sql (from rev 13554, branches/thailand/ISEC/adempiere354a/migration/354a-trunk/postgresql/FR[Z26]_Pretty_Cash_PrePrinted_Form_postgresql.sql)
===================================================================
--- branches/thailand/ISEC/adempiere354a/migration/354a-trunk/postgresql/FR[Z26]_Petty_Cash_PrePrinted_Form_postgresql.sql (rev 0)
+++ branches/thailand/ISEC/adempiere354a/migration/354a-trunk/postgresql/FR[Z26]_Petty_Cash_PrePrinted_Form_postgresql.sql 2010-08-10 09:11:20 UTC (rev 13556)
@@ -0,0 +1,41 @@
+-- Aug 9, 2010 6:20:02 PM ICT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Process (AD_Org_ID,AD_Process_ID,AccessLevel,CopyFromProcess,Created,CreatedBy,Description,EntityType,IsActive,IsBetaFunctionality,IsDirectPrint,IsReport,IsServerProcess,JasperReport,Name,ShowHelp,Statistic_Count,Statistic_Seconds,Updated,UpdatedBy,Value,AD_Client_ID) VALUES (0,93102,'1','N',TO_TIMESTAMP('2010-08-09 18:20:02','YYYY-MM-DD HH24:MI:SS'),100,'Petty Cash Pre-Printed Form','U','Y','N','N','Y','N','http://<SERVER>:<PORT>/shw/pretty_cash_report.jrxml','Petty Cash Pre-Printed Form','Y',0,0,TO_TIMESTAMP('2010-08-09 18:20:02','YYYY-MM-DD HH24:MI:SS'),100,'Petty Cash Pre-Printed Form',0)
+;
+
+-- Aug 9, 2010 6:20:02 PM ICT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Process_Trl (AD_Language,AD_Process_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Process_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Process t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Process_ID=93102 AND EXISTS (SELECT * FROM AD_Process_Trl tt WHERE tt.AD_Language!=l.AD_Language OR tt.AD_Process_ID!=t.AD_Process_ID)
+;
+
+-- Aug 9, 2010 6:21:47 PM ICT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Process_Para (AD_Org_ID,AD_Process_ID,AD_Process_Para_ID,AD_Reference_ID,ColumnName,Created,CreatedBy,DefaultValue,Description,DisplayLogic,EntityType,FieldLength,IsActive,IsCentrallyMaintained,IsMandatory,IsRange,Name,ReadOnlyLogic,SeqNo,Updated,UpdatedBy,AD_Client_ID) VALUES (0,93102,93106,15,'DateTrx',TO_TIMESTAMP('2010-08-09 18:21:47','YYYY-MM-DD HH24:MI:SS'),100,NULL,'Transaction Date',NULL,'U',0,'Y','Y','N','Y','Transaction Date',NULL,10,TO_TIMESTAMP('2010-08-09 18:21:47','YYYY-MM-DD HH24:MI:SS'),100,0)
+;
+
+-- Aug 9, 2010 6:21:47 PM ICT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Process_Para_Trl (AD_Language,AD_Process_Para_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Process_Para_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Process_Para t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Process_Para_ID=93106 AND EXISTS (SELECT * FROM AD_Process_Para_Trl tt WHERE tt.AD_Language!=l.AD_Language OR tt.AD_Process_Para_ID!=t.AD_Process_Para_ID)
+;
+
+-- Aug 9, 2010 6:22:58 PM ICT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Menu (AD_Org_ID,AD_Menu_ID,AD_Process_ID,"action",Created,CreatedBy,Description,EntityType,IsActive,IsReadOnly,IsSOTrx,IsSummary,Name,Updated,AD_Client_ID,UpdatedBy) VALUES (0,93102,93102,'R',TO_TIMESTAMP('2010-08-09 18:22:58','YYYY-MM-DD HH24:MI:SS'),100,'Petty Cash Pre-Printed Form','U','Y','N','N','N','Petty Cash Pre-Printed Form',TO_TIMESTAMP('2010-08-09 18:22:58','YYYY-MM-DD HH24:MI:SS'),0,100)
+;
+
+-- Aug 9, 2010 6:22:58 PM ICT
+-- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
+INSERT INTO AD_Menu_Trl (AD_Language,AD_Menu_ID, Description,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Menu_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_Menu t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Menu_ID=93102 AND EXISTS (SELECT * FROM AD_Menu_Trl tt WHERE tt.AD_Language!=l.AD_Language OR tt.AD_Menu_ID!=t.AD_Menu_ID)
+;
+
+-- Aug 9, 2010 6:22:58 PM ICT
+-- 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', CURRENT_TIMESTAMP, 0, CURRENT_TIMESTAMP, 0,t.AD_Tree_ID, 93102, 0, 999 FROM AD_Tree t WHERE t.AD_Client_ID=0 AND t.IsActive='Y' AND t.IsAllNodes='Y' AND t.TreeType='MM' AND NOT EXISTS (SELECT * FROM AD_TreeNodeMM e WHERE e.AD_Tree_ID=t.AD_Tree_ID AND Node_ID=93102)
+;
+
+--insert process access
+INSERT INTO ad_process_access(ad_process_id, ad_role_id, ad_client_id, ad_org_id, isactive, created,createdby, updated, updatedby, isreadwrite)
+VALUES (93102, 102, 0, 0, 'Y', TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, 'Y');
+--insert process access
+INSERT INTO ad_process_access(ad_process_id, ad_role_id, ad_client_id, ad_org_id, isactive, created,createdby, updated, updatedby, isreadwrite)
+VALUES (93102, 103, 0, 0, 'Y', TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, 'Y');
\ No newline at end of file
Deleted: branches/thailand/ISEC/adempiere354a/migration/354a-trunk/postgresql/FR[Z26]_Pretty_Cash_PrePrinted_Form_postgresql.sql
===================================================================
--- branches/thailand/ISEC/adempiere354a/migration/354a-trunk/postgresql/FR[Z26]_Pretty_Cash_PrePrinted_Form_postgresql.sql 2010-08-10 09:10:51 UTC (rev 13555)
+++ branches/thailand/ISEC/adempiere354a/migration/354a-trunk/postgresql/FR[Z26]_Pretty_Cash_PrePrinted_Form_postgresql.sql 2010-08-10 09:11:20 UTC (rev 13556)
@@ -1,41 +0,0 @@
--- Aug 9, 2010 6:20:02 PM ICT
--- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
-INSERT INTO AD_Process (AD_Org_ID,AD_Process_ID,AccessLevel,CopyFromProcess,Created,CreatedBy,Description,EntityType,IsActive,IsBetaFunctionality,IsDirectPrint,IsReport,IsServerProcess,JasperReport,Name,ShowHelp,Statistic_Count,Statistic_Seconds,Updated,UpdatedBy,Value,AD_Client_ID) VALUES (0,93102,'1','N',TO_TIMESTAMP('2010-08-09 18:20:02','YYYY-MM-DD HH24:MI:SS'),100,'Pretty Cash Pre-Printed Form','U','Y','N','N','Y','N','http://<SERVER>:<PORT>/shw/pretty_cash_report.jrxml','Pretty Cash Pre-Printed Form','Y',0,0,TO_TIMESTAMP('2010-08-09 18:20:02','YYYY-MM-DD HH24:MI:SS'),100,'Pretty Cash Pre-Printed Form',0)
-;
-
--- Aug 9, 2010 6:20:02 PM ICT
--- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
-INSERT INTO AD_Process_Trl (AD_Language,AD_Process_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Process_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Process t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Process_ID=93102 AND EXISTS (SELECT * FROM AD_Process_Trl tt WHERE tt.AD_Language!=l.AD_Language OR tt.AD_Process_ID!=t.AD_Process_ID)
-;
-
--- Aug 9, 2010 6:21:47 PM ICT
--- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
-INSERT INTO AD_Process_Para (AD_Org_ID,AD_Process_ID,AD_Process_Para_ID,AD_Reference_ID,ColumnName,Created,CreatedBy,DefaultValue,Description,DisplayLogic,EntityType,FieldLength,IsActive,IsCentrallyMaintained,IsMandatory,IsRange,Name,ReadOnlyLogic,SeqNo,Updated,UpdatedBy,AD_Client_ID) VALUES (0,93102,93106,15,'DateTrx',TO_TIMESTAMP('2010-08-09 18:21:47','YYYY-MM-DD HH24:MI:SS'),100,NULL,'Transaction Date',NULL,'U',0,'Y','Y','N','Y','Transaction Date',NULL,10,TO_TIMESTAMP('2010-08-09 18:21:47','YYYY-MM-DD HH24:MI:SS'),100,0)
-;
-
--- Aug 9, 2010 6:21:47 PM ICT
--- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
-INSERT INTO AD_Process_Para_Trl (AD_Language,AD_Process_Para_ID, Description,Help,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Process_Para_ID, t.Description,t.Help,t.Name, 'N',t.AD_Client_ID,t.AD_Org_ID,t.Created,t.Createdby,t.Updated,t.UpdatedBy FROM AD_Language l, AD_Process_Para t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Process_Para_ID=93106 AND EXISTS (SELECT * FROM AD_Process_Para_Trl tt WHERE tt.AD_Language!=l.AD_Language OR tt.AD_Process_Para_ID!=t.AD_Process_Para_ID)
-;
-
--- Aug 9, 2010 6:22:58 PM ICT
--- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
-INSERT INTO AD_Menu (AD_Org_ID,AD_Menu_ID,AD_Process_ID,"action",Created,CreatedBy,Description,EntityType,IsActive,IsReadOnly,IsSOTrx,IsSummary,Name,Updated,AD_Client_ID,UpdatedBy) VALUES (0,93102,93102,'R',TO_TIMESTAMP('2010-08-09 18:22:58','YYYY-MM-DD HH24:MI:SS'),100,'Pretty Cash Pre-Printed Form','U','Y','N','N','N','Pretty Cash Pre-Printed Form',TO_TIMESTAMP('2010-08-09 18:22:58','YYYY-MM-DD HH24:MI:SS'),0,100)
-;
-
--- Aug 9, 2010 6:22:58 PM ICT
--- I forgot to set the DICTIONARY_ID_COMMENTS System Configurator
-INSERT INTO AD_Menu_Trl (AD_Language,AD_Menu_ID, Description,Name, IsTranslated,AD_Client_ID,AD_Org_ID,Created,Createdby,Updated,UpdatedBy) SELECT l.AD_Language,t.AD_Menu_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_Menu t WHERE l.IsActive='Y' AND l.IsSystemLanguage='Y' AND l.IsBaseLanguage='N' AND t.AD_Menu_ID=93102 AND EXISTS (SELECT * FROM AD_Menu_Trl tt WHERE tt.AD_Language!=l.AD_Language OR tt.AD_Menu_ID!=t.AD_Menu_ID)
-;
-
--- Aug 9, 2010 6:22:58 PM ICT
--- 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', CURRENT_TIMESTAMP, 0, CURRENT_TIMESTAMP, 0,t.AD_Tree_ID, 93102, 0, 999 FROM AD_Tree t WHERE t.AD_Client_ID=0 AND t.IsActive='Y' AND t.IsAllNodes='Y' AND t.TreeType='MM' AND NOT EXISTS (SELECT * FROM AD_TreeNodeMM e WHERE e.AD_Tree_ID=t.AD_Tree_ID AND Node_ID=93102)
-;
-
---insert process access
-INSERT INTO ad_process_access(ad_process_id, ad_role_id, ad_client_id, ad_org_id, isactive, created,createdby, updated, updatedby, isreadwrite)
-VALUES (93102, 102, 0, 0, 'Y', TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, 'Y');
---insert process access
-INSERT INTO ad_process_access(ad_process_id, ad_role_id, ad_client_id, ad_org_id, isactive, created,createdby, updated, updatedby, isreadwrite)
-VALUES (93102, 103, 0, 0, 'Y', TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, TO_TIMESTAMP('2010-05-06 15:12:39','YYYY-MM-DD HH24:MI:SS'), 100, 'Y');
\ No newline at end of file
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|