aiM18开发者中心
  • Web Services中文
  • 企业资源规划
Multiable
2024-07-12
目录

财务EBI

# 读取EBI数据：记账凭证列表

# 一、接口描述

​ 用于执行EBI[记账凭证列表]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "T_A_particular": "",
            "T_A_refNo": "",
            "T_A_tDate": "2020 Feb 01",
            "ACCT_A_id": "50",
            "T_A_rate": "1.00000000",
            "aiM18ReservedCol_dataIndex": 1,
            "T_A_curId_desc__lang": "HK$",
            "ACCT_A_code": "9104",
            "T_A_accDesc": "採購:119884PRO",
            "BEDEPT_A_id": "1",
            "T_A_chequeNo": "",
            "MAIN_repCredit": "0.00",
            "T_A_amt": "15,000.00",
            "RCUR_A_sym": "HK$",
            "BEDEPT_A_code": "JC-AA",
            "MAINT_A_code": "119884PI-1",
            "MAIN_repDebit": "15,000.00",
            "MAINT_A_id": "43673"
        }
    ]
}

ebi1

# 读取EBI数据：明细分类账列表

# 一、接口描述

​ 用于执行EBI[明细分类账列表]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "CUR_A_sym": "HK$",
            "ACCT_A_id": "1283",
            "aiM18ReservedCol_dataIndex": 1,
            "MAIN_jlno": "PI20110009",
            "MAIN_amtCredit": "0.00",
            "MAIN_refNo": "",
            "MAIN_jlId": "38862",
            "ACCT_A_code": "110001",
            "MAIN_chequeNo": "",
            "MAIN_balDesc": "",
            "MAIN_tDate": "2020 Dec 31",
            "MAIN_particular": "",
            "BEDEPT_A_id": "80",
            "MAIN_amtDebit": "2,000.00",
            "MAIN_bankSlipNo": "",
            "MAIN_balance": "2,000.00",
            "MAIN_repCredit": "0.00",
            "RCUR_A_sym": "HK$",
            "BEDEPT_A_code": "AC",
            "MAIN_repDebit": "2,000.00"
        }
    ]
}

ebi1

# 读取EBI数据：应收创始记录列表

# 一、接口描述

​ 用于执行EBI[应收创始记录列表]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "M_A_code": "233827ARIB",
            "M_A_amt": "5,000.00",
            "aiM18ReservedCol_dataIndex": 1,
            "M_A_curId_desc__lang": "T",
            "M_A_tDate": "2020 Mar 08",
            "MAIN_reportIniAmt": "4,470.00",
            "MAIN_reportAlAmt": "0.00",
            "MAIN_reportAmt": "4,470.00",
            "M_A_beId": "1",
            "M_A_iniAmt": "5,000.00",
            "MAIN_AIDesc": "207866CUS (SC)",
            "M_A_alAmt": "0.00",
            "MAIN_AICode": "207866CUS",
            "M_A_id": "99",
            "M_A_rate": "0.89400000",
            "RCUR_A_sym": "HK$",
            "M_A_cpDate": "2020 Mar 08",
            "M_A_beId_code": "JC-AA"
        }
    ]
}

ebi1

# 读取EBI数据：预收创始记录列表

# 一、接口描述

​ 用于执行EBI[预收创始记录列表]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "M_A_code": "217315DRIB",
            "M_A_amt": "17,600.00",
            "aiM18ReservedCol_dataIndex": 1,
            "M_A_curId_desc__lang": "USD",
            "M_A_tDate": "2020 Nov 30",
            "MAIN_reportIniAmt": "160,000.00",
            "MAIN_reportAlAmt": "19,200.00",
            "MAIN_reportAmt": "140,800.00",
            "M_A_beId": "1",
            "M_A_iniAmt": "20,000.00",
            "MAIN_AIDesc": "217315CUS (SC)",
            "M_A_alAmt": "2,400.00",
            "MAIN_AICode": "217315CUS",
            "M_A_id": "17",
            "M_A_rate": "8.00000000",
            "M_A_beId_code": "JC-AA"
        }
    ]
}

ebi1

# 读取EBI数据：应收账款交易列表

