商业智能类

    ba_gl_accvouch/batch_get


    目录

    1.接口说明

    1.1接口描述

         批量获取BA凭证及明细账信息

    1.2适用版本

         支持U8V12.0 及更高版本

    2.使用场景

    基础数据同步或前端展示

    3.接口调用说明

    3.1请求说明

    url https://api.yonyouup.com/api/ba_gl_accvouch/batch_get
    格式 JSON
    https请求方式 GET


    3.2url参数说明

    参数 是否必填 类型 描述
    from_account 是 sting 调用方id
    to_account 是 string 提供方id
    app_key 是 string 应用编码
    token 是 string 全局访问唯一识别码
    ds_sequence 否 number 数据源序号(默认取应用的第一个数据源)

    3.3请求示例

    GET https://api.yonyouup.com/api/ba_gl_accvouch/batch_get?from_account=openapi_dev&to_account=openapi_ent&app_key=opa6fdd4bea98b95ad7&token=26d2fc4a06844448957a7f8260f3d08b


    3.4返回参数说明

    参数说明 类型 参数路径 描述
    errcode string   错误码,0 为正常。
    errmsg string   错误信息。
    i_id number 自动编号
    iperiod number 会计期间
    csign string 凭证类别字
    isignseq number 凭证类别排序号
    ino_id number 凭证编号
    inid number 行号
    dbill_date date 制单日期
    idoc number 附单据数
    cbill string 制单人
    ccheck string 审核人
    cbook string 记账人
    ibook number 记账标志
    ccashier string 出纳签字人
    iflag number 凭证标志
    ctext1 string 凭证头自定义项1
    ctext2 string 凭证头自定义项2
    cdigest string 摘要
    ccode string 科目编码
    cexch_name string 币种名称
    md number 借方金额
    mc number 贷方金额
    md_f number 外币借方金额
    mc_f number 外币贷方金额
    nfrat number 汇率
    nd_s number 数量借方
    nc_s number 数量贷方
    csettle string 结算方式编码
    cn_id string 票据号
    dt_date date 票号发生日期
    cdept_id string 部门编码
    cperson_id string 职员编码
    ccus_id string 客户编码
    csup_id string 供应商编码
    citem_id string 项目编码
    citem_class string 项目大类编码
    cname string 业务员
    ccode_equal string 对方科目编码
    iflagbank number 银行账两清标志
    iflagPerson number 往来账两清标志
    bdelete boolean 是否核销
    coutaccset string 外部凭证账套号
    ioutyear number 外部凭证会计年度
    coutsysname string 外部凭证系统名称
    coutsysver string 外部凭证系统版本号
    doutbilldate date 外部凭证制单日期
    ioutperiod number 外部凭证会计期间
    coutsign string 外部凭证业务类型
    coutno_id string 外部凭证业务号
    doutdate date 外部凭证单据日期
    coutbillsign string 外部凭证单据类型
    coutid string 外部凭证单据号
    bvouchedit boolean 凭证是否可修改
    bvouchAddordele boolean 凭证分录是否可增删
    bvouchmoneyhold boolean 凭证合计金额是否保值
    bvalueedit boolean 分录数值是否可修改
    bcodeedit boolean 分录科目是否可修改
    ccodecontrol string 分录受控科目可用状态
    bPCSedit boolean 分录往来项是否可修改
    bDeptedit boolean 分录部门是否可修改
    bItemedit boolean 分录项目是否可修改
    bCusSupInput boolean 分录往来项是否必输
    cDefine1 string 自定义项1
    cDefine2 string 自定义项2
    cDefine3 string 自定义项3
    cDefine4 date 自定义项4
    cDefine5 number 自定义项5
    cDefine6 date 自定义项6
    cDefine7 number 自定义项7
    cDefine8 string 自定义项8
    cDefine9 string 自定义项9
    cDefine10 string 自定义项10
    cDefine11 string 自定义项11
    cDefine12 string 自定义项12
    cDefine13 string 自定义项13
    cDefine14 string 自定义项14
    cDefine15 number 自定义项15
    cDefine16 number 自定义项16
    dReceive date u8/nc传输接受日期
    cWLDZFlag string 公司对账类型
    dWLDZTime date 公司对账日期
    bFlagOut boolean 公司对帐是否导出过对帐单
    iBG_OverFlag number 超预算标识
    cBG_Auditor string 超预算审批人
    dBG_AuditTime date 超预算审批时间
    cBG_AuditOpinion string 超预算审批结论
    bWH_BgFlag boolean 预算审核标志
    ssxznum number 实时核销号
    CErrReason string 错误原因
    BG_AuditRemark string 预算审核意见
    cBudgetBuffer string 作废时是否预算过
    iBG_ControlResult number 凭证预算通过标识
    NCVouchID string NC凭证标识
    daudit_date date 凭证审核日期
    RowGuid string 行标识
    cBankReconNo string 银行对账序号
    iyear number 凭证的会计年度
    iYPeriod number 包括年度的会计期间
    wllqDate date 往来两清的日期
    wllqPeriod number 往来两清的会计期间
    tvouchtime date 凭证保存时间
    cblueoutno_id string 冲销凭证ID
    ccodeexch_equal string 对方科目带币种

    3.5正确返回示例

    JSON示例:

    application/json;charset=UTF-8
    {
    	"ba_gl_accvouch":[
    		{
    			"CErrReason":"",
    			"coutid":"",
    			"ccodeexch_equal":"",
    			"bvouchedit":"0",
    			"NCVouchID":"",
    			"iyear":"2014",
    			"ctext1":"",
    			"ctext2":"",
    			"csup_id":"05001",
    			"coutsign":"",
    			"cBankReconNo":"",
    			"dt_date":"2014-11-3000:00:00.0",
    			"cbook":"demo1",
    			"ino_id":"",
    			"cWLDZFlag":"",
    			"bvalueedit":"0",
    			"bCusSupInput":"0",
    			"bdelete":"0",
    			"ccode":"1123",
    			"ccashier":"",
    			"dWLDZTime":"",
    			"iflag":"",
    			"ccheck":"",
    			"doutdate":"",
    			"cperson_id":"",
    			"daudit_date":"",
    			"mc_f":"0.0000",
    			"mc":"0.0000",
    			"md":"20000.0000",
    			"md_f":"20000.0000",
    			"nc_s":"0.0",
    			"iflagbank":"",
    			"cbill":"",
    			"nd_s":"0.0",
    			"citem_id":"",
    			"iperiod":"0",
    			"iflagPerson":"",
    			"dbill_date":"2014-11-3000:00:00.0",
    			"cname":"查玫",
    			"ccus_id":"",
    			"wllqDate":"",
    			"cBG_AuditOpinion":"",
    			"bDeptedit":"0",
    			"idoc":"0",
    			"cdept_id":"",
    			"cDefine6":"",
    			"bvouchAddordele":"0",
    			"cDefine7":"",
    			"cDefine8":"",
    			"cBG_Auditor":"",
    			"cDefine9":"",
    			"cDefine2":"",
    			"coutsysver":"",
    			"cDefine3":"",
    			"cDefine4":"",
    			"cDefine5":"",
    			"ioutyear":"",
    			"cDefine1":"",
    			"iYPeriod":"201400",
    			"coutno_id":"",
    			"cdigest":"往来期初引入",
    			"bFlagOut":"0",
    			"cexch_name":"",
    			"tvouchtime":"2014-12-2709:22:43.64",
    			"bvouchmoneyhold":"0",
    			"BG_AuditRemark":"",
    			"csettle":"",
    			"inid":"1",
    			"nfrat":"0.0",
    			"citem_class":"",
    			"doutbilldate":"",
    			"cBudgetBuffer":"",
    			"iBG_ControlResult":"",
    			"bcodeedit":"0",
    			"RowGuid":"3AF03D6A-C6B5-417D-9C97-DBF55F59E327",
    			"ssxznum":"",
    			"bPCSedit":"0",
    			"cDefine16":"",
    			"cDefine15":"",
    			"cn_id":"0000000005",
    			"ibook":"1",
    			"csign":"",
    			"cDefine14":"",
    			"ccode_equal":"",
    			"cDefine13":"",
    			"isignseq":"",
    			"coutsysname":"",
    			"coutaccset":"",
    			"iBG_OverFlag":"",
    			"ccodecontrol":"",
    			"dReceive":"",
    			"bItemedit":"0",
    			"bWH_BgFlag":"0",
    			"coutbillsign":"",
    			"cDefine10":"",
    			"dBG_AuditTime":"",
    			"cDefine11":"",
    			"cDefine12":"",
    			"wllqPeriod":"",
    			"cblueoutno_id":"",
    			"ioutperiod":"0"
    		},
    		{
    			"CErrReason":"",
    			"coutid":"",
    			"ccodeexch_equal":"",
    			"bvouchedit":"0",
    			"NCVouchID":"",
    			"iyear":"2014",
    			"ctext1":"",
    			"ctext2":"",
    			"csup_id":"09001",
    			"coutsign":"",
    			"cBankReconNo":"",
    			"dt_date":"2014-11-3000:00:00.0",
    			"cbook":"demo1",
    			"ino_id":"",
    			"cWLDZFlag":"",
    			"bvalueedit":"0",
    			"bCusSupInput":"0",
    			"bdelete":"0",
    			"ccode":"1123",
    			"ccashier":"",
    			"dWLDZTime":"",
    			"iflag":"",
    			"ccheck":"",
    			"doutdate":"",
    			"cperson_id":"",
    			"daudit_date":"",
    			"mc_f":"0.0000",
    			"mc":"0.0000",
    			"md":"50000.0000",
    			"md_f":"50000.0000",
    			"nc_s":"0.0",
    			"iflagbank":"",
    			"cbill":"",
    			"nd_s":"0.0",
    			"citem_id":"",
    			"iperiod":"0",
    			"iflagPerson":"",
    			"dbill_date":"2014-11-3000:00:00.0",
    			"cname":"孙亮",
    			"ccus_id":"",
    			"wllqDate":"",
    			"cBG_AuditOpinion":"",
    			"bDeptedit":"0",
    			"idoc":"0",
    			"cdept_id":"",
    			"cDefine6":"",
    			"bvouchAddordele":"0",
    			"cDefine7":"",
    			"cDefine8":"",
    			"cBG_Auditor":"",
    			"cDefine9":"",
    			"cDefine2":"",
    			"coutsysver":"",
    			"cDefine3":"",
    			"cDefine4":"",
    			"cDefine5":"",
    			"ioutyear":"",
    			"cDefine1":"",
    			"iYPeriod":"201400",
    			"coutno_id":"",
    			"cdigest":"往来期初引入",
    			"bFlagOut":"0",
    			"cexch_name":"",
    			"tvouchtime":"2014-12-2709:22:43.64",
    			"bvouchmoneyhold":"0",
    			"BG_AuditRemark":"",
    			"csettle":"",
    			"inid":"1",
    			"nfrat":"0.0",
    			"citem_class":"",
    			"doutbilldate":"",
    			"cBudgetBuffer":"",
    			"iBG_ControlResult":"",
    			"bcodeedit":"0",
    			"RowGuid":"CF8D4773-973B-4576-846C-E583F428D093",
    			"ssxznum":"",
    			"bPCSedit":"0",
    			"cDefine16":"",
    			"cDefine15":"",
    			"cn_id":"0000000006",
    			"ibook":"1",
    			"csign":"",
    			"cDefine14":"",
    			"ccode_equal":"",
    			"cDefine13":"",
    			"isignseq":"",
    			"coutsysname":"",
    			"coutaccset":"",
    			"iBG_OverFlag":"",
    			"ccodecontrol":"",
    			"dReceive":"",
    			"bItemedit":"0",
    			"bWH_BgFlag":"0",
    			"coutbillsign":"",
    			"cDefine10":"",
    			"dBG_AuditTime":"",
    			"cDefine11":"",
    			"cDefine12":"",
    			"wllqPeriod":"",
    			"cblueoutno_id":"",
    			"ioutperiod":"0"
    		}
    	],
    	"page_index":"1",
    	"rows_per_page":"20",
    	"row_count":"225",
    	"errmsg":"",
    	"page_count":"12",
    	"errcode":"0"
    }
    

    3.6错误返回示例

    application/json;charset=UTF-8
    {
    	"errcode":"30021",
    	"errmsg":"此应用未上线"
    } 

    4.API测试

    API测试 SDK下载