biz_orderheadandoverseas

<h4>biz_orderheadandoverseas 销售区本部及海外订单信息</h4> <table> <thead> <tr> <th>字段名称</th> <th>类型长度</th> <th>是否NULL</th> <th>默认值</th> <th>注释</th> </tr> </thead> <tbody> <tr> <td>ID</td> <td>bigint(20)</td> <td>NO</td> <td></td> <td>ID</td> </tr> <tr> <td>Office</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>办事处</td> </tr> <tr> <td>DealerID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>经销商ID</td> </tr> <tr> <td>DealerNo</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>经销商编码</td> </tr> <tr> <td>DealerName</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>经销商名称</td> </tr> <tr> <td>ProductID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>产品ID</td> </tr> <tr> <td>ProductNo</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>产品编码</td> </tr> <tr> <td>ProductMaterialIntro</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>产品说明</td> </tr> <tr> <td>OrderDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>下单日期</td> </tr> <tr> <td>ShipmentDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>发运日期</td> </tr> <tr> <td>ShipmentAmount</td> <td>double(11,2)</td> <td>YES</td> <td></td> <td>发运数量</td> </tr> <tr> <td>ShipmentPieceAmount</td> <td>double(11,2)</td> <td>YES</td> <td></td> <td>发运件数</td> </tr> <tr> <td>Price</td> <td>double(11,2)</td> <td>YES</td> <td></td> <td>销售价（支/元）</td> </tr> <tr> <td>TotalPrice</td> <td>double(11,2)</td> <td>YES</td> <td></td> <td>总金额</td> </tr> <tr> <td>ShipmentNo</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>发运号</td> </tr> <tr> <td>PrimaryUnit</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>单位</td> </tr> <tr> <td>TakeDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>数据日期</td> </tr> <tr> <td>Type</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>类型，区分海外与电子商务数据</td> </tr> <tr> <td>CreateDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>创建时间</td> </tr> <tr> <td>CreateBy</td> <td>bigint(11) unsigned zerofill</td> <td>YES</td> <td></td> <td>创建人</td> </tr> <tr> <td>LastUpdateDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>最后一次更新时间</td> </tr> <tr> <td>LastUpdateBy</td> <td>int(11)</td> <td>YES</td> <td></td> <td>最后一次更新人</td> </tr> <tr> <td>Attribute1</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute2</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute3</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute4</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute5</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> </tbody> </table>