接口名称t100.oapi.sales.order.change.list.data.query.get接口说明查询订单变更单列表资料程序代号wssp00190输入参数说明参数代号型态是否必填参数说明范例值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.order.change.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号99CompanyIdstring否营运据点DSCTCso_nostring是订单单号CNJ-DBC-141000000001sequencestring否条件顺序1field_namestring否字段名称xmeecrtdt参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring否企业编号99xmeeentsite_nostring否营运据点DSCTCxmeesiteis_digiwin_productstring是是否为鼎捷产品(Y,N)Ndata_timedate否异动时间格式：yyyyMMddHHmmss20230621000000xmeemoddt/xmeecrtdtkey_conditionstring否前次最后一笔资料的Key条件(首次呼叫可空值)xmee001='CTC-XM2-200400000087'use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数使用说明：当启用分页机制时，代表每页条数。取值范围：大于零的整数，默认值50；最大值500。当不启用分页机制时，代表分包的请求笔数，如果值为NULL或０，则不做分包机制50page_nonumeric否页码1so_nostring否订单单号CNJ-DBC-141000000001xmeedocnocustomer_nostring否客户编号(支持模糊查询，输入不完整编号可查)M20140902xmee004customer_namestring否客户名称(支持模糊查询，输入不完整姓名可查)鼎鼎公司pmaal004sales_nostring否业务人员(支持模糊查询，输入不完整编号可查)00939xmee002sales_namestring否业务人员名称(支持模糊查询，输入不完整姓名可查)林大同ooag011department_nostring否部门编号DC0360xmee003department_namestring否部门名称南京品保ooefl003date_sstring否开始日期格式：yyyyMMdd20200101xmeemoddt/xmeecrtdtdate_estring否结束日期格式：yyyyMMdd20210101xmeemoddt/xmeecrtdtconditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否字段名称xmeecrtdtvaluestring否字段值20230401operatorstring否操作符>、>=、=、<、<=、like、in、<>>logicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点，支持多数组)field_namestring是字段名称xmee001order_typestring是排序类型asc：升序desc：降序ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:356cfba237d33d5a53d8857b5f944ac5digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.sales.order.change.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","so_no":"订单单号","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":"客户名称","sales_no":"业务人员","sales_name":"业务人员名称","department_no":"部门编号","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:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000datakeyso_nostring是订单单号CNJ-DBC-141000000001xmeedocnochange_seqnumeric是变更序1xmee900参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述data_timedate是异动时间格式：yyyyMMddHHmmss20230621000000xmeemoddt/xmeecrtdtkey_conditionstring是前次最后一笔资料的Key条件xmee001='CTC-XM2-200400000087'total_resultsnumeric否总数100has_nextboolean否是否有下一页true：是false：否trueso_change_master_attr—是订单变更信息属性(单头节点)cntnumeric否当前回传资料笔数50tt_cntnumeric否应回传的资料总笔数100so_change_master—是订单变更信息(单头节点，支持多数组)so_nostring是订单单号CNJ-DBC-141000000001xmeedocnochange_seqnumeric是变更序1xmee900change_datedate是变更日期格式：yyyy-mm-dd2016-04-06xmee902sales_nostring否业务人员00939xmee002sales_namestring否业务人员名称林大同ooag011department_nostring否部门编号DC0360xmee003department_namestring否部门名称南京品保ooefl003customer_nostring否客户编号M20140902xmee004customer_namestring否客户名称鼎鼎公司pmaal004source_typestring是资料来源1.人工录入1xmee0072.预先订单3.报价单5:销退换货,6:多角抛转7:协作转入9:EC10.订货会单,11.CRM报价单入,12.CRM样品单转入,13.分销订单转入,14.接单作业转入,15.督审缺货订单,16.零售转分销订单source_nostring否来源单号xmee008payment_condition_nostring否收款条件编号200xmee009payment_condition_namestring否收款条件说明现金ooibl004trade_conditionstring否交易条件CFRxmee010trade_condition_namestring否交易条件说明成本加运费oocql004tax_nostring否税别编号P06xmee011tax_namestring否税别说明oodbl004tax_ratenumeric否税率17xmee012is_price_taxstring否单价含税否(Y,N)Yxmee013currencystring否币别CNYxmee015currency_namestring否币别说明人民币ooail003exchange_ratenumeric否汇率1xmee016customer_contractor_nostring否客户连络人编号00000000000000001366xmee027contact_namestring否联络人名称pmaj012customer_so_nostring否客户订购单号xmee033remarkstring否备注测试xmee071so_kindstring否订单性质1.一般订单2.换货订单3.签收订单4.调拨订单5.预先订单6.调货订单7.寄销正式出货\销退1xmee0058.借货订单change_reasonstring否变更理由Q01xmee903change_reason_namestring否变更理由说明交货日期变更oocql004change_remarkstring否变更备注测试xmee904internal_external_salesString否内外销1:内销2:外销1xmee048rate_calculation_typestring否汇率计算基准1.依订单日汇率2.依Invoice日汇率3.依出货日汇率4.依立帐日汇率5.依立帐日月平均汇率1xmee049invoice_typestring否发票类型A1xmee035invoice_type_namestring否发票类型说明销项三联式手开发票isacl004valuation_method_nostring否取价方式编号001xmee017valuation_method_namestring否取价方式说明一般销售取价pmaml003last_customer_nostring否最终客户编号00000002xmee034last_customer_namestring否最终客户名称精密模具有限公司pmaal004transport_mode_namestring否运输方式Wxmee020transport_mode_name_descstring否运输方式说明海运oocql004delivery_addressstring否收货地址xmee025delivery_address_descstring否收货地址说明billing_addressstring否帐款地址xmee026billing_address_descstring否帐款地址说明sales_type_nostring否销售分类xmee024sales_type_descstring否销售分类说明oocql004sales_channel_nostring否销售通路编号xmee023sales_channel_namestring否销售通路说明oojdl003retain_cause_nostring否留置原因代码xmee032retain_cause_namestring否留置原因说明oocql004total_trans_curr_not_tax_amountnumeric否订单总未税金额1000xmee041total_trans_curr_tax_amountnumeric否订单总含税金额1700xmee042total_trans_curr_taxnumeric否订单总税额1700xmee043statusstring否状态码N.未审核Y.已审核A.已核准D.抽单R.已拒绝W.送签中X.作废Yxmeestuscreate_employee_nostring否建档人员编号07024xmeeownidmodify_nostring否资料修改者07024xmeemodidmodify_datedate否资料修改日格式：yyyy-mm-ddhh:mm:ss2016-04-0608:36:57xmeemoddtconfirmorstring否确认者07024xmeecnfidconfirm_datestring否确认日格式：yyyy-mm-ddhh:mm:ss2016-04-0608:39:57xmeecnfdtdisposable_customer_namestring否一次性客户姓名pmak003contact_addressstring否联络地址pmak005disposable_customer_mobilestring否一次性客户手机号pmak007closed_stusstring否订单结案否(Y,N)NxmeeactiResponse范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:c9a5bf5d-3be1-4c82-b334-b061e1bee952digi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"so_no":"订单单号","change_seq":"变更序"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"是否有下一页","so_change_master_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"so_change_master":[{"so_no":"订单单号","change_seq":"变更序","change_date":"变更日期","sales_no":"业务人员","sales_name":"业务人员名称","department_no":"部门编号","department_name":"部门名称","customer_no":"客户编号","customer_name":"客户名称","source_type":"资料来源","source_no":"来源单号","payment_condition_no":"收款条件编号","payment_condition_name":"收款条件说明","trade_condition":"交易条件","trade_condition_name":"交易条件说明","tax_no":"税别编号","tax_name":"税别说明","tax_rate":"税率","is_price_tax":"单价含税否","currency":"币别","currency_name":"币别说明","exchange_rate":"汇率","customer_contractor_no":"客户连络人编号","contact_name":"联络人名称","customer_so_no":"客户订购单号","remark":"备注","so_kind":"订单性质","change_reason":"变更理由","change_reason_name":"变更理由说明","change_remark":"变更备注","internal_external_sales":"内外销","rate_calculation_type":"汇率计算基准","invoice_type":"发票类型","invoice_type_name":"发票类型说明","valuation_method_no":"取价方式编号","valuation_method_name":"取价方式说明","last_customer_no":"最终客户编号","last_customer_name":"最终客户名称","transport_mode_name":"运输方式","transport_mode_name_desc":"运输方式说明","delivery_address":"收货地址","delivery_address_desc":"收货地址说明","billing_address":"帐款地址","billing_address_desc":"帐款地址说明","sales_type_no":"销售分类","sales_type_desc":"销售分类说明","sales_channel_no":"销售通路编号","sales_channel_name":"销售通路说明","retain_cause_no":"留置原因代码","retain_cause_name":"留置原因说明","total_trans_curr_not_tax_amount":"订单总未税金额","total_trans_curr_tax_amount":"订单总含税金额","total_trans_curr_tax":"订单总税额","status":"状态码","create_employee_no":"建档人员编号","modify_no":"资料修改者","modify_date":"资料修改日","confirmor":"确认者","confirm_date":"确认日","disposable_customer_name":"一次性客户姓名","contact_address":"联络地址","disposable_customer_mobile":"一次性客户手机号","closed_stus":"订单结案否"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果100参数代号型态是否必填参数说明范例值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:c9a5bf5d-3be1-4c82-b334-b061e1bee952digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
