biz_product

<h4>biz_product 产品信息表</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>int(11)</td> <td>YES</td> <td></td> <td>库存组织Id</td> </tr> <tr> <td>ProductId</td> <td>bigint(20)</td> <td>YES</td> <td></td> <td>EBSproduct_id</td> </tr> <tr> <td>No</td> <td>varchar(11)</td> <td>YES</td> <td></td> <td>产品编码</td> </tr> <tr> <td>Name</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>产品名称</td> </tr> <tr> <td>MaterialIntro</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>物料说明</td> </tr> <tr> <td>MaterialCode</td> <td>int(11)</td> <td>YES</td> <td></td> <td>物料编码</td> </tr> <tr> <td>Spec</td> <td>int(11)</td> <td>YES</td> <td></td> <td>辅-主单位转换率</td> </tr> <tr> <td>PrimaryUomCode</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>主单位</td> </tr> <tr> <td>SecondUomCode</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>辅单位</td> </tr> <tr> <td>Standard</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>规格</td> </tr> <tr> <td>Type</td> <td>varchar(255)</td> <td>YES</td> <td></td> <td>类型，区分是否促销装</td> </tr> <tr> <td>Weight</td> <td>double(11,3)</td> <td>YES</td> <td></td> <td>产品重量</td> </tr> <tr> <td>Length</td> <td>double(11,3)</td> <td>YES</td> <td></td> <td>长度</td> </tr> <tr> <td>Width</td> <td>double(11,3)</td> <td>YES</td> <td></td> <td>宽度</td> </tr> <tr> <td>Height</td> <td>double(11,3)</td> <td>YES</td> <td></td> <td>高度</td> </tr> <tr> <td>Volume</td> <td>double(11,6)</td> <td>YES</td> <td></td> <td>产品体积</td> </tr> <tr> <td>ClassId</td> <td>int(11)</td> <td>YES</td> <td></td> <td>类型ID</td> </tr> <tr> <td>ClassCode</td> <td>varchar(50)</td> <td>YES</td> <td></td> <td>分类code</td> </tr> <tr> <td>CreateBy</td> <td>int(11)</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>int(11)</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>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>seqNo</td> <td>int(11)</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>sendToSiebel</td> <td>bit(1)</td> <td>YES</td> <td>b'0'</td> <td>是否已传siebel</td> </tr> <tr> <td>conversion</td> <td>int(11)</td> <td>NO</td> <td>0</td> <td>转换率-正对牙膏工厂托盘-件数参考</td> </tr> </tbody> </table>