fx_franchise_order_product

4,933 rows · 33 columns · page 71 / 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
3501 3514 12 860 12521 53 Terra care 2 kg NULL 3103100 2 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 3000.0 0.0 2300.0 2.5 54.76 2.5 54.76 0.0 0.0 2190.48 109.52 2300.0 INR 3 2.0 43.81 2026-01-29 22:20:37
3502 3515 13 860 12521 5 Thyro Care 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
3503 3516 1 861 12548 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-29 22:23:28
3504 3517 2 861 12548 38 Dish Wash 500ml NULL 34029099 7 0.0 230.0 0.0 0.0 184.0 155.93 28.07 1610.0 0.0 1288.0 9.0 98.24 9.0 98.24 0.0 0.0 1091.53 196.47 1288.0 INR 3 2.0 21.83 2026-01-29 22:23:28
3505 3518 3 861 12548 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-29 22:23:28
3506 3519 4 861 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-29 22:23:28
3507 3520 5 861 12548 33 Herbal Soap 100gm NULL 30049011 20 0.0 100.0 0.0 0.0 80.0 76.19 3.81 2000.0 0.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-01-29 22:23:28
3508 3521 6 861 12548 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-29 22:23:28
3509 3522 7 861 12548 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-29 22:23:28
3510 3523 8 861 12548 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-01-29 22:23:28
3511 3524 9 861 12548 36 Toilet Cleaner 500ml NULL 3924101 10 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1500.0 0.0 1200.0 9.0 91.53 9.0 91.53 0.0 0.0 1016.95 183.05 1200.0 INR 3 2.0 20.34 2026-01-29 22:23:28
3512 3525 1 862 12547 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-29 22:53:00
3513 3526 2 862 12547 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 22:53:00
3514 3527 3 862 12547 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-29 22:53:00
3515 3528 4 862 12547 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-29 22:53:00
3516 3529 5 862 12547 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-29 22:53:00
3517 3530 6 862 12547 37 Floor Cleaner 500ml NULL 3924101 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-29 22:53:00
3518 3531 7 862 12547 2 Heart Care Capsules NULL 2936900 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 3 2.0 45.71 2026-01-29 22:53:00
3519 3532 8 862 12547 33 Herbal Soap 100gm NULL 30049011 13 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1300.0 0.0 1040.0 2.5 24.76 2.5 24.76 0.0 0.0 990.48 49.52 1040.0 INR 3 2.0 19.81 2026-01-29 22:53:00
3520 3533 9 862 12547 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:53:00
3521 3534 10 862 12547 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 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-29 22:53:00
3522 3535 11 862 12547 16 Liver Care Juice NULL 2009899 2 0.0 349.0 0.0 0.0 279.0 265.71 13.29 698.0 0.0 558.0 2.5 13.29 2.5 13.29 0.0 0.0 531.43 26.57 558.0 INR 3 2.0 10.63 2026-01-29 22:53:00
3523 3536 12 862 12547 25 Manicalcium Tablets NULL 2009899 1 0.0 399.0 0.0 0.0 319.0 303.81 15.19 399.0 0.0 319.0 2.5 7.6 2.5 7.6 0.0 0.0 303.81 15.19 319.0 INR 3 2.0 6.08 2026-01-29 22:53:00
3524 3537 13 862 12547 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-29 22:53:00
3525 3538 14 862 12547 32 Neem Soap 100gm NULL 34011110 27 0.0 60.0 0.0 0.0 48.0 45.71 2.29 1620.0 0.0 1296.0 2.5 30.86 2.5 30.86 0.0 0.0 1234.29 61.71 1296.0 INR 3 2.0 24.69 2026-01-29 22:53:00
3526 3539 15 862 12547 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-29 22:53:00
3527 3540 16 862 12547 41 Premium Coco Body Lotion NULL 3304300 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-01-29 22:53:00
3528 3541 17 862 12547 81 PREMIUM GLOW FACE WASH NULL 3404 1 0.0 699.0 0.0 0.0 559.0 512.84 46.16 699.0 0.0 559.0 4.5 23.08 4.5 23.08 0.0 0.0 512.84 46.16 559.0 INR 3 2.0 10.26 2026-01-29 22:53:00
3529 3542 18 862 12547 46 Root Vitality Hair Oil NULL 3305901 1 0.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 0.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 194.29 9.71 204.0 INR 3 2.0 3.89 2026-01-29 22:53:00
3530 3543 19 862 12547 35 Sanitary Pad (15 pcs) NULL 9619001 1 0.0 380.0 0.0 0.0 304.0 304.0 0.0 380.0 0.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 304.0 INR 3 2.0 6.08 2026-01-29 22:53:00
3531 3544 20 862 12547 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:53:00
3532 3545 21 862 12547 1 Stem Cell Powder NULL 2936900 1 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 2499.0 0.0 1999.0 2.5 47.6 2.5 47.6 0.0 0.0 1903.81 95.19 1999.0 INR 3 2.0 38.08 2026-01-29 22:53:00
3533 3546 22 862 12547 36 Toilet Cleaner 500ml NULL 3924101 2 0.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 0.0 240.0 9.0 18.31 9.0 18.31 0.0 0.0 203.39 36.61 240.0 INR 3 2.0 4.07 2026-01-29 22:53:00
3534 3547 1 863 12525 37 Floor Cleaner 500ml NULL 3924101 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-29 22:56:45
3535 3548 2 863 12525 33 Herbal Soap 100gm NULL 30049011 10 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 0.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 761.9 38.1 800.0 INR 3 2.0 15.24 2026-01-29 22:56:45
3536 3549 3 863 12525 7 Morning Fresh Churan NULL 30049011 3 0.0 199.0 0.0 0.0 159.0 151.43 7.57 597.0 0.0 477.0 2.5 11.36 2.5 11.36 0.0 0.0 454.29 22.71 477.0 INR 3 2.0 9.09 2026-01-29 22:56:45
3537 3550 4 863 12525 35 Sanitary Pad (15 pcs) NULL 9619001 2 0.0 380.0 0.0 0.0 304.0 304.0 0.0 760.0 0.0 608.0 0.0 0.0 0.0 0.0 0.0 0.0 608.0 0.0 608.0 INR 3 2.0 12.16 2026-01-29 22:56:45
3538 3551 5 863 12525 36 Toilet Cleaner 500ml NULL 3924101 4 0.0 150.0 0.0 0.0 120.0 101.69 18.31 600.0 0.0 480.0 9.0 36.61 9.0 36.61 0.0 0.0 406.78 73.22 480.0 INR 3 2.0 8.14 2026-01-29 22:56:45
3539 3552 1 864 12528 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-30 12:08:52
3540 3553 2 864 12528 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-30 12:08:52
3541 3554 3 864 12528 33 Herbal Soap 100gm NULL 30049011 20 0.0 100.0 0.0 0.0 80.0 76.19 3.81 2000.0 0.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-01-30 12:08:52
3542 3555 4 864 12528 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-30 12:08:52
3543 3556 5 864 12528 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-30 12:08:52
3544 3557 6 864 12528 35 Sanitary Pad (15 pcs) NULL 9619001 10 0.0 380.0 0.0 0.0 304.0 304.0 0.0 3800.0 0.0 3040.0 0.0 0.0 0.0 0.0 0.0 0.0 3040.0 0.0 3040.0 INR 3 2.0 60.8 2026-01-30 12:08:52
3545 3558 7 864 12528 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-01-30 12:08:52
3546 3559 1 865 12532 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.37 9.0 46.37 0.0 0.0 515.25 92.75 608.0 INR 3 2.0 10.31 2026-01-30 16:41:49
3547 3560 2 865 12532 27 Multicharge Cap NULL 2009899 6 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 8994.0 0.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 6857.14 342.86 7200.0 INR 3 2.0 137.14 2026-01-30 16:41:49
3548 3561 3 865 12532 82 ALKALINE CAPSULE NULL 3402000 2 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 5000.0 0.0 4000.0 2.5 95.24 2.5 95.24 0.0 0.0 3809.52 190.48 4000.0 INR 3 2.0 76.19 2026-01-30 16:41:49
3549 3562 4 865 12532 4 Diabetic Care Capsules NULL 2936900 5 0.0 999.0 0.0 0.0 720.0 685.71 34.29 4995.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-30 16:41:49
3550 3563 5 865 12532 38 Dish Wash 500ml NULL 34029099 1 0.0 230.0 0.0 0.0 184.0 155.93 28.07 230.0 0.0 184.0 9.0 14.03 9.0 14.03 0.0 0.0 155.93 28.07 184.0 INR 3 2.0 3.12 2026-01-30 16:41:49