界面名称tt.oapi.wo.change.list.data.query.get界面说明查询工单变更单资料程序代号soap_oapi00238输入参数说明参数代号型态是否必填参数说明范例值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.wo.change.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号CompanyIdstring否营运据点DS1so_nostring是订单单号FB2-230600000001sequencestring是条件顺序1field_namestring否字段名称参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring否企业编号若无传值则预设值g_enterprisesite_nostring否营运中心DS1is_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间key_conditionstring否前次最后一笔资料的Key条件use_has_nextboolean是是否启用分页机制1.是2.否1page_sizenumeric否每页条数/分包的请求笔数2page_nonumeric否页码1wo_change_nostring是工单变更单单号FB2-230600000001snb01wo_typeString否工单类型2.一般工单,2.重工工单,3.拆件式工单,4.研发工单,5.模具工单1sfb02production_control_noString否生管员编号production_item_noString否生产料号00272-201007-KT1sfb05wo_sourceString否工单来源单号sfb22/sfb91plan_date_sdate否预计开工日格式：yyyyMMdd若无传值则预设值g_todayget_latestboolean否取最新Ydate_sstring否开始日期date_estring否结束日期conditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))field_namestring否字段名称valuestring否字段值operatorstring否操作符>、>=、=、<、<=、like、in、<>logicalstring否搜寻组间的关系AND、ORorders—否排序设置(单头节点，支持多数组)field_namestring是字段名称order_typestring是排序类型asc、descRequest范例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":"tt","name":"tt.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是异动时间key_conditionstring是前次最后一笔资料的Key条件total_resultsnumeric否总数has_nextboolean否是否有下一页cntnumeric否当前回传资料笔数tt_cntnumeric否应回传的资料总笔数wo_info—是工单信息(单头节点，支持多数组)wo_change_nostringY工单变更单单号FB2-230600000001snb01change_seqnumericN变更序1sfka900change_datedateN变更日期格式：yyyyMMdd若无传值则预设值g_todayproduction_control_noStringN生管员编号production_control_nameStringN生管人员名称wo_typeStringN工单类型2.一般工单,2.重工工单,3.拆件式工单,4.研发工单,5.模具工单1sfb02outsourcing_typeStringN委外类型1.厂内,2.委外1sfb100issue_ruleStringN发料制度1.事先发料制,2.倒扣料1sfb39production_item_noStringN生产料号00272-201007-KT1sfb05production_item_naStringN生产料号品名棉T-2010Kitty-产品ima02me特征测试201007production_item_specStringN生产料号规格ima021production_item_featureStringN生产料号特性after_change_production_qtynumericN变更后生产数量10.000snb08abefore_change_production_qtynumericN变更前生产数量10.000snb08bproduction_unit_noStringN生产单位PCSima55production_unit_nameStringN生产单位名称process_noStringN制程编号sfb06process_nameStringN制程说明wo_source_typeStringN工单来源类型0.人工输入,2.订单,6.独立需求单,7.MPS计划wo_sourceStringN工单来源单号sfb22/sfb91wo_source_seqnumericN工单来源项次sfb221/sfb92wo_source_term_seqnumericN工单来源项序after_change_plan_date_sdateN变更后预计开工日格式：yyyyMMdd若无传值则预设值g_today2023-06-20snb13abefore_change_plan_date_sdateN变更前预计开工日格式：yyyyMMdd若无传值则预设值g_today2023-06-20snb13bafter_change_plan_end_datedateN变更后预计完工日格式：yyyyMMdd若无传值则预设值g_today2023-06-20snb15abefore_change_plan_end_datedateN变更前预计完工日格式：yyyyMMdd若无传值则预设值g_today2023-06-20snb15bstatusstringN状态码Nsfb04after_change_department_supplier_noStringN变更后部门供应商snb82aafter_change_department_supplier_nameStringN变更后部门供应商名称before_change_department_supplier_noStringN变更前部门供应商snb82bbefore_change_department_supplier_nameStringN变更前部门供应商名称cost_center_noStringN成本中心cost_center_nameStringN成本中心名称gem02bom_versionStringNBOM版本sfb07pbi_noStringN料表批号(PBI)sfb85urgency_rateStringN紧急比率sfb34priority_seqStringN优先级sfb40project_noStringN项目编号sfb27project_nameStringN项目说明pja02workstation_idStringN产线sfb102shift_noStringN班别plan_stock_in_warehouse_noStringN预计入库库位sfb30plan_stock_in_warehouse_nameStringN预计入库库位名称plan_stock_in_location_noStringN预计入库储位sfb31plan_stock_in_location_nameStringN预计入库储位名称plan_stock_in_lot_noStringN预计入库批号plan_stock_in_inventory_management_featuresStringN预计入库库存管理特征doc_head_change_reasonStringN单头变更理由doc_head_change_remarkStringN单头变更备注create_employee_noStringN资料修改者00272snboriumodify_nodateN资料修改日格式：yyyyMMddHHmmss若无传值则预设值cl_get_current()2023-06-2108:16:40snbdateprepare_material_detail—是备料明细(单身节点，支持多数组)seq_nonumericY项次10sna04part_noStringN部位after_change_op_noStringN变更后作业编号sna08abefore_change_op_noStringN变更前作业编号sna08bop_seqStringN作业序bom_item_noStringNBOM料号after_change_issue_item_noStringN变更后发料料号00272-181118-C1sna03aissue_item_nameStringN发料料号品名ima02issue_item_specStringN发料料号规格ima021before_change_issue_item_noStringN变更前发料料号00272-181118-C1sna03bproduct_feature_noStringN产品特征mandatory_featureStringN必要特性1.主要材料,2.次要材料,3.间接材料,4.参考材料recoil_materialStringN倒扣料allow_error_ratenumericN允许误差率after_change_adjust_issuance_qtynumericN变更后调整应发数量0.000000sna05abefore_change_adjust_issuance_qtynumericN变更前调整应发数量0.000000sna05bunit_noStringN单位after_change_outsourcing_purchasing_qtynumericN变更后委外代买数量0.000000sna065abefore_change_outsourcing_purchasing_qtynumericN变更前委外代买数量0.000000sna065bissue_qtynumericN已发数量0.000000sfa06over_picking_qtynumericN超领数量0.000000sfa062scrap_qtynumericN报废数量0.000000sfa063designation_warehouse_noStringN指定发料库位00272-5sfa30designation_warehouse_nameStringN指定发料库位名称designation_storage_spaces_noStringN指定发料储位sfa31designation_storage_spaces_nameStringN指定发料储位名称designation_lot_noStringN指定发料批号designation_inventory_management_featuresStringN指定发料库存管理特征body_change_reasonStringN单身变更理由body_change_remarkStringN单身变更备注remarkStringN备注sna50production_item_no_list—是生产料号清单(单身节点，支持多数组)production_typeStringN类型1.一般,2.联产品,3.多产出主件,4.拆件式入库,5.副产品/回收料item_noStringN料件编号product_featureStringN产品特征plan_output_qtynumericN预计产出量actual_output_qtynumericN实际产出量change_reasonstringN变更理由change_remarkstringN变更备注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: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:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000参数代号型态是否必填参数说明范例值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:f58528af-0393-477f-81ce-8199fdcff2d8digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
