biz_inventoryoptservicelog
<h4>biz_inventoryoptservicelog EBS库存量变更同步记录</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>EbsBizId</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Type</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>事务处理类型</td>
</tr>
<tr>
<td>OrganizationCode</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>SubInventoryCode</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>子库存</td>
</tr>
<tr>
<td>LocatorCode</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>ProductCode</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>产品</td>
</tr>
<tr>
<td>BatchNo</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>产品批次</td>
</tr>
<tr>
<td>BatchStatus</td>
<td>int(4)</td>
<td>YES</td>
<td></td>
<td>批次状态</td>
</tr>
<tr>
<td>PrimaryUnit</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>主单位</td>
</tr>
<tr>
<td>PrimaryQty</td>
<td>int(11)</td>
<td>YES</td>
<td></td>
<td>主数量</td>
</tr>
<tr>
<td>SecondUnit</td>
<td>varchar(50)</td>
<td>YES</td>
<td></td>
<td>辅单位</td>
</tr>
<tr>
<td>SecondQty</td>
<td>double</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>ProductionDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>批次生产日期</td>
</tr>
<tr>
<td>InvalidDate</td>
<td>datetime</td>
<td>YES</td>
<td></td>
<td>批次失效日期</td>
</tr>
<tr>
<td>CreateBy</td>
<td>varchar(50)</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>TransactionDate</td>
<td>datetime</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>
<tr>
<td>Attribute6</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Attribute7</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Attribute8</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Attribute9</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
<tr>
<td>Attribute10</td>
<td>varchar(255)</td>
<td>YES</td>
<td></td>
<td></td>
</tr>
</tbody>
</table>