fx_franchise_order

1,057 rows · 31 columns · page 5 / 22

Excel export
# id orderid invoice_no userid shopee_id purchase_type product_type total_quantity total_amount comm_per dicount_comm total_cgst_amt total_sgst_amount total_igst_amount final_amount _currency total_bv total_pv total_sv payment_type order_by created_on delivery_status delivered_on admin_status admin_processed_on processed_by receipt_path payment_ref_no fran_comm_status fran_comm_credited_on
201 421 POF-1411 INVF-1411 12554 12516 2 1 20 229790.0 0.0 11489.5 3346.46 3346.46 0.0 218300.5 INR 0.0 30.0 0.0 4 12554 2025-12-21 11:18:12 0 NULL 1 2025-12-21 11:18:36 12516 0 NULL
202 422 POF-1412 INVF-1412 12516 1 2 1 10 79800.0 0.0 6384.0 1162.14 1162.14 0.0 73416.0 INR 0.0 20.0 0.0 4 12516 2025-12-21 11:36:28 0 NULL 1 2025-12-21 11:36:55 1 0 NULL
203 423 POF-1413 INVF-1413 12554 12516 2 1 20 229790.0 0.0 11489.5 3346.46 3346.46 0.0 218300.5 INR 0.0 30.0 0.0 4 12554 2025-12-21 11:39:11 0 NULL 1 2025-12-21 11:39:44 12516 0 NULL
204 424 POF-1414 INVF-1414 12555 12554 2 1 30 20400.0 0.0 408.0 485.72 485.72 0.0 19992.0 INR 0.0 1.0 0.0 4 12555 2025-12-23 14:15:35 0 NULL 1 2025-12-23 14:15:54 12554 0 NULL
205 425 POF-1415 INVF-1415 12516 1 2 1 10 149990.0 0.0 11999.2 2184.32 2184.32 0.0 137990.8 INR 0.0 30.0 0.0 4 12516 2025-12-23 16:54:00 0 NULL 1 2025-12-23 18:03:26 1 0 NULL
206 426 POF-1416 INVF-1416 12551 12516 2 1 22 150845.0 0.0 7542.25 2381.61 2381.61 0.0 143302.75 INR 0.0 4.0 0.0 4 12551 2025-12-23 18:04:27 0 NULL 1 2025-12-23 18:04:53 12516 0 NULL
207 427 POF-1417 INVF-1417 12516 1 2 1 40 459580.0 0.0 36766.4 6692.91 6692.91 0.0 422813.6 INR 0.0 60.0 0.0 4 12516 2025-12-23 20:05:34 0 NULL 1 2025-12-23 20:05:55 1 0 NULL
208 428 POF-1418 INVF-1418 12554 12516 2 1 40 459580.0 0.0 22979.0 6692.91 6692.91 0.0 436601.0 INR 0.0 60.0 0.0 4 12554 2025-12-23 20:06:55 0 NULL 1 2025-12-24 14:49:00 12516 0 NULL
209 429 POF-1419 INVF-1419 12555 12554 2 1 40 459580.0 0.0 9191.6 6692.91 6692.91 0.0 450388.4 INR 0.0 60.0 0.0 4 12555 2025-12-23 20:09:09 0 NULL 1 2025-12-23 20:09:46 12554 0 NULL
210 430 POF-1420 INVF-1420 12555 12554 2 1 100 12000.0 0.0 240.0 915.25 915.25 0.0 11760.0 INR 0.0 1.1 0.0 4 12555 2025-12-23 22:26:12 0 NULL 1 2025-12-23 22:26:49 12554 0 NULL
211 431 POF-1421 INVF-1421 12516 1 2 1 90 111160.0 0.0 8892.8 1722.03 1722.03 0.0 102267.2 INR 0.0 1.0 0.0 4 12516 2025-12-24 14:47:35 0 NULL 1 2025-12-24 14:47:50 1 0 NULL
212 432 POF-1422 INVF-1422 12554 12516 2 1 70 105580.0 0.0 5279.0 1589.17 1589.17 0.0 100301.0 INR 0.0 0.5 0.0 4 12554 2025-12-24 14:48:30 0 NULL 1 2025-12-24 14:48:57 12516 0 NULL
213 433 POF-1423 INVF-1423 12555 12554 2 1 70 105580.0 0.0 2111.6 1589.17 1589.17 0.0 103468.4 INR 0.0 0.5 0.0 4 12555 2025-12-24 14:50:04 0 NULL 1 2025-12-24 14:50:16 12554 0 NULL
214 434 POF-1424 INVF-1424 12555 12554 2 1 10 26000.0 0.0 520.0 619.05 619.05 0.0 25480.0 INR 0.0 5.0 0.0 4 12555 2025-12-24 17:55:29 0 NULL 1 2025-12-24 17:56:33 12554 0 NULL
215 435 POF-1425 INVF-1425 12554 12516 2 1 10 26000.0 0.0 1300.0 619.05 619.05 0.0 24700.0 INR 0.0 5.0 0.0 4 12554 2025-12-24 17:56:00 0 NULL 1 2025-12-24 17:56:19 12516 0 NULL
216 436 POF-1426 INVF-1426 13438 12517 2 1 4 736.0 0.0 14.72 56.13 56.13 0.0 721.28 INR 0.0 0.04 0.0 4 13438 2025-12-24 18:38:13 0 NULL 1 2025-12-25 11:30:57 12517 0 NULL
217 437 POF-1427 INVF-1427 13438 12517 2 1 53 2544.0 0.0 50.88 60.57 60.57 0.0 2493.12 INR 0.0 0.32 0.0 4 13438 2025-12-24 18:42:55 0 NULL 1 2025-12-25 11:30:57 12517 0 NULL
218 438 POF-1428 INVF-1428 13438 12517 2 1 5 3884.0 0.0 77.68 159.84 159.84 0.0 3806.32 INR 0.0 0.09 0.0 4 13438 2025-12-24 18:50:57 0 NULL 1 2025-12-25 11:30:57 12517 0 NULL
219 439 POF-1429 INVF-1429 13438 12517 2 1 4 636.0 0.0 12.72 48.51 48.51 0.0 623.28 INR 0.0 0.04 0.0 4 13438 2025-12-24 19:01:38 0 NULL 1 2025-12-25 11:30:57 12517 0 NULL
220 440 POF-1430 INVF-1430 13438 12517 2 1 1 304.0 0.0 6.08 23.18 23.18 0.0 297.92 INR 0.0 0.05 0.0 4 13438 2025-12-24 19:07:42 0 NULL 1 2025-12-25 11:30:57 12517 0 NULL
221 441 POF-1431 INVF-1431 13438 12517 2 1 1 279.0 0.0 5.58 6.64 6.64 0.0 273.42 INR 0.0 0.05 0.0 4 13438 2025-12-24 19:10:21 0 NULL 1 2025-12-25 11:30:58 12517 0 NULL
222 442 POF-1432 INVF-1432 13438 12517 2 1 43 2064.0 0.0 41.28 49.15 49.15 0.0 2022.72 INR 0.0 0.26 0.0 4 13438 2025-12-24 19:15:44 0 NULL 1 2025-12-25 11:30:58 12517 0 NULL
223 443 POF-1433 INVF-1433 13438 12517 2 1 10 800.0 0.0 16.0 19.05 19.05 0.0 784.0 INR 0.0 0.09 0.0 4 13438 2025-12-25 12:07:07 0 NULL 2 2025-12-25 12:16:58 12517 0 NULL
224 444 POF-1434 INVF-1434 13438 12517 2 1 5 600.0 0.0 12.0 45.77 45.77 0.0 588.0 INR 0.0 0.06 0.0 4 13438 2025-12-25 12:08:24 0 NULL 2 2025-12-25 12:16:58 12517 0 NULL
225 445 POF-1435 INVF-1435 13438 12517 2 1 15 1400.0 0.0 28.0 64.81 64.81 0.0 1372.0 INR 0.0 0.06 0.0 4 13438 2025-12-25 12:10:14 0 NULL 1 2025-12-25 12:15:36 12517 0 NULL
226 446 POF-1436 INVF-1436 12517 12516 2 1 1 7980.0 0.0 399.0 0.0 0.0 232.43 7581.0 INR 0.0 2.0 0.0 4 12517 2025-12-25 12:15:57 0 NULL 1 2025-12-25 12:16:11 12516 0 NULL
227 447 POF-1437 INVF-1437 13438 12517 2 1 1 7980.0 0.0 159.6 116.22 116.22 0.0 7820.4 INR 0.0 2.0 0.0 4 13438 2025-12-25 12:17:19 0 NULL 1 2025-12-25 12:17:53 12517 0 NULL
228 448 POF-1438 INVF-1438 13438 12517 2 1 30 4770.0 0.0 95.4 363.81 363.81 0.0 4674.6 INR 0.0 0.75 0.0 4 13438 2025-12-25 12:40:02 0 NULL 1 2025-12-25 12:40:17 12517 0 NULL
229 449 POF-1439 INVF-1439 13438 12517 2 1 10 1840.0 0.0 36.8 140.34 140.34 0.0 1803.2 INR 0.0 0.11 0.0 4 13438 2025-12-25 12:41:14 0 NULL 1 2025-12-25 12:41:31 12517 0 NULL
230 450 POF-1440 INVF-1440 13438 12517 2 1 10 1590.0 0.0 31.8 121.27 121.27 0.0 1558.2 INR 0.0 0.25 0.0 4 13438 2025-12-25 12:48:56 0 NULL 1 2025-12-25 13:02:45 12517 0 NULL
231 451 POF-1441 INVF-1441 12555 12554 2 1 5 3600.0 0.0 72.0 85.71 85.71 0.0 3528.0 INR 0.0 0.75 0.0 4 12555 2025-12-25 12:57:23 0 NULL 1 2025-12-25 12:57:31 12554 0 NULL
232 452 POF-1442 INVF-1442 13438 12517 2 1 2 318.0 0.0 6.36 7.57 7.57 0.0 311.64 INR 0.0 0.03 0.0 4 13438 2025-12-25 12:58:02 0 NULL 1 2025-12-25 13:02:45 12517 0 NULL
233 453 POF-1443 INVF-1443 13438 12517 2 1 5 795.0 0.0 15.9 18.93 18.93 0.0 779.1 INR 0.0 0.08 0.0 4 13438 2025-12-25 13:02:13 0 NULL 1 2025-12-25 13:02:45 12517 0 NULL
234 454 POF-1444 INVF-1444 12555 12554 2 1 20 3180.0 0.0 63.6 242.54 242.54 0.0 3116.4 INR 0.0 0.5 0.0 4 12555 2025-12-25 13:51:34 0 NULL 1 2025-12-25 13:51:47 12554 0 NULL
235 455 POF-1445 INVF-1445 12555 12554 2 1 10 79800.0 0.0 1596.0 1162.14 1162.14 0.0 78204.0 INR 0.0 20.0 0.0 4 12555 2025-12-25 16:23:34 0 NULL 1 2025-12-25 16:23:44 12554 0 NULL
236 456 POF-1446 INVF-1446 12554 12516 2 1 5 49500.0 0.0 2475.0 3775.42 3775.42 0.0 47025.0 INR 0.0 10.0 0.0 4 12554 2025-12-25 16:28:28 0 NULL 1 2025-12-25 16:29:39 12516 0 NULL
237 457 POF-1447 INVF-1447 12516 1 2 1 10 99000.0 0.0 7920.0 7550.85 7550.85 0.0 91080.0 INR 0.0 20.0 0.0 4 12516 2025-12-25 16:29:11 0 NULL 1 2025-12-25 16:29:23 1 0 NULL
238 458 POF-1448 INVF-1448 12555 12554 2 1 5 49500.0 0.0 990.0 3775.42 3775.42 0.0 48510.0 INR 0.0 10.0 0.0 4 12555 2025-12-25 16:30:55 0 NULL 1 2025-12-25 16:31:10 12554 0 NULL
239 459 POF-1449 INVF-1449 12517 12516 2 1 1 7980.0 0.0 399.0 0.0 0.0 232.43 7581.0 INR 0.0 2.0 0.0 4 12517 2025-12-25 17:28:03 0 NULL 1 2025-12-25 17:28:43 12516 0 NULL
240 460 POF-1450 INVF-1450 12542 12517 2 1 1 7980.0 0.0 159.6 116.22 116.22 0.0 7820.4 INR 0.0 2.0 0.0 4 12542 2025-12-25 17:29:03 0 NULL 1 2025-12-25 17:29:21 12517 0 NULL
241 461 POF-1451 INVF-1451 12516 1 2 1 30 239400.0 0.0 19152.0 3486.41 3486.41 0.0 220248.0 INR 0.0 60.0 0.0 4 12516 2025-12-26 11:03:16 0 NULL 1 2025-12-26 11:03:26 1 0 NULL
242 462 POF-1452 INVF-1452 12554 12516 2 1 20 159600.0 0.0 7980.0 2324.27 2324.27 0.0 151620.0 INR 0.0 40.0 0.0 4 12554 2025-12-26 11:03:51 0 NULL 1 2025-12-26 11:04:26 12516 0 NULL
243 463 POF-1453 INVF-1453 12555 12554 2 1 20 159600.0 0.0 3192.0 2324.27 2324.27 0.0 156408.0 INR 0.0 40.0 0.0 4 12555 2025-12-26 11:04:14 0 NULL 1 2025-12-26 11:04:40 12554 0 NULL
244 464 POF-1454 INVF-1454 12555 12554 2 1 10 7190.0 0.0 143.8 171.19 171.19 0.0 7046.2 INR 0.0 1.5 0.0 4 12555 2025-12-26 12:33:09 0 NULL 1 2025-12-26 12:33:24 12554 0 NULL
245 465 POF-1455 INVF-1455 12555 12554 2 1 100 15900.0 0.0 318.0 1212.71 1212.71 0.0 15582.0 INR 0.0 2.5 0.0 4 12555 2025-12-26 12:42:38 0 NULL 1 2025-12-26 12:42:49 12554 0 NULL
246 466 POF-1456 INVF-1456 12542 12554 2 1 53 2544.0 0.0 50.88 0.0 0.0 121.14 2493.12 INR 0.0 0.32 0.0 4 12542 2025-12-26 13:42:23 0 NULL 1 2025-12-26 13:42:53 12554 0 NULL
247 467 POF-1457 INVF-1457 12555 12554 2 1 300 14400.0 0.0 288.0 342.86 342.86 0.0 14112.0 INR 0.0 1.8 0.0 4 12555 2025-12-26 15:16:48 0 NULL 1 2025-12-26 15:17:08 12554 0 NULL
248 468 POF-1458 INVF-1458 12555 12554 2 1 10 12000.0 0.0 240.0 285.71 285.71 0.0 11760.0 INR 0.0 2.5 0.0 4 12555 2025-12-26 15:40:10 0 NULL 1 2025-12-26 15:40:23 12554 0 NULL
249 469 POF-1459 INVF-1459 12555 12554 2 1 50 15200.0 0.0 304.0 0.0 0.0 0.0 14896.0 INR 0.0 2.5 0.0 4 12555 2025-12-26 15:55:05 0 NULL 1 2025-12-26 15:56:46 12554 0 NULL
250 470 POF-1460 INVF-1460 12554 12516 2 1 50 15200.0 0.0 760.0 0.0 0.0 0.0 14440.0 INR 0.0 2.5 0.0 4 12554 2025-12-26 15:55:39 0 NULL 1 2025-12-26 15:56:32 12516 0 NULL