接口名称tt.oapi.wo.list.data.query.get接口说明查询工单资料程序代号soap_oapi00175输入参数说明参数代号型态是否必填参数说明范例值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.wo.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topproddatakeyEntIdstring否企业编号CompanyIdstring否营运据点DS1wo_nostring否工单单号003-151200000参数代号型态是否必填参数说明范例值ERP字段enterprise_nostring否企业别不使用site_nostring是营运中心不使用is_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间格式：yyyyMMddHHmmss20230621000000sfbdatekey_conditionstring否前次最后一笔资料的Key条件KEY1=003-161200000002use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数50page_nonumeric否页码1wo_nostring否工单单号003-151200000001sfb01wo_typestring否工单类型1sfb02production_control_nostring否生管员编号20126sfb44production_item_nostring否生产料号A01396000sfb05wo_sourcestring否工单来源单号SO3-140600000001sfb22/sfb91plan_date_sdate否预计开工日格式：yyyyMMdd20120606sfb13date_sstring否开始日期格式：yyyyMMdd20230601sfbdatedate_estring否结束日期格式：yyyyMMdd20230630sfbdateconditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否字段名称sfb03valuestring否字段值1operatorstring否操作符>、>=、=、<、<=、like、in、<>=logicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点，支持多数组)field_namestring否字段名称sfbdateorder_typestring否排序类型asc：升序desc：降幂ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:8a0f4c630b84b744851ec9c910abd4b0digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"tt","name":"tt.oapi.wo.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","wo_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":"页码","wo_no":"工单单号","wo_type":"工单类型","production_control_no":"生管员编号","production_item_no":"生产料号","wo_source":"工单来源单号","plan_date_s":"预计开工日","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<>0：FAIL（原因代码）sql_codestring否失败时数据库回传代码0descriptionstring否错误问题描述data_timedate是异动时间格式：yyyyMMddHHmmss20230621000000key_conditionstring是前次最后一笔资料的Key条件KEY1=003-161200000002total_resultsnumeric否总数75has_nextboolean否存在下一页true.是false.否truewo_info—是工单信息(单头节点，支持多数组)wo_nostring是工单单号003-151200000001sfb01doc_datedate否单据日期格式：yyyy-mm-dd2012-06-06sfb81production_control_nostring否生管员编号20126sfb44production_control_namestring否生管人员名称周测试gen02wo_typestring否工单类型1:一般工单5:再加工工单7:委外工单8:重工委外工单11:拆件式工单13:预测工单15:试产工单1sfb02outsourcing_typestring否委外类型1:委外工单对委外采购单型态为一对一2:委外工单对委外采购单型态为一对多2sfb100issue_rulestring否发料制度1:捡料及发料系统2:领料及事后扣帐系统1sfb39production_item_nostring否生产料号0000sfb05production_item_namestring否生产料号品名男装ima02production_item_specstring否生产料号规格2014新款ima021production_item_featurestring否生产料号特性不使用production_qtynumeric否生产数量12sfb08production_unit_nostring否生产单位SETima55production_unit_namestring否生产单位名称套gfe02process_nostring否制程编号1sfb06process_namestring否制程说明标准制程ecu03wo_source_typestring否工单来源类型不使用wo_sourcestring否工单来源单号SO3-140600000001sfb22/sfb91wo_source_seqnumeric否工单来源项次1sfb221/sfb92wo_source_term_seqnumeric否工单来源项序不使用plan_date_sdate否预计开工日格式：yyyy-mm-dd2012-06-06sfb13statusstring否状态码1:开立2:发放3:料表已打印4:发料5:WIP6:F.Q.C7:入库2sfb048:结案department_supplier_nostring否部门供应商BP0000sfb82department_supplier_namestring否部门供应商名称台中国泰pmc03cost_center_nostring否成本中心DC0340sfb98cost_center_namestring否成本中心名称台中开发部gem02bom_versionstring否BOM版本1.1sfb07pbi_nostring否料表批号(PBI)303-150100000005sfb85urgency_ratestring否紧急比率100sfb34priority_seqstring否优先级1sfb40project_nostring否项目编号B003sfb27project_namestring否项目说明测试电力组pja02workstation_idstring否产线DAY10SHIFTsfb102shift_nostring否班别不使用plan_stock_in_warehouse_nostring否预计入库库位P1000sfb30plan_stock_in_warehouse_namestring否预计入库库位名称1号仓库imd02plan_stock_in_location_nostring否预计入库储位001sfb31plan_stock_in_location_namestring否预计入库储位名称储位1ime03plan_stock_in_lot_nostring否预计入库批号不使用plan_stock_in_inventory_management_featuresstring否预计入库库存管理特征不使用create_employee_nostring否资料修改者20126sfbmodumodify_datedate否资料修改日格式：yyyy-mm-dd2012-06-06sfbdateprepare_material_detail—是备料明细档(单身节点，支持多数组)seq_nonumeric是项次不使用part_nostring否部位不使用op_nostring否作业编号1010sfa08op_seqstring否作业序不使用bom_item_nostring否BOM料号A016801401001sfa27issue_item_nostring否发料料号A016801401001sfa03issue_item_namestring否发料料号品名电影供应器原材料1ima02issue_item_specstring否发料料号规格150vima021product_feature_nostring否产品特征不使用mandatory_featurestring否必要特性N:一般料件Nsfa11E:消耗性料件V:大宗采购料件U:大宗自制料件R:在制料件X:信息参考S:回收料C:客供料recoil_materialstring否倒扣料不使用allow_error_ratenumeric否允许误差率0sfa100adjust_issuance_qtynumeric否调整应发数量10sfa05unit_nostring否单位PCSsfa12outsourcing_purchasing_qtynumeric否委外代买数量0sfa065issue_qtynumeric否已发数量10sfa06over_picking_qtynumeric否超领数量10sfa062scrap_qtynumeric否报废数量10sfa063designation_warehouse_nostring否指定发料库位P1000sfa30designation_warehouse_namestring否指定发料库位名称1号仓库imd02designation_storage_spaces_nostring否指定发料储位001sfa31designation_storage_spaces_namestring否指定发料储位名称储位1ime03designation_lot_nostring否指定发料批号不使用designation_inventory_management_featuresstring否指定发料库存管理特征不使用remarkstring否备注123sfb96production_item_no_list—是生产料号清单档(单身节点，支持多数组)production_typestring否类型不使用item_nostring否料件编号不使用product_featurestring否产品特征不使用plan_output_qtynumeric否预计产出量不使用actual_output_qtynumeric否实际产出量不使用Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:6728d1e2-83c7-4fa6-9939-09e4e22d5677digi-protocol:rawdigi-srvver:1.0digi-srvcode:000{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","wo_info_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"wo_info":[{"wo_no":"工单单号","doc_date":"单据日期","production_control_no":"生管员编号","production_control_name":"生管人员名称","wo_type":"工单类型","outsourcing_type":"委外类型","issue_rule":"发料制度","production_item_no":"生产料号","production_item_name":"生产料号品名","production_item_spec":"生产料号规格","production_item_feature":"生产料号特性","production_qty":"生产数量","production_unit_no":"生产单位","production_unit_name":"生产单位名称","process_no":"制程编号","process_name":"制程说明","wo_source_type":"工单来源类型","wo_source":"工单来源单号","wo_source_seq":"工单来源项次","wo_source_term_seq":"工单来源项序","plan_date_s":"预计开工日","status":"状态码","department_supplier_no":"部门供应商","department_supplier_name":"部门供应商名称","cost_center_no":"成本中心","cost_center_name":"成本中心名称","bom_version":"BOM版本","pbi_no":"料表批号(PBI)","urgency_rate":"紧急比率","priority_seq":"优先级","project_no":"项目编号","project_name":"项目说明","workstation_id":"产线","shift_no":"班别","plan_stock_in_warehouse_no":"预计入库库位","plan_stock_in_warehouse_name":"预计入库库位名称","plan_stock_in_location_no":"预计入库储位","plan_stock_in_location_name":"预计入库储位名称","plan_stock_in_lot_no":"预计入库批号","plan_stock_in_inventory_management_features":"预计入库库存管理特征","create_employee_no":"资料修改者","modify_date":"资料修改日","prepare_material_detail":[{"seq_no":"项次","part_no":"部位","op_no":"作业编号","op_seq":"作业序","bom_item_no":"BOM料号","issue_item_no":"发料料号","issue_item_name":"发料料号品名","issue_item_spec":"发料料号规格","product_feature_no":"产品特征","mandatory_feature":"必要特性","recoil_material":"倒扣料","allow_error_rate":"允许误差率","adjust_issuance_qty":"调整应发数量","unit_no":"单位","outsourcing_purchasing_qty":"委外代买数量","issue_qty":"已发数量","over_picking_qty":"超领数量","scrap_qty":"报废数量","designation_warehouse_no":"指定发料库位","designation_warehouse_name":"指定发料库位名称","designation_storage_spaces_no":"指定发料储位","designation_storage_spaces_name":"指定发料储位名称","designation_lot_no":"指定发料批号","designation_inventory_management_features":"指定发料库存管理特征","remark":"备注"}],"production_item_no_list":[{"production_type":"类型","item_no":"料件编号","product_feature":"产品特征","plan_output_qty":"预计产出量","actual_output_qty":"实际产出量"}]}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果100参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确<>0：FAIL（原因代码）aws1409sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述传入参数is_digiwin_product不可为空！Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:6728d1e2-83c7-4fa6-9939-09e4e22d5677digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
