[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

SF.net SVN: ledger-smb:[5342] trunk/sql/modules/Report.sql



Revision: 5342
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=5342&view=rev
Author:   einhverfr
Date:     2012-12-12 10:22:22 +0000 (Wed, 12 Dec 2012)
Log Message:
-----------
Fixing load errors

Modified Paths:
--------------
    trunk/sql/modules/Report.sql

Modified: trunk/sql/modules/Report.sql
===================================================================
--- trunk/sql/modules/Report.sql	2012-12-12 07:26:33 UTC (rev 5341)
+++ trunk/sql/modules/Report.sql	2012-12-12 10:22:22 UTC (rev 5342)
@@ -342,7 +342,7 @@
 
 $$ LANGUAGE SQL; 
 
-DROP TYPE IF EXISTS aa_report_line CASCADE;
+DROP TYPE IF EXISTS aa_transactions_line CASCADE;
 
 CREATE TYPE aa_transactions_line AS (
     id int,
@@ -361,17 +361,17 @@
     manager text,
     shpping_point text,
     ship_via text,
-    business_units text[];
+    business_units text[]
 );
 
 CREATE OR REPLACE FUNCTION aa_transactions
 (in_entity_class int, in_account_id int, in_name text, in_meta_number text,
- in_employee_id int, in_manager_id int, in_invnumber text, in_ordnumber text
+ in_employee_id int, in_manager_id int, in_invnumber text, in_ordnumber text,
  in_ponumber text, in_source text, in_description text, in_notes text, 
- in_shipvia text, in_date_from text, in_date_to text, in_on_hold bool))
+ in_shipvia text, in_date_from text, in_date_to text, in_on_hold bool)
 RETURNS SETOF aa_transactions_line LANGUAGE PLPGSQL AS $$
 
-DECLARE retval aa_transaction_line;
+DECLARE retval aa_transactions_line;
 
 BEGIN
 
@@ -379,7 +379,7 @@
 
 SELECT a.id, a.transdate, a.invnumber, a.amount, a.netamount, 
        a.amount - a.netamount as tax, a.amount - p.due, p.last_payment, 
-       a.duedate, a.notes
+       a.duedate, a.notes,
        a.till, eee.name as employee, mee.name as manager, a.shipping_point, 
        a.shipvia, '{}'
        

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.