fx_franchise_order_product

4,933 rows · 33 columns · page 64 / 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
3151 3164 3 776 12546 24 Immunomax 24/7 Caps NULL 2009899 1 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 1499.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-01-16 22:27:40
3152 3165 4 776 12546 7 Morning Fresh Churan NULL 30049011 1 0.0 199.0 0.0 0.0 159.0 151.43 7.57 199.0 0.0 159.0 2.5 3.79 2.5 3.79 0.0 0.0 151.43 7.57 159.0 INR 3 2.0 3.03 2026-01-16 22:27:40
3153 3166 5 776 12546 32 Neem Soap 100gm NULL 34011110 1 0.0 60.0 0.0 0.0 48.0 45.71 2.29 60.0 0.0 48.0 2.5 1.14 2.5 1.14 0.0 0.0 45.71 2.29 48.0 INR 3 2.0 0.91 2026-01-16 22:27:40
3154 3167 6 776 12546 35 Sanitary Pad (15 pcs) NULL 9619001 1 0.0 380.0 0.0 0.0 304.0 304.0 0.0 380.0 0.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 304.0 INR 3 2.0 6.08 2026-01-16 22:27:40
3155 3168 7 776 12546 26 Spirulina Cap NULL 2009899 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-01-16 22:27:40
3156 3169 1 777 12546 32 Neem Soap 100gm NULL 34011110 84 0.0 60.0 0.0 0.0 48.0 45.71 2.29 5040.0 0.0 4032.0 2.5 96.0 2.5 96.0 0.0 0.0 3840.0 192.0 4032.0 INR 3 2.0 76.8 2026-01-16 22:42:08
3157 3170 1 778 12516 84 B AND B NULL 94041000 6 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 77994.0 0.0 63000.0 2.5 1500.0 2.5 1500.0 0.0 0.0 60000.0 3000.0 63000.0 INR 1 0.0 400.0 2026-01-16 23:00:58
3158 3171 1 779 12517 20 Premium Berry Juice 1000ml NULL 2936900 5 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 17495.0 0.0 13000.0 0.0 0.0 0.0 0.0 5.0 619.05 12380.95 619.05 13000.0 INR 2 6.0 742.86 2026-01-16 23:02:35
3159 3172 2 779 12517 84 B AND B NULL 94041000 4 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 51996.0 0.0 42000.0 0.0 0.0 0.0 0.0 5.0 2000.0 40000.0 2000.0 42000.0 INR 2 0.0 300.0 2026-01-16 23:02:35
3160 3173 1 780 13438 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-01-16 23:08:15
3161 3174 1 781 12554 84 B AND B NULL 94041000 2 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 25998.0 0.0 21000.0 2.5 500.0 2.5 500.0 0.0 0.0 20000.0 1000.0 21000.0 INR 2 0.0 300.0 2026-01-16 23:10:15
3162 3175 1 782 13536 33 Herbal Soap 100gm NULL 30049011 6 0.0 100.0 0.0 0.0 80.0 76.19 3.81 600.0 0.0 480.0 2.5 11.43 2.5 11.43 0.0 0.0 457.14 22.86 480.0 INR 3 2.0 9.14 2026-01-16 23:24:06
3163 3176 2 782 13536 32 Neem Soap 100gm NULL 34011110 7 0.0 60.0 0.0 0.0 48.0 45.71 2.29 420.0 0.0 336.0 2.5 8.0 2.5 8.0 0.0 0.0 320.0 16.0 336.0 INR 3 2.0 6.4 2026-01-16 23:24:06
3164 3177 3 782 13536 35 Sanitary Pad (15 pcs) NULL 9619001 1 0.0 380.0 0.0 0.0 304.0 304.0 0.0 380.0 0.0 304.0 0.0 0.0 0.0 0.0 0.0 0.0 304.0 0.0 304.0 INR 3 2.0 6.08 2026-01-16 23:24:06
3165 3178 1 783 13536 61 Radiation chip NULL 902221 2 0.0 999.0 0.0 0.0 500.0 423.73 76.27 1998.0 0.0 1000.0 9.0 76.27 9.0 76.27 0.0 0.0 847.46 152.54 1000.0 INR 3 2.0 16.95 2026-01-16 23:26:14
3166 3179 1 784 13536 46 Root Vitality Hair Oil NULL 3305901 2 0.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 0.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 388.57 19.43 408.0 INR 3 2.0 7.77 2026-01-16 23:30:01
3167 3180 1 785 12516 20 Premium Berry Juice 1000ml NULL 2936900 50 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 174950.0 0.0 130000.0 2.5 3095.24 2.5 3095.24 0.0 0.0 123809.52 6190.48 130000.0 INR 1 8.0 9904.76 2026-01-19 12:28:56
3168 3181 1 786 12516 19 Fat loss Juice 500 ml NULL 30049011 30 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 44970.0 0.0 36000.0 2.5 857.14 2.5 857.14 0.0 0.0 34285.71 1714.29 36000.0 INR 1 8.0 2742.86 2026-01-19 12:31:58
3169 3182 1 787 12517 27 Multicharge Cap NULL 2009899 15 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 22485.0 0.0 18000.0 0.0 0.0 0.0 0.0 5.0 857.14 17142.86 857.14 18000.0 INR 2 6.0 1028.57 2026-01-19 12:38:48
3170 3183 2 787 12517 20 Premium Berry Juice 1000ml NULL 2936900 15 0.0 3499.0 0.0 0.0 2600.0 2476.19 123.81 52485.0 0.0 39000.0 0.0 0.0 0.0 0.0 5.0 1857.14 37142.86 1857.14 39000.0 INR 2 6.0 2228.57 2026-01-19 12:38:48
3171 3184 3 787 12517 19 Fat loss Juice 500 ml NULL 30049011 15 0.0 1499.0 0.0 0.0 1200.0 1142.86 57.14 22485.0 0.0 18000.0 0.0 0.0 0.0 0.0 5.0 857.14 17142.86 857.14 18000.0 INR 2 6.0 1028.57 2026-01-19 12:38:48
3172 3185 4 787 12517 26 Spirulina Cap NULL 2009899 15 0.0 899.0 0.0 0.0 719.0 684.76 34.24 13485.0 0.0 10785.0 0.0 0.0 0.0 0.0 5.0 513.57 10271.43 513.57 10785.0 INR 2 6.0 616.29 2026-01-19 12:38:48
3173 3186 1 788 12516 44 Vital Glow Face Scrub NULL 3304300 20 0.0 325.0 0.0 0.0 260.0 220.34 39.66 6500.0 0.0 5200.0 9.0 396.61 9.0 396.61 0.0 0.0 4406.78 793.22 5200.0 INR 1 8.0 352.54 2026-01-19 14:51:47
3174 3187 1 789 12517 44 Vital Glow Face Scrub NULL 3304300 15 0.0 325.0 0.0 0.0 260.0 220.34 39.66 4875.0 0.0 3900.0 0.0 0.0 0.0 0.0 18.0 594.92 3305.09 594.92 3900.0 INR 2 6.0 198.31 2026-01-19 14:54:13
3175 3188 1 790 12529 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 2.5 250.0 2.5 250.0 0.0 0.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-19 14:57:39
3176 3189 1 791 12529 48 glow face wash NULL 3304999 1 0.0 380.0 0.0 0.0 304.0 257.63 46.37 380.0 0.0 304.0 9.0 23.19 9.0 23.19 0.0 0.0 257.63 46.37 304.0 INR 3 2.0 5.15 2026-01-19 15:00:04
3177 3190 2 791 12529 34 Herbo2o Toothpaste NULL 33061090 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-01-19 15:00:04
3178 3191 1 792 12528 39 Fabric Wash 1000ml NULL 3924101 6 0.0 401.0 0.0 0.0 321.0 272.03 48.97 2406.0 0.0 1926.0 9.0 146.9 9.0 146.9 0.0 0.0 1632.2 293.8 1926.0 INR 3 2.0 32.64 2026-01-19 15:15:09
3179 3192 2 792 12528 33 Herbal 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-01-19 15:15:09
3180 3193 3 792 12528 34 Herbo2o Toothpaste NULL 33061090 10 0.0 199.0 0.0 0.0 159.0 134.75 24.25 1990.0 0.0 1590.0 9.0 121.27 9.0 121.27 0.0 0.0 1347.46 242.54 1590.0 INR 3 2.0 26.95 2026-01-19 15:15:09
3181 3194 4 792 12528 30 Iron Capsules NULL 30049011 2 0.0 899.0 0.0 0.0 719.0 684.76 34.24 1798.0 0.0 1438.0 2.5 34.24 2.5 34.24 0.0 0.0 1369.52 68.48 1438.0 INR 3 2.0 27.39 2026-01-19 15:15:09
3182 3195 5 792 12528 16 Liver Care Juice NULL 2009899 2 0.0 349.0 0.0 0.0 279.0 265.71 13.29 698.0 0.0 558.0 2.5 13.29 2.5 13.29 0.0 0.0 531.43 26.57 558.0 INR 3 2.0 10.63 2026-01-19 15:15:09
3183 3196 6 792 12528 32 Neem Soap 100gm NULL 34011110 100 0.0 60.0 0.0 0.0 48.0 45.71 2.29 6000.0 0.0 4800.0 2.5 114.29 2.5 114.29 0.0 0.0 4571.43 228.57 4800.0 INR 3 2.0 91.43 2026-01-19 15:15:09
3184 3197 7 792 12528 9 Omega 369 NULL 2936900 4 0.0 999.0 0.0 0.0 720.0 685.71 34.29 3996.0 0.0 2880.0 2.5 68.57 2.5 68.57 0.0 0.0 2742.86 137.14 2880.0 INR 3 2.0 54.86 2026-01-19 15:15:09
3185 3198 8 792 12528 81 PREMIUM GLOW FACE WASH NULL 3404 4 0.0 699.0 0.0 0.0 559.0 512.84 46.16 2796.0 0.0 2236.0 4.5 92.31 4.5 92.31 0.0 0.0 2051.38 184.62 2236.0 INR 3 2.0 41.03 2026-01-19 15:15:09
3186 3199 9 792 12528 5 Thyro Care 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-01-19 15:15:09
3187 3200 10 792 12528 44 Vital Glow Face Scrub NULL 3304300 4 0.0 325.0 0.0 0.0 260.0 220.34 39.66 1300.0 0.0 1040.0 9.0 79.32 9.0 79.32 0.0 0.0 881.36 158.64 1040.0 INR 3 2.0 17.63 2026-01-19 15:15:09
3188 3201 1 793 12543 84 B AND B NULL 94041000 1 0.0 12999.0 0.0 0.0 10500.0 10000.0 500.0 12999.0 0.0 10500.0 2.5 250.0 2.5 250.0 0.0 0.0 10000.0 500.0 10500.0 INR 3 0.0 150.0 2026-01-19 19:13:18
3189 3202 2 793 12543 17 Memory Booster Juice NULL 2009899 2 0.0 349.0 0.0 0.0 279.0 265.71 13.29 698.0 0.0 558.0 2.5 13.29 2.5 13.29 0.0 0.0 531.43 26.57 558.0 INR 3 2.0 10.63 2026-01-19 19:13:18
3190 3203 1 794 12549 48 glow face wash NULL 3304999 3 0.0 380.0 0.0 0.0 304.0 257.63 46.37 1140.0 0.0 912.0 9.0 69.56 9.0 69.56 0.0 0.0 772.88 139.12 912.0 INR 3 2.0 15.46 2026-01-19 19:58:07
3191 3204 2 794 12549 34 Herbo2o Toothpaste NULL 33061090 4 0.0 199.0 0.0 0.0 159.0 134.75 24.25 796.0 0.0 636.0 9.0 48.51 9.0 48.51 0.0 0.0 538.98 97.02 636.0 INR 3 2.0 10.78 2026-01-19 19:58:07
3192 3205 3 794 12549 7 Morning Fresh Churan NULL 30049011 2 0.0 199.0 0.0 0.0 159.0 151.43 7.57 398.0 0.0 318.0 2.5 7.57 2.5 7.57 0.0 0.0 302.86 15.14 318.0 INR 3 2.0 6.06 2026-01-19 19:58:07
3193 3206 4 794 12549 12 P 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-01-19 19:58:07
3194 3207 5 794 12549 72 Pain Relief Patch NULL 30051090 2 0.0 800.0 0.0 0.0 600.0 571.43 28.57 1600.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-01-19 19:58:07
3195 3208 6 794 12549 8 Piles Care NULL 30049011 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-01-19 19:58:07
3196 3209 7 794 12549 41 Premium Coco Body Lotion NULL 3304300 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-01-19 19:58:07
3197 3210 8 794 12549 46 Root Vitality Hair Oil NULL 3305901 2 0.0 255.0 0.0 0.0 204.0 194.29 9.71 510.0 0.0 408.0 2.5 9.71 2.5 9.71 0.0 0.0 388.57 19.43 408.0 INR 3 2.0 7.77 2026-01-19 19:58:07
3198 3211 9 794 12549 11 SOUNDARYA VEDA BRINGARAJ & SHIKAKAI NULL 33051090 2 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 2500.0 0.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-01-19 19:58:07
3199 3212 10 794 12549 10 SOUNDARYA VEDA RADIANCE DAY CREAM NULL 33049910 2 0.0 1424.0 0.0 0.0 750.0 714.29 35.71 2848.0 0.0 1500.0 2.5 35.71 2.5 35.71 0.0 0.0 1428.57 71.43 1500.0 INR 3 2.0 28.57 2026-01-19 19:58:07
3200 3213 11 794 12549 50 Sun Screen NULL 330499 2 0.0 699.0 0.0 0.0 559.0 473.73 85.27 1398.0 0.0 1118.0 9.0 85.27 9.0 85.27 0.0 0.0 947.46 170.54 1118.0 INR 3 2.0 18.95 2026-01-19 19:58:07