接口名称t100.oapi.pricing.list.data.query.get接口说明査询核价单列表资料程序代号wssp00070输入参数说明参数代号型态是否必填参数说明范例值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.pricing.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring是企业编号99CompanyIdstring否营运据点DSCNJ参数代号型态是否必填参数说明范例值ERP字段enterprise_nostring否企业别99pmdientsite_nostring否营运中心DSCNJpmdisiteis_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间格式：yyyyMMddHHmmss20160101000000key_conditionstring否前次最后一笔资料的Key条件ENT=99ANDKEY1='CNJ-DH1-160100000119'use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数使用说明：当启用分页机制时，代表每页条数。取值范围：大于零的整数，10默认值50；最大值500。当不启用分页机制时，代表分包的请求笔数，如果值为NULL或０，则不做分包机制page_nonumeric否页码2pricing_nostring否核价单号CNJ-DH1-160100000119pmdidocnoapplicant_nostring否申请人编号支持模糊查询(输入不完整编号可查)587pmdi002applicant_namestring否申请人名称支持模糊查询(输入不完整名称可查)周ooag011supplierstring否供应商支持模糊查询(输入不完整编号可查)123pmdi004supplier_namestring否供应商名称支持模糊查询(输入不完整名称可查)鼎新pmaal004date_sstring是开始日期格式：yyyyMMdd20160101pmdidocdtdate_estring是结束日期格式：yyyyMMdd20160131pmdidocdtconditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否字段名称pmdi002valuestring否字段值02587operatorstring否操作符>、>=、=、<、<=、like、in、<>=logicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点，支持多数组)field_namestring否字段名称pmdidocnoorder_typestring否排序类型asc：升序desc：降幂ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-reqid:5d03985e-a0ae-4013-87a1-72be8b0bc626digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.pricing.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":"页码","pricing_no":"核价单号","applicant_no":"申请人编号","applicant_name":"申请人名称","supplier":"供应商","supplier_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是异动时间格式：yyyyMMddHHmmss20160101000000key_conditionstring是前次最后一笔资料的Key条件ENT=99ANDKEY1='CNJ-DH1-160100000119'total_resultsnumeric否总数8has_nextboolean否是否有下一页true：是false：否falsepricing_list_master—是核价单主档(单头节点，支持多数组)pricing_nostring是核价单号CNJ-DH1-160100000119pmdidocnooutsourcing_typestring否是否委外Npmdi001doc_datedate否单据日期格式：yyyy-mm-dd2016-01-19pmdidocdtapplicant_nostring否申请人编号02587pmdi002applicant_namestring否申请人名称周于ooag011application_departmentstring否申请部门DSC0300pmdi003application_department_nameString否申请部门名称中区丰原店ooefl003supplierstring否供应商123pmdi004supplier_namestring否供应商名称鼎新计算机pmaal004currency_nostring否币别编号CNYpmdi005currency_namestring否币别说明美元ooail003tax_nostring否税别编号N01pmdi006tax_namestring否税别说明17%含税oodbl004tax_ratenumeric否税率16pmdi007is_price_taxstring否单价含税否(Y,N)Ypmdi008payment_conditionstring否付款条件101pmdi009payment_condition_namestring否付款条件说明发票月结90天ooibl004trade_conditionstring否交易条件CFRpmdi011trade_condition_namestring否交易条件说明个人会员oocql004approval_contentstring否核决内容1:核准价2:暂定价1pmdi014effective_datedate否生效日期格式：yyyy-mm-dd2016-01-19pmdi015expiration_datedate否失效日期格式：yyyy-mm-dd2016-12-31pmdi016price_valuation_target_controlstring否核价对象控制1:单一供应商适用2:同法人适用3:同集团适用1pmdi017price_valuation_controlstring否核价使用控制1:单一据点适用2:同法人适用3:同集团适用1pmdi018is_qty_valuationstring否分量计价否(Y,N)不使用remarkstring否备注备注1pmdi030modify_nostring否资料修改者07423pmdiownidmodify_datedate否最近修改日期格式：yyyy-mm-ddhh:mm:ss2016-01-1916:27:55pmdimoddtstatusstring否状态码N:未审核Y:已审核A:已核准D:抽单R:已拒绝W:送签中C:结案X:作废H:留置UH:取消留置YpmdistusResponse范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:593b6b02-96be-4bda-ab17-4c7b3490e450digi-protocol:rawdigi-srvver:1.0digi-srvcode:000{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","pricing_list_master":[{"pricing_no":"核价单号","outsourcing_type":"是否委外","doc_date":"单据日期","applicant_no":"申请人编号","applicant_name":"申请人名称","application_department":"申请部门","application_department_name":"申请部门名称","supplier":"供应商","supplier_name":"供应商名称","currency_no":"币别编号","currency_name":"币别说明","tax_no":"税别编号","tax_name":"税别说明","tax_rate":"税率","is_price_tax":"单价含税否","payment_condition":"付款条件","payment_condition_name":"付款条件说明","trade_condition":"交易条件","trade_condition_name":"交易条件说明","approval_content":"核决内容","effective_date":"生效日期","expiration_date":"失效日期","price_valuation_target_control":"核价对象控制","price_valuation_control":"核价使用控制","is_qty_valuation":"分量计价否","remark":"备注","modify_no":"资料修改者","modify_date":"最近修改日期","status":"状态码"}],"total_results":"总数","has_next":"存在下一页"}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码100000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确<>0：FAIL（原因代码）anm-03078sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述[T100_message]查询无数据！Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:593b6b02-96be-4bda-ab17-4c7b3490e450digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
