SELECT t1.ID_POSITION_DATE          AS "持仓日期"
        ,'一般账户'                 AS "所属账户"
       /*       t.RPS_PORT_NAME,--考核名称
       t.ALLOCATION_PROPERTIES,
       t.STRATEGY_PROPERTIES,*/
       ,t1.VALUATION_PORT_CODE      AS "子组合代码"
       ,t1.VALUATION_PORT_NAME      AS "子组合名称"
       ,t1.ID_INVESTMENT_CODE       AS "会计分类E"
       ,t1.SEC_TL4_NAME             AS TL4
       ,T1.BOND_FLAG_LV2   		 as "资产分类"
       ,T1.RPS_PORT_CODE   
       ,IS_APPRAISED
       ,IS_DRILL      			  AS CT
         ,T1.INVEST_FUND_NAME             AS    "账户名称"  
       ,T2.FIX_MANAGER                  AS    "实际投资经理"
       ,t1.ALLOCATION_PROPERTIES              AS    "配置情况"
       ,T1.SEC_MARKET_CODE              AS    "证券市场代码"
       ,T1.SEC_SHT_NAME                 AS    "证券名称"
       ,T1.fi_level2_flag               AS    "固收二级分类"
       ,T1.SEC_TL4_NAME                 AS    "证券TL4类别"
       ,T1.bond_flag_n                  AS    "债券\债权标识"
       ,T1.SHARE_COUNT                  AS    "数量"
       ,T1.PORT_ORIG_COST               AS    "原始成本"
       ,T1.PORT_NET_ORIG_COST           AS    "净价成本"
       ,T1.COST_YTM                     AS    "成本YTM"
       ,T1.COST_DURATION                AS    "成本修正久期"
       ,T1.RATE_RECEIVE / 100           AS    "票面利率"
       ,T1.RESIDUAL_MATURITY_OPTION     AS    "实际剩余期限"
       ,T1.EXCHANGE_NAME                AS    "交易场所"
       ,T1.ID_POS_STATUS                AS    "持仓状态"
       ,(ID_INVESTMENT_KIND)            AS    "会计分类"
       ,T1.BOND_CREDIT_RATING_INNER     AS    "债项内部评级"
       ,T1.BOND_CREDIT_RATING           AS    "债项外部评级"
       ,T1.BOND_CREDIT_RATING_COMNAME   AS    "评级机构"
       ,T1.ISSUER_NAME                  AS    "发行主体"
       ,T1.ISSUER_CREDIT_INNER          AS    "主体内部评级"
       ,T1.ISSUER_CREDIT_OUTTER         AS    "主体外部评级"
       ,T1.PORT_INTE_ADJU               AS    "利息调整"
       ,T1.PORT_INTE_RECE               AS    "应收利息（含应计利息）"
       ,T1.PORT_INTE_RECE_A             AS    "应收利息（不含应计利息）"
       ,T1.PORT_FULL_COST               AS    "全价成本"
       ,T1.ASSET_VALUATION_VALUE_ADDED  AS    "估值增值"
       ,T1.PORT_FULL_VALUE              AS    "全价市值"
       ,T1.PORT_NET_BOOK_VALUE          AS    "账面价值"
       ,T1.ASSET_DIMI_VALUE             AS    "减值金额"
       ,T1.CB_MDURATION                 AS    "中债修正久期"
       ,T1.CB_YIELD / 100               AS    "中债到期收益率"
       ,T1.CB_DIFFDURATION              AS    "中债利差久期"                                    
       ,T1.WIND_REAL_YIELD / 100        AS    "Wind行情到期收益率"
       ,T1.WIND_PUTABLE_YIELD / 100     AS    "Wind回售到期收益率"
       ,T1.WIND_REAL_MDURATION          AS    "Wind行情修正久期"
       ,T1.RATE_TYPE_RECEIVE            AS    "利率类型"
       ,T1.START_DATE                   AS    "起息日"
       ,T1.MATURITY_DATE                AS    "实际到期日"
       ,T1.PUTABLE_FLAG                 AS    "是否行权（是否可回售）"
       ,CASE WHEN (PUTABLE_FLAG = '不可回售' OR PUTABLE_START_DATE = DATE '1900-1-2') THEN '无'
         ELSE TO_CHAR(PUTABLE_START_DATE, 'yyyy-mm-dd') 
           END                             AS    "行权日（回售日期）"
       ,T1.CALLABLE_FLAG               AS    "是否行权（是否可赎回）"
       ,CASE WHEN (CALLABLE_FLAG = '不可赎回' OR CALLABLE_START_DATE = DATE '1900-1-2') THEN '无'
         ELSE TO_CHAR(CALLABLE_START_DATE, 'yyyy-mm-dd')
           END                         AS    "行权日（赎回日期）"
       ,NULL                           AS    "提前还本日期"
       ,(ID_POSITION_DATE - T1.PUTABLE_START_DATE) / 365       AS    "回售剩余期限"
       ,T1.BOND_INDUSTRY_NAME1         AS    "内部行业分类"
       ,T1.BOND_CREDIT_RATING_CICC     AS    "中金评级"
       ,DECODE(T1.ISSUER_CREDIT_OUTTER_ANTIC, '1', '正面', '2', ' 稳定', '3', ' 负面', '4', ' 列入评级观察(可能调高)', '5', ' 列入评级观察(可能调低)', '6', ' 列入评级观察(走势不明)', '7', ' 待决', T1.ISSUER_CREDIT_OUTTER_ANTIC) AS "主体外部评级展望"
  from dm.V_FIXINCOME_APPRAISE_FACT_ALL t1
  LEFT JOIN DM.FIXINCOME_LOGIN_AUTHORITY T2
    ON T1.INVEST_FUND_NAME = T2.INVEST_FUND_NAME
    where  NVL(T1.IS_DRILL,'XX') IN ('${穿透参数}','XX') --穿透参数（默认穿透后）
   --AND T1.ID_REC_ENDDATE = DATE '2199-12-31'
   --AND T1.STRATEGY_PROPERTIES IS NULL
   AND T1.ID_POSITION_DATE = to_date( '${结束日期}','yyyy-mm-dd')
   AND t1.ALLOCATION_PROPERTIES ||  case when t1.STRATEGY_PROPERTIES is not null then '-'|| t1.STRATEGY_PROPERTIES else '' end  in ('${策略}')
  -- AND t1.INVEST_FUND_NAME  in (${"'"+JOINARRAY(账户名称,"','")+"'"})
  /*and  (1=1  ${if(len(账户名称) == 0,"","and  t1.INVEST_FUND_NAME in ('" + SUBSTITUTE(账户名称,",","','") + "')")})*/
  ${if(len(账户名称)==0||账户名称=="''","","and t1.INVEST_FUND_NAME  in ('"+ SUBSTITUTE(账户名称,",","','") +"') ")}   --账户名称是参数，t1.INVEST_FUND_NAME是字段名
     AND (1=1  ${if(len(资产分类) == 0,"","and T1.BOND_FLAG_LV2 in ('" +资产分类 + "')")})