接口名称t100.oapi.wo.stockin.list.data.query.get接口说明查询工单完工入库单列表资料程序代号wssp00263输入参数说明参数代号型态是否必填参数说明范例值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.stockin.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号99CompanyIdstring否营运据点DSCTCsequencestring是条件顺序1field_namestring否字段名称sfeadocno参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring否企业编号99sfeaentsite_nostring否营运据点DSCTCsfeasiteis_digiwin_productstring是是否为鼎捷产品(Y,N)Ndata_timedate否异动时间格式：yyyyMMddHHmmss20221001080300000sfeamoddt/sfeacrtdtkey_conditionstring否前次最后一笔资料的Key条件(首次呼叫可空值)sfeadocno='CNJ-P32-201404020003'use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数使用说明：当启用分页机制时，50代表每页条数。取值范围：大于零的整数，默认值50；最大值500。当不启用分页机制时，代表分包的请求笔数，如果值为NULL或０，则不做分包机制page_nonumeric否页码1stock_in_nostring否入库单号(支持模糊查询，输入不完整编号可查)CTC-B34-202107190001sfeadocnoapplicant_nostring否申请人编号(支持模糊查询，输入不完整编号可查)14589sfea002applicant_department_idstring否申请人部门(支持模糊查询，输入不完整编号可查)DC0300sfea003item_nostring否料号(支持模糊查询，输入不完整编号可查)CL-1000sfec005/sfeb004warehouse_nostring否仓库(支持模糊查询，输入不完整编号可查)001sfec012/sfeb013storage_spaces_nostring否储位(支持模糊查询，输入不完整编号可查)01sfec013/sfeb014lot_nostring否批号(支持模糊查询，输入不完整编号可查)1sfec014/sfeb015date_sstring是开始日期格式：yyyyMMdd20181211sfeamoddt/sfeacrtdtdate_estring是结束日期格式：yyyyMMdd20181211sfeamoddt/sfeacrtdtconditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否字段名称sfeadocnovaluestring否字段值CNJ-ASF-201405230001operatorstring否操作符>、>=、=、<、<=、like、in、<>inlogicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点，支持多数组)field_namestring是字段名称sfea001order_typestring是排序类型asc：升序desc：降序ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:94dd5d97e5c83c07ab40924d3ef6fb84digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.wo.stockin.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","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":"页码","stock_in_no":"入库单号","applicant_no":"申请人编号","applicant_department_id":"申请人部门","item_no":"料号","warehouse_no":"仓库","storage_spaces_no":"储位","lot_no":"批号","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是异动时间格式：yyyyMMddHHmmss20230621000000sfeamoddt/sfeacrtdtkey_conditionstring是前次最后一笔资料的Key条件sfeadocno='CTC-XM2-200400000087'total_resultsnumeric否总数100has_nextboolean否是否有下一页true：是false：否truestock_in_attr—是完工入库属性(单头节点)cntnumeric否当前回传资料笔数50tt_cntnumeric否应回传的资料总笔数100stock_in—是完工入库(单头节点，支持多数组)site_nostring否营运据点DSCTCsfeasitesite_namestring否营运据点名稱鼎捷南京ooefl003stock_in_nostring是入库单号CTC-B34-202107190001sfeadocnodoc_typestring否单别B34doc_type_namestring否单别名称完工入库单oobxl003doc_datedate否单据日期格式：yyyy-mm-dd2021-07-19sfeadocdtposted_datedate否过账日期格式：yyyy-mm-dd2021-07-19sfea001applicant_nostring否申请人编号14589sfea002applicant_namestring否申请人名称林小君ooag011applicant_department_idstring否申请人部门DC0300sfea003applicant_department_namestring否申请人部门名称项目部ooefl003source_nostring否来源单号remarkstring否备注测试ooff013statusstring否状态码A.已核准D.抽单N.未审核Y.已审核S.已过帐R.已拒绝W.送签中X.作废Ysfeastusstock_in_detail—是完工入库单身(单身节点，支持多数组)seqstring否项次1sfecseq/sfebseqsubseqnumeric否项序1sfecseq1wo_nostring是工单号码CTC-FB2-210700000035sfec001/sfeb001run_card_nostring否RunCard0sfec021/sfeb026stock_in_typestring否入库类型1.一般2.联产品3.多产出主件4.拆件式入库5.副产品/回收料1sfec004/sfeb003item_nostring是料号CL-1000sfec005/sfeb004item_namestring否料件品名clyde测试imaal003item_specstring否料件规格测试imaal004item_feature_nostring否产品特征sfec006/sfeb005item_feature_namestring否产品特征说明inaml004stock_in_qtynumeric是入库数量5sfec009/sfeb008unit_nostring是单位PCSsfec008/sfeb007reference_qtynumeric否参考数量5sfec011/sfeb011reference_unit_nostring否参考单位PCSsfec010/sfeb010warehouse_nostring否仓库001sfec012/sfeb013warehouse_namestring否仓库名称一号仓库inayl003storage_spaces_nostring否储位01sfec013/sfeb014storage_spaces_namestring否储位名称塑料储位inab003lot_nostring否批号1sfec014/sfeb015inventory_management_featuresstring否库存管理特征sfec015/sfeb016project_codestring否项目编号20210818sfec022/sfeb017project_namestring否项目名称迭代5测试项目pjbal003manufacture_datedate否制造日期格式：yyyy-mm-dd2021-05-05sfec028/sfeb028expiry_datedate否有效日期格式：yyyy-mm-dd2021-05-05sfec016/sfeb021remarkstring否备注测试sfec017/sfeb022stock_in_sn—否序号单身(子单身节点，支持多数组)seqstring否项次inaoseqsubseqnumeric否项序inaoseq1snnumeric否序号inaoseq2item_nostring否料号inao001item_namestring否料件品名imaal003item_specstring否料件规格imaal004manufacture_lot_nostring否制造批号inao008serial_nostring否制造序号inao009manufacture_datedate否制造日期格式：yyyy-mm-ddinao010expiry_datedate否有效日期格式：yyyy-mm-ddinao011qtynumeric否数量inao012Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:3ce910dc-6559-4856-a8c6-af91e085bf15digi-protocol:rawdigi-srvver:1.0digi-srvcode:000{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","stock_in_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"stock_in":[{"stock_in_no":"入库单号","doc_type":"单别","doc_type_name":"单别名称","doc_date":"单据日期","posted_date":"过帐日期","applicant_no":"申请人编号","applicant_name":"申请人名称","applicant_department_id":"申请人部门","applicant_department_name":"申请人部门名称","source_no":"来源单号","remark":"备注","status":"状态码","stock_in_detail":[{"seq":"项次","subseq":"项序","wo_no":"工单号码","run_card_no":"RunCard","stock_in_type":"入库类型","item_no":"料号","item_name":"料件品名","item_spec":"料件规格","item_feature_no":"产品特征","item_feature_name":"产品特征说明","stock_in_qty":"入库数量","unit_no":"单位","reference_qty":"参考数量","reference_unit_no":"参考单位","warehouse_no":"仓库","warehouse_name":"仓库名称","storage_spaces_no":"储位","storage_spaces_name":"储位名称","lot_no":"批号","inventory_management_features":"库存管理特征","project_code":"项目编号","project_name":"项目名称","manufacture_date":"制造日期","expiry_date":"有效日期","remark":"备注","stock_in_sn":[{"seq":"项次","subseq":"项序","sn":"序号","item_no":"料号","item_name":"料件品名","item_spec":"料件规格","manufacture_lot_no":"制造批号","serial_no":"制造序号","manufacture_date":"制造日期","expiry_date":"有效日期","qty":"数量"}]}]}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值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:3ce910dc-6559-4856-a8c6-af91e085bf15digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
