X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=blobdiff_plain;f=httemplate%2Fdocs%2Fschema.html;h=6522b041a4f6311d8e206d27ca01a59d1f6b3905;hp=192f56ba9c82517a2ee01710a5a4fea6e32ac381;hb=c232fac0743999105f6948b9fa352fe2293b09f8;hpb=20bb426a02c0ea54d8feaea7c5da51735ab70293 diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index 192f56ba9..6522b041a 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -3,6 +3,7 @@

Schema reference

+ Schema diagram: as a giant .png or dia source (dia homepage).

agent - Agents are resellers of your service. Agents may be limited to a subset of your full offerings (via their agent type).
- 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 @@ -46,6 +47,7 @@
  - plan - eventcode plan
  - plandata - additional plan data
  - disabled - Disabled flag, empty or `Y' +
  - taxclass - Texas tax class flag, empty or "none", "access", or "hosting"
- cust_bill_pkg - Invoice line items
  - 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.
  - 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) @@ -129,6 +139,17 @@
  - county
  - country
  - tax - % rate +
  - taxclass +
  - exempt_amount +
  - taxname - if defined, printed on invoices instead of "Tax" +
  +
- cust_tax_exempt - Tax exemption record +
  - exemptnum - primary key +
  - taxnum - tax rate +
  - year +
  - month +
  - amount
- cust_pay - Payments. Money being transferred from a customer.
  - 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' @@ -186,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' @@ -236,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'