fx_franchise_order_product

4,933 rows · 33 columns · page 49 / 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
2401 2414 10 552 12527 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 0.0 0.0 0.0 0.0 18.0 426.36 473.73 426.36 2795.0 INR 0 0.0 0.0 2026-01-02 18:05:33
2402 2415 1 553 12554 15 KIDNEY CARE JUICE NULL 2009899 10 0.0 349.0 0.0 0.0 279.0 265.71 13.29 3490.0 0.0 2790.0 2.5 66.43 2.5 66.43 0.0 0.0 265.71 132.86 2790.0 INR 0 0.0 0.0 2026-01-02 18:07:44
2403 2416 2 553 12554 25 Manicalcium Tablets NULL 2009899 10 0.0 399.0 0.0 0.0 319.0 303.81 15.19 3990.0 0.0 3190.0 2.5 75.95 2.5 75.95 0.0 0.0 303.81 151.9 3190.0 INR 0 0.0 0.0 2026-01-02 18:07:44
2404 2417 3 553 12554 53 Terra care 2 kg NULL 3103100 10 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 15000.0 0.0 11500.0 2.5 273.81 2.5 273.81 0.0 0.0 1095.24 547.62 11500.0 INR 0 0.0 0.0 2026-01-02 18:07:44
2405 2418 1 554 12527 15 KIDNEY 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 0.0 0.0 0.0 0.0 5.0 39.86 265.71 39.86 837.0 INR 0 0.0 0.0 2026-01-02 18:11:12
2406 2419 2 554 12527 25 Manicalcium Tablets NULL 2009899 5 0.0 399.0 0.0 0.0 319.0 303.81 15.19 1995.0 0.0 1595.0 0.0 0.0 0.0 0.0 5.0 75.95 303.81 75.95 1595.0 INR 0 0.0 0.0 2026-01-02 18:11:12
2407 2420 3 554 12527 53 Terra care 2 kg NULL 3103100 5 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 7500.0 0.0 5750.0 0.0 0.0 0.0 0.0 5.0 273.81 1095.24 273.81 5750.0 INR 0 0.0 0.0 2026-01-02 18:11:12
2408 2421 1 555 12554 33 Herbal Soap 100gm NULL 30049011 500 0.0 100.0 0.0 0.0 80.0 76.19 3.81 50000.0 0.0 40000.0 2.5 952.38 2.5 952.38 0.0 0.0 76.19 1904.76 40000.0 INR 0 0.0 0.0 2026-01-02 18:21:33
2409 2422 2 555 12554 32 Neem Soap 100gm NULL 34011110 500 0.0 60.0 0.0 0.0 48.0 45.71 2.29 30000.0 0.0 24000.0 2.5 571.43 2.5 571.43 0.0 0.0 45.71 1142.86 24000.0 INR 0 0.0 0.0 2026-01-02 18:21:33
2410 2423 1 556 12554 62 3*6 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.27 79800.0 INR 0 0.0 0.0 2026-01-02 18:24:32
2411 2424 2 556 12554 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 10 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 219990.0 0.0 149990.0 1.5 2184.32 1.5 2184.32 0.0 0.0 14562.14 4368.64 149990.0 INR 0 0.0 0.0 2026-01-02 18:24:32
2412 2425 3 556 12554 19 Fat loss Juice 500 ml NULL 30049011 10 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 14990.0 0.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 1142.86 571.43 12000.0 INR 0 0.0 0.0 2026-01-02 18:24:32
2413 2426 4 556 12554 41 Premium Coco Body Lotion NULL 3304300 20 0.0 699.0 0.0 0.0 559.0 473.73 85.27 13980.0 0.0 11180.0 9.0 852.71 9.0 852.71 0.0 0.0 473.73 1705.42 11180.0 INR 0 0.0 0.0 2026-01-02 18:24:32
2414 2427 5 556 12554 43 Quench Kiss Lip Balm NULL 3304300 20 0.0 199.0 0.0 0.0 159.0 134.75 24.25 3980.0 0.0 3180.0 9.0 242.54 9.0 242.54 0.0 0.0 134.75 485.08 3180.0 INR 0 0.0 0.0 2026-01-02 18:24:32
2415 2428 6 556 12554 46 Root Vitality Hair Oil NULL 3305901 20 0.0 255.0 0.0 0.0 204.0 194.29 9.71 5100.0 0.0 4080.0 2.5 97.14 2.5 97.14 0.0 0.0 194.29 194.29 4080.0 INR 0 0.0 0.0 2026-01-02 18:24:32
2416 2429 7 556 12554 50 Sun Screen NULL 330499 20 0.0 699.0 0.0 0.0 559.0 473.73 85.27 13980.0 0.0 11180.0 9.0 852.71 9.0 852.71 0.0 0.0 473.73 1705.42 11180.0 INR 0 0.0 0.0 2026-01-02 18:24:32
2417 2430 1 557 12516 62 3*6 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2026-01-02 18:25:20
2418 2431 1 558 12516 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 5 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 109995.0 0.0 74995.0 1.5 1092.16 1.5 1092.16 0.0 0.0 14562.14 2184.32 74995.0 INR 0 0.0 0.0 2026-01-02 18:33:21
2419 2432 1 559 12555 62 3*6 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.27 79800.0 INR 0 0.0 0.0 2026-01-02 18:51:12
2420 2433 1 560 13438 62 3*6 BED WITH BRACELET NULL 94041000 4 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 51996.0 0.0 31920.0 0.0 0.0 0.0 0.0 3.0 929.71 7747.57 929.71 31920.0 INR 0 0.0 0.0 2026-01-02 19:04:52
2421 2434 2 560 13438 50 Sun Screen NULL 330499 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.0 559.0 0.0 0.0 0.0 0.0 18.0 85.27 473.73 85.27 559.0 INR 0 0.0 0.0 2026-01-02 19:04:52
2422 2435 1 561 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 194.29 97.14 2040.0 INR 0 0.0 0.0 2026-01-02 20:50:12
2423 2436 1 562 12542 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 0.0 0.0 0.0 0.0 5.0 2.29 45.71 2.29 48.0 INR 0 0.0 0.0 2026-01-02 20:58:55
2424 2437 1 563 12516 65 1 Bracelet NULL 9404 1 0.0 12999.0 0.0 0.0 10500.0 10194.17 305.83 12999.0 0.0 10500.0 1.5 152.91 1.5 152.91 0.0 0.0 10194.17 305.83 10500.0 INR 0 0.0 0.0 2026-01-02 21:12:29
2425 2438 1 564 12516 68 18000 bracelt NULL 9404 25 0.0 23999.0 0.0 0.0 18000.0 17475.73 524.27 599975.0 0.0 450000.0 1.5 6553.4 1.5 6553.4 0.0 0.0 17475.73 13106.8 450000.0 INR 0 0.0 0.0 2026-01-02 21:14:01
2426 2439 2 564 12516 65 1 Bracelet NULL 9404 25 0.0 12999.0 0.0 0.0 10500.0 10194.17 305.83 324975.0 0.0 262500.0 1.5 3822.82 1.5 3822.82 0.0 0.0 10194.17 7645.63 262500.0 INR 0 0.0 0.0 2026-01-02 21:14:01
2427 2440 1 565 12516 68 18000 bracelt NULL 9404 25 0.0 23999.0 0.0 0.0 18000.0 17475.73 524.27 599975.0 0.0 450000.0 1.5 6553.4 1.5 6553.4 0.0 0.0 17475.73 13106.8 450000.0 INR 0 0.0 0.0 2026-01-02 21:15:04
2428 2441 2 565 12516 65 1 Bracelet NULL 9404 25 0.0 12999.0 0.0 0.0 10500.0 10194.17 305.83 324975.0 0.0 262500.0 1.5 3822.82 1.5 3822.82 0.0 0.0 10194.17 7645.63 262500.0 INR 0 0.0 0.0 2026-01-02 21:15:04
2429 2442 1 566 12542 62 3*6 BED WITH BRACELET NULL 94041000 2 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 25998.0 0.0 15960.0 0.0 0.0 0.0 0.0 3.0 464.85 7747.57 464.85 15960.0 INR 0 0.0 0.0 2026-01-02 21:41:09
2430 2443 2 566 12542 12 P RADIANCE FACE SERUM NULL 33049990 10 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 12500.0 0.0 7500.0 0.0 0.0 0.0 0.0 5.0 357.14 714.29 357.14 7500.0 INR 0 0.0 0.0 2026-01-02 21:41:09
2431 2444 1 567 12516 62 3*6 BED WITH BRACELET NULL 94041000 50 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 649950.0 0.0 399000.0 1.5 5810.68 1.5 5810.68 0.0 0.0 7747.57 11621.36 399000.0 INR 0 0.0 0.0 2026-01-02 22:21:33
2432 2445 1 568 12554 62 3*6 BED WITH BRACELET NULL 94041000 50 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 649950.0 0.0 399000.0 1.5 5810.68 1.5 5810.68 0.0 0.0 7747.57 11621.36 399000.0 INR 0 0.0 0.0 2026-01-02 22:23:16
2433 2446 1 569 12555 62 3*6 BED WITH BRACELET NULL 94041000 44 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 571956.0 0.0 351120.0 1.5 5113.4 1.5 5113.4 0.0 0.0 7747.57 10226.8 351120.0 INR 0 0.0 0.0 2026-01-02 22:27:06
2434 2447 1 570 12516 66 Premium Blanket Single NULL 9404 1 0.0 14999.0 0.0 0.0 7500.0 7142.86 357.14 14999.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 7142.86 357.14 7500.0 INR 0 0.0 0.0 2026-01-02 23:26:11
2435 2448 1 571 12554 66 Premium Blanket Single NULL 9404 1 0.0 14999.0 0.0 0.0 7500.0 7142.86 357.14 14999.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 7142.86 357.14 7500.0 INR 0 0.0 0.0 2026-01-02 23:27:23
2436 2449 1 572 12555 66 Premium Blanket Single NULL 9404 1 0.0 14999.0 0.0 0.0 7500.0 7142.86 357.14 14999.0 0.0 7500.0 2.5 178.57 2.5 178.57 0.0 0.0 7142.86 357.14 7500.0 INR 0 0.0 0.0 2026-01-02 23:29:35
2437 2450 1 573 12555 52 Bhoo sanjeevni 5 kg NULL 3103100 5 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 8000.0 0.0 6250.0 2.5 148.81 2.5 148.81 0.0 0.0 1190.48 297.62 6250.0 INR 0 0.0 0.0 2026-01-02 23:39:12
2438 2451 1 574 12555 62 3*6 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 1.5 116.21 1.5 116.21 0.0 0.0 7747.57 232.43 7980.0 INR 0 0.0 0.0 2026-01-02 23:59:43
2439 2452 1 575 12555 61 Radiation chip NULL 902221 3 0.0 999.0 0.0 0.0 500.0 423.73 76.27 2997.0 0.0 1500.0 9.0 114.41 9.0 114.41 0.0 0.0 423.73 228.81 1500.0 INR 0 0.0 0.0 2026-01-03 14:45:08
2440 2453 1 576 12554 61 Radiation chip NULL 902221 5 0.0 999.0 0.0 0.0 500.0 423.73 76.27 4995.0 0.0 2500.0 9.0 190.68 9.0 190.68 0.0 0.0 423.73 381.36 2500.0 INR 0 0.0 0.0 2026-01-03 16:17:04
2441 2454 1 577 12555 61 Radiation chip NULL 902221 3 0.0 999.0 0.0 0.0 500.0 423.73 76.27 2997.0 0.0 1500.0 9.0 114.41 9.0 114.41 0.0 0.0 423.73 228.81 1500.0 INR 0 0.0 0.0 2026-01-03 16:17:37
2442 2455 1 578 12555 62 3*6 BED WITH BRACELET NULL 94041000 1 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 12999.0 0.0 7980.0 1.5 116.21 1.5 116.21 0.0 0.0 7747.57 232.43 7980.0 INR 0 0.0 0.0 2026-01-03 16:37:10
2443 2456 1 579 12554 55 Grow master 500ml NULL 3105 5 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 10150.0 0.0 8250.0 2.5 196.43 2.5 196.43 0.0 0.0 1571.43 392.86 8250.0 INR 0 0.0 0.0 2026-01-03 16:46:21
2444 2457 1 580 12555 55 Grow master 500ml NULL 3105 10 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 20300.0 0.0 16500.0 2.5 392.86 2.5 392.86 0.0 0.0 1571.43 785.71 16500.0 INR 0 0.0 0.0 2026-01-03 16:47:15
2445 2458 1 581 12555 34 Herbo2o Toothpaste NULL 33061090 100 0.0 199.0 0.0 0.0 159.0 134.75 24.25 19900.0 0.0 15900.0 9.0 1212.71 9.0 1212.71 0.0 0.0 134.75 2425.42 15900.0 INR 0 0.0 0.0 2026-01-03 18:04:20
2446 2459 1 582 12555 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-03 22:01:43
2447 2460 1 583 12554 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 2 6.0 2.74 2026-01-03 22:03:29
2448 2461 1 584 12554 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 2 6.0 71.43 2026-01-03 22:04:12
2449 2462 1 585 12518 48 glow face wash NULL 3304999 2 0.0 380.0 0.0 0.0 304.0 257.63 46.37 760.0 0.0 608.0 9.0 46.38 9.0 46.38 0.0 0.0 515.25 92.75 608.0 INR 3 2.0 10.31 2026-01-03 22:21:25
2450 2463 2 585 12518 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-01-03 22:21:25