fx_franchise_order_product

4,933 rows · 33 columns · page 4 / 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
151 164 9 57 12557 72 Pain Relief Patch NULL 30051090 1 200.0 800.0 0.0 0.0 640.0 609.52 30.48 800.0 200.0 640.0 2.5 15.24 2.5 15.24 0.0 0.0 609.52 30.48 640.0 INR 0 0.0 0.0 2025-11-07 18:20:42
152 165 10 57 12557 46 Root Vitality Hair Oil NULL 3305901 10 54.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 540.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 194.29 97.14 2040.0 INR 0 0.0 0.0 2025-11-07 18:20:42
153 166 11 57 12557 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 18:20:42
154 167 12 57 12557 44 Vital Glow Face Scrub NULL 3304300 2 71.0 325.0 0.0 0.0 260.0 220.34 39.66 650.0 142.0 520.0 9.0 39.66 9.0 39.66 0.0 0.0 220.34 79.32 520.0 INR 0 0.0 0.0 2025-11-07 18:20:42
155 168 1 58 12524 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 9.0 69.56 9.0 69.56 0.0 0.0 257.63 139.12 912.0 INR 0 0.0 0.0 2025-11-07 18:31:54
156 169 2 58 12524 70 Premium Hand belt NULL 9404 2 600.0 9999.0 0.0 0.0 7999.2 7618.29 380.92 19998.0 1200.0 15998.4 2.5 380.92 2.5 380.92 0.0 0.0 7618.29 761.83 15998.4 INR 0 0.0 0.0 2025-11-07 18:31:54
157 170 3 58 12524 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 18:31:54
158 171 4 58 12524 3 BP Care Capsules NULL 2936900 3 160.0 599.0 0.0 0.0 479.2 456.38 22.82 1797.0 480.0 1437.6 2.5 34.23 2.5 34.23 0.0 0.0 456.38 68.46 1437.6 INR 0 0.0 0.0 2025-11-07 18:31:54
159 172 5 58 12524 4 Diabetic Care Capsules NULL 2936900 4 250.0 899.0 0.0 0.0 719.2 684.95 34.25 3596.0 1000.0 2876.8 2.5 68.5 2.5 68.5 0.0 0.0 684.95 136.99 2876.8 INR 0 0.0 0.0 2025-11-07 18:31:54
160 173 6 58 12524 38 Dish Wash 500ml NULL 3924101 4 85.0 230.0 0.0 0.0 184.0 155.93 28.07 920.0 340.0 736.0 9.0 56.13 9.0 56.13 0.0 0.0 155.93 112.27 736.0 INR 0 0.0 0.0 2025-11-07 18:31:54
161 174 7 58 12524 39 Fabric Wash 1000ml NULL 3924101 11 150.0 401.0 0.0 0.0 320.8 271.86 48.94 4411.0 1650.0 3528.8 9.0 269.14 9.0 269.14 0.0 0.0 271.86 538.29 3528.8 INR 0 0.0 0.0 2025-11-07 18:31:54
162 175 8 58 12524 60 Foot patch NULL 30051090 1 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 1999.0 500.0 1599.2 2.5 38.08 2.5 38.08 0.0 0.0 1523.05 76.15 1599.2 INR 0 0.0 0.0 2025-11-07 18:31:54
163 176 9 58 12524 33 Herbal Soap 100gm NULL 30049011 10 28.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 280.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 76.19 38.1 800.0 INR 0 0.0 0.0 2025-11-07 18:31:54
164 177 10 58 12524 34 Herbo2o Toothpaste NULL 33061090 2 45.0 199.0 0.0 0.0 159.2 134.92 24.29 398.0 90.0 318.4 9.0 24.29 9.0 24.29 0.0 0.0 134.92 48.57 318.4 INR 0 0.0 0.0 2025-11-07 18:31:54
165 178 11 58 12524 25 Manicalcium Tablets NULL 2009899 1 95.0 399.0 0.0 0.0 319.2 304.0 15.2 399.0 95.0 319.2 2.5 7.6 2.5 7.6 0.0 0.0 304.0 15.2 319.2 INR 0 0.0 0.0 2025-11-07 18:31:54
166 179 12 58 12524 12 Melatonin 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 18:31:54
167 180 13 58 12524 17 Memory Booster Juice NULL 2009899 4 120.0 349.0 0.0 0.0 279.2 265.9 13.29 1396.0 480.0 1116.8 2.5 26.59 2.5 26.59 0.0 0.0 265.9 53.18 1116.8 INR 0 0.0 0.0 2025-11-07 18:31:54
168 181 14 58 12524 7 Morning Fresh Churan NULL 30049011 4 40.0 199.0 0.0 0.0 159.2 151.62 7.58 796.0 160.0 636.8 2.5 15.16 2.5 15.16 0.0 0.0 151.62 30.32 636.8 INR 0 0.0 0.0 2025-11-07 18:31:54
169 182 15 58 12524 32 Neem Soap 100gm NULL 34011110 88 10.0 60.0 0.0 0.0 48.0 45.71 2.29 5280.0 880.0 4224.0 2.5 100.57 2.5 100.57 0.0 0.0 45.71 201.14 4224.0 INR 0 0.0 0.0 2025-11-07 18:31:54
170 183 16 58 12524 8 Piles 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 18:31:54
171 184 17 58 12524 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 18:31:54
172 185 18 58 12524 35 Sanitary Pad (15 pcs) NULL 9619001 15 40.0 380.0 0.0 0.0 304.0 304.0 0.0 5700.0 600.0 4560.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 4560.0 INR 0 0.0 0.0 2025-11-07 18:31:54
173 186 19 58 12524 29 Shilajith NULL 30049011 4 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 7200.0 1000.0 5760.0 2.5 137.15 2.5 137.15 0.0 0.0 1371.43 274.29 5760.0 INR 0 0.0 0.0 2025-11-07 18:31:54
174 187 20 58 12524 26 Spirulina Cap NULL 2009899 2 190.0 899.0 0.0 0.0 719.2 684.95 34.25 1798.0 380.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 18:31:54
175 188 21 58 12524 5 Thyro Care NULL 2936900 6 250.0 899.0 0.0 0.0 719.2 684.95 34.25 5394.0 1500.0 4315.2 2.5 102.75 2.5 102.75 0.0 0.0 684.95 205.49 4315.2 INR 0 0.0 0.0 2025-11-07 18:31:54
176 189 22 58 12524 11 Vitamin B12 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 18:31:54
177 190 23 58 12524 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 18:31:54
178 191 1 59 12516 48 glow face wash NULL 3304999 89 250.0 380.0 0.0 0.0 304.0 257.63 46.37 33820.0 22250.0 27056.0 9.0 2063.59 9.0 2063.59 0.0 0.0 257.63 4127.19 27056.0 INR 0 0.0 0.0 2025-11-07 18:37:14
179 192 2 59 12516 27 Multicharge Cap NULL 2009899 7 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 10493.0 3150.0 8394.4 2.5 199.87 2.5 199.87 0.0 0.0 1142.1 399.73 8394.4 INR 0 0.0 0.0 2025-11-07 18:37:14
180 193 3 59 12516 20 Premium Berry Juice 1000ml NULL 2936900 10 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 34990.0 7500.0 34790.0 2.5 828.34 2.5 828.34 0.0 0.0 3313.33 1656.67 34790.0 INR 0 0.0 0.0 2025-11-07 18:37:14
181 194 4 59 12516 70 Premium Hand belt NULL 9404 18 600.0 9999.0 0.0 0.0 7999.2 7618.29 380.91 179982.0 10800.0 143985.6 2.5 3428.23 2.5 3428.23 0.0 0.0 7618.29 6856.46 143985.6 INR 0 0.0 0.0 2025-11-07 18:37:14
182 195 5 59 12516 61 Radiation chip NULL 902221 10 325.0 999.0 0.0 0.0 799.2 677.29 121.91 9990.0 3250.0 7992.0 9.0 609.56 9.0 609.56 0.0 0.0 677.29 1219.12 7992.0 INR 0 0.0 0.0 2025-11-07 18:37:14
183 196 6 59 12516 31 Vegan Plant Protein Powder NULL 21061000 2 1000.0 2999.0 0.0 0.0 2399.2 2284.95 114.25 5998.0 2000.0 4798.4 2.5 114.25 2.5 114.25 0.0 0.0 2284.95 228.5 4798.4 INR 0 0.0 0.0 2025-11-07 18:37:14
184 197 7 59 12516 79 ALKALINE JUG NULL 8421 5 3500.0 14999.0 0.0 0.0 11999.2 10168.81 1830.39 74995.0 17500.0 59996.0 9.0 4575.97 9.0 4575.97 0.0 0.0 10168.81 9151.93 59996.0 INR 0 0.0 0.0 2025-11-07 18:37:14
185 198 8 59 12516 21 All Fuel Juice NULL 22029990 5 350.0 2499.0 0.0 0.0 2479.0 2360.95 118.05 12495.0 1750.0 12395.0 2.5 295.12 2.5 295.12 0.0 0.0 2360.95 590.24 12395.0 INR 0 0.0 0.0 2025-11-07 18:37:14
186 199 9 59 12516 49 Anti Dandruff Serum NULL 3304999 1 250.0 999.0 0.0 0.0 799.2 677.29 121.91 999.0 250.0 799.2 9.0 60.95 9.0 60.95 0.0 0.0 677.29 121.91 799.2 INR 0 0.0 0.0 2025-11-07 18:37:14
187 200 10 59 12516 6 Asthma Care NULL 30049011 24 250.0 899.0 0.0 0.0 719.2 684.95 34.25 21576.0 6000.0 17260.8 2.5 410.97 2.5 410.97 0.0 0.0 684.95 821.94 17260.8 INR 0 0.0 0.0 2025-11-07 18:37:14
188 201 11 59 12516 40 Bamboo Brush NULL 96032100 85 25.0 110.0 0.0 0.0 88.0 74.58 13.42 9350.0 2125.0 7480.0 9.0 570.51 9.0 570.51 0.0 0.0 74.58 1141.02 7480.0 INR 0 0.0 0.0 2025-11-07 18:37:14
189 202 12 59 12516 52 Bhoo sanjeevni 5 kg NULL 3103100 68 450.0 1600.0 0.0 0.0 1280.0 1219.05 60.95 108800.0 30600.0 87040.0 2.5 2072.38 2.5 2072.38 0.0 0.0 1219.05 4144.76 87040.0 INR 0 0.0 0.0 2025-11-07 18:37:14
190 203 13 59 12516 71 Bio magnetic water pad NULL 9404 6 1000.0 4500.0 0.0 0.0 3600.0 3428.57 171.43 27000.0 6000.0 21600.0 2.5 514.28 2.5 514.28 0.0 0.0 3428.57 1028.57 21600.0 INR 0 0.0 0.0 2025-11-07 18:37:14
191 204 14 59 12516 3 BP Care Capsules NULL 2936900 74 160.0 599.0 0.0 0.0 479.2 456.38 22.82 44326.0 11840.0 35460.8 2.5 844.3 2.5 844.3 0.0 0.0 456.38 1688.61 35460.8 INR 0 0.0 0.0 2025-11-07 18:37:14
192 205 15 59 12516 4 Diabetic Care Capsules NULL 2936900 45 250.0 899.0 0.0 0.0 719.2 684.95 34.25 40455.0 11250.0 32364.0 2.5 770.57 2.5 770.57 0.0 0.0 684.95 1541.14 32364.0 INR 0 0.0 0.0 2025-11-07 18:37:14
193 206 16 59 12516 38 Dish Wash 500ml NULL 3924101 197 85.0 230.0 0.0 0.0 184.0 155.93 28.07 45310.0 16745.0 36248.0 9.0 2764.68 9.0 2764.68 0.0 0.0 155.93 5529.36 36248.0 INR 0 0.0 0.0 2025-11-07 18:37:14
194 207 17 59 12516 39 Fabric Wash 1000ml NULL 3924101 166 150.0 401.0 0.0 0.0 320.8 271.86 48.94 66566.0 24900.0 53252.8 9.0 4061.66 9.0 4061.66 0.0 0.0 271.86 8123.31 53252.8 INR 0 0.0 0.0 2025-11-07 18:37:14
195 208 18 59 12516 19 Fat loss Juice 500 ml NULL 30049011 7 250.0 1499.0 0.0 0.0 1479.0 1408.57 70.43 10493.0 1750.0 10353.0 2.5 246.5 2.5 246.5 0.0 0.0 1408.57 493.0 10353.0 INR 0 0.0 0.0 2025-11-07 18:37:14
196 209 19 59 12516 22 Fit Fuel Juice NULL 2009899 4 200.0 1999.0 0.0 0.0 1979.0 1884.76 94.24 7996.0 800.0 7916.0 2.5 188.47 2.5 188.47 0.0 0.0 1884.76 376.95 7916.0 INR 0 0.0 0.0 2025-11-07 18:37:14
197 210 20 59 12516 37 Floor Cleaner 500ml NULL 3924101 125 80.0 199.0 0.0 0.0 159.2 134.92 24.28 24875.0 10000.0 19900.0 9.0 1517.8 9.0 1517.8 0.0 0.0 134.92 3035.59 19900.0 INR 0 0.0 0.0 2025-11-07 18:37:14
198 211 21 59 12516 60 Foot patch NULL 30051090 52 500.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 103948.0 26000.0 83158.4 2.5 1979.96 2.5 1979.96 0.0 0.0 1523.05 3959.92 83158.4 INR 0 0.0 0.0 2025-11-07 18:37:14
199 212 22 59 12516 58 Green shield 250ml NULL 3105 14 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 35000.0 11200.0 28000.0 2.5 666.66 2.5 666.66 0.0 0.0 1904.76 1333.33 28000.0 INR 0 0.0 0.0 2025-11-07 18:37:14
200 213 23 59 12516 55 Grow master 500ml NULL 3105 33 850.0 2030.0 0.0 0.0 1624.0 1546.67 77.33 66990.0 28050.0 53592.0 2.5 1276.0 2.5 1276.0 0.0 0.0 1546.67 2552.0 53592.0 INR 0 0.0 0.0 2025-11-07 18:37:14