Web Services - KFS Sub Account

Usage

Dev WSDL location: https://thea.adcom.uci.edu/WebServices/DWHServer?wsdl

Dev Endpoint: https://thea.adcom.uci.edu/WebServices/DWHServer

isValidKFSSubAccounts(List of (Chart, Account, SubAccount) )

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(6)	12345

DB Query

SELECT 
a.FIN_COA_CD,
a.ACCOUNT_NBR,
a.SUB_ACCT_NBR,
a.SUB_ACCT_ACTV_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 (SubAccountValidation.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)	12345
isValid	Is the SubAccount Active	boolean	true

WS Example

Request

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:isValidKFSSubAccounts>
         <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:isValidKFSSubAccounts>
   </soapenv:Body>
</soapenv:Envelope>

Response

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:isValidKFSSubAccountsResponse xmlns:ns2="http://www.adcom.uci.edu">
         <return>
            <kfsAcctNumber>1001783</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <kfsSubAcctNumber>XXXX</kfsSubAcctNumber>
            <valid>false</valid>
         </return>
         <return>
            <kfsAcctNumber>1001783</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <kfsSubAcctNumber>EXP02</kfsSubAcctNumber>
            <valid>true</valid>
         </return>
         <return>
            <kfsAcctNumber>1001783</kfsAcctNumber>
            <kfsChartCode>IR</kfsChartCode>
            <kfsSubAcctNumber>EXP01</kfsSubAcctNumber>
            <valid>true</valid>
         </return>
      </ns2:isValidKFSSubAccountsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

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

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

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

Response

<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>
         </return>
      </ns2:getValidKFSSubAccountsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

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

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

getAllKFSSubAccounts()

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

DB Query

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

Result Schema: same as getValidKFSSubAccounts()

WS Example

Request

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
   <soapenv:Header/>
   <soapenv:Body>
      <adc:getAllKFSSubAccounts/>
   </soapenv:Body>
</soapenv:Envelope>

Response

<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
   <soap:Body>
      <ns2:getAllKFSSubAccountsResponse 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>
         </return>

         ...
         ...
      </ns2:getAllKFSSubAccountsResponse>
   </soap:Body>
</soap:Envelope>

Java Client Example

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

System.out.println("\n=======================================getAllKFSSubAccounts()================================");
List<SubAccountDetails> resultList27 = myBean.getAllKFSSubAccounts();
if (resultList27 != null) {
	//for (Iterator i = resultList27.iterator(); i.hasNext();) {
	//	SubObjectDetails element = (SubAccountDetails)i.next();
	//	System.out.println("SERVER UNIT TEST-Result List27: " + element.toString());
	//}
	System.out.println("SERVER UNIT TEST-getAllKFSAccounts() total size: " + resultList27.size());
	System.out.println("SERVER UNIT TEST-getAllKFSAccounts() 1st element: " + resultList27.get(0).toString());
} else {
	System.out.println("something bad happened...please check your query");
}