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)

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
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

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

ParameterDescriptionData TypeExample
fsLocationCodeThe FS location codeString (2)9
fsAccountCodeThe FS accounts codeString (6)110001
fsFundCodeThe FS fund codeString (5)111200
kfsChartCodeKFS Chart CodeString (2)'IR'
kfsAcctNumberKFS Account NumberString (7)'1234567'

WS Example

Request
Response

Java Client Example

Code Block
 

 

...

getAllKFSSubAccounts()

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

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

ParameterDescriptionData TypeExample
fsLocationCodeThe FS location codeString (2)9
fsAccountCodeThe FS accounts codeString (6)110001
fsFundCodeThe FS fund codeString (5)111200
kfsChartCodeKFS Chart CodeString (2)'IR'
kfsAcctNumberKFS Account NumberString (7)'1234567'

WS Example

Request
Response

Java Client Example

Code Block
 

 

...