<p><strong>訂單商品表</strong></p> <table class="Tablelist"> <tbody><tr> <th>字段名</th> <th>功能 </th></tr> <tr> <td>id</td> <td> </td></tr> <tr> <td>uniacid</td> <td> </td></tr> <tr> <td>orderid</td> <td>訂單ID </td></tr> <tr> <td>goodsid</td> <td>商品ID </td></tr> <tr> <td>price</td> <td>訂單價格 </td></tr> <tr> <td>oldprice</td> <td>原價格 </td></tr> <tr> <td>changeprice</td> <td>修改價格 </td></tr> <tr> <td>total</td> <td>訂單總價 </td></tr> <tr> <td>optionid</td> <td>選項ID </td></tr> <tr> <td>createtime</td> <td>建立時間 </td></tr> <tr> <td>optionname</td> <td>選項名 </td></tr> <tr> <td>commissions</td> <td>實際傭金，可以通過后臺調整 </td></tr> <tr> <td>commission1</td> <td>應得傭金，分銷級別一，分成比率 </td></tr> <tr> <td>applytime1</td> <td>申請時間 </td></tr> <tr> <td>checktime1</td> <td>審核時間 </td></tr> <tr> <td>paytime1</td> <td>打款時間 </td></tr> <tr> <td>invalidtime1</td> <td>拒絕時間 </td></tr> <tr> <td>deletetime1</td> <td>刪除 </td></tr> <tr> <td>status1</td> <td>申請狀態，-2刪除，-1無效，0未申請，1申請，2審核通過 3已打款 </td></tr> <tr> <td>content1</td> <td>內容 </td></tr> <tr> <td>commission2</td> <td> </td></tr> <tr> <td>applytime2</td> <td> </td></tr> <tr> <td>checktime2</td> <td> </td></tr> <tr> <td>paytime2</td> <td> </td></tr> <tr> <td>invalidtime2</td> <td> </td></tr> <tr> <td>deletetime2</td> <td> </td></tr> <tr> <td>status2</td> <td> </td></tr> <tr> <td>content2</td> <td> </td></tr> <tr> <td>commission3</td> <td> </td></tr> <tr> <td>applytime3</td> <td> </td></tr> <tr> <td>checktime3</td> <td> </td></tr> <tr> <td>paytime3</td> <td> </td></tr> <tr> <td>invalidtime3</td> <td> </td></tr> <tr> <td>deletetime3</td> <td> </td></tr> <tr> <td>status3</td> <td> </td></tr> <tr> <td>content3</td> <td> </td></tr> <tr> <td>realprice</td> <td>實際價格 </td></tr> <tr> <td>goodssn</td> <td>商品編碼 </td></tr> <tr> <td>productsn</td> <td>產品條碼 </td></tr> <tr> <td>nocommission</td> <td>不參與分銷 </td></tr> <tr> <td>diyformid</td> <td> </td></tr> <tr> <td>diyformdataid</td> <td> </td></tr> <tr> <td>diyformdata</td> <td> </td></tr> <tr> <td>diyformfields</td> <td> </td></tr> <tr> <td>openid</td> <td> </td></tr> <tr> <td>printstate</td> <td>快遞單打印狀態 0 未 &gt;0 多次 </td></tr> <tr> <td>printstate2</td> <td>發貨單打印狀態 0 未 &gt;0 多次 </td></tr> <tr> <td>rstate</td> <td>v2 退款狀態 </td></tr> <tr> <td>refundtime</td> <td>v2 退款時間 </td></tr> <tr> <td>merchid</td> <td>v2 商戶ID </td></tr> <tr> <td>parentorderid</td> <td>v2 父訂單id </td></tr> <tr> <td>merchsale</td> <td>v2 商戶銷售 </td></tr> <tr> <td>isdiscountprice</td> <td>v2 是否折扣價格 </td></tr> <tr> <td>canbuyagain</td> <td>v2 可以復購 </td></tr> <tr> <td>sendtype</td> <td>v2 &gt;0 時為分拆包裹多次快遞 </td></tr> <tr> <td>expresscom</td> <td>v2 </td></tr> <tr> <td>expresssn</td> <td>v2 </td></tr> <tr> <td>express</td> <td>v2 </td></tr> <tr> <td>sendtime</td> <td>v2 </td></tr> <tr> <td>finishtime</td> <td>v2 </td></tr> <tr> <td>remarksend</td> <td>v2 </td></tr> <tr> <td>*paymerchid</td> <td>支付供應商ID </td></tr> <tr> <td>*payrealname</td> <td>供應商收款人名 </td></tr> <tr> <td>*paybankname</td> <td>供應商收款銀行 </td></tr> <tr> <td>*paybankcard</td> <td>供應商收款卡號 </td></tr> <tr> <td>*costprice</td> <td>成本價 </td></tr> <tr> <td>*otherprice</td> <td>其他費用 </td></tr> <tr> <td>*supplierid </td> <td> 供貨商ID </td></tr> <tr> <td>*goodspayrate</td> <td>合同商品扣點 </td></tr> <tr> <td>*refundtotal </td> <td> 退貨數量 </td></tr> <tr> <td>*unit</td> <td> 單位 </td></tr> <tr> <td>*title</td> <td> 標題 </td></tr></tbody></table>