接口名称tt.oapi.issuing.list.data.query.get接口说明查询发料单资料程序代号soap_oapi00245输入参数说明参数代号型态是否必填参数说明范例值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.issuing.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topproddatakeyEntIdstring是企业编号CompanyIdstring否营运据点DS1参数代号型态是否必填参数说明范例值ERP字段enterprise_nostring否企业编号不使用site_nostring否营运据点不使用is_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间格式：yyyyMMddHHmmssSSS20221001080300000sfpdatekey_conditionstring否前次最后一笔资料的Key条件KEY1='531-09040001'use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数使用说明：当启用分页机制时，代表每页条数。取值范围：大于零的整数，默认值50；最大值500。当不启用分50页机制时，代表分包的请求笔数，如果值为NULL或０，则不做分包机制page_nonumeric否页码3issuing_nostring否发料单单号支持模糊查询(输入不完整编号可查)531-09040001sfp01issue_typestring否发料类别1:成套发料2:工单超领3:工单补料4:耗材领料1sfp06production_department_nostring否生产部门编号DC0360sfp07applicant_nostring否申请人编号01680sfp16wo_nostring否工单单号支持模糊查询(输入不完整编号可查)513-09040004sfq02demand_item_nostring否需求料号100.000000sfs04date_sstring否开始日期格式：yyyyMMdd20240101sfpdatedate_estring否结束日期格式：yyyyMMdd20240101sfpdateconditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否栏位名称sfpdatevaluestring否栏位值20230601operatorstring否操作符>、>=、=、<、<=、like、in、<>>logicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点，支持多数组)field_namestring否栏位名称sfp01order_typestring否排序类型asc：升序desc：降幂ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:50d72735319048aa679e38b728889c5fdigi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"TIPTOP","name":"tt.oapi.issuing.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":"页码","issuing_no":"发料单单号","issue_type":"发料类别","production_department_no":"生产部门编号","applicant_no":"申请人编号","wo_no":"工单单号","demand_item_no":"需求料号","date_s":"开始日期","date_e":"结束日期","conditions":[{"sequence":"条件顺序","bracket":"括号类型","field_name":"字段名称","value":"字段值","operator":"操作符","logical":"搜寻组间的关系"}],"orders":[{"field_name":"字段名称","order_type":"排序类型"}]}}}成功返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)000100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring否错误问题描述data_timedate否异动时间格式：yyyyMMddHHmmssSSS20230109174700000sfpdatekey_conditionstring否前次最后一笔资料的Key条件total_resultsnumeric是总数has_nextboolean是是否有下一页true.是false.否trueissuing_info—是发料单信息(单头节点，支持多数组)issuing_nostring是发料单号531-09040001sfp01doc_datedate否单据日期格式：yyyy-mm-dd2023-06-02sfp02posted_datedate否过账日期格式：yyyy-mm-dd2023-06-21sfp03issue_typestring否工单类型1:成套发料2:工单超领3:工单补料4:耗材领料A:重覆性生产发料C:重覆性生产领料D:RunCard成套发料1sfp06production_department_nostring否生产部门编号001sfp07production_department_namestring否生产部门名称管理部B部gem02applicant_nostring否申请人123sfp16applicant_namestring否申请人名称叶申请人gen02pbi_nostring否PBI编号001-00001sfp08statusstring否状态码N:未确认Y:已确认X:已作废Ysfp04与sfpconfS:已过帐remarkstring否备注不使用modify_nostring否资料修改者1680sfpmodumodify_datedate否资料修改日格式：yyyy-mm-dd2023-06-21sfpdateissuing_demand_detailstring是发料需求明细(单身节点，支持多数组)wo_nostring否工单单号QC03-16050048sfs03/sfe01wo_seqstring否工单项次不使用wo_term_seqstring否工单项序不使用production_item_nostring否生产料号2437-F5sfb05production_item_namestring否生产料号品名PCima02production_item_specstring否生产料号规格I:17-36VO:3.3V/0.36A,5V/0.31Aima021production_item_featurestring否生产料号特性不使用run_card_nostring否RunCard0sfs014/sfe014part_nostring否部位不使用part_namestring否部位说明不使用op_nostring否作业编号1050sfs10/sfe14op_namestring否作业说明披皮ecd02op_seqstring否作业序不使用replaced_suggeststring否替代建议sfs26/sfe26demand_item_nostring否需求料号T001sfs04/sfe07item_namestring否品名A01ima02item_specstring否规格P002-001ima021item_featurestring否产品特征不使用required_featurestring否必要特性不使用transfer_before_issuestring否发料前调拨不使用issue_unit_nostring否发料单位EAsfs06/sfe17unit_namestring否单位说明袋gfe02should_issue_qtynumeric否应发数量200.000sfa05issued_qtynumeric否已发数量16.000sfa06application_qtynumeric否申请数量100.000sfs05/sfe16actual_qtynumeric否实际数量不使用designation_warehouse_nostring否指定库位P003sfs07/sfe08warehouse_namestring否库位名称原料仓imd02designation_storage_spaces_nostring否指定储位P002-001sfs08/sfe09storage_spaces_namestring否储位名称原料储ime03designation_lot_nostring否指定批号sfs09/sfe10inventory_management_featuresstring否库存管理特征不使用inv_available_qtynumeric否库存可用量300img10inv_picking_qtynumeric否库存在捡量10计算值reason_nostring否理由码P003sfs37/sfe37reason_namestring否理由码说明卡异动来源002azf03Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:41614865-4e90-4984-916a-ab95540e130edigi-protocol:rawdigi-srvver:1.0digi-srvcode:000{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","issuing_info_attr":{"cnt":"當前回傳資料筆數","tt_cnt":"應回傳的資料總筆數"},"issuing_info":[{"issuing_no":"发料单单号","doc_date":"单据日期","posted_date":"过帐日期","issue_type":"发料类别","production_department_no":"生产部门编号","production_department_name":"生产部门名称","applicant_no":"申请人编号","applicant_name":"申请人名称","pbi_no":"PBI编号","status":"状态码","remark":"备注","modify_no":"资料修改者","modify_date":"资料修改日","issuing_demand_detail":[{"wo_no":"工单单号","wo_seq":"工单项次","wo_term_seq":"工单项序","production_item_no":"生产料号","production_item_name":"生产料号品名","production_item_spec":"生产料号规格","production_item_feature":"生产料号特性","run_card_no":"RunCard","part_no":"部位","part_name":"部位说明","op_no":"作业编号","op_name":"作业说明","op_seq":"作业序","replaced_suggest":"替代建议","demand_item_no":"需求料号","item_name":"品名","item_spec":"规格","item_feature":"产品特征","required_feature":"必要特性","transfer_before_issue":"发料前调拨","issue_unit_no":"发料单位","unit_name":"单位说明","should_issue_qty":"应发数量","issued_qty":"已发数量","application_qty":"申请数量","actual_qty":"实际数量","designation_warehouse_no":"指定库位","warehouse_name":"库位名称","designation_storage_spaces_no":"指定储位","storage_spaces_name":"储位名称","designation_lot_no":"指定批号","inventory_management_features":"库存管理特征","inv_available_qty":"库存可用量","inv_picking_qty":"库存在捡量","reason_no":"理由码","reason_name":"理由码说明"}]}]}}}失败返回参数说明srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果100参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确<>0：FAIL（原因代码）aws1046sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述is_digiwin_product:参数值请输入Y或NResponse范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:00378fe0-357e-40b2-bffe-191217e8a9c6digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
