SF.net SVN: ledger-smb:[3821] trunk/sql/Pg-database.sql

[..hidden..]

Revision: 3821
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3821&view=rev
Author:   einhverfr
Date:     2011-10-08 19:39:56 +0000 (Sat, 08 Oct 2011)
Log Message:
-----------
adding eca_invoice.order_number for tracking orders of the other party.

Modified Paths:
--------------
    trunk/sql/Pg-database.sql

Modified: trunk/sql/Pg-database.sql
===================================================================
--- trunk/sql/Pg-database.sql	2011-10-08 18:50:12 UTC (rev 3820)
+++ trunk/sql/Pg-database.sql	2011-10-08 19:39:56 UTC (rev 3821)
@@ -1065,6 +1065,7 @@
     due date not null,
     language_code char(6) references language(code), 
     force_closed bool not null default false, 
+    order_number text,
     PRIMARY KEY  (journal_id)
 );
 
@@ -1088,8 +1089,11 @@
 and cannot be paid.  Overpayments where this is set to true do not appear on 
 outstanding reports and cannot be paid.$$;
 
+COMMENT ON COLUMN eca_invoice.order_number IS
+$$ This is the order number of the other party.  So for a sales invoice, this 
+would be a purchase order, and for a vendor invoice, this would be a sales 
+order.$$;
 
-
 --
 CREATE TABLE gifi (
   accno text PRIMARY KEY,

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