fx_franchise_order_product

4,933 rows · 33 columns · page 45 / 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
2201 2214 1 399 12516 61 Radiation chip NULL 902221 500 0.0 999.0 0.0 0.0 500.0 423.73 76.27 499500.0 0.0 250000.0 9.0 19067.8 9.0 19067.8 0.0 0.0 423.73 38135.6 250000.0 INR 0 0.0 0.0 2025-12-19 13:22:48
2202 2215 2 399 12516 4 Diabetic Care Capsules NULL 2936900 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 685.71 1714.28 36000.0 INR 0 0.0 0.0 2025-12-19 13:22:48
2203 2216 3 399 12516 8 Piles Care NULL 30049011 50 0.0 999.0 0.0 0.0 720.0 685.71 34.29 49950.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 685.71 1714.28 36000.0 INR 0 0.0 0.0 2025-12-19 13:22:48
2204 2217 1 400 12555 61 Radiation chip NULL 902221 400 0.0 999.0 0.0 0.0 500.0 423.73 76.27 399600.0 0.0 200000.0 9.0 15254.24 9.0 15254.24 0.0 0.0 423.73 30508.48 200000.0 INR 0 0.0 0.0 2025-12-19 18:45:44
2205 2218 1 401 12554 61 Radiation chip NULL 902221 400 0.0 999.0 0.0 0.0 500.0 423.73 76.27 399600.0 0.0 200000.0 9.0 15254.24 9.0 15254.24 0.0 0.0 423.73 30508.48 200000.0 INR 0 0.0 0.0 2025-12-19 18:46:10
2206 2219 1 402 12516 61 Radiation chip NULL 902221 400 0.0 999.0 0.0 0.0 500.0 423.73 76.27 399600.0 0.0 200000.0 9.0 15254.24 9.0 15254.24 0.0 0.0 423.73 30508.48 200000.0 INR 0 0.0 0.0 2025-12-19 18:46:31
2207 2220 1 403 12516 4 Diabetic Care Capsules NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-19 20:45:46
2208 2221 1 404 12554 4 Diabetic Care Capsules NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-19 20:46:36
2209 2222 1 405 12555 4 Diabetic Care Capsules NULL 2936900 100 0.0 999.0 0.0 0.0 720.0 685.71 34.29 99900.0 0.0 72000.0 2.5 1714.29 2.5 1714.29 0.0 0.0 685.71 3428.58 72000.0 INR 0 0.0 0.0 2025-12-19 20:47:30
2210 2223 1 406 12554 18 Lady Care Juice 500ml NULL 2009899 30 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 44970.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 1142.86 1714.28 36000.0 INR 0 0.0 0.0 2025-12-19 22:26:44
2211 2224 1 407 12516 18 Lady Care Juice 500ml NULL 2009899 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-12-19 22:27:41
2212 2225 1 408 12555 18 Lady Care Juice 500ml NULL 2009899 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-12-19 22:28:59
2213 2226 1 409 12554 19 Fat loss Juice 500 ml NULL 30049011 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-12-19 22:30:32
2214 2227 1 410 12516 18 Lady Care Juice 500ml NULL 2009899 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-12-19 22:32:59
2215 2228 1 411 12554 18 Lady Care Juice 500ml NULL 2009899 50 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 74950.0 0.0 60000.0 2.5 1428.57 2.5 1428.57 0.0 0.0 1142.86 2857.14 60000.0 INR 0 0.0 0.0 2025-12-19 22:34:31
2216 2229 1 412 12555 61 Radiation chip NULL 902221 400 0.0 999.0 0.0 0.0 500.0 423.73 76.27 399600.0 0.0 200000.0 9.0 15254.24 9.0 15254.24 0.0 0.0 423.73 30508.48 200000.0 INR 0 0.0 0.0 2025-12-19 22:42:31
2217 2230 1 413 12554 61 Radiation chip NULL 902221 400 0.0 999.0 0.0 0.0 500.0 423.73 76.27 399600.0 0.0 200000.0 9.0 15254.24 9.0 15254.24 0.0 0.0 423.73 30508.48 200000.0 INR 0 0.0 0.0 2025-12-19 22:42:58
2218 2231 1 414 12516 61 Radiation chip NULL 902221 400 0.0 999.0 0.0 0.0 500.0 423.73 76.27 399600.0 0.0 200000.0 9.0 15254.24 9.0 15254.24 0.0 0.0 423.73 30508.48 200000.0 INR 0 0.0 0.0 2025-12-19 22:43:22
2219 2232 1 415 12516 61 Radiation chip NULL 902221 200 0.0 999.0 0.0 0.0 500.0 423.73 76.27 199800.0 0.0 100000.0 9.0 7627.12 9.0 7627.12 0.0 0.0 423.73 15254.24 100000.0 INR 0 0.0 0.0 2025-12-20 10:05:14
2220 2233 1 416 12554 61 Radiation chip NULL 902221 200 0.0 999.0 0.0 0.0 500.0 423.73 76.27 199800.0 0.0 100000.0 9.0 7627.12 9.0 7627.12 0.0 0.0 423.73 15254.24 100000.0 INR 0 0.0 0.0 2025-12-20 10:05:53
2221 2234 1 417 12555 61 Radiation chip NULL 902221 200 0.0 999.0 0.0 0.0 500.0 423.73 76.27 199800.0 0.0 100000.0 9.0 7627.12 9.0 7627.12 0.0 0.0 423.73 15254.24 100000.0 INR 0 0.0 0.0 2025-12-20 10:06:40
2222 2235 1 418 12555 20 Premium Berry Juice 1000ml NULL 2936900 5 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 17495.0 0.0 13000.0 2.5 309.52 2.5 309.52 0.0 0.0 2476.19 619.04 13000.0 INR 0 0.0 0.0 2025-12-20 10:39:39
2223 2236 1 419 12516 62 3*3 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.28 79800.0 INR 0 0.0 0.0 2025-12-21 09:57:14
2224 2237 2 419 12516 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 10 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 219990.0 0.0 149990.0 1.5 2184.32 1.5 2184.32 0.0 0.0 14562.14 4368.64 149990.0 INR 0 0.0 0.0 2025-12-21 09:57:14
2225 2238 1 420 12517 62 3*3 BED WITH BRACELET NULL 94041000 2 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 25998.0 0.0 15960.0 0.0 0.0 0.0 0.0 3.0 464.85 7747.57 464.85 15960.0 INR 0 0.0 0.0 2025-12-21 10:01:00
2226 2239 1 421 12554 62 3*3 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.28 79800.0 INR 0 0.0 0.0 2025-12-21 11:18:12
2227 2240 2 421 12554 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 10 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 219990.0 0.0 149990.0 1.5 2184.32 1.5 2184.32 0.0 0.0 14562.14 4368.64 149990.0 INR 0 0.0 0.0 2025-12-21 11:18:12
2228 2241 1 422 12516 62 3*3 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.28 79800.0 INR 0 0.0 0.0 2025-12-21 11:36:28
2229 2242 1 423 12554 62 3*3 BED WITH BRACELET NULL 94041000 10 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 129990.0 0.0 79800.0 1.5 1162.14 1.5 1162.14 0.0 0.0 7747.57 2324.28 79800.0 INR 0 0.0 0.0 2025-12-21 11:39:11
2230 2243 2 423 12554 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 10 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 219990.0 0.0 149990.0 1.5 2184.32 1.5 2184.32 0.0 0.0 14562.14 4368.64 149990.0 INR 0 0.0 0.0 2025-12-21 11:39:11
2231 2244 1 424 12555 6 Asthma Care NULL 30049011 10 0.0 999.0 0.0 0.0 720.0 685.71 34.29 9990.0 0.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 685.71 342.86 7200.0 INR 0 0.0 0.0 2025-12-23 14:15:35
2232 2245 2 424 12555 4 Diabetic Care Capsules NULL 2936900 10 0.0 999.0 0.0 0.0 720.0 685.71 34.29 9990.0 0.0 7200.0 2.5 171.43 2.5 171.43 0.0 0.0 685.71 342.86 7200.0 INR 0 0.0 0.0 2025-12-23 14:15:35
2233 2246 3 424 12555 72 Pain Relief Patch NULL 30051090 10 0.0 800.0 0.0 0.0 600.0 571.43 28.57 8000.0 0.0 6000.0 2.5 142.86 2.5 142.86 0.0 0.0 571.43 285.72 6000.0 INR 0 0.0 0.0 2025-12-23 14:15:35
2234 2247 1 425 12516 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 10 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 219990.0 0.0 149990.0 1.5 2184.32 1.5 2184.32 0.0 0.0 14562.14 4368.64 149990.0 INR 0 0.0 0.0 2025-12-23 16:54:00
2235 2248 1 426 12551 62 3*3 BED WITH BRACELET NULL 94041000 7 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 90993.0 0.0 55860.0 1.5 813.5 1.5 813.5 0.0 0.0 7747.57 1627.0 55860.0 INR 0 0.0 0.0 2025-12-23 18:04:27
2236 2249 2 426 12551 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 5 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 109995.0 0.0 74995.0 1.5 1092.16 1.5 1092.16 0.0 0.0 14562.14 2184.32 74995.0 INR 0 0.0 0.0 2025-12-23 18:04:27
2237 2250 3 426 12551 1 Stem Cell Powder NULL 2936900 10 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 24990.0 0.0 19990.0 2.5 475.95 2.5 475.95 0.0 0.0 1903.81 951.9 19990.0 INR 0 0.0 0.0 2025-12-23 18:04:27
2238 2251 1 427 12516 62 3*3 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2025-12-23 20:05:34
2239 2252 2 427 12516 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 20 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 439980.0 0.0 299980.0 1.5 4368.64 1.5 4368.64 0.0 0.0 14562.14 8737.28 299980.0 INR 0 0.0 0.0 2025-12-23 20:05:34
2240 2253 1 428 12554 62 3*3 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2025-12-23 20:06:55
2241 2254 2 428 12554 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 20 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 439980.0 0.0 299980.0 1.5 4368.64 1.5 4368.64 0.0 0.0 14562.14 8737.28 299980.0 INR 0 0.0 0.0 2025-12-23 20:06:55
2242 2255 1 429 12555 62 3*3 BED WITH BRACELET NULL 94041000 20 0.0 12999.0 0.0 0.0 7980.0 7747.57 232.43 259980.0 0.0 159600.0 1.5 2324.27 1.5 2324.27 0.0 0.0 7747.57 4648.54 159600.0 INR 0 0.0 0.0 2025-12-23 20:09:09
2243 2256 2 429 12555 63 6*6 bio magnetic bed WITH bracelet NULL 94041000 20 0.0 21999.0 0.0 0.0 14999.0 14562.14 436.86 439980.0 0.0 299980.0 1.5 4368.64 1.5 4368.64 0.0 0.0 14562.14 8737.28 299980.0 INR 0 0.0 0.0 2025-12-23 20:09:09
2244 2257 1 430 12555 36 Toilet Cleaner 500ml NULL 3924101 100 0.0 150.0 0.0 0.0 120.0 101.69 18.3 15000.0 0.0 12000.0 9.0 915.25 9.0 915.25 0.0 0.0 101.69 1830.5 12000.0 INR 0 0.0 0.0 2025-12-23 22:26:12
2245 2258 1 431 12516 82 ALKALINE CAPSULE NULL 3402000 50 0.0 2500.0 0.0 0.0 2000.0 1941.75 58.25 125000.0 0.0 100000.0 1.5 1456.31 1.5 1456.31 0.0 0.0 1941.75 2912.62 100000.0 INR 0 0.0 0.0 2025-12-24 14:47:35
2246 2259 2 431 12516 15 KIDNEY CARE JUICE NULL 2009899 20 0.0 349.0 0.0 0.0 279.0 265.71 13.29 6980.0 0.0 5580.0 2.5 132.86 2.5 132.86 0.0 0.0 265.71 265.72 5580.0 INR 0 0.0 0.0 2025-12-24 14:47:35
2247 2260 3 431 12516 17 Memory Booster Juice NULL 2009899 20 0.0 349.0 0.0 0.0 279.0 265.71 13.29 6980.0 0.0 5580.0 2.5 132.86 2.5 132.86 0.0 0.0 265.71 265.72 5580.0 INR 0 0.0 0.0 2025-12-24 14:47:35
2248 2261 1 432 12554 82 ALKALINE CAPSULE NULL 3402000 50 0.0 2500.0 0.0 0.0 2000.0 1941.75 58.25 125000.0 0.0 100000.0 1.5 1456.31 1.5 1456.31 0.0 0.0 1941.75 2912.62 100000.0 INR 0 0.0 0.0 2025-12-24 14:48:30
2249 2262 2 432 12554 15 KIDNEY CARE JUICE NULL 2009899 10 0.0 349.0 0.0 0.0 279.0 265.71 13.29 3490.0 0.0 2790.0 2.5 66.43 2.5 66.43 0.0 0.0 265.71 132.86 2790.0 INR 0 0.0 0.0 2025-12-24 14:48:30
2250 2263 3 432 12554 17 Memory Booster Juice NULL 2009899 10 0.0 349.0 0.0 0.0 279.0 265.71 13.29 3490.0 0.0 2790.0 2.5 66.43 2.5 66.43 0.0 0.0 265.71 132.86 2790.0 INR 0 0.0 0.0 2025-12-24 14:48:30