[cleanup] Removed AD_TREENODEMM table
authorVíctor Martínez Romanos <victor.martinez@openbravo.com>
Tue, 10 May 2011 16:35:05 +0200
changeset 12106 aa63d51a7b54
parent 12103 347e6802d41c
child 12107 f9343faf73b8
[cleanup] Removed AD_TREENODEMM table
src-db/database/model/tables/AD_TREENODEMM.xml
src-db/database/model/triggers/AD_ACCOUNTINGRPT_ELEMENT_TRG.xml
src-db/database/model/triggers/AD_MENU_TRG.xml
src-db/database/model/triggers/AD_TREE_TRG.xml
src-db/database/model/triggers/C_TAX_REPORT_TRG.xml
src-db/database/sourcedata/AD_COLUMN.xml
src-db/database/sourcedata/AD_DATASET_TABLE.xml
src-db/database/sourcedata/AD_TABLE.xml
--- a/src-db/database/model/tables/AD_TREENODEMM.xml	Tue May 10 15:35:00 2011 +0200
+++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
@@ -1,70 +0,0 @@
-<?xml version="1.0"?>
-  <database name="TABLE AD_TREENODEMM">
-    <table name="AD_TREENODEMM" primaryKey="AD_TREENODEMM_KEY">
-      <column name="AD_TREENODEMM_ID" primaryKey="true" required="true" type="VARCHAR" size="32" autoIncrement="false">
-        <default/>
-        <onCreateDefault><![CDATA[get_uuid()]]></onCreateDefault>
-      </column>
-      <column name="AD_TREE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
-      <column name="NODE_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
-      <column name="AD_CLIENT_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
-      <column name="AD_ORG_ID" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
-      <column name="ISACTIVE" primaryKey="false" required="true" type="CHAR" size="1" autoIncrement="false">
-        <default><![CDATA[Y]]></default>
-        <onCreateDefault/>
-      </column>
-      <column name="CREATED" primaryKey="false" required="true" type="TIMESTAMP" size="7" autoIncrement="false">
-        <default><![CDATA[SYSDATE]]></default>
-        <onCreateDefault/>
-      </column>
-      <column name="CREATEDBY" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
-      <column name="UPDATED" primaryKey="false" required="true" type="TIMESTAMP" size="7" autoIncrement="false">
-        <default><![CDATA[SYSDATE]]></default>
-        <onCreateDefault/>
-      </column>
-      <column name="UPDATEDBY" primaryKey="false" required="true" type="VARCHAR" size="32" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
-      <column name="PARENT_ID" primaryKey="false" required="false" type="VARCHAR" size="32" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
-      <column name="SEQNO" primaryKey="false" required="false" type="DECIMAL" size="10,0" autoIncrement="false">
-        <default/>
-        <onCreateDefault/>
-      </column>
-      <foreign-key foreignTable="AD_CLIENT" name="AD_TREENODEMM_AD_CLIENT">
-        <reference local="AD_CLIENT_ID" foreign="AD_CLIENT_ID"/>
-      </foreign-key>
-      <foreign-key foreignTable="AD_ORG" name="AD_TREENODEMM_AD_ORG">
-        <reference local="AD_ORG_ID" foreign="AD_ORG_ID"/>
-      </foreign-key>
-      <foreign-key foreignTable="AD_TREE" name="AD_TREENODEMM_AD_TREE" onDelete="cascade">
-        <reference local="AD_TREE_ID" foreign="AD_TREE_ID"/>
-      </foreign-key>
-      <index name="AD_TREENODEMM_PARENT" unique="false">
-        <index-column name="PARENT_ID"/>
-      </index>
-      <unique name="AD_TREENODEMM_TREE_NODE_UN">
-        <unique-column name="AD_TREE_ID"/>
-        <unique-column name="NODE_ID"/>
-      </unique>
-      <check name="AD_TREENODEMM_ISACTIVE_CHECK"><![CDATA[ISACTIVE IN ('Y', 'N')]]></check>
-    </table>
-  </database>
--- a/src-db/database/model/triggers/AD_ACCOUNTINGRPT_ELEMENT_TRG.xml	Tue May 10 15:35:00 2011 +0200
+++ b/src-db/database/model/triggers/AD_ACCOUNTINGRPT_ELEMENT_TRG.xml	Tue May 10 16:35:05 2011 +0200
@@ -18,13 +18,12 @@
 * under the License.
 * The Original Code is Openbravo ERP.
 * The Initial Developer of the Original Code is Openbravo SLU
