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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1101 | 1112 | POFN-2101 | INVFN-2101 | 12526 | 12517 | 2 | 1 | 34 | 7869.0 | 0.0 | 146.53 | 271.3 | 271.3 | 0.0 | 7869.0 | INR | 3810.0 | 3810.5 | 3810.0 | 4 | 12526 | 2026-04-24 22:11:22 | 0 | NULL | 1 | 2026-04-24 22:14:23 | 12517 | 1 | 2026-04-24 22:14:23 | ||
| 1102 | 1113 | POFN-2102 | INVFN-2102 | 12545 | 12517 | 2 | 1 | 4 | 4800.0 | 0.0 | 91.43 | 114.29 | 114.29 | 0.0 | 4800.0 | INR | 2400.0 | 2400.5 | 2400.0 | 4 | 12545 | 2026-04-27 08:50:05 | 0 | NULL | 1 | 2026-04-27 16:24:29 | 12517 | 1 | 2026-04-27 16:24:29 | ||
| 1103 | 1114 | POFN-2103 | INVFN-2103 | 12532 | 12517 | 2 | 1 | 12 | 13490.0 | 0.0 | 256.95 | 321.19 | 321.19 | 0.0 | 13490.0 | INR | 6745.0 | 6745.75 | 6745.0 | 4 | 12532 | 2026-04-27 19:51:57 | 0 | NULL | 1 | 2026-04-28 14:33:10 | 12517 | 1 | 2026-04-28 14:33:10 | ||
| 1104 | 1115 | POFN-2104 | INVFN-2104 | 12539 | 12517 | 2 | 1 | 1 | 1600.0 | 0.0 | 30.48 | 38.1 | 38.1 | 0.0 | 1600.0 | INR | 800.0 | 800.25 | 800.0 | 4 | 12539 | 2026-04-28 15:41:58 | 0 | NULL | 1 | 2026-04-28 16:39:24 | 12517 | 1 | 2026-04-28 16:39:24 | ||
| 1105 | 1116 | POFN-2105 | INVFN-2105 | 12545 | 12517 | 2 | 1 | 1 | 18500.0 | 0.0 | 352.38 | 440.48 | 440.48 | 0.0 | 18500.0 | INR | 9250.0 | 9253.75 | 9250.0 | 4 | 12545 | 2026-04-28 15:48:13 | 0 | NULL | 2 | 2026-04-28 16:39:35 | 12517 | 0 | NULL | ||
| 1106 | 1117 | POFN-2106 | INVFN-2106 | 12545 | 12517 | 2 | 1 | 3 | 3120.0 | 0.0 | 59.43 | 74.29 | 74.29 | 0.0 | 3120.0 | INR | 1560.0 | 1560.25 | 1560.0 | 4 | 12545 | 2026-04-28 15:49:15 | 0 | NULL | 1 | 2026-04-28 16:39:25 | 12517 | 1 | 2026-04-28 16:39:25 | ||
| 1107 | 1118 | POFN-2107 | INVFN-2107 | 12516 | 1 | 2 | 1 | 101 | 20604.0 | 0.0 | 1569.83 | 490.57 | 490.57 | 0.0 | 20604.0 | INR | 10302.0 | 10306.04 | 10302.0 | 4 | 12516 | 2026-04-28 16:01:08 | 0 | NULL | 1 | 2026-04-28 16:03:05 | 1 | 1 | 2026-04-28 16:03:05 | ||
| 1108 | 1119 | POFN-2108 | INVFN-2108 | 12516 | 1 | 2 | 1 | 100 | 20400.0 | 0.0 | 1554.29 | 485.71 | 485.71 | 0.0 | 20400.0 | INR | 10200.0 | 10204.0 | 10200.0 | 4 | 12516 | 2026-04-28 16:04:14 | 0 | NULL | 1 | 2026-04-30 16:46:48 | 1 | 1 | 2026-04-30 16:46:48 | ||
| 1109 | 1120 | POFN-2109 | INVFN-2109 | 12517 | 12516 | 2 | 1 | 100 | 20400.0 | 0.0 | 1165.71 | 0.0 | 0.0 | 971.43 | 20400.0 | INR | 10200.0 | 10204.0 | 10200.0 | 4 | 12517 | 2026-04-28 16:07:51 | 0 | NULL | 1 | 2026-04-28 16:08:14 | 12516 | 1 | 2026-04-28 16:08:14 | ||
| 1110 | 1121 | POFN-2110 | INVFN-2110 | 12539 | 12517 | 2 | 1 | 3 | 3404.0 | 0.0 | 64.84 | 81.05 | 81.05 | 0.0 | 3404.0 | INR | 1702.0 | 1702.04 | 1702.0 | 4 | 12539 | 2026-04-28 16:11:34 | 0 | NULL | 1 | 2026-04-28 16:35:46 | 12517 | 1 | 2026-04-28 16:35:46 | ||
| 1111 | 1122 | POFN-2111 | INVFN-2111 | 12539 | 12517 | 2 | 1 | 6 | 2220.0 | 0.0 | 42.29 | 52.86 | 52.86 | 0.0 | 2220.0 | INR | 1110.0 | 1110.2 | 1110.0 | 4 | 12539 | 2026-04-28 17:29:13 | 0 | NULL | 1 | 2026-04-28 17:32:53 | 12517 | 1 | 2026-04-28 17:32:53 | ||
| 1112 | 1123 | POFN-2112 | INVFN-2112 | 12526 | 12517 | 2 | 1 | 40 | 35039.0 | 0.0 | 624.91 | 1896.66 | 1896.66 | 0.0 | 35039.0 | INR | 17921.0 | 17921.06 | 17921.0 | 4 | 12526 | 2026-04-28 20:45:38 | 0 | NULL | 1 | 2026-04-28 21:18:05 | 12517 | 1 | 2026-04-28 21:18:05 | ||
| 1113 | 1124 | POFN-2113 | INVFN-2113 | 12523 | 12517 | 2 | 1 | 148 | 25138.0 | 0.0 | 461.17 | 1039.73 | 1039.73 | 0.0 | 25138.0 | INR | 11583.0 | 11583.36 | 11583.0 | 4 | 12523 | 2026-04-29 15:31:48 | 0 | NULL | 1 | 2026-04-29 16:34:20 | 12517 | 1 | 2026-04-29 16:34:20 | ||
| 1114 | 1125 | POFN-2114 | INVFN-2114 | 12545 | 12517 | 2 | 1 | 38 | 7588.0 | 0.0 | 137.93 | 345.66 | 345.66 | 0.0 | 7588.0 | INR | 3395.0 | 3395.38 | 3395.0 | 4 | 12545 | 2026-04-29 15:44:54 | 0 | NULL | 2 | 2026-04-29 16:19:58 | 12517 | 0 | NULL | ||
| 1115 | 1126 | POFN-2115 | INVFN-2115 | 12545 | 12517 | 2 | 1 | 38 | 7588.0 | 0.0 | 137.93 | 345.66 | 345.66 | 0.0 | 7588.0 | INR | 3395.0 | 3395.38 | 3395.0 | 4 | 12545 | 2026-04-29 15:44:54 | 0 | NULL | 1 | 2026-04-29 16:34:20 | 12517 | 1 | 2026-04-29 16:34:20 | ||
| 1116 | 1127 | POFN-2116 | INVFN-2116 | 12545 | 12517 | 2 | 1 | 95 | 4940.0 | 0.0 | 94.1 | 117.62 | 117.62 | 0.0 | 4940.0 | INR | 1900.0 | 1900.57 | 1900.0 | 4 | 12545 | 2026-04-29 16:23:26 | 0 | NULL | 1 | 2026-04-29 16:34:20 | 12517 | 1 | 2026-04-29 16:34:20 | ||
| 1117 | 1128 | POFN-2117 | INVFN-2117 | 12526 | 12517 | 2 | 1 | 51 | 21492.0 | 0.0 | 405.36 | 612.07 | 612.07 | 0.0 | 21492.0 | INR | 10517.0 | 10517.22 | 10517.0 | 4 | 12526 | 2026-04-29 23:10:31 | 0 | NULL | 1 | 2026-04-30 00:16:41 | 12517 | 1 | 2026-04-30 00:16:41 | ||
| 1118 | 1129 | POFN-2118 | INVFN-2118 | 12545 | 12517 | 2 | 1 | 8 | 3969.0 | 0.0 | 75.6 | 94.5 | 94.5 | 0.0 | 3969.0 | INR | 1934.0 | 1934.15 | 1934.0 | 4 | 12545 | 2026-04-30 05:47:14 | 0 | NULL | 1 | 2026-04-30 09:38:23 | 12517 | 1 | 2026-04-30 09:38:23 | ||
| 1119 | 1130 | POFN-2119 | INVFN-2119 | 12545 | 12517 | 2 | 1 | 3 | 1362.0 | 0.0 | 24.6 | 66.11 | 66.11 | 0.0 | 1362.0 | INR | 584.0 | 584.04 | 584.0 | 4 | 12545 | 2026-04-30 09:06:55 | 0 | NULL | 1 | 2026-04-30 09:38:23 | 12517 | 1 | 2026-04-30 09:38:23 | ||
| 1120 | 1131 | POFN-2120 | INVFN-2120 | 12552 | 12517 | 2 | 1 | 6 | 6719.0 | 0.0 | 127.98 | 159.98 | 159.98 | 0.0 | 6719.0 | INR | 3359.0 | 3359.15 | 3359.0 | 4 | 12552 | 2026-04-30 09:29:27 | 0 | NULL | 1 | 2026-04-30 09:38:23 | 12517 | 1 | 2026-04-30 09:38:23 | ||
| 1121 | 1132 | POFN-2121 | INVFN-2121 | 12545 | 12517 | 2 | 1 | 4 | 2560.0 | 0.0 | 46.75 | 111.32 | 111.32 | 0.0 | 2560.0 | INR | 1280.0 | 1280.15 | 1280.0 | 4 | 12545 | 2026-04-30 09:52:30 | 0 | NULL | 1 | 2026-04-30 11:41:29 | 12517 | 1 | 2026-04-30 11:41:29 | ||
| 1122 | 1133 | POFN-2122 | INVFN-2122 | 12545 | 12517 | 2 | 1 | 1 | 720.0 | 0.0 | 13.71 | 17.14 | 17.14 | 0.0 | 720.0 | INR | 0.0 | 0.15 | 0.0 | 4 | 12545 | 2026-04-30 09:59:04 | 0 | NULL | 1 | 2026-04-30 11:41:24 | 12517 | 1 | 2026-04-30 11:41:24 | ||
| 1123 | 1134 | POFN-2123 | INVFN-2123 | 12545 | 12517 | 2 | 1 | 1 | 400.0 | 0.0 | 7.62 | 9.52 | 9.52 | 0.0 | 400.0 | INR | 200.0 | 200.03 | 200.0 | 4 | 12545 | 2026-04-30 10:17:31 | 0 | NULL | 1 | 2026-04-30 11:41:17 | 12517 | 1 | 2026-04-30 11:41:17 | ||
| 1124 | 1135 | POFN-2124 | INVFN-2124 | 12545 | 12517 | 2 | 1 | 2 | 1440.0 | 0.0 | 27.43 | 34.29 | 34.29 | 0.0 | 1440.0 | INR | 720.0 | 720.3 | 720.0 | 4 | 12545 | 2026-04-30 12:51:54 | 0 | NULL | 1 | 2026-04-30 14:43:55 | 12517 | 1 | 2026-04-30 14:43:55 | ||
| 1125 | 1136 | POFN-2125 | INVFN-2125 | 12527 | 12517 | 2 | 1 | 44 | 11098.0 | 0.0 | 204.72 | 431.07 | 431.07 | 0.0 | 11098.0 | INR | 5058.0 | 5058.5 | 5058.0 | 4 | 12527 | 2026-04-30 14:26:25 | 0 | NULL | 1 | 2026-04-30 14:43:55 | 12517 | 1 | 2026-04-30 14:43:55 | ||
| 1126 | 1137 | POFN-2126 | INVFN-2126 | 12545 | 12517 | 2 | 1 | 32 | 7440.0 | 0.0 | 129.12 | 491.91 | 491.91 | 0.0 | 7440.0 | INR | 2810.0 | 2810.25 | 2810.0 | 4 | 12545 | 2026-04-30 16:42:02 | 0 | NULL | 1 | 2026-04-30 17:42:19 | 12517 | 1 | 2026-04-30 17:42:19 | ||
| 1127 | 1138 | POFN-2127 | INVFN-2127 | 12545 | 12517 | 2 | 1 | 1 | 1200.0 | 0.0 | 22.86 | 28.57 | 28.57 | 0.0 | 1200.0 | INR | 600.0 | 600.2 | 600.0 | 4 | 12545 | 2026-04-30 19:49:47 | 0 | NULL | 1 | 2026-04-30 21:19:17 | 12517 | 1 | 2026-04-30 21:19:17 | ||
| 1128 | 1139 | POFN-2128 | INVFN-2128 | 12552 | 12517 | 2 | 1 | 4 | 3900.0 | 0.0 | 74.29 | 92.86 | 92.86 | 0.0 | 3900.0 | INR | 1950.0 | 1950.2 | 1950.0 | 4 | 12552 | 2026-04-30 21:40:36 | 0 | NULL | 1 | 2026-04-30 21:59:29 | 12517 | 1 | 2026-04-30 21:59:29 | ||
| 1129 | 1140 | POFN-2129 | INVFN-2129 | 12545 | 12517 | 2 | 1 | 1 | 719.0 | 0.0 | 13.7 | 17.12 | 17.12 | 0.0 | 719.0 | INR | 359.0 | 359.15 | 359.0 | 4 | 12545 | 2026-04-30 22:59:05 | 0 | NULL | 1 | 2026-05-01 11:25:07 | 12517 | 1 | 2026-05-01 11:25:07 | ||
| 1130 | 1141 | POFN-2130 | INVFN-2130 | 12552 | 12517 | 2 | 1 | 10 | 800.0 | 0.0 | 15.24 | 19.05 | 19.05 | 0.0 | 800.0 | INR | 350.0 | 350.09 | 350.0 | 4 | 12552 | 2026-05-02 11:18:11 | 0 | NULL | 1 | 2026-05-02 11:20:51 | 12517 | 1 | 2026-05-02 11:20:51 | ||
| 1131 | 1142 | POFN-2131 | INVFN-2131 | 12555 | 12554 | 2 | 1 | 5 | 3995.0 | 0.0 | 67.71 | 304.7 | 304.7 | 0.0 | 3995.0 | INR | 1995.0 | 1995.75 | 1995.0 | 4 | 12555 | 2026-05-03 14:00:00 | 0 | NULL | 1 | 2026-05-03 14:01:42 | 12554 | 1 | 2026-05-03 14:01:42 | ||
| 1132 | 1143 | POFN-2132 | INVFN-2132 | 14569 | 12517 | 2 | 1 | 12 | 3200.0 | 0.0 | 60.95 | 76.19 | 76.19 | 0.0 | 3200.0 | INR | 1550.0 | 1550.25 | 1550.0 | 4 | 14569 | 2026-05-03 23:44:54 | 0 | NULL | 1 | 2026-05-04 18:22:44 | 12517 | 1 | 2026-05-04 18:22:44 | ||
| 1133 | 1144 | POFN-2133 | INVFN-2133 | 12516 | 1 | 2 | 1 | 90 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 45.0 | 0.0 | 4 | 12516 | 2026-05-05 13:14:09 | 0 | NULL | 1 | 2026-05-05 13:14:42 | 1 | 1 | 2026-05-05 13:14:42 | ||
| 1134 | 1145 | POFN-2134 | INVFN-2134 | 12554 | 12516 | 2 | 1 | 90 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 45.0 | 0.0 | 4 | 12554 | 2026-05-05 13:15:16 | 0 | NULL | 1 | 2026-05-05 13:17:12 | 12516 | 1 | 2026-05-05 13:17:12 | ||
| 1135 | 1146 | POFN-2135 | INVFN-2135 | 12555 | 12554 | 2 | 1 | 90 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 45.0 | 0.0 | 4 | 12555 | 2026-05-05 13:20:06 | 0 | NULL | 1 | 2026-05-05 13:22:06 | 12554 | 1 | 2026-05-05 13:22:06 | ||
| 1136 | 1147 | POFN-2136 | INVFN-2136 | 12516 | 1 | 2 | 1 | 50 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 25.0 | 0.0 | 4 | 12516 | 2026-05-05 18:05:24 | 0 | NULL | 1 | 2026-05-05 18:06:17 | 1 | 1 | 2026-05-05 18:06:17 | ||
| 1137 | 1148 | POFN-2137 | INVFN-2137 | 12554 | 12516 | 2 | 1 | 50 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 25.0 | 0.0 | 4 | 12554 | 2026-05-05 18:06:48 | 0 | NULL | 2 | 2026-05-05 18:09:29 | 12516 | 0 | NULL | ||
| 1138 | 1149 | POFN-2138 | INVFN-2138 | 12554 | 12516 | 2 | 1 | 50 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 25.0 | 0.0 | 4 | 12554 | 2026-05-05 18:08:59 | 0 | NULL | 1 | 2026-05-05 18:09:26 | 12516 | 1 | 2026-05-05 18:09:26 | ||
| 1139 | 1150 | POFN-2139 | INVFN-2139 | 12555 | 12554 | 2 | 1 | 45 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 22.5 | 0.0 | 4 | 12555 | 2026-05-05 18:14:21 | 0 | NULL | 1 | 2026-05-05 18:15:29 | 12554 | 1 | 2026-05-05 18:15:29 | ||
| 1140 | 1151 | POFN-2140 | INVFN-2140 | 12526 | 12517 | 2 | 1 | 26 | 10857.0 | 0.0 | 198.58 | 463.99 | 463.99 | 0.0 | 10857.0 | INR | 5377.0 | 5377.4 | 5377.0 | 4 | 12526 | 2026-05-06 22:19:06 | 0 | NULL | 1 | 2026-05-07 15:42:41 | 12517 | 1 | 2026-05-07 15:42:41 | ||
| 1141 | 1152 | POFN-2141 | INVFN-2141 | 12516 | 1 | 2 | 1 | 100 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12516 | 2026-05-07 12:07:24 | 0 | NULL | 1 | 2026-05-07 12:07:36 | 1 | 1 | 2026-05-07 12:07:36 | ||
| 1142 | 1153 | POFN-2142 | INVFN-2142 | 12554 | 12516 | 2 | 1 | 100 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 50.0 | 0.0 | 4 | 12554 | 2026-05-07 12:09:00 | 0 | NULL | 1 | 2026-05-07 12:14:28 | 12516 | 1 | 2026-05-07 12:14:28 | ||
| 1143 | 1154 | POFN-2143 | INVFN-2143 | 12555 | 12554 | 2 | 1 | 99 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 49.5 | 0.0 | 4 | 12555 | 2026-05-07 12:13:34 | 0 | NULL | 1 | 2026-05-07 12:15:46 | 12554 | 1 | 2026-05-07 12:15:46 | ||
| 1144 | 1155 | POFN-2144 | INVFN-2144 | 12516 | 1 | 2 | 1 | 60 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 30.0 | 0.0 | 4 | 12516 | 2026-05-07 16:49:34 | 0 | NULL | 1 | 2026-05-07 16:50:03 | 1 | 1 | 2026-05-07 16:50:03 | ||
| 1145 | 1156 | POFN-2145 | INVFN-2145 | 12554 | 12516 | 2 | 1 | 60 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 30.0 | 0.0 | 4 | 12554 | 2026-05-07 16:51:35 | 0 | NULL | 1 | 2026-05-07 16:52:24 | 12516 | 1 | 2026-05-07 16:52:24 | ||
| 1146 | 1157 | POFN-2146 | INVFN-2146 | 12555 | 12554 | 2 | 1 | 60 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 30.0 | 0.0 | 4 | 12555 | 2026-05-07 16:53:27 | 0 | NULL | 1 | 2026-05-07 16:55:18 | 12554 | 1 | 2026-05-07 16:55:18 | ||
| 1147 | 1158 | POFN-2147 | INVFN-2147 | 12555 | 12554 | 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 | 12555 | 2026-05-07 19:40:42 | 0 | NULL | 1 | 2026-05-07 19:41:29 | 12554 | 1 | 2026-05-07 19:41:29 | ||
| 1148 | 1159 | POFN-2148 | INVFN-2148 | 12555 | 12554 | 2 | 1 | 5 | 8000.0 | 0.0 | 152.38 | 190.48 | 190.48 | 0.0 | 8000.0 | INR | 4000.0 | 4001.25 | 4000.0 | 4 | 12555 | 2026-05-07 21:55:42 | 0 | NULL | 1 | 2026-05-07 21:56:04 | 12554 | 1 | 2026-05-07 21:56:04 | ||
| 1149 | 1160 | POFN-2149 | INVFN-2149 | 12516 | 1 | 2 | 1 | 5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 2.5 | 0.0 | 4 | 12516 | 2026-05-07 23:21:54 | 0 | NULL | 1 | 2026-05-07 23:22:20 | 1 | 1 | 2026-05-07 23:22:20 | ||
| 1150 | 1161 | POFN-2150 | INVFN-2150 | 12554 | 12516 | 2 | 1 | 5 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | INR | 0.0 | 2.5 | 0.0 | 4 | 12554 | 2026-05-07 23:23:50 | 0 | NULL | 1 | 2026-05-07 23:24:32 | 12516 | 1 | 2026-05-07 23:24:32 |