[freeside-devel] Schema updates

[Jason Spence]

On Sun, Feb 11, 2001 at 12:05:15AM -0800, Jason Spence developed
a new theory of relativity and: 

> --- freeside/htdocs/docs/CVS/Entries	Sat Feb 10 22:44:51 2001
> +++ my-freeside/htdocs/docs/CVS/Entries	Wed Feb  7 15:04:36 2001
> @@ -9,6 +9,7 @@
>  /overview.png/1.1/Mon Dec 11 21:57:46 2000//
>  /passwd.html/1.1.3.1/Mon Aug 24 03:28:01 1998//
>  /postgresql.html/1.1/Tue Apr  6 08:55:12 1999//
> +/schema.html/1.10/Tue Nov  7 15:00:37 2000//
>  /trouble.html/1.5/Thu Aug  5 07:19:54 1999//
>  /upgrade.html/1.1.3.1/Thu Aug 13 04:15:02 1998//
>  /upgrade2.html/1.2/Wed Oct 14 06:52:43 1998//

Er, oops, forgot to exclude the CVS files.  Fixed patch attached.  

Does anyone know how to make diff exclude the CVS metafiles?

 - Jason
-------------- next part --------------
diff -urN -x Entries freeside/htdocs/docs/schema.html my-freeside/htdocs/docs/schema.html
--- freeside/htdocs/docs/schema.html	Sat Feb 10 22:44:50 2001
+++ my-freeside/htdocs/docs/schema.html	Sat Feb 10 22:53:54 2001
@@ -17,7 +17,9 @@
         <li>typenum - primary key
         <li>atype - name of this agent type
       </ul>
-    <li><a name="cust_bill">cust_bill</a> - Invoices
+    <li><a name="cust_bill">cust_bill</a> - Invoices; declarations that
+customers owe you money.  The specific charges are itemized in
+cust_bill_pkg.
       <ul>
         <li>invnum - primary key
         <li>custnum - <a href="#cust_main">customer</a>
@@ -29,13 +31,15 @@
     <li><a name="cust_bill_pkg">cust_bill_pkg</a> - Invoice line items
       <ul>
         <li>invnum - (multiple) key
-        <li>pkgnum - <a href="#cust_pkg">package</a>
+        <li>pkgnum - A <a href="#cust_pkg">package</a>.  
+            Set to 0 for the special sales tax package.
         <li>setup - setup fee 
         <li>recur - recurring fee
         <li>sdate - starting date
         <li>edate - ending date
       </ul>
-    <li><a name="cust_credit">cust_credit</a> - Credits
+    <li><a name="cust_credit">cust_credit</a> - Credits.  The equivalent
+of a negative cust_bill record.
       <ul>
         <li>crednum - primary key
         <li>custnum - <a href="#cust_main">customer</a>
@@ -87,7 +91,8 @@
         <li>country
         <li>tax - % rate
       </ul>
-    <li><a name="cust_pay">cust_pay</a> - Payments
+    <li><a name="cust_pay">cust_pay</a> - Payments.  Money being
+transferred from the customer to you.
       <ul>
         <li>paynum - primary key
         <li>invnum - <a href="#cust_bill">invoice</a>
@@ -127,7 +132,8 @@
         <li>cancel - (past) cancellation date
         <li>otaker - order taker
       </ul>
-    <li><a name="cust_refund">cust_refund</a> - Refunds
+    <li><a name="cust_refund">cust_refund</a> - Refunds, the transfer of
+funds from you to the customer.  Equivalent to a negative cust_pay record.
       <ul>
         <li>refundnum - primary key
         <li>crednum - <a href="#cust_credit">credit</a>