-* All portions are Copyright (C) 2001-2006 Openbravo SLU
+* All portions are Copyright (C) 2001-2011 Openbravo SLU
 * All Rights Reserved.
 * Contributor(s):  ______________________________________.
 ************************************************************************/
   v_xTree_ID VARCHAR2(32);
   v_xParent_ID VARCHAR2(32);
-  v_NextNo     VARCHAR2(32);
     
 BEGIN
     
@@ -36,14 +35,6 @@
   --  for Translation
   --  and TreeNode
   IF INSERTING THEN
-    --  Create TreeNode --
-    --  get AD_Tree_ID + ParentID
-    --SELECT  c.AD_Tree_Menu_ID, n.Node_ID
-    -- INTO  v_xTree_ID, v_xParent_ID
-    -- FROM    AD_CLIENTINFO c, AD_TREENODE n -- AD_TreeNodeMM n
-    --  WHERE   c.AD_Tree_Menu_ID=n.AD_Tree_ID
-    --    AND n.Parent_ID IS NULL
-    --AND c.AD_Client_ID=:NEW.AD_Client_ID;
     SELECT AD_TREE_ID,
       '0'
     INTO v_xTree_ID,
@@ -55,7 +46,6 @@
     --  Insert into TreeNode
     INSERT
     INTO AD_TREENODE
-      -- AD_TreeNodeMM
       (
         AD_TreeNode_ID, AD_Client_ID, AD_Org_ID, IsActive,
         Created, CreatedBy, Updated,
@@ -87,16 +77,8 @@
    OR COALESCE(:old.IsActive, '.') <> COALESCE(:NEW.IsActive, '.')))
   THEN
       IF(:OLD.IsActive!=:NEW.IsActive) THEN
-        --  get AD_Tree_ID + ParentID
-        --SELECT  c.AD_Tree_Menu_ID, n.Node_ID
-        --INTO  v_xTree_ID, v_xParent_ID
-        --FROM    AD_CLIENTINFO c, AD_TREENODE n -- AD_TreeNodeMM n
-        --WHERE   c.AD_Tree_Menu_ID=n.AD_Tree_ID
-        --  AND n.Parent_ID IS NULL
-        --AND c.AD_Client_ID=:NEW.AD_Client_ID;
         -- Update
         UPDATE AD_TREENODE
-          -- AD_TreeNodeMM
           SET IsActive=:NEW.IsActive
         WHERE AD_Tree_ID=v_xTree_ID
           AND Node_ID=:NEW.AD_Accountingrpt_Element_ID;
--- a/src-db/database/model/triggers/AD_MENU_TRG.xml	Tue May 10 15:35:00 2011 +0200
+++ b/src-db/database/model/triggers/AD_MENU_TRG.xml	Tue May 10 16:35:05 2011 +0200
@@ -17,7 +17,7 @@
   * parts created by ComPiere are Copyright (C) ComPiere, Inc.;
   * All Rights Reserved.
   * Contributor(s): Openbravo SLU
-  * Contributions are Copyright (C) 2001-2010 Openbravo, S.L.U.
+  * Contributions are Copyright (C) 2001-2011 Openbravo, S.L.U.
   *
   * Specifically, this derivative work is based upon the following Compiere
   * file and version.
@@ -67,7 +67,6 @@
       v_xParent_ID
     FROM AD_ClientInfo c,
       AD_TreeNode n
-      -- AD_TreeNodeMM n
     WHERE c.AD_Tree_Menu_ID=n.AD_Tree_ID
       AND n.Parent_ID IS NULL
       AND c.AD_Client_ID=:new.AD_Client_ID;
@@ -75,7 +74,6 @@
     --  Insert into TreeNode
     INSERT
     INTO AD_TreeNode
-      -- AD_TreeNodeMM
       (
         AD_TreeNode_ID, AD_Client_ID, AD_Org_ID, IsActive,
         Created, CreatedBy, Updated,
--- a/src-db/database/model/triggers/AD_TREE_TRG.xml	Tue May 10 15:35:00 2011 +0200
+++ b/src-db/database/model/triggers/AD_TREE_TRG.xml	Tue May 10 16:35:05 2011 +0200
@@ -25,8 +25,6 @@
     * Insert AD_Tree Trigger
     *  add Parent TreeNode
     */
-  v_NextNo VARCHAR2(32);
-  v_Tree_ID VARCHAR2(32);
     
 BEGIN
     
@@ -51,25 +49,6 @@
       NULL, 0
     )
     ;
