From 51984ac3d3da3006809c6866fdecd4ad83610731 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 30 Jul 2001 07:36:04 +0000 Subject: templates!!! --- httemplate/docs/schema.html | 277 ++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 277 insertions(+) create mode 100644 httemplate/docs/schema.html (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html new file mode 100644 index 000000000..f68b9d257 --- /dev/null +++ b/httemplate/docs/schema.html @@ -0,0 +1,277 @@ + + 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. Declarations that a customer owes you money. The specific charges are itemized in cust_bill_pkg. +
- invnum - primary key +
- custnum - customer +
- _date +
- charged - amount of this invoice +
- printed - how many times this invoice has been printed automatically +
+
cust_bill_pkg - Invoice line items +
- invnum - (multiple) key +
- pkgnum - package or 0 for the special virtual sales tax package +
- setup - setup fee +
- recur - recurring fee +
- sdate - starting date +
- edate - ending date +
+
cust_credit - Credits. The equivalent of a negative cust_bill record. +
- crednum - primary key +
- custnum - customer +
- amount - amount credited +
- _date +
- otaker - order taker +
- reason +
+
cust_main - Customers +
- custnum - primary key +
- agentnum - agent +
- refnum - referral +
- titlenum - title +
- first - name +
- last - name +
- ss - social security number +
- company +
- address1 +
- address2 +
- city +
- county +
- state +
- zip +
- country +
- daytime - phone +
- night - phone +
- fax - phone +
- ship_first +
- ship_last +
- ship_company +
- ship_address1 +
- ship_address2 +
- ship_city +
- ship_county +
- ship_state +
- ship_zip +
- ship_country +
- ship_daytime +
- ship_night +
- ship_fax +
- 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 +
+ (columns in italics are optional) +
cust_main_invoice - Invoice destinations for email invoices. Note that a customer can have many email destinations for their invoice (either literal or via svcnum), but only one postal destination. +
- destnum - primary key +
- custnum - customer +
- dest - Invoice destination. Freeside supports three types of invoice delivery: send directly to a service defined in Freeside, send to an arbitrary email address, or print the invoice to a printer and have someone send it out via snail mail. Freeside determines which method to use based on the contents of the dest field. If the contents are numeric, a svcnum pointing to a valid service is expected in the field. If the contents are a string, a literal email address is expected to be in the field. If the special keyword `POST' is present, the snail mail method is used (which is the default if no cust_main_invoice records exist). Snail mail invoices get their address information from cust_main and are printed with the printer defined in the configuration files. +
+
cust_main_county - Tax rates +
- taxnum - primary key +
- state +
- county +
- country +
- tax - % rate +
+
cust_pay - Payments. Money being transferred from a customer. +
- 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. The transfer of money to a customer; equivalent to a negative cust_pay record. +
- 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 +
+
nas - Network Access Server (terminal server) +
- nasnum - primary key +
- nas - NAS name +
- nasip - NAS ip address +
- nasfqdn - NAS fully-qualified domain name +
- last - timestamp indicating the last instant the NAS was in a known state (used by the session monitoring). +
+
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 - primary key +
- referral - 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 +
+
part_title - Personal titles +
- titlenum - primary key +
- title - personal title (`Dr.' or `Mr.') +
+
pkg_svc +
- pkgpart - Package definition +
- svcpart - Service definition +
- quantity - quantity of this service that this package includes +
+
port - individual port on a nas +
- portnum - primary key +
- ip - IP address of this port +
- nasport - port number on the NAS +
- nasnum - NAS +
+
prepay_credit +
- prepaynum - primary key +
- identifier - text or numeric string used to receive this credit +
- amount - amount of credit +
+
session +
- sessionnum - primary key +
- portnum - Port +
- svcnum - Account +
- login - timestamp indicating the beginning of this user session. +
- logout - timestamp indicating the end of this user session. May be null, which indicates a currently open session. +
+ +
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 +
- loc - rest of number +
+
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 +
+
domain_record - Domain zone detail +
- recnum - primary key +
- svcnum - Domain (by svcnum) +
- reczone - zone for this line +
- recaf - address family, usually IN +
- rectype - type for this record (A, MX, etc.) +
- recdata - data for this record +
+
svc_www +
- svcnum - primary key +
- recnum - host +
- usersvc - account +
+
type_pkgs +
- typenum - agent type +
- pkgpart - Package definition +
+

