用友 U8 产成品入库单数据库关联生产订单检验单

SELECT * FROM dbo.mom_order WHERE MoCode='222221556'

SELECT QualifiedInQty,* FROM mom_orderdetail WHERE MoId='1000006560'

--UPDATE mom_orderdetail SET QualifiedInQty = 4 WHERE MoId='1000006559'

SELECT cMPoCode,* FROM rdrecord10 a WHERE a.cCode='0000003612'

SELECT cMPoCode,* FROM rdrecord10 b WHERE b.cCode='0000003611'

rdrecord10修改cMPoCode、

--UPDATE rdrecords10 SET iMPoIds=1000007898 WHERE id IN ('1000138682')

SELECT * FROM rdrecords10 WHERE id IN ('1000138682','1000138677','1000138699')

UPDATE rdrecord10 SET cSource='产品检验单' WHERE cCode IN('0000003613','0000003612')

iNQuantity、 iMPoIds（生产订单子表ID）、cCheckCode（检验单号）、iCheckIdBaks（检验单子表ID）cCheckPersonCode（检验员）、

dCheckDate（检验日期）cmocode（生产订单号）imoseq（生产订单行号）

SELECT * FROM QMCHECKVOUCHER WHERE CCHECKCODE IN ('20231217030','20231228003')

--UPDATE QMCHECKVOUCHER SET FsumQuantity=4 WHERE CCHECKCODE IN ('20231218002','20231217030')