Updated: 2009-09-21
Version: Control 4.4
Table Purpose, Usage, and Notes
This table is used to track the movement of inventory through production.
Information on Table Data
Table Structure
| ~ Table.FieldName | ~ Data Type | ~ Description | ~ Links To | ||||
| InventoryLog.ClassTypeID | int | ID for this Type of Object | |||||
| InventoryLog.Cost | float | ||||||
| InventoryLog.ID | int | Primary Key for the Table | |||||
| InventoryLog.InventoryClassTypeID | int | ||||||
| InventoryLog.InventoryID | int | ||||||
| InventoryLog.IsActive | bit | Not Used for This Table | |||||
| InventoryLog.IsSystem | bit | Used to Mark Required Records | |||||
| InventoryLog.ModifiedByComputer | varchar(25) | HostName of computer that last modified this record | |||||
| InventoryLog.ModifiedByUser | varchar(25) | Windows User who last modified this record | |||||
| InventoryLog.ModifiedDate | datetime | DateTime this Record was last modified | |||||
| InventoryLog.ModifierClassTypeID | int | ||||||
| InventoryLog.ModifierID | int | ||||||
| InventoryLog.PartClassTypeID | int | ||||||
| InventoryLog.PartID | int | ||||||
| InventoryLog.ProductClassTypeID | int | ||||||
| InventoryLog.ProductID | int | ||||||
| InventoryLog.QuantityAvailable | float | ||||||
| InventoryLog.QuantityBilled | float | ||||||
| InventoryLog.QuantityExpected | float | ||||||
| InventoryLog.QuantityOnHand | float | ||||||
| InventoryLog.QuantityOnOrder | float | ||||||
| InventoryLog.QuantityReceivedOnly | float | ||||||
| InventoryLog.QuantityReserved | float | ||||||
| InventoryLog.SeqID | int | ||||||
| InventoryLog.StoreID | int | Not Used. | |||||
| InventoryLog.TransDetailClassTypeID | int | ||||||
| InventoryLog.TransDetailID | int | ||||||
| InventoryLog.TransPartClassTypeID | int | ||||||
| InventoryLog.TransPartID | int | ||||||
| InventoryLog.UnitCost | float |
Related Tables