接口名称t100.oapi.accounts.payable.list.data.query.get接口说明查询应付账款列表资料程序代号wssp00319输入参数说明参数代号型态是否必填参数说明范例值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.accounts.payable.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号99CompanyIdstring否营运据点DSCTC参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring否企业编号若无传值则预设值g_enterprise99apcaentsite_nostring否营运中心DSCTCapcasiteis_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间key_conditionstring否前次最后一笔资料的Key条件use_has_nextboolean是是否启用分页机制1.是2.否1page_sizenumeric否每页条数/分包的请求笔数2page_nonumeric否页码1ap_nostring是应付单号CTC-PA4-19010000apcadocno0001operating_sitestring否账务中心DSCTCapcasiteset_of_booksstring否账套DSCTCapcaldsource_nostring否整合单号apca075accountantstring否账务人员02716apca003account_customerstring否账款对象编号B030apca004payment_objectstring否付款对象B030apca005currencystring否交易原币别TWDapca100invoice_nostring否发票号码KG75466622isam010date_sstring否开始日期格式：yyyyMMdd20221201apcadocdtdate_estring否结束日期格式：yyyyMMdd20221231apcadocdtconditions—是条件集合(单头节点，支持多数组)sequencenumeric否条件顺序1bracketstring否括号类型(、((、)、))field_namestring否字段名称valuestring否字段值operatorstring否操作符>、>=、=、<、<=、like、in、<>logicalstring否搜寻组间的关系AND、ORorders—是排序设置(单头节点，支持多数组)field_namestring是字段名称order_typestring是排序类型asc、descRequest范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:d83dc40b24f176d6d9594c5229d9e05edigi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.accounts.payable.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":"页码","ap_no":"应付单号","operating_site":"账务中心","set_of_books":"账套","source_no":"整合单号","accountant":"账务人员","account_customer":"账款对象","payment_object":"付款对象","currency":"币别","invoice_no":"发票号码","date_s":"开始日期","date_e":"结束日期","conditions":[{"sequence":"条件顺序","bracket":"括号类型","field_name":"栏位名称","value":"栏位值","operator":"操作符","logical":"搜寻组间的关系"}],"orders":[{"field_name":"栏位名称","order_type":"排序类型"}]}}}成功返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预000期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果datakeyap_nostring是应付单号CTC-PA4-190100000001apcadocnosource_nostring否整合单号apca075参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述data_timedate是异动时间key_conditionstring是前次最后一笔资料的Key条件total_resultsnumeric否总数has_nextboolean否是否有下一页ap_list_data—是应付账款清单(单头节点，支持多数组)ap_nostring是应付单号CTC-PA4-190100000001apcadocnoap_datedate否账款日期格式：yyyyMMdd若无传值则预设值g_today2019/01/20apcadocdtap_propertystring否账款单性质13:采购应付单17:发票应付单17apca001operating_sitestring否账务中心DSCTCapcasiteoperating_site_namestring否账务中心名称鼎新台中国泰ooefl003set_of_booksstring否账套DSCTCapcaldset_of_books_namestring否账套名称DSCTCglaal002source_nostring否整合单号apca075accountantstring否账务人员02716apca003accountant_namestring否账务人员姓名tiptopoofa011account_customerstring否账款对象编号B030apca004account_customer_namestring否账款对象名称20180510payment_objectstring否付款对象B030apca005payment_object_namestring否付款对象名称20180510account_typestring否账款类别102apca007account_type_namestring否账款类别名称预付款-购固定资产payment_condition_nostring否付款条件编号101apca008payment_condition_namestring否付款条件说明月结银行电汇付款testaccount_payable_datedate否应付款日格式：yyyyMMdd若无传值则预设值g_today2019/01/11apca009bill_due_datedate否付款到期日格式：yyyyMMdd若无传值则预设值g_today2019/01/11apca010invoice_create_methodstring否发票开立方式1:不开立发票2:应开立发票3:普通收据2apca060tax_nostring否税种1250apca011tax_namestring否税别说明营业税tax_ratenumeric否税率5.00%apca012is_tax_includedstring否含税否Yapca013sales_nostring否业务人员00123apca014sales_namestring否业务人员姓名王大明sales_department_nostring否业务部门apca015sales_department_namestring否业务部门名称account_payable_account_nostring否应付账款科目编号2173apca035account_payable_account_namestring否应付账款科目名称inventory_account_nostring否存货科目编号1308apca036inventory_account_namestring否存货科目名称在途商品tax_account_nostring否税额科目编号tax_account_namestring否税额科目名称currencystring否交易原币别TWDapca100exchange_ratenumeric否原币汇率1.00apca101trans_curr_not_tax_amountnumeric否原币未税金额2152.00apca103trans_curr_taxnumeric否原币税额108.00apca104trans_curr_discount_amountnumeric否原币折让金额trans_curr_discount_tax_amountnumeric否原币折税金额trans_curr_write_off_amountnumeric否原币冲账金额0.00apca106trans_curr_ap_amountnumeric否原币应付金额2,260.00apca108trans_curr_payment_amountnumeric否原币已付金额trans_curr_not_payment_amountnumeric否原币未付金额local_curr_not_tax_amountnumeric否本币未税金额2,152.00apca113local_curr_taxnumeric否本币税额108.00apca114local_curr_discount_amountnumeric否本币折让金额local_curr_discount_tax_amountnumeric否本币折税金额local_curr_write_off_amountnumeric否本币冲账金额0.00apca116local_curr_ap_amountnumeric否本币应付金额2,260.00apca118local_curr_payment_amountnumeric否本币已付金额local_curr_not_payment_amountnumeric否本币未付金额remarkstring否备注apca053statusstring否状态码YapcastusResponse范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:e71e6e37-77c5-4a71-b525-9b9e7798be37digi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"ap_no":"应付单号","source_no":"整合单号"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"是否有下一页","ap_list_data_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"ap_list_data":[{"ap_no":"应付单号","ap_date":"账款日期","ap_property":"账款单性质","operating_site":"账务中心","operating_site_name":"账务中心名称","set_of_books":"账套","set_of_books_name":"账套名称","source_no":"整合单号","accountant":"账务人员","accountant_name":"账务人员姓名","account_customer":"账款对象编号","account_customer_name":"账款对象名称","payment_object":"付款对象","payment_object_name":"付款对象名称","account_type":"账款类别","account_type_name":"账款类别名称","payment_condition_no":"付款条件编号","payment_condition_name":"付款条件说明","account_payable_date":"应付款日","bill_due_date":"付款到期日","invoice_create_method":"发票开立方式","tax_no":"税别","tax_name":"税别说明","tax_rate":"税率","is_tax_included":"含税否","sales_no":"业务人员","sales_name":"业务人员姓名","sales_department_no":"业务部门","sales_department_name":"业务部门名称","account_payable_account_no":"应付账款科目编号","account_payable_account_name":"应付账款科目名称","inventory_account_no":"存货科目编号","inventory_account_name":"存货科目名称","tax_account_no":"税额科目编号","tax_account_name":"税额科目名称","currency":"交易原币别","exchange_rate":"原币汇率","trans_curr_not_tax_amount":"原币未税金额","trans_curr_tax":"原币税额","trans_curr_discount_amount":"原币折让金额","trans_curr_discount_tax_amount":"原币折税金额","trans_curr_write_off_amount":"原币冲账金额","trans_curr_ap_amount":"原币应付金额","trans_curr_payment_amount":"原币已付金额","trans_curr_not_payment_amount":"原币未付金额","local_curr_not_tax_amount":"本币未税金额","local_curr_tax":"本币税额","local_curr_discount_amount":"本币折让金额","local_curr_discount_tax_amount":"本币折税金额","local_curr_write_off_amount":"本币冲账金额","local_curr_ap_amount":"本币应付金额","local_curr_payment_amount":"本币已付金额","local_curr_not_payment_amount":"本币未付金额","remark":"备注","status":"状态码"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值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:e71e6e37-77c5-4a71-b525-9b9e7798be37digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
