fx_franchise_order

1,057 rows · 31 columns · page 6 / 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
251 471 POF-1461 INVF-1461 12516 1 2 1 50 15200.0 0.0 1216.0 0.0 0.0 0.0 13984.0 INR 0.0 2.5 0.0 4 12516 2025-12-26 15:56:11 0 NULL 1 2025-12-26 15:56:20 1 0 NULL
252 472 POF-1462 INVF-1462 12554 12516 2 1 20 11180.0 0.0 559.0 266.19 266.19 0.0 10621.0 INR 0.0 2.2 0.0 4 12554 2025-12-26 15:58:24 0 NULL 1 2025-12-26 16:00:55 12516 0 NULL
253 473 POF-1463 INVF-1463 12516 1 2 1 50 27950.0 0.0 2236.0 665.48 665.48 0.0 25714.0 INR 0.0 5.5 0.0 4 12516 2025-12-26 16:00:38 0 NULL 1 2025-12-26 16:00:46 1 0 NULL
254 474 POF-1464 INVF-1464 12555 12554 2 1 30 16770.0 0.0 335.4 399.29 399.29 0.0 16434.6 INR 0.0 3.3 0.0 4 12555 2025-12-26 16:01:33 0 NULL 1 2025-12-26 16:04:45 12554 0 NULL
255 475 POF-1465 INVF-1465 12554 12516 2 1 30 16770.0 0.0 838.5 399.29 399.29 0.0 15931.5 INR 0.0 3.3 0.0 4 12554 2025-12-26 16:02:44 0 NULL 1 2025-12-26 16:04:33 12516 0 NULL
256 476 POF-1466 INVF-1466 12551 12516 2 1 3 23940.0 0.0 1197.0 348.64 348.64 0.0 22743.0 INR 0.0 6.0 0.0 4 12551 2025-12-26 17:15:52 0 NULL 1 2025-12-26 17:16:08 12516 0 NULL
257 477 POF-1467 INVF-1467 12555 12554 2 1 10 3190.0 0.0 63.8 75.95 75.95 0.0 3126.2 INR 0.0 0.5 0.0 4 12555 2025-12-26 18:10:18 0 NULL 1 2025-12-26 18:10:30 12554 0 NULL
258 478 POF-1468 INVF-1468 13438 12554 2 1 1 559.0 0.0 11.18 0.0 0.0 85.27 547.82 INR 0.0 0.11 0.0 4 13438 2025-12-26 19:17:59 0 NULL 1 2025-12-26 19:33:53 12554 0 NULL
259 479 POF-1469 INVF-1469 13438 12554 2 1 1 260.0 0.0 5.2 0.0 0.0 39.66 254.8 INR 0.0 0.02 0.0 4 13438 2025-12-26 19:18:39 0 NULL 1 2025-12-26 19:39:37 12554 0 NULL
260 480 POF-1470 INVF-1470 12554 12516 2 1 1 260.0 0.0 13.0 19.83 19.83 0.0 247.0 INR 0.0 0.02 0.0 4 12554 2025-12-26 19:34:29 0 NULL 1 2025-12-26 19:35:04 12516 0 NULL
261 481 POF-1471 INVF-1471 13438 12554 2 1 2 318.0 0.0 6.36 0.0 0.0 15.14 311.64 INR 0.0 0.03 0.0 4 13438 2025-12-26 19:41:37 0 NULL 1 2025-12-26 19:49:59 12554 0 NULL
262 482 POF-1472 INVF-1472 13438 12554 2 1 1 720.0 0.0 14.4 0.0 0.0 34.29 705.6 INR 0.0 0.15 0.0 4 13438 2025-12-26 19:42:11 0 NULL 1 2025-12-26 19:42:36 12554 0 NULL
263 483 POF-1473 INVF-1473 12554 12516 2 1 30 4770.0 0.0 238.5 113.57 113.57 0.0 4531.5 INR 0.0 0.45 0.0 4 12554 2025-12-26 19:43:02 0 NULL 1 2025-12-26 19:43:25 12516 0 NULL
264 484 POF-1474 INVF-1474 13438 12554 2 1 2 558.0 0.0 11.16 0.0 0.0 26.57 546.84 INR 0.0 0.1 0.0 4 13438 2025-12-26 19:48:42 0 NULL 1 2025-12-26 20:02:53 12554 0 NULL
265 485 POF-1475 INVF-1475 12554 12516 2 1 20 4830.0 0.0 241.5 115.0 115.0 0.0 4588.5 INR 0.0 0.4 0.0 4 12554 2025-12-26 19:51:05 0 NULL 1 2025-12-26 19:51:23 12516 0 NULL
266 486 POF-1476 INVF-1476 13438 12554 2 1 2 408.0 0.0 8.16 0.0 0.0 19.43 399.84 INR 0.0 0.08 0.0 4 13438 2025-12-26 19:56:40 0 NULL 1 2025-12-26 20:02:59 12554 0 NULL
267 487 POF-1477 INVF-1477 13438 12554 2 1 2 558.0 0.0 11.16 0.0 0.0 26.57 546.84 INR 0.0 0.1 0.0 4 13438 2025-12-26 19:57:05 0 NULL 1 2025-12-26 20:02:59 12554 0 NULL
268 488 POF-1478 INVF-1478 13438 12554 2 1 1 304.0 0.0 6.08 0.0 0.0 0.0 297.92 INR 0.0 0.05 0.0 4 13438 2025-12-26 20:18:03 0 NULL 1 2025-12-26 20:31:21 12554 0 NULL
269 489 POF-1479 INVF-1479 13438 12554 2 1 1 260.0 0.0 5.2 0.0 0.0 39.66 254.8 INR 0.0 0.02 0.0 4 13438 2025-12-26 20:21:34 0 NULL 1 2025-12-26 20:45:31 12554 0 NULL
270 490 POF-1480 INVF-1480 12554 12516 2 1 10 2600.0 0.0 130.0 198.31 198.31 0.0 2470.0 INR 0.0 0.21 0.0 4 12554 2025-12-26 20:31:42 0 NULL 1 2025-12-26 20:32:10 12516 0 NULL
271 491 POF-1481 INVF-1481 12554 12516 2 1 40 9260.0 0.0 463.0 706.27 706.27 0.0 8797.0 INR 0.0 0.24 0.0 4 12554 2025-12-26 20:46:03 0 NULL 1 2025-12-26 20:48:37 12516 0 NULL
272 492 POF-1482 INVF-1482 12516 1 2 1 51 15359.0 0.0 1228.72 1171.45 1171.45 0.0 14130.28 INR 0.0 0.01 0.0 4 12516 2025-12-26 20:46:56 0 NULL 1 2025-12-26 20:47:39 1 0 NULL
273 493 POF-1483 INVF-1483 12516 1 2 1 50 7950.0 0.0 636.0 606.36 606.36 0.0 7314.0 INR 0.0 0.6 0.0 4 12516 2025-12-26 20:47:16 0 NULL 1 2025-12-26 20:48:24 1 0 NULL
274 494 POF-1484 INVF-1484 12516 1 2 1 100 55900.0 0.0 4472.0 2307.8 2307.8 0.0 51428.0 INR 0.0 11.0 0.0 4 12516 2025-12-26 20:51:57 0 NULL 1 2025-12-26 20:52:13 1 0 NULL
275 495 POF-1485 INVF-1485 12554 12516 2 1 50 27950.0 0.0 1397.5 1153.9 1153.9 0.0 26552.5 INR 0.0 5.5 0.0 4 12554 2025-12-26 20:52:46 0 NULL 1 2025-12-26 20:53:22 12516 0 NULL
276 496 POF-1486 INVF-1486 12554 12516 2 1 10 5590.0 0.0 279.5 230.78 230.78 0.0 5310.5 INR 0.0 1.1 0.0 4 12554 2025-12-26 21:22:15 0 NULL 1 2025-12-26 21:22:45 12516 0 NULL
277 497 POF-1487 INVF-1487 12555 12554 2 1 10 18500.0 0.0 370.0 440.48 440.48 0.0 18130.0 INR 0.0 3.5 0.0 4 12555 2025-12-26 21:35:30 0 NULL 1 2025-12-26 21:35:52 12554 0 NULL
278 498 POF-1488 INVF-1488 12555 12554 2 1 100 8000.0 0.0 160.0 190.48 190.48 0.0 7840.0 INR 0.0 0.9 0.0 4 12555 2025-12-26 21:38:56 0 NULL 1 2025-12-26 21:39:18 12554 0 NULL
279 499 POF-1489 INVF-1489 12517 12516 2 1 1 559.0 0.0 27.95 0.0 0.0 46.16 531.05 INR 0.0 0.11 0.0 4 12517 2025-12-26 21:57:14 0 NULL 2 2025-12-26 21:58:39 12516 0 NULL
280 500 POF-1490 INVF-1490 13438 12554 2 1 160 10880.0 0.0 217.6 0.0 0.0 518.1 10662.4 INR 0.0 0.36 0.0 4 13438 2025-12-26 22:14:06 0 NULL 1 2025-12-26 22:16:47 12554 0 NULL
281 501 POF-1491 INVF-1491 12555 12554 2 1 30 4770.0 0.0 95.4 363.81 363.81 0.0 4674.6 INR 0.0 0.36 0.0 4 12555 2025-12-26 22:30:02 0 NULL 1 2025-12-26 22:30:34 12554 0 NULL
282 502 POF-1492 INVF-1492 12555 12554 2 1 30 4770.0 0.0 95.4 363.81 363.81 0.0 4674.6 INR 0.0 0.33 0.0 4 12555 2025-12-26 22:41:03 0 NULL 1 2025-12-26 22:41:25 12554 0 NULL
283 503 POF-1493 INVF-1493 12542 12554 2 1 6 7516.0 0.0 150.32 0.0 0.0 475.21 7365.68 INR 0.0 0.8 0.0 4 12542 2025-12-26 22:59:07 0 NULL 1 2025-12-26 22:59:32 12554 0 NULL
284 504 POF-1494 INVF-1494 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-26 23:11:55 0 NULL 1 2025-12-26 23:12:17 12554 0 NULL
285 505 POF-1495 INVF-1495 12554 12516 2 1 250 50300.0 0.0 2515.0 1197.62 1197.62 0.0 47785.0 INR 0.0 5.0 0.0 4 12554 2025-12-27 08:43:06 0 NULL 1 2025-12-27 08:47:03 12516 0 NULL
286 506 POF-1496 INVF-1496 12516 1 2 1 50 37500.0 0.0 3000.0 892.86 892.86 0.0 34500.0 INR 0.0 5.0 0.0 4 12516 2025-12-27 08:44:34 0 NULL 1 2025-12-27 08:46:39 1 0 NULL
287 507 POF-1497 INVF-1497 12555 12554 2 1 210 20300.0 0.0 406.0 483.33 483.33 0.0 19894.0 INR 0.0 1.0 0.0 4 12555 2025-12-27 09:15:36 0 NULL 1 2025-12-27 09:15:57 12554 0 NULL
288 508 POF-1498 INVF-1498 12542 12554 2 1 375 29245.0 0.0 584.9 0.0 0.0 2531.04 28660.1 INR 0.0 0.22 0.0 4 12542 2025-12-27 16:47:29 0 NULL 1 2025-12-27 16:47:47 12554 0 NULL
289 509 POF-1499 INVF-1499 12554 12516 2 1 30 239400.0 0.0 11970.0 3486.41 3486.41 0.0 227430.0 INR 0.0 60.0 0.0 4 12554 2025-12-27 16:54:24 0 NULL 1 2025-12-27 16:55:45 12516 0 NULL
290 510 POF-1500 INVF-1500 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-27 16:55:21 0 NULL 1 2025-12-27 16:55:31 1 0 NULL
291 511 POF-1501 INVF-1501 12542 12554 2 1 2 15960.0 0.0 319.2 0.0 0.0 464.85 15640.8 INR 0.0 4.0 0.0 4 12542 2025-12-27 16:56:02 0 NULL 1 2025-12-27 16:56:13 12554 0 NULL
292 512 POF-1502 INVF-1502 12542 12554 2 1 1 7980.0 0.0 159.6 0.0 0.0 232.43 7820.4 INR 0.0 2.0 0.0 4 12542 2025-12-27 17:04:56 0 NULL 1 2025-12-27 20:01:22 12554 0 NULL
293 513 POF-1503 INVF-1503 13438 12554 2 1 2 718.0 0.0 14.36 0.0 0.0 70.41 703.64 INR 0.0 0.01 0.0 4 13438 2025-12-27 20:00:35 0 NULL 1 2025-12-27 20:01:22 12554 0 NULL
294 514 POF-1504 INVF-1504 13438 12554 2 1 1 7980.0 0.0 159.6 0.0 0.0 232.43 7820.4 INR 0.0 2.0 0.0 4 13438 2025-12-27 20:13:25 0 NULL 1 2025-12-27 20:14:32 12554 0 NULL
295 515 POF-1505 INVF-1505 12542 12554 2 1 5 39900.0 0.0 798.0 0.0 0.0 1162.14 39102.0 INR 0.0 10.0 0.0 4 12542 2025-12-29 10:45:08 0 NULL 1 2025-12-29 11:23:09 12554 0 NULL
296 516 POF-1506 INVF-1506 12554 12516 2 1 10 79800.0 0.0 3990.0 1162.14 1162.14 0.0 75810.0 INR 0.0 20.0 0.0 4 12554 2025-12-29 10:58:37 0 NULL 1 2025-12-29 11:00:59 12516 0 NULL
297 517 POF-1507 INVF-1507 12516 1 2 1 1 7980.0 0.0 638.4 116.21 116.21 0.0 7341.6 INR 0.0 2.0 0.0 4 12516 2025-12-29 10:59:11 0 NULL 1 2025-12-29 10:59:27 1 0 NULL
298 518 POF-1508 INVF-1508 12516 1 2 1 5 39900.0 0.0 3192.0 581.07 581.07 0.0 36708.0 INR 0.0 10.0 0.0 4 12516 2025-12-29 11:00:17 0 NULL 1 2025-12-29 11:00:38 1 0 NULL
299 519 POF-1509 INVF-1509 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-29 13:03:02 0 NULL 1 2025-12-29 13:03:38 12554 0 NULL
300 520 POF-1510 INVF-1510 12554 12516 2 1 30 22500.0 0.0 1125.0 535.71 535.71 0.0 21375.0 INR 0.0 3.0 0.0 4 12554 2025-12-30 11:22:32 0 NULL 1 2025-12-30 11:28:38 12516 0 NULL