接口名称t100.oapi.wo.change.list.data.query.get接口说明查询工单变更单列表资料程序代号wssp00238输入参数说明参数代号型态是否必填参数说明范例值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.wo.change.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号99CompanyIdstring否营运据点DSCTCwo_change_nostring否工单变更单单号CTC-FB2-230600000001sequencestring否条件顺序1field_namestring否字段名称sfkadocno参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring否企业编号99sfkaentsite_nostring否营运据点DSCTCsfkasiteis_digiwin_productstring是是否为鼎捷产品(Y,N)Ndata_timedate否异动时间格式：yyyyMMddHHmmss20221001080300000sfkamoddt/sfkacrtdtkey_conditionstring否前次最后一笔资料的Key条件(首次呼叫可空值)sfkadocno='CTC-FB2-230600000001'use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数使用说明：当启用分页机制时，代表每页条数。取值范围：大于零的整数，默认值50；最大值500。当不启用分页机制时，代表分包的请求笔数，如果值为NULL或０，则不做分包机制50page_nonumeric否页码1wo_change_nostring是工单变更单单号(支持模糊查询，输入不完整编号可查)CTC-FB2-230600000001sfkadocnowo_typestring否工单类型2.一般工单2.重工工单3.拆件式工单4.研发工单5.模具工单1sfka003production_control_nostring否生管员编号00272sfka002production_item_nostring否生产料号(支持模糊查询，输入不完整编号可查)00272-201007-KT1sfka010wo_sourcestring否工单来源单号Test001sfka006plan_date_sdate否预计开工日格式：yyyyMMdd20230620sfka019get_latestboolean否取最新Y.取变更序最大值的资料N.不另外过滤变更序，只排除已作废资料Ydate_sstring否开始日期格式：yyyyMMdd20200101sfkamoddt/sfkacrtdtdate_estring否结束日期格式：yyyyMMdd20210101sfkamoddt/sfkacrtdtconditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否字段名称sfkadocnovaluestring否字段值CTC-FB2-230600000001operatorstring否操作符>、>=、=、<、<=、like、in、<>inlogicalstring否搜寻组间的关系ANDAND、ORorders—否排序设置(单头节点，支持多数组)field_namestring是字段名称sfka001order_typestring是排序类型asc：升序desc：降序ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:cc20f86f6e33320195a31e74d55bcafcdigi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.wo.change.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","wo_change_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_change_no":"工单变更单单号","wo_type":"工单类型","production_control_no":"生管员编号","production_item_no":"生产料号","wo_source":"工单来源单号","plan_date_s":"预计开工日","get_latest":"取最新","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是异动时间格式：yyyyMMddHHmmss20230621000000sfkamoddt/sfkacrtdtkey_conditionstring是前次最后一笔资料的Key条件sfkadocno='CTC-XM2-200400000087'total_resultsnumeric否总数100has_nextboolean否是否有下一页true：是false：否truewo_info_attr—是工单信息属性(单头节点)cntnumeric否当前回传资料笔数50tt_cntnumeric否应回传的资料总笔数100wo_info—是工单信息(单头节点，支持多数组)wo_change_nostring是工单变更单单号CTC-FB2-230600000001sfkadocnochange_seqnumeric否变更序1sfka900change_datedate否变更日期格式：yyyy-mm-dd2023-06-20sfka902production_control_nostring否生管员编号00272sfka002production_control_string否生管人员名称林小君ooag011namewo_typestring否工单类型2.一般工单2.重工工单3.拆件式工单4.研发工单5.模具工单1sfka003outsourcing_typestring否委外类型1.厂内2.委外1sfka057issue_rulestring否发料制度1.事先发料制2.倒扣料1sfka004production_item_nostring否生产料号00272-201007-KT1sfka010production_item_namestring否生产料号品名棉T-2010Kitty-产品特征测试201007imaal003production_item_specstring否生产料号规格imaal004production_item_featurestring否生产料号特性210420Asfka011after_change_production_qtynumeric否变更后生产数量10sfka012before_change_production_qtynumeric否变更前生产数量10sfaa012production_unit_nostring否生产单位PCSsfka013production_unit_namestring否生产单位名称件oocal003process_nostring否制程编号sfka016process_namestring否制程说明ecba003wo_source_typestring否工单来源类型0.人工输入2.订单6.独立需求单7.MPS计划0sfka005wo_sourcestring否工单来源单号sfka006wo_source_seqnumeric否工单来源项次sfka007wo_source_term_seqnumeric否工单来源项序sfka008after_change_plan_date_sdate否变更后预计开工日格式：yyyy-mm-dd2023-06-20sfka019before_change_plan_date_sdate否变更前预计开工日格式：yyyy-mm-dd2023-06-20sfaa019after_change_plan_end_datedate否变更后预计完工日格式：yyyy-mm-dd2023-06-20sfka020before_change_plan_end_datedate否变更前预计完工日格式：yyyy-mm-dd2023-06-20sfaa020statusstring否状态码A.已核准D.抽单N.未审核Y.已审核R.已拒绝W.送签中X.作废Nsfkastusafter_change_department_supplier_nostring否变更后部门供应商0005sfka017after_change_department_supplier_namestring否变更后部门供应商名称通用部门ooefl003before_change_department_supplier_nostring否变更前部门供应商0007sfaa017before_change_department_supplier_namestring否变更前部门供应商名称研发部ooefl003cost_center_nostring否成本中心BP0270sfka068cost_center_namestring否成本中心名称质量保证部ooefl003bom_versionstring否BOM版本sfka014pbi_nostring否料表批号(PBI)sfka026urgency_ratestring否紧急比率(%)90sfka032priority_seqstring否优先级1sfka033project_nostring否项目编号20190426sfka028project_namestring否项目说明项目一pjbal003workstation_idstring否产线sfka076shift_nostring否班别sfka077plan_stock_in_warehouse_nostring否预计入库库位19097Asfka034plan_stock_in_warehouse_namestring否预计入库库位名称成品库inayl003plan_stock_in_location_nostring否预计入库储位A01sfka035plan_stock_in_location_namestring否预计入库储位名称19097储位inab003plan_stock_in_lot_nostring否预计入库批号sfka059plan_stock_in_inventstring否预计入库库存管理特征sfka073ory_management_featuresdoc_head_change_reasonstring否单头变更理由001sfka905doc_head_change_remarkstring否单头变更备注测试sfka906create_employee_nostring否资料修改者00272sfkamodidmodify_nodate否资料修改日格式：yyyy-mm-ddhh:mm:ss2023-06-2108:16:40sfkamoddtprepare_material_detail—是备料明细(单身节点，支持多数组)seq_nonumeric是项次10sfkgseqpart_nostring否部位sfkg002after_change_op_nostring否变更后作业编号001sfkg003before_change_op_nostring否变更前作业编号002sfba003op_seqstring否作业序1sfkg004bom_item_nostring否BOM料号00272-181118-C1sfkg005after_change_issue_item_nostring否变更后发料料号00272-181118-C2sfkg006issue_item_namestring否发料料号品名imaal003issue_item_specstring否发料料号规格imaal004before_change_issue_item_nostring否变更前发料料号00272-181118-C1sfba006product_feature_nostring否产品特征sfkg021mandatory_featurestring否必要特性1.主要材料2.次要材料3.间接材料4.参考材料1sfkg008recoil_materialstring否倒扣料(Y,N)Nsfkg009allow_error_ratenumeric否允许误差率(%)10sfkg012after_change_adjust_issuance_qtynumeric否变更后调整应发数量20sfkg024before_change_adjust_issuance_qtynumeric否变更前调整应发数量5sfba024unit_nostring否单位PCSsfkg014after_change_outsourcing_purchasing_qtynumeric否变更后委外代买数量0sfkg015before_change_outsnumeric否变更前委外代买数量0sfba015ourcing_purchasing_qtyissue_qtynumeric否已发数量0sfkg016over_picking_qtynumeric否超领数量0sfkg025scrap_qtynumeric否报废数量0sfkg017designation_warehouse_nostring否指定发料库位00272-5sfkg019designation_warehouse_namestring否指定发料库位名称inayl003designation_storage_spaces_nostring否指定发料储位sfkg020designation_storage_spaces_namestring否指定发料储位名称inab003designation_lot_nostring否指定发料批号sfkg029designation_inventory_management_featuresstring否指定发料库存管理特征sfkg030body_change_reasonstring否单身变更理由002sfkg904body_change_remarkstring否单身变更备注测试sfkg905remarkstring否备注ooff013production_item_no_list—是生产料号清单(单身节点，支持多数组)production_typestring否类型1.一般2.联产品3.多产出主件4.拆件式入库5.副产品/回收料1sfkc002item_nostring否料件编号00272-201007-KT1sfkc001product_featurestring否产品特征00XLsfkc006plan_output_qtynumeric否预计产出量10sfkc003actual_output_qtynumeric否实际产出量0sfkc005change_reasonstring否变更理由001sfkc904change_remarkstring否变更备注testbymandysfkc905Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:f58528af-0393-477f-81ce-8199fdcff2d8digi-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_change_no":"工单变更单单号","change_seq":"变更序","change_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":"生产料号特性","after_change_production_qty":"变更后生产数量","before_change_production_qty":"变更前生产数量","production_unit_no":"生产单位","production_unit_name":"生产单位名称","process_no":"制程编号","process_name":"制程说明","wo_source_type":"工单来源类型","wo_source":"工单来源单号","wo_source_seq":"工单来源项次","wo_source_term_seq":"工单来源项序","after_change_plan_date_s":"变更后预计开工日","before_change_plan_date_s":"变更前预计开工日","after_change_plan_end_date":"变更后预计完工日","before_change_plan_end_date":"变更前预计完工日","status":"状态码","after_change_department_supplier_no":"变更后部门供应商","after_change_department_supplier_name":"变更后部门供应商名称","before_change_department_supplier_no":"变更前部门供应商","before_change_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":"预计入库库存管理特征","doc_head_change_reason":"单头变更理由","doc_head_change_remark":"单头变更备注","create_employee_no":"资料修改者","modify_no":"资料修改日","prepare_material_detail":[{"seq_no":"项次","part_no":"部位","after_change_op_no":"变更后作业编号","before_change_op_no":"变更前作业编号","op_seq":"作业序","bom_item_no":"BOM料号","after_change_issue_item_no":"变更后发料料号","issue_item_name":"发料料号品名","issue_item_spec":"发料料号规格","before_change_issue_item_no":"变更前发料料号","product_feature_no":"产品特征","mandatory_feature":"必要特性","recoil_material":"倒扣料","allow_error_rate":"允许误差率","after_change_adjust_issuance_qty":"变更后调整应发数量","before_change_adjust_issuance_qty":"变更前调整应发数量","unit_no":"单位","after_change_outsourcing_purchasing_qty":"变更后委外代买数量","before_change_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":"指定发料库存管理特征","body_change_reason":"单身变更理由","body_change_remark":"单身变更备注","remark":"备注"}],"production_item_no_list":[{"production_type":"类型","item_no":"料件编号","product_feature":"产品特征","plan_output_qty":"预计产出量","actual_output_qty":"实际产出量","change_reason":"变更理由","change_remark":"变更备注"}]}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值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:f58528af-0393-477f-81ce-8199fdcff2d8digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
