API接口目录

自营业务

退厂API
厂送API
厂送退换货API
品牌串码API
采购订单API
供应商收发货API
售后服务API
供应商财务API
主数据API
自营合同API
自营商品API
自营财务API
采购计划API
收发货API
订单API
易道报表API
不良品API
自营促销API
异常码自查工具
suning.selfmarket.settlementdetail.query 分页查询结算清单明细
¥免费

分页查询结算清单明细

公共参数
请求参数
名称 类型 是否必须 示例值 描述
queryPageNoStringY1页码
queryPageSizeStringY10每页条数
supplierCodeStringY10000007供应商编码
billNumStringYJJ00000001070结算单号
detailTypeStringYA明细类型
响应参数
名称 类型 示例值 描述
detailAString
queryPageNoString1页码
queryPageSizeString10每页条数
totalRecordsString10总条数
dataAString
orderNoString9500333466采购订单号;采购入库&退货出库明细(A)
orderLineNoString0001采购订单行号;采购入库&退货出库明细(A)
transNoString10012339466入库单号;采购入库&退货出库明细(A)
transLineNoString0028入库单行号;采购入库&退货出库明细(A)
factoryOrderNoString1013739466供应商出库单号;采购入库&退货出库明细(A)
addressStringF343地点;采购入库&退货出库明细(A)
targetBinString8K3C库位;采购入库&退货出库明细(A)
cmmdtyCodeString000000000191570905商品编码;采购入库&退货出库明细(A)
cmmdtyNameString保温杯商品名称;采购入库&退货出库明细(A)
baseDateString2020-09-10入库日期/交货日期;采购入库&退货出库明细(A)
invoiceAmtString113.00记账金额;采购入库&退货出库明细(A),适用于JXRK04的出单方式
invoiceNumString1001217067发票校验流水号;采购入库&退货出库明细(A),适用于JXRK04的出单方式
taxRateString0.13税率;采购入库&退货出库明细(A),不适用于JXRK04的出单方式
transQtyString10交货数量;采购入库&退货出库明细(A)
setAmtString113.00结算金额;采购入库&退货出库明细(A)
serialNumStringC0721S006X样机序列号;采购入库&退货出库明细(A)
storeCodeString7304门店编码;采购入库&退货出库明细(A)
saleOrderLineNoString00249968311401转采销售订单行号;采购入库&退货出库明细(A)
setTypeStringRPO业务类型(PO:采购,RPO:采购退货)
detailBString
queryPageNoString1页码
queryPageSizeString10每页条数
totalRecordsString10总条数
dataBString
invoiceNoString00054000发票号码;发票记账明细(A),适用于JXRK04的出单方式
invoiceCodeString4400200000发票代码;发票记账明细(A),适用于JXRK04的出单方式
redInvoiceNumString3201062200000000红字通知单号;发票记账明细(A),适用于JXRK04的出单方式
invoiceNumString1001103258发票校验流水号;发票记账明细(A),适用于JXRK04的出单方式
detailCString
queryPageNoString1页码
queryPageSizeString10每页条数
totalRecordsString10总条数
dataCString
snCheckLetterNoString225477NAP00117100000苏宁确认函号;已收确认函待支付返利明细(B)
oriSnLetterNoString225477NAP00117100001原确认函号;已收确认函待支付返利明细(B)
supplyLetterNoString225477NAP00117100002补充确认函号;已收确认函待支付返利明细(B)
supplierCheckYsletterNoString111111111111111供应商费用预算单号;已收确认函待支付返利明细(B)
supplierCheckLetterAmountString200000.00函件金额;已收确认函待支付返利明细(B)
confirmDateString2022-04-01支付日期;已收确认函待支付返利明细(B)
setAmtString-200000本期结算单出单金额;已收确认函待支付返利明细(B)
taxString0.06税率;已收确认函待支付返利明细(B)
settleTypeStringS03结算方式;已收确认函待支付返利明细(B)
detailDString
queryPageNoString1页码
queryPageSizeString10每页条数
totalRecordsString10总条数
dataDString
feeOrderNoStringM20220474290000订单号;已收活动函待支付返利(B)
letterCouponNoString202204070018200000费用类型编号;已收活动函待支付返利(B)
feeDescString广告费费用描述;已收活动函待支付返利(B)
confirmDateString2022-04-01支付日期;已收活动函待支付返利(B)
setAmtString-200000应收金额;已收活动函待支付返利(B)
taxString0.06税率;已收活动函待支付返利(B)
settleTypeStringS03结算方式;已收活动函待支付返利(B)
detailEString
queryPageNoString1页码
queryPageSizeString10每页条数
totalRecordsString10总条数
dataEString
sourceSystemString预付款业务类型;未冲销预付款(C)
applyAmtString100.00金额;未冲销预付款(C)
applyDateString2020-10-16付款日期;未冲销预付款(C)
preNumStringYF20200000000付款单号;未冲销预付款(C)
preDaccAddStringDH50账扣地点;未冲销预付款(C)
detailFString
queryPageNoString1页码
queryPageSizeString10每页条数
totalRecordsString10总条数
dataFString
orderNoString9500333466退货订单号;超期退货明细(D),适用于JXRK04的出单方式
orderLineNoString0001行项目号;超期退货明细(D),适用于JXRK04的出单方式
transNoString10012339466交货单号;超期退货明细(D),适用于JXRK04的出单方式
addressStringF343地点;超期退货明细(D),适用于JXRK04的出单方式
targetBinString8K3C库位;超期退货明细(D),适用于JXRK04的出单方式
cmmdtyCodeString000000000191570905商品编码;超期退货明细(D),适用于JXRK04的出单方式
cmmdtyNameString保温杯商品名称;超期退货明细(D),适用于JXRK04的出单方式
baseDateString2020-09-10出库日期;超期退货明细(D),适用于JXRK04的出单方式
transQtyString1出库数量;超期退货明细(D),适用于JXRK04的出单方式
setAmtString113.00出库金额;超期退货明细(D),适用于JXRK04的出单方式
detailGString
queryPageNoString1页码
queryPageSizeString10每页条数
totalRecordsString10总条数
dataGString
snCheckLetterNoString225477NAP00117100000苏宁确认函号;已收确认函超期返利明细(D)
supplierCheckYsletterNoString111111111111111供应商费用预算单号;已收确认函超期返利明细(D)
supplierCheckLetterAmountString200000.00函件金额;已收确认函超期返利明细(D)
confirmDateString2022-04-01支付日期;已收确认函超期返利明细(D)
setAmtString-200000本期结算单出单金额;已收确认函超期返利明细(D)
taxString0.06税率;已收确认函超期返利明细(D)
detailHString
queryPageNoString1页码
queryPageSizeString10每页条数
totalRecordsString10总条数
dataHString
feeOrderNoStringM20220474290000订单号;已收活动函超期明细(D)
letterCouponNoString202204070018200000有函有货单活动函号;已收活动函超期明细(D)
activityTypeString20083114570410004754赋能ID;已收活动函超期明细(D)
feeDescString广告费费用描述;已收活动函超期明细(D)
confirmDateString2022-04-01支付日期;已收活动函超期明细(D)
taxString0.06税率;已收活动函超期明细(D)
setAmtString-200000应收金额;已收活动函超期明细(D)
detailIString
queryPageNoString1页码
queryPageSizeString10每页条数
totalRecordsString10总条数
dataIString
adjustMentTypeString扣款补扣款类型;其他补款扣款项明细(E)
setTypeString行政处罚业务类型;其他补款扣款项明细(E)
deductionCodeStringG067760000单据号;其他补款扣款项明细(E)
setAmtString-100.00出库金额;其他补款扣款项明细(E)
detailJString
queryPageNoString1页码
queryPageSizeString10每页条数
totalRecordsString10总条数
dataJString
orderItemIdString00251056320001OMS订单行号;节能补贴扣款补款项(E)
relatedItemIdString00251056320002原OMS订单行号;节能补贴扣款补款项(E)
effectiveTimeString2022-04-30销售日期;节能补贴扣款补款项(E)
zkAmountString-100.00节能补贴金额;节能补贴扣款补款项(E)
detailKString
queryPageNoString1页码
queryPageSizeString10每页条数
totalRecordsString10总条数
dataKString
orderNoString4551210000采购订单号;发票差异补扣款(F)
orderLineNoString00010采购订单行号;发票差异补扣款(F)
factoryOrderNoString1607178663交货单号;发票差异补扣款(F)
targetStorageStringD064地点;发票差异补扣款(F)
targetBinString2000库位;发票差异补扣款(F)
cmmdtyCodeString000000000107020000商品编码;发票差异补扣款(F)
cmmdtyNameString保温杯商品名称;发票差异补扣款(F)
detailLString
queryPageNoString1页码
queryPageSizeString10每页条数
totalRecordsString10总条数
dataLString
oldBillNumStringJJ00000000000结算单;发票差异补扣款(F),适用于JXRK06的出单方式
invoiceAmtString100.00应开票金额;发票差异补扣款(F),适用于JXRK06的出单方式
checkAmtString1.00发票校验金额;发票差异补扣款(F),适用于JXRK06的出单方式
diffAmtString100.00差异金额;发票差异补扣款(F),适用于JXRK06的出单方式
detailMString
queryPageNoString1页码
queryPageSizeString10每页条数
totalRecordsString10总条数
dataMString
creditBillNumStringJJ00000580000结算单;上期负数结算单(G)
creditAmtString-140.00结算金额;上期负数结算单(G)
请求示例
  • XML示例
  • JSON示例
