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

Name

note table — table for Note data

note Field Definitions

Name

Description

Data Type BillMax Default
Name

Description

Data Type BillMax Default
empl

The Authorized BillMax User who created the entry.

mediumint(8) The Authorized BillMax User who created the entry. If note created by closeofday then the id of the process running closeofday
entdate

Current Date

date Current Date
enttime

Current Time

time Current Time
fromtable

The table with which the note is associated.

varchar(20) No default. Populated by system based on context.
number

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

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

The priority of the note.

tinyint(4) 0
reference

The number of the record in the associated table.

int(11) No default. Populated by system based on context.
text

The text of the note.

text BLANK

SEE ALSO

Relevant Interfaces

  1. Library Routines

    BillMax_NoteGet
    BillMax_NoteGetNext
    BillMax_NoteGetWhere
    BillMax_NotePut

  2. Command Line Routines

    note

  3. CGI Routines - NONE

  4. Web Forms - Note Form

Prev  Up  Next
monthlysale table  Home  notice 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