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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 951 | 1172 | POFN-2161 | INVFN-2161 | 12555 | 12554 | 2 | 1 | 5 | 12500.0 | 0.0 | 242.72 | 182.04 | 182.04 | 0.0 | 12500.0 | INR | 6250.0 | 6252.5 | 6250.0 | 4 | 12555 | 2026-05-09 22:53:38 | 0 | NULL | 1 | 2026-05-09 22:54:12 | 12554 | 1 | 2026-05-09 22:54:12 | ||
| 952 | 1173 | POFN-2162 | INVFN-2162 | 12555 | 12554 | 2 | 1 | 5 | 6000.0 | 0.0 | 114.29 | 142.86 | 142.86 | 0.0 | 6000.0 | INR | 3000.0 | 3001.5 | 3000.0 | 4 | 12555 | 2026-05-10 13:31:22 | 0 | NULL | 1 | 2026-05-10 13:32:11 | 12554 | 1 | 2026-05-10 13:32:11 | ||
| 953 | 1174 | POFN-2163 | INVFN-2163 | 12555 | 12554 | 2 | 1 | 9 | 14850.0 | 0.0 | 282.86 | 353.57 | 353.57 | 0.0 | 14850.0 | INR | 7425.0 | 7427.7 | 7425.0 | 4 | 12555 | 2026-05-10 13:41:11 | 0 | NULL | 1 | 2026-05-10 13:42:43 | 12554 | 1 | 2026-05-10 13:42:43 | ||
| 954 | 1175 | POFN-2164 | INVFN-2164 | 14902 | 12517 | 2 | 1 | 51 | 12447.0 | 0.0 | 234.49 | 361.36 | 361.36 | 0.0 | 12447.0 | INR | 5843.0 | 5843.72 | 5843.0 | 4 | 14902 | 2026-05-10 21:09:55 | 0 | NULL | 1 | 2026-05-10 21:36:07 | 12517 | 1 | 2026-05-10 21:36:07 | ||
| 955 | 1176 | POFN-2165 | INVFN-2165 | 12545 | 12517 | 2 | 1 | 18 | 15419.0 | 0.0 | 281.1 | 681.89 | 681.89 | 0.0 | 15419.0 | INR | 7999.0 | 7999.75 | 7999.0 | 4 | 12545 | 2026-05-10 22:24:18 | 0 | NULL | 1 | 2026-05-11 11:05:59 | 12517 | 1 | 2026-05-11 11:05:59 | ||
| 956 | 1177 | POFN-2166 | INVFN-2166 | 12545 | 12517 | 2 | 1 | 21 | 5682.0 | 0.0 | 106.84 | 169.96 | 169.96 | 0.0 | 5682.0 | INR | 2763.0 | 2763.05 | 2763.0 | 4 | 12545 | 2026-05-11 19:34:07 | 0 | NULL | 1 | 2026-05-11 20:16:29 | 12517 | 1 | 2026-05-11 20:16:29 | ||
| 957 | 1178 | POFN-2167 | INVFN-2167 | 12539 | 12517 | 2 | 1 | 26 | 5821.0 | 0.0 | 107.54 | 222.01 | 222.01 | 0.0 | 5821.0 | INR | 2665.0 | 2665.25 | 2665.0 | 4 | 12539 | 2026-05-11 20:09:59 | 0 | NULL | 1 | 2026-05-11 20:16:29 | 12517 | 1 | 2026-05-11 20:16:29 | ||
| 958 | 1179 | POFN-2168 | INVFN-2168 | 12532 | 12517 | 2 | 1 | 275 | 52440.0 | 0.0 | 980.68 | 1702.99 | 1702.99 | 0.0 | 52440.0 | INR | 24398.0 | 24398.3 | 24398.0 | 4 | 12532 | 2026-05-11 20:16:31 | 0 | NULL | 1 | 2026-05-11 21:32:23 | 12517 | 1 | 2026-05-11 21:32:23 | ||
| 959 | 1180 | POFN-2169 | INVFN-2169 | 12532 | 12517 | 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 | 12532 | 2026-05-11 20:20:36 | 0 | NULL | 1 | 2026-05-11 20:40:05 | 12517 | 1 | 2026-05-11 20:40:05 | ||
| 960 | 1181 | POFN-2170 | INVFN-2170 | 12517 | 12516 | 2 | 1 | 14 | 2856.0 | 0.0 | 163.2 | 0.0 | 0.0 | 136.0 | 2856.0 | INR | 1428.0 | 1428.56 | 1428.0 | 4 | 12517 | 2026-05-11 21:30:30 | 0 | NULL | 1 | 2026-05-11 21:31:43 | 12516 | 1 | 2026-05-11 21:31:43 | ||
| 961 | 1182 | POFN-2171 | INVFN-2171 | 12526 | 12517 | 2 | 1 | 6 | 7850.0 | 0.0 | 149.52 | 186.9 | 186.9 | 0.0 | 7850.0 | INR | 3925.0 | 3925.3 | 3925.0 | 4 | 12526 | 2026-05-12 11:11:56 | 0 | NULL | 1 | 2026-05-12 11:53:58 | 12517 | 1 | 2026-05-12 11:53:58 | ||
| 962 | 1183 | POFN-2172 | INVFN-2172 | 12526 | 12517 | 2 | 1 | 54 | 7660.0 | 0.0 | 145.9 | 182.38 | 182.38 | 0.0 | 7660.0 | INR | 3580.0 | 3580.3 | 3580.0 | 4 | 12526 | 2026-05-12 11:16:00 | 0 | NULL | 1 | 2026-05-12 11:53:58 | 12517 | 1 | 2026-05-12 11:53:58 | ||
| 963 | 1184 | POFN-2173 | INVFN-2173 | 12532 | 12517 | 2 | 1 | 1 | 10700.0 | 0.0 | 203.81 | 254.76 | 254.76 | 0.0 | 10700.0 | INR | 5350.0 | 5352.0 | 5350.0 | 4 | 12532 | 2026-05-12 19:28:53 | 0 | NULL | 1 | 2026-05-12 21:02:15 | 12517 | 1 | 2026-05-12 21:02:15 | ||
| 964 | 1185 | POFN-2174 | INVFN-2174 | 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-05-13 17:01:51 | 0 | NULL | 1 | 2026-05-13 19:38:58 | 12517 | 1 | 2026-05-13 19:38:58 | ||
| 965 | 1186 | POFN-2175 | INVFN-2175 | 12523 | 12517 | 2 | 1 | 11 | 8070.0 | 0.0 | 150.57 | 270.84 | 270.84 | 0.0 | 8070.0 | INR | 4010.0 | 4010.2 | 4010.0 | 4 | 12523 | 2026-05-13 22:20:49 | 0 | NULL | 1 | 2026-05-14 11:19:29 | 12517 | 1 | 2026-05-14 11:19:29 | ||
| 966 | 1187 | POFN-2176 | INVFN-2176 | 12523 | 12517 | 2 | 1 | 6 | 2156.0 | 0.0 | 41.07 | 51.33 | 51.33 | 0.0 | 2156.0 | INR | 1036.0 | 1036.3 | 1036.0 | 4 | 12523 | 2026-05-14 13:20:15 | 0 | NULL | 1 | 2026-05-14 13:37:54 | 12517 | 1 | 2026-05-14 13:37:54 | ||
| 967 | 1188 | POFN-2177 | INVFN-2177 | 12545 | 12517 | 2 | 1 | 7 | 4743.0 | 0.0 | 90.01 | 121.27 | 121.27 | 0.0 | 4743.0 | INR | 2347.0 | 2347.03 | 2347.0 | 4 | 12545 | 2026-05-14 15:35:50 | 0 | NULL | 1 | 2026-05-14 16:27:04 | 12517 | 1 | 2026-05-14 16:27:04 | ||
| 968 | 1189 | POFN-2178 | INVFN-2178 | 12526 | 12517 | 2 | 1 | 2 | 998.0 | 0.0 | 19.01 | 23.76 | 23.76 | 0.0 | 998.0 | INR | 498.0 | 498.2 | 498.0 | 4 | 12526 | 2026-05-15 00:16:17 | 0 | NULL | 1 | 2026-05-15 19:19:52 | 12517 | 1 | 2026-05-15 19:19:52 | ||
| 969 | 1190 | POFN-2179 | INVFN-2179 | 12545 | 12517 | 2 | 1 | 9 | 1809.0 | 0.0 | 31.09 | 127.27 | 127.27 | 0.0 | 1809.0 | INR | 747.0 | 747.03 | 747.0 | 4 | 12545 | 2026-05-15 11:38:09 | 0 | NULL | 1 | 2026-05-15 19:19:52 | 12517 | 1 | 2026-05-15 19:19:52 | ||
| 970 | 1191 | POFN-2180 | INVFN-2180 | 12545 | 12517 | 2 | 1 | 18 | 5240.0 | 0.0 | 97.92 | 171.87 | 171.87 | 0.0 | 5240.0 | INR | 2494.0 | 2494.07 | 2494.0 | 4 | 12545 | 2026-05-17 19:37:35 | 0 | NULL | 1 | 2026-05-17 19:46:17 | 12517 | 1 | 2026-05-17 19:46:17 | ||
| 971 | 1192 | POFN-2181 | INVFN-2181 | 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-05-18 17:08:32 | 0 | NULL | 1 | 2026-05-18 18:26:05 | 12517 | 1 | 2026-05-18 18:26:05 | ||
| 972 | 1193 | POFN-2182 | INVFN-2182 | 12545 | 12517 | 2 | 1 | 2 | 1470.0 | 0.0 | 26.43 | 74.35 | 74.35 | 0.0 | 1470.0 | INR | 735.0 | 735.1 | 735.0 | 4 | 12545 | 2026-05-20 10:16:46 | 0 | NULL | 1 | 2026-05-20 15:36:37 | 12517 | 1 | 2026-05-20 15:36:37 | ||
| 973 | 1194 | POFN-2183 | INVFN-2183 | 12545 | 12517 | 2 | 1 | 5 | 1536.0 | 0.0 | 29.26 | 36.57 | 36.57 | 0.0 | 1536.0 | INR | 768.0 | 768.16 | 768.0 | 4 | 12545 | 2026-05-20 14:49:37 | 0 | NULL | 1 | 2026-05-20 15:36:37 | 12517 | 1 | 2026-05-20 15:36:37 | ||
| 974 | 1195 | POFN-2184 | INVFN-2184 | 12532 | 12517 | 2 | 1 | 32 | 14749.0 | 0.0 | 279.36 | 390.51 | 390.51 | 0.0 | 14749.0 | INR | 7264.0 | 7264.1 | 7264.0 | 4 | 12532 | 2026-05-20 15:47:17 | 0 | NULL | 1 | 2026-05-20 19:00:59 | 12517 | 1 | 2026-05-20 19:00:59 | ||
| 975 | 1196 | POFN-2185 | INVFN-2185 | 12545 | 12517 | 2 | 1 | 1 | 720.0 | 0.0 | 13.71 | 17.14 | 17.14 | 0.0 | 720.0 | INR | 360.0 | 360.15 | 360.0 | 4 | 12545 | 2026-05-20 15:58:41 | 0 | NULL | 1 | 2026-05-20 19:00:53 | 12517 | 1 | 2026-05-20 19:00:53 | ||
| 976 | 1197 | POFN-2186 | INVFN-2186 | 12526 | 12517 | 2 | 1 | 33 | 17118.0 | 0.0 | 319.6 | 568.9 | 568.9 | 0.0 | 17118.0 | INR | 8289.0 | 8289.25 | 8289.0 | 4 | 12526 | 2026-05-20 21:02:32 | 0 | NULL | 1 | 2026-05-20 21:09:32 | 12517 | 1 | 2026-05-20 21:09:32 | ||
| 977 | 1198 | POFN-2187 | INVFN-2187 | 12545 | 12517 | 2 | 1 | 3 | 1159.0 | 0.0 | 22.08 | 27.6 | 27.6 | 0.0 | 1159.0 | INR | 579.0 | 579.11 | 579.0 | 4 | 12545 | 2026-05-21 05:48:12 | 0 | NULL | 1 | 2026-05-21 11:41:30 | 12517 | 1 | 2026-05-21 11:41:30 | ||
| 978 | 1199 | POFN-2188 | INVFN-2188 | 12539 | 12517 | 2 | 1 | 2 | 1680.0 | 0.0 | 32.0 | 40.0 | 40.0 | 0.0 | 1680.0 | INR | 835.0 | 835.01 | 835.0 | 4 | 12539 | 2026-05-21 14:28:32 | 0 | NULL | 1 | 2026-05-21 16:55:34 | 12517 | 1 | 2026-05-21 16:55:34 | ||
| 979 | 1200 | POFN-2189 | INVFN-2189 | 14079 | 12517 | 2 | 1 | 13 | 1260.0 | 0.0 | 24.0 | 30.0 | 30.0 | 0.0 | 1260.0 | INR | 570.0 | 570.05 | 570.0 | 4 | 14079 | 2026-05-21 19:41:17 | 0 | NULL | 1 | 2026-05-21 21:46:26 | 12517 | 1 | 2026-05-21 21:46:26 | ||
| 980 | 1201 | POFN-2190 | INVFN-2190 | 12545 | 12517 | 2 | 1 | 19 | 3402.0 | 0.0 | 64.47 | 89.34 | 89.34 | 0.0 | 3402.0 | INR | 1626.0 | 1626.24 | 1626.0 | 4 | 12545 | 2026-05-21 20:36:55 | 0 | NULL | 1 | 2026-05-21 21:46:18 | 12517 | 1 | 2026-05-21 21:46:18 | ||
| 981 | 1202 | POFN-2191 | INVFN-2191 | 12517 | 12516 | 2 | 1 | 20 | 6400.0 | 0.0 | 325.42 | 0.0 | 0.0 | 976.27 | 6400.0 | INR | 3200.0 | 3201.0 | 3200.0 | 4 | 12517 | 2026-05-21 21:00:05 | 0 | NULL | 1 | 2026-05-21 21:00:43 | 12516 | 1 | 2026-05-21 21:00:43 | ||
| 982 | 1203 | POFN-2192 | INVFN-2192 | 12545 | 12517 | 2 | 1 | 3 | 1390.0 | 0.0 | 23.56 | 106.02 | 106.02 | 0.0 | 1390.0 | INR | 695.0 | 695.1 | 695.0 | 4 | 12545 | 2026-05-21 21:28:30 | 0 | NULL | 1 | 2026-05-21 21:46:11 | 12517 | 1 | 2026-05-21 21:46:11 | ||
| 983 | 1204 | POFN-2193 | INVFN-2193 | 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-05-22 14:06:55 | 0 | NULL | 1 | 2026-05-22 14:07:39 | 12554 | 1 | 2026-05-22 14:07:39 | ||
| 984 | 1205 | POFN-2194 | INVFN-2194 | 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-05-22 17:41:45 | 0 | NULL | 1 | 2026-05-22 17:42:04 | 12516 | 1 | 2026-05-22 17:42:04 | ||
| 985 | 1206 | POFN-2195 | INVFN-2195 | 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-05-22 17:43:22 | 0 | NULL | 1 | 2026-05-22 17:44:17 | 12554 | 1 | 2026-05-22 17:44:17 | ||
| 986 | 1207 | POFN-2196 | INVFN-2196 | 12539 | 12517 | 2 | 1 | 2 | 2350.0 | 0.0 | 43.19 | 95.3 | 95.3 | 0.0 | 2350.0 | INR | 1175.0 | 1175.1 | 1175.0 | 4 | 12539 | 2026-05-23 16:18:38 | 0 | NULL | 1 | 2026-05-23 16:22:25 | 12517 | 1 | 2026-05-23 16:22:26 | ||
| 987 | 1208 | POFN-2197 | INVFN-2197 | 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-05-23 16:38:13 | 0 | NULL | 1 | 2026-05-23 19:14:37 | 12517 | 1 | 2026-05-23 19:14:37 | ||
| 988 | 1209 | POFN-2198 | INVFN-2198 | 14902 | 12517 | 2 | 1 | 16 | 9893.0 | 0.0 | 181.33 | 413.34 | 413.34 | 0.0 | 9893.0 | INR | 4764.0 | 4764.02 | 4764.0 | 4 | 14902 | 2026-05-24 13:03:29 | 0 | NULL | 2 | 2026-05-24 16:31:26 | 12517 | 0 | NULL | ||
| 989 | 1210 | POFN-2199 | INVFN-2199 | 14902 | 12517 | 2 | 1 | 16 | 9893.0 | 0.0 | 181.33 | 413.34 | 413.34 | 0.0 | 9893.0 | INR | 4764.0 | 4764.02 | 4764.0 | 4 | 14902 | 2026-05-24 23:19:14 | 0 | NULL | 1 | 2026-05-24 23:26:33 | 12517 | 1 | 2026-05-24 23:26:33 | ||
| 990 | 1211 | POFN-2200 | INVFN-2200 | 12539 | 12517 | 2 | 1 | 3 | 2641.0 | 0.0 | 49.63 | 79.72 | 79.72 | 0.0 | 2641.0 | INR | 1272.0 | 1272.02 | 1272.0 | 4 | 12539 | 2026-05-28 04:00:28 | 0 | NULL | 1 | 2026-05-28 19:25:13 | 12517 | 1 | 2026-05-28 19:25:13 | ||
| 991 | 1212 | POFN-2201 | INVFN-2201 | 12526 | 12517 | 2 | 1 | 6 | 954.0 | 0.0 | 16.17 | 72.76 | 72.76 | 0.0 | 954.0 | INR | 330.0 | 330.15 | 330.0 | 4 | 12526 | 2026-05-28 20:44:51 | 0 | NULL | 1 | 2026-05-29 21:03:23 | 12517 | 1 | 2026-05-29 21:03:23 | ||
| 992 | 1213 | POFN-2202 | INVFN-2202 | 12539 | 12517 | 2 | 1 | 4 | 2222.0 | 0.0 | 41.95 | 62.35 | 62.35 | 0.0 | 2222.0 | INR | 1084.0 | 1084.05 | 1084.0 | 4 | 12539 | 2026-05-29 15:53:20 | 0 | NULL | 1 | 2026-05-29 21:03:47 | 12517 | 1 | 2026-05-29 21:03:47 | ||
| 993 | 1214 | POFN-2203 | INVFN-2203 | 12539 | 12517 | 2 | 1 | 3 | 957.0 | 0.0 | 18.23 | 22.79 | 22.79 | 0.0 | 957.0 | INR | 477.0 | 477.15 | 477.0 | 4 | 12539 | 2026-05-29 16:14:49 | 0 | NULL | 1 | 2026-05-29 21:03:47 | 12517 | 1 | 2026-05-29 21:03:47 | ||
| 994 | 1215 | POFN-2204 | INVFN-2204 | 12526 | 12517 | 2 | 1 | 18 | 5198.0 | 0.0 | 92.88 | 277.05 | 277.05 | 0.0 | 5198.0 | INR | 2396.0 | 2396.15 | 2396.0 | 4 | 12526 | 2026-05-29 23:55:48 | 0 | NULL | 1 | 2026-05-30 13:02:08 | 12517 | 1 | 2026-05-30 13:02:08 | ||
| 995 | 1216 | POFN-2205 | INVFN-2205 | 12532 | 12517 | 2 | 1 | 1 | 10700.0 | 0.0 | 203.81 | 254.76 | 254.76 | 0.0 | 10700.0 | INR | 5350.0 | 5352.0 | 5350.0 | 4 | 12532 | 2026-05-30 12:44:21 | 0 | NULL | 1 | 2026-05-30 13:02:23 | 12517 | 1 | 2026-05-30 13:02:23 | ||
| 996 | 1217 | POFN-2206 | INVFN-2206 | 12532 | 12517 | 2 | 1 | 9 | 7476.0 | 0.0 | 142.4 | 178.0 | 178.0 | 0.0 | 7476.0 | INR | 3736.0 | 3736.3 | 3736.0 | 4 | 12532 | 2026-05-30 13:37:20 | 0 | NULL | 1 | 2026-05-30 19:12:05 | 12517 | 1 | 2026-05-30 19:12:05 | ||
| 997 | 1218 | POFN-2207 | INVFN-2207 | 12526 | 12517 | 2 | 1 | 16 | 7458.0 | 0.0 | 136.48 | 317.01 | 317.01 | 0.0 | 7458.0 | INR | 3435.0 | 3435.3 | 3435.0 | 4 | 12526 | 2026-05-30 21:41:09 | 0 | NULL | 1 | 2026-05-30 21:53:58 | 12517 | 1 | 2026-05-30 21:53:58 | ||
| 998 | 1219 | POFN-2208 | INVFN-2208 | 12545 | 12517 | 2 | 1 | 63 | 13114.0 | 0.0 | 249.79 | 312.24 | 312.24 | 0.0 | 13114.0 | INR | 6304.0 | 6304.45 | 6304.0 | 4 | 12545 | 2026-05-31 08:49:43 | 0 | NULL | 1 | 2026-05-31 09:15:43 | 12517 | 1 | 2026-05-31 09:15:43 | ||
| 999 | 1220 | POFN-2209 | INVFN-2209 | 12539 | 12517 | 2 | 1 | 4 | 4418.0 | 0.0 | 84.15 | 105.19 | 105.19 | 0.0 | 4418.0 | INR | 2208.0 | 2208.15 | 2208.0 | 4 | 12539 | 2026-05-31 12:39:10 | 0 | NULL | 1 | 2026-05-31 12:42:32 | 12517 | 1 | 2026-05-31 12:42:32 | ||
| 1000 | 1221 | POFN-2210 | INVFN-2210 | 12539 | 12517 | 2 | 1 | 1 | 80.0 | 0.0 | 1.52 | 1.9 | 1.9 | 0.0 | 80.0 | INR | 35.0 | 35.01 | 35.0 | 4 | 12539 | 2026-05-31 12:43:52 | 0 | NULL | 1 | 2026-05-31 12:58:36 | 12517 | 1 | 2026-05-31 12:58:36 |