...
Code Block |
---|
DWHServerService dss = new DWHServerService();
DWHServer ds = dss.getDWHServerPortCustom();
List<OrganizationDetails> resultList14 = ds.getAllKFSOrganizations();
if (resultList14 != null) {
//for (Iterator i = resultList14.iterator(); i.hasNext();) {
// OrganizationDetails element = (OrganizationDetails)i.next();
//}
System.out.println("total size: " + resultList14.size());
System.out.println("the 1st item ChartCode / OrgCode: OrgName" + ((OrganizationDetails)resultList14.get(0)).getKfsChartCode() + " / " + ((OrganizationDetails)resultList14.get(0)).getKfsOrgCode() + " : " + ((OrganizationDetails)resultList14.get(0)).getKfsOrgName());
} else {
System.out.println("something bad happened...please check your query");
} |
translateFSOrganizations(List of (fsLocationCode, fsOrganizationCode, fsDivsionCode, fsSubDivisionCode, fsDepartmentCode))
This service is used to validate KFS organization. Returns an XML result set with a value of true or false for each organization.
Input Specifications
Index | Parameter | Description | Required? | Data Type (max length) | Example |
---|
0 | fsLocationCode | FS Location Code | Yes | String(1) | 9 |
1 | fsOrganizationCode | FS Organization Code | No | String(4) | 1000 |
DB Query
Code Block |
---|
select FIN_COA_CD, ORG_CD from UCI_CA_ORG_XW_T where uc_loc_cd = '9' and uc_hierarchy_cd = '0302' and uc_hierarchy_type_cd = 'O' |
Result Schema: A list of following elements (OrganizationValidation.java)
Parameter | Description | Data Type | Example |
---|
kfsChartCode | KFS Chart Code | String(2) | IR |
kfsOrgCode | KFS Organization Code | String(4) | 9052 |
WS Example
translateFSDivisions(List of (fsLocationCode, fsDivsionCode))
This service is used to validate KFS organization. Returns an XML result set with a value of true or false for each organization.
Input Specifications
Index | Parameter | Description | Required? | Data Type (max length) | Example |
---|
0 | fsLocationCode | FS Location Code | Yes | String(1) | 9 |
1 | fsDivsionCode | FS Division Code | Yes | String(4) | 1200 |
DB Query
Code Block |
---|
select FIN_COA_CD, ORG_CD from UCI_CA_ORG_XW_T where uc_loc_cd = '9' and uc_hierarchy_cd = '0302' and uc_hierarchy_type_cd = 'V' |
Result Schema: A list of following elements (OrganizationValidation.java)
Parameter | Description | Data Type | Example |
---|
kfsChartCode | KFS Chart Code | String(2) | IR |
kfsOrgCode | KFS Organization Code | String(4) | 9052 |
WS Example
translateFSSubDivisions(List of (fsLocationCode, fsSubDivisionCode))
This service is used to validate KFS organization. Returns an XML result set with a value of true or false for each organization.
Input Specifications
Index | Parameter | Description | Required? | Data Type (max length) | Example |
---|
0 | fsLocationCode | FS Location Code | Yes | String(1) | 9 |
1 | fsSubDivisionCode | FS SubDivisionCode | No | String(4) | 1250 |
DB Query
Code Block |
---|
select FIN_COA_CD, ORG_CD from UCI_CA_ORG_XW_T where uc_loc_cd = '9' and uc_hierarchy_cd = '0302' and uc_hierarchy_type_cd = 'S' |
Result Schema: A list of following elements (OrganizationValidation.java)
Parameter | Description | Data Type | Example |
---|
kfsChartCode | KFS Chart Code | String(2) | IR |
kfsOrgCode | KFS Organization Code | String(4) | 9052 |
WS Example
translateFSDepartments(List of (fsLocationCode, fsDepartmentCode))
This service is used to validate KFS organization. Returns an XML result set with a value of true or false for each organization.
Input Specifications
Index | Parameter | Description | Required? | Data Type (max length) | Example |
---|
0 | fsLocationCode | FS Location Code | Yes | String(1) | 9 |
1 | fsDepartmentCode | FS DepartmentCode | No | String(4) | 0302 |
DB Query
Code Block |
---|
select FIN_COA_CD, ORG_CD from UCI_CA_ORG_XW_T where uc_loc_cd = '9' and uc_hierarchy_cd = '0302' and uc_hierarchy_type_cd = 'D' |
Result Schema: A list of following elements (OrganizationValidation.java)
Parameter | Description | Data Type | Example |
---|
kfsChartCode | KFS Chart Code | String(2) | IR |
kfsOrgCode | KFS Organization Code | String(4) | 9052 |
WS Example