fx_franchise_order_product

4,933 rows · 33 columns · page 5 / 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
201 214 24 59 12516 2 Heart Care Capsules NULL 2936900 10 425.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 14990.0 4250.0 11992.0 2.5 285.52 2.5 285.52 0.0 0.0 1142.1 571.05 11992.0 INR 0 0.0 0.0 2025-11-07 18:37:14
202 215 25 59 12516 33 Herbal Soap 100gm NULL 30049011 1593 28.0 100.0 0.0 0.0 80.0 76.19 3.81 159300.0 44604.0 127440.0 2.5 3034.28 2.5 3034.28 0.0 0.0 76.19 6068.57 127440.0 INR 0 0.0 0.0 2025-11-07 18:37:14
203 216 26 59 12516 34 Herbo2o Toothpaste NULL 33061090 597 45.0 199.0 0.0 0.0 159.2 134.92 24.28 118803.0 26865.0 95042.4 9.0 7248.99 9.0 7248.99 0.0 0.0 134.92 14497.99 95042.4 INR 0 0.0 0.0 2025-11-07 18:37:14
204 217 27 59 12516 24 Immunomax 24/7 Caps NULL 2009899 3 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 4497.0 1350.0 3597.6 2.5 85.66 2.5 85.66 0.0 0.0 1142.1 171.31 3597.6 INR 0 0.0 0.0 2025-11-07 18:37:14
205 218 28 59 12516 30 Iron Capsules NULL 30049011 15 250.0 899.0 0.0 0.0 719.2 684.95 34.25 13485.0 3750.0 10788.0 2.5 256.86 2.5 256.86 0.0 0.0 684.95 513.71 10788.0 INR 0 0.0 0.0 2025-11-07 18:37:14
206 219 29 59 12516 15 Kidney Stone Juice NULL 2009899 11 120.0 349.0 0.0 0.0 279.2 265.9 13.3 3839.0 1320.0 3071.2 2.5 73.12 2.5 73.12 0.0 0.0 265.9 146.25 3071.2 INR 0 0.0 0.0 2025-11-07 18:37:14
207 220 30 59 12516 18 Lady Care Juice 500ml NULL 2009899 16 250.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 23984.0 4000.0 19187.2 2.5 456.84 2.5 456.84 0.0 0.0 1142.1 913.68 19187.2 INR 0 0.0 0.0 2025-11-07 18:37:14
208 221 31 59 12516 16 Liver Care Juice NULL 2009899 46 120.0 349.0 0.0 0.0 279.2 265.9 13.3 16054.0 5520.0 12843.2 2.5 305.79 2.5 305.79 0.0 0.0 265.9 611.58 12843.2 INR 0 0.0 0.0 2025-11-07 18:37:14
209 222 32 59 12516 25 Manicalcium Tablets NULL 2009899 23 95.0 399.0 0.0 0.0 319.2 304.0 15.2 9177.0 2185.0 7341.6 2.5 174.8 2.5 174.8 0.0 0.0 304.0 349.6 7341.6 INR 0 0.0 0.0 2025-11-07 18:37:14
210 223 33 59 12516 12 Melatonin Drop NULL 2106909 38 190.0 749.0 0.0 0.0 599.2 570.67 28.53 28462.0 7220.0 22769.6 2.5 542.13 2.5 542.13 0.0 0.0 570.67 1084.27 22769.6 INR 0 0.0 0.0 2025-11-07 18:37:14
211 224 34 59 12516 17 Memory Booster Juice NULL 2009899 52 120.0 349.0 0.0 0.0 279.2 265.9 13.3 18148.0 6240.0 14518.4 2.5 345.68 2.5 345.68 0.0 0.0 265.9 691.35 14518.4 INR 0 0.0 0.0 2025-11-07 18:37:14
212 225 35 59 12516 56 Micro magic 500ml NULL 3105 24 850.0 2030.0 0.0 0.0 1624.0 1376.27 247.73 48720.0 20400.0 38976.0 9.0 2972.74 9.0 2972.74 0.0 0.0 1376.27 5945.49 38976.0 INR 0 0.0 0.0 2025-11-07 18:37:14
213 226 36 59 12516 7 Morning Fresh Churan NULL 30049011 157 40.0 199.0 0.0 0.0 159.2 151.62 7.58 31243.0 6280.0 24994.4 2.5 595.11 2.5 595.11 0.0 0.0 151.62 1190.21 24994.4 INR 0 0.0 0.0 2025-11-07 18:37:14
214 227 37 59 12516 32 Neem Soap 100gm NULL 34011110 3122 10.0 60.0 0.0 0.0 48.0 45.71 2.29 187320.0 31220.0 149856.0 2.5 3568.0 2.5 3568.0 0.0 0.0 45.71 7136.0 149856.0 INR 0 0.0 0.0 2025-11-07 18:37:14
215 228 38 59 12516 9 Omega 369 NULL 2936900 57 260.0 999.0 0.0 0.0 799.2 761.14 38.06 56943.0 14820.0 45554.4 2.5 1084.63 2.5 1084.63 0.0 0.0 761.14 2169.26 45554.4 INR 0 0.0 0.0 2025-11-07 18:37:14
216 229 39 59 12516 28 Ortho Joint Shield NULL 2009899 14 450.0 1499.0 0.0 0.0 1199.2 1142.1 57.1 20986.0 6300.0 16788.8 2.5 399.74 2.5 399.74 0.0 0.0 1142.1 799.47 16788.8 INR 0 0.0 0.0 2025-11-07 18:37:14
217 230 40 59 12516 72 Pain Relief Patch NULL 30051090 52 200.0 800.0 0.0 0.0 640.0 609.52 30.48 41600.0 10400.0 33280.0 2.5 792.38 2.5 792.38 0.0 0.0 609.52 1584.76 33280.0 INR 0 0.0 0.0 2025-11-07 18:37:14
218 231 41 59 12516 8 Piles Care NULL 30049011 49 250.0 899.0 0.0 0.0 719.2 684.95 34.25 44051.0 12250.0 35240.8 2.5 839.07 2.5 839.07 0.0 0.0 684.95 1678.13 35240.8 INR 0 0.0 0.0 2025-11-07 18:37:14
219 232 42 59 12516 41 Premium Coco Body Lotion NULL 3304300 25 250.0 699.0 0.0 0.0 559.2 473.9 85.3 17475.0 6250.0 13980.0 9.0 1066.27 9.0 1066.27 0.0 0.0 473.9 2132.54 13980.0 INR 0 0.0 0.0 2025-11-07 18:37:14
220 233 43 59 12516 14 Premium Aloe Vera VEG caps NULL 2936900 5 100.0 359.0 0.0 0.0 287.2 273.52 13.68 1795.0 500.0 1436.0 2.5 34.19 2.5 34.19 0.0 0.0 273.52 68.38 1436.0 INR 0 0.0 0.0 2025-11-07 18:37:14
221 234 44 59 12516 47 Premium Hair Care Shampoo NULL 3305109 78 150.0 699.0 0.0 0.0 559.2 532.57 26.63 54522.0 11700.0 43617.6 2.5 1038.52 2.5 1038.52 0.0 0.0 532.57 2077.03 43617.6 INR 0 0.0 0.0 2025-11-07 18:37:14
222 235 45 59 12516 13 Premium NONI VEG caps NULL 2936900 27 150.0 501.0 0.0 0.0 400.8 381.71 19.09 13527.0 4050.0 10821.6 2.5 257.65 2.5 257.65 0.0 0.0 381.71 515.31 10821.6 INR 0 0.0 0.0 2025-11-07 18:37:14
223 236 46 59 12516 45 Premium radiance face serum NULL 3304991 16 300.0 1200.0 0.0 0.0 960.0 813.56 146.44 19200.0 4800.0 15360.0 9.0 1171.53 9.0 1171.53 0.0 0.0 813.56 2343.05 15360.0 INR 0 0.0 0.0 2025-11-07 18:37:14
224 237 47 59 12516 43 Quench Kiss Lip Balm NULL 3304300 15 35.0 199.0 0.0 0.0 159.2 134.92 24.28 2985.0 525.0 2388.0 9.0 182.13 9.0 182.13 0.0 0.0 134.92 364.27 2388.0 INR 0 0.0 0.0 2025-11-07 18:37:14
225 238 48 59 12516 46 Root Vitality Hair Oil NULL 3305901 59 54.0 255.0 0.0 0.0 204.0 194.29 9.71 15045.0 3186.0 12036.0 2.5 286.57 2.5 286.57 0.0 0.0 194.29 573.14 12036.0 INR 0 0.0 0.0 2025-11-07 18:37:14
226 239 49 59 12516 57 Safe guard 250ml NULL 3105 24 800.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 60000.0 19200.0 48000.0 2.5 1142.86 2.5 1142.86 0.0 0.0 1904.76 2285.71 48000.0 INR 0 0.0 0.0 2025-11-07 18:37:14
227 240 50 59 12516 35 Sanitary Pad (15 pcs) NULL 9619001 370 40.0 380.0 0.0 0.0 304.0 304.0 0.0 140600.0 14800.0 112480.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 112480.0 INR 0 0.0 0.0 2025-11-07 18:37:14
228 241 51 59 12516 29 Shilajith NULL 30049011 21 250.0 1800.0 0.0 0.0 1440.0 1371.43 68.57 37800.0 5250.0 30240.0 2.5 720.0 2.5 720.0 0.0 0.0 1371.43 1440.0 30240.0 INR 0 0.0 0.0 2025-11-07 18:37:14
229 242 52 59 12516 26 Spirulina Cap NULL 2009899 30 190.0 899.0 0.0 0.0 719.2 684.95 34.25 26970.0 5700.0 21576.0 2.5 513.72 2.5 513.72 0.0 0.0 684.95 1027.43 21576.0 INR 0 0.0 0.0 2025-11-07 18:37:14
230 243 53 59 12516 1 Stem Cell Powder NULL 2936900 55 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 137445.0 41195.0 109956.0 2.5 2618.0 2.5 2618.0 0.0 0.0 1904.0 5236.0 109956.0 INR 0 0.0 0.0 2025-11-07 18:37:14
231 244 54 59 12516 50 Sun Screen NULL 330499 44 250.0 699.0 0.0 0.0 559.2 473.9 85.3 30756.0 11000.0 24604.8 9.0 1876.63 9.0 1876.63 0.0 0.0 473.9 3753.27 24604.8 INR 0 0.0 0.0 2025-11-07 18:37:14
232 245 55 59 12516 59 T Shirt NULL 61099010 1 0.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 1400.0 0.0 1120.0 2.5 26.66 2.5 26.66 0.0 0.0 1066.67 53.33 1120.0 INR 0 0.0 0.0 2025-11-07 18:37:14
233 246 56 59 12516 53 Terra care 2 kg NULL 3103100 71 450.0 1500.0 0.0 0.0 1200.0 1142.86 57.14 106500.0 31950.0 85200.0 2.5 2028.57 2.5 2028.57 0.0 0.0 1142.86 4057.14 85200.0 INR 0 0.0 0.0 2025-11-07 18:37:14
234 247 57 59 12516 5 Thyro Care NULL 2936900 21 250.0 899.0 0.0 0.0 719.2 684.95 34.25 18879.0 5250.0 15103.2 2.5 359.6 2.5 359.6 0.0 0.0 684.95 719.2 15103.2 INR 0 0.0 0.0 2025-11-07 18:37:14
235 248 58 59 12516 36 Toilet Cleaner 500ml NULL 3924101 180 30.0 150.0 0.0 0.0 120.0 101.69 18.31 27000.0 5400.0 21600.0 9.0 1647.46 9.0 1647.46 0.0 0.0 101.69 3294.92 21600.0 INR 0 0.0 0.0 2025-11-07 18:37:14
236 249 59 59 12516 11 Vitamin B12 Drop NULL 2106909 131 190.0 749.0 0.0 0.0 599.2 570.67 28.53 98119.0 24890.0 78495.2 2.5 1868.93 2.5 1868.93 0.0 0.0 570.67 3737.87 78495.2 INR 0 0.0 0.0 2025-11-07 18:37:14
237 250 60 59 12516 23 Women Fuel Juice NULL 2202999 6 200.0 1999.0 0.0 0.0 1599.2 1523.05 76.15 11994.0 1200.0 9595.2 2.5 228.46 2.5 228.46 0.0 0.0 1523.05 456.91 9595.2 INR 0 0.0 0.0 2025-11-07 18:37:14
238 251 61 59 12516 54 Wonder grow 100ml NULL 3105 55 500.0 1400.0 0.0 0.0 1120.0 1066.67 53.33 77000.0 27500.0 61600.0 2.5 1466.66 2.5 1466.66 0.0 0.0 1066.67 2933.33 61600.0 INR 0 0.0 0.0 2025-11-07 18:37:14
239 252 1 60 12516 79 ALKALINE JUG NULL 8421 1 3500.0 14999.0 0.0 0.0 11999.2 10168.81 1830.39 14999.0 3500.0 11999.2 9.0 915.2 9.0 915.2 0.0 0.0 10168.81 1830.39 11999.2 INR 0 0.0 0.0 2025-11-07 18:50:33
240 253 2 60 12516 3 BP Care Capsules NULL 2936900 2 160.0 599.0 0.0 0.0 479.2 456.38 22.82 1198.0 320.0 958.4 2.5 22.82 2.5 22.82 0.0 0.0 456.38 45.64 958.4 INR 0 0.0 0.0 2025-11-07 18:50:33
241 254 3 60 12516 38 Dish Wash 500ml NULL 3924101 3 85.0 230.0 0.0 0.0 184.0 155.93 28.07 690.0 255.0 552.0 9.0 42.1 9.0 42.1 0.0 0.0 155.93 84.2 552.0 INR 0 0.0 0.0 2025-11-07 18:50:33
242 255 4 60 12516 39 Fabric Wash 1000ml NULL 3924101 3 150.0 401.0 0.0 0.0 320.8 271.86 48.94 1203.0 450.0 962.4 9.0 73.41 9.0 73.41 0.0 0.0 271.86 146.81 962.4 INR 0 0.0 0.0 2025-11-07 18:50:33
243 256 5 60 12516 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:50:33
244 257 6 60 12516 33 Herbal Soap 100gm NULL 30049011 24 28.0 100.0 0.0 0.0 80.0 76.19 3.81 2400.0 672.0 1920.0 2.5 45.72 2.5 45.72 0.0 0.0 76.19 91.43 1920.0 INR 0 0.0 0.0 2025-11-07 18:50:33
245 258 7 60 12516 7 Morning Fresh Churan NULL 30049011 6 40.0 199.0 0.0 0.0 159.2 151.62 7.58 1194.0 240.0 955.2 2.5 22.75 2.5 22.75 0.0 0.0 151.62 45.49 955.2 INR 0 0.0 0.0 2025-11-07 18:50:33
246 259 8 60 12516 32 Neem Soap 100gm NULL 34011110 50 10.0 60.0 0.0 0.0 48.0 45.71 2.29 3000.0 500.0 2400.0 2.5 57.15 2.5 57.15 0.0 0.0 45.71 114.29 2400.0 INR 0 0.0 0.0 2025-11-07 18:50:33
247 260 9 60 12516 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:50:33
248 261 10 60 12516 35 Sanitary Pad (15 pcs) NULL 9619001 3 40.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 120.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 912.0 INR 0 0.0 0.0 2025-11-07 18:50:33
249 262 11 60 12516 1 Stem Cell Powder NULL 2936900 2 749.0 2499.0 0.0 0.0 1999.2 1904.0 95.2 4998.0 1498.0 3998.4 2.5 95.2 2.5 95.2 0.0 0.0 1904.0 190.4 3998.4 INR 0 0.0 0.0 2025-11-07 18:50:33
250 263 1 61 12546 20 Premium Berry Juice 1000ml NULL 2936900 1 750.0 3499.0 0.0 0.0 3479.0 3313.33 165.67 3499.0 750.0 3479.0 2.5 82.83 2.5 82.83 0.0 0.0 3313.33 165.67 3479.0 INR 0 0.0 0.0 2025-11-07 18:56:18