[关闭]
@15311494814 2018-05-02T09:04:50.000000Z 字数 33357 阅读 410

iquantex_cb 接口设计文档

iquantex_cb

一、基础资料(cb_basic_info)

数据库信息

字段 名称 类型 说明
uuid primary key varchar(36)
create_time 创建时间 varchar(20) 数据的创建时间
sec_wd_code 证券代码 varchar(50)
sec_name 证券简称 varchar(50)
cb_name 转债简称 varchar(50)
cb_code 转债代码 varchar(20)
ustock_name 正股简称 varchar(50)
ustock_code 正股代码 varchar(20)
face_value 面值 decimal(9, 4) 单位：元
term 发行期限 decimal(9, 4) 单位：年
issue_price 发行价格 decimal(9, 4) 单位：元
issue_amount 发行总额 decimal(9, 4) 单位：亿元
start_date 起息日期 varchar(20)
maturity_date 到期日期 varchar(20)
ir_type 利率类型 varchar(10)
interest 利率 decimal(9, 4) 单位: %
frequency 年付息次数 int(3) 单位：次
list_date 上市日期 varchar(20)
list_venue 上市地点 varchar(20)
issue_credit_rating 发行信用等级 varchar(10)

1,添加一条数据

[post] /cbBasicInfo

  1. body :
  2. {
  3.     "secWdCode": "110030.SH", //证券代码,必须
  4.     "secName": "格力转债",//证券简称,必须
  5.     "cbName": "格力转债",//转债简称,必须
  6.     "cbCode": "110030",//转债代码,必须
  7.     "ustockName": "格力地产",//正股简称,必须
  8.     "ustockCode": "600185.SH",//正股代码,必须
  9.     "faceValue": 100.0000,//面值(单位：元),必须
  10.     "term": 5,//发行期限(单位：年),必须
  11.     "issuePrice": 100,//发行价格（单位：元）,必须
  12.     "issueAmount": 9.8,//发行总额(单位：元),必须
  13.     "startDate": "2018-01-01 12:00:01",//起息日期,必须
  14.     "maturityDate": "2019-01-01 12:00:01",//到期日期,必须
  15.     "irType": "累进利率",//利率类型,必须
  16.     "interest": 0.6,//利率[单位] %,必须
  17.     "frequency": 1,//年付息次数[单位] 次,必须
  18.     "listDate": "2018-01-01 12:00:01",//上市日期,必须
  19.     "listVenue": "上海",//上市地点,必须
  20.     "issueCreditRating": "AA"//发行信用等级,必须
  21. }
  23. result:
  24. {
  25.     "statusCode": "000000",
  26.     "result": {
  27.         "uuid": "88d3c26d5fc54a7a86463b24a784821a",
  28.         "secWdCode": "110030.SH",
  29.         "secName": "格力转债",
  30.         "cbName": "格力转债",
  31.         "cbCode": "110030",
  32.         "ustockName": "格力地产",
  33.         "ustockCode": "600185.SH",
  34.         "faceValue": 100,
  35.         "term": 5,
  36.         "issuePrice": 100,
  37.         "issueAmount": 9.8,
  38.         "startDate": "2018-01-01 12:00:01",
  39.         "maturityDate": "2019-01-01 12:00:01",
  40.         "irType": "累进利率",
  41.         "interest": 0.6,
  42.         "frequency": 1,
  43.         "listDate": "2018-01-01 12:00:01",
  44.         "listVenue": "上海",
  45.         "issueCreditRating": "AA",
  46.         "createTime": "2018-04-23 15:06:02"
  47.     },
  48.     "error": ""
  49. }

2,编辑一条数据

[put] /cbBasicInfo/{id}

  1. body: 
  2. {
  3.     "secWdCode": "110030.SH", //证券代码,非必须
  4.     "secName": "格力转债",//证券简称,非必须
  5.     "cbName": "格力转债",//转债简称,非必须
  6.     "cbCode": "110030",//转债代码,非必须
  7.     "ustockName": "格力地产",//正股简称,非必须
  8.     "ustockCode": "600185.SH",//正股代码,非必须
  9.     "faceValue": 100.0000,//面值(单位：元),非必须
  10.     "term": 5,//发行期限(单位：年),非必须
  11.     "issuePrice": 100,//发行价格（单位：元）,非必须
  12.     "issueAmount": 9.8,//发行总额(单位：元),非必须
  13.     "startDate": "2018-01-01 12:00:01",//起息日期,非必须
  14.     "maturityDate": "2019-01-01 12:00:01",//到期日期,非必须
  15.     "irType": "累进利率",//利率类型,非必须
  16.     "interest": 0.6,//利率[单位] %,非必须
  17.     "frequency": 1,//年付息次数[单位] 次,非必须
  18.     "listDate": "2018-01-01 12:00:01",//上市日期,非必须
  19.     "listVenue": "上海",//上市地点,非必须
  20.     "issueCreditRating": "AA"//发行信用等级,非必须
  21. }
  22. result:
  23. {
  24.     "statusCode": "000000",
  25.     "result": "ok",
  26.     "error": ""
  27. }

3,查询一条数据

[get] /cbBasicInfo/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": {},
  5.     "error": ""
  6. }

4,删除一条数据

[delete] /cbBasicInfo/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": "ok",
  5.     "error": ""
  6. }

5,批量获取数据

[post] /cbBasicInfo/list

  1. body : 
  2. {
  3.     "secWdCode":"格力" //equal to
  4.     "secName":{secName} //like
  5.     "cbName":{cbName} //like
  6.     "cbCode":{cbCode} //equal to
  7.     "ustockName":{ustockName} //like
  8.     "ustockCode":{ustockCode} //equal to
  9.     "startDateBegin":{startDateBegin} 
  10.     "startDateEnd":{startDateEnd} 
  11.     "maturityDateBegin":{maturityDateBegin} //equal to
  12.     "maturityDateEnd":{maturityDateEnd}
  13.     "irType":{irType}  //equal to
  14.     "listVenue":{listVenue} //equal to
  15.     "issueCreditRating":{issueCreditRating} //equal to
  16.     "listDateBegin":{listDateBegin}
  17.     "listDateEnd":{listDateEnd}
  18. }
  20. result:
  21. {
  22.     "statusCode": "000000",
  23.     "result": [
  24.         {
  25.             "uuid": "88d3c26d5fc54a7a86463b24a784821a",
  26.             "secWdCode": "110030.SH",
  27.             "secName": "格力转债",
  28.             "cbName": "格力转债",
  29.             "cbCode": "110030",
  30.             "ustockName": "格力地产",
  31.             "ustockCode": "600185.SH",
  32.             "faceValue": 100,
  33.             "term": 5,
  34.             "issuePrice": 100,
  35.             "issueAmount": 9.8,
  36.             "startDate": "2018-01-01 12:00:01",
  37.             "maturityDate": "2019-01-01 12:00:01",
  38.             "irType": "累进利率",
  39.             "interest": 0.6,
  40.             "frequency": 1,
  41.             "listDate": "2018-01-01 12:00:01",
  42.             "listVenue": "上海",
  43.             "issueCreditRating": "AA",
  44.             "createTime": "2018-04-23 15:06:02",
  45.             "startDateBegin": null,
  46.             "startDateEnd": null,
  47.             "maturityDateBegin": null,
  48.             "maturityDateEnd": null,
  49.             "listDateBegin": null,
  50.             "listDateEnd": null,
  51.             "startindex": null,
  52.             "pagesize": null
  53.         }
  54.     ],
  55.     "error": ""
  56. }

6,分页批量获取数据

[post] /cbBasicInfo/list/limit

  1. body : 
  2. {
  3.     "startIndex":"0",//分页索引下标，不填默认为0
  4.     "pageSize":"10",//每页显示条数，不填默认为10
  5.     "secWdCode":"格力"
  6.     "secName":{secName}
  7.     "cbName":{cbName}
  8.     "cbCode":{cbCode}
  9.     "ustockName":{ustockName}
  10.     "ustockCode":{ustockCode}
  11.     "startDateBegin":{startDateBegin}
  12.     "startDateEnd":{startDateEnd}
  13.     "maturityDateBegin":{maturityDateBegin}
  14.     "maturityDateEnd":{maturityDateEnd}
  15.     "irType":{irType}
  16.     "listVenue":{listVenue}
  17.     "issueCreditRating":{issueCreditRating}
  18.     "listDateBegin":{listDateBegin}
  19.     "listDateEnd":{listDateEnd}
  20. }
  22. result: 
  23. {
  24.     "statusCode": "000000",
  25.     "result": {
  26.         "data": [],
  27.         "startIndex": 0, //起始下标
  28.         "pageSize": 10,//每页显示条数
  29.         "totalCount": 1, //总条数
  30.         "currentPage": 1, //当前页
  31.         "pageCount": 1, //共多少页
  32.         "example": null //查询条件，response中无用
  33.     },
  34.     "error": ""
  35. }

