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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 11 | POF-1011 | INVF-1011 | 12555 | 12554 | 2 | 0 | 10 | 14990.0 | 0.0 | 0.0 | 1143.31 | 1143.31 | 0.0 | 14990.0 | INR | 0.0 | 0.0 | 0.0 | 4 | 12555 | 2025-11-03 11:04:39 | 0 | NULL | 2 | 2025-11-11 16:09:01 | 12516 | 0 | NULL | ||
| 2 | 12 | POF-1012 | INVF-1012 | 12555 | 12554 | 2 | 0 | 5 | 7495.0 | 0.0 | 0.0 | 571.65 | 571.65 | 0.0 | 7495.0 | INR | 0.0 | 0.0 | 0.0 | 2 | 12555 | 2025-11-03 11:43:40 | 0 | NULL | 1 | 2025-11-03 12:23:04 | 12554 | 0 | NULL | ||
| 3 | 13 | POF-1013 | INVF-1013 | 12554 | 12516 | 2 | 0 | 5 | 7495.0 | 0.0 | 0.0 | 571.65 | 571.65 | 0.0 | 7495.0 | INR | 0.0 | 0.0 | 0.0 | 2 | 12554 | 2025-11-03 11:46:18 | 0 | NULL | 1 | 2025-11-03 12:22:11 | 12516 | 0 | NULL | ||
| 4 | 14 | POF-1014 | INVF-1014 | 12516 | 1 | 2 | 0 | 10 | 14990.0 | 0.0 | 0.0 | 1143.31 | 1143.31 | 0.0 | 14990.0 | INR | 0.0 | 0.0 | 0.0 | 2 | 12516 | 2025-11-03 11:48:13 | 0 | NULL | 1 | 2025-11-03 12:21:55 | 1 | 0 | NULL | ||
| 5 | 15 | POF-1005 | INVF-1005 | 12516 | 1 | 2 | 2 | 1 | 3998.4 | 0.0 | 0.0 | 95.2 | 95.2 | 0.0 | 3998.4 | INR | 1000.0 | 0.0 | 0.0 | 4 | 12516 | 2025-11-06 13:33:53 | 0 | NULL | 1 | 2025-11-06 13:38:02 | 1 | 0 | NULL | ||
| 6 | 16 | POF-1006 | INVF-1006 | 12517 | 12516 | 2 | 2 | 1 | 3998.4 | 0.0 | 0.0 | 0.0 | 0.0 | 190.4 | 3998.4 | INR | 1000.0 | 0.0 | 0.0 | 2 | 12517 | 2025-11-06 13:38:39 | 0 | NULL | 1 | 2025-11-06 13:38:54 | 12516 | 0 | NULL | ||
| 7 | 17 | POF-1007 | INVF-1007 | 12518 | 12517 | 2 | 2 | 1 | 3998.4 | 0.0 | 0.0 | 95.2 | 95.2 | 0.0 | 3998.4 | INR | 1000.0 | 0.0 | 0.0 | 2 | 12518 | 2025-11-06 13:39:17 | 0 | NULL | 1 | 2025-11-06 13:39:34 | 12517 | 0 | NULL | ||
| 8 | 18 | POF-1008 | INVF-1008 | 12516 | 1 | 2 | 2 | 1 | 3998.4 | 0.0 | 0.0 | 95.2 | 95.2 | 0.0 | 3998.4 | INR | 1000.0 | 0.0 | 0.0 | 2 | 12516 | 2025-11-06 13:47:40 | 0 | NULL | 1 | 2025-11-06 13:48:20 | 1 | 0 | NULL | ||
| 9 | 19 | POF-1009 | INVF-1009 | 12517 | 12516 | 2 | 2 | 1 | 3998.4 | 0.0 | 0.0 | 0.0 | 0.0 | 190.4 | 3998.4 | INR | 1000.0 | 0.0 | 0.0 | 2 | 12517 | 2025-11-06 13:48:47 | 0 | NULL | 1 | 2025-11-06 13:48:56 | 12516 | 0 | NULL | ||
| 10 | 20 | POF-1010 | INVF-1010 | 12518 | 12517 | 2 | 2 | 1 | 3998.4 | 0.0 | 0.0 | 95.2 | 95.2 | 0.0 | 3998.4 | INR | 1000.0 | 0.0 | 0.0 | 2 | 12518 | 2025-11-06 13:49:11 | 0 | NULL | 1 | 2025-11-06 13:49:27 | 12517 | 0 | NULL | ||
| 11 | 21 | POF-1011 | INVF-1011 | 12516 | 1 | 2 | 2 | 1 | 3998.4 | 0.0 | 0.0 | 95.2 | 95.2 | 0.0 | 3998.4 | INR | 1000.0 | 0.0 | 0.0 | 2 | 12516 | 2025-11-06 16:26:30 | 0 | NULL | 1 | 2025-11-06 16:27:59 | 1 | 0 | NULL | ||
| 12 | 22 | POF-1012 | INVF-1012 | 12517 | 12516 | 2 | 2 | 1 | 3998.4 | 0.0 | 0.0 | 0.0 | 0.0 | 190.4 | 3998.4 | INR | 1000.0 | 0.0 | 0.0 | 2 | 12517 | 2025-11-06 16:29:11 | 0 | NULL | 1 | 2025-11-06 16:29:24 | 12516 | 0 | NULL | ||
| 13 | 23 | POF-1013 | INVF-1013 | 12516 | 1 | 2 | 1 | 1 | 1499.0 | 0.0 | 119.92 | 114.33 | 114.33 | 0.0 | 1379.08 | INR | 0.0 | 450.0 | 200.0 | 4 | 12516 | 2025-11-06 19:26:47 | 0 | NULL | 1 | 2025-11-09 22:37:31 | 1 | 0 | NULL | ||
| 14 | 24 | POF-1014 | INVF-1014 | 12516 | 1 | 2 | 1 | 1 | 1499.0 | 0.0 | 119.92 | 114.33 | 114.33 | 0.0 | 1379.08 | INR | 450.0 | 450.0 | 650.0 | 4 | 12516 | 2025-11-06 19:31:57 | 0 | NULL | 1 | 2025-11-09 22:37:31 | 1 | 0 | NULL | ||
| 15 | 25 | POF-1015 | INVF-1015 | 12555 | 12554 | 2 | 2 | 1 | 13699.0 | 0.0 | 273.98 | 1044.84 | 1044.84 | 0.0 | 13425.02 | INR | 0.0 | 3000.0 | 0.0 | 4 | 12555 | 2025-11-06 20:00:24 | 0 | NULL | 1 | 2025-11-06 20:52:48 | 12554 | 0 | NULL | ||
| 16 | 26 | POF-1016 | INVF-1016 | 12555 | 12554 | 2 | 1 | 1 | 1499.0 | 0.0 | 29.98 | 114.33 | 114.33 | 0.0 | 1469.02 | INR | 450.0 | 450.0 | 650.0 | 4 | 12555 | 2025-11-06 20:02:54 | 0 | NULL | 2 | 2025-11-12 08:23:36 | 12554 | 0 | NULL | ||
| 17 | 27 | POF-1017 | INVF-1017 | 12555 | 12554 | 2 | 1 | 1 | 1124.25 | 0.0 | 22.48 | 85.75 | 85.75 | 0.0 | 1101.77 | INR | 450.0 | 450.0 | 650.0 | 4 | 12555 | 2025-11-06 20:21:47 | 0 | NULL | 2 | 2025-11-12 08:23:36 | 12554 | 0 | NULL | ||
| 18 | 28 | POF-1018 | INVF-1018 | 12555 | 12554 | 2 | 2 | 1 | 13699.0 | 0.0 | 273.98 | 1044.84 | 1044.84 | 0.0 | 13425.02 | INR | 0.0 | 3000.0 | 0.0 | 4 | 12555 | 2025-11-06 20:46:06 | 0 | NULL | 2 | 2025-11-12 08:23:36 | 12554 | 0 | NULL | ||
| 19 | 29 | POF-1019 | INVF-1019 | 12554 | 12516 | 2 | 2 | 1 | 13699.0 | 0.0 | 684.95 | 1044.84 | 1044.84 | 0.0 | 13014.05 | INR | 0.0 | 3000.0 | 0.0 | 4 | 12554 | 2025-11-06 20:48:40 | 0 | NULL | 1 | 2025-11-06 20:50:47 | 12516 | 0 | NULL | ||
| 20 | 30 | POF-1020 | INVF-1020 | 12516 | 1 | 2 | 2 | 1 | 13699.0 | 0.0 | 1095.92 | 1044.84 | 1044.84 | 0.0 | 12603.08 | INR | 0.0 | 3000.0 | 0.0 | 4 | 12516 | 2025-11-06 20:49:16 | 0 | NULL | 1 | 2025-11-06 20:50:34 | 1 | 0 | NULL | ||
| 21 | 31 | POF-1021 | INVF-1021 | 12526 | 12517 | 2 | 2 | 1 | 10499.0 | 0.0 | 209.98 | 249.97 | 249.97 | 0.0 | 10289.02 | INR | 0.0 | 3500.0 | 0.0 | 4 | 12526 | 2025-11-06 21:38:46 | 0 | NULL | 1 | 2025-11-06 21:43:28 | 12517 | 0 | NULL | ||
| 22 | 32 | POF-1022 | INVF-1022 | 12526 | 12517 | 2 | 2 | 1 | 3998.4 | 0.0 | 79.97 | 95.2 | 95.2 | 0.0 | 3918.43 | INR | 0.0 | 1000.0 | 0.0 | 4 | 12526 | 2025-11-06 21:39:40 | 0 | NULL | 1 | 2025-11-06 22:27:56 | 12517 | 0 | NULL | ||
| 23 | 33 | POF-1023 | INVF-1023 | 12517 | 12516 | 2 | 2 | 2 | 20998.0 | 0.0 | 1049.9 | 0.0 | 0.0 | 999.9 | 19948.1 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12517 | 2025-11-06 21:41:46 | 0 | NULL | 1 | 2025-11-06 21:43:01 | 12516 | 0 | NULL | ||
| 24 | 34 | POF-1024 | INVF-1024 | 12516 | 1 | 2 | 2 | 3 | 31497.0 | 0.0 | 2519.76 | 749.93 | 749.93 | 0.0 | 28977.24 | INR | 0.0 | 10500.0 | 0.0 | 4 | 12516 | 2025-11-06 21:42:26 | 0 | NULL | 1 | 2025-11-06 21:42:50 | 1 | 0 | NULL | ||
| 25 | 35 | POF-1025 | INVF-1025 | 12516 | 1 | 2 | 2 | 495 | 5672343.6 | 0.0 | 453787.49 | 206204.36 | 206204.36 | 0.0 | 5218556.11 | INR | 0.0 | 346500.0 | 0.0 | 4 | 12516 | 2025-11-06 22:17:20 | 0 | NULL | 1 | 2025-11-06 22:36:33 | 1 | 0 | NULL | ||
| 26 | 36 | POF-1026 | INVF-1026 | 12557 | 12517 | 2 | 2 | 1 | 10499.0 | 0.0 | 209.98 | 249.97 | 249.97 | 0.0 | 10289.02 | INR | 0.0 | 3500.0 | 0.0 | 4 | 12557 | 2025-11-06 22:18:36 | 0 | NULL | 1 | 2025-11-06 22:27:56 | 12517 | 0 | NULL | ||
| 27 | 37 | POF-1027 | INVF-1027 | 12557 | 12517 | 2 | 2 | 1 | 10499.0 | 0.0 | 209.98 | 249.97 | 249.97 | 0.0 | 10289.02 | INR | 0.0 | 3500.0 | 0.0 | 4 | 12557 | 2025-11-06 22:24:05 | 0 | NULL | 1 | 2025-11-06 22:39:02 | 12517 | 0 | NULL | ||
| 28 | 38 | POF-1028 | INVF-1028 | 12516 | 1 | 2 | 2 | 50 | 483951.0 | 0.0 | 38716.08 | 15116.0 | 15116.0 | 0.0 | 445234.92 | INR | 0.0 | 17500.0 | 0.0 | 4 | 12516 | 2025-11-06 22:30:58 | 0 | NULL | 1 | 2025-11-06 22:34:03 | 1 | 0 | NULL | ||
| 29 | 39 | POF-1029 | INVF-1029 | 12516 | 1 | 2 | 2 | 25 | 99960.0 | 0.0 | 7996.8 | 2380.0 | 2380.0 | 0.0 | 91963.2 | INR | 0.0 | 25000.0 | 0.0 | 4 | 12516 | 2025-11-06 22:32:03 | 0 | NULL | 1 | 2025-11-06 22:34:03 | 1 | 0 | NULL | ||
| 30 | 40 | POF-1030 | INVF-1030 | 12542 | 12517 | 2 | 2 | 1 | 10499.0 | 0.0 | 209.98 | 249.97 | 249.97 | 0.0 | 10289.02 | INR | 0.0 | 3500.0 | 0.0 | 4 | 12542 | 2025-11-06 22:32:50 | 0 | NULL | 1 | 2025-11-06 22:39:02 | 12517 | 0 | NULL | ||
| 31 | 41 | POF-1031 | INVF-1031 | 12517 | 12516 | 2 | 2 | 25 | 99960.0 | 0.0 | 4998.0 | 0.0 | 0.0 | 4760.0 | 94962.0 | INR | 0.0 | 25000.0 | 0.0 | 4 | 12517 | 2025-11-06 22:33:12 | 0 | NULL | 1 | 2025-11-06 22:36:42 | 12516 | 0 | NULL | ||
| 32 | 42 | POF-1032 | INVF-1032 | 12517 | 12516 | 2 | 2 | 5 | 92500.0 | 0.0 | 4625.0 | 0.0 | 0.0 | 4404.76 | 87875.0 | INR | 0.0 | 37500.0 | 0.0 | 4 | 12517 | 2025-11-06 22:37:20 | 0 | NULL | 1 | 2025-11-06 22:38:43 | 12516 | 0 | NULL | ||
| 33 | 43 | POF-1033 | INVF-1033 | 12517 | 12516 | 2 | 2 | 25 | 262475.0 | 0.0 | 13123.75 | 0.0 | 0.0 | 12498.81 | 249351.25 | INR | 0.0 | 87500.0 | 0.0 | 4 | 12517 | 2025-11-06 22:37:36 | 0 | NULL | 1 | 2025-11-06 22:38:43 | 12516 | 0 | NULL | ||
| 34 | 44 | POF-1034 | INVF-1034 | 12517 | 12516 | 2 | 2 | 3 | 41097.0 | 0.0 | 2054.85 | 0.0 | 0.0 | 6269.03 | 39042.15 | INR | 0.0 | 9000.0 | 0.0 | 4 | 12517 | 2025-11-06 22:38:08 | 0 | NULL | 1 | 2025-11-06 22:38:43 | 12516 | 0 | NULL | ||
| 35 | 45 | POF-1035 | INVF-1035 | 12544 | 12517 | 2 | 2 | 1 | 10499.0 | 0.0 | 209.98 | 249.97 | 249.97 | 0.0 | 10289.02 | INR | 0.0 | 3500.0 | 0.0 | 4 | 12544 | 2025-11-06 23:02:00 | 0 | NULL | 1 | 2025-11-07 00:02:48 | 12517 | 0 | NULL | ||
| 36 | 46 | POF-1036 | INVF-1036 | 12546 | 12517 | 2 | 2 | 1 | 10499.0 | 0.0 | 209.98 | 249.97 | 249.97 | 0.0 | 10289.02 | INR | 0.0 | 3500.0 | 0.0 | 4 | 12546 | 2025-11-07 09:30:36 | 0 | NULL | 1 | 2025-11-07 11:25:39 | 12517 | 0 | NULL | ||
| 37 | 47 | POF-1037 | INVF-1037 | 12552 | 12517 | 2 | 2 | 1 | 3998.4 | 0.0 | 79.97 | 95.2 | 95.2 | 0.0 | 3918.43 | INR | 0.0 | 1000.0 | 0.0 | 4 | 12552 | 2025-11-07 11:03:22 | 0 | NULL | 1 | 2025-11-07 11:25:39 | 12517 | 0 | NULL | ||
| 38 | 48 | POF-1038 | INVF-1038 | 12517 | 12516 | 2 | 2 | 1 | 3998.4 | 0.0 | 199.92 | 0.0 | 0.0 | 190.4 | 3798.48 | INR | 0.0 | 1000.0 | 0.0 | 4 | 12517 | 2025-11-07 11:19:52 | 0 | NULL | 1 | 2025-11-07 18:39:01 | 12516 | 0 | NULL | ||
| 39 | 49 | POF-1039 | INVF-1039 | 12532 | 12517 | 2 | 2 | 1 | 10499.0 | 0.0 | 209.98 | 249.97 | 249.97 | 0.0 | 10289.02 | INR | 0.0 | 3500.0 | 0.0 | 4 | 12532 | 2025-11-07 11:23:10 | 0 | NULL | 1 | 2025-11-07 11:25:39 | 12517 | 0 | NULL | ||
| 40 | 50 | POF-1040 | INVF-1040 | 12557 | 12517 | 2 | 1 | 1 | 48.0 | 0.0 | 0.96 | 1.15 | 1.15 | 0.0 | 47.04 | INR | 10.0 | 10.0 | 13.0 | 4 | 12557 | 2025-11-07 11:38:24 | 0 | NULL | 1 | 2025-11-07 23:56:54 | 12517 | 0 | NULL | ||
| 41 | 51 | POF-1041 | INVF-1041 | 12534 | 12517 | 2 | 2 | 1 | 10499.0 | 0.0 | 209.98 | 249.97 | 249.97 | 0.0 | 10289.02 | INR | 0.0 | 3500.0 | 0.0 | 4 | 12534 | 2025-11-07 11:48:52 | 0 | NULL | 1 | 2025-11-07 18:21:22 | 12517 | 0 | NULL | ||
| 42 | 52 | POF-1042 | INVF-1042 | 12529 | 12517 | 2 | 2 | 2 | 20998.0 | 0.0 | 419.96 | 499.95 | 499.95 | 0.0 | 20578.04 | INR | 0.0 | 7000.0 | 0.0 | 4 | 12529 | 2025-11-07 11:56:23 | 0 | NULL | 1 | 2025-11-07 18:21:22 | 12517 | 0 | NULL | ||
| 43 | 53 | POF-1043 | INVF-1043 | 12552 | 12517 | 2 | 2 | 4 | 45196.0 | 0.0 | 903.92 | 1794.77 | 1794.77 | 0.0 | 44292.08 | INR | 0.0 | 10500.0 | 0.0 | 4 | 12552 | 2025-11-07 16:42:50 | 0 | NULL | 1 | 2025-11-07 18:21:22 | 12517 | 0 | NULL | ||
| 44 | 54 | POF-1044 | INVF-1044 | 12540 | 12517 | 2 | 1 | 184 | 64256.8 | 0.0 | 1285.14 | 2313.63 | 2313.63 | 0.0 | 62971.66 | INR | 20390.0 | 20390.0 | 22088.0 | 4 | 12540 | 2025-11-07 17:20:25 | 0 | NULL | 1 | 2025-11-08 00:06:24 | 12517 | 0 | NULL | ||
| 45 | 55 | POF-1045 | INVF-1045 | 12533 | 12517 | 2 | 1 | 163 | 38494.4 | 0.0 | 769.89 | 1309.51 | 1309.51 | 0.0 | 37724.51 | INR | 13206.0 | 13206.0 | 13356.0 | 4 | 12533 | 2025-11-07 18:00:39 | 0 | NULL | 1 | 2025-11-07 23:56:54 | 12517 | 0 | NULL | ||
| 46 | 56 | POF-1046 | INVF-1046 | 12532 | 12517 | 2 | 1 | 697 | 125815.0 | 0.0 | 2516.3 | 4303.42 | 4303.42 | 0.0 | 123298.7 | INR | 36173.0 | 36173.0 | 36533.0 | 4 | 12532 | 2025-11-07 18:03:06 | 0 | NULL | 1 | 2025-11-08 00:06:27 | 12517 | 0 | NULL | ||
| 47 | 57 | POF-1047 | INVF-1047 | 12557 | 12517 | 2 | 1 | 152 | 18812.8 | 0.0 | 376.26 | 515.46 | 515.46 | 0.0 | 18436.54 | INR | 5707.0 | 5707.0 | 5837.0 | 4 | 12557 | 2025-11-07 18:20:42 | 0 | NULL | 1 | 2025-11-08 00:06:30 | 12517 | 0 | NULL | ||
| 48 | 58 | POF-1048 | INVF-1048 | 12524 | 12517 | 2 | 1 | 176 | 58328.0 | 0.0 | 1166.56 | 1652.34 | 1652.34 | 0.0 | 57161.44 | INR | 13825.0 | 13825.0 | 13975.0 | 4 | 12524 | 2025-11-07 18:31:54 | 0 | NULL | 1 | 2025-11-08 00:06:35 | 12517 | 0 | NULL | ||
| 49 | 59 | POF-1049 | INVF-1049 | 12516 | 1 | 2 | 1 | 8160 | 2186323.6 | 0.0 | 174905.89 | 71656.38 | 71656.38 | 0.0 | 2011417.71 | INR | 689030.0 | 689030.0 | 695630.0 | 4 | 12516 | 2025-11-07 18:37:14 | 0 | NULL | 2 | 2025-11-11 21:20:01 | 1 | 0 | NULL | ||
| 50 | 60 | POF-1050 | INVF-1050 | 12516 | 1 | 2 | 1 | 96 | 26896.8 | 0.0 | 2151.74 | 1327.64 | 1327.64 | 0.0 | 24745.06 | INR | 8255.0 | 8255.0 | 9255.0 | 4 | 12516 | 2025-11-07 18:50:33 | 0 | NULL | 1 | 2025-11-09 22:37:31 | 1 | 0 | NULL |