select *
from ANAL_ZQTZJHJBXXB
where C_FUNDNAME || D_PRDINTENDDATE in
(select C_FUNDNAME || D_PRDINTENDDATE
from ANAL_ZQTZJHCYXXB
where MEM_NAME LIKE '%太平再保险%' and D_PRDINTENDDATE>= '2022-10-01')
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
CPQC as "产品全称",
CPDM as "产品代码",
CPDJBM as "产品登记编码",
CPGLJGNBCPDM as "产品管理机构内部产品代码",
ZCFZLX as "资产负债类型",
ZCXZ as "资产性质",
SFFBZHZQZC as "是否非标准化债权资产",
ZCLX as "资产类型",
FZLX as "负债类型",
QYLX as "权益类型",
CKLX as "存款类型",
CKXDM as "存款行代码",
CKHMC as "存款行名称",
CKHZHDM as "存款行总行代码",
CKHZHMC as "存款行总行名称",
CKQX as "存款期限（天）",
ZQLX as "债券类型",
ZQZXWBPJ as "债券最新外部评级",
JJLX as "基金类型",
BXZGCPLX as "保险资管产品类型",
ZCFZQYXMC as "资产/负债/权益项名称",
ZCDM as "资产代码",
QMZMYE as "期末账面余额（元）",
JZZB as "减值准备（元）",
JZSS as "减值损失（元）",
QMZMJZ as "期末账面价值（元）",
ZCPJZCBL as "占产品净资产比例",
ZCDQR as "资产到期日",
FBZHZQZCGLRJGMC as "非标准化债权资产管理人机构名称",
FBZHZQZCGLRJGDM as "非标准化债权资产管理人机构代码",
ZJTXGLGX as "资金投向关联关系",
BSLXRXM as "登记联系人姓名",
BSLXRBM as "登记联系人部门",
BSLXRLXDH as "登记联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YN_ZHLCPZCFZMXB_RE
where cpqc||sjrq in( select cpqc||sjrq
from ZBD_YN_ZHLCPCYRMXB_RE
where zhssrmc like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' );
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
CPQC as "产品全称",
CPDM as "产品代码",
CPDJBM as "产品登记编码",
FJCPDM as "分级产品代码",
CPGLJGNBCPDM as "产品管理机构内部产品代码",
ZJLY as "资金来源",
CYRZHMC as "持有人账户名称",
CYRZH as "持有人账号",
ZHSSRMC as "账户所属人名称",
ZHSSRZJLE as "账户所属人证件类型",
ZHSSRZJDM as "账户所属人证件代码",
CYRZHLX as "持有人账户类型",
ZHSSJGLX as "账户所属机构类型",
FFRCPMC as "非法人产品名称",
FFRCPLX as "非法人产品类型",
SFYCPGLRCZGLGX as "是否与产品管理人存在关联关系",
YGLRGX as "与管理人关系",
QMCYGM as "期末持有规模（元）",
QMCYFE as "期末持有份额（份）",
CYCPJB as "持有产品级别",
BSLXRXM as "登记联系人姓名",
BSLXRBM as "登记联系人部门",
BSLXRLXDH as "登记联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YN_ZHLCPCYRMXB_RE
where zhssrmc like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331';
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
CPQC as "产品全称",
CPDM as "产品代码",
CYJGQC as "持有机构全称",
CYJGTYSHXYDM as "持有机构统一社会信用代码",
CYJGLX as "持有机构类型",
ZJLX as "资金类型",
CPMC as "产品名称",
JRZCGLCPLX as "金融资产管理产品类型",
CYRZH as "持有人账号",
QMCYGM as "期末持有规模",
QMCYFE as "期末持有份额",
BQFEBD as "本期份额变动",
SFYCPGLRCZGLGX as "是否与产品管理人存在关联关系",
YGLRGX as "与管理人关系",
CYCPJB as "持有产品级别",
BSLXRXM as "登记联系人姓名",
BSLXRBM as "登记联系人部门",
BSLXRLXDH as "登记联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YN_ZXCPCYRFEXXB_D
where CYJGQC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06';
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH 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 "实际退出日期",
BSLXRXM as "报送联系人姓名",
BSLXRBM as "报送联系人部门",
BSLXRLXDH as "报送联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YW_BXJGCYCKZSSXXB_D
where JGFDMC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06' ;
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
JGLX as "机构类型",
CYZHMC as "持有账户名称",
CYZHDM as "持有账户代码",
TZXS as "投资形式",
ZJLY as "资金来源",
BDCXMMC as "不动产项目名称",
BDCXMDM as "不动产项目代码",
ZCMC as "资产名称",
ZCDM as "资产代码",
SSDQ as "所属地区",
CSTZRQ as "初始投资日期",
TZLX as "投资类型",
XMZT as "项目状态",
TZFS as "投资方式",
YT as "用途",
WYLX as "物业类型",
HJHSFF as "会计核算方法",
HJFL as "会计分类",
TZYZ as "投资原值",
QMCB as "期末成本",
ZMYE as "账面余额",
JZZB as "减值准备",
JZSS as "减值损失",
ZMJZ as "账面价值",
DQSYL as "当期收益率",
LJSYL as "累计收益率",
SFCZ as "是否处置",
CZRQ as "处置日期",
CZJZ as "处置价值",
BSLXRXM as "报送联系人姓名",
BSLXRBM as "报送联系人部门",
BSLXRLXDH as "报送联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YW_BXJGCYJNBDCXXB_D
where JGFDMC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06';
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
BDCXMMC as "不动产项目名称",
BDCXMDM as "不动产项目代码",
BDCDYDKRZBZ as "不动产抵押贷款融资币种",
BDCDYDKRZJE as "不动产抵押贷款融资金额",
BDCDYDKRZLL as "不动产抵押贷款融资利率",
RZYX as "融资银行",
RZQX_Y as "融资期限（月）",
QXR as "起息日",
DQR as "到期日",
BSLXRXM as "报送联系人姓名",
BSLXRBM as "报送联系人部门",
BSLXRLXDH as "报送联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YW_BXJGCYJWBDCDYXXB_D
where JGFDMC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06';
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
BDCXMMC as "不动产项目名称",
BDCXMDM as "不动产项目代码",
GTTZFMC as "共同投资方名称",
GTTZFTZBZ as "共同投资方投资币种",
GTTZFCZJE as "共同投资方出资金额",
BSLXRXM as "报送联系人姓名",
BSLXRBM as "报送联系人部门",
BSLXRLXDH as "报送联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YW_BXJGCYJWBDCGTTZFXXB_D
where JGFDMC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06';
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
JGLX as "机构类型",
BDCXMMC as "不动产项目名称",
BDCXMDM as "不动产项目代码",
WYLX as "物业类型",
TZFS as "投资方式",
TZXS as "投资形式",
ZJLY as "资金来源",
JYDS as "交易对手",
CSTZRQ as "初始投资日期",
XMZT as "项目状态",
DYCSPVMC as "第一层SPV名称",
DYCSPVSLDD as "第一层SPV设立地点",
DYCSPVZCZBBZ as "第一层SPV注册资本币种",
DYCSPVZCZB as "第一层SPV注册资本",
HJHSFF as "会计核算方法",
HJFL as "会计分类",
ZMYEBZ as "账面余额币种",
ZMYE as "账面余额",
ZMYEZRMB as "账面余额折人民币",
JZZB as "减值准备",
JZSS as "减值损失",
ZMJZ as "账面价值",
BXGSTZBZ as "保险公司投资币种",
BXGSCZJE as "保险公司出资金额",
RZBZ as "融资币种",
RZJE as "融资金额",
TZJEHJBZ as "投资金额合计币种",
TZJEHJ as "投资金额合计",
TZJEZRMB as "投资金额折人民币",
YQSYL as "预期收益率",
SFYGTTZF as "是否有共同投资方",
SFBLNBWDYW as "是否办理内保外贷业务",
SFBLBDCDYDK as "是否办理不动产抵押贷款",
SFCZ as "是否当期发生资产处置",
BSLXRXM as "报送联系人姓名",
BSLXRBM as "报送联系人部门",
BSLXRLXDH as "报送联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YW_BXJGCYJWBDCXXB_D
where JGFDMC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06' ;
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
JGLX as "机构类型",
CYZHMC as "持有账户名称",
CYZHDM as "持有账户代码",
TZXS as "投资形式",
ZJLY as "资金来源",
BXZGCPMC as "保险资管产品名称",
BXZGCPDM as "保险资管产品代码",
WTTZSTRMC as "委托投资受托人名称",
WTTZSTRTYSHXYDM as "委托投资受托人统一社会信用代码",
CPMC as "产品名称",
CPDM as "产品代码",
CPQSRQ as "产品起始日期",
CPYJZZRQ as "产品预计终止日期",
FXFS as "发行方式",
YXFS as "运行方式",
CPFXRFDMC as "产品发行人法定名称",
CPFXRTYSHXYDM as "产品发行人统一社会信用代码",
CPFXRZJDQR as "产品发行人证件到期日",
CPFXRLEIBM as "产品发行人LEI编码",
CPFXRSZD as "产品发行人所在地",
CPFXRLX as "产品发行人类型",
HSFS as "核算方式",
CPLX as "产品类型",
GLFS as "管理方式",
SYLX as "收益类型",
FXPJ as "风险评级",
JGHSX as "结构化属性",
JGHJB as "结构化级别",
JYJGMS as "交易结构描述",
YJBJJZ as "业绩比较基准",
DWJZ as "单位净值",
LJDWJZ as "累计单位净值",
HJHSFF as "会计核算方法",
HJFL as "会计分类",
CB as "成本",
ZMYE as "账面余额",
JZZB as "减值准备",
JZSS as "减值损失",
ZMJZ as "账面价值",
DQSYL as "当期收益率",
TZRQ as "投资日期",
TZFW as "投资范围",
CYZT as "持有状态",
TCRQ as "退出日期",
WYBXHJ as "违约本息合计",
WYBJYE as "违约本金余额",
WYLXYE as "违约利息余额",
WYFSRQ as "违约发生日期",
BSLXRXM as "报送联系人姓名",
BSLXRBM as "报送联系人部门",
BSLXRLXDH as "报送联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YW_BXJGCYLCCPXXB_D
where JGFDMC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06'
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
JGLX as "机构类型",
CYZHMC as "持有账户名称",
CYZHDM as "持有账户代码",
TZXS as "投资形式",
ZJLY as "资金来源",
BXZGCPMC as "保险资管产品名称",
BXZGCPDM as "保险资管产品代码",
WTTZSTRMC as "委托投资受托人名称",
WTTZSTRTYSHXYDM as "委托投资受托人统一社会信用代码",
XTJHQC as "信托计划全称",
CPDJBH as "产品登记编号",
XTJHDM as "信托计划代码",
XTJHCPCXBS as "信托计划产品存续标识",
TZSCPWBXYPJ as "投资时产品外部信用评级",
TZSCPWBPJJGMC as "投资时产品外部评级机构名称",
TZSCPWBPJJGDM as "投资时产品外部评级机构代码",
TZSCPWBPJSJ as "投资时产品外部评级时间",
TZSCPNBXYPJ as "投资时产品内部信用评级",
TZSCPNBPJSJ as "投资时产品内部评级时间",
DQCPWBXYPJ as "当前产品外部信用评级",
DQCPWBPJJGMC as "当前产品外部评级机构名称",
DQCPWBPJJGDM as "当前产品外部评级机构代码",
DQCPWBPJSJ as "当前产品外部评级时间",
DQCPNBXYPJ as "当前产品内部信用评级",
DQCPNBPJSJ as "当前产品内部评级时间",
XTGSMC as "信托公司名称",
XTGSZJHM as "信托公司证件号码",
ZJTX as "资金投向",
TXXYMX as "投向行业明细",
ZCBQ as "政策标签",
XTCCYYDQ as "信托财产运用地区",
RZZTFDMC as "融资主体法定名称",
RZZTZJLX as "融资主体证件类型",
RZZTZJHM as "融资主体证件号码",
RZZTZJDQR as "融资主体证件到期日",
RZZTLEIBM as "融资主体LEI编码",
RZZTLX as "融资主体类型",
RZZTSSDQ as "融资主体所属地区",
RZZTSSXY as "融资主体所属行业",
TZSRZZTWBXYPJ as "投资时融资主体外部信用评级",
TZSRZZTWBPJJGMC as "投资时融资主体外部评级机构名称",
TZSRZZTWBPJJGDM as "投资时融资主体外部评级机构代码",
TZSRZZTWBPJSJ as "投资时融资主体外部评级时间",
TZSRZZTNBXYPJ as "投资时融资主体内部信用评级",
TZSRZZTNBPJSJ as "投资时融资主体内部评级时间",
DQRZZTWBXYPJ as "当前融资主体外部信用评级",
DQRZZTWBPJJGMC as "当前融资主体外部评级机构名称",
DQRZZTWBPJJGDM as "当前融资主体外部评级机构代码",
DQRZZTWBPJSJ as "当前融资主体外部评级时间",
DQRZZTNBXYPJ as "当前融资主体内部信用评级",
DQRZZTNBPJSJ as "当前融资主体内部评级时间",
DCZCLX as "底层资产类型",
DLZCLX as "大类资产类型",
DBZTFDMC as "担保主体法定名称",
DBZTZJLX as "担保主体证件类型",
DBZTZJHM as "担保主体证件号码",
DBZTZJDQR as "担保主体证件到期日",
DBZTLEIBM as "担保主体LEI编码",
TZBZ as "投资币种",
CYFEQXR as "持有份额起息日",
CYFEYQDQR as "持有份额预期到期日",
CSCYFE as "初始持有份额",
QMCYFE as "期末持有份额",
QMCYGMZB as "期末持有规模占比",
YGLFHJQMCYGMZB as "与关联方合计期末持有规模占比",
HJHSFF as "会计核算方法",
HJFL as "会计分类",
CB as "成本",
ZMYE as "账面余额",
JZZB as "减值准备",
JZSS as "减值损失",
ZMJZ as "账面价值",
DQSYL as "当期收益率",
SSFJ as "所属分级",
SYLLX as "收益率类型",
CYRYQSYL as "持有人预期收益率",
SYLMS as "收益率描述",
ZXDWJZ as "最新单位净值",
LJDWJZ as "累计单位净值",
GZRQ as "估值日期",
CYZT as "持有状态",
TCFS as "退出方式",
SJTCRQ as "实际退出日期",
BSLXRXM as "报送联系人姓名",
BSLXRBM as "报送联系人部门",
BSLXRLXDH as "报送联系人联系电话",
BZ as "备注",SJRQ as "数据日期"
from ZBD_YW_BXJGCYXTJHXXB_D
where JGFDMC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06';
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
JGLX as "机构类型",
CYZHMC as "持有账户名称",
CYZHDM as "持有账户代码",
TZXS as "投资形式",
ZJLY as "资金来源",
WTTZSTRMC as "委托投资受托人名称",
WTTZSTRTYSHXYDM as "委托投资受托人统一社会信用代码",
BXZGCPMC as "保险资管产品名称",
BXZGCPDM as "保险资管产品代码",
XMLB as "项目类别",
SFSSJY as "是否上市交易",
CPQC as "产品全称",
CPJC as "产品简称",
CPDM as "产品代码",
ZJTX as "资金投向",
JCZCLX as "基础资产类型",
HJHSFF as "会计核算方法",
HJFL as "会计分类",
CB as "成本",
ZMYE as "账面余额",
JZZB as "减值准备",
JZSS as "减值损失",
ZMJZ as "账面价值",
DQSYL as "当期收益率",
TZRQ as "投资日期",
CPGLJG_FXJGFDMC as "产品管理机构/发行机构法定名称",
CPGLJG_FXJGZJLX as "产品管理机构/发行机构证件类型",
CPGLJG_FXJGZJHM as "产品管理机构/发行机构证件号码",
CPGLJG_FXJGZJDQR as "产品管理机构/发行机构证件到期日",
CPGLJG_FXJGLEIBM as "产品管理机构/发行机构LEI编",
JZC as "净资产",
YSQYR_FQJGFDMC as "原始权益人/发起机构法定名称",
YSQYR_FQJGZJLX as "原始权益人/发起机构证件类型",
YSQYR_FQJGZJHM as "原始权益人/发起机构证件号码",
YSQYR_FQJGZJDQR as "原始权益人/发起机构证件到期日",
YSQYR_FQJGLEIBM as "原始权益人/发起机构LEI编码",
YSQYR_FQJGXY as "原始权益人/发起机构行业",
JCZCMC as "基础资产名称",
JCZCLB as "基础资产类别",
CPQXR as "产品起息日",
CPDQR as "产品到期日",
SFHQ as "是否含权",
HQJG as "含权结构",
XZQLX as "选择权类型",
WBXYPJ as "外部信用评级",
WBPJJG as "外部评级机构",
ZJYY as "资金运用",
SSFJ as "所属分级",
JBXF as "级别细分",
YQSYL as "预期收益率",
YQSYMS as "预期收益描述",
LLLX as "利率类型",
HBFXFS as "还本付息方式",
FXZQ as "付息周期",
CYZT as "持有状态",
TCRQ as "退出日期",
WYBXHJ as "违约本息合计",
WYBJYE as "违约本金余额",
WYLXYE as "违约利息余额",
WYFSRQ as "违约发生日期",
BSLXRXM as "报送联系人姓名",
BSLXRBM as "报送联系人部门",
BSLXRLXDH as "报送联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YW_BXJGCYZCZQHCPXXB_D
where JGFDMC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06' ;
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
XMGSFDMC as "项目公司法定名称",
XMGSZJLX as "项目公司证件类型",
XMGSGSZJHM as "项目公司证件号码",
XMGSGDFDMC as "项目公司股东法定名称",
XMGSGDZJLX as "项目公司股东证件类型",
XMGSGDZJHM as "项目公司股东证件号码",
XMGSGDZJDQR as "项目公司股东证件到期日",
XMGSGDLEIBM as "项目公司股东LEI编码",
GDLB as "股东类别",
GDGB as "股东国别",
HYLX as "行业类型",
SFWXMGS as "是否为项目公司",
CZRQ as "出资日期",
ZCZBBZ as "注册资本币种",
RJJE as "认缴金额",
CZJE as "出资金额",
GDSFYX as "股东是否有效",
GQZYBL as "股权质押比例",
GQDJBL as "股权冻结比例",
BSLXRXM as "报送联系人姓名",
BSLXRBM as "报送联系人部门",
BSLXRLXDH as "报送联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YW_XMGSGDQKB_D
where JGFDMC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06';
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
XMGSFDMC as "项目公司法定名称",
XMGSZJLX as "项目公司证件类型",
XMGSZJHM as "项目公司证件号码",
BTZGSFDMC as "被投资公司法定名称",
BTZGSZJLX as "被投资公司证件类型",
BTZGSZJHM as "被投资公司证件号码",
BTZGSZJDQR as "被投资公司证件到期日",
BTZGSLEIBM as "被投资公司LEI编码",
BTZGSCJ as "被投资公司层级",
SYCBTZGSFDMC as "上一层被投资公司法定名称",
SYCBTZGSZJHM as "上一层被投资公司证件号码",
BTZGSSFWXMGS as "被投资公司是否为项目公司",
CSTZRQ as "初始投资日期",
BTZGSJYFW as "被投资公司经营范围",
TZBZ as "投资币种",
BTZGSZCZB as "被投资公司注册资本",
BTZGSSJZB as "被投资公司实缴资本",
ZCDSZGJ as "注册地所在国家",
SSDQ as "所属地区",
SZCS as "所在城市",
ZCDD as "注册地点",
HYLX as "行业类型",
RJJE as "认缴金额",
CZJE as "出资金额",
CGLX as "持股类型",
BSLXRXM as "报送联系人姓名",
BSLXRBM as "报送联系人部门",
BSLXRLXDH as "报送联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YW_XMGSGQTZQKB_D
where JGFDMC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06';
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
XMGSFDMC as "项目公司法定名称",
XMGSZJLX as "项目公司证件类型",
XMGSZJHM as "项目公司证件号码",
JKRFDMC as "借款人法定名称",
JKRZJLX as "借款人证件类型",
JKRZJHM as "借款人证件号码",
JKRZJDQR as "借款人证件到期日",
JKRLEIBM as "借款人LEI编码",
JKRLX as "借款人类型",
JKRSFWXMGSGD as "借款人是否为项目公司股东",
JKBZ as "借款币种",
JKJE as "借款金额",
JKRQ as "借款日期",
JKLLLX as "借款利率类型",
JKLL as "借款利率",
LLMS as "利率描述",
JKZXYTZJEBL as "借款占协议投资金额比例",
SFCZDZY as "是否存在抵质押",
DZYQK as "抵质押情况",
WCHBXJE as "未偿还本息金额",
YCHBXJE as "已偿还本息金额",
JKSFCZZQQK as "借款是否存在展期情况",
ZQQKSM as "展期情况说明",
JKSFCZBXWYQK as "借款是否存在本息违约情况",
WAQZFBJJE as "未按期支付本金金额",
WAQZFLXJE as "未按期支付利息金额",
SCWAQZFBXFSRQ as "首次未按期支付本息发生日期",
ZJSYQKMS as "资金使用情况描述",
BSLXRXM as "报送联系人姓名",
BSLXRBM as "报送联系人部门",
BSLXRLXDH as "报送联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YW_XMGSRZXXB_D
where JGFDMC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06' ;
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
XMGSFDMC as "项目公司法定名称",
XMGSZJLX as "项目公司证件类型",
XMGSZJHM as "项目公司证件号码",
ZCLX as "资产类型",
ZCMC as "资产名称",
ZCDM as "资产代码",
ZCGLFXJGFDMC as "资产管理/发行机构法定名称",
ZCGLFXJGZJLX as "资产管理/发行机构证件类型",
ZCGLFXJGZJHM as "资产管理/发行机构证件号码",
ZCGLFXJGZJDQR as "资产管理/发行机构证件到期日",
ZCGLFXJGLEIBM as "资产管理/发行机构LEI编码",
ZCQKSM as "资产情况说明",
RZZTFDMC as "融资主体法定名称",
RZZTZJLX as "融资主体证件类型",
RZZTZJHM as "融资主体证件号码",
RZZTZJDQR as "融资主体证件到期日",
RZZTLEIBM as "融资主体LEI编码",
SFCZGLGX as "是否存在关联关系",
GLGXSM as "关联关系说明",
CSTZRQ as "初始投资日期",
HJHSFF as "会计核算方法",
HJFL as "会计分类",
TZBZ as "投资币种",
TZYZ as "投资原值",
QMCB as "期末成本",
ZMYE as "账面余额",
JZZB as "减值准备",
JZSS as "减值损失",
ZMJZ as "账面价值",
DQSYL as "当期收益率",
LJSYL as "累计收益率",
SFCZ as "是否处置",
CZRQ as "处置日期",
CZJZ as "处置价值",
BSLXRXM as "报送联系人姓名",
BSLXRBM as "报送联系人部门",
BSLXRLXDH as "报送联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YW_XMGSTZQTZCQKB_D
where JGFDMC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06';
select '太平再保险',
BZBS as "补正标识",
JGTYSHXYDM as "机构统一社会信用代码",
JGFDMC as "机构法定名称",
LSH as "流水号",
BDCXMMC as "不动产项目名称",
DCXMDM as "不动产项目代码",
XMGSFDMC as "项目公司法定名称",
XMGSZJLX as "项目公司证件类型",
XMGSZJHM as "项目公司证件号码",
CJ as "层级",
SYCXMGSFDMC as "上一层项目公司法定名称",
SYCXMGSZJHM as "上一层项目公司证件号码",
BDCCYFS as "不动产持有方式",
BSLXRXM as "报送联系人姓名",
BSLXRBM as "报送联系人部门",
BSLXRLXDH as "报送联系人联系电话",
BZ as "备注",
SJRQ as "数据日期"
from ZBD_YW_XMGSYBDCGXB_D
where JGFDMC like '%太平再保险%' and sjrq >='20221001' and sjrq<='20240331' and DIS_DAILY='2024-05-06';