二、发行人和担保人(cb_issuer_guarantor)

数据库信息

字段 名称 类型 说明
uuid primary key varchar(36)
create_time 创建时间 varchar(20) 数据的创建时间
sec_wd_code 证券代码 varchar(50)
sec_name 证券简称 varchar(50)
issuer 发行人中文名称 varchar(200)
issuer_eng 发行人英文名称 varchar(200)
industry_1_wd 所属Wind行业 [行业级别] 一级行业 varchar(20)
industry_2_wd 所属Wind行业 [行业级别] 二级行业 varchar(20)
industry_3_wd 所属Wind行业 [行业级别] 三级行业 varchar(20)
industry_4_wd 所属Wind行业 [行业级别] 四级行业 varchar(20)
guarantor 担保人 varchar(100)
guarant_type 担保方式 varchar(20)
guarant_term 担保期限 varchar(50)
guarant_range 担保范围 varchar(200)
counter_guarant 反担保情况 varchar(100)

1,添加一条数据

[post] /cbIssuerGuarantor

  1. body :
  2. {
  3.     "secWdCode": "110031.SH",//证券代码,必须
  4.     "secName": "航信转债",//证券简称,必须
  5.     "issuer": "航天信息股份有限公司",//发行人中文名称,必须
  6.     "issuerEng": "Aisino Corporation",//发行人英文名称
  7.     "industry1Wd": "信息技术",//所属Wind行业 [行业级别] 一级行业
  8.     "industry2Wd": "技术硬件与设备",//所属Wind行业 [行业级别] 二级行业
  9.     "industry3Wd": "电子设备、仪器和元件",//所属Wind行业 [行业级别] 三级行业
  10.     "industry4Wd": "电子设备和仪器",//所属Wind行业 [行业级别] 四级行业
  11.     "guarantor": "中国航天科工集团公司",//担保人
  12.     "guarantType": "不可撤销连带责任担保",//担保方式
  13.     "guarantTerm": "",//担保期限
  14.     "guarantRange": "航天科工集团承诺对本公司本次发行可转换公司债券的到期兑付提供全额、不可撤销的连带责任保证担保。",//担保范围
  15.     "counterGuarant": ""//反担保情况
  16. }
  18. result:
  19. {
  20.     "statusCode": "000000",
  21.     "result": {
  22.         "uuid": "b6c4848eaa6348668ab9c158f261193a",
  23.         "secWdCode": "110031.SH",
  24.         "secName": "航信转债",
  25.         "issuer": "航天信息股份有限公司",
  26.         "issuerEng": "Aisino Corporation",
  27.         "industry1Wd": "信息技术",
  28.         "industry2Wd": "技术硬件与设备",
  29.         "industry3Wd": "电子设备、仪器和元件",
  30.         "industry4Wd": "电子设备和仪器",
  31.         "guarantor": "中国航天科工集团公司",
  32.         "guarantType": "不可撤销连带责任担保",
  33.         "guarantTerm": "",
  34.         "guarantRange": "航天科工集团承诺对本公司本次发行可转换公司债券的到期兑付提供全额、不可撤销的连带责任保证担保。",
  35.         "counterGuarant": "",
  36.         "createtime": "2018-04-25 15:02:16",
  37.         "pageSize": null,
  38.         "startIndex": null
  39.     },
  40.     "error": ""
  41. }

2,编辑一条数据

[put] /cbIssuerGuarantor/{id}

  1. body: 
  2. {
  3.     "secWdCode": "110031.SH",//证券代码,必须
  4.     "secName": "航信转债",//证券简称,必须
  5.     "issuer": "航天信息股份有限公司",//发行人中文名称,必须
  6.     "issuerEng": "Aisino Corporation",//发行人英文名称
  7.     "industry1Wd": "信息技术",//所属Wind行业 [行业级别] 一级行业
  8.     "industry2Wd": "技术硬件与设备",//所属Wind行业 [行业级别] 二级行业
  9.     "industry3Wd": "电子设备、仪器和元件",//所属Wind行业 [行业级别] 三级行业
  10.     "industry4Wd": "电子设备和仪器",//所属Wind行业 [行业级别] 四级行业
  11.     "guarantor": "中国航天科工集团公司",//担保人
  12.     "guarantType": "不可撤销连带责任担保",//担保方式
  13.     "guarantTerm": "",//担保期限
  14.     "guarantRange": "航天科工集团承诺对本公司本次发行可转换公司债券的到期兑付提供全额、不可撤销的连带责任保证担保。",//担保范围
  15.     "counterGuarant": ""//反担保情况
  16. }
  18. result:
  19. {
  20.     "statusCode": "000000",
  21.     "result": "ok",
  22.     "error": ""
  23. }

3,查询一条数据

[get] /cbIssuerGuarantor/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": {},
  5.     "error": ""
  6. }

4,删除一条数据

[delete] /cbIssuerGuarantor/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": "ok",
  5.     "error": ""
  6. }

5,批量获取数据

[post] /cbIssuerGuarantor/list

  1. body : 
  2. {
  3.     "secWdCode":"110031.SH", //equal to
  4.     "secName":"航信", //like
  5.     "issuer":"航天信息", //like
  6.     "issuerEng":"Aisino", //like
  7.     "industry1Wd":"信息技术", //equal to
  8.     "industry2Wd":"", //equal to
  9.     "industry3Wd":"",//equal to
  10.     "industry4Wd":""//equal to
  11. }
  14. result:
  15. {
  16.     "statusCode": "000000",
  17.     "result": [
  18.         {
  19.             "uuid": "b7a383dc04a240f591dcc3f07c2d8544",
  20.             "secWdCode": "110031.SH",
  21.             "secName": "航信转债",
  22.             "issuer": "航天信息股份有限公司",
  23.             "issuerEng": "Aisino Corporation",
  24.             "industry1Wd": "信息技术",
  25.             "industry2Wd": "技术硬件与设备",
  26.             "industry3Wd": "电子设备、仪器和元件",
  27.             "industry4Wd": "电子设备和仪器",
  28.             "guarantor": "中国航天科工集团公司",
  29.             "guarantType": "不可撤销连带责任担保",
  30.             "guarantTerm": "",
  31.             "guarantRange": "航天科工集团承诺对本公司本次发行可转换公司债券的到期兑付提供全额、不可撤销的连带责任保证担保。",
  32.             "counterGuarant": "",
  33.             "createtime": "2018-04-25 15:23:19",
  34.             "pageSize": null,
  35.             "startIndex": null
  36.         }
  37.     ],
  38.     "error": ""
  39. }

6,分页批量获取数据

[post] /cbIssuerGuarantor/list/limit

  1. body : 
  2. {
  3.     "startIndex":"0",//分页索引下标，不填默认为0
  4.     "pageSize":"10",//每页显示条数，不填默认为10
  5.     "secWdCode":"110031.SH", //equal to
  6.     "secName":"航信", //like
  7.     "issuer":"航天信息", //like
  8.     "issuerEng":"Aisino", //like
  9.     "industry1Wd":"信息技术", //equal to
  10.     "industry2Wd":"", //equal to
  11.     "industry3Wd":"",//equal to
  12.     "industry4Wd":""//equal to
  13. }
  15. result: 
  16. {
  17.     "statusCode": "000000",
  18.     "result": {
  19.         "data": [],
  20.         "startIndex": 0, //起始下标
  21.         "pageSize": 10,//每页显示条数
  22.         "totalCount": 1, //总条数
  23.         "currentPage": 1, //当前页
  24.         "pageCount": 1, //共多少页
  25.         "example": null //查询条件，response中无用
  26.     },
  27.     "error": ""
  28. }

三、利率条款(cb_interest_clause)

数据库信息

