X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fdocs%2Fschema.html;h=6522b041a4f6311d8e206d27ca01a59d1f6b3905;hp=2b8b3a1324e9063630007e7a57a8ec26f4842026;hb=c232fac0743999105f6948b9fa352fe2293b09f8;hpb=eb7c552dd8290d6b33a4e026c5dc21ebf01105cf
diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html
index 2b8b3a132..6522b041a 100644
--- a/httemplate/docs/schema.html
+++ b/httemplate/docs/schema.html
@@ -39,7 +39,7 @@
part_bill_event - Invoice event definitions
- eventpart - primary key
-
- payby - CARD, BILL, or COMP
+
- payby - CARD, CHEK, LECB, BILL, or COMP
- event - event name
- eventcode - event action
- seconds - how long after the invoice date (cust_bill._date) events of this type are triggered
@@ -57,6 +57,14 @@
- recur - recurring fee
- sdate - starting date
- edate - ending date
+
- itemdesc - Line item description (currently used only when pkgnum is 0)
+
+ cust_bill_pkg_detail - Invoice line items detail
+
+ - detailnum - primary key
+
- pkgnum -
+
- invnum -
+
- detail - Detail description
cust_credit - Credits. The equivalent of a negative cust_bill record.
@@ -108,7 +116,7 @@
- ship_daytime
- ship_night
- ship_fax
-
- payby - CARD, BILL, or COMP
+
- payby - CARD, CHEK, LECB, BILL, or COMP
- payinfo - card number, P.O.#, or comp issuer
- paydate - expiration date
- payname - billing name (name on card)
@@ -133,6 +141,7 @@
- tax - % rate
- taxclass
- exempt_amount
+
- taxname - if defined, printed on invoices instead of "Tax"
cust_tax_exempt - Tax exemption record
@@ -148,7 +157,7 @@
- custnum - customer
- paid - amount
- _date
-
- payby - CARD, BILL, or COMP
+
- payby - CARD, CHEK, LECB, BILL, or COMP
- payinfo - card number, P.O.#, or comp issuer
- paybatch - text field for tracking card processor batches
- closed - books closed flag, empty or `Y'
@@ -198,7 +207,7 @@
- custnum - customer
- refund - amount
- _date
-
- payby - CARD, BILL or COMP
+
- payby - CARD, CHEK, LECB, BILL or COMP
- payinfo - card number, P.O.#, or comp issuer
- otaker - order taker
- closed - books closed flag, empty or `Y'
@@ -248,7 +257,7 @@
- svcpart - primary key
- svc - name of this service
-
- svcdb - table used for this service: svc_acct, svc_acct_sm, svc_forward, svc_domain, svc_charge or svc_wo
+
- svcdb - table used for this service: svc_acct, svc_forward, svc_domain, svc_charge or svc_wo
- disabled - Disabled flag, empty or `Y'