fx_franchise_order

1,057 rows · 31 columns · page 7 / 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
301 521 POF-1511 INVF-1511 12516 1 2 1 40 30000.0 0.0 2400.0 714.29 714.29 0.0 27600.0 INR 0.0 4.0 0.0 4 12516 2025-12-30 11:24:31 0 NULL 1 2025-12-30 11:24:41 1 0 NULL
302 522 POF-1512 INVF-1512 12555 12554 2 1 30 22500.0 0.0 450.0 535.71 535.71 0.0 22050.0 INR 0.0 3.0 0.0 4 12555 2025-12-30 11:31:11 0 NULL 1 2025-12-30 11:31:29 12554 0 NULL
303 523 POF-1513 INVF-1513 12555 12554 2 1 10 7200.0 0.0 144.0 171.43 171.43 0.0 7056.0 INR 0.0 1.5 0.0 4 12555 2025-12-30 16:58:51 0 NULL 1 2025-12-30 16:59:04 12554 0 NULL
304 524 POF-1514 INVF-1514 12555 12554 2 1 50 6000.0 0.0 120.0 457.63 457.63 0.0 5880.0 INR 0.0 0.55 0.0 4 12555 2025-12-30 18:37:35 0 NULL 1 2025-12-30 18:37:58 12554 0 NULL
305 525 POF-1515 INVF-1515 12555 12554 2 1 500 24000.0 0.0 480.0 571.43 571.43 0.0 23520.0 INR 0.0 3.0 0.0 4 12555 2025-12-30 22:52:30 0 NULL 1 2025-12-30 22:55:46 12554 0 NULL
306 526 POF-1516 INVF-1516 12554 12516 2 1 1000 48000.0 0.0 2400.0 1142.86 1142.86 0.0 45600.0 INR 0.0 6.0 0.0 4 12554 2025-12-30 22:53:18 0 NULL 1 2025-12-30 22:55:23 12516 0 NULL
307 527 POF-1517 INVF-1517 12516 1 2 1 1500 72000.0 0.0 5760.0 1714.29 1714.29 0.0 66240.0 INR 0.0 9.0 0.0 4 12516 2025-12-30 22:54:07 0 NULL 1 2025-12-30 22:54:59 1 0 NULL
308 528 POF-1518 INVF-1518 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-31 11:26:11 0 NULL 1 2025-12-31 11:36:59 12554 0 NULL
309 529 POF-1519 INVF-1519 12555 12554 2 1 15 119700.0 0.0 2394.0 1743.2 1743.2 0.0 117306.0 INR 0.0 30.0 0.0 4 12555 2025-12-31 12:02:14 0 NULL 1 2025-12-31 12:02:32 12554 0 NULL
310 530 POF-1520 INVF-1520 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 2026-01-01 13:22:12 0 NULL 1 2026-01-01 13:22:56 12554 0 NULL
311 531 POF-1521 INVF-1521 12555 12554 2 1 10 7500.0 0.0 150.0 178.57 178.57 0.0 7350.0 INR 0.0 1.0 0.0 4 12555 2026-01-01 13:30:52 0 NULL 1 2026-01-01 13:31:22 12554 0 NULL
312 532 POF-1522 INVF-1522 12542 12554 2 1 10 79800.0 0.0 1596.0 0.0 0.0 2324.27 78204.0 INR 0.0 20.0 0.0 4 12542 2026-01-01 15:28:02 0 NULL 1 2026-01-01 15:47:04 12554 0 NULL
313 533 POF-1523 INVF-1523 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 2026-01-01 15:45:33 0 NULL 1 2026-01-01 15:46:43 12516 0 NULL
314 534 POF-1524 INVF-1524 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 2026-01-01 15:46:16 0 NULL 1 2026-01-01 15:46:30 1 0 NULL
315 535 POF-1525 INVF-1525 12555 12554 2 1 30 309590.0 0.0 6191.8 4508.59 4508.59 0.0 303398.2 INR 0.0 30.0 0.0 4 12555 2026-01-01 16:26:55 0 NULL 1 2026-01-01 16:28:43 12554 0 NULL
316 536 POF-1526 INVF-1526 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 2026-01-01 16:27:51 0 NULL 1 2026-01-01 16:28:18 12516 0 NULL
317 537 POF-1527 INVF-1527 12555 12554 2 1 5 39900.0 0.0 798.0 581.07 581.07 0.0 39102.0 INR 0.0 10.0 0.0 4 12555 2026-01-01 22:47:09 0 NULL 2 2026-01-01 22:50:33 12554 0 NULL
318 538 POF-1528 INVF-1528 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 2026-01-01 22:48:02 0 NULL 1 2026-01-02 11:18:35 12516 0 NULL
319 539 POF-1529 INVF-1529 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 2026-01-01 22:48:42 0 NULL 1 2026-01-02 11:18:27 1 0 NULL
320 540 POF-1530 INVF-1530 12555 12554 2 1 3 23940.0 0.0 478.8 348.64 348.64 0.0 23461.2 INR 0.0 6.0 0.0 4 12555 2026-01-01 22:50:54 0 NULL 1 2026-01-01 22:51:12 12554 0 NULL
321 541 POF-1531 INVF-1531 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 2026-01-02 11:17:13 0 NULL 2 2026-01-02 11:18:37 12516 0 NULL
322 542 POF-1532 INVF-1532 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 2026-01-02 11:20:49 0 NULL 1 2026-01-02 11:21:06 12554 0 NULL
323 543 POF-1533 INVF-1533 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 2026-01-02 16:48:57 0 NULL 1 2026-01-02 16:49:07 1 0 NULL
324 544 POF-1534 INVF-1534 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 2026-01-02 16:49:26 0 NULL 1 2026-01-02 16:49:40 12516 0 NULL
325 545 POF-1535 INVF-1535 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 2026-01-02 16:50:22 0 NULL 1 2026-01-02 16:50:34 12554 0 NULL
326 546 POF-1536 INVF-1536 13438 12554 2 1 3 612.0 0.0 12.24 0.0 0.0 29.14 599.76 INR 0.0 0.12 0.0 4 13438 2026-01-02 17:08:48 0 NULL 1 2026-01-02 17:15:02 12554 0 NULL
327 547 POF-1537 INVF-1537 12554 12516 2 1 10 7500.0 0.0 375.0 178.57 178.57 0.0 7125.0 INR 0.0 1.0 0.0 4 12554 2026-01-02 17:23:29 0 NULL 1 2026-01-02 17:23:41 12516 0 NULL
328 548 POF-1538 INVF-1538 13438 12554 2 1 2 1500.0 0.0 30.0 0.0 0.0 71.43 1470.0 INR 0.0 0.2 0.0 4 13438 2026-01-02 17:27:48 0 NULL 1 2026-01-02 17:29:09 12554 0 NULL
329 549 POF-1539 INVF-1539 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 2026-01-02 17:42:07 0 NULL 1 2026-01-02 17:42:17 12554 0 NULL
330 550 POF-1540 INVF-1540 12554 12516 2 1 10 1590.0 0.0 79.5 121.27 121.27 0.0 1510.5 INR 0.0 0.12 0.0 4 12554 2026-01-02 17:52:14 0 NULL 1 2026-01-02 17:53:04 12516 0 NULL
331 551 POF-1541 INVF-1541 12554 12516 2 1 10 12500.0 0.0 625.0 297.62 297.62 0.0 11875.0 INR 0.0 2.5 0.0 4 12554 2026-01-02 18:01:14 0 NULL 1 2026-01-02 18:01:25 12516 0 NULL
332 552 POF-1542 INVF-1542 12527 12554 2 1 454 105189.0 0.0 2103.78 0.0 0.0 4599.54 103085.22 INR 0.0 0.55 0.0 4 12527 2026-01-02 18:05:33 0 NULL 1 2026-01-02 18:34:05 12554 0 NULL
333 553 POF-1543 INVF-1543 12554 12516 2 1 30 17480.0 0.0 874.0 416.19 416.19 0.0 16606.0 INR 0.0 2.5 0.0 4 12554 2026-01-02 18:07:44 0 NULL 1 2026-01-02 18:07:55 12516 0 NULL
334 554 POF-1544 INVF-1544 12527 12554 2 1 13 8182.0 0.0 163.64 0.0 0.0 389.62 8018.36 INR 0.0 1.25 0.0 4 12527 2026-01-02 18:11:12 0 NULL 1 2026-01-02 18:20:33 12554 0 NULL
335 555 POF-1545 INVF-1545 12554 12516 2 1 1000 64000.0 0.0 3200.0 1523.81 1523.81 0.0 60800.0 INR 0.0 3.0 0.0 4 12554 2026-01-02 18:21:33 0 NULL 1 2026-01-02 18:21:46 12516 0 NULL
336 556 POF-1546 INVF-1546 12554 12516 2 1 110 271410.0 0.0 13570.5 5677.28 5677.28 0.0 257839.5 INR 0.0 2.2 0.0 4 12554 2026-01-02 18:24:32 0 NULL 1 2026-01-02 18:33:45 12516 0 NULL
337 557 POF-1547 INVF-1547 12516 1 2 1 20 159600.0 0.0 12768.0 2324.27 2324.27 0.0 146832.0 INR 0.0 40.0 0.0 4 12516 2026-01-02 18:25:20 0 NULL 1 2026-01-02 18:26:09 1 0 NULL
338 558 POF-1548 INVF-1548 12516 1 2 1 5 74995.0 0.0 5999.6 1092.16 1092.16 0.0 68995.4 INR 0.0 15.0 0.0 4 12516 2026-01-02 18:33:21 0 NULL 1 2026-01-02 18:33:29 1 0 NULL
339 559 POF-1549 INVF-1549 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 2026-01-02 18:51:12 0 NULL 1 2026-01-02 18:51:22 12554 0 NULL
340 560 POF-1550 INVF-1550 13438 12554 2 1 5 32479.0 0.0 649.58 0.0 0.0 1014.98 31829.42 INR 0.0 0.11 0.0 4 13438 2026-01-02 19:04:52 0 NULL 1 2026-01-02 19:15:27 12554 0 NULL
341 561 POF-1551 INVF-1551 12545 12517 2 1 10 2040.0 0.0 40.8 48.57 48.57 0.0 1999.2 INR 0.0 0.4 0.0 4 12545 2026-01-02 20:50:12 0 NULL 1 2026-01-04 11:05:22 12517 0 NULL
342 562 POF-1552 INVF-1552 12542 12554 2 1 1 48.0 0.0 0.96 0.0 0.0 2.29 47.04 INR 0.0 0.01 0.0 4 12542 2026-01-02 20:58:55 0 NULL 1 2026-01-02 23:30:26 12554 0 NULL
343 563 POF-1553 INVF-1553 12516 1 2 1 1 10500.0 0.0 840.0 152.91 152.91 0.0 9660.0 INR 0.0 3.0 0.0 4 12516 2026-01-02 21:12:29 0 NULL 2 2026-04-08 16:48:55 1 0 NULL
344 564 POF-1554 INVF-1554 12516 1 2 1 50 712500.0 0.0 57000.0 10376.21 10376.21 0.0 655500.0 INR 0.0 75.0 0.0 4 12516 2026-01-02 21:14:01 0 NULL 1 2026-01-02 21:15:23 1 0 NULL
345 565 POF-1555 INVF-1555 12516 1 2 1 50 712500.0 0.0 57000.0 10376.21 10376.21 0.0 655500.0 INR 0.0 75.0 0.0 4 12516 2026-01-02 21:15:04 0 NULL 2 2026-04-08 16:48:55 1 0 NULL
346 566 POF-1556 INVF-1556 12542 12554 2 1 12 23460.0 0.0 469.2 0.0 0.0 822.0 22990.8 INR 0.0 1.0 0.0 4 12542 2026-01-02 21:41:09 0 NULL 1 2026-01-02 22:27:47 12554 0 NULL
347 567 POF-1557 INVF-1557 12516 1 2 1 50 399000.0 0.0 31920.0 5810.68 5810.68 0.0 367080.0 INR 0.0 100.0 0.0 4 12516 2026-01-02 22:21:33 0 NULL 1 2026-01-02 22:22:11 1 0 NULL
348 568 POF-1558 INVF-1558 12554 12516 2 1 50 399000.0 0.0 19950.0 5810.68 5810.68 0.0 379050.0 INR 0.0 100.0 0.0 4 12554 2026-01-02 22:23:16 0 NULL 1 2026-01-02 22:23:53 12516 0 NULL
349 569 POF-1559 INVF-1559 12555 12554 2 1 44 351120.0 0.0 7022.4 5113.4 5113.4 0.0 344097.6 INR 0.0 88.0 0.0 4 12555 2026-01-02 22:27:06 0 NULL 1 2026-01-02 22:27:32 12554 0 NULL
350 570 POF-1560 INVF-1560 12516 1 2 1 1 7500.0 0.0 600.0 178.57 178.57 0.0 6900.0 INR 0.0 1.5 0.0 4 12516 2026-01-02 23:26:11 0 NULL 1 2026-01-02 23:26:29 1 0 NULL