fx_franchise_order_product
| # | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4901 | 4916 | 3 | 1270 | 12532 | 15 | KIDNEY CARE 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-06-30 19:02:10 |
| 4902 | 4917 | 4 | 1270 | 12532 | 16 | Liver Care Juice | NULL | 2009899 | 3 | 150.0 | 349.0 | 0.0 | 0.0 | 300.0 | 285.71 | 14.29 | 1047.0 | 450.0 | 900.0 | 2.5 | 21.43 | 2.5 | 21.43 | 0.0 | 0.0 | 857.14 | 42.86 | 900.0 | INR | 3 | 2.0 | 17.14 | 2026-06-30 19:02:10 |
| 4903 | 4918 | 5 | 1270 | 12532 | 17 | Memory Booster Juice | NULL | 2009899 | 3 | 150.0 | 349.0 | 0.0 | 0.0 | 300.0 | 285.71 | 14.29 | 1047.0 | 450.0 | 900.0 | 2.5 | 21.43 | 2.5 | 21.43 | 0.0 | 0.0 | 857.14 | 42.86 | 900.0 | INR | 3 | 2.0 | 17.14 | 2026-06-30 19:02:10 |
| 4904 | 4919 | 6 | 1270 | 12532 | 94 | PAVANA DROPS | NULL | 30041211 | 2 | 249.0 | 699.0 | 0.0 | 0.0 | 499.0 | 475.24 | 23.76 | 1398.0 | 498.0 | 998.0 | 2.5 | 23.76 | 2.5 | 23.76 | 0.0 | 0.0 | 950.48 | 47.52 | 998.0 | INR | 3 | 2.0 | 19.01 | 2026-06-30 19:02:10 |
| 4905 | 4920 | 7 | 1270 | 12532 | 46 | Root Vitality Hair Oil | NULL | 3305901 | 5 | 102.0 | 255.0 | 0.0 | 0.0 | 204.0 | 194.29 | 9.71 | 1275.0 | 510.0 | 1020.0 | 2.5 | 24.29 | 2.5 | 24.29 | 0.0 | 0.0 | 971.43 | 48.57 | 1020.0 | INR | 3 | 2.0 | 19.43 | 2026-06-30 19:02:10 |
| 4906 | 4921 | 1 | 1271 | 12555 | 82 | ALKALINE CAPSULE | NULL | 3402000 | 10 | 800.0 | 2500.0 | 0.0 | 0.0 | 1650.0 | 1571.43 | 78.57 | 25000.0 | 8000.0 | 16500.0 | 2.5 | 392.86 | 2.5 | 392.86 | 0.0 | 0.0 | 15714.29 | 785.71 | 16500.0 | INR | 3 | 2.0 | 314.29 | 2026-06-30 19:05:03 |
| 4907 | 4922 | 1 | 1272 | 12555 | 47 | Premium Hair Care Shampoo | NULL | 3305109 | 5 | 279.0 | 699.0 | 0.0 | 0.0 | 559.0 | 532.38 | 26.62 | 3495.0 | 1395.0 | 2795.0 | 2.5 | 66.55 | 2.5 | 66.55 | 0.0 | 0.0 | 2661.91 | 133.1 | 2795.0 | INR | 3 | 2.0 | 53.24 | 2026-06-30 20:05:20 |
| 4908 | 4923 | 1 | 1273 | 12526 | 4 | Diabetic Care Capsules | NULL | 2936900 | 3 | 360.0 | 999.0 | 0.0 | 0.0 | 720.0 | 685.71 | 34.29 | 2997.0 | 1080.0 | 2160.0 | 2.5 | 51.43 | 2.5 | 51.43 | 0.0 | 0.0 | 2057.14 | 102.86 | 2160.0 | INR | 3 | 2.0 | 41.14 | 2026-06-30 21:15:28 |
| 4909 | 4924 | 2 | 1273 | 12526 | 39 | Fabric Wash 1000ml | NULL | 34029099 | 3 | 112.0 | 401.0 | 0.0 | 0.0 | 321.0 | 272.03 | 48.97 | 1203.0 | 336.0 | 963.0 | 9.0 | 73.45 | 9.0 | 73.45 | 0.0 | 0.0 | 816.1 | 146.9 | 963.0 | INR | 3 | 2.0 | 16.32 | 2026-06-30 21:15:28 |
| 4910 | 4925 | 3 | 1273 | 12526 | 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-06-30 21:15:28 |
| 4911 | 4926 | 4 | 1273 | 12526 | 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-06-30 21:15:28 |
| 4912 | 4927 | 1 | 1274 | 12527 | 52 | Bhoo sanjeevni 5 kg | NULL | 3103100 | 4 | 625.0 | 1600.0 | 0.0 | 0.0 | 1250.0 | 1190.48 | 59.52 | 6400.0 | 2500.0 | 5000.0 | 2.5 | 119.05 | 2.5 | 119.05 | 0.0 | 0.0 | 4761.9 | 238.1 | 5000.0 | INR | 3 | 2.0 | 95.24 | 2026-07-07 14:11:57 |
| 4913 | 4928 | 2 | 1274 | 12527 | 53 | Terra care 2 kg | NULL | 3103100 | 4 | 575.0 | 1500.0 | 0.0 | 0.0 | 1150.0 | 1095.24 | 54.76 | 6000.0 | 2300.0 | 4600.0 | 2.5 | 109.52 | 2.5 | 109.52 | 0.0 | 0.0 | 4380.95 | 219.05 | 4600.0 | INR | 3 | 2.0 | 87.62 | 2026-07-07 14:11:57 |
| 4914 | 4929 | 1 | 1275 | 12555 | 60 | Foot patch | NULL | 30051090 | 3 | 799.0 | 1999.0 | 0.0 | 0.0 | 1599.0 | 1522.86 | 76.14 | 5997.0 | 2397.0 | 4797.0 | 2.5 | 114.21 | 2.5 | 114.21 | 0.0 | 0.0 | 4568.57 | 228.43 | 4797.0 | INR | 3 | 2.0 | 91.37 | 2026-07-14 19:28:34 |
| 4915 | 4930 | 1 | 1276 | 12527 | 70 | Premium Hand belt | NULL | 9404 | 1 | 720.0 | 2500.0 | 0.0 | 0.0 | 1440.0 | 1371.43 | 68.57 | 2500.0 | 720.0 | 1440.0 | 2.5 | 34.29 | 2.5 | 34.29 | 0.0 | 0.0 | 1371.43 | 68.57 | 1440.0 | INR | 3 | 2.0 | 27.43 | 2026-07-16 13:56:54 |
| 4916 | 4931 | 2 | 1276 | 12527 | 6 | ASTORELIFE GUARD | NULL | 30049011 | 2 | 360.0 | 899.0 | 0.0 | 0.0 | 720.0 | 685.71 | 34.29 | 1798.0 | 720.0 | 1440.0 | 2.5 | 34.29 | 2.5 | 34.29 | 0.0 | 0.0 | 1371.43 | 68.57 | 1440.0 | INR | 3 | 2.0 | 27.43 | 2026-07-16 13:56:54 |
| 4917 | 4932 | 3 | 1276 | 12527 | 3 | BP Care Capsules | NULL | 2936900 | 2 | 360.0 | 999.0 | 0.0 | 0.0 | 720.0 | 685.71 | 34.29 | 1998.0 | 720.0 | 1440.0 | 2.5 | 34.29 | 2.5 | 34.29 | 0.0 | 0.0 | 1371.43 | 68.57 | 1440.0 | INR | 3 | 2.0 | 27.43 | 2026-07-16 13:56:54 |
| 4918 | 4933 | 4 | 1276 | 12527 | 4 | Diabetic Care Capsules | NULL | 2936900 | 2 | 360.0 | 999.0 | 0.0 | 0.0 | 720.0 | 685.71 | 34.29 | 1998.0 | 720.0 | 1440.0 | 2.5 | 34.29 | 2.5 | 34.29 | 0.0 | 0.0 | 1371.43 | 68.57 | 1440.0 | INR | 3 | 2.0 | 27.43 | 2026-07-16 13:56:54 |
| 4919 | 4934 | 5 | 1276 | 12527 | 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-07-16 13:56:54 |
| 4920 | 4935 | 6 | 1276 | 12527 | 28 | Ortho Joint Shield | NULL | 2009899 | 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-07-16 13:56:54 |
| 4921 | 4936 | 7 | 1276 | 12527 | 46 | Root Vitality Hair Oil | NULL | 3305901 | 20 | 102.0 | 255.0 | 0.0 | 0.0 | 204.0 | 194.29 | 9.71 | 5100.0 | 2040.0 | 4080.0 | 2.5 | 97.14 | 2.5 | 97.14 | 0.0 | 0.0 | 3885.71 | 194.29 | 4080.0 | INR | 3 | 2.0 | 77.71 | 2026-07-16 13:56:54 |
| 4922 | 4937 | 8 | 1276 | 12527 | 29 | Shilajith | NULL | 30049011 | 1 | 400.0 | 1500.0 | 0.0 | 0.0 | 1200.0 | 1142.86 | 57.14 | 1500.0 | 400.0 | 1200.0 | 2.5 | 28.57 | 2.5 | 28.57 | 0.0 | 0.0 | 1142.86 | 57.14 | 1200.0 | INR | 3 | 0.0 | 2.0 | 2026-07-16 13:56:54 |
| 4923 | 4938 | 1 | 1277 | 12527 | 4 | Diabetic Care Capsules | NULL | 2936900 | 2 | 360.0 | 999.0 | 0.0 | 0.0 | 720.0 | 685.71 | 34.29 | 1998.0 | 720.0 | 1440.0 | 2.5 | 34.29 | 2.5 | 34.29 | 0.0 | 0.0 | 1371.43 | 68.57 | 1440.0 | INR | 3 | 2.0 | 27.43 | 2026-07-30 09:46:26 |
| 4924 | 4939 | 2 | 1277 | 12527 | 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-07-30 09:46:26 |
| 4925 | 4940 | 3 | 1277 | 12527 | 33 | HALDI CHANDAN SOAP 100gm | NULL | 30049011 | 50 | 35.0 | 100.0 | 0.0 | 0.0 | 80.0 | 76.19 | 3.81 | 5000.0 | 1750.0 | 4000.0 | 2.5 | 95.24 | 2.5 | 95.24 | 0.0 | 0.0 | 3809.53 | 190.48 | 4000.0 | INR | 3 | 2.0 | 76.19 | 2026-07-30 09:46:26 |
| 4926 | 4941 | 4 | 1277 | 12527 | 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-07-30 09:46:26 |
| 4927 | 4942 | 5 | 1277 | 12527 | 35 | Sanitary Pad (15 pcs) | NULL | 9619001 | 10 | 150.0 | 380.0 | 0.0 | 0.0 | 304.0 | 304.0 | 0.0 | 3800.0 | 1500.0 | 3040.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 3040.0 | 0.0 | 3040.0 | INR | 3 | 2.0 | 60.8 | 2026-07-30 09:46:26 |
| 4928 | 4943 | 6 | 1277 | 12527 | 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-07-30 09:46:26 |
| 4929 | 4944 | 1 | 1278 | 12526 | 39 | Fabric Wash 1000ml | NULL | 34029099 | 1 | 112.0 | 401.0 | 0.0 | 0.0 | 321.0 | 272.03 | 48.97 | 401.0 | 112.0 | 321.0 | 9.0 | 24.48 | 9.0 | 24.48 | 0.0 | 0.0 | 272.03 | 48.97 | 321.0 | INR | 3 | 2.0 | 5.44 | 2026-07-31 13:11:15 |
| 4930 | 4945 | 2 | 1278 | 12526 | 33 | HALDI CHANDAN SOAP 100gm | NULL | 30049011 | 30 | 35.0 | 100.0 | 0.0 | 0.0 | 80.0 | 76.19 | 3.81 | 3000.0 | 1050.0 | 2400.0 | 2.5 | 57.14 | 2.5 | 57.14 | 0.0 | 0.0 | 2285.72 | 114.29 | 2400.0 | INR | 3 | 2.0 | 45.71 | 2026-07-31 13:11:15 |
| 4931 | 4946 | 3 | 1278 | 12526 | 7 | Morning Fresh Churan | NULL | 30049011 | 1 | 79.0 | 199.0 | 0.0 | 0.0 | 179.0 | 170.48 | 8.52 | 199.0 | 79.0 | 179.0 | 2.5 | 4.26 | 2.5 | 4.26 | 0.0 | 0.0 | 170.48 | 8.52 | 179.0 | INR | 3 | 2.0 | 3.41 | 2026-07-31 13:11:15 |
| 4932 | 4947 | 4 | 1278 | 12526 | 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-07-31 13:11:15 |
| 4933 | 4948 | 5 | 1278 | 12526 | 46 | Root Vitality Hair Oil | NULL | 3305901 | 20 | 102.0 | 255.0 | 0.0 | 0.0 | 204.0 | 194.29 | 9.71 | 5100.0 | 2040.0 | 4080.0 | 2.5 | 97.14 | 2.5 | 97.14 | 0.0 | 0.0 | 3885.71 | 194.29 | 4080.0 | INR | 3 | 2.0 | 77.71 | 2026-07-31 13:11:15 |