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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1001 | 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 | ||
| 1002 | 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 | ||
| 1003 | 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 | ||
| 1004 | 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 | ||
| 1005 | 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 | ||
| 1006 | 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 | ||
| 1007 | 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 | ||
| 1008 | 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 | ||
| 1009 | 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 | ||
| 1010 | 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 | ||
| 1011 | 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 | ||
| 1012 | 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 | ||
| 1013 | 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 | ||
| 1014 | 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 | ||
| 1015 | 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 | ||
| 1016 | 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 | ||
| 1017 | 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 | ||
| 1018 | 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 | ||
| 1019 | 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 | ||
| 1020 | 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 | ||
| 1021 | 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 | ||
| 1022 | 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 | ||
| 1023 | 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 | ||
| 1024 | 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 | ||
| 1025 | 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 | ||
| 1026 | 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 | ||
| 1027 | 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 | ||
| 1028 | 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 | ||
| 1029 | 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 | ||
| 1030 | 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 | ||
| 1031 | 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 | ||
| 1032 | 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 | ||
| 1033 | 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 | ||
| 1034 | 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 | ||
| 1035 | 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 | ||
| 1036 | 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 | ||
| 1037 | 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 | ||
| 1038 | 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 | ||
| 1039 | 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 | ||
| 1040 | 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 | ||
| 1041 | 1262 | POFN-2251 | INVFN-2251 | 12527 | 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 | 12527 | 2026-06-29 10:18:38 | 0 | NULL | 1 | 2026-06-29 10:51:04 | 12517 | 1 | 2026-06-29 10:51:04 | ||
| 1042 | 1263 | POFN-2252 | INVFN-2252 | 12517 | 12516 | 2 | 1 | 97 | 42990.0 | 0.0 | 2362.14 | 0.0 | 0.0 | 3620.99 | 42990.0 | INR | 21495.0 | 21496.2 | 21495.0 | 4 | 12517 | 2026-06-29 17:25:02 | 0 | NULL | 2 | 2026-06-29 18:17:11 | 12516 | 0 | NULL | ||
| 1043 | 1264 | POFN-2253 | INVFN-2253 | 12517 | 12516 | 2 | 1 | 95 | 36389.0 | 0.0 | 2008.55 | 0.0 | 0.0 | 2913.2 | 36389.0 | INR | 18189.0 | 18191.4 | 18189.0 | 4 | 12517 | 2026-06-29 18:30:31 | 0 | NULL | 1 | 2026-06-29 18:31:52 | 12516 | 1 | 2026-06-29 18:31:52 | ||
| 1044 | 1265 | POFN-2254 | INVFN-2254 | 12526 | 12517 | 2 | 1 | 11 | 7952.0 | 0.0 | 141.7 | 433.38 | 433.38 | 0.0 | 7952.0 | INR | 3731.0 | 3731.3 | 3731.0 | 4 | 12526 | 2026-06-29 22:33:56 | 0 | NULL | 1 | 2026-06-29 22:39:53 | 12517 | 1 | 2026-06-29 22:39:53 | ||
| 1045 | 1266 | POFN-2255 | INVFN-2255 | 12527 | 12517 | 2 | 1 | 54 | 11157.0 | 0.0 | 195.6 | 688.48 | 688.48 | 0.0 | 11157.0 | INR | 4367.0 | 4367.11 | 4367.0 | 4 | 12527 | 2026-06-30 07:53:39 | 0 | NULL | 1 | 2026-06-30 11:10:24 | 12517 | 1 | 2026-06-30 11:10:24 | ||
| 1046 | 1267 | POFN-2256 | INVFN-2256 | 12539 | 12517 | 2 | 1 | 8 | 2628.0 | 0.0 | 50.06 | 62.57 | 62.57 | 0.0 | 2628.0 | INR | 1314.0 | 1314.28 | 1314.0 | 4 | 12539 | 2026-06-30 14:28:31 | 0 | NULL | 1 | 2026-06-30 14:29:55 | 12517 | 1 | 2026-06-30 14:29:55 | ||
| 1047 | 1268 | POFN-2257 | INVFN-2257 | 12545 | 12517 | 2 | 1 | 26 | 4674.0 | 0.0 | 84.36 | 228.07 | 228.07 | 0.0 | 4674.0 | INR | 1994.0 | 1994.48 | 1994.0 | 4 | 12545 | 2026-06-30 16:36:58 | 0 | NULL | 1 | 2026-06-30 17:43:07 | 12517 | 1 | 2026-06-30 17:43:07 | ||
| 1048 | 1269 | POFN-2258 | INVFN-2258 | 12539 | 12517 | 2 | 1 | 8 | 1632.0 | 0.0 | 31.09 | 38.86 | 38.86 | 0.0 | 1632.0 | INR | 816.0 | 816.32 | 816.0 | 4 | 12539 | 2026-06-30 17:47:50 | 0 | NULL | 1 | 2026-06-30 17:58:34 | 12517 | 1 | 2026-06-30 17:58:34 | ||
| 1049 | 1270 | POFN-2259 | INVFN-2259 | 12532 | 12517 | 2 | 1 | 26 | 9878.0 | 0.0 | 186.14 | 285.55 | 285.55 | 0.0 | 9878.0 | INR | 4938.0 | 4938.2 | 4938.0 | 4 | 12532 | 2026-06-30 19:02:10 | 0 | NULL | 1 | 2026-06-30 19:29:27 | 12517 | 1 | 2026-06-30 19:29:27 | ||
| 1050 | 1271 | POFN-2260 | INVFN-2260 | 12555 | 12554 | 2 | 1 | 10 | 16500.0 | 0.0 | 314.29 | 392.86 | 392.86 | 0.0 | 16500.0 | INR | 8000.0 | 8002.5 | 8000.0 | 4 | 12555 | 2026-06-30 19:05:03 | 0 | NULL | 1 | 2026-06-30 19:06:17 | 12554 | 1 | 2026-06-30 19:06:17 |