接口名称t100.oapi.sales.return.list.data.query.get接口说明查询销退单列表资料程序代号wssp00165输入参数说明参数代号型态是否必填参数说明范例值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.sales.return.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号99CompanyIdstring否营运据点DSCTC参数代号型态是否必填参数说明范例值ERP字段enterprise_nostring否企业编号若无传值则预设值g_enterprise99xmdkentsite_nostring否营运中心DSCTCxmdksiteis_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间格式：yyyyMMddHHmmssSSS20221001080300000key_conditionstring否前次最后一笔资料的Key条件ENT=99ANDKEY1='CTC-998-210600000002'use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数50page_nonumeric否页码3sales_return_nostring是销退单单号CTC-998-210600000002xmdkdocnocustomer_nostring是客户编号190910-1xmdk007customer_namestring否客户名称190910-1测试pmaal004sales_nostring否业务人员12133xmdk003sales_namestring否业务人员名称刘测试ooag011sales_department_nostring否业务部门BP0240xmdk004sales_department_namestring否业务部门名称开发部ooefl003date_sstring否开始日期格式：yyyyMMdd20230601xmdkdocdtdate_estring否结束日期格式：yyyyMMdd20230630xmdkdocdtconditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否字段名称xmdk045valuestring否字段值1operatorstring否操作符>、>=、=、<、<=、like、in、<>=logicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点，支持多数组)field_namestring否字段名称xmdkdocdtorder_typestring否排序类型asc：升序desc：降幂ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:7f3137ada51506e4d20042f7ffb53c56digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"ERP","name":"t100.oapi.sales.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":"是否为鼎捷产品","data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","use_has_next":"是否启用分页机制","page_size":"每页条数/分包的请求笔数","page_no":"页码","sales_return_no":"销退单单号","customer_no":"客户编号","customer_name":"客户名称","sales_no":"业务人员","sales_name":"业务人员名称","sales_department_no":"业务部门","sales_department_name":"业务部门名称","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法完成预期的结果datakeysales_return_nostring是销退单单号CTC-998-210600000002xmdkdocno参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述data_timedate否异动时间格式：yyyyMMddHHmmss20230621000000key_conditionstring否前次最后一笔资料的Key条件ENT=99ANDKEY1='CTC-998-210600000002'total_resultsnumeric是总数25has_nextboolean是是否有下一页true：是false：否truesales_return_data—是销退信息(单头节点，支持多数组)sales_return_nostring是销退单单号CTC-998-210600000002xmdkdocnodoc_datedate否单据日期格式：yyyy-mm-dd2021-06-22xmdkdocdtsales_nostring否业务人员12133xmdk003sales_namestring否业务人员名称刘测试ooag011sales_department_nostring否业务部门BP0240xmdk004sales_department_namestring否业务部门名称开发部ooefl003sd_nostring否出货单号xmdk005customer_nostring是客户编号190910-1xmdk007customer_namestring否客户名称190910-1测试pmaal004delivery_customer_nostring否收货客户编号190910-1xmdk009delivery_customer_namestring否收货客户名称190910-1测试pmaal004shipping_return_typestring否销退方式1:销售退回2:销退依原订单出货3:销退产生新订单出货4:销货折让(纯金额折价)5:销退换货(与帐款无关)1xmdk082payment_condition_nostring否收款条件编号200xmdk010payment_condition_nastring否收款条件说明200收款用ooibl004metrade_condition_nostring否交易条件编号CFRxmdk011trade_condition_namestring否交易条件说明成本加运费oocql004tax_nostring否税别编号1251xmdk012tax_namestring否税别说明1251_testoodbl004tax_ratenumeric否税率5.00%xmdk013is_price_taxstring否单价含税否Nxmdk014currencystring否币别RMBxmdk016currency_namestring否币别说明ooail003exchange_ratenumeric否汇率4.000000xmdk017billing_customerstring否收款客户编号190910-1xmdk008billing_customer_namestring否收款客户名称190910-1测试pmaal004invoice_customer_nostring否发票客户编号190910-1xmdk202invoice_customer_namestring否发票客户名称190910-1测试pmaal004invoice_typestring否发票类型2xmdk015invoice_type_namestring否发票类型说明普通发票isacl004internal_external_saleString否内外销1:内销2:外销1xmdk042rate_calculation_typestring否汇率计算基准1:依订单日汇率2:依Invoice日汇率3:依出货日汇率4:依立帐日汇率5:依立帐日月平均汇率2xmdk043valuation_method_nostring否取价方式编号P001xmdk018valuation_method_namestring否取价方式说明销售取价xmahl003remarkstring否备注xmdk054sales_classificationstring否销售分类A02xmdk031sales_classification_descstring否销售分类说明海外交易oocql004sales_channel_nostring否销售通路编号002xmdk030sales_channel_namestring否销售通路说明分销通路002oojdl003trans_curr_not_tax_amountnumeric否未税金额7,400.00xmdk051trans_curr_tax_amountnumeric否含税金额7,770.00xmdk052trans_curr_taxnumeric否税额370.00xmdk053statusstring否状态码Sxmdkstusmodify_nostring否资料修改者12133xmdkmodidmodify_datedatetim否最近修改日期2021-06-22xmdkmoddte格式：yyyy-mm-ddhh:mm:ss11:49:13confirmorstring否确认者12133xmdkcnfidconfirm_datedatetime否确认日格式：yyyy-mm-ddhh:mm:ss2021-06-2211:49:08xmdkcnfdtResponse范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:e2f23964-4c0f-4ce5-9b85-a896eae6fa5adigi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"sales_return_no":"销退单单号"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","sales_return_data_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"sales_return_data":[{"sales_return_no":"销退单单号","doc_date":"单据日期","sales_no":"业务人员","sales_name":"业务人员名称","sales_department_no":"业务部门","sales_department_name":"业务部门名称","sd_no":"出货单号","customer_no":"客户编号","customer_name":"客户名称","delivery_customer_no":"收货客户编号","delivery_customer_name":"收货客户名称","shipping_return_type":"销退方式","payment_condition_no":"收款条件编号","payment_condition_name":"收款条件说明","trade_condition_no":"交易条件编号","trade_condition_name":"交易条件说明","tax_no":"税别编号","tax_name":"税别说明","tax_rate":"税率","is_price_tax":"单价含税否","currency":"币别","currency_name":"币别说明","exchange_rate":"汇率","billing_customer":"收款客户编号","billing_customer_name":"收款客户名称","invoice_customer_no":"发票客户编号","invoice_customer_name":"发票客户名称","invoice_type":"发票类型","invoice_type_name":"发票类型说明","internal_external_sale":"内外销","rate_calculation_type":"汇率计算基准","valuation_method_no":"取价方式编号","valuation_method_name":"取价方式说明","remark":"备注","sales_classification":"销售分类","sales_classification_desc":"销售分类说明","sales_channel_no":"销售通路编号","sales_channel_name":"销售通路说明","trans_curr_not_tax_amount":"未税金额","trans_curr_tax_amount":"含税金额","trans_curr_tax":"税额","status":"状态码","modify_no":"资料修改者","modify_date":"最近修改日期","confirmor":"确认者","confirm_date":"确认日"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)000100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果参数代号型态是否必填参数说明范例值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:c491b880-cd2b-4fe5-8f35-0ffd842f4985digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