+ -- cgit v1.2.1 From e6cf4af2b9d3ffefebe1a3e358f0674f566b56bc Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 13 Aug 2001 01:00:27 +0000 Subject: add svc_forward, depriciate svc_acct_sm --- httemplate/docs/schema.html | 11 +++++++++-- 1 file changed, 9 insertions(+), 2 deletions(-) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index f68b9d257..61bc17b03 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -180,7 +180,7 @@

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 +
svcdb - table used for this service: svc_acct, svc_acct_sm, svc_forward, svc_domain, svc_charge or svc_wo
table__field - Default or fixed value for field in table
table__field_flag - null, D or F

@@ -241,7 +241,7 @@

exch - exchange

loc - rest of number -

svc_acct_sm - Domain mail aliases +

svc_acct_sm - DEPRICIATED Domain mail aliases

svcnum - primary key
domsvc - Domain (by svcnum) @@ -253,6 +253,13 @@
svcnum - primary key
domain

primary key +

srcsvc - svcnum of the source of this forward +

dstsvc - svcnum of the destination of this forward +

dst - foreign destination (email address) - forward not local to freeside +

domain_record - Domain zone detail

recnum - primary key -- cgit v1.2.1 From 0fd508f695b4f19a447eba7663f59dc7fb4033d3 Mon Sep 17 00:00:00 2001 From: ivan
Date: Mon, 20 Aug 2001 09:38:28 +0000 Subject: documentation updates --- httemplate/docs/schema.html | 68 +++++++++++++++++++++------------------------ 1 file changed, 31 insertions(+), 37 deletions(-) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index 61bc17b03..0da33a5c2 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -4,7 +4,7 @@
Schema reference
- agent - Agents are resellers of your service. Agents may be limited to a subset of your full offerings (via their agent type). +
- 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 @@ -12,12 +12,12 @@
  - prog - (unimplemented)
  - freq - (unimplemented)
  -
- agent_type - Agent types define groups of packages that you can then assign to particular agents. +
- 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. Declarations that a customer owes you money. The specific charges are itemized in cust_bill_pkg. +
- cust_bill - Invoices. Declarations that a customer owes you money. The specific charges are itemized in cust_bill_pkg.
  - invnum - primary key
  - custnum - customer @@ -25,7 +25,7 @@
  - charged - amount of this invoice
  - printed - how many times this invoice has been printed automatically
  -
- cust_bill_pkg - Invoice line items +
- cust_bill_pkg - Invoice line items
  - invnum - (multiple) key
  - pkgnum - package or 0 for the special virtual sales tax package @@ -34,7 +34,7 @@
  - sdate - starting date
  - edate - ending date
  -
- cust_credit - Credits. The equivalent of a negative cust_bill record. +
- cust_credit - Credits. The equivalent of a negative cust_bill record.
  - crednum - primary key
  - custnum - customer @@ -43,12 +43,11 @@
  - otaker - order taker
  - reason
  -
- cust_main - Customers +
- cust_main - Customers
  - custnum - primary key
  - agentnum - agent
  - refnum - referral -
  - titlenum - title
  - first - name
  - last - name
  - ss - social security number @@ -84,13 +83,13 @@
  - otaker - order taker
  (columns in italics are optional) -
