深圳全飞鸿

标题: rksdt表的相关信息 [打印本页]

作者: zhgc 时间: 2020-11-8 21:28
标题: rksdt表的相关信息
rksdt表的相关信息

目标：R_KITTING_SCAN_DETAIL_T

以下几咱移动类型：
select * from smt.rksdt where move_type='i'  IQC->WHS
select * from smt.rksdt where move_type='f' KITTING->WHS
select * from smt.rksdt where move_type='e'  WO->KITTING
select * from smt.rksdt where move_type='d'  WO->SETUP   RETURN退料
select * from smt.rksdt where move_type='c'  WO->LINE       工单发料
select * from smt.rksdt where move_type='b'  KITTING->WO  备入工单
select * from smt.rksdt where move_type='a'  WHS->KITTING

欢迎光临深圳全飞鸿 (http://www.nagomes.com/disc/)