| Name: | Test |
| Ward Name: | Akkulam |
| Address: | Test |
| Landmark: | Test |
| Mobile No.: | 9061014814 |
| Email: | test@gmail.com |
| Alternate Mobile No: | |
| GST No.: |
| Date: | 13/11/2024 |
| Timeslot: | 15:00:00-19:00:00 |
| Type of Water: | Drinking |
| Water Quantity: | 20000 |
| Vehicle Capacity Group: | 5000 Litre Tanker_22 |
| No of trips: | 4 |
| Remaining trips: | 4 |
| Width of the road: | 4m |
| Additional pumping required?: | No |
| Customer OTP: | 123 |
| KL: | KL Based |
| Account Name: | Test |
| Account No.: | 234323456788 |
| IFSC Code: | SBDIN000213 |
| Bank Name: | Test |
| Branch Name: | Test |
| Trip No. | Details of Amount Collected | Actual Amount Calculation | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Distance between ward and vendor point | Maximun Distance | Additional Distance | Additional Rate per KM | Additional Charge | Vending Point Odometer Reading | Delivery Location Odometer Reading | Actual Distance Total | Additional KM | Additional Vehicle Charge | Customer Refund | |
| 1 | 100 | 60 | 40 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 2 | 100 | 60 | 40 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 3 | 100 | 60 | 40 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 4 | 100 | 60 | 40 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Sl No | Status Info | Status Comment | Date & Time |
|---|---|---|---|
| 1 | Splitup Payment | test | 13-11-2024 11:36:00 PM |
| 2 | Payment Completed | test | 13-11-2024 11:35:59 PM |
| 3 | Payment Failed | 13-11-2024 11:35:20 PM | |
| 4 | Payment Pending | 13-11-2024 11:34:34 PM |
| Sl No | Transaction ID | Payment Gateway | Amount | Date & Time | Status |
|---|---|---|---|---|---|
| 1 | 63846 | Worldline | 1500.00 | 13-11-2024 07:04 AM | Payment Failed |
| Sl No | Action | Operator Name | Filling Station | Approved Time | Image | Trip Number | Admin Entry/Not | KM From | KM To | Distance (in KM) |
|---|
| Sl No | Date & Time | Added User Name | Notes | File | Action |
|---|
| Sorry, no Connected Booking found |
| Booking Information | |||
| Customer Name | Test | Mobile No. | 9061014814 |
| Booking ID | 1706 | Invoice No. | 000364 |
| Invoice Date | 13/11/2024 | Water Tanker Type | 5000 Litre Tanker_22 |
| Total Qty. Booked (L) | 20000 | Received Amount (Rs) | 1,500.00 |
| Water Tanker Trip Details | ||||||||
| Sl No | Vehicle No. | Delivery Date | Sub Booking ID | Capacity (L) | Water Charge (Rs) | Addl. Km Charge (Rs) | Pumping Charge (Rs) | Total (Rs) |
|---|---|---|---|---|---|---|---|---|
| 1 | KL01A5050 | 14/11/2024 | 1708 | 5000 | 375.00 | 0.00 | 0.00 | 375.00 |
| 2 | KL01A5050 | 14/11/2024 | 1709 | 5000 | 375.00 | 0.00 | 0.00 | 375.00 |
| 3 | KL01A5050 | 13/11/2024 | 1707 | 5000 | 375.00 | 0.00 | 0.00 | 375.00 |
| 4 | KL01A5050 | - | 1710 | 5000 | 0.00 | 0.00 | 0.00 | 0.00 |
| Water Delivery Total | 15000 | 1,125.00 | 0.00 | 0.00 | 1,125.00 | |||
| Customer Refund Summary | |
| Non Delivered Water Quantity (Booked − Delivered) in KL | 5 |
| Rate Per Kilolitre (Rs) | ₹ 75.00 |
| Water Charge Refund in Rs (Non Delivered × Kilolitre Rate) | ₹ 375.00 |
| Pumping Charge Refund (Rs) | ₹ 0.00 |
| Addl. Kilometre Refund (Rs) | ₹ 0.00 |
| Total Refund (Rs) | ₹ 375.00 |
| OK | Booking Quantity Invariant — Sub-booking total (20,000 L) should equal contracted total (20,000 L) |
| OK | Delivery Within Limit — Delivered (20,000 L) should not exceed contracted (20,000 L) |
| 4/4 | Passes Issued — 4 water passes for 4 sub-bookings |
| Status | Count | Quantity (L) | Quantity (KL) |
|---|---|---|---|
| Completed (80) | 3 | 15,000 | 15.0 |
| Customer cancelled (130) | 1 | 5,000 | 5.0 |
| Active Total | 4 | 20,000 | 20.0 |
| Contracted | 20,000 | 20.0 | |
| Difference (Contracted - Active) | 0 | 0.0 |
| Sl No | Status Info | Status Comment | Date & Time | Photograph |
|---|---|---|---|---|
| 1 | Splitup Payment | test | 13-11-2024 11:36:00 PM | |
| 2 | Payment Completed | test | 13-11-2024 11:35:59 PM | |
| 3 | Payment Failed | 13-11-2024 11:35:20 PM | ||
| 4 | Payment Pending | 13-11-2024 11:34:34 PM |