编辑代码

select  JGFDMC as "机构法定名称",
        JGLX as "机构类型",
        CYZHMC as "持有账户名称",
        CYZHDM as "持有账户代码",
        TZXS as "投资形式",
        ZJLY as "资金来源",
        BXZGCPMC as "保险资管产品名称",
        BXZGCPDM as "保险资管产品代码",
        WTTZSTRMC as "委托投资受托人名称",
        WTTZSTRTYSHXYDM as "委托投资受托人统一社会信用代码",
        CKZSSBH as "存款证实书编号",
        CKLX as "存款类型",
        CXBS as "存续标识",
        CKYHZXFDMC as "存款银行总行法定名称",
        CKYHZXZJHM as "存款银行总行证件号码",
        CKYHFDMC as "存款银行法定名称",
        CKYHZJHM as "存款银行证件号码",
        CKYHSZD as "存款银行所在地",
        CKYHWBXYPJ as "存款银行外部信用评级",
        TGYHFDMC as "托管银行法定名称",
        TGYHZJLX as "托管银行证件类型",
        TGYHZJHM as "托管银行证件号码",
        TGYHZJDQR as "托管银行证件到期日",
        TGYHLEIBM as "托管银行LEI编码",
        CKQXR as "存款起息日",
        CKDQR as "存款到期日",
        CKQX as "存款期限",
        QXDW as "期限单位",
        LLLX as "利率类型",
        CKLL as "存款利率",
        JXJZ as "计息基准",
        JZLL as "基准利率",
        LC as "利差",
        LLMS as "利率描述",
        HJHSFF as "会计核算方法",
        HJFL as "会计分类",
        CB as "成本",
        ZMYE as "账面余额",
        JZZB as "减值准备",
        JZSS as "减值损失",
        ZMJZ as "账面价值",
        DQSYL as "当期收益率",
        ZJYCTQZQRQ as "最近一次提前支取日期",
        SFZY as "是否质押",
        ZYZSSBH as "质押证实书编号",
        ZYYT as "质押用途",
        ZYRZJE as "质押融资金额",
        ZYQSRQ as "质押起始日期",
        ZYQX as "质押期限",
        ZYQXDW as "质押期限单位",
        ZYDSFFDMC as "质押对手方法定名称",
        ZYDSFZJLX as "质押对手方证件类型",
        ZYDSFZJHM as "质押对手方证件号码",
        ZYDSFZJDQR as "质押对手方证件到期日",
        ZYDSFLEIBM as "质押对手方LEI编码",
        WYBXHJ as "违约本息合计",
        WYBJYE as "违约本金余额",
        WYLXYE as "违约利息余额",
        WYFSRQ as "违约发生日期",
        CYZT as "持有状态",
        TCFS as "退出方式",
        SJTCRQ as "实际退出日期",
        BZ as "备注",
        SJRQ as "数据日期" 
from ZBD_YW_BXJGCYCKZSSXXB_D 
where sjrq >='20210101' and sjrq<='20241231' and DIS_DAILY='2025-01-05';