反向同步订单排查语句

1.触发器触发至tbl_handlelog中间表数据

1.查看该团体备单至中间表多少条数据

select to_char(keyid) from tbl_handlelog where to_char(keyid) in 
(select to_char(tjh000) from HM_YW_TJZ000 where rwid00 = '1202') 
group by to_char(keyid)

2.同步至tbl_inv_group_person表数据

1.查看插入中间表多少条数据

upload: 0,未同步 1,已同步

select * from tbl_inv_group_person where hiscompanycode ='1202'