diff options
| author | ivan <ivan> | 2003-02-06 05:26:50 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2003-02-06 05:26:50 +0000 |
| commit | c232fac0743999105f6948b9fa352fe2293b09f8 (patch) | |
| tree | cfeb31670fdedeeefd286d58fa6bef2e0d9e1095 /httemplate/docs | |
| parent | 6e2dcb26245ef419438f60e99c91873a8d762625 (diff) | |
time/data detail on invoices
Diffstat (limited to 'httemplate/docs')
| -rw-r--r-- | httemplate/docs/schema.html | 7 | ||||
| -rw-r--r-- | httemplate/docs/upgrade10.html | 11 |
2 files changed, 18 insertions, 0 deletions
diff --git a/httemplate/docs/schema.html b/httemplate/docs/schema.html index b4d21f3b9..6522b041a 100644 --- a/httemplate/docs/schema.html +++ b/httemplate/docs/schema.html @@ -59,6 +59,13 @@ <li>edate - ending date <li>itemdesc - Line item description (currently used only when pkgnum is 0) </ul> + <li><a name="cust_bill_pkg_detail" href="man/FS/cust_bill_pkg_detail.html">cust_bill_pkg_detail</a> - Invoice line items detail + <ul> + <li>detailnum - primary key + <li>pkgnum - + <li>invnum - + <li>detail - Detail description + </ul> <li><a name="cust_credit" href="man/FS/cust_credit.html">cust_credit</a> - Credits. The equivalent of a negative <a href="#cust_bill">cust_bill</a> record. <ul> <li>crednum - primary key diff --git a/httemplate/docs/upgrade10.html b/httemplate/docs/upgrade10.html new file mode 100644 index 000000000..7aa26f698 --- /dev/null +++ b/httemplate/docs/upgrade10.html @@ -0,0 +1,11 @@ +this is very incomplete + +CREATE TABLE cust_bill_pkg_detail ( + detailnum serial, + pkgnum int NOT NULL, + invnum int NOT NULL, + detail varchar(80), + PRIMARY KEY (detailnum) +); +CREATE INDEX cust_bill_pkg_detail1 ON cust_bill_pkg_detail ( pkgnum, invnum ); + |