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

Name

listdef table — table for List Definition data

listdef Field Definitions

Name

Description

Data Type BillMax Default
Name

Description

Data Type BillMax Default
buttontitle

List button title for display on the "Administer Lists" web page.

char(50) BLANK
constraints

The Constraints used enforce data integrity for lists.value when entering a new item in a List. regexmacros list values are not allowed.

char(100) BLANK
descr

List description.

char(100) BLANK
list

List name.

char(50) BLANK
modify

The Permissions set of a Authorized BillMax User must intersect this set of Permissions to be able to modify the List entries.

int(11) 1
number

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

int(11) Autogenerated. Generally next available integer.
protected

Specifies whether entries in a particular list may be deleted.

  • 0 - list items may be deleted.

  • 1 - list items may not be deleted.

tinyint(4) 1
sortorder

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

float(10,2) 0.00
uniquebal

Specifies whether the entries for lists.value for a particular List must be unique.

  • 0 - non-unique entries allowed.

  • 1 - entries must be unique.

float(10,2) 1
view

The Permissions set of a Authorized BillMax User must intersect this set of Permissions to be able to view the List entries.

int(11) 0

SEE ALSO

Relevant Interfaces

  1. Library Routines - NONE

  2. Command Line Routines

    mklists

  3. CGI Routines - NONE

  4. Web Forms - the section called “Configuring Lists”

Prev  Up  Next
globalconf table  Home  lists 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