Table of Contents |
---|
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 | kfsObjectCodekfsObjCode | KFS Object Code | Yes | String (4) | |
4 | kfsSubObjectCodekfsSubObjCode | KFS SubObject Sub Object Code | Yes | String (4) |
DB Query
Code Block |
---|
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
Code Block |
---|
|
Response
Code Block |
---|
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
<soapenv:Header/>
<soapenv:Body>
<adc:isValidKFSSubObjects>
<kfsSubObjectList>
<item>2012</item>
<item>IR</item>
<item>1000211</item>
<item>4400</item>
<item>BRM1</item>
</kfsSubObjectList>
<kfsSubObjectList>
<item>2012</item>
<item>IR</item>
<item>1000211</item>
<item>4400</item>
<item>ITM1</item>
</kfsSubObjectList>
<kfsSubObjectList>
<item>2012</item>
<item>IR</item>
<item>1000211</item>
<item>0000</item>
<item>XXXX</item>
</kfsSubObjectList>
</adc:isValidKFSSubObjects>
</soapenv:Body>
</soapenv:Envelope> |
Response
Code Block |
---|
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns2:isValidKFSSubObjectsResponse xmlns:ns2="http://www.adcom.uci.edu">
<return>
<kfsAcctNumber>1000211</kfsAcctNumber>
<kfsChartCode>IR</kfsChartCode>
<kfsFiscalYear>2012</kfsFiscalYear>
<kfsObjCode>4400</kfsObjCode>
<kfsSubObjCode>BRM1</kfsSubObjCode>
<valid>true</valid>
</return>
<return>
<kfsAcctNumber>1000211</kfsAcctNumber>
<kfsChartCode>IR</kfsChartCode>
<kfsFiscalYear>2012</kfsFiscalYear>
<kfsObjCode>4400</kfsObjCode>
<kfsSubObjCode>ITM1</kfsSubObjCode>
<valid>true</valid>
</return>
<return>
<kfsAcctNumber>1000211</kfsAcctNumber>
<kfsChartCode>IR</kfsChartCode>
<kfsFiscalYear>2012</kfsFiscalYear>
<kfsObjCode>0000</kfsObjCode>
<kfsSubObjCode>XXXX</kfsSubObjCode>
<valid>false</valid>
</return>
</ns2:isValidKFSSubObjectsResponse>
</soap:Body>
</soap:Envelope> |
Java Client Example
Code Block |
---|
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
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 | kfsObjectCode | KFS Object Code | Yes | String (4) | |
4 | kfsSubObjectCode | KFS SubObject Code | Yes | String (4) |
DB Query
Code Block |
---|
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, CA_OBJECT_CODE_T b
WHERE a.fin_object_cd = b.fin_object_cd AND 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
Code Block |
---|
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adc="http://www.adcom.uci.edu">
<soapenv:Header/>
<soapenv:Body>
<adc:getValidKFSSubObjects>
<kfsSubObjectList>
<item>2012</item>
<item>IR</item>
<item>1000211</item>
<item>4400</item>
<item>BRM1</item>
</kfsSubObjectList>
<kfsSubObjectList>
<item>2012</item>
<item>IR</item>
<item>1000211</item>
<item>4400</item>
<item>ITM1</item>
</kfsSubObjectList>
<kfsSubObjectList>
<item>2012</item>
<item>IR</item>
<item>1000211</item>
<item>0000</item>
<item>XXXX</item>
</kfsSubObjectList>
</adc:getValidKFSSubObjects>
</soapenv:Body>
</soapenv:Envelope> |
Response
Code Block |
---|
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns2:getValidKFSSubObjectsResponse xmlns:ns2="http://www.adcom.uci.edu">
<return>
<kfsAcctNumber>1000211</kfsAcctNumber>
<kfsChartCode>IR</kfsChartCode>
<kfsFiscalYear>2012</kfsFiscalYear>
<kfsObjCode>4400</kfsObjCode>
<kfsObjCodeName>METERED MAIL</kfsObjCodeName>
<kfsSubObjCode>BRM1</kfsSubObjCode>
<kfsSubObjCodeName>BUSINESS REPLY MAIL</kfsSubObjCodeName>
</return>
<return>
<kfsAcctNumber>1000211</kfsAcctNumber>
<kfsChartCode>IR</kfsChartCode>
<kfsFiscalYear>2012</kfsFiscalYear>
<kfsObjCode>4400</kfsObjCode>
<kfsObjCodeName>METERED MAIL</kfsObjCodeName>
<kfsSubObjCode>ITM1</kfsSubObjCode>
<kfsSubObjCodeName>INTERNATIONAL MAIL</kfsSubObjCodeName>
</return>
</ns2:getValidKFSSubObjectsResponse>
</soap:Body>
</soap:Envelope> |
Java Client Example
Code Block |
---|
|
Java Client Example
Code Block |
---|
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();
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
Code Block |
---|
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
Code Block |
---|
|
Response
Code Block |
---|
|
Java Client Example
Code Block |
---|
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPort();
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
Code Block |
---|
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
Code Block |
---|
|
Response
Code Block |
---|
|
Java Client Example
Code Block |
---|
DWHServerService dss = new DWHServerService(); DWHServer ds = dss.getDWHServerPort(); System.out.println("\nWSClient-getAllKFSSubObjects()"); List<SubObjectDetails> resultList24 = ds.getAllKFSSubObjects(); if (resultList24 != null) { for (Iterator i = resultList23resultList24.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"); } |
...