接口名称t100.oapi.other.in.inventory.list.data.query.get接口说明查询杂收单列表资料程式代号wssp00228输入参数说明参数代号型态是否必填参数说明范例值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.other.in.inventory.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码,提供同一产品多台主机辨别之用topprddatakeyEntIdstring是企业编号99CompanyIdstring否营运据点DSCTCstock_in_nostring否单号CNJ-B17-202306080001sequencenumeric否条件顺序1field_namestring否字段名称inbadocno参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring是企业编号99inbaentsite_nostring是营运据点DSCTCinbasiteis_digiwin_productstring是是否为鼎捷产品(Y,N)Ndata_timedate否异动时间格式:yyyyMMddHHmmss20221001080300000inbamoddt/inbacrtdtkey_conditionstring否前次最后一笔资料的Key条件(首次呼叫可空值)inbadocno='CNJ-B16-202303080004'use_has_nextboolean是是否启用分页机制true:启用分页truefalse:不启用分页page_sizenumeric否每页条数/分包的请求笔数使用说明:当启用分页机制时,代表每页条数。取值范围:大于零的整数,默认值50;最大值500。当不启用分页机制时,代表分包的请求笔数,如果值为NULL或0,则不做分包机制50page_nonumeric否页码1stock_in_nostring否单号(支持模糊查询,输入不完整编号可查)CNJ-B16-202303080004inbadocnoresponsibility_employee_nostring否业务人员(支持模糊查询,输入不完整编号可查)19097inba003responsibility_employee_namestring否业务人员名称林大同ooag011department_nostring否业务部门(支持模糊查询,输入不完整编号可查)DC0380inba004department_namestring否业务部门名称资管部ooefl003date_sstring是开始日期格式:yyyyMMdd20200101inbamoddt/inbacrtdtdate_estring是结束日期格式:yyyyMMdd20210101inbamoddt/inbacrtdtconditions—否条件集合(单头节点,支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否字段名称inbadocnovaluestring否字段值CNJ-B16-202303080004operatorstring否操作符>、>=、=、<、<=、like、in、<>inlogicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点,支持多数组)field_namestring是字段名称inba001order_typestring是排序类型asc:升序desc:降序ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:a6fbd1f5d4413e7f65521d608a752ef3digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.other.in.inventory.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","stock_in_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":"页码","stock_in_no":"单号","responsibility_employee_no":"业务人员","responsibility_employee_name":"业务人员名称","department_no":"业务部门","department_name":"部门名称","date_s":"开始日期","date_e":"结束日期","conditions":[{"sequence":"栏位名称","bracket":"括号类型","field_name":"栏位名称","value":"栏位值","operator":"操作符","logical":"搜寻组间的关系"}],"orders":[{"field_name":"栏位名称","order_type":"排序类型"}]}}}成功返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程,幷产生预期的结果(Basicflow)100:服务未按照正常流程执行,例如发生资讯检核不通过等情况,导致无法完成预期的结果000datakeystock_in_nostring否单号CNJ-B16-202303080004inbadocno参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0:正确<>0:FAIL(原因代码)0sql_codestring否失败时资料库回传代码0descriptionstring是错误问题描述data_timedate是异动时间格式:yyyyMMddHHmmss20230621000000inbamoddt/inbacrtdtkey_conditionstring是前次最后一笔资料的Key条件inbadocno='CTC-XM2-200400000087'total_resultsnumeric否总数100has_nextboolean否是否有下一页true:是false:否truestock_in_attr—是杂收单资料属性(单头节点)cntnumeric否当前回传资料笔数50tt_cntnumeric否应回传的资料总笔数100stock_in—是杂收单资料(单头节点,支持多数组)source_nostring是来源单号19097test01inba006doc_datedate否单据日期格式:yyyy-mm-dd2023-02-26inbadocdtresponsibility_employee_nostring否业务人员19097inba003responsibility_employee_namestring否业务人员名称林大同ooag011stock_in_nostring否单号CNJ-B16-202303080004inbadocnodepartment_nostring否业务部门DC0380inba004department_namestring否业务部门名称资管部ooefl003reason_codestring否理由码011inba007resoncode_descstring否理由码说明011的说明oocql004remarksstring否备注测试inba008doc_statusstring否单据状态AinbastusA:已核准Z:扣账还原D:抽单N:未审核Y:已审核R:已拒绝S:已过账W:送签中X:作废create_employee_nostring否建档人员编号19097inbaownidcreate_datedate否资料创建日格式:yyyy-mm-ddhh:mm:ss2019-01-1114:17:06inbacrtdtmodify_nostring否资料修改者19097inbamodidmodify_datedate否最近修改日期格式:yyyy-mm-ddhh:mm:ss2019-01-1114:17:06inbamoddtconfirmorstring否确认者19097inbacnfidconfirm_datestring否确认日期格式:yyyy-mm-ddhh:mm:ss2019-01-1114:17:06inbacnfdtResponse范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"stock_out_no":"单号"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"是否有下一页","stock_out":[{"source_no":"来源单号","doc_date":"单据日期","responsibility_employee_no":"业务人员","responsibility_employee_name":"业务人员名称","stock_out_no":"单号","department_no":"业务部门","department_name":"部门名称","reason_code":"理由码","reason_code_desc":"理由码说明","remarks":"备注","doc_status":"单据状态","create_employee_no":"建档人员编号","create_date":"资料创建日","modify_no":"资料修改者","modify_date":"最近修改日期","confirmor":"确认者","confirm_date":"确认日"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值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:99a20f29-688f-453d-a5a5-4e0ddb4a9baadigi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"錯誤碼","sql_code":"資料庫回傳代碼","description":"錯誤問題描述"}}}