-  --  Insert into TreeNodeMM
-  IF(:new.TREETYPE='MM') THEN
-    INSERT
-    INTO AD_TreeNodeMM
-      (
-        AD_TreeNodeMM_ID, AD_Client_ID, AD_Org_ID, IsActive,
-        Created, CreatedBy, Updated,
-        UpdatedBy, AD_Tree_ID, Node_ID,
-        Parent_ID, SeqNo
-      )
-      VALUES
-      (
-        get_uuid(), :new.AD_Client_ID, :new.AD_Org_ID, :new.IsActive,
-        :new.Created, :new.CreatedBy, :new.Updated,
-        :new.UpdatedBy, :new.AD_Tree_ID, '0',
-        NULL, 0
-      )
-      ;
-  END IF;
 END AD_TREE_TRG
 ]]></body>
     </trigger>
--- a/src-db/database/model/triggers/C_TAX_REPORT_TRG.xml	Tue May 10 15:35:00 2011 +0200
+++ b/src-db/database/model/triggers/C_TAX_REPORT_TRG.xml	Tue May 10 16:35:05 2011 +0200
@@ -18,7 +18,7 @@
 * under the License.
 * The Original Code is Openbravo ERP.
 * The Initial Developer of the Original Code is Openbravo SLU
-* All portions are Copyright (C) 2001-2008 Openbravo SLU
+* All portions are Copyright (C) 2001-2011 Openbravo SLU
 * All Rights Reserved.
 * Contributor(s):  ______________________________________.
 ************************************************************************/
@@ -36,14 +36,6 @@
   --  for Translation
   --  and TreeNode
   IF INSERTING THEN
-    --  Create TreeNode --
-    --  get AD_Tree_ID + ParentID
-    --SELECT  c.AD_Tree_Menu_ID, n.Node_ID
-    -- INTO  v_xTree_ID, v_xParent_ID
-    -- FROM    AD_CLIENTINFO c, AD_TREENODE n -- AD_TreeNodeMM n
-    --  WHERE   c.AD_Tree_Menu_ID=n.AD_Tree_ID
-    --    AND n.Parent_ID IS NULL
-    --AND c.AD_Client_ID=:NEW.AD_Client_ID;
     SELECT AD_TREE_ID,
       0
     INTO v_xTree_ID,
@@ -55,7 +47,6 @@
     --  Insert into TreeNode
     INSERT
     INTO AD_TREENODE
-      -- AD_TreeNodeMM
       (
         AD_TreeNode_Id, AD_Client_ID, AD_Org_ID, IsActive,
         Created, CreatedBy, Updated,
@@ -87,16 +78,8 @@
    OR COALESCE(:OLD.IsActive, '.') <> COALESCE(:NEW.IsActive, '.')))
   THEN
       IF(:OLD.IsActive!=:NEW.IsActive) THEN
-        --  get AD_Tree_ID + ParentID
-        --SELECT  c.AD_Tree_Menu_ID, n.Node_ID
-        --INTO  v_xTree_ID, v_xParent_ID
-        --FROM    AD_CLIENTINFO c, AD_TREENODE n -- AD_TreeNodeMM n
-        --WHERE   c.AD_Tree_Menu_ID=n.AD_Tree_ID
-        --  AND n.Parent_ID IS NULL
-        --AND c.AD_Client_ID=:NEW.AD_Client_ID;
         -- Update
         UPDATE AD_TREENODE
-          -- AD_TreeNodeMM
           SET IsActive=:NEW.IsActive
         WHERE AD_Tree_ID=v_xTree_ID
           AND Node_ID=:NEW.C_TAX_REPORT_ID;
--- a/src-db/database/sourcedata/AD_COLUMN.xml	Tue May 10 15:35:00 2011 +0200
+++ b/src-db/database/sourcedata/AD_COLUMN.xml	Tue May 10 16:35:05 2011 +0200
@@ -89700,374 +89700,6 @@
 <!--6125-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--6125--></AD_COLUMN>
 
