接口名称t100.oapi.shipping.list.data.query.get接口说明查询列表出货单资料程序代号wssp00147输入参数说明参数代号型态是否必填参数说明范例值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.shipping.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码,提供同一产品多台主机辨别之用topprddatakeyEntIdstring是企业编号99CompanyIdstring否营运据点DSCTC参数代号型态是否必填参数说明范例值ERP字段enterprise_nostring否企业别99site_nostring否营运中心DSCNJis_digiwin_productstring是是否为鼎捷产品Ydata_timedate否异动时间格式:yyyyMMddHHmmss20230621000000key_conditionstring否前次最后一笔资料的Key条件use_has_nextboolean是是否启用分页机制true:启用分页false:不启用分页page_sizenumeric否每页条数/分包的请求笔数page_nonumeric否页码shipping_nostring否出货单号CTC-J10-201706050003xmdkdocnosales_nostring否业务人员04543xmdk003sales_department_nostring否业务部门DC0340xmdk004customer_nostring否客户编号00000002xmdk007so_nostring否订单单号002-P60-201804030001xmdl003shipping_notice_nostring否出货通知单002-WDD-180600000001xmdl001item_nostring否料件编号YS01xmdl008date_sstring否开始日期格式:yyyyMMdddate_estring否结束日期格式:yyyyMMddconditions—否条件集合(单头节点,支持多数组)sequencenumeric否条件顺序bracketstring否括号类型field_namestring否字段名称valuestring否字段值operatorstring否操作符logicalstring否搜寻组间的关系orders—否排序设置(单头节点,支持多数组)field_namestring否字段名称order_typestring否排序类型Request范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:cee76f25f60536668d98d0137b1ee877digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.shipping.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","enterprise_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":"页码","shipping_no":"出货单号","sales_no":"业务人员","sales_department_no":"业务部门","customer_no":"客户编号","so_no":"订单单号","shipping_notice_no":"出货通知单","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:服务未按照正常流程执行,例如发生信息检核不通过等情况,导致无法完成预期的结果000参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0:正确<>0:FAIL(原因代码)0sql_codestring否失败时数据库回传代码0descriptionstring否错误问题描述[T100_message]处理笔数1,成功0,失败1data_timedate否异动时间格式:yyyyMMddHHmmsskey_conditionstring否前次最后一笔资料的Key条件total_resultsnumeric是总笔数has_nextboolean是是否存在下一页true.是false.否shipping_info—是出货单信息(单头节点,支持多数组)shipping_nostring是出货单号CTC-J10-201706050003xmdkdocnodoc_datedate否单据日期格式:yyyy-mm-dd2023-01-04xmdkdocdtsales_nostring否业务人员20126xmdk003sales_namestring否业务人员名称zlxooag011sales_department_nostring否业务部门DC0340xmdk004sales_department_namestring否业务部门名称产中ooefl003customer_nostring是客户编号00000002xmdk007customer_namestring是客户名称金暾(无锡)精密模具pmaal004delivery_customer_nostring是收货客户00000002xmdk009delivery_customer_namestring是收货客户名称金暾(无锡)精密模具pmaal004account_customerstring是收款客户00000002xmdk008account_customer_namestring是收款客户名称金暾(无锡)精密模具pmaal004doc_typestring否单据性质2xmdk000shipping_propertystring否出货性质3xmdk002in_transit_cost_warehouse_nostring是在途成本仓360xmdk039in_transit_cost_warehouse_namestring是在途成本仓说明一号仓库inayl003in_transit_non_cost_warehouse_nostring是在途非成本仓P4000xmdk040in_transit_non_cost_warehouse_namestring是在途非成本仓说明一号仓库inayl003delivery_addressstring是送货地址DAJA001_01xmdk021receive_conditionstring否收款条件212xmdk010receive_condition_namestring否收款条件说明212收款用ooibl004trade_conditionstring否交易条件EXWxmdk011trade_condition_namestring否交易条件说明卖方工厂交货tax_nostring否税别编号001xmdk012tax_namestring否税别说明增值税含税17%oodbl004tax_ratenumeric否税率17.00%xmdk013is_tax_includedstring否含税否Yxmdk014currency_nostring否币别编号CNYxmdk016currency_namestring否币别说明人民币ooail003invoice_classstring否发票类型24xmdk015valuation_method_nostring否取价方式编号131219-001xmdk018valuation_method_namestring否取价方式说明允许单价为0xmahl003internal_external_salsestring否内外销2xmdk042rate_calculation_typestring否汇率计算基准类型1xmdk043sales_classification_nostring否销售分类P01xmdk031sales_channel_nostring否销售通路001xmdk030total_tax_amountnumeric否含税总金额0xmdk052total_not_tax_amountnumeric否未税总金额0xmdk051total_taxnumeric否总税额0xmdk053remarkstring否备注123xmdk054modify_nostring否资料修改者202126xmdkmodidmodify_datedate否资料修改日格式:yyyy-mm-ddhh:mm:ss2023-06-0517:19:25.00000xmdkmoddtstatusstring否状态码Yxmdkstusconfirmorstring否确认者20126xmdkcnfidconfirm_datestring否确认日格式:yyyy-mm-ddhh:mm:ss2023-06-0517:19:25.00000xmdkcnfdtposted_nostring否过帐者16584xmdkpstidposted_datestring否过帐日格式:yyyy-mm-ddhh:mm:ss2023-06-0517:19:25.00000xmdkpstdtshipping_detail—是出货明细(单身节点,支持多数组)seq_nostring否项次1xmdlseqshipping_notice_nostring否出通单号CNJ-FAR-230700000001xmdl001shipping_notice_seqnumeric否出通项次1xmdl002so_nostring否订单单号CNJ-FBK-202307110001xmdl003so_seqnumeric否订单项次1xmdl004item_nostring是料件编号Z0804xmdl008item_namestring否料件品名不启用参考单位imaal003item_specstring否料件规格2000imaal004item_feature_nostring否产品特征Bxmdl009item_feature_namestring否产品特征说明颜色:普通商品_尺寸:滋inaml004润保湿乳液_厂牌:金利来男士配饰-促销2_BIN等级:111shipping_unit_nostring否出货单位PCSxmdl017shipping_qtynumeric否出货数量12xmdl018pricestring否单价30xmdl024tax_nostring是税别编号001xmdl025tax_namestring否税别说明增值税含税17%oodbl004tax_ratenumeric否税率17.00%xmdl026valuation_unit_nostring否计价单位PCSxmdl021trans_curr_not_tax_amountnumeric否未税金额30xmdl027trans_curr_tax_amountnumeric否含税金额300xmdl028trans_curr_taxnumeric否税额20xmdl029accepted_qtystring否已验收数量10xmdl035received_qtystring否已签收数量10xmdl061receipt_return_qtystring否已签退数量10xmdl036shipping_return_qtystring否已销退数量1xmdl037project_nostring否项目编号1xmdl030remarkstring否备注123xmdl051multiple_warehouse_storage_lot_detail—是多库储批明细/多仓库储位批号详情(子单身节点,支持多数组)warehouse_nostring否库位编号801xmdm005warehouse_namestring否仓库名称倩原料仓inayl003location_nostring否储位A-01-01xmdm006storage_spaces_namestring否储位名称A-01-01inab003lot_nostring否批号202307110001xmdm007shipping_qtystring否出货数量10xmdm009inventory_management_featuresstring否库存管理特征F20170210xmdm033Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:9b8720f4-7880-48a3-979b-364058571d53digi-protocol:rawdigi-srvver:1.0digi-srvcode:000{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"是否有下一页","shipping_info_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"shipping_info":[{"shipping_no":"出货单号","doc_date":"单据日期","sales_no":"业务人员","sales_name":"业务人员名称","sales_department_no":"业务部门","sales_department_name":"业务部门名称","customer_no":"客户编号","customer_name":"客户名称","delivery_customer_no":"收货客户","delivery_customer_name":"收货客户名称","account_customer":"收款客户","account_customer_name":"收款客户名称","doc_type":"单据性质","shipping_property":"出货性质","in_transit_cost_warehouse_no":"在途成本仓","in_transit_cost_warehouse_name":"在途成本仓说明","in_transit_non_cost_warehouse_no":"在途非成本仓","in_transit_non_cost_warehouse_name":"在途非成本仓说明","delivery_address":"送货地址","receive_condition":"收款条件","receive_condition_name":"收款条件说明","trade_condition":"交易条件","trade_condition_name":"交易条件说明","tax_no":"税别编号","tax_name":"税别说明","tax_rate":"税率","is_tax_included":"含税否","currency_no":"币别编号","currency_name":"币别说明","invoice_class":"发票类型","valuation_method_no":"取价方式编号","valuation_method_name":"取价方式说明","internal_external_salse":"内外销","rate_calculation_type":"汇率计算基准类型","sales_classification_no":"销售分类","sales_channel_no":"销售通路","total_tax_amount":"含税总金额","total_not_tax_amount":"未税总金额","total_tax":"总税额","remark":"备注","modify_no":"资料修改者","modify_date":"资料修改日","status":"状态码","confirmor":"确认者","confirm_date":"确认日","posted_no":"过帐者","posted_date":"过帐日","shipping_detail":[{"seq_no":"项次","shipping_notice_no":"出通单号","shipping_notice_seq":"出通项次","so_no":"订单单号","so_seq":"订单项次","item_no":"料件编号","item_name":"料件品名","item_spec":"料件规格","item_feature_no":"产品特征","item_feature_name":"产品特征说明","shipping_unit_no":"出货单位","shipping_qty":"出货数量","price":"单价","tax_no":"税别编号","tax_name":"税别说明","tax_rate":"税率","valuation_unit_no":"计价单位","trans_curr_not_tax_amount":"未税金额","trans_curr_tax_amount":"含税金额","trans_curr_tax":"税额","accepted_qty":"已验收数量","received_qty":"已签收数量","receipt_return_qty":"已签退数量","shipping_return_qty":"已销退数量","project_no":"项目编号","remark":"备注","multiple_warehouse_storage_lot_detail":[{"warehouse_no":"库位编号","warehouse_name":"仓库名称","location_no":"储位","storage_spaces_name":"储位名称","lot_no":"批号","shipping_qty":"出货数量","inventory_management_features":"库存管理特征"}]}]}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程,并产生预期的结果(Basicflow)100:服务未按照正常流程执行,例如发生信息检核不通过等情况,导致无法完成预期的结果000参数代号型态是否必填参数说明范例值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:99823fde-89b0-4bc6-8125-56d71d719fc9digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}