fx_order_product
| # | sr_no | order_id | userid | product_id | product_name | product_qty | product_MRP | product_bv | product_pv | prod_dis_amt | total_bv | total_pv | total_mrp | total_price | created_on | cgst_per | cgst_amount | sgst_per | sgst_amount | igst_per | igst_amount | final_amount | prod_desc | product_sv | total_sv | hsn_no | prod_dis_type | prod_dis |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | intSrNO | intOrderID | intUserID | intProdID | strProdName | intQty | dblProdMRP | dblBV | dblPV | dblProdPrice | dblTotalBV | dblTotalPV | dblTotalMRP | dblTotalAmt | @Now | dblCGSTPer | dblCGSTAmt | dblSGSTPer | dblSGSTAmt | dblIGSTPer | dblIGSTAmt | dblTotalAmt | strProdDescription | dblSV | dblTotalSV | strHSNNo | intProdDisType | dblProdDis |
| 2 | intSrNO | intOrderID | intUserID | intProdID | strProdName | intQty | dblProdMRP | dblBV | dblPV | dblProdPrice | dblTotalBV | dblTotalPV | dblTotalMRP | dblTotalAmt | @Now | dblCGSTPer | dblCGSTAmt | dblSGSTPer | dblSGSTAmt | dblIGSTPer | dblIGSTAmt | dblTotalAmt | strProdDescription | dblSV | dblTotalSV | strHSNNo | intProdDisType | dblProdDis |
| 3 | intSrNO | intOrderID | intUserID | intProdID | strProdName | intQty | dblProdMRP | dblBV | dblPV | dblProdPrice | dblTotalBV | dblTotalPV | dblTotalMRP | dblTotalAmt | @Now | dblCGSTPer | dblCGSTAmt | dblSGSTPer | dblSGSTAmt | dblIGSTPer | dblIGSTAmt | dblTotalAmt | strProdDescription | dblSV | dblTotalSV | strHSN | NULL | NULL |
| 4 | intSrNO | intOrderID | intUserID | intProdID | strProdName | intQty | dblProdMRP | dblBV | dblPV | dblProdPrice | dblTotalBV | dblTotalPV | dblTotalMRP | dblTotalAmt | @Now | dblCGSTPer | dblCGSTAmt | dblSGSTPer | dblSGSTAmt | dblIGSTPer | dblIGSTAmt | dblTotalAmt | strProdDescription | dblSV | dblTotalSV | strHSNNo | intProdDisType | dblProdDis |