Ok, hears a quasi normal day here I get product for 2 or 3 sources, eBay, distribution (PO), stores, etc. When a PO is required I generate one. If not required, I just insert into history table as a purchase and tag it with a project, that could turn into a PO.
Now back here I get something from somewhere. Well first I have to check two tables the Manufactures and add if necessary, then get its Category's ID with those .two pieces I can now generate the Info table, If it is in the table we just generate the History. But wait you say does this go into the warehouse?
Ok the parts are from eBay, and there for my simulator MCT275, a opto-isolator, and made by Vishay, and there are 200 of them. Well I have to start at the beginning. OK I check the Manufactures table and its not there so I add it. It has an ManID = 19. Now I check the Categories table and the CatID = 1377 (Integrated Circuit, Opto-isolators). Now I go to the Info table and put in all the data. I have left the CatSeq blank, as the computer will update the CatSeq number to one higher than in the Categories table if its Null then its a 1 and and we update the Info tables CatSeq number buy the InfoID number of the part. This is done autonomously so CatSeq numbers are always correct. Next I need to add to the History table. Since I don't have an extra bin in my blue draws for them, I will keep them in their tubes, on the self where to two project boxes are. So lets see where they are. This requires a Spots its Location = Office, UnitID = C, ShelfID = 2 (above the lab bench), Spot = F, and here is its picture.
There they are right where I had to put them. --------->
If This had been a Purchase Order or eBay for that mater I would have had the Info table filled out before hand. So when I received the product all I would have done is fill in the History table. Note my system lacks one important feature. and that would be the Receiving and RecItems tables, I might add them later.
Now that there in the "Warehouse" how do I get them out, I need some sort of paper trail. that's where my History table comes in. So lets say I need 10 of the Opto-isolators, for project Master Caution System. What to do. Go into the table and fill in the information CatID, CatSeq, Condition Code, Quan, Invoice, Quan-Sold. For the Invoice we have to get creative. We fill-in "Pro-MSC" (Project Master Caution System) and for each item going into that project we need that invoice tag. The system will autonomously fill in dates, PriceLot, PriceEa from the purchase entry in the DB. The reason we have to get creative is because invoice number are yearmonthSequence. I could change the invoice to a number but then I cant find it. So to keep everything copacetic I would have to add a invoice number modifier, or a cross over table.
Questions?
