biz_inventory_dealer

<h4>biz_inventory_dealer</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>OrgName</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>ProductCode</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>SubInventoryID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>子库ID</td> </tr> <tr> <td>LocatorID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>货位ID</td> </tr> <tr> <td>ProductVersion</td> <td>int(11)</td> <td>YES</td> <td></td> <td>产品版本</td> </tr> <tr> <td>ProductVersionDesc</td> <td>varchar(255)</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>PrimaryUnit</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>主单位</td> </tr> <tr> <td>PrimaryQty</td> <td>int(15)</td> <td>YES</td> <td>0</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>0</td> <td>辅数量</td> </tr> <tr> <td>StorageDate</td> <td>datetime</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>BatchStatus</td> <td>int(4)</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>LockedQty</td> <td>int(11)</td> <td>YES</td> <td>0</td> <td>锁定量，单位为主单位</td> </tr> <tr> <td>TransitQty</td> <td>int(11)</td> <td>YES</td> <td>0</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(512)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>StorageBy</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>AchievePreQty</td> <td>int(11)</td> <td>YES</td> <td></td> <td>提前接收批次的数量</td> </tr> <tr> <td>AchievePreShipQty</td> <td>int(11)</td> <td>YES</td> <td></td> <td>提前接收批次已发运数量</td> </tr> <tr> <td>DamagedQty</td> <td>int(11)</td> <td>YES</td> <td></td> <td>破损数量</td> </tr> <tr> <td>ScatteredQty</td> <td>int(11)</td> <td>YES</td> <td>0</td> <td>零货量</td> </tr> <tr> <td>LockScatteredQty</td> <td>int(11)</td> <td>YES</td> <td>0</td> <td>零货锁定量</td> </tr> <tr> <td>LockDamagedQty</td> <td>int(11)</td> <td>YES</td> <td>0</td> <td>破损锁定量</td> </tr> <tr> <td>LockManualQty</td> <td>int(11)</td> <td>YES</td> <td>0</td> <td>手动锁定量</td> </tr> <tr> <td>WillTransitQty</td> <td>int(11)</td> <td>YES</td> <td>0</td> <td>待转入（分拨、子库转移目标仓库为本仓库未发运）</td> </tr> <tr> <td>LockOrderQty</td> <td>int(11)</td> <td>YES</td> <td>0</td> <td>销售类(订单，杂出、口头单）出库锁定</td> </tr> <tr> <td>Type</td> <td>int(11)</td> <td>YES</td> <td></td> <td>库存类型</td> </tr> <tr> <td>DealerId</td> <td>int(11)</td> <td>YES</td> <td></td> <td>经销商Id</td> </tr> <tr> <td>CreateBy</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>CreateDate</td> <td>datetime</td> <td>YES</td> <td></td> <td>创建时间</td> </tr> </tbody> </table>