复制全部代码
                                <sn_request>
  <sn_body>
    <querySettlementdetail>
      <detailType>A</detailType>
      <queryPageSize>10</queryPageSize>
      <supplierCode>10000007</supplierCode>
      <billNum>JJ00000001070</billNum>
      <queryPageNo>1</queryPageNo>
    </querySettlementdetail>
  </sn_body>
</sn_request>

                                
                                {
  "sn_request": {
    "sn_body": {
      "querySettlementdetail": {
        "detailType": "A",
        "queryPageSize": "10",
        "supplierCode": "10000007",
        "billNum": "JJ00000001070",
        "queryPageNo": "1"
      }
    }
  }
}
                                
响应示例
  • XML示例
  • JSON示例
复制全部代码
                              <sn_responseContent>
  <sn_body>
    <querySettlementdetail>
      <detailI>
        <dataI>
          <deductionCode>G067760000</deductionCode>
          <setAmt>-100.00</setAmt>
          <adjustMentType>扣款</adjustMentType>
          <setType>行政处罚</setType>
        </dataI>
        <totalRecords>10</totalRecords>
        <queryPageSize>10</queryPageSize>
        <queryPageNo>1</queryPageNo>
      </detailI>
      <detailJ>
        <totalRecords>10</totalRecords>
        <queryPageSize>10</queryPageSize>
        <queryPageNo>1</queryPageNo>
        <dataJ>
          <zkAmount>-100.00</zkAmount>
          <relatedItemId>00251056320002</relatedItemId>
          <effectiveTime>2022-04-30</effectiveTime>
          <orderItemId>00251056320001</orderItemId>
        </dataJ>
      </detailJ>
      <detailK>
        <totalRecords>10</totalRecords>
        <queryPageSize>10</queryPageSize>
        <queryPageNo>1</queryPageNo>
        <dataK>
          <orderLineNo>00010</orderLineNo>
          <orderNo>4551210000</orderNo>
          <targetBin>2000</targetBin>
          <cmmdtyCode>000000000107020000</cmmdtyCode>
          <cmmdtyName>保温杯</cmmdtyName>
          <factoryOrderNo>1607178663</factoryOrderNo>
          <targetStorage>D064</targetStorage>
        </dataK>
      </detailK>
      <detailL>
        <totalRecords>10</totalRecords>
        <queryPageSize>10</queryPageSize>
        <dataL>
          <oldBillNum>JJ00000000000</oldBillNum>
          <checkAmt>1.00</checkAmt>
          <diffAmt>100.00</diffAmt>
          <invoiceAmt>100.00</invoiceAmt>
        </dataL>
        <queryPageNo>1</queryPageNo>
      </detailL>
      <detailM>
        <totalRecords>10</totalRecords>
        <queryPageSize>10</queryPageSize>
        <dataM>
          <creditAmt>-140.00</creditAmt>
          <creditBillNum>JJ00000580000</creditBillNum>
        </dataM>
        <queryPageNo>1</queryPageNo>
      </detailM>
      <detailA>
        <totalRecords>10</totalRecords>
        <dataA>
          <transLineNo>0028</transLineNo>
          <orderLineNo>0001</orderLineNo>
          <address>F343</address>
          <baseDate>2020-09-10</baseDate>
          <orderNo>9500333466</orderNo>
          <serialNum>C0721S006X</serialNum>
          <setAmt>113.00</setAmt>
          <cmmdtyCode>000000000191570905</cmmdtyCode>
          <cmmdtyName>保温杯</cmmdtyName>
          <setType>RPO</setType>
          <transNo>10012339466</transNo>
          <invoiceNum>1001217067</invoiceNum>
          <invoiceAmt>113.00</invoiceAmt>
          <taxRate>0.13</taxRate>
          <targetBin>8K3C</targetBin>
          <transQty>10</transQty>
          <factoryOrderNo>1013739466</factoryOrderNo>
          <saleOrderLineNo>00249968311401</saleOrderLineNo>
          <storeCode>7304</storeCode>
        </dataA>
        <queryPageSize>10</queryPageSize>
        <queryPageNo>1</queryPageNo>
      </detailA>
      <detailB>
        <totalRecords>10</totalRecords>
        <dataB>
          <redInvoiceNum>3201062200000000</redInvoiceNum>
          <invoiceNo>00054000</invoiceNo>
          <invoiceCode>4400200000</invoiceCode>
          <invoiceNum>1001103258</invoiceNum>
        </dataB>
        <queryPageSize>10</queryPageSize>
        <queryPageNo>1</queryPageNo>
      </detailB>
      <detailC>
        <totalRecords>10</totalRecords>
        <dataC>
          <confirmDate>2022-04-01</confirmDate>
          <setAmt>-200000</setAmt>
          <snCheckLetterNo>225477NAP00117100000</snCheckLetterNo>
          <supplyLetterNo>225477NAP00117100002</supplyLetterNo>
          <supplierCheckLetterAmount>200000.00</supplierCheckLetterAmount>
          <tax>0.06</tax>
          <oriSnLetterNo>225477NAP00117100001</oriSnLetterNo>
          <supplierCheckYsletterNo>111111111111111</supplierCheckYsletterNo>
          <settleType>S03</settleType>
        </dataC>
        <queryPageSize>10</queryPageSize>
        <queryPageNo>1</queryPageNo>
      </detailC>
      <detailD>
        <totalRecords>10</totalRecords>
        <dataD>
          <letterCouponNo>202204070018200000</letterCouponNo>
          <confirmDate>2022-04-01</confirmDate>
          <feeDesc>广告费</feeDesc>
          <setAmt>-200000</setAmt>
          <feeOrderNo>M20220474290000</feeOrderNo>
          <tax>0.06</tax>
          <settleType>S03</settleType>
        </dataD>
        <queryPageSize>10</queryPageSize>
        <queryPageNo>1</queryPageNo>
      </detailD>
      <detailE>
        <totalRecords>10</totalRecords>
        <dataE>
          <preDaccAdd>DH50</preDaccAdd>
          <sourceSystem>预付款</sourceSystem>
          <preNum>YF20200000000</preNum>
          <applyDate>2020-10-16</applyDate>
          <applyAmt>100.00</applyAmt>
        </dataE>
        <queryPageSize>10</queryPageSize>
        <queryPageNo>1</queryPageNo>
      </detailE>
      <detailF>
        <totalRecords>10</totalRecords>
        <dataF>
          <orderLineNo>0001</orderLineNo>
          <address>F343</address>
          <baseDate>2020-09-10</baseDate>
          <orderNo>9500333466</orderNo>
          <setAmt>113.00</setAmt>
          <targetBin>8K3C</targetBin>
          <transQty>1</transQty>
          <cmmdtyCode>000000000191570905</cmmdtyCode>
          <cmmdtyName>保温杯</cmmdtyName>
          <transNo>10012339466</transNo>
        </dataF>
        <queryPageSize>10</queryPageSize>
        <queryPageNo>1</queryPageNo>
      </detailF>
      <detailG>
        <totalRecords>10</totalRecords>
        <dataG>
          <confirmDate>2022-04-01</confirmDate>
          <setAmt>-200000</setAmt>
          <snCheckLetterNo>225477NAP00117100000</snCheckLetterNo>
          <supplierCheckLetterAmount>200000.00</supplierCheckLetterAmount>
          <tax>0.06</tax>
          <supplierCheckYsletterNo>111111111111111</supplierCheckYsletterNo>
        </dataG>
        <queryPageSize>10</queryPageSize>
        <queryPageNo>1</queryPageNo>
      </detailG>
      <detailH>
        <dataH>
          <letterCouponNo>202204070018200000</letterCouponNo>
          <confirmDate>2022-04-01</confirmDate>
          <feeDesc>广告费</feeDesc>
          <setAmt>-200000</setAmt>
          <feeOrderNo>M20220474290000</feeOrderNo>
          <tax>0.06</tax>
          <activityType>20083114570410004754</activityType>
        </dataH>
        <totalRecords>10</totalRecords>
        <queryPageSize>10</queryPageSize>
        <queryPageNo>1</queryPageNo>
      </detailH>
    </querySettlementdetail>
  </sn_body>
