后台删除单据附件

1、查询单据附件的关联关系ID及附件ID；此处关联了费用管理系统的相关表单，如果需要增加，按照格式扩展即可

SELECT  

T.FNUMBER  AS 单据编号,

T.FID  AS 单据ID,

B.FNAME_L2  AS 附件名称,

B.FID  AS 附件ID ,

A.FID AS 关联关系ID

FROM 

(

(SELECT FID,FNUMBER  FROM T_BC_OtherExpenseBill )UNION   --费用申请单

(SELECT FID,FNUMBER  FROM T_BC_DailyLoanBill )UNION         --借款单

(SELECT FID,FNUMBER  FROM T_BC_BizAccountOutBill )UNION  --对公报销单

(SELECT FID,FNUMBER  FROM T_BC_EvectionReqBill )UNION    --出差申请单

(SELECT FID,FNUMBER  FROM T_BC_EvectionLoanBill )UNION   --出差借款单

(SELECT FID,FNUMBER  FROM T_BC_TravelAccountBill )UNION  --差旅费报销单

(SELECT FID,FNUMBER  FROM T_IM_MakeInvoice )UNION        --开