--接收SCM入库订单接口数据
SELECT A.*,A.rowid FROM ERPIFINFORMTBL A WHERE 1=1;
SELECT A.*,A.rowid FROM ERPIFINFORMDTTBL A WHERE 1=1;
--WMS到货确认接口数据
SELECT A.*,A.rowid FROM WMSIFRECCONFIRMTBL A WHERE 1=1;
SELECT A.*,A.rowid FROM WMSIFRECCONFIRMDETAILTBL A WHERE 1=1;
--入库实绩WMS接口数据
SELECT A.*,A.rowid FROM WMSIFSTOCKINACTTBL A WHERE 1=1;
SELECT A.*,A.rowid FROM WMSIFSTOCKINACTDETAILTBL A WHERE 1=1;
--接收SCM出库接口数据
SELECT A.*,A.rowid FROM ERPIFOUTFORMTBL A WHERE 1=1;
SELECT A.*,A.rowid FROM ERPIFOUTFORMDETAILTBL A WHERE 1=1;
--出库实绩WMS接口数据
SELECT A.*,A.rowid FROM WMSIFSTOCKOUTACTTBL A WHERE 1=1;
SELECT A.*,A.rowid FROM WMSIFSTOCKOUTACTDETAILTBL A WHERE 1=1;
--SCM下传抽单接口数据
SELECT A.*,A.rowid FROM IFFEEDBACKTBL A WHERE 1=1 ORDER BY NOTEDATE DESC ;
SELECT A.*,A.rowid FROM IFFEEDBACKDETAILTBL A WHERE 1=1;
--品质变更WMS接口数据
SELECT A.*,A.rowid FROM IFQUALITYCHANGETBL A WHERE 1=1 ORDER BY CREATETIME DESC ;
SELECT A.*,A.rowid FROM IFQUALITYCHANGEDETAILTBL A WHERE 1=1;
--接收SCM品质变更接口数据(移库前)
IFQUALITYCHANGEBACKTBL
IFQUALITYCHANGEBACKDETAILTBL
--库存调整WMS接口数据 对 SCM 4420
SELECT A.*,A.rowid FROM IFSTOCKADJTBL A WHERE 1=1 ORDER BY CREATETIME DESC ;
SELECT A.*,A.rowid FROM IFSTOCKADJDETAILTBL A WHERE 1=1;
--WMS锁定解锁接口数据
SELECT A.*,A.rowid FROM IFWMSSTOCKLOCKTBL A WHERE 1=1 ORDER BY CREATETIME DESC ;
SELECT A.*,A.rowid FROM IFWMSSTOCKLOCKDETAILTBL A WHERE 1=1;
文档更新时间: 2023-12-28 17:28 作者:周骏