接口名称tt.oapi.sales.order.list.data.query.get接口说明查询销售订单列表资料程序代号soap_oapi00003输入参数说明参数代号型态是否必填参数说明范例值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是接收方产品名称TIPTOPnamestring是服务名称tt.oapi.sales.order.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号CompanyIdstring否营运据点sequencestring是条件顺序field_namestring否字段名称参数代号型态是否必填参数说明范例值ERP字段enterprise_nostring否企业编号不使用site_nostring否营运中心不使用is_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间格式：yyyyMMddHHmmss20230516000000oeadatekey_conditionstring否前次最后一笔资料的Key条件KEY1='100-23051601'use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数50使用说明：当启用分页机制时，代表每页条数。取值范围：大于零的整数，默认值50；最大值500。当不启用分页机制时，代表分包的请求笔数，如果值为NULL或０，则不做分包机制page_nonumeric否页码1so_nostring否订单单号100-23051601oea01customer_nostring否客户编号支持模糊查询(输入不完整编号可查)001oea03customer_namestring否客户名称支持模糊查询(输入不完整名称可查)鼎新oea032salesman_nostring否业务员编号支持模糊查询(输入不完整编号可查)Doea14salesman_namestring否业务员名称支持模糊查询(输入不完整姓名可查)陈gen02sales_department_nostring否业务部门编号S0001oea15sales_department_namestring否业务部门名称业务部gem02date_sstring否开始日期格式：yyyyMMdd20230501oea02date_estring否结束日期格式：yyyyMMdd20230531oea02conditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否字段名称oea14oea_file中的所有字段valuestring否字段值D001operatorstring否操作符>、>=、=、<、<=、like、in、<>=logicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点，支持多数组)field_namestring是字段名称oea01oea_file中的所有字段order_typestring是排序类型asc、descdescRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:ae91cda70adcf965833d3a696263e64ddigi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"TIPTOP","name":"tt.oapi.sales.order.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","sequence":"条件顺序","field_name":"字段名称"}{"std_data":{"parameter":{"enterprise_no":"企业编号","site_no":"营运据点","is_digiwin_product":"是否为鼎捷产品","data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","use_has_next":"是否启用分页机制","page_size":"每页条数/分包的请求笔数","page_no":"页码","so_no":"订单单号","customer_no":"客户编号","customer_name":"客户名称","salesman_no":"业务员编号","salesman_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参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述data_timedate是异动时间格式：yyyyMMddHHmmss20230516000000oeadatekey_conditionstring是前次最后一笔资料的Key条件KEY1='100-23051601'total_resultsnumeric否总数35has_nextboolean否是否有下一页true：是false：否falsesales_list_detail—是销货清单(单头节点，支持多数组)so_nostring是订单单号100-23051601oea01so_versionnumeric否订单版次0oea06so_datedate否订单日期格式：yyyy-mm-dd2023-05-16oea02sales_nostring否业务人员D001oea14sales_namestring否业务人员名称陈小帅gen02sales_department_nostring否业务部门S0001oea15sales_department_namestring否业务部门名称业务部gem02customer_nostring否客户编号00001oea03customer_namestring否客户名称鼎新计算机oea032so_kindstring否订单性质1.一般订单2.换货订单3.出至境外仓4.境外仓出货6.调货订单7.寄销订单1oea00payment_condition_nostring否收款条件编号212oea32payment_condition_namestring否收款条件说明212收款用oag02trade_condition_nostring否交易条件编号不使用trade_condition_namestring否交易条件说明不使用tax_nostring否税别编号S000oea21tax_namestring否税别说明销项零税率0%gec02tax_ratenumeric否税率0oea211is_price_taxstring否单价含税否Noea213currencystring否币别CNYoea23exchange_ratenumeric否汇率4.42212oea24delivery_addressstring否出货地址A0001oea044delivery_address_descstring否出货地址说明台中市台湾大道100号之1ocd221+ocd222+ocd223+ocd230+ocd231以上5个地址字段字符串串在一起billing_addressstring否账款地址不使用billing_address_descstring否账款地址说明不使用total_trans_curr_not_tax_amountnumeric否订单总未税金额400oea61total_trans_curr_tax_amountnumeric否订单总含税金额400oea1008total_trans_curr_taxnumeric否订单总税额0oea1008-oea61remarkstring否备注不使用statusstring否状态码N:未审核Y:已审核X:已作废YoeaconfResponse范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:99b69415-2a1a-44f7-b872-f8c89510b4a8digi-protocol:rawdigi-srvver:1.0digi-srvcode:000{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"是否有下一页","sales_list_detail_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"sales_list_detail":[{"so_no":"订单单号","so_version":"订单版次","so_date":"订单日期","sales_no":"业务人员","sales_name":"业务人员名称","sales_department_no":"业务部门","sales_department_name":"业务部门名称","customer_no":"客户编号","customer_name":"客户名称","so_kind":"订单性质","payment_condition_no":"收款条件编号","payment_condition_name":"收款条件说明","trade_condition_no":"交易条件编号","trade_condition_name":"交易条件说明","tax_no":"税别编号","tax_name":"税别说明","tax_rate":"税率","is_price_tax":"单价含税否","currency":"币别","exchange_rate":"汇率","delivery_address":"出货地址","delivery_address_desc":"出货地址说明","billing_address":"账款地址","billing_address_desc":"账款地址说明","total_trans_curr_not_tax_amount":"订单总未税金额","total_trans_curr_tax_amount":"订单总含税金额","total_trans_curr_tax":"订单总税额","remark":"备注","status":"状态码"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果100参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确<>0：FAIL（原因代码）aws-132sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述没有传入资料Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:99b69415-2a1a-44f7-b872-f8c89510b4a8digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
