DWH Web Services - KFS Sub Account (NO DATA)

isValidKFSSubAccounts(List of (kfsChartCode, kfsAcctNumber, kfsSubAcctNumber) )

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

Response

Java Client Example

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

System.out.println("\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 (kfsChartCode, kfsAcctNumber, kfsSubAcctNumber))

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

Response

Java Client Example

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

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 = ds.getValidKFSSubAccounts(Arrays.asList(sa260, sa261, sa262));
if (resultList26 != null) {
	for (Iterator i = resultList26.iterator(); i.hasNext();) {
		SubAccountDetails element = (SubAccountDetails)i.next();
		System.out.println("\t" + element.getKfsChartCode() + "/" + element.getKfsAcctNumber() + "/" + element.getKfsSubAcctNumber() + " : " + element.getKfsSubAcctName());
	}
} 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

Response

Java Client Example

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

System.out.println("\nWSClient--getAllKFSSubAccounts()================================");
List<SubAccountDetails> resultList27 = ds.getAllKFSSubAccounts();
if (resultList27 != null) {
	System.out.println("getAllSubAccount-total size: " + resultList27.size());
	System.out.println("getAllSubAccount-1st item ChartCode / AcctNum / SubAcctNum: SubAcctName" + ((SubAccountDetails)resultList27.get(0)).getKfsChartCode() + " / " + ((SubAccountDetails)resultList27.get(0)).getKfsAcctNumber() + " / " + ((SubAccountDetails)resultList27.get(0)).getKfsSubAcctNumber() + ":" + ((SubAccountDetails)resultList27.get(0)).getKfsSubAcctName());
} else {
	System.out.println("something bad happened...please check your query");
}