fx_franchise_order_product

4,933 rows · 33 columns · page 98 / 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
4851 4866 1 1251 12526 60 Foot patch NULL 30051090 1 799.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 1999.0 799.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1522.86 76.14 1599.0 INR 3 2.0 30.46 2026-06-15 23:06:46
4852 4867 2 1251 12526 96 TRIM 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-06-15 23:06:46
4853 4868 1 1252 16410 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 4 4.0 60.95 2026-06-17 10:59:31
4854 4869 2 1252 16410 48 Glow it multi fruit face wash NULL 3304999 1 160.0 450.0 0.0 0.0 320.0 271.19 48.81 450.0 160.0 320.0 9.0 24.41 9.0 24.41 0.0 0.0 271.19 48.81 320.0 INR 4 4.0 10.85 2026-06-17 10:59:31
4855 4870 3 1252 16410 33 HALDI CHANDAN SOAP 100gm NULL 30049011 4 35.0 100.0 0.0 0.0 80.0 76.19 3.81 400.0 140.0 320.0 2.5 7.62 2.5 7.62 0.0 0.0 304.76 15.24 320.0 INR 4 4.0 12.19 2026-06-17 10:59:31
4856 4871 4 1252 16410 30 Iron Capsules NULL 30049011 2 359.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 718.0 1438.0 2.5 34.24 2.5 34.24 0.0 0.0 1369.52 68.48 1438.0 INR 4 4.0 54.78 2026-06-17 10:59:31
4857 4872 5 1252 16410 28 Ortho Joint Shield NULL 2009899 2 600.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 1200.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 4 2.0 45.71 2026-06-17 10:59:31
4858 4873 6 1252 16410 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 400.0 380.95 19.05 800.0 200.0 400.0 2.5 9.52 2.5 9.52 0.0 0.0 380.95 19.05 400.0 INR 4 4.0 15.24 2026-06-17 10:59:31
4859 4874 1 1253 12555 30 Iron Capsules NULL 30049011 10 359.0 899.0 0.0 0.0 719.0 684.76 34.24 8990.0 3590.0 7190.0 2.5 171.19 2.5 171.19 0.0 0.0 6847.62 342.38 7190.0 INR 3 2.0 136.95 2026-06-17 11:26:59
4860 4875 1 1254 12517 46 Root Vitality Hair Oil NULL 3305901 30 102.0 255.0 0.0 0.0 204.0 194.29 9.71 7650.0 3060.0 6120.0 0.0 0.0 0.0 0.0 5.0 291.43 5828.57 291.43 6120.0 INR 2 6.0 349.71 2026-06-17 11:29:12
4861 4876 1 1255 12527 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-06-22 10:10:04
4862 4877 1 1256 12685 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-06-22 18:33:33
4863 4878 2 1256 12685 10 RADIANCE GLOW DAY CREAM NULL 33049900 2 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 2848.0 750.0 1500.0 9.0 114.41 9.0 114.41 0.0 0.0 1271.19 228.81 1500.0 INR 3 2.0 25.42 2026-06-22 18:33:33
4864 4879 3 1256 12685 46 Root Vitality Hair Oil NULL 3305901 12 102.0 255.0 0.0 0.0 204.0 194.29 9.71 3060.0 1224.0 2448.0 2.5 58.29 2.5 58.29 0.0 0.0 2331.43 116.57 2448.0 INR 3 2.0 46.63 2026-06-22 18:33:33
4865 4880 1 1257 12527 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-06-23 09:48:47
4866 4881 1 1258 12526 38 Dish Wash 500ml NULL 34029099 4 65.0 230.0 0.0 0.0 184.0 155.93 28.07 920.0 260.0 736.0 9.0 56.14 9.0 56.14 0.0 0.0 623.73 112.27 736.0 INR 3 2.0 12.47 2026-06-27 10:07:22
4867 4882 1 1259 12516 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 1 8.0 1219.05 2026-06-28 15:55:37
4868 4883 2 1259 12516 66 Premium Blanket Single NULL 9404 10 3750.0 14999.0 0.0 0.0 7500.0 7142.86 357.14 149990.0 37500.0 75000.0 2.5 1785.71 2.5 1785.71 0.0 0.0 71428.57 3571.43 75000.0 INR 1 8.0 5714.29 2026-06-28 15:55:37
4869 4884 3 1259 12516 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 2.5 2547.62 2.5 2547.62 0.0 0.0 101904.76 5095.24 107000.0 INR 1 8.0 8152.38 2026-06-28 15:55:37
4870 4885 1 1260 12554 66 Premium Blanket Single NULL 9404 6 3750.0 14999.0 0.0 0.0 7500.0 7142.86 357.14 89994.0 22500.0 45000.0 2.5 1071.43 2.5 1071.43 0.0 0.0 42857.14 2142.86 45000.0 INR 2 6.0 2571.43 2026-06-28 17:22:54
4871 4886 2 1260 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-06-28 17:22:54
4872 4887 1 1261 12555 66 Premium Blanket Single NULL 9404 5 3750.0 14999.0 0.0 0.0 7500.0 7142.86 357.14 74995.0 18750.0 37500.0 2.5 892.86 2.5 892.86 0.0 0.0 35714.29 1785.71 37500.0 INR 3 2.0 714.29 2026-06-28 19:03:22
4873 4888 2 1261 12555 65 SINGLE WELLNESS NULL 94041000 2 5350.0 12999.0 0.0 0.0 10700.0 10190.48 509.52 25998.0 10700.0 21400.0 2.5 509.52 2.5 509.52 0.0 0.0 20380.95 1019.05 21400.0 INR 3 2.0 407.62 2026-06-28 19:03:22
4874 4889 1 1262 12527 15 KIDNEY CARE JUICE NULL 2009899 2 150.0 349.0 0.0 0.0 300.0 285.71 14.29 698.0 300.0 600.0 2.5 14.29 2.5 14.29 0.0 0.0 571.43 28.57 600.0 INR 3 2.0 11.43 2026-06-29 10:18:38
4875 4890 1 1263 12517 11 BHRINGRAJ & SHIKAKAI NULL 33051090 4 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 5000.0 1500.0 3000.0 0.0 0.0 0.0 0.0 5.0 142.86 2857.14 142.86 3000.0 INR 2 6.0 171.43 2026-06-29 17:25:02
4876 4891 2 1263 12517 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 9 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 11250.0 3375.0 6750.0 0.0 0.0 0.0 0.0 5.0 321.43 6428.57 321.43 6750.0 INR 2 6.0 385.71 2026-06-29 17:25:02
4877 4892 3 1263 12517 10 RADIANCE GLOW DAY CREAM NULL 33049900 20 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 28480.0 7500.0 15000.0 0.0 0.0 0.0 0.0 18.0 2288.14 12711.86 2288.14 15000.0 INR 2 6.0 762.71 2026-06-29 17:25:02
4878 4893 4 1263 12517 46 Root Vitality Hair Oil NULL 3305901 60 102.0 255.0 0.0 0.0 204.0 194.29 9.71 15300.0 6120.0 12240.0 0.0 0.0 0.0 0.0 5.0 582.86 11657.14 582.86 12240.0 INR 2 6.0 699.43 2026-06-29 17:25:02
4879 4894 5 1263 12517 96 TRIM VEDA NULL 30049011 4 750.0 2500.0 0.0 0.0 1500.0 1428.57 71.43 10000.0 3000.0 6000.0 0.0 0.0 0.0 0.0 5.0 285.71 5714.29 285.71 6000.0 INR 2 6.0 342.86 2026-06-29 17:25:02
4880 4895 1 1264 12517 47 Premium Hair Care Shampoo NULL 3305109 11 279.0 699.0 0.0 0.0 559.0 532.38 26.62 7689.0 3069.0 6149.0 0.0 0.0 0.0 0.0 5.0 292.81 5856.19 292.81 6149.0 INR 2 6.0 351.37 2026-06-29 18:30:31
4881 4896 2 1264 12517 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 9 375.0 1250.0 0.0 0.0 750.0 714.29 35.71 11250.0 3375.0 6750.0 0.0 0.0 0.0 0.0 5.0 321.43 6428.57 321.43 6750.0 INR 2 6.0 385.71 2026-06-29 18:30:31
4882 4897 3 1264 12517 10 RADIANCE GLOW DAY CREAM NULL 33049900 15 375.0 1424.0 0.0 0.0 750.0 635.59 114.41 21360.0 5625.0 11250.0 0.0 0.0 0.0 0.0 18.0 1716.1 9533.9 1716.1 11250.0 INR 2 6.0 572.03 2026-06-29 18:30:31
4883 4898 4 1264 12517 46 Root Vitality Hair Oil NULL 3305901 60 102.0 255.0 0.0 0.0 204.0 194.29 9.71 15300.0 6120.0 12240.0 0.0 0.0 0.0 0.0 5.0 582.86 11657.14 582.86 12240.0 INR 2 6.0 699.43 2026-06-29 18:30:31
4884 4899 1 1265 12526 82 ALKALINE CAPSULE NULL 3402000 2 800.0 2500.0 0.0 0.0 1650.0 1571.43 78.57 5000.0 1600.0 3300.0 2.5 78.57 2.5 78.57 0.0 0.0 3142.86 157.14 3300.0 INR 3 2.0 62.86 2026-06-29 22:33:56
4885 4900 2 1265 12526 39 Fabric Wash 1000ml NULL 34029099 4 112.0 401.0 0.0 0.0 321.0 272.03 48.97 1604.0 448.0 1284.0 9.0 97.93 9.0 97.93 0.0 0.0 1088.14 195.86 1284.0 INR 3 2.0 21.76 2026-06-29 22:33:56
4886 4901 3 1265 12526 81 PREMIUM GLOW FACE WASH NULL 3404 2 279.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 558.0 1118.0 9.0 85.27 9.0 85.27 0.0 0.0 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-06-29 22:33:56
4887 4902 4 1265 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-06-29 22:33:56
4888 4903 1 1266 12527 20 Premium Berry Juice 1000ml NULL 2936900 1 800.0 3499.0 0.0 0.0 1600.0 1523.81 76.19 3499.0 800.0 1600.0 2.5 38.1 2.5 38.1 0.0 0.0 1523.81 76.19 1600.0 INR 3 2.0 30.48 2026-06-30 07:53:39
4889 4904 2 1266 12527 38 Dish Wash 500ml NULL 34029099 20 65.0 230.0 0.0 0.0 184.0 155.93 28.07 4600.0 1300.0 3680.0 9.0 280.68 9.0 280.68 0.0 0.0 3118.64 561.36 3680.0 INR 3 2.0 62.37 2026-06-30 07:53:39
4890 4905 3 1266 12527 37 Floor Cleaner 500ml NULL 3924101 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-06-30 07:53:39
4891 4906 4 1266 12527 34 HERBO 33 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-06-30 07:53:39
4892 4907 5 1266 12527 94 PAVANA DROPS NULL 30041211 3 249.0 699.0 0.0 0.0 499.0 475.24 23.76 2097.0 747.0 1497.0 2.5 35.64 2.5 35.64 0.0 0.0 1425.71 71.29 1497.0 INR 3 2.0 28.51 2026-06-30 07:53:39
4893 4908 6 1266 12527 36 Toilet Cleaner 500ml NULL 3924101 10 42.0 150.0 0.0 0.0 120.0 101.69 18.31 1500.0 420.0 1200.0 9.0 91.53 9.0 91.53 0.0 0.0 1016.95 183.05 1200.0 INR 3 2.0 20.34 2026-06-30 07:53:39
4894 4909 1 1267 12539 2 Heart Care Capsules NULL 2936900 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-06-30 14:28:31
4895 4910 2 1267 12539 46 Root Vitality Hair Oil NULL 3305901 7 102.0 255.0 0.0 0.0 204.0 194.29 9.71 1785.0 714.0 1428.0 2.5 34.0 2.5 34.0 0.0 0.0 1360.0 68.0 1428.0 INR 3 2.0 27.2 2026-06-30 14:28:31
4896 4911 1 1268 12545 34 HERBO 33 TOOTHPASTE NULL 33061090 14 55.0 199.0 0.0 0.0 159.0 134.75 24.25 2786.0 770.0 2226.0 9.0 169.78 9.0 169.78 0.0 0.0 1886.44 339.56 2226.0 INR 3 2.0 37.73 2026-06-30 16:36:58
4897 4912 2 1268 12545 46 Root Vitality Hair Oil NULL 3305901 12 102.0 255.0 0.0 0.0 204.0 194.29 9.71 3060.0 1224.0 2448.0 2.5 58.29 2.5 58.29 0.0 0.0 2331.43 116.57 2448.0 INR 3 2.0 46.63 2026-06-30 16:36:58
4898 4913 1 1269 12539 46 Root Vitality Hair Oil NULL 3305901 8 102.0 255.0 0.0 0.0 204.0 194.29 9.71 2040.0 816.0 1632.0 2.5 38.86 2.5 38.86 0.0 0.0 1554.29 77.71 1632.0 INR 3 2.0 31.09 2026-06-30 17:47:50
4899 4914 1 1270 12532 4 Diabetic Care Capsules NULL 2936900 5 360.0 999.0 0.0 0.0 720.0 685.71 34.29 4995.0 1800.0 3600.0 2.5 85.71 2.5 85.71 0.0 0.0 3428.57 171.43 3600.0 INR 3 2.0 68.57 2026-06-30 19:02:10
4900 4915 2 1270 12532 48 Glow it multi fruit face wash NULL 3304999 3 160.0 450.0 0.0 0.0 320.0 271.19 48.81 1350.0 480.0 960.0 9.0 73.22 9.0 73.22 0.0 0.0 813.56 146.44 960.0 INR 3 2.0 16.27 2026-06-30 19:02:10