fx_franchise_order_product

4,933 rows · 33 columns · page 9 / 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
401 414 7 72 12517 33 Herbal Soap 100gm NULL 30049011 17 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1700.0 476.0 1360.0 0.0 0.0 0.0 0.0 5.0 64.76 76.19 64.76 1360.0 INR 0 0.0 0.0 2025-11-07 20:37:03
402 415 8 72 12517 34 Herbo2o Toothpaste NULL 33061090 10 45.0 199.0 0.0 0.0 159.2 134.92 24.29 1990.0 450.0 1592.0 0.0 0.0 0.0 0.0 18.0 242.85 134.92 242.85 1592.0 INR 0 0.0 0.0 2025-11-07 20:37:03
403 416 9 72 12517 7 Morning Fresh Churan NULL 30049011 6 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1194.0 240.0 955.2 0.0 0.0 0.0 0.0 5.0 45.49 151.62 45.49 955.2 INR 0 0.0 0.0 2025-11-07 20:37:03
404 417 10 72 12517 32 Neem Soap 100gm NULL 34011110 104 10.0 60.0 0.0 0.0 48.0 45.71 2.29 6240.0 1040.0 4992.0 0.0 0.0 0.0 0.0 5.0 237.71 45.71 237.71 4992.0 INR 0 0.0 0.0 2025-11-07 20:37:03
405 418 11 72 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:37:03
406 419 12 72 12517 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 0.0 0.0 0.0 0.0 5.0 68.5 684.95 68.5 1438.4 INR 0 0.0 0.0 2025-11-07 20:37:03
407 420 13 72 12517 41 Premium Coco Body Lotion NULL 3304300 2 250.0 699.0 0.0 0.0 559.2 473.9 85.3 1398.0 500.0 1118.4 0.0 0.0 0.0 0.0 18.0 170.6 473.9 170.6 1118.4 INR 0 0.0 0.0 2025-11-07 20:37:03
408 421 14 72 12517 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 0.0 0.0 0.0 0.0 5.0 9.71 194.29 9.71 204.0 INR 0 0.0 0.0 2025-11-07 20:37:03
409 422 15 72 12517 35 Sanitary Pad (15 pcs) NULL 9619001 3 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 120.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 912.0 INR 0 0.0 0.0 2025-11-07 20:37:03
410 423 16 72 12517 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 0.0 0.0 0.0 0.0 5.0 190.4 1904.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-07 20:37:03
411 424 17 72 12517 50 Sun Screen NULL 330499 3 250.0 699.0 0.0 0.0 559.2 473.9 85.3 2097.0 750.0 1677.6 0.0 0.0 0.0 0.0 18.0 255.91 473.9 255.91 1677.6 INR 0 0.0 0.0 2025-11-07 20:37:03
412 425 18 72 12517 53 Terra care 2 kg NULL 3103100 4 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 6000.0 1800.0 4800.0 0.0 0.0 0.0 0.0 5.0 228.57 1142.86 228.57 4800.0 INR 0 0.0 0.0 2025-11-07 20:37:03
413 426 19 72 12517 36 Toilet Cleaner 500ml NULL 3924101 5 30.0 150.0 0.0 0.0 120.0 101.69 18.31 750.0 150.0 600.0 0.0 0.0 0.0 0.0 18.0 91.53 101.69 91.53 600.0 INR 0 0.0 0.0 2025-11-07 20:37:03
414 427 20 72 12517 11 Vitamin B12 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 0.0 0.0 0.0 0.0 5.0 28.53 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-07 20:37:03
415 428 1 73 12552 49 Anti Dandruff Serum NULL 3304999 1 250.0 999.0 0.0 0.0 799.2 677.29 121.91 999.0 250.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 20:37:03
416 429 2 73 12552 3 BP Care Capsules NULL 2936900 1 160.0 599.0 0.0 0.0 479.2 456.38 22.82 599.0 160.0 479.2 2.5 11.41 2.5 11.41 0.0 0.0 456.38 22.82 479.2 INR 0 0.0 0.0 2025-11-07 20:37:03
417 430 3 73 12552 38 Dish Wash 500ml NULL 3924101 11 85.0 230.0 0.0 0.0 184.0 155.93 28.07 2530.0 935.0 2024.0 9.0 154.38 9.0 154.38 0.0 0.0 155.93 308.75 2024.0 INR 0 0.0 0.0 2025-11-07 20:37:03
418 431 4 73 12552 39 Fabric Wash 1000ml NULL 3924101 6 150.0 401.0 0.0 0.0 320.8 271.86 48.94 2406.0 900.0 1924.8 9.0 146.81 9.0 146.81 0.0 0.0 271.86 293.61 1924.8 INR 0 0.0 0.0 2025-11-07 20:37:03
419 432 5 73 12552 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 9.0 24.29 9.0 24.29 0.0 0.0 134.92 48.57 318.4 INR 0 0.0 0.0 2025-11-07 20:37:03
420 433 6 73 12552 60 Foot patch NULL 30051090 3 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 5997.0 1500.0 4797.6 2.5 114.23 2.5 114.23 0.0 0.0 1523.05 228.46 4797.6 INR 0 0.0 0.0 2025-11-07 20:37:03
421 434 7 73 12552 33 Herbal Soap 100gm NULL 30049011 4 28.0 100.0 0.0 0.0 80.0 76.19 3.81 400.0 112.0 320.0 2.5 7.62 2.5 7.62 0.0 0.0 76.19 15.24 320.0 INR 0 0.0 0.0 2025-11-07 20:37:03
422 435 8 73 12552 34 Herbo2o Toothpaste NULL 33061090 2 45.0 199.0 0.0 0.0 159.2 134.92 24.29 398.0 90.0 318.4 9.0 24.29 9.0 24.29 0.0 0.0 134.92 48.57 318.4 INR 0 0.0 0.0 2025-11-07 20:37:03
423 436 9 73 12552 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 20:37:03
424 437 10 73 12552 16 Liver Care Juice NULL 2009899 2 120.0 349.0 0.0 0.0 279.2 265.9 13.29 698.0 240.0 558.4 2.5 13.29 2.5 13.29 0.0 0.0 265.9 26.59 558.4 INR 0 0.0 0.0 2025-11-07 20:37:03
425 438 11 73 12552 17 Memory Booster 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 20:37:03
426 439 12 73 12552 7 Morning Fresh Churan NULL 30049011 2 40.0 199.0 0.0 0.0 159.2 151.62 7.58 398.0 80.0 318.4 2.5 7.58 2.5 7.58 0.0 0.0 151.62 15.16 318.4 INR 0 0.0 0.0 2025-11-07 20:37:03
427 440 13 73 12552 32 Neem Soap 100gm NULL 34011110 6 10.0 60.0 0.0 0.0 48.0 45.71 2.29 360.0 60.0 288.0 2.5 6.86 2.5 6.86 0.0 0.0 45.71 13.71 288.0 INR 0 0.0 0.0 2025-11-07 20:37:03
428 441 14 73 12552 28 Ortho Joint Shield NULL 2009899 1 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 1499.0 450.0 1199.2 2.5 28.55 2.5 28.55 0.0 0.0 1142.1 57.1 1199.2 INR 0 0.0 0.0 2025-11-07 20:37:03
429 442 15 73 12552 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:37:03
430 443 16 73 12552 45 Premium radiance face serum NULL 3304991 5 300.0 1200.0 0.0 0.0 960.0 813.56 146.44 6000.0 1500.0 4800.0 9.0 366.1 9.0 366.1 0.0 0.0 813.56 732.2 4800.0 INR 0 0.0 0.0 2025-11-07 20:37:03
431 444 17 73 12552 35 Sanitary Pad (15 pcs) NULL 9619001 2 40.0 380.0 0.0 0.0 304.0 304.0 0.0 760.0 80.0 608.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 608.0 INR 0 0.0 0.0 2025-11-07 20:37:03
432 445 18 73 12552 26 Spirulina Cap NULL 2009899 1 190.0 899.0 0.0 0.0 719.2 684.95 34.25 899.0 190.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:37:03
433 446 19 73 12552 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 20:37:03
434 447 20 73 12552 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:37:03
435 448 21 73 12552 36 Toilet Cleaner 500ml NULL 3924101 6 30.0 150.0 0.0 0.0 120.0 101.69 18.3 900.0 180.0 720.0 9.0 54.91 9.0 54.91 0.0 0.0 101.69 109.83 720.0 INR 0 0.0 0.0 2025-11-07 20:37:03
436 449 22 73 12552 44 Vital Glow Face Scrub NULL 3304300 1 71.0 325.0 0.0 0.0 260.0 220.34 39.66 325.0 71.0 260.0 9.0 19.83 9.0 19.83 0.0 0.0 220.34 39.66 260.0 INR 0 0.0 0.0 2025-11-07 20:37:03
437 450 23 73 12552 10 Vitamin D3 Drop NULL 2106909 1 190.0 749.0 0.0 0.0 599.2 570.67 28.53 749.0 190.0 599.2 2.5 14.27 2.5 14.27 0.0 0.0 570.67 28.53 599.2 INR 0 0.0 0.0 2025-11-07 20:37:03
438 451 1 74 12525 48 glow face wash NULL 3304999 1 250.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 250.0 304.0 9.0 23.18 9.0 23.18 0.0 0.0 257.63 46.37 304.0 INR 0 0.0 0.0 2025-11-07 20:41:37
439 452 2 74 12525 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 20:41:37
440 453 3 74 12525 79 ALKALINE JUG NULL 8421 1 3500.0 14999.0 0.0 0.0 11999.2 10168.81 1830.39 14999.0 3500.0 11999.2 9.0 915.2 9.0 915.2 0.0 0.0 10168.81 1830.39 11999.2 INR 0 0.0 0.0 2025-11-07 20:41:37
441 454 4 74 12525 49 Anti Dandruff Serum NULL 3304999 1 250.0 999.0 0.0 0.0 799.2 677.29 121.91 999.0 250.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 20:41:37
442 455 5 74 12525 52 Bhoo sanjeevni 5 kg NULL 3103100 5 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 8000.0 2250.0 6400.0 2.5 152.38 2.5 152.38 0.0 0.0 1219.05 304.76 6400.0 INR 0 0.0 0.0 2025-11-07 20:41:37
443 456 6 74 12525 3 BP Care Capsules NULL 2936900 1 160.0 599.0 0.0 0.0 479.2 456.38 22.82 599.0 160.0 479.2 2.5 11.41 2.5 11.41 0.0 0.0 456.38 22.82 479.2 INR 0 0.0 0.0 2025-11-07 20:41:37
444 457 7 74 12525 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 20:41:37
445 458 8 74 12525 38 Dish Wash 500ml NULL 3924101 5 85.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 425.0 920.0 9.0 70.17 9.0 70.17 0.0 0.0 155.93 140.34 920.0 INR 0 0.0 0.0 2025-11-07 20:41:37
446 459 9 74 12525 39 Fabric Wash 1000ml NULL 3924101 5 150.0 401.0 0.0 0.0 320.8 271.86 48.94 2005.0 750.0 1604.0 9.0 122.34 9.0 122.34 0.0 0.0 271.86 244.68 1604.0 INR 0 0.0 0.0 2025-11-07 20:41:37
447 460 10 74 12525 37 Floor Cleaner 500ml NULL 3924101 10 80.0 199.0 0.0 0.0 159.2 134.92 24.29 1990.0 800.0 1592.0 9.0 121.42 9.0 121.42 0.0 0.0 134.92 242.85 1592.0 INR 0 0.0 0.0 2025-11-07 20:41:37
448 461 11 74 12525 58 Green shield 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
449 462 12 74 12525 55 Grow master 500ml NULL 3105 3 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 6090.0 2550.0 4872.0 2.5 116.0 2.5 116.0 0.0 0.0 1546.67 232.0 4872.0 INR 0 0.0 0.0 2025-11-07 20:41:37
450 463 13 74 12525 33 Herbal Soap 100gm NULL 30049011 36 28.0 100.0 0.0 0.0 80.0 76.19 3.81 3600.0 1008.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 76.19 137.14 2880.0 INR 0 0.0 0.0 2025-11-07 20:41:37