{$page} 



Updated: 2009-09-16



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table stores catalog information which are vendor specific information for purchasing parts.



Information on Table Data 
  * ClassTypeIDs Stores in Table:
    * 12076 - Catalog Item



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| CatalogItem.BarCode || varchar(50) ||  ||   ||
|| CatalogItem.BillingNotes || text ||  ||   ||
|| CatalogItem.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| CatalogItem.Cost || float ||  ||   ||
|| CatalogItem.Flags || text ||  ||   ||
|| CatalogItem.ID || int || Primary Key for the Table ||   ||
|| CatalogItem.IsActive || bit || Indicates if Enabled.  1Record is Active, 0Record is Not Active ||   ||
|| CatalogItem.IsSystem || bit || Used to Mark Required Records ||   ||
|| CatalogItem.ModifiedByComputer || varchar(25) || HostName of computer that last modified this record ||   ||
|| CatalogItem.ModifiedByUser || varchar(25) || Windows User who last modified this record ||   ||
|| CatalogItem.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| CatalogItem.PackageSize || float ||  ||   ||
|| CatalogItem.PackageUnitID || int ||  ||   ||
|| CatalogItem.PartID || int ||  || [[sql_structure_-_part_tablepart|Part]].ID ||
|| CatalogItem.PartNumber || varchar(50) ||  ||   ||
|| CatalogItem.ProductionNotes || text ||  ||   ||
|| CatalogItem.SeqID || int ||  ||   ||
|| CatalogItem.StoreID || int || Not Used. ||   ||
|| CatalogItem.UnitCost || float ||  ||   ||
|| CatalogItem.VendorID || int ||  || [[sql_structure_-_account_table|Account]].ID ||
|| CatalogItem.VendorPartName || varchar(50) ||  ||   ||
|| CatalogItem.VendorPriority || int ||  ||   ||
Related Tables 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]