字段 名称 类型 说明
uuid primary key varchar(36)
create_time 创建时间 varchar(20) 数据的创建时间
sec_wd_code 证券代码 varchar(50)
sec_name 证券简称 varchar(50)
is_chgwith_depo 是否随存款利率调整 char(4)
has_interest_compensate 是否有利息补偿 char(4)
compensate_rate 补偿利率 [单位] % decimal(9, 4)
compensate_txt 补偿利率说明 varchar(500)
coupon_txt 票面利率说明 varchar(500)
coupon_payment_txt 付息说明 varchar(1000)

1,添加一条数据

[post] /cbInterestClause

  1. body :
  2. {
  3.     "secWdCode": "110030.SH",
  4.     "secName": "格力转债",
  5.     "isChgwithDepo": "否",
  6.     "hasInterestCompensate": "是",
  7.     "compensateRate": 1.9800,
  8.     "compensateTxt": "本公司将以本次发行的可转债的票面面值的106%（含最后一期利息）的价格向投资者赎回全部未转股的可转债。",
  9.     "couponTxt": "本次发行的可转债票面利率：第一年为0.60%、第二年为0.80%、第三年为1.00%、第四年为1.50%、第五年为2.00%。",
  10.     "couponPaymentTxt": "①本次可转债采用每年付息一次的付息方式，计息起始日为可转债发行首日。可转债持有人所获利息收入的应付税项由可转债持有人负担"
  11. }
  13. result:
  14. {
  15.     "statusCode": "000000",
  16.     "result": {
  17.         "uuid": "a933bc9d39b2403dad894d3c383e3d99",
  18.         "createTime": "2018-04-25 17:55:55",
  19.         "secWdCode": "110030.SH",
  20.         "secName": "格力转债",
  21.         "isChgwithDepo": "否",
  22.         "hasInterestCompensate": "是",
  23.         "compensateRate": 1.98,
  24.         "compensateTxt": "本公司将以本次发行的可转债的票面面值的106%（含最后一期利息）的价格向投资者赎回全部未转股的可转债。",
  25.         "couponTxt": "本次发行的可转债票面利率：第一年为0.60%、第二年为0.80%、第三年为1.00%、第四年为1.50%、第五年为2.00%。",
  26.         "couponPaymentTxt": "①本次可转债采用每年付息一次的付息方式，计息起始日为可转债发行首日。可转债持有人所获利息收入的应付税项由可转债持有人负担。",
  27.         "pageSize": null,
  28.         "startIndex": null
  29.     },
  30.     "error": ""
  31. }

2,编辑一条数据

[put] /cbInterestClause/{id}

  1. body: 
  2. {
  3.     "secWdCode": "110030.SH",
  4.     "secName": "格力转债",
  5.     "isChgwithDepo": "否",
  6.     "hasInterestCompensate": "是",
  7.     "compensateRate": 1.9800,
  8.     "compensateTxt": "本公司将以本次发行的可转债的票面面值的106%（含最后一期利息）的价格向投资者赎回全部未转股的可转债。",
  9.     "couponTxt": "本次发行的可转债票面利率：第一年为0.60%、第二年为0.80%、第三年为1.00%、第四年为1.50%、第五年为2.00%。",
  10.     "couponPaymentTxt": "①本次可转债采用每年付息一次的付息方式，计息起始日为可转债发行首日。可转债持有人所获利息收入的应付税项由可转债持有人负担"
  11. }
  13. result:
  14. {
  15.     "statusCode": "000000",
  16.     "result": "ok",
  17.     "error": ""
  18. }

3,查询一条数据

[get] /cbInterestClause/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": {},
  5.     "error": ""
  6. }

4,删除一条数据

[delete] /cbInterestClause/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": "ok",
  5.     "error": ""
  6. }

5,批量获取数据

[post] /cbInterestClause/list

  1. body : 
  2. {
  3.     "secWdCode": "110030.SH",//equal to
  4.     "secName": "格力转债", //like
  5.     "isChgwithDepo": "是",//equal to
  6.     "hasInterestCompensate": "是",//equal to
  7.     "compensateRate": 1.970//equal to
  8. }
  11. result:
  12. {
  13.     "statusCode": "000000",
  14.     "result": [
  15.         {
  16.             "uuid": "a933bc9d39b2403dad894d3c383e3d99",
  17.             "createTime": "2018-04-25 17:55:55",
  18.             "secWdCode": "110030.SH",
  19.             "secName": "格力转债1",
  20.             "isChgwithDepo": "是",
  21.             "hasInterestCompensate": "是",
  22.             "compensateRate": 1.97,
  23.             "compensateTxt": "本公司将以本次发行的可转债的票面面值的106%（含最后一期利息）的价格向投资者赎回全部未转股的可转债。",
  24.             "couponTxt": "1本次发行的可转债票面利率：第一年为0.60%、第二年为0.80%、第三年为1.00%、第四年为1.50%、第五年为2.00%。",
  25.             "couponPaymentTxt": "本次可转债采用每年付息一次的付息方式，计息起始日为可转债发行首日。可转债持有人所获利息收入的应付税项由可转债持有人负担.",
  26.             "pageSize": null,
  27.             "startIndex": null
  28.         }
  29.     ],
  30.     "error": ""
  31. }

6,分页批量获取数据

[post] /cbInterestClause/list/limit

  1. body : 
  2. {
  3.     "startIndex":"0",//分页索引下标，不填默认为0
  4.     "pageSize":"10",//每页显示条数，不填默认为10
  5.     "secWdCode": "110030.SH",//equal to
  6.     "secName": "格力转债", //like
  7.     "isChgwithDepo": "是",//equal to
  8.     "hasInterestCompensate": "是",//equal to
  9.     "compensateRate": 1.970//equal to
  10. }
  12. result: 
  13. {
  14.     "statusCode": "000000",
  15.     "result": {
  16.         "data": [],
  17.         "startIndex": 0, //起始下标
  18.         "pageSize": 10,//每页显示条数
  19.         "totalCount": 1, //总条数
  20.         "currentPage": 1, //当前页
  21.         "pageCount": 1, //共多少页
  22.         "example": null //查询条件，response中无用
  23.     },
  24.     "error": ""
  25. }

四、转股条款(cb_conv_clause)

数据库信息

字段 名称 类型 说明
uuid primary key varchar(36)
create_time 创建时间 varchar(20) 数据的创建时间
sec_wd_code 证券代码 varchar(50)
sec_name 证券简称 varchar(50)
noconv_period 相对转股期 [单位] 月 char(4)
conv_start_date 自愿转股起始日期 varchar(20)
conv_end_date 自愿转股终止日期 varchar(20)
is_forced 是否强制转股 char(4) 是、否
force_conv_date 强制转股日 varchar(20)
force_conv_price 强制转股价格 [单位] 元 decimal(9, 4)
conv_price 转股价格[交易日期] 最新收盘日 [单位] 元 decimal(9, 4)
conv_order_code 转股代码 varchar(50)
conv_proportion 转换比例 [交易日期] 最新收盘日 [单位] % decimal(9, 4)
outstanding_amount 未转股余额 [交易日期] 最新收盘日 [单位] 元 decimal(20, 4)
outstanding_proportion 未转股比例 [交易日期] 最新收盘日 [单位] % decimal(9, 4)
is_convprice_adj_by_divident 转股价随派息调整 char(4) 是、否
conv_clause_txt 转股条款 varchar(1000)

1,添加一条数据

[post] /cbConvClause

  1. body :
  2. {
  3.     "secWdCode": "110032.SH", //证券代码 ,必填
  4.     "secName": "三一转债", //证券简称,必填
  5.     "noconvPeriod": "6", //相对转股期 [单位] 月
  6.     "convStartDate": "2018-01-01 00:00:00", //自愿转股起始日期
  7.     "convEndDate": "2019-01-01 00:00:00", //自愿转股终止日期
  8.     "isForced": "是", //是否强制转股
  9.     "forceConvDate": "2019-01-02 00:00:00", //强制转股日
  10.     "forceConvPrice": 1, //强制转股价格 [单位] 元
  11.     "convPrice": 7.43, //转股价格[交易日期] 最新收盘日 [单位] 元
  12.     "convOrderCode": "190032", //转股代码
  13.     "convProportion": 13.4590, //转换比例 [交易日期] 最新收盘日 [单位] %
  14.     "outstandingAmount": 1, //未转股余额 [交易日期] 最新收盘日 [单位] 元
  15.     "outstanding_proportion": 100, //未转股比例 [交易日期] 最新收盘日 [单位] %
  16.     "isConvpriceAdjByDivident": "是", //转股价随派息调整
  17.     "convClauseTxt": "在本次债券发行之后，当公司因派送股票股利、转增股本、增发新股或配股、派送现金股利等情况。" //转股条款
  18. }
  20. result:
  21. {
  22.     "statusCode": "000000",
  23.     "result": {
  24.         "uuid": "1fdf3401a23d4c58ad4164bfe48a9e54",
  25.         "createTime": "2018-04-26 10:20:05",
  26.         "secWdCode": "110032.SH",
  27.         "secName": "三一转债",
  28.         "noconvPeriod": "6",
  29.         "convStartDate": "2018-01-01 00:00:00",
  30.         "convEndDate": "2019-01-01 00:00:00",
  31.         "isForced": "是",
  32.         "forceConvDate": "2019-01-02 00:00:00",
  33.         "forceConvPrice": null,
  34.         "convPrice": 7.43,
  35.         "convOrderCode": "190032",
  36.         "convProportion": 13.459,
  37.         "outstandingAmount": null,
  38.         "outstandingProportion": null,
  39.         "isConvpriceAdjByDivident": "是",
  40.         "convClauseTxt": "在本次债券发行之后，当公司因派送股票股利、转增股本、增发新股或配股、派送现金股利等情况。",
  41.         "pageSize": null,
  42.         "startIndex": null
  43.     },
  44.     "error": ""
  45. }