- cust_main_invoice - Invoice destinations for email invoices. Note that a customer can have many email destinations for their invoice (either literal or via svcnum), but only one postal destination. +
- cust_main_invoice - Invoice destinations for email invoices. Note that a customer can have many email destinations for their invoice (either literal or via svcnum), but only one postal destination.
  - destnum - primary key
  - custnum - customer
  - dest - Invoice destination. Freeside supports three types of invoice delivery: send directly to a service defined in Freeside, send to an arbitrary email address, or print the invoice to a printer and have someone send it out via snail mail. Freeside determines which method to use based on the contents of the dest field. If the contents are numeric, a svcnum pointing to a valid service is expected in the field. If the contents are a string, a literal email address is expected to be in the field. If the special keyword `POST' is present, the snail mail method is used (which is the default if no cust_main_invoice records exist). Snail mail invoices get their address information from cust_main and are printed with the printer defined in the configuration files.
  -
- cust_main_county - Tax rates +
- cust_main_county - Tax rates
  - taxnum - primary key
  - state @@ -98,7 +97,7 @@
  - country
  - tax - % rate
  -
- cust_pay - Payments. Money being transferred from a customer. +
- cust_pay - Payments. Money being transferred from a customer.
  - paynum - primary key
  - invnum - invoice @@ -108,7 +107,7 @@
  - payinfo - card number, P.O.#, or comp issuer
  - paybatch - text field for tracking card processor batches
  -
- cust_pay_batch - Pending batch +
- cust_pay_batch - Pending batch
  - trancode - 77 for charges
  - cardnum @@ -126,7 +125,7 @@
  - zip
  - country
  -
- cust_pkg - Customer billing items +
- cust_pkg - Customer billing items
  - pkgnum - primary key
  - custnum - customer @@ -138,7 +137,7 @@
  - cancel - (past) cancellation date
  - otaker - order taker
  -
- cust_refund - Refunds. The transfer of money to a customer; equivalent to a negative cust_pay record. +
- cust_refund - Refunds. The transfer of money to a customer; equivalent to a negative cust_pay record.
  - refundnum - primary key
  - crednum - credit @@ -148,13 +147,13 @@
  - payinfo - card number, P.O.#, or comp issuer
  - otaker - order taker
  -
- cust_svc - Customer services +
- cust_svc - Customer services
  - svcnum - primary key
  - pkgnum - package
  - svcpart - Service definition
  -
- nas - Network Access Server (terminal server) +
- nas - Network Access Server (terminal server)
  - nasnum - primary key
  - nas - NAS name @@ -162,7 +161,7 @@
  - nasfqdn - NAS fully-qualified domain name
  - last - timestamp indicating the last instant the NAS was in a known state (used by the session monitoring).
  -
- part_pkg - Package definitions +
- part_pkg - Package definitions
  - pkgpart - primary key
  - pkg - package name @@ -171,12 +170,12 @@
  - freq - recurring frequency (months)
  - recur - recurring fee
  -
- part_referral - Referral listing +
- part_referral - Referral listing
  - refnum - primary key
  - referral - referral
  -
- part_svc - Service definitions +
- part_svc - Service definitions
  - svcpart - primary key
  - svc - name of this service @@ -184,31 +183,26 @@
  - table__field - Default or fixed value for field in table
  - table__field_flag - null, D or F
  -
- part_title - Personal titles -
  - titlenum - primary key -
  - title - personal title (`Dr.' or `Mr.') -
  -
- pkg_svc +
- pkg_svc
  - pkgpart - Package definition
  - svcpart - Service definition
  - quantity - quantity of this service that this package includes
  -
- port - individual port on a nas +
- port - individual port on a nas
  - portnum - primary key
  - ip - IP address of this port
  - nasport - port number on the NAS
  - nasnum - NAS
  -
- prepay_credit +
- prepay_credit
  - prepaynum - primary key
  - identifier - text or numeric string used to receive this credit
  - amount - amount of credit
  -
- session +
- session
  - sessionnum - primary key
  - portnum - Port @@ -217,7 +211,7 @@
  - logout - timestamp indicating the end of this user session. May be null, which indicates a currently open session.
  -
- svc_acct - Accounts +
- svc_acct - Accounts
  - svcnum - primary key
  - username @@ -232,7 +226,7 @@
  - slipip - IP address
  - radius_Radius_Attribute - Radius-Attribute
  -
- svc_acct_pop - Points of Presence +
- svc_acct_pop - Points of Presence
  - popnum - primary key
  - city @@ -241,26 +235,26 @@
  - exch - exchange
  - loc - rest of number
  -
- svc_acct_sm - DEPRICIATED Domain mail aliases +
- svc_acct_sm - DEPRECIATED Domain mail aliases
  - svcnum - primary key
  - domsvc - Domain (by svcnum)
  - domuid - Account (by uid)
  - domuser - domuser @ Domain forwards to Account
  -
