信托文件存储地址

------------产品详情文件---------------------
SELECT MB.ID 附件ID,
‘/home/crm2/data/app/TDZHTYSMB’ 附件路径,
‘pdf’ 附件名,
‘信托合同’ 附件标题,
MB.pdf 附件名称
FROM TDZHTYSMB MB WHERE SFSX=1 and MB.CPID=27336
UNION ALL
SELECT XM.ID 附件ID,
‘/home/crm2/data/app/TXSXM’ 附件路径,
‘CPTJS’ 附件名,
‘信托计划说明书’ 附件标题，
XM.CPTJS 附件名称
FROM TXSXM XM WHERE XM.CPTJS IS NOT NULL AND XM.CPID=27336
------------持有详情-----------------------------------------

   SELECT  HT.ID                  附件ID,
   '/home/crm2/data/app/PDF_PATH/htqrd'   附件路径,
   'pdf'                        附件名,
   '认购确认单'                 附件标题 
   FROM THTXX HT 
   WHERE HT.SFSCQRD=1 AND HT.ID=27336
   UNION ALL 
   SELECT HTLS.ID               附件ID,
   '/home/crm2/data/app/TCUST_APP_KHQYLS' 附件路径,
   'FJ'      附件名,
   '信托合同' 附件标题
  FROM  TCUST_APP_KHQYLS HTLS
  WHERE HTLS.ZT=1
  AND HTLS.CPYYID= -99UNION ALL
   SELECT  XM.ID      附件ID,
   '/home/crm2/data/app/TXSXM' 附件路径,
   'CPTJS'        附件名,
   '信托计划说明书'   附件标题
   FROM TXSXM XM WHERE XM.CPTJS IS NOT NULL AND XM.ID=