2,编辑一条数据

[put] /cbConvClause/{id}

  1. body: 
  2. {
  3.     "secWdCode": "110032.SH", //证券代码 ,必填
  4.     "secName": "三一转债", //证券简称,必填
  5.     "noconvPeriod": "6", //相对转股期 [单位] 月
  6.     "convStartDate": "2018-01-01 00:00:00", //自愿转股起始日期
  7.     "convEndDate": "2019-01-01 00:00:00", //自愿转股终止日期
  8.     "isForced": "是", //是否强制转股
  9.     "forceConvDate": "2019-01-02 00:00:00", //强制转股日
  10.     "forceConvPrice": 1, //强制转股价格 [单位] 元
  11.     "convPrice": 7.43, //转股价格[交易日期] 最新收盘日 [单位] 元
  12.     "convOrderCode": "190032", //转股代码
  13.     "convProportion": 13.4590, //转换比例 [交易日期] 最新收盘日 [单位] %
  14.     "outstandingAmount": 1, //未转股余额 [交易日期] 最新收盘日 [单位] 元
  15.     "outstanding_proportion": 100, //未转股比例 [交易日期] 最新收盘日 [单位] %
  16.     "isConvpriceAdjByDivident": "是", //转股价随派息调整
  17.     "convClauseTxt": "在本次债券发行之后，当公司因派送股票股利、转增股本、增发新股或配股、派送现金股利等情况。" //转股条款
  18. }
  20. result:
  21. {
  22.     "statusCode": "000000",
  23.     "result": "ok",
  24.     "error": ""
  25. }

3,查询一条数据

[get] /cbConvClause/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": {},
  5.     "error": ""
  6. }

4,删除一条数据

[delete] /cbConvClause/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": "ok",
  5.     "error": ""
  6. }

5,批量获取数据

[post] /cbConvClause/list

  1. body : 
  2. {
  3.     "secWdCode": "110032.SH", //equal to
  4.     "secName": "三一转债", //like
  5.     "convStartDateBegin":"", 
  6.     "convStartDateEnd":"",
  7.     "convEndDateBegin":"",
  8.     "convEndDateEnd":"",
  9.     "isForced":"是", //equal to
  10.     "convOrderCode":"" //equal to
  11. }
  14. result:
  15. {
  16.     "statusCode": "000000",
  17.     "result": [
  18.         {
  19.             "uuid": "1fdf3401a23d4c58ad4164bfe48a9e54",
  20.             "createTime": "2018-04-26 10:20:05",
  21.             "secWdCode": "110032.SH",
  22.             "secName": "三一转债1",
  23.             "noconvPeriod": "2",
  24.             "convStartDate": "2018-01-01 00:00:00",
  25.             "convEndDate": "2019-01-01 00:00:00",
  26.             "isForced": "是",
  27.             "forceConvDate": "2019-01-02 00:00:00",
  28.             "forceConvPrice": null,
  29.             "convPrice": 7.43,
  30.             "convOrderCode": "190032",
  31.             "convProportion": 13.459,
  32.             "outstandingAmount": 11,
  33.             "outstandingProportion": 200,
  34.             "isConvpriceAdjByDivident": "否",
  35.             "convClauseTxt": "在本次债券发行之后",
  36.             "pageSize": null,
  37.             "startIndex": null
  38.         },
  39.         {
  40.             "uuid": "3f79b95d559e4e76b87a2daddb5f36bc",
  41.             "createTime": "2018-04-26 10:18:57",
  42.             "secWdCode": "110032.SH",
  43.             "secName": "三一转债",
  44.             "noconvPeriod": "6",
  45.             "convStartDate": "2018-01-01 00:00:00",
  46.             "convEndDate": "2019-01-01 00:00:00",
  47.             "isForced": "是",
  48.             "forceConvDate": "2019-01-02 00:00:00",
  49.             "forceConvPrice": 1,
  50.             "convPrice": 7.43,
  51.             "convOrderCode": "190032",
  52.             "convProportion": 13.459,
  53.             "outstandingAmount": 1,
  54.             "outstandingProportion": null,
  55.             "isConvpriceAdjByDivident": "是",
  56.             "convClauseTxt": "在本次债券发行之后，。",
  57.             "pageSize": null,
  58.             "startIndex": null
  59.         }
  60.     ],
  61.     "error": ""
  62. }

6,分页批量获取数据

[post] /cbConvClause/list/limit

  1. body : 
  2. {
  3.     "startIndex":"0",//分页索引下标，不填默认为0
  4.     "pageSize":"10",//每页显示条数，不填默认为10
  5.     "secWdCode": "110032.SH", //equal to
  6.     "secName": "三一转债", //like
  7.     "convStartDateBegin":"", 
  8.     "convStartDateEnd":"",
  9.     "convEndDateBegin":"",
  10.     "convEndDateEnd":"",
  11.     "isForced":"是", //equal to
  12.     "convOrderCode":"" //equal to
  13. }
  15. result: 
  16. {
  17.     "statusCode": "000000",
  18.     "result": {
  19.         "data": [],
  20.         "startIndex": 0, //起始下标
  21.         "pageSize": 10,//每页显示条数
  22.         "totalCount": 1, //总条数
  23.         "currentPage": 1, //当前页
  24.         "pageCount": 1, //共多少页
  25.         "example": null //查询条件，response中无用
  26.     },
  27.     "error": ""
  28. }

五、重设条款(cb_reset_clause)

数据库信息

字段 名称 类型 说明
uuid primary key varchar(36)
create_time 创建时间 varchar(20) 数据的创建时间
sec_wd_code 证券代码 varchar(50)
sec_name 证券简称 varchar(50)
reset_clause_txt 特别向下修正条款全文 varchar(500)
has_reset 是否有特别向下修正条款 char(4) 是、否
reset_start_date 特别修正起始时间 varchar(20)
reset_end_date 特别修正结束时间 varchar(20)
reset_max_window 重设触发计算最大时间区间 [单位] 天 int(4)
reset_window 重设触发计算时间区间 [单位] 天 int(4)
reset_trig_ratio 触发比例 [单位] % decimal(9,4)
is_arithm_avg 是否为算术平均价 char(4) 是、否
reset_pct 特别修正幅度 [单位] % decimal(9,4)
reset_floor_txt 修正价格底线说明 varchar(500)
reset_times_limit 修正次数限制 char(10)
reset_timingclause_txt 时点修正条款全文 varchar(1000)

1,添加一条数据

