Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 ParameterJava ParameterDescriptionData TypeExample
UC_LOC_CD
fsLocationCodeFS Location CodeString(1)9
UC_SUB_CD
fsSubCodeFS Sub CodeString(2)9H
UC_OBJECT_CD
fsObjCodeFS Object CodeString(4)3800
UC_ACCT_NBR
fsAccountCodeFS Account NumberString(6)803000
UNIV_FISCAL_YR
kfsFiscalYearKFS Fiscal YearString (4)2013
FIN_COA_CD
kfsChartCodeKFS Chart CodeString (2)IR
FIN_OBJECT_CD
kfsObjCodeKFS Object CodeString (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");
}