接口名称tt.oapi.purchase.order.list.data.query.get接口说明查询采购单列表资料程序代号soap_oapi00157输入参数说明参数代号型态是否必填参数说明范例值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是接收方产品名称ttnamestring是服务名称tt.oapi.purchase.order.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号CompanyIdstring否营运据点DS1参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring否企业编号若无传值则预设值g_enterprisesite_nostring否营运中心DS1is_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间key_conditionstring否前次最后一笔资料的Key条件use_has_nextboolean是是否启用分页机制1.是2.否1page_sizenumeric否每页条数/分包的请求笔数10page_nonumeric否页码1purchase_nostring否采购单号pmm01purchaser_nostring否采购人员编号pmm12purchaser_namestring否采购人员名称gen02department_nostring否采购部门pmm13department_namestring否部门名称gem02date_sstring是开始日期20230301date_estring是结束日期20230331conditions—否条件集合(单头节点，支持多数组)sequencestring否条件顺序1bracketstring否括号类型(field_namestring否栏位名称pmdldocdtvaluestring否栏位值20230401operatorstring否操作符>logicalstring否搜寻组间的关系ANDorders—否排序设置(单头节点，支持多数组)field_namestring否栏位名称pmdldocnoorder_typestring否排序类型ASCRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:e80af4609894c73d30bb53d1e5663989digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"tt","name":"tt.oapi.purchase.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":"页码","purchase_no":"采购单号","purchaser_no":"采购人员编号","purchaser_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:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000datakeyerp_nostring否ERP编号source_nostring否来源单号(编号)参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述data_timedate是异动时间key_conditionstring是前次最后一笔资料的Key条件total_resultsnumeric否总笔数has_nextboolean否是否存在下一页purchase_data—否采购单(单头节点，支持多数组)source_nostring否来源单号pmm56purchase_nostring是采购单号pmm01purchase_versionstring否采购版本pmm03purchase_datedate否采购日期pmm04purchaser_nostring否采购人员编号pmm09purchaser_namestring否采购人员名称gen02department_nostring否采购部门pmm13department_namestring否部门名称gem02supplier_nostring否供应商编号supplier_namestring否供应商名称purchase_propertystring否采购性质payment_conditionstring否付款条件payment_condition_namestring否付款条件说明trade_condition_nostring否交易条件trade_condition_namestring否交易条件说明tax_nostring否税别pmm21tax_ratenumeric否税率pmm43is_price_taxstring否单价含税否currencystring否币别pmm22exchange_ratenumeric否汇率pmm42remarkstring否备注internal_external_purchaseString否内外购rate_calculation_typestring否汇率计算基准invoice_typestring否发票类型invoice_type_namestring否发票类型说明valuation_method_nostring否取价方式编号valuation_method_namestring否取价方式说明last_customer_nostring否最终客户编号last_customer_namestring否最终客户名称transport_mode_nostring否运输方式pmm16transport_mode_namestring否运输方式说明delivery_addressstring否送货地址pmm10delivery_address_descstring否送货地址说明pme031billing_addressstring否账单地址pmm11billing_address_descstring否账单地址说明total_trans_curr_not_tax_amountnumeric否采购总未税金额pmm40total_trans_curr_tax_amountnumeric否采购总含税金额pmm40ttotal_trans_curr_taxnumeric否采购总税额modify_nostring否资料修改者pmmmodumodify_datestring否资料异动日pmmdateconfirmorstring否确认者pmm15confirm_datestring否确认日statusstring否单据状态pmm18Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:a862087c-1bf5-4cb9-9a3e-c00206cfe520digi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"purchase_no":"采购单号"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"是否有下一页","purchase_data_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"purchase_data":[{"source_no":"来源单号","purchase_no":"采购单号","purchase_version":"采购版本","purchase_date":"采购日期","purchaser_no":"采购人员编号","purchaser_name":"采购人员名称","department_no":"采购部门","department_name":"部门名称","supplier_no":"供应商编号","supplier_name":"供应商名称","purchase_property":"采购性质","payment_condition":"付款条件","payment_condition_name":"付款条件说明","trade_condition_no":"交易条件","trade_condition_name":"交易条件说明","tax_no":"税别","tax_rate":"税率","is_price_tax":"单价含税否","currency":"币别","exchange_rate":"汇率","remark":"备注","internal_external_purchase":"内外购","rate_calculation_type":"汇率计算基准","invoice_type":"发票类型","invoice_type_name":"发票类型说明","valuation_method_no":"取价方式编号","valuation_method_name":"取价方式说明","last_customer_no":"最终客户编号","last_customer_name":"最终客户名称","transport_mode_no":"运输方式","transport_mode_name":"运输方式说明","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":"采购总税额","modify_no":"资料修改者","modify_date":"资料异动日","confirmor":"确认者","confirm_date":"确认日","status":"状态码"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000datakeyerp_nostring否ERP编号source_nostring否来源单号(编号)参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）aws-00102sql_codestring否失败时数据库回传代码descriptionstring是错误问题描述[tt_message]处理笔数1,成功0,失败1Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:70e8978e-f4de-48b1-a679-e9ccb4294f95digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
