数据库表
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; -- 盘点货架及商品陈列清单