...
| Code Block |
|---|
SELECT UC_LOC_CD, UC_SUB_CD, UC_OBJECT_CD, UC_ACCT_NBR, CONVERT(varchar(4), UNIV_FISCAL_YR) AS UNIV_FISCAL_YR, FIN_COA_CD, FIN_OBJECT_CD FROM UCI_CA_OBJECT_CODE_XW_T WHERE ACTIVE_IND <> 'N' AND ( (UC_LOC_CD='9' AND UC_ACCT_NBR='270303803049') OR (UC_LOC_CD='9' AND UC_ACCT_NBR='118747803040') OR (UC_LOC_CD='9' AND UC_ACCT_NBR='112754112756') ); |
Result Schema: A list of following elements (FS2KFSAccountDetails.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| fsLocationCode | The FS location code | String (2) | 9 |
| fsSubCode | The FS Sub code | String(2) | 9H |
| fsObjCode | The FS Object Code | String(4) | 3879 |
| fsAccountCode | The FS accounts code | String (6) | 112754112756 |
| kfsFiscalYear | The KFS Fiscal Year | String (4) | 2013 |
| kfsChartCode | KFS Chart Code | String (2) | IR |
| kfsObjCode | KFS Object Code | String (4) | J321J323 |
WS Example
Request
| Code Block |
|---|
<?xml version="1.0" ?> <S:Envelope xmlns:S="http://schemas.xmlsoap.org/soap/envelope/"> <S:Body> <ns2:translateFSAccountToKFSObject xmlns:ns2="http://www.adcom.uci.edu"> <fsAccountList> <fsAccountCode>270303<<fsAccountCode>803049</fsAccountCode> <fsLocationCode>9</fsLocationCode> </fsAccountList> <fsAccountList> <fsAccountCode>118747<<fsAccountCode>803040</fsAccountCode> <fsLocationCode>9</fsLocationCode> </fsAccountList> <fsAccountList> <fsAccountCode>112754<<fsAccountCode>112756</fsAccountCode> <fsLocationCode>9</fsLocationCode> </fsAccountList> </ns2:translateFSAccountToKFSObject> </S:Body> </S:Envelope> |
...
| Code Block |
|---|
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <ns2:translateFSAccountToKFSObjectResponse xmlns:ns2="http://www.adcom.uci.edu"> <return> <fsAccountCode>112754<<fsAccountCode>803049</fsAccountCode> <fsLocationCode>9</fsLocationCode> <fsObjCode>3849</fsObjCode> <fsSubCode>9H</fsSubCode> <kfsChartCode>IR</kfsChartCode> <kfsFiscalYear>2013</kfsFiscalYear> <kfsObjCode>J321<<kfsObjCode>3800</kfsObjCode> </return> <return> <fsAccountCode>270303<<fsAccountCode>803099</fsAccountCode> <fsLocationCode>9</fsLocationCode> <fsObjCode>3899</fsObjCode> <fsSubCode>9H</fsSubCode> <kfsChartCode>IR</kfsChartCode> <kfsFiscalYear>2013</kfsFiscalYear> <kfsObjCode>S832<<kfsObjCode>3899</kfsObjCode> </return> <return> <fsAccountCode>118747<<fsAccountCode>112756</fsAccountCode> <fsLocationCode>9</fsLocationCode> <kfsChartCode>IR</kfsChartCode> <kfsFiscalYear>2013</kfsFiscalYear> <kfsObjCode>L537<<kfsObjCode>J323</kfsObjCode> </return> </ns2:translateFSAccountToKFSObjectResponse> </soap:Body> </soap:Envelope> |
...
| Code Block |
|---|
DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
ArrayList<AccountTranslateParameters> paramList = new ArrayList<AccountTranslateParameters>();
AccountTranslateParameters atp1 = new AccountTranslateParameters();
atp1.setFsLocationCode("9");
atp1.setFsAccountCode("270303803049");
paramList.add(atp1);
AccountTranslateParameters atp2 = new AccountTranslateParameters();
atp2.setFsLocationCode("9");
atp2.setFsAccountCode("118747803099");
paramList.add(atp2);
AccountTranslateParameters atp3 = new AccountTranslateParameters();
atp3.setFsLocationCode("9");
atp3.setFsAccountCode("112754112756");
paramList.add(atp3);
List<FsAccount2KFSObjectDetails> resultList = server.translateFSAccountToKFSObject(paramList);
if (resultList != null) {
for (FsAccount2KFSObjectDetails fod : resultList) {
System.out.println("fsLocationCode : " + fod.getFsLocationCode());
System.out.println("fsSubCode : " + fod.getFsSubCode());
System.out.println("fsObjCode : " + fod.getFsObjCode());
System.out.println("fsAccountCode : " + fod.getFsAccountCode());
System.out.println("kfsFiscalYear : " + fod.getKfsFiscalYear());
System.out.println("kfsChartCode : " + fod.getKfsChartCode());
System.out.println("kfsObjectCode : " + fod.getKfsObjCode());
System.out.println("--------------------------");
}
}
else {
System.out.println("something bad happened...please check your query");
} |