{$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
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 | Part.ID | |||||
| CatalogItem.PartNumber | varchar(50) | ||||||
| CatalogItem.ProductionNotes | text | ||||||
| CatalogItem.SeqID | int | ||||||
| CatalogItem.StoreID | int | Not Used. | |||||
| CatalogItem.UnitCost | float | ||||||
| CatalogItem.VendorID | int | Account.ID | |||||
| CatalogItem.VendorPartName | varchar(50) | ||||||
| CatalogItem.VendorPriority | int |
Related Tables
See Also