fx_order
| # | orderid | userid | total_quantity | total_amount | total_bv | total_pv | payment_type | order_by | created_on | admin_status | receipt_path | payment_ref_no | invoice_no | shopee_id | purchase_type | shipping_type | total_sv |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | strOrderID | intUserID | intTotalQuantity | dblTotalAmt | dblTotalBV | dblTotalPV | intPaymentType | intOrderBy | @Now | 0 | strReceipt | strRefNo | strInvoiceNo | intOrderBy | intPurchaseType | intShippingType | dblTotalSV |
| 2 | strOrderID | intUserID | intTotalQuantity | dblTotalAmt | dblTotalBV | dblTotalPV | intPaymentType | intOrderBy | @Now | 0 | strReceipt | strRefNo | strInvoiceNo | intShopeeID | intPurchaseType | NULL | NULL |
| 3 | strOrderID | intUserID | intTotalQuantity | dblTotalAmt | dblTotalBV | dblTotalPV | intPaymentType | intOrderBy | @Now | 0 | strReceipt | strRefNo | strInvoiceNo | intShopeeID | intPurchaseType | intShippingType | dblTotalSV |
| 4 | strOrderID | intUserID | intTotalQuantity | dblTotalAmt | dblTotalBV | dblTotalPV | intPaymentType | intOrderBy | @Now | 0 | strReceipt | strRefNo | strInvoiceNo | intOrderBy | intPurchaseType | intShippingType | dblTotalSV |
| 5 | strOrderID | intUserID | intTotalQuantity | dblTotalAmt | dblTotalBV | dblTotalPV | 5 | intActivatedBy | @Now | 0 | strVoucher | strInvoiceNo | intShopeeID | 1 | 1 | dblTotalSV |