接口名称t100.oapi.bom.data.list.data.query.get接口说明查询BOM列表资料程序代号wssp00351输入参数说明参数代号型态是否必填参数说明范例值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_TWserviceprodstring是接收方产品名称T100namestring是服务名称t100.oapi.bom.data.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring是企业编号99CompanyIdstring否营运据点DSCTCsequencestring否条件顺序field_namestring否栏位名称参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring否企业编号若无传值则预设值g_enterprise99bmaaentsite_nostring否营运中心DSCTCbmaasiteis_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间格式：yyyyMMddHHmmss20230615121059bmaamoddtbmaacrtdtkey_conditionstring否前次最后一笔资料的Key条件ENT=99ANDKEY1='190218-J'use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数50使用说明：当启用分页机制时，代表每页条数。取值范围：大于零的整数，默认值50；最大值500。当不启用分页机制时，代表分包的请求笔数，如果值为NULL或０，则不做分包机制page_nonumeric否页码2product_nostring否产品料号支持模糊查询(输入不完整编号可查)218bmaa001product_featurestring否产品特性支持模糊查询(输入不完整姓名可查)包装bmaa002item_sortstring否料件类别item_sort_namestring否料件类别名称Aoutput_typestring否产出类型00272-P001output_type_namestring否产出类型名称16584date_sstring否开始日期格式：YYYYMMddHH24miss202203011400bmaamoddtbmaacrtdtdate_estring否结束日期格式：YYYYMMddHH24miss202303312359bmaamoddtbmaacrtdtconditions—否条件集合(单头节点，支持多数组)sequencestring否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否栏位名称imaacrtdtvaluestring否栏位值20220401operatorstring否操作符>、>=、=、<、<=、like、in、<>>logicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点，支持多数组)field_namestring否栏位名称imaa001order_typestring否排序类型asc：升序desc：降幂ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:1181e5d21049ed18d952ff2b89a0c3b0digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.bom.data.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","product_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":"页码","product_no":"产品料号","product_feature":"产品特性","item_sort":"料件类别","item_sort_name":"料件类别名称","output_type":"产出类型","output_type_name":"产出类型名称","date_s":"开始日期","date_e":"结束日期","conditions":[{"sequence":"序号","bracket":"括号类型","field_name":"栏位名称","value":"栏位值","operator":"操作符","logical":"搜寻组间的关系"}],"orders":[{"field_name":"栏位名称","order_type":"排序类型"}]}}}成功返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果datakeyproduct_nostring是产品料号190218-Jbmaa001参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述执行成功！data_timedate是异动时间格式：yyyyMMddHHmmss20230621000000bmaamoddtbmaacrtdtkey_conditionstring是前次最后一笔资料的Key条件ENT=99ANDKEY1='190218-J'total_resultsnumeric否总数135has_nextboolean否是否有下一页true：是false：否truebom_data—是品号(单头节点，支持多数组)site_nostring否营运据点190218-Jsite_namestring否营运据点名称男士衬衫product_nostring是产品料号黑色，Lbmaa001product_namestring否产品料号名称件imaal003item_specstring否料件规格件imaal004product_featurestring否产品特性Abmaa002product_classificationstring否产品分类01imaa009product_classification_namestring否产品分类名称上衣rtaxl003item_sortstring否料件类别001imaa004item_sort_namestring否料件类别名称颜色gzcbl004life_cyclestring否生命周期状态0130301imaa010life_cycle_namestring否生命周期状态名称衬衫类oocql004output_typestring否产出类型6bmad004output_type_namestring否产出类型名称bmad005production_unit_nostring否生产单位bmaa004production_unit__namestring否生产单位说明oocal003project_nostring否项目号bmaa005project_namestring否项目号说明pjbal003doc_statusstring否单据状态N:未审核Y:已审核X:作废VO:失效bmaastusis_ebomstring否是否工程BOM(Y/N)create_employee_nostring否建档人员编号bmaaownidcreate_datedate否资料创建日bmaamodidmodify_nostring否资料修改者bmaamodidmodify_datedate否最近修改日期bmaamoddtconfirmorstring否确认者bmaacnfidconfirm_datestring否确认日bmaacnfdtResponse范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:b4ee5a5e-a3f6-4fbc-b3f3-f8351f2106b4digi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"product_no":"产品料号"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"是否有下一页""bom_data":[{"site_no":"营运据点","site_name":"营运据点名称","product_no":"产品料号","product_name":"产品料号名称","item_spec":"料件规格","product_feature":"产品特性","product_classification":"产品分类","product_classification_name":"产品分类名称","item_sort":"料件类别","item_sort_name":"料件类别名称","life_cycle":"生命周期状态","life_cycle_name":"生命周期状态名称","output_type":"产出类型","output_type_name":"产出类型名称","production_unit_no":"生产单位","production_unit__name":"生产单位说明","project_no":"项目号","project_name":"项目号说明","doc_status":"单据状态","is_ebom":"是否工程BOM","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（原因代码）anm-03078sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述[T100_message]查询无数据！Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:b4ee5a5e-a3f6-4fbc-b3f3-f8351f2106b4digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
