接口名称tt.oapi.purchase.stock.in.list.data.query.get接口说明查询列表采购入库单资料程序代号soap_oapi00105输入参数说明参数代号型态是否必填参数说明范例值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.purchase.stock.in.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码,提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号CompanyIdstring否营运据点DS1参数代号型态是否必填参数说明范例值ERP字段enterprise_nostring否企业编号不使用site_nostring否营运据点不使用is_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间格式:yyyyMMddHHmmssSSS20230109174700000key_conditionstring否前次最后一笔资料的Key条件xmaw011='A0010'use_has_nextboolean是是否启用分页机制true:启用分页false:不启用分页truepage_sizenumeric否每页条数/分包的请求笔数50page_nonumeric否页码3purchase_stock_in_nostring否采购入库单号461-07040013rvu01doc_datedate否单据日期20230703rvu03格式:yyyyMMddstock_in_staffstring否入库人员wangwyrvu07application_departmentstring否申请部门ZJTTESTrvu06supplier_nostring否供应商000002rvu04statusstring否状态码Yrvuconfpurchase_nostring否采购单号001-PO1-201510050002rvv36purchase_seqstring否采购项次1rvv37receipt_nostring否收货单号002-P52-201804030010rvv04receipt_seqstring否收货项次1rvv05item_nostring否料件编号LJL001rvv31date_sstring是开始日期格式:yyyyMMdd20230201rvudate/rvucratdate_estring是结束日期格式:yyyyMMdd20230228rvudate/rvucratconditions—否条件集合(单头节点,支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))field_namestring否字段名称rvu_file、rvv_file中的所有字段valuestring否字段值operatorstring否操作符=>、>=、=、<、<=、like、in、<>logicalstring否搜寻组间的关系AND、ORorders—否排序设置(单头节点,支持多数组)field_namestring否字段名称rvu_file、rvv_file中的所有字段order_typestring否排序类型ascasc、descRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:2b61d68063b96b6ab8b2ae110f0c8239digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"TIPTOP","name":"tt.oapi.purchase.stock.in.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":"页码","purchase_stock_in_no":"采购入库单号","doc_date":"单据日期","stock_in_staff":"入库人员","application_department":"申请部门","supplier_no":"供应商","status":"状态码","purchase_no":"采购单号","purchase_seq":"采购项次","receipt_no":"收货单号","receipt_seq":"收货项次","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)100:服务未按照正常流程执行,例如发生信息检核不通过等情况,导致无法完成预期的结果000datakeypurchase_stock_in_nostring是采购入库单号461-07040013rvu01参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0:正确<>0:FAIL(原因代码)0sql_codestring否失败时数据库回传代码0descriptionstring否错误问题描述data_timedate否异动时间格式:yyyyMMddHHmmssSSS20230109174700000key_conditionstring否前次最后一笔资料的Key条件total_resultsnumeric是总数has_nextboolean是是否有下一页true.是false.否truepurchase_stock_in_info—否采购入库信息(单头节点,支持多数组)purchase_stock_in_nostring是采购入库单号461-07040013rvu01doc_datedate否单据日期格式:yyyy-mm-dd2023-07-03rvu03stock_in_staffstring否入库人员wangwyrvu07stock_in_staff_namestring否入库人员名称王測試gen02application_departmentstring否申请部门ZJTTESTrvu06application_department_namestring否申请部门名称測試部門gem02purchase_kindstring是采购性质1rvu08source_nostring否来源单号001-CSD-201510050001rvu25supplier_nostring是供应商00000002rvu04supplier_namestring是供应商名称耐克rvu05payment_conditionstring否付款条件001rvu111payment_condition_nastring否付款条件说明及时付款pma02metrade_conditionstring否交易条件不使用trade_condition_namestring否交易条件说明不使用tax_nostring否税别编号0001rvu115tax_namestring否税别说明零税-Jaygec02currency_nostring否币别编号CNYrvu113currency_namestring否币别说明人民币azi02valuation_method_nostring否取价方式编号1rvu112valuation_method_namestring否取价方式说明国内厂商条件pnz02internal_external_Purchasestring否内外购不使用rate_calculation_typestring否汇率计算基准类型不使用total_tax_amountnumeric否含税总金额不使用total_not_tax_amountnumeric否未税总金额不使用total_taxnumeric否总税额不使用remarkstring否备注不使用modify_nostring否资料修改者20126rvumodumodify_datedate否资料修改日格式:yyyy-mm-dd2012-05-05rvudatestatusstring否状态码Yrvuconfconfirmorstring否确认者00222rvuconuconfirm_datestring否确认日格式:yyyy-mm-dd2012-05-13rvucondposted_nostring否过账人不使用posted_datestring否过账日不使用purchase_stock_in_detail—是采购入库明细(单身节点,支持多数组)seq_nonumeric否项次1rvv02purchase_nostring是采购单号PO1-201510050002rvv36purchase_seqnumeric是采购项次1rvv37receipt_nostring是收货单号P52-201804030010rvv04receipt_seqnumeric是收货项次1rvv05qc_nostring否检验单号不使用qc_seqnumeric否检验项次1rvv47qc_resultstring否检验结果P002rvv46item_nostring是料件编号LJL001rvv31item_namestring否料件品名手机屏幕rvv031item_specstring否料件规格PMDima021item_feature_nostring否产品特征不使用item_feature_namestring否产品特征说明不使用unit_nostring否入库单位PCSrvv35stock_in_qtynumeric是入库数量700rvv17pricenumeric否单价1200rvv38tax_nostring是税别编号不使用tax_namestring否税别说明不使用tax_ratenumeric否税率不使用trans_curr_not_tax_amountnumeric否未税金额23301rvv39trans_curr_tax_amountnumeric否含税金额23301rvv39ttrans_curr_taxnumeric否税额不使用remarkstring否备注不使用statusstring否状态码不使用multiple_warehouse_storage_lot_detail—是多库储批明细/多仓库储位批号详情(子单身节点,支持多数组)warehouse_nostring否库位编号LIJINGrvv32warehouse_namestring否仓库名称imd02location_nostring否储位JLL01-1rvv33storage_spaces_namestring否储位名称ime03lot_nostring否批号190312rvv34unit_nostring否入库单位PCSrvv35stock_in_qtynumeric是入库数量200rvv17inventory_management_featuresstring否库存管理特征CCC不使用original_demand_distribute_detail—是原始需求分配明细(子单身节点,支持多数组)demand_doc_nostring否需求单号不使用demand_seqnumeric否需求项次不使用unit_nostring否入库单位不使用stock_in_dispatch_qtynumeric否入库分配数量不使用Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:4ec071b3-7547-4d6f-ba7b-4bc2c0fc9f33digi-protocol:rawdigi-srvver:1.0digi-srvcode:000{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","purchase_stock_in_info":[{"purchase_stock_in_no":"采购入库单号","doc_date":"单据日期","stock_in_staff":"入库人员","stock_in_staff_name":"入库人员名称","application_department":"申请部门","application_department_name":"申请部门名称","purchase_kind":"采购性质","source_no":"来源单号","supplier_no":"供应商","supplier_name":"供应商名称","payment_condition":"付款条件","payment_condition_name":"付款条件说明","trade_condition":"交易条件","trade_condition_name":"交易条件说明","tax_no":"税别编号","tax_name":"税别说明","currency_no":"币别编号","currency_name":"币别说明","valuation_method_no":"取价方式编号","valuation_method_name":"取价方式说明","internal_external_purchase":"内外购","rate_calculation_type":"汇率计算基准类型","total_tax_amount":"含税总金额","total_not_tax_amount":"未税总金额","total_tax":"总税额","remark":"备注","modify_no":"资料修改者","modify_date":"资料修改日","status":"状态码","confirmor":"确认者","confirm_date":"确认日","posted_no":"过账人","posted_date":"过账日","purchase_stock_in_detail":[{"seq_no":"项次","purchase_no":"采购单号","purchase_seq":"采购项次","receipt_no":"收货单号","receipt_seq":"收货项次","qc_no":"检验单号","qc_seq":"检验项次","qc_result":"检验结果","item_no":"料件编号","item_name":"料件品名","item_spec":"料件规格","item_feature_no":"产品特征","item_feature_name":"产品特征说明","unit_no":"入库单位","stock_in_qty":"入库数量","price":"单价","tax_no":"税别编号","tax_name":"税别说明","tax_rate":"税率","trans_curr_not_tax_amount":"未税金额","trans_curr_tax_amount":"含税金额","trans_curr_tax":"税额","remark":"备注","status":"状态码","multiple_warehouse_storage_lot_detail":[{"warehouse_no":"库位编号","warehouse_name":"仓库名称","location_no":"储位","storage_spaces_name":"储位名称","lot_no":"批号","unit_no":"入库单位","stock_in_qty":"入库数量","inventory_management_features":"库存管理特征"}],"original_demand_distribute_detail":[{"demand_doc_no":"需求单号","demand_seq":"需求项次","unit_no":"入库单位","stock_in_dispatch_qty":"入库分配数量"}]}]}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程,并产生预期的结果(Basicflow)100:服务未按照正常流程执行,例如发生信息检核不通过等情况,导致无法完成预期的结果000参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0:正确<>0:FAIL(原因代码)0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述[tt_message]处理笔数1,成功0,失败1Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:4ec071b3-7547-4d6f-ba7b-4bc2c0fc9f33digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}