界面名称tt.oapi.account.info.list.data.query.get界面说明查询会计科目清单资料程序代号soap_oapi00325输入参数说明参数代号型态是否必填参数说明范例值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是接收方产品名称ttnamestring是服务名称tt.oapi.account.info.list.data.query.getsrvverstring否接收方产品版本1.0ipstring否接收方IP位置10.20.86.223idstring否接收方产品识别码,提供同一产品多台主机辨别之用topprddatakeyEntIdstring否企业编号CompanyIdstring否营运据点DS1account_std_nostring是参照表编号/账别001account_nostring是会计科目编号12sequencestring是条件顺序1field_namestring否字段名称参数代号型态是否必填参数说明范例值ERP栏位enterprise_nostring否企业编号若无传值则预设值g_enterprisesite_nostring否营运中心is_digiwin_productstring是是否为鼎捷产品(Y,N)Ydata_timedate否异动时间key_conditionstring否前次最后一笔资料的Key条件use_has_nextboolean是是否启用分页机制1.是2.否page_sizenumeric否每页条数/分包的请求笔数page_nonumeric否页码account_std_nostring是参照表编号/账别001aag00account_nostring是会计科目编号12aag01account_category_nostring否科目类别1:资产类2:负债类3:共享类4:股东权益类5:成本类6:损益类date_sstring否开始日期date_estring否结束日期conditions—是条件集合(单头节点,支持多数组)sequencenumeric否条件顺序bracketstring否括号类型(、((、)、))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:e203334c34c0a8c6af25c456e0c3f336digi-host:{"prod":"OAPI","ip":"10.20.88.30","lang":"zh_TW","timestamp":"20161018132542116","acct":"tiptop"}digi-service:{"prod":"tt","name":"tt.oapi.account.info.list.data.query.get","ip":"10.20.88.75","id":"topprod"}digi-datakey:{"EntId":"企业编号","CompanyId":"营运据点","account_std_no":"参照表编号","account_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":"页码","account_std_no":"参照表编号","account_no":"会计科目编号","account_category_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:服务未按照正常流程执行,例如发生信息检核不通过等情况,导致无法完成预期的结果000datakeyaccount_std_nostring是参照表编号/账别001aag00account_nostring是会计科目编号12aag01参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0:正确<>0:FAIL(原因代码)0sql_codestring否失败时数据库回传代码0descriptionstring是错误问题描述data_timedate是异动时间key_conditionstring是前次最后一笔资料的Key条件total_resultsnumeric否总数has_nextboolean否是否有下一页account_info—是科目信息(单头节点,支持多数组)cntnumeric否当前回传资料笔数tt_cntnumeric否应回传的资料总笔数account_std_nostring是参照表编号/账别001aag00account_nostring是会计科目编号12aag01account_namestring否科目名称吴洁测试aag02account_propertystring否科目性质1:账户科目2:结转科目1aag03analysis_category_nostring否财务比率分析类别01:流动资产-现金02:流动资产-金融资产03:流动资产-应收帐款04:流动资产-备抵呆帐-应收帐款05:流动资产-存货06:流动资产-备抵存货跌价损失07:流动资产-预付款项08:流动资产-其他流动资产09:无形资产10:非流动资产-长期投资11:非流动资产-长期应收12:不动产、厂房及设备13:非流动资产-其他非流动资产14:其他资产15:流动负债-短期借款16:流动负债-应付帐款17:流动负债-预收款项18:流动负债-其他30aag1919:非流动负债-长期借款20:非流动负债-其他非流动负债21:股本22:资本公积23:保留盈余24:累积换算调整数25:其他权益-重估增值26:投资收益调整27:库藏股票28:销货收入29:其他营业收入30:销货成本31:其他营业成本32:利息费用33:营业费用34:营业外收入35:营业外支出36:所得税费用99:其他38:流动资产-当期所得税资产39:投资性不动产40:流动负债-当期所得税负债41:其他权益-其他42:非控制权益43:其他综合损益44:使用权不动产37:制造成本45:其他综合收益-重分类46:其他综合收益-不重分类account_levelnumeric否科目层级1aag24cash_account_flagstring否现金科目否NResponse范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:f7d12d8d-284a-4cd6-8fdf-2081ff0ba648digi-protocol:rawdigi-srvver:1.0digi-srvcode:000digi-datakey:{"account_std_no":"参照表编号/账别","account_no":"会计科目编号"}{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"},"parameter":{"data_time":"异动时间","key_condition":"前次最后一笔资料的Key条件","total_results":"总数","has_next":"是否有下一页","account_info_attr":{"cnt":"当前回传资料笔数","tt_cnt":"应回传的资料总笔数"},"account_info":[{"account_std_no":"参照表编号/账别","account_no":"会计科目编号","account_name":"科目名称","account_property":"科目性质","analysis_category_no":"财务比率分析类别","account_level":"科目层级","cash_account_flag":"现金科目"}]}}}失败返回参数说明参数代号型态是否必填参数说明范例值ERP栏位srvverstring是服务版本1.0srvcodestring是服务执行结果状态代码000:服务按照正常流程,并产生预期的结果(Basicflow)100:服务未按照正常流程执行,例如发生信息检核不通过等情况,导致无法完成预期的结果000参数代号型态是否必填参数说明范例值ERP栏位statuscodestring是错误码0:正确<>0:FAIL(原因代码)aws-00102sql_codestring否失败时数据库回传代码descriptionstring是错误问题描述[tt_message]处理笔数1,成功0,失败1Response范例Content-Type:application/json;charset=utf-8digi-code:019digi-message:RUFJIFJlc3BvbnNlOuW5s+WPsOWbnuimhuWQjOatpee1kOaenA==digi-reqid:f7d12d8d-284a-4cd6-8fdf-2081ff0ba648digi-protocol:rawdigi-srvver:1.0digi-srvcode:100{"std_data":{"execution":{"code":"错误码","sql_code":"数据库回传代码","description":"错误问题描述"}}}