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 | 1061 | POFN-2051 | INVFN-2051 | 12521 | 12517 | 2 | 1 | 4 | 4800.0 | 0.0 | 91.43 | 114.29 | 114.29 | 0.0 | 4800.0 | INR | 0.0 | 0.5 | 0.0 | 4 | 12521 | 2026-03-27 22:56:16 | 0 | NULL | 1 | 2026-03-27 23:01:44 | 12517 | 1 | 2026-03-27 23:01:44 | ||
| 1052 | 1062 | POFN-2052 | INVFN-2052 | 12521 | 12517 | 2 | 1 | 65 | 3120.0 | 0.0 | 59.43 | 74.29 | 74.29 | 0.0 | 3120.0 | INR | 0.0 | 0.39 | 0.0 | 4 | 12521 | 2026-03-27 23:12:00 | 0 | NULL | 1 | 2026-03-28 08:27:12 | 12517 | 1 | 2026-03-28 08:27:12 | ||
| 1053 | 1063 | POFN-2053 | INVFN-2053 | 12517 | 12516 | 2 | 1 | 25 | 36000.0 | 0.0 | 2057.14 | 0.0 | 0.0 | 1714.29 | 36000.0 | INR | 0.0 | 5.0 | 0.0 | 4 | 12517 | 2026-03-30 12:20:17 | 0 | NULL | 1 | 2026-03-30 12:21:09 | 12516 | 1 | 2026-03-30 12:21:09 | ||
| 1054 | 1064 | POFN-2054 | INVFN-2054 | 12516 | 1 | 2 | 1 | 20 | 28800.0 | 0.0 | 2194.29 | 685.71 | 685.71 | 0.0 | 28800.0 | INR | 0.0 | 4.0 | 0.0 | 4 | 12516 | 2026-03-30 12:20:39 | 0 | NULL | 1 | 2026-03-30 12:20:54 | 1 | 1 | 2026-03-30 12:20:54 | ||
| 1055 | 1065 | POFN-2055 | INVFN-2055 | 12548 | 12517 | 2 | 1 | 3 | 5200.0 | 0.0 | 99.05 | 123.81 | 123.81 | 0.0 | 5200.0 | INR | 0.0 | 0.2 | 0.0 | 4 | 12548 | 2026-03-30 18:51:16 | 0 | NULL | 1 | 2026-03-30 19:35:33 | 12517 | 1 | 2026-03-30 19:35:33 | ||
| 1056 | 1066 | POFN-2056 | INVFN-2056 | 12526 | 12517 | 2 | 1 | 90 | 15435.0 | 0.0 | 291.07 | 440.68 | 440.68 | 0.0 | 15435.0 | INR | 0.0 | 0.06 | 0.0 | 4 | 12526 | 2026-03-30 21:11:48 | 0 | NULL | 1 | 2026-03-30 22:10:15 | 12517 | 1 | 2026-03-30 22:10:15 | ||
| 1057 | 1067 | POFN-2057 | INVFN-2057 | 12539 | 12517 | 2 | 1 | 9 | 4926.0 | 0.0 | 93.83 | 117.29 | 117.29 | 0.0 | 4926.0 | INR | 0.0 | 0.01 | 0.0 | 4 | 12539 | 2026-03-31 19:17:39 | 0 | NULL | 1 | 2026-03-31 19:34:13 | 12517 | 1 | 2026-03-31 19:34:13 | ||
| 1058 | 1068 | POFN-2058 | INVFN-2058 | 14079 | 12517 | 2 | 1 | 2 | 558.0 | 0.0 | 10.63 | 13.29 | 13.29 | 0.0 | 558.0 | INR | 0.0 | 0.1 | 0.0 | 4 | 14079 | 2026-04-01 21:29:53 | 0 | NULL | 1 | 2026-04-01 22:03:27 | 12517 | 1 | 2026-04-01 22:03:27 | ||
| 1059 | 1069 | POFN-2059 | INVFN-2059 | 12521 | 12517 | 2 | 1 | 11 | 3659.0 | 0.0 | 66.51 | 166.7 | 166.7 | 0.0 | 3659.0 | INR | 0.0 | 0.04 | 0.0 | 4 | 12521 | 2026-04-03 16:14:54 | 0 | NULL | 1 | 2026-04-03 16:17:00 | 12517 | 1 | 2026-04-03 16:17:00 | ||
| 1060 | 1070 | POFN-2060 | INVFN-2060 | 12526 | 12517 | 2 | 1 | 100 | 14268.0 | 0.0 | 261.46 | 597.51 | 597.51 | 0.0 | 14268.0 | INR | 0.0 | 0.06 | 0.0 | 4 | 12526 | 2026-04-03 20:56:09 | 0 | NULL | 1 | 2026-04-03 21:05:17 | 12517 | 1 | 2026-04-03 21:05:17 | ||
| 1061 | 1071 | POFN-2061 | INVFN-2061 | 12528 | 12517 | 2 | 1 | 263 | 14961.0 | 0.0 | 283.79 | 385.65 | 385.65 | 0.0 | 14961.0 | INR | 0.0 | 0.02 | 0.0 | 4 | 12528 | 2026-04-04 13:46:00 | 0 | NULL | 1 | 2026-04-06 10:46:38 | 12517 | 1 | 2026-04-06 10:46:38 | ||
| 1062 | 1072 | POFN-2062 | INVFN-2062 | 13438 | 12517 | 2 | 1 | 1 | 159.0 | 0.0 | 2.69 | 12.13 | 12.13 | 0.0 | 159.0 | INR | 0.0 | 0.01 | 0.0 | 4 | 13438 | 2026-04-07 22:44:23 | 0 | NULL | 1 | 2026-04-07 22:44:45 | 12517 | 1 | 2026-04-07 22:44:45 | ||
| 1063 | 1073 | POFN-2063 | INVFN-2063 | 12545 | 12517 | 2 | 1 | 124 | 7534.0 | 0.0 | 140.19 | 262.38 | 262.38 | 0.0 | 7534.0 | INR | 0.0 | 0.05 | 0.0 | 4 | 12545 | 2026-04-08 12:23:36 | 0 | NULL | 1 | 2026-04-08 12:53:41 | 12517 | 1 | 2026-04-08 12:53:41 | ||
| 1064 | 1074 | POFN-2064 | INVFN-2064 | 12545 | 12517 | 2 | 1 | 3 | 144.0 | 0.0 | 2.74 | 3.43 | 3.43 | 0.0 | 144.0 | INR | 0.0 | 0.02 | 0.0 | 4 | 12545 | 2026-04-08 12:24:26 | 0 | NULL | 1 | 2026-04-08 12:53:41 | 12517 | 1 | 2026-04-08 12:53:41 | ||
| 1065 | 1075 | POFN-2065 | INVFN-2065 | 12516 | 1 | 2 | 1 | 20 | 100000.0 | 0.0 | 7766.99 | 1456.31 | 1456.31 | 0.0 | 100000.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12516 | 2026-04-08 16:47:53 | 0 | NULL | 1 | 2026-04-08 16:48:34 | 1 | 1 | 2026-04-08 16:48:34 | ||
| 1066 | 1076 | POFN-2066 | INVFN-2066 | 12554 | 12516 | 2 | 1 | 20 | 100000.0 | 0.0 | 5825.24 | 1456.31 | 1456.31 | 0.0 | 100000.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12554 | 2026-04-08 16:51:21 | 0 | NULL | 1 | 2026-04-08 16:56:52 | 12516 | 1 | 2026-04-08 16:56:52 | ||
| 1067 | 1077 | POFN-2067 | INVFN-2067 | 12554 | 12516 | 2 | 1 | 20 | 100000.0 | 0.0 | 5825.24 | 1456.31 | 1456.31 | 0.0 | 100000.0 | INR | 0.0 | 20.0 | 0.0 | 4 | 12554 | 2026-04-08 16:55:57 | 0 | NULL | 2 | 2026-04-08 16:56:58 | 12516 | 0 | NULL | ||
| 1068 | 1078 | POFN-2068 | INVFN-2068 | 12545 | 12517 | 2 | 1 | 55 | 2640.0 | 0.0 | 50.29 | 62.86 | 62.86 | 0.0 | 2640.0 | INR | 0.0 | 0.33 | 0.0 | 4 | 12545 | 2026-04-10 09:52:53 | 0 | NULL | 1 | 2026-04-10 12:50:32 | 12517 | 1 | 2026-04-10 12:50:32 | ||
| 1069 | 1079 | POFN-2069 | INVFN-2069 | 12542 | 12517 | 2 | 1 | 3 | 846.0 | 0.0 | 16.11 | 20.14 | 20.14 | 0.0 | 846.0 | INR | 0.0 | 0.1 | 0.0 | 4 | 12542 | 2026-04-10 09:59:45 | 0 | NULL | 1 | 2026-04-10 12:50:39 | 12517 | 1 | 2026-04-10 12:50:39 | ||
| 1070 | 1080 | POFN-2070 | INVFN-2070 | 12526 | 12517 | 2 | 1 | 6 | 4827.0 | 0.0 | 87.52 | 225.52 | 225.52 | 0.0 | 4827.0 | INR | 0.0 | 0.1 | 0.0 | 4 | 12526 | 2026-04-10 20:48:50 | 0 | NULL | 1 | 2026-04-10 21:05:51 | 12517 | 1 | 2026-04-10 21:05:51 | ||
| 1071 | 1081 | POFN-2071 | INVFN-2071 | 12545 | 12517 | 2 | 1 | 56 | 5039.0 | 0.0 | 95.98 | 119.98 | 119.98 | 0.0 | 5039.0 | INR | 0.0 | 0.18 | 0.0 | 4 | 12545 | 2026-04-11 17:22:51 | 0 | NULL | 1 | 2026-04-11 17:25:02 | 12517 | 1 | 2026-04-11 17:25:02 | ||
| 1072 | 1082 | POFN-2072 | INVFN-2072 | 12548 | 12517 | 2 | 1 | 31 | 1612.0 | 0.0 | 30.7 | 38.38 | 38.38 | 0.0 | 1612.0 | INR | 620.0 | 620.19 | 620.0 | 4 | 12548 | 2026-04-13 22:58:25 | 0 | NULL | 1 | 2026-04-16 17:15:49 | 12517 | 1 | 2026-04-16 17:15:50 | ||
| 1073 | 1083 | POFN-2073 | INVFN-2073 | 12516 | 1 | 2 | 1 | 37 | 395900.0 | 0.0 | 30163.81 | 9426.19 | 9426.19 | 0.0 | 395900.0 | INR | 197950.0 | 198024.0 | 197950.0 | 4 | 12516 | 2026-04-14 11:43:44 | 0 | NULL | 1 | 2026-04-14 11:43:53 | 1 | 1 | 2026-04-14 11:43:53 | ||
| 1074 | 1084 | POFN-2074 | INVFN-2074 | 12517 | 12516 | 2 | 1 | 50 | 10000.0 | 0.0 | 508.47 | 0.0 | 0.0 | 1525.42 | 10000.0 | INR | 5000.0 | 5001.25 | 5000.0 | 4 | 12517 | 2026-04-16 16:49:00 | 0 | NULL | 1 | 2026-04-16 16:49:37 | 12516 | 1 | 2026-04-16 16:49:37 | ||
| 1075 | 1085 | POFN-2075 | INVFN-2075 | 12546 | 12517 | 2 | 1 | 74 | 21900.0 | 0.0 | 411.35 | 666.22 | 666.22 | 0.0 | 21900.0 | INR | 10275.0 | 10276.75 | 10275.0 | 4 | 12546 | 2026-04-16 18:27:52 | 0 | NULL | 1 | 2026-04-16 18:33:03 | 12517 | 1 | 2026-04-16 18:33:04 | ||
| 1076 | 1086 | POFN-2076 | INVFN-2076 | 14902 | 12517 | 2 | 1 | 93 | 16171.0 | 0.0 | 303.61 | 495.36 | 495.36 | 0.0 | 16171.0 | INR | 7399.0 | 7399.25 | 7399.0 | 4 | 14902 | 2026-04-17 14:32:34 | 0 | NULL | 1 | 2026-04-17 14:35:26 | 12517 | 1 | 2026-04-17 14:35:26 | ||
| 1077 | 1087 | POFN-2077 | INVFN-2077 | 12517 | 12516 | 2 | 1 | 10 | 107000.0 | 0.0 | 6114.29 | 0.0 | 0.0 | 5095.24 | 107000.0 | INR | 53500.0 | 53520.0 | 53500.0 | 4 | 12517 | 2026-04-18 15:47:56 | 0 | NULL | 1 | 2026-04-18 15:48:07 | 12516 | 1 | 2026-04-18 15:48:07 | ||
| 1078 | 1088 | POFN-2078 | INVFN-2078 | 12516 | 1 | 2 | 1 | 50 | 125000.0 | 0.0 | 9708.74 | 1820.39 | 1820.39 | 0.0 | 125000.0 | INR | 62500.0 | 62525.0 | 62500.0 | 4 | 12516 | 2026-04-18 17:22:29 | 0 | NULL | 1 | 2026-04-18 17:22:41 | 1 | 1 | 2026-04-18 17:22:41 | ||
| 1079 | 1089 | POFN-2079 | INVFN-2079 | 12554 | 12516 | 2 | 1 | 20 | 50000.0 | 0.0 | 2912.62 | 728.16 | 728.16 | 0.0 | 50000.0 | INR | 25000.0 | 25010.0 | 25000.0 | 4 | 12554 | 2026-04-18 17:24:01 | 0 | NULL | 1 | 2026-04-18 17:24:19 | 12516 | 1 | 2026-04-18 17:24:19 | ||
| 1080 | 1090 | POFN-2080 | INVFN-2080 | 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-04-18 17:24:42 | 0 | NULL | 1 | 2026-04-18 17:24:53 | 12554 | 1 | 2026-04-18 17:24:53 | ||
| 1081 | 1091 | POFN-2081 | INVFN-2081 | 12554 | 12516 | 2 | 1 | 15 | 24000.0 | 0.0 | 1371.43 | 571.43 | 571.43 | 0.0 | 24000.0 | INR | 12000.0 | 12003.75 | 12000.0 | 4 | 12554 | 2026-04-18 18:20:00 | 0 | NULL | 1 | 2026-04-18 18:20:11 | 12516 | 1 | 2026-04-18 18:20:11 | ||
| 1082 | 1092 | POFN-2082 | INVFN-2082 | 12555 | 12554 | 2 | 1 | 10 | 16000.0 | 0.0 | 304.76 | 380.95 | 380.95 | 0.0 | 16000.0 | INR | 8000.0 | 8002.5 | 8000.0 | 4 | 12555 | 2026-04-18 18:21:42 | 0 | NULL | 1 | 2026-04-18 18:21:57 | 12554 | 1 | 2026-04-18 18:21:57 | ||
| 1083 | 1093 | POFN-2083 | INVFN-2083 | 12555 | 12554 | 2 | 1 | 5 | 3750.0 | 0.0 | 71.43 | 89.29 | 89.29 | 0.0 | 3750.0 | INR | 1875.0 | 1875.5 | 1875.0 | 4 | 12555 | 2026-04-18 18:27:23 | 0 | NULL | 1 | 2026-04-18 18:28:02 | 12554 | 1 | 2026-04-18 18:28:02 | ||
| 1084 | 1095 | POFN-2084 | INVFN-2084 | 12526 | 12517 | 2 | 1 | 46 | 13184.0 | 0.0 | 229.75 | 848.17 | 848.17 | 0.0 | 13184.0 | INR | 5868.0 | 5868.6 | 5868.0 | 4 | 12526 | 2026-04-20 13:57:13 | 0 | NULL | 1 | 2026-04-20 14:09:02 | 12517 | 1 | 2026-04-20 14:09:02 | ||
| 1085 | 1096 | POFN-2085 | INVFN-2085 | 12555 | 12554 | 2 | 1 | 4 | 10000.0 | 0.0 | 194.17 | 145.63 | 145.63 | 0.0 | 10000.0 | INR | 5000.0 | 5002.0 | 5000.0 | 4 | 12555 | 2026-04-20 19:40:03 | 0 | NULL | 1 | 2026-04-20 19:40:49 | 12554 | 1 | 2026-04-20 19:40:49 | ||
| 1086 | 1097 | POFN-2086 | INVFN-2086 | 12555 | 12554 | 2 | 1 | 4 | 10000.0 | 0.0 | 194.17 | 145.63 | 145.63 | 0.0 | 10000.0 | INR | 5000.0 | 5002.0 | 5000.0 | 4 | 12555 | 2026-04-20 22:37:30 | 0 | NULL | 1 | 2026-04-20 22:39:42 | 12554 | 1 | 2026-04-20 22:39:42 | ||
| 1087 | 1098 | POFN-2087 | INVFN-2087 | 12555 | 12554 | 2 | 1 | 2 | 5000.0 | 0.0 | 97.09 | 72.82 | 72.82 | 0.0 | 5000.0 | INR | 2500.0 | 2501.0 | 2500.0 | 4 | 12555 | 2026-04-20 22:55:05 | 0 | NULL | 1 | 2026-04-20 23:05:42 | 12554 | 1 | 2026-04-20 23:05:42 | ||
| 1088 | 1099 | POFN-2088 | INVFN-2088 | 12516 | 1 | 2 | 1 | 20 | 50000.0 | 0.0 | 3883.5 | 728.16 | 728.16 | 0.0 | 50000.0 | INR | 25000.0 | 25010.0 | 25000.0 | 4 | 12516 | 2026-04-20 23:01:59 | 0 | NULL | 1 | 2026-04-20 23:02:54 | 1 | 1 | 2026-04-20 23:02:54 | ||
| 1089 | 1100 | POFN-2089 | INVFN-2089 | 12554 | 12516 | 2 | 1 | 10 | 25000.0 | 0.0 | 1456.31 | 364.08 | 364.08 | 0.0 | 25000.0 | INR | 12500.0 | 12505.0 | 12500.0 | 4 | 12554 | 2026-04-20 23:07:34 | 0 | NULL | 1 | 2026-04-20 23:08:30 | 12516 | 1 | 2026-04-20 23:08:30 | ||
| 1090 | 1101 | POFN-2090 | INVFN-2090 | 12534 | 12517 | 2 | 1 | 2 | 2880.0 | 0.0 | 54.86 | 68.57 | 68.57 | 0.0 | 2880.0 | INR | 1440.0 | 1440.4 | 1440.0 | 4 | 12534 | 2026-04-22 18:46:06 | 0 | NULL | 1 | 2026-04-22 20:06:04 | 12517 | 1 | 2026-04-22 20:06:04 | ||
| 1091 | 1102 | POFN-2091 | INVFN-2091 | 12526 | 12517 | 2 | 1 | 8 | 416.0 | 0.0 | 7.92 | 9.9 | 9.9 | 0.0 | 416.0 | INR | 160.0 | 160.05 | 160.0 | 4 | 12526 | 2026-04-22 19:06:56 | 0 | NULL | 1 | 2026-04-22 20:06:04 | 12517 | 1 | 2026-04-22 20:06:04 | ||
| 1092 | 1103 | POFN-2092 | INVFN-2092 | 12545 | 12517 | 2 | 1 | 40 | 8721.0 | 0.0 | 158.52 | 397.61 | 397.61 | 0.0 | 8721.0 | INR | 3735.0 | 3735.25 | 3735.0 | 4 | 12545 | 2026-04-23 14:35:45 | 0 | NULL | 1 | 2026-04-23 18:51:23 | 12517 | 1 | 2026-04-23 18:51:23 | ||
| 1093 | 1104 | POFN-2093 | INVFN-2093 | 12516 | 1 | 2 | 1 | 5 | 53500.0 | 0.0 | 4076.19 | 1273.81 | 1273.81 | 0.0 | 53500.0 | INR | 26750.0 | 26760.0 | 26750.0 | 4 | 12516 | 2026-04-24 15:23:28 | 0 | NULL | 1 | 2026-04-24 15:24:10 | 1 | 1 | 2026-04-24 15:24:10 | ||
| 1094 | 1105 | POFN-2094 | INVFN-2094 | 12554 | 12516 | 2 | 1 | 5 | 53500.0 | 0.0 | 3057.14 | 1273.81 | 1273.81 | 0.0 | 53500.0 | INR | 26750.0 | 26760.0 | 26750.0 | 4 | 12554 | 2026-04-24 15:27:44 | 0 | NULL | 1 | 2026-04-24 15:29:35 | 12516 | 1 | 2026-04-24 15:29:35 | ||
| 1095 | 1106 | POFN-2095 | INVFN-2095 | 12555 | 12554 | 2 | 1 | 3 | 32100.0 | 0.0 | 611.43 | 764.29 | 764.29 | 0.0 | 32100.0 | INR | 16050.0 | 16056.0 | 16050.0 | 4 | 12555 | 2026-04-24 15:30:32 | 0 | NULL | 1 | 2026-04-24 15:31:08 | 12554 | 1 | 2026-04-24 15:31:08 | ||
| 1096 | 1107 | POFN-2096 | INVFN-2096 | 12554 | 12516 | 2 | 1 | 5 | 8250.0 | 0.0 | 471.43 | 196.43 | 196.43 | 0.0 | 8250.0 | INR | 4000.0 | 4001.25 | 4000.0 | 4 | 12554 | 2026-04-24 15:32:24 | 0 | NULL | 1 | 2026-04-24 15:32:49 | 12516 | 1 | 2026-04-24 15:32:49 | ||
| 1097 | 1108 | POFN-2097 | INVFN-2097 | 12555 | 12554 | 2 | 1 | 5 | 8250.0 | 0.0 | 157.14 | 196.43 | 196.43 | 0.0 | 8250.0 | INR | 4000.0 | 4001.25 | 4000.0 | 4 | 12555 | 2026-04-24 15:34:12 | 0 | NULL | 1 | 2026-04-24 15:34:43 | 12554 | 1 | 2026-04-24 15:34:43 | ||
| 1098 | 1109 | POFN-2098 | INVFN-2098 | 12516 | 1 | 2 | 1 | 10 | 200000.0 | 0.0 | 14678.9 | 8256.88 | 8256.88 | 0.0 | 200000.0 | INR | 10000.0 | 10010.0 | 10000.0 | 4 | 12516 | 2026-04-24 19:47:26 | 0 | NULL | 1 | 2026-04-24 19:48:03 | 1 | 1 | 2026-04-24 19:48:03 | ||
| 1099 | 1110 | POFN-2099 | INVFN-2099 | 12554 | 12516 | 2 | 1 | 10 | 200000.0 | 0.0 | 11009.17 | 8256.88 | 8256.88 | 0.0 | 200000.0 | INR | 10000.0 | 10010.0 | 10000.0 | 4 | 12554 | 2026-04-24 19:49:37 | 0 | NULL | 1 | 2026-04-24 19:50:19 | 12516 | 1 | 2026-04-24 19:50:19 | ||
| 1100 | 1111 | POFN-2100 | INVFN-2100 | 12555 | 12554 | 2 | 1 | 10 | 200000.0 | 0.0 | 3669.72 | 8256.88 | 8256.88 | 0.0 | 200000.0 | INR | 10000.0 | 10010.0 | 10000.0 | 4 | 12555 | 2026-04-24 19:54:20 | 0 | NULL | 1 | 2026-04-27 16:25:03 | 12554 | 1 | 2026-04-27 16:25:03 |