接口名称tt.oapi.shipping.list.data.query.get接口说明查询列表出货单资料程序代号soap_oapi00147输入参数说明参数代号型态是否必填参数说明范例值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是接收方产品名称ttnamestring是服务名称tt.oapi.shipping.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条件use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数50page_nonumeric否页码1shipping_nostring否出货单号200-23072402oga01sales_nostring否业务人员012345oga14sales_department_nostring否业务部门TP320oga15customer_nostring否客户编号00001oga03so_nostring否订单单号100-23072402ogb31shipping_notice_nostring否出货通知单201-13060621oga011item_nostring否料件编号12787-Aogb04date_sstring否开始日期格式：yyyyMMdd20230201date_estring否结束日期格式：yyyyMMdd20230228conditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))field_namestring否字段名称oga_file、ogb_file中的所有字段valuestring否字段值operatorstring否操作符>、>=、=、<、<=、like、in、<>logicalstring否搜寻组间的关系AND、ORorders—否排序设置(单头节点，支持多数组)field_namestring否字段名称oga_file、ogb_file中的所有字段order_typestring否排序类型asc、descRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:15396cc27be1d182bad8db2bd42b292bdigi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"TIPTOP","name":"tt.oapi.shipping.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":"页码","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否错误问题描述data_timedate否异动时间格式：yyyyMMddHHmmssSSS20230109174700000key_conditionstring否前次最后一笔资料的Key条件total_resultsnumeric是总数has_nextboolean是是否有下一页true.是false.否trueshipping_info—是出货单信息(单头节点，支持多数组)shipping_nostring是出货单号200-23072402oga01doc_datedate否单据日期格式：yyyy-mm-dd2023-07-24oga02sales_nostring否业务人员012345oga14sales_namestring否业务人员名称刘測試gen02sales_department_nostring否业务部门TP320oga15sales_department_namestring否业务部门名称项目部gem02customer_nostring是客户编号00001oga03customer_namestring是客户名称客户00001oga032delivery_customer_nostring是收货客户00001oga04delivery_customer_namestring是收货客户名称客户00001occ02account_customerstring是收款客户00001oga18account_customer_namestring是收款客户名称客户00001occ02doc_typestring否单据性质2.出貨單A.借貨出貨單3.無訂單出貨單2oga09shipping_propertystring否出货性质1.一般出貨2.換貨出貨3.出至境外倉4.境外倉出貨5.BU間銷售6.調貨出貨7.寄銷出貨A.借貨出貨B.借貨償價1oga00in_transit_cost_warehostring是在途成本仓不使用use_noin_transit_cost_warehouse_namestring是在途成本仓说明不使用in_transit_non_cost_warehouse_nostring是在途非成本仓不使用in_transit_non_cost_warehouse_namestring是在途非成本仓说明不使用delivery_addressstring是送货地址oga044receive_conditionstring否收款条件002oga32receive_condition_namestring否收款条件说明出貨7日內收款,30天票oag02trade_conditionstring否交易条件不使用trade_condition_namestring否交易条件说明不使用tax_nostring否税别编号001oga21tax_namestring否税别说明銷項零稅率0%gec02tax_ratenumeric否税率0oga211is_tax_includedstring否含税否Noga213currency_nostring否币别编号CNYoga23currency_namestring否币别说明人民幣azi02invoice_classstring否发票类型13oga05valuation_method_nostring否取价方式编号不使用valuation_method_namestring否取价方式说明不使用internal_external_salsestring否内外销1oga08rate_calculation_typestring否汇率计算基准类型不使用sales_classification_nostring否销售分类1000oga25sales_channel_nostring否销售通路不使用total_tax_amountnumeric否含税总金额400oga50total_not_tax_amountnumeric否未税总金额不使用total_taxnumeric否总税额不使用remarkstring否备注不使用modify_nostring否资料修改者01234ogamodumodify_datedate否资料修改日格式：yyyy-mm-dd2023-07-24ogadatestatusstring否状态码Yogaconfconfirmorstring否确认者01234ogaconuconfirm_datedate否确认日格式：yyyy-mm-dd2023-07-24ogacondposted_nostring否过账人不使用posted_datedate否过账日不使用shipping_detail—是出货明细(单身节点，支持多数组)seq_nonumeric否项次1ogb03shipping_notice_nostring否出通单号201-13060621oga011shipping_notice_seqnumeric否出通项次1不使用so_nostring否订单单号100-23072402ogb31so_seqnumeric否订单项次1ogb32item_nostring是料件编号12787-Aogb04item_namestring否料件品名12787-A品名ogb06item_specstring否料件规格12787-A規格ogb07item_feature_nostring否产品特征不使用item_feature_namestring否产品特征说明不使用shipping_unit_nostring否出货单位PCSogb05shipping_qtynumeric否出货数量20ogb12pricenumeric否单价20ogb13tax_nostring是税别编号001oga21tax_namestring否税别说明不使用tax_ratenumeric否税率0oga211valuation_unit_nostring否计价单位PCSogb916trans_curr_not_tax_amountnumeric否未税金额400ogb14trans_curr_tax_amountnumeric否含税金额400ogb14ttrans_curr_taxnumeric否税额不使用accepted_qtynumeric否已验收数量不使用received_qtynumeric否已签收数量不使用receipt_return_qtynumeric否已签退数量0ogb51shipping_return_qtynumeric否已销退数量0ogb63project_nostring否项目编号ogb41remarkstring否备注不使用multiple_warehouse_storage_lot_detail—是多库储批明细/多仓库储位批号详情(子单身节点，支持多数组)warehouse_nostring否库位编号T16584ogc09warehouse_namestring否仓库名称16584仓imd02location_nostring否储位001ogc091storage_spaces_namestring否储位名称1仓ime03lot_nostring否批号ogc092shipping_qtynumeric否出货数量20ogc12inventory_management_featuresstring否库存管理特征不使用Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:a0bc71c7-0367-4ea9-ba01-5442f01979acdigi-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（原因代码）aws1046sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述is_digiwin_product:参数值请输入Y或NResponse范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:d3da1cc4-3f2f-47a6-a566-089241514cebdigi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
