Updated: 2009-09-16

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is the header record for a tax class. The sql_structure_-_taxlink_table stores the individual links to each of the Tax Accounts (stored in the sql_structure_-_glaccount_table).

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 5000 - Tax Class

Table Structure

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

Related Tables

You could leave a comment if you were logged in.