fx_franchise_order
| # | id | orderid | invoice_no | userid | shopee_id | purchase_type | product_type | total_quantity | total_amount | comm_per | dicount_comm | total_cgst_amt | total_sgst_amount | total_igst_amount | final_amount | _currency | total_bv | total_pv | total_sv | payment_type | order_by | created_on | delivery_status | delivered_on | admin_status | admin_processed_on | processed_by | receipt_path | payment_ref_no | fran_comm_status | fran_comm_credited_on |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1201 | 1212 | POFN-2201 | INVFN-2201 | 12526 | 12517 | 2 | 1 | 6 | 954.0 | 0.0 | 16.17 | 72.76 | 72.76 | 0.0 | 954.0 | INR | 330.0 | 330.15 | 330.0 | 4 | 12526 | 2026-05-28 20:44:51 | 0 | NULL | 1 | 2026-05-29 21:03:23 | 12517 | 1 | 2026-05-29 21:03:23 | ||
| 1202 | 1213 | POFN-2202 | INVFN-2202 | 12539 | 12517 | 2 | 1 | 4 | 2222.0 | 0.0 | 41.95 | 62.35 | 62.35 | 0.0 | 2222.0 | INR | 1084.0 | 1084.05 | 1084.0 | 4 | 12539 | 2026-05-29 15:53:20 | 0 | NULL | 1 | 2026-05-29 21:03:47 | 12517 | 1 | 2026-05-29 21:03:47 | ||
| 1203 | 1214 | POFN-2203 | INVFN-2203 | 12539 | 12517 | 2 | 1 | 3 | 957.0 | 0.0 | 18.23 | 22.79 | 22.79 | 0.0 | 957.0 | INR | 477.0 | 477.15 | 477.0 | 4 | 12539 | 2026-05-29 16:14:49 | 0 | NULL | 1 | 2026-05-29 21:03:47 | 12517 | 1 | 2026-05-29 21:03:47 | ||
| 1204 | 1215 | POFN-2204 | INVFN-2204 | 12526 | 12517 | 2 | 1 | 18 | 5198.0 | 0.0 | 92.88 | 277.05 | 277.05 | 0.0 | 5198.0 | INR | 2396.0 | 2396.15 | 2396.0 | 4 | 12526 | 2026-05-29 23:55:48 | 0 | NULL | 1 | 2026-05-30 13:02:08 | 12517 | 1 | 2026-05-30 13:02:08 | ||
| 1205 | 1216 | POFN-2205 | INVFN-2205 | 12532 | 12517 | 2 | 1 | 1 | 10700.0 | 0.0 | 203.81 | 254.76 | 254.76 | 0.0 | 10700.0 | INR | 5350.0 | 5352.0 | 5350.0 | 4 | 12532 | 2026-05-30 12:44:21 | 0 | NULL | 1 | 2026-05-30 13:02:23 | 12517 | 1 | 2026-05-30 13:02:23 | ||
| 1206 | 1217 | POFN-2206 | INVFN-2206 | 12532 | 12517 | 2 | 1 | 9 | 7476.0 | 0.0 | 142.4 | 178.0 | 178.0 | 0.0 | 7476.0 | INR | 3736.0 | 3736.3 | 3736.0 | 4 | 12532 | 2026-05-30 13:37:20 | 0 | NULL | 1 | 2026-05-30 19:12:05 | 12517 | 1 | 2026-05-30 19:12:05 | ||
| 1207 | 1218 | POFN-2207 | INVFN-2207 | 12526 | 12517 | 2 | 1 | 16 | 7458.0 | 0.0 | 136.48 | 317.01 | 317.01 | 0.0 | 7458.0 | INR | 3435.0 | 3435.3 | 3435.0 | 4 | 12526 | 2026-05-30 21:41:09 | 0 | NULL | 1 | 2026-05-30 21:53:58 | 12517 | 1 | 2026-05-30 21:53:58 | ||
| 1208 | 1219 | POFN-2208 | INVFN-2208 | 12545 | 12517 | 2 | 1 | 63 | 13114.0 | 0.0 | 249.79 | 312.24 | 312.24 | 0.0 | 13114.0 | INR | 6304.0 | 6304.45 | 6304.0 | 4 | 12545 | 2026-05-31 08:49:43 | 0 | NULL | 1 | 2026-05-31 09:15:43 | 12517 | 1 | 2026-05-31 09:15:43 | ||
| 1209 | 1220 | POFN-2209 | INVFN-2209 | 12539 | 12517 | 2 | 1 | 4 | 4418.0 | 0.0 | 84.15 | 105.19 | 105.19 | 0.0 | 4418.0 | INR | 2208.0 | 2208.15 | 2208.0 | 4 | 12539 | 2026-05-31 12:39:10 | 0 | NULL | 1 | 2026-05-31 12:42:32 | 12517 | 1 | 2026-05-31 12:42:32 | ||
| 1210 | 1221 | POFN-2210 | INVFN-2210 | 12539 | 12517 | 2 | 1 | 1 | 80.0 | 0.0 | 1.52 | 1.9 | 1.9 | 0.0 | 80.0 | INR | 35.0 | 35.01 | 35.0 | 4 | 12539 | 2026-05-31 12:43:52 | 0 | NULL | 1 | 2026-05-31 12:58:36 | 12517 | 1 | 2026-05-31 12:58:36 | ||
| 1211 | 1222 | POFN-2211 | INVFN-2211 | 12545 | 12517 | 2 | 1 | 7 | 2235.0 | 0.0 | 40.9 | 94.92 | 94.92 | 0.0 | 2235.0 | INR | 995.0 | 995.12 | 995.0 | 4 | 12545 | 2026-05-31 21:50:53 | 0 | NULL | 1 | 2026-05-31 22:16:32 | 12517 | 1 | 2026-05-31 22:16:32 | ||
| 1212 | 1223 | POFN-2212 | INVFN-2212 | 12545 | 12517 | 2 | 1 | 7 | 1113.0 | 0.0 | 18.86 | 84.89 | 84.89 | 0.0 | 1113.0 | INR | 385.0 | 385.08 | 385.0 | 4 | 12545 | 2026-05-31 21:51:34 | 0 | NULL | 1 | 2026-05-31 22:16:28 | 12517 | 1 | 2026-05-31 22:16:28 | ||
| 1213 | 1224 | POFN-2213 | INVFN-2213 | 12545 | 12517 | 2 | 1 | 2 | 520.0 | 0.0 | 9.65 | 18.68 | 18.68 | 0.0 | 520.0 | INR | 242.0 | 242.01 | 242.0 | 4 | 12545 | 2026-06-01 12:06:10 | 0 | NULL | 1 | 2026-06-01 13:30:15 | 12517 | 1 | 2026-06-01 13:30:15 | ||
| 1214 | 1225 | POFN-2214 | INVFN-2214 | 12555 | 12554 | 2 | 1 | 1 | 1600.0 | 0.0 | 30.48 | 38.1 | 38.1 | 0.0 | 1600.0 | INR | 800.0 | 800.25 | 800.0 | 4 | 12555 | 2026-06-02 17:07:58 | 0 | NULL | 1 | 2026-06-02 17:08:35 | 12554 | 1 | 2026-06-02 17:08:35 | ||
| 1215 | 1226 | POFN-2215 | INVFN-2215 | 12516 | 1 | 2 | 1 | 10 | 185000.0 | 0.0 | 14095.24 | 4404.76 | 4404.76 | 0.0 | 185000.0 | INR | 92500.0 | 92537.5 | 92500.0 | 4 | 12516 | 2026-06-03 14:55:50 | 0 | NULL | 1 | 2026-06-28 15:56:18 | 1 | 1 | 2026-06-28 15:56:18 | ||
| 1216 | 1227 | POFN-2216 | INVFN-2216 | 12554 | 12516 | 2 | 1 | 10 | 185000.0 | 0.0 | 10571.43 | 4404.76 | 4404.76 | 0.0 | 185000.0 | INR | 92500.0 | 92537.5 | 92500.0 | 4 | 12554 | 2026-06-03 17:02:13 | 0 | NULL | 1 | 2026-06-03 17:03:11 | 12516 | 1 | 2026-06-03 17:03:11 | ||
| 1217 | 1228 | POFN-2217 | INVFN-2217 | 12554 | 12516 | 2 | 1 | 10 | 16000.0 | 0.0 | 914.29 | 380.95 | 380.95 | 0.0 | 16000.0 | INR | 8000.0 | 8002.5 | 8000.0 | 4 | 12554 | 2026-06-03 17:02:33 | 0 | NULL | 1 | 2026-06-03 17:03:11 | 12516 | 1 | 2026-06-03 17:03:11 | ||
| 1218 | 1229 | POFN-2218 | INVFN-2218 | 12555 | 12554 | 2 | 1 | 10 | 100500.0 | 0.0 | 1914.29 | 2392.86 | 2392.86 | 0.0 | 100500.0 | INR | 50250.0 | 50268.75 | 50250.0 | 4 | 12555 | 2026-06-03 17:04:09 | 0 | NULL | 1 | 2026-06-03 17:04:28 | 12554 | 1 | 2026-06-03 17:04:28 | ||
| 1219 | 1230 | POFN-2219 | INVFN-2219 | 12545 | 12517 | 2 | 1 | 2 | 2400.0 | 0.0 | 45.71 | 57.14 | 57.14 | 0.0 | 2400.0 | INR | 1200.0 | 1200.25 | 1200.0 | 4 | 12545 | 2026-06-03 21:34:29 | 0 | NULL | 1 | 2026-06-03 21:35:34 | 12517 | 1 | 2026-06-03 21:35:34 | ||
| 1220 | 1231 | POFN-2220 | INVFN-2220 | 12555 | 12554 | 2 | 1 | 4 | 6000.0 | 0.0 | 114.29 | 142.86 | 142.86 | 0.0 | 6000.0 | INR | 3000.0 | 3001.2 | 3000.0 | 4 | 12555 | 2026-06-04 17:20:10 | 0 | NULL | 1 | 2026-06-04 17:20:45 | 12554 | 1 | 2026-06-04 17:20:45 | ||
| 1221 | 1232 | POFN-2221 | INVFN-2221 | 12554 | 12516 | 2 | 1 | 30 | 75000.0 | 0.0 | 4368.93 | 1092.23 | 1092.23 | 0.0 | 75000.0 | INR | 37500.0 | 37515.0 | 37500.0 | 4 | 12554 | 2026-06-05 18:57:52 | 0 | NULL | 1 | 2026-06-05 18:59:23 | 12516 | 1 | 2026-06-05 18:59:23 | ||
| 1222 | 1233 | POFN-2222 | INVFN-2222 | 12555 | 12554 | 2 | 1 | 10 | 25000.0 | 0.0 | 485.44 | 364.08 | 364.08 | 0.0 | 25000.0 | INR | 12500.0 | 12505.0 | 12500.0 | 4 | 12555 | 2026-06-05 19:50:33 | 0 | NULL | 1 | 2026-06-05 19:51:25 | 12554 | 1 | 2026-06-05 19:51:25 | ||
| 1223 | 1234 | POFN-2223 | INVFN-2223 | 12555 | 12554 | 2 | 1 | 5 | 8000.0 | 0.0 | 152.38 | 190.48 | 190.48 | 0.0 | 8000.0 | INR | 4000.0 | 4001.25 | 4000.0 | 4 | 12555 | 2026-06-06 12:11:14 | 0 | NULL | 1 | 2026-06-06 12:11:40 | 12554 | 1 | 2026-06-06 12:11:40 | ||
| 1224 | 1235 | POFN-2224 | INVFN-2224 | 14902 | 12517 | 2 | 1 | 92 | 20198.0 | 0.0 | 362.46 | 1037.42 | 1037.42 | 0.0 | 20198.0 | INR | 8663.0 | 8663.02 | 8663.0 | 4 | 14902 | 2026-06-07 09:38:45 | 0 | NULL | 1 | 2026-06-07 10:19:36 | 12517 | 1 | 2026-06-07 10:19:36 | ||
| 1225 | 1236 | POFN-2225 | INVFN-2225 | 14902 | 12517 | 2 | 1 | 1 | 1000.0 | 0.0 | 19.05 | 23.81 | 23.81 | 0.0 | 1000.0 | INR | 500.0 | 500.18 | 500.0 | 4 | 14902 | 2026-06-07 12:34:40 | 0 | NULL | 1 | 2026-06-07 13:53:22 | 12517 | 1 | 2026-06-07 13:53:22 | ||
| 1226 | 1237 | POFN-2226 | INVFN-2226 | 12555 | 12554 | 2 | 1 | 48 | 66280.0 | 0.0 | 1248.23 | 1934.31 | 1934.31 | 0.0 | 66280.0 | INR | 33130.0 | 33131.8 | 33130.0 | 4 | 12555 | 2026-06-07 17:17:05 | 0 | NULL | 1 | 2026-06-07 17:17:28 | 12554 | 1 | 2026-06-07 17:17:28 | ||
| 1227 | 1238 | POFN-2227 | INVFN-2227 | 12554 | 12516 | 2 | 1 | 39 | 61100.0 | 0.0 | 3491.43 | 1454.76 | 1454.76 | 0.0 | 61100.0 | INR | 30300.0 | 30302.5 | 30300.0 | 4 | 12554 | 2026-06-07 17:21:33 | 0 | NULL | 1 | 2026-06-07 17:21:58 | 12516 | 1 | 2026-06-07 17:21:58 | ||
| 1228 | 1239 | POFN-2228 | INVFN-2228 | 12527 | 12517 | 2 | 1 | 51 | 18980.0 | 0.0 | 349.81 | 744.64 | 744.64 | 0.0 | 18980.0 | INR | 8640.0 | 8640.22 | 8640.0 | 4 | 12527 | 2026-06-08 15:26:48 | 0 | NULL | 1 | 2026-06-08 21:23:04 | 12517 | 1 | 2026-06-08 21:23:04 | ||
| 1229 | 1240 | POFN-2229 | INVFN-2229 | 12527 | 12517 | 2 | 1 | 2 | 1919.0 | 0.0 | 36.55 | 45.69 | 45.69 | 0.0 | 1919.0 | INR | 959.0 | 959.05 | 959.0 | 4 | 12527 | 2026-06-10 08:11:53 | 0 | NULL | 1 | 2026-06-10 11:40:27 | 12517 | 1 | 2026-06-10 11:40:27 | ||
| 1230 | 1241 | POFN-2230 | INVFN-2230 | 14079 | 12517 | 2 | 1 | 2 | 600.0 | 0.0 | 11.43 | 14.29 | 14.29 | 0.0 | 600.0 | INR | 300.0 | 300.1 | 300.0 | 4 | 14079 | 2026-06-11 18:54:37 | 0 | NULL | 1 | 2026-06-12 16:30:04 | 12517 | 1 | 2026-06-12 16:30:04 | ||
| 1231 | 1242 | POFN-2231 | INVFN-2231 | 12527 | 12517 | 2 | 1 | 1 | 1600.0 | 0.0 | 30.48 | 38.1 | 38.1 | 0.0 | 1600.0 | INR | 800.0 | 800.25 | 800.0 | 4 | 12527 | 2026-06-12 12:47:27 | 0 | NULL | 1 | 2026-06-12 16:21:54 | 12517 | 1 | 2026-06-12 16:21:54 | ||
| 1232 | 1243 | POFN-2232 | INVFN-2232 | 12527 | 12517 | 2 | 1 | 1 | 1600.0 | 0.0 | 30.48 | 38.1 | 38.1 | 0.0 | 1600.0 | INR | 800.0 | 800.25 | 800.0 | 4 | 12527 | 2026-06-12 19:24:02 | 0 | NULL | 1 | 2026-06-12 21:09:56 | 12517 | 1 | 2026-06-12 21:09:56 | ||
| 1233 | 1244 | POFN-2233 | INVFN-2233 | 16410 | 12555 | 2 | 1 | 9 | 2091.0 | 0.0 | 78.89 | 59.44 | 59.44 | 0.0 | 2091.0 | INR | 1003.0 | 1003.08 | 1003.0 | 4 | 16410 | 2026-06-13 13:04:53 | 0 | NULL | 1 | 2026-06-13 13:16:13 | 12555 | 1 | 2026-06-13 13:16:13 | ||
| 1234 | 1245 | POFN-2234 | INVFN-2234 | 16410 | 12555 | 2 | 1 | 4 | 3278.0 | 0.0 | 78.49 | 86.39 | 86.39 | 0.0 | 3278.0 | INR | 1614.0 | 1614.5 | 1614.0 | 4 | 16410 | 2026-06-13 13:15:23 | 0 | NULL | 1 | 2026-06-13 13:16:13 | 12555 | 1 | 2026-06-13 13:16:13 | ||
| 1235 | 1246 | POFN-2235 | INVFN-2235 | 12555 | 12554 | 2 | 1 | 20 | 32000.0 | 0.0 | 609.52 | 761.9 | 761.9 | 0.0 | 32000.0 | INR | 16000.0 | 16005.0 | 16000.0 | 4 | 12555 | 2026-06-13 13:20:29 | 0 | NULL | 1 | 2026-06-13 13:21:00 | 12554 | 1 | 2026-06-13 13:21:00 | ||
| 1236 | 1247 | POFN-2236 | INVFN-2236 | 16410 | 12555 | 2 | 1 | 6 | 2697.0 | 0.0 | 101.41 | 80.9 | 80.9 | 0.0 | 2697.0 | INR | 1289.0 | 1289.3 | 1289.0 | 4 | 16410 | 2026-06-13 13:28:28 | 0 | NULL | 1 | 2026-06-13 15:10:01 | 12555 | 1 | 2026-06-13 15:10:01 | ||
| 1237 | 1248 | POFN-2237 | INVFN-2237 | 12527 | 12517 | 2 | 1 | 1 | 559.0 | 0.0 | 9.47 | 42.64 | 42.64 | 0.0 | 559.0 | INR | 279.0 | 279.11 | 279.0 | 4 | 12527 | 2026-06-15 14:53:17 | 0 | NULL | 1 | 2026-06-15 16:09:20 | 12517 | 1 | 2026-06-15 16:09:20 | ||
| 1238 | 1249 | POFN-2238 | INVFN-2238 | 12527 | 12517 | 2 | 1 | 1 | 1600.0 | 0.0 | 30.48 | 38.1 | 38.1 | 0.0 | 1600.0 | INR | 800.0 | 800.25 | 800.0 | 4 | 12527 | 2026-06-15 16:09:37 | 0 | NULL | 1 | 2026-06-15 21:10:16 | 12517 | 1 | 2026-06-15 21:10:16 | ||
| 1239 | 1250 | POFN-2239 | INVFN-2239 | 12526 | 12517 | 2 | 1 | 7 | 8600.0 | 0.0 | 163.81 | 204.76 | 204.76 | 0.0 | 8600.0 | INR | 4300.0 | 4300.75 | 4300.0 | 4 | 12526 | 2026-06-15 22:48:22 | 0 | NULL | 1 | 2026-06-15 22:58:59 | 12517 | 1 | 2026-06-15 22:58:59 | ||
| 1240 | 1251 | POFN-2240 | INVFN-2240 | 12526 | 12517 | 2 | 1 | 2 | 3099.0 | 0.0 | 59.03 | 73.79 | 73.79 | 0.0 | 3099.0 | INR | 1549.0 | 1549.3 | 1549.0 | 4 | 12526 | 2026-06-15 23:06:46 | 0 | NULL | 1 | 2026-06-16 08:10:32 | 12517 | 1 | 2026-06-16 08:10:32 | ||
| 1241 | 1252 | POFN-2241 | INVFN-2241 | 16410 | 12555 | 2 | 1 | 11 | 6478.0 | 0.0 | 199.72 | 171.03 | 171.03 | 0.0 | 6478.0 | INR | 3218.0 | 3218.03 | 3218.0 | 4 | 16410 | 2026-06-17 10:59:31 | 0 | NULL | 1 | 2026-06-17 11:16:37 | 12555 | 1 | 2026-06-17 11:16:37 | ||
| 1242 | 1253 | POFN-2242 | INVFN-2242 | 12555 | 12554 | 2 | 1 | 10 | 7190.0 | 0.0 | 136.95 | 171.19 | 171.19 | 0.0 | 7190.0 | INR | 3590.0 | 3591.5 | 3590.0 | 4 | 12555 | 2026-06-17 11:26:59 | 0 | NULL | 1 | 2026-06-17 11:27:27 | 12554 | 1 | 2026-06-17 11:27:28 | ||
| 1243 | 1254 | POFN-2243 | INVFN-2243 | 12517 | 12516 | 2 | 1 | 30 | 6120.0 | 0.0 | 349.71 | 0.0 | 0.0 | 291.43 | 6120.0 | INR | 3060.0 | 3061.2 | 3060.0 | 4 | 12517 | 2026-06-17 11:29:12 | 0 | NULL | 1 | 2026-06-17 11:29:31 | 12516 | 1 | 2026-06-17 11:29:31 | ||
| 1244 | 1255 | POFN-2244 | INVFN-2244 | 12527 | 12517 | 2 | 1 | 1 | 1600.0 | 0.0 | 30.48 | 38.1 | 38.1 | 0.0 | 1600.0 | INR | 800.0 | 800.25 | 800.0 | 4 | 12527 | 2026-06-22 10:10:04 | 0 | NULL | 1 | 2026-06-22 11:36:26 | 12517 | 1 | 2026-06-22 11:36:26 | ||
| 1245 | 1256 | POFN-2245 | INVFN-2245 | 12685 | 12517 | 2 | 1 | 15 | 5548.0 | 0.0 | 102.53 | 210.79 | 210.79 | 0.0 | 5548.0 | INR | 2774.0 | 2774.48 | 2774.0 | 4 | 12685 | 2026-06-22 18:33:33 | 0 | NULL | 1 | 2026-06-23 00:00:26 | 12517 | 1 | 2026-06-23 00:00:26 | ||
| 1246 | 1257 | POFN-2246 | INVFN-2246 | 12527 | 12517 | 2 | 1 | 1 | 1600.0 | 0.0 | 30.48 | 38.1 | 38.1 | 0.0 | 1600.0 | INR | 800.0 | 800.25 | 800.0 | 4 | 12527 | 2026-06-23 09:48:47 | 0 | NULL | 1 | 2026-06-23 11:00:24 | 12517 | 1 | 2026-06-23 11:00:24 | ||
| 1247 | 1258 | POFN-2247 | INVFN-2247 | 12526 | 12517 | 2 | 1 | 4 | 736.0 | 0.0 | 12.47 | 56.14 | 56.14 | 0.0 | 736.0 | INR | 260.0 | 260.04 | 260.0 | 4 | 12526 | 2026-06-27 10:07:22 | 0 | NULL | 1 | 2026-06-27 12:35:13 | 12517 | 1 | 2026-06-27 12:35:13 | ||
| 1248 | 1259 | POFN-2248 | INVFN-2248 | 12516 | 1 | 2 | 1 | 30 | 198000.0 | 0.0 | 15085.71 | 4714.29 | 4714.29 | 0.0 | 198000.0 | INR | 99000.0 | 99020.0 | 99000.0 | 4 | 12516 | 2026-06-28 15:55:37 | 0 | NULL | 1 | 2026-06-28 15:56:18 | 1 | 1 | 2026-06-28 15:56:18 | ||
| 1249 | 1260 | POFN-2249 | INVFN-2249 | 12554 | 12516 | 2 | 1 | 11 | 98500.0 | 0.0 | 5628.57 | 2345.24 | 2345.24 | 0.0 | 98500.0 | INR | 49250.0 | 49260.0 | 49250.0 | 4 | 12554 | 2026-06-28 17:22:54 | 0 | NULL | 1 | 2026-06-28 19:00:51 | 12516 | 1 | 2026-06-28 19:00:51 | ||
| 1250 | 1261 | POFN-2250 | INVFN-2250 | 12555 | 12554 | 2 | 1 | 7 | 58900.0 | 0.0 | 1121.9 | 1402.38 | 1402.38 | 0.0 | 58900.0 | INR | 29450.0 | 29454.0 | 29450.0 | 4 | 12555 | 2026-06-28 19:03:22 | 0 | NULL | 1 | 2026-06-28 19:03:58 | 12554 | 1 | 2026-06-28 19:03:58 |