获取云结算交易列表

简要描述：

  • 通过此接口，可以查询商户下的所有云结算交易信息，可用于数据复核和报表查询。

请求URL：

  • 沙箱环境 http://api.sandbox.yhsms.com.cn/UserAccount/Account/AccountService.svc/GetReceiptList
  • 生产环境 http://api.yhsms.com.cn/UserAccount/Account/AccountService.svc/GetReceiptList

请求方式：

  • POST

参数：

参数名 必选 类型 说明
PlatformID 是 string YHDT号
PlatformAccessToken 是 string 平台级接口访问Token
ParamObject 是 string 单据查询参数，详见以下说明

ParamObject参数说明

参数名 类型 说明
TableName string 查询的数据表名称，只持 tbReceipt
FieldName string 查询的字段名称，多个字段用逗号分隔，如：ReceiptID,PayType,TotalFee,PayChannel,CreateTime
Condition string 查询条件，SQL语法，按照FieldName传入，例如：ReceiptID=’6270818771674337280’
FieldSort string 排序条件，SQL语法，按照FieldName传入，例如：CreateTime DESC
PageSize string 分页大小，例如 50
PageIndex string 指定页码，例如 1

返回示例

  1. {
  2.     "Code":"0",
  3.     "Method":0,
  4.     "Compressed":false,
  5.     "Encrypted":false,
  6.     "Message":{
  7.         "RtnValue":626,
  8.         "RtnMsg":1,
  9.         "RtnCount":626,
  10.         "RtnPageCount":63,
  11.         "RtnCurPage":1,
  12.         "ResultList":[
  13.             {
  14.                 "ReceiptID":"6379975095373570049",
  15.                 "PayType":"PT_TRANSFER",
  16.                 "TotalFee":200,
  17.                 "PayChannel":"PC_YH",
  18.                 "CreateTime":"2018-03-15T17:03:16.943",
  19.                 "_ROW":1
  20.             },
  21.             {
  22.                 "ReceiptID":"6379974931795714048",
  23.                 "PayType":"PT_TRANSFER",
  24.                 "TotalFee":-2000,
  25.                 "PayChannel":"PC_YH",
  26.                 "CreateTime":"2018-03-15T17:02:37.943",
  27.                 "_ROW":2
  28.             },
  29.             {
  30.                 "ReceiptID":"6379971544484192256",
  31.                 "PayType":"PT_TRANSFER",
  32.                 "TotalFee":5000,
  33.                 "PayChannel":"PC_YH",
  34.                 "CreateTime":"2018-03-15T16:49:10.343",
  35.                 "_ROW":3
  36.             },
  37.             {
  38.                 "ReceiptID":"6379869651527311360",
  39.                 "PayType":"PT_DEPOSIT",
  40.                 "TotalFee":1000,
  41.                 "PayChannel":"PC_YH",
  42.                 "CreateTime":"2018-03-15T10:04:17.17",
  43.                 "_ROW":4
  44.             },
  45.             {
  46.                 "ReceiptID":"6379650556622053376",
  47.                 "PayType":"PT_TRANSFER",
  48.                 "TotalFee":-12,
  49.                 "PayChannel":"PC_YH",
  50.                 "CreateTime":"2018-03-14T19:33:40.873",
  51.                 "_ROW":5
  52.             },
  53.             {
  54.                 "ReceiptID":"6379640023302840320",
  55.                 "PayType":"PT_TRANSFER",
  56.                 "TotalFee":20,
  57.                 "PayChannel":"PC_YH",
  58.                 "CreateTime":"2018-03-14T18:51:49.537",
  59.                 "_ROW":6
  60.             },
  61.             {
  62.                 "ReceiptID":"T6379231619300237312",
  63.                 "PayType":"PT_REFUND",
  64.                 "TotalFee":109.36,
  65.                 "PayChannel":"PC_YH",
  66.                 "CreateTime":"2018-03-13T15:48:58.433",
  67.                 "_ROW":7
  68.             },
  69.             {
  70.                 "ReceiptID":"6379225469741735936",
  71.                 "PayType":"PT_PAY",
  72.                 "TotalFee":109.36,
  73.                 "PayChannel":"PC_YH",
  74.                 "CreateTime":"2018-03-13T15:24:32.263",
  75.                 "_ROW":8
  76.             },
  77.             {
  78.                 "ReceiptID":"T6379204535731396608",
  79.                 "PayType":"PT_REFUND",
  80.                 "TotalFee":109.36,
  81.                 "PayChannel":"PC_YH",
  82.                 "CreateTime":"2018-03-13T14:01:21.207",
  83.                 "_ROW":9
  84.             },
  85.             {
  86.                 "ReceiptID":"6379203580369608704",
  87.                 "PayType":"PT_PAY",
  88.                 "TotalFee":109.36,
  89.                 "PayChannel":"PC_YH",
  90.                 "CreateTime":"2018-03-13T13:57:33.43",
  91.                 "_ROW":10
  92.             }
  93.         ]
  94.     }
  95. }

返回参数说明

参数名 类型 说明
Message string 查询结果集
RtnCount int 记录总条数
RtnPageCount int 总页数
RtnCurPage int 当前页码
ResultList Array 记录集

备注

  • 更多返回错误代码请看首页的错误代码描述
文档更新时间: 2018-07-31 15:27   作者：张国伟