{$page}

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

See Also

You could leave a comment if you were logged in.