接口名称t100.oapi.supplier.list.data.query.get接口说明查询供应商资料程序代号wssp00080输入参数说明参数代号型态是否必填参数说明范例值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.supplier.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码,提供同一产品多台主机辨别之用topprddatakeyEntIdstring是企业编号99CompanyIdstring否营运据点DSCNJsequencenumeric否条件顺序1field_namestring否字段名称企业名参数代号型态是否必填参数说明范例值ERP字段enterprise_nostring否企业别若无传值则预设值g_enterprise99pmaaentsite_nostring否营运中心DSCNJis_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间格式:yyyyMMddHHmmss20220630000000key_conditionstring否前次最后一笔资料的Key条件ENT=99ANDKEY1='DAJA001'use_has_nextboolean是是否启用分页机制true:启用分页false:不启用分页truepage_sizenumeric否每页条数/分包的请求笔数10使用说明:当启用分页机制时,代表每页条数。取值范围:大于零的整数,默认值50;最大值500。当不启用分页机制时,代表分包的请求笔数,如果值为NULL或0,则不做分包机制page_nonumeric否页码2supplier_nostring否供应商编号支持模糊查询(输入不完整编号可查)DAJApmaa006supplier_full_namestring否供应商全名支持模糊查询(输入不完整名称可查)靖江市pmaal003supplier_shortnamestring否供应商简称支持模糊查询(输入不完整名称可查)传动轴pmaal004trans_object_typestring否交易对象类型1:供应商2:客户3:二者皆是3pmaa002legal_typestring否法人类型1:法人2:一次性交易对象3:分公司4:内部员工1pmaa004belong_legalstring否所属法人DAJA001pmaa005belong_group_nostring否所属集团BGC-002pmaa006date_sstring否开始日期格式:yyyyMMdd20220630pmaamoddt/pmaacrtdtdate_estring否结束日期格式:yyyyMMdd20220701pmaamoddt/pmaacrtdtconditions—否条件集合(单头节点,支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))(field_namestring否字段名称pmaa007valuestring否字段值CNoperatorstring否操作符>、>=、=、<、<=、like、in、<>=logicalstring否搜寻组间的关系AND、ORANDorders—否排序设置(单头节点,支持多数组)field_namestring否字段名称pmaa001order_typestring否排序类型asc:升序desc:降幂ascRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:c53a4dddbeacfbcfc36617469071a09bdigi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_CN","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.supplier.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":"页码","supplier_no":"供应商编号","supplier_full_name":"供应商全名","supplier_shortname":"供应商简称","trans_object_type":"交易对象类型","legal_type":"法人类型","belong_legal":"所属法人","belong_group_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:服务未按照正常流程执行,例如发生信息检核不通过等情况,导致无法完成预期的结果000datakeysupplier_nostring否供应商编号DAJA001pmaa001参数代号型态是否必填参数说明范例值ERP字段statuscodestring是错误码0:正确<>0:FAIL(原因代码)0sql_codestring否失败时数据库回传代码0descriptionstring否错误问题描述data_timedate是异动时间格式:yyyyMMddHHmmss20220630000000key_conditionstring是前次最后一笔资料的Key条件ENT=99ANDKEY1='DAJA001'total_resultsnumeric否总数18has_nextboolean否是否有下一页true:是false:否falsesupplier_detail—是供应商明细(单头节点,支持多数组)supplier_nostring是供应商编号DAJA001pmaa001supplier_full_namestring否供应商全名靖江市格瑞特传动轴有限公司pmaal003supplier_shortnamestring否供应商简称格瑞特传动轴pmaal004trans_object_typestring否交易对象类型1:供应商2:客户3:二者皆是1pmaa002legal_typestring否法人类型1:法人2:一次性交易对象3:分公司4:内部员工1pmaa004belong_legalstring否所属法人DAJA001pmaa005belong_legal_namestring否所属法人名称格瑞特传动轴pmaal004belong_group_nostring否所属集团BGC-002pmaa006belong_group_namestring否所属集团名称格瑞特oocql004uniform_numberstring否统一编号202308280001pmaa003country_nostring否国家别CNpmaa007industry_idstring否产业别0337pmaa023Industry_namestring否产业别说明交通运输设备制造业oocql004monthly_settlement_daynumeric否月结日输入值范围1~311pmaa038payment_daynumeric否付款日输入值范围1~3115pmaa041receivable_daynumeric否收款日输入值范围1~3130pmaa044purchaser_nostring否预设采购员SACAEpmaa086purchaser_namestring否采购员名称周于ooag011responsibility_department_nostring否预设采购部门D0000pmaa087responsibility_department_namestring否预设采购部门名称采购一课ooefl003currency_nostring否交易币别CNYpmab033currency_namestring否交易币别说明人民币ooail003tax_nostring否交易税别A01pmab034tax_namestring否交易税别说明增值税-一般纳税人增值税(进项)oodbl004payment_condition_nostring否付款条件102pmab037payment_condition_namestring否付款条件说明现金付款ooibl004trade_condition_nostring否交易条件CIFpmab053trade_condition_namestring否交易条件说明成本加运费保险费oocql004account_typestring否账款类别R1101pmab055account_type_namestring否账款类别说明出货应收账款oocql004modify_nostring否资料修改者00939pmaamodidmodify_datedate否资料修改日格式:yyyy-mm-ddhh:mm:ss2022-06-3017:01:02pmaamoddtstatusdate否状态码N:未审核Y:已审核X:作废Ypmaastustrans_object_relation_detail—是交易对象关系明细(单身节点,支持多数组)trade_typestring否交易类型1:收/付款对象2:送货对象3:发票对象2pmac003trade_type_namestring否交易类型说明送货对象gzcbl004is_mainstring否主要否(Y,N)Ypmac004trans_object_nostring否交易对象编号0000-Epmac002trans_object_namestring否交易对象名称苹果公司pmaal004contact_address_detail—是联络地址明细/联系地址明细(单身节点,支持多数组)brief_nostring否简要编号11oofb019address_typestring否地址类型1:登记地址2:联络地址3:送货地址4:其他地址5:账款地址3oofb008is_main_contact_addressstring否主要联络地址(Y,N)Yoofb010country_codestring否国家/地区CNoofb012addressstring否地址花神大道27号oofb017expiration_datedate否失效日期格式:yyyy-mm-dd2022-12-31oofb018communication_detail—是通讯方式(单身节点,支持多数组)communication_typestring否通讯类型1:一般电话2:行动电话3:传真4:电子邮件5:Skype联络6:Skypeout7:QQ8:Facebook9:网址10:发票电话11:微博12:twitter13:移动设备14:M-cloud15:WeChat4oofc008communication_contentstring否通讯内容yangmm@digiwin.bizoofc012is_main_communication_methodstring否是否主要通讯方式(Y,N)Yoofc010expiration_datedate否失效日期格式:yyyy-mm-dd2030-03-01oofc013bank_info—是银行信息(单身节点,支持多数组)bank_codestring否银行编号0040107pmaf002bank_accountstring否银行账户1238888pmaf003main_receive_bank_accountstring否主要收款银行账户(Y,N)Npmaf008main_payment_bank_accountstring否主要付款银行账户(Y,N)Ypmaf009allow_payment_condition—是允许付款条件(单身节点,支持多数组)trade_condition_nostring否交易条件编号213pmad002trade_condition_namestring否交易条件说明30天期应付票据oocql004is_mainstring否主要否(Y,N)Ypmad004contact_person—是联络人(单身节点,支持多数组)contractor_typestring否联络人类别02pmaj003contractor_type_namestring否联络人类别说明业务联络人oocql004full_namestring否全名张三pmaj012main_contractor_typestring否主要联络人类型(Y,N)Npmaj004is_main_financial_contact_personstring否财务主要联络人否(Y,N)Npmaj005brief_descstring否简要说明wwpmaj008contractor_statusstring否联络人状态码Y:有效N:无效YpmajstusResponse范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:a361f347-9712-482b-bffa-bd97e2a8dcccdigi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"supplier_no":"供应商编号"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","supplier_detail_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"supplier_detail":[{"supplier_no":"供应商编号","supplier_full_name":"供应商全名","supplier_shortname":"供应商简称","trans_object_type":"交易对象类型","legal_type":"法人类型","belong_legal":"所属法人","belong_legal_name":"所属法人名称","belong_group_no":"所属集团","belong_group_name":"所属集团名称","uniform_number":"统一编号","country_no":"国家别","industry_id":"产业别","industry_name":"产业别说明","monthly_settlement_day":"月结日","payment_day":"付款日","receivable_day":"收款日","purchaser_no":"预设采购员","purchaser_name":"采购员名称","responsibility_department_no":"预设采购部门","responsibility_department_name":"预设采购部门名称","site_no":"营运据点","currency_no":"交易币别","currency_name":"交易币别说明","tax_no":"交易税别","tax_name":"交易税别说明","payment_condition_no":"付款条件","payment_condition_name":"付款条件说明","trade_condition_no":"交易条件","trade_condition_name":"交易条件说明","account_type":"账款类别","account_type_name":"账款类别说明","modify_no":"资料修改者","modify_date":"资料修改日","status":"状态码","trans_object_relation_detail":[{"trade_type":"交易类型","trade_type_name":"交易类型说明","is_main":"主要否","trans_object_no":"交易对象编号","trans_object_name":"交易对象名称"}],"contact_address_detail":[{"brief_no":"简要编号","address_type":"地址类型","is_main_contact_address":"是否主要联络地址","country_code":"国家/地区","address":"地址","expiration_date":"失效日期"}],"communication_detail":[{"communication_type":"通讯类型","communication_content":"通讯内容","is_main_communication_method":"是否主要通讯方式","expiration_date":"失效日期"}],"bank_info":[{"bank_code":"银行编号","bank_account":"银行账户","main_receive_bank_account":"主要收款银行账户","main_payment_bank_account":"主要付款银行账户"}],"allow_payment_condition":[{"trade_condition_no":"交易条件编号","trade_condition_name":"交易条件说明","is_main":"主要否"}],"contact_person":[{"contractor_type":"联络人类别","contractor_type_name":"联络人类别说明","full_name":"全名","main_contractor_type":"主要联络人类型","is_main_financial_contact_person":"财务主要联络人否","brief_desc":"简要说明","contractor_status":"联络人状态码"}]}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP字段srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程,并产生预期的结果(Basicflow)100:服务未按照正常流程执行,例如发生信息检核不通过等情况,导致无法完成预期的结果100参数代号型态是否必填参数说明范例值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:a361f347-9712-482b-bffa-bd97e2a8dcccdigi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}