...
This service is used retrieve valid KFS organizations and related attributes. Returns an XML result set with a list of organizations
DB Query
| Code Block |
|---|
SELECT a.SELECT FIN_COA_CD, ORG_CD, ORG_MGR_UNVL_ID, ORG_NM, RC_CD, ORG_PHYS_CMP_CD, ORG_TYP_CD, ORG_DFLT_ACCT_NBR, ORG_LN1_ADDR, ORG_LN2_ADDR, ORG_CITY_NM, ORG_STATE_CD, ORG_ZIP_CD, ORG_CNTRY_CD, ORG_BEGIN_DT, ORG_END_DT, RPTS_TO_FIN_COA_CD as \"Chart Code\", "); sql.append(" a.org_cd as \"Organization Code \", "); sql.append(" a.org_nm as \"Organization Name \", "); sql.append(" a.RPTS_TO_FIN_COA_CD as \"Reports to Chart Code\", ", RPTS_TO_ORG_CD, ORG_ACTIVE_CD, ORG_PLNT_ACCT_NBR, CMP_PLNT_ACCT_NBR, ORG_PLNT_COA_CD, CMP_PLNT_COA_CD FROM CA_ORG_T a WHERE a.ORG_ACTIVE_CD <> 'N' AND ( (a.ORG_CD='9052' AND a.FIN_COA_CD='IR') OR (a.ORG_CD='9053' AND a.FIN_COA_CD='IR') OR (a.ORG_CD='1111' AND a.FIN_COA_CD='IR') OR (a.ORG_CD='9054' AND a.FIN_COA_CD='XX') ); |
Result Schema: A list of following elements (OrganizationDetails.java)
| DB Parameter | Java Parameter | Description | Data Type | Example |
|---|---|---|---|---|
| FIN_COA_CD | kfsChartCode | KFS Chart Code | String (2) | IR |
| ORG_CD | kfsOrgCode | KFS Organization Code | String (4) | 1234 |
| ORG_MGR_UNVL_ID | kfsOrgManagerId | KFS Organization Manager ID | String | |
| ORG_NM | kfsOrgName | KFS Organization Name | String | |
| RC_CD | KfsRcCodeKfsRCCode | KFS RC Responsibility Center Code | String | |
| ORG_PHYS_CMP_CD | kfsOrgCampusCode | KFS Organization Physical Campus Code | String | |
| ORG_TYP_CD | kfsOrgTypeCode | KFS Organization Type Code | String | |
| ORG_DFLT_ACCT_NBR | kfsDfltAcctNumberkfsOrgDefaultAcctNumber | KFS DFLT Default Account Number | String | |
| ORG_LN1_ADDR | kfsOrgAddr1 | KFS Address Line 1 | String | |
| ORG_LN2_ADDR | kfsOrgAddr2 | KFS Address Line 2 | String | |
| ORG_CITY_NM | kfsOrgCity | KFS Organization City Name | String | |
| ORG_STATE_CD | kfsOrgState | KFS Organization State Code | String | |
| ORG_ZIP_CD | kfsOrgZip | KFS Organization Zip Code | String | |
| ORG_CNTRY_CD | kfsOrgCountryCode | KFS Organization Country Code | String | |
| ORG_BEGIN_DT | kfsOrgBeginDate | KFS Organization Begin Date | String | |
| ORG_END_DT | kfsOrgEndDate | KFS Organization End Date | String | |
| RPTS_TO_FIN_COA_CD | kfsReportsToChartCodekfsReportToChartCode | KFS Reports To Chart Code | String | |
| RPTS_TO_ORG_NBRCD | kfsReportsToOrgNumberkfsReportToOrgCode | KFS Reports To Organization NumberCode | String | |
| ORG_ACTIVE_CD | kfsOrgActiveCode | KFS Organization Active Code | String | |
| ORG_PLNT_ACCT_NBR | kfsOrgPlantAcctNumber | KFS Organization Plant Account Number | String | |
| CMP_PLNT_ACCT_NBR | kfsCampusPlantAcctNumber | KFS Campus Plant Account Number | String | |
| ORG_PLNT_COA_CD | kfsOrgPlantChartCode | KFS Organization Plant Chart Code | String | |
| CMP_PLNT_COA_CD | kfsCampusPlantChartCode | KFS Campus Plant Chart Code | String |
WS Example
Request
| Code Block |
|---|
...
No input parameter, ALL active KFS organization details will be returned in result set.
DB Query
| Code Block |
|---|
SELECT
FIN_COA_CD,
ORG_CD,
ORG_MGR_UNVL_ID,
ORG_NM,
RC_CD,
ORG_PHYS_CMP_CD,
ORG_TYP_CD,
ORG_DFLT_ACCT_NBR,
ORG_LN1_ADDR,
ORG_LN2_ADDR,
ORG_CITY_NM,
ORG_STATE_CD,
ORG_ZIP_CD,
ORG_CNTRY_CD,
ORG_BEGIN_DT,
ORG_END_DT,
RPTS_TO_FIN_COA_CD,
RPTS_TO_ORG_CD,
ORG_ACTIVE_CD,
ORG_PLNT_ACCT_NBR,
CMP_PLNT_ACCT_NBR,
ORG_PLNT_COA_CD,
CMP_PLNT_COA_CD
FROM CA_ORG_T WHERE ORG_ACTIVE_CD <> 'N'; |
Result Schema: SAME as getValidKFSOrganizations
WS Example
Request
| Code Block |
|---|
|
Response
| Code Block |
|---|
|
Java Client Example
| Code Block |
|---|
|