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

Name

tier table — table for Tier data

tier Field Definitions

Name

Description

Data Type BillMax Default
Name

Description

Data Type BillMax Default
margintotal

The sum of all the tiers up to and including this tier.

int(11) BillMax derived
number

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

int(11) System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647.
price

The price associated with this Tier

int(11) No default. User input required.
tierplan

The Tierplan to which this Tier belongs.

int(11) Tierplan Plan ID for this tier.
top

The top value for this Tier The price from this Tier will not be used if the Usage Based Computation Result exceeds this value. The price from this Tier will be used if the Usage Based Computation Result is less than this top value and not less the top value of any other Tier belonging to the same Tierplan

double(20,8) No default. User input required.

SEE ALSO

Relevant Interfaces

  1. Library Routines

    BillMax_TierGet
    BillMax_TierGetNext
    BillMax_TierGetWhere
    BillMax_TierPut

  2. Command Line Routines - NONE

  3. CGI Routines

    enter_tierplan.cgi

  4. Web Forms - Usage Based Tierplan Forms

Prev  Up  Next
termservers table  Home  tierplan 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