Updated: 2009-09-16



Version: Control 4.4



Table Purpose, Usage, and Notes 



This table is used to store the Inventory record for parts using inventory. Note that a record may still exist for Parts where the inventory is not being tracked if it was ever turned on in the past.



Information on Table Data 
  * ClassTypeIDs Stores in Table: 
    * 12200 - Warehouse Inventory Record (actual inventory record)
    * 12201 - Division Summary Inventory Record
    * 12202 - Warehouse Summary Inventory Record



Table Structure 



||~ Table.FieldName ||~ Data Type ||~ Description ||~ Links To ||
|| Inventory.AssetAccountClassTypeID || int ||   ||   ||
|| Inventory.AssetAccountID || int || ID of the Asset Account this Inventory is tracked in || GLAccount.ID ||
|| Inventory.AssetAccountIDOV || bit ||   ||   ||
|| Inventory.AverageCost || float || Average Cost of this Inventory Item (should always equal Part.UnitCost) || 0 ||
|| Inventory.ClassTypeID || int || Identifier for the Type of Object ||   ||
|| Inventory.ID || int || Primary Key Field || 0 ||
|| Inventory.IsActive || bit || Indicates if Enabled. 1Record is Active, 0Record is Not Active ||   ||
|| Inventory.IsSystem || bit || Used to Mark Required Records ||   ||
|| Inventory.ItemName || varchar(50) || Name of Inventoried Part || 0 ||
|| Inventory.ModifiedByComputer || varchar(25) || HostName of computer that last modified this record ||   ||
|| Inventory.ModifiedByUser || varchar(25) || Windows User who last modified this record ||   ||
|| Inventory.ModifiedDate || datetime || DateTime this Record was last modified ||   ||
|| Inventory.PartID || int || ID of the Inventoried Part || Part.ID ||
|| Inventory.QuantityAvailable || float ||   ||   ||
|| Inventory.QuantityBilled || float ||   ||   ||
|| Inventory.QuantityExpected || float ||   ||   ||
|| Inventory.QuantityOnHand || float ||   ||   ||
|| Inventory.QuantityOnOrder || float ||   ||   ||
|| Inventory.QuantityReceivedOnly || float ||   ||   ||
|| Inventory.QuantityReserved || float ||   ||   ||
|| Inventory.RedNotificationPoint || float ||   ||   ||
|| Inventory.ReorderPoint || float ||   ||   ||
|| Inventory.ReOrderQuantity || float ||   ||   ||
|| Inventory.SeqID || int ||   ||   ||
|| Inventory.StoreID || int || Not Used. ||   ||
|| Inventory.UnitID || int ||   ||   ||
|| Inventory.UnitType || int ||   ||   ||
|| Inventory.UseCategoryDefaults || bit ||   ||   ||
|| Inventory.YellowNotificationPoint || float ||   ||   ||
Related Tables