{$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

You could leave a comment if you were logged in.