877.245.5629
sales@billmax.com
|
BillMax Billing Solutions 877.245.5629 sales@billmax.com |
| globalconf table | ||
|---|---|---|
 |
Chapter 3. Database Schema | 
|
globalconf table — table for Globalconf data
| Name | Description |
Data Type | BillMax Default | |||
|---|---|---|---|---|---|---|
| Name | Description |
Data Type | BillMax Default | |||
| accountholes |
By default, BillMax will automatically assign Account numbers when a new Account is created. Use |
varchar(100) | BLANK | |||
| accountlowest |
By default, the number for a new Account will be he greatest Account number that ever existed in BillMax plus one. Use |
int(11) | 0 | |||
| bmversion | The version of BillMax. |
varchar(10) | The version of BillMax. | |||
| ccsoft |
Specify which software will be used for Electronic Funds Processing. The values are maintained in the ccsofts list.
|
tinyint(4) | 0 | |||
| custom_nav_url | The URL the browser display below the Navigation Bar. |
varchar(100) | /blank.html | |||
| dateformat | The format of the display of dates in BillMax. |
varchar(100) | YYYY-MM-DD | |||
| dbsig | The database signature. |
mediumtext | BillMax derived | |||
| decimalpt | The decimal point for representation and input. Specified when specifying a locale. |
varchar(4) | BillMax derived | |||
| encryptcc | The Permissions needed to view a credit card number. Only one permission value need match the Permissions of a Authorized BillMax User |
tinyint(4) | 1 | |||
| fracdigits | The number of local fractional digits for money for the locale. |
tinyint(4) | BillMax derived | |||
| intfracdigits | The number of international fractional digits for money for the locale. |
tinyint(4) | BillMax derived | |||
| intsym | The international symbol for money for the locale. |
varchar(10) | BillMax derived | |||
| licensekey | The BillMax license. |
mediumtext | No default. User input required. | |||
| locale |
The locale for the BillMax installation. The value for the locale must be supported by the underlying operating system. This affects the interpretation and display of monetary values. Please contact |
varchar(100) | BLANK | |||
| locsym | The local symbol for money for the locale. |
varchar(10) | BillMax derived | |||
| logographic | Specify the graphic to display above the Navigation Bar. |
varchar(100) | /images/flags3.gif | |||
| mondecimalpt | The monetary decimal point representation an input. Specified when specifying a locale. |
varchar(4) | BillMax derived | |||
| number | System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647. |
int(11) | 1 | |||
| path_bshell | The system path to the Bourne shell. Essential for BillMax operations. |
mediumtext | No default. User input required. | |||
| path_lpr | The system path to the print command. Essential for BillMax printing. |
mediumtext | No default. User input required. | |||
| path_sendmail | The system path to the sendmail command. Essential for BillMax emailing. |
mediumtext | No default. User input required. | |||
| serviceholes | varchar(100) | BLANK | ||||
| servicelowest | int(11) | 0 | ||||
| showsym | Specify whether to use the local (e.g. "$") or international (e.g. "USD") symbology when displaying monetary values. |
tinyint(4) | 0 | |||
| sitename | A text string to display below the graphic displayed above the Navigation Bar |
varchar(100) | BLANK | |||
| userholes | varchar(100) | BLANK | ||||
| userlowest | int(11) | 0 |
Relevant Interfaces
Library Routines
| BillMax_GlobalconfGet |
Command Line Routines - NONE
CGI Routines - NONE
Web Forms - Global Configuration Forms
|
|
 |
|
| datatopop table |  |
listdef table |
![[Important]](images/important.png)