DWH Web Services - KFS Sub Object (NO DATA)

isValidKFSSubObjects (List of (kfsFiscalYear, kfsChartCode, kfsAcctNumber, kfsObjCode, kfsSubObjCode))

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)	Example
0	kfsFiscalYear	KFS Fiscal Year (e.g. 2013)	Yes	String (4)
1	kfsChartCode	KFS Chart Code	Yes	String (2)
2	kfsAcctNumber	KFS Account Number	Yes	String (7)	'1234567'
3	kfsObjCode	KFS Object Code	Yes	String (4)
4	kfsSubObjCode	KFS Sub Object Code	Yes	String (4)

DB Query

SELECT 
CONVERT(varchar(4),UNIV_FISCAL_YR) AS UNIV_FISCAL_YR, 
FIN_COA_CD, 
ACCOUNT_NBR, 
FIN_OBJECT_CD, 
FIN_SUB_OBJ_CD, 
FIN_SUBOBJ_ACTV_CD
FROM CA_SUB_OBJECT_CD_T 
WHERE FIN_SUBOBJ_ACTV_CD <> 'N' AND 
(
 (univ_fiscal_yr = '2012' AND 
  fin_coa_cd='IR' AND 
  account_nbr='1000211' AND 
  fin_object_cd = '4400' AND 
  fin_sub_obj_cd = 'BRM1') OR 
 (univ_fiscal_yr = '2012' AND 
  fin_coa_cd='IR' AND 
  account_nbr='1000211' AND 
  fin_object_cd = '4400' AND 
  fin_sub_obj_cd = 'ITM1') OR
 (univ_fiscal_yr = '2012' AND
  fin_coa_cd='IR' AND 
  account_nbr='1000211' AND 
  fin_object_cd = '0000' AND 
  fin_sub_obj_cd = 'XXXX')
);

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

Parameter	Description	Data Type	Example
kfsFiscalYear	The KFS Fiscal Year	String (4)	'2013'
kfsChartCode	The KFS chart of accounts code	String (2)	'IR'
kfsAcctNumber	KFS Account Number	String(7)	'1234567'
kfsObjCode	KFS Object Code	String (4)	'CASH'
kfsSubObjCode	KFS SubObject Code	String (4)	'CASH'
isValid	Is the SubObject Active?	boolean	true

WS Example

Request

Response

Java Client Example

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

