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_table.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.ID
CatalogItem.VendorPartName varchar(50)
CatalogItem.VendorPriority int

Related Tables

You could leave a comment if you were logged in.