Versions Compared

Version Old Version 113 New Version 114
Changes made by

Jarrod Lannan

Jarrod Lannan

Saved on

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
	(
		(UC_LOC_CD='9' AND UC_ACCT_NBR='803049')
		OR
		119850' and UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR')
        OR
        (UC_LOC_CD='9' AND UC_ACCT_NBR='115181' and UNIV_FISCAL_YR ='803040')
		OR
		 '2013' AND FIN_COA_CD = 'IR')
        OR
        (UC_LOC_CD='9' AND UC_ACCT_NBR='112756')
	);

...

101193' and UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR')
        OR
        (UC_LOC_CD='9' AND UC_ACCT_NBR='229344' and UNIV_FISCAL_YR = '2013' AND FIN_COA_CD = 'IR')
	);

Result Schema: A list of following elements (FS2KFSAccountDetails.java)

...

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>803049<<fsAccountCode>119850</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>803040<<kfsChartCode>IR</fsAccountCode>kfsChartCode>
				<fsLocationCode>9<<kfsFiscalYear>2013</fsLocationCode>kfsFiscalYear>
			</fsAccountList>
			<fsAccountList>
				<fsAccountCode>112756<<fsAccountCode>115181</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<<kfsChartCode>IR</fsAccountList>kfsChartCode>
		</ns2:translateFSAccountToKFSObject>
	</S:Body>
</S:Envelope>
Response
Code Block
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
	<soap:Body>
		<ns2:translateFSAccountToKFSObjectResponse xmlns:ns2="http://www.adcom.uci.edu">		<kfsFiscalYear>2013</kfsFiscalYear>
			</fsAccountList>
			<return><fsAccountList>
				<fsAccountCode>803049<<fsAccountCode>101193</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<fsObjCode>3849</fsObjCode>
				<fsSubCode>9H</fsSubCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>3800</kfsObjCode>
			</return>fsAccountList>
			<return><fsAccountList>
				<fsAccountCode>803099<<fsAccountCode>229344</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<fsObjCode>3899<<kfsChartCode>IR</fsObjCode>kfsChartCode>
				<fsSubCode>9H<<kfsFiscalYear>2013</fsSubCode>kfsFiscalYear>
				<kfsChartCode>IR<</kfsChartCode>fsAccountList>
				<kfsFiscalYear>2013</kfsFiscalYear><fsAccountList>
				<kfsObjCode>3899</kfsObjCode>
			</return><fsAccountCode>229344</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2014</kfsFiscalYear>
			</fsAccountList>
		</ns2:translateFSAccountToKFSObject>
	</S:Body>
</S:Envelope>
Response
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>112756<<fsAccountCode>229344</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>J323<<kfsObjCode>R010</kfsObjCode>
			</return>
			</ns2:translateFSAccountToKFSObjectResponse>
	</soap:Body>
</soap:<return>
				<fsAccountCode>115181</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>L231</kfsObjCode>
			</return>
			<return>
				<fsAccountCode>101193</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>N004</kfsObjCode>
			</return>
			<return>
				<fsAccountCode>119850</fsAccountCode>
				<fsLocationCode>9</fsLocationCode>
				<kfsChartCode>IR</kfsChartCode>
				<kfsFiscalYear>2013</kfsFiscalYear>
				<kfsObjCode>N013</kfsObjCode>
			</return>
		</ns2:translateFSAccountToKFSObjectResponse>
	</soap:Body>
</soap:Envelope>

Java Client Example

Code Block
DWHServerService service DWHServerService service = new DWHServerService();
DWHServer server = service.getDWHServerPort();
ArrayList<AccountToObjectTranslateParameters> paramList = new DWHServerService();
DWHServer server = service.getDWHServerPort();
ArrayList<AccountTranslateParameters> paramList = new ArrayList<AccountTranslateParameters>( ArrayList<AccountToObjectTranslateParameters>();
		
AccountToObjectTranslateParameters atp1 = new AccountToObjectTranslateParameters();
atp1.setFsLocationCode("9");
atp1.setFsAccountCode("119850");
atp1.setKfsChartCode("IR");
atp1.setKfsFiscalYear("2013");
paramList.add(atp1);
		
AccountToObjectTranslateParameters atp2 = new AccountToObjectTranslateParameters();
atp2.setFsLocationCode("9");
atp2.setFsAccountCode("115181");
atp2.setKfsChartCode("IR");
atp2.setKfsFiscalYear("2013");
paramList.add(atp2);
		
AccountTranslateParametersAccountToObjectTranslateParameters atp1atp3 = new AccountTranslateParametersAccountToObjectTranslateParameters();
atp1atp3.setFsLocationCode("9");
atp1atp3.setFsAccountCode("803049("101193");
atp3.setKfsChartCode("IR");
atp3.setKfsFiscalYear("2013");
paramList.add(atp1atp3);
		
AccountTranslateParametersAccountToObjectTranslateParameters atp2atp4 = new AccountTranslateParametersAccountToObjectTranslateParameters();
atp2atp4.setFsLocationCode("9");
atp2atp4.setFsAccountCode("803099"229344");
atp4.setKfsChartCode("IR");
atp4.setKfsFiscalYear("2013");
paramList.add(atp2atp4);
		
AccountTranslateParametersAccountToObjectTranslateParameters atp3atp5 = new AccountTranslateParametersAccountToObjectTranslateParameters();
atp3atp5.setFsLocationCode("9");
atp3atp5.setFsAccountCode("229344");
atp5.setKfsChartCode("IR");
atp5.setKfsFiscalYear("1127562014");
paramList.add(atp3atp5);
		
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");
}