biz_subinventory

<h4>biz_subinventory 供应商代管库</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>OrganizationID</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Name</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Code</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Description</td> <td>varchar(250)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>ChildIds</td> <td>varchar(250)</td> <td>YES</td> <td></td> <td>子库id</td> </tr> <tr> <td>Type</td> <td>int(11)</td> <td>YES</td> <td></td> <td>仓库层级：1、总仓；2、分仓</td> </tr> <tr> <td>ValidFlag</td> <td>bit(1)</td> <td>YES</td> <td></td> <td>是否使用</td> </tr> <tr> <td>ShippedFlag</td> <td>bit(1)</td> <td>YES</td> <td></td> <td>是否可发货</td> </tr> <tr> <td>Contact</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>仓库联系人</td> </tr> <tr> <td>ContactNumber</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>联系电话</td> </tr> <tr> <td>ContactAddress</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>地址</td> </tr> <tr> <td>SubInventoryVolume</td> <td>double</td> <td>YES</td> <td></td> <td>仓库容积:单位为件数</td> </tr> <tr> <td>InventoryWarning</td> <td>int(11)</td> <td>YES</td> <td></td> <td>库存预警量:单位为件数</td> </tr> <tr> <td>PickupDays</td> <td>int(11)</td> <td>YES</td> <td></td> <td>提货天数，用于计算最晚提货日期</td> </tr> <tr> <td>ProvinceName</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>省</td> </tr> <tr> <td>ProvinceCode</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>CityCode</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>市</td> </tr> <tr> <td>CityName</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>CountyCode</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>CountyName</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>县</td> </tr> <tr> <td>Attribute1</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute2</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute3</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute4</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td></td> </tr> <tr> <td>Attribute5</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>LastUpdateBy</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>PTypeIds</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>仓库存储的产品类型id</td> </tr> </tbody> </table>