fx_franchise_order

1,267 rows · 31 columns · page 22 / 26

Invoice view Excel export
# 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