fx_franchise_order

1,267 rows · 31 columns · page 2 / 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
51 61 POF-1051 INVF-1051 12546 12517 2 1 707 91834.0 0.0 1836.68 3127.25 3127.25 0.0 89997.32 INR 22362.0 22362.0 22662.0 4 12546 2025-11-07 18:56:18 0 NULL 1 2025-11-08 00:06:35 12517 0 NULL
52 62 POF-1052 INVF-1052 12537 12517 2 1 187 39278.4 0.0 785.57 843.33 843.33 0.0 38492.83 INR 12540.0 12540.0 14040.0 4 12537 2025-11-07 19:35:22 0 NULL 1 2025-11-08 00:06:35 12517 0 NULL
53 63 POF-1053 INVF-1053 12529 12517 2 2 2 20998.0 0.0 419.96 499.95 499.95 0.0 20578.04 INR 0.0 7000.0 0.0 4 12529 2025-11-07 19:49:03 0 NULL 1 2025-11-07 20:52:28 12517 0 NULL
54 64 POF-1054 INVF-1054 12529 12517 2 2 1 18500.0 0.0 370.0 440.48 440.48 0.0 18130.0 INR 0.0 7500.0 0.0 4 12529 2025-11-07 19:50:02 0 NULL 1 2025-11-07 20:53:20 12517 0 NULL
55 65 POF-1055 INVF-1055 12526 12517 2 1 519 102808.8 0.0 2056.18 3738.62 3738.62 0.0 100752.62 INR 35134.0 35134.0 35734.0 4 12526 2025-11-07 19:52:39 0 NULL 1 2025-11-08 00:07:17 12517 0 NULL
56 66 POF-1056 INVF-1056 12536 12517 2 1 207 51154.4 0.0 1023.09 1592.62 1592.62 0.0 50131.31 INR 11800.0 11800.0 11905.0 4 12536 2025-11-07 20:05:13 0 NULL 1 2025-11-08 00:09:45 12517 0 NULL
57 67 POF-1057 INVF-1057 12528 12517 2 1 267 52476.0 0.0 1049.52 2005.95 2005.95 0.0 51426.48 INR 12458.0 12458.0 12908.0 4 12528 2025-11-07 20:12:29 0 NULL 1 2025-11-08 00:07:17 12517 0 NULL
58 68 POF-1058 INVF-1058 12522 12517 2 1 563 101669.4 0.0 2033.39 3805.41 3805.41 0.0 99636.01 INR 32522.0 32522.0 32672.0 4 12522 2025-11-07 20:12:32 0 NULL 1 2025-11-08 00:09:56 12517 0 NULL
59 69 POF-1059 INVF-1059 12529 12517 2 2 1 18500.0 0.0 370.0 440.48 440.48 0.0 18130.0 INR 0.0 7500.0 0.0 4 12529 2025-11-07 20:17:38 0 NULL 1 2025-11-07 20:53:31 12517 0 NULL
60 70 POF-1060 INVF-1060 12517 12516 2 1 6 384.0 0.0 19.2 0.0 0.0 18.29 364.8 INR 114.0 114.0 123.0 4 12517 2025-11-07 20:21:33 0 NULL 2 2025-11-09 22:21:50 12516 0 NULL
61 71 POF-1061 INVF-1061 12517 12516 2 1 1 559.2 0.0 27.96 0.0 0.0 26.63 531.24 INR 150.0 150.0 240.0 4 12517 2025-11-07 20:24:05 0 NULL 2 2025-11-09 22:22:00 12516 0 NULL
62 72 POF-1062 INVF-1062 12517 12516 2 1 190 36818.4 0.0 1840.92 0.0 0.0 2855.68 34977.48 INR 13183.0 13183.0 13333.0 4 12517 2025-11-07 20:37:03 0 NULL 2 2025-11-09 22:22:00 12516 0 NULL
63 73 POF-1063 INVF-1063 12552 12517 2 1 69 27122.4 0.0 542.45 1363.7 1363.7 0.0 26579.95 INR 9628.0 9628.0 9778.0 4 12552 2025-11-07 20:37:03 0 NULL 1 2025-11-08 00:07:17 12517 0 NULL
64 74 POF-1064 INVF-1064 12525 12517 2 1 279 107182.4 0.0 2143.65 3314.82 3314.82 0.0 105038.75 INR 28929.0 28929.0 29289.0 4 12525 2025-11-07 20:41:37 0 NULL 1 2025-11-08 00:12:34 12517 0 NULL
65 75 POF-1065 INVF-1065 12517 12516 2 1 472 85907.8 0.0 4295.39 0.0 0.0 5535.96 81612.41 INR 20735.0 20735.0 21110.0 4 12517 2025-11-07 20:52:07 0 NULL 2 2025-11-09 22:22:00 12516 0 NULL
66 76 POF-1066 INVF-1066 12517 12516 2 1 46 7446.4 0.0 372.32 0.0 0.0 1007.47 7074.08 INR 2529.0 2529.0 2724.0 4 12517 2025-11-07 20:59:30 0 NULL 2 2025-11-09 22:22:00 12516 0 NULL
67 77 POF-1067 INVF-1067 12523 12517 2 1 585 72554.4 0.0 1451.09 2582.48 2582.48 0.0 71103.31 INR 22301.0 22301.0 22601.0 4 12523 2025-11-07 21:02:50 0 NULL 1 2025-11-08 00:07:17 12517 0 NULL
68 78 POF-1068 INVF-1068 12520 12517 2 1 222 63525.4 0.0 1270.51 2265.82 2265.82 0.0 62254.89 INR 20481.0 20481.0 21131.0 4 12520 2025-11-07 21:04:47 0 NULL 1 2025-11-08 00:12:34 12517 0 NULL
69 79 POF-1069 INVF-1069 12518 12517 2 1 170 44416.0 0.0 888.32 1562.69 1562.69 0.0 43527.68 INR 10808.0 10808.0 10958.0 4 12518 2025-11-07 21:51:44 0 NULL 1 2025-11-08 00:12:34 12517 0 NULL
70 80 POF-1070 INVF-1070 12552 12517 2 2 1 3998.4 0.0 79.97 95.2 95.2 0.0 3918.43 INR 0.0 1000.0 0.0 4 12552 2025-11-07 22:06:15 0 NULL 1 2025-11-08 00:07:17 12517 0 NULL
71 81 POF-1071 INVF-1071 12516 1 2 1 8247 2249471.6 0.0 179957.73 72511.94 72511.94 0.0 2069513.87 INR 703220.0 703220.0 709820.0 4 12516 2025-11-07 22:39:17 0 NULL 1 2025-11-07 22:39:35 1 0 NULL
72 82 POF-1072 INVF-1072 12516 1 2 1 8247 2249471.6 0.0 179957.73 72511.94 72511.94 0.0 2069513.87 INR 703220.0 703220.0 709820.0 4 12516 2025-11-07 22:56:50 0 NULL 2 2025-11-11 21:20:01 1 0 NULL
73 83 POF-1073 INVF-1073 12526 12517 2 2 1 10499.0 0.0 209.98 249.97 249.97 0.0 10289.02 INR 0.0 3500.0 0.0 4 12526 2025-11-07 23:02:42 0 NULL 1 2025-11-08 00:07:17 12517 0 NULL
74 84 POF-1074 INVF-1074 12517 12516 2 1 8247 2249471.6 0.0 112473.58 0.0 0.0 145023.88 2136998.02 INR 703220.0 703220.0 709820.0 4 12517 2025-11-07 23:11:39 0 NULL 1 2025-11-07 23:12:01 12516 0 NULL
75 85 POF-1075 INVF-1075 12534 12517 2 1 135 38632.6 0.0 772.65 1286.06 1286.06 0.0 37859.95 INR 10103.0 10103.0 10273.0 4 12534 2025-11-07 23:24:21 0 NULL 1 2025-11-08 00:09:56 12517 0 NULL
76 86 POF-1076 INVF-1076 12529 12517 2 1 40 18631.2 0.0 372.62 443.6 443.6 0.0 18258.58 INR 5702.0 5702.0 6212.0 4 12529 2025-11-07 23:32:19 0 NULL 1 2025-11-08 00:07:17 12517 0 NULL
77 87 POF-1077 INVF-1077 12543 12517 2 1 59 6676.0 0.0 133.52 224.47 224.47 0.0 6542.48 INR 1815.0 1815.0 2391.0 4 12543 2025-11-07 23:34:58 0 NULL 1 2025-11-08 00:07:17 12517 0 NULL
78 88 POF-1078 INVF-1078 12544 12517 2 1 123 26633.6 0.0 532.67 1091.37 1091.37 0.0 26100.93 INR 7845.0 7845.0 7995.0 4 12544 2025-11-07 23:38:29 0 NULL 1 2025-11-08 00:07:17 12517 0 NULL
79 89 POF-1079 INVF-1079 12557 12517 2 1 149 18244.8 0.0 364.9 474.65 474.65 0.0 17879.9 INR 5555.0 5555.0 5895.0 4 12557 2025-11-07 23:42:17 0 NULL 1 2025-11-12 15:26:00 12517 0 NULL
80 90 POF-1080 INVF-1080 12685 12517 2 1 190 36818.4 0.0 736.37 1427.84 1427.84 0.0 36082.03 INR 13183.0 13183.0 13333.0 4 12685 2025-11-07 23:47:34 0 NULL 1 2025-11-12 15:26:00 12517 0 NULL
81 91 POF-1081 INVF-1081 12548 12517 2 1 186 36338.4 0.0 726.77 1391.23 1391.23 0.0 35611.63 INR 13063.0 13063.0 13213.0 4 12548 2025-11-07 23:54:32 0 NULL 1 2025-11-08 00:09:56 12517 0 NULL
82 92 POF-1082 INVF-1082 12517 12516 2 1 40 21184.0 0.0 1059.2 0.0 0.0 3231.46 20124.8 INR 6420.0 6420.0 7720.0 4 12517 2025-11-08 00:04:03 0 NULL 1 2025-11-08 00:05:39 12516 0 NULL
83 93 POF-1083 INVF-1083 12516 1 2 1 50 26480.0 0.0 2118.4 2019.66 2019.66 0.0 24361.6 INR 8025.0 8025.0 9650.0 4 12516 2025-11-08 00:05:04 0 NULL 1 2025-11-08 00:05:14 1 0 NULL
84 94 POF-1084 INVF-1084 12517 12516 2 1 50 15200.0 0.0 760.0 0.0 0.0 2318.64 14440.0 INR 12500.0 12500.0 18500.0 4 12517 2025-11-08 00:08:24 0 NULL 1 2025-11-08 00:09:19 12516 0 NULL
85 95 POF-1085 INVF-1085 12516 1 2 1 50 15200.0 0.0 1216.0 1159.32 1159.32 0.0 13984.0 INR 12500.0 12500.0 18500.0 4 12516 2025-11-08 00:08:40 0 NULL 1 2025-11-08 00:09:12 1 0 NULL
86 96 POF-1086 INVF-1086 12517 12516 2 1 50 13000.0 0.0 650.0 0.0 0.0 1983.05 12350.0 INR 3550.0 3550.0 6800.0 4 12517 2025-11-08 00:11:02 0 NULL 1 2025-11-08 00:12:07 12516 0 NULL
87 97 POF-1087 INVF-1087 12516 1 2 1 50 13000.0 0.0 1040.0 991.52 991.52 0.0 11960.0 INR 3550.0 3550.0 6800.0 4 12516 2025-11-08 00:11:41 0 NULL 1 2025-11-08 00:12:01 1 0 NULL
88 98 POF-1088 INVF-1088 12530 12517 2 1 46 7446.4 0.0 148.93 503.74 503.74 0.0 7297.47 INR 2529.0 2529.0 2724.0 4 12530 2025-11-08 00:24:38 0 NULL 1 2025-11-08 00:24:54 12517 0 NULL
89 99 POF-1089 INVF-1089 12521 12517 2 1 96 26896.8 0.0 537.94 1327.64 1327.64 0.0 26358.86 INR 8255.0 8255.0 9255.0 4 12521 2025-11-08 00:35:07 0 NULL 1 2025-11-08 00:35:32 12517 0 NULL
90 100 POF-1090 INVF-1090 12527 12517 2 1 426 29379.2 0.0 587.58 1000.17 1000.17 0.0 28791.62 INR 8292.0 8292.0 9000.0 4 12527 2025-11-08 02:09:55 0 NULL 1 2025-11-08 02:13:10 12517 0 NULL
91 101 POF-1091 INVF-1091 12527 12517 2 1 214 72516.8 0.0 1450.34 2798.45 2798.45 0.0 71066.46 INR 25361.0 25361.0 25796.0 4 12527 2025-11-08 02:21:46 0 NULL 1 2025-11-08 02:22:54 12517 0 NULL
92 102 POF-1092 INVF-1092 12516 1 2 1 2795 749494.2 0.0 59959.54 33188.29 33188.29 0.0 689534.66 INR 236442.0 236442.0 237792.0 4 12516 2025-11-08 13:26:29 0 NULL 1 2025-11-08 13:27:54 1 0 NULL
93 103 POF-1093 INVF-1093 12526 12517 2 2 3 11995.2 0.0 239.9 285.6 285.6 0.0 11755.3 INR 0.0 3000.0 0.0 4 12526 2025-11-08 16:25:14 0 NULL 1 2025-11-08 16:55:55 12517 0 NULL
94 104 POF-1094 INVF-1094 12548 12517 2 1 60 16400.0 0.0 328.0 390.48 390.48 0.0 16072.0 INR 5900.0 5900.0 6650.0 4 12548 2025-11-08 16:46:05 0 NULL 1 2025-11-08 16:48:23 12517 0 NULL
95 105 POF-1095 INVF-1095 12532 12517 2 2 1 10499.0 0.0 209.98 249.97 249.97 0.0 10289.02 INR 0.0 3500.0 0.0 4 12532 2025-11-09 09:46:23 0 NULL 1 2025-11-09 19:01:05 12517 0 NULL
96 106 POF-1096 INVF-1096 12517 12516 2 1 1955 393665.8 0.0 19683.29 0.0 0.0 23614.21 373982.51 INR 113706.0 113706.0 115056.0 4 12517 2025-11-09 12:02:35 0 NULL 1 2025-11-09 12:18:03 12516 0 NULL
97 107 POF-1097 INVF-1097 12517 12516 2 1 823 348599.6 0.0 17429.98 0.0 0.0 42141.34 331169.62 INR 120085.0 120085.0 123085.0 4 12517 2025-11-09 12:31:27 0 NULL 1 2025-11-09 22:40:57 12516 0 NULL
98 108 POF-1098 INVF-1098 12516 1 2 1 12 10398.0 0.0 831.84 247.57 247.57 0.0 9566.16 INR 2750.0 2750.0 3000.0 4 12516 2025-11-09 13:31:28 0 NULL 1 2025-11-09 22:39:20 1 0 NULL
99 109 POF-1099 INVF-1099 12516 1 2 1 50 4000.0 0.0 320.0 95.24 95.24 0.0 3680.0 INR 1400.0 1400.0 1900.0 4 12516 2025-11-09 13:35:25 0 NULL 1 2025-11-09 22:37:31 1 0 NULL
100 110 POF-1100 INVF-1100 12516 1 2 1 50 4000.0 0.0 320.0 95.24 95.24 0.0 3680.0 INR 1400.0 1400.0 1900.0 4 12516 2025-11-09 13:37:52 0 NULL 1 2025-11-09 22:37:31 1 0 NULL