fx_purchase_order_product
| # | id | sr_no | order_id | userid | product_id | product_name | product_qty | prod_balance_qty | product_MRP | product_bv | prod_dis_amt | total_mrp | total_bv | total_price | cgst_per | cgst_amount | sgst_per | sgst_amount | igst_per | igst_amount | final_amount | _currency | created_on |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | 1 | 1 | 1 | 48 | glow face wash | 1 | 1 | 380.0 | 100.0 | 304.0 | 380.0 | 100.0 | 304.0 | 0.0 | 0.0 | 0.0 | 0.0 | 18.0 | 54.72 | 358.72 | INR | 2025-11-24 17:01:41 |
| 2 | 2 | 2 | 1 | 1 | 27 | Multicharge Cap | 1 | 1 | 1499.0 | 450.0 | 1199.2 | 1499.0 | 450.0 | 1199.2 | 0.0 | 0.0 | 0.0 | 0.0 | 5.0 | 59.96 | 1259.16 | INR | 2025-11-24 17:01:41 |