...
| Code Block |
|---|
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
StringArray sa60 = new StringArray();
sa60.getItem().add("9");
sa60.getItem().add("110001");
sa60.getItem().add("18888");
StringArray sa61 = new StringArray();
sa61.getItem().add("9");
sa61.getItem().add("111200");
sa61.getItem().add("18213");
StringArray sa62 = new StringArray();
sa62.getItem().add("9");
sa62.getItem().add("111200");
sa62.getItem().add("182");
List<Fs2KFSAccountDetails> resultList6 = ds.translateFSAccountFunds(Arrays.asList(sa60,sa61,sa62));
if (resultList6 != null) {
for (Iterator i = resultList6.iterator(); i.hasNext();) {
Fs2KFSAccountDetails element = (Fs2KFSAccountDetails)i.next();
System.out.println("\t" + element.getFsLocationCode() + "/" + element.getFsAccountCode() + "/" + element.getFsFundCode() + " : " + element.getKfsChartCode() + "/" + element.getKfsAcctNumber());
}
} else {
System.out.println("something bad happened...please check your query");
} |
...
translateFSAccountToKFSObject(List of (fsLocationCode, fsAccountCode
...
))
This service is used to translate legacy FS accounts to KFS account object codes. Returns an XML result set with a KFS chart/account (example isValidKFSAccounts result) for each FS location/account
Take a row in UC_ACCOUNT_T to get the corresponding row(s) from UCI_CA_OBJECT_CODE_XW_T.
- (uc_loc_cd, uc_acct_nbr, uc_sau_cd) are the composite PK for UC_ACCOUNT_T but uc_sau_cd is almost always 0. There are some rows with uc_sau_cd is NOT 0, but (uc_loc_cd, uc_acct_nbr) are not overlapped. Only uc_loc_cd and uc_acct_nbr are the input parameters.
Input Specifications
| 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 | fsFundCode | The FS fund code | Yes | String (5) |
...