everydaystock

<h4>everydaystock 每日库存记录</h4> <table> <thead> <tr> <th>字段名称</th> <th>类型长度</th> <th>是否NULL</th> <th>默认值</th> <th>注释</th> </tr> </thead> <tbody> <tr> <td>id</td> <td>int(11)</td> <td>NO</td> <td></td> <td></td> </tr> <tr> <td>cpmc</td> <td>varchar(512)</td> <td>YES</td> <td></td> <td>产品名称</td> </tr> <tr> <td>cpbm</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>产品编码</td> </tr> <tr> <td>pg</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>品规</td> </tr> <tr> <td>pc</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>批次</td> </tr> <tr> <td>pczt</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>批次状态</td> </tr> <tr> <td>ckbm</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>仓库编码</td> </tr> <tr> <td>ckmc</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>仓库名称</td> </tr> <tr> <td>kczl</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>库存总量</td> </tr> <tr> <td>xsky</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>销售可用</td> </tr> <tr> <td>xsdfh</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>销售待发货</td> </tr> <tr> <td>dzr</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>待转入</td> </tr> <tr> <td>ztsl</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>在途数量</td> </tr> <tr> <td>kysl</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>可用数量</td> </tr> <tr> <td>sdsl</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>锁定数量</td> </tr> <tr> <td>lhsl</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>零货数量</td> </tr> <tr> <td>pssl</td> <td>varchar(45)</td> <td>YES</td> <td></td> <td>破损数量</td> </tr> <tr> <td>tqrksl</td> <td>varchar(45)</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>stockday</td> <td>date</td> <td>YES</td> <td></td> <td></td> </tr> </tbody> </table>