timetrack table


	BillMax Billing Solutions 877.245.5629 sales@billmax.com

timetrack table
	Chapter 3. Database Schema

Name

timetrack table — table for Timetrack data

timetrack Field Definitions

Name	Description	Data Type	BillMax Default
Name	Description	Data Type	BillMax Default
billable	Defines whether the timetrack entry is billable and should be billed to a Account 0 - Not billable. 1 - billable.	tinyint(4)	0
billaccount	The entity to which the timetrack entry is associated. May be an Account, User or Service.	int(11)	BLANK
comment	A description of the timetrack entry.	char(200)	BLANK
empl	The employee for whom the timetrack entry is entered. List is from the auth table	mediumint(8)	User currently logged in.
enddate	The end date of the timetrack entry. Combination of enddate and endtime must be greater than startdate and starttime.	date	Current Date
endtime	The endtime of the timetrack entry. Combination of enddate and endtime must be greater than startdate and starttime.	time	Current Time
number	System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647.	int(11)	Autogenerated. Generally next available integer.
offtime	The number of minutes to be subtracted from the total time. Represents time not worked due to a break.	int(11)	0
startdate	The startdate of the timetrack entry. Combination of enddate and endtime must be greater than startdate and starttime.	date	Current Date
starttime	The enddate of the timetrack entry. Combination of enddate and endtime must be greater than startdate and starttime.	time	No default. User input required.
type	The timetrack entry type. Selected from the tttypes list	char(30)	Normal

SEE ALSO

Relevant Interfaces

Library Routines

BillMax_TimetrackGet

BillMax_TimetrackGetNext

BillMax_TimetrackGetWhere

BillMax_TimetrackPut
Command Line Routines

enter_stat
CGI Routines - NONE
Web Forms - NONE


tierplan table		user 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