cust_refund and cust_pay get custnums

2 files changed, 4 insertions, 0 deletions

diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html
index 818547e1c..c90f47641 100644
--- a/httemplate/docs/schema.html
+++ b/httemplate/docs/schema.html
@@ -100,6 +100,7 @@
     <li><a name="cust_pay" href="man/FS/cust_pay.html">cust_pay</a> - Payments.  Money being transferred from a customer.
       <ul>
         <li>paynum - primary key
+        <li>custnum - <a href="#cust_main">customer</a>
         <li>paid - amount
         <li>_date
         <li>payby - CARD, BILL, or COMP
@@ -147,6 +148,7 @@
     <li><a name="cust_refund" href="man/FS/cust_refund.html">cust_refund</a> - Refunds.  The transfer of money to a customer; equivalent to a negative <a href="#cust_pay">cust_pay</a> record.
       <ul>
         <li>refundnum - primary key
+        <li>custnum - <a href="#cust_main">customer</a>
         <li>refund - amount
         <li>_date
         <li>payby - CARD, BILL or COMP
diff --git a/httemplate/docs/upgrade8.html b/httemplate/docs/upgrade8.html
index 1e4064e8d..573db3683 100644
--- a/httemplate/docs/upgrade8.html
+++ b/httemplate/docs/upgrade8.html
@@ -109,6 +109,8 @@ ALTER TABLE part_svc ADD svc_forward__dstsvc_flag char(1) NULL;
 ALTER TABLE part_svc ADD svc_forward__dst integer NULL;
 ALTER TABLE part_svc ADD svc_forward__dst_flag char(1) NULL;
 ALTER TABLE cust_main ADD referral_custnum integer NULL;
+ALTER TABLE cust_pay ADD custnum integer;
+ALTER TABLE cust_refund ADD custnum integer;
 CREATE INDEX cust_main3 ON cust_main ( referral_custnum );
 CREATE INDEX cust_credit_bill1 ON cust_credit_bill ( crednum );
 CREATE INDEX cust_credit_bill2 ON cust_credit_bill ( invnum );