接口名称tt.oapi.station.scrapped.list.data.query.get接口说明查询当站报废单列表资料程序代号soap_oapi00283输入参数说明参数代号型态是否必填参数说明范例值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.station.scrapped.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号CompanyIdstring否营运据点DS1scrap_nostring是单号CTC-336-230700000003sequencestring是条件顺序1field_namestring否字段名称参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring否企业编号若无传值则预设值g_enterprisesite_nostring否营运中心DS1is_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间key_conditionstring否前次最后一笔资料的Key条件use_has_nextboolean是是否启用分页机制1.是2.否1page_sizenumeric否每页条数/分包的请求笔数2page_nonumeric否页码1scrap_nostring是单号CTC-336-230700000003shb01responsibility_employee_nostring否业务人员000001shb04responsibility_employee_namestring否业务人员名称张三gen02department_nostring否业务部门department_namestring否部门名称date_sstring否开始日期格式：yyyyMMddHHmmssSSSdate_estring否结束日期格式：yyyyMMddHHmmssSSSconditions—是条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))field_namestring否字段名称valuestring否字段值operatorstring否操作符>、>=、=、<、<=、like、in、<>logicalstring否搜寻组间的关系AND、ORorders—是排序设置(单头节点，支持多数组)field_namestring是字段名称order_typestring是排序类型asc、descRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:74e145418445bcdcd9165110464cdadddigi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"tt","name":"tt.oapi.station.scrapped.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","scrap_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":"页码","scrap_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:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000datakeyscrap_nostring是单号CTC-336-230700000003shb01参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述data_timedate是异动时间key_conditionstring是前次最后一笔资料的Key条件total_resultsnumeric否总数has_nextboolean否是否有下一页scrap_data—是当站报废单(单头节点，支持多数组)source_nostring否来源单号doc_datedate否单据日期格式：yyyyMMdd若无传值则预设值g_today2023-07-14responsibility_employee_nostring否业务人员000001shb04responsibility_employee_namestring否业务人员名称张三gen02scrap_nostring是单号CTC-336-230700000003shb01department_nostring否业务部门0013department_namestring否部门名称wo_nostring否工单单号CTC-FB2-230700000001shb05run_card_nonumeric否RunCard编号shift_nostring否班别编号shb08shift_namestring否班别名称ecg02item_nostring否生产料号00272-190611-Ashb10item_namestring否名称中部在地,最红的奶茶ima02item_name_specstring否规格全糖_正常冰_一匙法国特级蜂蜜ima021op_nostring否作业编号shb081op_namestring否作业名称shb082op_seqstring否作业序application_qtynumeric否申请数量100.000shb112scrap_qtynumeric否报废数量0.000mes_nostring否Mes单号333shb35workstationstring否工作站COST-2shb07workstation_namestring否工作站名称remarksstring否备注actual_start_datedate否开工日期shb02格式：yyyyMMddactual_start_timestring否开工时间shb021actual_start_date_enddate否完工日期格式：yyyyMMddshb03actual_start_time_endstring否完工时间shb031doc_statusstring否单据状态Nshbconfcreate_employee_nostring否建档人员编号tiptopshboriucreate_datedate否资料创建日格式：yyyyMMddHHmmss20230714105913modify_nostring否资料修改者tiptopshbmodumodify_datedate否最近修改日期格式：yyyyMMddHHmmss20230714105913shbdateconfirmorstring否确认者tiptopconfirm_datestring否确认日格式：yyyyMMddHHmmss20230714105913Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:93640425-fb64-4a50-ac5d-6c51b560fc7ddigi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"scrap_no":"单号"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","scrap_data":[{"source_no":"来源单号","doc_date":"单据日期","responsibility_employee_no":"业务人员","responsibility_employee_name":"业务人员名称","scrap_no":"单号","department_no":"业务部门","department_name":"部门名称","wo_no":"工单单号","run_card_no":"RunCard编号","shift_no":"班别编号","shift_name":"班别名称","item_no":"生产编号","item_name":"名称","item_name_spec":"规格","op_no":"作业编号","op_name":"作业名称","op_seq":"作业序","application_qty":"申请数量","scrap_qty":"报废数量","mes_no":"Mes单号","workstation":"工作站","workstation_name":"工作站名称","remarks":"备注","actual_start_date":"开工日期","actual_start_time":"开工时间","actual_start_date_end":"完工日期","actual_start_time_end":"完工时间","doc_status":"单据状态","create_employee_no":"建档人员编号","create_date":"资料创建日","modify_no":"资料修改者","modify_date":"最近修改日期","confirmor":"确认者","confirm_date":"确认日"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）aws-00102sql_codestring否失败时数据库回传代码descriptionstring是错误问题描述[tt_message]处理笔数1,成功0,失败1Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:93640425-fb64-4a50-ac5d-6c51b560fc7ddigi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
