fx_franchise_order_product

4,933 rows · 33 columns · page 67 / 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
3301 3314 7 818 12517 46 Root Vitality Hair Oil NULL 3305901 200 0.0 255.0 0.0 0.0 204.0 194.29 9.71 51000.0 0.0 40800.0 0.0 0.0 0.0 0.0 5.0 1942.86 38857.14 1942.86 40800.0 INR 2 6.0 2331.43 2026-01-25 13:47:25
3302 3315 8 818 12517 35 Sanitary Pad (15 pcs) NULL 9619001 900 0.0 380.0 0.0 0.0 304.0 304.0 0.0 342000.0 0.0 273600.0 0.0 0.0 0.0 0.0 0.0 0.0 273600.0 0.0 273600.0 INR 2 6.0 16416.0 2026-01-25 13:47:25
3303 3316 1 819 12517 48 glow face wash NULL 3304999 64 0.0 380.0 0.0 0.0 304.0 257.63 46.37 24320.0 0.0 19456.0 0.0 0.0 0.0 0.0 18.0 2967.86 16488.13 2967.86 19456.0 INR 2 6.0 989.29 2026-01-25 14:01:40
3304 3317 2 819 12517 58 Green shield 250ml NULL 3105 60 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 150000.0 0.0 111000.0 0.0 0.0 0.0 0.0 5.0 5285.71 105714.29 5285.71 111000.0 INR 2 6.0 6342.86 2026-01-25 14:01:40
3305 3318 3 819 12517 2 Heart Care Capsules NULL 2936900 200 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 299800.0 0.0 240000.0 0.0 0.0 0.0 0.0 5.0 11428.57 228571.42 11428.57 240000.0 INR 2 6.0 13714.29 2026-01-25 14:01:40
3306 3319 4 819 12517 28 Ortho Joint Shield NULL 2009899 150 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 224850.0 0.0 180000.0 0.0 0.0 0.0 0.0 5.0 8571.43 171428.57 8571.43 180000.0 INR 2 6.0 10285.71 2026-01-25 14:01:40
3307 3320 5 819 12517 12 P RADIANCE FACE SERUM NULL 33049990 80 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 100000.0 0.0 60000.0 0.0 0.0 0.0 0.0 5.0 2857.14 57142.86 2857.14 60000.0 INR 2 6.0 3428.57 2026-01-25 14:01:40
3308 3321 6 819 12517 43 Quench Kiss Lip Balm NULL 3304300 200 0.0 199.0 0.0 0.0 159.0 134.75 24.25 39800.0 0.0 31800.0 0.0 0.0 0.0 0.0 18.0 4850.85 26949.16 4850.85 31800.0 INR 2 6.0 1616.95 2026-01-25 14:01:40
3309 3322 7 819 12517 57 Safe guard 250ml NULL 3105 60 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 150000.0 0.0 111000.0 0.0 0.0 0.0 0.0 5.0 5285.71 105714.29 5285.71 111000.0 INR 2 6.0 6342.86 2026-01-25 14:01:40
3310 3323 8 819 12517 11 SOUNDARYA VEDA BRINGARAJ & SHIKAKAI NULL 33051090 100 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 125000.0 0.0 75000.0 0.0 0.0 0.0 0.0 5.0 3571.43 71428.57 3571.43 75000.0 INR 2 6.0 4285.71 2026-01-25 14:01:40
3311 3324 9 819 12517 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 100 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 142400.0 0.0 75000.0 0.0 0.0 0.0 0.0 5.0 3571.43 71428.57 3571.43 75000.0 INR 2 6.0 4285.71 2026-01-25 14:01:40
3312 3325 10 819 12517 5 Thyro Care NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 0.0 0.0 0.0 0.0 5.0 3428.57 68571.43 3428.57 72000.0 INR 2 6.0 4114.29 2026-01-25 14:01:40
3313 3326 11 819 12517 54 Wonder grow 100ml NULL 3105 60 0.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 84000.0 0.0 72000.0 0.0 0.0 0.0 0.0 5.0 3428.57 68571.43 3428.57 72000.0 INR 2 6.0 4114.29 2026-01-25 14:01:40
3314 3327 1 820 12542 32 Neem Soap 100gm NULL 34011110 200 0.0 60.0 0.0 0.0 48.0 45.71 2.29 12000.0 0.0 9600.0 2.5 228.57 2.5 228.57 0.0 0.0 9142.86 457.14 9600.0 INR 3 2.0 182.86 2026-01-25 14:05:04
3315 3328 1 821 12517 3 BP Care Capsules NULL 2936900 200 0.0 999.0 0.0 0.0 720.0 685.71 34.29 199800.0 0.0 144000.0 0.0 0.0 0.0 0.0 5.0 6857.14 137142.86 6857.14 144000.0 INR 2 6.0 8228.57 2026-01-25 14:08:05
3316 3329 2 821 12517 4 Diabetic Care Capsules NULL 2936900 200 0.0 999.0 0.0 0.0 720.0 685.71 34.29 199800.0 0.0 144000.0 0.0 0.0 0.0 0.0 5.0 6857.14 137142.86 6857.14 144000.0 INR 2 6.0 8228.57 2026-01-25 14:08:05
3317 3330 3 821 12517 24 Immunomax 24/7 Caps NULL 2009899 60 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 89940.0 0.0 72000.0 0.0 0.0 0.0 0.0 5.0 3428.57 68571.43 3428.57 72000.0 INR 2 6.0 4114.29 2026-01-25 14:08:05
3318 3331 4 821 12517 30 Iron Capsules NULL 30049011 120 0.0 899.0 0.0 0.0 719.0 684.76 34.24 107880.0 0.0 86280.0 0.0 0.0 0.0 0.0 5.0 4108.57 82171.43 4108.57 86280.0 INR 2 6.0 4930.29 2026-01-25 14:08:05
3319 3332 5 821 12517 18 Lady Care Juice 500ml NULL 2009899 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 0.0 0.0 0.0 0.0 5.0 5714.29 114285.71 5714.29 120000.0 INR 2 6.0 6857.14 2026-01-25 14:08:05
3320 3333 6 821 12517 25 Manicalcium Tablets NULL 2009899 200 0.0 399.0 0.0 0.0 319.0 303.81 15.19 79800.0 0.0 63800.0 0.0 0.0 0.0 0.0 5.0 3038.1 60761.9 3038.1 63800.0 INR 2 6.0 3645.71 2026-01-25 14:08:05
3321 3334 7 821 12517 9 Omega 369 NULL 2936900 40 0.0 999.0 0.0 0.0 720.0 685.71 34.29 39960.0 0.0 28800.0 0.0 0.0 0.0 0.0 5.0 1371.43 27428.57 1371.43 28800.0 INR 2 6.0 1645.71 2026-01-25 14:08:05
3322 3335 8 821 12517 72 Pain Relief Patch NULL 30051090 300 0.0 800.0 0.0 0.0 600.0 571.43 28.57 240000.0 0.0 180000.0 0.0 0.0 0.0 0.0 5.0 8571.43 171428.58 8571.43 180000.0 INR 2 6.0 10285.71 2026-01-25 14:08:05
3323 3336 9 821 12517 47 Premium Hair Care Shampoo NULL 3305109 200 0.0 699.0 0.0 0.0 559.0 532.38 26.62 139800.0 0.0 111800.0 0.0 0.0 0.0 0.0 5.0 5323.81 106476.2 5323.81 111800.0 INR 2 6.0 6388.57 2026-01-25 14:08:05
3324 3337 10 821 12517 26 Spirulina Cap NULL 2009899 100 0.0 899.0 0.0 0.0 719.0 684.76 34.24 89900.0 0.0 71900.0 0.0 0.0 0.0 0.0 5.0 3423.81 68476.19 3423.81 71900.0 INR 2 6.0 4108.57 2026-01-25 14:08:05
3325 3338 1 822 12517 27 Multicharge Cap NULL 2009899 120 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 179880.0 0.0 144000.0 0.0 0.0 0.0 0.0 5.0 6857.14 137142.85 6857.14 144000.0 INR 2 6.0 8228.57 2026-01-25 14:17:29
3326 3339 2 822 12517 20 Premium Berry Juice 1000ml NULL 2936900 300 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 1049700.0 0.0 780000.0 0.0 0.0 0.0 0.0 5.0 37142.86 742857.15 37142.86 780000.0 INR 2 6.0 44571.43 2026-01-25 14:17:29
3327 3340 3 822 12517 31 Vegan Plant Protein Powder NULL 21061000 100 0.0 2999.0 0.0 0.0 2000.0 1904.76 95.24 299900.0 0.0 200000.0 0.0 0.0 0.0 0.0 5.0 9523.81 190476.19 9523.81 200000.0 INR 2 6.0 11428.57 2026-01-25 14:17:29
3328 3341 4 822 12517 49 Anti Dandruff Serum NULL 3304999 100 0.0 999.0 0.0 0.0 799.0 677.12 121.88 99900.0 0.0 79900.0 0.0 0.0 0.0 0.0 18.0 12188.14 67711.86 12188.14 79900.0 INR 2 6.0 4062.71 2026-01-25 14:17:29
3329 3342 5 822 12517 6 Asthma Care NULL 30049011 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 0.0 0.0 0.0 0.0 5.0 3428.57 68571.43 3428.57 72000.0 INR 2 6.0 4114.29 2026-01-25 14:17:29
3330 3343 6 822 12517 52 Bhoo sanjeevni 5 kg NULL 3103100 100 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 160000.0 0.0 125000.0 0.0 0.0 0.0 0.0 5.0 5952.38 119047.62 5952.38 125000.0 INR 2 6.0 7142.86 2026-01-25 14:17:29
3331 3344 7 822 12517 19 Fat loss Juice 500 ml NULL 30049011 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 0.0 0.0 0.0 0.0 5.0 2857.14 57142.86 2857.14 60000.0 INR 2 6.0 3428.57 2026-01-25 14:17:29
3332 3345 8 822 12517 60 Foot patch NULL 30051090 60 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 119940.0 0.0 95940.0 0.0 0.0 0.0 0.0 5.0 4568.57 91371.43 4568.57 95940.0 INR 2 6.0 5482.29 2026-01-25 14:17:29
3333 3346 9 822 12517 55 Grow master 500ml NULL 3105 60 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 121800.0 0.0 99000.0 0.0 0.0 0.0 0.0 5.0 4714.29 94285.72 4714.29 99000.0 INR 2 0.0 0.0 2026-01-25 14:17:29
3334 3347 10 822 12517 34 Herbo2o Toothpaste NULL 33061090 500 0.0 199.0 0.0 0.0 159.0 134.75 24.25 99500.0 0.0 79500.0 0.0 0.0 0.0 0.0 18.0 12127.12 67372.9 12127.12 79500.0 INR 2 6.0 4042.37 2026-01-25 14:17:29
3335 3348 11 822 12517 15 KIDNEY CARE JUICE NULL 2009899 150 0.0 349.0 0.0 0.0 279.0 265.71 13.29 52350.0 0.0 41850.0 0.0 0.0 0.0 0.0 5.0 1992.86 39857.14 1992.86 41850.0 INR 2 6.0 2391.43 2026-01-25 14:17:29
3336 3349 12 822 12517 16 Liver Care Juice NULL 2009899 200 0.0 349.0 0.0 0.0 279.0 265.71 13.29 69800.0 0.0 55800.0 0.0 0.0 0.0 0.0 5.0 2657.14 53142.86 2657.14 55800.0 INR 2 6.0 3188.57 2026-01-25 14:17:29
3337 3350 13 822 12517 17 Memory Booster Juice NULL 2009899 200 0.0 349.0 0.0 0.0 279.0 265.71 13.29 69800.0 0.0 55800.0 0.0 0.0 0.0 0.0 5.0 2657.14 53142.86 2657.14 55800.0 INR 2 6.0 3188.57 2026-01-25 14:17:29
3338 3351 14 822 12517 56 Micro magic 500ml NULL 3105 60 0.0 2030.0 0.0 0.0 1650.0 1571.43 78.57 121800.0 0.0 99000.0 0.0 0.0 0.0 0.0 5.0 4714.29 94285.72 4714.29 99000.0 INR 2 6.0 5657.14 2026-01-25 14:17:29
3339 3352 15 822 12517 32 Neem Soap 100gm NULL 34011110 2000 0.0 60.0 0.0 0.0 48.0 45.71 2.29 120000.0 0.0 96000.0 0.0 0.0 0.0 0.0 5.0 4571.43 91428.6 4571.43 96000.0 INR 2 6.0 5485.72 2026-01-25 14:17:29
3340 3353 16 822 12517 50 Sun Screen NULL 330499 150 0.0 699.0 0.0 0.0 559.0 473.73 85.27 104850.0 0.0 83850.0 0.0 0.0 0.0 0.0 18.0 12790.68 71059.32 12790.68 83850.0 INR 2 6.0 4263.56 2026-01-25 14:17:29
3341 3354 17 822 12517 53 Terra care 2 kg NULL 3103100 100 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 150000.0 0.0 115000.0 0.0 0.0 0.0 0.0 5.0 5476.19 109523.81 5476.19 115000.0 INR 2 6.0 6571.43 2026-01-25 14:17:29
3342 3355 1 823 12516 79 ALKALINE JUG NULL 8421 30 0.0 14499.0 0.0 0.0 9900.0 8389.83 1510.17 434970.0 0.0 297000.0 9.0 22652.54 9.0 22652.54 0.0 0.0 251694.92 45305.08 297000.0 INR 1 0.0 0.0 2026-01-25 15:00:57
3343 3356 2 823 12516 38 Dish Wash 500ml NULL 34029099 200 0.0 230.0 0.0 0.0 184.0 155.93 28.07 46000.0 0.0 36800.0 9.0 2806.78 9.0 2806.78 0.0 0.0 31186.44 5613.56 36800.0 INR 1 8.0 2494.92 2026-01-25 15:00:57
3344 3357 3 823 12516 39 Fabric Wash 1000ml NULL 34029099 300 0.0 401.0 0.0 0.0 321.0 272.03 48.97 120300.0 0.0 96300.0 9.0 7344.92 9.0 7344.92 0.0 0.0 81610.17 14689.83 96300.0 INR 1 8.0 6528.81 2026-01-25 15:00:57
3345 3358 4 823 12516 8 Piles Care NULL 30049011 60 0.0 999.0 0.0 0.0 720.0 685.71 34.29 59940.0 0.0 43200.0 2.5 1028.57 2.5 1028.57 0.0 0.0 41142.86 2057.14 43200.0 INR 1 8.0 3291.43 2026-01-25 15:00:57
3346 3359 5 823 12516 41 Premium Coco Body Lotion NULL 3304300 100 0.0 699.0 0.0 0.0 559.0 473.73 85.27 69900.0 0.0 55900.0 9.0 4263.56 9.0 4263.56 0.0 0.0 47372.88 8527.12 55900.0 INR 1 8.0 3789.83 2026-01-25 15:00:57
3347 3360 6 823 12516 81 PREMIUM GLOW FACE WASH NULL 3404 200 0.0 699.0 0.0 0.0 559.0 512.84 46.16 139800.0 0.0 111800.0 4.5 4615.6 4.5 4615.6 0.0 0.0 102568.8 9231.19 111800.0 INR 1 8.0 8205.5 2026-01-25 15:00:57
3348 3361 7 823 12516 46 Root Vitality Hair Oil NULL 3305901 200 0.0 255.0 0.0 0.0 204.0 194.29 9.71 51000.0 0.0 40800.0 2.5 971.43 2.5 971.43 0.0 0.0 38857.14 1942.86 40800.0 INR 1 8.0 3108.57 2026-01-25 15:00:57
3349 3362 8 823 12516 35 Sanitary Pad (15 pcs) NULL 9619001 1000 0.0 380.0 0.0 0.0 304.0 304.0 0.0 380000.0 0.0 304000.0 0.0 0.0 0.0 0.0 0.0 0.0 304000.0 0.0 304000.0 INR 1 8.0 24320.0 2026-01-25 15:00:57
3350 3363 1 824 12516 48 glow face wash NULL 3304999 50 0.0 380.0 0.0 0.0 304.0 257.63 46.37 19000.0 0.0 15200.0 9.0 1159.32 9.0 1159.32 0.0 0.0 12881.35 2318.64 15200.0 INR 1 8.0 1030.51 2026-01-25 15:11:07