Updated: 2009-09-16

Version: Control 4.4

Table Purpose, Usage, and Notes

This table is stores the Product Taxability Codes used to determine the tax treatment of products.

Information on Table Data

  • ClassTypeIDs Stores in Table:
    • 5005 - Product Taxability Code

Table Structure

~ Table.FieldName ~ Data Type ~ Description ~ Links To
ProductTaxabilityCode.AvaTaxCode varchar(50)
ProductTaxabilityCode.ClassTypeID int Identifier for the Type of Object
ProductTaxabilityCode.ID int Primary Key Field
ProductTaxabilityCode.IsActive bit Indicates if Enabled. 1Record is Active, 0Record is Not Active
ProductTaxabilityCode.IsFullyTaxed bit
ProductTaxabilityCode.IsSystem bit Used to Mark Required Records
ProductTaxabilityCode.IsTaxExempt bit
ProductTaxabilityCode.ModifiedByComputer varchar(25) HostName of computer that last modified this record
ProductTaxabilityCode.ModifiedByUser varchar(25) Windows User who last modified this record
ProductTaxabilityCode.ModifiedDate datetime DateTime this Record was last modified
ProductTaxabilityCode.SeqID int
ProductTaxabilityCode.StoreID int Not Used.
ProductTaxabilityCode.TaxableAmountFormula text
ProductTaxabilityCode.TaxableCalculationType int
ProductTaxabilityCode.TaxableCalculationTypeText varchar(30)
ProductTaxabilityCode.TaxCode varchar(50)

Related Tables

You could leave a comment if you were logged in.