# 一、接口描述

​ 用于执行EBI[应收账款交易列表]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "MAINARTRAN_A_rate": "1.00000000",
            "MAINARTRAN_A_id": "394",
            "MAINARTRAN_A_ttlCharge": "1,000.00",
            "aiM18ReservedCol_dataIndex": 1,
            "MAINARTRAN_A_beId": "1",
            "MAINARTRAN_A_curId_desc__lang": "HK$",
            "MAIN_reportAmt": "1,000.00",
            "MAIN_reportTtlDisc": "0.00",
            "MAINARTRAN_A_amt": "1,000.00",
            "MAIN_AIDesc": "207866CUS (SC)",
            "MAIN_reportTtlCharge": "1,000.00",
            "MAIN_AICode": "207866CUS",
            "MAINARTRAN_A_ttlDisc": "0.00",
            "MAINARTRAN_A_beId_code": "JC-AA",
            "MAINARTRAN_A_tDate": "2021 Oct 04",
            "MAIN_reportDepoAmt": "0.00",
            "MAINARTRAN_A_code": "JCAAART211001",
            "RCUR_A_sym": "HK$",
            "MAINARTRAN_A_depoAmt": "0.00"
        }
    ]
}

ebi1

# 读取EBI数据：应收账款交易报告

# 一、接口描述

​ 用于执行EBI[应收账款交易报告]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "MAINARTRAN_A_rate": "1.00000000",
            "MAINARTRAN_A_id": "394",
            "ARTRANT_A_c_d": "加",
            "ARTRANT_A_amt": "1,000.00",
            "aiM18ReservedCol_dataIndex": 1,
            "MAINARTRAN_A_beId": "1",
            "ARTRANT_A_accDesc": "Account Receivable 1",
            "ARTRANT_A_particular": "",
            "MAINARTRAN_A_curId_desc__lang": "HK$",
            "MAIN_reportAmt": "1,000.00",
            "MAIN_reportTtlDisc": "0.00",
            "MAIN_reportFooterAmt": "1,000.00",
            "MAIN_AIDesc": "207866CUS (SC)",
            "MAIN_reportTtlCharge": "1,000.00",
            "MAIN_AICode": "207866CUS",
            "MAINARTRAN_A_beId_code": "JC-AA",
            "MAINARTRAN_A_tDate": "2021 Oct 04",
            "MAIN_reportDepoAmt": "0.00",
            "MAINARTRAN_A_code": "JCAAART211001",
            "RCUR_A_sym": "HK$",
            "ACCCODE_A_code": "5707",
            "ACCCODE_A_id": "58"
        }
    ]
}

ebi1

# 读取EBI数据：应收账款账龄分析表（按应收对象和天数）

# 一、接口描述

​ 用于执行EBI[应收账款账龄分析表（按应收对象和天数）]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "MAIN_iPostClRep": "0.00",
            "MAIN_iPostClRepPer": "0.00",
            "CUR_A_sym": "RMB",
            "MAIN_depoAmt": "0.00",
            "aiM18ReservedCol_dataIndex": 1,
            "BE_A_id": "118",
            "MAIN_ePostClRepPer": "0.00",
            "MAIN_forRate": "1.00000000",
            "MAIN_reportOutAmt5": "0.00",
            "MAIN_reportOutAmt4": "0.00",
            "MAIN_outAmt": "21,597.00",
            "MAIN_reportOutAmt3": "0.00",
            "MAIN_AIDesc": "Test Customer",
            "MAIN_reportOutAmt2": "0.00",
            "MAIN_reportOutAmt1": "0.00",
            "MAIN_AICode": "CUS",
            "MAIN_AIId": "278",
            "BE_A_code": "COSTTEST",
            "MAIN_AIType": "cus",
            "MAIN_ePostClRep": "0.00"
        }
    ]
}

ebi1

# 读取EBI数据：应收账款账龄分析表（按应收对象和月份）

# 一、接口描述

​ 用于执行EBI[应收账款账龄分析表（按应收对象和月份）]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "aiM18ReservedCol_dataIndex": 1,
            "MAIN_settleId": "0",
            "MAIN_tDate": "2021 Jan 07",
            "MAIN_reportOutAmt5": "0.00",
            "MAIN_reportOutAmt4": "0.00",
            "MAIN_AIDesc": "Test Customer",
            "MAIN_rate": "1.00000000",
            "RCUR_A_sym": "RMB",
            "MAIN_ce01ModuleMess": "",
            "MAIN_tranTypeMess": "销售发票",
            "MAIN_settleCode": "",
            "CUR_A_sym": "RMB",
            "MAIN_reportOutAmt": "0.00",
            "MAIN_invCode": "SI21010063",
            "MAIN_settleMess": "完全核销",
            "MAIN_invAmt": "0.00",
            "MAIN_outAmt": "0.00",
            "MAIN_reportOutAmt3": "0.00",
            "MAIN_reportOutAmt2": "0.00",
            "MAIN_reportOutAmt1": "0.00",
            "BEDEPT_A_id": "118",
            "MAIN_AICode": "CUS",
            "MAIN_cpDate": "2021 Jan 07",
            "MAIN_settleAmt": "0.00",
            "BEDEPT_A_code": "COSTTEST",
            "MAIN_bal": "0.00",
            "MAIN_ce01Module": ""
        }
    ]
}

ebi1

# 读取EBI数据：应收账款账龄分析表（按发票和天数）

# 一、接口描述

​ 用于执行EBI[应收账款账龄分析表（按发票和天数）]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "MAIN_iPostClRep": "0.00",
            "MAIN_iPostClRepPer": "0.00",
            "CUR_A_sym": "RMB",
            "MAIN_depoAmt": "0.00",
            "aiM18ReservedCol_dataIndex": 1,
            "BE_A_id": "118",
            "MAIN_ePostClRepPer": "0.00",
            "MAIN_forRate": "1.00000000",
            "MAIN_reportOutAmt5": "0.00",
            "MAIN_reportOutAmt4": "0.00",
            "MAIN_outAmt": "21,597.00",
            "MAIN_reportOutAmt3": "0.00",
            "MAIN_AIDesc": "Test Customer",
            "MAIN_reportOutAmt2": "0.00",
            "MAIN_reportOutAmt1": "0.00",
            "MAIN_AICode": "CUS",
            "BE_A_code": "COSTTEST",
            "MAIN_ePostClRep": "0.00"
        }
    ]
}

ebi1

# 读取EBI数据：应收账款账龄分析表（按发票和月份）

# 一、接口描述

​ 用于执行EBI[应收账款账龄分析表（按发票和月份）]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "MAIN_outAmt5": "0.00",
            "MAIN_outAmt4": "0.00",
            "MAIN_outAmt3": "0.00",
            "MAIN_outAmt2": "0.00",
            "aiM18ReservedCol_dataIndex": 1,
            "MAIN_outAmt1": "0.00",
            "MAIN_reportInvAmt": "0.00",
            "MAIN_tDate": "2021 Jan 07",
            "MAIN_reportOutAmt5": "0.00",
            "MAIN_reportOutAmt4": "0.00",
            "MAIN_AIDesc": "Test Customer",
            "MAIN_rate": "1.00000000",
            "RCUR_A_sym": "RMB",
            "MAIN_tranTypeMess": "销售发票",
            "CUR_A_sym": "RMB",
            "MAIN_reportOutAmt": "0.00",
            "MAIN_invCode": "SI21010063",
            "MAIN_settleMess": "完全核销",
            "MAIN_invAmt": "0.00",
            "MAIN_outAmt": "0.00",
            "MAIN_reportOutAmt3": "0.00",
            "MAIN_reportBal": "0.00",
            "MAIN_reportOutAmt2": "0.00",
            "MAIN_reportOutAmt1": "0.00",
            "BEDEPT_A_id": "118",
            "MAIN_AICode": "CUS",
            "MAIN_cpDate": "2021 Jan 07",
            "BEDEPT_A_code": "COSTTEST",
            "MAIN_bal": "0.00"
        }
    ]
}

ebi1

# 读取EBI数据：客户订单订金往来报告

# 一、接口描述

​ 用于执行EBI[客户订单订金往来报告]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "CUR_A_sym": "HK$",
            "MAIN_orderId": "0",
            "MAIN_orderTypeMess": "",
            "MAIN_orderDate": "",
            "aiM18ReservedCol_dataIndex": 1,
            "MAIN_orderCode": "",
            "MAIN_balDesc": "",
            "MAIN_tDate": "2020 Aug 05",
            "MAIN_repDrAmt": "0.00",
            "MAIN_AICode": "210302CUS",
            "MAIN_AIId": "86",
            "MAIN_id": "88",
            "MAIN_orderType": "",
            "MAIN_repBal": "529.30",
            "MAIN_repCrAmt": "529.30",
            "MAIN_AIType": "cus",
            "MAIN_ce01Module": "recReg",
            "MAIN_code": "210302RR-C1"
        }
    ]
}

ebi1

# 读取EBI数据：应收账款及订金往来报告

# 一、接口描述

​ 用于执行EBI[应收账款及订金往来报告]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "MAIN_ARCrAmt": "0.00",
            "aiM18ReservedCol_dataIndex": 1,
            "MAIN_DepDrAmt": "0.00",
            "MAIN_ARNetAmt": "2,850.00",
            "MAIN_balDesc": "",
            "MAIN_tDate": "2020 Jan 25",
            "MAIN_ARDrAmt": "2,850.00",
            "MAIN_AICode": "",
            "MAIN_AIId": "0",
            "MAIN_id": "144",
            "MAIN_accDesc": "P20210827",
            "MAIN_tranNo": "232036POSDN-2",
            "MAIN_ce01ModuleMess": "零售送货单",
            "MAIN_DepCrAmt": "0.00",
            "MAIN_amt": "2,850.00",
            "MAIN_DepNetAmt": "0.00",
            "MAIN_AIType": "poscoreMember",
            "MAIN_ce01Module": "poscoreDeliveryNote"
        }
    ]
}

ebi1

# 读取EBI数据：应付创始记录列表

# 一、接口描述

​ 用于执行EBI[应付创始记录列表]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "M_A_code": "217315APIB",
            "M_A_amt": "5,000.00",
            "aiM18ReservedCol_dataIndex": 1,
            "M_A_curId_desc__lang": "USD",
            "M_A_tDate": "2020 Dec 01",
            "MAIN_reportIniAmt": "39,150.00",
            "MAIN_reportAlAmt": "0.00",
            "MAIN_reportAmt": "39,150.00",
            "M_A_beId": "1",
            "M_A_iniAmt": "5,000.00",
            "MAIN_AIDesc": "217315VEN (SC)",
            "M_A_alAmt": "0.00",
            "MAIN_AICode": "217315VEN",
            "MAIN_AIId": "105",
            "M_A_id": "28",
            "M_A_rate": "7.83000000",
            "RCUR_A_sym": "HK$",
            "M_A_cpDate": "2021 Jan 31",
            "M_A_beId_code": "JC-AA",
            "MAIN_AIType": "ven"
        }
    ]
}

ebi1

# 读取EBI数据：预付创始记录列表

# 一、接口描述

​ 用于执行EBI[预付创始记录列表]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "M_A_code": "217315DPIB",
            "M_A_amt": "654.72",
            "aiM18ReservedCol_dataIndex": 1,
            "M_A_curId_desc__lang": "USD",
            "M_A_tDate": "2020 Dec 04",
            "MAIN_reportIniAmt": "36,018.00",
            "MAIN_reportAlAmt": "30,891.54",
            "MAIN_reportAmt": "5,126.46",
            "M_A_beId": "1",
            "M_A_iniAmt": "4,600.00",
            "MAIN_AIDesc": "217315VEN (SC)",
            "M_A_alAmt": "3,945.28",
            "MAIN_AICode": "217315VEN",
            "MAIN_AIId": "105",
            "M_A_id": "16",
            "M_A_rate": "7.83000000",
            "M_A_beId_code": "JC-AA",
            "MAIN_AIType": "ven"
        }
    ]
}

ebi1

# 读取EBI数据：应付账款交易列表

# 一、接口描述

​ 用于执行EBI[应付账款交易列表]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "MAINAPTRAN_A_ttlDisc": "0.00",
            "aiM18ReservedCol_dataIndex": 1,
            "MAINAPTRAN_A_code": "AP_211230",
            "MAINAPTRAN_A_id": "109",
            "MAIN_reportAmt": "260.00",
            "MAIN_reportTtlDisc": "0.00",
            "MAINAPTRAN_A_rate": "1.30000000",
            "MAINAPTRAN_A_curId_desc__lang": "CNY",
            "MAINAPTRAN_A_ttlCharge": "200.00",
            "MAIN_AIDesc": "",
            "MAIN_reportTtlCharge": "260.00",
            "MAIN_AICode": "2021125VEN",
            "MAIN_AIId": "1627",
            "MAINAPTRAN_A_beId": "1",
            "MAIN_reportDepoAmt": "0.00",
            "RCUR_A_sym": "HK$",
            "MAINAPTRAN_A_beId_code": "JC-AA",
            "MAINAPTRAN_A_amt": "200.00",
            "MAINAPTRAN_A_depoAmt": "0.00",
            "MAIN_AIType": "ven",
            "MAINAPTRAN_A_tDate": "2021 Dec 30"
        }
    ]
}

ebi1

# 读取EBI数据：应付账款交易报告

# 一、接口描述

​ 用于执行EBI[应付账款交易报告]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "aiM18ReservedCol_dataIndex": 1,
            "APTRANT_A_particular": "",
            "MAINAPTRAN_A_code": "AP_211230",
            "MAINAPTRAN_A_id": "109",
            "MAIN_reportAmt": "260.00",
            "MAIN_reportTtlDisc": "0.00",
            "MAIN_reportFooterAmt": "260.00",
            "APTRANT_A_accDesc": "Fee",
            "MAINAPTRAN_A_rate": "1.30000000",
            "MAINAPTRAN_A_curId_desc__lang": "CNY",
            "MAIN_AIDesc": "",
            "MAIN_reportTtlCharge": "260.00",
            "MAIN_AICode": "2021125VEN",
            "MAIN_AIId": "1627",
            "MAINAPTRAN_A_beId": "1",
            "MAIN_reportDepoAmt": "0.00",
            "RCUR_A_sym": "HK$",
            "APTRANT_A_c_d": "加",
            "APTRANT_A_amt": "200.00",
            "MAINAPTRAN_A_beId_code": "JC-AA",
            "ACCCODE_A_code": "1004",
            "MAIN_AIType": "ven",
            "MAINAPTRAN_A_tDate": "2021 Dec 30",
            "ACCCODE_A_id": "22"
        }
    ]
}

ebi1

# 读取EBI数据：应付账款账龄分析表（按应付对象和天数）

# 一、接口描述

​ 用于执行EBI[应付账款账龄分析表（按应付对象和天数）]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "MAIN_iPostClRep": "0.00",
            "MAIN_iPostClRepPer": "0.00",
            "CUR_A_sym": "HK$",
            "MAIN_depoAmt": "0.00",
            "aiM18ReservedCol_dataIndex": 1,
            "BE_A_id": "80",
            "MAIN_ePostClRepPer": "0.00",
            "MAIN_forRate": "1.00000000",
            "MAIN_reportOutAmt5": "0.00",
            "MAIN_reportOutAmt4": "0.00",
            "MAIN_outAmt": "10,000.00",
            "MAIN_reportOutAmt3": "0.00",
            "MAIN_AIDesc": "",
            "MAIN_reportOutAmt2": "0.00",
            "MAIN_reportOutAmt1": "0.00",
            "MAIN_AICode": "PB",
            "MAIN_AIId": "96",
            "BE_A_code": "AC",
            "MAIN_AIType": "ven",
            "MAIN_ePostClRep": "0.00"
        }
    ]
}

ebi1

# 读取EBI数据：应付账款账龄分析表（按应付对象和月份）

# 一、接口描述

​ 用于执行EBI[应付账款账龄分析表（按应付对象和月份）]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "MAIN_iPostClRep": "0.00",
            "MAIN_iPostClRepPer": "0.00",
            "CUR_A_sym": "HK$",
            "MAIN_depoAmt": "0.00",
            "aiM18ReservedCol_dataIndex": 1,
            "BE_A_id": "80",
            "MAIN_ePostClRepPer": "0.00",
            "MAIN_forRate": "1.00000000",
            "MAIN_reportOutAmt5": "0.00",
            "MAIN_reportOutAmt4": "0.00",
            "MAIN_outAmt": "10,000.00",
            "MAIN_reportOutAmt3": "0.00",
            "MAIN_AIDesc": "",
            "MAIN_reportOutAmt2": "0.00",
            "MAIN_reportOutAmt1": "0.00",
            "MAIN_AICode": "PB",
            "MAIN_AIId": "96",
            "BE_A_code": "AC",
            "MAIN_AIType": "ven",
            "MAIN_ePostClRep": "0.00"
        }
    ]
}

ebi1

# 读取EBI数据：应付账款账龄分析表（按发票和天数）

# 一、接口描述

​ 用于执行EBI[应付账款账龄分析表（按发票和天数）]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "MAIN_tranType": "pi",
            "MAIN_outAmt5": "0.00",
            "MAIN_outAmt4": "0.00",
            "MAIN_outAmt3": "0.00",
            "MAIN_outAmt2": "0.00",
            "aiM18ReservedCol_dataIndex": 1,
            "MAIN_outAmt1": "0.00",
            "MAIN_settleId": "0",
            "MAIN_reportInvAmt": "10,000.00",
            "MAIN_invId": "74",
            "MAIN_tDate": "2020 Dec 31",
            "MAIN_reportOutAmt5": "0.00",
            "MAIN_reportOutAmt4": "0.00",
            "MAIN_AIDesc": "",
            "MAIN_rate": "1.00000000",
            "RCUR_A_sym": "HK$",
            "MAIN_ce01ModuleMess": "",
            "MAIN_tranTypeMess": "采购发票",
            "MAIN_AIType": "ven",
            "MAIN_settleCode": "",
            "CUR_A_sym": "HK$",
            "MAIN_reportOutAmt": "10,000.00",
            "MAIN_invCode": "PI20110009",
            "MAIN_settleMess": "未核销",
            "MAIN_invAmt": "10,000.00",
            "MAIN_outAmt": "10,000.00",
            "MAIN_reportOutAmt3": "0.00",
            "MAIN_reportBal": "0.00",
            "MAIN_reportOutAmt2": "0.00",
            "MAIN_reportOutAmt1": "0.00",
            "BEDEPT_A_id": "80",
            "MAIN_AICode": "PB",
            "MAIN_AIId": "96",
            "MAIN_cpDate": "2020 Dec 31",
            "MAIN_settleAmt": "0.00",
            "BEDEPT_A_code": "AC",
            "MAIN_ce01Module": "",
            "MAIN_bal": "0.00"
        }
    ]
}

ebi1

# 读取EBI数据：应付账款账龄分析表（按发票和月份）

# 一、接口描述

​ 用于执行EBI[应付账款账龄分析表（按发票和月份）]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "MAIN_tranType": "pi",
            "aiM18ReservedCol_dataIndex": 1,
            "MAIN_invId": "74",
            "MAIN_tDate": "2020 Dec 31",
            "MAIN_reportOutAmt5": "0.00",
            "MAIN_reportOutAmt4": "0.00",
            "MAIN_AIDesc": "",
            "MAIN_rate": "1.00000000",
            "RCUR_A_sym": "HK$",
            "MAIN_tranTypeMess": "采购发票",
            "MAIN_AIType": "ven",
            "CUR_A_sym": "HK$",
            "MAIN_reportOutAmt": "10,000.00",
            "MAIN_invCode": "PI20110009",
            "MAIN_settleMess": "未核销",
            "MAIN_invAmt": "10,000.00",
            "MAIN_outAmt": "10,000.00",
            "MAIN_reportOutAmt3": "0.00",
            "MAIN_reportOutAmt2": "0.00",
            "MAIN_reportOutAmt1": "0.00",
            "BEDEPT_A_id": "80",
            "MAIN_AICode": "PB",
            "MAIN_AIId": "96",
            "MAIN_cpDate": "2020 Dec 31",
            "BEDEPT_A_code": "AC",
            "MAIN_bal": "0.00"
        }
    ]
}

ebi1

# 读取EBI数据：供应商订单订金往来报告

# 一、接口描述

​ 用于执行EBI[供应商订单订金往来报告]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "CUR_A_sym": "HK$",
            "MAIN_orderId": "0",
            "MAIN_orderTypeMess": "",
            "MAIN_orderDate": "",
            "aiM18ReservedCol_dataIndex": 1,
            "MAIN_orderCode": "",
            "MAIN_balDesc": "",
            "MAIN_tDate": "2021 Dec 29",
            "MAIN_repDrAmt": "242.00",
            "MAIN_AICode": "2021125VEN",
            "MAIN_AIId": "1627",
            "MAIN_id": "145",
            "MAIN_orderType": "",
            "MAIN_repBal": "242.00",
            "MAIN_repCrAmt": "0.00",
            "MAIN_AIType": "ven",
            "MAIN_ce01Module": "payReg",
            "MAIN_code": "PET21120064"
        }
    ]
}

ebi1

# 读取EBI数据：应付账款及订金往来报告

# 一、接口描述

​ 用于执行EBI[应付账款及订金往来报告]，返回EBI数据

# 二、接口调用说明

​ 1、请求说明

URL http://[server]/jsf/rfws/ebiWidget/loadReport
http请求方式 GET
编码类型 UTF-8

​ 2、URL参数

参数 类型 必填 说明
authorization String(Header) 是 OAuth获取的Access Token
client_id String(Header) 是 aiM18[授权应用列表]中的Client ID
formatId long(Query) 是 通过EBI接口获取到formatId
beId long(Query) 否 企业法人的ID。若不传，则查询所有有权限的BE数据
offset int(Query) 否 返回结果的开始行
rows int(Query) 否 返回结果的结束行

​ 3、请求示例

	CloseableHttpClient client = HttpClientBuilder.create().build();
	CloseableHttpResponse res = null;
	try {

		String url = "http://" + HostIP + ":" + HostPort + "/jsf/rfws/ebiWidget/loadReport";
		String param = "&formatId=" + formatId;

		HttpGet get = new HttpGet(url + "?" + param);
		get.addHeader("authorization", access_token);
		get.addHeader("client_id", ClientID);
		res = client.execute(get);
		if (res.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
			JSONObject json = JSON.parseObject(EntityUtils.toString(res.getEntity()));

			System.out.println(json);
		}

		get.releaseConnection();
	} catch (Exception e) {
		e.printStackTrace();
	} finally {
		try {
			if (res != null) {
				res.close();
			}
			if (client != null) {
				client.close();
			}
		} catch (Exception ex) {
			ex.printStackTrace();
		}
	}

​ 4、返回示例

{
    "size": 1,
    "rows": [
        {
            "CUR_A_sym": "CNY",
            "MAIN_APDrAmt": "0.00",
            "aiM18ReservedCol_dataIndex": 1,
            "AI1_A_code": "",
            "MAIN_DepDrAmt": "0.00",
            "MAIN_tDate": "2021 Dec 29",
            "MAIN_rate": "1.21000000",
            "MAIN_AICode": "2021125VEN",
            "MAIN_AIId": "1627",
            "MAIN_id": "145",
            "MAIN_accDesc": "",
            "MAIN_tranNo": "PET21120064",
            "MAIN_ce01ModuleMess": "付款单",
            "MAIN_DepCrAmt": "242.00",
            "MAIN_amt": "200.00",
            "MAIN_DepNetAmt": "242.00",
            "MAIN_APCrAmt": "0.00",
            "MAIN_AIType": "ven",
            "MAIN_ce01Module": "payReg",
            "MAIN_APNetAmt": "0.00"
        }
    ]
}

ebi1

Last Updated: 2024/09/13, 09:57:11
财务
委外代销

← 委外代销→

Theme by Vdoing | Copyright © 1990-2024 Multiable | MIT License