The Requests table is the central hub of this database, capturing all relevant information for each purchase request. This includes the Request Date, the individual Requested By, the Items being requested, and the Purpose behind the purchase. The table also tracks key details like the Vendor, Estimated Cost, and Priority of the request, ensuring that high-priority needs are addressed first. Additionally, the table logs the Status of the request, along with information about who Approved the request and when it was Approved, ensuring proper authorization. Once the purchase is approved, it records details like the Order Date, PO Number, PO Total, and who Received the items, ensuring full visibility from start to finish.
This table ensures that all purchase requests are properly documented, managed, and tracked, allowing organizations to maintain control over their purchasing process and budget.
Any support materials, such as spreadsheets and real-life work samples would be very helpful as they would help us better understand your business process.