Page Comparison

...

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();

System.out.println("\n=======================================isValidKFSSubAccounts()================================");
List<SubAccountValidation> resultList25 = myBean.isValidKFSSubAccounts(new String[][]{{"IR","1001783","EXP01"}, {"IR","1001783","EXP02"}, {"IR","1001783","XXXX"}});
if (resultList25 != null) {
	for (Iterator i = resultList25.iterator(); i.hasNext();) {
		SubAccountValidation element = (SubAccountValidation)i.next();
		System.out.println("SERVER UNIT TEST-Result List25: " + element.toString());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

getValidKFSSubAccounts(List of Chart, KFSAccount, KFSSubAccount)

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)	Example
0	kfsChartCode	KFS Chart Code	Yes	String(2)	IR
1	kfsAcctNumber	KFS Account Number	Yes	String(7)	1234567
2	kfsSubAcctNumber	KFS SubAccount Number	Yes	String(5)	1234567

DB Query

Code Block

SELECT 
a.FIN_COA_CD,
a.ACCOUNT_NBR,
a.SUB_ACCT_NBR,
a.SUB_ACCT_NM,
a.FIN_RPT_CHRT_CD,
a.FIN_RPT_ORG_CD,
a.FIN_RPT_CD 
FROM ca_sub_acct_t a 
WHERE 
a.SUB_ACCT_ACTV_CD <> 'N' AND 
(
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='EXP01') OR
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='EXP02') OR
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='XXXX')
);

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

Parameter	Description	Data Type	Example
kfsChartCode	KFS Chart Code	String (2)	IR
kfsAcctNumber	KFS Account Number	String (7)	1234567
kfsSubAcctNumber	KFS SubAccount Number	String (5)	1234567
kfsSubAcctName	KFS SubAccount Name	String (40)
kfsReportToChartCode	KFS Reports To Chart Code	String (2)
kfsReportToAcctNumber	KFS Reports To Account Number	String (4)
kfsReportCode	KFS Reports Code	String (10)

WS Example

Request

Code Block

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:getValidKFSSubAccounts>
         <kfsSubAccountList>
          nWSClient-isValidKFSSubAccounts()");
StringArray sa250 = new StringArray();
sa250.getItem().add("IR");
sa250.getItem().add("1001783");
sa250.getItem().add("EXP01");
StringArray sa251 = new StringArray();
sa251.getItem().add("IR");
sa251.getItem().add("1001783");
sa251.getItem().add("EXP02");
StringArray sa252 = new StringArray();
sa252.getItem().add("IR");
sa252.getItem().add("1001783");
sa252.getItem().add("XXXX");
List<SubAccountValidation> resultList25 = ds.isValidKFSSubAccounts(Arrays.asList(sa250, sa251, sa252));
if (resultList25 != null) {
	for (Iterator i = resultList25.iterator(); i.hasNext();) {
		SubAccountValidation element = (SubAccountValidation)i.next();
		System.out.println("\t" + element.getKfsChartCode() + "/" + element.getKfsAcctNumber() + "/" + element.getKfsSubAcctNumber() + " : " + element.isValid());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

...

getValidKFSSubAccounts(List of Chart, KFSAccount, KFSSubAccount)

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)	Example
0	kfsChartCode	KFS Chart Code	Yes	String(2)	IR
1	kfsAcctNumber	KFS Account Number	Yes	String(7)	1234567
2	kfsSubAcctNumber	KFS SubAccount Number	Yes	String(5)	1234567

DB Query

Code Block

SELECT 
a.FIN_COA_CD,
a.ACCOUNT_NBR,
a.SUB_ACCT_NBR,
a.SUB_ACCT_NM,
a.FIN_RPT_CHRT_CD,
a.FIN_RPT_ORG_CD,
a.FIN_RPT_CD 
FROM ca_sub_acct_t a 
WHERE 
a.SUB_ACCT_ACTV_CD <> 'N' AND 
(
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='EXP01') OR
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='EXP02') OR
(a.fin_coa_cd='IR' AND a.account_nbr='1001783' AND a.sub_acct_nbr='XXXX')
);

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

Parameter	Description	Data Type	Example
kfsChartCode	KFS Chart Code	String (2)	IR
kfsAcctNumber	KFS Account Number	String (7)	1234567
kfsSubAcctNumber	KFS SubAccount Number	String (5)	1234567
kfsSubAcctName	KFS SubAccount Name	String (40)
kfsReportToChartCode	KFS Reports To Chart Code	String (2)
kfsReportToAcctNumber	KFS Reports To Account Number	String (4)
kfsReportCode	KFS Reports Code	String (10)