- svc_domain - Domains +
- svc_domain - Domains
  - svcnum - primary key
  - domain
  -
- svc_forward - Mail forwarding aliases
  - svcnum - primary key -
  - srcsvc - svcnum of the source of this forward -
  - dstsvc - svcnum of the destination of this forward +
  - srcsvc - svcnum of the source of this forward +
  - dstsvc - svcnum of the destination of this forward
  - dst - foreign destination (email address) - forward not local to freeside
  -
- domain_record - Domain zone detail +
- domain_record - Domain zone detail
  - recnum - primary key
  - svcnum - Domain (by svcnum) @@ -269,13 +263,13 @@
  - rectype - type for this record (A, MX, etc.)
  - recdata - data for this record
  -
- svc_www +
- svc_www
  - svcnum - primary key
  - recnum - host
  - usersvc - account
  -
- type_pkgs +
- type_pkgs
  - typenum - agent type
  - pkgpart - Package definition -- cgit v1.2.1 From cdd5aa1d86cd5b266e02bed58570c97c2d7698ba Mon Sep 17 00:00:00 2001 From: ivan Date: Sat, 1 Sep 2001 20:11:07 +0000 Subject: cust_bill_pay and cust_credit_refund. payments can apply to multiple invoices and refunds can apply to multiple credits. --- httemplate/docs/schema.html | 18 ++++++++++++++++-- 1 file changed, 16 insertions(+), 2 deletions(-) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index 0da33a5c2..818547e1c 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -100,13 +100,20 @@
  - cust_pay - Payments. Money being transferred from a customer.
    - 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_bill_pay - Applicaton of a payment to a specific invoice. +
    - billpaynum +
    - invnum - invoice +
    - paynum - payment +
    - amount +
    - _date +
  - cust_pay_batch - Pending batch
    - trancode - 77 for charges @@ -140,13 +147,20 @@
    - cust_refund - Refunds. The transfer of money to a customer; equivalent to a negative cust_pay record.
      
      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_credit_refund - Applicaton of a refund to a specific credit. +
      +
      creditrefundnum - primary key +
      crednum - credit +
      refundnum - refund +
      amount +
      _date +
    - cust_svc - Customer services
      
      svcnum - primary key -- cgit v1.2.1 From 8c1f9804d9a02c0c054eededeb500c72a640249a Mon Sep 17 00:00:00 2001 From: ivan Date: Sun, 2 Sep 2001 02:46:55 +0000 Subject: cust_refund and cust_pay get custnums --- httemplate/docs/schema.html | 2 ++ 1 file changed, 2 insertions(+) (limited to 'httemplate/docs/schema.html') 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 @@
      cust_pay - Payments. Money being transferred from a customer.
      
      paynum - primary key +
      custnum - customer
      paid - amount
      _date
      payby - CARD, BILL, or COMP @@ -147,6 +148,7 @@
      cust_refund - Refunds. The transfer of money to a customer; equivalent to a negative cust_pay record.
      
      refundnum - primary key +
      custnum - customer
      refund - amount
      _date
      payby - CARD, BILL or COMP -- cgit v1.2.1 From 57d69d5c1f98f778a0df82795ce21ee7bd21042a Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 6 Sep 2001 20:42:00 +0000 Subject: finally fix part_svc!!! --- httemplate/docs/schema.html | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index c90f47641..59d68b718 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -196,8 +196,17 @@
      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 -
      table__field - Default or fixed value for field in table + +
      +
      part_svc_column +
      +
      columnnum - primary key +
      svcpart - Service definition +
      columnname - column name in part_svc.svcdb table +
      columnvalue - default or fixed value for the column +
      columnflag - null, D or F
      
      pkg_svc
      -- cgit v1.2.1 From e9c47f5904df328e0ac6e8ab993927d9aab3867c Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 6 Sep 2001 21:20:58 +0000 Subject: doc --- httemplate/docs/schema.html | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index 59d68b718..32c365ec3 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -249,7 +249,10 @@
      shell
      quota - (unimplementd)
      slipip - IP address -
      radius_Radius_Attribute - Radius-Attribute +
      seconds +
      domsvc +
      radius_Radius_Reply_Attribute - Radius-Reply-Attribute +
      rc_Radius_Check_Attribute - Radius-Check-Attribute
      
      svc_acct_pop - Points of Presence
      -- cgit v1.2.1 From f5266a4d07d116efd732f433d0f4f3a47b143a7d Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 11 Sep 2001 00:08:18 +0000 Subject: faster (cached) fuzzy searches prelim. job queues! fixed part_svc editing --- httemplate/docs/schema.html | 23 +++++++++++++++++++++++ 1 file changed, 23 insertions(+) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index 32c365ec3..e3fe98096 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -43,6 +43,14 @@
      otaker - order taker
      reason
      +
      cust_credit_bill - Credit invoice application. Links a credit to an invoice. +
      +
      creditbillnum - primary key +
      crednum - credit being applied +
      invnum - invoice to which credit is applied +
      amount - amount applied +
      _date +
      
      cust_main - Customers
      
      custnum - primary key @@ -81,6 +89,8 @@
      payname - billing name (name on card)
      tax - tax exempt, Y or null
      otaker - order taker +
      referral_custnum +
      comments
      (columns in italics are optional)
      cust_main_invoice - Invoice destinations for email invoices. Note that a customer can have many email destinations for their invoice (either literal or via svcnum), but only one postal destination. @@ -302,5 +312,18 @@
      typenum - agent type
      pkgpart - Package definition
      +
      queue - job queue +
      +
      jobnum - primary key +
      job +
      _date +
      status +
      +
      queue_arg - job arguments +
      +
      argnum - primary key +
      jobnum - job +
      arg - argument +
      
      -- cgit v1.2.1 From 8ca6f203e5dae208d7af581d68671fe47c5e1a1a Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 26 Sep 2001 09:17:06 +0000 Subject: add part_pop_local table --- httemplate/docs/schema.html | 9 +++++++++ 1 file changed, 9 insertions(+) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index e3fe98096..c3cb51425 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -273,6 +273,15 @@
    - exch - exchange
    - loc - rest of number
    +
  - part_pop_local - Local calling areas +
    - localnum - primary key +
    - popnum - primary key +
    - city +
    - state +
    - npa - area code +
    - nxx - exchange +
  - svc_acct_sm - DEPRECIATED Domain mail aliases
    - svcnum - primary key -- cgit v1.2.1 From 4bbf90e800406ff75a5fed09ba5cd71293cda542 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 9 Oct 2001 23:10:17 +0000 Subject: add `unsuspendauto' config file: enable the automatic unsuspension of suspended packages when a customer's balance due changes from positive to zero or negative as the result of a payment or credit add cust_pkg.manual_flag to disable this behaviour per customer package (no UI to set this yet) --- httemplate/docs/schema.html | 1 + 1 file changed, 1 insertion(+) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index c3cb51425..d831c59f4 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -154,6 +154,7 @@
    - expire - (future) cancellation date
    - cancel - (past) cancellation date
    - otaker - order taker +
    - manual_flag - If this field is set to 1, disables the automatic unsuspensiond of this package when using the unsuspendauto config file.
  - cust_refund - Refunds. The transfer of money to a customer; equivalent to a negative cust_pay record.
  - part_referral - Referral listing
    -- cgit v1.2.1 From 20c1183d2673b62bd0e29eb65f0a9a2c974b8027 Mon Sep 17 00:00:00 2001 From: ivan Date: Tue, 30 Oct 2001 19:05:27 +0000 Subject: depriciate cust_pay_batch.trancode web interface to view pending batch --- httemplate/docs/schema.html | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index 145d55fc2..a5bf16c37 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -127,7 +127,7 @@
- cust_pay_batch - Pending batch
  - trancode - 77 for charges +
  - paybatchnum
  - cardnum
  - exp - card expiration
  - amount -- cgit v1.2.1 From fee9bc7edcdd27e7a4e47bc313d05c66cd900073 Mon Sep 17 00:00:00 2001 From: ivan Date: Wed, 26 Dec 2001 23:59:33 +0000 Subject: doc --- httemplate/docs/schema.html | 2 ++ 1 file changed, 2 insertions(+) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index a5bf16c37..9f00d48b1 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -200,6 +200,7 @@
  - recurtax - Recurring fee tax exempt flag, empty or `Y'
  - plan - price plan
  - plandata - additional price plan data +
  - disabled - Disabled flag, empty or `Y'
- part_referral - Referral listing
  - 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 +
  - disabled - Disabled flag, empty or `Y' -- cgit v1.2.1 From 69a0a7504f84aa9bb1f204d1f3522e1520e0885e Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 3 Jan 2002 17:40:26 +0000 Subject: more schema changes: part_bill_event and cust_bill_event tables remove old 1.4.0pre READMEs --- httemplate/docs/schema.html | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index 9f00d48b1..a51bf6e68 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -25,6 +25,22 @@
  - charged - amount of this invoice
  - printed - how many times this invoice has been printed automatically
  +
