src/org/openbravo/erpCommon/ad_process/CopyFromGLJournal_data.xsql
changeset 799 fef2c5e2feb7
parent 423 ecf368072c48
child 1538 adedf6da8824
--- a/src/org/openbravo/erpCommon/ad_process/CopyFromGLJournal_data.xsql	Wed Apr 30 10:48:47 2008 +0000
+++ b/src/org/openbravo/erpCommon/ad_process/CopyFromGLJournal_data.xsql	Mon May 05 06:59:24 2008 +0000
@@ -29,7 +29,7 @@
       <![CDATA[
       SELECT GL.GL_JOURNAL_ID, GL.C_ACCTSCHEMA_ID, GL.C_DOCTYPE_ID, GL.DOCSTATUS, GL.DOCACTION, GL.ISAPPROVED, GL.ISPRINTED, 
         GL.DESCRIPTION,
-        GL.POSTINGTYPE, GL.GL_BUDGET_ID, GL.GL_CATEGORY_ID, 
+        GL.POSTINGTYPE, GL.GL_CATEGORY_ID, 
         (SELECT GL2.C_PERIOD_ID FROM GL_JOURNALBATCH GL2 WHERE GL2.GL_JOURNALBATCH_ID = TO_NUMBER(?)) AS C_PERIOD_ID, 
         GL.C_CURRENCY_ID, GL.CURRENCYRATETYPE, GL.CURRENCYRATE,
         GL.CONTROLAMT, '' AS LINE, '' AS ISGENERATED, '' AS AMTSOURCEDR, '' AS AMTSOURCECR, '' AS AMTACCTDR, '' AS AMTACCTCR,
@@ -90,7 +90,7 @@
       <![CDATA[
         INSERT INTO GL_JOURNAL (GL_JOURNAL_ID, AD_CLIENT_ID, AD_ORG_ID, CREATED, CREATEDBY, 
         UPDATED, UPDATEDBY, C_ACCTSCHEMA_ID,C_DOCTYPE_ID, DOCSTATUS,DOCACTION, ISAPPROVED, ISPRINTED, 
-        DESCRIPTION, POSTINGTYPE, GL_BUDGET_ID,GL_CATEGORY_ID, DATEDOC, DATEACCT,C_PERIOD_ID, C_CURRENCY_ID, 
+        DESCRIPTION, POSTINGTYPE, GL_CATEGORY_ID, DATEDOC, DATEACCT,C_PERIOD_ID, C_CURRENCY_ID, 
         CURRENCYRATETYPE,CURRENCYRATE, GL_JOURNALBATCH_ID, CONTROLAMT, DOCUMENTNO, PROCESSING, PROCESSED, POSTED) 
         VALUES (TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),now(),TO_NUMBER(?),now(),TO_NUMBER(?),TO_NUMBER(?),TO_NUMBER(?),?,?,?,?,?,?,TO_NUMBER(?),TO_NUMBER(?),?,?,TO_NUMBER(?),TO_NUMBER(?),?,?,TO_NUMBER(?),?,?,?,?,?)
       ]]>
@@ -108,7 +108,6 @@
     <Parameter name="isprinted"/>
     <Parameter name="description"/>
     <Parameter name="postingtype"/>
-    <Parameter name="gl_budget_id"/>
     <Parameter name="gl_category_id"/>
     <Parameter name="datedoc"/>
     <Parameter name="dateacct"/>