界面名称tt.oapi.payment.condition.list.data.query.get界面说明查询付款条件资料程序代号soap_oapi00336输入参数说明参数代号型态是否必填参数说明范例值requestkeystring是检核编码(MD5)13cc69fb4d4861d95d29331b7f02711ctypestring是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是接收方产品名称ttnamestring是服务名称tt.oapi.payment.condition.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码，提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号CompanyIdstring是营运据点DS1sequencestring是条件顺序1field_namestring否字段名称参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring是企业编号若无传值则预设值g_enterprisesite_nostring是营运中心is_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间key_conditionstring否前次最后一笔资料的Key条件use_has_nextboolean是是否启用分页机制1.是2.否1page_sizenumeri否每页条数/分包的请求笔数cpage_nonumeric否页码payment_condition_nostring是付款条件编号101gec01payment_condition_namestring否付款条件说明月结银行电汇付款testpma02payment_typestring否款别性质10.现金与即期汇款20.银行电汇款30.票据类型40.有价券(礼券)类型50.银行卡/信用卡60.储值类型70.银行信用状80.第三方支付90.其他类型91.赊销92:出纳收款99:质押票据兑现还款94:预收ZZ:冲预收20pma11payment_type_descstring否款别性质说明date_sstring是开始日期date_estring是结束日期conditions—是条件集合(单头节点，支持多数组)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:cee350c5f095694a2af70b40f183321bdigi-host:{"prod":"Athena","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"ERP","name":"tt.oapi.payment.condition.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","payment_condition_no":"付款条件编号","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":"页码","payment_condition_no":"付款条件编号","payment_condition_name":"付款条件说明","payment_type":"款别性质","payment_type_desc":"款别性质说明","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参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）00sql_codestring否失败时数据库回传代码00descriptionstring是错误问题描述total_resultsnumeric否总数has_nextboolean否是否有下一页payment_condition—是收付款条件(单头节点，支持多数组)payment_condition_nostring是付款条件编号101pma01payment_condition_namestring否付款条件说明月结银行电汇付款testpma02payment_typestring否款别性质10.现金与即期汇款20.银行电汇款30.票据类型40.有价券(礼券)类型50.银行卡/信用卡60.储值类型70.银行信用状80.第三方支付90.其他类型91.赊销92:出纳收款99:质押票据兑现还款94:预收ZZ:冲预收20pma11payment_type_descstring否款别性质说明ap_date_typestring否应收付款起算基准类型01.依交易单据日03.发票日05pma0304.发票日次月初05.帐款日06.帐款日次月初07.出入库扣帐日08.出入库扣帐日次月初09.交易认定日10.依交易认定日次月初90.依应收付款日ap_date_type_descstring否应收付款起算基准类型说明ap_added_monthnumeric否应付款日加(月)0pma09ap_added_daynumeric否应付款日加(日)7pma08payment_cashing_date_typestring否帐款兑现起算基准类型01.依交易单据日03.发票日04.发票日次月初05.帐款日06.帐款日次月初07.出入库扣帐日08.出入库扣帐日次月初09.交易认定日10.依交易认定日次月初90.依应收付款日08pma12payment_cashing_date_type_descstring否帐款兑现起算基准类型说明payment_cashing_added_monthnumeric否帐款兑现日加(月)0pma13payment_cashing_added_daynumeric否帐款兑现日加(日)0pma10statusstring否状态码Y：确认/有效Ｎ：未确认/无效Ypmaactimodify_nostring否资料修改者08172pmamodumodify_datedatetime否资料创建日格式：yyyyMMddHHmmss若无传值则预设值cl_get_current()2021-09-2610:13:53pmadateResponse范例Content-Type:application/json;charset=utf-8digi-protocol:rawdigi-srvver:1.0digi-srvcode:000{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"存在下一页","payment_condition_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"payment_condition":[{"payment_condition_no":"付款条件编号","payment_condition_name":"付款条件说明","payment_type":"款别性质","payment_type_desc":"款别性质说明","ap_date_type":"应收付款起算基准类型","ap_date_type_desc":"应收付款起算基准类型说明","ap_added_month":"应付款日加(月)","ap_added_day":"应付款日加(日)","payment_cashing_date_type":"票据到期日起算基准类型","payment_cashing_date_type_desc":"票据到期日起算基准类型说明","payment_cashing_added_month":"票据兑现日加(月)","payment_cashing_added_day":"票据兑现日加(日)","status":"状态码","modify_no":"资料修改者","modify_date":"资料修改日"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程，并产生预期000的结果(Basicflow)100:服务未按照正常流程执行，例如发生信息检核不通过等情况，导致无法完成预期的结果datakeyerp_nostring是ERP编号source_nostring是来源单号(编号)参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0：正确<>0：FAIL（原因代码）aws-00102sql_codestring否失败时数据库回传代码descriptionstring是错误问题描述[tt_message]处理笔数1,成功0,失败1payment_condition—是收付款条件(单头节点，支持多数组)erp_nostring是ERP编号(执行成功时把PK值回传，若执行失败回传空值)source_nostring否来源单号(编号)回传入参中的PK(来源单号)栏位值。execute_descriptionstring否执行描述(执行成功则回传空值；执行失败则回传失败描述)传入的资料不存在或已失效Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:5a75abbe-331d-4175-97b8-1f0c26c77b0cdigi-protocol:rawdigi-srvver:1.0digi-srvcode:100digi-datakey:{"erp_no":"ERP编号","source_no":"来源单号(编号)"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"payment_condition":[{"erp_no":"ERP编号","source_no":"来源单号(编号)","execute_description":"执行描述"}]}}}
