{$page} 



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 
  * ClassTypeIDs Stores in Table: 
    * 12045 - Part change activity: Created when the part name has changed.
    * 20520 - Part Usage Header: Header Record used to group together one or more part usage activities. Created when usage cards are created.
    * 20530 - Inventory Adjustment: Created when changes to inventory or cost occurs in part setup
    * 20531 - Part Usage Detail: Detail Record created when a usage card is created.
    * 20536 - Inventory Division Summary: Created when changes to cost occurs in part setup that effect the cost at the division level.
    * 20566 - Inventory Transfer Header: Header Record created when inventory is transfered from one warehouse to another.
    * 20567 - Inventory Transfer Detail: Detail Record created when inventory is transfered from one warehouse to another. Two should be created with each transfer, one for the amount coming out of one warehouse and one for the amount going into the other.



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 



See Also 
  * Backlinks [[include_pagepage_componentbacklinks]]