From e1eb06c05b654a4533bab0e034e87a8de99015cc Mon Sep 17 00:00:00 2001 From: cvs2git Date: Mon, 12 Oct 1998 07:03:12 +0000 Subject: This commit was manufactured by cvs2svn to create tag 'freeside_current'. --- htdocs/docs/schema.html | 205 ------------------------------------------------ 1 file changed, 205 deletions(-) delete mode 100644 htdocs/docs/schema.html (limited to 'htdocs/docs/schema.html') diff --git a/htdocs/docs/schema.html b/htdocs/docs/schema.html deleted file mode 100644 index 5a296ec83..000000000 --- a/htdocs/docs/schema.html +++ /dev/null @@ -1,205 +0,0 @@ - - Schema reference - - -

Schema reference

agent - Agents are resellers of your service. Agents may be limited to a subset of your full offerings (via their agent type). -
- agentnum - primary key -
- agent - name of this agent -
- typenum - agent type -
- prog - (unimplemented) -
- freq - (unimplemented) -
-
agent_type - Agent types define groups of packages that you can then assign to particular agents. -
- typenum - primary key -
- atype - name of this agent type -
-
cust_bill - Invoices -
- invnum - primary key -
- custnum - customer -
- _date -
- charged - amount of this invoice -
- owed - amount still outstanding on this invoice -
- printed - how many times this invoice has been printed automatically -
-
cust_bill_pkg - Invoice line items -
- invnum - (multiple) key -
- pkgnum - package -
- setup - setup fee -
- recur - recurring fee -
- sdate - starting date -
- edate - ending date -
-
cust_credit - Credits -
- crednum - primary key -
- custnum - customer -
- amount - amount credited -
- credited - amount still outstanding (not yet refunded) on this credit -
- _date -
- otaker - order taker -
- reason -
-
cust_main - Customers -
- custnum - primary key -
- agentnum - agent -
- refnum - referral -
- first - name -
- last - name -
- ss - social security number -
- company -
- address1 -
- address2 -
- city -
- county -
- state -
- zip -
- country -
- daytime - phone -
- night - phone -
- payby - CARD, BILL, or COMP -
- payinfo - card number, P.O.#, or comp issuer -
- paydate - expiration date -
- payname - billing name (name on card) -
- tax - tax exempt, Y or null -
- otaker - order taker -
-
cust_main_county - Tax rates -
- taxnum - primary key -
- state -
- county -
- tax - % rate -
-
cust_pay - Payments -
- paynum - primary key -
- invnum - invoice -
- paid - amount -
- _date -
- payby - CARD, BILL, or COMP -
- payinfo - card number, P.O.#, or comp issuer -
- paybatch - text field for tracking card processor batches -
-
cust_pay_batch - Pending batch -
- trancode - 77 for charges -
- cardnum -
- exp - card expiration -
- amount -
- invnum - invoice -
- custnum - customer -
- payname - name on card -
- first - name -
- last - name -
- address1 -
- address2 -
- city -
- state -
- zip -
- country -
-
cust_pkg - Customer billing items -
- pkgnum - primary key -
- custnum - customer -
- pkgpart - Package definition -
- setup - date -
- bill - next bill date -
- susp - (past) suspension date -
- expire - (future) cancellation date -
- cancel - (past) cancellation date -
- otaker - order taker -
-
cust_refund - Refunds -
- refundnum - primary key -
- crednum - credit -
- refund - amount -
- _date -
- payby - CARD, BILL or COMP -
- payinfo - card number, P.O.#, or comp issuer -
- otaker - order taker -
-
cust_svc - Customer services -
- svcnum - primary key -
- pkgnum - package -
- svcpart - Service definition -
-
part_pkg - Package definitions -
- pkgpart - primary key -
- pkg - package name -
- comment - non-customer visable package comment -
- setup - setup fee -
- freq - recurring frequency (months) -
- recur - recurring fee -
-
part_referral - Referral listing -
- refnum
- referral
-
part_svc - Service definitions -
- svcpart - primary key -
- svc - name of this service -
- svcdb - table used for this service: svc_acct, svc_acct_sm, svc_domain, svc_charge or svc_wo -
- table__field - Default or fixed value for field in table -
- table__field_flag - null, D or F -
-
pkg_svc -
- pkgpart - Package definition -
- svcpart - Service definition -
- quantity - quantity of this service that this package includes -
-
svc_acct - Accounts -
- svcnum - primary key -
- username -
- _password -
- popnum - Point of Presence -
- uid -
- gid -
- finger - GECOS -
- dir -
- shell -
- quota - (unimplementd) -
- slipip - IP address -
- radius_Radius_Attribute - Radius-Attribute -
-
svc_acct_pop - Points of Presence -
- popnum - primary key -
- city -
- state -
- ac - area code -
- exch - exchange -
-
svc_acct_sm - Domain mail aliases -
- svcnum - primary key -
- domsvc - Domain (by svcnum) -
- domuid - Account (by uid) -
- domuser - domuser @ Domain forwards to Account -
-
svc_domain - Domains -
- svcnum - primary key -
- domain -
-
type_pkgs -
- typenum - agent type -
- pkgpart - Package definition -
-

- -- cgit v1.2.1