...
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 | kfsOrgCode | KFS Organization Code | Yes | String(4) | 9052 |
| 1 | kfsChartCode | KFS Chart Code | Yes | String(2) | IR |
...
This service is used retrieve valid KFS organizations and related attributes. Returns an XML result set with a list of organizations
Input Specifications
| Index | Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|---|
| 0 | kfsOrgCode | KFS Organization Code | Yes | String(4) | 9052 |
| 1 | kfsChartCode | KFS Chart Code | Yes | String(2) | IR |
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 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') ); |
...