ERP Internals/Data Tables/Item/Item

From Wikibooks, open books for an open world
< ERP Internals‎ | Data Tables‎ | Item
Jump to: navigation, search

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