...
| 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("400753");
atp1.setFsFundCode("19933");
paramList.add(atp1);
AccountTranslateParameters atp2 = new AccountTranslateParameters();
atp2.setFsLocationCode("9");
atp2.setFsAccountCode("400755");
atp2.setFsFundCode("19900");
paramList.add(atp2);
AccountTranslateParameters atp3 = new AccountTranslateParameters();
atp3.setFsLocationCode("9");
atp3.setFsAccountCode("270303");
atp3.setFsFundCode("70003");
paramList.add(atp3);
AccountTranslateParameters atp4 = new AccountTranslateParameters();
atp4.setFsLocationCode("9");
atp4.setFsAccountCode("270010");
atp4.setFsFundCode("70000");
paramList.add(atp4);
List<Fs2KFSAccountDetails> resultList = server.translateFSAccountFunds(paramList);
if (resultList != null) {
for (Fs2KFSAccountDetails fad : resultList) {
System.out.println("kfsChartCode : " + fad.getKfsChartCode());
System.out.println("kfsAccountNumber : " + fad.getKfsAcctNumber());
System.out.println("fsLocationCode : " + fad.getFsLocationCode());
System.out.println("fsAccountCode : " + fad.getFsAccountCode());
System.out.println("fsFundCode : " + fad.getFsFundCode());
System.out.println("------------------------------");
}
}
else {
System.out.println("something bad happened...please check your query");
} |
...
translateFSAccountToKFSObject(List of (fsLocationCode, fsAccountCode, kfsChartCode, kfsFiscalYear))
This service is used to translate legacy FS balance sheet and income accounts to KFS object codes.
...
| Index | Parameter | Description | Required? | Data Type (max length) |
|---|---|---|---|---|
| 0 | fsLocationCode | The FS location code | Yes | String (2) |
| 1 | fsAccountCode | The FS accounts code | Yes | String (6) |
| 2 | fsFundCodekfsChartCode | The FS fund codeKFS chart code | Yes | String (2) |
| 3 | kfsFiscalYear | The KFS fiscal year | Yes | String (54) |
DB Query
| 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='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 = '2013' AND FIN_COA_CD = 'IR')
OR
(UC_LOC_CD='9' AND UC_ACCT_NBR='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')
); |
...