--主数据

select * from sku;

select * from pack;

select * from userdatatranslation;

select * from storer a where a.type='' ;

SELECT * FROM LOC ;

SELECT * FROM PUTAWAYZONE ;

SELECT * FROM AREA;

SELECT * FROM AREADETAIL ;

--业务单据

select * from po; --采购订单

select * from podetail;

select a.type,a.* from receipt a ; --收货表

select a.pokey,a.polinenumber,A.* from receiptdetail a ;

select * from dropid ; --托盘与箱的关系表；

select * from dropiddetail ;

select a.type,a.externorderkey,a.externalorderkey2,a.* from orders a where a.type='' ; --出库单

select * from orderdetail ;

select * from transfer a ; --内部转移

select * from transferdetail a ;

select * from adjustment ; --库内调整

select * from adjustmentdetail ;

select * from cclst ;--盘点请求

select * from cc ;  --盘点结果；

select * from ccdetail ;

--任务相关

select * from taskdetail ; --任务表

select * from pickdetail ; --拣货明细 ;

--库存相关

select * from lotattribute ;--批次号

select * from lot ; --批次库存

select * from lotxlocxid; --明细库存

select * from skuxloc ; --库位库存

select distinct a.trantype from itrn a ;--库存交易；

select sum(a.qty) from itrn a where a.trantype in ('DP','AJ','WD') and a.adddate<to_date() ;

--系统配置表

select * from codelist  where listname='RECEIPTYPE'   ;--系统代码

select * from codelkup where listname='RECEIPTYPE' ;