接口名称tt.oapi.item.demand.supply.list.data.query.get接口说明查询品号供需量列表资料程序代号soap_oapi00040输入参数说明参数代号型态是否必填参数说明范例值requestkeystring是检核编码(MD5)13cc69fb4d4861d95d29331b7f02711ctypestring是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.item.demand.supply.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号CompanyIdstring否营运据点sequencenumeric否条件顺序field_namestring否字段名称参数代号型态是否必填参数说明范例值ERP字段enterprise_nostring否企业编号不使用site_nostring否营运中心不使用is_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间格式：yyyyMMddHHmmss20151211000000imadatekey_conditionstring否前次最后一笔资料的Key条件KEY1='0000'use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数使用说明：当启用分页机制时，代表10每页条数。取值范围：大于零的整数，默认值50；最大值500。当不启用分页机制时，代表分包的请求笔数，如果值为NULL或０，则不做分包机制page_nonumeric否页码1item_idstring否料号0000ima01item_classificationstring否品号分类不使用base_unitstring否基础单位EAima25supply_strategystring否补给策略0:再订购点1:MPS2:MRP3:FAS4:订单式生产5:期间采购1ima37item_inventory_groupstring否品号库存分群不使用item_sale_groupstring否销售分群不使用item_purchase_groupstring否品号采购分群不使用item_production_control_groupstring否品号生管分群不使用conditions—否条件集合(单头节点，支持多数组）sequencenumeric是条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否字段名称ima08valuestring否字段值Moperatorstring否操作符>、>=、=、<、<=、like、in、<>=logicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点，支持多数组)field_namestring是字段名称ima01order_typestring是排序类型asc：升序desc：降幂ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:365737c16246340a139d77e9771edce1digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"TIPTOP","name":"tt.oapi.item.demand.supply.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","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":"页码","item_id":"料号","item_classification":"品号分类","base_unit":"基础单位","supply_strategy":"补给策略","item_inventory_group":"品号库存分群","item_sale_group":"销售分群","item_purchase_group":"品号采购分群","item_production_control_group":"品号生管分群","conditions":[{"sequence":"条件顺序","bracket":"括号类型","field_name":"字段名称","value":"字段值","operator":"操作符","logical":"搜寻组间的关系"}],"orders":[{"field_name":"字段名称","order_type":"排序类型"}]}}}成功返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期000的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述data_timedate是异动时间格式：yyyyMMddHHmmss20151211000000key_conditionstring是前次最后一笔资料的Key条件KEY1='0000'total_resultsnumeric否总数1015has_nextboolean否是否有下一页true：是false：否trueitem_detail—是料件明细(单头节点，支持多数组)item_idstring是料号id0000ima01item_namestring否品名男装ima02item_specstring否料件规格2015新款ima021item_classificationstring否产品分类不使用base_unitstring否基础单位EAima25supply_strategystring否补给策略0:再订购点1:MPS2:MRP3:FAS4:订单式生产5:期间采购1ima37item_inventory_groupstring否品号库存分群不使用item_sale_groupstring否销售分群不使用item_purchase_groupstirng否品号采购分群不使用item_production_control_groupstring否品号生管分群不使用item_stock_qtynumeric否料件库存量2,588.000程序统计值l_avl_stkso_qtynumeric否受订量46916.000程序统计值l_oeb_qwo_prepare_material_qtynumeric否工单备料数量/制令准备材料数量636.000程序统计值l_sfa_q1requisitions_qtynumeric否请购量38.000程序统计值l_pml_qpurchase_qtynumeric否采购量5916.450程序统计值l_pmn_qwo_in_qtynumeric否工单在制量373.600程序统计值l_sfb_q1outsourcing_in_process_qtynumeric否委外在制量0.000程序统计值l_sfb_q2iqc_in_inspection_qtynumeric否IQC在验量0.000程序统计值l_rvb_qfqc_in_inspection_qtynumeric否FQC在验量0.000程序统计值l_qcf_qoutsourcing_iqc_in_inspection_qtynumeric否委外IQC在验量0.000程序统计值l_rvb_q2plan_production_qtynumeric否MPS生产计划0不使用inv_balance_qtynumeric否结存数量-39,621.950程序统计值l_atp_qtyprepare_material_qtynumeric否备置量0不使用current_month_consume_qtynumeric否当月已消耗量0不使用last_month_consume_qtynumeric否上月已消耗量0不使用half_year_average_consume_qtynumeric否半年平均消耗量0不使用annual_average_consume_qtynumeric否年平均消耗量0不使用Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:d890126b-a464-4cb8-84be-7448a4d5d379digi-protocol:rawdigi-srvver:1.0digi-srvcode:000{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","item_detail_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"item_detail":[{"item_id":"料号id","item_name":"品名","item_spec":"料件规格","item_classification":"产品分类","base_unit":"基础单位","supply_strategy":"补给策略","item_inventory_group":"品号库存分群","item_sale_group":"销售分群","item_purchase_group":"品号采购分群","item_production_control_group":"品号生管分群","item_stock_qty":"料件库存量","so_qty":"受订量","wo_prepare_material_qty":"工单备料数量/制令准备材料数量","requisitions_qty":"请购量","purchase_qty":"采购量","wo_in_qty":"工单在制量","outsourcing_in_process_qty":"委外在制量","iqc_in_inspection_qty":"IQC在验量","fqc_in_inspection_qty":"FQC在验量","outsourcing_iqc_in_inspection_qty":"委外IQC在验量","plan_production_qty":"MPS生产计划","inv_balance_qty":"结存数量","prepare_material_qty":"备置量","current_month_consume_qty":"当月已消耗量","last_month_consume_qty":"上月已消耗量","half_year_average_consume_qty":"半年平均消耗量","annual_average_consume_qty":"年平均消耗量"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果100参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确<>0：FAIL（原因代码）aws1409sql_codestring否失败时数据库回传代码descriptionstring是错误问题描述[TIPTOP_message]传入参数is_digiwin_product不可为空！Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:77fdd677-4db2-4556-82f1-cfef2a2c53e1digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
