fx_franchise_order_product

4,933 rows · 33 columns · page 89 / 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
4401 4414 9 1086 14902 32 Neem Soap 100gm NULL 34011110 50 20.0 60.0 0.0 0.0 52.0 49.52 2.48 3000.0 1000.0 2600.0 2.5 61.9 2.5 61.9 0.0 0.0 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-04-17 14:32:34
4402 4415 10 1086 14902 9 Omega 369 NULL 2936900 1 360.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 360.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-04-17 14:32:34
4403 4416 11 1086 14902 35 Sanitary Pad (15 pcs) NULL 9619001 5 150.0 380.0 0.0 0.0 304.0 304.0 0.0 1900.0 750.0 1520.0 0.0 0.0 0.0 0.0 0.0 0.0 1520.0 0.0 1520.0 INR 3 2.0 30.4 2026-04-17 14:32:34
4404 4417 12 1086 14902 26 Spirulina Cap NULL 2009899 1 359.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 359.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 3 2.0 13.7 2026-04-17 14:32:34
4405 4418 13 1086 14902 95 STRI VEDA NULL 30049011 1 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 2500.0 750.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-04-17 14:32:34
4406 4419 14 1086 14902 53 Terra care 2 kg NULL 3103100 1 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 575.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-04-17 14:32:34
4407 4420 1 1087 12517 65 SINGLE WELLNESS NULL 94041000 10 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 129990.0 53500.0 107000.0 0.0 0.0 0.0 0.0 5.0 5095.24 101904.76 5095.24 107000.0 INR 2 6.0 6114.29 2026-04-18 15:47:56
4408 4421 1 1088 12516 64 Bio magnetic bracelet NULL 9404 50 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 499950.0 62500.0 125000.0 1.5 1820.39 1.5 1820.39 0.0 0.0 121359.23 3640.78 125000.0 INR 1 8.0 9708.74 2026-04-18 17:22:29
4409 4422 1 1089 12554 64 Bio magnetic bracelet NULL 9404 20 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 199980.0 25000.0 50000.0 1.5 728.16 1.5 728.16 0.0 0.0 48543.69 1456.31 50000.0 INR 2 6.0 2912.62 2026-04-18 17:24:01
4410 4423 1 1090 12555 64 Bio magnetic bracelet NULL 9404 10 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 99990.0 12500.0 25000.0 1.5 364.08 1.5 364.08 0.0 0.0 24271.85 728.16 25000.0 INR 3 2.0 485.44 2026-04-18 17:24:42
4411 4424 1 1091 12554 20 Premium Berry Juice 1000ml NULL 2936900 15 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 52485.0 12000.0 24000.0 2.5 571.43 2.5 571.43 0.0 0.0 22857.14 1142.86 24000.0 INR 2 6.0 1371.43 2026-04-18 18:20:00
4412 4425 1 1092 12555 20 Premium Berry Juice 1000ml NULL 2936900 10 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 34990.0 8000.0 16000.0 2.5 380.95 2.5 380.95 0.0 0.0 15238.09 761.9 16000.0 INR 3 2.0 304.76 2026-04-18 18:21:42
4413 4426 1 1093 12555 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 5 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 6250.0 1875.0 3750.0 2.5 89.29 2.5 89.29 0.0 0.0 3571.43 178.57 3750.0 INR 3 2.0 71.43 2026-04-18 18:27:23
4414 4430 2 1095 12526 38 Dish Wash 500ml NULL 34029099 5 65.0 230.0 0.0 0.0 184.0 155.93 28.07 1150.0 325.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-04-20 13:57:13
4415 4429 1 1095 12526 49 Anti Dandruff Serum NULL 3304999 2 399.0 999.0 0.0 0.0 799.0 677.12 121.88 1998.0 798.0 1598.0 9.0 121.88 9.0 121.88 0.0 0.0 1354.24 243.76 1598.0 INR 3 2.0 27.08 2026-04-20 13:57:13
4416 4431 3 1095 12526 19 Fat loss Juice 500 ml NULL 30049011 1 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.0 600.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-04-20 13:57:13
4417 4432 4 1095 12526 48 Glow it multi fruit face wash NULL 3304999 5 160.0 450.0 0.0 0.0 320.0 271.19 48.81 2250.0 800.0 1600.0 9.0 122.03 9.0 122.03 0.0 0.0 1355.93 244.07 1600.0 INR 3 2.0 27.12 2026-04-20 13:57:13
4418 4433 5 1095 12526 16 Liver Care Juice NULL 2009899 1 150.0 349.0 0.0 0.0 300.0 285.71 14.29 349.0 150.0 300.0 2.5 7.14 2.5 7.14 0.0 0.0 285.71 14.29 300.0 INR 3 2.0 5.71 2026-04-20 13:57:13
4419 4434 6 1095 12526 17 Memory Booster Juice NULL 2009899 5 150.0 349.0 0.0 0.0 300.0 285.71 14.29 1745.0 750.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-04-20 13:57:13
4420 4435 7 1095 12526 10 RADIANCE GLOW DAY CREAM NULL 33049900 3 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 4272.0 1125.0 2250.0 9.0 171.61 9.0 171.61 0.0 0.0 1906.78 343.22 2250.0 INR 3 2.0 38.14 2026-04-20 13:57:13
4421 4436 8 1095 12526 34 Toothpaste NULL 33061090 24 55.0 199.0 0.0 0.0 159.0 134.75 24.25 4776.0 1320.0 3816.0 9.0 291.05 9.0 291.05 0.0 0.0 3233.9 582.1 3816.0 INR 3 2.0 64.68 2026-04-20 13:57:13
4422 4437 1 1096 12555 64 Bio magnetic bracelet NULL 9404 4 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 39996.0 5000.0 10000.0 1.5 145.63 1.5 145.63 0.0 0.0 9708.74 291.26 10000.0 INR 3 2.0 194.17 2026-04-20 19:40:03
4423 4438 1 1097 12555 64 Bio magnetic bracelet NULL 9404 4 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 39996.0 5000.0 10000.0 1.5 145.63 1.5 145.63 0.0 0.0 9708.74 291.26 10000.0 INR 3 2.0 194.17 2026-04-20 22:37:30
4424 4439 1 1098 12555 64 Bio magnetic bracelet NULL 9404 2 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 19998.0 2500.0 5000.0 1.5 72.82 1.5 72.82 0.0 0.0 4854.37 145.63 5000.0 INR 3 2.0 97.09 2026-04-20 22:55:05
4425 4440 1 1099 12516 64 Bio magnetic bracelet NULL 9404 20 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 199980.0 25000.0 50000.0 1.5 728.16 1.5 728.16 0.0 0.0 48543.69 1456.31 50000.0 INR 1 8.0 3883.5 2026-04-20 23:01:59
4426 4441 1 1100 12554 64 Bio magnetic bracelet NULL 9404 10 1250.0 9999.0 0.0 0.0 2500.0 2427.18 72.82 99990.0 12500.0 25000.0 1.5 364.08 1.5 364.08 0.0 0.0 24271.85 728.16 25000.0 INR 2 6.0 1456.31 2026-04-20 23:07:34
4427 4442 1 1101 12534 70 Premium Hand belt NULL 9404 2 720.0 2500.0 0.0 0.0 1440.0 1371.43 68.57 5000.0 1440.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 2742.86 137.14 2880.0 INR 3 2.0 54.86 2026-04-22 18:46:06
4428 4443 1 1102 12526 32 Neem Soap 100gm NULL 34011110 8 20.0 60.0 0.0 0.0 52.0 49.52 2.48 480.0 160.0 416.0 2.5 9.9 2.5 9.9 0.0 0.0 396.19 19.81 416.0 INR 3 2.0 7.92 2026-04-22 19:06:56
4429 4444 1 1103 12545 52 Bhoo sanjeevni 5 kg NULL 3103100 1 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 625.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-04-23 14:35:45
4430 4445 2 1103 12545 38 Dish Wash 500ml NULL 34029099 3 65.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 195.0 552.0 9.0 42.1 9.0 42.1 0.0 0.0 467.8 84.2 552.0 INR 3 2.0 9.36 2026-04-23 14:35:45
4431 4446 3 1103 12545 39 Fabric Wash 1000ml NULL 34029099 2 112.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 224.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-04-23 14:35:45
4432 4447 4 1103 12545 37 Floor Cleaner 500ml NULL 3924101 3 55.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 165.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-04-23 14:35:45
4433 4448 5 1103 12545 33 HALDI CHANDAN SOAP 100gm NULL 30049011 15 35.0 100.0 0.0 0.0 80.0 76.19 3.81 1500.0 525.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-04-23 14:35:45
4434 4449 6 1103 12545 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 2 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 2500.0 750.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-04-23 14:35:45
4435 4450 7 1103 12545 53 Terra care 2 kg NULL 3103100 1 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 575.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-04-23 14:35:45
4436 4451 8 1103 12545 36 Toilet Cleaner 500ml NULL 3924101 3 42.0 150.0 0.0 0.0 120.0 101.69 18.31 450.0 126.0 360.0 9.0 27.46 9.0 27.46 0.0 0.0 305.08 54.92 360.0 INR 3 2.0 6.1 2026-04-23 14:35:45
4437 4452 9 1103 12545 34 Toothpaste NULL 33061090 10 55.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 550.0 1590.0 9.0 121.27 9.0 121.27 0.0 0.0 1347.46 242.54 1590.0 INR 3 2.0 26.95 2026-04-23 14:35:45
4438 4453 1 1104 12516 65 SINGLE WELLNESS NULL 94041000 5 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 64995.0 26750.0 53500.0 2.5 1273.81 2.5 1273.81 0.0 0.0 50952.38 2547.62 53500.0 INR 1 8.0 4076.19 2026-04-24 15:23:28
4439 4454 1 1105 12554 65 SINGLE WELLNESS NULL 94041000 5 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 64995.0 26750.0 53500.0 2.5 1273.81 2.5 1273.81 0.0 0.0 50952.38 2547.62 53500.0 INR 2 6.0 3057.14 2026-04-24 15:27:44
4440 4455 1 1106 12555 65 SINGLE WELLNESS NULL 94041000 3 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 38997.0 16050.0 32100.0 2.5 764.29 2.5 764.29 0.0 0.0 30571.43 1528.57 32100.0 INR 3 2.0 611.43 2026-04-24 15:30:32
4441 4456 1 1107 12554 82 ALKALINE CAPSULE NULL 3402000 5 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 12500.0 4000.0 8250.0 2.5 196.43 2.5 196.43 0.0 0.0 7857.14 392.86 8250.0 INR 2 6.0 471.43 2026-04-24 15:32:24
4442 4457 1 1108 12555 82 ALKALINE CAPSULE NULL 3402000 5 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 12500.0 4000.0 8250.0 2.5 196.43 2.5 196.43 0.0 0.0 7857.14 392.86 8250.0 INR 3 2.0 157.14 2026-04-24 15:34:12
4443 4458 1 1109 12516 97 Go Goa NULL NA 10 1000.0 30000.0 0.0 0.0 20000.0 18348.62 1651.38 300000.0 10000.0 200000.0 4.5 8256.88 4.5 8256.88 0.0 0.0 183486.24 16513.76 200000.0 INR 1 8.0 14678.9 2026-04-24 19:47:26
4444 4459 1 1110 12554 97 Go Goa NULL NA 10 1000.0 30000.0 0.0 0.0 20000.0 18348.62 1651.38 300000.0 10000.0 200000.0 4.5 8256.88 4.5 8256.88 0.0 0.0 183486.24 16513.76 200000.0 INR 2 6.0 11009.17 2026-04-24 19:49:37
4445 4460 1 1111 12555 97 Go Goa NULL NA 10 1000.0 30000.0 0.0 0.0 20000.0 18348.62 1651.38 300000.0 10000.0 200000.0 4.5 8256.88 4.5 8256.88 0.0 0.0 183486.24 16513.76 200000.0 INR 3 2.0 3669.72 2026-04-24 19:54:20
4446 4461 1 1112 12526 6 Asthma Care NULL 30049011 1 360.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 360.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 3 2.0 13.7 2026-04-24 22:11:22
4447 4462 2 1112 12526 52 Bhoo sanjeevni 5 kg NULL 3103100 1 625.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 625.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-04-24 22:11:22
4448 4463 3 1112 12526 48 Glow it multi fruit face wash NULL 3304999 5 160.0 450.0 0.0 0.0 320.0 271.19 48.81 2250.0 800.0 1600.0 9.0 122.03 9.0 122.03 0.0 0.0 1355.93 244.07 1600.0 INR 3 2.0 27.12 2026-04-24 22:11:22
4449 4464 4 1112 12526 33 HALDI CHANDAN SOAP 100gm NULL 30049011 25 35.0 100.0 0.0 0.0 80.0 76.19 3.81 2500.0 875.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-04-24 22:11:22
4450 4465 5 1112 12526 53 Terra care 2 kg NULL 3103100 2 575.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 3000.0 1150.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-04-24 22:11:22