INFOR WMS仓储管理系统里常用表说明

--主数据
select * from sku;   
select * from pack;   
select * from userdatatranslation;
select * from storer a where a.type='1' ;

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='03' ; --出库单
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' ;