ProductId | Product Name | Available Quantity | Next Refill Date | Buffer
Quantity
-----------------------------------------------------------------------------------
--------
P001 | Laptop | 50 | 2025-03-10 [Link] | 10
P002 | Smartphone | 120 | 2025-03-15 [Link] | 20
P003 | Keyboard | 80 | 2025-02-28 [Link] | 15
P004 | Mouse | 90 | 2025-03-01 [Link] | 18
P005 | Monitor | 30 | 2025-03-05 [Link] | 5
P006 | Printer | 15 | 2025-03-20 [Link] | 3
P007 | External HDD | 40 | 2025-03-12 [Link] | 8
P008 | USB Flash Drive | 250 | 2025-02-25 [Link] | 50
P009 | Headphones | 60 | 2025-03-08 [Link] | 12
P010 | Web Camera | 25 | 2025-02-26 [Link] | 7
MandateID | UserId | Name | Product Name | Quantity | Date
---------------------------------------------------------------------------------
M001 | U001 | ABC Corp | Laptop | 10 | 2025-02-
15 [Link]
M002 | U002 | XYZ Pvt Ltd | Smartphone | 25 | 2025-02-
20 [Link]
M003 | U003 | John Doe | Keyboard | 15 | 2025-02-
10 [Link]
M004 | U004 | Jane Smith | Mouse | 20 | 2025-02-
12 [Link]
M005 | U005 | Tech Solutions | Monitor | 5 | 2025-02-
18 [Link]
M006 | U006 | Innovate Inc | Printer | 3 | 2025-02-
25 [Link]
M007 | U007 | Digital Works | External HDD | 8 | 2025-02-
22 [Link]
M008 | U008 | Mark Johnson | USB Flash Drive | 50 | 2025-02-
14 [Link]
M009 | U009 | Future Systems | Headphones | 12 | 2025-02-
17 [Link]
M010 | U010 | Sarah Lee | Web Camera | 7 | 2025-02-
16 [Link]
PurchaseID | UserId | Name | Purchased Product Name | Quantity |
Date | Payment Status
-----------------------------------------------------------------------------------
-------------------------
P001 | U001 | ABC Corp | Laptop | 5 |
2025-01-10 [Link] | Completed
P002 | U001 | ABC Corp | Smartphone | 12 |
2024-12-22 [Link] | Completed
P003 | U002 | XYZ Pvt Ltd | Smartphone | 20 |
2025-01-15 [Link] | Completed
P004 | U002 | XYZ Pvt Ltd | Mouse | 10 |
2024-12-30 [Link] | Completed
P005 | U003 | John Doe | Keyboard | 8 |
2025-01-05 [Link] | Completed
P006 | U003 | John Doe | Web Camera | 3 |
2024-12-25 [Link] | **Pending - ₹1200**
P007 | U004 | Jane Smith | Monitor | 4 |
2025-01-08 [Link] | Completed
P008 | U004 | Jane Smith | USB Flash Drive | 30 |
2024-12-18 [Link] | Completed
P009 | U005 | Tech Solutions | Printer | 2 |
2025-01-12 [Link] | Completed
P010 | U005 | Tech Solutions | External HDD | 6 |
2024-12-28 [Link] | Completed
P011 | U006 | Innovate Inc | Headphones | 10 |
2025-01-07 [Link] | Completed
P012 | U006 | Innovate Inc | Web Camera | 5 |
2024-12-29 [Link] | Completed
P013 | U007 | Digital Works | Keyboard | 12 |
2025-01-02 [Link] | Completed
P014 | U007 | Digital Works | Laptop | 3 |
2024-12-20 [Link] | Completed
P015 | U008 | Mark Johnson | USB Flash Drive | 40 |
2025-01-14 [Link] | **Pending - ₹6200**
P016 | U008 | Mark Johnson | Smartphone | 15 |
2024-12-24 [Link] | Completed
P017 | U009 | Future Systems | Headphones | 5 |
2025-01-09 [Link] | Completed
P018 | U009 | Future Systems | Monitor | 3 |
2024-12-27 [Link] | Completed
P019 | U010 | Sarah Lee | External HDD | 4 |
2025-01-06 [Link] | Completed
P020 | U010 | Sarah Lee | Printer | 2 |
2024-12-23 [Link] | **Pending - ₹1400**
