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.