数据库表

select \* from stktakeindex; -- 盘点要素表\ select \* from stktakemodel; -- 盘点模型\ select \* from stktakemodelitem; -- 盘点模型明细表\ select \* from stktakemodellist; -- 盘点模型查询(审核后) select \* from stktakeplanplace; -- 卖场\ select \* from stktakeplan; -- 盘点计划(总部)\ select \* from stktakeplanitem; -- 总部盘点计划明细表(根据盘点范围)\ select \* from stktakeplanshop; -- 总部盘点计划选择的门店 select \* from stktakeshopplan; -- 盘点计划(门店)\ select \* from stktakeshopplanitem; -- 门店盘点计划明细表\ select \* from stktakeplanlistplace;\ select \* from stktakeplantask; select \* from stktakegoodslist; -- 账存锁定\ select \* from stktakegoodstask; -- 盘点流程驱动任务控制 select \* from stktakeinput; -- 盘点单据(初盘单/盘点更正单/复盘单/复盘更正单)\ select \* from stktakeinputitem; -- 明细表\ select \* from stktakerptdiffinput; -- 初盘复盘对比报表\ select \* from stktakerptcheckinput; -- 盘点检查报表 select \* from stktakerptgoodslist;\ select \* from stktaketotalprepl;\ select \* from stktaketotalpreplitem;\ select \* from stktaketotalpl;\ select \* from stktakepl; -- 盘点盈亏记账\ select \* from stktakeplitem;\ select \* from stktakepreplacc; -- 预览记账(已废除)\ select \* from stktakeprepl;\ select \* from stktakepreplitem;\ select \* from stktakepl;\ select \* from stktakeplitem;\ select \* from stktakeplacc; select \* from stktakenoplaninput; -- 盘点录入单(无计划)\ select \* from stktakenoplaninputitem; -- 明细表 select \* from stktakeshelves; -- 盘点货架维护单\ select \* from stktakeshelvesitem;\ select \* from stktakeshelveslist; -- 盘点货架清单\ select \* from stktakeshelvesgoods; -- 盘点货架及商品陈列维护单\ select \* from stktakeshelvesgoodsitem;\ select \* from stktakeshelvesgoodslist; -- 盘点货架及商品陈列清单