fx_franchise_order_product

4,933 rows · 33 columns · page 62 / 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
3051 3064 6 749 13438 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-16 12:14:48
3052 3065 7 749 13438 34 Herbo2o 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-01-16 12:14:48
3053 3066 8 749 13438 12 P RADIANCE FACE SERUM NULL 33049990 4 0.0 1250.0 0.0 0.0 750.0 714.29 35.71 5000.0 0.0 3000.0 2.5 71.43 2.5 71.43 0.0 0.0 2857.14 142.86 3000.0 INR 3 2.0 57.14 2026-01-16 12:14:48
3054 3067 9 749 13438 43 Quench Kiss Lip Balm NULL 3304300 12 0.0 199.0 0.0 0.0 159.0 134.75 24.25 2388.0 0.0 1908.0 9.0 145.53 9.0 145.53 0.0 0.0 1616.95 291.05 1908.0 INR 3 2.0 32.34 2026-01-16 12:14:48
3055 3068 10 749 13438 35 Sanitary Pad (15 pcs) NULL 9619001 3 0.0 380.0 0.0 0.0 304.0 304.0 0.0 1140.0 0.0 912.0 0.0 0.0 0.0 0.0 0.0 0.0 912.0 0.0 912.0 INR 3 2.0 18.24 2026-01-16 12:14:48
3056 3069 11 749 13438 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 12:14:48
3057 3070 12 749 13438 50 Sun Screen NULL 330499 3 0.0 699.0 0.0 0.0 559.0 473.73 85.27 2097.0 0.0 1677.0 9.0 127.91 9.0 127.91 0.0 0.0 1421.19 255.81 1677.0 INR 3 2.0 28.42 2026-01-16 12:14:48
3058 3071 13 749 13438 36 Toilet Cleaner 500ml NULL 3924101 1 0.0 150.0 0.0 0.0 120.0 101.69 18.3 150.0 0.0 120.0 9.0 9.15 9.0 9.15 0.0 0.0 101.69 18.3 120.0 INR 3 2.0 2.03 2026-01-16 12:14:48
3059 3072 1 750 13836 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 12:52:34
3060 3073 2 750 13836 30 Iron Capsules 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-01-16 12:52:34
3061 3074 3 750 13836 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-01-16 12:52:34
3062 3075 4 750 13836 9 Omega 369 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-16 12:52:34
3063 3076 5 750 13836 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 12:52:34
3064 3077 1 751 12527 48 glow face wash NULL 3304999 2 0.0 380.0 0.0 0.0 304.0 257.63 46.37 760.0 0.0 608.0 9.0 46.37 9.0 46.37 0.0 0.0 515.25 92.75 608.0 INR 3 2.0 10.31 2026-01-16 12:58:14
3065 3078 2 751 12527 39 Fabric Wash 1000ml NULL 3924101 20 0.0 401.0 0.0 0.0 321.0 272.03 48.97 8020.0 0.0 6420.0 9.0 489.66 9.0 489.66 0.0 0.0 5440.68 979.32 6420.0 INR 3 2.0 108.81 2026-01-16 12:58:14
3066 3079 3 751 12527 37 Floor Cleaner 500ml NULL 3924101 20 0.0 199.0 0.0 0.0 159.0 134.75 24.25 3980.0 0.0 3180.0 9.0 242.54 9.0 242.54 0.0 0.0 2694.92 485.08 3180.0 INR 3 2.0 53.9 2026-01-16 12:58:14
3067 3080 4 751 12527 34 Herbo2o Toothpaste NULL 33061090 30 0.0 199.0 0.0 0.0 159.0 134.75 24.25 5970.0 0.0 4770.0 9.0 363.81 9.0 363.81 0.0 0.0 4042.37 727.63 4770.0 INR 3 2.0 80.85 2026-01-16 12:58:14
3068 3081 5 751 12527 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-01-16 12:58:14
3069 3082 6 751 12527 35 Sanitary Pad (15 pcs) NULL 9619001 20 0.0 380.0 0.0 0.0 304.0 304.0 0.0 7600.0 0.0 6080.0 0.0 0.0 0.0 0.0 0.0 0.0 6080.0 0.0 6080.0 INR 3 2.0 121.6 2026-01-16 12:58:14
3070 3083 7 751 12527 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-16 12:58:14
3071 3084 8 751 12527 36 Toilet Cleaner 500ml NULL 3924101 30 0.0 150.0 0.0 0.0 120.0 101.69 18.31 4500.0 0.0 3600.0 9.0 274.58 9.0 274.58 0.0 0.0 3050.85 549.15 3600.0 INR 3 2.0 61.02 2026-01-16 12:58:14
3072 3085 9 751 12527 44 Vital Glow Face Scrub NULL 3304300 5 0.0 325.0 0.0 0.0 260.0 220.34 39.66 1625.0 0.0 1300.0 9.0 99.15 9.0 99.15 0.0 0.0 1101.69 198.31 1300.0 INR 3 2.0 22.03 2026-01-16 12:58:14
3073 3086 1 752 12525 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-16 13:31:06
3074 3087 2 752 12525 27 Multicharge Cap 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 13:31:06
3075 3088 3 752 12525 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-01-16 13:31:06
3076 3089 4 752 12525 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-01-16 13:31:06
3077 3090 1 753 12541 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-16 13:50:17
3078 3091 2 753 12541 39 Fabric Wash 1000ml NULL 3924101 2 0.0 401.0 0.0 0.0 321.0 272.03 48.97 802.0 0.0 642.0 9.0 48.97 9.0 48.97 0.0 0.0 544.07 97.93 642.0 INR 3 2.0 10.88 2026-01-16 13:50:17
3079 3092 3 753 12541 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-16 13:50:17
3080 3093 4 753 12541 34 Herbo2o Toothpaste NULL 33061090 3 0.0 199.0 0.0 0.0 159.0 134.75 24.25 597.0 0.0 477.0 9.0 36.38 9.0 36.38 0.0 0.0 404.24 72.76 477.0 INR 3 2.0 8.08 2026-01-16 13:50:17
3081 3094 5 753 12541 32 Neem Soap 100gm NULL 34011110 35 0.0 60.0 0.0 0.0 48.0 45.71 2.29 2100.0 0.0 1680.0 2.5 40.0 2.5 40.0 0.0 0.0 1600.0 80.0 1680.0 INR 3 2.0 32.0 2026-01-16 13:50:17
3082 3095 6 753 12541 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-01-16 13:50:17
3083 3096 7 753 12541 43 Quench Kiss Lip Balm NULL 3304300 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-16 13:50:17
3084 3097 8 753 12541 1 Stem Cell Powder NULL 2936900 1 0.0 2499.0 0.0 0.0 1999.0 1903.81 95.19 2499.0 0.0 1999.0 2.5 47.6 2.5 47.6 0.0 0.0 1903.81 95.19 1999.0 INR 3 2.0 38.08 2026-01-16 13:50:17
3085 3098 9 753 12541 36 Toilet Cleaner 500ml NULL 3924101 3 0.0 150.0 0.0 0.0 120.0 101.69 18.31 450.0 0.0 360.0 9.0 27.46 9.0 27.46 0.0 0.0 305.08 54.92 360.0 INR 3 2.0 6.1 2026-01-16 13:50:17
3086 3099 10 753 12541 44 Vital Glow Face Scrub NULL 3304300 1 0.0 325.0 0.0 0.0 260.0 220.34 39.66 325.0 0.0 260.0 9.0 19.83 9.0 19.83 0.0 0.0 220.34 39.66 260.0 INR 3 2.0 4.41 2026-01-16 13:50:17
3087 3100 1 754 12541 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-16 13:54:30
3088 3101 2 754 12541 37 Floor Cleaner 500ml NULL 3924101 1 0.0 199.0 0.0 0.0 159.0 134.75 24.25 199.0 0.0 159.0 9.0 12.13 9.0 12.13 0.0 0.0 134.75 24.25 159.0 INR 3 2.0 2.69 2026-01-16 13:54:30
3089 3102 3 754 12541 32 Neem Soap 100gm NULL 34011110 10 0.0 60.0 0.0 0.0 48.0 45.71 2.29 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 13:54:30
3090 3103 4 754 12541 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-01-16 13:54:30
3091 3104 5 754 12541 44 Vital Glow Face Scrub NULL 3304300 1 0.0 325.0 0.0 0.0 260.0 220.34 39.66 325.0 0.0 260.0 9.0 19.83 9.0 19.83 0.0 0.0 220.34 39.66 260.0 INR 3 2.0 4.41 2026-01-16 13:54:30
3092 3105 1 755 14323 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-16 15:17:08
3093 3106 1 756 13836 38 Dish Wash 500ml NULL 3924101 4 0.0 230.0 0.0 0.0 184.0 155.93 28.07 920.0 0.0 736.0 9.0 56.14 9.0 56.14 0.0 0.0 623.73 112.27 736.0 INR 3 2.0 12.47 2026-01-16 15:34:09
3094 3107 2 756 13836 39 Fabric Wash 1000ml NULL 3924101 1 0.0 401.0 0.0 0.0 321.0 272.03 48.97 401.0 0.0 321.0 9.0 24.48 9.0 24.48 0.0 0.0 272.03 48.97 321.0 INR 3 2.0 5.44 2026-01-16 15:34:09
3095 3108 3 756 13836 33 Herbal 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-01-16 15:34:09
3096 3109 4 756 13836 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-16 15:34:09
3097 3110 5 756 13836 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-16 15:34:09
3098 3111 6 756 13836 32 Neem Soap 100gm NULL 34011110 120 0.0 60.0 0.0 0.0 48.0 45.71 2.29 7200.0 0.0 5760.0 2.5 137.14 2.5 137.14 0.0 0.0 5485.72 274.29 5760.0 INR 3 2.0 109.71 2026-01-16 15:34:09
3099 3112 7 756 13836 46 Root Vitality Hair Oil NULL 3305901 3 0.0 255.0 0.0 0.0 204.0 194.29 9.71 765.0 0.0 612.0 2.5 14.57 2.5 14.57 0.0 0.0 582.86 29.14 612.0 INR 3 2.0 11.66 2026-01-16 15:34:09
3100 3113 8 756 13836 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 15:34:09