接口名称t100.oapi.sales.price.list.data.query.get接口说明查询销售价格表列表资料程序代号wssp00097输入参数说明参数代号型态是否必填参数说明范例值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.sales.price.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring是企业编号99CompanyIdstring否营运据点DSCTC参数代号型态是否必填参数说明范例值ERP字段enterprise_nostring否企业别若无传值则预设值g_enterprise99xmawentsite_nostring否营运中心DSCTCxmawsiteis_digiwin_productstring是是否为鼎捷产品Ydata_timedate否异动时间格式：yyyyMMddHHmmssSSS20230109174700000key_conditionstring否前次最后一笔资料的Key条件ENT=99ANDKEY1='A0010'use_has_nextboolean是是否启用分页机制true：启用分页false：不启用分页truepage_sizenumeric否每页条数/分包的请求笔数50page_nonumeric否页码3reference_table_nostring否销售价格参照表号XM01xmaw001currencystring否币种CADxmaw002item_nostring是料件编号00593-Cxmaw011item_feature_nostring否产品特征3456-67-AAAAA-12.00-1xmaw012unit_nostring是单位编号BAGxmaw013standard_costnumeric否标准成本10.000000xmaw019sales_floor_pricenumeric否销售底价11.000000xmaw020business_floor_pricenumeric否业务底价109.000000xmaw021general_sales_pricenumeric是一般售价889.000000xmaw022standard_list_pricenumeric否标准定价78.000000xmaw023date_sstring否开始日期格式：yyyyMMdd20221010xmawmoddt/xmawcrtdtdate_estring否结束日期格式：yyyyMMdd20221010xmawmoddt/xmawcrtdtconditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))field_namestring否字段名称xmawstusxmaw_t中的所有字段valuestring否字段值Yoperatorstring否操作符=>、>=、=、<、<=、like、in、<>logicalstring否搜寻组间的关系AND、ORorders—否排序设置(单头节点，支持多数组)field_namestring否字段名称xmaw011xmaw_t中的所有字段order_typestring否排序类型ascasc、descRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:ebfb2a5dddb8419bb35a51f816d0254ddigi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.sales.price.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":"页码","reference_table_no":"销售价格参照表号","currency":"币别","item_no":"料件编号","item_feature_no":"产品特征","unit_no":"单位编号","standard_cost":"标准成本","sales_floor_price":"销售底价","business_floor_price":"业务底价","general_sales_price":"一般售价","standard_list_price":"标准定价","date_s":"开始日期","date_e":"结束日期","conditions":[{"sequence":"条件顺序","bracket":"括号类型","field_name":"字段名称","value":"字段值","operator":"操作符","logical":"搜寻组间的关系"}],"orders":[{"field_name":"字段名称","order_type":"排序类型"}]}}}成功返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)000100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring否错误问题描述data_timedate否异动时间20230109174700000key_conditionstring否前次最后一笔资料的Key条件total_resultsnumeric是总数has_nextboolean是是否有下一页true.是false.否truesales_price_info—是销售价格信息(单头节点，支持多数组)reference_table_nostring否销售价格参照表号XM01xmaw001reference_table_namestring否参照表名称会计行事历ooall004currencystring否币种CADxmaw002currency_namestring否币名别称墨西哥比索ooail003item_nostring是料件编号00593-Cxmaw011item_namestring否料件品名LJ-Iimaal003item_specstring否料件规格300gimaal004item_feature_nostring否产品特征3456-67-AAAAA-12.00-1xmaw012item_feature_namestring否产品特征说明白_大号inaml004unit_nostring是单位编号BAGxmaw013unit_namestring否单位名称公升oocal003standard_costnumeric否标准成本10.000000xmaw019sales_floor_pricenumeric否销售底价11.000000xmaw020business_floor_pricenumeric否业务底价109.000000xmaw021general_sales_pricenumeric是一般售价889.000000xmaw022standard_list_pricenumeric否标准定价78.000000xmaw023statusstring否状态码CNYxmawstusmodify_nostring否资料修改者Yxmawmodidmodify_datedate否资料修改日格式：yyyy-mm-ddhh:mm:ss2019-05-0617:19:25.00000xmawmoddtResponse范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:058cb8e1-eecb-4e0f-99d6-b77e2d2bc9b6digi-protocol:rawdigi-srvver:1.0digi-srvcode:000{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"是否有下一页","sales_price_info_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"sales_price_info":[{"reference_table_no":"销售价格参照表号","reference_table_name":"参照表名称","currency":"币别","currency_name":"币别名称","item_no":"料件编号","item_name":"料件品名","item_spec":"料件规格","item_feature_no":"产品特征","item_feature_name":"产品特征说明","unit_no":"单位编号","unit_name":"单位名称","standard_cost":"标准成本","sales_floor_price":"销售底价","business_floor_price":"业务底价","general_sales_price":"一般售价","standard_list_price":"标准定价","status":"状态码","modify_no":"资料修改者","modify_date":"资料修改日"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果100参数代号型态是否必填参数说明范例值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:914328d5-013b-44d0-a96b-949941567e63digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
