aiM18 Developer Center aiM18 Developer Center
DOC Home
  • Platform

    • Overview
    • Frontend Framework
    • Backend Framework
    • EBI Development
    • JSF Components
    • BPM Extension Interface
    • Telescope Extension Interface
    • Mobile App Setup
  • ERP

    • ERP EJB Interfaces
    • ERP XML Config Files
    • ERP Decorators (Frontend Interfaces)
  • Tutorial

    • Setup Development Environment
    • Sample App
  • Platform

    • Authentication
    • Common JSON Objects
    • Core Services
    • EBI Services
  • Enterprise Resource Planning
  • Human Capital Management
  • Business Process Management
  • Schedule Management
  • Document Management
  • Tutorial

    • Interacting with aiM18 via webservices
Tutorial
GitHub (opens new window)
DOC Home
  • Platform

    • Overview
    • Frontend Framework
    • Backend Framework
    • EBI Development
    • JSF Components
    • BPM Extension Interface
    • Telescope Extension Interface
    • Mobile App Setup
  • ERP

    • ERP EJB Interfaces
    • ERP XML Config Files
    • ERP Decorators (Frontend Interfaces)
  • Tutorial

    • Setup Development Environment
    • Sample App
  • Platform

    • Authentication
    • Common JSON Objects
    • Core Services
    • EBI Services
  • Enterprise Resource Planning
  • Human Capital Management
  • Business Process Management
  • Schedule Management
  • Document Management
  • Tutorial

    • Interacting with aiM18 via webservices
Tutorial
GitHub (opens new window)
  • base

    • Authentication
    • Common JSON Objects
    • Core Services
    • Enduser-driven Business Intelligence
    • Error Code Description
  • Business Process Management

    • Business Process Management
  • Schedule Management

    • Schedule Management
  • Document Management System

    • Document Management System
  • Enterprise Resource Planning

    • README for ERP
    • Master Data
    • Sales
    • Purchase
    • Stock
    • Consignment
    • Subcontract
    • Production
    • Retail
    • Retail Stored Value
    • Warehouse Management Solution
    • Retail and Third-Party Logistics
    • Trading and Finance
    • Accounting
    • Accounting EBI
      • Load EBI data:Journal List
        • 一、Description
        • 二、API Detail
      • Load EBI data:Account Ledger
        • 一、Description
        • 二、API Detail
      • Load EBI data:AR Initial Balance List
        • 一、Description
        • 二、API Detail
      • Load EBI data:Deposit Receipt Initial Balance List
        • 一、Description
        • 二、API Detail
      • Load EBI data:AR Transaction List
        • 一、Description
        • 二、API Detail
      • Load EBI data:AR Transaction Report
        • 一、Description
        • 二、API Detail
      • Load EBI data:AR Aging Report by Debtor in Day
        • 一、Description
        • 二、API Detail
      • Load EBI data:AR Aging Report by Debtor in Month
        • 一、Description
        • 二、API Detail
      • Load EBI data:AR Aging Report by Invoice in Day
        • 一、Description
        • 二、API Detail
      • Load EBI data:AR Aging Report by Invoice in Month
        • 一、Description
        • 二、API Detail
      • Load EBI data:Deposit Movement Report Per Customer Per Order
        • 一、Description
        • 二、API Detail
      • Load EBI data:AR & Deposit Receipt Movement Report
        • 一、Description
        • 二、API Detail
      • Load EBI data:AP Initial Balance List
        • 一、Description
        • 二、API Detail
      • Load EBI data:Deposit Payment Initial Balance List
        • 一、Description
        • 二、API Detail
      • Load EBI data:AP Transaction List
        • 一、Description
        • 二、API Detail
      • Load EBI data:AP Transaction Report
        • 一、Description
        • 二、API Detail
      • Load EBI data:AP Aging Report by Creditor in Day
        • 一、Description
        • 二、API Detail
      • Load EBI data:AP Aging Report by Creditor in Month
        • 一、Description
        • 二、API Detail
      • Load EBI data:AP Aging Report by Invoice in Day
        • 一、Description
        • 二、API Detail
      • Load EBI data:AP Aging Report by Invoice in Month
        • 一、Description
        • 二、API Detail
      • Load EBI data:Deposit Movement Report Per Vendor Per Order
        • 一、Description
        • 二、API Detail
      • Load EBI data:AP & Deposit Payment Movement Report
        • 一、Description
        • 二、API Detail
  • Human Capital Management

    • README for HCM
    • Attendance Management
    • Hong Kong Labour Law Compliance
    • Leave Management
    • Organization And Personnel Management
    • Payroll Management
    • PRC Labour Law Compliance
    • Appraisal Management
    • Attendance
    • Casual Labour
    • Personnel
    • Leave
    • Medical Claim Management
    • Payroll
    • Recruitment
    • Training & Sponsorship
  • Web Services
  • Enterprise Resource Planning
Multiable
2024-02-23
目录

Accounting EBI

# 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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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 aiM18
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

Last Updated: 2025/05/29, 08:57:55
Accounting
README for HCM

← Accounting README for HCM→

Theme by Vdoing | Copyright © 1990-2025 Multiable | MIT License
  • 跟随系统
  • 浅色模式
  • 深色模式
  • 阅读模式