[post] /cbResetClause

  1. body :
  2. {
  3.     "secWdCode": "110041.SH", //证券代码,必须
  4.     "secName": "蒙电转债", //证券简称,必须
  5.     "resetClauseTxt": "在本次发行的可转换公司债券存续期间。", //特别向下修正条款全文
  6.     "hasReset": "是", //是否有特别向下修正条款
  7.     "resetStartDate": "2018-01-01 00:00:00", //特别修正起始时间
  8.     "resetEndDate": "2010-01-01 00:00:00", //特别修正结束时间
  9.     "resetMaxWindow": 30, //重设触发计算最大时间区间 [单位] 天
  10.     "resetWindow": 15, //重设触发计算时间区间 [单位] 天
  11.     "resetTrigRatio": 90, //触发比例 [单位] %
  12.     "isArithmAvg": "否", //是否为算术平均价
  13.     "resetPct": "", //特别修正幅度 [单位] %
  14.     "resetFloorTxt": "不低于股东大会前20个交易日股票交易均价和前1交易日的交易均价,不得低于最近1期每股净资产值和股票面值", //修正价格底线说明
  15.     "resetTimesLimit": "", //修正次数限制
  16.     "resetTimingclauseTxt": "" //时点修正条款全文
  17. }
  19. result:
  20. {
  21.     "statusCode": "000000",
  22.     "result": {
  23.         "uuid": "45598b9d27f94745add606e03d1c239a",
  24.         "createTime": "2018-04-26 11:04:46",
  25.         "secWdCode": "110041.SH",
  26.         "resetClauseTxt": "在本次发行的可转换公司债券存续期间。",
  27.         "secName": "蒙电转债",
  28.         "hasReset": "是",
  29.         "resetStartDate": "2018-01-01 00:00:00",
  30.         "resetEndDate": "2010-01-01 00:00:00",
  31.         "resetMaxWindow": 30,
  32.         "resetWindow": 15,
  33.         "resetTrigRatio": 90,
  34.         "isArithmAvg": "否",
  35.         "resetPct": null,
  36.         "resetFloorTxt": "不低于股东大会前20个交易日股票交易均价和前1交易日的交易均价,不得低于最近1期每股净资产值和股票面值",
  37.         "resetTimesLimit": null,
  38.         "resetTimingclauseTxt": "",
  39.         "pageSize": null,
  40.         "startIndex": null
  41.     },
  42.     "error": ""
  43. }

2,编辑一条数据

[put] /cbResetClause/{id}

  1. body: 
  2. {
  3.     "secWdCode": "110041.SH",
  4.     "secName": "蒙电转债12",
  5.     "resetClauseTxt": "在本次发行的可转换公司债券存续期间。",
  6.     "hasReset": "是",
  7.     "resetStartDate": "2018-01-01 00:00:00",
  8.     "resetEndDate": "2010-01-01 00:00:00",
  9.     "resetMaxWindow": 30,
  10.     "resetWindow": 15,
  11.     "resetTrigRatio": 90,
  12.     "isArithmAvg": "否",
  13.     "resetPct": "",
  14.     "resetFloorTxt": "不低于股东大会前20个交易日股票交易均价和前1交易日的交易均价,不得低于最近1期每股净资产值和股票面值",
  15.     "resetTimesLimit": "3",
  16.     "resetTimingclauseTxt": ""
  17. }
  19. result:
  20. {
  21.     "statusCode": "000000",
  22.     "result": "ok",
  23.     "error": ""
  24. }

3,查询一条数据

[get] /cbResetClause/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": {},
  5.     "error": ""
  6. }

4,删除一条数据

[delete] /cbResetClause/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": "ok",
  5.     "error": ""
  6. }

5,批量获取数据

[post] /cbResetClause/list

  1. body : 
  2. {
  3.     "secWdCode": "110030.SH",//equal to
  4.     "secName": "格力转债", //like
  5.     "hasReset":"", //equal to
  6.     "isArithmAvg":"" //equal to
  7. }
  10. result:
  11. {
  12.     "statusCode": "000000",
  13.     "result": [
  14.         {
  15.             "uuid": "45598b9d27f94745add606e03d1c239a",
  16.             "createTime": "2018-04-26 11:04:46",
  17.             "secWdCode": "110041.SH",
  18.             "resetClauseTxt": "在本次发行的可转换公司债券存续期间。",
  19.             "secName": "蒙电转债12",
  20.             "hasReset": "是",
  21.             "resetStartDate": "2018-01-01 00:00:00",
  22.             "resetEndDate": "2010-01-01 00:00:00",
  23.             "resetMaxWindow": 30,
  24.             "resetWindow": 15,
  25.             "resetTrigRatio": 90,
  26.             "isArithmAvg": "否",
  27.             "resetPct": null,
  28.             "resetFloorTxt": "不低于股东大会前20个交易日股票交易均价和前1交易日的交易均价,不得低于最近1期每股净资产值和股票面值",
  29.             "resetTimesLimit": 3,
  30.             "resetTimingclauseTxt": "",
  31.             "pageSize": null,
  32.             "startIndex": null
  33.         }
  34.     ],
  35.     "error": ""
  36. }

6,分页批量获取数据

[post] /cbResetClause/list/limit

  1. body : 
  2. {
  3.     "startIndex":"0",//分页索引下标，不填默认为0
  4.     "pageSize":"10",//每页显示条数，不填默认为10
  5.     "secWdCode": "110030.SH",//equal to
  6.     "secName": "格力转债", //like
  7.     "hasReset":"", //equal to
  8.     "isArithmAvg":"" //equal to
  9. }
  11. result: 
  12. {
  13.     "statusCode": "000000",
  14.     "result": {
  15.         "data": [],
  16.         "startIndex": 0, //起始下标
  17.         "pageSize": 10,//每页显示条数
  18.         "totalCount": 1, //总条数
  19.         "currentPage": 1, //当前页
  20.         "pageCount": 1, //共多少页
  21.         "example": null //查询条件，response中无用
  22.     },
  23.     "error": ""
  24. }

六、赎回条款(cb_redemp_clause)

数据库信息

字段 名称 类型 说明
uuid primary key varchar(36)
create_time 创建时间 varchar(20) 数据的创建时间
sec_wd_code 证券代码 varchar(50)
sec_name 证券简称 varchar(50)
nocall_period 相对赎回期 [单位] 月 char(4)
redemp_times_per_year 每年可赎回次数 [单位] 次 varchar(20)
cond_redemp_start_date 条件赎回起始日期 varchar(20)
cond_redemp_end_date 条件赎回截止日期 varchar(20)
redemp_trig_max_window 赎回触发计算最大时间区间 [单位] 天 int(4)
redemp_trig_window 赎回触发计算时间区间 [单位] 天 int(4)
redemp_trig_ratio 赎回触发比例 [单位] % decimal(9,4)
redemp_price 赎回价格 decimal(9, 4)
redemp_price_txt 赎回价格说明 varchar(500)
redemp_interest_calc 利息处理 varchar(20)
redemp_clause_txt 赎回条款 varchar(1000)
has_timing_redemp_clause 是否有时点赎回条款 char(4) 是、否
num_timing_redemp 时点赎回数 decimal(9,4)
timing_redemp_clause_txt 时点赎回条款全文 varchar(1000)

1,添加一条数据

[post] /cbRedempClause

  1. body :
  2. {
  3.     "secWdCode": "110038.SH", //证券代码,必填
  4.     "secName": "济川转债", //证券简称,必填
  5.     "nocallPeriod": 6, //相对赎回期 [单位] 月
  6.     "redempTimesPerYear": "不限次数", //每年可赎回次数 [单位] 
  7.     "condRedempStartDate": "2018-01-01 00:00:00", //条件赎回起始日期
  8.     "condRedempEndDate": "2010-01-01 00:00:00", //条件赎回截止日期
  9.     "redempTrigMaxWindow": 30, //赎回触发计算最大时间区间 [单位] 天
  10.     "redempTrigWindow": 15, //赎回触发计算时间区间 [单位] 天
  11.     "redempTrigRatio": 130, //赎回触发比例 [单位] %
  12.     "redempPrice": "", //赎回价格
  13.     "redempPriceTxt":  "按照以债券面值加当期应计利息的价格赎回全部或部分转债", //赎回价格说明
  14.     "redempInterestCalc": "应计", //利息处理
  15.     "redempClauseTxt": "①到期赎回条款在本次发行的可转债期满后五日内，。", // 赎回条款  
  16.     "hasTimingRedempClause": "否", //是否有时点赎回条款
  17.     "numTimingRedemp": "", //时点赎回数
  18.     "timingRedempClauseTxt": "" //时点赎回条款全文
  19. }
  21. result:
  22. {
  23.     "statusCode": "000000",
  24.     "result": {
  25.         "uuid": "3ec547c6b94342158538f80b79a84dc8",
  26.         "createTime": "2018-04-26 14:03:39",
  27.         "secWdCode": "110038.SH",
  28.         "secName": "济川转债",
  29.         "nocallPeriod": "6",
  30.         "redempTimesPerYear": "不限次数",
  31.         "condRedempStartDate": "2018-01-01 00:00:00",
  32.         "condRedempEndDate": "2010-01-01 00:00:00",
  33.         "redempTrigMaxWindow": 30,
  34.         "redempTrigWindow": 15,
  35.         "redempTrigRatio": 130,
  36.         "redempPrice": null,
  37.         "redempPriceTxt": "按照以债券面值加当期应计利息的价格赎回全部或部分未转股的可转债",
  38.         "redempInterestCalc": "应计",
  39.         "redempClauseTxt": "①到期赎回条款在本次发行的可转债期满后五个交易日内。",
  40.         "hasTimingRedempClause": "否",
  41.         "numTimingRedemp": null,
  42.         "timingRedempClauseTxt": "",
  43.         "pageSize": null,
  44.         "startIndex": null
  45.     },
  46.     "error": ""
  47. }

