fx_franchise_order_product

4,933 rows · 33 columns · page 82 / 99

Invoice view Excel export
# id sr_no order_id userid product_id product_name prod_desc hsn_no product_qty product_bv product_MRP discount_per discount_amount prod_dis_amt prod_before_gst_amt prod_gst_amount total_mrp total_bv total_price cgst_per cgst_amount sgst_per sgst_amount igst_per igst_amount total_before_gst_amount total_gst_amount final_amount _currency fr_category comm_per comm_amount created_on
4051 4064 1 989 12521 20 Premium Berry Juice 1000ml NULL 2936900 1 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 3499.0 0.0 2600.0 2.5 61.9 2.5 61.9 0.0 0.0 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-03-01 15:08:20
4052 4065 2 989 12521 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-03-01 15:08:20
4053 4066 3 989 12521 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-03-01 15:08:20
4054 4067 1 990 12545 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-03-01 16:14:20
4055 4068 2 990 12545 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-03-01 16:14:20
4056 4069 1 991 12526 93 FAMILY WELLNESS PACKAGE NULL NULL 2 0.0 26000.0 0.0 0.0 18750.0 17857.14 892.86 52000.0 0.0 37500.0 2.5 892.86 2.5 892.86 0.0 0.0 35714.29 1785.71 37500.0 INR 3 2.0 714.29 2026-03-01 16:47:37
4057 4070 1 992 12526 46 Root Vitality Hair Oil NULL 3305901 10 0.0 255.0 0.0 0.0 204.0 194.29 9.71 2550.0 0.0 2040.0 2.5 48.57 2.5 48.57 0.0 0.0 1942.86 97.14 2040.0 INR 3 2.0 38.86 2026-03-01 16:48:52
4058 4071 1 993 12523 20 Premium Berry Juice 1000ml NULL 2936900 1 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 3499.0 0.0 2600.0 2.5 61.9 2.5 61.9 0.0 0.0 2476.19 123.81 2600.0 INR 3 2.0 49.52 2026-03-01 18:15:27
4059 4072 2 993 12523 82 ALKALINE CAPSULE NULL 3402000 1 0.0 2500.0 0.0 0.0 2000.0 1904.76 95.24 2500.0 0.0 2000.0 2.5 47.62 2.5 47.62 0.0 0.0 1904.76 95.24 2000.0 INR 3 2.0 38.1 2026-03-01 18:15:27
4060 4073 3 993 12523 52 Bhoo sanjeevni 5 kg NULL 3103100 2 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 3200.0 0.0 2500.0 2.5 59.52 2.5 59.52 0.0 0.0 2380.95 119.05 2500.0 INR 3 2.0 47.62 2026-03-01 18:15:27
4061 4074 4 993 12523 4 Diabetic Care Capsules NULL 2936900 1 0.0 999.0 0.0 0.0 720.0 685.71 34.29 999.0 0.0 720.0 2.5 17.14 2.5 17.14 0.0 0.0 685.71 34.29 720.0 INR 3 2.0 13.71 2026-03-01 18:15:27
4062 4075 5 993 12523 18 Lady Care Juice 500ml NULL 2009899 2 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 2998.0 0.0 2400.0 2.5 57.14 2.5 57.14 0.0 0.0 2285.71 114.29 2400.0 INR 3 2.0 45.71 2026-03-01 18:15:27
4063 4076 6 993 12523 7 Morning Fresh Churan NULL 30049011 15 0.0 199.0 0.0 0.0 159.0 151.43 7.57 2985.0 0.0 2385.0 2.5 56.79 2.5 56.79 0.0 0.0 2271.43 113.57 2385.0 INR 3 2.0 45.43 2026-03-01 18:15:27
4064 4077 7 993 12523 32 Neem Soap 100gm NULL 34011110 75 0.0 60.0 0.0 0.0 48.0 45.71 2.29 4500.0 0.0 3600.0 2.5 85.71 2.5 85.71 0.0 0.0 3428.57 171.43 3600.0 INR 3 2.0 68.57 2026-03-01 18:15:27
4065 4078 8 993 12523 47 Premium Hair Care Shampoo NULL 3305109 1 0.0 699.0 0.0 0.0 559.0 532.38 26.62 699.0 0.0 559.0 2.5 13.31 2.5 13.31 0.0 0.0 532.38 26.62 559.0 INR 3 2.0 10.65 2026-03-01 18:15:27
4066 4079 9 993 12523 12 PREMIUM RADIANCE FACE SERUM NULL 33049990 1 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 1250.0 0.0 750.0 2.5 17.86 2.5 17.86 0.0 0.0 714.29 35.71 750.0 INR 3 2.0 14.29 2026-03-01 18:15:27
4067 4080 10 993 12523 43 Quench Kiss Lip Balm NULL 3304300 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-03-01 18:15:27
4068 4081 11 993 12523 10 RADIANCE GLOW DAY CREAM NULL 33049900 1 0.0 1424.0 0.0 0.0 750.0 635.59 114.41 1424.0 0.0 750.0 9.0 57.2 9.0 57.2 0.0 0.0 635.59 114.41 750.0 INR 3 2.0 12.71 2026-03-01 18:15:27
4069 4082 12 993 12523 50 Sun Screen NULL 330499 7 0.0 699.0 0.0 0.0 559.0 473.73 85.27 4893.0 0.0 3913.0 9.0 298.45 9.0 298.45 0.0 0.0 3316.1 596.9 3913.0 INR 3 2.0 66.32 2026-03-01 18:15:27
4070 4083 13 993 12523 36 Toilet Cleaner 500ml NULL 3924101 7 0.0 150.0 0.0 0.0 120.0 101.69 18.31 1050.0 0.0 840.0 9.0 64.07 9.0 64.07 0.0 0.0 711.86 128.14 840.0 INR 3 2.0 14.24 2026-03-01 18:15:27
4071 4084 14 993 12523 34 Toothpaste NULL 33061090 15 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2985.0 0.0 2385.0 9.0 181.91 9.0 181.91 0.0 0.0 2021.19 363.81 2385.0 INR 3 2.0 40.42 2026-03-01 18:15:27
4072 4085 15 993 12523 44 Vital Glow Face Scrub NULL 3304300 10 0.0 325.0 0.0 0.0 260.0 220.34 39.66 3250.0 0.0 2600.0 9.0 198.31 9.0 198.31 0.0 0.0 2203.39 396.61 2600.0 INR 3 2.0 44.07 2026-03-01 18:15:27
4073 4086 1 994 12526 92 MANIRAYA DOUBLE WELLNESS COMBO NULL NULL 1 0.0 34001.0 0.0 0.0 18500.0 17619.05 880.95 34001.0 0.0 18500.0 2.5 440.48 2.5 440.48 0.0 0.0 17619.05 880.95 18500.0 INR 3 2.0 352.38 2026-03-01 21:17:34
4074 4087 1 995 12526 6 Asthma Care NULL 30049011 1 0.0 899.0 0.0 0.0 719.0 684.76 34.24 899.0 0.0 719.0 2.5 17.12 2.5 17.12 0.0 0.0 684.76 34.24 719.0 INR 3 2.0 13.7 2026-03-01 21:20:53
4075 4088 2 995 12526 52 Bhoo sanjeevni 5 kg NULL 3103100 2 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 3200.0 0.0 2500.0 2.5 59.52 2.5 59.52 0.0 0.0 2380.95 119.05 2500.0 INR 3 2.0 47.62 2026-03-01 21:20:53
4076 4089 3 995 12526 53 Terra care 2 kg NULL 3103100 2 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 3000.0 0.0 2300.0 2.5 54.76 2.5 54.76 0.0 0.0 2190.48 109.52 2300.0 INR 3 2.0 43.81 2026-03-01 21:20:53
4077 4090 1 996 12517 46 Root Vitality Hair Oil NULL 3305901 100 0.0 255.0 0.0 0.0 204.0 194.29 9.71 25500.0 0.0 20400.0 0.0 0.0 0.0 0.0 5.0 971.43 19428.57 971.43 20400.0 INR 2 6.0 1165.71 2026-03-02 12:33:58
4078 4091 1 997 12516 46 Root Vitality Hair Oil NULL 3305901 100 0.0 255.0 0.0 0.0 204.0 194.29 9.71 25500.0 0.0 20400.0 2.5 485.71 2.5 485.71 0.0 0.0 19428.57 971.43 20400.0 INR 1 8.0 1554.29 2026-03-02 12:34:19
4079 4092 1 998 12539 3 BP Care Capsules NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-03-02 13:41:09
4080 4093 2 998 12539 4 Diabetic Care Capsules NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-03-02 13:41:09
4081 4094 3 998 12539 38 Dish Wash 500ml NULL 34029099 2 0.0 230.0 0.0 0.0 184.0 155.93 28.07 460.0 0.0 368.0 9.0 28.07 9.0 28.07 0.0 0.0 311.86 56.14 368.0 INR 3 2.0 6.24 2026-03-02 13:41:09
4082 4095 4 998 12539 37 Floor Cleaner 500ml NULL 3924101 2 0.0 199.0 0.0 0.0 159.0 134.75 24.25 398.0 0.0 318.0 9.0 24.25 9.0 24.25 0.0 0.0 269.49 48.51 318.0 INR 3 2.0 5.39 2026-03-02 13:41:09
4083 4096 5 998 12539 33 HALDI CHANDAN SOAP 100gm NULL 30049011 11 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1100.0 0.0 880.0 2.5 20.95 2.5 20.95 0.0 0.0 838.1 41.9 880.0 INR 3 2.0 16.76 2026-03-02 13:41:09
4084 4097 6 998 12539 25 Manicalcium Tablets NULL 2009899 1 0.0 399.0 0.0 0.0 319.0 303.81 15.19 399.0 0.0 319.0 2.5 7.6 2.5 7.6 0.0 0.0 303.81 15.19 319.0 INR 3 2.0 6.08 2026-03-02 13:41:09
4085 4098 7 998 12539 32 Neem Soap 100gm NULL 34011110 40 0.0 60.0 0.0 0.0 48.0 45.71 2.29 2400.0 0.0 1920.0 2.5 45.71 2.5 45.71 0.0 0.0 1828.57 91.43 1920.0 INR 3 2.0 36.57 2026-03-02 13:41:09
4086 4099 8 998 12539 9 Omega 369 NULL 2936900 2 0.0 999.0 0.0 0.0 720.0 685.71 34.29 1998.0 0.0 1440.0 2.5 34.29 2.5 34.29 0.0 0.0 1371.43 68.57 1440.0 INR 3 2.0 27.43 2026-03-02 13:41:09
4087 4100 9 998 12539 94 PAVANA DROPS NULL 30041211 1 0.0 699.0 0.0 0.0 499.0 475.24 23.76 699.0 0.0 499.0 2.5 11.88 2.5 11.88 0.0 0.0 475.24 23.76 499.0 INR 3 2.0 9.5 2026-03-02 13:41:09
4088 4101 10 998 12539 46 Root Vitality Hair Oil NULL 3305901 23 0.0 255.0 0.0 0.0 204.0 194.29 9.71 5865.0 0.0 4692.0 2.5 111.71 2.5 111.71 0.0 0.0 4468.57 223.43 4692.0 INR 3 2.0 89.37 2026-03-02 13:41:09
4089 4102 11 998 12539 50 Sun Screen NULL 330499 1 0.0 699.0 0.0 0.0 559.0 473.73 85.27 699.0 0.0 559.0 9.0 42.64 9.0 42.64 0.0 0.0 473.73 85.27 559.0 INR 3 2.0 9.47 2026-03-02 13:41:09
4090 4103 12 998 12539 36 Toilet Cleaner 500ml NULL 3924101 2 0.0 150.0 0.0 0.0 120.0 101.69 18.31 300.0 0.0 240.0 9.0 18.31 9.0 18.31 0.0 0.0 203.39 36.61 240.0 INR 3 2.0 4.07 2026-03-02 13:41:09
4091 4104 13 998 12539 34 Toothpaste NULL 33061090 23 0.0 199.0 0.0 0.0 159.0 134.75 24.25 4577.0 0.0 3657.0 9.0 278.92 9.0 278.92 0.0 0.0 3099.15 557.85 3657.0 INR 3 2.0 61.98 2026-03-02 13:41:09
4092 4105 1 999 14569 52 Bhoo sanjeevni 5 kg NULL 3103100 1 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 1600.0 0.0 1250.0 2.5 29.76 2.5 29.76 0.0 0.0 1190.48 59.52 1250.0 INR 3 2.0 23.81 2026-03-02 21:43:18
4093 4106 2 999 14569 33 HALDI CHANDAN SOAP 100gm NULL 30049011 10 0.0 100.0 0.0 0.0 80.0 76.19 3.81 1000.0 0.0 800.0 2.5 19.05 2.5 19.05 0.0 0.0 761.9 38.1 800.0 INR 3 2.0 15.24 2026-03-02 21:43:18
4094 4107 3 999 14569 32 Neem Soap 100gm NULL 34011110 8 0.0 60.0 0.0 0.0 48.0 45.71 2.29 480.0 0.0 384.0 2.5 9.14 2.5 9.14 0.0 0.0 365.71 18.29 384.0 INR 3 2.0 7.31 2026-03-02 21:43:18
4095 4108 4 999 14569 53 Terra care 2 kg NULL 3103100 1 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 1500.0 0.0 1150.0 2.5 27.38 2.5 27.38 0.0 0.0 1095.24 54.76 1150.0 INR 3 2.0 21.9 2026-03-02 21:43:18
4096 4109 1 1000 12521 52 Bhoo sanjeevni 5 kg NULL 3103100 3 0.0 1600.0 0.0 0.0 1250.0 1190.48 59.52 4800.0 0.0 3750.0 2.5 89.29 2.5 89.29 0.0 0.0 3571.43 178.57 3750.0 INR 3 2.0 71.43 2026-03-02 23:03:40
4097 4110 2 1000 12521 58 Green shield 250ml NULL 3105 1 0.0 2500.0 0.0 0.0 1850.0 1761.9 88.1 2500.0 0.0 1850.0 2.5 44.05 2.5 44.05 0.0 0.0 1761.9 88.1 1850.0 INR 3 2.0 35.24 2026-03-02 23:03:40
4098 4111 3 1000 12521 53 Terra care 2 kg NULL 3103100 2 0.0 1500.0 0.0 0.0 1150.0 1095.24 54.76 3000.0 0.0 2300.0 2.5 54.76 2.5 54.76 0.0 0.0 2190.48 109.52 2300.0 INR 3 2.0 43.81 2026-03-02 23:03:40
4099 4112 4 1000 12521 54 Wonder grow 100ml NULL 3105 1 0.0 1400.0 0.0 0.0 1200.0 1142.86 57.14 1400.0 0.0 1200.0 2.5 28.57 2.5 28.57 0.0 0.0 1142.86 57.14 1200.0 INR 3 2.0 22.86 2026-03-02 23:03:40
4100 4113 1 1001 14079 60 Foot patch NULL 30051090 1 0.0 1999.0 0.0 0.0 1599.0 1522.86 76.14 1999.0 0.0 1599.0 2.5 38.07 2.5 38.07 0.0 0.0 1522.86 76.14 1599.0 INR 3 2.0 30.46 2026-03-03 12:47:39