projects
/
freeside.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
i18n! i18n!
[freeside.git]
/
htdocs
/
docs
/
schema.html
diff --git
a/htdocs/docs/schema.html
b/htdocs/docs/schema.html
index
5a296ec
..
f7a9bc1
100644
(file)
--- a/
htdocs/docs/schema.html
+++ b/
htdocs/docs/schema.html
@@
-50,7
+50,9
@@
<li>custnum - primary key
<li>agentnum - <a href="#agent">agent</a>
<li>refnum - <a href="#part_referral">referral</a>
<li>custnum - primary key
<li>agentnum - <a href="#agent">agent</a>
<li>refnum - <a href="#part_referral">referral</a>
+ <li>titlenum - <a href="#part_title">title</a>
<li>first - name
<li>first - name
+ <li>middle - name
<li>last - name
<li>ss - social security number
<li>company
<li>last - name
<li>ss - social security number
<li>company
@@
-75,6
+77,7
@@
<li>taxnum - primary key
<li>state
<li>county
<li>taxnum - primary key
<li>state
<li>county
+ <li>country
<li>tax - % rate
</ul>
<li><a name="cust_pay">cust_pay</a> - Payments
<li>tax - % rate
</ul>
<li><a name="cust_pay">cust_pay</a> - Payments
@@
-155,6
+158,11
@@
<li><i>table</i>__<i>field</i> - Default or fixed value for <i>field</i> in <i>table</i>
<li><i>table</i>__<i>field</i>_flag - null, D or F
</ul>
<li><i>table</i>__<i>field</i> - Default or fixed value for <i>field</i> in <i>table</i>
<li><i>table</i>__<i>field</i>_flag - null, D or F
</ul>
+ <li><a name="part_title">part_title</a> - Personal titles
+ <ul>
+ <li>titlenum - primary key
+ <li>title - personal title (`Dr.' or `Mr.')
+ </ul>
<li><a name="pkg_svc">pkg_svc</a>
<ul>
<li>pkgpart - <a href="#part_pkg">Package definition</a>
<li><a name="pkg_svc">pkg_svc</a>
<ul>
<li>pkgpart - <a href="#part_pkg">Package definition</a>