original_pages:sql_structure_-_taxclass

{$page}

Updated: 2009-09-16

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is the header record for a tax class. The TaxLink Table stores the individual links to each of the Tax Accounts (stored in the 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