- cust_bill_event - Invoice event history +
  - eventnum - primary key +
  - invnum - invoice +
  - eventpart - event definition +
  - _date +
  +
- part_bill_event - Invoice event definitions +
  - eventpart - primary key +
  - payby - CARD, 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 +
  - disabled - Disabled flag, empty or `Y' +
- cust_bill_pkg - Invoice line items
  - invnum - (multiple) key -- cgit v1.2.1 From b03df92e48df653460cb8b6034a06dd1de6f4095 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 28 Jan 2002 05:15:29 +0000 Subject: part_export schema changes --- httemplate/docs/schema.html | 15 +++++++++++++++ 1 file changed, 15 insertions(+) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index a51bf6e68..3e9189b30 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -247,6 +247,21 @@
  - svcpart - Service definition
  - quantity - quantity of this service that this package includes
  +
- part_export - Export to external provisioning +
  - exportnum - primary key +
  - svcpart - Service definition +
  - machine - Machine name +
  - exporttype - Export type +
  - nodomain - blank or Y: usernames are exported to this service with no domain +
  +
- part_export_option - provisioning options +
  - optionnum - primary key +
  - exportnum - Export +
  - option - option name +
  - optionvalue - option value +
- port - individual port on a nas
  - portnum - primary key -- cgit v1.2.1 From 1aa750eba2b9b73b4f09f28b9acd748ee3669bd4 Mon Sep 17 00:00:00 2001 From: ivan Date: Mon, 28 Jan 2002 06:57:23 +0000 Subject: book closing schema changes --- httemplate/docs/schema.html | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index 3e9189b30..21da3ecf6 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -24,6 +24,7 @@
  - _date
  - charged - amount of this invoice
  - printed - how many times this invoice has been printed automatically +
  - closed - books closed flag, empty or `Y'
