...
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
UNIV_FISCAL_YR = '2013' AND
FIN_COA_CD = 'IR' AND
UC_LOC_CD = '9' |
...
DB Parameter | Java Parameter | Description | Data Type | Example |
---|---|---|---|---|
UC_LOC_CD | fsLocationCode | FS Location Code | String(1) | 9 |
UC_SUB_CD | fsSubCode | FS Sub Code | String(2) | 9H |
UC_OBJECT_CD | fsObjCode | FS Object Code | String(4) | 3800 |
UC_ACCT_NBR | fsAccountCode | FS Account Number | String(6) | 803000 |
UNIV_FISCAL_YR | kfsFiscalYear | KFS Fiscal Year | String (4) | 2013 |
FIN_COA_CD | kfsChartCode | KFS Chart Code | String (2) | IR |
FIN_OBJECT_CD | kfsObjCode | KFS Object Code | String (4) | 3800 |
...
Code Block |
---|
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:Body> <ns2:getAllFSAccountToKFSObjectResponse xmlns:ns2="http://www.adcom.uci.edu"> <return> <fsAccountCode>223609<<fsAccountCode>803099</fsAccountCode> <fsLocationCode>9</fsLocationCode> <fsObjCode>3899</fsObjCode> <fsSubCode>9H</fsSubCode> <kfsChartCode>IR</kfsChartCode> <kfsFiscalYear>2013</kfsFiscalYear> <kfsObjCode>R010<<kfsObjCode>3899</kfsObjCode> </return> <return> <fsAccountCode>223610<<fsAccountCode>225160</fsAccountCode> <fsLocationCode>9</fsLocationCode> <kfsChartCode>IR</kfsChartCode> <kfsFiscalYear>2013</kfsFiscalYear> <kfsObjCode>R010<<kfsObjCode>R016</kfsObjCode> </return> <return> <fsAccountCode>223611<<fsAccountCode>225161</fsAccountCode> <fsLocationCode>9</fsLocationCode> <kfsChartCode>IR</kfsChartCode> <kfsFiscalYear>2013</kfsFiscalYear> <kfsObjCode>R010<<kfsObjCode>R016</kfsObjCode> </return> ... </ns2:getAllFSAccountToKFSObjectResponse> </soap:Body> </soap:Envelope> |
...
Code Block |
---|
DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
AccountToObjectTranslateParameters atop = new AccountToObjectTranslateParameters();
atop.setFsLocationCode("9");
atop.setKfsFiscalYear("2013");
atop.setKfsChartCode("IR");
List<FsAccount2KFSObjectDetails> resultList = server.getAllFSAccountToKFSObject(atop);
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");
} |