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