billmax documentation   BillMax Billing Solutions
  877.245.5629
  sales@billmax.com
 
tabledefaults table
Prev  Chapter 3. Database Schema  Next

Name

tabledefaults table — table for Table Defaults data

tabeldefaults Field Definitions

Name

Description

Data Type BillMax Default
Name

Description

Data Type BillMax Default
defaultval

The default value for a field. If non-NULL, this value is used when creating a new record. As an example, if htmlfile is "special", then the default value for the field SERVICE_price could be set to the special price. Note that the default may be used even if the field is not submitted by a bmuitemplate.

char(50) BLANK
errmsg

An override to the standard error message generated by BillMax. As an example, when a credit card is invalid, then a customized message may be displayed.

char(100) BLANK
field

The name of the database field and/or bmuitemplate form field. Not all values specified here need to be a database field.

char(50) BLANK
htmlfile

A filter used to choose a record from tabledefaults table. Supplying the value for htmlfile is described in the section called “New Customer Self Registration”. "*" matches any value for htmlfile. If the desire is to use more than one htmlfile, all htmlfile will need to be specified for the fields in question and the "*" entries for the fields in question will need to be removed. The default value for htmlfile is "default". Note that this means that is any htmlfile desired other that "default" will require the removal of the "*" entry for that field.

char(50) *
newovw

Specify whether a field may be supplied by bmui.cgi to bmuid upon creation of a Account/User/Service triplet for a new customer. Using SERVICE_price as an example, in general SERVICE_price should not be allowed to be supplied as a customer could specify their own price for a service.

  • 0 - Field may not supplied.

  • 1 - Field may be supplied.

tinyint(4) 0
newreq

Specify whether a field must be supplied by bmuid to bmuid upon creation of a Account/User/Service triplet for a new customer. An example is requiring that SERVICE_d01 (the field in which BillMax stores login names) be supplied.

  • 0 - Field is not required.

  • 1 - Field is required.

tinyint(4) 0
number

System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647.

int(11) 0
sortorder

User specified sort order of entries. Used for display purposes.

float(10,2) 0.00
updreq

When updating the records of an existing customer, is a value for the field required.

  • 0 - Value for the field is not required.

  • 1 - Value for the field is required.

tinyint(4) 0
updrw

Specifies the customer's accessibility to the value specified by tabledefaults.field.

  • 0 - No access.

  • 1 - Read-only access.

  • 2 - Write-only access. Credit card number would be an example.

  • 3 - Read/Write access.

tinyint(4) 0

SEE ALSO

Relevant Interfaces

  1. Library Routines - NONE

  2. Command Line Routines - NONE

  3. CGI Routines - NONE

  4. Web Forms - the section called “Understanding the tabledefaults table”

Prev  Up  Next
stats table  Home  termservers table
Document Revision A for BillMax 2.2.0   -   Copyright © 1997-2006 The iSpark Group, Inc.

All rights reserved. No part of this documentation may be reproduced or transmitted in any fashion without written permission by The iSpark Group, Inc. This documentation is for the sole use of licensees of the BillMax billing software created by The iSpark Group, Inc. Making the documentation available to a non-licensee of BillMax without written permission of The iSpark Group, Inc. is a violation of the use of this documentation.

While precautions have been taken in the preparation of this documentation, The iSpark Group, Inc. assumes neither liability nor responsibility for errors or omissions, or for damages resulting from the use of the information contained herein.

All terms mentioned that are known to be trademarks have been appropriately capitalized. Use of the a trademark does not affect the validity of any trademark or service mark.

Links to third-party Web sites are provided for convenience. The iSpark Group, Inc. is not responsible for any content contained in the third-party Web sites.

Comments about this documentation may be sent to doc@billmax.com