2,编辑一条数据

[put] /cbRedempClause/{id}

  1. body: 
  2. {
  3.     "secWdCode": "110038.SH",
  4.     "secName": "济川转债",
  5.     "nocallPeriod": 6,
  6.     "redempTimesPerYear": "不限次数",
  7.     "condRedempStartDate": "2018-01-01 00:00:00",
  8.     "condRedempEndDate": "2010-01-01 00:00:00",
  9.     "redempTrigMaxWindow": 30,
  10.     "redempTrigWindow": 15,
  11.     "redempTrigRatio": 130,
  12.     "redempPrice": "",
  13.     "redempPriceTxt": "按照以债券面值加当期应计利息的价格赎回全部或部分未转股的可转债",
  14.     "redempInterestCalc": "应计",
  15.     "redempClauseTxt": "①到期赎回条款在本次发行的可转债期满后五个交易日内，。",
  16.     "hasTimingRedempClause": "否",
  17.     "numTimingRedemp": "",
  18.     "timingRedempClauseTxt": ""
  19. }
  21. result:
  22. {
  23.     "statusCode": "000000",
  24.     "result": "ok",
  25.     "error": ""
  26. }

3,查询一条数据

[get] /cbRedempClause/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": {},
  5.     "error": ""
  6. }

4,删除一条数据

[delete] /cbRedempClause/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": "ok",
  5.     "error": ""
  6. }

5,批量获取数据

[post] /cbRedempClause/list

  1. body : 
  2. {
  3.     "secWdCode": "110030.SH",//equal to
  4.     "secName": "格力转债", //like
  5.     "hasTimingRedempClause":""//equal to
  6. }
  9. result:
  10. {
  11.     "statusCode": "000000",
  12.     "result": [
  13.         {
  14.             "uuid": "3ec547c6b94342158538f80b79a84dc8",
  15.             "createTime": "2018-04-26 14:03:39",
  16.             "secWdCode": "110038.SH",
  17.             "secName": "济川转债a",
  18.             "nocallPeriod": "6",
  19.             "redempTimesPerYear": "不限次数",
  20.             "condRedempStartDate": "2018-01-01 00:00:00",
  21.             "condRedempEndDate": "2010-01-01 00:00:00",
  22.             "redempTrigMaxWindow": 310,
  23.             "redempTrigWindow": 15,
  24.             "redempTrigRatio": 130,
  25.             "redempPrice": null,
  26.             "redempPriceTxt": "按照以债券面值加当期应计利息的价格赎回全部或部分未转股的可转债",
  27.             "redempInterestCalc": "应计",
  28.             "redempClauseTxt": "①到期赎回条款在本次发行的可转债期满后五个交易日内。",
  29.             "hasTimingRedempClause": "否",
  30.             "numTimingRedemp": null,
  31.             "timingRedempClauseTxt": "",
  32.             "pageSize": null,
  33.             "startIndex": null
  34.         }
  35.     ],
  36.     "error": ""
  37. }

6,分页批量获取数据

[post] /cbRedempClause/list/limit

  1. body : 
  2. {
  3.     "startIndex":"0",//分页索引下标，不填默认为0
  4.     "pageSize":"10",//每页显示条数，不填默认为10
  5.     "secWdCode": "110030.SH",//equal to
  6.     "secName": "格力转债", //like
  7.     "hasTimingRedempClause":""//equal to
  8. }
  10. result: 
  11. {
  12.     "statusCode": "000000",
  13.     "result": {
  14.         "data": [],
  15.         "startIndex": 0, //起始下标
  16.         "pageSize": 10,//每页显示条数
  17.         "totalCount": 1, //总条数
  18.         "currentPage": 1, //当前页
  19.         "pageCount": 1, //共多少页
  20.         "example": null //查询条件，response中无用
  21.     },
  22.     "error": ""
  23. }

七、回售条款(cb_put_clause)

数据库信息

字段 名称 类型 说明
uuid primary key varchar(36)
create_time 创建时间 varchar(20) 数据的创建时间
sec_wd_code 证券代码 varchar(50)
sec_name 证券简称 varchar(50)
noput_period 相对回售期 [单位] 月 char(4)
cond_put_start_date 条件回售起始日期 varchar(20)
cond_put_end_date 条件回售截止日期 varchar(20)
put_trig_max_window 回售触发计算最大时间区间 [单位] 天 int(4)
put_trig_window 回售触发计算时间区间 [单位] 天 int(4)
put_trig_ratio 回售触发比例 [单位] % decimal(9,4)
put_price 回售价格 decimal(9,4)
put_price_txt 回售价格说明 varchar(200)
put_times_limit 每年回售次数 [单位] 次 int(4)
put_interest_calc 利息处理 varchar(20)
cond_put_clause_txt 条件回售条款全文 varchar(500)
uncond_put_period 无条件回售期 varchar(50)
uncond_put_start_date 无条件回售起始日期 varchar(20)
uncond_put_end_date 无条件回售结束日期 varchar(20)
uncond_put_price 无条件回售价 [单位] 元 decimal(9,4)
uncond_put_clause_txt 无条件回售条款 varchar(200)
timing_put_times 时点回售数 decimal(9,4)
timing_put_clause_txt 时点回售条款全文 varchar(500)
additional_put_price_txt 附加回售价格说明 varchar(500)
additional_put_trig_txt 附加回售条件 varchar(500)

1,添加一条数据

[post] /cbPutClause

  1. body :
  2. {
  3.     "secWdCode": "110030.SH", //证券代码,必填
  4.     "secName": "格力转债", //证券简称,必填
  5.     "noputPeriod": "24", //相对回售期 [单位] 月
  6.     "condPutStartDate": "2018-01-01 00:00:00", //条件回售起始日期
  7.     "condPutEndDate": "2010-01-01 00:00:00", //条件回售截止日期
  8.     "putTrigMaxWindow": 30, //回售触发计算最大时间区间 [单位] 天
  9.     "putTrigWindow": 30, //回售触发计算时间区间 [单位] 天
  10.     "putTrigRatio": 70, //回售触发比例 [单位] %
  11.     "putPrice": 103, //回售价格
  12.     "putPriceTxt": "按债券103元(含当期应计利息)的价格回售给公司", //回售价格说明
  13.     "putTimesLimit": 1, //每年回售次数 [单位] 次
  14.     "putInterestCalc": "应计", //利息处理
  15.     "condPutClauseTxt": "自本次可转债第三个计息年度起。", //条件回售条款全文
  16.     "uncondPutPeriod": "否", //无条件回售期
  17.     "uncondPutStartDate": "", //无条件回售起始日期
  18.     "uncondPutEndDate": "", //无条件回售结束日期
  19.     "uncondPutPrice": "", //无条件回售价 [单位] 元
  20.     "uncondPutClauseTxt": "", //无条件回售条款
  21.     "timingPutTimes": "", //时点回售数
  22.     "timingPutClauseTxt": "", //时点回售条款全文
  23.     "additionalPutPriceTxt": "可转债持有人有权将其持有的可转债全部或部分按103元（含当期应计利息）的价格回售给公司", //附加回售价格说明
  24.     "additionalPutTrigTxt": "根据中国证监会的相关规定被视作改变募集资金用途或被中国证监会认定为改变募集资金用途的，公司本次发行的可转债持有人享有一次回售的权利。" //附加回售条件
  25. }
  27. result:
  28. {
  29.     "statusCode": "000000",
  30.     "result": {
  31.         "uuid": "3542a031a9194792832ac8569af142ff",
  32.         "createTime": "2018-04-26 15:35:30",
  33.         "secWdCode": "110030.SH",
  34.         "secName": "格力转债",
  35.         "noputPeriod": "24",
  36.         "condPutStartDate": "2018-01-01 00:00:00",
  37.         "condPutEndDate": "2010-01-01 00:00:00",
  38.         "putTrigMaxWindow": 30,
  39.         "putTrigWindow": 30,
  40.         "putTrigRatio": 70,
  41.         "putPrice": 103,
  42.         "putPriceTxt": "按债券103元(含当期应计利息)的价格回售给公司",
  43.         "putTimesLimit": 1,
  44.         "putInterestCalc": "应计",
  45.         "condPutClauseTxt": "自本次可转债第三个计息年度起。",
  46.         "uncondPutPeriod": "否",
  47.         "uncondPutStartDate": "",
  48.         "uncondPutEndDate": "",
  49.         "uncondPutPrice": null,
  50.         "uncondPutClauseTxt": "",
  51.         "timingPutTimes": null,
  52.         "timingPutClauseTxt": "",
  53.         "additionalPutPriceTxt": "可转债持有人有权将其持有的可转债全部或部分按103元（含当期应计利息）的价格回售给公司",
  54.         "additionalPutTrigTxt": "根据中国证监会的相关规定被视作改变募集资金用途或被中国证监会认定为改变募集资金用途的，公司本次发行的可转债持有人享有一次回售的权利。",
  55.         "pageSize": null,
  56.         "startIndex": null
  57.     },
  58.     "error": ""
  59. }

