fx_franchise_order

1,057 rows · 31 columns · page 15 / 22

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
701 921 POFN-1911 INVFN-1911 12517 12516 2 1 1 9900.0 0.0 503.39 0.0 0.0 1510.17 9900.0 INR 0.0 2.0 0.0 4 12517 2026-02-07 16:12:17 0 NULL 1 2026-02-07 16:21:59 12516 1 2026-02-07 16:21:59
702 922 POFN-1912 INVFN-1912 12517 12516 2 1 178 298876.0 0.0 17078.63 0.0 0.0 14232.19 298876.0 INR 0.0 56.0 0.0 4 12517 2026-02-07 16:19:38 0 NULL 1 2026-02-07 16:25:20 12516 1 2026-02-07 16:25:20
703 923 POFN-1913 INVFN-1913 12517 12516 2 1 533 28112.0 0.0 1606.4 0.0 0.0 1338.67 28112.0 INR 0.0 2.72 0.0 4 12517 2026-02-07 16:20:22 0 NULL 1 2026-02-07 16:21:49 12516 1 2026-02-07 16:21:49
704 924 POFN-1914 INVFN-1914 12517 12516 2 1 58 69600.0 0.0 3314.29 0.0 0.0 3314.29 69600.0 INR 0.0 14.4 0.0 4 12517 2026-02-07 16:21:22 0 NULL 1 2026-02-07 16:25:17 12516 1 2026-02-07 16:25:17
705 925 POFN-1915 INVFN-1915 12516 1 2 1 170 287060.0 0.0 21777.39 7421.28 7421.28 0.0 287060.0 INR 0.0 9.0 0.0 4 12516 2026-02-07 16:25:00 0 NULL 1 2026-02-07 16:25:08 1 1 2026-02-07 16:25:08
706 926 POFN-1916 INVFN-1916 12517 12516 2 1 37 9592.0 0.0 556.48 0.0 0.0 164.75 9592.0 INR 0.0 0.1 0.0 4 12517 2026-02-07 16:54:50 0 NULL 1 2026-02-07 16:55:02 12516 1 2026-02-07 16:55:02
707 927 POFN-1917 INVFN-1917 12685 12517 2 1 659 95587.0 0.0 1730.02 3907.29 3907.29 0.0 95587.0 INR 0.0 0.06 0.0 4 12685 2026-02-09 11:31:19 0 NULL 1 2026-02-09 11:39:15 12517 1 2026-02-09 11:39:15
708 928 POFN-1918 INVFN-1918 14569 12517 2 1 8 2522.0 0.0 48.23 55.22 55.22 0.0 2522.0 INR 0.0 0.1 0.0 4 14569 2026-02-09 12:23:47 0 NULL 1 2026-02-09 13:14:24 12517 1 2026-02-09 13:14:24
709 929 POFN-1919 INVFN-1919 12516 1 2 1 600 699800.0 0.0 53318.09 16661.9 16661.9 0.0 699800.0 INR 0.0 60.0 0.0 4 12516 2026-02-09 16:23:31 0 NULL 1 2026-02-09 16:23:44 1 1 2026-02-09 16:23:44
710 930 POFN-1920 INVFN-1920 12517 12516 2 1 300 349900.0 0.0 18565.71 0.0 0.0 16661.9 349900.0 INR 0.0 30.0 0.0 4 12517 2026-02-09 16:26:11 0 NULL 1 2026-02-09 16:26:58 12516 1 2026-02-09 16:26:58
711 931 POFN-1921 INVFN-1921 13438 12517 2 1 1 500.0 0.0 8.47 38.14 38.14 0.0 500.0 INR 0.0 0.1 0.0 4 13438 2026-02-10 11:28:57 0 NULL 1 2026-02-10 11:57:50 12517 1 2026-02-10 11:57:50
712 932 POFN-1922 INVFN-1922 13438 12517 2 1 1 750.0 0.0 12.71 57.2 57.2 0.0 750.0 INR 0.0 0.1 0.0 4 13438 2026-02-10 11:37:25 0 NULL 1 2026-02-10 11:57:50 12517 1 2026-02-10 11:57:50
713 933 POFN-1923 INVFN-1923 14569 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 14569 2026-02-10 13:07:20 0 NULL 1 2026-02-10 14:27:30 12517 1 2026-02-10 14:27:30
714 934 POFN-1924 INVFN-1924 14569 12517 2 1 14 1543.0 0.0 28.33 63.23 63.23 0.0 1543.0 INR 0.0 0.06 0.0 4 14569 2026-02-10 13:21:08 0 NULL 1 2026-02-10 14:27:30 12517 1 2026-02-10 14:27:30
715 935 POFN-1925 INVFN-1925 14569 12517 2 1 10 800.0 0.0 15.24 19.05 19.05 0.0 800.0 INR 0.0 0.09 0.0 4 14569 2026-02-10 13:22:19 0 NULL 1 2026-02-10 14:27:30 12517 1 2026-02-10 14:27:30
716 936 POFN-1926 INVFN-1926 12543 12517 2 1 19 6286.0 0.0 115.99 243.21 243.21 0.0 6286.0 INR 0.0 0.11 0.0 4 12543 2026-02-10 22:40:54 0 NULL 1 2026-02-11 07:27:43 12517 1 2026-02-11 07:27:43
717 937 POFN-1927 INVFN-1927 12545 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 12545 2026-02-11 11:33:57 0 NULL 1 2026-02-11 11:56:55 12517 1 2026-02-11 11:56:55
718 938 POFN-1928 INVFN-1928 12545 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 12545 2026-02-11 11:36:45 0 NULL 1 2026-02-11 11:56:55 12517 1 2026-02-11 11:56:55
719 939 POFN-1929 INVFN-1929 12544 12517 2 1 6 822.0 0.0 15.66 19.57 19.57 0.0 822.0 INR 0.0 0.08 0.0 4 12544 2026-02-11 11:49:49 0 NULL 1 2026-02-11 11:56:55 12517 1 2026-02-11 11:56:55
720 940 POFN-1930 INVFN-1930 14569 12517 2 1 4 2528.0 0.0 48.15 60.19 60.19 0.0 2528.0 INR 0.0 0.25 0.0 4 14569 2026-02-11 12:41:18 0 NULL 1 2026-02-11 12:52:31 12517 1 2026-02-11 12:52:31
721 941 POFN-1931 INVFN-1931 12555 12554 2 1 3 4320.0 0.0 2.0 102.86 102.86 0.0 4320.0 INR 0.0 0.87 0.0 4 12555 2026-02-11 13:32:24 0 NULL 1 2026-02-11 13:32:40 12554 1 2026-02-11 13:32:40
722 942 POFN-1932 INVFN-1932 12554 12516 2 1 150 174950.0 0.0 9282.86 4165.48 4165.48 0.0 174950.0 INR 0.0 15.0 0.0 4 12554 2026-02-11 15:53:50 0 NULL 2 2026-02-11 15:55:48 12516 0 NULL
723 943 POFN-1933 INVFN-1933 12554 12516 2 1 60 69980.0 0.0 3713.14 1666.19 1666.19 0.0 69980.0 INR 0.0 6.0 0.0 4 12554 2026-02-11 15:56:50 0 NULL 1 2026-02-11 15:57:07 12516 1 2026-02-11 15:57:07
724 944 POFN-1934 INVFN-1934 12555 12554 2 1 30 34990.0 0.0 666.48 833.1 833.1 0.0 34990.0 INR 0.0 3.0 0.0 4 12555 2026-02-11 15:57:49 0 NULL 1 2026-02-11 15:58:09 12554 1 2026-02-11 15:58:09
725 945 POFN-1935 INVFN-1935 14569 12517 2 1 4 2142.0 0.0 37.82 125.6 125.6 0.0 2142.0 INR 0.0 0.11 0.0 4 14569 2026-02-11 18:01:01 0 NULL 1 2026-02-12 08:56:08 12517 1 2026-02-12 08:56:08
726 946 POFN-1936 INVFN-1936 14569 12517 2 1 1 159.0 0.0 2.69 12.13 12.13 0.0 159.0 INR 0.0 0.02 0.0 4 14569 2026-02-11 19:26:04 0 NULL 1 2026-02-12 08:56:08 12517 1 2026-02-12 08:56:08
727 947 POFN-1937 INVFN-1937 13836 12517 2 1 5 1967.0 0.0 36.46 72.02 72.02 0.0 1967.0 INR 0.0 0.02 0.0 4 13836 2026-02-12 15:19:05 0 NULL 1 2026-02-12 15:21:21 12517 1 2026-02-12 15:21:21
728 948 POFN-1938 INVFN-1938 14569 12517 2 1 4 448.0 0.0 8.82 3.43 3.43 0.0 448.0 INR 0.0 0.05 0.0 4 14569 2026-02-12 20:18:43 0 NULL 1 2026-02-13 06:44:19 12517 1 2026-02-13 06:44:19
729 949 POFN-1939 INVFN-1939 12521 12517 2 1 13 1425.0 0.0 24.96 88.54 88.54 0.0 1425.0 INR 0.0 0.02 0.0 4 12521 2026-02-13 14:18:36 0 NULL 1 2026-02-13 14:26:55 12517 1 2026-02-13 14:26:55
730 950 POFN-1940 INVFN-1940 12546 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 12546 2026-02-13 15:07:59 0 NULL 1 2026-02-13 15:09:57 12517 1 2026-02-13 15:09:57
731 951 POFN-1941 INVFN-1941 12545 12517 2 1 8 2573.0 0.0 44.78 166.92 166.92 0.0 2573.0 INR 0.0 0.02 0.0 4 12545 2026-02-13 15:32:07 0 NULL 1 2026-02-13 15:44:53 12517 1 2026-02-13 15:44:53
732 952 POFN-1942 INVFN-1942 12546 12517 2 1 2 1438.0 0.0 27.39 34.24 34.24 0.0 1438.0 INR 0.0 0.3 0.0 4 12546 2026-02-13 15:51:51 0 NULL 1 2026-02-13 15:58:37 12517 1 2026-02-13 15:58:37
733 953 POFN-1943 INVFN-1943 14569 12517 2 1 3 2198.0 0.0 41.87 52.33 52.33 0.0 2198.0 INR 0.0 0.2 0.0 4 14569 2026-02-13 16:07:07 0 NULL 1 2026-02-13 16:29:58 12517 1 2026-02-13 16:29:58
734 954 POFN-1944 INVFN-1944 14569 12517 2 1 2 2499.0 0.0 47.6 59.5 59.5 0.0 2499.0 INR 0.0 0.1 0.0 4 14569 2026-02-13 16:10:33 0 NULL 1 2026-02-13 16:29:58 12517 1 2026-02-13 16:29:58
735 955 POFN-1945 INVFN-1945 14569 12517 2 1 2 441.0 0.0 7.47 33.64 33.64 0.0 441.0 INR 0.0 0.01 0.0 4 14569 2026-02-13 16:22:29 0 NULL 1 2026-02-13 16:29:58 12517 1 2026-02-13 16:29:58
736 956 POFN-1946 INVFN-1946 12526 12517 2 1 240 54713.0 0.0 1011.4 2071.57 2071.57 0.0 54713.0 INR 0.0 0.1 0.0 4 12526 2026-02-13 17:48:09 0 NULL 2 2026-02-13 21:11:48 12517 0 NULL
737 957 POFN-1947 INVFN-1947 12546 12517 2 1 57 3343.0 0.0 62.03 120.73 120.73 0.0 3343.0 INR 0.0 0.06 0.0 4 12546 2026-02-13 18:24:00 0 NULL 1 2026-02-13 18:26:20 12517 1 2026-02-13 18:26:20
738 958 POFN-1948 INVFN-1948 12526 12517 2 1 2 4600.0 0.0 87.62 109.52 109.52 0.0 4600.0 INR 0.0 0.4 0.0 4 12526 2026-02-13 21:30:14 0 NULL 2 2026-02-13 21:30:56 12517 0 NULL
739 959 POFN-1949 INVFN-1949 12526 12517 2 1 235 53193.0 0.0 985.63 1955.64 1955.64 0.0 53193.0 INR 0.0 0.1 0.0 4 12526 2026-02-13 21:38:45 0 NULL 1 2026-02-13 21:39:28 12517 1 2026-02-13 21:39:28
740 960 POFN-1950 INVFN-1950 12526 12517 2 1 3 2998.0 0.0 57.1 71.38 71.38 0.0 2998.0 INR 0.0 0.2 0.0 4 12526 2026-02-13 21:57:11 0 NULL 1 2026-02-13 21:58:28 12517 1 2026-02-13 21:58:28
741 961 POFN-1951 INVFN-1951 12546 12517 2 1 6 7200.0 0.0 137.14 171.43 171.43 0.0 7200.0 INR 0.0 0.75 0.0 4 12546 2026-02-13 23:20:27 0 NULL 1 2026-02-13 23:21:16 12517 1 2026-02-13 23:21:16
742 962 POFN-1952 INVFN-1952 12541 12517 2 1 62 8299.0 0.0 148.22 444.06 444.06 0.0 8299.0 INR 0.0 0.1 0.0 4 12541 2026-02-14 18:04:42 0 NULL 1 2026-02-14 19:56:40 12517 1 2026-02-14 19:56:40
743 963 POFN-1953 INVFN-1953 12542 12554 2 1 8 63840.0 0.0 1239.61 0.0 0.0 1859.42 63840.0 INR 0.0 16.0 0.0 4 12542 2026-02-16 15:02:31 0 NULL 1 2026-02-16 15:03:57 12554 1 2026-02-16 15:03:57
744 964 POFN-1954 INVFN-1954 12554 12516 2 1 10 79800.0 0.0 4648.54 1162.14 1162.14 0.0 79800.0 INR 0.0 20.0 0.0 4 12554 2026-02-16 15:03:21 0 NULL 1 2026-02-16 15:03:37 12516 1 2026-02-16 15:03:37
745 965 POFN-1955 INVFN-1955 12542 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 12542 2026-02-16 15:06:32 0 NULL 1 2026-02-16 15:06:50 12517 1 2026-02-16 15:06:50
746 966 POFN-1956 INVFN-1956 12545 12517 2 1 36 7735.0 0.0 141.78 322.88 322.88 0.0 7735.0 INR 0.0 0.22 0.0 4 12545 2026-02-17 21:26:21 0 NULL 1 2026-02-17 21:37:47 12517 1 2026-02-17 21:37:47
747 967 POFN-1957 INVFN-1957 12545 12517 2 1 13 7791.0 0.0 143.71 302.8 302.8 0.0 7791.0 INR 0.0 0.22 0.0 4 12545 2026-02-18 22:10:34 0 NULL 1 2026-02-18 22:14:06 12517 1 2026-02-18 22:13:44
748 968 POFN-1958 INVFN-1958 12545 12517 2 1 1 48.0 0.0 0.91 1.14 1.14 0.0 48.0 INR 0.0 0.01 0.0 4 12545 2026-02-19 09:59:47 0 NULL 1 2026-02-19 10:02:10 12517 1 2026-02-19 10:02:10
749 969 POFN-1959 INVFN-1959 13438 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 13438 2026-02-19 17:23:59 0 NULL 1 2026-02-19 18:01:29 12517 1 2026-02-19 18:01:29
750 970 POFN-1960 INVFN-1960 13438 12517 2 1 14 5428.0 0.0 56.34 212.65 212.65 0.0 5428.0 INR 0.0 0.5 0.0 4 13438 2026-02-19 17:28:17 0 NULL 1 2026-02-19 18:17:59 12517 1 2026-02-19 18:17:59