接口名称t100.oapi.accounts.receivable.list.data.query.get接口说明查询应收账款单列表资料程序代号wssp00293输入参数说明参数代号型态是否必填参数说明范例值requestkeystring是检核编码(MD5)109c3c41a1441e702b909ed3de58e4b1typestring是Request类型(sync,async)固定传入synchostprodstring是发起方产品名称OAPIverstring是发起方产品版本1.0ipstring是发起方IP位置10.40.71.91idstring否发起方产品识别码，提供同一产品多台主机辨别之用acctstring是登入账号固定传入tiptoptimestampstring是时间戳记格式：yyyMMddHHmmssSSS20151211123204361timezonestring否发起方时区(-12~+14)+8langstring是语言别(zh_TW,zh_CN,en,vi)zh_CNserviceprodstring是接收方产品名称T100namestring是服务名称t100.oapi.accounts.receivable.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号99CompanyIdstring否营运据点DSCTCsequencenumeric否栏位顺序field_namestring否栏位名称field_namestring是栏位名称参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring否企业别99xrcaentsite_nostring否营运中心DSCNJxrcasiteis_digiwin_productstring是是否为鼎捷产品Ydata_timedate否异动时间格式：yyyMMddHHmmssSSS20221211123204key_conditionstring否前次最后一笔资料的Key条件use_has_nextboolean是是否启用分页机制1.是2.否1page_sizenumeric否每页条数/分包的请求笔数page_nonumeric否页码account_center_nostring否账务中心编号DSCNJxrcasiteaccount_center_namestring否账务中心名称鼎捷南京ooefl003book_set_nostring否账套编号03xrcaldbook_set_namestring否账套名称03账套glaal002account_customer_nostring否账款客户131219-001xrca004account_customer_namestring否账款客户简称昆山泓源链条pmaal004sales_nostring否业务人员20126xrca014sales_namestring否业务人员名称周来新ooag011sales_department_nostring否业务部门BP0270xrca015sales_department_namestring否业务部门名称T产中台中服务部ooefl003account_type_nostring是账款类别编号AR07xrca007account_type_descstring是账款类别说明经睝区交易oocql004；oocql001='3111'ar_typestring否账款单性质编号12xrca001ar_type_descstring否账款单性质说明出货应收单gzcbl004；SCC:8302statusstring否状态码Yxrcastusar_nostring否应收单号GZA-711-201804080001xrcadocnodate_sstring否开始日期格式：yyyyMMdd20221201xrcadocdtdate_estring否结束日期格式：yyyyMMdd20221231xrcadocdtconditions—是条件集合(单头节点，支持多数组)sequencenumeric否条件顺序bracketstring否括号类型field_namestring否栏位名称valuestring否栏位值operatorstring否操作符logicalstring否搜寻组间的关系orders—是排序设置(单头节点，支持多数组)field_namestring是栏位名称order_typestring是排序类型Request范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-type:syncdigi-key:55a0421c5bcb5ad6d072b763dc92d5e1digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"T100","name":"t100.oapi.accounts.receivable.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":"页码","account_center_no":"账务中心编号","account_center_name":"账务中心名称","book_set_no":"账套编号","book_set_name":"账套名称","account_customer_no":"账款客户","account_customer_name":"账款客户简称","sales_no":"业务人员","sales_name":"业务人员名称","sales_department_no":"业务部门","sales_department_name":"业务部门名称","account_type_no":"账款类别编号","account_type_desc":"账款类别说明","ar_type":"账款单性质编号","ar_type_desc":"账款单性质说明","status":"状态码","ar_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:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000datakeysource_nostring是来源单号(编号)GZA-711-201804080001xrca018参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述[T100_message]处理笔数1,成功0,失败1data_timedate是异动时间key_conditionstring是前次最后一笔资料的Key条件ar_list_detail—是应收账款清单(单头节点，支持多数组)statusstring否状态码Yxrcastusstatus_descstring否状态码说明已审核gzcbl004account_center_nostring否账务中心编号DSCNJxrcasiteaccount_center_namestring否账务中心名称鼎捷南京ooefl003book_set_nostring否账套编号03xrcaldbook_set_namestring否账套名称03账套glaal002ar_nostring是应收单号30Bxrcadocnoar_datedate否立账日期2012-06-06xrcadocdtar_typestring否账款单性质编号12xrca001ar_type_descstring否账款单性质说明出货应收单gzcbl004account_customer_nostring否账款客户131219-001xrca004account_customer_namestring否账款客户简称昆山泓源链条pmaal04ar_account_nostring否账款科目1132xrca035accounts_namestring否账款科目名称应收利息glacl004voucher_nostring否凭证号码CTC-T31-202004000019xrca038sales_nostring否业务人员05634xrcb051sales_namestring否业务人员名称周来新ooag011sales_department_nostring否业务部门BP0270xrcb010sales_department_namestring否业务部门名称T产中台中服务部ooefl003account_type_nostring否账款类别编号AR07xrca007account_type_descstring否账款类别说明经睝区交易oocql004currency_nostring否币别应收利息xrca100exchange_ratenumeric否汇率1xrca101ar_seqnumeric否项次1xrcbseqar_periodnumeric否期别1xrcc001ar_due_datedate否应收款日2012-06-06xrcc003collection_due_datedate否收款到期日2012-06-06xrcc004invoice_nostring否发票号码EM30005003xrcc009commercial_invoice_nostring否商用发票号码CNJ-FAA-180800000001xrca021trans_curr_receivable_amountnumeric否原币应收金额100xrcc108trans_curr_collected_amountnumeric否原币已收金额100xrcc109trans_curr_uncollected_amountnumeric否原币未收金额local_curr_receivable_amountnumeric否本币应收金额100xrcc118local_curr_collected_amountnumeric否本币已收金额100xrcc119local_curr_uncollected_amountnumeric否本币未收金额remarkstring否备注123xrca053Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:ef5d59af-86fa-4687-9989-9e37b47b620ddigi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"book_set_no":"帐套编号","ar_no":"应收单号"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","ar_list_detail_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"ar_list_detail":[{"status":"状态码","status_desc":"状态码说明","account_center_no":"帐务中心编号","account_center_name":"帐务中心名称","book_set_no":"帐套编号","book_set_name":"帐套名称","ar_no":"应收单号","ar_date":"立帐日期","ar_type":"帐款单性质编号","ar_type_desc":"帐款单性质说明","account_customer_no":"帐款客户","account_customer_name":"帐款客户简称","ar_account_no":"帐款科目","accounts_name":"帐款科目名称","voucher_no":"传票号码","sales_no":"业务人员","sales_name":"业务人员名称","sales_department_no":"业务部门","sales_department_name":"业务部门名称","account_type_no":"帐款类别编号","account_type_desc":"帐款类别说明","currency_no":"币别","exchange_rate":"汇率","ar_seq":"项次","ar_period":"期别","ar_due_date":"应收款日","collection_due_date":"收款到期日","invoice_no":"发票号码","commercial_invoice_no":"商用发票号码","trans_curr_receivable_amount":"原币应收金额","trans_curr_collected_amount":"原币已收金额","trans_curr_uncollected_amount":"原币未收金额","local_curr_receivable_amount":"本币应收金额","local_curr_collected_amount":"本币已收金额","local_curr_uncollected_amount":"本币未收金额","remark":"备注"}],"total_results":"总数","has_next":"存在下一页"}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果000datakeysource_nostring是来源单号(编号)GZA-711-201804080001xrca018参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）0sql_codestring否失败时数据库回传代码0descriptionstring否错误问题描述[T100_message]处理笔数1,成功0,失败1erp_nostring否ERP编号(执行成功时把PK值回传，若执行失败回传空值)CTP-30A-140400000001xrcadocnosource_nostring是来源单号(编号)(回传入参中的PK栏位值)GZA-711-201804080001xrca018execute_descriptionstring否执行描述(执行成功则回传空值；执行失败则回传失败描述)传入的资料不存在或已失效is_auto_confirmstring否是否自动确认YResponse范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:ef5d59af-86fa-4687-9989-9e37b47b620ddigi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}