-<!--6149--><AD_COLUMN>
-<!--6149-->  <AD_COLUMN_ID><![CDATA[6149]]></AD_COLUMN_ID>
-<!--6149-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--6149-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--6149-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--6149-->  <NAME><![CDATA[Organization]]></NAME>
-<!--6149-->  <DESCRIPTION><![CDATA[Organizational entity within client]]></DESCRIPTION>
-<!--6149-->  <HELP><![CDATA[An organization is a unit of your client or legal entity - examples are store, department. You can share data between organizations.]]></HELP>
-<!--6149-->  <COLUMNNAME><![CDATA[AD_Org_ID]]></COLUMNNAME>
-<!--6149-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--6149-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
-<!--6149-->  <FIELDLENGTH><![CDATA[22]]></FIELDLENGTH>
-<!--6149-->  <DEFAULTVALUE><![CDATA[@AD_Org_ID@]]></DEFAULTVALUE>
-<!--6149-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--6149-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--6149-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--6149-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--6149-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--6149-->  <SEQNO><![CDATA[0]]></SEQNO>
-<!--6149-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--6149-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--6149-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--6149-->  <AD_ELEMENT_ID><![CDATA[113]]></AD_ELEMENT_ID>
-<!--6149-->  <ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
-<!--6149-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--6149-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--6149-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--6149-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--6149-->  <POSITION><![CDATA[5]]></POSITION>
-<!--6149-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--6149-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--6149-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--6149--></AD_COLUMN>
-
-<!--6150--><AD_COLUMN>
-<!--6150-->  <AD_COLUMN_ID><![CDATA[6150]]></AD_COLUMN_ID>
-<!--6150-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--6150-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--6150-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--6150-->  <NAME><![CDATA[Active]]></NAME>
-<!--6150-->  <DESCRIPTION><![CDATA[A flag indicating whether this record is available for use or de-activated.]]></DESCRIPTION>
-<!--6150-->  <HELP><![CDATA[There are two methods of making records unavailable in the system: One is to delete the record, the other is to de-activate the record. A de-activated record is not available for selection, but available for reporting. There are two reasons for de-activating and not deleting records: 
-(1) The system requires the record for auditing purposes.
-(2) The record is referenced by other records. E.g., you cannot delete a Business Partner, if there are existing invoices for it. By de-activating the Business Partner you prevent it from being used in future transactions.]]></HELP>
-<!--6150-->  <COLUMNNAME><![CDATA[IsActive]]></COLUMNNAME>
-<!--6150-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--6150-->  <AD_REFERENCE_ID><![CDATA[20]]></AD_REFERENCE_ID>
-<!--6150-->  <FIELDLENGTH><![CDATA[1]]></FIELDLENGTH>
-<!--6150-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--6150-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--6150-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--6150-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--6150-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--6150-->  <SEQNO><![CDATA[0]]></SEQNO>
-<!--6150-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--6150-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--6150-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--6150-->  <AD_ELEMENT_ID><![CDATA[348]]></AD_ELEMENT_ID>
-<!--6150-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--6150-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--6150-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--6150-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--6150-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--6150-->  <POSITION><![CDATA[6]]></POSITION>
-<!--6150-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--6150-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--6150-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--6150--></AD_COLUMN>
-
-<!--6151--><AD_COLUMN>
-<!--6151-->  <AD_COLUMN_ID><![CDATA[6151]]></AD_COLUMN_ID>
-<!--6151-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--6151-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--6151-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--6151-->  <NAME><![CDATA[Creation Date]]></NAME>
-<!--6151-->  <DESCRIPTION><![CDATA[The date that this record is completed.]]></DESCRIPTION>
-<!--6151-->  <HELP><![CDATA[The Created field indicates the date that this record was created.]]></HELP>
-<!--6151-->  <COLUMNNAME><![CDATA[Created]]></COLUMNNAME>
-<!--6151-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--6151-->  <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID>
-<!--6151-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
-<!--6151-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--6151-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--6151-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--6151-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
-<!--6151-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--6151-->  <SEQNO><![CDATA[0]]></SEQNO>
-<!--6151-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--6151-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--6151-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--6151-->  <AD_ELEMENT_ID><![CDATA[245]]></AD_ELEMENT_ID>
-<!--6151-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--6151-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--6151-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--6151-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--6151-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--6151-->  <POSITION><![CDATA[7]]></POSITION>
-<!--6151-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--6151-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--6151-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--6151--></AD_COLUMN>
-
-<!--6152--><AD_COLUMN>
-<!--6152-->  <AD_COLUMN_ID><![CDATA[6152]]></AD_COLUMN_ID>
-<!--6152-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--6152-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--6152-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--6152-->  <NAME><![CDATA[Created By]]></NAME>
-<!--6152-->  <DESCRIPTION><![CDATA[User who created this records]]></DESCRIPTION>
-<!--6152-->  <HELP><![CDATA[The Created By field indicates the user who created this record.]]></HELP>
-<!--6152-->  <COLUMNNAME><![CDATA[CreatedBy]]></COLUMNNAME>
-<!--6152-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--6152-->  <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
-<!--6152-->  <FIELDLENGTH><![CDATA[22]]></FIELDLENGTH>
-<!--6152-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--6152-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--6152-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--6152-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
-<!--6152-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--6152-->  <SEQNO><![CDATA[0]]></SEQNO>
-<!--6152-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--6152-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--6152-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--6152-->  <AD_ELEMENT_ID><![CDATA[246]]></AD_ELEMENT_ID>
-<!--6152-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--6152-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--6152-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--6152-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--6152-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--6152-->  <POSITION><![CDATA[8]]></POSITION>
-<!--6152-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--6152-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--6152-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--6152--></AD_COLUMN>
-
-<!--6153--><AD_COLUMN>
-<!--6153-->  <AD_COLUMN_ID><![CDATA[6153]]></AD_COLUMN_ID>
-<!--6153-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--6153-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--6153-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--6153-->  <NAME><![CDATA[Updated]]></NAME>
-<!--6153-->  <DESCRIPTION><![CDATA[x not implemented]]></DESCRIPTION>
-<!--6153-->  <HELP><![CDATA[The Updated field indicates the date that this record was updated.]]></HELP>
-<!--6153-->  <COLUMNNAME><![CDATA[Updated]]></COLUMNNAME>
-<!--6153-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--6153-->  <AD_REFERENCE_ID><![CDATA[16]]></AD_REFERENCE_ID>
-<!--6153-->  <FIELDLENGTH><![CDATA[19]]></FIELDLENGTH>
-<!--6153-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--6153-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--6153-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--6153-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
-<!--6153-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--6153-->  <SEQNO><![CDATA[0]]></SEQNO>
-<!--6153-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--6153-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--6153-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--6153-->  <AD_ELEMENT_ID><![CDATA[607]]></AD_ELEMENT_ID>
-<!--6153-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--6153-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--6153-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--6153-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--6153-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--6153-->  <POSITION><![CDATA[9]]></POSITION>
-<!--6153-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--6153-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--6153-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--6153--></AD_COLUMN>
-
-<!--6154--><AD_COLUMN>
-<!--6154-->  <AD_COLUMN_ID><![CDATA[6154]]></AD_COLUMN_ID>
-<!--6154-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--6154-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--6154-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--6154-->  <NAME><![CDATA[Updated By]]></NAME>
-<!--6154-->  <DESCRIPTION><![CDATA[User who updated this records]]></DESCRIPTION>
-<!--6154-->  <HELP><![CDATA[The Updated By field indicates the user who updated this record.]]></HELP>
-<!--6154-->  <COLUMNNAME><![CDATA[UpdatedBy]]></COLUMNNAME>
-<!--6154-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--6154-->  <AD_REFERENCE_ID><![CDATA[30]]></AD_REFERENCE_ID>
-<!--6154-->  <FIELDLENGTH><![CDATA[22]]></FIELDLENGTH>
-<!--6154-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--6154-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--6154-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--6154-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
-<!--6154-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--6154-->  <SEQNO><![CDATA[0]]></SEQNO>
-<!--6154-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--6154-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--6154-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--6154-->  <AD_ELEMENT_ID><![CDATA[608]]></AD_ELEMENT_ID>
-<!--6154-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--6154-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--6154-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--6154-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--6154-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--6154-->  <POSITION><![CDATA[10]]></POSITION>
-<!--6154-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--6154-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--6154-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--6154--></AD_COLUMN>
-
-<!--6155--><AD_COLUMN>
-<!--6155-->  <AD_COLUMN_ID><![CDATA[6155]]></AD_COLUMN_ID>
-<!--6155-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--6155-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--6155-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--6155-->  <NAME><![CDATA[Report Set]]></NAME>
-<!--6155-->  <DESCRIPTION><![CDATA[A means of grouping reports in order to view and print summary and individual information.]]></DESCRIPTION>
-<!--6155-->  <HELP><![CDATA[The Parent indicates the value used to represent a summary level or report to level for a record]]></HELP>
-<!--6155-->  <COLUMNNAME><![CDATA[Parent_ID]]></COLUMNNAME>
-<!--6155-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--6155-->  <AD_REFERENCE_ID><![CDATA[13]]></AD_REFERENCE_ID>
-<!--6155-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
-<!--6155-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--6155-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--6155-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
-<!--6155-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--6155-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--6155-->  <SEQNO><![CDATA[0]]></SEQNO>
-<!--6155-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--6155-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--6155-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--6155-->  <AD_ELEMENT_ID><![CDATA[496]]></AD_ELEMENT_ID>
-<!--6155-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--6155-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--6155-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--6155-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--6155-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--6155-->  <POSITION><![CDATA[11]]></POSITION>
-<!--6155-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--6155-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--6155-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--6155--></AD_COLUMN>
-
-<!--6157--><AD_COLUMN>
-<!--6157-->  <AD_COLUMN_ID><![CDATA[6157]]></AD_COLUMN_ID>
-<!--6157-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--6157-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--6157-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--6157-->  <NAME><![CDATA[Sequence Number]]></NAME>
-<!--6157-->  <DESCRIPTION><![CDATA[The order of records in a specified document.]]></DESCRIPTION>
-<!--6157-->  <HELP><![CDATA[The Sequence indicates the order of records]]></HELP>
-<!--6157-->  <COLUMNNAME><![CDATA[SeqNo]]></COLUMNNAME>
-<!--6157-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--6157-->  <AD_REFERENCE_ID><![CDATA[11]]></AD_REFERENCE_ID>
-<!--6157-->  <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
-<!--6157-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--6157-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--6157-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
-<!--6157-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--6157-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--6157-->  <SEQNO><![CDATA[0]]></SEQNO>
-<!--6157-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--6157-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--6157-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--6157-->  <AD_ELEMENT_ID><![CDATA[566]]></AD_ELEMENT_ID>
-<!--6157-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--6157-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--6157-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--6157-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--6157-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--6157-->  <POSITION><![CDATA[12]]></POSITION>
-<!--6157-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--6157-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--6157-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--6157--></AD_COLUMN>
-
-<!--6160--><AD_COLUMN>
-<!--6160-->  <AD_COLUMN_ID><![CDATA[6160]]></AD_COLUMN_ID>
-<!--6160-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--6160-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--6160-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--6160-->  <NAME><![CDATA[Tree]]></NAME>
-<!--6160-->  <DESCRIPTION><![CDATA[Identifies a Tree]]></DESCRIPTION>
-<!--6160-->  <HELP><![CDATA[The Tree field identifies a unique Tree in the system. Trees define roll ups or summary levels of information.  They are used in reports for defining report points and summarization levels.]]></HELP>
-<!--6160-->  <COLUMNNAME><![CDATA[AD_Tree_ID]]></COLUMNNAME>
-<!--6160-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--6160-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
-<!--6160-->  <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
-<!--6160-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--6160-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--6160-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--6160-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
-<!--6160-->  <ISIDENTIFIER><![CDATA[Y]]></ISIDENTIFIER>
-<!--6160-->  <SEQNO><![CDATA[0]]></SEQNO>
-<!--6160-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--6160-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--6160-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--6160-->  <AD_ELEMENT_ID><![CDATA[132]]></AD_ELEMENT_ID>
-<!--6160-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--6160-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--6160-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--6160-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--6160-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--6160-->  <POSITION><![CDATA[2]]></POSITION>
-<!--6160-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--6160-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--6160-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--6160--></AD_COLUMN>
-
-<!--6161--><AD_COLUMN>
-<!--6161-->  <AD_COLUMN_ID><![CDATA[6161]]></AD_COLUMN_ID>
-<!--6161-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--6161-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--6161-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--6161-->  <NAME><![CDATA[Node_ID]]></NAME>
-<!--6161-->  <DESCRIPTION><![CDATA[Identifies a tree node]]></DESCRIPTION>
-<!--6161-->  <HELP><![CDATA[Identifies a tree node.]]></HELP>
-<!--6161-->  <COLUMNNAME><![CDATA[Node_ID]]></COLUMNNAME>
-<!--6161-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--6161-->  <AD_REFERENCE_ID><![CDATA[13]]></AD_REFERENCE_ID>
-<!--6161-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
-<!--6161-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--6161-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--6161-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--6161-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
-<!--6161-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--6161-->  <SEQNO><![CDATA[0]]></SEQNO>
-<!--6161-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--6161-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--6161-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--6161-->  <AD_ELEMENT_ID><![CDATA[472]]></AD_ELEMENT_ID>
-<!--6161-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--6161-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--6161-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--6161-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--6161-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--6161-->  <POSITION><![CDATA[3]]></POSITION>
-<!--6161-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--6161-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--6161-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--6161--></AD_COLUMN>
-
-<!--6162--><AD_COLUMN>
-<!--6162-->  <AD_COLUMN_ID><![CDATA[6162]]></AD_COLUMN_ID>
-<!--6162-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--6162-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--6162-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--6162-->  <NAME><![CDATA[Client]]></NAME>
-<!--6162-->  <DESCRIPTION><![CDATA[Client for this installation.]]></DESCRIPTION>
-<!--6162-->  <HELP><![CDATA[A Client is a company or a legal entity. You cannot share data between Clients.]]></HELP>
-<!--6162-->  <COLUMNNAME><![CDATA[AD_Client_ID]]></COLUMNNAME>
-<!--6162-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--6162-->  <AD_REFERENCE_ID><![CDATA[19]]></AD_REFERENCE_ID>
-<!--6162-->  <AD_VAL_RULE_ID><![CDATA[103]]></AD_VAL_RULE_ID>
-<!--6162-->  <FIELDLENGTH><![CDATA[22]]></FIELDLENGTH>
-<!--6162-->  <DEFAULTVALUE><![CDATA[@AD_CLIENT_ID@]]></DEFAULTVALUE>
-<!--6162-->  <ISKEY><![CDATA[N]]></ISKEY>
-<!--6162-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--6162-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--6162-->  <ISUPDATEABLE><![CDATA[N]]></ISUPDATEABLE>
-<!--6162-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--6162-->  <SEQNO><![CDATA[0]]></SEQNO>
-<!--6162-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--6162-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--6162-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--6162-->  <AD_ELEMENT_ID><![CDATA[102]]></AD_ELEMENT_ID>
-<!--6162-->  <ISSESSIONATTR><![CDATA[Y]]></ISSESSIONATTR>
-<!--6162-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--6162-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--6162-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--6162-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--6162-->  <POSITION><![CDATA[4]]></POSITION>
-<!--6162-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--6162-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--6162-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--6162--></AD_COLUMN>
-
 <!--6205--><AD_COLUMN>
 <!--6205-->  <AD_COLUMN_ID><![CDATA[6205]]></AD_COLUMN_ID>
 <!--6205-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
