...
| Parameter | Description | Required? | Data Type (max length) | Example |
|---|---|---|---|---|
| kfsProjCode | KFS Project Number | Yes | String(10) | '1234567890' |
DB Query
...
Result Schema: A list of following elements (ProjectValidation.java)
| Parameter | Description | Data Type | Example |
|---|---|---|---|
| kfsProjCode | KFS Project Code | String (10) | '1234567890' |
| isValid | Is the KFS Project Code valid? | boolean | true |
WS Example
...
...
...
Java Client Example
select * FROM KFSINT.CA_ORG_T a " + "where a.org_cd='" + pKFSOrganizationCode + "' AND a.fin_coa_cd='" + pChartCode + "' " + "AND a.ORG_ACTIVE_CD <> 'N' "sql.append("SELECT ");
sql.append(" a.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\", ");