877.245.5629
sales@billmax.com
|
BillMax Billing Solutions 877.245.5629 sales@billmax.com |
| monthlysale table | ||
|---|---|---|
 |
Chapter 3. Database Schema | 
|
monthlysale table — table for Monthlysale data
| Name | Description |
Data Type |
|---|---|---|
| Name | Description |
Data Type |
| bookdate | The effective date of the financial transaction. |
date |
| enddate | The enddate of the monthly portion of the sale. |
date |
| fullmonth | Whether or not the record represents a full month. |
tinyint(4) |
| ntaxable | The non-taxable part of the monthly portion of the sale. |
int(11) |
| number | System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647. |
int(11) |
| payhist | The value of payhist.number to which this record is associated. |
int(11) |
| startdate | The start date of the monthly portion of the sale. |
date |
| taxable | The taxable part of the monthly portion of the sale. |
int(11) |
| taxdate | The date to use when computing tax exemption amounts. |
date |
Relevant Interfaces
Library Routines
| BillMax_MonthlySaleGet |
| BillMax_MonthlySaleGetWhere |
| BillMax_MonthlySaleGetNext |
| BillMax_MonthlySalePut |
| BillMax_MonthlySaleDeleteByPayhist |
Command Line Routines - NONE
CGI Routines - NONE
Web Forms - NONE
|
|
 |
|
| lists table |  |
note table |