System.out.println("\nWSClient-isValidKFSSubObjects()");
StringArray sa220 = new StringArray();
sa220.getItem().add("2012");
sa220.getItem().add("IR");
sa220.getItem().add("1000211");
sa220.getItem().add("4400");
sa220.getItem().add("BRM1");
StringArray sa221 = new StringArray();
sa221.getItem().add("2012");
sa221.getItem().add("IR");
sa221.getItem().add("1000211");
sa221.getItem().add("4400");
sa221.getItem().add("ITM1");
StringArray sa222 = new StringArray();
sa221.getItem().add("2012");
sa221.getItem().add("IR");
sa221.getItem().add("1000211");
sa221.getItem().add("0000");
sa221.getItem().add("XXXX");
List<SubObjectValidation> resultList22 = ds.isValidKFSSubObjects(Arrays.asList(sa220, sa221, sa222));
if (resultList22 != null) {
	for (Iterator i = resultList22.iterator(); i.hasNext();) {
		SubObjectValidation element = (SubObjectValidation)i.next();
		System.out.println("\t" + element.getKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getKfsAcctNumber() + "/" + element.getKfsObjCode() + "/" + element.getKfsSubObjCode() + " : " + element.isValid());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

getValidKFSSubObjects(List of (kfsFiscalYear, kfsChartCode, kfsAcctNumber, kfsObjCode, kfsSubObjCode))

Input Specifications

Index	Parameter	Description	Required?	Data Type (max length)	Example
0	kfsFiscalYear	KFS Fiscal Year (e.g. 2013)	Yes	String (4)
1	kfsChartCode	KFS Chart Code	Yes	String (2)
2	kfsAcctNumber	KFS Account Number	Yes	String (7)	'1234567'
3	kfsObjCode	KFS Object Code	Yes	String (4)
4	kfsSubObjCode	KFS Sub Object Code	Yes	String (4)

DB Query

SELECT 
CONVERT(varchar(4), a.univ_fiscal_yr) AS UNIV_FISCAL_YR,
a.fin_coa_cd, 
a.account_nbr, 
a.fin_object_cd, 
b.fin_obj_cd_nm, 
a.fin_sub_obj_cd, 
a.fin_sub_obj_cd_nm 
FROM CA_SUB_OBJECT_CD_T a LEFT OUTER JOIN CA_OBJECT_CODE_T b ON a.fin_object_cd = b.fin_object_cd  
WHERE a.FIN_SUBOBJ_ACTV_CD <> 'N' AND
(
 (a.univ_fiscal_yr = '2012' AND 
  a.fin_coa_cd='IR' AND 
  a.account_nbr='1000211' AND 
  a.fin_object_cd = '4400' AND 
  a.fin_sub_obj_cd = 'BRM1') OR 
 (a.univ_fiscal_yr = '2012' AND 
  a.fin_coa_cd='IR' AND 
  a.account_nbr='1000211' AND 
  a.fin_object_cd = '4400' AND 
  a.fin_sub_obj_cd = 'ITM1') OR
 (a.univ_fiscal_yr = '2012' AND
  a.fin_coa_cd='IR' AND 
  a.account_nbr='1000211' AND 
  a.fin_object_cd = '0000' AND 
  a.fin_sub_obj_cd = 'XXXX')
);

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

DB Parameter	Java Parameter	Description	Data Type
UNIV_FISCAL_YR	kfsFiscalYear	KFS Fiscal Year	String (4)	2012
FIN_COA_CD	kfsChartCode	KFS Chart Code	String (2)	'IR'
ACCOUNT_NBM	kfsAcctNumber	KFS Account Number	String (7)	'1234567'
FIN_OBJECT_CD	kfsObjCode	KFS Object Code	String (4)	'CASH'
FIN_OBJ_CD_NM	kfsObjCodeName	KFS Object Code Name	String (40)
FIN_SUB_OBJ_CD	kfsSubObjCode	KFS SubObject Code	String (4)	'CASH'
FIN_SUB_OBJ_CD_NM	kfsSubObjCodeName	KFS SubObject Code Name	String (40)

WS Example

Request

Response

Java Client Example

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

System.out.println("\nWSClient-getValidKFSSubObjects()");
StringArray sa230 = new StringArray();
sa230.getItem().add("2012");
sa230.getItem().add("IR");
sa230.getItem().add("1000211");
sa230.getItem().add("4400");
sa230.getItem().add("BRM1");
StringArray sa231 = new StringArray();
sa231.getItem().add("2012");
sa231.getItem().add("IR");
sa231.getItem().add("1000211");
sa231.getItem().add("4400");
sa231.getItem().add("ITM1");
StringArray sa232 = new StringArray();
sa232.getItem().add("2012");
sa232.getItem().add("IR");
sa232.getItem().add("1000211");
sa232.getItem().add("0000");
sa232.getItem().add("XXXX");
List<SubObjectDetails> resultList23 = ds.getValidKFSSubObjects(Arrays.asList(sa230, sa231, sa232));
if (resultList23 != null) {
	for (Iterator i = resultList23.iterator(); i.hasNext();) {
		SubObjectDetails element = (SubObjectDetails)i.next();
		System.out.println("\t" + element.getKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getKfsAcctNumber() + "/" + element.getKfsObjCode() + "/" + element.getKfsSubObjCode() + " : " + element.getKfsSubObjCodeName());
	}
} else {
	System.out.println("something bad happened...please check your query");
}

getAllKFSSubObjects()

Input Specifications

DB Query

SELECT 
CONVERT(varchar(4), a.univ_fiscal_yr) AS UNIV_FISCAL_YR,
a.fin_coa_cd, 
a.account_nbr, 
a.fin_object_cd, 
b.fin_obj_cd_nm, 
a.fin_sub_obj_cd, 
a.fin_sub_obj_cd_nm 
FROM CA_SUB_OBJECT_CD_T a LEFT OUTER JOIN CA_OBJECT_CODE_T b ON a.fin_object_cd = b.fin_object_cd  
WHERE a.FIN_SUBOBJ_ACTV_CD <> 'N';

Result Schema: Same as getValidKfsObjects

WS Example

Request

Response

Java Client Example

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

System.out.println("\nWSClient-getAllKFSSubObjects()");
List<SubObjectDetails> resultList24 = ds.getAllKFSSubObjects();
if (resultList24 != null) {
	for (Iterator i = resultList24.iterator(); i.hasNext();) {
		SubObjectDetails element = (SubObjectDetails)i.next();
		System.out.println("\t" + element.getKfsFiscalYear() + "/" + element.getKfsChartCode() + "/" + element.getKfsAcctNumber() + "/" + element.getKfsObjCode() + "/" + element.getKfsSubObjCode() + " : " + element.getKfsSubObjCodeName());
	}
} else {
	System.out.println("something bad happened...please check your query");
}