-- 查询采购申请单-采购订单的转换规则 SELECT b.FNAME AS 单据转换规则名称,a.FID AS 单据转换规则内码,a.FKERNELXML AS 转换规则元数据,c.FNAME AS 源单名称,d.FNAME AS 目标单名称,a.* FROM T_META_CONVERTRULE a LEFT JOIN T_META_CONVERTRULE_L b ON a.FID=b.FID AND b.FLOCALEID=2052 LEFT JOIN T_META_OBJECTTYPE_L c ON a.FSOURCEFORMID=c.FID AND c.FLOCALEID=2052 LEFT JOIN T_META_OBJECTTYPE_L d ON a.FTARGETFORMID=d.FID AND d.FLOCALEID=2052 WHERE a.FSOURCEFORMID='PUR_Requisition' AND a.FTARGETFORMID='PUR_PurchaseOrder' --获取到待删除的单据转换规则的内码后，执行以下SQL，进行删除。 -- 删除转换规则，FID是转换规则的内码 DELETE FROM T_META_CONVERTRULE WHERE FID='005056af-13b3-bd30-11e4-e747e5b3cdfe'; DELETE FROM T_META_CONVERTRULE_L WHERE FID='005056af-13b3-bd30-11e4-e747e5b3cdfe';