WS Example

Request

Code Block

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:getValidKFSSubAccounts>
         <kfsSubAccountList>
            <item>IR</item>
            <item>1001783</item>
            <item>EXP01</item>
         </kfsSubAccountList>
         <kfsSubAccountList>
            <item>IR</item>
            <item>1001783</item>
            <item>EXP02</item>
         </kfsSubAccountList>
         <kfsSubAccountList>
            <item>IR</item>
            <item>1001783</item>
            <item>XXXX</item>
         </kfsSubAccountList>
      </adc:getValidKFSSubAccounts>
   </soapenv:Body>
</soapenv:Envelope>

...

Code Block

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getValidKFSSubAccountsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsAcctNumber>1001783</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <kfsSubAcctName>Test Sample Sub Account Number</kfsSubAcctName>
         </return>
         <return>
            <kfsAcctNumber>1001783</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <kfsSubAcctName>Test Sample Sub Account Number</kfsSubAcctName>
      <kfsChartCode>IR</kfsChartCode>    </return>
      </ns2:getValidKFSSubAccountsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

Code Block
DWHServerService dss <kfsSubAcctName>Test= Sample Sub Account Number</kfsSubAcctName> </return> </ns2:getValidKFSSubAccountsResponse> </soap:Body> </soap:Envelope>

Java Client Example

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();

System.out.println("\n=======================================getValidKFSSubAccounts()================================new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();

System.out.println("\nWSClient-getValidKFSSubAccounts()");
StringArray sa260 = new StringArray();
sa260.getItem().add("IR");
sa260.getItem().add("1001783");
sa260.getItem().add("EXP01");
StringArray sa261 = new StringArray();
sa261.getItem().add("IR");
sa261.getItem().add("1001783");
sa261.getItem().add("EXP02");
StringArray sa262 = new StringArray();
sa262.getItem().add("IR");
sa262.getItem().add("1001783");
sa262.getItem().add("XXXX");
List<SubAccountDetails> resultList26 = myBeands.getValidKFSSubAccounts(new String[][]{{"IR","1001783","EXP01"}, {"IR","1001783","EXP02"}, {"IR","1001783","XXXX"}}(Arrays.asList(sa260, sa261, sa262));
if (resultList26 != null) {
	for (Iterator i = resultList26.iterator(); i.hasNext();) {
		SubAccountDetails element = (SubAccountDetails)i.next();
		System.out.println("SERVER UNIT TEST-Result List26();
		System.out.println("\t" + element.getKfsChartCode() + "/" + element.getKfsAcctNumber() + "/" + element.getKfsSubAcctNumber() + " : " + element.toStringgetKfsSubAcctName());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

...

Code Block

DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();

System.out.println("\n=======================================println("\nWSClient--getAllKFSSubAccounts()================================");
List<SubAccountDetails> resultList27 = myBeands.getAllKFSSubAccounts();
if (resultList27 != null) {
	//for (Iterator i = resultList27.iterator(); i.hasNext();) {
	//	SubObjectDetails element = (SubAccountDetails)i.next();
	//	System.out.println("getAllSubAccount-total size: " + resultList27.size());
	System.out.println("SERVER UNIT TEST-Result List27: getAllSubAccount-1st item ChartCode / AcctNum / SubAcctNum: SubAcctName" + element.toString());
	//}
	System.out.println("SERVER UNIT TEST-getAllKFSAccounts() total size:((SubAccountDetails)resultList27.get(0)).getKfsChartCode() + " / " + ((SubAccountDetails)resultList27.get(0)).getKfsAcctNumber() + " / " + ((SubAccountDetails)resultList27.sizeget(0));
	System.out.println("SERVER UNIT TEST-getAllKFSAccounts.getKfsSubAcctNumber() 1st+ element": " + ((SubAccountDetails)resultList27.get(0)).toStringgetKfsSubAcctName());
} else {
	System.out.println("something bad happened...please check your query");
}

Version	Old Version 12	New Version 13
Changes made by	Adam Chang	Adam Chang
Saved on	Aug 03, 2012	Aug 03, 2012

Versions Compared

Key

getValidKFSSubAccounts(List of Chart, KFSAccount, KFSSubAccount)

Input Specifications

DB Query

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

WS Example

Request

getValidKFSSubAccounts(List of Chart, KFSAccount, KFSSubAccount)

Input Specifications

DB Query

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

WS Example

Request

Java Client Example

Java Client Example