fx_franchise_order_product

4,933 rows · 33 columns · page 10 / 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
451 464 14 74 12525 34 Herbo2o Toothpaste NULL 33061090 20 45.0 199.0 0.0 0.0 159.2 134.92 24.28 3980.0 900.0 3184.0 9.0 242.84 9.0 242.84 0.0 0.0 134.92 485.69 3184.0 INR 0 0.0 0.0 2025-11-07 20:41:37
452 465 15 74 12525 7 Morning Fresh Churan NULL 30049011 9 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1791.0 360.0 1432.8 2.5 34.12 2.5 34.12 0.0 0.0 151.62 68.23 1432.8 INR 0 0.0 0.0 2025-11-07 20:41:37
453 466 16 74 12525 32 Neem Soap 100gm NULL 34011110 83 10.0 60.0 0.0 0.0 48.0 45.71 2.29 4980.0 830.0 3984.0 2.5 94.86 2.5 94.86 0.0 0.0 45.71 189.71 3984.0 INR 0 0.0 0.0 2025-11-07 20:41:37
454 467 17 74 12525 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 20:41:37
455 468 18 74 12525 8 Piles Care 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 20:41:37
456 469 19 74 12525 47 Premium Hair Care Shampoo NULL 3305109 1 150.0 699.0 0.0 0.0 559.2 532.57 26.63 699.0 150.0 559.2 2.5 13.31 2.5 13.31 0.0 0.0 532.57 26.63 559.2 INR 0 0.0 0.0 2025-11-07 20:41:37
457 470 20 74 12525 46 Root Vitality Hair Oil NULL 3305901 1 54.0 255.0 0.0 0.0 204.0 194.29 9.71 255.0 54.0 204.0 2.5 4.86 2.5 4.86 0.0 0.0 194.29 9.71 204.0 INR 0 0.0 0.0 2025-11-07 20:41:37
458 471 21 74 12525 57 Safe guard 250ml NULL 3105 3 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 7500.0 2400.0 6000.0 2.5 142.85 2.5 142.85 0.0 0.0 1904.76 285.71 6000.0 INR 0 0.0 0.0 2025-11-07 20:41:37
459 472 22 74 12525 35 Sanitary Pad (15 pcs) NULL 9619001 59 40.0 380.0 0.0 0.0 304.0 304.0 0.0 22420.0 2360.0 17936.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 17936.0 INR 0 0.0 0.0 2025-11-07 20:41:37
460 473 23 74 12525 29 Shilajith NULL 30049011 2 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 3600.0 500.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 1371.43 137.14 2880.0 INR 0 0.0 0.0 2025-11-07 20:41:37
461 474 24 74 12525 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 20:41:37
462 475 25 74 12525 50 Sun Screen NULL 330499 1 250.0 699.0 0.0 0.0 559.2 473.9 85.3 699.0 250.0 559.2 9.0 42.65 9.0 42.65 0.0 0.0 473.9 85.3 559.2 INR 0 0.0 0.0 2025-11-07 20:41:37
463 476 26 74 12525 59 T Shirt NULL 61099010 1 0.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 1400.0 0.0 1120.0 2.5 26.66 2.5 26.66 0.0 0.0 1066.67 53.33 1120.0 INR 0 0.0 0.0 2025-11-07 20:41:37
464 477 27 74 12525 53 Terra care 2 kg NULL 3103100 5 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 7500.0 2250.0 6000.0 2.5 142.85 2.5 142.85 0.0 0.0 1142.86 285.71 6000.0 INR 0 0.0 0.0 2025-11-07 20:41:37
465 478 28 74 12525 5 Thyro Care 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 20:41:37
466 479 29 74 12525 36 Toilet Cleaner 500ml NULL 3924101 10 30.0 150.0 0.0 0.0 120.0 101.69 18.3 1500.0 300.0 1200.0 9.0 91.53 9.0 91.53 0.0 0.0 101.69 183.05 1200.0 INR 0 0.0 0.0 2025-11-07 20:41:37
467 480 30 74 12525 44 Vital Glow Face Scrub NULL 3304300 2 71.0 325.0 0.0 0.0 260.0 220.34 39.66 650.0 142.0 520.0 9.0 39.66 9.0 39.66 0.0 0.0 220.34 79.32 520.0 INR 0 0.0 0.0 2025-11-07 20:41:37
468 481 31 74 12525 54 Wonder grow 100ml NULL 3105 3 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 4200.0 1500.0 3360.0 2.5 80.0 2.5 80.0 0.0 0.0 1066.67 160.0 3360.0 INR 0 0.0 0.0 2025-11-07 20:41:37
469 482 1 75 12517 70 Premium Hand belt NULL 9404 3 600.0 9999.0 0.0 0.0 7999.2 7618.29 380.91 29997.0 1800.0 23997.6 0.0 0.0 0.0 0.0 5.0 1142.74 7618.29 1142.74 23997.6 INR 0 0.0 0.0 2025-11-07 20:52:07
470 483 2 75 12517 6 Asthma Care NULL 30049011 1 250.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 250.0 719.2 0.0 0.0 0.0 0.0 5.0 34.25 684.95 34.25 719.2 INR 0 0.0 0.0 2025-11-07 20:52:07
471 484 3 75 12517 40 Bamboo Brush NULL 96032100 1 25.0 110.0 0.0 0.0 88.0 74.58 13.42 110.0 25.0 88.0 0.0 0.0 0.0 0.0 18.0 13.42 74.58 13.42 88.0 INR 0 0.0 0.0 2025-11-07 20:52:07
472 485 4 75 12517 52 Bhoo sanjeevni 5 kg NULL 3103100 3 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 4800.0 1350.0 3840.0 0.0 0.0 0.0 0.0 5.0 182.86 1219.05 182.86 3840.0 INR 0 0.0 0.0 2025-11-07 20:52:07
473 486 5 75 12517 38 Dish Wash 500ml NULL 3924101 21 85.0 230.0 0.0 0.0 184.0 155.93 28.07 4830.0 1785.0 3864.0 0.0 0.0 0.0 0.0 18.0 589.42 155.93 589.42 3864.0 INR 0 0.0 0.0 2025-11-07 20:52:07
474 487 6 75 12517 39 Fabric Wash 1000ml NULL 3924101 3 150.0 401.0 0.0 0.0 320.8 271.86 48.94 1203.0 450.0 962.4 0.0 0.0 0.0 0.0 18.0 146.81 271.86 146.81 962.4 INR 0 0.0 0.0 2025-11-07 20:52:07
475 488 7 75 12517 19 Fat loss Juice 500 ml NULL 30049011 1 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 1499.0 250.0 1479.0 0.0 0.0 0.0 0.0 5.0 70.43 1408.57 70.43 1479.0 INR 0 0.0 0.0 2025-11-07 20:52:07
476 489 8 75 12517 37 Floor Cleaner 500ml NULL 3924101 9 80.0 199.0 0.0 0.0 159.2 134.92 24.28 1791.0 720.0 1432.8 0.0 0.0 0.0 0.0 18.0 218.56 134.92 218.56 1432.8 INR 0 0.0 0.0 2025-11-07 20:52:07
477 490 9 75 12517 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 0.0 0.0 0.0 0.0 5.0 152.3 1523.05 152.3 3198.4 INR 0 0.0 0.0 2025-11-07 20:52:07
478 491 10 75 12517 33 Herbal Soap 100gm NULL 30049011 125 28.0 100.0 0.0 0.0 80.0 76.19 3.81 12500.0 3500.0 10000.0 0.0 0.0 0.0 0.0 5.0 476.19 76.19 476.19 10000.0 INR 0 0.0 0.0 2025-11-07 20:52:07
479 492 11 75 12517 34 Herbo2o Toothpaste NULL 33061090 33 45.0 199.0 0.0 0.0 159.2 134.92 24.28 6567.0 1485.0 5253.6 0.0 0.0 0.0 0.0 18.0 801.4 134.92 801.4 5253.6 INR 0 0.0 0.0 2025-11-07 20:52:07
480 493 12 75 12517 16 Liver Care Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 0.0 0.0 0.0 0.0 5.0 39.89 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-07 20:52:07
481 494 13 75 12517 17 Memory Booster Juice NULL 2009899 3 120.0 349.0 0.0 0.0 279.2 265.9 13.3 1047.0 360.0 837.6 0.0 0.0 0.0 0.0 5.0 39.89 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-07 20:52:07
482 495 14 75 12517 7 Morning Fresh Churan NULL 30049011 14 40.0 199.0 0.0 0.0 159.2 151.62 7.58 2786.0 560.0 2228.8 0.0 0.0 0.0 0.0 5.0 106.13 151.62 106.13 2228.8 INR 0 0.0 0.0 2025-11-07 20:52:07
483 496 15 75 12517 32 Neem Soap 100gm NULL 34011110 204 10.0 60.0 0.0 0.0 48.0 45.71 2.29 12240.0 2040.0 9792.0 0.0 0.0 0.0 0.0 5.0 466.29 45.71 466.29 9792.0 INR 0 0.0 0.0 2025-11-07 20:52:07
484 497 16 75 12517 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 0.0 0.0 0.0 0.0 5.0 38.06 761.14 38.06 799.2 INR 0 0.0 0.0 2025-11-07 20:52:07
485 498 17 75 12517 72 Pain Relief Patch NULL 30051090 3 200.0 800.0 0.0 0.0 640.0 609.52 30.48 2400.0 600.0 1920.0 0.0 0.0 0.0 0.0 5.0 91.43 609.52 91.43 1920.0 INR 0 0.0 0.0 2025-11-07 20:52:07
486 499 18 75 12517 8 Piles Care NULL 30049011 8 250.0 899.0 0.0 0.0 719.2 684.95 34.25 7192.0 2000.0 5753.6 0.0 0.0 0.0 0.0 5.0 273.98 684.95 273.98 5753.6 INR 0 0.0 0.0 2025-11-07 20:52:07
487 500 19 75 12517 35 Sanitary Pad (15 pcs) NULL 9619001 6 40.0 380.0 0.0 0.0 304.0 304.0 0.0 2280.0 240.0 1824.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 1824.0 INR 0 0.0 0.0 2025-11-07 20:52:07
488 501 20 75 12517 29 Shilajith NULL 30049011 2 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 3600.0 500.0 2880.0 0.0 0.0 0.0 0.0 5.0 137.14 1371.43 137.14 2880.0 INR 0 0.0 0.0 2025-11-07 20:52:07
489 502 21 75 12517 53 Terra care 2 kg NULL 3103100 1 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 1500.0 450.0 1200.0 0.0 0.0 0.0 0.0 5.0 57.14 1142.86 57.14 1200.0 INR 0 0.0 0.0 2025-11-07 20:52:07
490 503 22 75 12517 36 Toilet Cleaner 500ml NULL 3924101 25 30.0 150.0 0.0 0.0 120.0 101.69 18.31 3750.0 750.0 3000.0 0.0 0.0 0.0 0.0 18.0 457.63 101.69 457.63 3000.0 INR 0 0.0 0.0 2025-11-07 20:52:07
491 504 1 76 12517 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 0.0 0.0 0.0 0.0 18.0 92.75 257.63 92.75 608.0 INR 0 0.0 0.0 2025-11-07 20:59:30
492 505 2 76 12517 38 Dish Wash 500ml NULL 3924101 3 85.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 255.0 552.0 0.0 0.0 0.0 0.0 18.0 84.2 155.93 84.2 552.0 INR 0 0.0 0.0 2025-11-07 20:59:30
493 506 3 76 12517 37 Floor Cleaner 500ml NULL 3924101 2 80.0 199.0 0.0 0.0 159.2 134.92 24.29 398.0 160.0 318.4 0.0 0.0 0.0 0.0 18.0 48.57 134.92 48.57 318.4 INR 0 0.0 0.0 2025-11-07 20:59:30
494 507 4 76 12517 34 Herbo2o Toothpaste NULL 33061090 20 45.0 199.0 0.0 0.0 159.2 134.92 24.28 3980.0 900.0 3184.0 0.0 0.0 0.0 0.0 18.0 485.69 134.92 485.69 3184.0 INR 0 0.0 0.0 2025-11-07 20:59:30
495 508 5 76 12517 46 Root Vitality Hair Oil NULL 3305901 6 54.0 255.0 0.0 0.0 204.0 194.29 9.71 1530.0 324.0 1224.0 0.0 0.0 0.0 0.0 5.0 58.29 194.29 58.29 1224.0 INR 0 0.0 0.0 2025-11-07 20:59:30
496 509 6 76 12517 36 Toilet Cleaner 500ml NULL 3924101 13 30.0 150.0 0.0 0.0 120.0 101.69 18.31 1950.0 390.0 1560.0 0.0 0.0 0.0 0.0 18.0 237.97 101.69 237.97 1560.0 INR 0 0.0 0.0 2025-11-07 20:59:30
497 510 1 77 12523 3 BP Care Capsules NULL 2936900 2 160.0 599.0 0.0 0.0 479.2 456.38 22.82 1198.0 320.0 958.4 2.5 22.82 2.5 22.82 0.0 0.0 456.38 45.64 958.4 INR 0 0.0 0.0 2025-11-07 21:02:50
498 511 2 77 12523 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:02:50
499 512 3 77 12523 38 Dish Wash 500ml NULL 3924101 10 85.0 230.0 0.0 0.0 184.0 155.93 28.07 2300.0 850.0 1840.0 9.0 140.34 9.0 140.34 0.0 0.0 155.93 280.68 1840.0 INR 0 0.0 0.0 2025-11-07 21:02:50
500 513 4 77 12523 39 Fabric Wash 1000ml NULL 3924101 28 150.0 401.0 0.0 0.0 320.8 271.86 48.94 11228.0 4200.0 8982.4 9.0 685.1 9.0 685.1 0.0 0.0 271.86 1370.2 8982.4 INR 0 0.0 0.0 2025-11-07 21:02:50