ERP Internals/Data Tables/Item/Item

This table contains one record for every Inventory item.

Used by: Inventory, Order Entry/Invoicing, Purchasing, Quotation/Estimation

Key: Item Number

Fields:
 * Item Number (a unique Identifier assigned by the user)
 * Type (Item/Service/Time Billing)
 * Category (Hardware/Raw Material/Finished Goods)
 * Class (user-defined)
 * Active (Yes/No)
 * Description
 * Long Description
 * Picture
 * Thumbnail
 * BOM Number
 * Configurable (Yes/No)
 * Stocking UOM
 * Selling UOM
 * Buying UOM
 * Conversion Factors between UOMs
 * Weight
 * Dimensions (length,width,height, thickness)
 * Shape (rod, sheet, etc.)
 * Alloy (Aluminum, Stainless Steel, etc.)
 * On-Hand (sum of all locations)
 * On-Order
 * Allocated
 * Minimum
 * Re-order Quantity
 * EOQ
 * Lead Time (Days)
 * Lot Number
 * Serial Number
 * Cycle Count
 * Last Count Date
 * Duty Percentage (used to calculate anticipated duty on receipts)
 * Costing Type
 * Last Cost
 * Average Cost
 * Standard Cost
 * Selling Price
 * YTD Units
 * YTD Amount
 * GL Distribution Group (contains all the postable account numbers)
 * Notes