</sn_responseContent>

                              
                              {
  "sn_responseContent": {
    "sn_body": {
      "querySettlementdetail": {
        "detailI": [
          {
            "dataI": [
              {
                "deductionCode": "G067760000",
                "setAmt": "-100.00",
                "adjustMentType": "扣款",
                "setType": "行政处罚"
              }
            ],
            "totalRecords": "10",
            "queryPageSize": "10",
            "queryPageNo": "1"
          }
        ],
        "detailJ": [
          {
            "totalRecords": "10",
            "queryPageSize": "10",
            "queryPageNo": "1",
            "dataJ": [
              {
                "zkAmount": "-100.00",
                "relatedItemId": "00251056320002",
                "effectiveTime": "2022-04-30",
                "orderItemId": "00251056320001"
              }
            ]
          }
        ],
        "detailK": [
          {
            "totalRecords": "10",
            "queryPageSize": "10",
            "queryPageNo": "1",
            "dataK": [
              {
                "orderLineNo": "00010",
                "orderNo": "4551210000",
                "targetBin": "2000",
                "cmmdtyCode": "000000000107020000",
                "cmmdtyName": "保温杯",
                "factoryOrderNo": "1607178663",
                "targetStorage": "D064"
              }
            ]
          }
        ],
        "detailL": [
          {
            "totalRecords": "10",
            "queryPageSize": "10",
            "dataL": [
              {
                "oldBillNum": "JJ00000000000",
                "checkAmt": "1.00",
                "diffAmt": "100.00",
                "invoiceAmt": "100.00"
              }
            ],
            "queryPageNo": "1"
          }
        ],
        "detailM": [
          {
            "totalRecords": "10",
            "queryPageSize": "10",
            "dataM": [
              {
                "creditAmt": "-140.00",
                "creditBillNum": "JJ00000580000"
              }
            ],
            "queryPageNo": "1"
          }
        ],
        "detailA": [
          {
            "totalRecords": "10",
            "dataA": [
              {
                "transLineNo": "0028",
                "orderLineNo": "0001",
                "address": "F343",
                "baseDate": "2020-09-10",
                "orderNo": "9500333466",
                "serialNum": "C0721S006X",
                "setAmt": "113.00",
                "cmmdtyCode": "000000000191570905",
                "cmmdtyName": "保温杯",
                "setType": "RPO",
                "transNo": "10012339466",
                "invoiceNum": "1001217067",
                "invoiceAmt": "113.00",
                "taxRate": "0.13",
                "targetBin": "8K3C",
                "transQty": "10",
                "factoryOrderNo": "1013739466",
                "saleOrderLineNo": "00249968311401",
                "storeCode": "7304"
              }
            ],
            "queryPageSize": "10",
            "queryPageNo": "1"
          }
        ],
        "detailB": [
          {
            "totalRecords": "10",
            "dataB": [
              {
                "redInvoiceNum": "3201062200000000",
                "invoiceNo": "00054000",
                "invoiceCode": "4400200000",
                "invoiceNum": "1001103258"
              }
            ],
            "queryPageSize": "10",
            "queryPageNo": "1"
          }
        ],
        "detailC": [
          {
            "totalRecords": "10",
            "dataC": [
              {
                "confirmDate": "2022-04-01",
                "setAmt": "-200000",
                "snCheckLetterNo": "225477NAP00117100000",
                "supplyLetterNo": "225477NAP00117100002",
                "supplierCheckLetterAmount": "200000.00",
                "tax": "0.06",
                "oriSnLetterNo": "225477NAP00117100001",
                "supplierCheckYsletterNo": "111111111111111",
                "settleType": "S03"
              }
            ],
            "queryPageSize": "10",
            "queryPageNo": "1"
          }
        ],
        "detailD": [
          {
            "totalRecords": "10",
            "dataD": [
              {
                "letterCouponNo": "202204070018200000",
                "confirmDate": "2022-04-01",
                "feeDesc": "广告费",
                "setAmt": "-200000",
                "feeOrderNo": "M20220474290000",
                "tax": "0.06",
                "settleType": "S03"
              }
            ],
            "queryPageSize": "10",
            "queryPageNo": "1"
          }
        ],
        "detailE": [
          {
            "totalRecords": "10",
            "dataE": [
              {
                "preDaccAdd": "DH50",
                "sourceSystem": "预付款",
                "preNum": "YF20200000000",
                "applyDate": "2020-10-16",
                "applyAmt": "100.00"
              }
            ],
            "queryPageSize": "10",
            "queryPageNo": "1"
          }
        ],
        "detailF": [
          {
            "totalRecords": "10",
            "dataF": [
              {
                "orderLineNo": "0001",
                "address": "F343",
                "baseDate": "2020-09-10",
                "orderNo": "9500333466",
                "setAmt": "113.00",
                "targetBin": "8K3C",
                "transQty": "1",
                "cmmdtyCode": "000000000191570905",
                "cmmdtyName": "保温杯",
                "transNo": "10012339466"
              }
            ],
            "queryPageSize": "10",
            "queryPageNo": "1"
          }
        ],
        "detailG": [
          {
            "totalRecords": "10",
            "dataG": [
              {
                "confirmDate": "2022-04-01",
                "setAmt": "-200000",
                "snCheckLetterNo": "225477NAP00117100000",
                "supplierCheckLetterAmount": "200000.00",
                "tax": "0.06",
                "supplierCheckYsletterNo": "111111111111111"
              }
            ],
            "queryPageSize": "10",
            "queryPageNo": "1"
          }
        ],
        "detailH": [
          {
            "dataH": [
              {
                "letterCouponNo": "202204070018200000",
                "confirmDate": "2022-04-01",
                "feeDesc": "广告费",
                "setAmt": "-200000",
                "feeOrderNo": "M20220474290000",
                "tax": "0.06",
                "activityType": "20083114570410004754"
              }
            ],
            "totalRecords": "10",
            "queryPageSize": "10",
            "queryPageNo": "1"
          }
        ]
      }
    }
  }
}
                              
