fx_franchise_order_product
| # | sr_no | order_id | userid | product_id | product_name | product_qty | product_MRP | product_bv | prod_before_gst_amt | prod_gst_amount | prod_dis_amt | total_bv | total_mrp | total_price | created_on | cgst_per | cgst_amount | sgst_per | sgst_amount | igst_per | igst_amount | final_amount | total_before_gst_amount | total_gst_amount | hsn_no | fr_category | comm_per | comm_amount |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | intSrNO | intOrderID | intUserID | intProdID | strProdName | intQty | dblProdMRP | dblBV | dblBeforeGSTAmt | dblGSTAmt | dblProdPrice | dblTotalBV | dblTotalMRP | dblTotalAmt | @Now | dblCGSTPer | dblCGSTAmt | dblSGSTPer | dblSGSTAmt | dblIGSTPer | dblIGSTAmt | dblTotalAmt | dblTotalBeforeGSTAmt | dblTotalGSTAmt | strHSN | intFransType | dblDiscountPer | dblDisAmt |
| 2 | intSrNO | intOrderID | intUserID | intProdID | strProdName | intQty | dblProdMRP | dblBV | dblBeforeGSTAmt | dblGSTAmt | dblProdPrice | dblTotalBV | dblTotalMRP | dblTotalAmt | @Now | dblCGSTPer | dblCGSTAmt | dblSGSTPer | dblSGSTAmt | dblIGSTPer | dblIGSTAmt | dblTotalAmt | dblTotalBeforeGSTAmt | dblTotalGSTAmt | strHSN | NULL | NULL | NULL |
| 3 | intSrNO | intOrderID | intUserID | intProdID | strProdName | intQty | dblProdMRP | dblBV | dblBeforeGSTAmt | dblGSTAmt | dblProdPrice | dblTotalBV | dblTotalMRP | dblTotalAmt | @Now | dblCGSTPer | dblCGSTAmt | dblSGSTPer | dblSGSTAmt | dblIGSTPer | dblIGSTAmt | dblTotalAmt | dblTotalBeforeGSTAmt | dblTotalGSTAmt | strHSN | intFransType | dblDiscountPer | dblDisAmt |