@@ -231687,36 +231319,6 @@
 <!--521F823119386C29E040007F01001B31-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
 <!--521F823119386C29E040007F01001B31--></AD_COLUMN>
 
-<!--521F823119396C29E040007F01001B31--><AD_COLUMN>
-<!--521F823119396C29E040007F01001B31-->  <AD_COLUMN_ID><![CDATA[521F823119396C29E040007F01001B31]]></AD_COLUMN_ID>
-<!--521F823119396C29E040007F01001B31-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--521F823119396C29E040007F01001B31-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--521F823119396C29E040007F01001B31-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--521F823119396C29E040007F01001B31-->  <NAME><![CDATA[AD_TreeNodeMM_ID]]></NAME>
-<!--521F823119396C29E040007F01001B31-->  <COLUMNNAME><![CDATA[AD_TreeNodeMM_ID]]></COLUMNNAME>
-<!--521F823119396C29E040007F01001B31-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--521F823119396C29E040007F01001B31-->  <AD_REFERENCE_ID><![CDATA[13]]></AD_REFERENCE_ID>
-<!--521F823119396C29E040007F01001B31-->  <FIELDLENGTH><![CDATA[32]]></FIELDLENGTH>
-<!--521F823119396C29E040007F01001B31-->  <ISKEY><![CDATA[Y]]></ISKEY>
-<!--521F823119396C29E040007F01001B31-->  <ISPARENT><![CDATA[N]]></ISPARENT>
-<!--521F823119396C29E040007F01001B31-->  <ISMANDATORY><![CDATA[Y]]></ISMANDATORY>
-<!--521F823119396C29E040007F01001B31-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
-<!--521F823119396C29E040007F01001B31-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
-<!--521F823119396C29E040007F01001B31-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
-<!--521F823119396C29E040007F01001B31-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
-<!--521F823119396C29E040007F01001B31-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
-<!--521F823119396C29E040007F01001B31-->  <AD_ELEMENT_ID><![CDATA[5221067DBEBC52DEE040007F01001FE1]]></AD_ELEMENT_ID>
-<!--521F823119396C29E040007F01001B31-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
-<!--521F823119396C29E040007F01001B31-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
-<!--521F823119396C29E040007F01001B31-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
-<!--521F823119396C29E040007F01001B31-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
-<!--521F823119396C29E040007F01001B31-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--521F823119396C29E040007F01001B31-->  <POSITION><![CDATA[1]]></POSITION>
-<!--521F823119396C29E040007F01001B31-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
-<!--521F823119396C29E040007F01001B31-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
-<!--521F823119396C29E040007F01001B31-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
-<!--521F823119396C29E040007F01001B31--></AD_COLUMN>
-
 <!--521F8231193A6C29E040007F01001B31--><AD_COLUMN>
 <!--521F8231193A6C29E040007F01001B31-->  <AD_COLUMN_ID><![CDATA[521F8231193A6C29E040007F01001B31]]></AD_COLUMN_ID>
 <!--521F8231193A6C29E040007F01001B31-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_DATASET_TABLE.xml	Tue May 10 15:35:00 2011 +0200
