--查询单据注意id信息 select ID, * from ST_RDRecord where code in('MD-2025-09-0069','MD-2025-09-0070','MD-2025-09-0076' ) select idRDRecordDTO, * from ST_RDRecord_b WHERE idRDRecordDTO IN ('49538','49540','49551') if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); } --删除单据 delete ST_RDRecord where code in('MD-2025-09-0069','MD-2025-09-0070','MD-2025-09-0076' ) delete ST_RDRecord_b WHERE idRDRecordDTO IN ('49538','49540','49551') if(window.hljsLoader && !document.currentScript.parentNode.hasAttribute('data-s9e-livepreview-onupdate')) { window.hljsLoader.highlightBlocks(document.currentScript.parentNode); }

T+数据库删除单据

用友小张

--查询单据注意id信息

select ID,
* from
ST_RDRecord

where code in('MD-2025-09-0069','MD-2025-09-0070','MD-2025-09-0076'   )

select idRDRecordDTO,
* from
ST_RDRecord_b
WHERE  idRDRecordDTO IN ('49538','49540','49551')

--删除单据

delete ST_RDRecord
where  code in('MD-2025-09-0069','MD-2025-09-0070','MD-2025-09-0076'   )
delete ST_RDRecord_b
WHERE  idRDRecordDTO IN ('49538','49540','49551')