异常示例
  • XML示例
  • JSON示例
复制全部代码

  
  	API异常码
  	异常码中文描述
  

                           	  
{
  "sn_responseContent": {
    "sn_error": {
      "error_code": "API异常码",
      "error_msg": "异常码中文描述"
    }
  }
}
                           		
业务异常码
异常码 错误描述 解决方案
biz.selfmarket.querysettlementdetail.missing-parameter:* 参数必填 请检查此参数的值,*号表示参数字段名
biz.handler.data-get:no-result 查询没结果 请检查查询参数
isp.sys.service.unavailable.sbc 服务不可用 请联系苏宁技术人员
biz.selfmarket.querysettlementdetail.invalid-biz:100 供应商编码不存在或格式错误 请输入正确参数。
biz.selfmarket.querysettlementdetail.invalid-biz:101 页码必须是正整数 请输入正确参数。
biz.selfmarket.querysettlementdetail.invalid-biz:102 每页查询条数大于0且小于等于50的整数 请输入正确参数。
biz.selfmarket.querysettlementdetail.invalid-biz:103 结算清单号必填 请输入正确参数。
biz.selfmarket.querysettlementdetail.invalid-biz:104 结算清单号不存在 请输入正确参数。
biz.selfmarket.querysettlementdetail.invalid-biz:105 明细类型必填 请输入正确参数。
biz.selfmarket.querysettlementdetail.invalid-biz:106 明细类型只能为A/B/C/D/E/F/G 请输入正确参数。
公共异常码
API工具
FAQ