+++ b/src-db/database/sourcedata/AD_DATASET_TABLE.xml	Tue May 10 16:35:05 2011 +0200
@@ -2576,20 +2576,6 @@
 <!--A7354F58BAE111DDB046001B388C61A4-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
 <!--A7354F58BAE111DDB046001B388C61A4--></AD_DATASET_TABLE>
 
-<!--A7357636BAE111DDAE3B001B388C61A4--><AD_DATASET_TABLE>
-<!--A7357636BAE111DDAE3B001B388C61A4-->  <AD_DATASET_TABLE_ID><![CDATA[A7357636BAE111DDAE3B001B388C61A4]]></AD_DATASET_TABLE_ID>
-<!--A7357636BAE111DDAE3B001B388C61A4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--A7357636BAE111DDAE3B001B388C61A4-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--A7357636BAE111DDAE3B001B388C61A4-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--A7357636BAE111DDAE3B001B388C61A4-->  <AD_DATASET_ID><![CDATA[D81C5C810AEF47C690E4F688ABC8AAC8]]></AD_DATASET_ID>
-<!--A7357636BAE111DDAE3B001B388C61A4-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--A7357636BAE111DDAE3B001B388C61A4-->  <INCLUDEALLCOLUMNS><![CDATA[Y]]></INCLUDEALLCOLUMNS>
-<!--A7357636BAE111DDAE3B001B388C61A4-->  <WHERECLAUSE><![CDATA[client.id=:ClientID]]></WHERECLAUSE>
-<!--A7357636BAE111DDAE3B001B388C61A4-->  <EXCLUDEAUDITINFO><![CDATA[N]]></EXCLUDEAUDITINFO>
-<!--A7357636BAE111DDAE3B001B388C61A4-->  <ISBUSINESSOBJECT><![CDATA[N]]></ISBUSINESSOBJECT>
-<!--A7357636BAE111DDAE3B001B388C61A4-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
-<!--A7357636BAE111DDAE3B001B388C61A4--></AD_DATASET_TABLE>
-
 <!--A735896EBAE111DD9481001B388C61A4--><AD_DATASET_TABLE>
 <!--A735896EBAE111DD9481001B388C61A4-->  <AD_DATASET_TABLE_ID><![CDATA[A735896EBAE111DD9481001B388C61A4]]></AD_DATASET_TABLE_ID>
 <!--A735896EBAE111DD9481001B388C61A4-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