2,编辑一条数据

[put] /cbPutClause/{id}

  1. body: 
  2. {
  3.     "secWdCode": "110030.SH",
  4.     "secName": "格力转债",
  5.     "noputPeriod": 24,
  6.     "condPutStartDate": "2018-01-01 00:00:00",
  7.     "condPutEndDate": "2010-01-01 00:00:00",
  8.     "putTrigMaxWindow": 30,
  9.     "putTrigWindow": 30,
  10.     "putTrigRatio": 70,
  11.     "putPrice": 103,
  12.     "putPriceTxt": "按债券103元(含当期应计利息)的价格回售给公司",
  13.     "putTimesLimit": 1,
  14.     "putInterestCalc": "应计",
  15.     "condPutClauseTxt": "自本次可转债第三个计息年度起权。",
  16.     "uncondPutPeriod": "否",
  17.     "uncondPutStartDate": "aaaa",
  18.     "uncondPutEndDate": "",
  19.     "uncondPutPrice": "",
  20.     "uncondPutClauseTxt": "",
  21.     "timingPutTimes": "",
  22.     "timingPutClauseTxt": "",
  23.     "additionalPutPriceTxt": "可转债持有人有权将其持有的可转债全部或部分按103元（含当期应计利息）的价格回售给公司",
  24.     "additionalPutTrigTxt": "根据中国证监会的相关规定被视作改变募集资金用途或被中国证监会认定为改变募集资金用途的，公司本次发行的可转债持有人享有一次回售的权利。"
  25. }
  27. result:
  28. {
  29.     "statusCode": "000000",
  30.     "result": "ok",
  31.     "error": ""
  32. }

3,查询一条数据

[get] /cbPutClause/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": {},
  5.     "error": ""
  6. }

4,删除一条数据

[delete] /cbInterestClause/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": "ok",
  5.     "error": ""
  6. }

5,批量获取数据

[post] /cbPutClause/list

  1. body : 
  2. {
  3.     "secWdCode": "110030.SH",//equal to
  4.     "secName": "格力转债", //like
  5. }
  8. result:
  9. {
  10.     "statusCode": "000000",
  11.     "result": [
  12.         {
  13.             "uuid": "3542a031a9194792832ac8569af142ff",
  14.             "createTime": "2018-04-26 15:35:30",
  15.             "secWdCode": "110030.SH",
  16.             "secName": "格力转债",
  17.             "noputPeriod": "24",
  18.             "condPutStartDate": "2018-01-01 00:00:00",
  19.             "condPutEndDate": "2010-01-01 00:00:00",
  20.             "putTrigMaxWindow": 30,
  21.             "putTrigWindow": 30,
  22.             "putTrigRatio": 70,
  23.             "putPrice": 103,
  24.             "putPriceTxt": "按债券103元(含当期应计利息)的价格回售给公司",
  25.             "putTimesLimit": 1,
  26.             "putInterestCalc": "应计",
  27.             "condPutClauseTxt": "自本次可转债第三个计息年度起。",
  28.             "uncondPutPeriod": "否",
  29.             "uncondPutStartDate": "aaaa",
  30.             "uncondPutEndDate": "",
  31.             "uncondPutPrice": null,
  32.             "uncondPutClauseTxt": "",
  33.             "timingPutTimes": null,
  34.             "timingPutClauseTxt": "",
  35.             "additionalPutPriceTxt": "可转债持有人有权将其持有的可转债全部或部分按103元（含当期应计利息）的价格回售给公司",
  36.             "additionalPutTrigTxt": "根据中国证监会的相关规定被视作改变募集资金用途或被中国证监会认定为改变募集资金用途的，公司本次发行的可转债持有人享有一次回售的权利。",
  37.             "pageSize": null,
  38.             "startIndex": null
  39.         }
  40.     ],
  41.     "error": ""
  42. }

6,分页批量获取数据

[post] /cbPutClause/list/limit

  1. body : 
  2. {
  3.     "startIndex":"0",//分页索引下标，不填默认为0
  4.     "pageSize":"10",//每页显示条数，不填默认为10
  5.     "secWdCode": "110030.SH",//equal to
  6.     "secName": "格力转债", //like
  7. }
  9. result: 
  10. {
  11.     "statusCode": "000000",
  12.     "result": {
  13.         "data": [],
  14.         "startIndex": 0, //起始下标
  15.         "pageSize": 10,//每页显示条数
  16.         "totalCount": 1, //总条数
  17.         "currentPage": 1, //当前页
  18.         "pageCount": 1, //共多少页
  19.         "example": null //查询条件，response中无用
  20.     },
  21.     "error": ""
  22. }

八、(bond_conbdconvertinfo)

数据库信息

字段 名称 类型 说明
id primary key varchar(50)
innercode 证券内部编码 int(10)
infopubldate 信息发布日期 varchar(36)
infosource 信息来源 varchar(50)
enddate 日期 varchar(36)
issueamount 可转债总额(元) decimal(19,4)
totalamountconverted 累计转股金额(元) decimal(19,4)
totalvolconverted 累计转股数量(股) decimal(18,2)
remainingamount 可转债剩余金额(元) decimal(19,4)
currenttotalshares 转股后总股本(股) decimal(18,2)
convertprice 转股价(元/股) decimal(19,4)
amountthisperiod 本次转股金额(元) decimal(19,4)
volthisperiod 本次转股数量(股) decimal(18,2)
initialconvetprice 初始转股价(元/股) decimal(19,4)
accurealcp 累计实际转股价(元/股) decimal(19,4)
updatetime 更新时间 carchar(36)
jsid jsid decimal(19)
eventtype 事件类型 decimal
cprsum 本次赎回/兑付/回售金额(元) decimal(19,4)
totalcprsum 累计赎回/兑付/回售金额(元) decimal(19,4)
totalcbamountconverted 累计转股张数(张) decimal

1,添加一条数据

[post] /bondConbdconvertInfo

  1. body :
  2. {
  3.     "id": "540464764501",
  4.     "innercode": "67173",
  5.     "infopubldate": "2017-02-15 00:00:00",
  6.     "infosource": "转股情况公告0",
  7.     "enddate": "2017-02-14 00:00:00",
  8.     "issueamount": 1400000000.0000,
  9.     "totalamountconverted": 5276300.0000,
  10.     "totalvolconverted": 307043.00,
  11.     "remainingamount": 2494721700.0000,
  12.     "currenttotalshares": 1507476591.00,
  13.     "convertprice": 12.5600,
  14.     "amountthisperiod": 10000.0000,
  15.     "volthisperiod": 381.00,
  16.     "initialconvetprice": 12.8800,
  17.     "accurealcp": 12.5644,
  18.     "jsid": 540464764514,
  19.     "eventtype": "1",
  20.     "cprsum": "",
  21.     "totalcprsum": "",
  22.     "totalcbamountconverted": "52763"
  23. }
  25. result:
  26. {
  27.     "statusCode": "000000",
  28.     "result": {
  29.         "id": "540464764501",
  30.         "innercode": 67173,
  31.         "infopubldate": "2017-02-15 00:00:00",
  32.         "infosource": "转股情况公告0",
  33.         "enddate": "2017-02-14 00:00:00",
  34.         "issueamount": 1400000000,
  35.         "totalamountconverted": 5276300,
  36.         "totalvolconverted": 307043,
  37.         "remainingamount": 2494721700,
  38.         "currenttotalshares": 1507476591,
  39.         "convertprice": 12.56,
  40.         "amountthisperiod": 10000,
  41.         "volthisperiod": 381,
  42.         "initialconvetprice": 12.88,
  43.         "accurealcp": 12.5644,
  44.         "updatetime": "2018-05-02 16:18:46",
  45.         "jsid": 540464764514,
  46.         "eventtype": 1,
  47.         "cprsum": null,
  48.         "totalcprsum": null,
  49.         "totalcbamountconverted": 52763,
  50.         "pageSize": null,
  51.         "startIndex": null
  52.     },
  53.     "error": ""
  54. }

