411 REFERENCE · Wikibooks
ERP Internals/Data Tables/Item/Item
Reference material by Wikibooks contributors. This retains its source identity and is not 411 news reporting.
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