This system has a categorized product inventory control system. Products are building construction raw materials such as cement, steels, sands, blocks, tiles, etc. The company has a central warehouse that stores all raw materials and issues to sites from there. So the inventory control system is developed on that concept.
Every product is belongs to a category. Therefore the inventory control system is consists of following database tables.
- Categories
- Items
Categories table has only category ID and the name. Following the structure of the categories table.
Items table has Item Code (primary key is an auto increment integer), Name, Part Number, Category, Low Limit and Unit. _Part Number is an internal code to identify and search the product when issuing, Low Limit is the minimum stock level the warehouse should maintain and the Unit is the scale of products such as Meters, Liters, Pcs, etc.
Comments
Post a Comment