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