fx_franchise_order

1,267 rows · 31 columns · page 26 / 26

Invoice view Excel export
# 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