biz_tactics
<h4>biz_tactics 业务策略表(自动发货等)</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></td>
</tr>
<tr>
<td>Name</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>策略名称</td>
</tr>
<tr>
<td>Type</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>1 挑选库存产品; 2 挑选仓库; 3 挑选物流</td>
</tr>
<tr>
<td>Value</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>策略的sql脚本(或其他数值)</td>
</tr>
<tr>
<td>CreateDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>CreateBy</td>
<td>bigint(20)</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>bigint(20)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>BizType</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>业务类型,如分拨出库,入库等</td>
</tr>
<tr>
<td>BizID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>业务id</td>
</tr>
<tr>
<td>Description</td>
<td>varchar(200)</td>
<td>YES</td>
<td></td>
<td>策略描述</td>
</tr>
<tr>
<td>First</td>
<td>bit(1)</td>
<td>YES</td>
<td></td>
<td>是否默认</td>
</tr>
<tr>
<td>TacticsType</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>策略类型, 如效期优先等,来自数据字典</td>
</tr>
<tr>
<td>StartDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>策略生效时间</td>
</tr>
<tr>
<td>EndDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>策略失效时间</td>
</tr>
<tr>
<td>DeptID</td>
<td>bigint(20)</td>
<td>YES</td>
<td></td>
<td>机构Id 如仓库 物流公司 经销商Id 等</td>
</tr>
<tr>
<td>Attribute1</td>
<td>varchar(55)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Attribute2</td>
<td>varchar(55)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Attribute3</td>
<td>varchar(55)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Attribute4</td>
<td>varchar(55)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Attribute5</td>
<td>varchar(55)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Level</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>策略优先级</td>
</tr>
<tr>
<td>Dtype</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>策略中经销商类型1-经销商 2-大区 3-省区 4-地址</td>
</tr>
<tr>
<td>ProductIds</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>策略中产品对象的id,或者库存对象ID</td>
</tr>
<tr>
<td>SubIvtIds</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>策略中仓库对象的Id</td>
</tr>
<tr>
<td>DealerIds</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>策略中经销商、大区、省区、地址对象的id</td>
</tr>
<tr>
<td>Ptype</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>产品对象类型 1-产品 2-库存 BizInventory</td>
</tr>
<tr>
<td>IsActive</td>
<td>bit(1)</td>
<td>YES</td>
<td></td>
<td>是否生效</td>
</tr>
<tr>
<td>Batches</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>策略中批次对象批次号</td>
</tr>
<tr>
<td>OrderNos</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td>对应订单号</td>
</tr>
<tr>
<td>InventoryType</td>
<td>int(11) unsigned zerofill</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
</tbody>
</table>