fx_franchise_order
| # | orderid | userid | total_quantity | total_amount | total_bv | payment_type | order_by | created_on | admin_status | receipt_path | payment_ref_no | invoice_no | shopee_id | comm_per | dicount_comm | product_type |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | strOrderID | intUserID | intTotalQuantity | dblTotalAmt | dblTotalBV | intPaymentType | intOrderBy | @Now | 0 | strReceipt | strRefNo | strInvoiceNo | intShopeeID | dblCommPer | dblCommissionDiscount | intProductType |
| 2 | strOrderID | intUserID | intTotalQuantity | dblTotalAmt | dblTotalBV | intPaymentType | intOrderBy | @Now | 0 | strReceipt | strRefNo | strInvoiceNo | intShopeeID | dblCommPer | dblComm | intProductType |
| 3 | strOrderID | intUserID | intTotalQuantity | dblTotalAmt | dblTotalBV | intPaymentType | intOrderBy | @Now | 0 | strReceipt | strRefNo | strInvoiceNo | intShopeeID | dblCommPer | NULL | intProductType |