- cust_bill_event - Invoice event history
  - _date
  - otaker - order taker
  - reason +
  - closed - books closed flag, empty or `Y'
- cust_credit_bill - Credit invoice application. Links a credit to an invoice.
  - payby - CARD, 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'
- cust_bill_pay - Applicaton of a payment to a specific invoice.
  - payby - CARD, BILL or COMP
  - payinfo - card number, P.O.#, or comp issuer
  - otaker - order taker +
  - closed - books closed flag, empty or `Y'
- cust_credit_refund - Applicaton of a refund to a specific credit.
- cust_bill_pkg - Invoice line items -- cgit v1.2.1 From 47bc56487b4aebf3e415767a053dc049fe4a28d4 Mon Sep 17 00:00:00 2001 From: ivan
  Date: Tue, 19 Feb 2002 23:43:54 +0000 Subject: set EVERYTHING=1 for your own mod_perl compile --- httemplate/docs/schema.html | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index bdf3a500e..8420161bf 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -266,7 +266,7 @@
  - optionnum - primary key
  - exportnum - Export -
  - option - option name +
  - optionname - option name
  - optionvalue - option value
- port - individual port on a nas @@ -372,6 +372,8 @@
- job
- _date
- status +
- statustext +
- svcnum
queue_arg - job arguments
part_bill_event - Invoice event definitions
+
radius_usergroup - Link users to RADIUS groups. +
- usergroupnum - primary key +
- svcnum - account +
- groupname +

