fx_franchise_order_product

4,933 rows · 33 columns · page 43 / 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
2101 2114 1 355 12555 74 EXPLORER BOX NULL NULL 10 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 269970.0 0.0 104990.0 2.5 2499.76 2.5 2499.76 0.0 0.0 9999.05 4999.52 104990.0 INR 0 0.0 0.0 2025-12-13 16:28:16
2102 2115 1 356 12552 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-12-14 12:30:31
2103 2116 1 357 12552 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-12-14 12:48:00
2104 2117 1 358 12552 74 EXPLORER BOX NULL NULL 1 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 26997.0 0.0 10499.0 2.5 249.97 2.5 249.97 0.0 0.0 9999.05 499.95 10499.0 INR 0 0.0 0.0 2025-12-14 12:55:28
2105 2118 1 359 12555 74 EXPLORER BOX NULL NULL 20 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 539940.0 0.0 209980.0 2.5 4999.52 2.5 4999.52 0.0 0.0 9999.05 9999.04 209980.0 INR 0 0.0 0.0 2025-12-14 15:49:37
2106 2119 1 360 12554 74 EXPLORER BOX NULL NULL 20 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 539940.0 0.0 209980.0 2.5 4999.52 2.5 4999.52 0.0 0.0 9999.05 9999.04 209980.0 INR 0 0.0 0.0 2025-12-14 15:51:12
2107 2120 1 361 12516 74 EXPLORER BOX NULL NULL 20 0.0 26997.0 0.0 0.0 10499.0 9999.05 499.95 539940.0 0.0 209980.0 2.5 4999.52 2.5 4999.52 0.0 0.0 9999.05 9999.04 209980.0 INR 0 0.0 0.0 2025-12-14 15:52:13
2108 2121 1 362 12518 5 Thyro Care NULL 2936900 101 0.0 899.0 0.0 0.0 719.2 684.95 34.25 90799.0 0.0 72639.2 2.5 1729.51 2.5 1729.51 0.0 0.0 684.95 3459.01 72639.2 INR 0 0.0 0.0 2025-12-16 15:39:27
2109 2122 1 363 12555 5 Thyro Care NULL 2936900 10 0.0 899.0 0.0 0.0 719.2 684.95 34.25 8990.0 0.0 7192.0 2.5 171.24 2.5 171.24 0.0 0.0 684.95 342.48 7192.0 INR 0 0.0 0.0 2025-12-16 16:37:33
2110 2123 1 364 12516 62 3*3 BED WITH BRACELET NULL 9404 10 0.0 12999.0 0.0 0.0 7799.4 7572.23 227.17 129990.0 0.0 77994.0 1.5 1135.83 1.5 1135.83 0.0 0.0 7572.23 2271.66 77994.0 INR 0 0.0 0.0 2025-12-17 12:02:36
2111 2124 2 364 12516 63 6*6 bio magnetic bed WITH bracelet NULL 9404 10 0.0 21999.0 0.0 0.0 13199.4 12814.95 384.45 219990.0 0.0 131994.0 1.5 1922.24 1.5 1922.24 0.0 0.0 12814.95 3844.48 131994.0 INR 0 0.0 0.0 2025-12-17 12:02:36
2112 2125 1 365 12516 62 3*3 BED WITH BRACELET NULL 9404 10 0.0 12999.0 0.0 0.0 7799.4 7572.23 227.17 129990.0 0.0 77994.0 1.5 1135.83 1.5 1135.83 0.0 0.0 7572.23 2271.66 77994.0 INR 0 0.0 0.0 2025-12-17 12:08:01
2113 2126 2 365 12516 63 6*6 bio magnetic bed WITH bracelet NULL 9404 10 0.0 21999.0 0.0 0.0 13199.4 12814.95 384.45 219990.0 0.0 131994.0 1.5 1922.24 1.5 1922.24 0.0 0.0 12814.95 3844.48 131994.0 INR 0 0.0 0.0 2025-12-17 12:08:01
2114 2127 1 366 12554 62 3*3 BED WITH BRACELET NULL 9404 10 0.0 12999.0 0.0 0.0 7799.4 7572.23 227.17 129990.0 0.0 77994.0 1.5 1135.83 1.5 1135.83 0.0 0.0 7572.23 2271.66 77994.0 INR 0 0.0 0.0 2025-12-17 12:10:20
2115 2128 2 366 12554 63 6*6 bio magnetic bed WITH bracelet NULL 9404 10 0.0 21999.0 0.0 0.0 13199.4 12814.95 384.45 219990.0 0.0 131994.0 1.5 1922.24 1.5 1922.24 0.0 0.0 12814.95 3844.48 131994.0 INR 0 0.0 0.0 2025-12-17 12:10:20
2116 2129 1 367 12555 62 3*3 BED WITH BRACELET NULL 9404 10 0.0 12999.0 0.0 0.0 7799.4 7572.23 227.17 129990.0 0.0 77994.0 1.5 1135.83 1.5 1135.83 0.0 0.0 7572.23 2271.66 77994.0 INR 0 0.0 0.0 2025-12-17 12:12:24
2117 2130 2 367 12555 63 6*6 bio magnetic bed WITH bracelet NULL 9404 10 0.0 21999.0 0.0 0.0 13199.4 12814.95 384.45 219990.0 0.0 131994.0 1.5 1922.24 1.5 1922.24 0.0 0.0 12814.95 3844.48 131994.0 INR 0 0.0 0.0 2025-12-17 12:12:24
2118 2131 1 368 12555 62 3*3 BED WITH BRACELET NULL 9404 5 0.0 12999.0 0.0 0.0 7799.4 7572.23 227.17 64995.0 0.0 38997.0 1.5 567.92 1.5 567.92 0.0 0.0 7572.23 1135.84 38997.0 INR 0 0.0 0.0 2025-12-17 12:13:42
2119 2132 2 368 12555 63 6*6 bio magnetic bed WITH bracelet NULL 9404 3 0.0 21999.0 0.0 0.0 13199.4 12814.95 384.45 65997.0 0.0 39598.2 1.5 576.67 1.5 576.67 0.0 0.0 12814.95 1153.34 39598.2 INR 0 0.0 0.0 2025-12-17 12:13:42
2120 2133 1 369 12555 61 Radiation chip NULL 902221 10 0.0 999.0 0.0 0.0 799.2 677.29 121.91 9990.0 0.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-12-17 13:54:51
2121 2134 1 370 12555 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 799.2 677.29 121.91 99900.0 0.0 79920.0 9.0 6095.59 9.0 6095.59 0.0 0.0 677.29 12191.18 79920.0 INR 0 0.0 0.0 2025-12-17 14:55:12
2122 2135 1 371 12554 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 799.2 677.29 121.91 99900.0 0.0 79920.0 9.0 6095.59 9.0 6095.59 0.0 0.0 677.29 12191.18 79920.0 INR 0 0.0 0.0 2025-12-17 14:55:38
2123 2136 1 372 12516 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 799.2 677.29 121.91 99900.0 0.0 79920.0 9.0 6095.59 9.0 6095.59 0.0 0.0 677.29 12191.18 79920.0 INR 0 0.0 0.0 2025-12-17 14:55:58
2124 2137 1 373 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-17 21:29:33
2125 2138 2 373 12555 19 Fat loss Juice 500 ml NULL 30049011 10 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 14990.0 0.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 1142.86 571.42 12000.0 INR 0 0.0 0.0 2025-12-17 21:29:33
2126 2139 3 373 12555 2 Heart Care Capsules NULL 2936900 10 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 14990.0 0.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 1142.86 571.42 12000.0 INR 0 0.0 0.0 2025-12-17 21:29:33
2127 2140 4 373 12555 24 Immunomax 24/7 Caps NULL 2009899 10 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 14990.0 0.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 1142.86 571.42 12000.0 INR 0 0.0 0.0 2025-12-17 21:29:33
2128 2141 5 373 12555 18 Lady Care Juice 500ml NULL 2009899 10 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 14990.0 0.0 12000.0 2.5 285.71 2.5 285.71 0.0 0.0 1142.86 571.42 12000.0 INR 0 0.0 0.0 2025-12-17 21:29:33
2129 2142 6 373 12555 8 Piles 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-17 21:29:33
2130 2143 1 374 12516 27 Multicharge Cap NULL 2009899 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-17 21:41:08
2131 2144 2 374 12516 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 500.0 423.73 76.27 99900.0 0.0 50000.0 9.0 3813.56 9.0 3813.56 0.0 0.0 423.73 7627.12 50000.0 INR 0 0.0 0.0 2025-12-17 21:41:08
2132 2145 3 374 12516 3 BP 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-17 21:41:08
2133 2146 4 374 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-17 21:41:08
2134 2147 5 374 12516 19 Fat loss Juice 500 ml NULL 30049011 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-17 21:41:08
2135 2148 6 374 12516 2 Heart Care Capsules NULL 2936900 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-17 21:41:08
2136 2149 7 374 12516 8 Piles Care NULL 30049011 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-17 21:41:08
2137 2150 8 374 12516 5 Thyro Care 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-17 21:41:08
2138 2151 1 375 12554 27 Multicharge Cap 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-17 21:44:19
2139 2152 2 375 12554 61 Radiation chip NULL 902221 50 0.0 999.0 0.0 0.0 500.0 423.73 76.27 49950.0 0.0 25000.0 9.0 1906.78 9.0 1906.78 0.0 0.0 423.73 3813.56 25000.0 INR 0 0.0 0.0 2025-12-17 21:44:19
2140 2153 3 375 12554 3 BP 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-17 21:44:19
2141 2154 4 375 12554 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-17 21:44:19
2142 2155 5 375 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-17 21:44:19
2143 2156 6 375 12554 2 Heart Care Capsules NULL 2936900 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-17 21:44:19
2144 2157 7 375 12554 24 Immunomax 24/7 Caps 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-17 21:44:19
2145 2158 8 375 12554 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-17 21:44:19
2146 2159 9 375 12554 5 Thyro Care 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-17 21:44:19
2147 2160 1 376 12516 24 Immunomax 24/7 Caps NULL 2009899 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-17 21:45:35
2148 2161 1 377 12555 27 Multicharge Cap NULL 2009899 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-17 21:53:22
2149 2162 2 377 12555 61 Radiation chip NULL 902221 100 0.0 999.0 0.0 0.0 500.0 423.73 76.27 99900.0 0.0 50000.0 9.0 3813.56 9.0 3813.56 0.0 0.0 423.73 7627.12 50000.0 INR 0 0.0 0.0 2025-12-17 21:53:22
2150 2163 3 377 12555 19 Fat loss Juice 500 ml NULL 30049011 100 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 149900.0 0.0 120000.0 2.5 2857.14 2.5 2857.14 0.0 0.0 1142.86 5714.28 120000.0 INR 0 0.0 0.0 2025-12-17 21:53:22