2,编辑一条数据

[put] /cbPutClause/{id}

  1. body: 
  2. {
  3.     "innercode": "67173",
  4.     "infopubldate": "2017-02-15 00:00:00",
  5.     "infosource": "转股情况公告1",
  6.     "enddate": "2017-02-14 00:00:00",
  7.     "issueamount": 1400000000.0000,
  8.     "totalamountconverted": 5276300.0000,
  9.     "totalvolconverted": 307043.00,
  10.     "remainingamount": 2494721700.0000,
  11.     "currenttotalshares": 1507476591.00,
  12.     "convertprice": 12.5600,
  13.     "amountthisperiod": 10000.0000,
  14.     "volthisperiod": 381.00,
  15.     "initialconvetprice": 12.8800,
  16.     "accurealcp": 12.5644,
  17.     "jsid": 540464764514,
  18.     "eventtype": "1",
  19.     "cprsum": "",
  20.     "totalcprsum": "",
  21.     "totalcbamountconverted": "52763"
  22. }
  24. result:
  25. {
  26.     "statusCode": "000000",
  27.     "result": "ok",
  28.     "error": ""
  29. }

3,查询一条数据

[get] /cbPutClause/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": {},
  5.     "error": ""
  6. }

4,删除一条数据

[delete] /cbInterestClause/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": "ok",
  5.     "error": ""
  6. }

5,批量获取数据

[post] /cbPutClause/list

  1. body : 
  2. {
  3.     "innercode": "64454" //equal to
  4. }
  7. result:
  8. {
  9.     "statusCode": "000000",
  10.     "result": [{}],
  11.     "error": ""
  12. }

6,分页批量获取数据

[post] /bondConbdconvertInfo/list/limit

  1. body : 
  2. {
  3.     "startIndex":"0",//分页索引下标，不填默认为0
  4.     "pageSize":"10",//每页显示条数，不填默认为10
  5.     "innercode": "64454" //equal to
  6. }
  8. result: 
  9. {
  10.     "statusCode": "000000",
  11.     "result": {
  12.         "data": [],
  13.         "startIndex": 0, //起始下标
  14.         "pageSize": 10,//每页显示条数
  15.         "totalCount": 1, //总条数
  16.         "currentPage": 1, //当前页
  17.         "pageCount": 1, //共多少页
  18.         "example": null //查询条件，response中无用
  19.     },
  20.     "error": ""
  21. }

九、(bond_conbdchangeinfo)

数据库信息

字段 名称 类型 说明
id primary key varchar(36)
innercode 证券内部编码 varchar(50)
bondcode 债券代码 varchar(50)
bondabnr 可转债券简称 varchar(50)
startdate 起始日期 varchar(36)
putlevel 修正触发转股价比例 decimal(19, 8)
putchangepro 修正幅度 decimal(19, 8)
putstartdate 修正开始日期 varchar(36)
puttype 行使权力次数名称 int(3)
puttypename 行使权力次数名称 varchar(50)
putconditionday 修正条件天数 int(10)
updatetime 更新时间 varchar(36)
jsid jsid varchar(50)
putenddate 修正结束日期 varchar(36)
putreachday 修正条件满足天数 int(10)

1,添加一条数据

[post] /bondConbdchangeInfo

  1. body :
  2. {
  3.     "id": "564047425362",
  4.     "innercode": "67173",
  5.     "bondcode": "128021",
  6.     "bondabnr": "18康02EB",
  7.     "startdate": "2017-02-14 00:00:00",
  8.     "putlevel": 0.85000000,
  9.     "putchangepro": "",
  10.     "putstartdate": "2017-11-10 00:00:00",
  11.     "puttype": 1,
  12.     "puttypename": "随时",
  13.     "putconditionday": 30,
  14.     "jsid": "563045448601",
  15.     "putenddate": "2020-11-05 00:00:00",
  16.     "putreachday": 15
  17. }
  18. result:
  19. {
  20.     "statusCode": "000000",
  21.     "result": {
  22.         "id": "564047425362",
  23.         "innercode": "67173",
  24.         "bondcode": "128021",
  25.         "bondabnr": "18康02EB",
  26.         "startdate": "2017-02-14 00:00:00",
  27.         "putlevel": 0.85,
  28.         "putchangepro": null,
  29.         "putstartdate": "2017-11-10 00:00:00",
  30.         "puttype": 1,
  31.         "puttypename": "随时",
  32.         "putconditionday": 30,
  33.         "updatetime": "2018-05-02 16:59:09",
  34.         "jsid": "563045448601",
  35.         "putenddate": "2020-11-05 00:00:00",
  36.         "putreachday": 15,
  37.         "pageSize": null,
  38.         "startIndex": null
  39.     },
  40.     "error": ""
  41. }

2,编辑一条数据

[put] /bondConbdchangeInfo/{id}

  1. body: 
  2. {
  3.     "innercode": "67173",
  4.     "bondcode": "128021",
  5.     "bondabnr": "182康02EB",
  6.     "startdate": "2017-02-14 00:00:00",
  7.     "putlevel": 0.85000000,
  8.     "putchangepro": "",
  9.     "putstartdate": "2017-11-10 00:00:00",
  10.     "puttype": 1,
  11.     "puttypename": "随时",
  12.     "putconditionday": 30,
  13.     "jsid": "563045448601",
  14.     "putenddate": "2020-11-05 00:00:00",
  15.     "putreachday": 15
  16. }
  18. result:
  19. {
  20.     "statusCode": "000000",
  21.     "result": "ok",
  22.     "error": ""
  23. }

3,查询一条数据

[get] /bondConbdchangeInfo/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": {},
  5.     "error": ""
  6. }

4,删除一条数据

[delete] /bondConbdchangeInfo/{id}

  1. result :
  2. {
  3.     "statusCode": "000000",
  4.     "result": "ok",
  5.     "error": ""
  6. }

5,批量获取数据

[post] /bondConbdchangeInfo/list

  1. body : 
  2. {
  3.     "innercode": "75609" //equal to
  4. }
  7. result:
  8. {
  9.     "statusCode": "000000",
  10.     "result": [{}],
  11.     "error": ""
  12. }

6,分页批量获取数据

[post] /bondConbdchangeInfo/list/limit

  1. body : 
  2. {
  3.     "startIndex":"0",//分页索引下标，不填默认为0
  4.     "pageSize":"10",//每页显示条数，不填默认为10
  5.     "innercode": "75609" //equal to
  6. }
  8. result: 
  9. {
  10.     "statusCode": "000000",
  11.     "result": {
  12.         "data": [],
  13.         "startIndex": 0, //起始下标
  14.         "pageSize": 10,//每页显示条数
  15.         "totalCount": 1, //总条数
  16.         "currentPage": 1, //当前页
  17.         "pageCount": 1, //共多少页
  18.         "example": null //查询条件，response中无用
  19.     },
  20.     "error": ""
  21. }

错误信息一览表

  1. id 数据不存在:
  2. {
  3.     "statusCode": "102001",
  4.     "result": "",
  5.     "error": "this id data does not exist"
  6. }
  8. 请求body不存在:
  9. {
  10.     "timestamp": "2018-04-25T07:24:14.089+0000",
  11.     "status": 400,
  12.     "error": "Bad Request",
  13.     "message": "Required request body is missing: public com.iquantex.cb.utils.Results com.iquantex.cb.controller.CbIssuerGuarantorController.getList(com.iquantex.cb.entity.CbIssuerGuarantor)",
  14.     "path": "/iquantex_cb/cbIssuerGuarantor/list"
  15. }
添加新批注
在作者公开此批注前，只有你和作者可见。
回复批注