-- cgit v1.2.1 From 87af741da0dd5f6a76bbb566b4d6c54cd5b15315 Mon Sep 17 00:00:00 2001 From: ivan Date: Fri, 5 Apr 2002 23:51:18 +0000 Subject: - add message catalog table & beginning of web interface - add security_phrase and conf option to svc_acct.pm - random other stuff --- httemplate/docs/schema.html | 8 ++++++++ 1 file changed, 8 insertions(+) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index 192f56ba9..a7c21c7c9 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -298,6 +298,7 @@

svcnum - primary key

username

_password +

sec_phrase - security phrase

popnum - Point of Presence

uid

gid @@ -389,5 +390,12 @@

svcnum - account

groupname +

msgcat - i18n message catalog +

msgnum - primary key +
msgcode - message code +
locale - locale +
msg - Message text +

-- cgit v1.2.1 From a7c1b602f88c177db34477ed4cdc1f72603f8995 Mon Sep 17 00:00:00 2001 From: ivan Date: Thu, 11 Apr 2002 22:05:31 +0000 Subject: (almost) everything for bug#375 - create export_svc table - part_svc to part_export is now properly many-to-many, not one-to-many still need to finish service editing (choosing exports) in httemplate/edit/part_svc.cgi and httemplate/edti/process/part_svc.cgi and do somethinga about that manual $svcdb = 'svc_acct' in httemplate/edit/part_export.cgi (do part_export records need a svcdb? probably not... should be able to just pass an svcdb on creation of new exports, move the big %exports hash into part_export.pm and allow httemplate/edit/part_svc.cgi to query it for exports that can apply to a given svcdb.... --- httemplate/docs/schema.html | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index a7c21c7c9..6ed96d229 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -256,10 +256,15 @@

svcpart - Service definition

quantity - quantity of this service that this package includes +

export_svc +

exportsvcnum - primary key +
svcpart - Service definition +
exportnum - Export +

part_export - Export to external provisioning

exportnum - primary key -
svcpart - Service definition
machine - Machine name
exporttype - Export type
nodomain - blank or Y: usernames are exported to this service with no domain -- cgit v1.2.1 From 9bf26ed4b065b12826fc2980ff277a2f3be25c1d Mon Sep 17 00:00:00 2001 From: ivan
Date: Sun, 14 Apr 2002 09:11:22 +0000 Subject: - move cyrus, shellcommands, CP exports exports to new-style - skeleton files for vpopmail exports - documentation updates - add big schema diagram to docs --- httemplate/docs/schema.html | 1 + 1 file changed, 1 insertion(+) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index 6ed96d229..07fcb908e 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).
- cust_bill_pkg - Invoice line items
  - county
  - country
  - tax - % rate +
  - taxclass +
  - exempt_amount +
  +
- cust_tax_exempt - Tax exemption record +
  - exemptnum - primary key +
  - taxnum - tax rate +
  - year +
  - month +
  - amount
- cust_pay - Payments. Money being transferred from a customer.
  +
- queue_depend - job dependancies +
  - dependnum - primary key +
  - jobnum - source jobnum +
  - depend_jobnum - dependancy jobnum +
- radius_usergroup - Link users to RADIUS groups.
  - usergroupnum - primary key -- cgit v1.2.1 From 0e8861ca6b3b04b99ea9477e8c1555561b21c929 Mon Sep 17 00:00:00 2001 From: khoff Date: Sat, 8 Jun 2002 07:48:37 +0000 Subject: Default svcpart support for part_pkg. Fixes 'bug' with new customer and online signup. --- httemplate/docs/schema.html | 1 + 1 file changed, 1 insertion(+) (limited to 'httemplate/docs/schema.html') diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index 2b8b3a132..e2a0f475a 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -238,6 +238,7 @@
  - plan - price plan
  - plandata - additional price plan data
  - disabled - Disabled flag, empty or `Y' +
  - def_svcpart - Default svcpart to use when ordering this part_pkg
- part_referral - Referral listing
- part_referral - Referral listing