details: /erp/devel/main/rev/8511be48f0f8
changeset: 8455:8511be48f0f8
user: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
date: Tue Sep 21 11:40:58 2010 +0530
summary: Fixes Issue 14509: The fields of the 'Product Complete' selector
does not work
details: /erp/devel/main/rev/7cb5584380b5
changeset: 8456:7cb5584380b5
user: Eduardo Argal Guibert <eduardo.argal <at> openbravo.com>
date: Tue Sep 21 11:06:11 2010 +0200
summary: Fixes bug 0014629: G/L Item: Tax field is inactive and has to be
active
details: /erp/devel/main/rev/c0245cb0e221
changeset: 8457:c0245cb0e221
user: Martin Taal <martin.taal <at> openbravo.com>
date: Tue Sep 21 12:31:00 2010 +0200
summary: fixes issue 14619: Generate entities do not notice that a field name
has changed one letter to upper
details: /erp/devel/main/rev/3249119dbc09
changeset: 8458:3249119dbc09
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Tue Sep 21 13:22:49 2010 +0200
summary: Fixes issue 0014634: Cannot unprocess a bank statement with more
than one business partner
It has been reverted the fix created in issue 13958 and applied a proper fix
that consist in only removing the condition C_Settlement_Cancel_ID IS NULL when
selecting business partners to update
details: /erp/devel/main/rev/fc352bd901a6
changeset: 8459:fc352bd901a6
user: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
date: Wed Sep 22 16:30:51 2010 +0530
summary: Fixes issue 14524: Wrong Label in Product Movements Report
Label has been changes as described in the issue (Starting location, Final
location).
No Impacts.
details: /erp/devel/main/rev/e79dc1a96284
changeset: 8460:e79dc1a96284
user: Adrián Romero <adrianromero <at> openbravo.com>
date: Wed Sep 22 13:13:54 2010 +0200
summary: Fixes issue 0014634: Cannot unprocess a bank statement with more
than one business partner
It has been fixed the sentence that gets the business partners to update
details: /erp/devel/main/rev/66a2b1f2a809
changeset: 8461:66a2b1f2a809
user: Valery Lezhebokov <valery.lezhebokov <at> gmail.com>
date: Sun Aug 22 19:28:18 2010 +0200
summary: Fixes issue 13292: Update details for an MP points to current
installed release notes
details: /erp/devel/main/rev/7b519576ec42
changeset: 8462:7b519576ec42
user: Valery Lezhebokov <valery.lezhebokov <at> gmail.com>
date: Tue Aug 31 14:27:33 2010 +0200
summary: merging with PI
details: /erp/devel/main/rev/99e2f90447a6
changeset: 8463:99e2f90447a6
user: Valery Lezhebokov <valery.lezhebokov <at> gmail.com>
date: Wed Sep 01 16:59:24 2010 +0200
summary: Fixes issue 13292: Update details for an MP points to current
installed release notes
details: /erp/devel/main/rev/0667d8d85840
changeset: 8464:0667d8d85840
user: Valery Lezhebokov <valery.lezhebokov <at> gmail.com>
date: Thu Sep 02 09:05:30 2010 +0200
summary: Fixes issue 13826: On email document popup, "Add Attachment" button
label doesn't fit the button
details: /erp/devel/main/rev/4bad3f86effc
changeset: 8465:4bad3f86effc
user: Valery Lezhebokov <valery.lezhebokov <at> gmail.com>
date: Wed Sep 08 17:25:08 2010 +0200
summary: Fixes issue 14346: On activating an instance with a wrong key, the
message is "InvalidPublicKey"
details: /erp/devel/main/rev/2eaf48823a32
changeset: 8466:2eaf48823a32
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Thu Sep 23 12:24:35 2010 +0200
summary: related to issue 14346: Reverted formatting changes of 4bad3f86effc
details: /erp/devel/main/rev/0ec9db2b11aa
changeset: 8467:0ec9db2b11aa
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Thu Sep 23 12:25:41 2010 +0200
summary: merge
details: /erp/devel/main/rev/3d8ae9cb28d5
changeset: 8468:3d8ae9cb28d5
user: Sivaraman Rajagopal <sivaraman.rajagopal <at> openbravo.com>
date: Fri Sep 24 11:03:37 2010 +0530
summary: Fixes issue 14243: Requisition form is not following the logic of
read only for completed status
Read Only Logic is also applied to organisation fields.
details: /erp/devel/main/rev/88428c9b2bcc
changeset: 8469:88428c9b2bcc
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Fri Sep 24 08:42:01 2010 +0200
summary: fixed issue 14689: Tranlation does not work in PG
Translation process now sets NULL instead of '' for empty strings. This
makes Oracle, PostgreSQL and edition from UI behave in the same way,
making also to work properly SQL code expecting null for empty strings.
This last case was what made the translation to fail in AD_Element_Trl_Trg
trigger.
details: /erp/devel/main/rev/9c3462a79ee3
changeset: 8470:9c3462a79ee3
user: Antonio Moreno <antonio.moreno <at> openbravo.com>
date: Fri Sep 24 11:37:55 2010 +0200
summary: Fixed issue 14695. Prevent NullPointerException when using the
rebuild window with some language whose translation module has been uninstalled
details: /erp/devel/main/rev/714819270152
changeset: 8471:714819270152
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Fri Sep 24 12:27:34 2010 +0200
summary: related to issue 14689
When updating ad_element_trl check for changes in PO* columns, this solves:
-A change in a PO* column was not propagated to its trl fields if there was
not also a change in any other column.
-Reinstalling a language didn't made changes as data is not previously
removed,
so the only change after previos fix was changes in PO* from '' to null
details: /erp/devel/main/rev/b7e55cf8773c
changeset: 8472:b7e55cf8773c
user: Valery Lezhebokov <valery.lezhebokov <at> gmail.com>
date: Sun Sep 12 17:18:51 2010 +0200
summary: Fixes issue 14253: Using the link "All" for selecting all the
modules does not activate the Uninstall button
details: /erp/devel/main/rev/57d4bf060d34
changeset: 8473:57d4bf060d34
user: Valery Lezhebokov <valery.lezhebokov <at> gmail.com>
date: Thu Sep 23 16:01:24 2010 +0200
summary: formatting for b7e55cf8773c
details: /erp/devel/main/rev/eac2e293ef02
changeset: 8474:eac2e293ef02
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Fri Sep 24 15:32:36 2010 +0200
summary: merge
details: /erp/devel/main/rev/d6f404defcf2
changeset: 8475:d6f404defcf2
user: Antonio Moreno <antonio.moreno <at> openbravo.com>
date: Fri Sep 24 15:33:32 2010 +0200
summary: Fixed issue 14642. Removed the view so that the Openbravo full build
works in PostgreSQL 9.0
details: /erp/devel/main/rev/d61bca59af84
changeset: 8476:d61bca59af84
user: Martin Taal <martin.taal <at> openbravo.com>
date: Sat Sep 25 11:26:10 2010 +0200
summary: Fixes issue 14636: Support database views defined in the AD in the
Data Access Layer, Fixes issue 9640: Table Validation on View
details: /erp/devel/main/rev/508c1e4e6b7a
changeset: 8477:508c1e4e6b7a
user: Martin Taal <martin.taal <at> openbravo.com>
date: Sat Sep 25 11:27:17 2010 +0200
summary: Fixes source warning
details: /erp/devel/main/rev/6000237719aa
changeset: 8478:6000237719aa
user: Asier Lostalé <asier.lostale <at> openbravo.com>
date: Mon Sep 27 11:39:06 2010 +0200
summary: fixed bug 14701: Not possible to register a module that has been
installed
Removed display logic for register button, now it is possible to click on
it for modules set as registered. When trying to register a module that has
already been registered the following meesage is shown:
Module Id already Registered
details: /erp/devel/main/rev/f2c30fd7b2f8
changeset: 8479:f2c30fd7b2f8
user: Víctor Martínez Romanos <victor.martinez <at> openbravo.com>
date: Mon Sep 27 10:13:22 2010 +0200
summary: Fixed bug 11460: Unpost a document in a closed period
Added a check in the FACT_ACCT_RESET process that is run
only when the user manually tries to unpost a document. If the
period is closed, an error is shown.
However, the global 'Reset accounting' process will not show any error in
case it finds any document in a closed period.
details: /erp/devel/main/rev/f6316be65fe7
changeset: 8480:f6316be65fe7
user: Antonio Moreno <antonio.moreno <at> openbravo.com>
date: Tue Sep 28 11:09:22 2010 +0200
summary: Related to issue 14642. Readded the view so that
ad_script_disable/enable_triggers still work, but with a small change so that
it works in PostgreSQL 8.4 and 9.0
details: /erp/devel/main/rev/51c2c2967221
changeset: 8481:51c2c2967221
user: RM packaging bot <staff.rm <at> openbravo.com>
date: Wed Sep 29 09:56:39 2010 +0000
summary: CI: promote changesets from pi to main
diffstat:
.hgsigs | 1
+
.hgtags | 1
+
src-db/database/model/functions/C_BANKSTATEMENT_POST.xml | 9
+-
src-db/database/model/functions/FACT_ACCT_RESET.xml | 36
++++++-
src-db/database/model/postscript-PostgreSql.sql | 2
-
src-db/database/model/prescript-PostgreSql.sql | 32
+++++-
src-db/database/model/triggers/AD_ELEMENT_TRL_TRG.xml | 9
+-
src-db/database/sourcedata/AD_COLUMN.xml | 2
+
src-db/database/sourcedata/AD_FIELD.xml | 3
+-
src-db/database/sourcedata/AD_MESSAGE.xml | 32
+++++-
src-db/database/sourcedata/AD_MODULE.xml | 2
+-
src-db/database/sourcedata/AD_TEXTINTERFACES.xml | 11
--
src-test/org/openbravo/test/AllAntTaskTests.java | 2
+
src-test/org/openbravo/test/dal/ViewTest.java | 52
++++++++++
src/org/openbravo/base/model/Column.java | 5
+-
src/org/openbravo/base/model/ModelProvider.java | 19
+-
src/org/openbravo/base/model/NamingUtil.java | 8
+-
src/org/openbravo/erpCommon/ad_forms/ModuleManagementInstalled.html | 2
+
src/org/openbravo/erpCommon/ad_forms/TranslationHandler.java | 4
+-
src/org/openbravo/erpCommon/ad_process/ApplyModules.java | 2
+-
src/org/openbravo/erpCommon/ad_reports/ReportProductMovement.html | 4
+-
src/org/openbravo/erpCommon/info/ProductComplete.java | 2
+-
src/org/openbravo/erpCommon/modules/ImportModule.java | 2
+-
src/org/openbravo/erpCommon/modules/ImportModule_data.xsql | 4
+-
src/org/openbravo/erpCommon/utility/reporting/printing/EmailOptions.html | 12
+-
web/js/genericTree.js | 10
+-
26 files changed, 201 insertions(+), 67 deletions(-)
diffs (truncated from 688 to 300 lines):
diff -r cb48a6557b67 -r 51c2c2967221 .hgsigs
--- a/.hgsigs Mon Sep 20 17:38:36 2010 +0200
+++ b/.hgsigs Wed Sep 29 09:56:39 2010 +0000
@@ -22,3 +22,4 @@
7fe932c5c015da84a972d6945dd0451366bbf325 0
iEYEABECAAYFAkwodmcACgkQCX/oGf+2qkM4jQCgq2n4X0Tzi8EcGqNLhtzjOJ/1YcgAn3Fh9aZRpXmM2zYmMwuecn4UR5tt
618363224a381737439e0bd4461e2d36c4fd986e 0
iEYEABECAAYFAkxFkHoACgkQCX/oGf+2qkP7DQCeK9qCv3jETpO5iM89PV2bJYmpErMAoO/H2QyeKKZjublcgFmH7g1tEomB
6563372bc2fbf0bc2e15f70c2a8da81fad8cbc2e 0
iEYEABECAAYFAkyDw4sACgkQCX/oGf+2qkMZ1ACePoFeipRkNAN6bW7yIUeiRYgEMBMAni+gFwpEp8kfGKryvixvdudRgGoQ
+b033dcbeeabc1db396798b8e5cbe196522f43a53 0
iEYEABECAAYFAkydFwMACgkQCX/oGf+2qkM1NwCbBJjgs9qM221q415Ygu/EVvhE31sAn2+O6DOYQNbM3xFuCnhhtuDQWDa/
diff -r cb48a6557b67 -r 51c2c2967221 .hgtags
--- a/.hgtags Mon Sep 20 17:38:36 2010 +0200
+++ b/.hgtags Wed Sep 29 09:56:39 2010 +0000
@@ -32,3 +32,4 @@
34eed7b386965b19e191fbfe03195588cdc75254 2.50MP19
99ff33f6588973f7e738b6afd47ad44f3ac08d20 2.50MP20
a3c1cffa8af7b60cab6949251fce1faaa13ca5bb 2.50MP21
+8ede6ac265f1dd70536888ce3e20ffd54e3a3bc6 2.50MP22
diff -r cb48a6557b67 -r 51c2c2967221
src-db/database/model/functions/C_BANKSTATEMENT_POST.xml
--- a/src-db/database/model/functions/C_BANKSTATEMENT_POST.xml Mon Sep 20
17:38:36 2010 +0200
+++ b/src-db/database/model/functions/C_BANKSTATEMENT_POST.xml Wed Sep 29
09:56:39 2010 +0000
@@ -145,7 +145,7 @@
v_ResultStr := 'Reversed';
--Unpost Settlement
- FOR Cur_AutomaticSettlementCancel IN (SELECT DISTINCT S.C_SETTLEMENT_ID,
DP.C_BPartner_ID
+ FOR Cur_AutomaticSettlementCancel IN (SELECT DISTINCT S.C_SETTLEMENT_ID
FROM C_DEBT_PAYMENT DP, C_SETTLEMENT S
WHERE DP.C_SETTLEMENT_CANCEL_ID = S.C_SETTLEMENT_ID
AND DP.C_BANKSTATEMENTLINE_ID IN
@@ -169,10 +169,9 @@
BEGIN
FOR Cur_Debts IN
(SELECT DISTINCT C_BPartner_ID
- FROM C_DEBT_PAYMENT
- WHERE
- C_BPartner_ID = Cur_AutomaticSettlementCancel.C_BPartner_ID
- OR
C_Settlement_Generate_ID=Cur_AutomaticSettlementCancel.C_SETTLEMENT_ID AND
ISRECEIPT = 'Y'
+ FROM C_DEBT_PAYMENT, C_BANKSTATEMENTLINE
+ WHERE C_DEBT_PAYMENT.C_DEBT_PAYMENT_ID =
C_BANKSTATEMENTLINE.C_DEBT_PAYMENT_ID
+ AND C_BANKSTATEMENTLINE.C_BANKSTATEMENT_ID = v_Record_ID
)
LOOP
C_BP_SOCREDITUSED_REFRESH(Cur_Debts.C_BPartner_ID) ;
diff -r cb48a6557b67 -r 51c2c2967221
src-db/database/model/functions/FACT_ACCT_RESET.xml
--- a/src-db/database/model/functions/FACT_ACCT_RESET.xml Mon Sep 20
17:38:36 2010 +0200
+++ b/src-db/database/model/functions/FACT_ACCT_RESET.xml Wed Sep 29
09:56:39 2010 +0000
@@ -19,7 +19,7 @@
* parts created by ComPiere are Copyright (C) ComPiere, Inc.;
* All Rights Reserved.
* Contributor(s): Openbravo SLU
- * Contributions are Copyright (C) 2001-2009 Openbravo, S.L.U.
+ * Contributions are Copyright (C) 2001-2010 Openbravo, S.L.U.
*
* Specifically, this derivative work is based upon the following Compiere
* file and version.
@@ -62,6 +62,8 @@
v_DocAction VARCHAR2(60);
v_UpdatedBy AD_PINSTANCE.UpdatedBy%TYPE;
v_DeleteFact varchar2(1):='Y';
+
+ v_isacctle AD_OrgType.IsAcctLegalEntity%TYPE:='N';
BEGIN
-- Update AD_PInstance
DBMS_OUTPUT.PUT_LINE('Updating PInstance - Processing ' || p_PInstance_ID)
;
@@ -119,14 +121,41 @@
WHERE ' || v_TableName || '_ID =''' || v_Record_ID || ''' AND
AD_CLIENT_ID =''' || v_AD_Client_ID || ''' '
INTO v_AD_Org_ID;
END IF;
+
+ -- Check the period control is opened (only if it is legal entity with
accounting)
+ SELECT COALESCE(t.ISACCTLEGALENTITY, 'N')
+ INTO v_isacctle
+ FROM AD_Org o JOIN AD_OrgType t ON (o.ad_orgtype_id=t.ad_orgtype_id)
+ WHERE AD_IsOrgIncluded(v_AD_Org_ID, o.ad_org_id , v_AD_Client_ID) <> -1
+ AND t.ISACCTLEGALENTITY='Y';
+ IF (v_isacctle='Y') THEN
+ DECLARE
+ v_available_period NUMBER:=0;
+ TYPE RECORD IS REF CURSOR;
+ Cur_Fact_Records RECORD;
+ BEGIN
+ FOR Cur_Fact_Records IN
+ (SELECT DATEACCT, DOCBASETYPE, C_DOCTYPE_ID
+ FROM FACT_ACCT
+ WHERE AD_TABLE_ID=v_AD_Table_ID
+ AND Record_ID = v_Record_ID
+ )
+ LOOP
+ v_available_period:=C_CHK_OPEN_PERIOD(v_AD_Org_ID,
Cur_Fact_Records.DATEACCT, Cur_Fact_Records.DOCBASETYPE,
Cur_Fact_Records.C_DOCTYPE_ID);
+ IF (v_available_period<>1) THEN
+ RAISE_APPLICATION_ERROR(-20000, '@PeriodClosedForUnPosting@');
+ END IF;
+ END LOOP;
+ END;
+ END IF;
END IF;
DBMS_OUTPUT.PUT_LINE(' Record_ID=' || v_Record_ID) ;
- -- Fact_Acct_Rest - Finish_Process Extension Point
+ -- Fact_Acct_Rest - Start_Process Extension Point
SELECT count(*) INTO v_count
FROM DUAL
where exists (select 1 from ad_ep_procedures where ad_extension_points_id =
'E1F9635815BF4A44B88E3EAADBD0D10E');
- IF (v_count=1) THEN
+ IF (v_count=1) THEN
DECLARE
v_ep_instance VARCHAR(32);
v_extension_point_id VARCHAR(32) := 'E1F9635815BF4A44B88E3EAADBD0D10E';
@@ -166,6 +195,7 @@
WHERE ad_ep_instance_id = v_ep_instance;
END;
END IF;
+ -- Fact_Acct_Rest - Finish_Process Extension Point
DECLARE
TYPE RECORD IS REF CURSOR;
Cur_Clients RECORD;
diff -r cb48a6557b67 -r 51c2c2967221
src-db/database/model/postscript-PostgreSql.sql
--- a/src-db/database/model/postscript-PostgreSql.sql Mon Sep 20 17:38:36
2010 +0200
+++ b/src-db/database/model/postscript-PostgreSql.sql Wed Sep 29 09:56:39
2010 +0000
@@ -23,7 +23,6 @@
BEGIN
FOR Cur_Triggers IN (SELECT OBJECT_NAME AS NAME, TABLE_NAME
FROM USER_OBJECTS
- WHERE OBJECT_TYPE = 'TRIGGER'
ORDER BY OBJECT_NAME) LOOP
v_seqNo := v_seqNo + 1;
-- INSERT INTO AD_SCRIPT_SQL VALUES (v_seqNo, 'ALTER TRIGGER
'||Cur_Triggers.NAME||' DISABLE');
@@ -96,7 +95,6 @@
BEGIN
FOR Cur_Triggers IN (SELECT OBJECT_NAME AS NAME, TABLE_NAME
FROM USER_OBJECTS
- WHERE OBJECT_TYPE = 'TRIGGER'
ORDER BY OBJECT_NAME) LOOP
v_seqNo := v_seqNo + 1;
-- INSERT INTO AD_SCRIPT_SQL VALUES (v_seqNo, 'ALTER TRIGGER
'||Cur_Triggers.NAME||' ENABLE');
diff -r cb48a6557b67 -r 51c2c2967221
src-db/database/model/prescript-PostgreSql.sql
--- a/src-db/database/model/prescript-PostgreSql.sql Mon Sep 20 17:38:36
2010 +0200
+++ b/src-db/database/model/prescript-PostgreSql.sql Wed Sep 29 09:56:39
2010 +0000
@@ -1158,18 +1158,42 @@
SELECT * FROM drop_view('USER_OBJECTS')
/-- END
-CREATE OR REPLACE VIEW USER_OBJECTS
-(TABLE_NAME, OBJECT_NAME, OBJECT_ID, OBJECT_TYPE, STATUS)
+CREATE or REPLACE function create_user_objects() returns varchar as '
+DECLARE
+ cnt int4;
+BEGIN
+ SELECT into cnt count(*) from version() where version like ''%PostgreSQL
9.%'';
+ if cnt > 0 then
+ execute ''CREATE OR REPLACE VIEW USER_OBJECTS
+(TABLE_NAME, OBJECT_NAME, OBJECT_ID)
AS
-SELECT UPPER(PG_CLASS.RELNAME), UPPER(PG_TRIGGER.TGNAME), PG_TRIGGER.TGFOID,
TO_CHAR('TRIGGER'), CASE is_Trigger_Enabled(PG_TRIGGER.TGNAME) WHEN TRUE THEN
TO_CHAR('VALID') ELSE TO_CHAR('INVALID') END
+SELECT UPPER(PG_CLASS.RELNAME), UPPER(PG_TRIGGER.TGNAME), PG_TRIGGER.TGFOID
+FROM PG_TRIGGER, PG_NAMESPACE, PG_CLASS
+WHERE PG_TRIGGER.TGRELID = PG_CLASS.OID
+AND PG_TRIGGER.TGISINTERNAL = FALSE
+AND PG_CLASS.RELNAMESPACE = PG_NAMESPACE.OID
+AND PG_NAMESPACE.NSPNAME = CURRENT_SCHEMA()'';
+else
+execute ''CREATE OR REPLACE VIEW USER_OBJECTS
+(TABLE_NAME, OBJECT_NAME, OBJECT_ID)
+AS
+SELECT UPPER(PG_CLASS.RELNAME), UPPER(PG_TRIGGER.TGNAME), PG_TRIGGER.TGFOID
FROM PG_TRIGGER, PG_NAMESPACE, PG_CLASS
WHERE PG_TRIGGER.TGRELID = PG_CLASS.OID
AND PG_TRIGGER.TGISCONSTRAINT = FALSE
AND PG_CLASS.RELNAMESPACE = PG_NAMESPACE.OID
-AND PG_NAMESPACE.NSPNAME = CURRENT_SCHEMA()
+AND PG_NAMESPACE.NSPNAME = CURRENT_SCHEMA()'';
+ end if;
+ return null;
+END;'
+language 'plpgsql'
/-- END
+SELECT * FROM create_user_objects()
+/-- END
+DROP FUNCTION create_user_objects()
+/-- END
SELECT * FROM drop_view('USER_CONS_COLUMNS')
/-- END
diff -r cb48a6557b67 -r 51c2c2967221
src-db/database/model/triggers/AD_ELEMENT_TRL_TRG.xml
--- a/src-db/database/model/triggers/AD_ELEMENT_TRL_TRG.xml Mon Sep 20
17:38:36 2010 +0200
+++ b/src-db/database/model/triggers/AD_ELEMENT_TRL_TRG.xml Wed Sep 29
09:56:39 2010 +0000
@@ -38,12 +38,13 @@
IF UPDATING
THEN
IF ( COALESCE (:OLD.NAME, '.') <> COALESCE (:NEW.NAME, '.')
- OR COALESCE (:OLD.Description, '.') <>
- COALESCE (:NEW.Description, '.')
+ OR COALESCE (:OLD.Description, '.') <> COALESCE (:NEW.Description, '.')
OR COALESCE (:OLD.HELP, '.') <> COALESCE (:NEW.HELP, '.')
OR COALESCE (:OLD.PrintName, '.') <> COALESCE (:NEW.PrintName, '.')
- OR COALESCE (:OLD.IsTranslated, '.') <>
- COALESCE (:NEW.IsTranslated, '.')
+ OR COALESCE (:OLD.IsTranslated, '.') <> COALESCE (:NEW.IsTranslated,
'.')
+ OR COALESCE (:OLD.PO_NAME, '.') <> COALESCE (:NEW.PO_NAME, '.')
+ OR COALESCE (:OLD.PO_Description, '.') <> COALESCE
(:NEW.PO_Description, '.')
+ OR COALESCE (:OLD.PO_HELP, '.') <> COALESCE (:NEW.PO_HELP, '.')
)
THEN
-- Field
diff -r cb48a6557b67 -r 51c2c2967221 src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml Mon Sep 20 17:38:36 2010 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml Wed Sep 29 09:56:39 2010 +0000
@@ -240013,6 +240013,7 @@
<!--803531--> <ISPARENT><![CDATA[N]]></ISPARENT>
<!--803531--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
<!--803531--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--803531-->
<READONLYLOGIC><![cda...@docstatus@='CO'|@docsta...@='CL']]></READONLYLOGIC>
<!--803531--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
<!--803531--> <SEQNO><![CDATA[30]]></SEQNO>
<!--803531--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
@@ -240457,6 +240458,7 @@
<!--803544--> <ISPARENT><![CDATA[N]]></ISPARENT>
<!--803544--> <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
<!--803544--> <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--803544-->
<READONLYLOGIC><![cda...@docstatus@='CO'|@docsta...@='CL']]></READONLYLOGIC>
<!--803544--> <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
<!--803544--> <SEQNO><![CDATA[30]]></SEQNO>
<!--803544--> <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
diff -r cb48a6557b67 -r 51c2c2967221 src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml Mon Sep 20 17:38:36 2010 +0200
+++ b/src-db/database/sourcedata/AD_FIELD.xml Wed Sep 29 09:56:39 2010 +0000
@@ -190844,7 +190844,6 @@
<!--59D388C6AF9CDD4EE040007F010043D6-->
<AD_TAB_ID><![CDATA[F53E35A11C564F20BE4082A7B8CFF6B7]]></AD_TAB_ID>
<!--59D388C6AF9CDD4EE040007F010043D6-->
<AD_COLUMN_ID><![CDATA[59D47C703D99BCCFE040007F0100439B]]></AD_COLUMN_ID>
<!--59D388C6AF9CDD4EE040007F010043D6-->
<ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
-<!--59D388C6AF9CDD4EE040007F010043D6-->
<DISPLAYLOGIC><![cda...@isregistered@='N']]></DISPLAYLOGIC>
<!--59D388C6AF9CDD4EE040007F010043D6-->
<DISPLAYLENGTH><![CDATA[1]]></DISPLAYLENGTH>
<!--59D388C6AF9CDD4EE040007F010043D6--> <ISREADONLY><![CDATA[N]]></ISREADONLY>
<!--59D388C6AF9CDD4EE040007F010043D6--> <SEQNO><![CDATA[290]]></SEQNO>
@@ -203772,7 +203771,7 @@
<!--C92612B656AC11DEBB69837DC96AB39A-->
<AD_FIELD_ID><![CDATA[C92612B656AC11DEBB69837DC96AB39A]]></AD_FIELD_ID>
<!--C92612B656AC11DEBB69837DC96AB39A-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
<!--C92612B656AC11DEBB69837DC96AB39A--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--C92612B656AC11DEBB69837DC96AB39A--> <ISACTIVE><![CDATA[N]]></ISACTIVE>
+<!--C92612B656AC11DEBB69837DC96AB39A--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--C92612B656AC11DEBB69837DC96AB39A--> <NAME><![CDATA[Tax]]></NAME>
<!--C92612B656AC11DEBB69837DC96AB39A--> <DESCRIPTION><![CDATA[The percentage
of money requested by the government for this specified product or
transaction.]]></DESCRIPTION>
<!--C92612B656AC11DEBB69837DC96AB39A--> <HELP><![CDATA[The Tax indicates the
type of tax for this document line.]]></HELP>
diff -r cb48a6557b67 -r 51c2c2967221 src-db/database/sourcedata/AD_MESSAGE.xml
--- a/src-db/database/sourcedata/AD_MESSAGE.xml Mon Sep 20 17:38:36 2010 +0200
+++ b/src-db/database/sourcedata/AD_MESSAGE.xml Wed Sep 29 09:56:39 2010 +0000
@@ -28920,7 +28920,7 @@
<!--1006400012--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--1006400012--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--1006400012--> <VALUE><![CDATA[PCS_QTY]]></VALUE>
-<!--1006400012--> <MSGTEXT><![CDATA[Quantity]]></MSGTEXT>
+<!--1006400012--> <MSGTEXT><![CDATA[Quantity on Hand]]></MSGTEXT>
<!--1006400012--> <MSGTIP><![CDATA[Used for column name translation in
Product Complete Selector]]></MSGTIP>
<!--1006400012--> <MSGTYPE><![CDATA[I]]></MSGTYPE>
<!--1006400012--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
@@ -28956,7 +28956,7 @@
<!--1006400015--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--1006400015--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--1006400015--> <VALUE><![CDATA[PCS_QTYORDER]]></VALUE>
-<!--1006400015--> <MSGTEXT><![CDATA[Quant. of order]]></MSGTEXT>
+<!--1006400015--> <MSGTEXT><![CDATA[On Hand Quantity order]]></MSGTEXT>
<!--1006400015--> <MSGTIP><![CDATA[Used for column name translation in
Product Complete Selector]]></MSGTIP>
<!--1006400015--> <MSGTYPE><![CDATA[I]]></MSGTYPE>
<!--1006400015--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
@@ -28968,7 +28968,7 @@
<!--1006400016--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--1006400016--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--1006400016--> <VALUE><![CDATA[PCS_C_UOM2]]></VALUE>
-<!--1006400016--> <MSGTEXT><![CDATA[Order No.]]></MSGTEXT>
+<!--1006400016--> <MSGTEXT><![CDATA[Order UOM]]></MSGTEXT>
<!--1006400016--> <MSGTIP><![CDATA[Used for column name translation in
Product Complete Selector]]></MSGTIP>
<!--1006400016--> <MSGTYPE><![CDATA[I]]></MSGTYPE>
<!--1006400016--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
@@ -28980,7 +28980,7 @@
<!--1006400017--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--1006400017--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--1006400017--> <VALUE><![CDATA[PCS_QTY_REF]]></VALUE>
-<!--1006400017--> <MSGTEXT><![CDATA[Quant. Served]]></MSGTEXT>
+<!--1006400017--> <MSGTEXT><![CDATA[Quantity in draft
transactions]]></MSGTEXT>
<!--1006400017--> <MSGTIP><![CDATA[Used for column name translation in
Product Complete Selector]]></MSGTIP>
<!--1006400017--> <MSGTYPE><![CDATA[I]]></MSGTYPE>
<!--1006400017--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
@@ -28992,7 +28992,7 @@
<!--1006400018--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--1006400018--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--1006400018--> <VALUE><![CDATA[PCS_QUANTITYORDER_REF]]></VALUE>
-<!--1006400018--> <MSGTEXT><![CDATA[Quant. of order delivered]]></MSGTEXT>
+<!--1006400018--> <MSGTEXT><![CDATA[Quantity Order in draft
transactions]]></MSGTEXT>
<!--1006400018--> <MSGTIP><![CDATA[Used for column name translation in
Product Complete Selector]]></MSGTIP>
<!--1006400018--> <MSGTYPE><![CDATA[I]]></MSGTYPE>
<!--1006400018--> <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
@@ -29579,6 +29579,17 @@
<!--043C7F0B055D4B01B5E9CAB6A94FCD85-->
<AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
<!--043C7F0B055D4B01B5E9CAB6A94FCD85--></AD_MESSAGE>
+<!--04591200C09947A08DA4E8462197B2C3--><AD_MESSAGE>
+<!--04591200C09947A08DA4E8462197B2C3-->
<AD_MESSAGE_ID><![CDATA[04591200C09947A08DA4E8462197B2C3]]></AD_MESSAGE_ID>
+<!--04591200C09947A08DA4E8462197B2C3-->
<AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--04591200C09947A08DA4E8462197B2C3--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
