Updated: 2009-09-21

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is …

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 7000 - Spped Note
    • 7100 - PO Speed Note
    • 7500 - Standard Pricing Formula

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
SpeedNote.ClassTypeID int Identifier for the Type of Object
SpeedNote.Full text
SpeedNote.HasParseFields bit
SpeedNote.ID int Primary Key for the Table
SpeedNote.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
SpeedNote.IsSystem bit Used to Mark Required Records
SpeedNote.ModifiedByComputer nvarchar(25) HostName of computer that last modified this record
SpeedNote.ModifiedByUser nvarchar(25) Windows User who last modified this record
SpeedNote.ModifiedDate datetime DateTime this Record was last modified
SpeedNote.NoteTypeID int
SpeedNote.SeqID int
SpeedNote.StoreID int Not Used.
SpeedNote.Title nvarchar(50)

Related Tables

You could leave a comment if you were logged in.