--- a/src-db/database/sourcedata/AD_TABLE.xml	Tue May 10 15:35:00 2011 +0200
+++ b/src-db/database/sourcedata/AD_TABLE.xml	Tue May 10 16:35:05 2011 +0200
@@ -3648,27 +3648,6 @@
 <!--437-->  <AD_PACKAGE_ID><![CDATA[5A3ED54AB1FA4B84E040007F01006125]]></AD_PACKAGE_ID>
 <!--437--></AD_TABLE>
 
-<!--452--><AD_TABLE>
-<!--452-->  <AD_TABLE_ID><![CDATA[452]]></AD_TABLE_ID>
-<!--452-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
-<!--452-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
-<!--452-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
-<!--452-->  <NAME><![CDATA[ADTreeNodeMM]]></NAME>
-<!--452-->  <DESCRIPTION><![CDATA[Menu tree]]></DESCRIPTION>
-<!--452-->  <HELP><![CDATA[This table defines the relations of nodes for menu tree.]]></HELP>
-<!--452-->  <TABLENAME><![CDATA[AD_TreeNodeMM]]></TABLENAME>
-<!--452-->  <CLASSNAME><![CDATA[TreeNodeMM]]></CLASSNAME>
-<!--452-->  <ISVIEW><![CDATA[N]]></ISVIEW>
-<!--452-->  <ACCESSLEVEL><![CDATA[7]]></ACCESSLEVEL>
-<!--452-->  <ISSECURITYENABLED><![CDATA[N]]></ISSECURITYENABLED>
-<!--452-->  <ISDELETEABLE><![CDATA[Y]]></ISDELETEABLE>
-<!--452-->  <ISHIGHVOLUME><![CDATA[N]]></ISHIGHVOLUME>
-<!--452-->  <ISCHANGELOG><![CDATA[N]]></ISCHANGELOG>
-<!--452-->  <ISDEFAULTACCT><![CDATA[N]]></ISDEFAULTACCT>
-<!--452-->  <DEVELOPMENTSTATUS><![CDATA[DP]]></DEVELOPMENTSTATUS>
-<!--452-->  <AD_PACKAGE_ID><![CDATA[5A3ED54AB1D04B84E040007F01006125]]></AD_PACKAGE_ID>
-<!--452--></AD_TABLE>
-
 <!--456--><AD_TABLE>
 <!--456-->  <AD_TABLE_ID><![CDATA[456]]></AD_TABLE_ID>
 <!--456-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>