📄 help.asp
字号:
<table BORDER="1" CELLSPACING="0" CELLPADDING="7" WIDTH="100%" bordercolorlight="#000000"
bordercolordark="#FFFFFF">
<tr>
<td WIDTH="17%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">字段名称</font></td>
<td WIDTH="13%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">数据类型</font></td>
<td WIDTH="71%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">说明</font></td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">id</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">自动编号</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">编号</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">storage_id</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">数字</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">仓库编号，用来识别此记录所属哪个仓库</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">rq</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">日期/时间</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">报表日期，做报表的日期，一般一天是做一次</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">isprint</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">是/否</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">是否打印报表</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">user</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">操作员，做报表的用户，显示为登录时的用户名</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">sj</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">日期/时间</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">报表时间，产生报表的时间</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">count_in</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">收入统计金额，今日报表产生的入库总金额</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">count_out</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">发出统计金额，今日报表产生的出库总金额</td>
</tr>
</table>
<p ALIGN="RIGHT">[ <a href="#top">TOP</a> ] </p>
<p ALIGN="JUSTIFY"><strong>Stock<br>
</strong>此表记录仓库中的具体的品名的描述。</p>
<table BORDER="1" CELLSPACING="0" CELLPADDING="7" WIDTH="100%" bordercolorlight="#000000"
bordercolordark="#FFFFFF">
<tr>
<td WIDTH="17%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">字段名称</font></td>
<td WIDTH="13%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">数据类型</font></td>
<td WIDTH="71%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">说明</font></td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">storage_id</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">数字</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">仓库编号，用来识别当前品名所属哪个仓库</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">type_id</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">数字</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">类型编号，标记当前品名属于哪个类别</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">name_id</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">自动编号</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">品名编号，编辑品名的唯一性编号</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">name</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">品名，物品的名称</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">unit</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">单位</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">计量单位，用来计量物品的单位，如：只、台，个等</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">now_stock</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">当前库存数，描述当前物品在当前仓库的库存数量</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">now_sum</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">当前库存总金额，描述当前物品在当前仓库的库存总金额</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">last_stock</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">昨日库存，昨日的库存数量</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">pic</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">图片，显示该物品的图片，（暂时没有）</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">memo</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">备注，描述物品的更多的信息</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">max</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">最大储存量，物品最大的仓库储存量，用来检验库存是否超出</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">min</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">货币</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">最小储存量，物品最小的仓库储存量，用来检验库存是否不足</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">address</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">储存地点，物品在仓库中存放的地点，如一号货架</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">rule</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">规格，该物品的规格，如彩电29寸</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">no</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">货号</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">hm</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">货名</td>
</tr>
</table>
<p ALIGN="RIGHT">[ <a href="#top">TOP</a> ] </p>
<p ALIGN="JUSTIFY"><strong>Storage<br>
</strong>仓库名列表，一个企业会有许多的仓库，就存放在这个库中。</p>
<table BORDER="1" CELLSPACING="0" CELLPADDING="7" WIDTH="100%" bordercolorlight="#000000"
bordercolordark="#FFFFFF">
<tr>
<td WIDTH="17%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">字段名称</font></td>
<td WIDTH="13%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">数据类型</font></td>
<td WIDTH="71%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">说明</font></td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">storage_id</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">自动编号</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">仓库编号</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">storage_name</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">仓库名称，如一号仓库，二号仓库等</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">memo</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">备注</td>
</tr>
</table>
<p ALIGN="RIGHT">[ <a href="#top">TOP</a> ] </p>
<p ALIGN="JUSTIFY"><strong>Type<br>
</strong>该表用来分类时的记录，由于该系统使用了无限分类方案，所以需要该表存放某仓库下分类的情况。</p>
<table BORDER="1" CELLSPACING="0" CELLPADDING="7" WIDTH="100%" bordercolorlight="#000000"
bordercolordark="#FFFFFF">
<tr>
<td WIDTH="17%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">字段名称</font></td>
<td WIDTH="13%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">数据类型</font></td>
<td WIDTH="71%" VALIGN="TOP" BGCOLOR="#c0c0c0"><font COLOR="#0000ff"><p ALIGN="CENTER">说明</font></td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">type_name</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">文本</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">类型名称，如食品，五金，日用品等</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">type_id</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">自动编号</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">类型编号，用来识别类别</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">in_storage</td>
<td WIDTH="13%" VALIGN="TOP"><p ALIGN="JUSTIFY">数字</td>
<td WIDTH="71%" VALIGN="TOP"><p ALIGN="JUSTIFY">所属仓库，每一个仓库都可以有自己的一套分类方案，所以要分清</td>
</tr>
<tr>
<td WIDTH="17%" VALIGN="TOP"><p ALIGN="JUSTIFY">parent_id</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -