M18 Developer Center

# Load EBI data：Journal List

# 一、Description

​ Usage: Run EBI[Journal List]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "T_A_particular": "",
            "T_A_refNo": "",
            "T_A_tDate": "2020 Feb 01",
            "ACCT_A_id": "50",
            "T_A_rate": "1.00000000",
            "M18ReservedCol_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

# Load EBI data：Account Ledger

# 一、Description

​ Usage: Run EBI[Account Ledger]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "CUR_A_sym": "HK$",
            "ACCT_A_id": "1283",
            "M18ReservedCol_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

# Load EBI data：AR Initial Balance List

# 一、Description

​ Usage: Run EBI[AR Initial Balance List]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "M_A_code": "233827ARIB",
            "M_A_amt": "5,000.00",
            "M18ReservedCol_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

# Load EBI data：Deposit Receipt Initial Balance List

# 一、Description

​ Usage: Run EBI[Deposit Receipt Initial Balance List]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "M_A_code": "217315DRIB",
            "M_A_amt": "17,600.00",
            "M18ReservedCol_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

# Load EBI data：AR Transaction List

# 一、Description

​ Usage: Run EBI[AR Transaction List]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "MAINARTRAN_A_rate": "1.00000000",
            "MAINARTRAN_A_id": "394",
            "MAINARTRAN_A_ttlCharge": "1,000.00",
            "M18ReservedCol_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

# Load EBI data：AR Transaction Report

# 一、Description

​ Usage: Run EBI[AR Transaction Report]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "MAINARTRAN_A_rate": "1.00000000",
            "MAINARTRAN_A_id": "394",
            "ARTRANT_A_c_d": "加",
            "ARTRANT_A_amt": "1,000.00",
            "M18ReservedCol_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

# Load EBI data：AR Aging Report by Debtor in Day

# 一、Description

​ Usage: Run EBI[AR Aging Report by Debtor in Day]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "MAIN_iPostClRep": "0.00",
            "MAIN_iPostClRepPer": "0.00",
            "CUR_A_sym": "RMB",
            "MAIN_depoAmt": "0.00",
            "M18ReservedCol_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

# Load EBI data：AR Aging Report by Debtor in Month

# 一、Description

​ Usage: Run EBI[AR Aging Report by Debtor in Month]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "M18ReservedCol_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

# Load EBI data：AR Aging Report by Invoice in Day

# 一、Description

​ Usage: Run EBI[AR Aging Report by Invoice in Day]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "MAIN_iPostClRep": "0.00",
            "MAIN_iPostClRepPer": "0.00",
            "CUR_A_sym": "RMB",
            "MAIN_depoAmt": "0.00",
            "M18ReservedCol_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

# Load EBI data：AR Aging Report by Invoice in Month

# 一、Description

​ Usage: Run EBI[AR Aging Report by Invoice in Month]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "MAIN_outAmt5": "0.00",
            "MAIN_outAmt4": "0.00",
            "MAIN_outAmt3": "0.00",
            "MAIN_outAmt2": "0.00",
            "M18ReservedCol_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

# Load EBI data：Deposit Movement Report Per Customer Per Order

# 一、Description

​ Usage: Run EBI[Deposit Movement Report Per Customer Per Order]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "CUR_A_sym": "HK$",
            "MAIN_orderId": "0",
            "MAIN_orderTypeMess": "",
            "MAIN_orderDate": "",
            "M18ReservedCol_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

# Load EBI data：AR & Deposit Receipt Movement Report

# 一、Description

​ Usage: Run EBI[AR & Deposit Receipt Movement Report]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "MAIN_ARCrAmt": "0.00",
            "M18ReservedCol_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

# Load EBI data：AP Initial Balance List

# 一、Description

​ Usage: Run EBI[AP Initial Balance List]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "M_A_code": "217315APIB",
            "M_A_amt": "5,000.00",
            "M18ReservedCol_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

# Load EBI data：Deposit Payment Initial Balance List

# 一、Description

​ Usage: Run EBI[Deposit Payment Initial Balance List]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "M_A_code": "217315DPIB",
            "M_A_amt": "654.72",
            "M18ReservedCol_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

# Load EBI data：AP Transaction List

# 一、Description

​ Usage: Run EBI[AP Transaction List]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "MAINAPTRAN_A_ttlDisc": "0.00",
            "M18ReservedCol_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

# Load EBI data：AP Transaction Report

# 一、Description

​ Usage: Run EBI[AP Transaction Report]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "M18ReservedCol_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

# Load EBI data：AP Aging Report by Creditor in Day

# 一、Description

​ Usage: Run EBI[AP Aging Report by Creditor in Day]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "MAIN_iPostClRep": "0.00",
            "MAIN_iPostClRepPer": "0.00",
            "CUR_A_sym": "HK$",
            "MAIN_depoAmt": "0.00",
            "M18ReservedCol_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

# Load EBI data：AP Aging Report by Creditor in Month

# 一、Description

​ Usage: Run EBI[AP Aging Report by Creditor in Month]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "MAIN_iPostClRep": "0.00",
            "MAIN_iPostClRepPer": "0.00",
            "CUR_A_sym": "HK$",
            "MAIN_depoAmt": "0.00",
            "M18ReservedCol_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

# Load EBI data：AP Aging Report by Invoice in Day

# 一、Description

​ Usage: Run EBI[AP Aging Report by Invoice in Day]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "MAIN_tranType": "pi",
            "MAIN_outAmt5": "0.00",
            "MAIN_outAmt4": "0.00",
            "MAIN_outAmt3": "0.00",
            "MAIN_outAmt2": "0.00",
            "M18ReservedCol_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

# Load EBI data：AP Aging Report by Invoice in Month

# 一、Description

​ Usage: Run EBI[AP Aging Report by Invoice in Month]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "MAIN_tranType": "pi",
            "M18ReservedCol_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

# Load EBI data：Deposit Movement Report Per Vendor Per Order

# 一、Description

​ Usage: Run EBI[Deposit Movement Report Per Vendor Per Order]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "CUR_A_sym": "HK$",
            "MAIN_orderId": "0",
            "MAIN_orderTypeMess": "",
            "MAIN_orderDate": "",
            "M18ReservedCol_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

# Load EBI data：AP & Deposit Payment Movement Report

# 一、Description

​ Usage: Run EBI[AP & Deposit Payment Movement Report]，return EBI data

# 二、API Detail

​ 1、Request URL

URL http://[server]/jsf/rfws/ebiWidget/loadReport
HTTP Method GET
Encode UTF-8

​ 2、URL Parameters

Parameter Type Required Remarks
authorization String(Header) Yes Access Token obtained via Oauth2
client_id String(Header) Yes Client ID from [OAuth Applications], generated by the M18
formatId long(Query) Yes Format ID fetched from another API
beId long(Query) No Business Entity ID，If not specified, query all authorized Business Entity data.
offset int(Query) No Resultset offset : start index
rows int(Query) No Resultset offset : end index

​ 3、Request Sample

	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、Response Sample

{
    "size": 1,
    "rows": [
        {
            "CUR_A_sym": "CNY",
            "MAIN_APDrAmt": "0.00",
            "M18ReservedCol_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

← Trading and Finance →