接口名称t100.oapi.purchase.inspection.return.list.data.query.get接口说明查询采购验退单清单资料程序代号wssp00115输入参数说明参数代号型态是否必填参数说明范例值requestkeystring是检核编码(MD5)109c3c41a1441e702b909ed3de58e4b1typestring是Request类型(sync,async)固定传入synchostprodstring是发起方产品名称OAPIverstring是发起方产品版本1.0ipstring是发起方IP位置10.40.71.91idstring否发起方产品识别码，提供同一产品多台主机辨别之用acctstring是登入帐号固定传入tiptoptimestampstring是时间戳记格式：yyyyMMddHHmmssSSS20151211123204361timezonestring否发起方时区(-12~+14)+8langstring是语言别(zh_TW,zh_CN,en,vi)zh_CNserviceprodstring是接收方产品名称T100namestring是服务名称t100.oapi.purchase.inspection.return.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号99CompanyIdstring否营运据点DSCTC参数代号型态是否必填参数说明范例值ERP字段enterprise_nostring否企业编号若无传值则预设值g_enterprise99pmdsentsite_nostring否营运中心DSCTCpmdssiteis_digiwin_productstring是是否为鼎捷产品(Y,N)Ydoc_typenumeric否单据性质1.验退单、2.委外验退单、3.借货采购验退作业3pmds000doc_nostring否验退单号CTC-YTD-202304070001pmdsdocnoapplicant_nostring否申请人编号00272pmds002supplier_nostring否采购供应商00000002pmds007receipt_nostring否收货单号CTC-HS4-230300000003pmds006data_timedate否异动时间格式：yyyyMMddHHmmss20230621000000key_conditionstring否前次最后一笔资料的Key条件use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页1page_sizenumeric否每页条数/分包的请求笔数2page_nonumeric否页码1date_sstring否开始日期格式：yyyyMMdd20230601pmdsdocdtdate_estring否结束日期格式：yyyyMMdd20230630pmdsdocdtconditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))((、((、)、))field_namestring否字段名称pmds000valuestring否字段值1operatorstring否操作符>、>=、=、<、<=、like、in、<>=>、>=、=、<、<=、like、in、<>logicalstring否搜寻组间的关系AND、ORANDAND、ORorders—否排序设置(单头节点，支持多数组)field_namestring否字段名称pmdsdocdtorder_typestring否排序类型asc、descascasc、descRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:9733e76416c3eb93e96da906716a7835digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.purchase.inspection.return.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点"}{"std_data":{"parameter":{"enterprise_no":"企业编号","site_no":"营运据点","is_digiwin_product":"是否为鼎捷产品","doc_type":"单据性质","doc_no":"验退单号","applicant_no":"申请人编号","supplier_no":"采购供应商","receipt_no":"收货单号","data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","use_has_next":"是否启用分页机制","page_size":"每页条数/分包的请求笔数","page_no":"页码","date_s":"开始日期","date_e":"结束日期","conditions":[{"sequence":"字段名称","bracket":"括号类型","field_name":"字段名称","value":"字段值","operator":"操作符","logical":"搜寻组间的关系"}],"orders":[{"field_name":"字段名称","order_type":"排序类型"}]}}}成功返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确0<>0：FAIL（原因代码）sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述data_timedate否异动时间格式：yyyyMMddHHmmsskey_conditionstring否前次最后一笔资料的Key条件total_resultsnumeric是总数has_nextboolean是是否有下一页true.是false.否purchase_inspection_return—是采购验退(单头节点，支持多数组)doc_typenumeric是单据性质1.验退单、2.委外验退单、3.借货采购验退作业5pmds000doc_nostring是验退单号CTC-YTD-202304070001pmdsdocnosource_nostring是来源单号(传入方)pmds042statusstring是状态码Ypmdsstuscreate_datedate是单据日期格式：yyyy-mm-dd2023-04-07pmdsdocdtsupplier_nostring是采购供应商00000002pmds007datedate是退货日期格式：yyyy-mm-dd2023-04-07pmds001applicant_nostring是申请人编号00272pmds002application_departmentstring是申请部门MADpmds003receipt_nostring是收货单号CTC-HS4-230300000003pmds006remarkstring是备注purchase_inspection_return_detail—是采购验退明细(单身节点，支持多数组)seqnumeric是项次1pmdtseqreceipt_nostring是收货单号CTC-HS4-230300000003pmdt027receipt_seqnumeric是收货项次1pmdt028purchase_nostring是采购单号CTC-PO1-202303300001pmdt001purchase_seqnumeric是采购项次1pmdt002line_seqnumeric是采购项序1pmdt003batch_seqnumeric是采购分批序1pmdt004item_nostring是料件编号00272-230330-P1pmdt006item_namestring是品名AVL-1imaal003item_specstring是规格AVL-1imaal004unit_nostring是单位PCSpmdt019doc_qtynumeric是退货数量5.000000pmdt020reference_unit_nostring是参考单位pmdt021reference_qtynumeric是参考数量pmdt022valuation_unit_nostring是计价单位PCSpmdt023valuation_qtynumeric是计价数量5.000000pmdt024qc_nostring是验收单号CTC-Q30-230300000001pmdt081qc_seqnumeric是验收单项次2pmdt082shipping_nostring是出货单号pmdt064shipping_seqnumeric是出货单项次pmdt065body_remarkstring是单身备注ooff013Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:81fc47a7-39b8-4320-995d-94d7bc6c5015digi-protocol:rawdigi-srvver:1.0digi-srvcode:000{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","purchase_inspection_return":[{"doc_type":"单据性质","doc_no":"验退单号","source_no":"来源单号(传入方)","status":"状态码","create_date":"单据日期","supplier_no":"采购供应商","date":"退货日期","applicant_no":"申请人编号","application_department":"申请部门","receipt_no":"收货单号","remark":"备注","purchase_inspection_return_detail":[{"seq":"项次","receipt_no":"收货单号","receipt_seq":"收货项次","purchase_no":"采购单号","purchase_seq":"采购项次","line_seq":"采购项序","batch_seq":"采购分批序","item_no":"料件编号","item_name":"品名","item_spec":"规格","unit_no":"单位","doc_qty":"退货数量","reference_unit_no":"参考单位","reference_qty":"参考数量","valuation_unit_no":"计价单位","valuation_qty":"计价数量","qc_no":"验收单号","qc_seq":"验收单项次","shipping_no":"出货单号","shipping_seq":"出货单项次","body_remark":"单身备注"}]}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确<>0：FAIL（原因代码）wss-00138sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述传入参数is_digiwin_product不可为空！Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:75788d6b-1ddd-4848-a06e-10e978d3b2eadigi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
