isValidKFSSubAccounts(List of (kfsChartCode, kfsAcctNumber, kfsSubAcctNumber) )
Input Specifications
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|
| 0 | kfsChartCode | KFS Chart Code | Yes | String(2) | IR |
| 1 | kfsAcctNumber | KFS Account Number | Yes | String(7) | 1234567 |
| 2 | kfsSubAcctNumber | KFS SubAccount Number | Yes | String(6) | 12345 |
DB Query
| Code Block |
|---|
SELECT
a.FIN_COA_CD,
a.ACCOUNT_NBR,
a.SUB_ACCT_NBR,
a.SUB_ACCT_ACTV_CD
FROM ca_sub_acct_t a
WHERE
a.SUB_ACCT_ACTV_CD <> 'N' AND
(
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='EXP01') OR
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='EXP02') OR
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='XXXX')
); |
Result Schema: A list of following elements (SubAccountValidation.java)
| Parameter | Description | Data Type | Example |
|---|
| kfsChartCode | KFS Chart Code | String (2) | IR |
| kfsAcctNumber | KFS Account Number | String (7) | 1234567 |
| kfsSubAcctNumber | KFS SubAccount Number | String (5) | 12345 |
| isValid | Is the SubAccount Active | boolean | true |
WS Example
Request
Response
Java Client Example
| Code Block |
|---|
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
System.out.println("\nWSClient-isValidKFSSubAccounts()");
StringArray sa250 = new StringArray();
sa250.getItem().add("IR");
sa250.getItem().add("1001783");
sa250.getItem().add("EXP01");
StringArray sa251 = new StringArray();
sa251.getItem().add("IR");
sa251.getItem().add("1001783");
sa251.getItem().add("EXP02");
StringArray sa252 = new StringArray();
sa252.getItem().add("IR");
sa252.getItem().add("1001783");
sa252.getItem().add("XXXX");
List<SubAccountValidation> resultList25 = ds.isValidKFSSubAccounts(Arrays.asList(sa250, sa251, sa252));
if (resultList25 != null) {
for (Iterator i = resultList25.iterator(); i.hasNext();) {
SubAccountValidation element = (SubAccountValidation)i.next();
System.out.println("\t" + element.getKfsChartCode() + "/" + element.getKfsAcctNumber() + "/" + element.getKfsSubAcctNumber() + " : " + element.isValid());
}
} else {
System.out.println("something bad happened...please check your query");
} |
...
getValidKFSSubAccounts(List of (kfsChartCode, kfsAcctNumber, kfsSubAcctNumber))
Input Specifications
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|
| 0 | kfsChartCode | KFS Chart Code | Yes | String(2) | IR |
| 1 | kfsAcctNumber | KFS Account Number | Yes | String(7) | 1234567 |
| 2 | kfsSubAcctNumber | KFS SubAccount Number | Yes | String(5) | 1234567 |
DB Query
| Code Block |
|---|
SELECT
a.FIN_COA_CD,
a.ACCOUNT_NBR,
a.SUB_ACCT_NBR,
a.SUB_ACCT_NM,
a.FIN_RPT_CHRT_CD,
a.FIN_RPT_ORG_CD,
a.FIN_RPT_CD
FROM ca_sub_acct_t a
WHERE
a.SUB_ACCT_ACTV_CD <> 'N' AND
(
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='EXP01') OR
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='EXP02') OR
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='XXXX')
); |
Result Schema: A list of following elements (KFSSubAccountDetails.java)
| Parameter | Description | Data Type | Example |
|---|
| kfsChartCode | KFS Chart Code | String (2) | IR |
| kfsAcctNumber | KFS Account Number | String (7) | 1234567 |
| kfsSubAcctNumber | KFS SubAccount Number | String (5) | 1234567 |
| kfsSubAcctName | KFS SubAccount Name | String (40) | |
| kfsReportToChartCode | KFS Reports To Chart Code | String (2) | |
| kfsReportToAcctNumber | KFS Reports To Account Number | String (4) | |
| kfsReportCode | KFS Reports Code | String (10) | |
WS Example
Request
Response
Java Client Example
| Code Block |
|---|
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
System.out.println("\nWSClient-getValidKFSSubAccounts()");
StringArray sa260 = new StringArray();
sa260.getItem().add("IR");
sa260.getItem().add("1001783");
sa260.getItem().add("EXP01");
StringArray sa261 = new StringArray();
sa261.getItem().add("IR");
sa261.getItem().add("1001783");
sa261.getItem().add("EXP02");
StringArray sa262 = new StringArray();
sa262.getItem().add("IR");
sa262.getItem().add("1001783");
sa262.getItem().add("XXXX");
List<SubAccountDetails> resultList26 = ds.getValidKFSSubAccounts(Arrays.asList(sa260, sa261, sa262));
if (resultList26 != null) {
for (Iterator i = resultList26.iterator(); i.hasNext();) {
SubAccountDetails element = (SubAccountDetails)i.next();
System.out.println("\t" + element.getKfsChartCode() + "/" + element.getKfsAcctNumber() + "/" + element.getKfsSubAcctNumber() + " : " + element.getKfsSubAcctName());
}
} else {
System.out.println("something bad happened...please check your query");
} |
...
getAllKFSSubAccounts()
No input parameter, ALL active KFS subaccount details will be returned in result set.
DB Query
| Code Block |
|---|
SELECT
a.FIN_COA_CD,
a.ACCOUNT_NBR,
a.SUB_ACCT_NBR,
a.SUB_ACCT_NM,
a.FIN_RPT_CHRT_CD,
a.FIN_RPT_ORG_CD,
a.FIN_RPT_CD
FROM ca_sub_acct_t a
WHERE
a.SUB_ACCT_ACTV_CD <> 'N'; |
Result Schema: same as getValidKFSSubAccounts()
WS Example
Request
Response
Java Client Example
| Code Block |
|---|
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
System.out.println("\nWSClient--getAllKFSSubAccounts()================================");
List<SubAccountDetails> resultList27 = ds.getAllKFSSubAccounts();
if (resultList27 != null) {
System.out.println("getAllSubAccount-total size: " + resultList27.size());
System.out.println("getAllSubAccount-1st item ChartCode / AcctNum / SubAcctNum: SubAcctName" + ((SubAccountDetails)resultList27.get(0)).getKfsChartCode() + " / " + ((SubAccountDetails)resultList27.get(0)).getKfsAcctNumber() + " / " + ((SubAccountDetails)resultList27.get(0)).getKfsSubAcctNumber() + ":" + ((SubAccountDetails)resultList27.get(0)).getKfsSubAcctName());
} else {
System.out.println("something bad happened...please check your query");
} |