fx_order
| # | id | userid | orderid | invoice_no | shopee_id | purchase_type | _currency | total_quantity | total_amount | cgst_amount | sgst_amount | igst_amount | final_amount | coupon_code | coupon_dis_per | coupon_dis_amount | gross_amount | total_pv | total_bv | total_sv | payment_type | receipt_path | payment_ref_no | order_by | created_on | admin_status | shipping_type | shipping_charges | shipping_address_id | delivered_on | admin_processed_on | delivery_status | form_name | courier_name | pick_up_person_name | docket_no | processed_by | refund_status |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6451 | 6636 | 16313 | PO/7/26/16636 | INV/7/26/26636 | 12527 | 2 | INR | 24 | 2256.0 | 24.76 | 24.76 | 0.0 | 2256.0 | NULL | 0.0 | 0.0 | 2256.0 | 0.0 | 1000.0 | 0.0 | 2 | 0 | 12527 | 2026-07-21 11:31:45 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-21 11:31:58 | 0 | NULL | NULL | NULL | NULL | 12527 | 0 | |
| 6452 | 6637 | 16317 | PO/7/26/16637 | INV/7/26/26637 | 12527 | 2 | INR | 16 | 2584.0 | 150.5 | 150.5 | 0.0 | 2584.0 | NULL | 0.0 | 0.0 | 2584.0 | 0.0 | 1008.0 | 0.0 | 2 | 0 | 12527 | 2026-07-21 11:39:02 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-21 11:39:21 | 0 | NULL | NULL | NULL | NULL | 12527 | 0 | |
| 6453 | 6638 | 16320 | PO/7/26/16638 | INV/7/26/26638 | 12527 | 2 | INR | 13 | 2485.0 | 119.98 | 119.98 | 0.0 | 2485.0 | NULL | 0.0 | 0.0 | 2485.0 | 0.0 | 1001.0 | 0.0 | 2 | 0 | 12527 | 2026-07-21 11:44:45 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-21 11:45:05 | 0 | NULL | NULL | NULL | NULL | 12527 | 0 | |
| 6454 | 6639 | 16470 | PO/7/26/16639 | INV/7/26/26639 | 12555 | 1 | INR | 3 | 3090.0 | 73.58 | 73.58 | 0.0 | 3090.0 | NULL | 0.0 | 0.0 | 3090.0 | 0.55 | 0.0 | 0.0 | 2 | 0 | 12555 | 2026-07-22 17:56:38 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-22 17:56:50 | 0 | NULL | NULL | NULL | NULL | 12555 | 0 | |
| 6455 | 6640 | 15281 | PO/7/26/16640 | INV/7/26/26640 | 12527 | 2 | INR | 10 | 2313.0 | 80.09 | 80.09 | 0.0 | 2313.0 | NULL | 0.0 | 0.0 | 2313.0 | 0.0 | 1050.0 | 0.0 | 2 | 0 | 12527 | 2026-07-22 18:29:16 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-22 18:29:34 | 0 | NULL | NULL | NULL | NULL | 12527 | 0 | |
| 6456 | 6641 | 16402 | PO/7/26/16641 | INV/7/26/26641 | 12555 | 1 | INR | 2 | 1440.0 | 34.28 | 34.28 | 0.0 | 1440.0 | NULL | 0.0 | 0.0 | 1440.0 | 0.3 | 0.0 | 0.0 | 2 | 0 | 12555 | 2026-07-22 18:56:04 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-22 18:56:17 | 0 | NULL | NULL | NULL | NULL | 12555 | 0 | |
| 6457 | 6642 | 16471 | PO/7/26/16642 | INV/7/26/26642 | 12555 | 1 | INR | 2 | 1720.0 | 40.95 | 40.95 | 0.0 | 1720.0 | NULL | 0.0 | 0.0 | 1720.0 | 0.33 | 0.0 | 0.0 | 2 | 0 | 12555 | 2026-07-25 15:07:43 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-25 15:07:49 | 0 | NULL | NULL | NULL | NULL | 12555 | 0 | |
| 6458 | 6643 | 15140 | PO/7/26/16643 | INV/7/26/26643 | 12555 | 2 | INR | 4 | 1039.0 | 0.0 | 0.0 | 83.05 | 1039.0 | NULL | 0.0 | 0.0 | 1039.0 | 0.0 | 509.0 | 0.0 | 2 | 0 | 12555 | 2026-07-25 15:12:59 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-25 15:13:05 | 0 | NULL | NULL | NULL | NULL | 12555 | 0 | |
| 6459 | 6644 | 16314 | PO/7/26/16644 | INV/7/26/26644 | 12527 | 2 | INR | 5 | 1088.0 | 59.79 | 59.79 | 0.0 | 1088.0 | NULL | 0.0 | 0.0 | 1088.0 | 0.0 | 424.0 | 0.0 | 2 | 0 | 12527 | 2026-07-26 15:52:53 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-26 15:53:16 | 0 | NULL | NULL | NULL | NULL | 12527 | 0 | |
| 6460 | 6645 | 10060 | PO/7/26/16645 | INV/7/26/26645 | 12527 | 2 | INR | 8 | 1172.0 | 6.19 | 6.19 | 0.0 | 1172.0 | NULL | 0.0 | 0.0 | 1172.0 | 0.0 | 550.0 | 0.0 | 2 | 0 | 12527 | 2026-07-30 09:50:39 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-30 09:51:09 | 0 | NULL | NULL | NULL | NULL | 12527 | 0 | |
| 6461 | 6646 | 15347 | PO/7/26/16646 | INV/7/26/26646 | 12527 | 2 | INR | 3 | 2140.0 | 84.52 | 84.52 | 0.0 | 2140.0 | NULL | 0.0 | 0.0 | 2140.0 | 0.0 | 1070.0 | 0.0 | 2 | 0 | 12527 | 2026-07-30 11:59:21 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-30 11:59:44 | 0 | NULL | NULL | NULL | NULL | 12527 | 0 | |
| 6462 | 6647 | 15348 | PO/7/26/16647 | INV/7/26/26647 | 12527 | 2 | INR | 15 | 2176.0 | 130.51 | 130.51 | 0.0 | 2176.0 | NULL | 0.0 | 0.0 | 2176.0 | 0.0 | 1010.0 | 0.0 | 2 | 0 | 12527 | 2026-07-30 12:02:44 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-30 12:03:05 | 0 | NULL | NULL | NULL | NULL | 12527 | 0 | |
| 6463 | 6648 | 15294 | PO/7/26/16648 | INV/7/26/26648 | 12527 | 2 | INR | 6 | 1326.0 | 101.13 | 101.13 | 0.0 | 1326.0 | NULL | 0.0 | 0.0 | 1326.0 | 0.0 | 560.0 | 0.0 | 2 | 0 | 12527 | 2026-07-30 12:06:43 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-30 12:07:16 | 0 | NULL | NULL | NULL | NULL | 12527 | 0 | |
| 6464 | 6649 | 15344 | PO/7/26/16649 | INV/7/26/26649 | 12532 | 2 | INR | 4 | 2314.0 | 89.93 | 89.93 | 0.0 | 2314.0 | NULL | 0.0 | 0.0 | 2314.0 | 0.0 | 1032.0 | 0.0 | 2 | 0 | 12532 | 2026-07-30 17:31:52 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-30 17:32:00 | 0 | NULL | NULL | NULL | NULL | 12532 | 0 | |
| 6465 | 6650 | 15291 | PO/7/26/16650 | INV/7/26/26650 | 12532 | 2 | INR | 25 | 1300.0 | 30.95 | 30.95 | 0.0 | 1300.0 | NULL | 0.0 | 0.0 | 1300.0 | 0.0 | 500.0 | 0.0 | 2 | 0 | 12532 | 2026-07-30 21:20:05 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-30 21:20:13 | 0 | NULL | NULL | NULL | NULL | 12532 | 0 | |
| 6466 | 6651 | 15310 | PO/7/26/16651 | INV/7/26/26651 | 12532 | 2 | INR | 12 | 2222.0 | 52.91 | 52.91 | 0.0 | 2222.0 | NULL | 0.0 | 0.0 | 2222.0 | 0.0 | 1020.0 | 0.0 | 2 | 0 | 12532 | 2026-07-30 21:23:49 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-30 21:23:55 | 0 | NULL | NULL | NULL | NULL | 12532 | 0 | |
| 6467 | 6652 | 15316 | PO/7/26/16652 | INV/7/26/26652 | 12532 | 2 | INR | 14 | 2230.0 | 103.35 | 103.35 | 0.0 | 2230.0 | NULL | 0.0 | 0.0 | 2230.0 | 0.0 | 1015.0 | 0.0 | 2 | 0 | 12532 | 2026-07-30 21:27:21 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-30 21:27:27 | 0 | NULL | NULL | NULL | NULL | 12532 | 0 | |
| 6468 | 6653 | 15361 | PO/7/26/16653 | INV/7/26/26653 | 12532 | 2 | INR | 19 | 2474.0 | 142.52 | 142.52 | 0.0 | 2474.0 | NULL | 0.0 | 0.0 | 2474.0 | 0.0 | 1035.0 | 0.0 | 2 | 0 | 12532 | 2026-07-30 21:31:05 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-30 21:31:10 | 0 | NULL | NULL | NULL | NULL | 12532 | 0 | |
| 6469 | 6654 | 15370 | PO/7/26/16654 | INV/7/26/26654 | 12532 | 2 | INR | 4 | 3838.0 | 91.38 | 91.38 | 0.0 | 3838.0 | NULL | 0.0 | 0.0 | 3838.0 | 0.0 | 1918.0 | 0.0 | 2 | 0 | 12532 | 2026-07-30 21:38:56 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-30 21:39:03 | 0 | NULL | NULL | NULL | NULL | 12532 | 0 | |
| 6470 | 6655 | 15721 | PO/7/26/16655 | INV/7/26/26655 | 12532 | 2 | INR | 10 | 3655.0 | 87.02 | 87.02 | 0.0 | 3655.0 | NULL | 0.0 | 0.0 | 3655.0 | 0.0 | 1790.0 | 0.0 | 2 | 0 | 12532 | 2026-07-30 21:54:18 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-30 21:54:25 | 0 | NULL | NULL | NULL | NULL | 12532 | 0 | |
| 6471 | 6656 | 12013 | PO/7/26/16656 | INV/7/26/26656 | 12532 | 2 | INR | 1 | 720.0 | 17.14 | 17.14 | 0.0 | 720.0 | NULL | 0.0 | 0.0 | 720.0 | 0.0 | 360.0 | 0.0 | 2 | 0 | 12532 | 2026-07-31 11:21:54 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-31 11:22:00 | 0 | NULL | NULL | NULL | NULL | 12532 | 0 | |
| 6472 | 6657 | 16234 | PO/7/26/16657 | INV/7/26/26657 | 12532 | 2 | INR | 4 | 2121.0 | 67.33 | 67.33 | 0.0 | 2121.0 | NULL | 0.0 | 0.0 | 2121.0 | 0.0 | 1012.0 | 0.0 | 2 | 0 | 12532 | 2026-07-31 11:24:07 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-31 11:24:13 | 0 | NULL | NULL | NULL | NULL | 12532 | 0 | |
| 6473 | 6658 | 15476 | PO/7/26/16658 | INV/7/26/26658 | 12532 | 2 | INR | 2 | 1020.0 | 24.28 | 24.28 | 0.0 | 1020.0 | NULL | 0.0 | 0.0 | 1020.0 | 0.0 | 510.0 | 0.0 | 2 | 0 | 12532 | 2026-07-31 20:55:40 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-31 20:56:20 | 0 | NULL | NULL | NULL | NULL | 12532 | 0 | |
| 6474 | 6659 | 6712 | PO/7/26/16659 | INV/7/26/26659 | 12526 | 2 | INR | 10 | 2281.0 | 133.46 | 133.46 | 0.0 | 2281.0 | NULL | 0.0 | 0.0 | 2281.0 | 0.0 | 1015.0 | 0.0 | 2 | 0 | 12526 | 2026-07-31 21:03:05 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-31 21:03:12 | 0 | NULL | NULL | NULL | NULL | 12526 | 0 | |
| 6475 | 6660 | 15875 | PO/7/26/16660 | INV/7/26/26660 | 12532 | 2 | INR | 26 | 2850.0 | 184.64 | 184.64 | 0.0 | 2850.0 | NULL | 0.0 | 0.0 | 2850.0 | 0.0 | 1010.0 | 0.0 | 2 | 0 | 12532 | 2026-07-31 21:03:13 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-31 21:03:26 | 0 | NULL | NULL | NULL | NULL | 12532 | 0 | |
| 6476 | 6661 | 8100 | PO/7/26/16661 | INV/7/26/26661 | 12526 | 2 | INR | 8 | 2158.0 | 51.37 | 51.37 | 0.0 | 2158.0 | NULL | 0.0 | 0.0 | 2158.0 | 0.0 | 1033.0 | 0.0 | 2 | 0 | 12526 | 2026-07-31 21:05:06 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-31 21:05:18 | 0 | NULL | NULL | NULL | NULL | 12526 | 0 | |
| 6477 | 6662 | 5430 | PO/7/26/16662 | INV/7/26/26662 | 12526 | 2 | INR | 1 | 1200.0 | 28.57 | 28.57 | 0.0 | 1200.0 | NULL | 0.0 | 0.0 | 1200.0 | 0.0 | 600.0 | 0.0 | 2 | 0 | 12526 | 2026-07-31 21:06:58 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-31 21:07:12 | 0 | NULL | NULL | NULL | NULL | 12526 | 0 | |
| 6478 | 6663 | 5564 | PO/7/26/16663 | INV/7/26/26663 | 12526 | 2 | INR | 4 | 2174.0 | 75.05 | 75.05 | 0.0 | 2174.0 | NULL | 0.0 | 0.0 | 2174.0 | 0.0 | 1030.0 | 0.0 | 2 | 0 | 12526 | 2026-07-31 21:10:33 | 1 | 1 | 0.0 | 0 | NULL | 2026-07-31 21:10:44 | 0 | NULL | NULL | NULL | NULL | 12526 | 0 | |
| 6479 | 6664 | 15243 | PO/8/26/16664 | INV/8/26/26664 | 12555 | 2 | INR | 7 | 2207.0 | 0.0 | 0.0 | 160.39 | 2207.0 | NULL | 0.0 | 0.0 | 2207.0 | 0.0 | 1010.0 | 0.0 | 2 | 0 | 12555 | 2026-08-01 09:35:55 | 1 | 1 | 0.0 | 0 | NULL | 2026-08-01 09:36:32 | 0 | NULL | NULL | NULL | NULL | 12555 | 0 | |
| 6480 | 6665 | 16292 | PO/8/26/16665 | INV/8/26/26665 | 16292 | 2 | INR | 2 | 211.0 | 13.37 | 13.37 | 0.0 | 211.0 | NULL | 0.0 | 0.0 | 211.0 | 0.0 | 75.0 | 0.0 | 2 | 16292 | 2026-08-02 20:41:48 | 0 | 1 | 0.0 | 0 | NULL | NULL | 0 | NULL | NULL | NULL | NULL | 0 | 0 | ||
| 6481 | 6666 | 16296 | PO/8/26/16666 | INV/8/26/26666 | 12527 | 1 | INR | 10 | 520.0 | 12.38 | 12.38 | 0.0 | 520.0 | NULL | 0.0 | 0.0 | 520.0 | 0.06 | 0.0 | 0.0 | 2 | 0 | 12527 | 2026-08-02 20:59:55 | 1 | 1 | 0.0 | 0 | NULL | 2026-08-02 21:00:14 | 0 | NULL | NULL | NULL | NULL | 12527 | 0 | |
| 6482 | 6667 | 16243 | PO/8/26/16667 | INV/8/26/26667 | 12527 | 1 | INR | 4 | 1463.0 | 43.18 | 43.18 | 0.0 | 1463.0 | NULL | 0.0 | 0.0 | 1463.0 | 0.287 | 0.0 | 0.0 | 2 | 0 | 12527 | 2026-08-02 21:03:09 | 1 | 1 | 0.0 | 0 | NULL | 2026-08-02 21:03:28 | 0 | NULL | NULL | NULL | NULL | 12527 | 0 | |
| 6483 | 6668 | 16468 | PO/8/26/16668 | INV/8/26/26668 | 12555 | 1 | INR | 15 | 3775.0 | 89.87 | 89.87 | 0.0 | 3775.0 | NULL | 0.0 | 0.0 | 3775.0 | 0.509 | 0.0 | 0.0 | 2 | 0 | 12555 | 2026-08-07 19:56:06 | 1 | 1 | 0.0 | 0 | NULL | 2026-08-07 19:56:17 | 0 | NULL | NULL | NULL | NULL | 12555 | 0 | |
| 6484 | 6669 | 16234 | PO/8/26/16669 | INV/8/26/26669 | 12532 | 2 | INR | 8 | 1546.0 | 36.81 | 36.81 | 0.0 | 1546.0 | NULL | 0.0 | 0.0 | 1546.0 | 0.0 | 752.0 | 0.0 | 2 | 0 | 12532 | 2026-08-10 14:43:39 | 1 | 1 | 0.0 | 0 | NULL | 2026-08-10 14:43:47 | 0 | NULL | NULL | NULL | NULL | 12532 | 0 |