fx_franchise_order_product

4,933 rows · 33 columns · page 11 / 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
501 514 5 77 12523 37 Floor Cleaner 500ml NULL 3924101 1 80.0 199.0 0.0 0.0 159.2 134.92 24.28 199.0 80.0 159.2 9.0 12.14 9.0 12.14 0.0 0.0 134.92 24.28 159.2 INR 0 0.0 0.0 2025-11-07 21:02:50
502 515 6 77 12523 33 Herbal Soap 100gm NULL 30049011 138 28.0 100.0 0.0 0.0 80.0 76.19 3.81 13800.0 3864.0 11040.0 2.5 262.86 2.5 262.86 0.0 0.0 76.19 525.71 11040.0 INR 0 0.0 0.0 2025-11-07 21:02:50
503 516 7 77 12523 34 Herbo2o Toothpaste NULL 33061090 24 45.0 199.0 0.0 0.0 159.2 134.92 24.28 4776.0 1080.0 3820.8 9.0 291.42 9.0 291.42 0.0 0.0 134.92 582.83 3820.8 INR 0 0.0 0.0 2025-11-07 21:02:50
504 517 8 77 12523 30 Iron Capsules NULL 30049011 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 21:02:50
505 518 9 77 12523 15 Kidney Stone Juice NULL 2009899 1 120.0 349.0 0.0 0.0 279.2 265.9 13.3 349.0 120.0 279.2 2.5 6.65 2.5 6.65 0.0 0.0 265.9 13.3 279.2 INR 0 0.0 0.0 2025-11-07 21:02:50
506 519 10 77 12523 16 Liver Care Juice NULL 2009899 4 120.0 349.0 0.0 0.0 279.2 265.9 13.29 1396.0 480.0 1116.8 2.5 26.59 2.5 26.59 0.0 0.0 265.9 53.18 1116.8 INR 0 0.0 0.0 2025-11-07 21:02:50
507 520 11 77 12523 25 Manicalcium Tablets NULL 2009899 1 95.0 399.0 0.0 0.0 319.2 304.0 15.2 399.0 95.0 319.2 2.5 7.6 2.5 7.6 0.0 0.0 304.0 15.2 319.2 INR 0 0.0 0.0 2025-11-07 21:02:50
508 521 12 77 12523 17 Memory Booster Juice NULL 2009899 9 120.0 349.0 0.0 0.0 279.2 265.9 13.3 3141.0 1080.0 2512.8 2.5 59.83 2.5 59.83 0.0 0.0 265.9 119.66 2512.8 INR 0 0.0 0.0 2025-11-07 21:02:50
509 522 13 77 12523 7 Morning Fresh Churan NULL 30049011 8 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1592.0 320.0 1273.6 2.5 30.32 2.5 30.32 0.0 0.0 151.62 60.65 1273.6 INR 0 0.0 0.0 2025-11-07 21:02:50
510 523 14 77 12523 32 Neem Soap 100gm NULL 34011110 289 10.0 60.0 0.0 0.0 48.0 45.71 2.29 17340.0 2890.0 13872.0 2.5 330.29 2.5 330.29 0.0 0.0 45.71 660.57 13872.0 INR 0 0.0 0.0 2025-11-07 21:02:50
511 524 15 77 12523 9 Omega 369 NULL 2936900 1 260.0 999.0 0.0 0.0 799.2 761.14 38.06 999.0 260.0 799.2 2.5 19.03 2.5 19.03 0.0 0.0 761.14 38.06 799.2 INR 0 0.0 0.0 2025-11-07 21:02:50
512 525 16 77 12523 8 Piles Care NULL 30049011 2 250.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 500.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-07 21:02:50
513 526 17 77 12523 41 Premium Coco Body Lotion NULL 3304300 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 9.0 127.95 9.0 127.95 0.0 0.0 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-07 21:02:50
514 527 18 77 12523 47 Premium Hair Care Shampoo NULL 3305109 6 150.0 699.0 0.0 0.0 559.2 532.57 26.63 4194.0 900.0 3355.2 2.5 79.89 2.5 79.89 0.0 0.0 532.57 159.77 3355.2 INR 0 0.0 0.0 2025-11-07 21:02:50
515 528 19 77 12523 13 Premium NONI VEG caps NULL 2936900 1 150.0 501.0 0.0 0.0 400.8 381.71 19.09 501.0 150.0 400.8 2.5 9.54 2.5 9.54 0.0 0.0 381.71 19.09 400.8 INR 0 0.0 0.0 2025-11-07 21:02:50
516 529 20 77 12523 35 Sanitary Pad (15 pcs) NULL 9619001 29 40.0 380.0 0.0 0.0 304.0 304.0 0.0 11020.0 1160.0 8816.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 8816.0 INR 0 0.0 0.0 2025-11-07 21:02:50
517 530 21 77 12523 26 Spirulina Cap NULL 2009899 2 190.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 380.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-07 21:02:50
518 531 22 77 12523 1 Stem Cell Powder NULL 2936900 1 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 2499.0 749.0 1999.2 2.5 47.6 2.5 47.6 0.0 0.0 1904.0 95.2 1999.2 INR 0 0.0 0.0 2025-11-07 21:02:50
519 532 23 77 12523 50 Sun Screen NULL 330499 2 250.0 699.0 0.0 0.0 559.2 473.9 85.3 1398.0 500.0 1118.4 9.0 85.3 9.0 85.3 0.0 0.0 473.9 170.6 1118.4 INR 0 0.0 0.0 2025-11-07 21:02:50
520 533 24 77 12523 36 Toilet Cleaner 500ml NULL 3924101 16 30.0 150.0 0.0 0.0 120.0 101.69 18.3 2400.0 480.0 1920.0 9.0 146.44 9.0 146.44 0.0 0.0 101.69 292.88 1920.0 INR 0 0.0 0.0 2025-11-07 21:02:50
521 534 25 77 12523 44 Vital Glow Face Scrub NULL 3304300 3 71.0 325.0 0.0 0.0 260.0 220.34 39.66 975.0 213.0 780.0 9.0 59.49 9.0 59.49 0.0 0.0 220.34 118.98 780.0 INR 0 0.0 0.0 2025-11-07 21:02:50
522 535 26 77 12523 10 Vitamin D3 Drop NULL 2106909 2 190.0 749.0 0.0 0.0 599.2 570.67 28.54 1498.0 380.0 1198.4 2.5 28.54 2.5 28.54 0.0 0.0 570.67 57.07 1198.4 INR 0 0.0 0.0 2025-11-07 21:02:50
523 536 1 78 12520 48 glow face wash NULL 3304999 4 250.0 380.0 0.0 0.0 304.0 257.63 46.37 1520.0 1000.0 1216.0 9.0 92.75 9.0 92.75 0.0 0.0 257.63 185.49 1216.0 INR 0 0.0 0.0 2025-11-07 21:04:47
524 537 2 78 12520 20 Premium Berry Juice 1000ml NULL 2936900 1 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 3499.0 750.0 3479.0 2.5 82.83 2.5 82.83 0.0 0.0 3313.33 165.67 3479.0 INR 0 0.0 0.0 2025-11-07 21:04:47
525 538 3 78 12520 49 Anti Dandruff Serum NULL 3304999 5 250.0 999.0 0.0 0.0 799.2 677.29 121.91 4995.0 1250.0 3996.0 9.0 304.78 9.0 304.78 0.0 0.0 677.29 609.56 3996.0 INR 0 0.0 0.0 2025-11-07 21:04:47
526 539 4 78 12520 3 BP Care Capsules NULL 2936900 3 160.0 599.0 0.0 0.0 479.2 456.38 22.82 1797.0 480.0 1437.6 2.5 34.23 2.5 34.23 0.0 0.0 456.38 68.46 1437.6 INR 0 0.0 0.0 2025-11-07 21:04:47
527 540 5 78 12520 4 Diabetic Care Capsules NULL 2936900 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 2.5 17.12 2.5 17.12 0.0 0.0 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 21:04:47
528 541 6 78 12520 60 Foot patch NULL 30051090 2 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 3998.0 1000.0 3198.4 2.5 76.15 2.5 76.15 0.0 0.0 1523.05 152.3 3198.4 INR 0 0.0 0.0 2025-11-07 21:04:47
529 542 7 78 12520 33 Herbal Soap 100gm NULL 30049011 46 28.0 100.0 0.0 0.0 80.0 76.19 3.81 4600.0 1288.0 3680.0 2.5 87.62 2.5 87.62 0.0 0.0 76.19 175.24 3680.0 INR 0 0.0 0.0 2025-11-07 21:04:47
530 543 8 78 12520 34 Herbo2o Toothpaste NULL 33061090 19 45.0 199.0 0.0 0.0 159.2 134.92 24.28 3781.0 855.0 3024.8 9.0 230.71 9.0 230.71 0.0 0.0 134.92 461.41 3024.8 INR 0 0.0 0.0 2025-11-07 21:04:47
531 544 9 78 12520 30 Iron Capsules NULL 30049011 3 250.0 899.0 0.0 0.0 719.2 684.95 34.25 2697.0 750.0 2157.6 2.5 51.37 2.5 51.37 0.0 0.0 684.95 102.74 2157.6 INR 0 0.0 0.0 2025-11-07 21:04:47
532 545 10 78 12520 16 Liver Care Juice NULL 2009899 8 120.0 349.0 0.0 0.0 279.2 265.9 13.29 2792.0 960.0 2233.6 2.5 53.18 2.5 53.18 0.0 0.0 265.9 106.36 2233.6 INR 0 0.0 0.0 2025-11-07 21:04:47
533 546 11 78 12520 25 Manicalcium Tablets NULL 2009899 10 95.0 399.0 0.0 0.0 319.2 304.0 15.2 3990.0 950.0 3192.0 2.5 76.0 2.5 76.0 0.0 0.0 304.0 152.0 3192.0 INR 0 0.0 0.0 2025-11-07 21:04:47
534 547 12 78 12520 12 Melatonin Drop NULL 2106909 3 190.0 749.0 0.0 0.0 599.2 570.67 28.53 2247.0 570.0 1797.6 2.5 42.8 2.5 42.8 0.0 0.0 570.67 85.6 1797.6 INR 0 0.0 0.0 2025-11-07 21:04:47
535 548 13 78 12520 17 Memory Booster Juice NULL 2009899 10 120.0 349.0 0.0 0.0 279.2 265.9 13.29 3490.0 1200.0 2792.0 2.5 66.47 2.5 66.47 0.0 0.0 265.9 132.95 2792.0 INR 0 0.0 0.0 2025-11-07 21:04:47
536 549 14 78 12520 7 Morning Fresh Churan NULL 30049011 10 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1990.0 400.0 1592.0 2.5 37.91 2.5 37.91 0.0 0.0 151.62 75.81 1592.0 INR 0 0.0 0.0 2025-11-07 21:04:47
537 550 15 78 12520 32 Neem Soap 100gm NULL 34011110 44 10.0 60.0 0.0 0.0 48.0 45.71 2.29 2640.0 440.0 2112.0 2.5 50.28 2.5 50.28 0.0 0.0 45.71 100.57 2112.0 INR 0 0.0 0.0 2025-11-07 21:04:47
538 551 16 78 12520 9 Omega 369 NULL 2936900 3 260.0 999.0 0.0 0.0 799.2 761.14 38.06 2997.0 780.0 2397.6 2.5 57.09 2.5 57.09 0.0 0.0 761.14 114.17 2397.6 INR 0 0.0 0.0 2025-11-07 21:04:47
539 552 17 78 12520 8 Piles Care NULL 30049011 3 250.0 899.0 0.0 0.0 719.2 684.95 34.25 2697.0 750.0 2157.6 2.5 51.37 2.5 51.37 0.0 0.0 684.95 102.74 2157.6 INR 0 0.0 0.0 2025-11-07 21:04:47
540 553 18 78 12520 41 Premium Coco Body Lotion NULL 3304300 5 250.0 699.0 0.0 0.0 559.2 473.9 85.3 3495.0 1250.0 2796.0 9.0 213.25 9.0 213.25 0.0 0.0 473.9 426.51 2796.0 INR 0 0.0 0.0 2025-11-07 21:04:47
541 554 19 78 12520 47 Premium Hair Care Shampoo NULL 3305109 10 150.0 699.0 0.0 0.0 559.2 532.57 26.63 6990.0 1500.0 5592.0 2.5 133.15 2.5 133.15 0.0 0.0 532.57 266.29 5592.0 INR 0 0.0 0.0 2025-11-07 21:04:47
542 555 20 78 12520 35 Sanitary Pad (15 pcs) NULL 9619001 15 40.0 380.0 0.0 0.0 304.0 304.0 0.0 5700.0 600.0 4560.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 4560.0 INR 0 0.0 0.0 2025-11-07 21:04:47
543 556 21 78 12520 1 Stem Cell Powder NULL 2936900 2 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 4998.0 1498.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 1904.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-07 21:04:47
544 557 22 78 12520 50 Sun Screen NULL 330499 5 250.0 699.0 0.0 0.0 559.2 473.9 85.3 3495.0 1250.0 2796.0 9.0 213.25 9.0 213.25 0.0 0.0 473.9 426.51 2796.0 INR 0 0.0 0.0 2025-11-07 21:04:47
545 558 23 78 12520 44 Vital Glow Face Scrub NULL 3304300 10 71.0 325.0 0.0 0.0 260.0 220.34 39.66 3250.0 710.0 2600.0 9.0 198.31 9.0 198.31 0.0 0.0 220.34 396.61 2600.0 INR 0 0.0 0.0 2025-11-07 21:04:47
546 559 1 79 12518 48 glow face wash NULL 3304999 2 250.0 380.0 0.0 0.0 304.0 257.63 46.38 760.0 500.0 608.0 9.0 46.38 9.0 46.38 0.0 0.0 257.63 92.75 608.0 INR 0 0.0 0.0 2025-11-07 21:51:44
547 560 2 79 12518 70 Premium Hand belt NULL 9404 2 600.0 9999.0 0.0 0.0 7999.2 7618.29 380.92 19998.0 1200.0 15998.4 2.5 380.92 2.5 380.92 0.0 0.0 7618.29 761.83 15998.4 INR 0 0.0 0.0 2025-11-07 21:51:44
548 561 3 79 12518 61 Radiation chip NULL 902221 1 325.0 999.0 0.0 0.0 799.2 677.29 121.91 999.0 325.0 799.2 9.0 60.95 9.0 60.95 0.0 0.0 677.29 121.91 799.2 INR 0 0.0 0.0 2025-11-07 21:51:44
549 562 4 79 12518 49 Anti Dandruff Serum NULL 3304999 3 250.0 999.0 0.0 0.0 799.2 677.29 121.91 2997.0 750.0 2397.6 9.0 182.87 9.0 182.87 0.0 0.0 677.29 365.74 2397.6 INR 0 0.0 0.0 2025-11-07 21:51:44
550 563 5 79 12518 6 Asthma Care NULL 30049011 2 250.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 500.0 1438.4 2.5 34.25 2.5 34.25 0.0 0.0 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-07 21:51:44