stats table


	BillMax Billing Solutions 877.245.5629 sales@billmax.com

stats table
	Chapter 3. Database Schema

Name

stats table — table for Stats data

stats Field Definitions

Name	Description	Data Type	BillMax Default
Name	Description	Data Type	BillMax Default
entdate	The date the sample was entered in to the database.	date	Current Date
enttime	The time the sample was entered in to the database.	time	Current Time
isused	0 - sample has yet to be used in a Usage Based Computation Result. 1 - sample has already been used in a Usage Based Computation Result.	tinyint(4)	0
number	System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647.	int(11)	Autogenerated. Generally next available integer.
sgroup	The group to which this sample belongs. The most common value is a Service number.	char(20)	Blank
stype	The type of sample captured.	char(30)	Blank
value	The actual value(s) for the recorded sample(s). This may contain more than one sample. If it contains more than one, the value must be Named Samples.	char(100)	Blank

SEE ALSO

Relevant Interfaces

Library Routines

BillMax_StatsGetNext

BillMax_StatsGetWhere

BillMax_StatsSample
Command Line Routines

enter_stat
CGI Routines - NONE
Web Forms - NONE


servicechange table		tabledefaults 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