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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1051 | 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 | ||
| 1052 | 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 | ||
| 1053 | 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 | ||
| 1054 | 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 | ||
| 1055 | 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 | ||
| 1056 | 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 | ||
| 1057 | 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 |