fx_franchise_order_product

4,933 rows · 33 columns · page 8 / 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
351 364 19 67 12528 47 Premium Hair Care Shampoo NULL 3305109 4 150.0 699.0 0.0 0.0 559.2 532.57 26.63 2796.0 600.0 2236.8 2.5 53.26 2.5 53.26 0.0 0.0 532.57 106.51 2236.8 INR 0 0.0 0.0 2025-11-07 20:12:29
352 365 20 67 12528 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:12:29
353 366 21 67 12528 35 Sanitary Pad (15 pcs) NULL 9619001 1 40.0 380.0 0.0 0.0 304.0 304.0 0.0 380.0 40.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 304.0 INR 0 0.0 0.0 2025-11-07 20:12:29
354 367 22 67 12528 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:12:29
355 368 23 67 12528 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:12:29
356 369 24 67 12528 36 Toilet Cleaner 500ml NULL 3924101 1 30.0 150.0 0.0 0.0 120.0 101.69 18.31 150.0 30.0 120.0 9.0 9.15 9.0 9.15 0.0 0.0 101.69 18.31 120.0 INR 0 0.0 0.0 2025-11-07 20:12:29
357 370 25 67 12528 10 Vitamin D3 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 20:12:29
358 371 1 68 12522 48 glow face wash NULL 3304999 10 250.0 380.0 0.0 0.0 304.0 257.63 46.37 3800.0 2500.0 3040.0 9.0 231.87 9.0 231.87 0.0 0.0 257.63 463.73 3040.0 INR 0 0.0 0.0 2025-11-07 20:12:32
359 372 2 68 12522 31 Vegan Plant Protein Powder NULL 21061000 1 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 2999.0 1000.0 2399.2 2.5 57.12 2.5 57.12 0.0 0.0 2284.95 114.25 2399.2 INR 0 0.0 0.0 2025-11-07 20:12:32
360 373 3 68 12522 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:12:32
361 374 4 68 12522 49 Anti Dandruff Serum NULL 3304999 2 250.0 999.0 0.0 0.0 799.2 677.29 121.91 1998.0 500.0 1598.4 9.0 121.91 9.0 121.91 0.0 0.0 677.29 243.82 1598.4 INR 0 0.0 0.0 2025-11-07 20:12:32
362 375 5 68 12522 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 20:12:32
363 376 6 68 12522 52 Bhoo sanjeevni 5 kg NULL 3103100 4 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 6400.0 1800.0 5120.0 2.5 121.91 2.5 121.91 0.0 0.0 1219.05 243.81 5120.0 INR 0 0.0 0.0 2025-11-07 20:12:32
364 377 7 68 12522 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 20:12:32
365 378 8 68 12522 4 Diabetic Care Capsules NULL 2936900 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 20:12:32
366 379 9 68 12522 38 Dish Wash 500ml NULL 3924101 20 85.0 230.0 0.0 0.0 184.0 155.93 28.07 4600.0 1700.0 3680.0 9.0 280.68 9.0 280.68 0.0 0.0 155.93 561.36 3680.0 INR 0 0.0 0.0 2025-11-07 20:12:32
367 380 10 68 12522 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:12:32
368 381 11 68 12522 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 2.5 35.22 2.5 35.22 0.0 0.0 1408.57 70.43 1479.0 INR 0 0.0 0.0 2025-11-07 20:12:32
369 382 12 68 12522 33 Herbal Soap 100gm NULL 30049011 150 28.0 100.0 0.0 0.0 80.0 76.19 3.81 15000.0 4200.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 76.19 571.43 12000.0 INR 0 0.0 0.0 2025-11-07 20:12:32
370 383 13 68 12522 34 Herbo2o Toothpaste NULL 33061090 30 45.0 199.0 0.0 0.0 159.2 134.92 24.28 5970.0 1350.0 4776.0 9.0 364.27 9.0 364.27 0.0 0.0 134.92 728.54 4776.0 INR 0 0.0 0.0 2025-11-07 20:12:32
371 384 14 68 12522 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:12:32
372 385 15 68 12522 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 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-07 20:12:32
373 386 16 68 12522 12 Melatonin 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 20:12:32
374 387 17 68 12522 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 2.5 19.95 2.5 19.95 0.0 0.0 265.9 39.89 837.6 INR 0 0.0 0.0 2025-11-07 20:12:32
375 388 18 68 12522 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 2.5 53.06 2.5 53.06 0.0 0.0 151.62 106.13 2228.8 INR 0 0.0 0.0 2025-11-07 20:12:32
376 389 19 68 12522 32 Neem Soap 100gm NULL 34011110 250 10.0 60.0 0.0 0.0 48.0 45.71 2.29 15000.0 2500.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 45.71 571.43 12000.0 INR 0 0.0 0.0 2025-11-07 20:12:32
377 390 20 68 12522 9 Omega 369 NULL 2936900 2 260.0 999.0 0.0 0.0 799.2 761.14 38.05 1998.0 520.0 1598.4 2.5 38.05 2.5 38.05 0.0 0.0 761.14 76.11 1598.4 INR 0 0.0 0.0 2025-11-07 20:12:32
378 391 21 68 12522 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:12:32
379 392 22 68 12522 72 Pain Relief Patch NULL 30051090 5 200.0 800.0 0.0 0.0 640.0 609.52 30.48 4000.0 1000.0 3200.0 2.5 76.19 2.5 76.19 0.0 0.0 609.52 152.38 3200.0 INR 0 0.0 0.0 2025-11-07 20:12:32
380 393 23 68 12522 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:12:32
381 394 24 68 12522 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 20:12:32
382 395 25 68 12522 14 Premium Aloe Vera VEG caps NULL 2936900 1 100.0 359.0 0.0 0.0 287.2 273.52 13.68 359.0 100.0 287.2 2.5 6.84 2.5 6.84 0.0 0.0 273.52 13.68 287.2 INR 0 0.0 0.0 2025-11-07 20:12:32
383 396 26 68 12522 47 Premium Hair Care Shampoo NULL 3305109 2 150.0 699.0 0.0 0.0 559.2 532.57 26.63 1398.0 300.0 1118.4 2.5 26.63 2.5 26.63 0.0 0.0 532.57 53.26 1118.4 INR 0 0.0 0.0 2025-11-07 20:12:32
384 397 27 68 12522 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 20:12:32
385 398 28 68 12522 35 Sanitary Pad (15 pcs) NULL 9619001 30 40.0 380.0 0.0 0.0 304.0 304.0 0.0 11400.0 1200.0 9120.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 9120.0 INR 0 0.0 0.0 2025-11-07 20:12:32
386 399 29 68 12522 29 Shilajith NULL 30049011 1 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 1800.0 250.0 1440.0 2.5 34.28 2.5 34.28 0.0 0.0 1371.43 68.57 1440.0 INR 0 0.0 0.0 2025-11-07 20:12:32
387 400 30 68 12522 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 20:12:32
388 401 31 68 12522 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 2.5 114.28 2.5 114.28 0.0 0.0 1142.86 228.57 4800.0 INR 0 0.0 0.0 2025-11-07 20:12:32
389 402 32 68 12522 44 Vital Glow Face Scrub NULL 3304300 4 71.0 325.0 0.0 0.0 260.0 220.34 39.66 1300.0 284.0 1040.0 9.0 79.32 9.0 79.32 0.0 0.0 220.34 158.64 1040.0 INR 0 0.0 0.0 2025-11-07 20:12:32
390 403 33 68 12522 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:12:32
391 404 1 69 12529 77 ELITE COMFORT NULL NULL 1 0.0 53994.0 0.0 0.0 18500.0 17619.05 880.95 53994.0 0.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.95 18500.0 INR 0 0.0 0.0 2025-11-07 20:17:38
392 405 1 70 12517 33 Herbal Soap 100gm NULL 30049011 3 28.0 100.0 0.0 0.0 80.0 76.19 3.81 300.0 84.0 240.0 0.0 0.0 0.0 0.0 5.0 11.43 76.19 11.43 240.0 INR 0 0.0 0.0 2025-11-07 20:21:33
393 406 2 70 12517 32 Neem Soap 100gm NULL 34011110 3 10.0 60.0 0.0 0.0 48.0 45.71 2.29 180.0 30.0 144.0 0.0 0.0 0.0 0.0 5.0 6.86 45.71 6.86 144.0 INR 0 0.0 0.0 2025-11-07 20:21:33
394 407 1 71 12517 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 0.0 0.0 0.0 0.0 5.0 26.63 532.57 26.63 559.2 INR 0 0.0 0.0 2025-11-07 20:24:05
395 408 1 72 12517 48 glow face wash NULL 3304999 3 250.0 380.0 0.0 0.0 304.0 257.63 46.37 1140.0 750.0 912.0 0.0 0.0 0.0 0.0 18.0 139.12 257.63 139.12 912.0 INR 0 0.0 0.0 2025-11-07 20:37:03
396 409 2 72 12517 52 Bhoo sanjeevni 5 kg NULL 3103100 4 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 6400.0 1800.0 5120.0 0.0 0.0 0.0 0.0 5.0 243.81 1219.05 243.81 5120.0 INR 0 0.0 0.0 2025-11-07 20:37:03
397 410 3 72 12517 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 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:37:03
398 411 4 72 12517 38 Dish Wash 500ml NULL 3924101 9 85.0 230.0 0.0 0.0 184.0 155.93 28.07 2070.0 765.0 1656.0 0.0 0.0 0.0 0.0 18.0 252.61 155.93 252.61 1656.0 INR 0 0.0 0.0 2025-11-07 20:37:03
399 412 5 72 12517 39 Fabric Wash 1000ml NULL 3924101 9 150.0 401.0 0.0 0.0 320.8 271.86 48.94 3609.0 1350.0 2887.2 0.0 0.0 0.0 0.0 18.0 440.42 271.86 440.42 2887.2 INR 0 0.0 0.0 2025-11-07 20:37:03
400 413 6 72 12517 37 Floor Cleaner 500ml NULL 3924101 3 80.0 199.0 0.0 0.0 159.2 134.92 24.28 597.0 240.0 477.6 0.0 0.0 0.0 0.0 18.0 72.85 134.92 72.85 477.6 INR 0 0.0 0.0 2025-11-07 20:37:03