fx_franchise_order_product

4,933 rows · 33 columns · page 73 / 99

Invoice view Excel export
# id sr_no order_id userid product_id product_name prod_desc hsn_no product_qty product_bv product_MRP discount_per discount_amount prod_dis_amt prod_before_gst_amt prod_gst_amount total_mrp total_bv total_price cgst_per cgst_amount sgst_per sgst_amount igst_per igst_amount total_before_gst_amount total_gst_amount final_amount _currency fr_category comm_per comm_amount created_on
3601 3614 3 870 12526 39 Fabric Wash 1000ml NULL 34029099 5 0.0 401.0 0.0 0.0 321.0 272.03 48.97 2005.0 0.0 1605.0 9.0 122.42 9.0 122.42 0.0 0.0 1360.17 244.83 1605.0 INR 3 2.0 27.2 2026-01-31 00:12:12
3602 3615 4 870 12526 34 Herbo2o Toothpaste NULL 33061090 12 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2388.0 0.0 1908.0 9.0 145.53 9.0 145.53 0.0 0.0 1616.95 291.05 1908.0 INR 3 2.0 32.34 2026-01-31 00:12:12
3603 3616 5 870 12526 17 Memory Booster Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-31 00:12:12
3604 3617 6 870 12526 7 Morning Fresh Churan NULL 30049011 2 0.0 199.0 0.0 0.0 159.0 151.43 7.57 398.0 0.0 318.0 2.5 7.57 2.5 7.57 0.0 0.0 302.86 15.14 318.0 INR 3 2.0 6.06 2026-01-31 00:12:12
3605 3618 7 870 12526 32 Neem Soap 100gm NULL 34011110 15 0.0 60.0 0.0 0.0 48.0 45.71 2.29 900.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-31 00:12:12
3606 3619 8 870 12526 28 Ortho Joint Shield NULL 2009899 3 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 4497.0 0.0 3600.0 2.5 85.71 2.5 85.71 0.0 0.0 3428.57 171.43 3600.0 INR 3 2.0 68.57 2026-01-31 00:12:12
3607 3620 9 870 12526 72 Pain Relief Patch NULL 30051090 3 0.0 800.0 0.0 0.0 600.0 571.43 28.57 2400.0 0.0 1800.0 2.5 42.86 2.5 42.86 0.0 0.0 1714.29 85.71 1800.0 INR 3 2.0 34.29 2026-01-31 00:12:12
3608 3621 10 870 12526 35 Sanitary Pad (15 pcs) NULL 9619001 3 0.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 0.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 912.0 0.0 912.0 INR 3 2.0 18.24 2026-01-31 00:12:12
3609 3622 1 871 12516 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 1 0.0 0.0 2026-01-31 13:25:20
3610 3623 1 872 12554 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 2 0.0 0.0 2026-01-31 13:25:59
3611 3624 1 873 12555 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 3 0.0 0.0 2026-01-31 13:26:38
3612 3625 1 874 12516 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 4 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 74800.0 0.0 42800.0 2.5 1019.05 2.5 1019.05 0.0 0.0 40761.9 2038.1 42800.0 INR 1 0.0 0.0 2026-01-31 13:33:35
3613 3626 1 875 12517 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 0.0 0.0 0.0 0.0 5.0 509.52 10190.48 509.52 10700.0 INR 2 0.0 0.0 2026-01-31 13:39:06
3614 3627 1 876 12554 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 2 0.0 0.0 2026-01-31 13:55:44
3615 3628 1 877 12555 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 3 0.0 0.0 2026-01-31 13:56:23
3616 3629 1 878 12555 20 Premium Berry Juice 1000ml NULL 2936900 5 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 17495.0 0.0 13000.0 2.5 309.52 2.5 309.52 0.0 0.0 12380.95 619.05 13000.0 INR 3 2.0 247.62 2026-01-31 14:00:54
3617 3630 1 879 12554 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 2 0.0 0.0 2026-01-31 14:10:48
3618 3631 1 880 12555 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 1 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 18700.0 0.0 10700.0 2.5 254.76 2.5 254.76 0.0 0.0 10190.48 509.52 10700.0 INR 3 0.0 0.0 2026-01-31 14:12:23
3619 3632 1 881 12548 38 Dish Wash 500ml NULL 34029099 5 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 0.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 779.66 140.34 920.0 INR 3 2.0 15.59 2026-01-31 15:32:23
3620 3633 2 881 12548 39 Fabric Wash 1000ml NULL 34029099 2 0.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 0.0 642.0 9.0 48.97 9.0 48.97 0.0 0.0 544.07 97.93 642.0 INR 3 2.0 10.88 2026-01-31 15:32:23
3621 3634 3 881 12548 37 Floor Cleaner 500ml NULL 3924101 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 9.0 60.64 9.0 60.64 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-31 15:32:23
3622 3635 4 881 12548 33 Herbal Soap 100gm NULL 30049011 30 0.0 100.0 0.0 0.0 80.0 76.19 3.81 3000.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.72 114.29 2400.0 INR 3 2.0 45.71 2026-01-31 15:32:23
3623 3636 5 881 12548 34 Herbo2o Toothpaste NULL 33061090 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 9.0 60.64 9.0 60.64 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-31 15:32:23
3624 3637 1 882 12516 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 5 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 93500.0 0.0 53500.0 2.5 1273.81 2.5 1273.81 0.0 0.0 50952.38 2547.62 53500.0 INR 1 0.0 0.0 2026-01-31 17:11:37
3625 3638 1 883 12554 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 5 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 93500.0 0.0 53500.0 2.5 1273.81 2.5 1273.81 0.0 0.0 50952.38 2547.62 53500.0 INR 2 0.0 0.0 2026-01-31 17:12:05
3626 3639 1 884 12555 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 3 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 56100.0 0.0 32100.0 2.5 764.29 2.5 764.29 0.0 0.0 30571.43 1528.57 32100.0 INR 3 0.0 0.0 2026-01-31 17:12:56
3627 3640 1 885 12555 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 2 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 37400.0 0.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 3 0.0 0.0 2026-01-31 17:16:09
3628 3641 1 886 12534 84 B AND B NULL 94041000 2 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 25998.0 0.0 21000.0 2.5 500.0 2.5 500.0 0.0 0.0 20000.0 1000.0 21000.0 INR 3 0.0 150.0 2026-01-31 17:29:07
3629 3642 1 887 12516 92 MANIRAYA DOUBLE WELLNESS COMBO NULL NULL 20 0.0 34001.0 0.0 0.0 18500.0 17619.05 880.95 680020.0 0.0 370000.0 2.5 8809.52 2.5 8809.52 0.0 0.0 352380.95 17619.05 370000.0 INR 1 0.0 0.0 2026-01-31 17:30:46
3630 3643 2 887 12516 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 150 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 2805000.0 0.0 1605000.0 2.5 38214.29 2.5 38214.29 0.0 0.0 1528571.43 76428.57 1605000.0 INR 1 0.0 0.0 2026-01-31 17:30:46
3631 3644 1 888 12517 91 MANIRAYA SINGLE WELLNESS COMBO NULL NULL 100 0.0 18700.0 0.0 0.0 10700.0 10190.48 509.52 1870000.0 0.0 1070000.0 0.0 0.0 0.0 0.0 5.0 50952.38 1019047.62 50952.38 1070000.0 INR 2 0.0 300.0 2026-01-31 18:55:11
3632 3645 1 889 14490 48 glow face wash NULL 3304999 5 0.0 380.0 0.0 0.0 304.0 257.63 46.37 1900.0 0.0 1520.0 9.0 115.93 9.0 115.93 0.0 0.0 1288.14 231.86 1520.0 INR 3 2.0 25.76 2026-01-31 19:04:03
3633 3646 2 889 14490 61 Radiation chip NULL 902221 2 0.0 999.0 0.0 0.0 500.0 423.73 76.27 1998.0 0.0 1000.0 9.0 76.27 9.0 76.27 0.0 0.0 847.46 152.54 1000.0 INR 3 2.0 16.95 2026-01-31 19:04:03
3634 3647 3 889 14490 32 Neem Soap 100gm NULL 34011110 30 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1800.0 0.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-01-31 19:04:03
3635 3648 1 890 12526 48 glow face wash NULL 3304999 1 0.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 0.0 304.0 9.0 23.19 9.0 23.19 0.0 0.0 257.63 46.37 304.0 INR 3 2.0 5.15 2026-01-31 20:09:21
3636 3649 1 891 12526 48 glow face wash NULL 3304999 9 0.0 380.0 0.0 0.0 304.0 257.63 46.37 3420.0 0.0 2736.0 9.0 208.68 9.0 208.68 0.0 0.0 2318.64 417.36 2736.0 INR 3 2.0 46.37 2026-01-31 21:01:36
3637 3650 2 891 12526 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 2500.0 0.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 1904.76 95.24 2000.0 INR 3 2.0 38.1 2026-01-31 21:01:36
3638 3651 3 891 12526 6 Asthma Care NULL 30049011 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-31 21:01:36
3639 3652 4 891 12526 3 BP Care Capsules NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-31 21:01:36
3640 3653 5 891 12526 4 Diabetic Care Capsules NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-31 21:01:36
3641 3654 6 891 12526 38 Dish Wash 500ml NULL 34029099 5 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 0.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 779.66 140.34 920.0 INR 3 2.0 15.59 2026-01-31 21:01:36
3642 3655 7 891 12526 37 Floor Cleaner 500ml NULL 3924101 5 0.0 199.0 0.0 0.0 159.0 134.75 24.25 995.0 0.0 795.0 9.0 60.64 9.0 60.64 0.0 0.0 673.73 121.27 795.0 INR 3 2.0 13.47 2026-01-31 21:01:36
3643 3656 8 891 12526 60 Foot patch NULL 30051090 1 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 1999.0 0.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1522.86 76.14 1599.0 INR 3 2.0 30.46 2026-01-31 21:01:36
3644 3657 9 891 12526 33 Herbal Soap 100gm NULL 30049011 50 0.0 100.0 0.0 0.0 80.0 76.19 3.81 5000.0 0.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.53 190.48 4000.0 INR 3 2.0 76.19 2026-01-31 21:01:36
3645 3658 10 891 12526 18 Lady Care Juice 500ml NULL 2009899 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-01-31 21:01:36
3646 3659 11 891 12526 17 Memory Booster Juice NULL 2009899 1 0.0 349.0 0.0 0.0 279.0 265.71 13.29 349.0 0.0 279.0 2.5 6.64 2.5 6.64 0.0 0.0 265.71 13.29 279.0 INR 3 2.0 5.31 2026-01-31 21:01:36
3647 3660 12 891 12526 32 Neem Soap 100gm NULL 34011110 100 0.0 60.0 0.0 0.0 48.0 45.71 2.29 6000.0 0.0 4800.0 2.5 114.29 2.5 114.29 0.0 0.0 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-01-31 21:01:36
3648 3661 13 891 12526 28 Ortho Joint Shield NULL 2009899 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-01-31 21:01:36
3649 3662 14 891 12526 12 P RADIANCE FACE SERUM NULL 33049990 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-01-31 21:01:36
3650 3663 15 891 12526 8 Piles Care NULL 30049011 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-01-31 21:01:36