<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>