界面名称t100.oapi.customer.list.data.query.get界面说明查询客户资料程序代号wssp00139输入参数说明参数代号型态是否必填参数说明范例值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.customer.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring是企业编号99CompanyIdstring否营运据点DSCTCenterprise_nostring否企业编号99customer_nostring是客户编号000002sequencenumeric否栏位名称1field_namestring是栏位名称inaa001参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring是企业编号若无传值则预设值g_enterprise99inbaentsite_nostring是营运中心DSCTCis_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间20221001080300000key_conditionstring否前次最后一笔资料的Key条件xmda001='CTC-XM2-200400000087'use_has_nextboolean是是否启用分页机制truepage_sizenumeric是每页条数/分包的请求笔数3page_nonumeric否页码3customer_nostring否客户编号00000002pmaa001customer_full_namestring否客户全名金暾（无锡）精密模具pmaal003customer_shortnamestring否客户简称金暾（无锡）精密模具有限公司pmaal004trans_object_typestring否交易对象类型1.供应商,2.客户,3.二者皆是pmaa002legal_typestring否法人类型1.法人,2.一次性交易对象,3.分公司,4.内部员工pmaa004belong_legalstring否所属法人00000002pmaa005belong_group_nostring否所属集团A002pmaa006date_snumeric是开始日期20230606date_estring是结束日期20230607conditions—否条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))field_namestring否栏位名称inaa001valuestring否栏位值CTC-XM2-200400000087operatorstring否操作符=logicalstring否搜寻组间的关系orders—否排序设置(单头节点，支持多数组)field_namestring是栏位名称xmda001order_typestring是搜寻组间的关系Request范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:c53a89adbc6ee58a758868d75dc60094digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.customer.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","enterprise_no":"企业编号","customer_no":"客户编号"}{"std_data":{"parameter":{"enterprise_no":"企业编号","site_no":"营运据点","is_digiwin_product":"是否为鼎捷产品","data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","use_has_next":"是否启用分页机制","page_size":"每页条数/分包的请求笔数","page_no":"页码","customer_no":"客户编号","customer_full_name":"客户全名","customer_shortname":"客户简称","trans_object_type":"交易对象类型","legal_type":"法人类型","belong_legal":"所属法人","belong_group":"所属集团","date_s":"开始日期","date_e":"结束日期","conditions":[{"sequence":"栏位名称","bracket":"括号类型","field_name":"栏位名称","value":"栏位值","operator":"操作符","logical":"搜寻组间的关系"}],"orders":[{"field_name":"栏位名称","order_type":"排序类型"}]}}}成功返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，幷产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无000法完成预期的结果datakeystock_out_nostring否ERP编号CNJ-B17-202303080050ooeg001参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述data_timedate是异动时间20230223key_conditionstring是前次最后一笔资料的Key条件xmda01='CTC-XM2-200400000087';首次呼叫可空值total_resultsnumeric否总数100has_nextboolean否是否有下一页TRUEcustomer_detail—是客户明细(单头节点，支持多数组)customer_noString否客户编号00000002pmaa001customer_full_nameString否客户全名金暾（无锡）精密模具有限公司pmaal003customer_shortnameString否客户简称金暾（无锡）精密模具pmaal004trans_object_typeString否交易对象类型3pmaa002legal_typeString否法人类型1pmaa004belong_legalString否所属法人00000002pmaa005belong_legal_nameString否所属法人名称金暾（无锡）精密模具pmaal004belong_group_noString否所属集团A002pmaa006belong_group_nameString否所属集团名称鼎捷集团oocql004uniform_numbernumeric否统一编号0001pmaa003country_nostring否国家别CNpmaa007industry_idstring否产业别0101pmaa023industry_id_namestring否产业别说明农业oocql004monthly_settlement_daynumeric否月结日6pmaa038payment_daynumeric否付款日12pmaa041receivable_daynumeric否收款日13pmaa044main_sales_nostring否负责业务人员19097pmaa096main_sales_namestring否负责业务人员名称张宇ooag011responsibility_department_nostring否负责业务部门DC0300pmaa097responsibility_department_namestring否负责业务部门名称南京开发部ooefl003currency_nostring否交易币别TWDpmab033currency_namestring否交易币别说明台币ooail003tax_nostring否交易税别001pmab034tax_namestring否交易税别说明增值税含税17%oodbl004receive_conditionstring否收款条件212pmab037payment_condition_namestring否付款条件说明款到发货ooibl004trade_condition_nostring否交易条件EXWpmab053trade_condition_namestring否交易条件说明卖方工厂交货oocql004account_typestring否帐款类别A1类产品销售收入-国内pmab055account_type_namestring否帐款类别说明00272oocql004modify_nostring否资料修改者2023-05-0408:35:53pmaamodidmodify_datedate否资料修改日011的说明pmaamoddtstatusstring否状态码Ypmaastustrading_partner_relation_detail—是交易对象关系(单身节点，支持多数组)trade_typestring否交易类型1pmac003trade_type_namestring否交易类型说明收/付款对象gzcbl004is_mainboolean否主要否Ypmac004trading_partner_nostring否交易对象编号00000002pmac002trading_partner_namestring否交易对象名称金暾（无锡）精密模具pmaal004contact_address_detail—是联络地址明细/联系地址明细(单身节点，支持多数组)simple_nostring否简要编号07oofb011address_typestring否地址类型3oofb008is_main_contact_addressstring否主要联络地址Yoofb010country_codestring否国家/地区CNoofb012addressstring否地址南京市江宁区双龙大道1698号景枫大厦写字间17Foofb017expiration_datestring否失效日期20230506oofb018communication_detail—是通讯方式(单身节点，支持多数组)communication_typestring否通讯类型1oofc008communication_contentstring否通讯内容0987654321oofc012is_main_communication_wayboolean否主要通讯方式Noofc010expiration_datedatetime否失效日期20230608oofc013bank_detail—是银行信息(单身节点，支持多数组)bank_codestring否银行编号0040200pmaf002bank_accountstring否银行账户6222201991334843449292CSpmaf003is_receive_bank_accountboolean否主要收款账户Npmaf008is_payment_bank_accountboolean否主要付款账户Npmaf009allow_payment_condition—是允许付款条件(单身节点，支持多数组)trade_condition_nostring否交易条件编号IT115pmad002trade_condition_namestring否交易条件说明Noocql004is_mainboolean否主要否Ypmad004Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:2e85034a-9774-4811-9f72-020f066e60a8digi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"customer_no":"客户编号"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"是否有下一页","customer_detail":[{"customer_no":"客户编号","customer_full_name":"客户全名","customer_shortname":"客户简称","trans_object_type":"交易对象类型","legal_type":"法人类型","belong_legal":"所属法人","belong_legal_name":"所属法人名称","belong_group":"所属集团","belong_group_name":"所属集团名称","uniform_number":"统一编号","country_no":"国家别","industry_id":"产业别","industry_id_name":"产业别说明","monthly_settlement_day":"月结日","payment_day":"付款日","receivable_day":"收款日","main_sales_no":"负责业务人员","main_sales_name":"负责业务人员名称","responsibility_department_no":"负责业务部门","responsibility_department_name":"负责业务部门名称","currency_no":"交易币别","currency_name":"交易币别说明","tax_no":"交易税别","tax_name":"交易税别说明","receive_condition":"收款条件","payment_condition_name":"付款条件说明","trade_condition_no":"交易条件","trade_condition_name":"交易条件说明","account_type":"帐款类别","account_type_name":"帐款类别说明","modify_no":"资料修改者","modify_date":"资料修改日","status":"状态码","trading_partner_relation_detail":[{"trade_type":"交易类型","trade_type_name":"交易类型说明","is_main":"主要否","trading_partner_no":"交易对象编号","trading_partner_name":"交易对象名称"}],"contact_address_detail":[{"simple_no":"简要编号","address_type":"地址类型","is_main_contact_address":"主要联络地址","country_code":"国家/地区","address":"地址","expiration_date":"失效日期"}],"communication_detail":[{"communication_type":"通讯类型","communication_content":"通讯内容","is_main_communication_way":"主要通讯方式","expiration_date":"失效日期"}],"bank_detail":[{"bank_code":"银行编号","bank_account":"银行账户","is_receive_bank_account":"主要收款账户","is_payment_bank_account":"主要付款账户"}],"allow_payment_condition":[{"trade_condition_no":"交易条件编号","trade_condition_name":"交易条件说明","is_main":"主要否"}]}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，幷产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）aws-00102sql_codestring否失败时数据库回传代码descriptionstring是错误问题描述[T100_message]处理笔数1,成功0,失败1Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:2e85034a-9774-4811-9f72-020f066e60a8digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
