X-Git-Url: http://git.freeside.biz/gitweb/?a=blobdiff_plain;f=htdocs%2Fdocs%2Fschema.html;h=f505251833ddf3f68d995d0b72cf1d9dbacc493b;hb=9fb39f590f06d9913ec9f433403c67b30c955bd5;hp=5a296ec83963ef4519299645e9241ca23dd53ac2;hpb=c0af1d666cd655dcece6f263890123851631c0fd;p=freeside.git
diff --git a/htdocs/docs/schema.html b/htdocs/docs/schema.html
index 5a296ec83..f50525183 100644
--- a/htdocs/docs/schema.html
+++ b/htdocs/docs/schema.html
@@ -50,7 +50,9 @@
custnum - primary key
agentnum - agent
refnum - referral
+ titlenum - title
first - name
+ middle - name
last - name
ss - social security number
company
@@ -70,11 +72,18 @@
tax - tax exempt, Y or null
otaker - order taker
+ cust_main_invoice - Invoice destinations for email invoices
+
+ - destnum - primary key
+
- custnum - customer
+
- dest - Invoice destination: If numeric, a svcnum, if string, a literal email address, or `POST' to enable mailing (the default if no cust_main_invoice records exist)
+
cust_main_county - Tax rates
- taxnum - primary key
- state
- county
+
- country
- tax - % rate
cust_pay - Payments
@@ -155,6 +164,11 @@
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