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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1001 | 1011 | POFN-2001 | INVFN-2001 | 12526 | 12517 | 2 | 1 | 100 | 18295.0 | 0.0 | 338.5 | 685.05 | 685.05 | 0.0 | 18295.0 | INR | 0.0 | 0.2 | 0.0 | 4 | 12526 | 2026-03-07 21:01:56 | 0 | NULL | 1 | 2026-03-07 21:06:24 | 12517 | 1 | 2026-03-07 21:06:24 | ||
| 1002 | 1012 | POFN-2002 | INVFN-2002 | 12526 | 12517 | 2 | 1 | 27 | 25489.0 | 0.0 | 474.49 | 882.25 | 882.25 | 0.0 | 25489.0 | INR | 0.0 | 0.6 | 0.0 | 4 | 12526 | 2026-03-09 20:18:47 | 0 | NULL | 1 | 2026-03-09 20:24:25 | 12517 | 1 | 2026-03-09 20:24:25 | ||
| 1003 | 1013 | POFN-2003 | INVFN-2003 | 12521 | 12517 | 2 | 1 | 2 | 2400.0 | 0.0 | 45.71 | 57.14 | 57.14 | 0.0 | 2400.0 | INR | 0.0 | 0.5 | 0.0 | 4 | 12521 | 2026-03-09 22:11:44 | 0 | NULL | 1 | 2026-03-09 22:12:36 | 12517 | 1 | 2026-03-09 22:12:36 | ||
| 1004 | 1014 | POFN-2004 | INVFN-2004 | 12539 | 12517 | 2 | 1 | 4 | 2437.0 | 0.0 | 46.42 | 58.02 | 58.02 | 0.0 | 2437.0 | INR | 0.0 | 0.15 | 0.0 | 4 | 12539 | 2026-03-11 20:12:03 | 0 | NULL | 1 | 2026-03-11 20:21:22 | 12517 | 1 | 2026-03-11 20:21:12 | ||
| 1005 | 1015 | POFN-2005 | INVFN-2005 | 12539 | 12517 | 2 | 2 | 1 | 10700.0 | 0.0 | 203.81 | 254.76 | 254.76 | 0.0 | 10700.0 | INR | 0.0 | 1.0 | 50.0 | 4 | 12539 | 2026-03-11 20:13:26 | 0 | NULL | 1 | 2026-03-11 20:21:12 | 12517 | 1 | 2026-03-11 20:21:12 | ||
| 1006 | 1016 | POFN-2006 | INVFN-2006 | 12539 | 12517 | 2 | 1 | 1 | 204.0 | 0.0 | 3.89 | 4.86 | 4.86 | 0.0 | 204.0 | INR | 0.0 | 0.04 | 0.0 | 4 | 12539 | 2026-03-11 20:34:48 | 0 | NULL | 1 | 2026-03-11 21:39:37 | 12517 | 1 | 2026-03-11 21:39:37 | ||
| 1007 | 1017 | POFN-2007 | INVFN-2007 | 12539 | 12517 | 2 | 2 | 1 | 10700.0 | 0.0 | 203.81 | 254.76 | 254.76 | 0.0 | 10700.0 | INR | 0.0 | 1.0 | 50.0 | 4 | 12539 | 2026-03-13 10:54:59 | 0 | NULL | 1 | 2026-03-13 12:01:48 | 12517 | 1 | 2026-03-13 12:01:48 | ||
| 1008 | 1018 | POFN-2008 | INVFN-2008 | 14079 | 12517 | 2 | 1 | 25 | 2000.0 | 0.0 | 38.1 | 47.62 | 47.62 | 0.0 | 2000.0 | INR | 0.0 | 0.22 | 0.0 | 4 | 14079 | 2026-03-13 14:10:02 | 0 | NULL | 1 | 2026-03-13 14:58:55 | 12517 | 1 | 2026-03-13 14:58:55 | ||
| 1009 | 1019 | POFN-2009 | INVFN-2009 | 12526 | 12517 | 2 | 1 | 51 | 13208.0 | 0.0 | 233.83 | 758.2 | 758.2 | 0.0 | 13208.0 | INR | 0.0 | 0.25 | 0.0 | 4 | 12526 | 2026-03-13 14:43:10 | 0 | NULL | 1 | 2026-03-13 14:58:51 | 12517 | 1 | 2026-03-13 14:58:51 | ||
| 1010 | 1020 | POFN-2010 | INVFN-2010 | 12517 | 12516 | 2 | 1 | 926 | 44448.0 | 0.0 | 2539.89 | 0.0 | 0.0 | 2116.57 | 44448.0 | INR | 0.0 | 5.56 | 0.0 | 4 | 12517 | 2026-03-13 17:47:27 | 0 | NULL | 1 | 2026-03-13 17:47:51 | 12516 | 1 | 2026-03-13 17:47:51 | ||
| 1011 | 1021 | POFN-2011 | INVFN-2011 | 14902 | 12517 | 2 | 1 | 8 | 10500.0 | 0.0 | 200.0 | 250.0 | 250.0 | 0.0 | 10500.0 | INR | 0.0 | 0.75 | 0.0 | 4 | 14902 | 2026-03-13 22:12:48 | 0 | NULL | 1 | 2026-03-13 22:18:19 | 12517 | 1 | 2026-03-13 22:18:19 | ||
| 1012 | 1022 | POFN-2012 | INVFN-2012 | 14569 | 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 | 14569 | 2026-03-14 10:25:41 | 0 | NULL | 1 | 2026-03-14 11:18:55 | 12517 | 1 | 2026-03-14 11:18:55 | ||
| 1013 | 1023 | POFN-2013 | INVFN-2013 | 14569 | 12517 | 2 | 2 | 4 | 66450.0 | 0.0 | 1265.71 | 1582.14 | 1582.14 | 0.0 | 66450.0 | INR | 0.0 | 1.0 | 50.0 | 4 | 14569 | 2026-03-14 10:31:53 | 0 | NULL | 1 | 2026-03-14 11:18:55 | 12517 | 1 | 2026-03-14 11:18:55 | ||
| 1014 | 1024 | POFN-2014 | INVFN-2014 | 14569 | 12517 | 2 | 1 | 1 | 1650.0 | 0.0 | 31.43 | 39.29 | 39.29 | 0.0 | 1650.0 | INR | 0.0 | 0.3 | 0.0 | 4 | 14569 | 2026-03-14 11:30:41 | 0 | NULL | 1 | 2026-03-14 11:40:53 | 12517 | 1 | 2026-03-14 11:40:53 | ||
| 1015 | 1025 | POFN-2015 | INVFN-2015 | 14569 | 12517 | 2 | 1 | 1 | 1650.0 | 0.0 | 31.43 | 39.29 | 39.29 | 0.0 | 1650.0 | INR | 0.0 | 0.3 | 0.0 | 4 | 14569 | 2026-03-14 11:31:41 | 0 | NULL | 1 | 2026-03-14 11:40:53 | 12517 | 1 | 2026-03-14 11:40:53 | ||
| 1016 | 1026 | POFN-2016 | INVFN-2016 | 14569 | 12517 | 2 | 1 | 2 | 2400.0 | 0.0 | 45.71 | 57.14 | 57.14 | 0.0 | 2400.0 | INR | 0.0 | 0.25 | 0.0 | 4 | 14569 | 2026-03-14 11:36:44 | 0 | NULL | 1 | 2026-03-14 11:40:53 | 12517 | 1 | 2026-03-14 11:40:53 | ||
| 1017 | 1027 | POFN-2017 | INVFN-2017 | 14569 | 12517 | 2 | 2 | 2 | 29200.0 | 0.0 | 556.19 | 695.24 | 695.24 | 0.0 | 29200.0 | INR | 0.0 | 1.0 | 50.0 | 4 | 14569 | 2026-03-14 12:24:42 | 0 | NULL | 1 | 2026-03-14 12:46:12 | 12517 | 1 | 2026-03-14 12:46:12 | ||
| 1018 | 1028 | POFN-2018 | INVFN-2018 | 12545 | 12517 | 2 | 1 | 5 | 2495.0 | 0.0 | 47.52 | 59.4 | 59.4 | 0.0 | 2495.0 | INR | 0.0 | 0.5 | 0.0 | 4 | 12545 | 2026-03-14 12:57:35 | 0 | NULL | 1 | 2026-03-14 12:59:42 | 12517 | 1 | 2026-03-14 12:59:42 | ||
| 1019 | 1029 | POFN-2019 | INVFN-2019 | 12526 | 12517 | 2 | 1 | 76 | 7164.0 | 0.0 | 132.45 | 270.67 | 270.67 | 0.0 | 7164.0 | INR | 0.0 | 0.3 | 0.0 | 4 | 12526 | 2026-03-14 20:28:05 | 0 | NULL | 1 | 2026-03-14 20:30:14 | 12517 | 1 | 2026-03-14 20:30:14 | ||
| 1020 | 1030 | POFN-2020 | INVFN-2020 | 14569 | 12517 | 2 | 1 | 15 | 5356.0 | 0.0 | 99.67 | 186.18 | 186.18 | 0.0 | 5356.0 | INR | 0.0 | 0.15 | 0.0 | 4 | 14569 | 2026-03-14 20:34:24 | 0 | NULL | 1 | 2026-03-14 22:20:36 | 12517 | 1 | 2026-03-14 22:20:36 | ||
| 1021 | 1031 | POFN-2021 | INVFN-2021 | 14569 | 12517 | 2 | 2 | 1 | 10700.0 | 0.0 | 203.81 | 254.76 | 254.76 | 0.0 | 10700.0 | INR | 0.0 | 1.0 | 50.0 | 4 | 14569 | 2026-03-14 20:40:24 | 0 | NULL | 1 | 2026-03-14 22:20:36 | 12517 | 1 | 2026-03-14 22:20:36 | ||
| 1022 | 1032 | POFN-2022 | INVFN-2022 | 14569 | 12517 | 2 | 2 | 1 | 10700.0 | 0.0 | 203.81 | 254.76 | 254.76 | 0.0 | 10700.0 | INR | 0.0 | 1.0 | 50.0 | 4 | 14569 | 2026-03-15 10:39:46 | 0 | NULL | 1 | 2026-03-15 11:37:48 | 12517 | 1 | 2026-03-15 11:37:48 | ||
| 1023 | 1033 | POFN-2023 | INVFN-2023 | 12545 | 12517 | 2 | 1 | 3 | 2749.0 | 0.0 | 50.79 | 104.8 | 104.8 | 0.0 | 2749.0 | INR | 0.0 | 0.3 | 0.0 | 4 | 12545 | 2026-03-16 06:26:04 | 0 | NULL | 1 | 2026-03-16 12:26:36 | 12517 | 1 | 2026-03-16 12:26:36 | ||
| 1024 | 1034 | POFN-2024 | INVFN-2024 | 12542 | 12517 | 2 | 2 | 1 | 10700.0 | 0.0 | 203.81 | 254.76 | 254.76 | 0.0 | 10700.0 | INR | 0.0 | 1.0 | 50.0 | 4 | 12542 | 2026-03-16 13:02:58 | 0 | NULL | 1 | 2026-03-16 13:03:46 | 12517 | 1 | 2026-03-16 13:03:46 | ||
| 1025 | 1035 | POFN-2025 | INVFN-2025 | 12539 | 12517 | 2 | 2 | 2 | 37500.0 | 0.0 | 714.29 | 892.86 | 892.86 | 0.0 | 37500.0 | INR | 0.0 | 4.0 | 200.0 | 4 | 12539 | 2026-03-16 14:47:31 | 0 | NULL | 1 | 2026-03-16 14:52:19 | 12517 | 1 | 2026-03-16 14:52:19 | ||
| 1026 | 1036 | POFN-2026 | INVFN-2026 | 12516 | 1 | 2 | 2 | 15 | 277500.0 | 0.0 | 0.0 | 6607.14 | 6607.14 | 0.0 | 277500.0 | INR | 0.0 | 30.0 | 1500.0 | 4 | 12516 | 2026-03-16 14:56:35 | 0 | NULL | 1 | 2026-03-16 14:56:45 | 1 | 1 | 2026-03-16 14:56:45 | ||
| 1027 | 1037 | POFN-2027 | INVFN-2027 | 12545 | 12517 | 2 | 1 | 23 | 2214.0 | 0.0 | 38.83 | 136.13 | 136.13 | 0.0 | 2214.0 | INR | 0.0 | 0.25 | 0.0 | 4 | 12545 | 2026-03-16 20:49:50 | 0 | NULL | 1 | 2026-03-16 20:52:36 | 12517 | 1 | 2026-03-16 20:52:36 | ||
| 1028 | 1038 | POFN-2028 | INVFN-2028 | 12533 | 12517 | 2 | 2 | 2 | 21400.0 | 0.0 | 407.62 | 509.52 | 509.52 | 0.0 | 21400.0 | INR | 0.0 | 2.0 | 100.0 | 4 | 12533 | 2026-03-16 20:55:37 | 0 | NULL | 1 | 2026-03-16 20:57:39 | 12517 | 1 | 2026-03-16 20:57:39 | ||
| 1029 | 1039 | POFN-2029 | INVFN-2029 | 12521 | 12517 | 2 | 2 | 3 | 40150.0 | 0.0 | 764.76 | 955.95 | 955.95 | 0.0 | 40150.0 | INR | 0.0 | 2.0 | 100.0 | 4 | 12521 | 2026-03-16 20:56:25 | 0 | NULL | 1 | 2026-03-16 20:57:54 | 12517 | 1 | 2026-03-16 20:57:54 | ||
| 1030 | 1040 | POFN-2030 | INVFN-2030 | 14902 | 12517 | 2 | 1 | 48 | 13863.0 | 0.0 | 257.96 | 482.47 | 482.47 | 0.0 | 13863.0 | INR | 0.0 | 0.04 | 0.0 | 4 | 14902 | 2026-03-16 22:58:45 | 0 | NULL | 1 | 2026-03-16 23:02:11 | 12517 | 1 | 2026-03-16 23:02:11 | ||
| 1031 | 1041 | POFN-2031 | INVFN-2031 | 12517 | 12516 | 2 | 2 | 10 | 185000.0 | 0.0 | 8809.52 | 0.0 | 0.0 | 8809.52 | 185000.0 | INR | 0.0 | 20.0 | 1000.0 | 4 | 12517 | 2026-03-17 12:24:06 | 0 | NULL | 1 | 2026-03-17 12:25:48 | 12516 | 1 | 2026-03-17 12:25:48 | ||
| 1032 | 1042 | POFN-2032 | INVFN-2032 | 14079 | 12517 | 2 | 1 | 3 | 1278.0 | 0.0 | 24.34 | 30.43 | 30.43 | 0.0 | 1278.0 | INR | 0.0 | 0.15 | 0.0 | 4 | 14079 | 2026-03-18 22:46:17 | 0 | NULL | 1 | 2026-03-19 06:18:33 | 12517 | 1 | 2026-03-19 06:18:33 | ||
| 1033 | 1043 | POFN-2033 | INVFN-2033 | 14569 | 12517 | 2 | 1 | 4 | 5419.0 | 0.0 | 103.22 | 129.02 | 129.02 | 0.0 | 5419.0 | INR | 0.0 | 0.3 | 0.0 | 4 | 14569 | 2026-03-19 22:17:39 | 0 | NULL | 1 | 2026-03-20 08:50:41 | 12517 | 1 | 2026-03-20 08:50:41 | ||
| 1034 | 1044 | POFN-2034 | INVFN-2034 | 12521 | 12517 | 2 | 1 | 2 | 2400.0 | 0.0 | 45.71 | 57.14 | 57.14 | 0.0 | 2400.0 | INR | 0.0 | 0.25 | 0.0 | 4 | 12521 | 2026-03-20 23:25:40 | 0 | NULL | 1 | 2026-03-21 00:00:56 | 12517 | 1 | 2026-03-21 00:00:56 | ||
| 1035 | 1045 | POFN-2035 | INVFN-2035 | 12548 | 12517 | 2 | 1 | 32 | 5440.0 | 0.0 | 103.62 | 129.52 | 129.52 | 0.0 | 5440.0 | INR | 0.0 | 0.18 | 0.0 | 4 | 12548 | 2026-03-20 23:30:39 | 0 | NULL | 1 | 2026-03-21 00:00:56 | 12517 | 1 | 2026-03-21 00:00:56 | ||
| 1036 | 1046 | POFN-2036 | INVFN-2036 | 12545 | 12517 | 2 | 1 | 2 | 1500.0 | 0.0 | 25.42 | 114.41 | 114.41 | 0.0 | 1500.0 | INR | 0.0 | 0.2 | 0.0 | 4 | 12545 | 2026-03-24 06:10:51 | 0 | NULL | 2 | 2026-03-24 21:57:15 | 12517 | 0 | NULL | ||
| 1037 | 1047 | POFN-2037 | INVFN-2037 | 12517 | 12516 | 2 | 1 | 10 | 7500.0 | 0.0 | 428.57 | 0.0 | 0.0 | 357.14 | 7500.0 | INR | 0.0 | 1.0 | 0.0 | 4 | 12517 | 2026-03-24 15:41:18 | 0 | NULL | 1 | 2026-03-24 15:41:46 | 12516 | 1 | 2026-03-24 15:41:46 | ||
| 1038 | 1048 | POFN-2038 | INVFN-2038 | 12526 | 12517 | 2 | 1 | 54 | 10329.0 | 0.0 | 192.07 | 362.71 | 362.71 | 0.0 | 10329.0 | INR | 0.0 | 0.3 | 0.0 | 4 | 12526 | 2026-03-24 20:47:23 | 0 | NULL | 1 | 2026-03-24 21:17:13 | 12517 | 1 | 2026-03-24 21:17:13 | ||
| 1039 | 1049 | POFN-2039 | INVFN-2039 | 12532 | 12517 | 2 | 1 | 35 | 13023.0 | 0.0 | 245.04 | 385.62 | 385.62 | 0.0 | 13023.0 | INR | 0.0 | 0.13 | 0.0 | 4 | 12532 | 2026-03-24 20:49:23 | 0 | NULL | 1 | 2026-03-24 21:17:22 | 12517 | 1 | 2026-03-24 21:17:22 | ||
| 1040 | 1050 | POFN-2040 | INVFN-2040 | 12545 | 12517 | 2 | 1 | 2 | 1500.0 | 0.0 | 28.57 | 35.71 | 35.71 | 0.0 | 1500.0 | INR | 0.0 | 0.2 | 0.0 | 4 | 12545 | 2026-03-24 22:01:23 | 0 | NULL | 1 | 2026-03-25 09:23:11 | 12517 | 1 | 2026-03-25 09:23:11 | ||
| 1041 | 1051 | POFN-2041 | INVFN-2041 | 12523 | 12517 | 2 | 1 | 114 | 25175.0 | 0.0 | 458.84 | 1116.41 | 1116.41 | 0.0 | 25175.0 | INR | 0.0 | 0.3 | 0.0 | 4 | 12523 | 2026-03-25 15:15:31 | 0 | NULL | 1 | 2026-03-25 15:47:26 | 12517 | 1 | 2026-03-25 15:47:26 | ||
| 1042 | 1052 | POFN-2042 | INVFN-2042 | 12548 | 12517 | 2 | 1 | 9 | 5965.0 | 0.0 | 111.11 | 204.72 | 204.72 | 0.0 | 5965.0 | INR | 0.0 | 0.05 | 0.0 | 4 | 12548 | 2026-03-26 07:51:58 | 0 | NULL | 1 | 2026-03-26 10:51:56 | 12517 | 1 | 2026-03-26 10:51:56 | ||
| 1043 | 1053 | POFN-2043 | INVFN-2043 | 12526 | 12517 | 2 | 1 | 7 | 3197.0 | 0.0 | 58.71 | 130.68 | 130.68 | 0.0 | 3197.0 | INR | 0.0 | 0.08 | 0.0 | 4 | 12526 | 2026-03-26 22:37:16 | 0 | NULL | 1 | 2026-03-27 05:17:11 | 12517 | 1 | 2026-03-27 05:17:11 | ||
| 1044 | 1054 | POFN-2044 | INVFN-2044 | 12545 | 12517 | 2 | 1 | 59 | 11201.0 | 0.0 | 202.14 | 547.1 | 547.1 | 0.0 | 11201.0 | INR | 0.0 | 0.32 | 0.0 | 4 | 12545 | 2026-03-27 19:10:08 | 0 | NULL | 1 | 2026-03-27 19:15:12 | 12517 | 1 | 2026-03-27 19:15:12 | ||
| 1045 | 1055 | POFN-2045 | INVFN-2045 | 12545 | 12517 | 2 | 1 | 19 | 3979.0 | 0.0 | 74.61 | 124.17 | 124.17 | 0.0 | 3979.0 | INR | 0.0 | 0.02 | 0.0 | 4 | 12545 | 2026-03-27 19:13:13 | 0 | NULL | 1 | 2026-03-27 19:15:12 | 12517 | 1 | 2026-03-27 19:15:12 | ||
| 1046 | 1056 | POFN-2046 | INVFN-2046 | 12545 | 12517 | 2 | 1 | 9 | 1077.0 | 0.0 | 19.51 | 50.67 | 50.67 | 0.0 | 1077.0 | INR | 0.0 | 0.08 | 0.0 | 4 | 12545 | 2026-03-27 21:29:24 | 0 | NULL | 1 | 2026-03-27 21:29:35 | 12517 | 1 | 2026-03-27 21:29:35 | ||
| 1047 | 1057 | POFN-2047 | INVFN-2047 | 12526 | 12517 | 2 | 1 | 11 | 6177.0 | 0.0 | 111.41 | 303.25 | 303.25 | 0.0 | 6177.0 | INR | 0.0 | 0.1 | 0.0 | 4 | 12526 | 2026-03-27 21:29:57 | 0 | NULL | 1 | 2026-03-27 21:30:17 | 12517 | 1 | 2026-03-27 21:30:17 | ||
| 1048 | 1058 | POFN-2048 | INVFN-2048 | 12516 | 1 | 2 | 1 | 50 | 16000.0 | 0.0 | 1084.75 | 1220.34 | 1220.34 | 0.0 | 16000.0 | INR | 0.0 | 2.5 | 0.0 | 4 | 12516 | 2026-03-27 21:43:39 | 0 | NULL | 1 | 2026-03-27 21:44:08 | 1 | 1 | 2026-03-27 21:44:08 | ||
| 1049 | 1059 | POFN-2049 | INVFN-2049 | 12517 | 12516 | 2 | 1 | 50 | 16000.0 | 0.0 | 813.56 | 0.0 | 0.0 | 2440.68 | 16000.0 | INR | 0.0 | 2.5 | 0.0 | 4 | 12517 | 2026-03-27 21:45:18 | 0 | NULL | 1 | 2026-03-27 21:45:35 | 12516 | 1 | 2026-03-27 21:45:35 | ||
| 1050 | 1060 | POFN-2050 | INVFN-2050 | 12526 | 12517 | 2 | 1 | 10 | 3200.0 | 0.0 | 54.24 | 244.07 | 244.07 | 0.0 | 3200.0 | INR | 0.0 | 0.5 | 0.0 | 4 | 12526 | 2026-03-27 22:03:26 | 0 | NULL | 1 | 2026-03-27 22:03:45 | 12517 | 1 | 2026-03-27 22:03:45 |