fx_franchise_order_product

4,933 rows · 33 columns · page 70 / 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
3451 3464 3 851 12545 32 Neem Soap 100gm NULL 34011110 16 0.0 60.0 0.0 0.0 48.0 45.71 2.29 960.0 0.0 768.0 2.5 18.29 2.5 18.29 0.0 0.0 731.43 36.57 768.0 INR 3 2.0 14.63 2026-01-28 13:42:36
3452 3465 4 851 12545 43 Quench Kiss Lip Balm NULL 3304300 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-28 13:42:36
3453 3466 5 851 12545 46 Root Vitality Hair Oil NULL 3305901 10 0.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 0.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 1942.86 97.14 2040.0 INR 3 2.0 38.86 2026-01-28 13:42:36
3454 3467 6 851 12545 44 Vital Glow Face Scrub NULL 3304300 2 0.0 325.0 0.0 0.0 260.0 220.34 39.66 650.0 0.0 520.0 9.0 39.66 9.0 39.66 0.0 0.0 440.68 79.32 520.0 INR 3 2.0 8.81 2026-01-28 13:42:36
3455 3468 1 852 12534 48 glow face wash NULL 3304999 8 0.0 380.0 0.0 0.0 304.0 257.63 46.37 3040.0 0.0 2432.0 9.0 185.49 9.0 185.49 0.0 0.0 2061.02 370.98 2432.0 INR 3 2.0 41.22 2026-01-28 17:51:07
3456 3469 2 852 12534 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-28 17:51:07
3457 3470 3 852 12534 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-28 17:51:07
3458 3471 4 852 12534 15 KIDNEY CARE 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-28 17:51:07
3459 3472 5 852 12534 16 Liver Care Juice NULL 2009899 3 0.0 349.0 0.0 0.0 279.0 265.71 13.29 1047.0 0.0 837.0 2.5 19.93 2.5 19.93 0.0 0.0 797.14 39.86 837.0 INR 3 2.0 15.94 2026-01-28 17:51:07
3460 3473 6 852 12534 32 Neem Soap 100gm NULL 34011110 20 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1200.0 0.0 960.0 2.5 22.86 2.5 22.86 0.0 0.0 914.29 45.71 960.0 INR 3 2.0 18.29 2026-01-28 17:51:07
3461 3474 7 852 12534 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-28 17:51:07
3462 3475 8 852 12534 12 P RADIANCE FACE SERUM NULL 33049990 2 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 2500.0 0.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-01-28 17:51:07
3463 3476 9 852 12534 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-28 17:51:07
3464 3477 10 852 12534 47 Premium Hair Care Shampoo NULL 3305109 4 0.0 699.0 0.0 0.0 559.0 532.38 26.62 2796.0 0.0 2236.0 2.5 53.24 2.5 53.24 0.0 0.0 2129.52 106.48 2236.0 INR 3 2.0 42.59 2026-01-28 17:51:07
3465 3478 11 852 12534 43 Quench Kiss Lip Balm NULL 3304300 15 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2985.0 0.0 2385.0 9.0 181.91 9.0 181.91 0.0 0.0 2021.19 363.81 2385.0 INR 3 2.0 40.42 2026-01-28 17:51:07
3466 3479 12 852 12534 46 Root Vitality Hair Oil NULL 3305901 6 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1530.0 0.0 1224.0 2.5 29.14 2.5 29.14 0.0 0.0 1165.71 58.29 1224.0 INR 3 2.0 23.31 2026-01-28 17:51:07
3467 3480 13 852 12534 35 Sanitary Pad (15 pcs) NULL 9619001 12 0.0 380.0 0.0 0.0 304.0 304.0 0.0 4560.0 0.0 3648.0 0.0 0.0 0.0 0.0 0.0 0.0 3648.0 0.0 3648.0 INR 3 2.0 72.96 2026-01-28 17:51:07
3468 3481 14 852 12534 50 Sun Screen NULL 330499 5 0.0 699.0 0.0 0.0 559.0 473.73 85.27 3495.0 0.0 2795.0 9.0 213.18 9.0 213.18 0.0 0.0 2368.64 426.36 2795.0 INR 3 2.0 47.37 2026-01-28 17:51:07
3469 3482 15 852 12534 36 Toilet Cleaner 500ml NULL 3924101 5 0.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 0.0 600.0 9.0 45.76 9.0 45.76 0.0 0.0 508.47 91.53 600.0 INR 3 2.0 10.17 2026-01-28 17:51:07
3470 3483 1 853 12523 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-28 18:02:24
3471 3484 2 853 12523 70 Premium Hand belt NULL 9404 1 0.0 9999.0 0.0 0.0 1440.0 1371.43 68.57 9999.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-28 18:02:24
3472 3485 3 853 12523 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-28 18:02:24
3473 3486 4 853 12523 37 Floor Cleaner 500ml NULL 3924101 6 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1194.0 0.0 954.0 9.0 72.76 9.0 72.76 0.0 0.0 808.47 145.53 954.0 INR 3 2.0 16.17 2026-01-28 18:02:24
3474 3487 5 853 12523 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-28 18:02:24
3475 3488 6 853 12523 34 Herbo2o Toothpaste NULL 33061090 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.0 1590.0 9.0 121.27 9.0 121.27 0.0 0.0 1347.46 242.54 1590.0 INR 3 2.0 26.95 2026-01-28 18:02:24
3476 3489 7 853 12523 18 Lady Care Juice 500ml NULL 2009899 4 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 5996.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-28 18:02:24
3477 3490 8 853 12523 7 Morning Fresh Churan NULL 30049011 10 0.0 199.0 0.0 0.0 159.0 151.43 7.57 1990.0 0.0 1590.0 2.5 37.86 2.5 37.86 0.0 0.0 1514.29 75.71 1590.0 INR 3 2.0 30.29 2026-01-28 18:02:24
3478 3491 9 853 12523 32 Neem Soap 100gm NULL 34011110 50 0.0 60.0 0.0 0.0 48.0 45.71 2.29 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-28 18:02:24
3479 3492 10 853 12523 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 1 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 1424.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-28 18:02:24
3480 3493 11 853 12523 26 Spirulina Cap NULL 2009899 2 0.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 0.0 1438.0 2.5 34.24 2.5 34.24 0.0 0.0 1369.52 68.48 1438.0 INR 3 2.0 27.39 2026-01-28 18:02:24
3481 3494 12 853 12523 36 Toilet Cleaner 500ml NULL 3924101 7 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1050.0 0.0 840.0 9.0 64.07 9.0 64.07 0.0 0.0 711.86 128.14 840.0 INR 3 2.0 14.24 2026-01-28 18:02:24
3482 3495 13 853 12523 44 Vital Glow Face Scrub NULL 3304300 7 0.0 325.0 0.0 0.0 260.0 220.34 39.66 2275.0 0.0 1820.0 9.0 138.81 9.0 138.81 0.0 0.0 1542.37 277.63 1820.0 INR 3 2.0 30.85 2026-01-28 18:02:24
3483 3496 1 854 13438 72 Pain Relief Patch NULL 30051090 1 0.0 800.0 0.0 0.0 600.0 571.43 28.57 800.0 0.0 600.0 2.5 14.29 2.5 14.29 0.0 0.0 571.43 28.57 600.0 INR 3 2.0 11.43 2026-01-28 18:34:36
3484 3497 2 854 13438 47 Premium Hair Care Shampoo NULL 3305109 1 0.0 699.0 0.0 0.0 559.0 532.38 26.62 699.0 0.0 559.0 2.5 13.31 2.5 13.31 0.0 0.0 532.38 26.62 559.0 INR 3 2.0 10.65 2026-01-28 18:34:36
3485 3498 1 855 12547 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 2.5 1.14 2.5 1.14 0.0 0.0 45.71 2.29 48.0 INR 3 2.0 0.91 2026-01-28 19:57:54
3486 3499 1 856 12516 84 B AND B NULL 94041000 5 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 64995.0 0.0 52500.0 2.5 1250.0 2.5 1250.0 0.0 0.0 50000.0 2500.0 52500.0 INR 1 0.0 400.0 2026-01-29 15:38:38
3487 3500 1 857 12517 84 B AND B NULL 94041000 5 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 64995.0 0.0 52500.0 0.0 0.0 0.0 0.0 5.0 2500.0 50000.0 2500.0 52500.0 INR 2 0.0 300.0 2026-01-29 15:39:04
3488 3501 1 858 12527 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-29 15:53:35
3489 3502 1 859 12527 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-29 16:06:03
3490 3503 1 860 12521 52 Bhoo sanjeevni 5 kg NULL 3103100 2 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 3200.0 0.0 2500.0 2.5 59.52 2.5 59.52 0.0 0.0 2380.95 119.05 2500.0 INR 3 2.0 47.62 2026-01-29 22:20:37
3491 3504 2 860 12521 33 Herbal Soap 100gm NULL 30049011 25 0.0 100.0 0.0 0.0 80.0 76.19 3.81 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-29 22:20:37
3492 3505 3 860 12521 34 Herbo2o Toothpaste NULL 33061090 3 0.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 0.0 477.0 9.0 36.38 9.0 36.38 0.0 0.0 404.24 72.76 477.0 INR 3 2.0 8.08 2026-01-29 22:20:37
3493 3506 4 860 12521 15 KIDNEY CARE 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-29 22:20:37
3494 3507 5 860 12521 25 Manicalcium Tablets NULL 2009899 3 0.0 399.0 0.0 0.0 319.0 303.81 15.19 1197.0 0.0 957.0 2.5 22.79 2.5 22.79 0.0 0.0 911.43 45.57 957.0 INR 3 2.0 18.23 2026-01-29 22:20:37
3495 3508 6 860 12521 7 Morning Fresh Churan NULL 30049011 5 0.0 199.0 0.0 0.0 159.0 151.43 7.57 995.0 0.0 795.0 2.5 18.93 2.5 18.93 0.0 0.0 757.14 37.86 795.0 INR 3 2.0 15.14 2026-01-29 22:20:37
3496 3509 7 860 12521 32 Neem Soap 100gm NULL 34011110 50 0.0 60.0 0.0 0.0 48.0 45.71 2.29 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-29 22:20:37
3497 3510 8 860 12521 9 Omega 369 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-29 22:20:37
3498 3511 9 860 12521 46 Root Vitality Hair Oil NULL 3305901 5 0.0 255.0 0.0 0.0 204.0 194.29 9.71 1275.0 0.0 1020.0 2.5 24.29 2.5 24.29 0.0 0.0 971.43 48.57 1020.0 INR 3 2.0 19.43 2026-01-29 22:20:37
3499 3512 10 860 12521 35 Sanitary Pad (15 pcs) NULL 9619001 6 0.0 380.0 0.0 0.0 304.0 304.0 0.0 2280.0 0.0 1824.0 0.0 0.0 0.0 0.0 0.0 0.0 1824.0 0.0 1824.0 INR 3 2.0 36.48 2026-01-29 22:20:37
3500 3513 11 860 12521 26 Spirulina Cap NULL 2009899 2 0.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 0.0 1438.0 2.5 34.24 2.5 34.24 0.0 0.0 1369.52 68.48 1438.0 INR 3 2.0 27.39 2026-01-29 22:20:37