...
Code Block |
---|
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
StringArray sa60 = new StringArray();
sa60.getItem().add("9");
sa60.getItem().add("110001");
sa60.getItem().add("18888");
StringArray sa61 = new StringArray();
sa61.getItem().add("9");
sa61.getItem().add("111200");
sa61.getItem().add("18213");
StringArray sa62 = new StringArray();
sa62.getItem().add("9");
sa62.getItem().add("111200");
sa62.getItem().add("182");
StringArray sa63 = new StringArray();
sa63.getItem().add("");
sa63.getItem().add("");
sa63.getItem().add("");
List<Fs2KFSAccountDetails> resultList6 = ds.translateFSAccountFunds(Arrays.asList(sa60,sa61,sa62,sa63));
if (resultList6 != null) {
for (Iterator i = resultList6.iterator(); i.hasNext();) {
Fs2KFSAccountDetails element = (Fs2KFSAccountDetails)i.next();
System.out.println("\t" + element.getFsLocationCode() + "/" + element.getFsAccountCode() + "/" + element.getFsFundCode() + " : " + element.getKfsChartCode() + "/" + element.getKfsAcctNumber());
}
} else {
System.out.println("something bad happened...please check your query");
} |
isValidKFSSubAccount(List of Chart, Account, SubAccount)
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(7) | 1234567 |
DB Query
Code Block |
---|
select * FROM ca_sub_acct_t a where a.account_nbr='pKFSAccountCode' AND a.fin_coa_cd='pChartCode' AND a.sub_acct_nbr='pKFSSubAccountCode' AND a.SUB_ACCT_ACTV_CD <> 'N' |
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 (7) | 1234567 |
isValid | Is the Chart/Account Active for that effective date (or today)? | boolean | true |
WS Example
Request
Response
Java Client Example
getValidKFSSubAccounts(List of Chart, KFSAccount, KFSSubAccount)
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(7) | 1234567 |
DB Query
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' |
| | | |
WS Example
Request
Response
Java Client Example
Code Block |
---|
SELECT fin_coa_cd, account_nbr, account_nm, sub_acct_nbr, sub_acct_nm FROM ca_sub_acct_t WHERE SUB_ACCT_ACTV_CD <> 'N' |
getAllKFSSubAccounts()
No input parameter, ALL active KFS subaccount details will be returned in result set.
DB Query
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' |
| | | |
WS Example
Request
Response
Java Client Example
...