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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1251 | 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 | ||
| 1252 | 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 | ||
| 1253 | 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 | ||
| 1254 | 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 | ||
| 1255 | 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 | ||
| 1256 | 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 | ||
| 1257 | 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 | ||
| 1258 | 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 | ||
| 1259 | 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 | ||
| 1260 | 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 | ||
| 1261 | 1272 | POFN-2261 | INVFN-2261 | 12555 | 12554 | 2 | 1 | 5 | 2795.0 | 0.0 | 53.24 | 66.55 | 66.55 | 0.0 | 2795.0 | INR | 1395.0 | 1395.55 | 1395.0 | 4 | 12555 | 2026-06-30 20:05:20 | 0 | NULL | 1 | 2026-06-30 20:05:55 | 12554 | 1 | 2026-06-30 20:05:55 | ||
| 1262 | 1273 | POFN-2262 | INVFN-2262 | 12526 | 12517 | 2 | 1 | 12 | 3960.0 | 0.0 | 71.65 | 188.72 | 188.72 | 0.0 | 3960.0 | INR | 1707.0 | 1707.03 | 1707.0 | 4 | 12526 | 2026-06-30 21:15:28 | 0 | NULL | 1 | 2026-06-30 21:42:29 | 12517 | 1 | 2026-06-30 21:42:29 | ||
| 1263 | 1274 | POFN-2263 | INVFN-2263 | 12527 | 12517 | 2 | 1 | 8 | 9600.0 | 0.0 | 182.86 | 228.57 | 228.57 | 0.0 | 9600.0 | INR | 4800.0 | 4801.0 | 4800.0 | 4 | 12527 | 2026-07-07 14:11:57 | 0 | NULL | 1 | 2026-07-07 14:16:05 | 12517 | 1 | 2026-07-07 14:16:05 | ||
| 1264 | 1275 | POFN-2264 | INVFN-2264 | 12555 | 12554 | 2 | 1 | 3 | 4797.0 | 0.0 | 91.37 | 114.21 | 114.21 | 0.0 | 4797.0 | INR | 2397.0 | 2397.9 | 2397.0 | 4 | 12555 | 2026-07-14 19:28:34 | 0 | NULL | 1 | 2026-07-14 19:29:08 | 12554 | 1 | 2026-07-14 19:29:08 | ||
| 1265 | 1276 | POFN-2265 | INVFN-2265 | 12527 | 12517 | 2 | 1 | 30 | 13440.0 | 0.0 | 235.14 | 320.0 | 320.0 | 0.0 | 13440.0 | INR | 6520.0 | 6520.15 | 6520.0 | 4 | 12527 | 2026-07-16 13:56:54 | 0 | NULL | 1 | 2026-07-16 19:23:02 | 12517 | 1 | 2026-07-16 19:23:02 | ||
| 1266 | 1277 | POFN-2266 | INVFN-2266 | 12527 | 12517 | 2 | 1 | 69 | 13190.0 | 0.0 | 247.4 | 410.07 | 410.07 | 0.0 | 13190.0 | INR | 6325.0 | 6325.3 | 6325.0 | 4 | 12527 | 2026-07-30 09:46:26 | 0 | NULL | 1 | 2026-07-30 11:36:29 | 12517 | 1 | 2026-07-30 11:36:29 | ||
| 1267 | 1278 | POFN-2267 | INVFN-2267 | 12526 | 12517 | 2 | 1 | 54 | 8480.0 | 0.0 | 157.7 | 297.44 | 297.44 | 0.0 | 8480.0 | INR | 4031.0 | 4031.8 | 4031.0 | 4 | 12526 | 2026-07-31 13:11:15 | 0 | NULL | 1 | 2026-07-31 14:32:03 | 12517 | 1 | 2026-07-31 14:32:03 |