Versions Compared

Key

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

...

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");


StringArray sa63 = new StringArray();
sa63.getItem().add("");
sa63.getItem().add("");
sa63.getItem().add("");
		
List<Fs2KFSAccountDetails> resultList6 = ds.translateFSAccountFunds(Arrays.asList(sa60,sa61,sa62,sa63));
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");
}

 

isValidKFSSubAccount(List of Chart, Account, SubAccount)

Input Specifications

IndexParameterDescriptionRequired?Data Type (max length)Example
0kfsChartCodeKFS Chart CodeYesString(2)IR
1kfsAcctNumberKFS Account NumberYesString(7)1234567
2kfsSubAcctNumberKFS SubAccount NumberYesString(7)1234567

DB Query

Code Block
select * FROM ca_sub_acct_t a where a.account_nbr='pKFSAccountCode' AND a.fin_coa_cd='pChartCode' AND a.sub_acct_nbr='pKFSSubAccountCode' AND a.SUB_ACCT_ACTV_CD <> 'N'

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

ParameterDescriptionData TypeExample
kfsChartCodeKFS Chart CodeString (2)IR
kfsAcctNumberKFS Account NumberString (7)

1234567

kfsSubAcctNumberKFS SubAccount NumberString (7)1234567
isValidIs the Chart/Account Active for that effective date (or today)?booleantrue

WS Example

Request
Code Block
 
Response
Code Block
 

Java Client Example

Code Block
 

 

getValidKFSSubAccounts(List of Chart, KFSAccount, KFSSubAccount)

Input Specifications

IndexParameterDescriptionRequired?Data Type (max length)Example
0kfsChartCodeKFS Chart CodeYesString(2)IR
1kfsAcctNumberKFS Account NumberYesString(7)1234567
2kfsSubAcctNumberKFS SubAccount NumberYesString(7)1234567

DB Query

Code Block
 

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

ParameterDescriptionData TypeExample
kfsChartCodeKFS Chart CodeString (2)'IR'
kfsAcctNumberKFS Account NumberString (7)'1234567'
    

WS Example

Request
Code Block
 
Response
Code Block
 

Java Client Example

Code Block
SELECT fin_coa_cd, account_nbr, account_nm, sub_acct_nbr, sub_acct_nm FROM ca_sub_acct_t WHERE SUB_ACCT_ACTV_CD <> 'N' 

 

getAllKFSSubAccounts()

No input parameter, ALL active KFS subaccount details will be returned in result set.

DB Query

Code Block
 

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

ParameterDescriptionData TypeExample
kfsChartCodeKFS Chart CodeString (2)'IR'
kfsAcctNumberKFS Account NumberString (7)'1234567'
    

WS Example

Request
Code Block
 
Response
Code Block
 

Java Client Example

Code Block
 

 

...