...
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)
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
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
Code Block |
---|
|
Response
Code Block |
---|
|
Java Client Example
Code Block |
---|
|
...
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 (FS2KFSAccountDetails.java)
Parameter | Description | Data Type | Example |
---|---|---|---|
fsLocationCode | The FS location code | String (2) | 9 |
fsAccountCode | The FS accounts code | String (6) | 110001 |
fsFundCode | The FS fund code | String (5) | 111200 |
kfsChartCode | KFS Chart Code | String (2) | 'IR' |
kfsAcctNumber | KFS Account Number | String (7) | '1234567' |
WS Example
Request
Response
Java Client Example
Code Block |
---|
|
...
getAllKFSSubAccounts()
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 (FS2KFSAccountDetails.java)
Parameter | Description | Data Type | Example |
---|---|---|---|
fsLocationCode | The FS location code | String (2) | 9 |
fsAccountCode | The FS accounts code | String (6) | 110001 |
fsFundCode | The FS fund code | String (5) | 111200 |
kfsChartCode | KFS Chart Code | String (2) | 'IR' |
kfsAcctNumber | KFS Account Number | String (7) | '1234567' |
WS Example
Request
Response
Java Client Example
Code Block |
---|
|
...