fx_franchise_order

1,057 rows · 31 columns · page 8 / 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
351 571 POF-1561 INVF-1561 12554 12516 2 1 1 7500.0 0.0 375.0 178.57 178.57 0.0 7125.0 INR 0.0 1.5 0.0 4 12554 2026-01-02 23:27:23 0 NULL 1 2026-01-02 23:27:45 12516 0 NULL
352 572 POF-1562 INVF-1562 12555 12554 2 1 1 7500.0 0.0 150.0 178.57 178.57 0.0 7350.0 INR 0.0 1.5 0.0 4 12555 2026-01-02 23:29:35 0 NULL 1 2026-01-02 23:30:26 12554 0 NULL
353 573 POF-1563 INVF-1563 12555 12554 2 1 5 6250.0 0.0 125.0 148.81 148.81 0.0 6125.0 INR 0.0 1.25 0.0 4 12555 2026-01-02 23:39:12 0 NULL 1 2026-01-02 23:39:34 12554 0 NULL
354 574 POF-1564 INVF-1564 12555 12554 2 1 1 7980.0 0.0 159.6 116.21 116.21 0.0 7820.4 INR 0.0 2.0 0.0 4 12555 2026-01-02 23:59:43 0 NULL 1 2026-01-03 00:00:02 12554 0 NULL
355 575 POF-1565 INVF-1565 12555 12554 2 1 3 1500.0 0.0 30.0 114.41 114.41 0.0 1470.0 INR 0.0 0.3 0.0 4 12555 2026-01-03 14:45:08 0 NULL 1 2026-01-03 14:45:23 12554 0 NULL
356 576 POF-1566 INVF-1566 12554 12516 2 1 5 2500.0 0.0 125.0 190.68 190.68 0.0 2375.0 INR 0.0 0.5 0.0 4 12554 2026-01-03 16:17:04 0 NULL 1 2026-01-03 16:17:15 12516 0 NULL
357 577 POF-1567 INVF-1567 12555 12554 2 1 3 1500.0 0.0 30.0 114.41 114.41 0.0 1470.0 INR 0.0 0.3 0.0 4 12555 2026-01-03 16:17:37 0 NULL 1 2026-01-03 16:17:49 12554 0 NULL
358 578 POF-1568 INVF-1568 12555 12554 2 1 1 7980.0 0.0 159.6 116.21 116.21 0.0 7820.4 INR 0.0 2.0 0.0 4 12555 2026-01-03 16:37:10 0 NULL 1 2026-01-03 16:37:24 12554 0 NULL
359 579 POF-1569 INVF-1569 12554 12516 2 1 5 8250.0 0.0 412.5 196.43 196.43 0.0 7837.5 INR 0.0 1.5 0.0 4 12554 2026-01-03 16:46:21 0 NULL 1 2026-01-03 16:46:40 12516 0 NULL
360 580 POF-1570 INVF-1570 12555 12554 2 1 10 16500.0 0.0 330.0 392.86 392.86 0.0 16170.0 INR 0.0 3.0 0.0 4 12555 2026-01-03 16:47:15 0 NULL 1 2026-01-03 16:47:27 12554 0 NULL
361 581 POF-1571 INVF-1571 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 2026-01-03 18:04:20 0 NULL 1 2026-01-03 18:04:32 12554 0 NULL
362 582 POFN-1572 INVFN-1572 12555 12554 2 1 1 48.0 0.0 0.91 1.14 1.14 0.0 47.09 INR 0.0 0.01 0.0 4 12555 2026-01-03 22:01:43 0 NULL 1 2026-01-03 22:08:47 12554 0 NULL
363 583 POFN-1573 INVFN-1573 12554 12516 2 1 1 48.0 0.0 2.74 1.14 1.14 0.0 45.26 INR 0.0 0.01 0.0 4 12554 2026-01-03 22:03:29 0 NULL 2 2026-01-05 15:12:42 12516 0 NULL
364 584 POFN-1574 INVFN-1574 12554 12516 2 1 1 1250.0 0.0 71.43 29.76 29.76 0.0 1178.57 INR 0.0 0.25 0.0 4 12554 2026-01-03 22:04:12 0 NULL 2 2026-01-05 15:12:42 12516 0 NULL
365 585 POFN-1575 INVFN-1575 12518 12517 2 1 185 20127.0 0.0 353.94 701.44 701.44 0.0 19773.06 INR 0.0 0.25 0.0 4 12518 2026-01-03 22:21:25 0 NULL 1 2026-01-05 14:17:52 12517 0 NULL
366 586 POFN-1576 INVFN-1576 12545 12517 2 1 120 9580.0 0.0 177.47 353.21 353.21 0.0 9402.53 INR 0.0 0.3 0.0 4 12545 2026-01-04 11:08:14 0 NULL 1 2026-01-04 11:22:51 12517 0 NULL
367 587 POFN-1577 INVFN-1577 12517 12516 2 1 1 559.0 0.0 30.77 0.0 0.0 46.16 528.23 INR 0.0 0.11 0.0 4 12517 2026-01-04 21:40:06 0 NULL 1 2026-01-04 21:40:33 12516 0 NULL
368 588 POFN-1578 INVFN-1578 12549 12517 2 1 14 3630.0 0.0 64.4 204.95 204.95 0.0 3565.6 INR 0.0 0.15 0.0 4 12549 2026-01-04 21:45:26 0 NULL 1 2026-01-04 21:46:15 12517 0 NULL
369 589 POFN-1579 INVFN-1579 12549 12517 2 1 14 3630.0 0.0 64.79 195.18 195.18 0.0 3565.21 INR 0.0 0.15 0.0 4 12549 2026-01-05 14:09:40 0 NULL 1 2026-01-05 14:12:44 12517 0 NULL
370 590 POFN-1580 INVFN-1580 12685 12517 2 1 30 14239.0 0.0 266.73 451.13 451.13 0.0 13972.27 INR 0.0 0.02 0.0 4 12685 2026-01-05 20:06:58 0 NULL 1 2026-01-05 21:00:44 12517 0 NULL
371 591 POFN-1581 INVFN-1581 12548 12517 2 1 187 17938.0 0.0 335.74 575.51 575.51 0.0 17602.26 INR 0.0 0.03 0.0 4 12548 2026-01-05 20:53:19 0 NULL 1 2026-01-05 21:00:37 12517 0 NULL
372 592 POFN-1582 INVFN-1582 12547 12517 2 1 120 8422.0 0.0 160.42 200.53 200.53 0.0 8261.58 INR 0.0 0.4 0.0 4 12547 2026-01-05 21:07:42 0 NULL 1 2026-01-05 21:20:54 12517 0 NULL
373 593 POFN-1583 INVFN-1583 12543 12517 2 1 3 612.0 0.0 11.66 14.57 14.57 0.0 600.34 INR 0.0 0.12 0.0 4 12543 2026-01-05 22:33:36 0 NULL 1 2026-01-06 15:37:49 12517 0 NULL
374 594 POFN-1584 INVFN-1584 12549 12517 2 1 10 4166.0 0.0 78.35 124.22 124.22 0.0 4087.65 INR 0.0 0.12 0.0 4 12549 2026-01-06 12:03:33 0 NULL 1 2026-01-06 12:05:29 12517 0 NULL
375 595 POFN-1585 INVFN-1585 12552 12517 2 1 13 3469.0 0.0 64.9 111.92 111.92 0.0 3404.1 INR 0.0 0.11 0.0 4 12552 2026-01-06 12:12:05 0 NULL 1 2026-01-06 12:26:22 12517 0 NULL
376 596 POFN-1586 INVFN-1586 12549 12517 2 1 17 4116.0 0.0 74.88 185.98 185.98 0.0 4041.12 INR 0.0 0.11 0.0 4 12549 2026-01-06 12:24:02 0 NULL 1 2026-01-06 12:58:19 12517 0 NULL
377 597 POFN-1587 INVFN-1587 12516 1 2 1 3 31500.0 0.0 1200.0 750.0 750.0 0.0 30300.0 INR 0.0 9.0 0.0 4 12516 2026-01-06 15:43:54 0 NULL 1 2026-01-06 15:56:21 1 0 NULL
378 598 POFN-1588 INVFN-1588 12516 1 2 1 20 40000.0 0.0 3106.8 582.52 582.52 0.0 36893.2 INR 0.0 8.0 0.0 4 12516 2026-01-06 15:55:40 0 NULL 1 2026-01-06 15:56:21 1 0 NULL
379 599 POFN-1589 INVFN-1589 12517 12516 2 1 10 20000.0 0.0 1165.05 0.0 0.0 582.52 18834.95 INR 0.0 4.0 0.0 4 12517 2026-01-06 16:02:16 0 NULL 1 2026-01-06 16:02:30 12516 0 NULL
380 600 POFN-1590 INVFN-1590 12517 12516 2 1 3 31500.0 0.0 900.0 0.0 0.0 1500.0 30600.0 INR 0.0 9.0 0.0 4 12517 2026-01-06 18:01:56 0 NULL 1 2026-01-06 18:02:12 12516 0 NULL
381 601 POFN-1591 INVFN-1591 13438 12554 2 1 6 3705.0 0.0 68.16 0.0 0.0 296.78 3636.84 INR 0.0 0.4 0.0 4 13438 2026-01-06 18:29:46 0 NULL 1 2026-01-06 21:07:35 12554 0 NULL
382 602 POFN-1592 INVFN-1592 12516 1 2 1 19 274500.0 0.0 8600.0 6535.71 6535.71 0.0 265900.0 INR 0.0 27.0 0.0 4 12516 2026-01-06 19:56:40 0 NULL 1 2026-01-06 19:58:44 1 0 NULL
383 603 POFN-1593 INVFN-1593 12517 12516 2 1 12 163500.0 0.0 4100.0 0.0 0.0 7785.71 159400.0 INR 0.0 21.0 0.0 4 12517 2026-01-06 20:02:00 0 NULL 1 2026-01-06 20:02:58 12516 0 NULL
384 604 POFN-1594 INVFN-1594 12549 12517 2 1 7 2605.0 0.0 48.98 77.97 77.97 0.0 2556.02 INR 0.0 0.45 0.0 4 12549 2026-01-06 20:06:40 0 NULL 1 2026-01-06 20:31:28 12517 0 NULL
385 605 POFN-1595 INVFN-1595 12555 12554 2 1 10 1590.0 0.0 26.95 121.27 121.27 0.0 1563.05 INR 0.0 0.11 0.0 4 12555 2026-01-06 21:06:59 0 NULL 1 2026-01-06 21:08:22 12554 0 NULL
386 606 POFN-1596 INVFN-1596 12541 12517 2 1 12 4479.0 0.0 82.02 188.91 188.91 0.0 4396.98 INR 0.0 0.4 0.0 4 12541 2026-01-06 21:10:17 0 NULL 1 2026-01-06 21:32:10 12517 0 NULL
387 607 POFN-1597 INVFN-1597 12533 12517 2 1 1 10500.0 0.0 150.0 250.0 250.0 0.0 10350.0 INR 0.0 3.0 0.0 4 12533 2026-01-07 10:37:40 0 NULL 1 2026-01-07 10:46:46 12517 0 NULL
388 608 POFN-1598 INVFN-1598 12545 12517 2 1 2 18720.0 0.0 213.71 445.71 445.71 0.0 18506.29 INR 0.0 0.15 0.0 4 12545 2026-01-07 11:12:01 0 NULL 1 2026-01-07 11:16:55 12517 0 NULL
389 609 POFN-1599 INVFN-1599 12526 12517 2 1 2 20400.0 0.0 300.0 0.0 0.0 2010.17 20100.0 INR 0.0 3.0 0.0 4 12526 2026-01-07 16:23:06 0 NULL 1 2026-01-07 17:22:40 12517 0 NULL
390 610 POFN-1600 INVFN-1600 12518 12517 2 1 39 15603.0 0.0 285.41 0.0 0.0 1332.41 15317.59 INR 0.0 0.06 0.0 4 12518 2026-01-07 16:39:49 0 NULL 1 2026-01-07 17:22:37 12517 0 NULL
391 611 POFN-1601 INVFN-1601 12555 12554 2 1 5 5750.0 0.0 109.52 136.9 136.9 0.0 5640.48 INR 0.0 1.25 0.0 4 12555 2026-01-07 16:42:40 0 NULL 1 2026-01-07 16:45:21 12554 0 NULL
392 612 POFN-1602 INVFN-1602 12554 12516 2 1 30 36000.0 0.0 2057.14 857.14 857.14 0.0 33942.86 INR 0.0 3.75 0.0 4 12554 2026-01-07 16:44:29 0 NULL 1 2026-01-07 16:44:42 12516 0 NULL
393 613 POFN-1603 INVFN-1603 12555 12554 2 1 10 12500.0 0.0 238.1 297.62 297.62 0.0 12261.9 INR 0.0 2.5 0.0 4 12555 2026-01-07 16:45:06 0 NULL 1 2026-01-07 16:45:21 12554 0 NULL
394 614 POFN-1604 INVFN-1604 12518 12517 2 1 15 2385.0 0.0 40.42 0.0 0.0 363.81 2344.58 INR 0.0 0.38 0.0 4 12518 2026-01-07 16:46:34 0 NULL 1 2026-01-07 17:22:33 12517 0 NULL
395 615 POFN-1605 INVFN-1605 12555 12554 2 1 15 17750.0 0.0 338.1 422.62 422.62 0.0 17411.9 INR 0.0 2.5 0.0 4 12555 2026-01-07 17:17:06 0 NULL 1 2026-01-07 17:17:16 12554 0 NULL
396 616 POFN-1606 INVFN-1606 12554 12516 2 1 6 7500.0 0.0 428.57 178.57 178.57 0.0 7071.43 INR 0.0 1.5 0.0 4 12554 2026-01-07 17:17:52 0 NULL 1 2026-01-07 17:18:07 12516 0 NULL
397 617 POFN-1607 INVFN-1607 12555 12554 2 1 5 6250.0 0.0 119.05 148.81 148.81 0.0 6130.95 INR 0.0 1.25 0.0 4 12555 2026-01-07 17:19:28 0 NULL 1 2026-01-07 17:19:44 12554 0 NULL
398 618 POFN-1608 INVFN-1608 12554 12516 2 1 1 10500.0 0.0 300.0 250.0 250.0 0.0 10200.0 INR 0.0 3.0 0.0 4 12554 2026-01-07 18:11:09 0 NULL 1 2026-01-07 18:11:21 12516 0 NULL
399 619 POFN-1609 INVFN-1609 12555 12554 2 1 2 10548.0 0.0 150.91 251.14 251.14 0.0 10397.09 INR 0.0 0.01 0.0 4 12555 2026-01-07 18:11:43 0 NULL 1 2026-01-07 18:11:52 12554 0 NULL
400 620 POFN-1610 INVFN-1610 12546 12517 2 1 92 28555.0 0.0 484.68 0.0 0.0 1821.11 28070.32 INR 0.0 0.11 0.0 4 12546 2026-01-07 19:23:04 0 NULL 1 2026-01-08 14:04:42 12517 0 NULL