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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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": ""
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}
# 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"
}
]
}