上级单据删除后，下级单据不能删除

yonnon

885次浏览编辑于2015年03月16日 15:23:39

场景：
运费单下推应付单，之前没配删除条件，运费单删除后应付单不能删除。
delete
FROM T_BF_InstanceEntry
WHERE FInstanceId in (select FInstanceId from T_BF_Instance where FInstanceId = '5502953d0f2c77817d')
delete FROM T_BF_Instance WHERE T_BF_Instance.FInstanceId = '5502953d0f2c77817d';
delete
FROM T_AP_PAYABLE_LK
WHERE FEntryID in (select FEntryID from T_AP_PAYABLEENTRY e,T_AP_PAYABLE p where e.fid=p.fid and p.fid='103027');